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

—

Age_Range | DISABLEd_Count | Percent Weight | Percent Running Total |
---|---|---|---|

0 to 10 | 4,034 | 27.20 | 27.20 |

11 to 20 | 2,666 | 17.97 | 45.17 |

21 to 30 | 1,345 | 9.07 | 54.24 |

31 to 40 | 1,472 | 9.92 | 64.16 |

41 to 50 | 1,516 | 10.22 | 74.38 |

51 to 60 | 1,395 | 9.40 | 83.79 |

61 to 70 | 1,390 | 9.37 | 93.16 |

71 to 80 | 764 | 5.15 | 98.31 |

81 to 90 | 227 | 1.53 | 99.84 |

91 plus | 24 | 0.16 | 100 |

Total | 14,833 | 100 |

—

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%