Wikidata:Weekly query examples/2018

2015

2016

2017

2018

2019

2020

2021

2022

2023

2024

Wikidata weekly query #293

From Wikidata Status update of 02 JANUARY 2018

• Landlocked countries bordering coastal countries (source)
• Most common years of birth in Wikidata (source)
• Map of lighthouses around the world (source)
• Bubble chart showing countries with the highest number of children out of school in 2013 (source)
• Playwright dead in 1947 (whose works are now in Public Domain) (source)

Wikidata weekly query #294

From Wikidata Status update of 08 JANUARY 2018

• Events starting in 2017 and ending in 2018, shortest duration first (source)

Wikidata weekly query #295

From Wikidata Status update of 15 JANUARY 2018

• Gallery of photography techniques
• Street names that exist several times in Berlin (source)
• Average length of movie by genre and year (source)
• Inventions by Republicans (source)
• Celebrities born in January of a leap year (source)
• Countries with no rivers (source)
• Female aviation pioneers born before 1900 (source)
• People who died on K2 (source)

Wikidata weekly query #296

From Wikidata Status update of 22 JANUARY 2018

• Map of nuclear tests (source)
• Languages with more than one writing system (source)
• Subclasses of malware (source)
• Male actors who starred in a trilogy of movies when they were in their 20s and then no fewer than 40 years later played the same character again(source - see whole thread for more)
• Bands from the UK whose member's average age is at least 70 (source)
• Disney movie narrative locations (source)

Wikidata weekly query #297

From Wikidata Status update of 29 JANUARY 2018

• Buildings higher than the Eiffel Tower (source)
• Descendants of Charlemagne by year of birth (source)
• Cinemas in Berlin (source)
• Things (or people) depicted in the xkcd webcomic (source)
• Image grid of inductees to WITI Hall of Fame (source)
• Movies filmed in Austria (source)

Wikidata weekly query #298

From Wikidata Status update of 05 FEBRUARY 2018

• Items that have or will have been gone for as long as they were there this month (source)
• Members of the current UK Parliament who have ancestors in Wikidata who are identified as possibly mythical (source)
• Older siblings who died less than a month before their younger sibling entered an office (source)
• List of tram lines in Vienna (source)
• Adjacent districts in Vienna that have no tram line connecting them (source)
• Places of birth, death and burial of the artists hosted in the Sweden’s museum of art and design (source)

Wikidata weekly query #299

From Wikidata Status update of 12 FEBRUARY 2018

• Timeline of the Soviet Space Program (source)
• Countries with the most sister cities with French towns (source)
• JO2018: all 108 French competitors at the 2018 Winter Olympics by year of birth (source)
• Languages used by poeple in Austria, other than German (source)
• Biologists with Twitter accounts (source)
• Feed readers by license and operating system (source)
• List of female UK MPs who were descended from UK MPs (source)

Wikidata weekly query #300

From Wikidata Status update of 19 FEBRURARY 2018

• Women with an Erdős number
• Classes that are subclass of both physical object and abstract object (thread)
• Countries sharing land borders only with larger countries (source)
• Alive actors and actresses without an image, ordered by number of films they appear in (source)
• Beast species in the Harry Potter universe (source)
• Places that have been indicated as the topic of scientific articles indexed in Wikidata (source)
• Scientists whose cause of death was "death by burning" (source)
• Women who have been elected to the National Academy of Sciences (source)

Wikidata weekly query #301

From Wikidata Status update of 26 FEBRURARY 2018

• Actors who have starred in at least three Oscar Best Picture-nominated films in the same year (Inspired by this Vulture article)
• Items in the part of the Getty AAT thesaurus (P1014) below costume accessory (Q1065579) where the upward relationship in the thesaurus cannot as yet be 'explained' by our existing subclass (P279) relations (thread1;thread2;thread3)
• Where were people who went to space born? (source)
• National flags featuring the Union Jack as a canton (the top inner corner of a flag) (source)
• Number of mass shootings by country since 1990 (source)

Wikidata weekly query #302

From Wikidata Status update of 05 MARCH 2018

• 3D models on Commons
• Timeline of programming languages (source)
• Date of birth of computer scientists (source)
• Women born in Latin America without an article on Spanish Wikipedia (source)
• Timeline of Düsseldorf mayors (source)

Wikidata weekly query #303

From Wikidata Status update of 12 MARCH 2018

• Some costume items ending in 'us'
• Women on Wikidata without article in any Wikipedia, ordered by number of statements (source)
• WikiProjects about women (source)
• Software of the KDE community (source)
• Films starring more than one future head of government (source)
• Timeline of prominent Women Computer Scientists (source)

