User talk:Bovlb/Archive 2017-10

Wikidata weekly summary #280
Here's your quick overview of what has been happening around Wikidata over the last week. 


 * Events/Press/Blogs
 * Using Wikidata data, fixing wrong Wikipedia and Wikidata tags, by Mateusz Konieczny
 * One Knowledge Graph to Rule Them All? Analyzing the Differences Between DBpedia, YAGO, Wikidata & co
 * Modeling the Domain of Digital Preservation in Wikidata
 * Wikidata as a linking hub for knowledge organization systems? Integrating an authority mapping into Wikidata and learning lessons for KOS mappings (Paper and presentation), by Joachim Neubert, NKOS Workshop 2017 at TPDL
 * Knowledge exploration in public linked data ontologies


 * Other Noteworthy Stuff
 * The ArticlePlaceholder has been enabled on Bengali Wikipedia (example)
 * There is a new page with information around Wikidata:Wikidata in Wikimedia projects. You can help expand and improve it.
 * New Wikidata Game to help you evaluate merge candidates based on projectmerge.
 * A reading tip from Spinster (not mentioning Wikidata, but interesting general background knowledge): Indigenous peoples and responsible data: an introductory reading list from responsibledata.io
 * Where's Wally (aka Waldo)? Right here on Wikidata, of course!
 * Wikidata passed 8 average statements per item
 * Statement 300.000.000 was created
 * 20 million edits were done in September 2017


 * Did you know?
 * Newest properties: TSE number, defined daily dose, Vincoli in Rete ID, The Black Book ID, Tagesschau election ID, LfD-HB object ID, cultural heritage monument in Serbia ID, Bavarian monument authority ID
 * Query examples: What exists in the "... as a service" genre? (source)


 * Development
 * Added a css class to values that link to redirects so they can more easily be identified by editors who want that for maintenance work (T70567) Thanks Matej!
 * Continued work on persistent editing of forms as part of the work to support lexicographical data (T173742, T173744)
 * Finishing touches on adding full URIs for external identifiers to our RDF export so we're good citizens of the semantic web (T121274)
 * Added a new  Lua function in addition to the existing , that returns all statements regardless of their rank (T176124)
 * Looking into an issue where unwanted email notifications are being sent (T174794)
 * Released version 2.1.1 of the base DataValues component


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Suggested and open tasks!
 * Contribute to a Showcase item.
 * Help translate or proofread the interface and documentation pages, in your own language!
 * Help merge identical items across Wikimedia projects.
 * Help write the next summary!

Read the full report &middot; Unsubscribe &middot; Lydia Pintscher (WMDE) 17:53, 2 October 2017 (UTC)

Wikidata weekly summary #281
Here's your quick overview of what has been happening around Wikidata over the last week. 


 * Events/Press/Blogs
 * Upcoming: WikidataCon, Berlin, 28-29 October (sold out)
 * We will have two exciting keynotes. The first keynote speaker is Fabian M. Suchanek, professor at Télécom Paris Tech University, working on the knowledge base YAGO. The second keynote speaker is Michael Kreil, datajournalist working on the project Data Sciences and Stories.
 * Please volunteer for some tasks at the conference if you are attending.
 * Upcoming: Wikidata workshop at XLDB, October 12th, Clermont-Ferrand, France
 * Rebuild the map of famous artwork with Wikidata by Poulpy (in French)
 * Research libraries and Wikimedia: A shared commitment to diversity, open knowledge, and community participation


 * Other Noteworthy Stuff
 * There is now a good start for documentation for QuickStatements. Feel free to help improve it!
 * New Mix’n’match mode to show just the entries with multiple matches (example)


 * Did you know?
 * Newest properties: Lega Pallavolo Serie A player ID, KNAU ID, PfaF id, YouTube Playlist ID, Wheelchair ITF player ID, VBL player ID, MIL-STD-2525 Symbol Identification Code, stellar rotational velocity, readership, PROSPERO ID, PM20 folder ID, possessed by spirit, panorama view, official app, LFH player ID, UK National Fruit Collection ID, Riigikogu ID, Nominis saint ID, Theses.fr person ID, Nominis given name ID, LUMIERE director ID, LUMIERE film ID, LNV player ID, International Standard Text Code, hydrological order number, FCI rider ID, Daum movie ID, Cinémathèque québécoise work identifier, Japanese Database of National important cultural properties, Tunisian geographic code, New York City Landmarks Preservation Commission ID, DPLA subject ID, rating, Daum TV series ID, half maximal effective concentration, half maximal inhibitory concentration (IC50), Landtag of Liechtenstein ID, Bavarian geotope ID, Reddit user name, LinkedIn company ID, THW Kiel player ID, Footoféminin.fr player ID, FFVoile sailor ID, NPB player ID, Lega Pallavolo Serie A Femminile player ID, Gallica ID, National Museums of Japan e-museum ID, Spanish "Boletín Oficial del Estado" ID, Banglapedia (English version) ID, Banglapedia (Bengali version) ID, number of constituencies, All-Russian Mathematical Portal ID
 * Query examples:
 * 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)
 * Newest WikiProjects: Delhi Metro
 * Newest database reports: television series by camera setup


 * Development
 * Breaking change: "wb_entity_per_page" table will not be updated and replicated on ToolLabs anymore
 * A  Lua function will be added (T173262)
 * The  Lua function will accept a second parameter with the global identifier of a wiki (e.g. "enwiki") to link to (T142903)
 * Had to temporarily turn off showing Wikidata's changes on Commons and Russian Wikipedia because of database issues. We're working on turning it back on.
 * Continued work on persistently storing edits to Forms on Lexemes
 * Finishing work on checking constraints on qualifiers and references with the constraint checks gadget
 * Fixed a bug where notification emails for Wikidata changes were sent when they shouldn't have been (T174794)
 * Full URIs for external identifiers will soon be in the RDF export (T121274)


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Suggested and open tasks!
 * Contribute to a Showcase item.
 * Help translate or proofread the interface and documentation pages, in your own language!
 * Help merge identical items across Wikimedia projects.
 * Help write the next summary!

