This web application permits you to process a query on the FDA Adverse Event Reporting System (AERS) pharmacovigilance data. Click here for a tutorial on how to use it. Further information/specifications can be found in the documentation. Limitations can be found in the OpenVigil Cave-At document. Press to display more information about the database structure and content.
This installation uses data from
2003-10-06 to 2013-12-31 (according to DEMO.FDA_DT).
Registered tables are:
DEMO with columns ISR CASENO I_F_COD FOLL_SEQ IMAGE EVENT_DT MFR_DT FDA_DT REPT_COD MFR_NUM MFR_SNDR AGE AGE_COD GNDR_COD E_SUB WT WT_COD REPT_DT OCCP_COD DEATH_DT TO_MFR CONFIG REPORTER_COUNTRY DSRC containing 5337037 records.
DMAP with columns ISR DRUG BRAND EXTRA DOSE ROUTE containing 0 records.
DRUG with columns ISR DRUG_SEQ ROLE_COD DRUGNAME VAL_VBM ROUTE DOSE_VBM DECHAL RECHAL LOT_NUM EXP_DT NDA_NUM DSRC containing 19388354 records.
DSRC with columns FNAME DT NERR_PARSER NERR_SQL TERR_PARSER TERR_SQL containing 281 records.
INDI with columns ISR DRUG_SEQ INDI_PT DSRC containing 9441806 records.
OUTC with columns ISR OUTC_CODE DSRC containing 4810836 records.
REAC with columns ISR PT DSRC containing 19239224 records.
RPSR with columns ISR RPSR_COD DSRC containing 1992810 records.
THER with columns ISR DRUG_SEQ START_DT END_DT DUR DUR_COD DSRC containing 7835655 records.
For advanced users: a description of the content of tables and columns in these tables can be found in chapters B. FILE DESCRIPTIONS, C. DATA ELEMENT DESCRIPTIONS, D. DATA ELEMENT CONTENTS AND MAXIMUM LENGTHS of the FDA Asc_nts.doc database description document (created by the FDA and can also be found in the archive of the original data). Note that DEMO.CASE is called DEMO.CASENO in our database. Import failures from the original FDA data into this database can be found in the data import table from aers2sql for this instance of OpenVigil. Pitfalls and shortcomings of pharmacovigilance data analyses are described in the OpenVigil Cave-At document.