Wikidata:SPARQL query service/qotw/2021

Queries from Wikidata status update weekly summaries in 2021

January

(weekly summaries for: 04 11 18 25 )

• Works identified (via dedicated property P3893) as entering the public domain on 1/1/2021, ordered by number of articles on Wikimedia sites (Source)
• Painters in the collections of Paris Musées which enter the public domain on January 1 (Source)
• Map of forts related to Dutch trading companies VOC and WIC found in the Atlas of Mutual Heritage (Source)
• Map of forts in the Cologne fortress ring (Source)
• First-level administrative divisions in Germany
• Population of cities in Germany corresponds to the total number of vaccinations in Germany (Source)
• Most popular theorems according to their number of articles on Wikipedia (Source)
• Number of people who have died, or been diagnosed, of COVID-19, grouped by occupation (Source)
• Deaths in 2020 - date of birth, date of death, cause of death and country of nationality (Source)
• Summary of a UK parliamentary career seat-party-start pairs(Source)
• Timeline of aircraft types around the world and the first time a type of aircraft made a flight (Source)
• Indonesian legislation related to indigenous people (Source)
• Which artist could be "D.K. 1964"? (source)
• Line graph of colleges and universities in India by year of establishment (Source)
• Graph of Indian films that are remakes of other Indian films (Source)
• Graph of academic descendants of C. R. Rao and K. Ananda Rau (Source)
• Map of gram panchayats in Kerala by literacy rate in 2001 (Source)
• Maps of different places in West Bengal according to suffix (Source)
• Tree map of Rabindranath's poems according to the month of writing (Source)
• Count of locations of exhibitions on Wikidata (Source)
• Wikidata lexeme forms by language (Source)
• Mathematicians born in prime number years featuring Albert Einstein, Pierre de Fermat, Georg Ohm, Carl Gauss, Évariste Galois, Augustin-Louis Cauchy, James Maxwell et al.
• Timeline of coups d'état of the 21st century (including attempted ones) (Source)
• Map of Karens / Johns per million according to Wikidata (Source)
• Children of which were born with by a person, and their step child
• Map of the shortest railway path (in terms of number of stations) between Dibrugarh and the Scottish Highlands (Source)
• Map of place of birth of Olympique de Marseille football players (Source)
• Map of Kolkata wards by number of schools (Source)
• Map of beaches in Mexico (Source)
• Graph of shared borders between Indian districts (Source)
• Descendants of Upendrakishore Roy (Source)
• Timeline of Indian High Commissioners to Britain (Source)
• A tree map of items for artworks depicting Mughal emperors (Source)
• Example of documented usage of different Bengali words (Source)
• 'Llan' place names in the UK (Source)
• Organizations with DZI donation seal approval according to donation amount (Source)
• Red Cross and Red Crescent societies
• The people of the government of Bangladesh on 13 January 2005 (Source)
• Buildings in the Basque Country dedicated to San Roque (Source)
• List of words for "beard" in Eighth Schedule languages (Source)
• Map of train services starting at Howrah station (Source)
• Map of big sculptures of New Zealand (Source)
• Map of mosques in Bangladesh according to architectural style (Source)
• UK deaths per month since 2005 split by sex/gender (Source)
• Timeline of Indian cricket tours abroad (Source)
• Timeline of inception of Mexican universities (Source)
• Mangifera species and mango cultivars (Source)
• Locations where The Antartic Circumpolar Voyage expedition passed (Source)
• English Language forms missing an audio pronunciation -- you can contribute via LinguaLibre
• Czech religious buildings used also as a fire station
• Common ingredients to prepare a sandwich (Source)
• Location of GLAMs with open access policies (Source)
• Mexican presidents who have an image of their signature on Wikidata (Source)
• Timeline of Mexican writers who were born between 1800 and 1900 (Source)
• TV-Series in Spain by Decade (Source)
• Diplomats who are also art collectors (Source)

February

(weekly summaries for: 01 08 15 22 )

