Wikidata:Weekly query examples/2016
Wikidata weekly query #191[edit]
From Wikidata Status update of 09 JANUARY 2016
Wikidata weekly query #192[edit]
From Wikidata Status update of 16 JANUARY 2016
Wikidata weekly query #193[edit]
From Wikidata Status update of 23 JANUARY 2016
Wikidata weekly query #194[edit]
From Wikidata Status update of 30 JANUARY 2016
Wikidata weekly query #195[edit]
From Wikidata Status update of 06 FEBRUARY 2016
Wikidata weekly query #196[edit]
From Wikidata Status update of 13 FEBRUARY 2016
Wikidata weekly query #197[edit]
From Wikidata Status update of 20 FEBRUARY 2016
Wikidata weekly query #198[edit]
From Wikidata Status update of 27 FEBRUARY 2016
Wikidata weekly query #199[edit]
From Wikidata Status update of 05 MARCH 2016
Wikidata weekly query #200[edit]
From Wikidata Status update of 12 MARCH 2016
- Number of museums by U. S. state on map,
- Film directors ranked by number of sitelinks multiplied by their number of films,
- all museums in Barcelona with coordinates,
- women mushers,
- women scientists,
- women artists,
- air accidents,
- Twitter accounts of biologists,
- torture devices
- public art in Paris,
- Locations of Pablo Picasso works
Wikidata weekly query #201[edit]
From Wikidata Status update of 19 MARCH 2016
Wikidata weekly query #202[edit]
From Wikidata Status update of 26 MARCH 2016
Wikidata weekly query #203[edit]
From Wikidata Status update of 02 APRIL 2016
- The query service now has bubble charts as a visualization option (*example)
Wikidata weekly query #204[edit]
From Wikidata Status update of 09 APRIL 2016
- women with most sitelinks and no image born in 1921 or later,
- what is depicted in artwork,
- most eponymous mathematicians
Wikidata weekly query #205[edit]
From Wikidata Status update of 16 APRIL 2016
- items named after their shape,
- recent events,
- assemblies by number of seats,
- characters portrayed by most actors
Wikidata weekly query #206[edit]
From Wikidata Status update of 23 APRIL 2016
- songs with longest melody (source),
- subjects with most art dedicated to them (source),
- versions of The Scream (source)
Wikidata weekly query #207[edit]
From Wikidata Status update of 30 APRIL 2016
- software with most versions (source)
- oldest software (source),
- map of U1 stations in Berlin (source)
Wikidata weekly query #208[edit]
From Wikidata Status update of 07 MAY 2016
- most frequent occupations without a label in a given language,
- map of places of birth of economists (source),
- map of all the paintings for which we know a location with the count per location (source),
- scientists who have worked together but whose Erdős numbers don’t reflect that (source),
- members of the French National Assembly born out of France (source),
- mathematical proofs (source),
- items that depict most things (source)
Wikidata weekly query #209[edit]
From Wikidata Status update of 14 MAY 2016
- longest rivers (source),
- map of places mentioned in travel stories with text in French accessible online (source),
- things located where the equator meets the prime meridian (source),
- people who acted with Brad Pitt (source),
- Italian mountains higher than 4000mt (source),
- who died by burning (source),
- age at date of death for musicians (source),
- universities of main programming language authors (source),
- hashtags (source),
- Pokemon! (source)
Wikidata weekly query #210[edit]
From Wikidata Status update of 21 MAY 2016
- given names with most variations (source with links to graphs),
- papers about Wikidata (source),
- memes (source),
- cathedrals in Paris (source),
- highest mountains in the universe (source),
- Law & Order episodes (source),
- things/people with most children (source)
Wikidata weekly query #211[edit]
From Wikidata Status update of 28 MAY 2016
- Fictional universes with most fictional planets (source),
- main subject of West Wing episodes (source),
- places with free wifi (source),
- citation network of paper about Zika (source),
- taxons and what they are named after (source),
- billionaires (source),
- animals that were executed (source),
- chemical elements and their isotopes by number of neutrons (min/max) (source),
- popes with children (source),
- birthplaces of astronauts (source)
Wikidata weekly query #212[edit]
From Wikidata Status update of 04 JUNE 2016
- body of water with the most watercourses ending in it (source),
- French communes with names ending in ac (source),
- birthplaces of Europeana280 artists (source),
- popular eye colors (source)
Wikidata weekly query #213[edit]
From Wikidata Status update of 11 JUNE 2016
- Eiffel Tower in art (source),
- popular surnames among humans (source),
- popular surnames among fictional characters (source),
- average lifespan by occupation (source),
- German breweries (source),
- years with 3 popes (source),
- people who died by burning - on a timeline (source)
Wikidata weekly query #214[edit]
From Wikidata Status update of 18 JUNE 2016
- colors of chemical compounds (source),
- map of braodway venues (source),
- sculptures by Max Bill (source),
- works of art where the name might be a rhyme (source),
- works of art where the title is an alliteration (source)
Wikidata weekly query #215[edit]
From Wikidata Status update of 25 JUNE 2016
- sandwich ingredients (source),
- inventors killed by their own invention (source),
- objects with most mass (source),
- music genres (source),
- number of jurisdictions by driving side (source)
Wikidata weekly query #216[edit]
From Wikidata Status update of 02 JULY 2016
- Ancestors of Guðni Jóhannesson (note the last names),
- movies with Bud Spencer (source),
- largest cities per country (source),
- longest river of each continent (source),
- rivers in Antarctica (source),
- continents (source),
- and some other continents (source),
- places with continent Antarctica more than 3000 km north of south pole (source),
- files used as “image” in more than 10 items (source),
- monuments historiques in Loire-Atlantique (source),
- music composers by birth place (source),
- places of whorship (source),
- teachers with most students (source),
- buildings in more than one country (source),
- sandwiches (source),
- composers and their most-used tonality (source),
- former capitals (source),
- list of suicide attacks (source),
- birthplaces of people named Antoine (source),
- places that are below 10 meters above sea level (source)
Wikidata weekly query #217[edit]
From Wikidata Status update of 09 JULY 2016
- timeline of space probes (source),
- countries with most UNESCO World Heritage Sites (source),
- places in America named after places in England (source),
- emergency number by country size (source)
Wikidata weekly query #218[edit]
From Wikidata Status update of 16 JULY 2016
- letters with more than two forms (source),
- metro stations (source),
- railway incidents (source),
- pyramids in Egypt (source),
- women described as wife and
- men described as husband (source),
- neuroinformatics coauthor network (source),
- nationalities of people with an article in the Bavarian Wikipedia (source),
- Irish general elections and their winners (source),
- types of historical monuments (source),
- Alpine four-thousanders (source),
- Alpine peaks (source),
- language statements that point to a country instead of a language (source)
- Newest database reports: list of people who died on their birthday
Wikidata weekly query #219[edit]
From Wikidata Status update of 23 JULY 2016
- most cited Danish people (source),
- most self-citing authors (source),
- topics of series (source),
- human settlements, north of the Arctic Circle (source),
- poles of inaccessibility (source),
- people with the same family and given name (source),
- compositions for organ and orchestra/
- compositions for organ and anything else (source),
- people with a statement with start time / end time qualifiers over 100 years apart (source),
- causes of death for noble people (source),
- long-running noble families (source)
Wikidata weekly query #220[edit]
From Wikidata Status update of 30 JULY 2016
- frequency of Romans' praenomen (source),
- movies by number of actors who studied at RADA (source),
- actors directed by Tony Scott + number of appearances (source),
- actors directed more than 20 times by the same director (source),
- actors directed more than 20 times by the same director with years (source)
Wikidata weekly query #221[edit]
From Wikidata Status update of 06 AUGUST 2016
- places of worship in France (source), *former capitals (source),
- Edinburgh-born authors and their notable works (source),
- movies by David Lynch by duration (source),
- descendants of Gustav Vasa,
- people sharing the same name, the other way around,
- Tony awards nominees and winners (source)
Wikidata weekly query #222[edit]
From Wikidata Status update of 13 AUGUST 2016
- You can now render sparql queries using the Histropedia timeline engine. Example : Structures in London, colour coded by heritage status
- 2016 Olympics flag bearers (source)
- Composer that scored more than 100 films (source)
- churches using the same image (source)
- Challenge: Find a class with more fictional instances than real ones (source)
- items on human genes with unreferenced statements (source)
- Women elected to the UK Paliament (via WD:RAQ)
- Treaties of Paris (source)
- fictional thoroughfares (source)
- map of sports teams, with layers for different sports (source)
- big cities grouped into map layers by population (source)
- Free software with/without license (source)
- treaties with/without a date (source)
- capitals that aren’t capitals (soure)
- works of art depicting many people (source)
Wikidata weekly query #223[edit]
From Wikidata Status update of 20 AUGUST 2016
- 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)
Wikidata weekly query #224[edit]
From Wikidata Status update of 27 AUGUST 2016
- 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)
Wikidata weekly query #225[edit]
From Wikidata Status update of 03 SEPTEMBER 2016
- 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)
Wikidata weekly query #226[edit]
From Wikidata Status update of 10 SEPTEMBER 2016
- 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)
Wikidata weekly query #227[edit]
From Wikidata Status update of 17 SEPTEMBER 2016
- 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)
Wikidata weekly query #228[edit]
From Wikidata Status update of 24 SEPTEMBER 2016
- taxonomy of squirrels (source),
- good or featured articles about people on Wikipedia but with no picture on Wikidata (source),
- Nordic Cross flags (source)
Wikidata weekly query #229[edit]
From Wikidata Status update of 01 OCTOBER 2016
- 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)
Wikidata weekly query #230[edit]
From Wikidata Status update of 08 OCTOBER 2016
- Chemistry Nobel prizes through time (source)
- Former countries without continent (P30) (source)
- Rivers without any mouth specified (source)
- Interesting items near you (source)
Wikidata weekly query #231[edit]
From Wikidata Status update of 15 OCTOBER 2016
- 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)
Wikidata weekly query #232[edit]
From Wikidata Status update of 22 OCTOBER 2016
- 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)
Wikidata weekly query #233[edit]
From Wikidata Status update of 29 OCTOBER 2016
- Deities and their families
- Most frequently variants of given names (source)
- Cheese made with cow milk (source)
- Abandoned villages in the Czech Republic (source)
Wikidata weekly query #234[edit]
From Wikidata Status update of 05 NOVEMBER 2016
- 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)
Wikidata weekly query #235[edit]
From Wikidata Status update of 12 NOVEMBER 2016
- 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)
Wikidata weekly query #236[edit]
From Wikidata Status update of 19 NOVEMBER 2016
- 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)
Wikidata weekly query #237[edit]
From Wikidata Status update of 26 NOVEMBER 2016
Wikidata weekly query #238[edit]
From Wikidata Status update of 03 DECEMBER 2016
- 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)
Wikidata weekly query #239[edit]
From Wikidata Status update of 10 DECEMBER 2016
- 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)
Wikidata weekly query #240[edit]
From Wikidata Status update of 17 DECEMBER 2016
- 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)
Wikidata weekly query #241[edit]
From Wikidata Status update of 24 DECEMBER 2016
- 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)
- Solidays 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)