Read the full report &middot; Unsubscribe &middot; Lydia Pintscher (WMDE) 20:27, 9 October 2017 (UTC)

Wikidata weekly summary #282
Wikidata weekly summary #282

Here's your quick overview of what has been happening around Wikidata over the last week.  Read the full report &middot; Unsubscribe &middot; Lydia Pintscher (WMDE) 21:39, 16 October 2017 (UTC)
 * Discussions
 * New request for comments: Association Football Matches
 * Events/Blogs/Press
 * Upcoming: WikidataCon, Berlin, 28-29 October (sold out)
 * If you organize a local event for the Wikidata birthday, feel free to add it on the events page and the birthday page
 * A blog post describing Textes d'affiches, a tool using Wikidata to show movies and the works they are adapted from, developed during a hackathon at the national French library (by Shonagon, in French)
 * Slides of the presentation "Wikidata Query Service: The State of the Engine" by Stas Malyshev
 * Slides of the presentation "Wikidata and structured data initiatives at Wikimedia. Current trends and priorities" by Dario Taborelli
 * Wikidata as a linking hub for knowledge organization systems? Integrating an authority mapping into Wikidata and learning lessons for KOS mappings by Joachim Neubert
 * Other Noteworthy Stuff
 * If you are interested in Structured Data on Commons, and helping out as a Wikidata contributor, please consider joining the new Structured Commons community focus group!
 * Participate to the Global Legislative Openness Week with MySociety and organize a Wikidata workshop in your country, from 20th to 30th November 2017
 * Inventaire now has a News section where you can follow ongoing discussions and developments of the project
 * wikidata-cli added bot support and new commands (wd search, wd aliases, wd add-alias, wd remove-alias, wd set-alias)
 * wikidata-edit added bot edits support and new functions (alias.add, alias.remove, alias.set)
 * HarvestTemplates has a new collaboration platform
 * You can now use reCh to patrol items from your PagePile
 * Did you know?
 * Newest properties: Women's Sports Foundation ID, Oklahoma Sports Hall of Fame ID, North Carolina Sports Hall of Fame ID, New Mexico Sports Hall of Fame ID, National Trust Collections ID, Infopatrimônio ID, KBO pitcher ID, KBO hitter ID, Cairn author ID, Mississippi Sports Hall of Fame ID, Louisiana Sports Hall of Fame ID, Kansas Sports Hall of Fame ID, Hawai‘i Sports Hall of Fame ID, Georgia Sports Hall of Fame ID, DSMHOF athlete ID, ASHOF athlete ID, ExecutedToday ID, Monumentos de São Paulo ID, gravsted.dk ID, Dutch lost building register ID, Musikverket person ID, Megalithic Portal ID, PROSITE documentation ID, Search formatter URL, nominated by, BillionGraves cemetery ID, Cravo Albin artist ID, salinity, Lotsawa House Indian author ID, Lotsawa House Tibetan author ID, Florida Sports Hall of Fame athlete ID, T4T35 megalith ID, excavation director, QEdu ID, WBPLN author ID, Store norske leksikon ID, synodic period, PubsHistory pub ID, Organization ID on Radio Radicale, LOINC ID, digitised page from Lloyd's Register of Ships from 1930 to 1945, Lloyd's Register Ship ID, IDESCAT territorial code in Catalonia, Heritage Conservation District of Ontario ID, GenBank Assembly accession, Deutsche Synchronkartei actor-ID, Department of Education and Skills roll number, contains, Wikimedia template, Brueckenweb id, BHL bibliography ID, BFI-Filmography person ID, APA phoneme code, combination classification, young rider classification, best sprinter classification, best combative classification, mountains classification, Elite Prospects staff ID, Scottish Sports HoF athlete ID, GARD rare disease ID, kinship equivalent in SPARQL at Wikidata, SwimSwam ID, SpeedskatingResults.com speed skater ID, musée de Bretagne identifiant collections ID, camera setup, FOIH taxon ID, FOIH decree types ID, FOIH event types ID, FOIH value types ID, FOIH heritage types ID, FOIH periods ID, FOIH styles and cultures ID, FOIH materials ID
 * Query examples:
 * Flags with more than 5 stars (source)
 * Timeline of programming languages (source)
 * Female scientists sorted by number of citations of their work (source)
 * Newest WikiProjects: Women
 * Newest database reports: Jean Rochefort Filmography
 * Development
 * Continued working on persistently storing edits on Lexeme pages (specifically Forms)
 * Dealt with issues caused by too many edits being injected into recent changes on Commons and Russian Wikipedia
 * Constraint checks will also be done on qualifiers and references (T176863)
 * Fixed a regression with the focus not automatically being set after a property was selected (T177485)
 * Full URIs for external identifiers will soon be in the RDF export (T121274)
 * The secondary  table got removed now (T140890)
 * The secondary  table does have a   column now (T167114)
 * Released version 4.0.0 of the [//github.com/wmde/WikibaseDataModelJavaScript Wikibase DataModel JavaScript library] as a pure NPM package with no MediaWiki dependency (T177476)
 * Released version 3.0.0 of the [//github.com/wmde/WikibaseSerializationJavaScript Wikibase Serialization JavaScript library] as a pure NPM package with no MediaWiki dependency (T177613)
 * Released version 0.10.0 of the [//github.com/wmde/DataValuesJavaScript DataValues JavaScript library] as a pure NPM package with no MediaWiki dependency (T177232)
 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Suggested and open tasks!
 * Contribute to a Showcase item.
 * Help translate or proofread the interface and documentation pages, in your own language!
 * Help merge identical items across Wikimedia projects.
 * Help write the next summary!

The Signpost: 23 October 2017
 * Read this Signpost in full * Single-page * Unsubscribe * MediaWiki message delivery (talk) 02:36, 23 October 2017 (UTC)

Wikidata weekly summary #283
Wikidata weekly summary #282

Here's your quick overview of what has been happening around Wikidata over the last week.  Read the full report &middot; Unsubscribe &middot; Lydia Pintscher (WMDE) 08:53, 24 October 2017 (UTC)
 * Events/Blogs/Press
 * Past: Zugang Gestalten (slides by multichill)
 * Past: Coding Da Vinci (slides by Jonas)
 * Upcoming: Wikidata Birthday Tokyo, 27 October from 12:00 to 14:00 in Roppongi Hills
 * Upcoming: WikiArabia 2017, Cairo, Egypt, 23-25 October
 * Upcoming: WikidataCon, Berlin, 28-29 October (sold out)
 * Upcoming: Wikidata Birthday Seoul, 29 October from 15:00 to 18:00
 * Upcoming: Biographical Data in a Digital World 2017 6-7 November 2017 (in cooperation with Wikimedia Austria)
 * COOL-WD: A Completeness Tool for Wikidata (tool website)
 * Provenance Information in a Collaborative Knowledge Graph: an Evaluation of Wikidata External References
 * Question Answering Benchmarks for Wikidata
 * Using Word Embeddings for Search in Linked Data with Ontodia (tool website)
 * Unlocking the human potential of Wikidata
 * Textes d’Affiches, des films à lire sur Gallica
 * Other Noteworthy Stuff
 * If you have a present or organize an event for the Wikidata's fifth birthday, feel free to add link and pictures here
 * New version of the Alexa skill for Wikidata by metaphacts
 * Nice short gif tutorial for writing a Wikidata query
 * Did you know?
 * Newest properties: Ontario Sports Hall of Fame athlete ID, Quora username, Women's Basketball Hall of Fame ID, Baseball Almanac ID, sports.ru player ID, Opera Vivra singer ID, Nova Scotia Sport Hall of Fame ID, NLBPA ID, MusicBrainz recording ID, caliber, Women's Collegiate Tennis Hall of Fame ID, Museus.br ID, Memória Globo, Enciclopédia Itaú Cultural ID, Canada's Sports Hall of Fame athlete ID, International Paralympic Committee athlete ID, Alberta Sports Hall of Fame and Museum athlete ID, BrainInfo ID (hierarchical), NeuroNames ID (plain mode), Anvisa drug ID, BC Sports Hall of Fame athlete ID, TheSports.org athlete ID, mapping relation type, Science Museum people ID, Mappy place ID, update method, Virginia Sports Hall of Fame ID, Missouri Sports Hall of Fame ID, DAMIT asteroid ID, Tennessee Sports Hall of Fame athlete ID, LFB player ID, Soccerdonna player ID, Sandrart.net artwork ID, youth wing
 * Query examples:
 * 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)
 * Newest database reports: list of kinship types
 * Development
 * Query Service throttling has been tweaked, to block a type of abusive client
 * Adding diff support for Lexeme-related edits
 * More work on checking constraints on qualifiers and references (T168532)
 * Now caching constraints results to make it ready for rollout for more users
 * Continued work on more fine-grained usage tracking so we better know which parts of an item is used on an article on Wikipedia and the other sister projects
 * Improved the way Wikidata changes are shown in watchlist and recent changes on Wikipedia and Co so they are more in-line with the other changes (T48329, T50684) Thanks Matej!
 * Released the [//github.com/wmde/WikibaseDataModel Wikibase DataModel] component in version 7.2.0 (T177486)
 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Suggested and open tasks!
 * Contribute to a Showcase item.
 * Help translate or proofread the interface and documentation pages, in your own language!
 * Help merge identical items across Wikimedia projects.
 * Help write the next summary!

Wikidata weekly summary #284
Here's your quick overview of what has been happening around Wikidata over the last week. 
 * Discussions
 * New request for comments: Defining account creators


 * Events/Press/Blogs
 * Past: WikiArabia 2017, Cairo, Egypt, 23-25 October
 * Past: WikidataCon, Berlin, 28-29 October. You can find the slides, notes and video recordings for most of the sessions
 * Past: Wikidata's fifth birthday in Tokyo, Seoul, Munich
 * Upcoming: Using Wikidata to create a multi-lingual multi-dialectal dictionary for Arabic dialects in the 14th ACS/IEEE International Conference on Computer Systems and Applications (AICCSA 2017), Yasmine Hammamet, Tunisia, 30 October-3 November.
 * Upcoming : Wikidata and Wiki Loves Monuments editathon in Berlin, 24-26 November (in German). We're looking for trainers to explain the basic use of QuickStatements, Open Refine and Mix'n'Match. If you want to join, please contact MB-one


 * Wikidata's birthday
 * The fifth anniversary of Wikidata was celebrated, as every year, with a lot of presents, events and stories. You can find an overview on the birthday page.
 * Birthday presents
 * Search index now contains statements with and  . These can be used to influence search rankings and in the future also for matching.
 * inventaire.io CC0 Wikidata-ready NDJSON and TTL dumps are now accessible at dumps.inventaire.io
 * You can now move claims to new items with moveClaim.js. You can do so by typing "new".
 * Prefix search on Wikidata (wbsearchentities API) now is using ElasticSearch as backend. This should improve search quality and also is more flexible and tunable.
 * Wikidata becomes a proper citizen of the linked open data web
 * graves.wiki – visualization of grave locations stored in Wikidata
 * Wikidata Concepts Monitor (WDCM) - Wikidata semantic topics and usage statistics
 * Happy Birthday to You, Dear Wikidata – recording and improvisation (Lucas Werkmeister)
 * You can now create items from the command-line
 * Crochet your own cute structured data bee to express your appreciation for structured data in the Wikimedia movement! And ask her/him/it to join the.
 * Wikidata Query Service UI: Geoshapes from Commons are now displayed in the Map view: [https://query.wikidata.org/embed.html#%23defaultView%3AMap%0A%23%20constituencies%20for%20the%20election%20to%20the%20German%20Bundestag%202017%2C%20with%20winning%20candidate%20and%20party%0ASELECT%20%3Fdistrict%20%3FdistrictLabel%20%3FdistrictNumber%20%3Fmdb%20%3FmdbLabel%20%3Fparty%20%3FpartyLabelCONF%20%28%3FpartyLabel%20AS%20%3Flayer%29%20%3FvotesPercentage%20%3Frgb%20%3Fshape%20%3FsanityCheckMdb%20WHERE%20%7B%0A%20%20%23%20find%20districts%20with%20shape%0A%20%20%3Fdistrict%20wdt%3AP3896%20%3Fshape%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%23%20successful%20candidate%20for%2019th%20German%20Bundestag%20with%20party%20and%20%25%20votes%0A%20%20%20%20%20%20%20%20%20%20%20%20p%3AP991%20%5B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20ps%3AP991%20%3Fmdb%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20pq%3AP2937%20wd%3AQ30579723%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20pq%3AP1268%20%3Fparty%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20pqv%3AP1111%20%5B%20wikibase%3AquantityAmount%20%3FvotesPercentage%3B%20wikibase%3AquantityUnit%20wd%3AQ11229%20%5D%0A%20%20%20%20%20%20%20%20%20%20%20%20%5D%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%23%20district%20number%20in%202017%20Bundestag%20constituencies%0A%20%20%20%20%20%20%20%20%20%20%20%20p%3AP528%20%5B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20ps%3AP528%20%3FdistrictNumberString%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20pq%3AP972%20wd%3AQ26971257%0A%20%20%20%20%20%20%20%20%20%20%20%20%5D.%0A%20%20%23%20turn%20string%20district%20number%20into%20integer%0A%20%20BIND%28xsd%3Ainteger%28%3FdistrictNumberString%29%20AS%20%3FdistrictNumber%29%0A%20%20%23%20sanity%20check%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fmdb%20p%3AP39%20%5B%0A%20%20%20%20%20%20ps%3AP39%20wd%3AQ1939555%3B%0A%20%20%20%20%20%20pq%3AP2937%20wd%3AQ30579723%3B%0A%20%20%20%20%20%20pq%3AP768%20%3Fdistrict%3B%0A%20%20%20%20%20%20pq%3AP4100%20%3Fparty%0A%20%20%20%20%5D.%0A%20%20%20%20BIND%28true%20AS%20%3FsanityCheckMdb%29%0A%20%20%7D%0A%20%20%23%20find%20original%20color%20of%20party%0A%20%20%3Fparty%20wdt%3AP462%3F%2Fwdt%3AP465%20%3FrgbOriginal.%0A%20%20%23%20fade%20color%20depending%20on%20%25%20votes%2C%20knowing%20that%20the%20original%20colors%20are%20only%20composed%20of%20FF%2C%2080%2C%2000%3A%20shift%2080%20to%20A0%20or%20C0%2C%20and%2000%20to%2040%20or%2080%0A%20%20%23%20%28using%20separate%20calls%20to%20replace%20R%2C%20G%2C%20and%20B%20components%20so%20that%20the%20replacements%20are%20aligned%20to%20them%29%0A%20%20BIND%28IF%28%3FvotesPercentage%20%3E%3D%20%28100%2F2%29%2C%0A%20%20%20%20%20%20%20%20%20%20%3FrgbOriginal%2C%0A%20%20%20%20%20%20%20%20%20%20IF%28%3FvotesPercentage%20%3E%3D%20%28100%2F3%29%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20REPLACE%28REPLACE%28REPLACE%28REPLACE%28REPLACE%28REPLACE%28%3FrgbOriginal%2C%20%2280%28..%29%28..%29%22%2C%20%22A0%241%242%22%29%2C%20%22%28..%2980%28..%29%22%2C%20%22%241A0%242%22%29%2C%20%22%28..%29%28..%2980%22%2C%20%22%241%242A0%22%29%2C%20%2200%28..%29%28..%29%22%2C%20%2240%241%242%22%29%2C%20%22%28..%2900%28..%29%22%2C%20%22%24140%242%22%29%2C%20%22%28..%29%28..%2900%22%2C%20%22%241%24240%22%29%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20REPLACE%28REPLACE%28REPLACE%28REPLACE%28REPLACE%28REPLACE%28%3FrgbOriginal%2C%20%2280%28..%29%28..%29%22%2C%20%22C0%241%242%22%29%2C%20%22%28..%2980%28..%29%22%2C%20%22%241C0%242%22%29%2C%20%22%28..%29%28..%2980%22%2C%20%22%241%242C0%22%29%2C%20%2200%28..%29%28..%29%22%2C%20%2280%241%242%22%29%2C%20%22%28..%2900%28..%29%22%2C%20%22%24180%242%22%29%2C%20%22%28..%29%28..%2900%22%2C%20%22%241%24280%22%29%0A%20%20%20%20%20%20%20%20%20%20%20%20%29%0A%20%20%20%20%20%20%20%20%20%29%20AS%20%3Frgb%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%0A%20%20%20%20%3Fdistrict%20rdfs%3Alabel%20%3FdistrictLabel.%0A%20%20%20%20%3Fparty%20rdfs%3Alabel%20%3FpartyLabel.%0A%20%20%20%20%3Fmdb%20rdfs%3Alabel%20%3FmdbLabel.%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3FdistrictNumber Constituencies for the election to the German Bundestag 2017, with winning candidate and party]
 * Wikidata Query Service UI: The query service now shows you code examples for how to use your query in many programming languages (example query)
 * [//www.johl.io/dungeonofknowledge/ Dungeon of Knowledge] ([//github.com/johl/dungeonofknowledge source]), a roguelike game where you explore a dungeon full of bits of Wikidata wisdom
 * Simple WD an experiment of a simple frontend API on top of Wikidata using JSON-LD and schema.org.
 * mapview widget/user script on Wikidata
 * Images fragments for an item depicted on several artworks
 * Histropedia Query Timeline tool - Demo of cool new features launched today for WikidataCon
 * Q42395533 - the first item about a notable item!
 * SQID now suggests statements that we are missing (example page, log in to see suggestions) -- more on WikiProject_Reasoning soon
 * From labs VM to Wikibase Query Service in 2 minutes (using Docker images and docker-compose)
 * Stories and reflections
 * Wishes for the year to come, by Tpt
 * Happy Birthday Wikidata! by the Gene Wiki Team
 * Some random thoughts on the occasion of Wikidata's fifth birthday, by PKM
 * Wishes and a personal story, by Spinster
 * Happy Birthday, Wikidata by RolandUnger from Wikivoyage
 * Happy Birthday, Wikidata by Katherine Maher
 * Two years of Wikidata experience from ArthurPSmith
 * Happy Birthday wishes from Wikimedia Deutschland
 * Message from the development team


 * Did you know?


 * Newest properties: Biblioteca Nacional de México ID, MNCARS artist ID, BFI Film and TV ID, FPB rating, The Coptic Library ID, snap package, LesBiographies.com ID, Indian Foundation for Butterflies ID, AKL Online Artist ID, Google Doodle, New York City Parks Monument ID, Pro14 player ID, implementation of, GACS ID, Y-DNA Haplogroup, mtDNA haplogroup, mandates, Portuguese lighthouse ID, U.S. Ski and Snowboard Hall of Fame athlete ID, Sportbox.ru ID, VNDB ID, Videolectures ID, New Zealand Sports Hall of Fame ID, rfpl.org player ID, Panthéon des sports du Québec ID, Sport Australia Hall of Fame inductee ID, New Brunswick Sports Hall of Fame athlete ID, Manitoba Sports Hall of Fame athlete ID, Ontario Sports Hall of Fame athlete ID, Quora username, Women's Basketball Hall of Fame ID


 * Query examples:
 * Organic acids with images (source)
 * People who are their father's father (source)
 * [https://query.wikidata.org/#%23defaultView%3AMap%0A%23%20constituencies%20for%20the%20election%20to%20the%20German%20Bundestag%202017%2C%20with%20winning%20candidate%20and%20party%0ASELECT%20%3Fdistrict%20%3FdistrictLabel%20%3FdistrictNumber%20%3Fmdb%20%3FmdbLabel%20%3Fparty%20%3FpartyLabelCONF%20%28%3FpartyLabel%20AS%20%3Flayer%29%20%3FvotesPercentage%20%3Frgb%20%3Fshape%20%3FsanityCheckMdb%20WHERE%20%7B%0A%20%20%23%20find%20districts%20with%20shape%0A%20%20%3Fdistrict%20wdt%3AP3896%20%3Fshape%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%23%20successful%20candidate%20for%2019th%20German%20Bundestag%20with%20party%20and%20%25%20votes%0A%20%20%20%20%20%20%20%20%20%20%20%20p%3AP991%20%5B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20ps%3AP991%20%3Fmdb%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20pq%3AP2937%20wd%3AQ30579723%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20pq%3AP1268%20%3Fparty%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20pqv%3AP1111%20%5B%20wikibase%3AquantityAmount%20%3FvotesPercentage%3B%20wikibase%3AquantityUnit%20wd%3AQ11229%20%5D%0A%20%20%20%20%20%20%20%20%20%20%20%20%5D%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%23%20district%20number%20in%202017%20Bundestag%20constituencies%0A%20%20%20%20%20%20%20%20%20%20%20%20p%3AP528%20%5B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20ps%3AP528%20%3FdistrictNumberString%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20pq%3AP972%20wd%3AQ26971257%0A%20%20%20%20%20%20%20%20%20%20%20%20%5D.%0A%20%20%23%20turn%20string%20district%20number%20into%20integer%0A%20%20BIND%28xsd%3Ainteger%28%3FdistrictNumberString%29%20AS%20%3FdistrictNumber%29%0A%20%20%23%20sanity%20check%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fmdb%20p%3AP39%20%5B%0A%20%20%20%20%20%20ps%3AP39%20wd%3AQ1939555%3B%0A%20%20%20%20%20%20pq%3AP2937%20wd%3AQ30579723%3B%0A%20%20%20%20%20%20pq%3AP768%20%3Fdistrict%3B%0A%20%20%20%20%20%20pq%3AP4100%20%3Fparty%0A%20%20%20%20%5D.%0A%20%20%20%20BIND%28true%20AS%20%3FsanityCheckMdb%29%0A%20%20%7D%0A%20%20%23%20find%20original%20color%20of%20party%0A%20%20%3Fparty%20wdt%3AP462%3F%2Fwdt%3AP465%20%3FrgbOriginal.%0A%20%20%23%20fade%20color%20depending%20on%20%25%20votes%2C%20knowing%20that%20the%20original%20colors%20are%20only%20composed%20of%20FF%2C%2080%2C%2000%3A%20shift%2080%20to%20A0%20or%20C0%2C%20and%2000%20to%2040%20or%2080%0A%20%20%23%20%28using%20separate%20calls%20to%20replace%20R%2C%20G%2C%20and%20B%20components%20so%20that%20the%20replacements%20are%20aligned%20to%20them%29%0A%20%20BIND%28IF%28%3FvotesPercentage%20%3E%3D%20%28100%2F2%29%2C%0A%20%20%20%20%20%20%20%20%20%20%3FrgbOriginal%2C%0A%20%20%20%20%20%20%20%20%20%20IF%28%3FvotesPercentage%20%3E%3D%20%28100%2F3%29%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20REPLACE%28REPLACE%28REPLACE%28REPLACE%28REPLACE%28REPLACE%28%3FrgbOriginal%2C%20%2280%28..%29%28..%29%22%2C%20%22A0%241%242%22%29%2C%20%22%28..%2980%28..%29%22%2C%20%22%241A0%242%22%29%2C%20%22%28..%29%28..%2980%22%2C%20%22%241%242A0%22%29%2C%20%2200%28..%29%28..%29%22%2C%20%2240%241%242%22%29%2C%20%22%28..%2900%28..%29%22%2C%20%22%24140%242%22%29%2C%20%22%28..%29%28..%2900%22%2C%20%22%241%24240%22%29%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20REPLACE%28REPLACE%28REPLACE%28REPLACE%28REPLACE%28REPLACE%28%3FrgbOriginal%2C%20%2280%28..%29%28..%29%22%2C%20%22C0%241%242%22%29%2C%20%22%28..%2980%28..%29%22%2C%20%22%241C0%242%22%29%2C%20%22%28..%29%28..%2980%22%2C%20%22%241%242C0%22%29%2C%20%2200%28..%29%28..%29%22%2C%20%2280%241%242%22%29%2C%20%22%28..%2900%28..%29%22%2C%20%22%24180%242%22%29%2C%20%22%28..%29%28..%2900%22%2C%20%22%241%24280%22%29%0A%20%20%20%20%20%20%20%20%20%20%20%20%29%0A%20%20%20%20%20%20%20%20%20%29%20AS%20%3Frgb%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%0A%20%20%20%20%3Fdistrict%20rdfs%3Alabel%20%3FdistrictLabel.%0A%20%20%20%20%3Fparty%20rdfs%3Alabel%20%3FpartyLabel.%0A%20%20%20%20%3Fmdb%20rdfs%3Alabel%20%3FmdbLabel.%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3FdistrictNumber 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)
 * [https://query.wikidata.org/#%23%20UK%20parliaments%20with%20count%20of%20Johns%20and%20count%20of%20women%0A%23defaultView%3ALineChart%0ASELECT%20%3Fdate%20%3Fcount%20%3Flabel%20WITH%20%7B%0A%20%20%23%20all%20MPs%20with%20their%20associated%20parliament%0A%20%20SELECT%20DISTINCT%20%3Fmp%20%3Fparliament%20WHERE%20%7B%0A%20%20%20%20%3Fmp%20wdt%3AP31%20wd%3AQ5.%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%23%20new%20data%20model%3A%20position%20held%20%E2%80%93%20Member%20of%20the%20nth%20Parliament%20of%20the%20United%20Kingdom%0A%20%20%20%20%20%20%3Fmp%20p%3AP39%2Fps%3AP39%20%3Fposition.%0A%20%20%20%20%20%20%3Fposition%20wdt%3AP279%20wd%3AQ16707842%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20p%3AP279%2Fpq%3AP2937%7Cwdt%3AP2937%20%3Fparliament.%0A%20%20%20%20%7D%20UNION%20%7B%0A%20%20%20%20%20%20%23%20old%20data%20model%3A%20member%20of%20%E2%80%93%20nth%20Parliament%20of%20the%20United%20Kingdom%0A%20%20%20%20%20%20%3Fmp%20p%3AP463%2Fps%3AP463%20%3Fparliament.%0A%20%20%20%20%20%20%3Fparliament%20wdt%3AP31%20wd%3AQ21094819.%0A%20%20%20%20%7D%0A%20%20%7D%0A%7D%20AS%20%25MPsWithParliament%20WITH%20%7B%0A%20%20%23%20count%20of%20Johns%20in%20each%20parliament%0A%20%20SELECT%20%3Fparliament%20%28COUNT%28DISTINCT%20%3Fmp%29%20AS%20%3Fjohns%29%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25MPsWithParliament.%0A%20%20%20%20%3Fmp%20wdt%3AP735%20wd%3AQ4925477.%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fparliament%0A%7D%20AS%20%25johns%20WITH%20%7B%0A%20%20%23%20count%20of%20women%20in%20each%20parliament%0A%20%20SELECT%20%3Fparliament%20%28COUNT%28DISTINCT%20%3Fmp%29%20AS%20%3Fwomen%29%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25MPsWithParliament.%0A%20%20%20%20%3Fmp%20wdt%3AP21%2Fwdt%3AP279%2a%20wd%3AQ6581072.%20%23%20%28P279%2a%3A%20include%20transgender%20females%20%E2%80%93%20non%20yet%2C%20but%20will%20probably%20happen%20in%20the%20future%29%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fparliament%0A%7D%20AS%20%25women%20WHERE%20%7B%0A%20%20%23%20get%20%3Fjohns%20and%20%3Fwomen%0A%20%20INCLUDE%20%25johns.%0A%20%20INCLUDE%20%25women.%0A%20%20%23%20fan%20out%20single%20result%0A%20%20%23%20%3Fparliament%20%3Fjohns%20%3Fwomen%0A%20%20%23%20into%20two%20results%0A%20%20%23%20%3Fparliament%20%22Johns%22%20%3Fjohns%0A%20%20%23%20%3Fparliament%20%22women%22%20%3Fwomen%0A%20%20%23%20so%20the%20line%20chart%20works%0A%20%20VALUES%20%3Flabel%20%7B%20%22Johns%22%40en%20%22women%22%40en%20%7D%0A%20%20BIND%28IF%28%3Flabel%20%3D%20%22Johns%22%40en%2C%20%3Fjohns%2C%20%3Fwomen%29%20AS%20%3Fcount%29%0A%20%20%23%20get%20parliament%20date%20for%20the%20chart%0A%20%20%3Fparliament%20wdt%3AP571%7Cwdt%3AP580%20%3Fdate.%0A%20%20%23%20add%20labels%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AORDER%20BY%20%3Fdate 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)


 * Development
 * Continued working on persistent storage of edits on Lexeme pages
 * Fixed an encoding problem in the SVG download of query results in the query service (T178564)
 * Fixed a problem with change dispatching changes to Wikipedia and co, that sometimes lead to single wikis falling way behind. (T179060)
 * Added full URIs for external identifiers to the RDF export
 * You can leave feedback on how improved fulltext search result page should look like

You can see all open tickets related to Wikidata here.


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Suggested and open tasks!
 * Contribute to a Showcase item.
 * Help translate or proofread the interface and documentation pages, in your own language!
 * Help merge identical items across Wikimedia projects.
 * Help write the next summary!

Read the full report &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 15:29, 30 October 2017 (UTC)