Symptom Counts By Vaccine

Exploratory Data Analysis.

Which vaccines resulted in the most symptoms?  

First, see:
Normalized Table AD_2019_ALL_VAX_NORM

Normalized Table AD_2019_ALL_SYMP_NORM

as these two tables are joined for this query.

—

Select count(*) Count
from dbo.[AD_2019_ALL_VAX_NORM]  

Count:
1,155,341

Select count(*) Count
from dbo.[AD_2019_ALL_SYMP_NORM]  

Count:
2,765,759

Note:

A cartesian product between these two tables would be:

= 1,155,341 * 2,765,759
= 3,195,394,768,819

Over three trillion. So large that SQL Server could not handle the query.

Select count(*) 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

Count:
4,221,966

Correct join gives 4.2 million rows

—

Select 
  vax.Vax
, 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
order by 2 desc

—

—

Analysis:

n=4,221,966

The vaccines that recorded the most symptoms are:
FLU3, MMR, VARZOS
comprising 21% of all symptoms

The results are similar to:
Reactions By VAX Code

—