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’.

VaxSymptomVax_Symp_countRank_In_Vax
6VAX-FAutopsy551
6VAX-FSudden infant death syndrome522
6VAX-FResuscitation323
6VAX-FPyrexia244
6VAX-FSudden death195
6VAX-FCardiac arrest176
6VAX-FRespiratory arrest127
6VAX-FHypotonia118
6VAX-FCardio-respiratory arrest99
6VAX-FVomiting910
ADEN_4_7Bacterial test negative11
ADEN_4_7Blood culture negative12
ADEN_4_7Cold agglutinins negative13
ADEN_4_7CSF culture negative14
ADEN_4_7Culture urine negative15
ADEN_4_7Diarrhoea16
ADEN_4_7Dizziness17
ADEN_4_7Drug screen negative18
ADEN_4_7Influenza A virus test negative19
ADEN_4_7Influenza B virus test110
ANTHFatigue51
ANTHCardiovascular disorder32
ANTHCompleted suicide33
ANTHDyspnoea34
ANTHInfluenza like illness35
ANTHLaboratory test abnormal36
ANTHMalaise37
ANTHMyocardial infarction38
ANTHArthralgia29
ANTHCardiomegaly210
BCGPyrexia311
BCGCough232
BCGRespiratory rate increased173
BCGPneumonia114
BCGBovine tuberculosis95
BCGVomiting96
BCGAutopsy87
BCGLymphadenopathy88
BCGCyanosis69
BCGFeeling cold610
CHOLMultiple sclerosis11
DPPDyspnoea11
DPPRash12
DTPyrexia71
DTUnevaluable event62
DTAutopsy33
DTInfection34
DTMalaise35
DTSudden infant death syndrome36
DTVomiting37
DTAcidosis28
DTAcute disseminated encephalomyelitis29
DTAgitation210
DTAPSudden infant death syndrome3311
DTAPApnoea1192
DTAPPyrexia1013
DTAPUnevaluable event1004
DTAPCardiac arrest925
DTAPComa706
DTAPCyanosis557
DTAPAutopsy538
DTAPIrritability459
DTAPVomiting4410
DTAPHPyrexia61
DTAPHSudden infant death syndrome32
DTAPHComa23
DTAPHGrunting24
DTAPHIntussusception25
DTAPHPetechiae26
DTAPHVomiting27
DTAPHAbdominal distension18
DTAPHAcute respiratory failure19
DTAPHAnaemia110
DTAPHEPBIPSudden infant death syndrome781
DTAPHEPBIPAutopsy692
DTAPHEPBIPUnresponsive to stimuli453
DTAPHEPBIPRespiratory arrest384
DTAPHEPBIPResuscitation375
DTAPHEPBIPCardiac arrest286
DTAPHEPBIPApnoea267
DTAPHEPBIPPyrexia268
DTAPHEPBIPIrritability219
DTAPHEPBIPVomiting2010
DTAPIPVAutopsy91
DTAPIPVPyrexia82
DTAPIPVResuscitation53
DTAPIPVSudden death54
DTAPIPVSudden infant death syndrome55
DTAPIPVCardio-respiratory arrest46
DTAPIPVRespiratory arrest47
DTAPIPVUnresponsive to stimuli48
DTAPIPVAsphyxia39
DTAPIPVCardiac arrest310
DTAPIPVHIBAutopsy641
DTAPIPVHIBSudden infant death syndrome502
DTAPIPVHIBResuscitation463
DTAPIPVHIBRespiratory arrest304
DTAPIPVHIBUnresponsive to stimuli305
DTAPIPVHIBPyrexia266
DTAPIPVHIBCardiac arrest207
DTAPIPVHIBVomiting178
DTAPIPVHIBCrying169
DTAPIPVHIBIrritability1510
DTIPVPyrexia31
DTIPVHeadache22
DTIPVAutoantibody negative13
DTIPVBiopsy heart normal14
DTIPVBrain herniation15
DTIPVCardiac output16
DTIPVCerebellar haemorrhage17
DTIPVCerebellar infarction18
DTIPVComputerised tomogram head abnormal19
DTIPVConvulsion110
DTOXMultiple sclerosis11
DTPSudden infant death syndrome4361
DTPApnoea1372
DTPPyrexia1133
DTPCardiac arrest1004
DTPUnevaluable event805
DTPLung disorder746
DTPPetechiae687
DTPPulmonary oedema688
DTPAgitation679
DTPHaemorrhage4710
DTPHEPCrying101
DTPHEPPyrexia102
DTPHEPPneumonia83
DTPHEPAnaemia74
DTPHEPBronchopneumonia65
DTPHEPColitis66
DTPHEPEnteritis67
DTPHEPAutopsy58
DTPHEPDyspnoea59
DTPHEPPallor510
DTPHIBSudden infant death syndrome1371
DTPHIBApnoea562
DTPHIBPyrexia503
DTPHIBCardiac arrest364
DTPHIBUnevaluable event335
DTPHIBPneumonia286
DTPHIBPetechiae277
DTPHIBStupor248
DTPHIBCyanosis229
DTPHIBAgitation1910
DTPIHIPyrexia21
DTPIHIApnoea12
DTPIHIAsthenia13
DTPIHIBronchitis14
DTPIHICardiovascular disorder15
DTPIHICyanosis16
DTPIHIGastrooesophageal reflux disease17
DTPIHIHepatitis18
DTPIHIHyporesponsive to stimuli19
DTPIHIMalaise110
DTPIPVAutopsy91
DTPIPVCardio-respiratory arrest72
DTPIPVResuscitation63
DTPIPVSudden infant death syndrome64
DTPIPVPyrexia45
DTPIPVRespiratory arrest46
DTPIPVSudden death47
DTPIPVInterstitial lung disease38
DTPIPVLoss of consciousness39
DTPIPVNasopharyngitis310
DTPPHIBAutopsy21
DTPPHIBBrain oedema22
DTPPHIBSudden infant death syndrome23
DTPPHIBAsphyxia14
DTPPHIBBloody airway discharge15
DTPPHIBCerebrovascular disorder16
DTPPHIBDecreased appetite17
DTPPHIBDiffuse alveolar damage18
DTPPHIBHepatic steatosis19
DTPPHIBHistology110
FLU(H1N1)Autopsy141
FLU(H1N1)Dyspnoea92
FLU(H1N1)Pyrexia73
FLU(H1N1)Asthenia64
FLU(H1N1)Syncope65
FLU(H1N1)Unresponsive to stimuli66
FLU(H1N1)Dizziness57
FLU(H1N1)Guillain-Barre syndrome58
FLU(H1N1)Intensive care59
FLU(H1N1)Myocardial infarction510
FLU3Pyrexia1071
FLU3Pneumonia792
FLU3Cough763
FLU3Dyspnoea714
FLU3Cardiac arrest605
FLU3Malaise526
FLU3Apnoea517
FLU3Asthenia488
FLU3Myocardial infarction469
FLU3Unevaluable event4610
FLU4Influenza301
FLU4Vaccination failure272
FLU4Pyrexia173
FLU4Autopsy154
FLU4Cough95
FLU4Unresponsive to stimuli96
FLU4Dyspnoea87
FLU4Pneumonia88
FLU4Resuscitation89
FLU4Asthenia710
FLUA3Cardiac arrest51
FLUA3Diarrhoea52
FLUA3Malaise53
FLUA3Dyspnoea44
FLUA3Hyperpyrexia45
FLUA3Abdominal pain upper36
FLUA3Autopsy37
FLUA3Guillain-Barre syndrome38
FLUA3Pneumonia39
FLUA3Vomiting310
FLUC3Cardiac arrest11
FLUC3Cardiac failure congestive12
FLUC3Diarrhoea13
FLUC3General physical health deterioration14
FLUC3Hospice care15
FLUC3Malaise16
FLUC3Resuscitation17
FLUC4Death neonatal21
FLUC4Foetal exposure during pregnancy22
FLUC4Acute disseminated encephalomyelitis13
FLUC4Alpha 1 foetoprotein normal14
FLUC4Apgar score abnormal15
FLUC4Caesarean section16
FLUC4Cardiac arrest17
FLUC4Congenital cystic kidney disease18
FLUC4Oligohydramnios19
FLUC4Premature baby110
FLUN(H1N1)Fatigue21
FLUN(H1N1)Influenza like illness22
FLUN(H1N1)Resuscitation23
FLUN(H1N1)Autopsy14
FLUN(H1N1)Blood alkaline phosphatase normal15
FLUN(H1N1)Blood glucose normal16
FLUN(H1N1)Cardiac arrest17
FLUN(H1N1)Chest X-ray abnormal18
FLUN(H1N1)Cough19
FLUN(H1N1)Croup infectious110
FLUN3Pyrexia61
FLUN3Autopsy42
FLUN3Headache43
FLUN3Dyspnoea34
FLUN3Intensive care35
FLUN3Vomiting36
FLUN3Activities of daily living impaired27
FLUN3Asthenia28
FLUN3Asthma29
FLUN3Fall210
FLUN4Autopsy51
FLUN4Vomiting32
FLUN4Cardiac arrest23
FLUN4Cough24
FLUN4Cyanosis25
FLUN4Influenza26
FLUN4Malaise27
FLUN4Mental status changes28
FLUN4Pyrexia29
FLUN4Sudden death210
FLUR4Autopsy11
FLUR4Gait inability12
FLUR4Muscular weakness13
FLUXInfluenza881
FLUXDyspnoea572
FLUXPyrexia503
FLUXPneumonia484
FLUXAutopsy465
FLUXCardiac arrest436
FLUXMalaise427
FLUXGuillain-Barre syndrome348
FLUXAsthenia309
FLUXMyocardial infarction3010
FLUX(H1N1)Sudden death101
FLUX(H1N1)Unevaluable event52
FLUX(H1N1)Cardio-respiratory arrest43
FLUX(H1N1)Autopsy34
FLUX(H1N1)Condition aggravated35
FLUX(H1N1)Guillain-Barre syndrome36
FLUX(H1N1)Respiratory failure37
FLUX(H1N1)Resuscitation38
FLUX(H1N1)Vomiting39
FLUX(H1N1)Blood test210
HBHEPBSudden infant death syndrome971
HBHEPBApnoea332
HBHEPBCardiac arrest273
HBHEPBUnevaluable event264
HBHEPBComa235
HBHEPBPyrexia186
HBHEPBPulmonary oedema147
HBHEPBCyanosis138
HBHEPBNasal congestion119
HBHEPBAsphyxia1010
HBPVSudden infant death syndrome41
HBPVIrritability22
HBPVPyrexia23
HBPVAbnormal sleep-related event14
HBPVAgitation15
HBPVCardiac arrest16
HBPVComa17
HBPVConjunctivitis18
HBPVContusion19
HBPVConvulsion110
HEPSudden infant death syndrome3951
HEPPyrexia1392
HEPApnoea1273
HEPCardiac arrest1104
HEPUnevaluable event1065
HEPInfection786
HEPAutopsy647
HEPVomiting648
HEPPetechiae629
HEPPulmonary oedema6110
HEPAPyrexia221
HEPAAutopsy212
HEPACardiac arrest113
HEPADyspnoea84
HEPAHeadache85
HEPAMalaise86
HEPAEndotracheal intubation77
HEPAVomiting78
HEPAAsthenia69
HEPAConvulsion610
HEPABArrhythmia41
HEPABAutopsy32
HEPABCardiac arrest33
HEPABHeadache34
HEPABHepatitis A35
HEPABViral infection36
HEPABComa27
HEPABComputerised tomogram abnormal28
HEPABDiarrhoea29
HEPABFatigue210
HIBVSudden infant death syndrome6821
HIBVApnoea2292
HIBVPyrexia1983
HIBVCardiac arrest1894
HIBVAutopsy1535
HIBVUnevaluable event1336
HIBVPulmonary oedema917
HIBVCyanosis908
HIBVLung disorder859
HIBVVomiting8410
HPV2Malaise51
HPV2Cardiac arrest42
HPV2Completed suicide43
HPV2Headache34
HPV2Pyrexia35
HPV2Abdominal pain26
HPV2Abdominal pain upper27
HPV2Arrhythmia28
HPV2Back pain29
HPV2Chemotherapy210
HPV4Thrombosis431
HPV4Headache292
HPV4Autopsy253
HPV4Unevaluable event204
HPV4Sudden death155
HPV4Fatigue136
HPV4Pyrexia137
HPV4Malaise128
HPV4Completed suicide119
HPV4Syncope1110
HPV9Headache41
HPV9Syncope42
HPV9Unevaluable event43
HPV9Pyrexia34
HPV9Rash25
HPV9Seizure26
HPV9Vaccination complication27
HPV9Activities of daily living impaired18
HPV9Acute disseminated encephalomyelitis19
HPV9Adverse event110
HPVXMalaise71
HPVXCervix carcinoma52
HPVXDizziness53
HPVXHeadache54
HPVXAutopsy45
HPVXParalysis46
HPVXVaccination complication47
HPVXAdverse event38
HPVXAsthenia39
HPVXDisability310
IPVSudden infant death syndrome3321
IPVApnoea1042
IPVPyrexia913
IPVUnevaluable event844
IPVCardiac arrest755
IPVComa656
IPVAutopsy477
IPVCyanosis478
IPVVomiting449
IPVIrritability3810
JEVCardiac arrest31
JEVComa22
JEVPyrexia23
JEVSyncope24
JEVApnoea15
JEVBrain oedema16
JEVCardiac failure17
JEVCerebral haemorrhage18
JEVCerebral ischaemia19
JEVCondition aggravated110
JEV1Body temperature11
JEV1Brain injury12
JEV1Cardiac arrest13
JEV1Dizziness14
JEV1Encephalitis viral15
JEV1General physical health deterioration16
JEV1Influenza like illness17
JEV1Speech disorder18
JEV1Sudden death19
JEVXCardiac arrest11
JEVXCyanosis12
JEVXHaematemesis13
JEVXInappropriate schedule of drug administration14
JEVXSudden death15
JEVXViral myocarditis16
LYMEArthralgia31
LYMECognitive disorder32
LYMEAgitation23
LYMEAntinuclear antibody negative24
LYMEArteriosclerosis25
LYMEBack pain26
LYMEBlood immunoglobulin G27
LYMEBlood immunoglobulin M28
LYMECardiovascular disorder29
LYMEFatigue210
MEAPyrexia121
MEAVomiting82
MEADiarrhoea73
MEAPneumonia74
MEAPoor quality drug administered65
MEASeptic shock66
MEAToxic shock syndrome67
MEAConvulsion58
MEAComa49
MEAEncephalitis410
MENAutopsy131
MENPyrexia122
MENMeningitis103
MENNeisseria test positive94
MENVaccination failure95
MENSudden infant death syndrome86
MENEncephalitis57
MENHaemoglobin decreased58
MENMeningococcal infection59
MENSudden death510
MENBPyrexia91
MENBAutopsy72
MENBSudden infant death syndrome63
MENBCardio-respiratory arrest54
MENBVaccination failure55
MENBCardiac arrest46
MENBResuscitation47
MENBSudden death48
MENBCyanosis39
MENBMalaise310
MENHIBResuscitation31
MENHIBIntensive care22
MENHIBAdenovirus test positive13
MENHIBAspiration14
MENHIBBody temperature increased15
MENHIBBradycardia16
MENHIBCardiac arrest17
MENHIBCerebral disorder18
MENHIBComputerised tomogram normal19
MENHIBCSF lymphocyte count increased110
MERCardio-respiratory arrest21
MERAlanine aminotransferase increased12
MERApnoea13
MERAspartate aminotransferase increased14
MERAsphyxia15
MERAspiration bronchial16
MERAutopsy17
MERBlood alkaline phosphatase increased18
MERBody temperature increased19
MERChest X-ray abnormal110
MMPyrexia31
MMBradycardia22
MMEncephalitis23
MMApnoea14
MMBrain oedema15
MMConvulsion16
MMElectroencephalogram abnormal17
MMFebrile convulsion18
MMInfection19
MMLaboratory test abnormal110
MMRPyrexia1101
MMRAutopsy432
MMRInfection393
MMRVomiting374
MMRConvulsion355
MMRCardiac arrest346
MMRPneumonia317
MMRUnevaluable event298
MMRApnoea289
MMREncephalitis2610
MMRVPyrexia81
MMRVAutopsy62
MMRVCardiac arrest33
MMRVResuscitation34
MMRVCardio-respiratory arrest25
MMRVDyspnoea26
MMRVRestlessness27
MMRVSudden death28
MMRVToxicologic test29
MMRVToxicologic test normal210
MNCSudden infant death syndrome21
MNCAsphyxia12
MNCAtelectasis13
MNCAutopsy14
MNCBlood test15
MNCCardiac arrest16
MNCConvulsion17
MNCCough18
MNCCSF test19
MNCCSF test abnormal110
MNQPyrexia161
MNQIntensive care82
MNQMeningococcal infection83
MNQNeisseria test positive84
MNQAutopsy65
MNQMeningitis meningococcal66
MNQMeningococcal sepsis67
MNQVaccination failure68
MNQBlood culture positive59
MNQCardiac arrest510
MURespiratory failure21
MUCardiac arrest12
MUCellulitis13
MUChest pain14
MUCough15
MUDizziness16
MUElectrocardiogram abnormal17
MUEncephalitis18
MUEncephalopathy19
MUHeadache110
OPVSudden infant death syndrome4951
OPVApnoea1742
OPVPyrexia1403
OPVCardiac arrest1224
OPVUnevaluable event1065
OPVLung disorder916
OPVPetechiae897
OPVAgitation778
OPVPulmonary oedema759
OPVPneumonia6510
PERResuscitation21
PERAcute disseminated encephalomyelitis12
PERAcute respiratory distress syndrome13
PERAutopsy14
PERBacterial infection15
PERBrain death16
PERBrain stem syndrome17
PERCardiac failure18
PERCerebral atrophy19
PERConvulsion110
PLAGUEApnoea21
PLAGUECardiac arrest22
PLAGUEStupor23
PLAGUEAnaphylactoid reaction14
PLAGUEArrhythmia15
PLAGUEAsthma16
PLAGUECardiomyopathy17
PLAGUECardiovascular disorder18
PLAGUELaryngitis19
PLAGUELung disorder110
PNCSudden infant death syndrome2531
PNCPyrexia1082
PNCAutopsy1063
PNCApnoea904
PNCCardiac arrest765
PNCComa686
PNCRespiratory arrest547
PNCUnevaluable event528
PNCMeningitis pneumococcal519
PNCVomiting5010
PNC10Autopsy41
PNC10Pyrexia42
PNC10Dyspnoea23
PNC10Epistaxis24
PNC10Pneumococcal infection25
PNC10Pneumonia26
PNC10Abdominal distension17
PNC10Acute respiratory failure18
PNC10Anuria19
PNC10Asphyxia110
PNC13Autopsy1631
PNC13Resuscitation1202
PNC13Sudden infant death syndrome993
PNC13Pyrexia854
PNC13Unresponsive to stimuli665
PNC13Cardiac arrest606
PNC13Streptococcus test positive587
PNC13Respiratory arrest578
PNC13Meningitis pneumococcal439
PNC13Vomiting4210
PPVPneumonia1111
PPVPyrexia722
PPVSepsis673
PPVDrug ineffective574
PPVDyspnoea575
PPVAutopsy496
PPVInfection417
PPVBacterial infection408
PPVCough289
PPVCardiac arrest2610
RABRabies621
RABPyrexia332
RABParalysis293
RABVaccination failure284
RABLyssavirus test positive235
RABAutopsy226
RABEncephalitis167
RABAgitation158
RABHydrophobia159
RABConfusional state1110
RUBAgitation11
RUBApnoea12
RUBAutopsy13
RUBBacterial test negative14
RUBCardiopulmonary failure15
RUBComa16
RUBConfusional state17
RUBCSF culture negative18
RUBCSF glucose normal19
RUBCSF protein increased110
RVApnoea51
RVInfection42
RVSudden infant death syndrome43
RVCardiac arrest34
RVSepsis35
RVComa26
RVCyanosis27
RVHypoxia28
RVRespiratory disorder29
RVShock210
RV1Autopsy661
RV1Sudden infant death syndrome442
RV1Pyrexia393
RV1Resuscitation314
RV1Vomiting285
RV1Cardio-respiratory arrest246
RV1Diarrhoea197
RV1Respiratory arrest188
RV1Unresponsive to stimuli149
RV1Intussusception1310
RV5Autopsy991
RV5Sudden infant death syndrome692
RV5Resuscitation563
RV5Unresponsive to stimuli564
RV5Respiratory arrest425
RV5Pyrexia416
RV5Vomiting297
RV5Cardiac arrest268
RV5Diarrhoea259
RV5Cyanosis2310
RVXAutopsy111
RVXPyrexia72
RVXCrying53
RVXDiarrhoea54
RVXSudden infant death syndrome55
RVXVomiting56
RVXInterstitial lung disease47
RVXPneumonia48
RVXResuscitation49
RVXSplenomegaly410
SMALLComa41
SMALLDyspnoea42
SMALLFatigue33
SMALLHypertrophy34
SMALLLaboratory test abnormal35
SMALLMyocardial infarction36
SMALLMyocarditis37
SMALLPain38
SMALLPyrexia39
SMALLArteriosclerosis210
TBEAutopsy21
TBEFall22
TBEAortic aneurysm13
TBEAortic dissection14
TBEBack pain15
TBEBlood follicle stimulating hormone16
TBEBrain oedema17
TBEChest pain18
TBEChest X-ray19
TBEDrowning110
TDCardiac arrest61
TDApnoea52
TDConvulsion53
TDPyrexia54
TDCoronary artery disease45
TDArrhythmia36
TDArteriosclerosis37
TDAsthenia38
TDComa39
TDNausea310
TDAPFoetal exposure during pregnancy81
TDAPPyrexia82
TDAPHeadache63
TDAPAsthenia54
TDAPAutopsy55
TDAPCardiac arrest56
TDAPDyspnoea57
TDAPIntensive care58
TDAPPain59
TDAPResuscitation510
TDAPIPVBordetella test positive21
TDAPIPVFoetal exposure during pregnancy22
TDAPIPVPertussis23
TDAPIPVDeath neonatal14
TDAPIPVExposure during pregnancy15
TTOXRabies51
TTOXPyrexia42
TTOXAutonomic nervous system imbalance33
TTOXEncephalitis34
TTOXHeadache35
TTOXIntensive care36
TTOXMuscle spasms37
TTOXSalivary hypersecretion38
TTOXAgitation29
TTOXComa210
TYPCardiac arrest41
TYPPyrexia42
TYPAbdominal pain33
TYPBlood creatinine increased34
TYPCardiovascular disorder35
TYPChills36
TYPDyspnoea37
TYPShock38
TYPActivated partial thromboplastin time prolonged29
TYPApnoea210
UNKPyrexia121
UNKPneumonia92
UNKSudden infant death syndrome83
UNKDyspnoea74
UNKApnoea65
UNKCrying66
UNKBronchitis57
UNKCardiac arrest58
UNKDiarrhoea59
UNKInfluenza510
VARCELPyrexia371
VARCELAutopsy302
VARCELVomiting223
VARCELPneumonia174
VARCELInfection155
VARCELCardiac arrest146
VARCELSepsis137
VARCELApnoea108
VARCELSudden infant death syndrome109
VARCELConvulsion910
VARZOSHerpes zoster431
VARZOSPain132
VARZOSDyspnoea123
VARZOSIntensive care124
VARZOSRash115
VARZOSBlister96
VARZOSCardiac arrest97
VARZOSMyocardial infarction98
VARZOSRash vesicular99
VARZOSAsthenia810
YFPyrexia161
YFYellow fever vaccine-associated viscerotropic disease82
YFDyspnoea73
YFPolymerase chain reaction74
YFBlood immunoglobulin E65
YFBlood immunoglobulin M66
YFHeadache67
YFMalaise68
YFAbdominal pain59
YFBlood immunoglobulin G510
    
