SQL to Create Normalized Table AD_2019_ALL_VAX_NORM
SQL Scripts to create the
View: V_AD_2019_ALL_VAX_NORM
and
Normalized Table: AD_2019_ALL_VAX_NORM
More anomalies with the fields: Vax_date and Onset_Date. Year incorrect.
Naming Conventions For Newly Created Database Objects. Views, Tables, etc
Exploring some of the anomalies with the fields AGE_YRS and NUMDAYS. In some rows, NUMDAYS converted to years, would actually be larger than the person’s age in years (AGE_YRS).
Official VAERS documentation, the VAERS Data User Guide
How to load the 2018 VAERS CSV Datasets into SQL Server
How to load the 2019 VAERS MDB Access file into SQL Server
How to load the 2019 VAERS CSV files into SQL Server