• Basque lexemes and their attestations in a 1745 Spanish-Basque dictionary, with links to dictionary entries in Wikisource
• Lexemes describing a color (Source)
• Danish-Hebrew Lexeme pairs (Source)
• Lexemes in Swedish with usage example that demonstrates both a form and a sense and a reference (Source)
• Episodes of the TV series "The Mentalist"
• Nationality of authors publishing papers relevant to the Australian fauna (Source)
• Number of musicians on Wikidata by country (Source)
• Map of ISO 3166-2 codes (Source)
• Map films that have been filmed in Mexico (Source)
• Map of Githubtopics on Wikidata (Source)
• Eye color distribution of the people on Wikidata (Source)
• Timeline with the start date of the Summer Olympics (Source)
• directors of episodes of The Mentalist (source)
• Articles from The Wētā entomology journal (Source)
• Town halls of the municipalities that surround Nantes (Source)
• Caves containing prehistoric art (Source)
• Endemic birds in a place located in France (Source)
• Spanish Wikipedia articles about women astronauts (Source)
• Websites related to works in the Women's & Gender History DH list (Source)
• List of states with more than one official language (Source)
• Location of the organizations in the Name Assigning Authority Number (NAAN) registry (Source)
• List of locations named after the planned language Esperanto or its founder, L. L. Zamenhof
• Use the MediaWiki API to get the content of a Wikipedia category into a query
• Number of scholarly articles sharing their datasets by year (Source)
• Most specific taxon that includes two given species (Source)
• List of vegan restaurants
• List of food that are iconic to particular countries (Source)
• Map of monuments in Lower Saxony, Germany (Source)
• Map of former plantations in Surinam (Source)
• Map of Wats in Thailand - (Source)
• Localities in Mexico and contain 𝐒𝐚n in their name (Source)
• Female mycologists born pre-1900, sorted by number of sitelinks (Source)
• Women scientists who were born between the year 1500 and 1900 (Source)

March

(weekly summaries for: 01 08 15 22 29 )

• Hungarian church buildings sorted by confessions (Source)
• Where Czechs most died if not in their place of birth (Source)
• Most popular tonalities (Source)
• Deceased people with verified Twitter accounts (source)
• members of Ludlamshöhle, a society in Vienna (1819-1826) (source)
• Things discovered or invented by women (Source)
• Latin American women who are activists and were born between 1900-1999 (ordered by the number of articles written on Wikipedia) (Source)
• Transportation routes in Zurich named after women (Source)
• Location of buildings designed by Zaha Hadid (Source)
• Proportion of Basque men / women in Donostialdea region (Source)
• Count of the industry companies on Wikidata belong to (Source)
• Danish verbs-derived-from-non-verbs (Source)
• Mountains of the Basque Country (Source)
• Railway junctions in Scotland (Source)
• Maps of Y-shaped subway lines (Source)
• Map of the hometown of Real Sociedad / Athletic Club players (Source)
• Count of type of things with IIIF links known to Wikidata (Source)
• Successful candidates during 2016 Kerala Legislative Assembly in each constituencies (Source)
• COVID-19 external Identifier URLs in Wikidata (Source)
• Public spaces whose names are of women (Source)
• Place of birth of females with biography articles on Basque Wikipedia (Source)
• Map of places in iNaturalist (Source)
• Number of elements of scientists by nationality (Source)
• Donald P. Bellisario credits as screenwriter or director
• Interwiki table from P6720, with end date for prefixes that are no longer in use (source)
• Index map of Ordnance Survey Old Series preparatory drawings, with georeferencer links (source)
• Listed buildings in Wales that would be lost if the sea level rose by 70 metres (source)
• Music releases with incomplete track lists, showing diff count (Source)
• Date and place of birth of female musicians in Nigeria (Source)
• Scholarly articles on multilingualism and bilingualism (Source)
• Things in Czechia which changed coordinate location at some point (Source)
• Images about women programmers (Source)
• UK railway stations connected from Topsham railway station (Source)
• Most awarded person affiliated with the Technical University of Denmark (Source)

April

(weekly summaries for: 05 12 19 26 )

