Deaths By NUMDAYS

Exploratory Data Analysis

Of those that DIED post vaccination, how many days before they DIED?

Field Analysis:

In the two fields (VAX_DATE and ONSET_DATE) used to calculate NUMDAYS, there is a lot of anomalies in the data.

First see the links in

Statistics: Reactions By NUMDAYS

This query is the same, the only difference being the rows are filtered by DIED IS NOT NULL.

use VAERS_2019
go

Select count(*) Count
from dbo.[VAERSDATA]
where DIED is NOT NULL

Count: 8,150

Row Counts of DIED and NUMDAYS:

select
Count (DIED) CNT_DIED
, Count (NUMDAYS) CNT_NUMDAYS
, Count (*) Count
from dbo.[VAERSDATA]
where NUMDAYS is NOT NULL

—

Row Counts Without the WHERE clause

—

Row Counts With the WHERE clause

—

Percent NUMDAYS NOT NULL
= 100 * 593,718/ 759,483
= 78.1% populated

Percent DIED NOT NULL Where NUMDAYS IS NOT NULL
= 100 * 5,259 / 8,150
= 64.5% populated

—

Query:

Select convert ( int, v.NUMDAYS ) as NUMDAYS
, count(*) Count
from dbo.[VAERSDATA] v
left outer join dbo.[V_AD_NUM_YRS_GT_AGE_YRS] ny
on v.vaers_id = ny.vaers_id
left outer join dbo.[V_AD_VAX_ONSET_DT_EXACT_YEAR_MULTIPLE] ym
on v.vaers_id = ym.vaers_id
where v.numdays is not null
and NY.VAERS_ID is null
and ym.VAERS_ID is null
and v.DIED is NOT null
group by convert ( int, v.NUMDAYS )
order by 1
go

—

Results:

298 rows

—

Analysis:

Of all those that DIED post vaccination,

18.4% DIED on day 0, the very same day
22.6% DIED on day 1, the next day
10.1% DIED on day 2
7% DIED on day 3

Of all those that DIED post vaccination, cumulatively,

Between day 0 and day 1, 41.1% DIED
Between day 0 and day 2, 51.3% DIED
Between day 0 and day 4, 66.1% DIED
Between day 0 and day 9, 75.3% DIED

The remaining 24.7% of deaths were distributed in the remaining 290 rows. Another long tail.

—