Deaths By Year

Exploratory Data Analysis

Of the reactions, how many deaths were reported each year?  

Field Analysis:


use vaers_2019
go

Select DIED
, count(*) Count 
from dbo.[VAERSDATA]
group by DIED

DIEDCountPercent Weight
NULL751,33398.93
Y8,1501.07
   
Total759,483100

In the field DIED, the only values are NULL and Y. No data anomalies such as blanks or other characters. Clean data.

Percent DIED by Year:

select Year ( s_date ) Year
, Count (DIED) Count_DIED
, count(*) Count_Reactions
from dbo.[VAERSDATA]
group by Year ( s_date )
order by 1

YearCount_DIEDCount_ReactionsPercent DIED Each Year
1990802,1513.72
19911669,9921.66
199222810,8172.11
199323410,3092.27
199423710,3542.29
199515810,2731.54
199615111,1891.35
199717311,6081.49
199817210,7821.60
199917912,8781.39
200021215,1141.40
200122514,6331.54
200218715,3311.22
200326518,0821.47
200420816,5101.26
200521517,4471.23
200622019,3301.14
200726230,8130.85
200833333,4431.00
200933737,0420.91
201031936,5780.87
201133131,1261.06
201231632,1100.98
201333936,2620.93
201435841,2410.87
201537751,9540.73
201643753,6990.81
201745946,3440.99
201853557,8060.93
201943453,8460.81
202034190.72
    
Totals   
1990-20208,150759,4831.07
1991-20198,067756,9131.07

Statistics For Years 1991-2019:

Stats: 1991-2019Percent DIED by Year
Min0.73
Max2.29
Median1.22
Mean1.27
Standard Deviation0.43
Kurtosis0.57

Analysis:

There are 29 data points (rows) for the years 1991 to 2019.

Total n values:

Count_DIED:
n=8,067

Count_Reactions:
n=756,913

The mean (1.27) and median (1.22) are very close to each other, indicating the data is not significantly skewed.

Both the mean and median are multiples (~2.8 times) larger than the standard deviation (0.43), indicating that there is little variability.

Post vaccinations, the number of DIED per year is pretty consistent.

For all years, the average is 1.07% of all reactions.

The trend is clear. Both the number of reactions, and the number of people who DIED after a vaccination are rising.

Leave a Reply

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