• interwiki prefixes without corresponding Wikidata property by 2019 linkcount (some filtered) (source)
• Women whose article on English Wikipedia has the featured article badge (source)
• Map of males and females after which streets are named (Leiden, NL) (source)
• Map of birthplaces of trans women and men with articles in the Basque Wikipedia (source)
• Map of institutions where UNR faculty got their academic degrees (source)
• Map of location of sense usage (P6084) by language
• Botanists with image of signature and optional IPNI author ID (source)
• Subclasses of musical instrument with the most individual instances (source, result starts with: bell, organ)
• list of U.S. state songs, anthems, marches, hymns, cantatas, or missing (source)
• Adjacency map of Ordnance Survey Old Series preparatory drawings (source)
• Ordinals in all languages/notations: 0th to 100th (source)
• locked-room mysteries (source)
• Danish lexemes matched to sentences (Source)
• Twitter usernames and number of subscribers (Source)
• Latin American musicians without a Wikipedia article in Spanish but with an article in another language (Source)
• Artists on Spotify that lack a Spotify Artist ID (P1902) on Wikidata (Source)
• Timeline of the discovery of elements in the periodic table (Source)
• 19th-century depictions of sunflowers (Source)
• Czech art collections by size (Source)
• Timeline of road vehicles crashing into Montague Street Bridge, Melbourne, Victoria, Australia
• Coal-fired power plants in Germany (Source)
• Average lifespan by profession (Select the desired columns and get labels) (Source)
• The number of natural disasters in various countries since 1970 (Source)
• Heads of states/governments whose cause of death was a military casualty (Source)
• List of French stations sorted by number of tracks (Source)
• Relationship of the different Corona viruses (Source)
• Map of about one third of the ancient trees in Bulgaria (Source)
• Lexemes without statements or senses by language

May

(weekly summaries for: 03 10 17 24 31 )

• List number of albums (Q482994) by language (P407) in descending order (Source)
• Map of Scottish council areas (Source)
• Databases with a SPARQL endpoint, sorted by number of ids known by Wikidata (Source)
• List of actors and actresses who died during 2020 (Source)
• List of French firms without SIREN id (P1616) ordered by number of sitelinks with search links in annuaire-entreprises‧data‧gouv.fr : the query makes it easy to find the SIREN number (P1616) (source Property talk P1616)
• Number of works per year by researchers supervised by Lars Kai Hansen (source)
• Count of sitelinks of Nigerians on Wikidata (Source)
• 30 largest cities with female mayor (Source)
• Recent locations of boundary stones in Upper Lusatia (see pictures by clicking on the dots) (Source)
• Types of items in Australia that don't have identifier properties (Source)
• Number of species belonging to the different IUCN conservation categories (Source)
• List of Wikimedia language codes (Source)
• Plant genera that honor women (Source)
• Poets whose fathers are lawyers (Source)
• Phrase-book for types of food (mapping Catalan and English) (Source)
• Danish idioms (Source)
• Map of coronavirus research organizations active from before 2020 (Source)
• Scholarly articles about COVID-19 with "Wikipedia" in the title
• 20th-century UK parliaments with count of father/mother who were MPs (Source)
• The tallest known female politicians (Source)
• Writing systems/characters and their year of appearance (Source)
• Nocturnal animals based on diel cycle (Source)
• People with bird-like surnames in Czech (Source)
• Properties used to link from preprints (Q580922) to scholarly articles (Q13442814) (Source)
• Birthplace of Spanish poets (Source)
• UK Parliaments since 1801 with number of members, number of distinct member-terms, and count of missing seats/parties. (Source)

June

(weekly summaries for: 07 14 21 28 )

• Properties used to describe themselves (Inspiration)
• Most common name in Germany by year of birth (Source)
• Famous (not French) people born in France (Source)
• Lakes within 10 km of Berlin
• Old pictures from Swedish Digitalmuseum of bathing waters
• Bathing water in Sweden with distance to the center of the lake it is connected to
• Bathing water in Sweden located in Nature reserves (protected area, geojson)
• Map of the standard English and Welsh spellings of all places in the database (Source)
• Films directed by Agnès Varda and their publication date (Source)
• List of women who hold or have held the position of rector at a university (Source)
• Map of public bookcases
• SPARQL Jupyter notebook to explore generic queries for positions (using PAWS)
• Biographies that can be linked in different Wikipedias (apart from deWP) (Source)
• Vulnerable, endangered or extinct languages with number of lexemes in Wikidata (Source)
• Articles in English Wikipedia about women that have the good article badge but do not have an article written in Spanish (Source)
• Languages spoken by participants of Arctic Knot Conference 2021
• Street names in Alsatian (source)
• What kind of places in Wales host public toilets? (Source)
• UK Health Ministers and their occupations on Wikidata (Source)
• Count of statements by property for theatrical plays (Source)
• Things dedicated to St. John the Baptist (Source)

