Hot answers tagged

12

Wikidata RDF dumps have been available since 3-Aug-2013. http://www.mail-archive.com/wikidata-l@lists.wikimedia.org/msg02553.html If you're interested in topics related to Wikidata, I'd suggest subscribing to their mailing list. Of course, both Freebase and DBpedia have had much larger dumps available for years.


9

In addition to @enridaga's great answer, let me offer a few additional thoughts. RDFa is (only) useful if you already have HTML content that you want to enrich with semantic data. RDF/XML is very well readable for machines, but not so much for humans. N-Triples, Turtle or N3 are currently pretty much the default formats for Linked Data dumps. For example, ...


8

So you have a CSV file and you want to publish it as linked data in a RDF format, not CSV. The core part of the work here is the translation to RDF, that implies, as @andrew-opengeocode suggested in his answer, that you find one or more RDF ontologies/vocabularies that define terms you can reuse to model your data. The more popular are the terms you reuse, ...


7

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 website : https://www.cia.gov/library/publications/download/ Previous answer : The links are dead - looks like data has been removed without any notice. Check ...


7

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 explains how it works. If you just want a list of drugs which are related to a specific disease (or any other text string, for that matter), you can search for ...


6

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.wikipedia.org/w/index.php?title=' + 'List_of_country_calling_codes&action=raw') wt = wtp.parse(r.text) print(json.dumps({'root': wt.tables[1].getdata()[0:3]}, ...


6

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 three formats you are inquiring of. https://github.com/scrollmapper/bible_databases_deuterocanonical : This is a newer continuance of the bible databases, but ...


6

The current OpenFDA Adverse Event dataset isn't really well suited for a query like that. An API for the drug SPLs (Structured Product Labels) is coming soon according to https://open.fda.gov/about/ though. For now, check out the following resources for the data you're looking for: NLM Pillbox API (http://pillbox.nlm.nih.gov) - recommended - most developer ...


6

The two links below are NOAA/NWS weather terms used in their datasets: This document is the vocabulary for the annual summaries: http://www1.ncdc.noaa.gov/pub/data/cdo/documentation/ANNUAL_documentation.pdf This document is the vocabulary for the daily summaries http://www1.ncdc.noaa.gov/pub/data/cdo/documentation/GHCND_documentation.pdf These are a ...


6

If you mean Hydra-based Web APIs that closely resemble current JSON-based APIs, than I guess the answer is that no "significant site or project" has published anything production ready yet. Quite of a few people and a handful of startups mentioned that they are working on it. If, on the other hand, you include Triple Pattern Fragment servers, which are based ...


5

We (met.no) plan on publishing a JSON-LD vocabulary for climate/weather data, when we release our public portal later this year. We'll be publishing JSON-LD ourselves as our primary data format. To the best of my knowledge, there isn't anything else stable out there yet suitable for this kind of use. The closest you get, AFAIK, is http://codes.wmo.int/


5

The common vocabulary for weather data is the Weather Exchange Model (WXXM). Read more here: https://wiki.ucar.edu/display/NNEWD/WXXM


5

Depending on your use-case Wikidata toolkit is a Java tool that allows you to iterate over all the items in a dump. In fact it auto-downloads the latest dump and translates the entire model into Java objects. This means everything is abstracted and you just have to write the call-back to be applied to each item. I wrote a tutorial on how to use it in ...


5

Here's my 2 cents. Since your data is already in CSV format, the fastest way to add semantic context is to use ODI's 'Linked CSV' format: (http://jenit.github.io/linked-csv/). You will need to pick a vocabulary. Without knowing about your data, I would start by looking at existing [semi]standardized data vocabularies. For example, a large number of datasets ...


5

First off, you can use CSV as a Linked Open Data (LOD) serialization format. This has been the case since 2009 (early days of LOD cloud, demonstrated via DBpedia; just look in the footer of any of DBpedia's entity description pages). There's even a Linked CSV draft spect in regards to this matter (there are even CSV Browsers). The only downside is that ...


5

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, at least the following: SPARQL endpoint, URI dereferencing. These ways are more convenient for the goals you are trying to achieve. We have open data as a ...


5

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:birthYear ?YSA. ?B dbo:birthYear ?YSB. BIND( SUBSTR( xsd:string(?YSA), 1, 4) AS ?YA ) BIND( SUBSTR( xsd:string(?YSB), 1, 4) AS ?YB ) } LIMIT 10000 which ...


5

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 outside of the instance of a class and should be outside of the actual instance data. The first solution is to adopt SHACL. It is a W3C recommendation and ...


4

Should these help you ! Bibles in JSON & XML Bibles versions in SQL format


4

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#data There's some explanation of the project at https://iancoleman.github.io/exploring-the-cia-world-factbook/ Disclaimer: I am the maintainer of that project.


4

I wrote some software awhile back ago that parses many of the WFB web pages and converted the data into CSV files. You can find them here: http://www.opengeocode.org/cude1.1/CIA/WFB/index.php


4

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://api.fda.gov/drug/event.json?' print requests.get(url) gives an error like: requests.exceptions.SSLError: [Errno 1] _ssl.c:504: error:14090086:SSL routines:...


3

Joe, we don't support CSV downloads for the time being. Drug adverse event data is highly relational, a format that does not easily lend itself to being represented in a format like CSV. For instance, a given record may have 5-10 different drugs associated with it and an additional 5-10 different reactions, each of which all have their own additional ...


3

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, instead of parsing the wiki text table, it might be easier to query Wikidata for that data. As an example, when trying to extract - say - country calling codes ...


3

This site used JSON-LD to markup their recipes and successfully got rich snippets in Google: http://gracessweetlife.com/2010/06/cannoli-siciliani-the-ultimate-italian-pastry/ Example query: https://www.google.pt/?gfe_rd=cr&ei=ikWyVdPPOLLj8wfKrIyABg&gws_rd=ssl#q=grace%27s+cannoli+and+cannoli+filling+recipe A very important move forward in terms of ...


3

Additionally to what is described in other answers, there is a Wikidata RDF dump which is used for the Wikidata query service. The format is described in RDF data format article.


3

Max Klein describes three ways of getting the data at 3 Ways To Access Wikidata Data Until It Can Be Done Properly. Not mentioned is the WDA tool.


3

They way openFDA stands, it is an API which returns JSON for a search. I too have asked for bulk downloads. The information you seem to be looking for is available by modifying the following API call: https://api.fda.gov/drug/event.json?search=patient.drug.openfda.brand_name:advil&count=patient.reaction.reactionmeddrapt.exact&limit=1000 If you are ...


3

There is no way to make the connection you seek using the data in the openFDA drug adverse events API. Reports include all suspected adverse reactions, and all known drugs the patient was taking. While the classification of drugs as suspect or concomitant may be helpful, it is not always present, and it is often impossible to know which drug caused a ...


3

Your sample data as well as the provided list of country codes are valid JavaScript, but they are not JSON. To make them valid JSON, put all strings in double quotes: [ {"name": "Afghanistan", "code": "AF"}, {"name": "Albania", "code": "AL"} ] This answer on StackOverflow gives a nice overview of the differences between JavaScript and JSON. ...


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