Wikidata:SPARQL query service/qotw/2019
Jump to navigation
Jump to search
Queries from Wikidata status update weekly summaries in 2019
January[edit]
- Graph of student-master relationship of Christian Thielemann #Neujahrskonzert (source)
- Cricket teams in the world by number of players and their gender (source)
- Buildings designed by Brazilian architect Oscar Niemeyer (source)
- Species have been named after Donald Trump (source)
- Catchphrases (source)
- articles about obituaries (source)
- Map of Slovenian cultural monuments coloured by type (source)
- French settlements with more than one word in the name (source)
- People after which a state is named (source)
- "official name" statements including a slash punctuation mark (source)
- Streets in the Netherlands named after a woman described in Els Kloek's book (source)
- Map of parts of the wall of Philip II Augustus in Paris (source)
- Schools of magic by numbers of students (source)
- Members of the Association for Computing Machinery who also gave TED talks (source)
- Languages where some lexemes have more than one grammatical gender entered in Wikidata (source)
- Timeline of early French aviation pioneers (source)
- Map of schools where virtual twins were educated (source)
- Most cited Magnuses in Wikidata (source)
- Images of exoplanets (source)
- Types of protected historical objects in Loire-Atlantique, France (source)
- Common long words in scholarly article titles (source)
- Timeline of writing systems and alphabets (source)
- Image grid of synthesizers produced by ARP Instruments (source)
- Things depicted in the collections of the Cleveland Museum of Art and the Ashmolean Museum (source)
- Stradivari(us) instruments (source)
- Rivers whose names in Spanish start with "Guad" (source)
February[edit]
- Common topics of publications by people affiliated with a given organization
- World __ days and other awareness days in calendar order (Source)
- timeline of writing systems (source)
- family tree of Donald Duck (source)
- Common long words in titles of scholarly articles (source)
- schools of magic by number of students (source)
- Counts of Indian films directed and written by the same person, sorted by film language (source)
- Sovereign states that have more than one capital city (source)
- Decreases in sex ratio for mandals of West Godavari district between 2001 and 2011 (source)
- Counts of articles published in different Indian medical journals, sorted by year/journal (source)
- Forms to Lexeme ratio per language (source)
- Airports and railway stations named after fictional people or works of fiction (source)
- Species of hummingbirds, their genus, and image (source)
- Bubble chart of Indian universities with the most people ever employed by them (source)
- Graph of shared borders between certain West Bengal community development blocks (source)
- Tree map of ambassadors to India (source)
- Fictional swords (source)
- Taxa named after women scientists (source)
- Timeline of red pandas (source)
- Women having a good or featured article on Russian Wikipedia but no article on French Wikipedia (source)
- Timeline of Renaissance humanists (source)
- Map of cities from the Hanseatic League (source)
- Image gallery of musicians who have a software title named after them (source)
- Frequency of first letter in Breton words in Wikidata (source)
- Items about buildings with coordinates and at least one sitelink, but no image (source)
March[edit]
- Average distance between a French museum and its hosted artists' place of birth (source)
- Persons with a surname that matches the past participle form of a Danish verb (source)
- Town halls of communes bordering Paris (source)
- Literary awards with 0–2 recipients (source)
- Female Howard medical grads before 1900 (source)
- items including the property "preferred pronoun" (source)
- Map of tram service in Ulm (source)
- Calendar of Saints' feast days and other calendar queries
- A bunch of new GLAM-related queries including image gallery of the most notable libraries and map of museums colour-coded by type.
- the number of songs in Wikidata named after days of the week by day
- Map of preserved Concorde aircrafts
- Timeline of video games having at least 42 Wikipedia sitelinks (source)
- Timeline of Microscopists (source)
- Map of all the libraries in the world present on Wikidata (source)
- People with songs named after them (source)
- Animals most frequently depicted in artworks (source)
- Field of work of the Austrian scientists with an Orcid ID (source)
- Women from Africa sorted by number of sitelinks (source)
- Color associations in national flags (source)
- List of German-language female science fiction authors (source)
- List of the Wikimedia projects in French and languages of France (source)
- Maximum temperatures on Earth (°F/°C) (source)
- People with social media accounts that are identical but differently capitalised (source)
April[edit]
- Siblings who have won the Israel Prize (source)
- British female engineers, 1919-2019 (source)
- Female scientific illustrators (source)
- French archivists with a picture (source)
- Archive institutions in Switzerland and how much they hold (source)
- Graph of open source research software by field (source)
- Groups of characters in the Marvel universe (source)
- In what type of places are ancient Greek potteries stored? (source)
- Public art in London (source)
- Software titles that have their own mascot (source)
- Wikipedia articles using a transgender person’s deadname in the title (source)
- Entities linked to a 3d model (source)
- Graph of parties at the Feb 1974 general election in the UK (source)
- Gender balance of art prizes and Gender balance of literary awards (source)
- Images used on more than one item about a person (source)
- Map of public libraries in Wales coloured by county (source)
- Artworks by street artist Invader in Versailles (source)
- American Sign Language signs for the letters of the English alphabet
- French Sign Language signs for the letters of the French alphabet
- All deaths in Game of Thrones (source)
- Wikidata knows of at least 5263 buildings started before Notre Dame de Paris (query based on this discussion)
- Timeline for the History of Telecommunications (source)
- Graph of London Tube stations that are on at least three lines (source)
- Map of churches in Sri Lanka (source)
- A map of the Rio de Janeiro light rail network
- Nigerian women with Wikipedia article and pictures (source)
- Map of places of residence for accused witches with a layer for occupations (source)
- Map of Wikidata items that are dedicated to, named after or depict etc, St George. (source)
- Partigiani color-coded by year of death (source)
May[edit]
- Some people are named after the strangest sorts of things (source)
- Commons categories for a set of books, that have categories for people other than those 'explained' by statements on Wikidata for author, contributor, etc. (source)
- Timeline for members of the Illuminati Order (source)
- Newspapers founded before 1900 with their Twitter hashtag (source)
- Street signs in Rennes (source)
- Lines linking UK MPs' place of birth and their constituency with colour-coded layers for each political party (source)
- Map of birthplaces for Members of Scottisch Parliament born outside Scotland (source)
- Global map of dams and reservoirs (source)
- Lexemes language overlap tree map (source)
- Most common properties for maps, with their top 5 values (source)
- Timeline of pioneers of photography, via Wikidata and DBpedia (source)
- Maps of synagogues in Czech Republic (source)
- Lexemes that lack Senses but have at least one usage example (source)
- European countries that have a street named after them in Rennes
- Map of meteor impact craters (source)
- Bubble chart of all instances of color which have an sRGB color hex triplet (source)
- Number of riots per country (source)
- Country having the most female politicians (source)
June[edit]
- Gay parades in Italy in 2019
- Map of communes of the French area "Ille-et-Vilaine" which share borders (source)
- Connections between the subject and printing location of Welsh landscape prints (source)
- Dunes in Wikidata (source)
- Co-author network of Journal of Cheminformatics authors (source)
- Map of archives in the world (source)
- Items in Japanese museums by British sculptors (federated query with Japan Search) (source)
- Number of items about Australia created over time (source)
- Federated query comparing Wikidata and UK Parliament database, to show differences of more than 10km in locations of UK parliamentary constituencies (source)
- Table of counts of distinct MPs, legislative terms and per constituency P39s for UK parliamentary constituencies, with links to per constituency reports (source)
- Reverse taxon names of 100 mosquitoes (source)
- Five-letter words beginning with "f", from wikidata's lexeme collection (source)
- Péniches in Lyon
- Lexemes ordered according to compound parts (source)
- Airports named after a person, color-coded by gender (source)
- Timeline of the Chief Mousers of 10 Downing Street, with photographs when available
- Most commonly used qualifiers on depicts (P180) statements on Wikidata, with top 10 classes or items that each one is used on (source)
- Most commonly used properties connecting military people to military organisations (source)
- Bubblechart of most frequent WMF import sources
- French male first names ending with "ée" (source)
July[edit]
- Nouns without grammatical gender in a chosen language (source)
- Current UK Members of Parliament ranked by number of Wikimedia sitelinks (source)
- Architectural drawings depicting cathedrals in France (source)
- Music bands named after Tolkien's universe, by genre (source)
- 762 people made edits on lexicographical data, 571 created at least one Lexeme (source)
- Map with percentage of Welsh speakers in the regions of Wales (source)
- Publication dates of works used as usage example for Swedish Lexemes (source)
- Ratios of male/female organizers and speakers at conferences (source)
- World map of sign languages by country (source)
- Number of punk bands from Indonesia by region (source)
- Map of World Heritage places in Europe (source)
- Map of parishes of New South Wales, Australia, colour-coded by county (source)
- places in Canada with no English label
- Languages having the most usage examples in Wikidata's lexicographical data (source)
- Map of places of residence of accused witches in Scotland, colour-coded by gender (source)
- Symphonies written by Camille Saint-Saëns (source)
- Number of living people who have walked on the Moon (source)
- Artworks depicting the Moon (source)
- People that have been on spaceflights operated by at least two different sovereign states, and their time in space (source)
- Temporal distribution of book editions in Swedish (source)
- How long after a UK general election that a political party has appointed a new leader, since 1945 (source)
- Settlements along the Way of Saint James in Basque Country (source)
- Map of places of residence of accused witches in Scotland (source)
- List of regional languages of France (source)
August[edit]
- French female authors whose work is in the public domain (source)
- Timeline of hypertext systems (source)
- Megaliths in the Basque Country, color-coded by type (source)
- Heavy metal bands from Finland with or without picture and date of the picture (source)
- Types of GLAMs in Wikidata (source)
- Bands whose name is part of Tolkien's legendarium (source)
- Map of offshore windfarms (source)
- Cities having more Wikipedia sitelinks than their country (source)
- Books in Bengali Wikisource that are validated (source)
- Flightless birds of New Zealand (source)
- Islands in Germany (source)
- Clandestine center of detention and torture in Chile, Uruguay, and Argentina (source)
- Same-sex married couples where neither partner has a sexual orientation (source)
- timeline of competitions of the 2019-2020 figure skating season
- Future figure skating competitions
- Currently happening figure skating competitions
- French ships whose name start with an A (source)
- Map of birth places of delegates to the Alaska Constitutional Convention (source)
September[edit]
- Public art in London by female artists
- People used as examples in Wikidata properties (source)
- Closest capitals of non bordering countries (<200 km) (source)
- Hillforts mapped with their heritage designation/protection status
- YouTubers without a YouTube channel
- Racing automobile drivers who died in a car crash (source)
- UK Cabinet Ministers and their links in the UK National Archives | (Histropedia timeline)
- Most common properties on Senses (source)
- Place of birth of actors in The Matrix (source)
- Graph of all species in the Heron (Ardeidae) family with an IBP alpha code (source)
- Number of times a Wikidata item for Carl von Linnaeus was created
- Picture of species were the author(s) of the first scientific description is in WD and connected to Uppsala University Alvin database
- same query but where we miss a picture in Wikidata
- Twins with different places of birth (source)
- Places in Scottish local government areas (source)
- Libraries in Austria (source)
- Library systems in California
- Waterfalls without a drainage basin yet
- Works of art depicting kisses (source)
- Longest English word without a repeated letter (source)
- Longest alphabetically sorted words in English (source)
- Civil parishes of Scotland, revealed through their listed buildings (source)
- Scottish civil parishes by county and present-day council area (source)
- Federated SPARQL query from the Swedish National Archive TORA project to Wikidata
- Libraries in Africa (source)
- Most recently dissolved enterprises that were over 200 years old (source)
October[edit]
- Biographical entries in the Gazetteer for Scotland, with no article on English Wikipedia
- Map of medical facilities in Murshidabad district, India, color-coded by type (source)
- Map of flight connections between airports in India (source)
- GLAMs institutions located north of Umeå (source)
- Map of Scottish settlements linked to the average coordinates of Historic Scotland items within civil parishes - demonstrating the use of map lines to highlight possible data quality issues (source)
- Bundesliga football results - exemplar of a report predicated mainly on statement qualifiers (source)
- On which side of the road do cars drive? - demonstrating the use of geoshapes to fill a map (source)
- Map of the embassies to Belgium (source)
- Graph showing direct descendants of Prithwiraj Kapoor (source)
- Nobel laureates by award type and gender (source)
- Map of châteaux in the French world heritage site "the Loire Valley between Sully-sur-Loire and Chalonnes" (source)
- Graph of the personal relationships between Tekken characters and their fighting styles (source)
- Timeline of the chief ministers of Haryana and Maharashtra (source)
- Language representation of descriptions in Wikidata for objects connected to Ksamsök (source)
- Cricketers who have ever played on an Indian Super League team (source)
- Tree map of members of the 16th Lok Sabha, grouped by state represented (source)
- Pictures of animals with female grammatical gender in German but male grammatical gender in French (source)
- Map of bus stops in Biscay (source)
- Tree graph of doctoral advisors going backward from Abhijit Banerjee (source)
November[edit]
- Map of UK MPs coloured by party (source) - may change in the next few weeks
- Maintenance query: items which have a value of "unknown" (Q24238356) rather than the "unknown" special value (source)
- 100 cities closest to the North pole with more than 200k inhabitants (source)
- Actors with whom Shah Rukh Khan collaborated, in a bubble chart showing how many times it happened (source)
- Persons in the genealogy family tree WikiTree were WIkidata has a source from the Swedish National Archives Birth/Death records
- Minimum temperature records on Earth
- Map of districts of India by ratio of illiterate to literate population in 2011 (source)
- List of episodes of Detective Conan's Case Closed, with date and place of publication and series and season number, sorted by date of publication (source)
- Parent and child who both had a governor mandate in the USA (source)
- Belgian artists whose work will be in public domain starting in 2020 (source)
- Adaptations of The War of the Worlds (source)
- Graves at the Stockholm church Riddarholmskyrkan who use book Riddarholmskyrkan - inventories and graves (Q61765464) as a source, source
- Map of sisterly relationships with cities in India (source)
- Map of the languages without any Wikidata Lexemes yet (source)
- Paintings of people with cats (source)
- Number of English Lexemes in Wikidata by first letter (source)
- Tree map of 1990s National Film Award winners, sorted by specific award (source)
- Map of world's disputed areas (source)
December[edit]
- Graph of shared borders between regions of Myanmar (source)
- Plurals in German ending with only "n" (not "en") (source)
- Women's + Gender History Digital Humanities list (source)
- Number of lexemes on Wikidata in Indian languages (source)
- Collections of the National Gallery of Armenia imported into Wikidata (source)
- Movie directors having the longest carrier (source)
- Wikidata properties > 7000
- Wikidata External identifiers > 4590
- Map of locations of "big cities" (source)
- Seats which changed party in the 2019 UK General Election (source) (mapped)
- artists in Wikidata mapped to the Swedish National museums but are not an entity in Europeana (image view)
- Map showing objects named after a person represented in Europeana
- Locations where paintings were made (source)
- Swedish citizens who died in 1949 and whose works will enter the public domain on 1 January 2020 with profession and image, ordered by number of Wikimedia articles (source)
- Oldest subways (source)
- Popes who were children of other popes (source)
- Colorful flags (source)