Questions tagged [openfda]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
33 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
15 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
0answers
7 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
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
23 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
36 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
64 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
40 views

Is Trade name the 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
2answers
71 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
0answers
28 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 ...
1
vote
0answers
6 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- ...
1
vote
1answer
64 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
36 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
1answer
46 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
0answers
7 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
60 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
20 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
28 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
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 ...
0
votes
1answer
29 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
64 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
57 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
53 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
139 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
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
38 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
109 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=...
1
vote
1answer
106 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
50 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
46 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....
5
votes
3answers
2k views

I get 'certificate verify failed' URLError when trying to download data from openFDA

I'm using Python and pandas to try to download the data in the FDA's 'Adverse drug event reports since 2004'. Here is my code: import pandas as pd import json from pandas.io.json import ...
0
votes
1answer
63 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
32 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
0answers
13 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
1answer
111 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 ...
0
votes
1answer
33 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
14 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
34 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
0answers
51 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
141 views

Get results for partial drug name searches

Currently I can get results for a generic drug name if I use a query like: https://api.fda.gov/drug/label.json?search=generic_name:atorvastatin But is there a way to get results back if the drug ...
1
vote
1answer
90 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
22 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
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
49 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
12 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 ...
9
votes
3answers
3k views

Query medicine descriptions API

I am looking for publicly available API for querying medicine's descriptions. For example, if I supply Carbidopa/Levodopa or Sinemet the expected return data (in json or xml format) is a simple ...
0
votes
1answer
16 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 ...
1
vote
0answers
81 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
108 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 2 3 4 5