Wikidata:Weekly query examples/2017

2015

2016

2017

2018

2019

2020

2021

2022

2023

2024

Wikidata weekly query #242

From Wikidata Status update of 07 JANUARY 2017

• Birth place of Academy Award winners
• Neujahrskonzert with conductor by country and age (source)
• 9 species named after the President of the USA (source)

Wikidata weekly query #243

From Wikidata Status update of 14 JANUARY 2017

• People without gender, but with photo (~2500 items)
• Gallery of cheese varieties and origin
• Taxa with more female than male individuals (source)
• Scatter chart of river watershed area (in km²) over length (in km), now using normalized unit support (source)

Wikidata weekly query #244

From Wikidata Status update of 21 JANUARY 2017

• Tide mills in France (source)
• Wind mills in Paris (source)
• Mathematical formulae containing HTML escapes (source)
• Fire stations in Paris (source)

Wikidata weekly query #245

From Wikidata Status update of 28 JANUARY 2017

• Most articles about films in each Wikipedia
• Largest companies by revenue in USD
• Characters whose actors died recently (source)
• Stock-listed US companies with founders who (or whose parents) were born outside the US (source)
• Wizards from Harry Potter and their houses/groups (source)

Wikidata weekly query #246

• Places of worship south of 48°S(source)
• Fictional items named after real items(source)

Wikidata weekly query #247

• Collection of the Ashmolean Museum, Oxford, UK
• Office-holders convicted of crimes (source)
• Monarchs convicted of regicide (source)
• Timeline of antipopes (source)
• Battles etc of the U.S. Civil War, that have maps (source) -- but the results are a bit patchy.
• Grade I listed buildings in Bedfordshire (source: Commons "category contains" template)

Wikidata weekly query #248

• People born at the sea (source)
• Persons buried in Père-Lachaise cemetery, Paris (source)
• Paintings by women painters in the Louvre (source)

• People born on Valentine's day, colour coded by country of citizenship (source)

Wikidata weekly query #249

• Map of cheese by milk used (source)
• The many flags of Afghanistan (source)
• Real works written by fictional authors (source)
• Maps of churches in Pyrénées-Orientales (France) (source)
• Cities with millions of inhabitants that not a single person in Wikidata was born, has lived, or died in (source)

Wikidata weekly query #250

• Countries with similar populations (source)
• Items that have "feminist art" as a value (source)
• Books, incipits, concatenating a sentence to the incipit (source and inspiration)
• Paintings by Vermeer depicting maps (source)
• Painters sorted by the number of Wikipedia articles about their works (source)

Wikidata weekly query #251

• List of female bioinformaticians/computational biologists (source)
• Most gender-imbalanced occupations in US citizens (source)
• Awards received by more women than men (source)
• Transgender characters played by trangender actors/actresses (source)
• The most famous astronomical objects in Solar System according to Wikipedia sitelinks (source)
• Natural arches around the globe (source)

Wikidata weekly query #252

• Gallery of authors of scientific articles that have been published on this day of the year (source)
• Scholarly articles that have Wikipedia articles about them (source)
• False Vermeer works (source)
• From Natalie Portman to Paul Erdös graph (source)

Wikidata weekly query #253

• Time zones that are more than 12 hours away from UTC (source)
• Countries which have the same name as their capital in their official language (source)
• Roman amphitheatres on Wikidata (source)
• Sluices on canals in Bretagne (France) (source)

Wikidata weekly query #254

• Map of the megaliths of the World, coloured by type (showing some nice paterns, source)
• French people without a gender (source)
• Eldest members of noble families (source)
• Map of places with population “zero” (0) (source)

Noteworthy Stuff

• Query Service: you can now create a template to explain what your query is doing

Wikidata weekly query #255

From Wikidata Status update of 10 APR 2017

• Notable integers
• Longest streets of Moscow
• Top 20 of heaviest humans in Wikidata (source)
• Timeline of Paris marathons (source)
• Countries not involved in any world war (source)
• People whose place of birth is named after them (source)

Wikidata weekly query #256

From Wikidata Status update of 17 APR 2017

• The 500 most important paintings, according to Wikidata sitelinks (source)
• The most important works in German by Wiki* articles (source)
• Cities in France starting with the letter W (source)

