Reactions By VAX Code

Exploratory Data Analysis
Counts of all VAERS Reactions by VAX code 

—

Use VAERS_2019
go

Select count(*) Count
from dbo.VAERSDATA
go

Count:
759,483

—

Select count(*) Count
from dbo.AD_2019_all_vax_norm
go

—

Count:
1,155,341

There are 759,483 unique VAERS_ID, each indicating a reaction to at least one vaccine.

In these 759K reactions, 1,155,341 vaccines were taken.

Average:
= 1,155,341/759,483
= 1.52 vaccines per VAERS_ID

—

Select VAX
, count(*) Count
from dbo.AD_2019_all_vax_norm
group by VAX
order by 2 desc

—

—

Statistics:

n = 1,155,341
Years: 1990 to early 2020

92 unique vaccine codes found

Over 20% of all reactions in VAERS come from 3 vaccines codes:
FLU3, MMR, VARCEL

Over 50% of all reactions in VAERS come from 9 vaccines:
FLU3, MMR, VARCEL, VARZOS, HEP, PPV, DTAP, HIBV, HPV4

Comment:

There are:
13 VAX codes that start with FLU
5 VAX codes that start with DTAP
4 VAX codes that start with HPV
2 VAX codes that start with MMR

7 VAX codes that contain the phrase HEP

If it makes sense to group these 92 vaccines into fewer categories, please send a link as how they should be grouped.