Exploratory data analysis.
More anomalies with the fields: Vax_date and Onset_Date
Another pattern in the VAERS database is that there are many rows with clerical data errors where
Between Vax_date and Onset_Date:
YEAR is different
Month is the same
Day is different
When, both years should have actually been the same.
And, the Onset_Date should have been within a few days of Vax_Date.
Some examples:
—-
VAERS_ID: 32486
Vax_date: 1990-01-16
Onset_Date: 1991-01-30
NUMDAYS: 379
Symptom_text:
16JAN91 pt vax w/ hepta B; exp trigeminal paresthesia left cheek roof of mouth. Recv CAT scan & MRI.
Comment:
Symptom_text lists 16JAN91 as vaccination date
But, Vax_date listed as: 1990-01-16
Vax_date should be: 1991-01-16
Data entry/Clerical error
——
VAERS_ID: 741671
AGE_YRS: 24
Vax_date: 2017-03-16
Onset_date: 2018-03-19
Symptom_text:
Patient experienced intense pain and swelling in the area 3 days after the injection. She also reported itching.
Comment:
Symptom_text says 3 days.
Vax_date should be: 2018-03-16
Data entry/Clerical error
—-
VAERS_ID: 813186
AGE_YRS: 74
Vax_date: 1944-05-07
Onset_Date: 2019-05-08
NUMDAYS: 27394
NUM_YRS: 75.0520547945205
Symptom_text:
Patient called store later and complained of severe sore shoulder with intense pain
Comment:
“Later” most probably does not mean 75 years later.
Vax_date should be: 2019-05-07
Data entry/Clerical error
—
VAERS_ID: 829207
Vax_date: 2018-07-17
Onset_Date: 2019-07-21
Symptom_Text:
on July 17th of 2018 patient was given her routine shots. a week after recieving the vaccines patient became very ill with a really bad stomach virus called gastroenteritis.gastroenteritis ended up turning into intussusception virus. Patient was diagnosed with sepsis, and organ failure.
Comment:
Symptom_Text: a week
Onset_Date should be: 2018-07-21
Data entry/Clerical error
—-
VAERS_ID: 845741
AGE_YRS: 1
Vax_date: 2017-10-05
Onset_Date: 2019-10-31
Symptom_Text:
Pt presented to office on 10/31/19 with Zoster Rash on same arm as receiving Varivax Immunization.
Comment:
Patient only one year old,
Vax_date should be: 2019-10-05
Data entry/Clerical error
——
VAERS_ID: 847502
Vax_date: 2012-09-21
Onset_Date: 2019-09-22
Symptom_Text:
Ran a fever the following night + sore muscles + bones (felt like a case of the flu) for 1 1/2 days. Still – after 2 1/2 months – having tingling on the left arm. Feels like \”ants crawling\” + the blood running up + down the veins in left arm. At night,the feeling of a \”rolling pin\” moving up + down the arm awoken me. The vein in the elbow is raised when the tingling occurs. The \”sensation\” happens multiple times each day, sometimes 2 or 3 times in an hour. From 8/21 to 11/6 Still feeling tingling s
Comment:
Symptom_Text: Ran a fever the following night
Vax_date should be: 2019-09-21
Data entry/Clerical error
—-
Note:
There are cases with this pattern where the year is different, and the data is accurate. See VAERS_ID 589421.
—-
To find the rows:
use VAERS_2019 go select VAERS_ID , convert (float, AGE_YRS) AS AGE_YRS , Vax_date , Onset_Date , convert (int, numdays ) NUMDAYS , ( convert ( float, NUMDAYS ) / 365.0 ) as NUM_YRS , year ( Onset_Date ) - year ( Vax_date ) as YRS_DIFF , concat (Symptom_Text, Symptom_Text2 ) Symptom_Text from dbo.[VAERSDATA] where year ( Vax_date ) <> year ( Onset_Date ) and month ( Vax_date ) = month( Onset_Date ) and day ( Vax_date ) <> day ( Onset_Date ) go
2025 rows returned