Questions tagged [openfda]

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

Filter by
Sorted by
Tagged with
3
votes
1answer
66 views

Is there a openFDA Data Pipeline version supported for Windows?

Everything in the openFDA data pipeline API seems Linux-centric, including several dependencies; dependencies require me to compile the source because packages only exist for Linux (like leveldb). I ...
3
votes
1answer
98 views

list of approved active ingredients

If I wanted to define how drugs and cosmetics chemicals/ingredients overlap, could I use openFDA to help answer the drug part of that comparison? Would I be able to take the contents of all the ...
3
votes
1answer
52 views

How quickly after FDA approval will adverse events be listed on openFDA?

I cannot seem to find information on what the lag time is between FDA approval (drug on market) and results for adverse events being listed on openFDA. Does anyone have an idea of the timeline? For ...
3
votes
1answer
96 views

How do I query for a field with a single quote or apostrophe? e.g. “CROHN'S DISEASE”

I want to list all drugs that have "CROHN'S DISEASE" or "CROHN^S DISEASE" as drugindication: http://api.fda.gov/drug/event.json?search=patient.drug.drugindication.exact:%22CROHN'S+DISEASE%22&...
3
votes
1answer
92 views

Is it possible to get the exact (particular) information from openFDA?

I am looking for just meta information from openFDA. Whenever I do a query I get all the information like meta, results. My requirement doesn't deal with results. We just care about metadata, because ...
3
votes
1answer
54 views

Delay in openFDA's drug recalls/enforcement reports?

It looks like there is a delay in the data served by the openFDA's enforcement report API. Right now, the most recent records in the responses from the endpoint are dated 6/18, but the most recent ...
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
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
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
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.
3
votes
1answer
104 views

Does the openFDA drug adverse events dataset (or any other dataset) have a geographic dimension?

I want to produce visualizations of PRR and ROR of drug adverse events using openFDA data using d3 and shiny. I want to build interactive map view (map of the US with PRR values by state, for example)....
3
votes
1answer
309 views

Cosmetic Names (INCI nomenclature) and URLs to OpenFDA

I am trying to pass INCI names (perhaps my first mistake) to the OpenFDA api. Some INCI names give me something to work with; however, others I think are not really passable, even after replacing ...
3
votes
1answer
59 views

Where is the “product problem” field in the openFDA API?

In the MAUDE search tool on FDA.gov there is a standard list of problems in a product problem field. This is not available in the API. See screenshot for example. This would be a great addition to ...
3
votes
1answer
50 views

Dietary Supplement data

Does this data contain recall data (or any data) on dietary supplements for humans or dietary supplements for animals (which is handled by the Veterinary Drug department)?
3
votes
1answer
31 views

Model documents for presubmission meeting with FDA about mhealth pilot trial and risk assessment

I am planning a trial with diabetic patients to use our digital tablet-based Android app for helping to track/manage glucose, nutrition, medications, and fitness-related activities. It has been ...
3
votes
1answer
62 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 ...
3
votes
0answers
78 views

.How can I get the list of drugs that interact with a particular drug in openFDA

I am trying to get a list of ingredients/drugs that might interact with a particular drug or check if a list of drugs might interact with each other. How can I achieve it using openFDA API.
3
votes
1answer
98 views

OpenFDA API: Can I perform search by same field with various values

I'm in a process of investigation of openFDA API and its possibilities. For now I'm reviewing this type of request - One enforcement report of a certain health hazard class https://api.fda.gov/drug/...
2
votes
6answers
263 views

Where do I type in my query in the API in openFDA.gov

The openFDA.gov reference website says to use the following webpage for queries: https://api.fda.gov. But when I go to that page, there is no where to type in a query and run it. Where can I type in ...
2
votes
2answers
202 views

FDA Open Data sample URL for date range

I am new to OpenFDA API, and I just got my API key and I want to get a food recalls that falls within range of dates. Could anyone provide me with an example of what would be the URL with range of ...
2
votes
2answers
87 views

How can I find the missing information from openfda?

