Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [openfda]

Questions and answers surrounding the U.S. Food and Drug Administration's OpenFDA program.

9
votes
3answers
2k views

Query medicine descriptions API

I am looking for publicly available API for querying medicine's descriptions. For example, if I supply Carbidopa/Levodopa or Sinemet the expected return data (in json or xml format) is a simple ...
7
votes
2answers
970 views

How to get all the DrugList

I want to fetch all the drugList, lets say -> DrugName, Manufacturer, Prescribed for, Description. I tried using https://api.fda.gov/drug/event.json?count=patient.drug.openfda.manufacturer_name.exact ...
7
votes
1answer
108 views

Missing medical device recall information? OpenFDA not finding recalls from FDA database

To ensure I was understanding how openFDA works, I have been checking my queries against the searchable medical device recall database the FDA already has (http://www.accessdata.fda.gov/scripts/cdrh/...
6
votes
3answers
7k views

List of United States cities

I'm looking to get some data of this page http://www.greatschools.org/california/san-francisco/schools/?gradeLevels=e&page=2 To do it I need to create the links in this format: http://www....
6
votes
4answers
809 views

Disease and Symptoms Hierarchy

I have a huge list of symptoms (1 million rows+ ). I would like to reduce the data by grouping the symptoms. For example, lower abdominal pain and upper abdominal pain into "abdominal pain" category. ...
6
votes
1answer
203 views

Searching by disease through openFDA API

I'm trying to query for all drugs related to a certain disease group (say, for example testicular cancer). How would I structure that query? is this possible?
6
votes
2answers
235 views

openFDA: Can we print results for multiple patients at once?

Is there any way to get multiple patients' results in one output? I've noticed it defaults to show one patient's results at a time - and skipping allows you to see other patients - but is there any ...
6
votes
1answer
151 views

Search for deaths by a specific drug

I am not a programmer, so I am trying to understand the search methods to use when looking at OpenFDA. I am currently using the generic form for Reported Reactions. How do you get more the 10 adverse ...
6
votes
2answers
241 views

Wildcard searches

First time to use the OpenFDA API's. Very nice work! It seems like wildcards are not permitted in queries, so I was curious how one might go about generating data such as count of specific AEs by ...
6
votes
1answer
108 views

How can I access FDA drug and medical device recall data from 1970 to 2014?

The FDA only provides drug and medical device recall data since 2002. As a journalist seeking a more comprehensive data set, I really need to have access to this information.
6
votes
1answer
62 views

Plans and documentation to tidy RAW data in Maude?

MAUDE is the Manufacturer and User Facility Device Experience database from the FDA. The MAUDE database houses medical device reports submitted to the FDA by mandatory reporters 1 (manufacturers, ...
6
votes
1answer
97 views

Is there a way to get a drug's experimental name on open FDA?

This query can return the product label for the drug Cetuximab: https://api.fda.gov/drug/label.json?search=set_id:8bc6397e-4bd8-4d37-a007-a327e4da34d9 But can we link it to its former name when it ...
5
votes
5answers
704 views

Now I have an API key, how do I access OpenFDA?

The link I am told to use, https://api.fda.gov, redirects me to http://api.data.gov, which does NOT have an FDA option! In any case, that site has no place to enter the API key I got on the OpenFDA ...
5
votes
3answers
152 views

OpenFDA: Why is the database updated infrequently, given that recall notices are pretty time sensitive . . . and when is it likely to get improved?

For instance, last update to their database was on 01. of May. But on other pages I could find two reports that were published in May. So the newest report from their api that I could get is from ...
5
votes
2answers
76 views

Getting updated date for all the endpoints through an API

I am trying to build a code that download all files from the provided end points. However, I do not want to download the files everytime and will only download the files if the data in the endpoints ...
5
votes
1answer
4k views

Where can I find sales figures on pharmaceutical drugs listed by manufacturer?

I have some set of data from openFDA that looks like: Nausea reports concomitant w/ Fluoxetine, by manufacturer. +--------------+-------------------+ | Manufacturer | Number of reports | +------------...
5
votes
1answer
136 views

Is there any open data FDA, or other, regarding U.S. Pharmacopoeia standards?

In purchasing drugs and supplements, I've noticed that certain products are advertised as Pharmaceutical Grade. Wanting to know what qualifies a substance as pharmaceutical grade I did some googling ...
5
votes
1answer
103 views

Multiple attributes available in a single OpenFDA query

Can I pull a single query that counts & breaks down adverse events reported for multiple attributes such as by year and by drug and by manufacturer? I've had success pulling counts by individual (...
4
votes
3answers
146 views

Big Data Neophyte Trying To Work With FDA Data — Any kind souls out there willing to help?

Question #1 -- We are trying the get the data currently in table form out of this online database and into a spreadsheet. The end game is a postal mailing list/sales contact list. So we're looking ...
4
votes
3answers
509 views

Data In CSV Format from OpenFDA

I read about data availability on http://open.fda.gov/ Now i want to download data in structured row-column format but all that i am getting is modifying my search query in order to retrieve ...
4
votes
2answers
1k views

I get 'certificate verify failed' URLError when trying to download data from openFDA

I'm using Python and pandas to try to download the data in the FDA's 'Adverse drug event reports since 2004'. Here is my code: import pandas as pd import json from pandas.io.json import ...
4
votes
2answers
62 views

Is there an easy way to access medical device approvals beyond recently-approved devices?

Is there an easy way to access medical device approvals? (Including being able to sort the approvals by manufacturer?) Currently you are able to view "recently-approved devices." Hoping to be able to ...
4
votes
1answer
62 views

seriousnesscongenitalanomaly in openFDA Adverse Events

I'm dipping my toes into the openFDA dataset and want to do some searches related to congenital anomalies. I know this data is searchable because the folks at Social Health Insights have built a ...
4
votes
1answer
130 views

OpenFDA API for drug Label changes

Is there is any API for getting the label changes for a list of drugs. I have been searching for APIs and RSS feeds with no luck.
4
votes
2answers
127 views

Determining a drug's approval status from ClinicalTrials.Gov/chEMBL

I am trying to query these databases and identify trials that passed, and those that didn't. I have gone through and parsed all of ClinicalTrials.gov and matched it to records from chEMBL to build a ...
4
votes
1answer
398 views

OpenFDA API - how to query on drug name with more than one word

Try running this query: https://api.fda.gov/drug/label.json?&search=brand_name:tylenol+number+three I've also tried the %20 instead of '+' and it didn't work either. I'm trying to pull up the ...
4
votes
1answer
91 views

openFDA API - ingredient and product name queries give bad results - is it me?

Try running this query: https://api.fda.gov/drug/label.json?&search=generic_name=hydrocodone - returns Oxycontin, not Norco or other hydrocodone containing drugs https://api.fda.gov/drug/label....
4
votes
1answer
746 views

API for getting data from a disease name?

For example, entering: "lung Adenocarcinoma" should return (JSON preferably) large chunks of information about that disease, such as definition, alternate names, validity, treatments, signs, etc.. I'...
4
votes
1answer
492 views

Determining if drug is generic or brand using NDC

Is there a way to determine if a drug is generic or brand by passing in an NDC (National Drug Code) to the drug label endpoint (https://api.fda.gov/drug/label)?
4
votes
1answer
121 views

openFDA endpoints not updated in over 2 months. Has this project been abandoned?

We are specifically interested in the "Devices › Adverse Events" data which until recently seemed to get updated monthly, usually within 2 weeks of the end of the month. We realize that this is a ...
4
votes
1answer
49 views

Adverse Events for Avastin - vision issues

I need a list of the adverse events for Avastin drug. I mainly would like to see a list of adverse events concerning vision issues. Thank you.
4
votes
2answers
164 views

open.fda.gov JSON search terms

I am interested in finding a list of valid search terms for the JSON query tool. The query syntax examples are clear, but knowing what terms to use with the syntax remains a mystery. Is there a ...
4
votes
1answer
219 views

OpenFDA API : can we count on several fields?

Is it possible to get counts nested by 2 fields ? For example adverse events by patient sex and reaction type. The result would be something like a 2 dim array. edit (since this account doesn't have ...
4
votes
1answer
59 views

OpenFDA Bad Zip File?

I have been working to build a download and unzipping "pipeline" going (as a noob) with OpenFDA data, and I saw with interest @h.das' closed post about zips - "Python crashing when trying to read ...
4
votes
2answers
75 views

Is it possible to get a complete list of medical devices through OpenFDA?

I was trying to get a complete list of medical devices through openFDA, but then I came to realize that through that data set the list can never be complete, since I can only get devices involved in a ...
4
votes
0answers
124 views

Is there an API for drug approval packages from the FDA?

I am building an application where we'd like to reuse information from drug approval packages (Example). The FDA API does not have a query interface for drug approval packages. Is there an ...
3
votes
3answers
104 views

Seriousness values on OpenFDA

In looking at OpenFDA, I'd like to know the range of values for results.seriousnessother, results.seriousnesshospitalization, results.serious, and results.primarysource.qualification, as well as what ...
3
votes
2answers
89 views

Can someone explain “openfda data is not for clinical use”?

I am looking for OTC Labelling information and was curious how I might be able to use the information in my applications since it says the data is not for clinical use.
3
votes
2answers
921 views

Looking for openFDA datasets which gives JSON data

I am looking for openFDA datasets for my current academic project. The project describes that a user enters medicine name and the result has to show me the information about the adverse events based ...
3
votes
1answer
55 views

Endpoint not returning expected data based on NDC package code

I recently stumbled upon openFDA and it seems to be the perfect answer for relaying drug brand name information to our users based on a provided NDC code. The issue I am running into however is that ...
3
votes
1answer
174 views

Comparing FDA drug data with other countries

We are trying to link the openFDA drug data with similar databases from other countries, and struggling to find a set of identifiers that will allow us to match drugs in different formats. Can't see ...
3
votes
1answer
143 views

OpenFDA adverse event counts by dates do not add up

The counts by date range do not seem to add up. For example, the following two queries https://api.fda.gov/drug/event.json?search=patient.drug.openfda.brand_name:"ambien"+AND+serious:1+AND+patient....
3
votes
1answer
76 views

Adverse Events Reported Term + MEDDRA coding dataset

I just wanted to kindly ask if anyone is aware about the presence of a repository of datasets containing both the Reported Term (usually collected in the CRF as free text by the investigator) and its ...
3
votes
1answer
71 views

Writing a script to mimic openFDA's count query

I downloaded all of the JSON files from openFDA (2004Q1-2015Q4) so I could run my own python scripts to mimic the count query provided by the API. My goal is to get the counts of adverse reactions ...
3
votes
1answer
268 views

Synchronize with the openFDA S3 bucket

When i'm try to synchronize my s3 bucket with openFDA S3 bucket ( aws s3 sync s3://my-bucket s3://download.open.fda.gov/), error occurce: "A client error (AccessDenied) occurred when calling the ...
3
votes
1answer
211 views

Why does the number of results change when I search for YAZ in the field patient.drug.medicinalproduct vs. patient.drug.openfda.brand_name?

Depending on how I search for drugs in the openFDA drug adverse event API, I get different counts (numbers of results). Here are two searches for the drug YAZ, between January 1, 2004, and September ...
3
votes
1answer
195 views

Why does a report listing a generic drug (drospirenone and ethinyl estradiol) have multiple brand names listed in the drug’s openfda section?

https://api.fda.gov/drug/event.json?search=safetyreportid:"4990905-5" In this adverse event report, three drugs are listed in patient.drug.medicinalproduct. The first is marked as the suspect drug (...
3
votes
1answer
47 views

help diagnose the query result? or a possible bug?

I used the following query: https://api.fda.gov/device/event.json?search=date_received:[20130101+TO+20141231]+AND+device.device_report_product_code=LLZ+AND+adverse_event_flag=Y&limit=1 In the ...
3
votes
3answers
55 views

Is it possible to receive complaint count in monthly format?

Hi I'm currently using the following function to get complaints on certain drugs over time. However the output gives me the number of reported complaints on a daily basis. It would help me a great ...
3
votes
2answers
154 views

Inconsistency in API results?

Two of the sample queries on the open.fda.gov "API Basics" webpage return what appears to be inconsistent results: https://api.fda.gov/drug/event.json?search=patient.drug.openfda.pharm_class_epc:"...