July

(weekly summaries for: 05 12 19 26 )

• List of pairs of senses on the same lexeme that have the same gloss in at least one language (Source)
• Which British Monarch saw most US Presidents; which US President saw most British Monarchs? (graph view) (dimensions view) (Source)
• All paintings (Q3305213) that depict (P180) a painting (Source)
• Count of qualifiers used in performer (P175) statements (Source)
• Scientific and Commons names of animals which are threatened as per IUCN Red List (Source)
• Latin American female mathematicians who are not on spanish Wikipedia but have an article in another language (Source)
• US Governors and their religion, if listed (Source)
• Living soccer players whose birthday is on January 1st (Source)
• Museums nearby Cēsis (Q107582) (Source)
• Distribution of public toilets per administrative units in Wales (Source)
• Subclasses of Q732577 'publication' found by the Gather, Apply & Scatter service (source)
• Places more or less on Papa Stour (using P1332-P1335 to constrain a wikibase:around search)
• Map of Sweden's outdoor gyms (Source)
• List of all stages of all tour de France (source)
• Comparing gender statistics about people cited in an article across several articles (source)
• Swedish Supreme Court judges who citing reports by commissions they themselves took part in (Source)
• Map public organizations that allow one to fill citizen's initiatives online (Source)
• Unemployment rate in Sweden by year (1970-2020) (Source)
• Serious plane crashes with only one survivor (Source)
• Mayors' genders of U.S. cities above 100k population (Source)
• Global usage of pronouns (in English Language) (Source)
• Number of causes of death (P509) 2019-2021 separated by year so that a comparison of the causes of death before and during the pandemic can also be seen (Source)
• List of all stage winners in the Tour de France with links to the list of stages won (source)
• Map of miniature parks (Source)
• Map of open data portals (Source)
• Video games published before 1980, and their authors (Source)
• Protected bridges over the Zadorra river basin (Source)

August

(weekly summaries for: 02 09 16 23 30 )

• List of film directors who have worked with Jean-François Stevenin the most (source) Jean-François Stevenin is a French actor, dead the 27th of July
• French municipalities containing the word "ville" (Source)
• Most frequently occurring titles found on audio tracks (Source)
• Museums within 70 km of Dresden (Source)
• Map of Welsh lakes and reservoirs (Source)
• Gender statistics about featured articles in fr.wikipedia.org
• Statistics about featured articles in fr.wikipedia.org by their value of instance of property
• Place of birth of Swedish 1912 Summer Olympics participants (Source)
• Interactive map with all Olympic Games medalists by place of birth (Source)
• List of properties which have instances or subclass of organisations as possible value (source)
• List of classes which are used as value constraints for the properties (source)
• Concepts, processes, practices, etc. linked to the philosophical concept of power (Source)
• Twelve Times table using Wikidata items (Source)
• Newly protected World Heritage sites in 2021 (Source)
• Total number of wins for each world snooker champion (Source)
• Who was the UK Prime Minister when each of the English Premier League/First Division title winners last won the title (Source)
• Map of the birthplace of sports team players by decade (lines link birthplace to home venue location) (Source)
• Predicates implicated in non-scholarly-article item bloat (source)
• Church of Scotland Synods as Geoshapes (Source)
• Map of the origin of Balinese palm-leaf manuscripts, current location (Source)
• Current principal local authorities in England
• Map of Items in Sweden with coordinate location and elevation above sea-level statements (Source)
• Map of UK's most extreme cities (Source)
• All current principal Local Authorities in England (Source)

September

(weekly summaries for: 06 13 20 27 )