Wikidata weekly query #257

From Wikidata Status update of 24 APR 2017

• Place of birth of the candidates to French presidency since 1958 (source)
• Oldest given names on Wikidata (source)
• Cocktails and their ingredients (source)
• Cities in UK named after a patron saint (source)

Wikidata weekly query #258

From Wikidata Status update of 01 MAY 2017

• 15415 people who died in 2016
• Maps of statues of Jeanne d'Arc on a horse (source)
• Families who’ve had the same occupation for five generations (source)
• Couples of capitals more than 19,000 km away from each other (source)
• A ten-persons “surname = given name” chain on Wikidata (source)

Wikidata weekly query #259

From Wikidata Status update of 08 MAY 2017

• All places (with coordinates) that gave its name to something (source)
• Paintings depicting monkeys (source)
• Artworks with presumably depicted persons (source)

Wikidata weekly query #260

From Wikidata Status update of 15 MAY 2017

• Paintings in the Louvre Museum, with heights and widths (source)
• Chart of USA cities founded per year (source)
• Country flags including a symbol of sun (source)
• Birthplace of Spanish Queen Consorts (source)

Wikidata weekly query #261

From Wikidata Status update of 22 MAY 2017

• Websites but without an official website
• Plants with associated emoji (source)
• Languages ordered by number of speakers (source)
• HMDB identifiers with more than one item (source)
• Painters with a lot of identifiers on Wikidata, but few Wikipedia articles (source)
• Buildings with the greatest numbers of elevators (source)
• Map of female writers on Wikidata by birthplace- generated by SPARQL query (source)

Wikidata weekly query #262

From Wikidata Status update of 29 MAY 2017

• Map of subreddits associated to a place on Earth (source)
• Potential reviewers for papers in computer science (source)
• Paintings with 'portrait' in the name that lack P180 / depicts (source)
• Publications and presentations about WikiCite (source)

Wikidata weekly query #263

From Wikidata Status update of 05 JUNE 2017

