Wikidata:Weekly query examples/2016
Wikidata weekly query #191
editWikidata weekly query #192
editWikidata weekly query #193
editWikidata weekly query #194
editWikidata weekly query #195
editWikidata weekly query #196
editWikidata weekly query #197
editWikidata weekly query #198
editWikidata weekly query #199
editWikidata weekly query #200
editFrom 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
editWikidata weekly query #202
editWikidata weekly query #203
editFrom Wikidata Status update of 02 APRIL 2016
- The query service now has bubble charts as a visualization option (*example)
Wikidata weekly query #204
editWikidata weekly query #205
editWikidata weekly query #206
editWikidata weekly query #207
editWikidata weekly query #208
editFrom 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
editFrom 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
editWikidata weekly query #211
editFrom 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
editWikidata weekly query #213
editWikidata weekly query #214
editWikidata weekly query #215
editWikidata weekly query #216
editFrom 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),
Wikidata weekly query #217
editWikidata weekly query #218
editFrom 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
editFrom 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
editFrom 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
editWikidata weekly query #222
editFrom 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
editFrom 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)
Wikidata weekly query #224
editFrom 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
editFrom 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
editWikidata weekly query #227
editWikidata weekly query #228
editWikidata weekly query #229
editWikidata weekly query #230
editWikidata weekly query #231
editFrom 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
editWikidata weekly query #233
editWikidata weekly query #234
editFrom 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
editFrom 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
editFrom 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
editWikidata weekly query #238
editFrom 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
editFrom 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
editFrom 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
editFrom 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)