Exploratory data analysis. VAERS data. Count of Reactions by Year.
All years, from 1990 til early 2020.
—
use vaers_2019; go select year (s_date) year , count(*) cnt_reactions from dbo.[vaersdata] group by year (s_date) order by 1; go
—
| Year | Cnt_Reactions |
|---|---|
| 1990 | 2,151 |
| 1991 | 9,992 |
| 1992 | 10,817 |
| 1993 | 10,309 |
| 1994 | 10,354 |
| 1995 | 10,273 |
| 1996 | 11,189 |
| 1997 | 11,608 |
| 1998 | 10,782 |
| 1999 | 12,878 |
| 2000 | 15,114 |
| 2001 | 14,633 |
| 2002 | 15,332 |
| 2003 | 18,084 |
| 2004 | 16,510 |
| 2005 | 17,447 |
| 2006 | 19,330 |
| 2007 | 30,813 |
| 2008 | 33,443 |
| 2009 | 37,042 |
| 2010 | 36,580 |
| 2011 | 31,129 |
| 2012 | 32,114 |
| 2013 | 36,270 |
| 2014 | 41,243 |
| 2015 | 51,972 |
| 2016 | 53,727 |
| 2017 | 46,344 |
| 2018 | 53,761 |
| 2019 | 430 |
—-
Analysis:
The reaction count has been been on a clear overall upward trend.
1991: 9,992
2019: 53,846 (over 5 times that of 1991)
Aggregate statistics are done in a spreadsheet.