Disabled By NUMDAYS

Exploratory Data Analysis

For those that were DISABLEd post vaccination, how many days before they became DISABLEd?

—

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

—

Row counts With and Without the WHERE clause (DISABLE)

select 
   Count (DISABLE) CNT_DISABLE	
,  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 populated in query

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

DISABLE
= 100 * 12,725 / 17,644
– 72.1% 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.DISABLE is NOT null
group by convert ( int, v.NUMDAYS )
order by 1
go

—

Results:

—

844 rows

—

Analysis:

Of all those that were DISABLEd post vaccination;

29.4% were DISABLEd on day 0, the very same day
12.2% were DISABLEd on day 1, the next day
5.5% were DISABLEd on day 2
3.3% were DISABLEd on day 3

Between day 0 and day 1, 41.7% were DISABLEd

Between day 0 and day 3, 50.6% were DISABLEd

The remaining 50% are distributed over the remaining 841 rows. See the anomalies with NUMDAYS in the other post.

Another very long tail

—

—