Questions tagged [openfda]
Questions and answers surrounding the U.S. Food and Drug Administration's OpenFDA program.
204
questions
0
votes
0answers
3 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
26 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
0answers
8 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
0answers
29 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 ...
0
votes
1answer
35 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
65 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
0answers
20 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
27 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
31 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
32 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
22 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
1answer
25 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
42 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
11 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
15 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
28 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
28 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
67 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
11 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
17 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
86 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
58 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
23 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 ...
0
votes
1answer
28 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 ...
0
votes
1answer
23 views
Which data processes are applied on FAERS data
I am trying to understand if the FAERS data are processed in OpenFDA similarly to what is done in softwares (RxLogix, ORACLE, CVW), meaning:
Have the FAERS data been checked for duplicates with ...
1
vote
1answer
33 views
How to filter drugs by date , ex : marketing start date , or , listing_expiration_date
I am using the REST API Endpoint
https://api.fda.gov/drug/ndc.json?search=finished:true&limit=1
how to i filter the drugs based on the created date or marketing start date etc..
0
votes
1answer
58 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
43 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
59 views
openFDA: Is there any way to match NDC data in different format?
I'd like to know whether or not there is a possible way to match NDC codes in different format by using openFDA API like Recall Enforcement Reports. For example, matching 0187-0798-30 with 0187-079-...
0
votes
1answer
24 views
What is the status of VAERS?
What is the status of the US government Vaccine Averse Event Reporting System (VAERS)?
Is there also a JSON file containing links to all downloadable files for automating the download of the data?
0
votes
1answer
162 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
1answer
35 views
Retrieve the Supplier details using FEI number?
a. Can we retrieve the Supplier details using FEI number, in any of the APIs?
b. Are there any datasets or APIs available to query information under Cosmetics?
c. Are there any open APIs to fetch ...
0
votes
1answer
33 views
openFDA - Open APIs to access Import Alerts, Import Refusals, Warning Letters & Inspection details
Does openFDA have APIs to access Import Alerts, Import Refusals, Warning Letters & Inspection details for a Supplier?
0
votes
1answer
35 views
Is Trade name is same as brand name
i wanted to get the trade name of a drug, but in https://api.fda.gov/drug/label.json?search=openfda.generic_name:Amoxicillin i get brand_name.
so can someone please confirm, that brand_name refers to ...
1
vote
1answer
60 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
2answers
37 views
Identifying conventional vs natural drugs
Is there a way to identify which drugs are Conventional (Allopathic) drugs vs which drugs are Natural (Homeo, Ayurvedic) drugs from open FDA drug label repository?
0
votes
1answer
74 views
OpenFDA - Differences Between Dashboard and API Results
I want to find the numbers of cases of each adverse effect for some drugs in the FAERS database. I am using Keytruda as an example.
I ran the API to count the adverse events for Keytruda: https://api....
0
votes
1answer
42 views
OpenFDA: Programmatic/Machine Readable Biologic License Application Data
Is there a way to programatically (or manually) download the biologic license applications data in a machine readable format?
Here is a PDF that at the bottom has the 2015 approvals, https://www.fda....
0
votes
1answer
45 views
Q: Boolean Structure
I'm looking for help to construct a search with multiple parameters. Is this possible? I'm basically performing this search to try to catch reports that may have been labeled with the incorrect ...
1
vote
1answer
44 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 ...
0
votes
1answer
21 views
Searching for adverse reports related to quality only reported in 2017
I'm trying to search for the number of adverse reports related to "quality" within the query and only for the year 2017. I've tried this query
https://api.fda.gov/drug/event.json?search=receivedate:[...
1
vote
1answer
81 views
Why is this NDA not available in openFDA?
I'm working on a project that annotates FDA label text. We're trying to use the openFDA API to get information about specific NDA IDs. I'm trying to query information about NDA206038 using the /search ...
0
votes
1answer
29 views
Medical Device - multiple FEI numbers associated with a single 510(k) number
In the device 510(k) endpoint data (downloadable JSON file on OpenFDA), a single 510(k) number is associated with multiple FDA Establishment Identification (FEI) numbers, and I am not being able to ...
0
votes
1answer
102 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?...
0
votes
1answer
103 views
OpenFDA query - wanting one section
I'm rying to eventually populate a spreadsheet with only the dosage_and_administration section for like 2000 medications. I created a query for this:
https://api.fda.gov/drug/label.json?search=...
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 ...
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 ...
1
vote
1answer
56 views
using openfda.brand_name.exact:“Tylenol” case sensitive
I have recently come across openfda.brand_name.exact. It is getting the results where the brand name has to match exactly, i.e. also case sensitive. For example, the query
api.fda.gov/drug/label....
0
votes
1answer
87 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....
1
vote
2answers
42 views
meds not appearing in FDA CDER or medical device DBs
The meds not appearing in either are as follows:
RabAvert
Donnatal
Androxy
The search engine I used for the FDA CDER DB is as follows:
https://www.accessdata.fda.gov/scripts/cder/daf/index.cfm
The ...
