Wikidata:Weekly query examples/2016

2015

2016

2017

2018

2019

2020

2021

2022

2023

2024

Wikidata weekly query #191

From Wikidata Status update of 09 JANUARY 2016

Wikidata weekly query #192

From Wikidata Status update of 16 JANUARY 2016

Wikidata weekly query #193

From Wikidata Status update of 23 JANUARY 2016

• List of countries by age of the head of government

Wikidata weekly query #194

From Wikidata Status update of 30 JANUARY 2016

• horses
• French sculptors by year of birth

Wikidata weekly query #195

From Wikidata Status update of 06 FEBRUARY 2016

Wikidata weekly query #196

From Wikidata Status update of 13 FEBRUARY 2016

Wikidata weekly query #197

From Wikidata Status update of 20 FEBRUARY 2016

• natural numbers

Wikidata weekly query #198

From Wikidata Status update of 27 FEBRUARY 2016

• battles

Wikidata weekly query #199

From Wikidata Status update of 05 MARCH 2016

• French heads of government by length of service,
• Metro stations in Paris

Wikidata weekly query #200

From Wikidata Status update of 12 MARCH 2016

• Number of museums by U. S. state on map,
• Film directors ranked by number of sitelinks multiplied by their number of films,
• all museums in Barcelona with coordinates,
• women mushers,
• women scientists,
• women artists,
• air accidents,
• Twitter accounts of biologists,
• torture devices
• public art in Paris,
• Locations of Pablo Picasso works

Wikidata weekly query #201

From Wikidata Status update of 19 MARCH 2016

• distribution of public art by place

Wikidata weekly query #202

From Wikidata Status update of 26 MARCH 2016

• Library and Information Science journals,
• number of statements backed by a reference with a DOI

Wikidata weekly query #203

From Wikidata Status update of 02 APRIL 2016

• phrases,
• Redewendungen,
• most commons eponyms

• The query service now has bubble charts as a visualization option (*example)

Wikidata weekly query #204

From Wikidata Status update of 09 APRIL 2016

• women with most sitelinks and no image born in 1921 or later,
• what is depicted in artwork,
• most eponymous mathematicians

Wikidata weekly query #205

From Wikidata Status update of 16 APRIL 2016

• items named after their shape,
• recent events,
• assemblies by number of seats,
• characters portrayed by most actors

Wikidata weekly query #206

From Wikidata Status update of 23 APRIL 2016

• songs with longest melody (source),
• subjects with most art dedicated to them (source),
• versions of The Scream (source)

Wikidata weekly query #207

From Wikidata Status update of 30 APRIL 2016

• software with most versions (source)
• oldest software (source),
• map of U1 stations in Berlin (source)

Wikidata weekly query #208

From Wikidata Status update of 07 MAY 2016

• most frequent occupations without a label in a given language,
• map of places of birth of economists (source),
• map of all the paintings for which we know a location with the count per location (source),
• scientists who have worked together but whose Erdős numbers don’t reflect that (source),
• members of the French National Assembly born out of France (source),
• mathematical proofs (source),
• items that depict most things (source)

Wikidata weekly query #209

From Wikidata Status update of 14 MAY 2016

• longest rivers (source),
• map of places mentioned in travel stories with text in French accessible online (source),
• things located where the equator meets the prime meridian (source),
• people who acted with Brad Pitt (source),
• Italian mountains higher than 4000mt (source),
• who died by burning (source),
• age at date of death for musicians (source),
• universities of main programming language authors (source),
• hashtags (source),
• Pokemon! (source)

Wikidata weekly query #210

From Wikidata Status update of 21 MAY 2016

• given names with most variations (source with links to graphs),
• papers about Wikidata (source),
• memes (source),
• cathedrals in Paris (source),
• highest mountains in the universe (source),
• Law & Order episodes (source),
• things/people with most children (source)

Wikidata weekly query #211

From Wikidata Status update of 28 MAY 2016

• Fictional universes with most fictional planets (source),
• main subject of West Wing episodes (source),
• places with free wifi (source),
• citation network of paper about Zika (source),
• taxons and what they are named after (source),
• billionaires (source),
• animals that were executed (source),
• chemical elements and their isotopes by number of neutrons (min/max) (source),
• popes with children (source),
• birthplaces of astronauts (source)

