Wikidata:SPARQL query service/qotw/2021
Queries from Wikidata status update weekly summaries in 2021
January edit
- 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 edit
- 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 edit
- 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 edit
- 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 edit
- 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 edit
- 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 edit
- 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 edit
- 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 edit
- 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 edit
- 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 edit
- 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 edit
- 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)