Exploratory Data Analysis
Of all post vaccination deaths, which Age groups are the most affected?
—
Field Analysis:
For field analysis, first see, Deaths By Age
—-
Query:
use VAERS_2019
go
select
CASE WHEN [AGE_YRS_ROUND] <= 10.0 THEN '0 to 10'
WHEN [AGE_YRS_ROUND] <= 20.0 THEN '11 to 20'
WHEN [AGE_YRS_ROUND] <= 30.0 THEN '21 to 30'
WHEN [AGE_YRS_ROUND] <= 40.0 THEN '31 to 40'
WHEN [AGE_YRS_ROUND] <= 50.0 THEN '41 to 50'
WHEN [AGE_YRS_ROUND] <= 60.0 THEN '51 to 60'
WHEN [AGE_YRS_ROUND] <= 70.0 THEN '61 to 70'
WHEN [AGE_YRS_ROUND] <= 80.0 THEN '71 to 80'
WHEN [AGE_YRS_ROUND] <= 90.0 THEN '81 to 90'
WHEN [AGE_YRS_ROUND] <= 400.0 THEN '91 plus'
END
AS Age_Range
, count(*) as DIED_Count
from dbo.[VAERSDATA] V
join dbo.[AD_2019_AGE_YRS_ROUND] YRS
on V.VAERS_ID = YRS.VAERS_ID
where YRS.AGE_YRS_ROUND is NOT NULL
and DIED is NOT NULL
group by
CASE WHEN [AGE_YRS_ROUND] <= 10.0 THEN '0 to 10'
WHEN [AGE_YRS_ROUND] <= 20.0 THEN '11 to 20'
WHEN [AGE_YRS_ROUND] <= 30.0 THEN '21 to 30'
WHEN [AGE_YRS_ROUND] <= 40.0 THEN '31 to 40'
WHEN [AGE_YRS_ROUND] <= 50.0 THEN '41 to 50'
WHEN [AGE_YRS_ROUND] <= 60.0 THEN '51 to 60'
WHEN [AGE_YRS_ROUND] <= 70.0 THEN '61 to 70'
WHEN [AGE_YRS_ROUND] <= 80.0 THEN '71 to 80'
WHEN [AGE_YRS_ROUND] <= 90.0 THEN '81 to 90'
WHEN [AGE_YRS_ROUND] <= 400.0 THEN '91 plus'
END
order by 1;
go
—
Results:
| Age_Range | DIED_Count | Percent Weight | Percent Running Total |
|---|---|---|---|
| 0 to 10 | 4,107 | 65.18 | 65.18 |
| 11 to 20 | 354 | 5.62 | 70.80 |
| 21 to 30 | 131 | 2.08 | 72.88 |
| 31 to 40 | 104 | 1.65 | 74.53 |
| 41 to 50 | 171 | 2.71 | 77.24 |
| 51 to 60 | 206 | 3.27 | 80.51 |
| 61 to 70 | 359 | 5.70 | 86.21 |
| 71 to 80 | 449 | 7.13 | 93.33 |
| 81 to 90 | 314 | 4.98 | 98.32 |
| 91 plus | 106 | 1.68 | 100 |
| Total | 6,301 | 100 |
—
Analysis:
All years, All deaths, All data
Where both the field DIED and AGE_YRS is populated,
n=6301
Of all post vaccination deaths,
65.18% are in the age group: 0 to 10
The remaining 34.82% are found in all other age groups starting at age 11. The maximum age found was 104.
Another long tail.
Clearly, post vaccination deaths occur mainly in children.
For more detail on deaths by individual ages, please see
Deaths By Age