Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [openfda]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
21 views

Searching for adverse reports related to quality only reported in 2017

I'm trying to search for the number of adverse reports related to "quality" within the query and only for the year 2017. I've tried this query https://api.fda.gov/drug/event.json?search=receivedate:[...
2
votes
3answers
540 views

Where is the list of fields available through the openFDA API?

I was wondering how to create a query based off the examples, and the main question I have is where do the patient.drug.openfda.pharm_class_epc and patient.reaction.reactionmeddrapt come from? I ...
0
votes
2answers
109 views

How can I access FDA drug recall or warning letter data?

How can I access FDA drug recall, or warning letter data? So that I can use that information to predict the Drug Shortage using machine learning algorithms
2
votes
2answers
106 views

Drug label information does not include all approved drugs (kymriah and yescarta missing)

It appears as though some drug labels are missing. I just want to know if I'm missing something obvious? Specifically I cannot find either Kymriah or Yescarta searching by their brand or generic ...
0
votes
1answer
87 views

API for searching Orphan Drug Designations and Approvals

I'm building a website using the openFDA APIs, which works perfectly. I also notice that the FDA website provides a tool called "Search Orphan Drug Designations and Approvals" at https://www....
2
votes
1answer
48 views

How to decode the company number in the field `header$companynumb`

Is there a lookup table where I can find the names of repackaging or drug manufacturing companies with companynumb reported in the field companynumb? e.g. "companynumb": "200501050" Thanks
1
vote
2answers
42 views

meds not appearing in FDA CDER or medical device DBs

The meds not appearing in either are as follows: RabAvert Donnatal Androxy The search engine I used for the FDA CDER DB is as follows: https://www.accessdata.fda.gov/scripts/cder/daf/index.cfm The ...
0
votes
1answer
78 views

why doesn't FDA drug list include all meds?

The FDA has a drug list that I would have thought would have had all FDA approved drugs. The list can be downloaded here: https://www.fda.gov/drugs/informationondrugs/ucm079750.htm You can search it ...
3
votes
1answer
63 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 ...
1
vote
1answer
166 views

what is the difference between drugs@fda and openfda?

What is the difference between (drugs@fda or drugs@fda data files) and openfda? Is there a recommended resource to use for drug name lookup?
1
vote
0answers
39 views

How to find information about buildings using specific addresses?

As indicated in the question, I am looking for all kind of information about buildings in Switzerland, preferably using an API. This could include information like whether a restaurant or a bank is ...
2
votes
2answers
276 views

Use Fuzzy Search with OpenFDA API

I want to ask how can I use fuzzy search in openfda api? For example, I am using "panadol" to search something. https://api.fda.gov/drug/label.json?search=brand_name:panadol But sometime I miss ...
1
vote
1answer
60 views

openFDA co-occurring adverse events

Is there a way to query openFDA to get the set of co-occurring adverse events that for a given set of 2 or more drugs for a given indication? For example, What are the adverse events that happen in ...
1
vote
1answer
49 views

Availability of data from 3 specific FDA web pages

I'm looking at the API references for drugs and for devices, but haven't found answers. I'm wondering if it is possible to return the information that is listed on 3 web pages at FDA: Hematology/...
4
votes
1answer
856 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)?
2
votes
1answer
153 views

Open FDA - Medical device search -> summary pdf

I want to know how to search the PDF files with a search term. Most 510K records have the value "Summary" stored in the Summary field. How can one search the PDF files attached to the summary and ...
3
votes
1answer
99 views

Inflexible search params with open.fda.gov

I'm having the following issues with the Search result limitations with open.fda.gov: Up to 100 results for single request; and up to 5100 results for single search criteria No flexible search (e.g. ...
3
votes
2answers
144 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 ...
1
vote
1answer
144 views

Accessing raw OpenFDA data for visualizations

Is there a way to connect a Tableau Web Data Connector to the data on the OpenFDA API?
1
vote
0answers
58 views

Limit the array of drugs in openFDA

Hello I am messing around with openFDA and was wondering if its possible to search for a medicinal product and only return objects with one drug in the array. For example when you search for a drug, ...
3
votes
2answers
1k views

Get All medicine names

My aim is to give intelligent support to the textbox where the user will type the medicine name that they want, and I will provide suggestions of the medicine. For this purpose, i want to get the ...
2
votes
3answers
253 views

OpenFDA API: Including the skip parameter limit

I was working with the API and trying to paginate the results and I ran into an error which says 'Skip value must 5000 or less'. It would be nice if you guys could add this to your documentation ...
3
votes
1answer
162 views

