Questions tagged [openfda]
Questions and answers surrounding the U.S. Food and Drug Administration's OpenFDA program.
325
questions
1
vote
0
answers
20
views
510(k) Clearance Data Set seems to end as of June 1, 2023
Over the last month or so, I have downloaded the 510(k) dataset several times, and each time it seems to be lacking any 510(k)s decided after June 1, 2023. https://open.fda.gov/apis/device/510k/...
0
votes
1
answer
13
views
Contact open FDA information
We are a team from Asia Taiwan. This center, based in Taiwan, aims to promote international police cooperation and enhance law enforcement capabilities through scientific research and technological ...
0
votes
2
answers
44
views
Discrepancy between MAUDE and API Search Results
Here an update to my previous post with additional details and an answer to the initial response:
Unfortunately the measures listed above did not remedy the problem we are facing. Maybe it would help ...
0
votes
2
answers
36
views
Missing previous month data
We are using below mentioned API to fetch data based on product code and date range:
https://api.fda.gov/device/event.json?search=date_received:[20230927+TO+20231027]AND+device....
0
votes
1
answer
18
views
510(k) openFDA API Data - Missing 510(k)s
I have a question concerning the API dataset for 510(k)s - I noticed that the API data does not incorporate the "subsequent product code" data that is available when searching through the ...
- 1
0
votes
1
answer
13
views
Connection timeout calling open api
We are using below APIs to fetch the data using python but it continues to give us connection timeout and connection forcibly refused error:
https://api.fda.gov/device/event.json
https://api.fda.gov/...
0
votes
1
answer
17
views
Wrong product code in API response
We are using below API to get data for product code "CAN" from 1st may 23 to 30th may 23:
https://api.fda.gov/device/event.json?api_key=T1Hc46PBzj4XxShHdLhmdfilfr9Xpsd1DmpZo0or&search=...
0
votes
3
answers
90
views
Missing certain data in API
We are using the below API to fetch data based on dates:
https://api.fda.gov/device/event.json?api_key=T1Hc46PBzj4XxShHdLhmdfilfr9Xpsd1DmpZo0or&search=date_received:[20230702+TO+20230704]AND+...
0
votes
1
answer
18
views
Comparing new data of drugsfda
How can I effectively compare this extensive dataset with the previous version I downloaded, especially considering that I need to re-download the updated dataset each time it's refreshed?
Furthermore,...
0
votes
1
answer
20
views
way to get new dataset on FDA
Is there a way to know when and what new data set is added to a specific endpoint like drugs/events?
we have last modified for a particuklar endpoint, but I want see what all new data is added ...
0
votes
1
answer
18
views
How do you use the sorting function in OpenFDA for registration listing?
Can you sort "sort=receivedate:desc&limit=10" under the registration listing for product.created_date?
0
votes
0
answers
17
views
API to ITACS to query Entry Number and get the Entry Level Status
Is there an application programming interface (API) to ITACS to query an Entry Number and get the Entry Level Status?
- 1
1
vote
1
answer
22
views
open FDA Recalls API does not have same device class as accessdata.fda.gov
accessdata.fda.gov shows class 1 while api returns "device_class":2
examples
1)Baxter, SIGMA Spectrum
https://api.fda.gov/device/recall.json?search=product_res_number:"Z-0530-2022"&...
- 11
0
votes
1
answer
22
views
Some 510k records with 'statement' value stored in the summary searchable field from openFDA do not have summary information from FDA database
I see there is a searchable field called 'summary_or_statement' from openFDA API to indicate the summary or statement result. However, some records with "statement' value for the ...
- 1
0
votes
1
answer
26
views
Is there a way to extract NCT ID, approval order, post-approval study links from PMA database with openFDA api?
I am wondering if it is possible to add more searchable fields to the openFDA api PMA database such as NCT ID, approval order link and post-approval study link? Or adding something to determine which ...
- 1
0
votes
1
answer
22
views
Ability to link API report back to site
I currently do not see a way to link a result returned from openFDA API to the sites report. For example the recall below does not have a link back to the report on the fda site. Is there a way to ...
- 103
0
votes
1
answer
69
views
mdr text is missing for many report numbers
I am using the below mentioned adverse event device open API url but it is not giving MDR text for many report numbers like 2112667-2023-03226, 2112667-2023-03227, 2112667-2023-03228 etc though the ...
0
votes
1
answer
22
views
Why does device.device_report_product_code require = rather than :?
To successfully search the device/event endpoint for device.device_report_product_code, you must search using = instead of : like this:
https://api.fda.gov/device/event.json?search=device....
- 101
0
votes
1
answer
22
views
FDA API not working since last month
The FDA API is not able to extract data for the month of May and June. The API used in collecting the data for May is given below: 'https://api.fda.gov/device/event.json?search=date_received:[20230501+...
- 1
0
votes
1
answer
20
views
Occurence rates and FAERS data
I had a question regarding rates of occurence in FAERS. According to the FAERS documentation,
Rates of occurrence cannot be established with reports: The number of
suspected reactions in FAERS should ...
- 33
0
votes
1
answer
46
views
Using the openfda API, is there a way to download the 510(k) summary documents using the API? Or simple get the links to those summaries?
I can use the API to determine if a "statement_or_summary" exists. Is there a way to download the 510(k) summary documents, or get links to those documents? I am fine ignoring the documents ...
- 1
1
vote
1
answer
64
views
FDA APIs have data discrepancies
FDA APIs have data discrepancies. Last month and current month, I ran APIs for getting values using the below APIs, but the results were different. Last month it showed 500+ records for my filter, but ...
- 11
0
votes
1
answer
23
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
1
answer
47
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
45
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
1
answer
63
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 ...
- 113
1
vote
1
answer
81
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
116
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
86
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
66
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 ...
- 1
0
votes
1
answer
30
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 ...
- 1
1
vote
1
answer
89
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 ...
- 11
0
votes
1
answer
97
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
61
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
110
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
56
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
67
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
57
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
194
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=...
- 157
0
votes
1
answer
47
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....
- 157
0
votes
1
answer
47
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
38
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.
- 11
0
votes
1
answer
36
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
84
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?
- 23
0
votes
1
answer
28
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....
- 1
0
votes
1
answer
36
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
44
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
- 11
0
votes
1
answer
16
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?
- 11
0
votes
1
answer
35
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: ...
- 31
1
vote
1
answer
40
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 ...
- 11