3

The openFDA drug enforcement reports API download returns results in one large JSON file.

Unfortunately I have no experience in parsing/programming JSON and I need the drug enforcements data in Excel/CSV format (2004-present as far as I know).

Can anyone help please?

  • What data are you talking about? Please provide a link. – FuzzyLeapfrog Mar 13 '17 at 21:56
  • Thanks a lot for your answer! I really appreciate. I want to get these data on drug enforcments: open.fda.gov/drug/enforcement/reference – Arusyak Zakaryan Mar 14 '17 at 9:31
  • 1
    I have edited your question to exactly describe the issue. Please take some time next time to do the same. – user4293 Mar 14 '17 at 13:01
3

Download the JSON file and open it with a Json to CSV converter like http://www.convertcsv.com/json-to-csv.htm

You will get this file.

  • Thank you very much. My problem is that the JSTON file that is downloadable contains only 2012-2017 records. However OpenFDA says that "The openFDA drug enforcement reports API returns data from the FDA Recall Enterprise System (RES)... Currently, this data covers publically releasable records from 2004-present". And I am not able to run openFDA API queries to retrieve the data starting from 2004. Thanks again for help. – Arusyak Zakaryan Mar 14 '17 at 13:50
  • Their database does not allow you to go back before 2012, and their APIs neither. You may want to check if someone has this data or ask the US Food & Drug Administration directly. – Ettore Rizza Mar 14 '17 at 14:32
  • I see. I will probably make a Freedom of Information Act (FOIA) request. Thanks for help. fda.gov/RegulatoryInformation/FOI/HowtoMakeaFOIARequest/… – Arusyak Zakaryan Mar 14 '17 at 14:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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