Statistics: Reactions By NUMDAYS

VAERS Exploratory Analysis.
NUMDAYS til reaction.
Statistics on the Number of Days after a vaccination, that a reaction occurs.


First, please see analysis of data anomalies:

Field Analysis of NUMDAYS

Field Analysis Of AGE_YRS and NUMDAYS

More Anomalies With Vax_Date And Onset_Date

And some associated views to remove some data anomalies:

View V_AD_NUM_YRS_GT_AGE_YRS

View V_AD_VAX_ONSET_DT_EXACT_YEAR_MULTIPLE

Note: Even using these two views, there are still a lot of data anomalies and data entry errors. It’s not perfectly clean data. For instance:

—-

VAERS_ID: 819826
Vax_date: 1941-09-05
Onset_date: 2019-06-18
Numdays: 28,410

Symptom_text:
Swollen injection site Sore \” \” itching red bumbs over body

Comment:

Vax_Date could be birth date (78 years old).

Or, the VAX_Date could have actually been 2018-09-05 and the ONSET_DATE 2019-06-18, about 9 months later.

But, from the Symptom_Text, you would think that the NUMDAYS til reaction was quite soon after the vaccination.

What is correct?

Another clerical/data entry error.

—-

 


use VAERS_2019
go

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


—–

Reactions by NUMDAYSCountPercent WeightRunning Total
0277,26147.3165147.31651
1134,00822.8693970.18590
244,2147.5454277.73132
317,4532.9784880.70980
410,0351.7125482.42234
57,9011.3483683.77070
66,6931.1422184.91291
79,4011.6043586.51725
86,2061.0591087.57635
95,7330.9783888.55472
106,0921.0396489.59437
113,9540.6747890.26914
123,0980.5287090.79784
132,6560.4532691.25110
143,6430.6217091.87281
151,9710.3363692.20917
161,5960.2723792.48154
171,4200.2423392.72387
181,2900.2201592.94402
191,1820.2017293.14574
201,2170.2076993.35343
211,3060.2228893.57630
228490.1448993.72119
237270.1240793.84526
247230.1233893.96864
256500.1109394.07957
265870.1001894.17975
276310.1076894.28743
286970.1189594.40638
295610.0957494.50212
308770.1496794.65178
311,2170.2076994.85947
324900.0836294.94309
334070.0694695.01255
344320.0737295.08628
354010.0684395.15471
363440.0587195.21341
372840.0484795.26188
382870.0489895.31086
392970.0506995.36155
402730.0465995.40813
412870.0489895.45711
423860.0658795.52299
432300.0392595.56224
442460.0419895.60422
452250.0384095.64262
461980.0337995.67641
472100.0358495.71225
482020.0344795.74672
492450.0418195.78853
501910.0326095.82112
511900.0324295.85355
521570.0267995.88034
532020.0344795.91481
541740.0296995.94451
551640.0279995.97250
561830.0312396.00373
571570.0267996.03052
581440.0245796.05509
592000.0341396.08923
601560.0266296.11585
614700.0802196.19606
622660.0453996.24145
631890.0322596.27371
641510.0257796.29948
651420.0242396.32371
661590.0271396.35084
671010.0172496.36808
681140.0194596.38753
691260.0215096.40904
701490.0254396.43447
711210.0206596.45511
721040.0177596.47286
731030.0175896.49044
741050.0179296.50836
751130.0192896.52764
761070.0182696.54590
771160.0198096.56570
78880.0150296.58072
79860.0146896.59539
80770.0131496.60854
811000.0170796.62560
82940.0160496.64164
83900.0153696.65700
841160.0198096.67680
85890.0151996.69199
86870.0148596.70683
87840.0143496.72117
88790.0134896.73465
89840.0143496.74899
901250.0213396.77032
911630.0278296.79814
923010.0513796.84950
931000.0170796.86657
94820.0139996.88056
95840.0143496.89490
96750.0128096.90770
97900.0153696.92306
98800.0136596.93671
99690.0117896.94848
100720.0122996.96077
101690.0117896.97255
102730.0124696.98500
103710.0121296.99712
104550.0093997.00651
   
6,17710.0001799.99420
6,21010.0001799.99437
6,23510.0001799.99454
6,27710.0001799.99471
6,39720.0003499.99505
6,43110.0001799.99522
6,82210.0001799.99539
6,86210.0001799.99556
6,97210.0001799.99573
7,13710.0001799.99590
7,31510.0001799.99607
7,53910.0001799.99625
7,61110.0001799.99642
7,77910.0001799.99659
7,90810.0001799.99676
7,98210.0001799.99693
8,06610.0001799.99710
8,32610.0001799.99727
8,33910.0001799.99744
8,34610.0001799.99761
8,89710.0001799.99778
8,94310.0001799.99795
9,49810.0001799.99812
9,50010.0001799.99829
9,78110.0001799.99846
9,96510.0001799.99863
10,50010.0001799.99881
11,06410.0001799.99898
13,51510.0001799.99915
14,28410.0001799.99932
16,03710.0001799.99949
16,43910.0001799.99966
23,38010.0001799.99983
28,41010.00017100.00000
    
Total585,971100 
Number of rows2,924 

—-

Statistics:

n = 585,971

Already on Day 0, 47% of all reactions have started
By Day 1, 70% of all reactions have started
By Day 3, 80% of all reactions have started
By Day 11, 90% of all reactions have started
By Day 33, 95% of all reactions have started

The remaining 5% of reactions are found in 2,891 (2924 minus 33) rows.
A very long tail. (Results edited for readability.)

The pattern is very clear. Most reactions start very soon after vaccination.

If the reaction was not caused by the vaccine, what was it caused by?

Leave a Reply

Your email address will not be published. Required fields are marked *