Wikidata:SPARQL query service/qotw/2023
Queries from Wikidata status update weekly summaries in 2023
January
edit- Finnish hockey players whose child is also a hockey player (source)
- Map of the birthplaces of Italian authors who died in 1952 (source)
- Pairs of opposites (source)
- Ratio of paintings at the Museum of Brittany (source)
- Top album languages found on Wikidata right now (2023.01.08) (source)
- Cheeses named after towns (source)
- Map of sub-categories of a Commons category (source)
- Number of sitelinks to redirects by wiki (source)
- Top album languages found on Wikidata right now (source)
- Airports named after poets (source)
- Map of places that places in Rennes are named after (source)
- Map of places named after a place in Rennes, color coded by distance of the place from Rennes (source)
- Modern descendants of the Achaemenes (Achaemenid dynasty of rulers of Persia, 7th century BCE)
February
edit- Map of disasters by type (source)
- Maps of museums in Malaysia (source)
- Map with place names that gave names to places in Riga (source)
- Area of sovereign states without a river (source)
- Wikidata properties whose URL format matches some format (source)
- People born in the Vatican (https://twitter.com/slaettaratindur/status/1613861217440866306 source)
- Shortest rail link between Narvik and Singapore (source)
- Memes (source)
- Top album languages found on Wikidata right now (Week 4, 2023) (source)
- Number of literary works (Q7725634) by language (P407) in descending order (source)
- Humans that have a 'relationship' with University of Leeds (source)
- Railway stations named after literary works (source)
- Week 6, 2023: Top album languages found on Wikidata right now (source)
- Free software grouped by programming language and instance of (source)
- Historical timeline of WorldPride events: (2000 in Rome to 2023 in Sydney) (source)
- Which glaciers have been named after Moby Dick characters?
- Free software grouped by licenses (source)
- German nouns with unparseable combines statements
- Grammatical features used on English nouns and proper nouns
- List of countries sorted by life expectancy (source)
- Map of lighthouses in South America (source)
March
edit- Railway bridges in Germany and Austria (source)
- Number of deaths in train wrecks per country (source)
- Pairs of people who both have an English #Wikipedia article and are married to one another (source)
- Notable milkmaids
- Places of birth or death of female painters in Brittany (source)
- What profession do women in Basque Wikipedia biographies have? (source)
- World map according to shared borders (source)
- Top album languages found on Wikidata right now (Week 10, 2023) (source)
- Lexeme with a Sense related to a geolocated Item (source)
- Highest TV seasons numbers (source)
- Wikidata items which have both a UK Parliament Thesaurus ID and a subreddit (source)
- Number of books written in Basque grouped by the birth place of their authors (source)
April
edit- Authors from Latin America born today (source)
- Businesses whose official websites use the ".biz" top-level domain (source)
- Superheroes with a degree in the humanities (source)
- Places of discovery of objects held in the Musée de Bretagne (colored according to the period of the object) (source)
- People with far apart reported death dates (source)
- Top album languages found on Wikidata right now (source)
- Articles citing the most retracted articles (source)
- ATMs around Munich belonging to the Bankcard-Servicenetz interbank network (federated query)
- Population growth in Ghana from 1960 onward
- Administrative subdivisions with more than 10 million inhabitants (source)
- Rivers in France over 50 km long (source)
- List of mental disorders (source)
- Paintings once owned by Red Flag Names (source)
- Top album languages found on Wikidata right now (Week 16, 2023) (source)
- Place of birth of humans with Github username (source)
May
edit- Map of where the presidents of BCALA were educated (source)
- Number of Wikipedia sitelinks for Art Looting Investigation (source)
- Family relationships of New Zealand MPs (source)
- Mapping birthplace and place of death of female Dutch Resistance Fighters on a line (source)
- Countries that have site links to French Wikipedia with a parenthesis in the title (source)
- Map of libraries from Austria with ISIL-code or twitter-handle (source)
- Name of languages containing the words "old" or "ancient" (source)
- Birthplaces of humans called "Antoine" (source)
- Who took the most pictures on WikiCommons around a Wikidata item? (source)
- Graph of art (and other things) owned by Art Looting Red Flag Names or members of the Nazi Party at any time (source)
- Top album languages found on Wikidata right now (Week 19, 2023) (source)
- Scottish waterbodies & how they're linked (source)
- Count comparison of England, Scotland and Wales items claiming to be a human settlement as well as a parish (source)
- Twins at Eurovision (source)
June
edit- Terminus stations of the Transilien railroad network (source)
- List of children of Johann Sebastian Bach (source)
- Which mountaineers died on Mount Everest ordered by their death date? (source)
- Gallery of people born in Brittany and named Jeanne, Jean or Yann (source)
- List of botanical collectors who have a death date but don't have a Bionomia ID (source)
- British MPs who resigned from the Commons mid-parliament on two separate occasions (source)
- Dutch members of parliament with a Mastodon account (source)
- Last words of authors (adapted from a query generated by ChatGPT) (source)
- List of American actors and actresses having a wikipedia page with parents having a wikipedia page
- (history) Where were the borders crossing between German Democratic Republic (Q16957) and West Germany (Q713750) ?
- Week 25, 2023: Top album languages found on Wikidata right now (source)
July
edit- Subject areas of journals that have published papers about the replication crisis (by User:Zeromonk and User:MartinPoulter)
- Count of games published in ROM format per platform per year, 1995-1997 (source)
- Countries with similar populations
- Week 26, 2023: Top album languages found on Wikidata right now (source)
- Portraits of queer men people
- World Universities on Mastodon (source)
- List of data journals at Wikidata (source)
- Week 28, 2023: Top album languages found on Wikidata right now (source)
- Bubble graph of the first letter of the word for "one" for languages where Wikidata has a Lexeme (source)
- Searches for trying to replace broken Art UK external IDs (source)
- People linked in the English Wikipedia page "List of current United States governors" (source)
- List of people in the NZThesisProject with no assigned gender (source)
- Cultural institutions having a Mastodon handle (source)
- Maps of places in Rennes with an article on French Wikipedia, color-coded by number of pages on the Wikimedia Projects (source)
August
edit- Entry dates and discovery dates of the objects of the museum of Britanny (source)
- Map of places located in Rennes with an article on the French Wikipedia (and colored according to the number of pages in all Wikimedia projects)
- Teenage Mutant Ninja Turtles weapon types, and primary colors (source)
- Number of albums in Wikidata by year of release (source)
- Objects in Dresden with significant event (source)
- Count of items with an article on fr.wikivoyage.org by country (source)
- Count of items with an article on fr.wikiquote.org by instance of (source)
- Count of items that have X amount of statements. A simple showcase of Blazegraph optimizations.
- Week 33, 2023: Top album languages found on Wikidata right now (source)
- Map of birthplaces of German women writers (source)
- Week 34, 2023: Top album languages found on Wikidata right now (source)
- Where were people who went to space born? (source)
September
edit- Old Greek personalities with entries in Prosopographia attica (source)
- Largest heist by damage (source)
- Territories claimed by irredentism
- Map of tram stop all over the world (source)
- Map of public archives in Germany (source)
- Google Scholar Organization IDs to Wikidata (source)
- Power stations of this world (source)
- Usage state of the nuclear power plant (source)
- Subclass of blogger (source)
- List of taxon name as first having been described by Dennis P. Gordon (source)
- Gallery of wood cuts made before 1600, including file description and the link to the Wikimedia Commons file (source)
- Top album languages found on Wikidata right now (Week 38, 2023) (source)
October
edit- Most frequent birth places for PTBNP authors (source)
- University's museum in France (source)
- 52,153 French words which have both masculine and feminine forms (source)
- Accused witches in Scotland accused of shapeshifting(source)
- Argentinian national team football players that participating in 3 matches or bellow (source)
- List of people who are in Art Looting Investigation Unit red flag list (source)
- Main Subject bubble chart of Articles in Journals with AJOL ID, published in Ghana, about diseases (source: @espejolento)
- List of lighthouses in France (source)
- Which academic journals publish the most International Space Station Research? (graph) (source)
- Tamil Lexemes missing Item for this sense statements (source)
- People with no country of citizenship having Norwegian names (source)
- Birthplace of recipients of the Nazi Germany Iron Cross
- Burial place of Swedish Prime Ministers
- List of cathedrals around the world with its height (source)
- Population of Czech villages with rivers flowing through them (source)
- Ships with multiple operators that do not have multiple official names (source)
- Property completeness dashboard for manuscripts
- Map of narrative locations of romantic comedies (source)
- Tunisian scientists are cited by Nobel Prize winners (source)
- Which cathedrals are the tallest in the world? (source)
November
edit- List of phobias in French
- Interviewees who were part of the Suffragette Movement and
- Interviewees who had a relative or friend in the Suffragette Movement as part of the LSE Suffrage Interviews Project
- Map of every recorded battle the past 4,500 years (source)
- Map of locations of witch memorials and sites of interest in Scotland (source)
- Articles on English Wikipedia tagged 'Water pollution' with no equivalent article in Spanish (source)
- Highest point (in meters) per counties in Finland (source)
- Week 46, 2023: Top album languages found on Wikidata right now (source) "Basque are back on top for the second time this month"
- Rail link between Narvik and Singapore (source)
- Week 47, 2023: Top album languages found on Wikidata right now (source)
- Gender representation of Scottish witches (source)
- Most popular names in Ghana among Ghanaians on Wikidata (source)
December
edit- People born somewhere named after them (source)
- Rose cultivars named after screen writers source)
- Geolocalized object that have the same name than something named after some some kind of church building. This includes streets, bus stops, …
- Video games per Platform. Timeline of video game releases per platform.
- List of movies directed by French filmmakers born after 1930 with or without Depardieu (source)
- Czech buildings carved into the rock (source)
- Top album languages found on Wikidata right now (source)
- Works created by females, died in 2023
- Distribution of the different tram gauges in Germany (source)
- Scale of stampedes reported on Wikidata (source)
- Timeline of the Christmas movies (source)
- Christmas traditions around the world (with pictures) (source)