Wikidata:SPARQL query service/qotw/2020
Jump to navigation
Jump to search
Queries from Wikidata status update weekly summaries in 2020
January[edit]
- Horses sorted by age of death (source)
- Affiliates of the USA organization Peace Action (source)
- 100 random paintings related to Haarlem (source)
- Timeline of adaptations of Little Women and actresses who played Jo's character (source)
- Indian people whose work is entering public domain in 2020 (source)
- Locations depicted on album covers
- Forts and heritage-scheduled sections of the Antonine Wall in Scotland (source)
- Number of Lexemes including recordings from Lingua Libre by language (source)
- Contributors to Jacob Heyblocqs vriendenboek and their occupations (source)
- Number of Co-Authors by Country using ORCID to identify the "searched author" (source)
- The results of the Australian Triple J Hottest 100, 2019 music voting poll were published on 25 January 2019. See the results with associated music videos to watch.
- Map of destinations from Wuhan Tianhe International Airport
- 50 philosophers for which DBpedia and Wikidata state different date of birth (source)
February[edit]
- Number of cases coronavirus reported per country
- Release date of albums from before 1980 by artists of the EDM genre (source)
- Books related to LGBTI+ topics (source)
- Map of medical facilities in Kalimpong district, India, color-coded by type (source)
- Timeline of same-sex marriage legalization in various countries (source)
- Chart of the number of infections and deaths casued since the outbreak of novel coronavirus, as reported by the World Health Organisation
- Adjacent constituencies of the UK Parliament - query federated with Ordnance Survey's SPARQL endpoint. (source)
- List of this year’s Academy Awards winners
- Place names of Bergamo: map with pronunciation audio files (source)
- Number words whose number of letters equals their value: with Lexemes (source), with labels (source)
- Graph of the extended Kardashian clan (source)
- Scottish monuments with a commons sitelink, but no image (source)
- Number of films with LGBT representation per country (source)
- Importing from ThePeerage (Nov. 2019) added 50% to the number of Johns on Wikidata (source)
- SF movies and series with a significant character known to have been portrayed by an actor who was born in Liverpool (source)
- countries in Europe whose ISO 2-letter abbreviation contains letters not in the native language name of their country (source)
- places names in Wales with Welsh pronunciation audio (source)
- Map of types of GLAMs in Wales (source)
March[edit]
- Updated chart of the number of infections and deaths caused since the outbreak of SARS-CoV-2, as reported by the World Health Organisation
- British Prime Ministers with children under the age of 5 when elected, or born during their time in office (source)
- Timeline of countries of origin of the winner of the European Film Award for Best European Film
- People with profiles on the Washington Post website
- Subjects and panelists of the BBC radio programme In Our Time (source)
- People affected by COVID-19
- Map of hillforts in the UK (source)
- Images for language items (source)
- Timeline of films about pandemics
- World map of hospitals (source)
- English and Scottish health trusts & boards (source)
- Videogames nominated at the Pégases award (source)
- Most recent common ancestors of George W. Bush and Queen Elizabeth II
- Notable people with COVID-19 by number of sitelinks
- COVID-19 case statistics for India:
- * State-level map
- * State-level line graph
- Lakes spanning at least 3 countries (source)
- Michelin starred restaurants in Luxembourg (source)
- People born more than a year after one of their parents died
- UK MPs who were born after their father's death (source)
- National flags representing mountains (source)
- Map of Umgebindehäuser (Upper Lusatian houses) (source)
- Map of megaliths in Morbihan (Bretagne) (source)
April[edit]
- Country-level citation graph for #COVID19 (source)
- Movies from artfilm.ch in free access (source)
- Topic co-occurrence graph in the SARS-CoV-2 & #COVID19 literature (source)
- Fibulas in Musée Saint-Raymond with date, material, location of discovery
- Names of countries without letter "a" (source)
- Infectious diseases and their number of cases (source)
- Map of mountain huts in Bulgaria (source)
- Women with cats in paintings (Source)
- Films by Peter Mettler available free on VOD (Source)
- Films broadcast on VOD by artfilm.ch sorted by Director and Date (Source)
- Swiss films listed by date and duration per minutes (Source)
- Counties in England (Source)
- Programming Languages, Year of creation and Image of inventor(Source)
- Map of Antonine Wall items on Wikidata (Source)
- Map of Hospitals in Buenos Aires on Spanish Wikipedia (Source)
- Map of Michelin starred restaurants in Switzerland (Source)
- English civil parishes on Wikidata with OSM relation ID (Source)
- Collections in Louvre with an image on Wikimedia Commons (Source)
- Chief Mousers(Source)
- Books about Semantics (Source)
- Danish COVID-19 research projects(Source)
- Pairs of lakes named after a couple
- The longest river that feeds into another river (Source)
- Longest rivers that do not feed into a sea or ocean (Source)
- Map showing things in Wikidata that are located on or next to the River Thames (Source)
- Defining formulas of physical and other quantities (Source)
- TreeMap visualising the 12 times table (Source)
- Map of the "Leipzig University Villages" (Source)
- There are now more than 7 million people on Wikidata (Source)
- Recently published works on COVID-19 (Source)
- Welsh hospitals, health centres, doctors surgeries and temporary Covid19 hospitals (Source)
May[edit]
- Map of countries receiving the Nobel peace prize (Source)
- Map of geolocated Argentine libraries (Source)
- Recipes that include garlic (Source)
- Images of postcards from the catalog of the Regional bibliography of Saxony (Source)
- French municipalities which have the property "archived by" (P485) for the departmental archives of Bouches-du-Rhône (Source)
- Municipalities with less than 5,000 inhabitants in the Basque Country (Source)
- People born in Wales who became head of government in Wales or overseas (Source)
- Average stardate of Star Trek episodes (Source)
- Municipalities in mainland France with more than 50,000 inhabitants (Source)
- Graph showing direct ancestral lines linking Boris Johnson and George I, and Jesus and Abraham (Source)
- Photos by Carlton Watkins with their collection (Source)
- Works from Louvre Museum whose inventory number begins with an S (Source)
- Works from the Islamic arts department of Louvre Museum (Source)
- Map of artists with place of their birth on Wikidata (Source)
- Location and image of the cathedrals of Paris (Source)
- Jewish art collectors and dealers who were murdered in Nazi concentration camps (Source)
- Films claimed to pass the Bechdel test with less than 2 female cast members in Wikidata
- African-American librarians in Wikidata that don't have Wikipedia articles (Source)
- Magicians with known precise birth date (Source)
- Sheffield Shield cricket players and the number of states they have played in (Source)
- Number of Twitter followers of scientists at Dutch universities (Source)
- Former United Kingdom Parliament MP's still living (by first election) (Source)
- Number of paintings in National Gallery with artist and gender (Source)
- Nearby table tennis tables to public spaces for the Wiki Explorer Android application (Source)
- Map of Ramsar sites in France (Source)
- Highest software version numbers recorded on Wikidata (Source)
- Recommended units of measurement listed in the SI Brochure (9th, concise edition) (Source)
- Border with which all the municipalities of the Basque Country share (Source)
- Map of hospitals (blue) and health centers (green) of Argentina (Source)
- Best snipers of the world by number of victims of killer (Source)
- Plans and photographs of the restoration works of cathedrals in the 19th century contained in the French National Archives) (Source)
- Map of railways stations in France (Source)
- List of African countries with their current leaders and their ages (Source)
- Point in time of Advisor and Student relationships for professions mathematician and computer scientist (Source)
- Drawings with an image that depicts a ship (Source)
- Map of National parks in Sweden (Source)
- US States with an A (Source)
- Famous mathematicians related to famous actors (Source)
- West Highlands of Scotland rail line connections (Source)
- Universities ranked by PageRank on English Wikipedia (Source)
- Interactive, zoomable tree map of second level administrative regions of the world (Source)
- Number of alphabets which use this letter (Source)
- Metabolites and the species where they are found in (Source)
- Items in the United Kingdom with coordinate location (P625) on or near 1 degree 50 west (Source)
- Map of Tunisian museums (Source)
- Map of pairs of homonymous French municipalities linked by a colored line according to the distance (Source)
- Women botanists or botanical collectors with a birth date prior to 1900 (Source)
- vBIB20 lectures in Wikidata (Source)
June[edit]
- Map of German states with links to iNaturalist observations
- Cities/towns named after people (Source)
- Network of researchers who are vBIB20 co-presenters and are linked with a Wikidata item (Source)
- Timeline of legalized same-sex marriages by country (Source)
- BubbleChart of the 7,397 different keywords in DieDatenlaube (Source)
- Weight of royal crowns (Source)
- Recorded COVID-19 cases in difference Indian states (Source)
- Twitter accounts of current UK MP's (Source)
- Number of female employees at different organizations that Wikidata knows about (Source)
- Location of libraries that have a GitHub repository (Source)
- Location of 19th century infectious diseases published in Die Gartenlaube (Source)
- People with an entry in the Biographical Lexicon of the Austrian Empire and biographical articles in Die Datenlaube (Source)
- Fictional spaceship captains from the Star Trek multiverse (Source)
- Timeline of Selenographers, for the birthday of German astronomer Johann Heinrich von Mädler and his famous map of the Moon (Source)
- Points of interest 2 km within St. Jakobus church, Pesterwitz (Source)
- Images of religious art whose main theme is Pentecost (Source)
- World map of authors with both an ORCID and Twitter account ID's (Source)
- Completeness of Head of Government data for UN Member States (Source)
- Map of 2020 Art+Feminism editathons (Source)
- User:PAC2/Prenoms a notebook interface (Q28405706) to explore data about a given name (Q202444) : the idea is to ask simple questions and find answers
- Similarly the talk page of "Ada" with queries
- Postcards of exterior and interior views of theatres on CARTHALIA (Source)
- List of cities (or map) of Russia where no one famous was born and died (Source)
- Turkish scientists by citation count (Source)
- ESWC2020 papers with links to video lectures (Source)
- Women who have been Captain Regent of San Marino (Source)
- Species of birds (Source)
- List of open science fellows (Source)
- Spouses of the German Bundestag (Source)
- MWAPI searches in wikidata about people descibed as slave traders by citizenship (Source)
- Rose cultivars
- List of present-day countries and capital(s) (Source)
- Aliases of all sovereign states in Wikidata (Source)
- Monuments named after/commemorating/depicting slave traders (Source)
- Statues and monuments of slaveholders or traders (Source)
- Members of the Ku Klux Klan whose English description doesn’t mention that (Source)
- Bases named after Union soldiers (Source)
- Married couples who also sat in the Bundestag (Source)
- List of virtual conferences and their environment (Source)
- Network of the Erich Fried Prize winners (Source)
- Notable Russian people with possible (but unproved) descent from Genghis Khan (see the query for explanation)
- Researchers or academics with Native American ancestry
- Count of items by ethnic group (Source)
- Metro map of Stockholm Country showing line colors and layers (Source)
- Countries that have no world heritage sites (Source)
- Number of statues of women, per country (Source)
- 1st level subdivisions of Europe (and colonies) with less than 30 inhabitants per km² (Source)
- Apologies for both of the problematic queries ("MWAPI searches in wikidata about people described as slave traders by citizenship" in Weekly Summary #419 and "Monuments named after/commemorating/depicting slave traders” in Weekly Summary #420). The "MWAPI searches in wikidata about people described as slave traders by citizenship” in #419 lists any people with the word "slave" in a label, description or alias, among them several people who are not slave traders. The "Monuments named after/commemorating/depicting slave traders” in #420 incorrectly linked this query for enslaved people instead of this query for slavetraders.
- Ages of US presidents/vice-presidents: today, when leaving office, at death
- The subway network of Stockholm
- Former footballers who have ever been an MP in the UK parliament (Source)
- Latin American Women Writers with a GND ID (Source)
- Roads that are named after film directors (Source)
- Wikidata Queries around the SARS-CoV-2 virus and pandemic
- Timeline of U.S. Presidents
- List of MPs currently in the Sveriges riksdag (Source)
- Map showing people buried in Père Lachaise by place of birth (Source)
- Existing named trees in the world (Source)
- Artworks depicting things related to a fairy tale (Source)
July[edit]
- France has a new Prime Minister: see the list of all ministers in French history (very long scroll). If you want to know more, see this notebook
- Open data portals in Wikidata (using the newly created property Open Data portal (P8402))
- Objects that are named after people on Wikidata (Source)
- Illustrated Basque word of the day for children
- Oldest UK MPs at the time of election (Source)
- Map of archives in Wikidata (Source)
- Painters in Wikidata with the surname Ruiz (Source)
- Cities with female mayor (Source)
- MPs in the current UK parliament with identified mythical ancestors (Source)
- Indian subcontinent rail lines (Source)
- List of countries by age of the head of government (Source)
- Cities of the United States between 100,000 and 600,000 inhabitants with the counties and states they are located in (Source)
- People who have returned to being their country’s head of government after the longest gap (Source)
- Number of MPs elected to the Swedish parliament for each election back to 1970 (Source)
August[edit]
- Properties and the number of constraint definition statements on them - there are quite a few with 0 constraint definitions
- a graph of MPs and parties in the Swedish Parliament and with whom they worked together with to create motions 2018 SPOILER: >95% is just with people in the same party
- Wealthiest queer people on Wikidata (Source)
- Bubble chart showing the winners of the FA Cup (Source)
- Map of parks in Oslo missing images on Wikidata (Source)
- Orienteerers:
tinyurl.com/y25qa8ef(source, at 53:45) - Animal hugs:
tinyurl.com/yykvj26y(source) - Ancestors of the current King of Spain color coded by sex or gender
- Political alignments of the parties of world leaders (Source)
- Female Mathematicians whose birth/death anniversary is today (Source)
- Map of images found in the medieval Atlas De Wit (source)
- Things depicted with cats (source)
- Largest collections of Picasso content (Source). The National Gallery of Art holds the most with 303 objects
- Bubble chart of snooker world champions (Source)
- Map of streets in Tillydrone named after WW2 military leaders (Source)
- British MPs with sons- or daughters-in-law who were also MPs (source)
- MPs with the largest number of children or childen-in-law who became MPs (source)
- Descendants of Robert Emett (born 1729), with counts of sitelinks and external IDs for them and their spouses (source)
- Programming languages written by women (Source)
- Bar chart showing the number of research output (articles, etc) annotated with a SARSCoV2 proteins as 'main subject' (Source)
- Female soccer players who have a (known) social media account (Source)
- Largest cities in France by population (Source)
- Works in Helsinki, and their copyright status (source)
- Map of cities and towns in the San Jose–San Francisco–Oakland combined statistical area - OSM/Wikidata query
- Map of structures that have won architectural awards - OSM/Wikidata query
- Birth places of Buffalo Sabres players (Source)
- Timeline of all of Bird’s tunes (Source)
- Approximate proportion of people called "John" in any given UK Parliament since 1372 (Source)
- People born in Czechia who died in Germany and vice versa, by decade of birth (Source)
- Location of decommissioned aircraft - OSM/Wikidata query (Source)
- Railway network in Czechia (Source)
- People born in Czechia who died in Germany and vice versa, by decade (of birth) (Source)
- List of locations of Woolf's books (Source)
September[edit]
- Map of companies developing/manufacturing a COVID-19 vaccine candidate that is at least in a phase 1 clinical trial
- A table of the 100 highest fees charged for using various kinds of facilities, normalized to United States dollars - OSM/Wikidata query
- Youngest age of UK MPs leaving office since 1900 (Source)
- Longest time UK MPs lived after leaving office since 1900 (Source)
- British cabinet members with past military service (Source)
- Earliest written record of 10 largest Czech cities (Source)
- Churches dedicated to Czech patron St. Wenceslas (blue) and Moravian patrons St. Cyril and Methodeus (orange) (Source)
- German municipality names ending with -in, -ing, -heim (Source)
- Shortest path of descent from Charlemagne to George Washington, George W. Bush, Barack Obama, Elizabeth II
- List of most recent common ancestors (ordered by number of total degrees separated) between George Washington and George W. Bush (9th cousin 8 times removed), George Washington and Barack Obama (12th cousin 9 times removed), George Washington and Elizabeth II (2th consin 7 times removed), George W. Bush and Barack Obama (11th cousin), George W. Bush and Elizabeth II (14th cousin once removed), Barack Obama and Elizabeth II (19th cousin 3 times removed)
- Artists that have recorded songs in several languages, by number of different languages used (Source)
- Average age of companies listed on major indices (Source)
- Basque Country sister cities with world municipalities (Source)
- Map of companies developing/manufacturing a COVID-19 vaccine candidate that is at least in a phase 1 clinical trial (Source)
- Map of mountains in Austria showing their heights; from red for the lowest through green to black for the highest (Source)
- Top World Heritage sites by number of paintings depicting them (Source)
- Map of sports pitches for team sports that require between 10 and 20 players on the field - Wikidata/OSM query
- Map of anything that memorializes or is named after a Whig Party member - OSM/Wikidata query
- Map of every railway station presently connected directly or indirectly to St Pancras on Wikidata
- Age of the winners of the Tour de France (Source)
- Location and date of death of Danish rulers (Source)
- Map of the places & causes of death of Roman Emperors (Source)
- Images of members of the 16th Odisha Assembly (2019-24) (Source)
- Star signs of Japanese Prime Ministers (Source)
- Video game series with the longest time gap between a game and its direct sequel (Source)
- Table of the 100 most recent additions of interactive OpenStreetMap maps to English Wikipedia articles - OSM/Wikidata query
- Map of the birthplace of persons with an ELEM id on Wikidata (Source)
October[edit]
- Birthplace of people named Michael or any other variant of the name (Source)
- Map of outdoor warning sirens, color-coded by manufacturer. A layer selector lets you toggle individual manufacturers on and off. Clicking a siren shows its make and model if available. - OSM/Wikidata query
- Soviet cartoons in descending order of popularity in the world (Source)
- List of ISO countries showing each country's synonyms, labels, etc. (Source)
- Norwegian politicians who have been members of at least 3 parties (Source)
- Streets in Leiden named after people/things (Source)
- Maps of arts and humanities research grants funded by Arts and Humanities Research Council in UK between 2013-2019. Sorted by year, Sorted by budget (Source)
- Map of trees whose species is categorized as threatened on the IUCN Red List - OSM/Wikidata query
- Women actress less than 70 years old who are descendants of the first king of Navarre, ordered by number of sitelinks
- Dead Social Democratic Party members who have been ministers in 1992 or later (Source)
- Artworks with an image in Wikidata by year of creation (Source)
- Map of mountains in Switzerland (Source)
- Map of markets in the city of Surabaya (Source)
- National Anthems by tonality (Source)
- Gallery of 3D models of structures mapped in OpenStreetMap that are available under Creative Commons licenses at Wikimedia Commons - OSM/Wikidata query (sophox.org)
- Item named after item named after item named after item named after item named after item
- UK parliament members' opposition posts, start dates and end dates where Wikidata has a Parliament ID for that member (Source)
- Count of Irish Statutory Instruments, 1948-2020 (Source)
- Movie genre trends (Source)
- Scientific papers explaining backward contact tracing (Source)
- List of sovereign states in en, fr, de, ru (Source)
- Locations depicted in paintings (Source)
- The most commonly depicted locations (Source)
- Commemorative plaques and their subjects in Aberdeen, Scotland; with photos of plaque and subject and Wikipedia links. (Source)
- Cities with female mayor (Source)
- Most common variants of the name "Susanne" in each country (Source)
- Birthplaces of art historians (Source)
- Invasive species in EU and whether they have articles in different languages (Source)
- Birthplace of Olympique de Marseille players (Source)
- COVID-19 deaths by month (Source)
November[edit]
- Movies by rate of actors who studied at RADA (When distribution has at last 5 actors)
- Central libraries in California linked to their branch library
- Writers in the SIEFAR dictionary with a portrait in Wikimedia Commons (Source)
- Place and date of birth of people buried at Père Lachaise Cemetery (one color per century of birth) (Source)
- Occupations of people on Wikidata dying of coronavirus (politician ranks higher than the next 3 occupations combined) (Source)
- Things Donald Trump and others own / have owned (Source)
- Graveplots by gender in Père Lachaise Cemetery (Source)
- Co-authorship between researchers from National University of La Plata (Source)
- Number of Harvard Law graduates dead by year between 1850 and 1950 (Source)
- Visualization of the works of Charles Heaphy (Source)
- Identifiers present on the item for Penelope Cruz (or other movie people), but not on the item for Sean Connery
- Map of places of birth of people with an identifier Inter-university Health Library in Wikidata colored by century of birth (Source)
- Map of the trees recorded in OSM with protection status. OSM/Wikidata query Source
- Terminus locations of A Roads in Britain (Source)
- POTUS/UK PM age at inauguration/appointment and England mean age (Source)
- Map of (public-sector) winners of H2020 projects in the Netherlands sortable by year (Source)
- People who have held the positions of both Vice President and President of the United States (Source)
- Crew of missions to the ISS and human spaceflights that have docked with the ISS (Source)
- Graph of reasons UK MPs have left Parliament, grouped by decade since the 1890s (Source)
- Number of successful UK election petitions by parliamentary term, 1859 onwards (includes by-elections as well as general elections) (Source)
- List of longest Cars (Source)
- Rivers and canals in the United Kingdom.
- Map of images taken for the Wicipics photography campaign in Wales (Source)
- Number of people and terms of UK parties since the 1945 election (Source)
- UK MPs who have voluntarily resigned their seats and then come back for a different seat in the same Parliament (Source)
- Media articles, public documents and academic references on backward/cluster-focused contact tracing (including models) (Source)
- Date of birth of current French prefects and their sources (Source)
- Protected heritage related to the Camino in the Basque Country (Source)
- Living 'notable' people with the given name "Karen" per 100k per country (Source)
- Paintings in the Suter Art Gallery (Source)
- Chilean ministers who were not educated at any high school (Source)
- Age of US presidents start and end time (Source)
- Map of Welsh Railways (Source)
- Connections of railways of the Netherlands (Source)
- Distinct languages of Wikidata lexemes. Top 5 are Russian-101144, English-69066, Latin-32106, Hebrew-28286 and Basque-22904.(Source)
- Death place of all Basque people with known birthplace on Wikipedia, by century. Interactive map on kepler.gl (Source)
- Aberdeen recycling centers and recycling points (Source)
- Map of Semantic Web in Libraries 2020 participant's institutions (federated query) (Source)
- Women who play chess and have a Wikipedia article in Spanish (They are 132 while men have 899 entries) (Source)
- Timeline of Dietary Advocates (Source)
- Philosophers born between 0 and 500 grouped by the decade where they lived (Source)
- Video games from ?country (template) (Source)
- Politicians with an account at GitHub, CPAN, or Wikimedia (Source)
- Percentage of deaths caused by tuberculosis by decade (Source)
- Number of programming languages and their paradigms (Source)
- Museums within 2 miles of MoMA (federated query) (Source)
- Largest cities of the world ordered by population (Source)
- Italian politicians who served as a minister in more than one cabinet since 1990 (Source)
- People born after 1800 whose “name in native language” is in Latin (Source)
- UK statues and whether they are of nobles and/or women (Source)
- Location of German cities with a population count greater than 50.000 (Source)
- Map of medicines used (green) to fight infectious diseases (orange) (Source)
December[edit]
- Russian cuisine
- Belgian artists that rise to the public domain in 2021 (Source)
- Asian food made from noodles (Source)
- Bubble diagram by wiki page numbers in each language on objects kept at the Bardo National Museum (note: Commons is counted as English) (Source)
- Amusement parks around the world (Source)
- All stumbling stones in the city of Hannover
- (partial) list, timeline and gallery of successful ascents of Mount Everest (and few other summits)
- Web & social media URLs for UK Civic Societies (Source)
- Publication related to Research Institute of Text Analysis and Applications: no. of pages per author/year, authors network (Source)
- Map of the ritual objects said to be used by accused witches in Scotland (colourcoded layer accessible on top right to see the list of objects) (Source)
- Seats of the Parliament of England, and the first year we have a named person listed for them (Source)
- Female race car drivers on Spanish Wikipedia (Source)
- Places of Geological Interest in Alamedilla (Source)
- Number of Nature articles that were published on a Sunday in a given year
- Tex-Mex singers (Source)
- Map of images from Wicipics project (photography campaign in Wales) (Source)
- Vito Russo Test in Wikidata
- Distinct dialects of Wikidata lexemes (Source)
- Patronage of rapid-transit transportation (Source)
- People who played Julius Caesar, and what "version" of him they played
- Check Corona vaccine progress using Wikidata SPARQL to get metadata about the countries see notebook - SPARQL query