Number One Symptom By Vaccine – DIED Only

Exploratory Data Analysis

For all those DIED, what is the number one symptom for 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

The only difference is that a filter is added:
DIED is not NULL

Table Counts:

Select count(*) VAERS_Count
from dbo.[VAERSDATA]

VAERS_Count: 759,483

Select count(*) All_Symp_norm_count
from dbo.[AD_2019_ALL_SYMP_NORM]

All_Symp_norm_count: 2,765,759

Select count(*) All_Vax_Norm_count
from dbo.[AD_2019_ALL_VAX_NORM]

All_Vax_Norm_count: 1,155,341

Count with all tables joined, and no filtration

Select count(*) All_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

All_Vax_Symp_count: 4,221,966

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 <= 1
order by 3 desc, 1, 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:

Select  outtter.Symptom
, count(*) Count_Number_One_Symptoms
, 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 <= 1
) outtter 
group by outtter.Symptom
order by 3 desc,  1

Results 2:

Grouped again and counts. For DIED, the number of times that the symptoms was the number one symptom of a VAX. And the number of times that the symptom was found in AD_2019_ALL_SYMP_NORM for DIED.

—

Analysis of Results 1:

Again, of the 92 VAX codes in the VAERS database, 82 of them had at least one death.

See: Deaths By VAX Code – Weighted

For this result set of DIED, the number one symptom of all 82 VAX codes, only 12 VAX have counts of 100 or more. These are: HIBV, OPV, DTP, HEP IPV, DTAP, PNC, PNC13, DTPHIB, PPV, MMR, FLU3.

The number one symptom of 23 VAX codes have counts between 10 and 100.

The number one symptom of 47 VAX codes have counts of 10 or less. 9 VAX codes, like RUB, count their number one symptom, only once. If the results are filtered for the top 10 symptoms, all of RUB’s top ten symptoms, tie for only 1 reaction. These are not statistically significant.

The top seven VAX all reported “Sudden infant death syndrome” as the number one symptom. They are: HIBV, OPV, DTP, HEP, IPV, DTAP, PNC.

Other VAX that reported SIDS were: DTPHIB, HBHEPB, DTAPHEPBIP, HBPV, HBPV, MNC.

The number one symptom in this set for FLUX(H1N1) was “Sudden death”

Of those that DIED post vaccination, the number one symptom for 15 VAX was Autopsy: PNC13, RV5, RV1, DTAPIPVHIB, 6VAX-F, FLU(H1N1), MEN, RVX, DTAPIPV, DTPIPV, FLUN4, PNC10, DTPPHIB, TBE, FLUR4

Of those that DIED post vaccination, the number one symptom for six VAX was Cardiac arrest: TD, FLUA3, TYP, JEV, FLUC3, JEVX. Similarily, MER reported Cardio-respiratory arrest. The Vax_Symp_count for each of these was 6 or less. These vaccines look to be removed from the market.

Of those that DIED post vaccination, the number one symptom for 17 VAX codes was Pyrexia: BCG, DT, DTAPH, DTIPV, DTPIHI, FLU3, FLUN3, HEPA, MEA, MENB, MM, MMR, MMRV, MNQ, UNK, VARCEL, YF.

One pattern is that for some VAX, the number one symptom post vaccination, aside from the fact that they DIED, is that the patients first contracted the infection that the vaccination was supposed to protect against. These are:

FLU4, Influenza
FLUX, Influenza
PPV, Pneumonia
RAB, Rabies
VARZOS, Herpes zoster

TTOX also reported Rabies as the number one symptom of those that DIED, even though the VAX is developed for Tetanus.

See also: Is tetanus a toxoid for rabies?

Would this suggest that TTOX also had the rabies virus in it? If anyone knows, please leave a comment.

—

Analysis of Results 2:

Of the 82 VAX codes that reported at least one post vaccination death, there were 29 number one symptoms.

The total of all reported symptoms in this result set was 4656.

Of those that DIED post vaccination, Sudden infant death syndrome (SIDS) was the number one symptom for 12 different VAX codes. SIDS is the symptom with the highest count of reported instances, 3242. This dominates 69.6% of the total 4656 instances in this result set.

For those that DIED post vaccination, Autopsy was the number one symptom for 15 VAX codes. There were 517 instances reported in this result set, comprising 11.1% of the total.

These two symptoms comprise 80% of the 4656 total symptoms in this result set.
Of those that DIED post vaccination, Pyrexia (fever) was the number one symptom for the most VAX codes, 17. However, the count of instances of Pyrexia was only 407 in this result set. This is approximately 1/8 the count of SIDS (3242).

—