Hot answers tagged

8 votes

Where can I download those bible verses in JSON or XML or SQL formatted file?

Disclaimer: I am the author of below github projects. Two very good (and complete) sources are: https://github.com/scrollmapper/bible_databases : This has many database formats including all ...
Leo Blanchette's user avatar
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
7 votes

Any Open (Structured) Datasets for the World Factbook (Public Domain Country Profiles Published by the CIA)?

You can use factbook for data. A simple google search can get you raw json or csv. Officially you can use their tool : https://github.com/factbook/factbook or download data directly from CIA ...
Madhurendra Sachan's user avatar
7 votes

Wikipedia table to JSON (or other machine-readable format)

The wikitextparser Python module has good support for converting tables into structured formats. Example: import wikitextparser as wtp import requests import json r = requests.get('http://en....
maxschlepzig's user avatar
6 votes

designing a vocabulary / ontology where classes have fixed constraints

Based on my research into this topic there appears to be two reasonable solutions. Perhaps one solution is more reasonable then the other. One key is to recognize that constraints exist as a concept ...
James Hudson's user avatar
5 votes

What Linked Data serialization format to choose for our (now CSV) open data?

In order to make it into Linked Data and be easily reusable by as many mashups/apps/etc as possible.. It seems you are talking about RDF dumps, but there are other ways to provide access to RDF data, ...
Stanislav Kralin's user avatar
5 votes
Accepted

Getting influences / influencedBy data from DBpedia

Using this SPARQL end-point: http://dbpedia.org/sparql you can enter this query: SELECT DISTINCT ?YA ?A ?YB ?B where { ?A dbo:influenced ?B. ?A a dbo:Philosopher. ?B a dbo:Philosopher. ?A dbo:...
Bolo's user avatar
  • 238
4 votes

Any Open (Structured) Datasets for the World Factbook (Public Domain Country Profiles Published by the CIA)?

For factbook data which has been parsed into numbers / arrays etc (unlike any existing projects which store all values as strings) have a look at https://github.com/iancoleman/cia_world_factbook_api#...
iancoleman'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

College Scorecard API call returns all data in .json but only two fields in .csv

Many apologies for this issue, and also for this slow response. Open Data Maker hasn't had much work done on it recently, but we're currently in the process of transitioning it to new maintainers. ...
yoz's user avatar
  • 141
3 votes

How can I download the complete Wikidata database?

As you already found out the Dumps of wikidata are readily available and can be downloaded and unzipped in a few hours. Getting a proper RDF database server running with such dumps is another story. ...
Wolfgang Fahl's user avatar
3 votes

Wikipedia table to JSON (or other machine-readable format)

Sometimes it pays off to look one step ahead, i.e. to check if the items and its properties represented by a Wikipedia table are also available in the Wikidata knowledge base. Depending on the data, ...
maxschlepzig'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
2 votes

Any uses of JSON-LD?

Current statistics: as of March 2020, JSON-LD is used by ~30% of all the websites. https://w3techs.com/technologies/details/da-jsonld/all/all (compare https://w3techs.com/technologies/...
Stanislav Kralin's user avatar
2 votes

Any uses of JSON-LD?

Our team is working on the idea of the Semantic Web based on JSON-LD. Since you are interested in this format, you may be interested in learning about the project as well. WRIO Internet OS — All You ...
Alexey Anshakov's user avatar
2 votes

Where can I download those bible verses in JSON or XML or SQL formatted file?

https://github.com/godlytalias/Bible-Database also have a good database collection
Digin's user avatar
  • 27
2 votes

What Linked Data serialization format to choose for our (now CSV) open data?

I would suggest just uploading it to https://data.world (disclaimer: I work there, but it's free). It's easy for other users to get it in a few different ways (whether it's a download, API, or a ...
scuttlemonkey's user avatar
2 votes

Is there a vocabulary for linking weather data?

Meteo is out there: http://purl.org/ns/meteo. I have no idea how well-used it is.
Charles's user avatar
  • 161
2 votes

Good easy to use api with a dataset for exam

The Internet Archive One of the single biggest fully open data repositories on this planet. To cite their About page: Today our archive contains: 279 billion web pages 11 million books ...
ojdo's user avatar
  • 2,804
2 votes

Syntax error when the developer friendly name starts with a number

The problem was with the way I tried to access that property. Since the key name starts with a number, I need to use brackets. This expression works. obj.results[0][2017].admissions.sat_scores["...
Jeff's user avatar
  • 31
1 vote
Accepted

Testing my code with NoSQL Telecom data

It's not a big dataset, but you can use Telecommunications Towers and Antennas Connecticut General Statutes §16-50dd requires the Connecticut Siting Council to develop, maintain and update on a ...
philshem's user avatar
  • 17.6k
1 vote

Free, Limitless GeoJSON APIs for nation shapes?

Although not an API, there are hosts of GeoJSON with quite a small size, for example, 251 KB: https://github.com/johan/world.geo.json/blob/master/countries.geo.json raw data: https://raw....
philshem's user avatar
  • 17.6k
1 vote
Accepted

Vocabulary alignment in LDflex

The long-term answer here is reasoning based on ontologies. A JSON-LD context alone indeed won't get us there. However, the ontological equivalence between foaf:name and schema:name can allow the ...
Ruben Verborgh's user avatar
1 vote

KEEPA API Experience

I’m assuming you’re looking for something to make this api work easier, rather than resorting to hand coding. I would suggest Talend’s Data Services Platform. I think Talend is the best tool around; ...
Christopher Klaus's user avatar
1 vote

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

I would try to do a request of the data first. import requests json_df = pd.read_json(requests.get(url).json())
Hans Nelsen's user avatar
1 vote

Getting drug register information through API

I am not sure if these are the data for which you are looking. There is not an API of which I am aware. It would not be unreasonable to ask the openFDA team to add the following dataset: http://www....
Hans Nelsen's user avatar
1 vote

Dataset of World Cities, Counties, Localities, Provinces, and States?

You can find the answers to your questions in the following links; the second question's title is specific, but you can use the geocoders in the answers to get the desired results: List of Cities ...
albert's user avatar
  • 11.9k
1 vote
Accepted

OPenFDA API - querying on dosage_and_administration_table _exists_ not working

I have looked at the openFDA code: it appears dosage_and_administration_table element is explicitly excluded from indexing in Elasticsearch along with a bunch of other table elements, which is why you ...
Denis Krylov's user avatar
1 vote

Is there a way to query openFDA for drug pair interaction?

Unfortunately, Open FDA cannot assess safety of a particular drug interaction. To see if a drug has any interaction warnings, precaution, or contraindication, you can query the Drug Label API and ...
Denis Krylov's user avatar
1 vote

Is there anyway to get the NDC code for a drug from the drug enforcement report fields?

This page explains that in about half of enforcement reports, there is a special openfda section that has identifiers (like the NDC) for the drug involved in the recall. https://open.fda.gov/drug/...
Adam's user avatar
  • 316

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