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
0 answers
7 views

openfda results in spl_patient_package_insert_table not rendering HTML correctly

I'm accessing the spl_patient_package_insert_table data in the https://api.fda.gov/drug/label.json endpoint. The HTML returned in this field is not rendering correctly in a browser. Does this ...
  • 1
0 votes
0 answers
14 views

Is OpenFDA for Food Recall Enforcement Reports [/food/enforcement] bulk download supports in TLS 1.2 enabled servers?

The bulk download with below link is not working in TLS 1.2 enabled servers. Can someone help me to understand whether OpenFDA bulk download supports in TLS 1.2 enabled servers? Or do I needs to use ...
1 vote
2 answers
33 views

api.fda.gov is failing security check

This server couldn't prove that it's api.fda.gov; its security certificate is from *.fr.cloud.gov. This may be caused by a misconfiguration or an attacker intercepting your connection.
  • 11
1 vote
0 answers
32 views

The 2023-01-02 openFDA recall file is missing searchable fields

The 2023-01-02 openFDA json file (https://open.fda.gov/apis/device/recall/download/) is missing searchable fields. For example, the field cfres_id is missing (was available in the 2022 json files). Is ...
  • 111
1 vote
1 answer
49 views

The openFDA API supports searching by range in date not working?

I would like to create an URL, that shows me all reports from the MAUDE database from December with the product key 'MQB'. I created the this URL as an attempt: https://api.fda.gov/device/recall.json?...
  • 11
0 votes
1 answer
74 views

510(k) summary documents indicated on openFDA are not available from FDA 510(k) database

I have a question regarding the openFDA 510k data: According to the File Layout for Releasable 510(k)s the statement_or_summary entry gives following information: SUMMARY indicates that a summary of ...
  • 115
0 votes
1 answer
73 views

Connection between "Recalls" and "Unique Device Identifier" databases

I would like to easily link a field on the "Unique Device Identifier" database to a field on the "Recalls" database, so I can easily see more information of a device/lead which has ...
0 votes
1 answer
39 views

Drugs@FDA Endpoint - Why is the openFDA field missing from some applications

I'm building a search form using the openFDA API starting with the Drugs@FDA endpoint. In my attempts to find a consistent method and identifiable field to search for drugs I have noticed some ...
0 votes
1 answer
19 views

Query Syntax by Drug Class

I am interested in creating a dataset that only contains that class of drugs. I would prefer being able to search by the drug name, but entries for that field are masked. Does anyone know if I can ...
0 votes
0 answers
27 views

Parsing the Original Files from Maude-Website (DEVICE_EVENT_KEY)

Because sadly OpenFDA is lagging behind currently with the device-events i want to parse the Data directly from FDA-Maude Website ZIP-Files from following Files: https://www.fda.gov/medical-devices/...
1 vote
1 answer
67 views

How to format openFDA API results?

I am able to retrieve the results for a drug from the openFDA via PHP; however the results are just strings of text without any indicators for formatting such as html tags or splitting them up into ...
0 votes
0 answers
22 views

MAUDE Device Events are not present past 4/29/2022

I would like to ask what the cause is for no updates to MAUDE events past 4/29/2022. In the past there has been some delay in new data, but in recent history, it has never lagged by more than a month.
0 votes
1 answer
72 views

How can I list FDA approved drugs in a year? asked again

Does anyone figur this out? How can I list FDA approved drugs in a year? The answer stated the example for the year of 1981, and that call contains [1981-01-01+TO+1981-12-31]. So, I assumed that I ...
0 votes
1 answer
53 views

Device Events for 2022 Q2 are missing

I want to ask why the Maude-Device-Event Files for Q2 are currently not available in the downloads. See: https://open.fda.gov/data/downloads/ It states last updated on 2022-06-23.
  • 101
0 votes
1 answer
75 views

How do I find NDC-level therapeutic equivalency (TE) codes (Orange Book)

FDA Orange Book data contains a column for strength, but it is formatted so differently from the strength columns available in other FDA data (i.e. NDC catalog). Therapeutic equivalency codes (TE ...
0 votes
1 answer
50 views

Why is my API call for drug.active_ingredients.name.exact not working? (Animal and Veterinary endpoint)

I am trying to look up data on the ingredient milbemycin oxime, and I want results that contain only milbemycin oxime as the active ingredient. https://api.fda.gov/animalandveterinary/event.json?...
0 votes
1 answer
44 views

How do I modularize openFDA API requests?

I'm trying to iterate through an excel sheet and find the NDC of a drug from its generic name in each cell in a column so that I don't have to manually type in each generic name. This is what I have ...
0 votes
1 answer
54 views

Is passing an "&" as a string character possible using the openFDA API? If no, is there a way to access data with manufacturer name containing "&"?

I am using the openFDA NDC API. Searching and counting using the "manufacture_name.exact" field results in a status 400 bad request when passing the character "&" as part of ...
  • 3
0 votes
1 answer
95 views

Which API to use to find the information based on NDC code?

I found out that there are two ways to find drug information based on NDC code but I am not quite sure which one to choose. Here is an example NDC API - https://api.fda.gov/drug/ndc.json?search=...
0 votes
1 answer
33 views

Search via NDC api and brand name outputs different results

I was trying to search information about Advil so I tried two ways Search by drug name: https://api.fda.gov/drug/event.json?search=patient.drug.openfda.brand_name:advil Search by ndc code: https://api....
0 votes
1 answer
34 views

Is it possible to have 2 drugs with same NDA number

I am facing a very peculiar issue with the USFDA database. There is one NDA number 050790 corresponding to 2 different drug names viz. Restasis and Restasis multidose! Both the drugs have different ...
1 vote
1 answer
26 views

frequency of data updates in source system

Is the source database for OpenFDA APIs updated on real time with the updates released by FDA? If not, what is the ideal update frequency, particularly for medical devices recalls and classification.
0 votes
1 answer
32 views

Cant Search By NDC String

Hello I know this may be a dumb question but I would like to search for a drug by the NDC like this https://api.fda.gov/drug/ndc.json?search=product_ndc:"54868-4517"&limit=100 but I get ...
  • 1
1 vote
2 answers
82 views

FDA Cosmetics Data

I see that open.fda.gov has data for drugs, food, etc, but I can't find anything about cosmetics (makeup, shampoo etc) recalls. Any ideas?
0 votes
1 answer
27 views

Connecting FDA API to SAP Data Warehouse Cloud

I am trying to connect the Adverse Events API to SAP's Data Warehouse Cloud. I do not know what to enter in the fields, can I please get some advice? FDA Base URL: https://api.fda.gov/device/event....
0 votes
1 answer
30 views

Device recalls - difference between date entry was created in openFDA database and date manufacturer informed about recall

I am using the recalls database to always be aware of the recalls for some specific vendors and products. This is the call I am doing: https://api.fda.gov/device/recall.json?search=recalling_firm:(&...
0 votes
1 answer
32 views

The difference between exact with suffix and without suffix

Can you explain the difference between searching on OpenFDA with the .exact suffix, and without the suffix? I'm a little confused
0 votes
1 answer
14 views

how to modify time range in interactive chat?

Deadlines are always up to date in interactive chat ,for example:i want to query time range between 2015/01/01-2020/01/01.how to modify?
0 votes
1 answer
31 views

FDA Api Issue with Brackets

When I'm making what seems like a working query: https://api.fda.gov/food/enforcement.json?api_key=123&search=report_date:[2021111+TO+20211112] I get an error: [token_mgr_error] token_mgr_error: ...
0 votes
1 answer
34 views

Why are the results of two search statements inconsistent?

https://api.fda.gov/drug/event.json?search=(receivedate:[20040108+TO+20210401])+AND+patient.drug.medicinalproduct:%22IBUPROFEN%22&count=patient.reaction.reactionmeddrapt.exact Using the above ...
1 vote
1 answer
89 views

How can I list FDA approved drugs in a year?

I am trying to list all of the approved drugs in a particular year, (e.g. https://www.fda.gov/drugs/new-drugs-fda-cders-new-molecular-entities-and-new-therapeutic-biological-products/novel-drug-...
0 votes
1 answer
34 views

How to obtain ROR and PRR of an adverse drug event using openFDA

I am writing a paper on adverse reaction mining, and I need to calculate ROR and PRR values of all adverse reactions of a drug. May I ask how to use openFDA to build query statements?
0 votes
1 answer
23 views

Filtering pma dataset for only new PMA decisions (that is, no supplmements)

All - admittedly, a beginner question. I'm looking at the most recent pma json dataset from OpenFDA to understand trends in new applications over time and by geographic location. My first look at ...
2 votes
1 answer
94 views

New Indications via OpenFDA API

Is it possible to access new indication submissions or approvals via the OpenFDA API? I can see the information that I am looking for via the the Drugs@FDA website. For example, the page for Jakafi ...
  • 21
0 votes
1 answer
54 views

Uniquely Identify Items in OpenFDA (MAUDE)

Im downloading and processing the complete data of OpenFDA as described in: https://open.fda.gov/apis/downloads/ https://api.fda.gov/download.json But i could not find a way to uniquely identify the ...
  • 101
0 votes
1 answer
22 views

Is there an identifier that might indicate 505(b)(1) vs 505(b)(2) filing?

I'm skimming through the Drugs@FDA dataset, and I'm wondering if any of the identifiers would tell me which pathway the application went through. Of the options, SubmissionClassCodeID seems most ...
0 votes
1 answer
20 views

No inactive_ingredient field when query for drug substance in Drug Label API

I am looking for the inactive ingredients for a dozen of different drugs. However when querying in the Label API, most results return without an "inactive_ingredient" field. The field only ...
  • 1
0 votes
1 answer
63 views

OpenFDA - Parsing Indications and Dosage Variables

I have a question about parsing two specific variables from the Product Labeling Endpoint on OpenFDA: indications_and_usage dosage_and_administration Ideally I would like to: Extract each ...
0 votes
1 answer
27 views

Combined search query of openfda.generic_name and inactive ingredients only provides info for OTC products?

I think the title explains the question. Im trying to run a query that pull specified legend drug name and specified inactive ingredient. The results only seem to have an inactive ingredient ...
0 votes
1 answer
221 views

Extracting data from OpenFDA using python to save it locally

I have been looking to extract all data from FDA so I can use it all. I created this code below that works but seems it is too much data it fails. This way it just gives me 25000 records. url = '...
0 votes
1 answer
30 views

Q1 2021 Drug Event Endpoint Update

It looks like the Q1 2021 FAERS release was posted on 10-May-2021. Does anyone know when openFDA will refresh its Drug Event endpoint to include the new data? I know this typically occurs once a week, ...
  • 33
1 vote
1 answer
157 views

Can I use openFDA API for Drugs side effects?

Is there any way to get Drugs side effect for specific drug name like Paxil from openFDA API. I read the documentation but don't really understand
0 votes
1 answer
121 views

(Drug API with NDC) Drug name with specified strength & NDC Error

Our website is a platform for patients to consult with physicians and specialists on-demand. The doctors will be able to search for the drug name though the database (NDCID drug database integrated in ...
1 vote
1 answer
52 views

How to know which drug product is a reference listed drug (RLD)?

I trying to figure out how to know which drug product is a reference listed drug (RLD). Let's take for an example following spl_set_id: https://api.fda.gov/drug/drugsfda.json?search=products....
1 vote
1 answer
51 views

Why is my API call for application_number is not working?

#1: https://api.fda.gov/drug/event.json?search=patient.drug.openfda.application_number:ANDA076407 I am trying to make a similar API call to above but for below application# New Drug Application (NDA): ...
0 votes
1 answer
32 views

FDA Press Releases/Announcements

I am looking at the openFDA documentation and I don't see an endpoint to gather all of their press releases/announcements. Can I back into that using the existing api?
0 votes
1 answer
92 views

Given the 510k dataset, how do I derive the location of summary PDFs?

Having ingested the 510k dataset, several of the entries have a statement_or_summary value of "Summary" or "Statement" which I understand means a summary/statement is available. ...
  • 103
1 vote
1 answer
28 views

Error retrieving adverse events by country

I was using a query like this one https://api.fda.gov/drug/event.json?search=patient.drug.medicinalproduct.exact:("ELIQUIS")+AND+receivedate:[20110101+TO+20151231]%27+AND+occurcountry:%27fr%...
  • 11
1 vote
1 answer
73 views

is there a way to fetch only the updated documents in openFDA?

I am using a query like the following one https://api.fda.gov/drug/label.json?search=effective_time:[20110601+TO+20121231]&limit=1 to search for all records with effective_time between Jun 01, ...
  • 11
1 vote
1 answer
95 views

Getting newly approved drugs from any of the Drug API Endpoints

I am looking to build and maintain a database of newly approved oncology drugs from the FDA. I need something similar to their "What's new" or "Novel Drug Approvals" section on ...

1
2 3 4 5
7