Hey everyone :)

Here's your summary of what happened around Wikidata over the past week. Events https://www.wikidata.org/wiki/Wikidata:Events/Press/Blogs https://www.wikidata.org/wiki/Wikidata:Press_coverage

- Past: OpenTechSummit http://opentechsummit.net/ (slides https://commons.wikimedia.org/wiki/File:Mining_the_knowledge_of_the_world_with_Wikidata.pdf ) - Past: CSVConf http://csvconf.com - Past: Subscribe7 https://fahrplan.subscribe.de/sub7/events/196 ( slides https://docs.google.com/presentation/d/1VF0ml3nWFRsYN-hwRgVfnXGi5w1iQ8CdJ3OKbEJsrVs/edit )

Other Noteworthy Stuff

- Our Main Page http://wikidata.org now has a section for popular items to show you what is trending on Wikidata based on several people editing an item over the last few days - More constraint templates https://www.wikidata.org/wiki/Category:Constraint_templates now generate SPARQL links - Europeana Art History Challenge https://www.wikidata.org/wiki/Wikidata:Europeana_Art_History_Challenge is still going on until the end of the month - Freebase has been shut down https://groups.google.com/d/msg/freebase-discuss/WEnyO8f7xOQ/VucJKFVhBAAJ - Wikiversity now has access to the data on Wikidata as well - The 24,000,000th item was created: Q24000000 https://www.wikidata.org/wiki/Q24000000 - The ArticlePlaceholder https://www.mediawiki.org/wiki/Extension:ArticlePlaceholder will go live on the first Wikipedias on Wednesday (Esperanto, Haitian Creole, Neapolitan Wikipedia) - Quora: Why isn't Wikimedia Commons using structured data via Wikidata? https://www.quora.com/Why-isnt-Wikimedia-Commons-using-structured-data-via-Wikidata/answer/Lydia-Pintscher - Newest trend on Twitter: annotating https://twitter.com/WikidataFacts/status/728628300147503104 books https://twitter.com/ReaderMeter/status/728998057216385024 with Wikidata statements https://twitter.com/WikidataFacts/status/729053802054193152 ;-)

Did you know?