openFDA: 510k update frequency

How often is openFDA 510k database updated? Through the FDA website I see a new batch of 510k clearances from June 2016. However, openFDA has not been updated since May.
1
vote
0answers
27 views

Retrieve Import Alerts published by FDA

The FDA publishes lists of Import Alerts in HTML format, such as, for example, in page https://www.accessdata.fda.gov/cms_ia/importalert_259.html . This is in FDA site under Industry > Import > ...
5
votes
1answer
308 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?
1
vote
1answer
128 views

How to openFDA Query data from 2014 to present?

I was looking through the openFDA API and have been trying to find a good way to get data from the start of 2014 to now. Unfortunately it appears the downloads only go to 01-25-16. I also ran a query ...
1
vote
1answer
36 views

Device events has duplicating patient records

It seems that in the https://open.fda.gov/device/event/ the patients have duplicated records. "patient": [ { "sequence_number_treatment": [ "" ], "...
6
votes
4answers
920 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. ...
2
votes
1answer
84 views

How to download all the ophthalmic devices data from device classification end point in openFDA

The API call https://api.fda.gov/device/classification.json?search=medical_specialty_description=%22ophthalmic%22 is returning (limiting) the number of records to 1 for ophthalmic devices data. I ...
2
votes
1answer
123 views

OPenFDA API - querying on dosage_and_administration_table _exists_ not working

I was planning to get the results where brand name is aspirin and whose drug result has property dosage_and_administration_table. So I did this https://api.fda.gov/drug/label.json?search=brand_name:...
1
vote
1answer
143 views

Running openFDA api locally

I am trying to do some classification and clustering on the openFDA dataset. I started by downloading a year's worth of data and realized I run into system limits and would need to solve for that. ...
1
vote
1answer
365 views

Python crashing when trying to read zipped json files [closed]

I downloaded the 2015 adverse drug events data from openfda and I want to run some analysis with python. I am a python newbie, but have become comfortable with the scikit-learn libraries, but I cannot ...
3
votes
1answer
148 views

Query OpenFDA by UPC

I am trying to query OpenFDA by UPC but the API keeps returning "No Matched Found". I assume this works in the same way as product NDC, which is returning as expected when I try something like this: ...
3
votes
1answer
66 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 ...
2
votes
1answer
519 views

Is there a way to query openFDA for drug pair interaction?

openFDA is awesome particularly the drug/event database. But I can't find a way to query whether a particular drug (e.g. xanax) has any drug interaction warning, precaution, or contraindication. ...
3
votes
1answer
84 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 ...
1
vote
1answer
23 views

is there a search class for whether the drug was taken in hospital or not?

is there a search class in open FDA Drug Adverse Event Report Browser for whether the drug was taken in hospital or not?
2
votes
2answers
156 views

openFDA: Is There an Open Database of Which Drugs are Approved for the Treatment of Which Illnesses?

Is there an open database which lists FDA or EMA approvals of drugs for the treatment of specific illnesses?
6
votes
3answers
9k 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....
3
votes
1answer
58 views

openFDA - update notice:: further clarification

A little more clarification, please. I see the Q/A here openFDA endpoints not updated in over 2 months. Has this project been abandoned? regarding the bug and update status. Did the bug and will ...
4
votes
1answer
126 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 ...
1
vote
1answer
173 views

How do I run openFDA API locally?

I'm currently working on a project that would greatly be assisted by running the openFDA API locally. I tried to follow the READMEs but I can't get it to work. Thank you!
5
votes
2answers
2k 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 ...
3
votes
1answer
496 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 ...
2
votes
1answer
74 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
123 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....
2
votes
1answer
82 views

Where to save the event JSON files for openFDA locally?

I just downloaded the openFDA source code from the github, as well as all the event endpoint JSON files, and I wanted to know which directory to save the JSON endpoints. Some also seemed to have the ...
1
vote
1answer
93 views

For openFDA, is there a way to get the counts of every drug for a particular adverse event?

I'm working on calculating a PRR, but instead of using a drug-adverse event pair, I'm looking at the drug-SOC (system organ class) pair, which needs all the reports of every drug-ADE pair within a ...
2
votes
1answer
113 views

Setting up a private instance

In general, I want to use OpenFDA to look at the overlap between FDA drug data and cosmetics ingredients, primarily using the drug event and drug label data sets. Device and food questions might arise ...
4
votes
2answers
112 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 ...