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
109 views

OpenFDA query - wanting one section

I'm rying to eventually populate a spreadsheet with only the dosage_and_administration section for like 2000 medications. I created a query for this: https://api.fda.gov/drug/label.json?search=...
3
votes
1answer
63 views

download and convert the data of the Medical Device Adverse Event database

I'm trying to convert the data from this database to a format like csv or sql database. The goal is to analyze this data with R later. I would like to store them in a local database to be able to ...
2
votes
2answers
114 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 ...
1
vote
1answer
62 views

using openfda.brand_name.exact:“Tylenol” case sensitive

I have recently come across openfda.brand_name.exact. It is getting the results where the brand name has to match exactly, i.e. also case sensitive. For example, the query api.fda.gov/drug/label....
0
votes
1answer
88 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....
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
79 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 ...
1
vote
1answer
173 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
41 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
1answer
50 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
2
votes
2answers
292 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
108 views

Difference between Inspection Observation and Inspection Citation reports

What is the difference between the FDA Inspection Observation and Inspection Citation reports? The inspection citation report appears to have slightly less data but provides more details for what is ...
1
vote
1answer
63 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 ...
4
votes
1answer
897 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
156 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
104 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. ...
1
vote
1answer
50 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/...
0
votes
1answer
57 views

How can I get the PI Label “Highlights” (or page 1) of the drug's label

Are the "highlight of the prescribing label" available through openFDA?
1
vote
0answers
63 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, ...
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
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 > ...
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
1answer
136 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 ...
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 ...
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 ...
5
votes
1answer
329 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
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": [ "" ], "...
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
127 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
145 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
399 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
152 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
68 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
539 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
85 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?
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 ...
5
votes
3answers
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
504 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 ...
3
votes
1answer
163 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.
2
votes
1answer
75 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
132 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....
1
vote
1answer
189 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!
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
94 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
115 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 ...
2
votes
1answer
2k views

Getting Started with the OpenFDA API

I am totally lost with the OpenFDA API. I've downloaded the API from Github, run the bootstrap.sh, run python setup.py install, and I have no clue what to do now. My specific questions: 1. ...