- Newest properties https://www.wikidata.org/wiki/Special:ListProperties: flower color https://www.wikidata.org/wiki/Property:P2827, Megogo ID https://www.wikidata.org/wiki/Property:P2826, via https://www.wikidata.org/wiki/Property:P2825, Gazetteer of Planetary Nomenclature ID https://www.wikidata.org/wiki/Property:P2824, Belgian Football ID https://www.wikidata.org/wiki/Property:P2823, by-product of https://www.wikidata.org/wiki/Property:P2822, by-product https://www.wikidata.org/wiki/Property:P2821, cardinality of this set https://www.wikidata.org/wiki/Property:P2820, Yandex.Music album ID https://www.wikidata.org/wiki/Property:P2819, Sherdog ID https://www.wikidata.org/wiki/Property:P2818, appears in the heritage monument list https://www.wikidata.org/wiki/Property:P2817, HowLongToBeat identifier https://www.wikidata.org/wiki/Property:P2816, ESR station code https://www.wikidata.org/wiki/Property:P2815, P-number https://www.wikidata.org/wiki/Property:P2814, mouthpiece https://www.wikidata.org/wiki/Property:P2813, MathWorld identifier https://www.wikidata.org/wiki/Property:P2812, PGA Tour ID https://www.wikidata.org/wiki/Property:P2811, LPGA Tour ID https://www.wikidata.org/wiki/Property:P2810, Australasian Pollen and Spore Atlas Code https://www.wikidata.org/wiki/Property:P2809, wavelength https://www.wikidata.org/wiki/Property:P2808, molar volume https://www.wikidata.org/wiki/Property:P2807, vibration https://www.wikidata.org/wiki/Property:P2806, goratings ID https://www.wikidata.org/wiki/Property:P2805, International Sailing Federation ID https://www.wikidata.org/wiki/Property:P2804, Wikidata time precision https://www.wikidata.org/wiki/Property:P2803, fleet or registration number https://www.wikidata.org/wiki/Property:P2802, FIVB beach volleyball player ID https://www.wikidata.org/wiki/Property:P2801, Beach Volleyball Database ID https://www.wikidata.org/wiki/Property:P2800, BVMC person ID https://www.wikidata.org/wiki/Property:P2799 - Query examples: most frequent occupations without a label in a given language https://query.wikidata.org/#%23Most%20frequent%20occupations%20without%20a%20label%20in%20Latvian%20%28lv%29%0A%23by%20Edgars2007%2FJura1%2C%202016-05-09%0ASELECT%20%3Foccup%20%3FoccupLabel%20%3Fcount%0AWHERE%0A%7B%0A%09%7B%0A%09%09SELECT%20%3Foccup%20%28COUNT%28%3Fperson%29%20as%20%3Fcount%29%0A%09%09WHERE%0A%09%09%7B%0A%09%09%09%3Fperson%20wdt%3AP106%20%3Foccup%0A%09%09%7D%0A%09%09GROUP%20BY%20%3Foccup%0A%09%09ORDER%20BY%20DESC%28%3Fcount%29%0A%09%09LIMIT%201000%0A%09%7D%0A%20%20%09OPTIONAL%20%7B%3Foccup%20rdfs%3Alabel%20%3Flabel1%20%09filter%28lang%28%3Flabel1%29%20%3D%20%22lv%22%29%7D%0A%09FILTER%28%21BOUND%28%3Flabel1%29%29%0A%20%20%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Ces%2Cpl%2Cja%2Czh%2Cru%22%20%7D%0A%7D%0AORDER%20BY%20DESC%28%3Fcount%29%0ALIMIT%2050, map of places of birth of economists https://query.wikidata.org/#%23defaultView%3AMap%0ASELECT%20%3Fperson%20%3Fname%20%3Fcoord%20%3Fplace%20%3Fbirthplace%20%3Fbirthyear%20WHERE%20%7B%0A%20%20%20%7B%3Fperson%20wdt%3AP106%20wd%3AQ188094%20.%7D%20UNION%20%7B%3Fperson%20wd%3AP101%20wd%3AQ8134.%7D.%20MINUS%20%7B%3Fperson%20wdt%3AP106%20wd%3AQ188094.%20%3Fperson%20wd%3AP101%20wd%3AQ8134.%7D%0A%20%20%20%3Fperson%20wdt%3AP19%20%3Fplace%20.%0A%20%20%20%3Fplace%20wdt%3AP625%20%3Fcoord%20.%0A%20%20%20%20%20%20OPTIONAL%20%7B%20%3Fperson%20wdt%3AP569%20%3Fdob%20.%7D.%0A%09BIND%28YEAR%28%3Fdob%29%20as%20%3Fbirthyear%29.%0A%20%20%20%3Fperson%20rdfs%3Alabel%20%3Fname%20filter%20%28lang%28%3Fname%29%20%3D%20%22en%22%29%0A%20%20%20%3Fplace%20rdfs%3Alabel%20%3Fbirthplace%20filter%20%28lang%28%3Fbirthplace%29%20%3D%20%22en%22%29%0A%7D (source https://twitter.com/economics_net/status/727480376193605632), map of all the paintings for which we know a location with the count per location https://query.wikidata.org/#%23Map%20of%20all%20the%20paintings%20for%20which%20we%20know%20a%20location%20with%20the%20count%20per%20location%0A%23defaultView%3AMap%0ASELECT%20%3FlocationLabel%20%3Fcoord%20%28count%28*%29%20as%20%3Fcount%29%0AWHERE%20%7B%0A%20%20%20%20%3Fpainting%20wdt%3AP31%20wd%3AQ3305213%20.%20%0A%20%20%20%20%3Fpainting%20wdt%3AP276%20%3Flocation%20.%0A%09%3Flocation%20wdt%3AP625%20%3Fcoord%0A%09SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%20%20%20%20%20%20%20%0A%7D%0A%20%20%20%20GROUP%20BY%20%3FlocationLabel%20%3Fcoord (source https://twitter.com/mdammers/status/727910405637582848), scientists who have worked together but whose Erdős numbers don’t reflect that https://query.wikidata.org/#%23%20Finds%20authors%20who%20have%20published%20scientific%20articles%20together%2C%0A%23%20but%20whose%20Erd%C5%91s%20numbers%20are%20more%20than%20one%20apart.%0A%23%20These%20would%20appear%20to%20violate%20the%20definition%20of%20the%20Erd%C5%91s%20number.%0A%0ASELECT%0A%23%20Q%23s%0A%3Fpaper%0A%3Fauthor1%0A%3Fauthor2%0A%23%20title%20%28either%20from%20title%20statement%20or%20label%29%0A%28IF%28BOUND%28%3Ftitle%29%2C%20%3Ftitle%2C%20%3FpaperLabel%29%20AS%20%3Ftitle%29%0A%23%20author%20labels%20%28should%20be%20names%29%20and%20their%20Erd%C5%91s%20numbers%0A%3Fauthor1Label%0A%3Ferd%C5%91s1%0A%3Fauthor2Label%0A%3Ferd%C5%91s2%0A%23%20distance%20between%20Erd%C5%91s%20numbers%0A%3Fdistance%0AWHERE%0A%7B%0A%20%20%23%20paper%2C%20instance%20of%20or%20subclass%20of%20scientific%20article%3B%20also%20has%20two%20authors%0A%20%20%3Fpaper%20wdt%3AP31%2Fwdt%3AP279*%20wd%3AQ13442814%3B%0A%20%20%20%20%20%20%20%20%20wdt%3AP50%20%3Fauthor1%2C%20%3Fauthor2.%0A%20%20%23%20if%20it%20has%20a%20title%2C%20we%E2%80%99ll%20grab%20that%20as%20well%2C%20but%20it%E2%80%99s%20also%20okay%20if%20there%E2%80%99s%20no%20title%0A%20%20OPTIONAL%20%7B%20%3Fpaper%20wdt%3AP1476%20%3Ftitle.%20%7D%0A%20%20%23%20grab%20Erd%C5%91s%20numbers%20of%20the%20two%20authors%0A%20%20%3Fauthor1%20wdt%3AP2021%20%3Ferd%C5%91s1.%0A%20%20%3Fauthor2%20wdt%3AP2021%20%3Ferd%C5%91s2.%0A%20%20%23%20introduce%20a%20new%20variable%20for%20the%20difference%20of%20the%20Erd%C5%91s%20numbers%0A%20%20BIND%28%3Ferd%C5%91s2%20-%20%3Ferd%C5%91s1%20AS%20%3Fdistance%29.%0A%20%20%23%20select%20those%20cases%20where%20the%20distance%20is%20%3E%201%0A%20%20%23%20%28note%3A%20by%20*not*%20taking%20the%20absolute%20value%20of%20the%20distance%2C%20we%20avoid%20getting%20duplicated%20cases%20because%20the%20author%20variables%20might%20be%20swapped%29%0A%20%20FILTER%28%3Fdistance%20%3E%201%29.%0A%20%20%23%20get%20*Label%20variables%20automagically%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D%0A%23%20sort%20by%20distance%20first%20%28descending%29%2C%20then%20by%20first%20author%2C%20then%20by%20second%20author%0AORDER%20BY%20DESC%28%3Fdistance%29%20%3Fauthor1Label%20%3Fauthor2Label (source https://twitter.com/WikidataFacts/status/728623992693731328), members of the French National Assembly born out of France https://query.wikidata.org/#PREFIX%20wikibase%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%0APREFIX%20wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%20%0APREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0A%0ASELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3FplaceLabel%20%3FcountryLabel%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP39%20wd%3AQ3044918%20.%0A%20%20%3Fitem%20wdt%3AP19%20%3Fplace%20.%0A%20%20%3Fplace%20wdt%3AP17%20%3Fcountry%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fplace%20wdt%3AP17%20wd%3AQ142%20.%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22fr%22%20.%20%7D%0A%7D%20ORDER%20BY%20%3FcountryLabel%20%3FitemLabel (source https://twitter.com/PoulpyWP/status/729048824203886592), mathematical proofs https://query.wikidata.org/#SELECT%20%3Fproof%20%3FproofLabel%0AWHERE%0A%7B%0A%20%20%3Fproof%20wdt%3AP31%20wd%3AQ11538.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D (source https://twitter.com/WikidataFacts/status/729078702965952513), items that depict most things https://query.wikidata.org/#SELECT%20%3Fwork%20%28COUNT%28%3Fdepicted%29%20AS%20%3Fcount%29%0AWHERE%0A%7B%0A%20%20%3Fwork%20wdt%3AP180%20%3Fdepicted.%0A%7D%0AGROUP%20BY%20%3Fwork%0AORDER%20BY%20DESC%28%3Fcount%29%0ALIMIT%2010 (source https://twitter.com/WikidataFacts/status/728636613182525440)

