Hey folks :)

Here is your summary of what's been happening around Wikidata over the past week. Discussions

- Monolingual language code creation process https://www.wikidata.org/wiki/Wikidata:Project_chat#Monolingual_language_code_creation_process

Events https://www.wikidata.org/wiki/Special:MyLanguage/Wikidata:Events/ Press/Blogs https://www.wikidata.org/wiki/Special:MyLanguage/Wikidata:Press_coverage

- Past: IRC office hour (log https://tools.wmflabs.org/meetbot/wikimedia-office/2017/wikimedia-office.2017-11-14-18.00.log.html ) - Past: Wikidata Lab II, a workshop to teach users how to create lists using Wikidata in São Paulo (images from the event https://commons.wikimedia.org/wiki/Category:Wikidata_Lab_II) - Upcoming: *IRC office hour* about *Structured Data on Commons https://commons.wikimedia.org/wiki/Commons:Structured_data*, November 21, 18:00 UTC in the channel #wikimedia-office - Upcoming: *WLM-Wikidata-Editathon 2017* https://de.wikipedia.org/wiki/Wikipedia:WLM-Wikidata-Editathon_2017 in Berlin, November 24-26 - Upcoming: *Wiki4MediaFreedom edit-a-thon - II edition* https://meta.wikimedia.org/wiki/Wiki4MediaFreedom_edit-a-thon_-_II_edition (with Wikidata track) in Sofia, November 27 - Upcoming: Wikidata-Hackathon at WikiMUC https://de.wikipedia.org/wiki/Wikipedia:WikiMUC/2017-11-30_Wikidata-Hackathon in Munich, November 30 - WikidataCon 2017 https://blog.wikimedia.de/2017/11/13/wikidatacon-2017/ - Fünf Jahre Wikidata at Chaosradio https://chaosradio.ccc.de/cr240.html - "Turning a historical book into a data set" http://blogs.bodleian.ox.ac.uk/digital/2017/10/24/turning-historical-book-data-set/ - "Creating Wikipedia articles from research data" http://blogs.bodleian.ox.ac.uk/digital/2017/10/27/creating-wikipedia-articles-from-research-data/

Other Noteworthy Stuff

- New tool by Magnus: Wikidata SPARQL Recent Changes https://tools.wmflabs.org/wikidata-todo/sparql_rc.php - get diffs for all items matching a SPARQL query, for a date range - New tool by Magnus: WD edit stats https://tools.wmflabs.org/wikidata-todo/wd_edit_stats.php - get edit stats for all items matching a SPARQL query - Wikidata coverage for 'place' in OpenStreetMap https://docs.google.com/spreadsheets/d/1iFk25F4tRtIGTP-3jih6MbDm2oF29Sjn0X7o81XGSsw/edit#gid=0 (as of October 2017) - OpenRefine 2.8 https://github.com/OpenRefine/OpenRefine/releases/tag/2.8 was released. Adding columns from Wikidata and importing Wikitables is now possible. Let's write tutorials for it https://www.wikidata.org/wiki/Wikidata:Tools/OpenRefine. - Mix'n'match now shows for a catalog which user originally imported it and if it is updated regularly (example https://tools.wmflabs.org/mix-n-match/?#/catalog/323) - A breaking change to the *wbcheckconstraints* API output format was announced https://www.wikidata.org/wiki/Wikidata:Project_chat#BREAKING_CHANGE:_wbcheckconstraints_detail_output

Did you know?

- Newest properties https://www.wikidata.org/wiki/Special:ListProperties: CGF athlete ID https://www.wikidata.org/wiki/Property:P4548, OKS athlete ID https://www.wikidata.org/wiki/Property:P4547, Gymn Forum athlete ID https://www.wikidata.org/wiki/Property:P4546, sexually homologous with https://www.wikidata.org/wiki/Property:P4545, Tennis Temple player ID https://www.wikidata.org/wiki/Property:P4544, has listed ingredient https://www.wikidata.org/wiki/Property:P4543, World of O athlete ID https://www.wikidata.org/wiki/Property:P4542, HOO athlete ID https://www.wikidata.org/wiki/Property:P4541, IBTrACS cyclone ID https://www.wikidata.org/wiki/Property:P4540, Collective Biographies of Women ID https://www.wikidata.org/wiki/Property:P4539, Snooker Database player ID https://www.wikidata.org/wiki/Property:P4538, Spider Ontology ID https://www.wikidata.org/wiki/Property:P4537, EThOS thesis ID https://www.wikidata.org/wiki/Property:P4536, EUTA theatre ID https://www.wikidata.org/wiki/Property:P4535, EUTA person ID https://www.wikidata.org/wiki/Property:P4534, Czech Street ID https://www.wikidata.org/wiki/Property:P4533, Survey of Scottish Witchcraft - Trial ID https://www.wikidata.org/wiki/Property:P4532, ChinesePosters artist ID https://www.wikidata.org/wiki/Property:P4531, Bangladesh administrative division code https://www.wikidata.org/wiki/Property:P4530, Douban movie ID https://www.wikidata.org/wiki/Property:P4529, REGINE water system number https://www.wikidata.org/wiki/Property:P4528, UK Parliament thesaurus ID https://www.wikidata.org/wiki/Property:P4527, ABA bird ID https://www.wikidata.org/wiki/Property:P4526, MuIS ID https://www.wikidata.org/wiki/Property:P4525, Survey of Scottish Witchcraft - Person ID https://www.wikidata.org/wiki/Property:P4524, Vermont Sports Hall of Fame athlete ID https://www.wikidata.org/wiki/Property:P4523, Alaska Sports Hall of Fame athlete ID https://www.wikidata.org/wiki/Property:P4522, Radio Radicale person ID https://www.wikidata.org/wiki/Property:P4521, SUNCAT ID https://www.wikidata.org/wiki/Property:P4520, payload mass https://www.wikidata.org/wiki/Property:P4519, Melon album ID https://www.wikidata.org/wiki/Property:P4518, ctext work ID https://www.wikidata.org/wiki/Property:P4517, Mémoire du cyclisme cyclist ID https://www.wikidata.org/wiki/Property:P4516, Prisma ID https://www.wikidata.org/wiki/Property:P4515, Africultures person ID https://www.wikidata.org/wiki/Property:P4514, Africultures movie ID https://www.wikidata.org/wiki/Property:P4513, Scottish Cemetery Kolkata ID https://www.wikidata.org/wiki/Property:P4512 - Query examples: - List of subclasses of Matrices https://tools.wmflabs.org/wikidata-todo/tree.html?lang=de&q=Q44337&rp=279 - Works of art in which the artists depicts their spouse https://query.wikidata.org/#%23defaultView%3AImageGrid%0ASELECT%20%3Fcreator%20%3FcreatorLabel%20%3FspouseLabel%20%3Fpic%0AWHERE%20%0A%7B%0A%20%20%3Fart%20wdt%3AP180%20%3Fspouse.%0A%20%20%3Fart%20wdt%3AP170%20%3Fcreator.%0A%20%20%3Fspouse%20wdt%3AP31%20wd%3AQ5.%0A%20%20%3Fcreator%20wdt%3AP26%20%3Fspouse.%0A%20%20OPTIONAL%20%7B%20%3Fart%20wdt%3AP18%20%3Fpic%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0A (source https://twitter.com/netsensei/status/930734466666041350) - locations Van Gogh depicted in his paintings https://query.wikidata.org/#%23defaultView%3AMap%0ASELECT%20%3Fpainting%20%3FdepictsLabel%20%3Flocation%20%3Fpic%0AWHERE%20%0A%7B%0A%20%20%3Fpainting%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ4502142.%0A%20%20%3Fpainting%20wdt%3AP170%20wd%3AQ5582.%0A%20%20%3Fpainting%20wdt%3AP180%20%3Fdepicts.%0A%20%20%3Fdepicts%20wdt%3AP625%20%3Flocation.%0A%20%20OPTIONAL%20%7B%20%3Fpainting%20wdt%3AP18%20%3Fpic%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D (source https://twitter.com/netsensei/status/932268852410535936) - Gender split of past Google Doodles https://query.wikidata.org/#SELECT%20%3Fsexo_ou_g_neroLabel%20%28COUNT%28%3Fser_humano%29%20AS%20%3Fcount%29%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fser_humano%20wdt%3AP31%20wd%3AQ5.%0A%20%20%3Fser_humano%20wdt%3AP4431%20%3FGoogle_Doodle.%0A%20%20OPTIONAL%20%7B%20%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fser_humano%20wdt%3AP21%20%3Fsexo_ou_g_nero.%20%7D%0A%7D%0AGROUP%20BY%20%3Fsexo_ou_g_neroLabel (source https://twitter.com/WikidataFacts/status/931131040185438210) - Newest database reports: expeditions https://www.wikidata.org/wiki/Wikidata:Lists/expeditions

Development

- Fixed Commons media suggester not loading all preview thumbnails ( phabricator:T160528 https://phabricator.wikimedia.org/T160528) - RDF exports can handle entity references to foreign Wikibase repositories now, needed for Structured Data on Commons ( phabricator:T161592 https://phabricator.wikimedia.org/T161592) - Worked on making statements on Forms https://www.mediawiki.org/wiki/Extension:WikibaseLexeme/Data_Model#Form editable and persistent (phabricator:T163724 https://phabricator.wikimedia.org/T163724) - Worked on fine-grained usage tracking in Wikibase' Lua library ( phabricator:T172914 https://phabricator.wikimedia.org/T172914) - Worked on caching constraint check results (phabricator:T179849 https://phabricator.wikimedia.org/T179849) and indicating when constraint check results are cached (phabricator:T179844 https://phabricator.wikimedia.org/T179844) - Wikibase code base does not use Composer class autoloading any more ( phabricator:T180067 https://phabricator.wikimedia.org/T180067) as another step towards getting rid of our own build process and being more in line with the rest of Wikimedia

You can see all open tickets related to Wikidata here https://phabricator.wikimedia.org/maniphest/query/4RotIcw5oINo/#R. Monthly Tasks

- Add labels, in your own language(s), for the new properties listed above. - Comment on property proposals: all open proposals https://www.wikidata.org/wiki/Wikidata:Property_proposal/Overview - Suggested and open tasks https://www.wikidata.org/wiki/Wikidata:Contribute/Suggested_and_open_tasks ! - Contribute to a Showcase item https://www.wikidata.org/wiki/Special:MyLanguage/Wikidata:Showcase_items . - Help translate https://www.wikidata.org/wiki/Special:LanguageStats or proofread the interface and documentation pages, in your own language! - Help merge identical items https://www.wikidata.org/wiki/User:Pasleim/projectmerge across Wikimedia projects. - Help write the next summary! https://www.wikidata.org/wiki/Wikidata:Status_updates/Next

Anything to add? Please share! :)

Cheers Lydia