• Paintings by Waldmüller in the Belvedere, Vienna - Austria (Source)
• Coauthors of coauthors of Birgit Meldal (Q46168094) that have never directly coauthored a paper with her (Source)
• Country-level citation network in biometrics (Scholia) (Source)
• Council Information Systems with OParlOrg API endpoints (Q47450936) (Source)
• List of movies with Jean-Paul Belmondo ordered by number of sitelinks (based on source via d:Template:Generic queries for actors)
• List of actors with whom Jean-Paul Belmondo has played the most (based on source via d:Template:Generic queries for actors)
• count of movies with Jean-Paul Belmondo by decade
• List of characters in Tintin ordered by number of apparitions (source)
• People with no birth/death/floruit dates but which have a position from which dates can be inferred (source)
• Map of the origin of diamond open access journal (Q108440863) publications (source)
• Map of place names in Ghana ending with "li", "ti", "om" (source)
• Biological taxa named after (metal (and other) music bands
• Works by Dante Alighieri (1265 - September 13/14, 1321)
• Cumulative page views for candidates in Czech parliamentary election 2021, split by party (Source)
• Given name "Filaret" ranked within similar names (source: talk page of item)
• Start time of open access journals known to Wikidata (Source)
• Mouths of rivers flowing into the Arctic (Source)
• What chocolate mousse is called in different languages (Source)
• Women in Wikidata whose husbands are economists with articles on the English Wikipedia, but they themselves lack articles (adapted from Source)
• Same with husbands (adapted from Source)
• People employed by the ZDF with an image on Commons and a link to the German language Wikipedia (Source)
• Coordinates of the birth places of people named Antoine (Source)
• Place of birth of people named Antoine, Tony, Antonio, etc
• UK MPs who had the most identified descendants who were themselves MPs (Source)

October

(weekly summaries for: 04 11 18 25 )

• Women born in Nigeria with an article in Basque for Listeria (Source)
• Still life paintings by women (Source)
• Map of cemeteries in New Zealand (Source)
• Right Livelihood Award laureates (Source)
• Chelsea FC players, with English Wikipedia article, Commons image, etc (Source)
• Share of women for each Nobel prize (source)
• Nobel Prize statistics on number of recipients for award wrt. gender (interactive plot) (source)
• Share of women among Nobel prize winners by decade
• Notable books on linked data, semantic technologies, and semantic knowledge graphs (source)
• Benelux railway stations connected from Brussels-South railway station (Q800587) (source)
• Date of opening and closing of railway stations in Denmark (Source)
• Map or Talaiotic archeological culture sites located in the Menorca island in Spain (source)
• Location of all the meteorological stations in Navarre (source)
• Photos of participants in the Pandora Papers (source)
• Diameter, size and mass of balls (source)
• French departments with their shape
• Longest rivers located in France and which did not gave their name to a department (source)
• Statues measuring more than 30 m in height (excluding the pedestal) (Source)
• List of written works authored by recent Nobel laureate Joshua Angrist (via d:Template:Item documentation on d:Talk:Q921499)
• Books by Canadian authors with a Wikisource page (Source)
• Repetitive taxon names (Source)
• Count of sitelinks of museums/tourist attractions in the US (Source)
• Map of French communes that are >30 characters long (Source)
• Lexemes in Swedish that are missing in Svenska Akademiens Ordbok (Q1935308) (Source)
• Attendance at the Bargoin, Roger-Quilliot and Henri-Lecoq museums per year (Source)
• Present and past members of Czech Chamber of Deputies who are relatives (Source)
• Map of mosques (Source)
• Documents from the Boyer collection by decades, subjects most represented (Source)
• Pronouns of people in different languages (Source)
• Twitter accounts of libraries in Switzerland (Source)
• Images of cell types in Wikidata (Source)
• Map of the place of death of people born in Puy-de-Dôme (Source)
• Graph of NFDI consortia with their fields of work, the map of (co-)applicants, (Source)
• Places where people in South-America work who published on Wikidata (Source)
• Rail link between Narvik and Singapore (Source)

November

(weekly summaries for: 01 08 15 22 29 )

• Map of French bridges and tunnels carrying an high-speed railway line
• List of Wikidata item's labels which are same as male form and different from female form in French (ie using the generic as male form) (source)
• List of Wikidata item's labels which are same as male form and different from female form in English (ie using the generic as male form)(source)
• consorts of Selim III (source)
• Coordinates of the birthplaces of people with family name Autrique (Source)
• Coordinates of battles (Source)
• Geographical distribution of votive boats historic monuments in France (Source)
• Relationship among accepted NFDI consortia (Source)
• Number of virtual twins (pair with the same dates of birth and death) in Wikidata (source)
• People recently buried in a cemetery nearby without an image of the grave (P1442) on Wikidata (source)
• List of lexemes in French associated with occupation items (source)
• Towns with less than 1000 people that have a cathedral (Source)
• Musical works based on literary works (Source)
• Main surnames of people born in the Puy-de-Dôme, France (Source)
• Members of the Ukrainian national sports team (Source)
• List of properties which have instances or subclass of humans as possible value with male and female form in French (source)
• Different people with same label / birthday / occupation in a specified year
• Narrative locations of the book Itinerary from Paris to Mont-d'Or (Source)
• Maps of tombs of unknown soldiers (Source)
• Most common first names (> 5) among people with a Wikidata item and born in Auvergne (Source)
• Student-Teacher relationship based on entries in 'Das Geistige Berlin' (1897) (Source)
• Relative frequency of reasons MPs' terms end, since 1870 (Source)
• Numbers from 0 to 20 sorted alphabetically thanks to lexicographical data (source)
• Given names of French fictional characters, as chosen by French / non-French authors (Source)
• Map of members of the International Society of Biocuration (historical and current; affiliation and education institutions) (Source)
• UK MPs and their reason for *finally* leaving office (Source)
• Number of new UK MPs at each general election since 1870 (new = never served before) (Source)
• Crewe Alexandra players from Crewe (Source)
• Chronological timeline of people buried in Cimetière des Carmes (Source)
• Stops in the travel routes of Wilhelm Müller on his way from Leipzig to Bad Schandau in 1820/21 (Source)
• Number of items without any statements (last week: more than 1,300,000)
• Number of items without any statements by sitelinks (sample: 1757 items link to nlwiki, but have no statements).
• Taxa named after women (by place of birth) (Source)
• List of articles on Blaise Pascal in all Wikipedias, sorted by decreasing article size (Source)
• Texts on French Wikisource by people born in Puy-de-Dôme (Source)
• List of countries by the highest elevation point (Source)
• Number of distinct (UK parliament) seats returning someone who chose to sit elsewhere each year, 1830-1910 (Source)
• List of services that support the OpenRefine Reconciliation service (Source)
• Things depicted in art works in the Khalili Collections (Source)
• Images of Wikidata's items linked to UBERON ids (Source)
• Population density of administrative subdivisions exceeding 100,000 km² and 100 inhabitants / km² (Source)
• List of government agencies in Scotland (Source)
• Which day of the week people died on in the Mauthausen concentration camp (Source)

December

(weekly summaries for: 06 13 20 27 )

• List of laureates of the women's Ballon d'or (source)
• List of people born in Cook Islands (source)
• Wordcloud articles without statements of MyLang Wikipedia (switch to "Table" view to list, at left border of screen)
• Artworks picturing snow (source)
• Graph of football players who died per year (source)
• Things depicted in art works of the Khalili Collections (source)
• People represented on the painting "Le Sacre de Napoléon" from 1804 by Jacques-Louis David (source)
• German cities whose names are also verbs (using Lexemes) (source)
• Railway stations in the Baltics (source, see the full thread for more queries)
• French departments with more population than all their neighbour departements (source)
• Map of places names after horses (source)
• Latvian citizens by occupation (source)
• Map of the mass graves from the Spanish Civil War (source)
• Shijian (SJ 实践) experimental satellites (source)
• Age of living Hawthorn FC players (source)
• People died on their 50th birthday (Source)
• Relationship between London School of Economics doctoral advisors and students (source)
• Map of twinned towns (or partners) of municipalities of Puy-de-Dôme (source)
• Map of the places named in reference the horse (source)
• Map of bridges in Kaliningrad (source)
• Latvian citizens by occupation (source)
• Wikidata items which are the most linked by lexemes using the property “item for this sense” (source)
• Actors in Christmas movies: by frequency, with film titles and sample film item (source)
• Filming locations of Christmas movies, with film titles and sample film item (source)
• Recent Christmas movies lacking filming location (source)
• Places that appear in the Encyclopaedia Britannica, the Great Russian Encyclopaedia, the Great Catalan Encyclopaedia and the Store Norske Leksikon, (ordered by country) (source)
• Christmas traditions around the world (with pictures) (source)
• UK parties since 1935 that have only ever been represented by a single MP (source)
• Brazilians with most Wikipedia pages across languages (source)