Wikidata:SPARQL query service/qotw/2018
Queries from Wikidata status update weekly summaries in 2018
January edit
- Landlocked countries bordering coastal countries (source)
- Most common years of birth in Wikidata (source)
- Map of lighthouses around the world (source)
- Bubble chart showing countries with the highest number of children out of school in 2013 (source)
- Playwright dead in 1947 (whose works are now in Public Domain) (source)
- Events starting in 2017 and ending in 2018, shortest duration first (source)
- Gallery of photography techniques
- Street names that exist several times in Berlin (source)
- Average length of movie by genre and year (source)
- Inventions by Republicans (source)
- Celebrities born in January of a leap year (source)
- Countries with no rivers (source)
- Female aviation pioneers born before 1900 (source)
- People who died on K2 (source)
- Map of nuclear tests (source)
- Languages with more than one writing system (source)
- Subclasses of malware (source)
- Male actors who starred in a trilogy of movies when they were in their 20s and then no fewer than 40 years later played the same character again(source - see whole thread for more)
- Bands from the UK whose member's average age is at least 70 (source)
- Disney movie narrative locations (source)
- Buildings higher than the Eiffel Tower (source)
- Descendants of Charlemagne by year of birth (source)
- Cinemas in Berlin (source)
- Things (or people) depicted in the xkcd webcomic (source)
- Image grid of inductees to WITI Hall of Fame (source)
- Movies filmed in Austria (source)
February edit
- Items that have or will have been gone for as long as they were there this month (source)
- Members of the current UK Parliament who have ancestors in Wikidata who are identified as possibly mythical (source)
- Older siblings who died less than a month before their younger sibling entered an office (source)
- List of tram lines in Vienna (source)
- Adjacent districts in Vienna that have no tram line connecting them (source)
- Places of birth, death and burial of the artists hosted in the Sweden’s museum of art and design (source)
- Timeline of the Soviet Space Program (source)
- Countries with the most sister cities with French towns (source)
- JO2018: all 108 French competitors at the 2018 Winter Olympics by year of birth (source)
- Languages used by people in Austria, other than German (source)
- Biologists with Twitter accounts (source)
- Feed readers by license and operating system (source)
- List of female UK MPs who were descended from UK MPs (source)
- Women with an Erdős number
- Classes that are subclass of both physical object and abstract object (thread)
- Countries sharing land borders only with larger countries (source)
- Alive actors and actresses without an image, ordered by number of films they appear in (source)
- Beast species in the Harry Potter universe (source)
- Places that have been indicated as the topic of scientific articles indexed in Wikidata (source)
- Scientists whose cause of death was "death by burning" (source)
- Women who have been elected to the National Academy of Sciences (source)
- Actors who have starred in at least three Oscar Best Picture-nominated films in the same year (Inspired by this Vulture article)
- Items in the part of the Getty AAT thesaurus (P1014) below costume accessory (Q1065579) where the upward relationship in the thesaurus cannot as yet be 'explained' by our existing subclass (P279) relations (thread1;thread2;thread3)
- Where were people who went to space born? (source)
- National flags featuring the Union Jack as a canton (the top inner corner of a flag) (source)
- Number of mass shootings by country since 1990 (source)
March edit
- 3D models on Commons (source)
- Timeline of programming languages (source)
- Date of birth of computer scientists (source)
- Women born in Latin America without an article on Spanish Wikipedia (source)
- Timeline of Düsseldorf mayors (source)
- Some costume items ending in 'us'
- Women on Wikidata without article in any Wikipedia, ordered by number of statements (source)
- WikiProjects about women (source)
- Software of the KDE community (source)
- Films starring more than one future head of government (source)
- Timeline of prominent Women Computer Scientists (source)
- Megalithic sites in Spain (source)
- Major periods of Japanese history and what they were named after (source)
- Icelandic names that are not ending in "son" or "dottir (source)
- In what language does Q137 and Q12518 have the same label? (source)
- Timeline of Earth's artificial satellites (source)
- Airports named after a person, color-coded by gender (source)
- Movies that Wikidata knows about and that have a German title that implies that someone or something doesn't answer (source)
- Software developed by people/organizations that have archival material at the ComputerHistory museum (source)
- Most common eponyms of French departments (source)
April edit
- Most common title of paintings in English
- Timeline for German author Heinrich Mann (source)
- Density in kilograms per cubicmeter for books (source)
- Books by weight (source)
- Train stations in the UK (source)
- Map of megaliths in Portugal and Spain (source)
- Timeline of weather satellites (source)
- Map with lighthouses all over the world (source)
- Number of articles about humans by gender on Welsh Wikipedia (source)
- List of French rivers with different names and SANDRE ids on Sophox (SPARQL endpoint querying OpenStreetMap and Wikidata) (source)
- Longest chain of mutual murders (source)
- 6 couples killed each other (source)
- All things named after Leonardo da Vinci (source)
- German municipality pairs with the name pattern -ing/-ingen (source)
- Timeline of early silent movies produced before 1900 (source)
- French citizens with at least 5 Wikipedia pages but not in French (source)
- Historical monuments in Wales (source)
- Software titles ranked by the number of dependencies listed for them (source)
- National parks around the world (source)
- Narrative locations of TV series and episodes (source)
- Timeline of Wikibase instances and WikidataCon events (federated query)
- User-friendly list of news articles by Kim Wall, as linked from the German and English Wikipedia (based on work of fnielsen)
- Places of birth of the European Parliament members (source)
- Obelisks in Rome (source)
- Artists from Cameroon and their places of birth (source)
- Place of birth of people with an ORCID ID (source)
- History of Milano metro stations on a map (source)
- Number of versions, editions and translations by language of work (source)
May edit
- Map of birth places of authors in the Portuguese Wikisource
- Video games that are set in the Star Wars Expanded Universe by game mode (source)
- Timeline of Programming Languages (source)
- Timeline of people named Karl born in Karlsruhe (source)
- Museums near you (source)
- Places near you that are the subject of publications (source)
- Map of libraries in Wales (source)
- Map of schools in Italy (source)
- List of TeX/LaTeX commands for special characters (source)
- Largest first-level country subdivisions (i.e. larger than 400,000 km²) (source)
- Most populous first-level country subdivisions without legislatures (source)
- Prisoners of Conscience by place of birth (source)
- Photos of railway stations from Latvia and Estonia (source)
- Map of items near me that have a label in Catalan but not in French (source)
- Places of residence of accused Scottish witches (source)
- Poets whose fathers were lawyers (source)
- Map of places of birth of Liverpool's football players (source)
- Areas of Malaysia states (source)
- People and the distance between their place of birth and place of death (source)
- Grammatical cases of languages (source)
June edit
- List of Danish female athletes (source)
- Battles within 100km of Edinburgh (source)
- Grammatical features graph (source)
- 10 items having the biggest number of sitelinks (source)
- Writers and their signatures (source)
- Timeline of discoveries in the Solar System (source)
- Map of Suffragettes around the world (source)
- Female ministers in African countries (source)
- References with only a quote but no other properties (source)
- Islands in capital cities (source)
- Map of titles in the Welsh Journals & Welsh Newspapers (source)
- Artworks and rooms of The Louvre museum shown in the latest Beyoncé video (source)
- Goalscorers for the 2018 FIFA World Cup (source)
- Female dancers and choregraphs having a picture and a Wikipedia article in English but not in French (source)
- Nudes with cats (source)
- Museums in Italy colored by number of Wikipedia articles (source)
- Countries and their official languages, ISO codes and Wikimedia language codes (source)
- Timeline of scientists dying a non natural death before 1900 (source)
- Most P2860-cited surname (source)
July edit
- Map of the birth places of people who have had taxa named after them (source)
- Space observatories and their namesakes (source)
- Timeline of computer games (source)
- List of companies owned by Disney (source)
- Same gender spouses (source)
- Map of places in the UK starting with "Llan" (source)
- Number and percentage of articles about female scientists for all Wikipedias (compared to all articles about scientists) (source)
- Statements disputed by their subject (source)
- Emulators and what they emulate (source)
- Map of items near me that have a label in English but not in Welsh (source)
- Map of birthplaces of football players at 2018 FIFA World Cup
- People born furthest from their place of education (source)
- Timeline of discontinued Google products (based on source)
- Paintings depicting the Bastille Day (source)
- Fictional characters married to their siblings (source)
- Translations of disease names in South-African languages (source)
- All Wikidata properties (which are not identifiers) without a label in Afrikaans (source)
- List of people born or dead in Canton de Vaud (Switzerland), with archives where their documents are stored (source)
- Timeline of serial killers (source)
- Map of disasters, color-coded by disaster type (source)
- Ancient Greek pottery items stored in Museum St-Raymond, France (source)
- Timeline of early aviators who died in an accident (source)
- Timeline of direct-to-video sequels of theatrical movies (source)
- Music albums from Argentina (source)
August edit
- minerals named after women (source)
- Frequency of major and minor key tonalities per genre (source)
- Timeline of Writing Systems (source)
- Nonprofit organizations and the software they develop (source)
- Map of newspapers in Oregon (source)
- Topics for which the English Wikipedia wikilinks to the University of Virginia but the corresponding Wikidata entry does not
- Map of institutions where Canadian citizens got their PhD
- Space probes that have their own Twitter accounts (source)
- Newspapers in Wikidata with a recorded place of publication (source)
- Countries whose capital city can be spelled out only using letters from the country's name (source)
- Amara taxons and their Wikispecies link (source)
- Things related to open access to research in Japan (source)
- Federated query with Nobel.org: Places on Moon or Mars named after Nobel prize winners (source)
- Texts ranked by the number of languages in which they are available through Wikisource (adapted from source)
- Map of places co-occurring with species or higher-order taxa as main subjects of publications (source)
- Software titles and what they were inspired by (source)
- Occupations of the accused witches in the Survey of Scottish Witchcraft database (source)
- Gallery of Nobel prizes winners (federated query) (source)
- Map of libraries in Austria (source)
- Countries ranked by number of Wikidata-known people born there whose English version of the given name starts with Q or X (source)
- List of Windows games released this year (source)
- Countries with most citizens on Wikidata whose given name starts with X or Q (source)
- People entered in the Dictionary of Welsh Biography by gender and birth location (source)
September edit
- License of an image on Commons, while Structured Commons is in the making (source)
- Gallery of Gods and other deities
- Closest library for each public bookcase in Vienna (source)
- Line chart of Human Development Index over time for a set of countries (source)
- Nobel Prize winners in WIkidata that miss a LIBRIS id (source)
- Recent video game items with associated sitelinks and identifiers (source)
- Video game titles available on more than ten platforms (source)
- Map of caves with prehistoric art (source)
- Most cited works with Swedish first author (source)
- Map of events for Wikidata's 6th Birthday (source)
- Heads of the same state whose family names share the first four letters but are not identical (source)
- Map of caves containing prehistoric art (source)
- Maps and libraries in Boston and Cambridge (source)
- Timeline of mobile phones (source)
- Average height of figure skaters by gender and discipline (source)
October edit
- Bounding boxes for a set of maps
- Where were UK ambassadors educated? (source)
- People who received the Order of Merit of the Federal Republic of Germany and were also in the NSDAP (Nazi party) (source)
- Characters from the Mario franchise by games in which they appear (source)
- Nobel Prize winners who also has been TED speakers (source)
- Age of receivers of Nobel Prize winners in Literature (source)
- Places of birth of Nobel prizes winners per decade (source)
- Things named after Ada Lovelace (source)
- Map of lines and stations of the Amsterdam metro (source)
- Workplaces of society portrait painter Philip de Laszlo, traced on a map (source)
- What other relationships do people have with their spouses? (source)
- Signatures of French-speaking female authors (source)
- Underground lines of London (source)
- Number of properties by datatype, with a (random) example property (source)
- Number of depicted subjects by gender (source)
- People at Svensktöversättarlexikon missing a LIBRISXL authority record ordered by number of articles in Wikipedia (source)
November edit
- Timeline of companies acquired by Red Hat (source)
- Video game characters named after humans (source)
- People who received an award on the day of their death (source)
- Things named after Tux, as described in (source)
- Currently happening figure skating competitions (source)
- Software developed by groups within Google (source)
- Knowledge organization systems (source)
- Most common election days by country (source)
- Battles with location and date in Wikidata (source)
- Pictures depicting a kiss with IIIF manifest (source)
- Software-related companies founded by women (source)
- Films based on video games (source)
- Place and century of discovery of the archaeological objects of St Raymond museum (France) (source)
- Location of city halls in Spain (source)
- Timeline of famous pirates (source)
- Authors who are the most cited in Nature Chemistry (source)
- Scholarly articles published about Wikidata (adapted from here)
- The world's 200 tallest mountains, and whether Wikidata knows they've been climbed (source)
December edit
- Timeline of early Western movies (source)
- Species represented in the exhibition "Espèces en voies d'illumination" in the natural history museum of Paris (source)
- Properties most used to describe cats in Wikidata (source)
- List of UK embassies (source)
- Map of places of residence for accused witches in Scotland with a layer for occupations (source)
- Map of fountains in Zürich (source)
- Timeline of famous bryologists (source)
- Percentage of people member of the Swedish church per Church parish (source)
- Musical genres with the most bands and musicians on Wikidata, per sovereign country of origin/citizenship (source)
- (UK) Ambassador by country list - Listeria report which writes 240 by-country reports on UK Ambassadors - h/t NavinoEvans for the approach
- Presidents of the United States ranked by the number of species named after them (source)
- Communes of France whose name starts with "Saint" (source)
- Italian toponyms with suffixes of Celtic origin (-ago, -ate, -asco) (source)
- List of ABBA songs in A major (source)
- Catchphrases in Wikidata (source)
- Timeline of Indian mathematicians (source)
- Painting part of the Bavarian State Painting Collections (source)
- Types of pasta in Wikidata with pictures (source)