Dataset: Obtained from FDA AERS

I would like to map the drug names to its generic name.

Example: Arthritis Pain, Aspir 81, Aspir-Low, Bayer Childrens Aspirin etc would be mapped to aspirin

Is there a dataset where such mappings are available(preferably in CSV format) so that it is possible to iterate through the FDA AERS dataset and replace the drug name with their generics.

  • Here are all the generic names to start with. I don't know OpenFDA, but maybe you can go from there in the other direction, i.e. querying for brand names associated with generic names.
    – user4293
    Aug 12, 2019 at 7:21
  • Or try going from here. BTW Did you search the site before posting your question?
    – user4293
    Aug 12, 2019 at 7:26
  • @JanDoggen Yes, I went through them, but I wanted to know if someone in the community knew of the availability of such database.
    – Jerry
    Aug 12, 2019 at 14:57

1 Answer 1


We at openFDA are unaware of such dataset, but you could probably compile such mappings by a) downloading openFDA FAERS JSON files, b) writing a quick tool that goes over the records and puts the mappings together.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.