Wikidata:SPARQL query service/qotw/2022
Queries from Wikidata status update weekly summaries in 2022
January
[edit]- Map of New Zealand suburbs (source)
- Graph of influences in the Age of Enlightenment (source)
- Family names shared by astronauts (along with how often they occur in Wikidata) (source)
- Bills and coins of Brazilian Real (with pictures) (source)
- People awarded by the French Legion of Honour on Dec 31, 2021 (source)
- Average height of people named Joe (Source)
- Indian writers who died in 1961 (Source)
- Authors without field of work but with topic-tagged publications
- Compound first names starting with "John" (and the number of uses on Wikidata) (Source)
- Presidents of Brazil with the most awards (Source)
- Locations of parishes across Scotland (Source)
- Map of where Roman Catholic Popes were born (Source)
- Birth place of people who are described in the Encyclopaedia Britannica, the Great Russian Encyclopedia, the Great Catalan Encyclopedia and the Store Norske Leksikon (Source)
- Various kinds of New Year's celebrations in the world (Source)
- World map of recent censuses known at Wikidata for each decade (source) select decade on the right side
- Non-English labels for a set of objects, with the names of the languages (source)
- Things that turned 20 years old today (source)
- Irish artists and their relationships (source)
- Eating or drinking establishments near you (1.5 radius) (source)
- Most common day for UK by-elections since 1880 (source)
- Map of tramways in France
- Map of categories for honorary citizens (source)
- Map of the Medieval universities and its founding date (source)
- Camps/subcamps within a 20km radius of your location (source)
- Taxa found at Fazenda Tamanduá (Sertão of Paraíba - Brazil) (source)
- Birthplace of Rabbis (source)
- Italian parliamentarians and ministers aged between 50 and 80 (source)
- Female Irish scientists in Wikidata without a Wikipedia article (source)
- Places in the Hautes-Alpes that are the subject of an article on Wikipedia in at least 10 languages (source)
- US states with the most punk bands (source)
- List of Ghanaian scientists by citation count (source)
- Actresses who have played Elizabeth Bennett in Pride and Prejudice, with type of production (source)
- MPs with identified mythical ancestors
- Items with "language of work or name = Toki Pona" as qualifier
- Timeline of 1st women practising a given sports discipline (source)
- Water boards in the Netherlands (source)
- Birthplaces of US Presidents, Russian emperors, Roman emperors (source)
- Age of the actress when she played "Elizabeth Bennet" (source)
- People with dates of birth and death on January 1st (day precision dates) (source)
- More than 500 lexemes in Breton now have at least one sense (source)
February
[edit]- Events by number of video games announced (source)
- Three-Michelin Stars restaurants with a female chef (source)
- Wikidata Properties specific to German Lexemes and number of times they are used (source)
- Countries with count of same Wikidata labels in different languages (source)
- Team and positions played by National Women's Football League players (source)
- Location of the graves of personalities in Père Lachaise Cemetery who died between 1800 and 1849 (50 year ranges) (source)
- Location of statues of women in Italy (source)
- Count of Lexeme pairs between different languages (source)
- Birthplaces of General secretaries of USSR (source)
- Items related to Abdülmecid I, their collections, and their types (source)
- Objects related in some way to Aurangzeb (source)
- Tram bridges in France
- Polish Righteous Among the Nations
- Launch date, logo of social media services (source)
- Oscar winners from 1929 (source)
- Images of biologists by height (source)
- Biggest coins outside the U.S. (source)
- Frequency of letters in five-letter words in Wikidata lexeme forms (source)
- Visualization of the Prime/Ulam Spiral using natural numbers and primes stored in Wikidata (source)
- Monuments that are named after somebody without being connected to them by any other property (source)
- Places named after Valentine's Day (Saint Valentine) (source)
- Gold medal winners in the Olympic Games by age (source)
- Top 20 languages in number of lexemes in Wikidata and percentage of lexemes with at least one external ID (source)
- Count of PropertyLabels for lakes in the UK (source)
- Moons of solar system planets and what they are names for (source)
- Number of edits by user on French lexemes (source)
- Languages in Indonesia with their status according to UNESCO (source)
- Successful coups and attempts in Africa (source)
- New York Times journalists that are alive (source)
- Ukrainian coins and banknotes (source)
- Types of quartz (source)
March
[edit]- Use of free software license for describing software (source)
- Count of latest available Twitter follower count for different programming languages (source)
- Timeline of programming languages and their paradigms (source)
- Most popular programming language on Wikipedia with multilingual articles (source)
- Russian TV channels from and about Russia (source)
- Places of birth of people named "Désirée" (source)
- People in the Père-Lachaise cemetery who were born in a city that is or was in Ukraine (source)
- Properties linking between a church and its saint (source)
- Properties describing Art UK artworks (source)
- Timeline of victims of the 2022 Russian invasion of Ukraine
- Language of work or name of 1.000.000 scholarly articles
- Population of countries that share a border with Russia (source)
- Audio pronunciation of places in Wales (source)
- Things with a national gallery of Scotland ID where the artist was or is a woman (source)
- Software with gender information of developer, designer and the person named after source
- Signature images from Wikidata (change the view to “map” to see the signatures arranged by the person’s place of birth! (source)
- Count of UK lake items with a 'UK Lakes Portal ID' (P7548) property statement (source)
- Travel reports by Alfred Brehm as timeline (source)
- Timeline for the Apple "M" series of Systems on a Chip (SoC)
- Religion of men named “Maria” (as one of their given names) (source)
- Shortest rail link between Narvik and Singapore (passing through Finland and Kazakhstan)
- Map of institutions where "where people who studied there" have created written works whose main subject is knowledge graph (Q33002955), knowledge base (Q515701) and (Q33002955)
- Colonies of Africa with their or their “main state”’s official language and ISO code
- Wikidata knowledge graph of Elizabeth Keckley, dressmaker to U.S. First Lady Mary Todd Lincoln (source)
- Women who served as defense ministers in various countries (source)
- UK MPs who had paired names (e.g. Owen Thomas / Thomas Owen) (source)
- List of properties associated with items that are class/subclass of File Format (source)
- Table frequency of properties used in instances of public libraries
April
[edit]- Long swedish / german nouns in Wikidata (source)
- Texts which have Wikisource links in English and French (source)
- Most popular Chess openings (by number of sitelinks) (source)
- Random set of popular ("having more than 20 site links") items (source)
- Wikimedia affiliates on social media (source)
- Listed viaducts in the UK (source)
- Pages linked to the University of Clermont according to the number of articles on Wikimedia projects (source)
- Which languages share a word for the same thing (visualized as a tree map). e.g. planet (source)
- Birthplace of rappers (source)
- Bubble chart of occupation of people linked to University of Clermont (source)
- List of corporate archives, location, and address where available (source)
- French adventure video games (source)
- Women with the citizenship of a country and the most articles in other languages (including English) but without an article in French Wikipedia (source)
- Countries that are bigger (blue) or smaller (red) than all their neighbours (source)
- Top 100 lexemes with the most number of senses
- Given a language and a country, show a map of the demonyms in that language that are used in any part within that country
- Most common classes for values of "depicts" (P180) on Commons (source)
- Scottish river drainage basins (source)
- The earliest road accident victims (source)
- Country of nationality of people linked to the Ghana's top 3 traditional universities (source)
- Count of Wikidata property types (source)
May
[edit]- Languages and dialects with number of first language speakers (preferred rank) (source)
- Graph of influences in the age of Enlightenment (source)
- Countries which are named after a person (source)
- Number of musical works (compositions) in Wikidata by language, in descending order (source)
- List of French public administrations with an open data portal, a siren number (P1616) and a servicepublic id (P6671) (source)
- Largest cities with a female mayor (source)
- Reach of Twitter accounts on Wikidata (source)
- Which works published in the 1970s have been most cited from works on archaeology? (source)
- List of oldest cryptocurrencies
- Scottish rivers that merge to make a river with a new name {source)
- List of candidates in the French legislative elections (source)
- List of people with Elisabeth, Élisabeth or Elizabeth as first name (source)
- Wikimedians with a Twitch channel (source)
- Relationships of Roman deities (source)
- Ingrediants of dishes on Wikidata (source)
- Food names after a place in the UK (source)
- French heads of government classified by tenure (source)
- Places in Antarctica over 3000km away from the South Pole
- Topics that members of the Swedish Parliament motioned about 2020/21 (source)
- Albums with more than one language statement where none has preferred rank (source)
- List of candidates for the next French legislative elections (source)
- Occupation of people named Elizabeth, Élisabeth or Elisabeth in Wikidata (source)
- Percentage of films passing the Bechdel test by genre / percentage of films passing the reverse Bechdel test by genre
- Timeline of the start of pride parades from 1970 (source)
- Top 20 genes with most genetic associations on Wikidata (source)
- Biennales that aren’t biennial (source)
June
[edit]- Which are the most popular natural products based on the number of statements on their corresponding QID? (from the Telegram Wikidata group)
- Occupation of people named Elizabeth, Elisabeth or Élisabeth (source)
- Thomas Telford's different alleged associations with buildings, according to wikidata statements (source)
- Averages of coordinates of depicted place (P9149) positions for Commons categories (useful as help in matching them to wikidata items) (source)
- items with senses in the most languages on Wikidata, with a sample language and lexeme in that language.
- Graph of the characters present in Mario franchise games (source)
- A & B roads carried on Scottish bridges (source)
- Timeline of Rafael Nadal awards and nominations (source)
- Articles studying chemicals from the oceans (source)
- Municipalities of France, by their population and their altitude (source)
- In cousin marriages (born 1800 and later) (source)
- Actors who played the same real politician the most times (source)
- Most famous heritage locations (measured by sitelinks) (source)
- Islands with at least 1 spring or freshwater body (source)
- Notable people who you share a birthday with (find the string "1966-08-25" and replace it with your date of birth) (source)
- List of filmmakers with whom Jean-Louis Trintignant has played (source)
- Cemeteries in France near churches (source)
- Graph of fictional wars and their participants (source)
- The 100 most common species as subjects of publications known to Wikidata (source)
- Map of birthplaces of ASM Clermont Auvergne players (source)
July
[edit]- Number of albums in Wikidata by language, in descending order (source)
- Occupation about musicians in Wales (source)
- Map of tram depots in France
- Mountains higher than 2,500 meters in France (source)
- List of all Tour de France's stage winners by nationality from 1903 to 2022 (source)
- French rugby teams according to the year of creation (source)
- French members of parliament that were on the same legislature and are or have been married (source)
- Number of countries on Wikidata where at least one pride parade has been held (source)
- Football players whose birthday is today (different every day) (source)
- Current list of French departments (documentation)
- Prime ministers of Japan whose manner of death is homicide (source)
- 1st level administrative subdivisions with more than 10 million inhabitants (source)
- List of globes and how many times they've been used
- List of recent heatwaves (source)
- Most recent information leaks according to Wikidata (source)
- Cause and mode of death of ex-prime ministers (source)
- Brazilian writers born in a city with less than 20000 inhabitants (source)
- Lexical categories sorted by number of languages using them in Wikidata lexemes (source)
- People playing rugby union by number of Wikipages (source)
- Map of driverless rapid transit railway lines worldwide
- An example of finding problematic references
- Papers by University of Leeds researchers that might have figures suitable for Wikimedia Commons (with a CC-BY or CC-BY-SA licence, with full text online)
- People born on rivers (source)
- Humans with "native language" "German"
August
[edit]- Grammatical features used on forms of French lexemes (source)
- Most notable people (by sitelinks) (source)
- List of draughts (source)
- Map of NZ graduates based on coordinates of employer (source)
- Most recent date not used as a date of birth (P569) or date of death (P570)
- Map of war memorials, showing EN Wikipedia article if it exists (source)
- Most frequent occupations of people born in Épinal (source)
- Species named after places in the state of Espírito Santo (source)
- Places named after Lenin (source)
- Most common numbers of statements per item (source)
- Locations and depicts statements for images in Commons category Mosques in Dubai (source)
- Art people who died in Nazi camps (source)
- Count of items in Wikidata by number of statements in the item (source)
- Fungi with image, ordered by number of languages it has an article (source)
- Longest natural watercourses in France (source)
- Multiple forms of a Lexeme with the same grammatical features and where no of these forms have any other statement
- Bengali Lexemes all of whose parts are derived from Sanskrit words, but which themselves aren't derived from Sanskrit words yet
- Longest tram line in the world with 68 stops
- Map of Coast Tram (Q1510414)1
- Most frequent .uk domains for P973 "described at URL" (source)
- Online accounts used by people that were born in People's Republic of China (Source)
- Journals with the most retractions (source)
- Occupations as classified by ISCO/ESCO (source)
- Occupation of people in the New Zealand Thesis Project (source)
- Average weights and heights of sportsmen (source)
- Letters by numbers of alphabet where they are found (source)
September
[edit]- Map of burials at Père Lachaise Cemetery in Paris, and around the world that have P625 as a qualifier (source)
- Age of Leonardo DiCaprio's girlfriends 1997-2002 (source)
- Education of French prefects (source)
- Number of substance records in PubChem Compounds (source)
- Map of rivers longer than 50 km passing through French territory, grouped by watershed (source)
- Brazilian players in the Fifa World Cup 2022 Sticker Album! (source)
- Language Wikipedias having biographies on recent UK Prime Ministers - (source)
- Has Wikidata been updated to show replacement UK ministers post the Great Boris Resignation of July 2022? - (source)
- Map of Global Administrative Areas (GADM) with links to Global Biodiversity Information Facility (GBIF) datasets (source)
- Places of birth of heads of the city of Riga 1890-2022 (source)
- Things named after Queen Elizabeth II (source)
- Essential Open-Source Software funded by CZI Science (source)
- Timeline of movies directed by Jean Luc Godard (source)
- Map of narrative locations of movies directed by Jean-Luc Godard (source)
- List of actors and actresses who have worked with Jean-Luc Godard by number of movies (source)
- Route of the Aberdeenshire Canal, as indicated by its remains (source)
- People born in Rennes classified according to the number of links pointing to them (source)
- French heads of state and government who were not born on current French territory (and after 1789) (source)
- Where were the players in the FIFA 2022 Sticker Album born? (source)
- World Cup Qatar 2022: The heaviest team is Ghana, averaging 87 kilos, and the lightest is Qatar, averaging 70 kilos (source)
- Streets of Milan, Italy named after males (blue) vs. females (orange) (source)
- Map of Roman theaters and amphitheaters (source)
- Chart of English monarch names by cause of death
- Cause of death of US presidents by party
- Smallest cities with at least two metro lines (source)
- Chart of occupation of people born in New Zealander (source)
- Capoeira practitioners through time! (birthdates) (source)
- Gallery of mid-seventeenth-century bishops (source)
- Song titles that match female given names (source)
- Songs about Elizabeth II (source)
- Student-advisor graph (Stanford University) (source)
- Official languages of Latin America and the Caribbean! (size proportional to the population of the countries) (source)
- People in the 2022–2026 parliamentary term of the Swedish Riksdag (source)
- Software license, by year (source)
October
[edit]- UK railway stations with coordinates sourced to English Wikipedia that have different coordinates on English Wikipedia (1/10) (source)
- Graph visualisation of 12 British monarchs and their 56 British prime ministers (source)
- British Monarchs vs. US Presidents (source)
- Children of Nobel laureates have themselves been awarded the prize (source)
- Profession and gender of people whose works are kept in the Musée de Bretagne (source)
- Map the type locality of New Zealand endemic species (source)
- Map visualization of Wikidata items located in Ukraine (source)
- Map of birthplaces of women in Finistère (with and without photo) (source)
- People in the British Museum's person-institution thesaurus by gender and occupation (source)
- Films with "it" in the title (source)
- Buildings most depicted on paintings (source)
- Emblems depicting birds! (source)
- Number and percent of lexemes with an external ID for top 20 languages in Wikidata (source)
- Wikidata has more than 200 Klingon lexemes. qapla'!
- Map of historic Welsh parishes (source)
- "Controversies” articles with the most sitelinks (language versions) (source)
- Are you cited by Nobel Prize winners? (Replace with your ORCID id in query to check) (source)
- Current members of UK Parliament and their PhD theses (source)
- Map of Rennes, each dot is a thoroughfare, in blue if there is an image of their name sign on Wikimedia Commons, red otherwise (source)
- Count of all external identifiers for people with ADB identifier (source)
- Bands that have had more members than the Sugababes (source)
- Average age difference from one's spouse, by profession, (for men) and (women) (source)
- How long has each UK chancellor been in office? (source)
- Streets of Paris that meet (source)
- Players in the FIFA World Cup 2022 Sticker Album with most years in the national team (source)
- Number of French lexemes per number of dictionaries they are linked to (source)
- People born in Split or Šibenik for whom there is a statement that they wrote or spoke Latin (source)
- Locations of employers/affiliations of first authors of articles in the Journal of Cheminformatics (source)
- Birthplaces of the presidents of the American Medical Association (source)
- Flags containing the colors white and yellow (source)
- AI models (source)
- Swedes accused for churel (source)
- Lunar craters and gender of their namesakes (source)
- Collaborative map of events taking place for Wikidata's 10th birthday
- Birth year of winning candidate of the last eight U.S. presidential elections (source)
- Number of music albums by language in descending order (source)
- French préfets with their signature on Commons (source)
- Graph of filmi music composers (source)
- Map of the highest points of Spain provinces (source)
- Twitter usernames and associated mastodon adresses
November
[edit]- Intangible cultural heritage (source)
- Wikimedians with Mastodon accounts
- Politicians with Mastodon accounts (source)
- Graph of the characters of the book "We Are Here" (source)
- Map of birth places of women mentioned in the book "Femmes de lettres en Bretagne" (source)
- Participants in the 1955 Bandung Conference (source)
- Biggest Mastodon instances according to Wikidata
- Mastodon accounts of researchers (source)
- Most annotated servers according to Wikidata (source)
- Map of birthplaces of people with known mastodon address (source)
- European islands culminating at more than 1,000 m of altitude (source)
- Map of water bodies in France (source)
- Other awards won by winners of the Booker Prize (source)
- Timeline of Libre and Open Source videogames (source)
- Finding the first revision and original creator of items with mwapi
- Mastodon accounts (with Twitter equivalents) (source)
- Gender balances of winners of literary awards (source)
- Translated Wikidata property labels (top 100 languages) (source)
- Dentists who are notable footballers (source)
- Map of obelisks over 40 m high (source)
- Notable doctoral student/advisor pairs where at least one of them is within the Wikidata:WikiProject NZThesisProject (source)
- Wikimedia affiliates on Mastodon (source)
December
[edit]- Composers by country of birth and edition (source)
- Researchers with a Mastodon account and a known field of work (source)
- Count per each language of unique language codes used in lemmas for Lexemes in that language
- Person(s) after whom both a warship and a microarchitecture are named (source)
- Institutions that have contributed to all #vBIB conferences so far (source)
- Composers by country of birth and edition (source)
- Mountains in Iceland with no Cebuano Wikipedia sitelink (source)
- Universities that have an associated Mastodon account (source)
- Most frequently occurring titles found on audio tracks (source)
- Football skills! (source)
- Concepts with more individuals having Mastodon IDs (source)
- Mastodon follower/subscriber figures (source)
- Lexeme senses which are described in Jaehoon Yeon and Lucien Brown's Comprehensive Grammar of Korean (source)
- List of nonprofit organizations / NGOs on the fediverse that Wikidata knows about (source)
- Top album languages found on Wikidata right now (Dec. 24th) (source)
- Alpha-3 codes for countries in Europe (source)
- Location of paintings in the Paintings Department of the Louvre made by women source
- Most frequent birth places for Italian SBN authors (source)