Deaths By VAX Code

Exploratory Data Analysis

Of those who DIED post vaccination, which vaccines were given?

Field Analysis:

First see, Normalized Table AD_2019_ALL_VAX_NORM

Select count(DIED) Count_DIED
, count(*) Count_VAERSDATA
from dbo.[VAERSDATA]

Count_DIED: 8,150
Count_VAERSDATA: 759,483

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

Count: 1,155,341

Of those that DIED post vaccination,
Total VAX administered:

Select count(*) Vax_Count
from dbo.[VAERSDATA]   V
join dbo.[AD_2019_ALL_VAX_NORM]  VN
   on   V.VAERS_ID   =  VN.VAERS_ID
Where DIED is not null

Vax_Count: 15,499

Query:

Select  VN.Vax
, count(*) Vax_Count
from dbo.[VAERSDATA]   V
join dbo.[AD_2019_ALL_VAX_NORM]  VN
   on   V.VAERS_ID   =  VN.VAERS_ID
Where DIED is not null
Group By VN.Vax 
order by count(*) Desc

Results:

VaxVax_CountPercent WeightPercent Running Total
HIBV1,73911.2211.22
HEP1,3118.4619.68
OPV1,0336.6626.34
PNC9746.2832.63
DTP8775.6638.29
FLU38745.6443.93
DTAP8685.6049.53
PNC138345.3854.91
IPV8285.3460.25
PPV5413.4963.74
FLUX5333.4467.18
RV54542.9370.11
MMR4102.6572.75
DTAPHEPBIP3942.5475.30
HPV43682.3777.67
DTAPIPVHIB2871.8579.52
DTPHIB2661.7281.24
RV12631.7082.93
6VAX-F2131.3784.31
VARZOS1991.2885.59
HBHEPB1961.2686.86
VARCEL1761.1487.99
RAB1310.8588.84
FLU41260.8189.65
HEPA1170.7590.41
HPVX990.6491.04
BCG980.6391.68
UNK970.6392.30
FLU(H1N1)850.5592.85
MEN800.5293.37
TDAP780.5093.87
MNQ660.4394.30
RVX620.4094.70
YF610.3995.09
FLUX(H1N1)500.3295.41
DTPHEP440.2895.70
MENB430.2895.97
HPV2420.2796.24
TD420.2796.52
MEA380.2596.76
FLUA3370.2497.00
TYP320.2197.21
DTPIPV320.2197.41
ANTH310.2097.61
HPV9310.2097.81
DTAPIPV300.1998.01
HEPAB280.1898.19
TTOX270.1798.36
FLUN3250.1698.52
DT250.1698.68
MMRV240.1598.84
PNC10180.1298.95
SMALL180.1299.07
FLUN4150.1099.17
DTAPH150.1099.26
RV100.0699.33
LYME90.0699.39
HBPV90.0699.45
FLUN(H1N1)90.0699.50
PER70.0599.55
DTPIHI60.0499.59
MENHIB60.0499.63
DTIPV50.0399.66
MU50.0399.69
FLUC450.0399.72
JEV50.0399.75
MNC50.0399.79
TBE30.0299.81
FLUC330.0299.83
JEVX30.0299.85
MER30.0299.86
MM30.0299.88
PLAGUE30.0299.90
DTPPHIB30.0299.92
TDAPIPV30.0299.94
FLUR420.0199.95
JEV120.0199.97
DTOX10.0199.97
ADEN_4_710.0199.98
DPP10.0199.99
CHOL10.0199.99
RUB10.01100
    
Total15,499100 
Rows82 

Analysis:

All data
All years
All deaths, n=8150

Of those who DIED post vaccination,
15499 vaccines were administered to
8150 VAERS_ID

Average number of vaccines per DIED post vaccination
= 15499 / 8150
= 1.9

In the entire data set, 1,155,341 vaccines were given to 759,483 VAERS_ID

Average number of vaccines in the entire data set:
= 1,155,341 / 759,483
= 1.52 vaccines per VAERS_ID on average

The number of vaccines given to those who DIED post vaccination (1.9) is slightly higher than the number given in the entire data set (1.52).

82 unique VAX codes found in the DIED result set. In the entire VAERS dataset, there are 92 unique VAX codes found. So, 89% of all VAX, were associated with at least one death post vaccination.

Of the 8150 post vaccination deaths

HIBV is the number 1 most common vaccine given, found in 11.2% of all post vaccination deaths

HEP is the number 2 most common vaccine given, found in 8.4%.

OPV is the number 3 most common vaccine given, found in 6.6%.

The top three vaccines, HIBV, HEP, and OPV were given in 26.3% of all post vaccination deaths

The top seven vaccines (HIBV, HEP, OPV, PNC, DTP, FLU3, DTAP), were given in 49.5% of all post vaccination deaths

The remaining 74 VAX codes were given in the remaining 50.5% of post vaccination deaths. Another long tail.

These results do not take into account any contraindications between multiple vaccines.

See also the post
Deaths by Number of Vaccines

Leave a Reply

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