*Here's your quick overview of what has been happening around Wikidata over the last week.* Fourth birthday: thank you! https://www.wikidata.org/wiki/Wikidata:Fourth_Birthday https://commons.wikimedia.org/wiki/File:WikidataBirthdayMap2016.png Map of the birthday parties

Thanks to everyone who celebrated the birthday by organizing or attending to an event, letting a message on Wikidata or on the social networks, writing a story or creating a present!

Here's the list of the birthday presents from the community and development team:

- d:Template:User Wikidata birthday 2016 https://www.wikidata.org/wiki/Template:User_Wikidata_birthday_2016 ( Pigsonthewing https://www.wikidata.org/wiki/User:Pigsonthewing) - A new version of the map showing all the Wikidata items with geolocalisation https://www.wikidata.org/wiki/File:Wikidata_Map_October_2016_Normal.png (Addshore https://www.wikidata.org/wiki/User:Addshore) - Wikidata's 4th birthday logo https://www.wikidata.org/wiki/File:Logo_fourth_Wikidata_Birthday.png ( Incabell https://www.wikidata.org/wiki/User:Incabell) - A new release of the Wikipedia and Wikidata Tools for Google Spreadsheets https://chrome.google.com/webstore/detail/wikipedia-and-wikidata-to/aiilcelhmpllcgkhhpifagfehbddkdfp?utm_source=permalink add-on has made working with Wikidata a lot easier https://docs.google.com/spreadsheets/d/1QuUVFl6x3c1Yj3J7jd_OTHYD2haVFVtebIw2It4KNoA/edit?usp=sharing for Google Sheets users. (Tomayac https://www.wikidata.org/wiki/User:Tomayac) - A guide to SPARQL and the Wikidata Query Service https://www.wikidata.org/wiki/User:TweetsFactsAndQueries/A_Guide_To_WDQS (TweetsFactsAndQueries https://www.wikidata.org/wiki/User:TweetsFactsAndQueries) - Four new types of charts for the Query Service http://query.wikidata.org: line chart, bar chart, scatter chart and area chart! Read more and try examples in the documentation https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/Wikidata_Query_Help/Result_Views (Jonas https://www.wikidata.org/wiki/User:Jonas_Kress_%28WMDE%29) - {{#statements:…}}, a new parser function is currently in development with better features: try it here https://de.wikipedia.beta.wmflabs.org/wiki/Statements! (Thiemo https://www.wikidata.org/wiki/User:Thiemo_M%C3%A4ttig_%28WMDE%29, Wikidata dev team and volunteers) - Search field added in Scholia https://tools.wmflabs.org/scholia/, a tool to create scholarship profiles (fnielsen https://www.wikidata.org/wiki/User:Fnielsen) - Technical documentation about Wikibase for PHP https://doc.wikimedia.org/Wikibase/master/php/annotated.html and JS https://doc.wikimedia.org/Wikibase/master/js/ scripts (Ladsgroup https://www.wikidata.org/wiki/User:Ladsgroup and Jonas https://www.wikidata.org/wiki/User:Jonas_Kress_%28WMDE%29) - new feature for the graph view in the Query Service: it can now browse the properties of items. see in the video https://commons.wikimedia.org/wiki/File:WDQS_-_Graph_Result_View_-_browse.webm (Jonas https://www.wikidata.org/wiki/User:Jonas_Kress_%28WMDE%29) - graph builder tool for the query service to create and export graphs (demo video https://commons.wikimedia.org/wiki/File:WDQS_GUI_graph_builder_demo.webm) (Jonas https://www.wikidata.org/wiki/User:Jonas_Kress_%28WMDE%29, [[d:user:Smalyshev (WMF)|Smalyshev) - d:Module:PropertyPath https://www.wikidata.org/wiki/Module:PropertyPath and d:Template:Show Path Items https://www.wikidata.org/wiki/Template:Show_Path_Items ( TomT0m https://www.wikidata.org/wiki/User:TomT0m) - Everything is connected https://tools.wmflabs.org/everythingisconnected/index.html, a knowledge game based on Wikidata and Commons (list of levels https://www.wikidata.org/wiki/Wikidata:Everything_is_connected) (Denny https://www.wikidata.org/wiki/User:Denny)

Discussions

- New request for comments: Editing descriptions from Wikipedia Android app https://www.wikidata.org/wiki/Wikidata:Requests_for_comment/Editing_descriptions_from_Wikipedia_Android_app

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

- Histropedia: “The power of data visualisation combined with free knowledge” https://blog.wikimedia.org/2016/10/30/histropedia on WMF's blog - Presenting the Wikidata Human Gender Indicators http://grouplens.org/blog/presenting-the-wikidata-human-gender-indicators/ by Max Klein - How the world’s first Wikidata Visiting Scholar created linked open data for five thousand works of art https://blog.wikimedia.org/2016/11/05/wikidata-visiting-scholar-art-dataset/ on WMF's blog

