Disabled By Age Group

Exploratory Data Analysis

Of those DISABLEd post vaccination, which Age groups are the most affected?

Field Analysis:
See Disabled By Age

—

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 DISABLEd_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   DISABLE 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

—

—

Analysis:

n=14,833

The age group with the most DISABLEd is 0 to 10, 27%.

The second most DISABLEd age group is 11 to 20, 18%

The least DISABLEd age group is 91 plus, .16%