I have performed adverse report based on drug name with male gender, unknown gender and female gender and for all genders. But it seems like all genders count is not equal to the combined count of ...
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 ...
2
votes
1answer
45 views

OpenFDA report_date for Food/Enforcement doesn't seem to work after 9/23/2015

I am getting 0 results for any ranges after 9/23/2015. See last day of results here: https://api.fda.gov/food/enforcement.json?search=report_date:[20150923+TO+20160106] No results from 9/24 on: ...
2
votes
3answers
114 views

How can I get accurate data re Adverse Events?

I am researching hormonal birth control and finding different results depending on how the order of the drug is listed. Also, if a space is used between Ethinyl Estradiol or not. Ethinyl Estradiol+...
2
votes
2answers
344 views

How do we relate Adverse Reactions and Drug in Open FDA?

I have been trying to relate adverse reaction to list of drugs in the Open FDA JSON but just can't manage to understand. Consider this JSON: "reaction": [ { "reactionmeddrapt": "...
2
votes
2answers
275 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 ...
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?
2
votes
2answers
65 views

Duplicates in device recall data?

Is it just me or almost all of the device recall data duplicated in OpenFDA? For example, why are there 4 nearly identical entries for recall "Z-3261-2011" when a query for this recall number is made ...
2
votes
3answers
252 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 ...
2
votes
1answer
83 views

OpenFDA Data: Labels with Boxed Warnings

I'd like to integrate boxed warning information from SPL with the Pillbox Engine so Pillbox users and developers can 1) know when a product has a boxed warning and 2) have access to the boxed warning ...
2
votes
1answer
57 views

Is there any better way to get sum number of reactions

I used this api call to get expected number of reactions: https://api.fda.gov/drug/event?&search=???&count=patient.reaction.reactionmeddrapt.exact&limit=24 But as I only get part of the ...
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
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 ...
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 ...
2
votes
1answer
161 views

Download all drug adverse events

I downloaded the adverse events quarterly data files from the FEARS website and I merged and cleaned them to use them in my next analytics pipeline. I was asked if I can download all the drug adverse ...
2
votes
1answer
28 views

openFDA Device Adverse Events missing for Dec, 2015 (as of 19-Jan-2016)

There still appears to be a problem with the data for Dec, 2015... the following query returns zero results as of now: http://api.fda.gov/device/event.json?search=date_received:[20151201+TO+20151231]
2
votes
1answer
42 views

openFDA Device Adverse Events Data out of date

Does anyone know why the Device Adverse Events data available via the openFDA API has not been updated since 01-Jul-2015?
2
votes
1answer
46 views

Return an Enforcement record for search=recall_number

Whenever I attempt to query the API with a specific recall_number, I receive the API error message. Is there another method for retrieving an individual record that I am overlooking in the docs? Also,...
2
votes
1answer
169 views

Variable/multidimensional json record structure OpenFDA

Arguably this is more a general programming question, and I should keep learning; yet, if advice or guidance is forthcoming I wanted to try asking: what is the best way to look for substances that ...
2
votes
1answer
271 views

Any public accessible web service to get MedDRA description?

I used this api call to get reaction list: https://api.fda.gov/drug/event?&search=???&count=patient.reaction.reactionmeddrapt.exact&limit=24 I just want to forward users to a page that ...
2
votes
1answer
481 views

Getting more than 100 records from OpenFDA in MS Excel [duplicate]

I have a query that appears to identify 975 items per the meta information. I used the limit (100) & skip (25) parameters to get the result. However, if I try to use that same query in Excel (...
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 ...
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
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 ...
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:...
2
votes
1answer
517 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. ...
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 ...
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. ...
2
votes
1answer
39 views

De-duping follow-up reports

In openFDA's source code documentation it's said that the FAERS pipeline includes a procedure for de-duping follow-up reports. I don't find in source code where it happens. What it means? Only last ...
2
votes
1answer
77 views

Is there a OpenFDA API Basics for medical devices?

Reading the documentation of OpenFDA fields, we are linked to the API Basics reference guide. Every time that I try to find information about API fields (including other questions on this site) I end ...