Disabled By VAX Code

Exploratory Data Analysis

Of those who became DISABLEd post vaccination, which vaccines were given?   

—

Field Analysis:

First see, Normalized Table AD_2019_ALL_VAX_NORM

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

—

Count: 1,155,341

Select count(DISABLE) Count_DISABLEd
, count(*) Count_VAERSDATA
from dbo.[VAERSDATA]

—

Count_DISABLEd: 17,644
Count_VAERSDATA: 759,483

The 759,483 VAERS_ID were given 1,155,341 vaccines
= 1,155,341 / 759,483
= 1.52 vaccines per VAERS_ID on average

—

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 DISABLE is not null
Group By VN.Vax 
order by count(*) Desc

—

Results:

—

—

Analysis:

n=24,847 vaccines
Given to 17,644 VAERS_ID

Average number of vaccines per DISABLEd
= 24,847 / 17,644
= 1.4

88 unique VAX codes found in the result set. In the entire VAERS dataset, there are 92 unique VAX codes found.

HEP is the most common vaccine given before DISABLEd, accounting for 11% of all DISABLEd.

The top 48% of all DISABLEd were given one of the 5 vaccines:
HEP, HPV4, MMR, FLU3, VARZOS, HIBV, PPV. Each of these vaccines account for 4% or more of all DISABLEd.

The remaining 83 VAX codes all account for 4% or less.

Another long tail.

—