Wikidata weekly query #212

From Wikidata Status update of 04 JUNE 2016

• body of water with the most watercourses ending in it (source),
• French communes with names ending in ac (source),
• birthplaces of Europeana280 artists (source),
• popular eye colors (source)

Wikidata weekly query #213

From Wikidata Status update of 11 JUNE 2016

• Eiffel Tower in art (source),
• popular surnames among humans (source),
• popular surnames among fictional characters (source),
• average lifespan by occupation (source),
• German breweries (source),
• years with 3 popes (source),
• people who died by burning - on a timeline (source)

Wikidata weekly query #214

From Wikidata Status update of 18 JUNE 2016

• colors of chemical compounds (source),
• map of braodway venues (source),
• sculptures by Max Bill (source),
• works of art where the name might be a rhyme (source),
• works of art where the title is an alliteration (source)

Wikidata weekly query #215

From Wikidata Status update of 25 JUNE 2016

• sandwich ingredients (source),
• inventors killed by their own invention (source),
• objects with most mass (source),
• music genres (source),
• number of jurisdictions by driving side (source)

Wikidata weekly query #216

From Wikidata Status update of 02 JULY 2016

• Ancestors of Guðni Jóhannesson (note the last names),
• movies with Bud Spencer (source),
• largest cities per country (source),
• longest river of each continent (source),
• rivers in Antarctica (source),
• continents (source),
• and some other continents (source),
• places with continent Antarctica more than 3000 km north of south pole (source),
• files used as “image” in more than 10 items (source),
• monuments historiques in Loire-Atlantique (source),
• music composers by birth place (source),
• places of whorship (source),
• teachers with most students (source),
• buildings in more than one country (source),
• sandwiches (source),
• composers and their most-used tonality (source),
• former capitals (source),

• list of suicide attacks (source),
• birthplaces of people named Antoine (source),
• places that are below 10 meters above sea level (source)

Wikidata weekly query #217

From Wikidata Status update of 09 JULY 2016

• timeline of space probes (source),
• countries with most UNESCO World Heritage Sites (source),
• places in America named after places in England (source),
• emergency number by country size (source)

Wikidata weekly query #218

From Wikidata Status update of 16 JULY 2016

• letters with more than two forms (source),
• metro stations (source),
• railway incidents (source),
• pyramids in Egypt (source),
• women described as wife and
• men described as husband (source),
• neuroinformatics coauthor network (source),
• nationalities of people with an article in the Bavarian Wikipedia (source),
• Irish general elections and their winners (source),
• types of historical monuments (source),
• Alpine four-thousanders (source),
• Alpine peaks (source),
• language statements that point to a country instead of a language (source)
  • Newest database reports: list of people who died on their birthday

Wikidata weekly query #219

From Wikidata Status update of 23 JULY 2016

• most cited Danish people (source),
• most self-citing authors (source),
• topics of series (source),
• human settlements, north of the Arctic Circle (source),
• poles of inaccessibility (source),
• people with the same family and given name (source),
• compositions for organ and orchestra/
• compositions for organ and anything else (source),
• people with a statement with start time / end time qualifiers over 100 years apart (source),
• causes of death for noble people (source),
• long-running noble families (source)

Wikidata weekly query #220

From Wikidata Status update of 30 JULY 2016

• frequency of Romans' praenomen (source),
• movies by number of actors who studied at RADA (source),
• actors directed by Tony Scott + number of appearances (source),
• actors directed more than 20 times by the same director (source),
• actors directed more than 20 times by the same director with years (source)

Wikidata weekly query #221

From Wikidata Status update of 06 AUGUST 2016

• places of worship in France (source), *former capitals (source),
• Edinburgh-born authors and their notable works (source),
• movies by David Lynch by duration (source),
• descendants of Gustav Vasa,
• people sharing the same name, the other way around,
• Tony awards nominees and winners (source)

Wikidata weekly query #222

From Wikidata Status update of 13 AUGUST 2016

• You can now render sparql queries using the Histropedia timeline engine. Example : Structures in London, colour coded by heritage status