Wikidata weekly query #304

From Wikidata Status update of 19 MARCH 2018

• Megalithic sites in Spain (source)
• Major periods of Japanese history and what they were named after (source)
• Islandic names that are not ending in "son" or "dottir (source)
• In what language does Q137 and Q12518 have the same label? (source)
• Timeline of Earth's artificial satellites (source)

Wikidata weekly query #305

From Wikidata Status update of 26 MARCH 2018

• Airports named after a person, color-coded by gender (source)
• Movies that Wikidata knows about and that have a German title that implies that someone or something doesn't answer (source)
• Software developed by people/organizations that have archival material at the ComputerHistory museum (source)
• Most common eponyms of French departments (source)

Wikidata weekly query #306

From Wikidata Status update of 02 APRIL 2018

• Most common title of paintings in English
• Timeline for German author Heinrich Mann (source)
• Density in kilograms per cubicmeter for books (source)
• Books by weight (source)
• Train stations in the UK (source)
• Map of megaliths in Portugal and Spain (source)

Wikidata weekly query #307

From Wikidata Status update of 09 APRIL 2018

• Timeline of weather satellites (source)
• Map with lighthouses all over the world (source)
• Number of articles about humans by gender on Welsh Wikipedia (source)
• List of French rivers with different names and SANDRE ids on Sophox (SPARQL endpoint querying OpenStreetMap and Wikidata) (source)

Wikidata weekly query #308

From Wikidata Status update of 16 APRIL 2018

• Longest chain of mutual murders (source)
• 6 couples killed each other (source)
• All things named after Leonardo da Vinci (source)
• German municipality pairs with the name pattern -ing/-ingen (source)
• Timeline of early silent movies produced before 1900 (source)
• French citizens with at least 5 Wikipedia pages but not in French (source)

Wikidata weekly query #309

From Wikidata Status update of 23 APRIL 2018

• Historical monuments in Wales (source)
• Software titles ranked by the number of dependencies listed for them (source)
• National parks around the world (source)
• Narrative locations of TV series and episodes (source)

Wikidata weekly query #310

From Wikidata Status update of 30 APRIL 2018

• Timeline of Wikibase instances and WikidataCon events (federated query)
• User-friendly list of news articles by Kim Wall, as linked from the German and English Wikipedia (based on work of fnielsen)
• Places of birth of the European Parliament members (source)
• Obelisks in Rome (source)
• Artists from Cameroon and their places of birth (source)
• Place of birth of people with an ORCID ID (source)
• History of Milano metro stations on a map (source)
• Number of versions, editions and translations by language of work (source)

Wikidata weekly query #311

From Wikidata Status update of 07 MAY 2018

• Map of birth places of authors in the Portuguese Wikisource
• Video games that are set in the Star Wars Expanded Universe by game mode (source)
• Timeline of Programming Languages (source)
• Timeline of people named Karl born in Karlsruhe (source)

Wikidata weekly query #312

From Wikidata Status update of 14 MAY 2018

• Museums near you (source)
• Places near you that are the subject of publications (source)
• Map of libraries in Wales (source)
• Map of schools in Italy (source)
• List of TeX/LaTeX commands for special characters (source)
• Largest first-level country subdivisions (i.e. larger than 400,000 km²) (source)

Wikidata weekly query #313

From Wikidata Status update of 21 MAY 2018

• Most populous first-level country subdivisions without legislatures (source)
  • Prisoners of Conscience by place of birth (source)
  • Photos of railway stations from Latvia and Estonia (source)
  • Map of items near me that have a label in Catalan but not in French (source)
  • Places of residence of accused Scottish witches (source)
  • Poets whose fathers were lawyers (source)

Wikidata weekly query #314

From Wikidata Status update of 28 MAY 2018

• Map of places of birth of Liverpool's football players (source)
• Areas of Malaysia states (source)
• People and the distance between their place of birth and place of death (source)
• Grammatical cases of languages (source)

Wikidata weekly query #315

From Wikidata Status update of 04 JUNE 2018

• List of Danish female athletes (source)
• Battles within 100km of Edinburgh (source)
• Grammatical features graph (source)
• 10 items having the biggest number of sitelinks (source)
• Writers and their signatures (source)

Wikidata weekly query #316

From Wikidata Status update of 11 JUNE 2018

• Timeline of discoveries in the Solar System (source)
• Map of Suffragettes around the world (source)
• Female ministers in African countries (source)
• References with only a quote but no other properties (source)
• Islands in capital cities (source)
• Map of titles in the Welsh Journals & Welsh Newspapers (source)

Wikidata weekly query #317

From Wikidata Status update of 18 JUNE 2018

