Create table AD_2019_AGE_YRS_ROUND
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.
Code to create the view V_AD_VAX_ONSET_DT_EXACT_YEAR_MULTIPLE
Naming Conventions For Newly Created Database Objects. Views, Tables, etc
Code to create the view: V_AD_NUM_YRS_GT_AGE_YRS
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).
Anomalies of the field: VAERSDATA.NUMDAYS
Official VAERS documentation, the VAERS Data User Guide