Exploratory Data Analysis
For all those DIED, what is the number one symptom for each vaccine?
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
Select count(*) VAERS_Count from dbo.[VAERSDATA]
Select count(*) All_Symp_norm_count from dbo.[AD_2019_ALL_SYMP_NORM]
Select count(*) All_Vax_Norm_count from dbo.[AD_2019_ALL_VAX_NORM]
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
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
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’.
|HIBV||Sudden infant death syndrome||682||1|
|OPV||Sudden infant death syndrome||495||1|
|DTP||Sudden infant death syndrome||436||1|
|HEP||Sudden infant death syndrome||395||1|
|IPV||Sudden infant death syndrome||332||1|
|DTAP||Sudden infant death syndrome||331||1|
|PNC||Sudden infant death syndrome||253||1|
|DTPHIB||Sudden infant death syndrome||137||1|
|HBHEPB||Sudden infant death syndrome||97||1|
|DTAPHEPBIP||Sudden infant death syndrome||78||1|
|TDAP||Foetal exposure during pregnancy||8||1|
|HBPV||Sudden infant death syndrome||4||1|
|MNC||Sudden infant death syndrome||2||1|
|TDAPIPV||Bordetella test positive||2||1|
|ADEN_4_7||Bacterial test negative||1||1|
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
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.
|Symptom||Count_Rows||Sum_Symp_count||Percent Weight of Total||Percent Running Total|
|Sudden infant death syndrome||12||3242||69.631||69.631|
|Foetal exposure during pregnancy||1||8||0.172||98.969|
|Bordetella test positive||1||2||0.043||99.742|
|Bacterial test negative||1||1||0.021||99.957|
Analysis of Results 1:
Again, of the 92 VAX codes in the VAERS database, 82 of them had at least one death.
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:
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).