Dataset Open Access

Drug Indications Extracted from FAERS

Stupp, Gregory S; Su, Andrew I

This dataset contains drug indications extracted from the FDA Adverse Event Reporting System (FAERS).

Source code here:

Method Outline

  • Data files are extracted from zip files, parsed from csvs, and imported into a MySQL database (see
  • Duplicate records are then de-duplicated by taking only the most recent version for each case ID (see
  • Indications are normalized by matching to UMLS terms by string matching. Cross-references to Human Phenotype Ontology are pulled from UMLS and xrefs to Monarch Disease Ontology (MONDO) are pulled from MONDO using the UMLS xrefs. (See
  • Drugs names are normalized first by applying a few simple string cleaning operations (strip, fix slashes and periods). Then they are attempted to be matched to rxnorm by exact string matching. Those that don't match are run against rxnorm's approximate matching service, and are accepted if the score is higher than 67/100. The matched rxnorm CUIs are then mapped to the their Ingredient level rxnorm ID. (See
  • Indications are then retrieved for each drug ingredient and filtered to require a minimum of 20 individual occurances. (See
Files (242.3 kB)
Name Size
242.3 kB Download
All versions This version
Views 2,5152,515
Downloads 411411
Data volume 99.6 MB99.6 MB
Unique views 2,3662,366
Unique downloads 385385


Cite as