Questions tagged [openfda]

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

Filter by
Sorted by
Tagged with
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 ...
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"...
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 ...
1
vote
1answer
35 views

“hypotension” due to carbamazepine in open FDA?

How to search count of specific adverse event "hypotension" due to carbamazepine in openFDA?
1
vote
2answers
53 views

How to download data more than limit of option “limit” and “skip”

I am using this api https://api.fda.gov/drug/ndc.json. But as per limitation, we can't pass limit more than 100 and value for Skip is 25000. But in the data, if we have more than 100K + record. How ...
1
vote
0answers
67 views

OpenFDA End Point Updates

With respect to the US Food and Drug Administration's API, I haven't seen the end points updated since 8/12/19. Did something change or is this common? I've noticed the end points refreshed fairly ...
1
vote
0answers
85 views

average ingredients for each drug in each year for a specific manufacturer

I want to count the average number of ingredients in each drug produced by a specific manufacturer in each year. The results I want should be like this: year | drug_names | avg_number_of_ingredients ...
1
vote
1answer
68 views

Why does the data on website not match what is returned from the api

I am trying to get data similar to what is shown on https://www.fda.gov/Safety/Recalls/default.htm using the api, but I am seeing a lot of discrepancies. For example when I use the following api ...
1
vote
1answer
65 views

Can we get the dosage list for a drug

How can we get the dosage list for a particular drug. we have the key "dosage_forms_and_strength" but it gives a single string not in a list format. I need to bind a dropdown for dosage information ...
1
vote
1answer
47 views

How to download a subset of the reports based on a specific indication of query term?

I understand that for performance purposes in my case it will be better to download the data rather than accessing it through the public API. On a practical note I am only interested in a subset of ...
1
vote
1answer
108 views