Other Noteworthy Stuff

- Music in Canada at 150 Wikipedia Project https://meta.wikimedia.org/wiki/Grants:Project/Music_in_Canada_@_150:_A_Wikipedia_and_Wikidata_Project, a multifaceted campaign to increase the amount and quality of content about Canadian music in Wikipedia and Wikidata - 400,000,000th https://www.wikidata.org/wiki/Special:Diff/400000000 edit was made. - The average amount of statements per item https://grafana.wikimedia.org/dashboard/db/wikidata-datamodel-statements?panelId=4&fullscreen&from=now-6M&to=now became higher than five and is still growing. - Wikidata entities usage on Wikimedia projects https://www.wikidata.org/wiki/Wikidata:Entity_Usage

Did you know?

- Newest properties https://www.wikidata.org/wiki/Special:ListProperties: DRÚSOP ID https://www.wikidata.org/wiki/Property:P3296, code https://www.wikidata.org/wiki/Property:P3295, encoding https://www.wikidata.org/wiki/Property:P3294, BALaT image ID https://www.wikidata.org/wiki/Property:P3293, DocCheck Flexikon De ID https://www.wikidata.org/wiki/Property:P3292, DocCheck Flexikon En ID https://www.wikidata.org/wiki/Property:P3291, biography at the Landtag of Mecklenburg-Vorpommern https://www.wikidata.org/wiki/Property:P3290, Cellosaurus ID https://www.wikidata.org/wiki/Property:P3289, World Spider Catalog ID https://www.wikidata.org/wiki/Property:P3288, Squash Info ID https://www.wikidata.org/wiki/Property:P3286, MSC ID https://www.wikidata.org/wiki/Property:P3285, Yahoo! Japan Talent Database ID https://www.wikidata.org/wiki/Property:P3284, Bandcamp artist ID https://www.wikidata.org/wiki/Property:P3283, French National Assembly Lobbyist ID https://www.wikidata.org/wiki/Property:P3281, BanQ author ID https://www.wikidata.org/wiki/Property:P3280, statistical leader https://www.wikidata.org/wiki/Property:P3279, Sandbox-Monolingual text II https://www.wikidata.org/wiki/Property:P3278 - Query examples: - Continents on Wikidata (All eleven of them) https://query.wikidata.org/#%23defaultView%3AImageGrid%0ASELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fmap%20WHERE%20%7B%0A%20%20%7B%20%3Fitem%20wdt%3AP31%20wd%3AQ5107%20.%20%7D%20UNION%20%7B%20%3Fitem%20wdt%3AP31%20wd%3AQ55833%20.%7D%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fitem%20wdt%3AP31%20wd%3AQ2284298%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP242%20%3Fmap%20.%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%7D%0A%7D%20ORDER%20BY%20%3FitemLabel (source https://twitter.com/PoulpyWP/status/795380477347659776) - Sluices on the river "Vilaine" in Brittany https://query.wikidata.org/#%23defaultView%3AMap%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Felev%20%3Fcoord%0AWHERE%0A%7B%0A%09%3Fitem%20wdt%3AP31%20wd%3AQ105731%20%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP706%20wd%3AQ842462%20%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP2044%20%3Felev%20%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP625%20%3Fcoord%20.%0A%09SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22fr%22%20%7D%0A%7D (source https://twitter.com/EdouardHue/status/795261887265046529) - Countries with most cities named after saints https://query.wikidata.org/#%23%20countries%20with%20most%20cities%20named%20after%20saints%0ASELECT%20%3Fcountry%20%3FcountryLabel%20%28COUNT%28DISTINCT%20%3Fcity%29%20AS%20%3Fcount%29%20WHERE%20%7B%0A%20%20%3Fcity%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ486972%3B%0A%20%20%20%20%20%20%20%20wdt%3AP17%20%3Fcountry%3B%0A%20%20%20%20%20%20%20%20wdt%3AP138%20%5B%20wdt%3AP411%20wd%3AQ43115%20%5D.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Fcountry%20%3FcountryLabel%0AORDER%20BY%20DESC%28%3Fcount%29 (source https://twitter.com/WikidataFacts/status/794172866644373505) - Disney characters who share name with their actors https://query.wikidata.org/#SELECT%20DISTINCT%20%3FfilmLabel%20%3Ffilm%20%3FactorLabel%20%3FcharacterLabel%0AWHERE%20%0A%7B%0A%20%20%23%20Remove%20next%20line%20to%20refer%20all%20works%2C%20not%20only%20Disney%20works%0A%20%20%7B%20%3Ffilm%20wdt%3AP449%7Cwdt%3AP272%20%5B%20%28wdt%3AP127%2Fwdt%3AP749%2a%29%20wd%3AQ7414%20%5D%20.%20%7D%20UNION%20%7B%20%3Ffilm%20wdt%3AP449%20wd%3AQ7414%20.%20%7D%0A%20%20%3Ffilm%20p%3AP161%7Cp%3AP725%20%5Bps%3AP161%7Cps%3AP725%20%3Factor%20%3B%20pq%3AP453%20%3Fcharacter%20%5D%20.%0A%20%20%3Factor%20wdt%3AP735%20%3Fname%20.%0A%20%20%3Fcharacter%20wdt%3AP735%20%3Fname%20.%0A%20%20FILTER%20%28%3Factor%20%21%3D%20%3Fcharacter%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%0A%7D%20 (source https://twitter.com/WDisneyTrivia/status/793152178068287488) - 204 items that cite themselves https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP2860%20%3Fitem.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D (source https://twitter.com/WikidataFacts/status/795267729624338432) - Statements with two references where one source cites the other https://query.wikidata.org/#%23%20statements%20with%20two%20references%20where%20one%20source%20cites%20the%20other%0ASELECT%20%3Fsubject%20%3FsubjectLabel%20%3FpropertyLabel%20%3FobjectLabel%20%3Fsource1Label%20%3Fsource2Label%0AWITH%20%7B%20%23%20subquery%20that%20actually%20finds%20the%20statements%20and%20sources%20%28written%20as%20named%20subquery%20to%20ensure%20it%E2%80%99s%20only%20run%20once%2C%20independently%20of%20the%20rest%20of%20the%20query%3B%20see%20https%3A%2F%2Fwiki.blazegraph.com%2Fwiki%2Findex.php%2FNamedSubquery%29%0A%20%20SELECT%20%3Fstatement%20%3Fsource1%20%3Fsource2%20WHERE%20%7B%0A%20%20%20%20%3Fstatement%20prov%3AwasDerivedFrom%2Fpr%3AP248%20%3Fsource1%2C%20%3Fsource2.%20%23%20statement%20has%20two%20%E2%80%9Cstated%20in%E2%80%9D%20references%0A%20%20%20%20%3Fsource1%20wdt%3AP2860%20%3Fsource2.%20%23%20first%20source%20cites%20the%20second%20one%0A%20%20%20%20FILTER%28%3Fsource1%20%21%3D%20%3Fsource2%29.%20%23%20apparently%20some%20items%20cite%20themselves%3F%0A%20%20%7D%0A%7D%20AS%20%25results%20WHERE%20%7B%0A%20%20INCLUDE%20%25results.%0A%20%20%23%20auxiliary%20query%20to%20find%20the%20subject%2C%20property%20and%20object%20of%20the%20statement%2C%20as%20well%20as%20labels%0A%20%20%3Fsubject%20%3Fp%20%3Fstatement.%0A%20%20%3Fstatement%20%3Fps%20%3Fobject.%0A%20%20%3Fproperty%20a%20wikibase%3AProperty%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3Aclaim%20%3Fp%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3AstatementProperty%20%3Fps.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D (source https://twitter.com/WikidataFacts/status/795269047793385473)

Development

- Stable interface policy update https://www.wikidata.org/w/index.php?title=Wikidata%3AStable_Interface_Policy&type=revision&diff=400924854&oldid=382163118 - More work on federation in order to be able to use Wikidata's items and properties to describe media files on Wikimedia Commons in the future ( phabricator:T149580 https://phabricator.wikimedia.org/T149580) - Worked on first version of Lexeme entity type (phabricator:T148139 https://phabricator.wikimedia.org/T148139) - Worked more on linking values in Lua and the property parser function instead of just returning the label (phabricator:T142940 https://phabricator.wikimedia.org/T142940) You can test it here: https://de.wikipedia.beta.wmflabs.org/wiki/Statements - Improved map layer colors in the query service (phabricator:T148022 https://phabricator.wikimedia.org/T148022) - Improved size of map markers in the query service (phabricator:T148496 https://phabricator.wikimedia.org/T148496) - Upcoming: quantity changes https://www.wikidata.org/wiki/Wikidata:Project_chat#Changes_to_quantity_precision_handling - Worked more on automated sitelinks for Wiktionary (phabricator:T987 https://phabricator.wikimedia.org/T987) Test system is coming in the next days.

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/Special:MyLanguage/Wikidata:Showcase_items - Help translate https://www.wikidata.org/wiki/Special:LanguageStats or proofread pages in your own language! - Help merge identical items https://www.wikidata.org/wiki/User:Pasleim/projectmerge across Wikimedia projects. - 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 - proposals needing attention https://www.wikidata.org/wiki/Wikidata:Property_proposal/Attention_needed