Number One Symptom By Vaccine

Exploratory Data Analysis

Determining the number one symptom for all 92 vaccines found in VAERS.    

As noted in Counts of Each Symptom,
Of all symptoms, Pyrexia (fever) was the most common symptom
n=121,099
Comprising 4.3% of 2,765,759 all symptoms found

Does this apply to different vaccines, or not?

If not, what is the most common symptom for each vaccine?

—

First See:

AD_2019_ALL_SYMP_NORM
AD_2019_ALL_VAX_NORM

—-

use vaers_2019
go


select 
   outter.vax
,  outter.symptom
,  outter.Vax_Symp_count
,  outter.Rank_In_Vax
from 
(

  Select 
    vs.vax
  , vs.symptom
  , vs.Vax_Symp_count
  , row_number() 
  over ( 
  partition by vs.vax 
  order by vs.Vax_Symp_count desc
  )  as Rank_In_Vax
  from 
    (
    Select 
      vax.vax
    , symp.symptom
    , count(*) Vax_Symp_count
    from dbo.[AD_2019_ALL_SYMP_NORM]  as symp
    join  dbo.[AD_2019_ALL_VAX_NORM]  as vax
      on symp.vaers_id = vax.vaers_id
    group by 
      vax.vax
    , symp.symptom
    )  as          vs

)  outter
where  outter.Rank_In_Vax = 1
order by 2, 1

—-

—-

Analysis:

The total count of this subset is 247,394.

Pyrexia (fever) is the number one symptom in 58 vaccines
Comprising 149,701 counts of the symptom
60% of the subset

Pyrexia is the number one symptom overall and the number one symptom for 58 vaccines.