When will the drug events api (https://api.fda.gov/drug/event.json) be updated with 2018 Q2 data

I see that on the FDA adverse events reporting (FAERS) public dashboard the data is already as of June 30, 2018 whereas on the API its still as of March 31, 2018. https://api.fda.gov/drug/event.json?...
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 ...
1
vote
1answer
121 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
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, ...
1
vote
0answers
28 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
0answers
63 views

Getting the complete list of AEs x drug with openFDA

Can one get ALL AEs per single drug instead of most frequent ones? Example Ibrutinib 2,921 reports; AEs reported 1,696 in 10 categories. How can I get the remaining list of less frequent events up to ...
1
vote
0answers
36 views

openFDA - Recalls - quantity in commerce

Any reason this field is not available on openFDA? It can be seen on individual queries on the website: (random example) https://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfres/res.cfm?id=131707 Are ...
1
vote
0answers
19 views

How to get a review page link or review files for a certain drug using API on FDA?

I wanna get the review link for a certain drug links via API, e.g, for the drug "AUBAGIO", it's "http://www.accessdata.fda.gov/scripts/cder/drugsatfda/index.cfm?fuseaction=Search.Set_Current_Drug&...
1
vote
0answers
41 views

Problem with date format

I'm getting some problems with the format dates on openfda. Is there an existing method to format or process to show on a chart?
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, ...
0
votes
1answer
80 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 ...
0
votes
1answer
30 views

Unzipping the openfda data in R

I've downloaded all the url's for the different drug-event pairs, but they all end in .zip. Does anyone know how to automate pulling the .json file out of these zip files without doing it manually for ...
0
votes
1answer
66 views

Package NDC Query

I am trying to query OpenFDA to get some data on the following product: https://ndclist.com/ndc/52380-0001/package/52380-0001-3 I have tried querying 52380000103, 5238000013, 5238000103 and ...
0
votes
1answer
17 views

Atopiclair does not appear on any FDA list I can find

Atopiclair is on drugs.com: https://www.drugs.com/cdi/atopiclair.html Here's where it's not (on fda.gov): The FDA CDER DB: https://www.accessdata.fda.gov/scripts/cder/daf/index.cfm The Medical ...
0
votes
1answer
33 views

Unexpected results from query

If I check the FDA's Drug Shortage page the first item on the list is a product with a generic name of: Abciximab (ReoPro) Injection. If I click on the link provided there is a column called ...
0
votes
1answer
113 views

How to fetch data from open fda API with multiple query parameters using +AND+

I am using below API query to fetch recalls for food by city AND termination date range. but it doesn't seem to work https://api.fda.gov/food/enforcement.json?search=city:%22Westminster%22+AND+...
0
votes
1answer
91 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....
0
votes
2answers
111 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
0
votes
1answer
20 views

Query Open FDA for application_number, ndc, and rxcui

My apologies if this has been asked: I am new to using OpenFDA and am trying to query the database to obtain a list of the ndc and rxcui associated with a particular application numbers appearing in ...
0
votes
1answer
29 views

Retrieving names of drug that include spaces from specific adverse reactions

I am trying to extract the top 100 drugs related to the highest number of adverse reaction of a specific type. For example, I would like to extract the top 100 drugs that have been reported as ...
0
votes
1answer
38 views

using barcode value to lookup drug information

I am trying to build a query tool that takes a scanned barcode (NDC) and looks up the drug information in the openFDA. I have a package for Latanoprost Ophthalmic Solution with a package code of ...
0
votes
1answer
13 views

Availability of PGx Biomarker data for drug labels?

Is the Pharmacogenomic Biomarkers in Drug Labeling available through the OpenFDA system? If not, are there any plans to make this data available? Seems like this would be an easy thing to model and ...
0
votes
2answers
73 views

How to get all generic names in the API (drug label)

I want list of all generic names in the api.fda. I have this end point query giving me first 1000 generic names. https://api.fda.gov/drug/label.json?count=openfda.brand_name.exact&limit=1000 ...
0
votes
2answers
48 views

Is it possible to link drugs, with protein targets, using OpenFDA?

I have a set of protein targets. The absolute ideal return for these targets for me, would be a .tsv file that looks like this: target_name fda_approved_drug target1 drug1 target2 - ...
0
votes
1answer
187 views

How to find Novartis medicines in openFDA drug labelling data

I am trying to look at the Novartis medicines on openFDA open data on drug labeling for a given period. I tried this: https://api.fda.gov/drug/label.json?search=spl_patient_package_insert:"Novartis"&...
0
votes
0answers
7 views

What characters are allowed in the search parameter of the NDC OpenFDA API request?

I'm having an issue where the NDC API returns errors when special characters are submitted in the search parameter. I working on a product that contains a search box that allows the user to lookup ...
0
votes
0answers
10 views

Is there an OpenFDA API That shows if a drug is hazardous to handle?

Is there an API that I can hit to see if a drug is categorized as hazardous to handle. Is there a property such as: IsHazardous or either an OSHA or NIOSH value in one of the APIs?
0
votes
0answers
21 views

Looking for an endpoint to retrieve warning letters

You can search for warning letters https://www.fda.gov/inspections-compliance-enforcement-and-criminal-investigations/compliance-actions-and-activities/warning-letters
0
votes
0answers
16 views

Where can I find FDA approval SPL drug data?

I am doing a study on approval label drug data for prescription drugs and want to get a a large dataset of the approval label for a drug. I will be then comparing this with later versions of the drug ...
0
votes
1answer
63 views

Mapping of drug names to generics

Dataset: Obtained from FDA AERS I would like to map the drug names to its generic name. Example: Arthritis Pain, Aspir 81, Aspir-Low, Bayer Childrens Aspirin etc would be mapped to aspirin Is there ...
0
votes
0answers
23 views

openfda - get list (dedupe) of unique medication strengths for given medication search

Searching for medication "atorvastatin calcium" returns a total of 509, lots of generics manufacturers. I want the API to return the unique medication strengths, is there a way to do that within the ...
0
votes
1answer
31 views

UDI Dataset JSON parsing efficiency TANKED after July 07 (Using Azure Data Factory)

I'm finding that my ability to parse the JSON using Azure Data factory is not possible after file updates on July 07. The process, which took 10 minutes previously now takes 50+ hours. Is anyone esle ...
0
votes
1answer
145 views

Difference between Recall Enforcement Report and Recall Report?

I notice there are two types of recall datasets: Recall Enforcement Report and Recall Report. And I downloaded both of them. There are overlaps of recall events and related information, but they are ...
0
votes
0answers
24 views

Different manufacturer for same application

While trying to access labels by using open FDA API, I observed that manufacturer_name is not consistent for same application. How can a single application can have more than one manufacturer.
0
votes
2answers
54 views

Historical National Drug Code Package Data Availability

I am wondering how I may be able to access historical NDC Directory File data? An example of the type of data I’m looking for would be for NDC Package Code 0002-3004-75, or Prozac Weekly. In the ...
0
votes
1answer
35 views

Why is there an extra “0” at the beginning of every UPC code in openFDA?

When I compare images of the package label UPC barcodes with these codes the zero isn't there. Having written an application that stores and uses pharmacy item UPC barcodes, I can assure you the ...
0
votes
1answer
15 views

I am attempting to locate DrugID or DCode information

Does anyone know where to obtain DCodes or DrugIDs in the OPEN FDA product? I get practically everything I need except this. Thanks.
0
votes
1answer
25 views

Device Product Code API call

I'm trying to return medical device "product_code" data, but the following two URLs do not work. For example, I'm trying to get data on the product code, "DXN" as listed here: https://www.accessdata....
0
votes
1answer
33 views

Download Table from PRR drug Research tool

I used the PRR drug research tool: https://openfda.shinyapps.io/RR_D/ When I select a drug name it lists me by default the top 50 drug event combinations with PRR & ROR values. In the R shiny ...