Wikidata:SPARQL query service/qotw/2016
Queries from Wikidata status update weekly summaries in 2016
January
editFebruary
editMarch
editAugust
edit- A famous Italian song, Tanti Auguri by Raffaella Carrà, states "Com'è bello far l'amore da Trieste in giù" (literally, in English: "How great it is to make love from Trieste to below"). This is a query to find out where you shouldn't make love.
- Common occupations of heads of state (source).
- Murderers by region in France (source).
- Authors with a known location and an ORCID (source).
- Popular surnames among humans (source).
- Movies that won all the Oscars they were nominated for (source).
- Colors with multiple RGB statements (source)
- Filmography of Jean Gabin (source)
- Cities as big as Antwerp (source)
- Cities connected by the Trans-Mongolian and Trans-Siberian Railway (source)
- Histropedia timeline of Europeana280 artworks (source)
- RADA alumni with a good or featured article on Wikipedia (source)
- Historians with links to French Wikipedia or Wikisource, but missing VIAF ID (source)
- Unicorn taxa, including the Indian rhinoceros (source)
- Mithras shrines, as a map (source)
- 2.300 Wikidata archaeological sites without coordinates (source)
- All items on Wikidata whom we know we don't know their sex or gender: (source)
- Drug-disease interactions (source)
- Nicknames of serial killers (source)
- Dynamic data map of all U-bahn lines in Berlin with colors (source)
- Timeline of internet services by type to celebrate 25 yrs of the web (source)
- Network of color (source)
- Dynamic data map of all country by year of joining the United Nations (source)
September
edit- People convicted of regicide and their victims (source)
- The most common birthday among US citizens (source)
- Things named after Polish people (source)
- Drama schools by number of students (source)
- Average gestation period of genera (source)
- Sir Christopher Lee's filmography (with film directors) (source)
- Posthumous marriages (source)
- Communes of France with more than one railway station (source)
- Languages and their grammatical cases they have in common (source)
- Cocktails recipes (source)
- People who died in the last seven days (source)
- Places of birth of 20th century saints (source)
- Embassies (source)
- World map of water towers (source)
- "Battles of the Middle Ages" without place or date (source)
- Asteroids named after characters from works by Lewis Caroll (source)
- Map of Austrian cultural heritage (source)
- Statues in Paris depicting historical female figures (source)
October
edit- Most populous commune of France whose name begins by a certain letter (source)
- Works mentioning #Wikidata properties (source)
- Places where people born in Brittany died (source)
- trees grown from seeds that went around the Moon (source)
- Chemistry Nobel prizes through time (source)
- Former countries without continent (P30) (source)
- Rivers without any mouth specified (source)
- Interesting items near you (source)
- first Nobel Prize winner who was born after Alfred Nobel’s death (source)
- streets in Paris named after doctors (source)
- international land tripoints (source)
- national flags depicting stars or constellations (source)
- national flags with inscriptions (source)
- people who died the furthest away from where they were born (source)
- closest pairs of capitals (of UN member states, <500km) (source)
- people who received military decorations from two different countries (source)
- volcanoes and earthquakes (source)
- height/width ratios of paintings (source)
- birthplaces of Members of the European Parliament (source)
- birthplaces of US Senators (source)
- places of birth of living US senators (compare with last week's)
- Wikidata map of filming locations (source)
- Streets in Paris named after a physician (source)
- Moons of trans-Neptunian objects (source)
- Deities and their families
- Most frequently variants of given names (source)
- Cheese made with cow milk (source)
- Abandoned villages in the Czech Republic (source)
November
edit- Continents on Wikidata (All eleven of them) (source)
- Sluices on the river "Vilaine" in Brittany (source)
- Countries with most cities named after saints (source)
- Disney characters who share name with their actors (source)
- 204 items that cite themselves (source)
- Statements with two references where one source cites the other (source)
- Map of educational institutes from all over the world (source)
- Current US Supreme Court justices by their date of birth (source)
- Death dates of people with Wikidata items (source)
- French towns that a street in Paris is name after(source)
- Statements with “reason for deprecation” rank that aren’t deprecated(source)
- Occupations of women, with French female-form labels (source, database report)
- Documents with most signatories (source)
- Filming locations of James Bond films (source)
- United States National Historic Landmarks not actually located in the United States (source)
- Items with VIAF, but no P31/279 (source)
December
edit- Bridges named after women (source)
- Network of brands of some big food/drink companies (source, help improve it)
- Cities located next to most rivers (source)
- Nobel Prize winners on Twitter (source)
- French deputies who died during their mandate (source)
- Streets in the Netherlands named after people
- People burried in the cemetery of La Croix Rousse (Lyon, France) (source)
- Map of people buried in the cemetery of Norra Begravningsplatsen (Stockholm, Sweden)
- Works of Musée Saint-Raymond (Toulouse, France) on Wikidata (source)
- Communes of France named after a river
- People awarded by a Theater World Award in 2016
- Upcoming creative works: films, TV series, video games… (source)
- Number of demonstrations per country (source)
- Timeline of the Christmas movies (source)
- All Theatre World Award winners, in a timeline with pictures (source)
- Birthplaces of people buried in Norra Begravningsplatsen (source)
- Planets, their moons, and the things they are named after (source)
- Items with no father or no mother (source)
- People born on Christmas day (source)
- List of heads of state by Erdős number (source)
- Airports named after people (source)
- Graves with no grave pictures of people buried in Norra Begravningsplatsen (source)
- Graves with grave pictures of people buried in Norra Begravningsplatsen (source)
- Holidays occurring today (source)
- Streets in Paris named after current countries (source)
- Streets in Paris named after battles (source)
- Wikipedia articles (in any language) of paintings by painter (source)
- Sovereign state flags with no red, white, or blue (source)
- Graph of number of compositions over age at first composition (source)
- Filtered timeline of Spotify artists
- Paintings of the Eiffel Tower by Robert Delaunay (source)
- Ratio of “famous” (≥25 sitelinks) people’s deaths since 2000 (source)
- Things with coordinates on globes other than Earth (source)