Hot answers tagged

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
6 votes
Accepted

List of United States cities

I have a CSV file you can download that lists all US cities by state. The data was compiled from the US Census 2013 Gazetteer. http://www.opengeocode.org/download.php#statecity In case you must ...
Andrew - OpenGeoCode'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

Comparing FDA drug data with other countries

This is perhaps a bit late, but I'm interested in this as well and have made some progress. With respect to drugs, the WHO has a lookup service for ATC codes: http://www.whocc.no/atc_ddd_index/ ...
user2997319's user avatar
4 votes
Accepted

OpenFDA report_date for Food/Enforcement doesn't seem to work after 9/23/2015

Thanks for catching this one. It is true for all of the enforcement endpoints (food, drug and device). The link on the FDA that we are crawling is dead (it hangs). There is a bug in pipeline code ...
Hans Nelsen'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

Can someone explain "openfda data is not for clinical use"?

Basically, the data can't be considered "complete" and thus trustworthy. Most of the information contained there comes from sources that need to handle their data really carefully. Consider drug ...
Diego's user avatar
  • 191
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

API for getting data from a disease name?

Have you tried a Wolfram Alpha search. There is a lot of information there. Wolfram|Alpha: lung adenocarcinoma You can get this information in Mathematica as well for analysis by using the ...
Edmund's user avatar
  • 387
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

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 Device Adverse Events missing for Dec, 2015 (as of 19-Jan-2016)

The data that powers that particular API is only available on a quarterly basis and is currently only available through Q3 of 2015. http://www.fda.gov/Drugs/GuidanceComplianceRegulatoryInformation/...
Hans Nelsen'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

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

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 - 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 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

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

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