• Artworks and rooms of The Louvre museum shown in the latest Beyoncé video (source)
• Goalscorers for the 2018 FIFA World Cup (source)
• Female dancers and choregraphs having a picture and a Wikipedia article in English but not in French (source)
• Nudes with cats (source)
• Museums in Italy colored by number of Wikipedia articles (source)
• Countries and their official languages, ISO codes and Wikimedia language codes (source)

Wikidata weekly query #318

From Wikidata Status update of 25 JUNE 2018

• Timeline of scientists dying a non natural death before 1900 (source)
• Most P2860-cited surname (source)

Wikidata weekly query #319

From Wikidata Status update of 02 JULY 2018

• Map of the birth places of people who have had taxa named after them (source)
• Space observatories and their namesakes (source)
• Timeline of computer games (source)
• List of companies owned by Disney (source)
• Same gender spouses (source)

Wikidata weekly query #320

From Wikidata Status update of 09 JULY 2018

• Map of places in the UK starting with "Llan" (source)
• Number and percentage of articles about female scientists for all Wikipedias (compared to all articles about scientists) (source)
• Statements disputed by their subject (source)
• Emulators and what they emulate (source)
• Map of items near me that have a label in English but not in Welsh (source)

Wikidata weekly query #321

From Wikidata Status update of 16 JULY 2018

• Map of birthplaces of football players at 2018 FIFA World Cup
• People born furthest from their place of education (source)
• Timeline of discontinued Google products (based on source)
• Paintings depicting the Bastille Day (source)

Wikidata weekly query #322

From Wikidata Status update of 23 JULY 2018

• Fictional characters married to their siblings (source)
• Translations of disease names in South-African languages (source)
• All Wikidata properties (which are not identifiers) without a label in Afrikaans (source)
• List of people born or dead in Canton de Vaud (Switzerland), with archives where their documents are stored (source)
• Timeline of serial killers (source)
• Map of disasters, color-coded by disaster type (source)

Wikidata weekly query #323

From Wikidata Status update of 30 JULY 2018

• Ancient Greek pottery items stored in Museum St-Raymond, France (source)
• Timeline of early aviators who died in an accident (source)
• Timeline of direct-to-video sequels of theatrical movies (source)
• Music albums from Argentina (source)

Wikidata weekly query #324

From Wikidata Status update of 06 AUGUST 2018

• minerals named after women (source)
• Frequency of major and minor key tonalities per genre (source)
• Timeline of Writing Systems (source)
• Nonprofit organizations and the software they develop (source)
• Map of newspapers in Oregon (source)

Wikidata weekly query #325

From Wikidata Status update of 13 AUGUST 2018

• Topics for which the English Wikipedia wikilinks to the University of Virginia but the corresponding Wikidata entry does not
• Map of institutions where Canadian citizens got their PhD
• Space probes that have their own Twitter accounts (source)
• Newspapers in Wikidata with a recorded place of publication (source)
• Countries whose capital city can be spelled out only using letters from the country's name (source)
• Amara taxons and their Wikispecies link (source)
• Things related to open access to research in Japan (source)

Wikidata weekly query #326

From Wikidata Status update of 20 AUGUST 2018

• Federated query with Nobel.org: Places on Moon or Mars named after Nobel prize winners (source)
• Texts ranked by the number of languages in which they are available through Wikisource (adapted from source)
• Map of places co-occurring with species or higher-order taxa as main subjects of publications (source)
• Software titles and what they were inspired by (source)
• Occupations of the accused witches in the Survey of Scottish Witchcraft database (source)
• Gallery of Nobel prizes winners (federated query) (source)

Wikidata weekly query #327

From Wikidata Status update of 27 AUGUST 2018

• Map of libraries in Austria (source)
• Countries ranked by number of Wikidata-known people born there whose English version of the given name starts with Q or X (source)
• List of Windows games released this year (source)
• Countries with most citizens on Wikidata whose given name starts with X or Q (source)
• People entered in the Dictionary of Welsh Biography by gender and birth location (source)

Wikidata weekly query #328

From Wikidata Status update of 03 SEPTEMBER 2018

• License of an image on Commons, while Structured Commons is in the making (source)
• Gallery of Gods and other deities
• Closest library for each public bookcase in Vienna (source)
• Line chart of Human Development Index over time for a set of countries (source)

Wikidata weekly query #329

From Wikidata Status update of 10 SEPTEMBER 2018

• Nobel Prize winners in WIkidata that miss a LIBRIS id (source)
• Recent video game items with associated sitelinks and identifiers (source)
• Video game titles available on more than ten platforms (source)

Wikidata weekly query #330

