Questions tagged [openfda]
Questions and answers surrounding the U.S. Food and Drug Administration's OpenFDA program.
231
questions
1
vote
1answer
16 views
OpenFDA Covid19 Serology Tests DB Created_On/Updated_On Fields?
We are looking to monitor data that is added/changed within the DB on a daily basis. When looking at the results returned from the OpenFDA Covid19 Serology Tests API, it appears that in the metadata ...
1
vote
1answer
12 views
OpenFDA Covid19 Serology Tests missing manufacturer?
-- Missing manfuacturer?:
The manufacturer Beckman Coulter, Inc. is not available in the data as can be seen here
https://api.fda.gov/device/covid19serology.json?count=manufacturer.exact
but it is ...
1
vote
2answers
22 views
What is the best free database to use to get prescription and otc drugs marketed in the U.S. and approved by FDA?
I'm working on a project to build a drug database that provides drug lookup and information (indications/use, side effects, interactions etc.) and also provide pricing by pharmacy networks. So, apart ...
1
vote
0answers
12 views
Get product recall information from Open FDA based on the DI or UDI of a product in GUDID
Can UDI or DI codes on product packaging of Medical Devices be used to check for a recall status? Search results from GUDID for product information data, and Open FDA for Recall data, do show some ...
1
vote
0answers
17 views
Does OpenFDA has duplicate reports?
In an answer of this specific question on stack exchange :
What does some reports have the same safetyreportid?
It is stated that openfda has duplicates:
'Duplicate and incomplete reports are in the ...
0
votes
1answer
28 views
What does the searchable field safetyreportid mean in openFDA drug adverse event api
In the openFDA website(https://open.fda.gov/apis/drug/event/searchable-fields), it said safetyreportid is "The 8-digit Safety Report ID number, also known as the case report number or case ID. ...
0
votes
1answer
12 views
How can I import your database downloads into Elasticsearch?
I spent several hours unsuccessfully trying to import the drug json files that you have available in the downloads section into the latest release of elasticseach (7.8.0). The download files don't ...
0
votes
1answer
36 views
What does some reports have the same safetyreportid?
I thought that safetyreportid is the unique identity of a report, but I found that some safetyreportid like "5390497-5" has two or three reports in openFDA when I search by API:
https://api....
0
votes
1answer
20 views
OpenFDA Medical Device 510(k) other information than summary/statement
Is it possible to identify all 510k records of medical devices were a FDA review or clinical trials is available (e.g. https://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfpmn/pmn.cfm?ID=K151502) ...
0
votes
1answer
16 views
Search the summary PDF 510k medical device of openfda
Is it posible to search specific terms within the summary or statement PDF of the 510k records of medical devices using either the API, the dataset (https://open.fda.gov/apis/device/510k/download/) or ...
1
vote
1answer
22 views
Incorrect Product Code in OpenFDA Recalls Database
I noticed that when I look at product recall "Z-1973-2012" in the OpenFDA Recalls database, it returns with a result containing Product Code "CGA".
However the same recall number on FDA's Recall ...
0
votes
1answer
16 views
Is “event_key” meant to be empty?
If you review the raw data documentation and any accompanying research papers, you will be informed that "event_key" is meant to be an important field.
Master Event Data: A distinct master event data ...
0
votes
1answer
24 views
Is it possible to search using multiple criteria
Is it possible to search OpenFDA using multiple search fields. Separately both terms work but I can't figure out how to search using both at the same time.
This is what I tried that does not work to ...
0
votes
1answer
51 views
open FDA Recalls API endpoint does not have same information as accessdata.fda.gov
I am trying to pull data from openFDA for a 2007 medical device recall. On the FDA website I can see all the details - https://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfRES/res.cfm?id=64517 such as ...
1
vote
0answers
29 views
Do we need to consider a duplicate report in openFDA adverse event database? (like patient and doctor both submitted reports)
I am trying to search data with the drug name Hydroxychloroquine from the URL here from OpenFDA api
https://api.fda.gov/drug/event.json?search=patient.drug.medicinalproduct:%22hydroxychloroquine%22+...
0
votes
1answer
31 views
How Reliable are the Data
I am trying to search data with the drug name Hydroxychloroquine from the URL here from OpenFDA api
https://api.fda.gov/drug/event.json?search=patient.drug.medicinalproduct:%22chloroquine%22+AND+...
1
vote
1answer
19 views
NDC - SETID Mapping
I am interested in connecting the NDC data (brand_name, labeler etc.) to the FDA Label data (SET_ID). However, I'm struggling to find a dataset that would contain the mapping between the NDC code and ...
2
votes
1answer
44 views
What Determines if a Drug appears on OpenFDA or Not?
I'm attempting to use OpenFDA to query a drug's package NDC and return information like manufacturer, brand name, and route.
I have the following query working, but noticed (during testing) I get no ...
0
votes
1answer
48 views
MAUDE data frontend vs API
I am trying to use the openfda API to get a view of the data in the front end.
This is an example of a front end search:
https://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfMAUDE/detail.cfm?...
0
votes
1answer
24 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
1answer
47 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 ...
1
vote
1answer
49 views
Open FDA API - LIKE search condition
I am interested in finding a syntax for the LIKE search condition.
The query syntax example is
https://api.fda.gov/drug/ndc.json?search=brand_name:aspirin
I have to enter the whole word (aspirin) ...
0
votes
1answer
32 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 ...
2
votes
1answer
78 views
OpenFDA API Suspension effective 12/20/2019?
I'm wondering if anybody has any knowledge around the current suspension. None of the APIs have been updated since 12/14/2019, and the API status page currently reads, "Currently, there is a temporary ...
3
votes
1answer
21 views
Hazard and NIOSH Code and Information for Prescription Drugs
Is there an API endpoint via OpenFDA or some other source that will give me Hazard and NIOSH codes for a specific drug based on NDC number or some other code?
For example, the drug WARFARIN SODIUM- ...
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
1answer
33 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 ...
1
vote
2answers
68 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 ...
0
votes
1answer
75 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 ...
1
vote
0answers
22 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
1answer
46 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 ...
1
vote
0answers
19 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 ...
1
vote
0answers
70 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
1answer
75 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 ...
1
vote
1answer
127 views
openFDA - how do I get the brand name of a generic drug
I need to build an api that can get the brand name of a generic drug, some generics have several hundred records, using pagination to go through this and parsing the data is not practical for my ...
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 ...
1
vote
1answer
46 views
Understanding data discrepancy between NDC and annotated OpenFDA data
When comparing the NDC drug data at
https://www.fda.gov/drugs/informationondrugs/ucm142438.htm and OpenFDA annotated data at https://open.fda.gov/apis/drug/ndc/download/ , I observed that the FDA ...
0
votes
1answer
149 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 ...
1
vote
1answer
40 views
GUDID / Device Registration Common Data Element
Is there a field or data element common to both the UID and the device registration databases in FDA? I'm trying to tie the two together but can't seem to find a common field.
0
votes
2answers
66 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
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
1answer
18 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
35 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
38 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 ...
1
vote
0answers
99 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
...
0
votes
1answer
18 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
32 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
130 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+...
1
vote
1answer
78 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
28 views
Basic Use of openFDA Animal & Veterinary API
Will FDA be offering any additional training materials regarding use of its recently introduced openFDA Animal & Veterinary API? Although I've read the 'How to use the API' instructions, the ...
