10 cool queries for Wikidata that will blow your mind. Number 7 will shock you.

Dieser Blogpost ist auch auf Deutsch verfügbar.

Wikidata is an open knowledge base that collects facts (statements) on pieces of knowledge (items). It is run by the Wikimedia Foundation, developed by a team led by Wikimedia Deutschland, and tended and cared for by a global community of volunteers. Unlike Wikipedia, that contains knowledge collected by volunteers written in free form, it is machine-readable and pieces of knowledge and can be queried in relation to each other.

Dozens of application already use the knowledge base. One particularly cool way to access knowledge in Wikidata is through queries in the SPARQL query language. Just a little knowledge of SPARQL goes a long way to query for facts and relationships – thus opening new horizons and rearranging knowledge in a totally new way.

With SPARQL, the possibilities are virtually endless. Follow along for 10 cool queries:

#1 The best cocktail recipes according to Wikidata

No longer sure about the ingredients for your Mojito on a hard day’s night? Wikidata to the rescue! There’s even a picture to go with the list of ingredients. This query is especially impressive as it magically generates a recipe in English. It was conjured up by a Wikidata volunteer known on Twitter as WikidataFacts.

http://tinyurl.com/gqbmzlp

#2 The Internet loves cats. So does Wikidata.

Cats are kind of a big deal on the Internet. But what famous and well-known cats are there in the world? Find out with just one click on Wikidata. We are definitely fans of Humphrey and Larry, both of them bearing the very British title of Chief Mouser to the Cabinet Office.

http://tinyurl.com/z75d4wc

#3 German settlements ending with “-ow” or “-itz”

Where are German towns, villages, and cities located ending in “-ow” or “-itz”? Geography and cultural science buffs may know the answer, but Wikidata will show it to you on a map: It’s basically East Germany with with a few notable exceptions in the North (Olpenitz near Kappeln) and South (Flanitz, a part of Frauenau).

http://tinyurl.com/gtonu2v

#4 The world’s most common surnames

What are the world’s most common surnames? A fun fact that may surprise you. Of course Smith, Miller, and similar (former) names of occupations are in that list, but don’t forget Lee, Liu, and Zhan!

http://tinyurl.com/hodlnmb

#5 Things named after French presidents

Many countries have the custom of naming institutions and buildings after former public officials – France is no exception to that rule. Did you ever want to know what kind of things has been named after former French presidents?

http://tinyurl.com/z654mgk

#6 Awesomely assorted alliterations…

…always acquire accolades. A  SPARQL query in Wikidata can be used to print out all the title of works containing an alliteration. It’s everything from All About Anna to Wild Wild West.

http://tinyurl.com/zdragu9

#7 Horses are dangerous. Especially if you happen to be of noble birth and fall down.

Wikidata can also tell you the cause of death for most noble people. Apparently, horses are dangerous, as the sixth most common cause is “horse fall”.

http://tinyurl.com/jl9et7g

#8 Average gestation period of genera, color-coded by order

Wikidata isn’t only for queries, but also for data visualizations. This biology SPARQL query impressively demonstrates this with a bubble chart.

http://tinyurl.com/hydtknk

#9  The data are alive with the sound of music. But which key is used most often?

A simple query will tell: The most common key is C, then D, then E♭and B♭. The first minor key is on the seventh rank (D minor).

http://tinyurl.com/jo68q9h

#10 Wikidata isn’t only fun and games, but can also be an inspiration for new Wikipedia articles.

Many of the queries we showed may be curious, funny or surprising and yet you may say “What’s in it for me?” If you’re a hardcore Wikipedian who has run out of ideas for new articles, just ask Wikidata for missing articles. One example: Which women born in Suriname are lacking an article in English Wikipedia? Wikidata will tell you!

http://tinyurl.com/h8gdozr

Where to go from here?

There is much more to discover regarding SPARQL. Wikidata has extensive documentation on the topic. If you want, you can turn to the community to request a query. And every Sunday there’s the #SundayQuery hashtag on Twitter for all your SPARQL questions.