• 2016 Olympics flag bearers (source)
• Composer that scored more than 100 films (source)
• churches using the same image (source)
• Challenge: Find a class with more fictional instances than real ones (source)
• items on human genes with unreferenced statements (source)
• Women elected to the UK Paliament (via WD:RAQ)
• Treaties of Paris (source)
• fictional thoroughfares (source)
• map of sports teams, with layers for different sports (source)
• big cities grouped into map layers by population (source)
• Free software with/without license (source)
• treaties with/without a date (source)
• capitals that aren’t capitals (soure)
• works of art depicting many people (source)

Wikidata weekly query #223

From Wikidata Status update of 20 AUGUST 2016

• A famous Italian song, Tanti Auguri by Raffaella Carrà, states "Com'è bello far l'amore da Trieste in giù" (literally, in English: "How great it is to make love from Trieste to below"). This is a query to find out where you shouldn't make love.
• Common occupations of heads of state (source).
• Murderers by region in France (source).
• Authors with a known location and an ORCID (source).
• Popular surnames among humans (source).
• Movies that won all the Oscars they were nominated for (source).
• Colors with multiple RGB statements (source)
• Filmography of Jean Gabin (source)
• Cities as big as Antwerp (source)
• Cities connected by the Trans-Mongolian and Trans-Siberian Railway (source)
  • Histropedia timeline of Europeana280 artworks (source)

Wikidata weekly query #224

From Wikidata Status update of 27 AUGUST 2016

• RADA alumni with a good or featured article on Wikipedia (source)
• Historians with links to French Wikipedia or Wikisource, but missing VIAF ID (source)
• Unicorn taxa, including the Indian rhinoceros (source)
• Mithras shrines, as a map (source)
• 2.300 Wikidata archaeological sites without coordinates (source)
• All items on Wikidata whom we know we don't know their sex or gender: (source)
• Drug-disease interactions (source)
• Nicknames of serial killers (source)
• Dynamic data map of all U-bahn lines in Berlin with colors (source)
• Timeline of internet services by type to celebrate 25 yrs of the web (source)
• Network of color (source)
• Dynamic data map of all country by year of joining the United Nations (source)

Wikidata weekly query #225

From Wikidata Status update of 03 SEPTEMBER 2016

• People convicted of regicide and their victims (source)
• The most common birthday among US citizens (source)
• Things named after Polish people (source)
• Drama schools by number of students (source)
• Average gestation period of genera (source)
• Sir Christopher Lee's filmography (with film directors) (source)

Wikidata weekly query #226

From Wikidata Status update of 10 SEPTEMBER 2016

• Posthumous marriages (source)
• Communes of France with more than one railway station (source)
• Languages and their grammatical cases they have in common (source)
• Cocktails recipes (source)
• People who died in the last seven days (source)
• Places of birth of 20th century saints (source)

Wikidata weekly query #227

From Wikidata Status update of 17 SEPTEMBER 2016

• Embassies (source)
• World map of water towers (source)
• "Battles of the Middle Ages" without place or date (source)
• Asteroids named after characters from works by Lewis Caroll (source)
• Map of Austrian cultural heritage (source)
• Statues in Paris depicting historical female figures (source)

Wikidata weekly query #228

From Wikidata Status update of 24 SEPTEMBER 2016

• taxonomy of squirrels (source),
• good or featured articles about people on Wikipedia but with no picture on Wikidata (source),
• Nordic Cross flags (source)

Wikidata weekly query #229

From Wikidata Status update of 01 OCTOBER 2016

• Most populous commune of France whose name begins by a certain letter (source)
• Works mentioning #Wikidata properties (source)
• Places where people born in Brittany died (source)
• trees grown from seeds that went around the Moon (source)

Wikidata weekly query #230

From Wikidata Status update of 08 OCTOBER 2016

• Chemistry Nobel prizes through time (source)
• Former countries without continent (P30) (source)
• Rivers without any mouth specified (source)
• Interesting items near you (source)

Wikidata weekly query #231

From Wikidata Status update of 15 OCTOBER 2016

