Disabled By VAX Code – Weighted

Exploratory Data Analysis

Of those who became DISABLEd post vaccination, which vaccines were given, weighted by the number of reactions for each vaccine?

Field Analysis:

Because the average number of vaccines given per VAERS_ID is not one, but greater than one, the resulting total numbers for DISABLEd and Reactions are larger than found in the single table VAERSDATA.

For details, see the field analysis in:
Disabled By VAX Code

Also
Normalized Table AD_2019_ALL_VAX_NORM

—

Query:

SELECT vax.VAX
, count ( DISABLE )  Count_Disabled
, Count(*) Count_Reactions
, 100 * count ( DISABLE )  / Count(*) 
   as PCT_Disabled_Per_Reactions
From dbo.[VAERSDATA]  v
JOIN   dbo.[AD_2019_ALL_VAX_NORM] vax
   on   V.VAERS_ID = VAX.VAERS_ID
Group by vax.VAX
order by 4 desc

—

Results 1:

Results are ranked in descending order, according the largest percentage of Disabled, given the number of Reactions.
Only the 21 rows with 5% or more.

—

—

Results 2:

Results are ranked in descending order, according to the number of Reactions.

Results are separated into 3 groups:
Reaction count of 10k or more (Large set)
Reaction count from 1k to 10k (Mid size set)
Reaction count less than 1k (Small set)

—

—

Summary Statistics:

—

—

—

Analysis:

—

Disabled: n=24,847
Reaction Count: n=1,155,341

Of the 92 VAX codes, 88 reported at least one DISABLEd post vaccination.

Of the four vaccines that did not report any DISABLEd, each one had less than 11 reactions in the entire database.

—

Analysis of Results 1:

DPIPV had the worst DISABLE per Reaction ratio: 50%. Although, this is a very small sample size of only 2 reactions, and 1 Disabled. Seems this vaccine was only used for a very short time.

Six vaccines report a disabled rate of 10% or more.
DPIPV, LYME, HPVX, MM, ADEN_4_7, PLAGUE

21 vaccines report a disabled rate of 5% or more. Most are small sample sizes. Of the 21 vaccines, only 4 vaccines have a Reaction count of 1000 or more: LYME, HPVX, HPV2, HEPAB.

—

Analysis of Results 2:

Large group Summary Statistics:

—

—

Large group standard deviation is smaller than the mean.

Still, the difference between Min (.76%) and Max (4.96%) is in multiples. The max value is 6.5 times larger than the min value. Lots of variability.

—

Mid size group Summary Statistics:

—

—

Standard deviation is slightly larger than the mean.
Higher values for the Mean and Median than the large group.

—

Small group Summary Statistics:

—

—

Standard deviation is 1.33 times larger than the mean, even with the four vaccines with zero Disabled.

Higher values for the Mean and Median than the mid size group.

—

Notes:

Between vaccines, there is huge variability in the Percent Disabled by the number of Reactions.

This would imply that some vaccines result in more Disabled than others.

The smallest group has the highest percent of disabled per reactions. This might suggest that perhaps some vaccines have been discontinued for safety reasons.

If anyone knows the history of any vaccines in the small group, please leave a comment.

—