Questions tagged [openfda]

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

Filter by
Sorted by
Tagged with
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,...
1
vote
1answer
699 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
1answer
74 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
85 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
59 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, ...
4
votes
3answers
153 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 ...
5
votes
3answers
169 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
44 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
519 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
1answer
86 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 ...
6
votes
1answer
103 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 ...
4
votes
2answers
184 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 ...
2
votes
2answers
88 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 ...
4
votes
1answer
156 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.
2
votes
6answers
266 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 ...
1
vote
2answers
194 views

How to get total count of adverse effects events by manufacturer in openFDA?

I get error when attempting to use count=patient.drug.openfda.manufacturer_name.exact without including the filter by field like in search=patient.drug.openfda.pharm_class_epc:"nonsteroidal+anti-...
3
votes
2answers
986 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 ...
5
votes
5answers
753 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 ...
2
votes
2answers
357 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
1answer
281 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
172 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 ...
3
votes
1answer
329 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
59 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
124 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?
2
votes
1answer
54 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 ...
2
votes
2answers
209 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 ...
1
vote
1answer
38 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 ...
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 ...
2
votes
1answer
51 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 ...
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?
1
vote
1answer
42 views

Data about the safety of Da Vinci Robotic Surgery

I am looking for data about the safety of the Da Vinci Robot. Have there been recalls on the Da Vinci Robot for not functioning properly? Have patients experienced terrible results via the use of the ...
6
votes
2answers
267 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 ...
7
votes
1answer
120 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/...
2
votes
3answers
119 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+...
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 ...
4
votes
1answer
56 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.
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
245 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
241 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 (...
1
vote
1answer
31 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
67 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"...
3
votes
1answer
49 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
1answer
60 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 ...
1
vote
1answer
128 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+...
5
votes
1answer
146 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
2answers
66 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
3answers
58 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
38 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
99 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
67 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 ...