Total 16579 
Rows 774

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:

SymptomSum_Symp_count
Sudden infant death syndrome3616
Pyrexia1879
Autopsy1322
Cardiac arrest1241
Apnoea1209
Unevaluable event830
Vomiting536
Pneumonia431
Resuscitation368
Pulmonary oedema309
Dyspnoea268
Cyanosis265
Respiratory arrest259
Lung disorder251
Coma249
Petechiae248
Unresponsive to stimuli230
Agitation186
Infection181
Malaise150
Cough141
Influenza125
Irritability121
Asthenia119
Myocardial infarction96
Meningitis pneumococcal94
Sepsis83
Vaccination failure75
Headache74
Diarrhoea70
Sudden death68
Rabies67
Convulsion65
Streptococcus test positive58
Cardio-respiratory arrest57
Drug ineffective57
Encephalitis57
Haemorrhage47
Guillain-Barre syndrome45
Herpes zoster43
Thrombosis43
Bacterial infection41
Intensive care38
Crying37
Paralysis33
Fatigue27
Stupor26
Lyssavirus test positive23
Syncope23
Pain21
Completed suicide18
Asphyxia17
Neisseria test positive17
Respiratory rate increased17
Hydrophobia15
Intussusception15
Rash14
Dizziness13
Meningococcal infection13
Confusional state12
Foetal exposure during pregnancy12
Hypotonia11
Nasal congestion11
Abdominal pain10
Arrhythmia10
Cardiovascular disorder10
Meningitis10
Blister9
Bovine tuberculosis9
Rash vesicular9
Anaemia8
Blood immunoglobulin M8
Lymphadenopathy8
Yellow fever vaccine-associated viscerotropic disease8
Arteriosclerosis7
Blood immunoglobulin G7
Endotracheal intubation7
Interstitial lung disease7
Laboratory test abnormal7
Polymerase chain reaction7
Blood immunoglobulin E6
Bronchitis6
Bronchopneumonia6
Colitis6
Enteritis6
Feeling cold6
Influenza like illness6
Meningitis meningococcal6
Meningococcal sepsis6
Poor quality drug administered6
Septic shock6
Toxic shock syndrome6
Vaccination complication6
Abdominal pain upper5
Acute disseminated encephalomyelitis5
Arthralgia5
Back pain5
Blood culture positive5
Brain oedema5
Cervix carcinoma5
Haemoglobin decreased5
Pallor5
Respiratory failure5
Shock5
Adverse event4
Condition aggravated4
Coronary artery disease4
Fall4
Hyperpyrexia4
Splenomegaly4
Activities of daily living impaired3
Asthma3
Autonomic nervous system imbalance3
Blood creatinine increased3
Blood test3
Bradycardia3
Chills3
Cognitive disorder3
Death neonatal3
Disability3
Hepatitis A3
Hypertrophy3
Loss of consciousness3
Muscle spasms3
Myocarditis3
Nasopharyngitis3
Nausea3
Salivary hypersecretion3
Viral infection3
Abdominal distension2
Acidosis2
Activated partial thromboplastin time prolonged2
Acute respiratory failure2
Antinuclear antibody negative2
Bacterial test negative2
Body temperature increased2
Bordetella test positive2
Cardiac failure2
Cardiomegaly2
Chemotherapy2
Chest pain2
Chest X-ray abnormal2
Computerised tomogram abnormal2
CSF culture negative2
Epistaxis2
General physical health deterioration2
Grunting2
Hypoxia2
Mental status changes2
Multiple sclerosis2
Pertussis2
Pneumococcal infection2
Respiratory disorder2
Restlessness2
Seizure2
Toxicologic test2
Toxicologic test normal2
Abnormal sleep-related event1
Acute respiratory distress syndrome1
Adenovirus test positive1
Alanine aminotransferase increased1
Alpha 1 foetoprotein normal1
Anaphylactoid reaction1
Anuria1
Aortic aneurysm1
Aortic dissection1
Apgar score abnormal1
Aspartate aminotransferase increased1
Aspiration1
Aspiration bronchial1
Atelectasis1
Autoantibody negative1
Biopsy heart normal1
Blood alkaline phosphatase increased1
Blood alkaline phosphatase normal1
Blood culture negative1
Blood follicle stimulating hormone1
Blood glucose normal1
Bloody airway discharge1
Body temperature1
Brain death1
Brain herniation1
Brain injury1
Brain stem syndrome1
Caesarean section1
Cardiac failure congestive1
Cardiac output1
Cardiomyopathy1
Cardiopulmonary failure1
Cellulitis1
Cerebellar haemorrhage1
Cerebellar infarction1
Cerebral atrophy1
Cerebral disorder1
Cerebral haemorrhage1
Cerebral ischaemia1
Cerebrovascular disorder1
Chest X-ray1
Cold agglutinins negative1
Computerised tomogram head abnormal1
Computerised tomogram normal1
Congenital cystic kidney disease1
Conjunctivitis1
Contusion1
Croup infectious1
CSF glucose normal1
CSF lymphocyte count increased1
CSF protein increased1
CSF test1
CSF test abnormal1
Culture urine negative1
Decreased appetite1
Diffuse alveolar damage1
Drowning1
Drug screen negative1
Electrocardiogram abnormal1
Electroencephalogram abnormal1
Encephalitis viral1
Encephalopathy1
Exposure during pregnancy1
Febrile convulsion1
Gait inability1
Gastrooesophageal reflux disease1
Haematemesis1
Hepatic steatosis1
Hepatitis1
Histology1
Hospice care1
Hyporesponsive to stimuli1
Inappropriate schedule of drug administration1
Influenza A virus test negative1
Influenza B virus test1
Laryngitis1
Muscular weakness1
Oligohydramnios1
Premature baby1
Speech disorder1
Viral myocarditis1
  
Total16579
Rows238

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.

Leave a Reply

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