Disabled by Number of Vaccines

Exploratory Data Analysis

Of those Disabled post vaccination, how many vaccines were they given?   

—

Field Analysis:

First see, Normalized Table AD_2019_ALL_VAX_NORM

select  
  count (DISABLE)  as CNT_Disabled
, count(*) CNT_VAERS_ID
from  dbo.[VAERSDATA]

CNT_Disabled: 17,644
CNT_VAERS_ID: 759,483

—

select count(*) CNT_ALL_VAX_NORM
From dbo.[AD_2019_ALL_VAX_NORM] vax

CNT_ALL_VAX_NORM: 1,155,341

Average number of Vaccines per VAERS_ID:
= 1,155,341/759,483
= 1.52

—

select count(*) CNT_VAX_DISABLED
From  dbo.[VAERSDATA]  v
join dbo.[AD_2019_ALL_VAX_NORM] vax
   on V.VAERS_ID = VAX.VAERS_ID 
WHERE V.DISABLE IS NOT NULL

—

CNT_VAX_DISABLED: 24,847

Of those DISABLEd,
24,847 vaccines were given to 17,644 individuals

Average number of Vaccines given to the DISABLEd
= 24,847 / 17,644
= 1.4

—

Query:

select sq.VAX_CNT
, count (*) Count
from
(
    select V.VAERS_ID
    , count(*) VAX_CNT
    From  dbo.[VAERSDATA]  v
    join dbo.[AD_2019_ALL_VAX_NORM] vax
       on V.VAERS_ID = VAX.VAERS_ID 
    WHERE V.DISABLE IS NOT NULL
    Group by V.VAERS_ID  
)  sq
Group by sq.VAX_CNT
order by 2 desc

—

Results:

—

Analysis:

On average, the number of vaccines given to those disabled post vaccination (1.4), is slightly less than the average number given to the whole population in VAERS (1.52).

76.9 percent of all those disabled post vaccination, were given only 1 vaccine.

11.8 percent of all those disabled post vaccination, were given 2 vaccines.

88.8 percent of all those disabled post vaccination, were given 2 vaccines or less.