Stack Exchange Network

Stack Exchange network consists of 175 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.

1
vote
0answers
14 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
12 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
5 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
35 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 ...
0
votes
1answer
4 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
18 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
16 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 ...
0
votes
1answer
21 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?
3
votes
1answer
51 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 ...
0
votes
1answer
23 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
51 views

How can I get the PI Label “Highlights” (or page 1) of the drug's label

Are the "highlight of the prescribing label" available through openFDA?
0
votes
1answer
43 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 ...
1
vote
1answer
36 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
97 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=...
0
votes
1answer
82 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
1answer
16 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
38 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 ...
0
votes
1answer
36 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
36 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-...
1
vote
1answer
22 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
2answers
38 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
22 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
23 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 ...
1
vote
1answer
38 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 ...
0
votes
1answer
24 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 ...
0
votes
1answer
65 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"&...
1
vote
1answer
73 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 ...
1
vote
2answers
34 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
50 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
17 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 ...
1
vote
1answer
46 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
19 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:[...
2
votes
3answers
509 views

Where is the list of fields available through the openFDA API?

I was wondering how to create a query based off the examples, and the main question I have is where do the patient.drug.openfda.pharm_class_epc and patient.reaction.reactionmeddrapt come from? I ...
0
votes
2answers
99 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
2
votes
2answers
84 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 ...
0
votes
1answer
73 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....
2
votes
1answer
42 views

How to decode the company number in the field `header$companynumb`

Is there a lookup table where I can find the names of repackaging or drug manufacturing companies with companynumb reported in the field companynumb? e.g. "companynumb": "200501050" Thanks
1
vote
1answer
77 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
2answers
35 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 ...
0
votes
1answer
66 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 ...
4
votes
1answer
62 views

OpenFDA Bad Zip File?

I have been working to build a download and unzipping "pipeline" going (as a noob) with OpenFDA data, and I saw with interest @h.das' closed post about zips - "Python crashing when trying to read ...
1
vote
1answer
147 views

what is the difference between drugs@fda and openfda?

What is the difference between (drugs@fda or drugs@fda data files) and openfda? Is there a recommended resource to use for drug name lookup?
1
vote
0answers
39 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 ...
2
votes
2answers
210 views

Use Fuzzy Search with OpenFDA API

I want to ask how can I use fuzzy search in openfda api? For example, I am using "panadol" to search something. https://api.fda.gov/drug/label.json?search=brand_name:panadol But sometime I miss ...
1
vote
1answer
54 views

openFDA co-occurring adverse events

Is there a way to query openFDA to get the set of co-occurring adverse events that for a given set of 2 or more drugs for a given indication? For example, What are the adverse events that happen in ...
1
vote
1answer
41 views

Availability of data from 3 specific FDA web pages

I'm looking at the API references for drugs and for devices, but haven't found answers. I'm wondering if it is possible to return the information that is listed on 3 web pages at FDA: Hematology/...
4
votes
1answer
696 views

Determining if drug is generic or brand using NDC

Is there a way to determine if a drug is generic or brand by passing in an NDC (National Drug Code) to the drug label endpoint (https://api.fda.gov/drug/label)?
2
votes
1answer
127 views

Open FDA - Medical device search -> summary pdf

I want to know how to search the PDF files with a search term. Most 510K records have the value "Summary" stored in the Summary field. How can one search the PDF files attached to the summary and ...
3
votes
1answer
84 views

Inflexible search params with open.fda.gov

I'm having the following issues with the Search result limitations with open.fda.gov: Up to 100 results for single request; and up to 5100 results for single search criteria No flexible search (e.g. ...
4
votes
2answers
135 views

Determining a drug's approval status from ClinicalTrials.Gov/chEMBL

I am trying to query these databases and identify trials that passed, and those that didn't. I have gone through and parsed all of ClinicalTrials.gov and matched it to records from chEMBL to build a ...