Nicolas Raoul
  • Member for 8 years, 7 months
  • Last seen more than a week ago
How to include sub-classes in a Wikidata SPARQL query? (example: when querying "bands", include "rock bands")
Accepted answer
13 votes

The right expression to use here is p:P31/ps:P31/wdt:P279*. Explanation: p:P31/ps:P31 means instance of, or instance of not marked as preferred. Only using p:P31 at this step would miss some ...

View answer
Downloadable smartphones data (name, specs)
11 votes

In the future, Wikidata will be the best, but for now, the most pragmatic solution is to use DBpedia. Go to the Smartphone page of DBpedia Scroll to the is dbpprop:type of section On the right is a ...

View answer
Dataset of sentences translated into many languages
Accepted answer
9 votes

Tatoeba.org is exactly that: http://tatoeba.org Their data is human-edited and used by dozens of products/websites including electronic dictionaries, so it is of reasonable quality. It has 471468 ...

View answer
Mapping Business Hours
8 votes

This CSV dataset contains opening-closing hours for thousands of US hotels/restaurants/bars/museums/etc: https://github.com/baturin/wikivoyage-listings/ Business type, name and location are included ...

View answer
Are there free APIs for searching news articles that I can use to collect trend data in news coverage?
8 votes

Nearly all newspapers have all kinds of license constraints, making exploitation a legal headache, but there is a welcome exception: https://en.wikinews.org All of the Wikinews content is available ...

View answer
Coordinates of all embassies and consulates
7 votes

Wikidata has a lot of data about embassies and consulates. I created a Python+SPARQL script that pulls that data and maintains an easy-to-consume CSV file. You can download the CSV file at https://...

View answer
Where to download decimals of Pi?
7 votes

UPDATE: Unfortunately this website is not available anymore, see philshem's comments below for a potential? workaround. This Japanese site has downloadable chunks up to 13x10^12: Web site: http://...

View answer
How to get list of all items that have a particular property, in Wikidata?
7 votes

While not the most script-friendly, here is the easiest/fastest way to get what you want without any third-party: 1) Go to the Wikidata page of the property 2) Click What links here in the left ...

View answer
Database of fictional characters?
6 votes

Wikidata contains 158752 fictional characters, you can get them using this query: SELECT ?item ?itemLabel WHERE { # Item's type is: fictional character, or sub-type, or sub-sub-type, etc ?item p:...

View answer
List of iOS and/or Android apps
6 votes

F-Droid is a repository of Android apps. All data is open source and freely reusable, including app names. The app names can be extracted from the XML file https://f-droid.org/repo/index.xml by ...

View answer
Does data stored in Mendeley qualify as open data?
6 votes

Data Mendeley does not seem to grant me any license to reuse the content (in particular the academic papers uploaded by other users), so by default the data must be considered closed: We are not ...

View answer
Domain Name System Record A database
Accepted answer
5 votes

The DNS Census 2013 is an attempt to provide a public dataset of registered domains and DNS records. The torrent is about 15 GB (uncompressed: 157 GB). I am pretty sure it contains domain names and ...

View answer
What decentralized open data project has the most contributors?
Accepted answer
5 votes

I would say Wikipedia, with 21,436,641 named editors (and more anonymous editors), but there might be bigger projects. The only other hard-numbers references I could find are the Ohloh project, which ...

View answer
Open Address Data for Restaurants
5 votes

Wikivoyage has open data about restaurants and bars, worldwide, pretty up-to-date. The data is licensed under Creative Commons Attribution/Share-Alike. The format is like this: {{eat | name=Atelier ...

View answer
Looking for audio data set for English words
4 votes

Lingua Libre has a lot of pronunciation recordings, including in English, by many speakers: https://lingualibre.org https://commons.wikimedia.org/wiki/Category:Lingua_Libre_pronunciation-eng https://...

View answer
How to output the description of Wikidata items using SPARQL?
4 votes

Include SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } inside your WHERE clause Append the magic string Label and Description to the variable names of your SELECT For instance, if ...

View answer
Database of French companies
4 votes

You can use the SIRENE database, maintained by INSEE, part of the French government. It is the official companies database, and has about 10 millions. It is updated everyday. It used to cost money, ...

View answer
Wikidata label language: How to fallback to ANY language?
Accepted answer
4 votes

As optional get the label in English and in any language, then coalesce: SELECT ?item (SAMPLE(COALESCE(?en_label, ?item_label)) as ?label) WHERE { ?item wdt:P31 wd:Q22674925 . OPTIONAL {?item ...

View answer
Longman English Dictionary Database
Accepted answer
4 votes

This particular dictionary's legal notice says that: Users are not entitled to [...] transmit [..] it on any other website without the express permission of Pearson. You must not use data mining, ...

View answer
What data formats that can be published on the first level (1 star) of open data?
4 votes

For level 1, any format is fine. Even a picture of data written on a sheet of paper is OK. That's because level 1 is only about web availability and license. So, yes, any format: PDF, XLS, CSV, JPG, ...

View answer
Popularity of given names through the ages
4 votes

For the USA, the Social Security Administration has statistics going back to 1880. The whole national data is downloadable in a ZIP file available for download at http://www.ssa.gov/OACT/babynames/...

View answer
Database of all mailing addresses in France, and their coordinates
4 votes

The French government has just launched a national open database that aims to contain all currently valid addresses: http://adresse.data.gouv.fr It is a collaboration between the government, the ...

View answer
Public transport maps for all cities
4 votes

Wikimedia Commons has a repository of public transport maps: https://commons.wikimedia.org/wiki/Category:Public_transport_maps The maps are available under various license, but are at least ...

View answer
Is there any dataset for problems common people are facing to build apps against?
4 votes

Look at the Unanswered Questions at Software Recommendations. Many are open data app ideas waiting for an implementer. Also, travel is something that most people do from time to time, and it often ...

View answer
Find all Wikidata items that use a particular P18 picture
3 votes

As pointed out by Stanislav Kralin, here is the correct query: SELECT ?item WHERE { ?item wdt:P18 <http://commons.wikimedia.org/wiki/Special:FilePath/Gthumb.svg>. }

View answer
Does this violate copyright of music/lyrics/sound?
Accepted answer
3 votes

As long as you don't keep the song anywhere on your servers, and have clear warnings "Do not transform songs that you are not allowed to transform", I believe you don't risk that much. You are just an ...

View answer
Icons set to represent Wikidata classes (hospital, park, waterfall, prison, school, etc)
3 votes

Based on ubahnverleih's tip, and due to the current lack of such an icon set, I created this project: https://github.com/nicolas-raoul/Icons-for-Wikidata I re-used the excellent Open-SVG-Map-Icons ...

View answer
Historical Mobile App Rankings/Downloads and Prices
3 votes

I have shared the statistics of my 2 million+ downloads app here: https://github.com/nicolas-raoul/google-play-statistics Data available: Installs/uninstalls/ratings/crashes data by country/language/...

View answer
Looking for web scraper that works on YouTube channel video catalogs
3 votes

On Linux use youtube-dl command to download videos straight off of YouTube. To install youtube-dl run sudo pip install youtube-dl To download an entire channel: youtube-dl -citw ytuser:<USER> ...

View answer
Employment density in the USA (Employees per sq. ft. by industry)
3 votes

The Smart Location Database by the EPA includes, among other things, gross employment density (jobs per acre) on unprotected land. It breaks it up by categories like Retail, Office, Industrial, etc.

View answer