Wikidata:Weekly query examples/2017
Wikidata weekly query #242[edit]
From Wikidata Status update of 07 JANUARY 2017
- Birth place of Academy Award winners
- Neujahrskonzert with conductor by country and age (source)
- 9 species named after the President of the USA (source)
Wikidata weekly query #243[edit]
From Wikidata Status update of 14 JANUARY 2017
- People without gender, but with photo (~2500 items)
- Gallery of cheese varieties and origin
- Taxa with more female than male individuals (source)
- Scatter chart of river watershed area (in km²) over length (in km), now using normalized unit support (source)
Wikidata weekly query #244[edit]
From Wikidata Status update of 21 JANUARY 2017
- Tide mills in France (source)
- Wind mills in Paris (source)
- Mathematical formulae containing HTML escapes (source)
- Fire stations in Paris (source)
Wikidata weekly query #245[edit]
From Wikidata Status update of 28 JANUARY 2017
- Most articles about films in each Wikipedia
- Largest companies by revenue in USD
- Characters whose actors died recently (source)
- Stock-listed US companies with founders who (or whose parents) were born outside the US (source)
- Wizards from Harry Potter and their houses/groups (source)
Wikidata weekly query #246[edit]
Wikidata weekly query #247[edit]
- Collection of the Ashmolean Museum, Oxford, UK
- Office-holders convicted of crimes (source)
- Monarchs convicted of regicide (source)
- Timeline of antipopes (source)
- Battles etc of the U.S. Civil War, that have maps (source) -- but the results are a bit patchy.
- Grade I listed buildings in Bedfordshire (source: Commons "category contains" template)
Wikidata weekly query #248[edit]
- People born at the sea (source)
- Persons buried in Père-Lachaise cemetery, Paris (source)
- Paintings by women painters in the Louvre (source)
Wikidata weekly query #249[edit]
- Map of cheese by milk used (source)
- The many flags of Afghanistan (source)
- Real works written by fictional authors (source)
- Maps of churches in Pyrénées-Orientales (France) (source)
- Cities with millions of inhabitants that not a single person in Wikidata was born, has lived, or died in (source)
Wikidata weekly query #250[edit]
- Countries with similar populations (source)
- Items that have "feminist art" as a value (source)
- Books, incipits, concatenating a sentence to the incipit (source and inspiration)
- Paintings by Vermeer depicting maps (source)
- Painters sorted by the number of Wikipedia articles about their works (source)
Wikidata weekly query #251[edit]
- List of female bioinformaticians/computational biologists (source)
- Most gender-imbalanced occupations in US citizens (source)
- Awards received by more women than men (source)
- Transgender characters played by trangender actors/actresses (source)
- The most famous astronomical objects in Solar System according to Wikipedia sitelinks (source)
- Natural arches around the globe (source)
Wikidata weekly query #252[edit]
- Gallery of authors of scientific articles that have been published on this day of the year (source)
- Scholarly articles that have Wikipedia articles about them (source)
- False Vermeer works (source)
- From Natalie Portman to Paul Erdös graph (source)
Wikidata weekly query #253[edit]
- Time zones that are more than 12 hours away from UTC (source)
- Countries which have the same name as their capital in their official language (source)
- Roman amphitheatres on Wikidata (source)
- Sluices on canals in Bretagne (France) (source)
Wikidata weekly query #254[edit]
- Map of the megaliths of the World, coloured by type (showing some nice paterns, source)
- French people without a gender (source)
- Eldest members of noble families (source)
- Map of places with population “zero” (0) (source)
Noteworthy Stuff[edit]
Wikidata weekly query #255[edit]
From Wikidata Status update of 10 APR 2017
- Notable integers
- Longest streets of Moscow
- Top 20 of heaviest humans in Wikidata (source)
- Timeline of Paris marathons (source)
- Countries not involved in any world war (source)
- People whose place of birth is named after them (source)
Wikidata weekly query #256[edit]
From Wikidata Status update of 17 APR 2017
- The 500 most important paintings, according to Wikidata sitelinks (source)
- The most important works in German by Wiki* articles (source)
- Cities in France starting with the letter W (source)
Wikidata weekly query #257[edit]
From Wikidata Status update of 24 APR 2017
- Place of birth of the candidates to French presidency since 1958 (source)
- Oldest given names on Wikidata (source)
- Cocktails and their ingredients (source)
- Cities in UK named after a patron saint (source)
Wikidata weekly query #258[edit]
From Wikidata Status update of 01 MAY 2017
- 15415 people who died in 2016
- Maps of statues of Jeanne d'Arc on a horse (source)
- Families who’ve had the same occupation for five generations (source)
- Couples of capitals more than 19,000 km away from each other (source)
- A ten-persons “surname = given name” chain on Wikidata (source)
Wikidata weekly query #259[edit]
From Wikidata Status update of 08 MAY 2017
- All places (with coordinates) that gave its name to something (source)
- Paintings depicting monkeys (source)
- Artworks with presumably depicted persons (source)
Wikidata weekly query #260[edit]
From Wikidata Status update of 15 MAY 2017
- Paintings in the Louvre Museum, with heights and widths (source)
- Chart of USA cities founded per year (source)
- Country flags including a symbol of sun (source)
- Birthplace of Spanish Queen Consorts (source)
Wikidata weekly query #261[edit]
From Wikidata Status update of 22 MAY 2017
- Websites but without an official website
- Plants with associated emoji (source)
- Languages ordered by number of speakers (source)
- HMDB identifiers with more than one item (source)
- Painters with a lot of identifiers on Wikidata, but few Wikipedia articles (source)
- Buildings with the greatest numbers of elevators (source)
- Map of female writers on Wikidata by birthplace- generated by SPARQL query (source)
Wikidata weekly query #262[edit]
From Wikidata Status update of 29 MAY 2017
- Map of subreddits associated to a place on Earth (source)
- Potential reviewers for papers in computer science (source)
- Paintings with 'portrait' in the name that lack P180 / depicts (source)
- Publications and presentations about WikiCite (source)
Wikidata weekly query #263[edit]
From Wikidata Status update of 05 JUNE 2017
- Number of citizens with “blood type” statements per country (source)
- Works with most citations (running time 20-45s) (source)
- Female recipients of the Palme d'Or award (source)
- Timeline of albums by Manu Chao and Mano Negra (source)
- Female given names ending in "o" (source)
- Newest external tools: Wikidata Diff (compares two items; proof-of-concept, doesn't yet include qualifiers, etc.), Wikidata Recent Changes livestream
Wikidata weekly query #264[edit]
From Wikidata Status update of 12 JUNE 2017
- Coordinates of parallels and meridians according to Wikidata (source)
- Uses of the property "IPv6 routing prefix" (source)
- Non-politician jobs that UK Prime Ministers had (source)
Wikidata weekly query #265[edit]
From Wikidata Status update of 19 JUNE 2017
- Gallery of monsters of the Japanese folklore
- Lang by number of label (with quarry.wmflabs.org)
- The 10 smallest countries with some kind of urban rail transit system (source)
- Occupations with highest rate of deaths by homicide (source)
- Software titles ranked by number of readable file formats (source)
Wikidata weekly query #266[edit]
From Wikidata Status update of 26 JUNE 2017
- BubbleChart of Metal band by country (source)
- Viennese composers and their compositions by tonality (source)
- Most prolific authors of scientific articles on Wikidata, who are still alive, without ORCID (source)
- Average age of members of the Landtag of Thuringia (source)
Wikidata weekly query #267[edit]
From Wikidata Status update of 03 JULY 2017
- Place of birth of the authors on Wikimammenn, the breton Wikisource
- First names of current French members of Parliament (source)
- Timeline of the births of current members of the French National Assembly (source)
- Family tree of Harry Potter characters (source)
- Map of mountains located in the Basque Country (source)
- Items with higher number of child statements than number of children (source)
- Pictures of Pharaos (source)
- Map of departemental archives in France (source)
Wikidata weekly query #268[edit]
From Wikidata Status update of 10 JULY 2017
- Scientific articles from PubMed that mention what version of STATA was used (source)
- 1000 places in UK that have no label in Welsh (source)
- Wikivoyage banners for French municipalities (source)
- Paintings with musical instruments from Spain or related to Spain (source)
- Images of things or persons in Wikidata with a Github account (source)
- Map of birthplaces of women who were educated in Edinburgh university (source)
Wikidata weekly query #269[edit]
From Wikidata Status update of 17 JULY 2017
- Graph of operating systems (source)
- Couples of Members of Parliament in UK (source)
- People who have the same person listed as both their parent and their child (source)
- Map of “railway things” in Berlin, as classified by LinkedGeoData.org (source)
- Map of discovery locations of the objects stored in the Musée Saint-Raymond (source)
- metro stations in Germany with public domain images on Commons (source)
- UK Members of Parliament who are born out of the UK (source)
Wikidata weekly query #270[edit]
From Wikidata Status update of 24 JULY 2017
- Properties with most “statement disputed by” qualifiers (source)
- Last meals of people (source)
- Colors on national flags (source)
- images of all winners of Free Software Foundation's Free Software Awards (source)
- lib.reviews now allows searching Wikidata directly to choose subjects to review. (more info)
Wikidata weekly query #271[edit]
From Wikidata Status update of 31 JULY 2017
- Which White House chief of staff had the shortest tenure? (source)
- Total number of sister city statements per country (source)
- Pictures of tube stations in London (source)
- Works created with the software Maya (source)
- Do I cite works from Nobel Prize winners? (source)
- ...or do Nobel prize winners cite me? (source)
- Timeline of Humanitarian personality of the year (source)
Wikidata weekly query #272[edit]
From Wikidata Status update of 07 AUGUST 2017
- Timeline of the programming languages created in the past 10 years (source)
- Countries where no european language has official or national status (source)
- Gallery of Star Trek characters (source)
- Timeline of female medieval writers (source)
Wikidata weekly query #273[edit]
From Wikidata Status update of 14 AUGUST 2017
- Most-depicted musical instruments (source)
- People who died in 2017 without a French label (source)
- Moar goats (source)
Wikidata weekly query #274[edit]
From Wikidata Status update of 21 AUGUST 2017
- Surnames, similar to Muller, according to Cologne phonetics, Caverphone and Soundex algorithms
- Shortest streets in Moscow
- A timeline of theologians with a connection to Berlin (source)
- Timeline of the life of Honoré de Balzac (source)
- Twin cities of places in South Africa (source)
- 51st UK parliament (1992) was the first one with more women than Johns (source)
- All places that are named "earth" in at least one language (source)
Wikidata weekly query #275[edit]
From Wikidata Status update of 28 AUGUST 2017
- number of persons per QID (using P735=Q4925477) (source)
- QID milestones by date
- Timeline for biochemist and Nobel Laureate Hans Adolf Krebs (source)
- Canadian actors who twice played a US president (source)
- Duration of Steven Spielberg's films (source)
Wikidata weekly query #276[edit]
From Wikidata Status update of 04 SEPTEMBER 2017
- The most famous painting from each country (source)
- Ranking universities according to PageRank (source)
- Actors who were cast in two different films with the same name (source)
Wikidata weekly query #277[edit]
From Wikidata Status update of 11 SEPTEMBER 2017
- Places of education of the UK members of Parliament (source)
- Pairs of churches in the UK that are within 25 metres of each other (source)
- National parks in India (source)
- Persons buried more than 13000 km away from their death place (warning: some errors needing correction)
Wikidata weekly query #278[edit]
From Wikidata Status update of 18 SEPTEMBER 2017
- Algorithms and the problems they solve (source)
- Swiss items with article in exactly one of German-, French-, Italian-, and Romansh-language Wikipedias (source)
- Popular gender-neutral given names (source)
- Computer network protocols and their ports (source)
- Software developers by number of software titles (source)
- Spacecraft and what they were named after (source)
Wikidata weekly query #279[edit]
From Wikidata Status update of 25 SEPTEMBER 2017
Wikidata weekly query #280[edit]
From Wikidata Status update of 02 OCTOBER 2017
Wikidata weekly query #281[edit]
From Wikidata Status update of 09 OCTOBER 2017
- Women who won the Nobel Prize in Physics (source)
- For each award, percentage of women who received it (source)
- Intelligent personal assistants described in Wikidata (source)
- Units of measurement named after German people (source)
- Buildings constructed by Karl Friedrich Schinkel (source)
Wikidata weekly query #282[edit]
From Wikidata Status update of 16 OCTOBER 2017
- Flags with more than 5 stars (source)
- Timeline of programming languages (source)
- Female scientists sorted by number of citations of their work (source)
Wikidata weekly query #283[edit]
From Wikidata Status update of 23 OCTOBER 2017
- Average age of members of the 19th German Bundestag (source)
- Mountains in CH by height (topographic prominence) (source)
- Mountains in CH by height (elevation above sea level) (source)
- Monuments in Berlin for which Berlin cultural heritage ID and geolocation are known in Wikidata (source)
- Initial characters of names of free software (source)
- Initial characters of names of nonfree software (source)
- First World Heritage site per country (source)
Wikidata weekly query #284[edit]
From Wikidata Status update of 30 OCTOBER 2017
- Organic acids with images (source)
- People who are their father's father (source)
- 2017 German federal election results by district with geoshapes and color depending on the % of votes (source)
- Cities with most first performances of works (source)
- Count of women Vs. guys names “John” in the UK parliament (source)
- Percentage of popes who died in Rome (source)
- First sites registered at Unesco for each country (source)
Wikidata weekly query #285[edit]
From Wikidata Status update of 06 NOVEMBER 2017
- endemic moths of New Zealand with images in Wikidata (source)
- Images of people commemorated by plaques in Jena, Germany (source)
- Paintings located in Le Louvre without pictures on Wikidata, with the location in the museum (source)
- Persons who will have their work in public domain in 2018 in Denmark, with their occupations (source)
- Political parties by ideology in a tree view (source)
- Organic acids with pictures (source)
- Levels of education in France, from kindergarten to high school, with their US equivalents (source)
- Horses drawn on hills in the UK (source)
- Frequency of “retrieved” dates in Wikidata references (source)
Wikidata weekly query #286[edit]
From Wikidata Status update of 13 NOVEMBER 2017
- Timeline of the works of Robert Louis Stevenson (source)
- Canals within 800 kilometres of Glasgow (source)
- File systems by developer, date, and OS (source)
- Map of metro stations of Bilbao (source)
- Highest point of each department of France (source)
Wikidata weekly query #287[edit]
From Wikidata Status update of 20 NOVEMBER 2017
- List of subclasses of Matrices
- Works of art in which the artists depicts their spouse (source)
- locations Van Gogh depicted in his paintings (source)
- Gender split of past Google Doodles (source)
Wikidata weekly query #288[edit]
From Wikidata Status update of 27 NOVEMBER 2017
- People who were Time Person of the Year in two consecutive years (source)
- Fictional characters “said to be the same as” other fictional characters from the same fictional universe (source)
- Map of places of birth of deceased sociologists (source)
- Map of libraries in India (source)
- Train and subway stations in Basque Country (source)
Wikidata weekly query #289[edit]
From Wikidata Status update of 04 DECEMBER 2017
- Timeline for the writer Robert Louis Stephenson (source)
- Movies with Bud Spencer and Terence Hill (source)
- Photographers born before the inception of the earliest photograph (source)
Wikidata weekly query #290[edit]
From Wikidata Status update of 11 DECEMBER 2017
- Place of birth of author with pages on the French Wikisource (source)
- Number of movies passing or failing the Bechdel test by year (source)
- 100 of the earliest 1000 works created by women on Wikidata with an image on Commons (source)
- Chemical entities, whom discovered them, and when (source)
- Sister-city and twin-city relationships of the largest cities (source)
- Cast age at date of film publication (source)
- Male saints that are the most used to name French cities after them (source)
Wikidata weekly query #291[edit]
From Wikidata Status update of 18 DECEMBER 2017
- Number of disasters by date and day of the week (source)
- Map with buildings by Brazilian architect Oscar Niemeyer (source)
- Properties most used for “no value” statements/qualifiers/references (source)
- Scientific papers with an animal credited as co-author (source)
- Image grid of what different cryptocurrencies are named after (source)
Wikidata weekly query #292[edit]
From Wikidata Status update of 25 DECEMBER 2017
- Map with radio telescopes around the world (source)
- People born on the same day their mother died (source)
- Largest first-level administrative subdivision by country (source)
- Data sets released under a Creative Commons NoDerivatives license (source)
- Type foundries and their typefaces (source)
- Map of Christmas traditions (source)
- Movies that are Christmas traditions (source)