Questions tagged [openfda]
Questions and answers surrounding the U.S. Food and Drug Administration's OpenFDA program.
1
vote
2answers
30 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
31 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
25 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
32 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
0answers
23 views
OpenFDA - SSL Certificate - short validity dates
Is there a way to obtain an SSL Certificate for use with OpenFDA which would have a validity longer than 90 days? We have developed a small query using the OpenFDA API within our corporate ...
1
vote
1answer
22 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
17 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:[...
1
vote
1answer
47 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 ...
0
votes
0answers
11 views
Statistics about the number of moocs
I'm interested in the growth of MOOCs offering by year, I have founf this report:
https://www.class-central.com/report/mooc-stats-2017/
Made by class central, which is quite good, but I wloud like ...
0
votes
1answer
15 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 ...
0
votes
1answer
58 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
86 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=...
3
votes
1answer
43 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 ...
2
votes
2answers
50 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 ...
1
vote
1answer
37 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
58 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....
1
vote
2answers
29 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
59 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 ...
0
votes
0answers
18 views
CA School Board Directory (district level)
Does anyone know where I can a directory of all school board members in California?
1
vote
1answer
134 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
38 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
1answer
37 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
2
votes
2answers
164 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
71 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
1answer
47 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 ...
4
votes
1answer
484 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
87 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 ...
2
votes
1answer
71 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. ...
1
vote
1answer
39 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/...
0
votes
1answer
46 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?
1
vote
0answers
51 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, ...
0
votes
0answers
70 views
Missing reports in OpenFDA
I found some missing reports in OpenFDA service and I'm trying to understand the reason.
I loaded two AERS dumps for 2012q3:
ascii - AdverseDrugEffects/UCM337616.zip
sgml - AdverseDrugEffects/...
0
votes
2answers
94 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
1
vote
0answers
15 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
1answer
130 views
Accessing raw OpenFDA data for visualizations
Is there a way to connect a Tableau Web Data Connector to the data on the OpenFDA API?
1
vote
1answer
95 views
How to openFDA Query data from 2014 to present?
I was looking through the openFDA API and have been trying to find a good way to get data from the start of 2014 to now. Unfortunately it appears the downloads only go to 01-25-16. I also ran a query ...
4
votes
1answer
59 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 ...
4
votes
2answers
127 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 ...
6
votes
1answer
203 views
Searching by disease through openFDA API
I'm trying to query for all drugs related to a certain disease group (say, for example testicular cancer). How would I structure that query? is this possible?
1
vote
1answer
36 views
Device events has duplicating patient records
It seems that in the https://open.fda.gov/device/event/ the patients have duplicated records.
"patient": [
{
"sequence_number_treatment": [
""
],
"...
2
votes
1answer
81 views
How to download all the ophthalmic devices data from device classification end point in openFDA
The API call
https://api.fda.gov/device/classification.json?search=medical_specialty_description=%22ophthalmic%22
is returning (limiting) the number of records to 1 for ophthalmic devices data. I ...
2
votes
1answer
97 views
OPenFDA API - querying on dosage_and_administration_table _exists_ not working
I was planning to get the results where brand name is aspirin and whose drug result has property dosage_and_administration_table.
So I did this
https://api.fda.gov/drug/label.json?search=brand_name:...
1
vote
1answer
125 views
Running openFDA api locally
I am trying to do some classification and clustering on the openFDA dataset. I started by downloading a year's worth of data and realized I run into system limits and would need to solve for that.
...
1
vote
1answer
239 views
Python crashing when trying to read zipped json files [closed]
I downloaded the 2015 adverse drug events data from openfda and I want to run some analysis with python. I am a python newbie, but have become comfortable with the scikit-learn libraries, but I cannot ...
3
votes
1answer
107 views
Query OpenFDA by UPC
I am trying to query OpenFDA by UPC but the API keeps returning "No Matched Found". I assume this works in the same way as product NDC, which is returning as expected when I try something like this:
...
3
votes
1answer
55 views
Endpoint not returning expected data based on NDC package code
I recently stumbled upon openFDA and it seems to be the perfect answer for relaying drug brand name information to our users based on a provided NDC code. The issue I am running into however is that ...
2
votes
1answer
285 views
Is there a way to query openFDA for drug pair interaction?
openFDA is awesome particularly the drug/event database. But I can't find a way to query whether a particular drug (e.g. xanax) has any drug interaction warning, precaution, or contraindication. ...
3
votes
1answer
76 views
Adverse Events Reported Term + MEDDRA coding dataset
I just wanted to kindly ask if anyone is aware about the presence of a repository of datasets containing both the Reported Term (usually collected in the CRF as free text by the investigator) and its ...
1
vote
1answer
21 views
is there a search class for whether the drug was taken in hospital or not?
is there a search class in open FDA Drug Adverse Event Report Browser for whether the drug was taken in hospital or not?
2
votes
2answers
146 views
openFDA: Is There an Open Database of Which Drugs are Approved for the Treatment of Which Illnesses?
Is there an open database which lists FDA or EMA approvals of drugs for the treatment of specific illnesses?
