Deaths By Age – Number One VAX

Exploratory Data Analysis

For those that DIED post vaccination, for each age, what was the number one VAX that preceded the most deaths?

Field Analysis:

Please see

AD_2019_AGE_YRS_ROUND

AD_2019_ALL_VAX_NORM

Deaths By Age

Deaths By VAX Code

Number One Symptom By Vaccine – DIED Only

Query:

use VAERS_2019
go

select 
  SQ_OUTER.AGE_YRS_ROUND
, SQ_OUTER.VAX
, SQ_OUTER.Count_AGE_VAX
, SQ_OUTER.Rank_In_AGE
from 
(
   Select SQ1.AGE_YRS_ROUND
   , SQ1.VAX 
   , SQ1.Count_AGE_VAX 
   , row_number() 
     over ( 
     partition by SQ1.AGE_YRS_ROUND
     order by SQ1.Count_AGE_VAX  desc
     )  as Rank_In_AGE
   from 
      (
      select YRS.AGE_YRS_ROUND
      ,  VN.VAX
      , COUNT(*) Count_AGE_VAX
      from dbo.[VAERSDATA]  V
      join dbo.[AD_2019_AGE_YRS_ROUND]  YRS
           on V.VAERS_ID = YRS.VAERS_ID
      join dbo.[AD_2019_ALL_VAX_NORM]  VN
         on   V.VAERS_ID   =  VN.VAERS_ID
      where DIED is NOT NULL
      and   YRS.AGE_YRS_ROUND is NOT NULL
      
      Group BY YRS.AGE_YRS_ROUND
      ,  VN.VAX
      )  SQ1
)  SQ_OUTER
where Rank_In_AGE <=  1


Results:

AGE_YRS_ROUNDVAXCount_AGE_VAXRank_In_AGE
0HIBV12891
1HIBV3021
2MMR541
3PNC101
4MMR141
5MMR121
6MMR61
7FLU341
8MMR41
9FLU341
10MMR31
11HPV481
12HPV4161
13HPV4111
14HPV4171
15HPV4151
16HPV4171
17HPV4131
18MNQ111
19HPV481
20HPV461
21HPV441
22FLU351
23FLU341
24HEP51
25HEP31
26YF31
27MMR21
28PPV31
29HEP21
30ANTH21
31PPV21
32HEPAB21
33RAB21
34FLU341
35HEP41
36HEP61
37PPV21
38HEP21
39ANTH31
40FLUX31
41TYP31
42PPV41
43FLU351
44FLUX31
45RAB51
46FLU341
47FLU361
48HEP31
49FLUX61
50PPV61
51PPV21
52FLU351
53FLUX101
54FLU331
55FLU371
56FLU351
57FLU381
58PPV61
59FLUX81
60FLU391
61FLU3101
62FLU391
63FLU3111
64FLU3101
65FLU3121
66FLU3141
67FLU3171
68FLU3121
69FLU3171
70FLUX171
71FLU3141
72FLU3111
73FLU3271
74FLU3151
75FLU3211
76FLU3161
77FLU3231
78FLU3201
79FLU3271
80FLU3291
81FLU3181
82FLU3161
83FLU3121
84FLU3171
85FLU3101
86FLU3151
87PPV101
88FLU371
89FLU3101
90PPV111
91FLUX41
92FLU381
93VARZOS31
94PPV81
95FLU361
96FLU331
97PPV41
98FLU321
99PPV21
100FLU321
102PPV11
104FLUX11
    
 Total2497 
 Rows103

Analysis:

Rows/Count of unique ages: n = 103
Count of DIED in this subset: n = 2497

For babies, 0 to 1.49 years or less, the number one VAX preceding post vaccination deaths is HIBV.

Of all the deaths in this subset (2497), the deaths in ages 0 and 1 comprise 63.7% of all deaths (1591). This is similar to the results in Deaths by Age, where 56% of all deaths were between 0 and 1.

Note the patterns.

Starting age 2, the number one VAX preceding post vaccination deaths is MMR. MMR continues as the number one VAX until age 10, with two exceptions.

From age 11 to 21, the number one VAX preceding post vaccination deaths is HPV4, with one exception.

Between age 22 to 45, there is no strong pattern. However, some of the repeating number one VAX preceding post vaccination deaths are: HEP, PPV, MMR, FLU3.

Starting from age 46, until age 89, FLU3 dominates the number one VAX preceding post vaccination deaths, with only 6 exceptions.

From age 90 to age 104, the number one VAX preceding post vaccination deaths is either PPV, FLU3 or FLUX, with only one exception.

Leave a Reply

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