Top Ten Symptoms By Vaccine – DIED only

Exploratory Data Analysis

For all those who DIED post vaccination, what were the top ten symptoms of each vaccine?    

—

Field Analysis:

First see

AD_2019_ALL_SYMP_NORM

AD_2019_ALL_VAX_NORM

This is basically the same query as
Number One Symptom By Vaccine – DIED Only
The only difference is that the filtration is for the top ten symptoms, not just the number one symptom.

It is also the same as:
Top Ten Symptoms By Vaccine – Disabled Only
except that the filtration is done for DIED, not DISABLE.

—

Query 1:

select 
   outter.Vax
,  outter.Symptom
,  outter.Vax_Symp_count
,  outter.Rank_In_Vax
from 
(

  Select 
    vs.vax
  , vs.symptom
  , vs.Vax_Symp_count
  , row_number() 
  over ( 
  partition by vs.vax 
  order by vs.Vax_Symp_count desc
  , vs.symptom
  )  as Rank_In_Vax
  from 
    (
    Select 
      vax.vax
    , symp.symptom
    , count(*) Vax_Symp_count
    from dbo.[AD_2019_ALL_SYMP_NORM]  as symp
    join  dbo.[AD_2019_ALL_VAX_NORM]  as vax
      on symp.vaers_id = vax.vaers_id
    join  dbo.[VAERSDATA]  v
      on v.vaers_id = vax.vaers_id
    where  V.DIED is NOT NULL
    and upper(symp.symptom) <> upper ('death') 
    group by 
      vax.vax
    , symp.symptom
    )  as          vs

)  outter
where  outter.Rank_In_Vax <= 10
order by 1, 3 desc, 4, 2

—

Results 1:

Note that the query is filtered for VAERSDATA.DIED is NOT NULL, but removes the AD_2019_ALL_SYMP_NORM.Symptom = ‘Death’. Otherwise, the majority of number one symptoms is ‘Death’.

—

Query 2:

The output of Query 1, Grouped BY and Counting the Symptoms.

—

Select  outtter.Symptom
, sum (outtter.Vax_Symp_count) As Sum_Symp_count
from
(
   select 
      outter.Vax
   ,  outter.Symptom
   ,  outter.Vax_Symp_count
   ,  outter.Rank_In_Vax
   from 
   (
     Select 
       vs.vax
     , vs.symptom
     , vs.Vax_Symp_count
     , row_number() 
     over ( 
     partition by vs.vax 
     order by vs.Vax_Symp_count desc
       , vs.symptom

     )  as Rank_In_Vax
     from 
       (
       Select 
         vax.vax
       , symp.symptom
       , count(*) Vax_Symp_count
       from dbo.[AD_2019_ALL_SYMP_NORM]  as symp
       join  dbo.[AD_2019_ALL_VAX_NORM]  as vax
         on symp.vaers_id = vax.vaers_id
       join  dbo.[VAERSDATA]  v
         on v.vaers_id = vax.vaers_id
       where  V.DIED is NOT NULL
       and upper(symp.symptom) <> upper ('death') 

       group by 
         vax.vax
       , symp.symptom
       )  as          vs
   )  outter
   where  outter.Rank_In_Vax <= 10
) outtter 
group by outtter.Symptom
order by 2 desc,  1

—

Results 2:

—

Analysis of Results 1:

A number of vaccines have the same symptoms in the top 3.
Sudden infant death syndrome, Apnoea, Pyrexia
They are: DTAP, HEP, HIBV, IPV, OPV, PNC

A number of VAX, for every symptom, have symptom counts less or equal to 10: ADEN_4_7, ANTH, DT, DTAPH, DTAPIPV, DTIPV, DTPHEP, DTPIHI, DTPIPV, FLUA3, FLUC3, FLUC4, FLUN(H1N1), FLUN3, FLUN4, FLUX(H1N1), HBPV, HEPAB, HPV2, HPV9, HPVX, JEV, JEV1, JEVX, LYME, MENB, MENHIB, MER, MM, MMRV, MNC, MU, PER, PLAGUE, PNC10, RUB, SMALL, TBE, TD, TDAP, TDAPIPV, TTOX

Some VAX do not have 10 symptoms listed:
CHOL, DPP, DTOX, JEV1, JEVX, TDAPIPV

These VAX also do not have many reactions. Another long tail.

—

Analysis of Results 2:

As in, Number One Symptom By Vaccine – DIED Only, in this result set, the most common symptom is: Sudden infant death syndrome

The most common five symptoms have counts over 1000:
Sudden infant death syndrome, Pyrexia, Autopsy, Cardiac arrest, Apnoea

With the exception of Pyrexia, the top 5 symptoms are the various ways patients died post vaccination.

—

—