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.
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 ...
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 ...
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.
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/
...
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 ...
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://...
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 ...
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 ...
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 ...
3
votes
Can someone explain "openfda data is not for clinical use"?
openFDA is not for clinical use since it is a research project still in beta. Additional details can be found on the about page:
https://open.fda.gov/about/
If you need labeling information for ...
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 ...
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 ...
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.
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.
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)...
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/...
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 ...
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)
}
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 ...
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-...
2
votes
How can I access FDA drug and medical device recall data from 1970 to 2014?
The process isn't as nice as the API at openFDA, but you can always file a Freedom of Information Act request: http://www.fda.gov/RegulatoryInformation/FOI/HowtoMakeaFOIARequest/
2
votes
list of approved active ingredients
It seems like your idea is possible using openFDA (or dailymed data which is where openFDA gets their SPL, Structured Product Label, data, I think), but it's not going to be necessarily easy.
You ...
2
votes
How quickly after FDA approval will adverse events be listed on openFDA?
In the past, the public data, which is the basis of the openFDA API, lagged about a year behind. Great improvements have been made this last year and we are starting to see that data within 3 months. ...
2
votes
openFDA Device Adverse Events Data out of date
My apologies, I posted a response earlier that was speaking about the status of the /drug/event.json API when your question is about the /device/event.json
The /device/event.json API is currently out ...
2
votes
Is there a openFDA Data Pipeline version supported for Windows?
We have not heard of anyone running the openFDA data pipeline on Windows. That being said, it should in theory be possible since we are using open source tools that work across platforms. If you ...
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/...
2
votes
Get results for partial drug name searches
Unfortunately, we do not support partial or ngram search. The search tool that we use forces us to decide between different tokenization approaches (whitespace, word, ngram, et al.). We decided ...
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",
"...
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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
openfda × 325api × 96
data.gov × 22
drugs × 22
data-request × 20
medical × 20
json × 18
uses-of-open-data × 13
government × 6
python × 6
usa × 5
download × 4
releasing-data × 3
database × 3
data-format × 3
programming × 2
healthcare-finder-api × 2
disease × 2
geospatial × 1
city × 1
time-series × 1
products × 1
covid19 × 1
parsing × 1
excel × 1