• first Nobel Prize winner who was born after Alfred Nobel’s death (source)
• streets in Paris named after doctors (source)
• international land tripoints (source)
• national flags depicting stars or constellations (source)
• national flags with inscriptions (source)
• people who died the furthest away from where they were born (source)
• closest pairs of capitals (of UN member states, <500km) (source)
• people who received military decorations from two different countries (source)
• volcanoes and earthquakes (source)
• height/width ratios of paintings (source)
• birthplaces of Members of the European Parliament (source)
• birthplaces of US Senators (source)

Wikidata weekly query #232

From Wikidata Status update of 22 OCTOBER 2016

• places of birth of living US senators (compare with last week's)
• Wikidata map of filming locations (source)
• Streets in Paris named after a physician (source)
• Moons of trans-Neptunian objects (source)

Wikidata weekly query #233

From Wikidata Status update of 29 OCTOBER 2016

• Deities and their families
• Most frequently variants of given names (source)
• Cheese made with cow milk (source)
• Abandoned villages in the Czech Republic (source)

Wikidata weekly query #234

From Wikidata Status update of 05 NOVEMBER 2016

• Continents on Wikidata (All eleven of them) (source)
• Sluices on the river "Vilaine" in Brittany (source)
• Countries with most cities named after saints (source)
• Disney characters who share name with their actors (source)
• 204 items that cite themselves (source)
• Statements with two references where one source cites the other (source)

Wikidata weekly query #235

From Wikidata Status update of 12 NOVEMBER 2016

• Map of educational institutes from all over the world (source)
• Current US Supreme Court justices by their date of birth (source)
• Death dates of people with Wikidata items (source)
• French towns that a street in Paris is name after(source)
• Statements with “reason for deprecation” rank that aren’t deprecated(source)

Wikidata weekly query #236

From Wikidata Status update of 19 NOVEMBER 2016

• Occupations of women, with French female-form labels (source, database report)
• Documents with most signatories (source)
• Filming locations of James Bond films (source)
• United States National Historic Landmarks not actually located in the United States (source)
• Items with VIAF, but no P31/279 (source)

Wikidata weekly query #237

From Wikidata Status update of 26 NOVEMBER 2016

• List of sovereign state flags by proportion (source)

Wikidata weekly query #238

From Wikidata Status update of 03 DECEMBER 2016

• Bridges named after women (source)
• Network of brands of some big food/drink companies (source, help improve it)
• Cities located next to most rivers (source)
• Nobel Prize winners on Twitter (source)
• French deputies who died during their mandate (source)
• Streets in the Netherlands named after people
• People burried in the cemetery of La Croix Rousse (Lyon, France) (source)

Wikidata weekly query #239

From Wikidata Status update of 10 DECEMBER 2016

• Map of people buried in the cemetery of Norra Begravningsplatsen (Stockholm, Sweden)
• Works of Musée Saint-Raymond (Toulouse, France) on Wikidata (source)
• Communes of France named after a river
• People awarded by a Theater World Award in 2016
• Upcoming creative works: films, TV series, video games… (source)
• Number of demonstrations per country (source)

Wikidata weekly query #240

From Wikidata Status update of 17 DECEMBER 2016

• Timeline of the Christmas movies (source)
• All Theatre World Award winners, in a timeline with pictures (source)
• Birthplaces of people buried in Norra Begravningsplatsen (source)
• Planets, their moons, and the things they are named after (source)
• Items with no father or no mother (source)
• People born on Christmas day (source)

Wikidata weekly query #241

From Wikidata Status update of 24 DECEMBER 2016

• List of heads of state by Erdős number (source)
• Airports named after people (source)
• Graves with no grave pictures of people buried in Norra Begravningsplatsen (*source)
• Graves with grave pictures of people buried in Norra Begravningsplatsen (*source)
• Solidays occurring today (source)
• Streets in Paris named after current countries (source)
• Streets in Paris named after battles (source)
• Wikipedia articles (in any language) of paintings by painter (source)
• Sovereign state flags with no red, white, or blue (source)
• Graph of number of compositions over age at first composition (source)

Wikidata weekly query #242

From Wikidata Status update of 31 DECEMBER 2016

• Filtered timeline of Spotify artists
• Paintings of the Eiffel Tower by Robert Delaunay (source)
• Ratio of “famous” (≥25 sitelinks) people’s deaths since 2000 (source)
• Things with coordinates on globes other than Earth (source)