Exploratory Data Analysis
Of those that DIED post vaccination, how many vaccines were they given?
First see, Normalized Table AD_2019_ALL_VAX_NORM
select count (DIED) as CNT_DIED , count(*) CNT_VAERS_ID from dbo.[VAERSDATA]
Select count(*) CNT_ALL_VAX_NORM From dbo.[AD_2019_ALL_VAX_NORM] vax
Average number of Vaccines for all VAERS_ID:
select count(*) CNT_VAX_DIED From dbo.[VAERSDATA] v join dbo.[AD_2019_ALL_VAX_NORM] vax on V.VAERS_ID = VAX.VAERS_ID WHERE V.DIED IS NOT NULL
Average number of Vaccines, given to those that DIED post vaccination:
15,499 vaccines were given to 8,150 individuals
= 15,499 / 8,150
= 1.90 vaccines per DIED
Note: This query could be done using VAERSDATA.VAX_CNT. However, this contained some duplicate records, about 2 dozen. They look like even more clerical errors.
Using the renormalized table, AD_2019_ALL_VAX_NORM, eliminated the duplicate rows.
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.DIED IS NOT NULL Group by V.VAERS_ID ) sq Group by sq.VAX_CNT order by 1
|VAX_CNT||Death_Count||Percent Weight||Percent Running Total|
All deaths, n=8150
On average, the number of vaccines given to those that DIED post vaccination (1.90), is slightly more than the average number given to the whole population in VAERS (1.52).
The majority of all deaths post vaccination, 56 percent, were given only 1 vaccine.
14 percent of all deaths post vaccination, were given 2 vaccines.
16 percent of all deaths post vaccination, were given 3 vaccines.
86 percent of all deaths post vaccination, were given 3 vaccines or less