Exploratory Data Analysis
Count of all Reactions, by Vaccine/VAX
How many vaccines did the patient take before any reactions?
Reactions by Vaccine Count:
use VAERS_2019 go Select convert ( int, VAX_CNT ) VAX_CNT , COUNT(*) Count FROM dbo.[VAERSDATA] group by convert ( int, VAX_CNT ) order by 1 go
—
| VAX_CNT | Count | Percent Weight | PCT Running Total |
|---|---|---|---|
| 0 | 1 | 0.00013 | 0.00013 |
| 1 | 539,513 | 71.03688 | 71.03701 |
| 2 | 104,252 | 13.72671 | 84.76371 |
| 3 | 68,147 | 8.97281 | 93.73653 |
| 4 | 37,397 | 4.92401 | 98.66054 |
| 5 | 7,963 | 1.04848 | 99.70901 |
| 6 | 1,793 | 0.23608 | 99.94509 |
| 7 | 287 | 0.03779 | 99.98288 |
| 8 | 104 | 0.01369 | 99.99658 |
| 9 | 17 | 0.00224 | 99.99881 |
| 10 | 5 | 0.00066 | 99.99947 |
| 11 | 1 | 0.00013 | 99.99960 |
| 12 | 1 | 0.00013 | 99.99974 |
| 14 | 1 | 0.00013 | 99.99987 |
| 18 | 1 | 0.00013 | 100.00000 |
| Total | 759,483 | 100 |
—
Anomalies:
There is one odd row listing zero vaccines.
VAERS_ID: 133652
AGE_YRS: 69.0
SEX: M
RPT_DATE: 2000-01-01
SYM_CNT: 2
SYM01: Myelitis
SYM02: Paralysis
DIED: NULL
HOSPITAL: Y
VAX_CNT: 0
VAX1: NULL
PRIOR_VAX: ~ ()~~~In patient
SYMPTOM_TEXT:
Developed paralysis and subsequently hospitalized. Diagnosed with transverse meylitis.
Comment:
Looks like another data entry/clerical error
—————
Statistics:
Of all the entries in the VAERS database:
71% of all reactions occurred after only 1 vaccine
84.7% of all reactions occurred after 2 vaccines or less
93.7% of all reactions occurred after 3 vaccines or less
98.7% of all reactions occurred after 4 vaccines or less