From Wikidata Status update of 17 SEPTEMBER 2018

• Map of caves with prehistoric art (source)
• Most cited works with Swedish first author (source)
• Map of events for Wikidata's 6th Birthday (source)
• Heads of the same state whose family names share the first four letters but are not identical (source)
• Map of caves containing prehistoric art (source)

Wikidata weekly query #331

From Wikidata Status update of 24 SEPTEMBER 2018

• Museums and libraries in Boston and Cambridge (source)
• Timeline of mobile phones (source)
• Average height of figure skaters by gender and discipline (source)

Wikidata weekly query #332

From Wikidata Status update of 01 OCTOBER 2018

• Bounding boxes for a set of maps
• Where were UK ambassadors educated? (source)
• People who received the Order of Merit of the Federal Republic of Germany and were also in the NSDAP (Nazi party) (source)

Wikidata weekly query #333

From Wikidata Status update of 08 OCTOBER 2018

• Characters from the Mario franchise by games in which they appear (source)
• Nobel Prize winners who also has been TED speakers (source)

Wikidata weekly query #334

From Wikidata Status update of 15 OCTOBER 2018

• Age of receivers of Nobel Prize winners in Literature (source)
• Places of birth of Nobel prizes winners per decade ([ source])
• Things named after Ada Lovelace (source)

Wikidata weekly query #335

From Wikidata Status update of 22 OCTOBER 2018

• Map of lines and stations of the Amsterdam metro (source)
• Workplaces of society portrait painter Philip de Laszlo, traced on a map (source)
• What other relationships do people have with their spouses? (source)
• Signatures of French-speaking female authors (source)
• Underground lines of London (source)

Wikidata weekly query #336

From Wikidata Status update of 29 OCTOBER 2018

• Number of properties by datatype, with a (random) example property (source)
• Number of depicted subjects by gender (source)
• People at Svensktöversättarlexikon missing a LIBRISXL authority record ordered by number of articles in Wikipedia (source)

Wikidata weekly query #337

From Wikidata Status update of 05 NOVEMBER 2018

• Timeline of companies acquired by Red Hat (source)
• Video game characters named after humans (source)
• People who received an award on the day of their death (source)
• Things named after Tux, as described in (source)

Wikidata weekly query #338

From Wikidata Status update of 12 NOVEMBER 2018

• Currently happening figure skating competitions (source)
• Software developed by groups within Google (source)
• Knowledge organization systems (source)
• Most common election days by country (source)

Wikidata weekly query #339

From Wikidata Status update of 19 NOVEMBER 2018

• Battles with location and date in Wikidata (source)
• Pictures depicting a kiss with IIIF manifest (source)
• Software-related companies founded by women (source)
• Films based on video games (source)

Wikidata weekly query #340

From Wikidata Status update of 26 NOVEMBER 2018

• Place and century of discovery of the archaeological objects of St Raymond museum (France) (source)
• Location of city halls in Spain (source)
• Timeline of famous pirates (source)
• Authors who are the most cited in Nature Chemistry (source)
• Scholarly articles published about Wikidata (adapted from here)
• The world's 200 tallest mountains, and whether Wikidata knows they've been climbed (source)

Wikidata weekly query #341

From Wikidata Status update of 03 DECEMBER 2018

• Timeline of early Western movies (source)
• Species represented in the exhibition "Espèces en voies d'illumination" in the natural history museum of Paris (source)
• Properties most used to describe cats in Wikidata (source)
• List of UK embassies (source)
• Map of places of residence for accused witches in Scotland with a layer for occupations (source)

Wikidata weekly query #342

From Wikidata Status update of 10 DECEMBER 2018

• Map of fountains in Zürich (source)
• Timeline of famous bryologists (source)
• Percentage of people member of the Swedish church per Church parish (source)
• Musical genres with the most bands and musicians on Wikidata, per sovereign country of origin/citizenship (source)

Wikidata weekly query #343

From Wikidata Status update of 17 DECEMBER 2018

• (UK) Ambassador by country list - Listeria report which writes 240 by-country reports on UK Ambassadors - h/t NavinoEvans for the approach
• Presidents of the United States ranked by the number of species named after them (source)
• Communes of France whose name starts with "Saint" (source)
• Italian toponyms with suffixes of Celtic origin (-ago, -ate, -asco) (source)
• List of ABBA songs in A major (source)

Wikidata weekly query #344

From Wikidata Status update of 24 DECEMBER 2018

• Catchphrases in Wikidata (source)
• Timeline of Indian mathematicians (source)
• Painting part of the Bavarian State Painting Collections (source)
• Types of pasta in Wikidata with pictures (source)