8 votes

List of United States cities

The US Census Bureau also has a national gazeteer file with state and city info, including incorporation information. For metadata/excel file column please have a look at HERE.
ako's user avatar
  • 201
7 votes
Accepted

Searching by disease through openFDA API

I'm Jack Finch with the openFDA team. Looking at what you're trying to do, I'll suggest a couple queries that should satisfy your needs and link you to the appropriate sections of documentation which ...
Jack Finch's user avatar
5 votes

List of United States cities

You might try using data from the Geonames.org database. You can download gazateer data by country from this list. Another potential source is the the MaxMind GeoLite2 dataset.
RyanKDalton's user avatar
4 votes
Accepted

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

I'm not sure what underlying HTTP packages pandas uses, but I found that the default settings of the requests package in python does not work with SSL and this site: import requests url = 'https://...
philshem's user avatar
  • 17.6k
3 votes

Disease and Symptoms Hierarchy

Check Bioportal for an ontology suiting your needs. There are various disease, anatomy and symptom related ontologies out there, which might help you there. Use the European Bioinformatics Institute ...
Grimaldi's user avatar
  • 488
3 votes

Disease and Symptoms Hierarchy

Have a look at the supplementary material of Learning disease relationships from clinical drug trials. disease_mappings10.txt file in the supplementary contains the info you need. For instance, if ...
emre's user avatar
  • 141
3 votes
Accepted

Synchronize with the openFDA S3 bucket

It took quite a while to figure this out myself, so I thought I'd share! The openFDA bucket is Requestor Pays, so you have to enable yourself -- in your amazon account -- to pay for requests to that ...
Darby's user avatar
  • 146
3 votes
Accepted

Adverse Events Reported Term + MEDDRA coding dataset

I'm one the many folks working on Open FDA. We've searched across FDA data sets open to the public and, unfortunately, did not identify one that would meet your requirement at this time.
Denis Krylov's user avatar
3 votes
Accepted

Endpoint not returning expected data based on NDC package code

openFDA has only the NDC codes that are in the National Drug Code Directory. This particular one -- "10135-150-01" -- isn't there, which is why you are getting no results back.
Denis Krylov's user avatar
3 votes

Open FDA - Medical device search -> summary pdf

Most 510K records have the value "Summary" stored in the Summary field. There is no such thing as the "Summary" field. A statement or summary can be provided per 21 CFR 807.3(n) and (o). A 510(k)...
Stanislav Kralin's user avatar
3 votes
Accepted

why doesn't FDA drug list include all meds?

The FDA CDER database, which you linked to, covers small molecule drugs. Monovisc is a medical device, so you'll need to search the medical device database: https://www.accessdata.fda.gov/scripts/...
Yali Friedman DrugPatentWatch's user avatar
3 votes

OpenFDA API Suspension effective 12/20/2019?

I'm Jack with the openFDA Team. The temporary suspension of updates to the openFDA datasets has ended. We're in the process of updating all datasets. Please stay tuned in to the API Status page for ...
Jack Finch's user avatar
3 votes

Unzipping the openfda data in R

Just use for: # unzipping the files temp<-tempfile() for (f in files) { download.file(f,temp) unzip(temp) }
Stanislav Kralin's user avatar
3 votes

New Indications via OpenFDA API

openFDA builds its Drugs@FDA dataset from the downloadable data files at the FDA. Unfortunately, the information you are looking for is currently absent from these files: if you scroll down to the ER ...
Denis Krylov's user avatar
3 votes
Accepted

Ability to link API report back to site

I'm Violet Wren with the openFDA team. The FDA dataset you linked to does not appear to store recall numbers. As such, searching with them will unfortunately yield no results. Your best bet for cross-...
Violet Wren's user avatar
2 votes

Duplicates in device recall data?

If you click on "Recall Event ID" link for Z-3261-2011 recall record, you see two instances on the online database. I have not tried the OpenFDA yet, but our previous analysis of medical device ...
homalm's user avatar
  • 21
2 votes

Setting up a private instance

I suppose it depends on how much re-use you are looking to get. Drug event, run from scratch, takes roughly 24 hours to run and needs around 80GB of space. The initial drug label run can take a long ...
Hans Nelsen's user avatar
2 votes

Getting updated date for all the endpoints through an API

The endpoint for downloads is: https://api.fda.gov/download.json I would log a bug on https://github.com/FDA/open.fda.gov letting them know that the above endpoint should be documented.
Hans Nelsen's user avatar
2 votes
Accepted

Writing a script to mimic openFDA's count query

I would check to make sure that you are processing all of the files. Start by printing out filename variable or len(DATA_FILES). It may be the case that you are missing some downloads. Also, are you ...
Hans Nelsen's user avatar
2 votes
Accepted

openFDA API - ingredient and product name queries give bad results - is it me?

I think you might be using the wrong query syntax for the openFDA API. Try: https://api.fda.gov/drug/label.json?&search=generic_name:hydrocodone Note the : instead of the = in the search value. ...
Mark Silverberg's user avatar
2 votes
Accepted

OpenFDA API - how to query on drug name with more than one word

This query appears to work for a two-word query of "infants tylenol" https://api.fda.gov/drug/label.json?search=brand_name:%22infants%20tylenol%22 %22 is for a double quote and %20 is a space I ...
Mark Silverberg's user avatar
2 votes

openFDA - update notice:: further clarification

I'd recommend checking export_date attribute in this JSON instead. The XML will only show first 1000 of items in the S3 bucket and thus is not reliable.
Denis Krylov's user avatar
2 votes

openFDA endpoints not updated in over 2 months. Has this project been abandoned?

The endpoints were updated on 08/12, and, no, the project is very much active.
Denis Krylov's user avatar
2 votes

Download all drug adverse events

There is limited demographic data in the adverse event records, but the ones that you asked for are on the patient record: patient: { "patientonsetage": "59", "patientonsetageunit": "801", "...
Hans Nelsen's user avatar
2 votes

openFDA: Is There an Open Database of Which Drugs are Approved for the Treatment of Which Illnesses?

You can use Drugs@FDA database: https://www.accessdata.fda.gov/scripts/cder/drugsatfda/index.cfm.
Denis Krylov's user avatar
2 votes

Python crashing when trying to read zipped json files

For those who might get to this question and look for an answer, here is the link to my other post with the answer. https://stackoverflow.com/questions/40824807/reading-zipped-json-files
h.das's user avatar
  • 41
2 votes

How to download all the ophthalmic devices data from device classification end point in openFDA

Simply use limit and skip URL parameters described here.
Denis Krylov's user avatar
2 votes

Determining if drug is generic or brand using NDC

The page that @Stanislav Kralin's comment links to contains a link to the Orange Book page, which provides downloads for ANDA (Abbreviated New Drug Application, i.e. Generics) data and the Orange book ...
Grimaldi's user avatar
  • 488
2 votes

openFDA co-occurring adverse events

Below is an example of a query against the openFDA drug event API that may be close to or approximate what you are looking to do. My query is offered just as an arbitrary example. You would have to ...
emulaire's user avatar
  • 176
2 votes
Accepted

Use Fuzzy Search with OpenFDA API

Sorry, openFDA doesn't currently support searches based on wildcard, fuzziness, regular expression or proximity. To get matching results, there are no reasonable alternatives except to search by the ...
rkg's user avatar
  • 36

Only top scored, non community-wiki answers of a minimum length are eligible