Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [openfda]

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

0
votes
1answer
88 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=...
0
votes
1answer
63 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
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
1answer
26 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....
1
vote
1answer
50 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 ...
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 ...
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
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 ...
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
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 ...
0
votes
1answer
16 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 ...
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
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:[...
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 ...
2
votes
3answers
479 views

Where is the list of fields available through the openFDA API?

I was wondering how to create a query based off the examples, and the main question I have is where do the patient.drug.openfda.pharm_class_epc and patient.reaction.reactionmeddrapt come from? I ...
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
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 ...
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....
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
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
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
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 ...
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 ...
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
2answers
165 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
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 ...
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/...
4
votes
1answer
492 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
88 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
72 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. ...
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 ...
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
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/...
3
votes
2answers
869 views

Get All medicine names

My aim is to give intelligent support to the textbox where the user will type the medicine name that they want, and I will provide suggestions of the medicine. For this purpose, i want to get the ...
2
votes
3answers
226 views

OpenFDA API: Including the skip parameter limit

I was working with the API and trying to paginate the results and I ran into an error which says 'Skip value must 5000 or less'. It would be nice if you guys could add this to your documentation ...
3
votes
1answer
159 views

openFDA: 510k update frequency

How often is openFDA 510k database updated? Through the FDA website I see a new batch of 510k clearances from June 2016. However, openFDA has not been updated since May.
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 > ...
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
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 ...
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": [ "" ], "...
6
votes
4answers
809 views

Disease and Symptoms Hierarchy

I have a huge list of symptoms (1 million rows+ ). I would like to reduce the data by grouping the symptoms. For example, lower abdominal pain and upper abdominal pain into "abdominal pain" category. ...
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
240 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
109 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: ...