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.

2
votes
1answer
39 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,...
1
vote
2answers
55 views

OpenFDA: BAD_REQUEST when searching with URL encoded inputs

I am trying to search some of the "free text" fields that have values with commas, apostrophes, etc. With the encoding I have tried all combinations of quotes, parenthesis, etc. however it always ...
1
vote
1answer
445 views

Searching for label by NDC

I'm trying to use the label API to search for a specific OTC drug. Lets take CVS's 10mg Loratadine for example. The NDC number is 59779-612-75. Based on the API docs I think the right query should ...
2
votes
3answers
226 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
69 views

Database of non-packager-specific drug information

DailyMed lets me look up the Structured Product Label files for various medications, and I know that I can download a database of those drug labels from DailyMed here. The Structured Product Labels (...
1
vote
0answers
79 views

OpenFDA: Is there a data source which provides descriptions of the ingredients listed in EAFUS DB?

Is there a data source which provides descriptions of the ingredients listed in EAFUS DB? I have been able to find details from varied sources (PubChem, Wikipedia etc etc) but I need something that ...
1
vote
0answers
52 views

Bug in count in openFDA Adverse Events?

When using "count" I have found that less frequent counts in a query are often incorrect. My ad hoc workaround has been to always set limit to 999, and only use the first 100 counts. For example, ...
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 ...
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 ...
2
votes
0answers
37 views

OpenFDA API: Why do some recalled items have UPCs listed and others don't, and is that something that would likely get improved?

I know that UPCs are optional. But I'm curious why when a company recalls all codes, those codes aren't listed. It would make it easier for apps to alert consumers accurately if more UPC codes were ...
2
votes
1answer
78 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
158 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 ...
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 ...
2
votes
1answer
221 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
55 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 ...
-4
votes
1answer
109 views

I am using open FDA for the first time, How can I get API key? [closed]

We are using Composite data virtualisation tool. How can openFDA help us? How can I get API key?
1
vote
1answer
36 views

Forward slashes in OpenFDA queries invariably lead to errors

When I query the OpenFDA API, some queries which should be valid yield invalid results. I suspect this has to do with an error in how forward slashes are handled in queries on the FDA server (which ...
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 ...
2
votes
2answers
194 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
0answers
22 views

OPEN FDA beta - 2 Letter Codes for device attribute - “manufacturer_country”

what are the 2 letter codes for the device attribute - "manufacturer_country" based on? are these fips codes or so-3166 alpha 2 codes or some other coding scheme? it seems there are multiple codes ...
3
votes
1answer
269 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 ...
2
votes
1answer
391 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
0answers
30 views

Timing/schedule for new datasets

Is there a target schedule for making additional datasets available via OpenFDA? For example, the data in Drugs@FDA database, or the PostMarketing Reqs and Commitements database data?
2
votes
1answer
51 views

How does one link two selected elements on two tables within openFDA?

I'm trying extract some summary information from openFDA and am receiving wildly different responses, and very different capabilities when attempting my search, and was hoping that someone could help ...
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, ...
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.
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
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 ...
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 (...
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 ...
2
votes
3answers
101 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
1answer
48 views

Drug time series produces unexpected results

I run two queries for the daily number of reports for bextra and avandia: https://api.fda.gov/drug/event.json?search=receivedate:[20050101+TO+20050430]+AND+brand_name:bextra&count=receivedate ...
3
votes
1answer
86 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 ...
2
votes
2answers
78 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
309 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": "...
1
vote
1answer
28 views

what is adverse_event_flag used for?

I first tried this query and the returned count of Injury was 9. https://api.fda.gov/device/event.json?search=date_received:[19950101+TO+20141231]+AND+device.device_report_product_code:LLZ+AND+...
1
vote
1answer
62 views

“The API response was an error” in OpenFDA search query

I used the following query: https://api.fda.gov/device/event.json?search=date_received:[20120101+TO+20141231]+AND+device.device_report_product_code:LLZ+AND+product_problem_flag:Y+AND+event_type:"Death"...
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.
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 ...
1
vote
1answer
116 views

Is it the right query on what I am looking for in openFDA?

I have performed a query. I was planning to get the adverse report based on medicine name and age. So I did this" https://api.fda.gov/drug/event.json?search=patient.drug.openfda.brand_name:advil+AND+...
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 ...
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 ...
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 ...
3
votes
1answer
55 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
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 ...
2
votes
1answer
33 views

Class 1 and 2 medical device recalls

How can I structure a question on the FDA OpenApp that will return all Class 1 and 2 medical device recalls for radiation therapy devices over a certain period (e.g. the month of June 2014)?
3
votes
1answer
95 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/...
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 ...
3
votes
1answer
49 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 ...