• Number of citizens with “blood type” statements per country (source)
• Works with most citations (running time 20-45s) (source)
• Female recipients of the Palme d'Or award (source)
• Timeline of albums by Manu Chao and Mano Negra (source)
• Female given names ending in "o" (source)
• Newest external tools: Wikidata Diff (compares two items; proof-of-concept, doesn't yet include qualifiers, etc.), Wikidata Recent Changes livestream

Wikidata weekly query #264

From Wikidata Status update of 12 JUNE 2017

• Coordinates of parallels and meridians according to Wikidata (source)
• Uses of the property "IPv6 routing prefix" (source)
• Non-politician jobs that UK Prime Ministers had (source)

Wikidata weekly query #265

From Wikidata Status update of 19 JUNE 2017

• Gallery of monsters of the Japanese folklore
• Lang by number of label (with quarry.wmflabs.org)
• The 10 smallest countries with some kind of urban rail transit system (source)
• Occupations with highest rate of deaths by homicide (source)
• Software titles ranked by number of readable file formats (source)

Wikidata weekly query #266

From Wikidata Status update of 26 JUNE 2017

• BubbleChart of Metal band by country (source)
• Viennese composers and their compositions by tonality (source)
• Most prolific authors of scientific articles on Wikidata, who are still alive, without ORCID (source)
• Average age of members of the Landtag of Thuringia (source)

Wikidata weekly query #267

From Wikidata Status update of 03 JULY 2017

• Place of birth of the authors on Wikimammenn, the breton Wikisource
• First names of current French members of Parliament (source)
• Timeline of the births of current members of the French National Assembly (source)
• Family tree of Harry Potter characters (source)
• Map of mountains located in the Basque Country (source)
• Items with higher number of child statements than number of children (source)
• Pictures of Pharaos (source)
• Map of departemental archives in France (source)

Wikidata weekly query #268

From Wikidata Status update of 10 JULY 2017

• Scientific articles from PubMed that mention what version of STATA was used (source)
• 1000 places in UK that have no label in Welsh (source)
• Wikivoyage banners for French municipalities (source)
• Paintings with musical instruments from Spain or related to Spain (source)
• Images of things or persons in Wikidata with a Github account (source)
• Map of birthplaces of women who were educated in Edinburgh university (source)

Wikidata weekly query #269

From Wikidata Status update of 17 JULY 2017

• Graph of operating systems (source)
• Couples of Members of Parliament in UK (source)
• People who have the same person listed as both their parent and their child (source)
• Map of “railway things” in Berlin, as classified by LinkedGeoData.org (source)
• Map of discovery locations of the objects stored in the Musée Saint-Raymond (source)
• metro stations in Germany with public domain images on Commons (source)
• UK Members of Parliament who are born out of the UK (source)

Wikidata weekly query #270

From Wikidata Status update of 24 JULY 2017

• Properties with most “statement disputed by” qualifiers (source)
• Last meals of people (source)
• Colors on national flags (source)
• images of all winners of Free Software Foundation's Free Software Awards (source)

• lib.reviews now allows searching Wikidata directly to choose subjects to review. (more info)

Wikidata weekly query #271

From Wikidata Status update of 31 JULY 2017

• Which White House chief of staff had the shortest tenure? (source)
• Total number of sister city statements per country (source)
• Pictures of tube stations in London (source)
• Works created with the software Maya (source)
• Do I cite works from Nobel Prize winners? (source)
• ...or do Nobel prize winners cite me? (source)
• Timeline of Humanitarian personality of the year (source)

Wikidata weekly query #272

From Wikidata Status update of 07 AUGUST 2017

• Timeline of the programming languages created in the past 10 years (source)
• Countries where no european language has official or national status (source)
• Gallery of Star Trek characters (source)
• Timeline of female medieval writers (source)

Wikidata weekly query #273

From Wikidata Status update of 14 AUGUST 2017

• Most-depicted musical instruments (source)
• People who died in 2017 without a French label (source)
• Moar goats (source)

Wikidata weekly query #274

From Wikidata Status update of 21 AUGUST 2017

• Surnames, similar to Muller, according to Cologne phonetics, Caverphone and Soundex algorithms
• Shortest streets in Moscow
• A timeline of theologians with a connection to Berlin (source)
• Timeline of the life of Honoré de Balzac (source)
• Twin cities of places in South Africa (source)
• 51st UK parliament (1992) was the first one with more women than Johns (source)
• All places that are named "earth" in at least one language (source)

Wikidata weekly query #275

From Wikidata Status update of 28 AUGUST 2017

• number of persons per QID (using P735=Q4925477) (source)
• QID milestones by date
• Timeline for biochemist and Nobel Laureate Hans Adolf Krebs (source)
• Canadian actors who twice played a US president (source)
• Duration of Steven Spielberg's films (source)

Wikidata weekly query #276

From Wikidata Status update of 04 SEPTEMBER 2017

• The most famous painting from each country (source)
• Ranking universities according to PageRank (source)
• Actors who were cast in two different films with the same name (source)

Wikidata weekly query #277

From Wikidata Status update of 11 SEPTEMBER 2017

• Places of education of the UK members of Parliament (source)
• Pairs of churches in the UK that are within 25 metres of each other (source)
• National parks in India (source)
• Persons buried more than 13000 km away from their death place (warning: some errors needing correction)

Wikidata weekly query #278

From Wikidata Status update of 18 SEPTEMBER 2017

• Algorithms and the problems they solve (source)
• Swiss items with article in exactly one of German-, French-, Italian-, and Romansh-language Wikipedias (source)
• Popular gender-neutral given names (source)
• Computer network protocols and their ports (source)
• Software developers by number of software titles (source)
• Spacecraft and what they were named after (source)

Wikidata weekly query #279

From Wikidata Status update of 25 SEPTEMBER 2017

• standards bodies by number of standards they are connected to (source)

Wikidata weekly query #280

From Wikidata Status update of 02 OCTOBER 2017

• What exists in the "... as a service" genre? (source)

Wikidata weekly query #281

From Wikidata Status update of 09 OCTOBER 2017

• Women who won the Nobel Prize in Physics (source)
• For each award, percentage of women who received it (source)
• Intelligent personal assistants described in Wikidata (source)
• Units of measurement named after German people (source)
• Buildings constructed by Karl Friedrich Schinkel (source)

Wikidata weekly query #282

From Wikidata Status update of 16 OCTOBER 2017

• Flags with more than 5 stars (source)
• Timeline of programming languages (source)
• Female scientists sorted by number of citations of their work (source)

Wikidata weekly query #283

From Wikidata Status update of 23 OCTOBER 2017

• Average age of members of the 19th German Bundestag (source)
• Mountains in CH by height (topographic prominence) (source)
• Mountains in CH by height (elevation above sea level) (source)
• Monuments in Berlin for which Berlin cultural heritage ID and geolocation are known in Wikidata (source)
• Initial characters of names of free software (source)
• Initial characters of names of nonfree software (source)
• First World Heritage site per country (source)

Wikidata weekly query #284

From Wikidata Status update of 30 OCTOBER 2017

• Organic acids with images (source)
• People who are their father's father (source)
• 2017 German federal election results by district with geoshapes and color depending on the % of votes (source)
• Cities with most first performances of works (source)
• Count of women Vs. guys names “John” in the UK parliament (source)
• Percentage of popes who died in Rome (source)
• First sites registered at Unesco for each country (source)

Wikidata weekly query #285

From Wikidata Status update of 06 NOVEMBER 2017

• endemic moths of New Zealand with images in Wikidata (source)
• Images of people commemorated by plaques in Jena, Germany (source)
• Paintings located in Le Louvre without pictures on Wikidata, with the location in the museum (source)
• Persons who will have their work in public domain in 2018 in Denmark, with their occupations (source)
• Political parties by ideology in a tree view (source)
• Organic acids with pictures (source)
• Levels of education in France, from kindergarten to high school, with their US equivalents (source)
• Horses drawn on hills in the UK (source)
• Frequency of “retrieved” dates in Wikidata references (source)

Wikidata weekly query #286

From Wikidata Status update of 13 NOVEMBER 2017

• Timeline of the works of Robert Louis Stevenson (source)
• Canals within 800 kilometres of Glasgow (source)
• File systems by developer, date, and OS (source)
• Map of metro stations of Bilbao (source)
• Highest point of each department of France (source)

Wikidata weekly query #287

From Wikidata Status update of 20 NOVEMBER 2017

• List of subclasses of Matrices
• Works of art in which the artists depicts their spouse (source)
• locations Van Gogh depicted in his paintings (source)
• Gender split of past Google Doodles (source)

Wikidata weekly query #288

From Wikidata Status update of 27 NOVEMBER 2017

• People who were Time Person of the Year in two consecutive years (source)
• Fictional characters “said to be the same as” other fictional characters from the same fictional universe (source)
• Map of places of birth of deceased sociologists (source)
• Map of libraries in India (source)
• Train and subway stations in Basque Country (source)

Wikidata weekly query #289

From Wikidata Status update of 04 DECEMBER 2017

• Timeline for the writer Robert Louis Stephenson (source)
• Movies with Bud Spencer and Terence Hill (source)
• Photographers born before the inception of the earliest photograph (source)

Wikidata weekly query #290

From Wikidata Status update of 11 DECEMBER 2017

• Place of birth of author with pages on the French Wikisource (source)
• Number of movies passing or failing the Bechdel test by year (source)
• 100 of the earliest 1000 works created by women on Wikidata with an image on Commons (source)
• Chemical entities, whom discovered them, and when (source)
• Sister-city and twin-city relationships of the largest cities (source)
• Cast age at date of film publication (source)
• Male saints that are the most used to name French cities after them (source)

Wikidata weekly query #291

From Wikidata Status update of 18 DECEMBER 2017

• Number of disasters by date and day of the week (source)
• Map with buildings by Brazilian architect Oscar Niemeyer (source)
• Properties most used for “no value” statements/qualifiers/references (source)
• Scientific papers with an animal credited as co-author (source)
• Image grid of what different cryptocurrencies are named after (source)

Wikidata weekly query #292

From Wikidata Status update of 25 DECEMBER 2017

• Map with radio telescopes around the world (source)
• People born on the same day their mother died (source)
• Largest first-level administrative subdivision by country (source)
• Data sets released under a Creative Commons NoDerivatives license (source)
• Type foundries and their typefaces (source)
• Map of Christmas traditions (source)
• Movies that are Christmas traditions (source)