Questions tagged [openfda]

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

69 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
142 views

Is there an API for drug approval packages from the FDA?

I am building an application where we'd like to reuse information from drug approval packages (Example). The FDA API does not have a query interface for drug approval packages. Is there an ...
3
votes
0answers
81 views

.How can I get the list of drugs that interact with a particular drug in openFDA

I am trying to get a list of ingredients/drugs that might interact with a particular drug or check if a list of drugs might interact with each other. How can I achieve it using openFDA API.
2
votes
1answer
23 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 ...
2
votes
0answers
68 views

Discrepancy between OpenFDA and FAERS

I noticed there are discrepancies in counts of events for a given drug when querying OpenFDA for a given quarter (I tried q1 2014) and trying to get a matching answer from the downloadable FAERS ...
2
votes
0answers
37 views

Inconsistent fields

This question is related to https://stackoverflow.com/questions/32363315/gson-fields-that-sometimes-are-strings-and-others-arrays I'm parsing json with Gson but I'm struggling with the data I'm ...
2
votes
0answers
34 views

Problem displaying charts in clone of open.fda.gov

I have cloned the open.fda.gov repository and followed instructions to get the site running on my machine. I've been meticulous to install all the ruby and nodejs dependencies, however when jekyll is ...
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
0answers
23 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
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
2answers
37 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
20 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
24 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 ...
1
vote
1answer
27 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 ...
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+...
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 ...
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
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
77 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
0answers
103 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
84 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
70 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
50 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
115 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
42 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
139 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
64 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
29 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
64 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
38 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
20 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, ...
1
vote
1answer
77 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
10 views

Total Product Life Cycle API?

I am unable to find any endpoint(s) to fetch TPLC related details in the OpenFDA website or may be i've overlooked. Is there is an API or other ways to retrieve TPLC related details, could you pls ...
0
votes
1answer
22 views

Device Endpoint - Brand Name Mismatch

When we Query Maude Website for Report Number "2024168-2020-03898", brand name is displayed as “ABSORB BIORESORBABLE VASCULAR SCAFFOLD SYSTEM”. However when we use the device end point and ...
0
votes
1answer
9 views

openFDA API query including “\”

I came across a question. Some of the generic_name contains backward slash sign, for example, CYCLOPHOSPHAMIDE\PREDNISONE\VINCRISTINE. How to construct the API query that can include backward slash ...
0
votes
0answers
6 views

Crosswalk / Equivalence Mapping from HCPCS (Devices) to FDA Product Code

Is there any available mapping between the HCPCS-II codes associated with medical devices and the 3-letter FDA "Product Code"? So to be excruciatingly obvious... The FDA Product Code for ...
0
votes
1answer
6 views

openFDA decision_code field in PMA device API endpoint

I downloaded the PMA devices dataset from here https://download.open.fda.gov/device/pma/device-pma-0001-of-0001.json.zip However, It seems like the denied filings were not included since the ...
0
votes
1answer
9 views

Need help for Constructing Query String - device/event.json endpoint

I'm trying to get all the filters working for Maude DB via device/event.json endpoint. URL : https://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfMAUDE/Search.cfm The Filter in the website Brand Name ...
0
votes
1answer
8 views

Missing pma_number in classification endpoint Aug2020 release

I downloaded the device classification dataset from here: https://open.fda.gov/apis/device/classification/download/ Despite being listed in the searchable fields in the documentation, the openFDA ...
0
votes
1answer
22 views

How would one leverage the OpenFDA API to obtain listing of all recalls associated with a specific CIED?

How would one leverage the OpenFDA API to obtain listing of all recalls associated with a specific CIED? We have limited info on each device such as the model of implanted device and serial number. ...
0
votes
1answer
8 views

openfda: query to obtain links to 510(k) summaries

Using the api for the 510(k) database in openfda, I can search the statement_or_summary field and find all the rows (i.e. devices) with summaries. But in the download, the api just produces the ...
0
votes
1answer
10 views

API returns code not found

For a number of codes found in the National Drug Code directory the API returns code not found. https://www.accessdata.fda.gov/scripts/cder/ndc/index.cfm I have reviewed the API documentation and ...
0
votes
1answer
12 views

How to know ATC Class 1-5 of a drug name in OpenFDA data

I am trying to use OpenFDA open-source data so that I can know ATC Class 1-5 of a drug name and the disease it can be used to treat for?
0
votes
1answer
31 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
15 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
37 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
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 ...