Development

- Finished remaining blockers for deploying the ArticlePlaceholder on the first Wikipedias - More work on initial Commons prototype - Further work on textual representation of SPARQL queries to allow you to read/edit more of an existing query without having to touch SPARQL - Show label instead of URI for globes in coordinate diffs - thanks Ricordisamoa! (phabricator:T110193 https://phabricator.wikimedia.org/T110193) - Improve recent changes entries formatting on Wikipedia and co ( phabricator:T52893 https://phabricator.wikimedia.org/T52893) - No longer showing a restore link for inaccessible revdel'ed entity revisions - thanks Matěj! (phabricator:T55496 https://phabricator.wikimedia.org/T55496) - Investigated and worked around issues with the suggestions for new statements - needs more work (phabricator:T132839 https://phabricator.wikimedia.org/T132839)

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

- Hack on one of these https://phabricator.wikimedia.org/maniphest/query/R8GRzX1eH0tb/#R. - Help develop the next summary here! https://www.wikidata.org/wiki/Wikidata:Status_updates/Next - Contribute to a Showcase item https://www.wikidata.org/wiki/Wikidata:Showcase_items - Help translate https://www.wikidata.org/wiki/Special:LanguageStats or proofread pages in your own language! - Add labels, in your own language(s), for the new properties listed above.

Anything to add? Please share! :)

Cheers Lydia