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

VAXCountPercent WeightPCT Running Total
    
FLU396,8838.385668.3857
MMR82,3697.1294115.5151
VARCEL77,8016.7340322.2491
VARZOS73,0716.3246328.5737
HEP67,5325.8452034.4189
PPV62,3815.3993639.8183
DTAP60,4695.2338745.0522
HIBV54,8564.7480449.8002
HPV445,3703.9269853.7272
IPV41,7273.6116657.3388
TDAP38,1743.3041360.6430
HEPA37,5843.2530763.8960
PNC1333,5942.9077166.8037
PNC28,0402.4269969.2307
OPV24,7972.1462971.3770
FLU424,0562.0821673.4592
FLUX24,0092.0780975.5373
DTP23,6382.0459877.5832
MNQ23,1602.0046079.5878
RV520,7851.7990481.3869
TD18,1501.5709682.9578
MMRV14,7821.2794584.2373
HPV912,7631.1047085.3420
DTAPHEPBIP10,739.9295186.2715
DTAPIPVHIB9,969.8628687.1344
DTAPIPV9,270.8023687.9367
FLU(H1N1)9,175.7941488.7309
ANTH9,030.7815989.5124
MENB8,499.7356390.2481
TYP8,496.7353790.9834
RV18,101.7011891.6846
FLUN36,412.5549992.2396
DTPHIB6,362.5506692.7903
UNK5,866.5077393.2980
SMALL5,678.4914693.7895
HBHEPB5,578.4828094.2723
HEPAB5,131.4441194.7164
RAB5,118.4429995.1594
HPV24,563.3949595.5543
6VAX-F4,468.3867395.9410
MEN4,205.3639696.3050
YF3,977.3442396.6492
FLUN43,925.3397396.9889
TTOX3,519.3045997.2935
FLUC43,346.2896197.5831
FLUN(H1N1)2,892.2503297.8335
FLUX(H1N1)2,668.2309398.0644
DT2,608.2257398.2901
FLUA32,392.2070498.4972
LYME2,226.1926798.6898
HPVX1,911.1654198.8552
RVX1,458.1262098.9814
FLUC31,075.0930599.0745
RUB938.0811999.1557
FLUR4926.0801599.2358
DTAPH855.0740099.3098
MEA772.0668299.3766
RV701.0606799.4373
DTPIPV653.0565299.4938
BCG584.0505599.5444
JEV566.0489999.5934
PNC10496.0429399.6363
JEV1460.0398299.6761
DTIPV353.0305599.7067
DTPHEP293.0253699.7320
HBPV260.0225099.7545
MENHIB242.0209599.7755
CHOL232.0200899.7956
MER215.0186199.8142
DPP215.0186199.8328
MU203.0175799.8503
FLUR3194.0167999.8671
DTPPHIB184.0159399.8831
PER182.0157599.8988
DTPIHI148.0128199.9116
ADEN_4_7134.0116099.9232
TBE132.0114399.9347
DTOX121.0104799.9451
JEVX120.0103999.9555
MNC119.0103099.9658
MM116.0100499.9759
TDAPIPV115.0099599.9858
HEPATYP37.0032099.9890
MUR32.0027799.9918
PLAGUE28.0024299.9942
MNQHIB22.0019099.9961
SSEV12.0010499.9971
ADEN11.0009599.9981
CEE11.0009599.9990
DF5.0004399.9995
H5N14.0003599.9998
DPIPV2.00017100
    
    
Total, n1,155,341100 
Rows92 

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.

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *