Live Wikidata Querying – 2020-03-15
Channel: Lucas Werkmeister
Date: 2020-03-15

LOUD AUDIO WARNING at 7:30 (my microphone is bad sorry)

Recording of a livestream on 15 March 2020, where I worked on Wikidata queries together with community members, who were providing suggestions via Twitch chat.

Timestamps:
1:03 – intro music
3:15 – begin stream proper
4:02 – US federal agencies dissolved under the Trump administration
15:05 – streets visualized by gender of person they’re named after, OpenStreetMap (OSM), Sophox
35:13 – rail networks visualized by stops from central station, coloring results, color gradients
54:06 – fixing broken queries: well-known musicians without sewiki article, GROUP BY + SAMPLE
59:42 – tricks to avoid timeouts, query optimization
1:03:23 – number formatting, thousands separator, Listeria / Wikidata list + custom row template
1:21:37 – updates on maxlag problem
1:22:03 – using pageviews in queries, MWAPI, XPath
1:42:28 – going through query examples
1:43:36 – interaction of “no value” with truthy statements
1:46:01 – URLs of Wikipedia in all languages
1:55:42 – population query, optimization strategies
2:14:53 – closing

More information about…
• Wikidata: https://www.wikidata.org/wiki/Special:MyLanguage/Wikidata:Wikidata
• Wikidata Query Service (WDQS): https://www.wikidata.org/wiki/Special:MyLanguage/Wikidata:SPARQL_query_service/Wikidata_Query_Help
• me: https://www.wikidata.org/wiki/User:TweetsFactsAndQueries