[11:03:55] is there a way to turn off this annoying thing that keeps popping up when I'm trying to type in the box on query.wikidata.org? [11:04:30] it didn't used to do that [15:20:05] So quiet this channel is [15:20:33] As predicted the bot migration practically killed it, I guess I should remove it from autojoin [18:40:18] hello! [18:40:32] I'm trying to modify a wdqs sparql query [18:40:57] specifically, modify the 'list of female mayors' query so it includes the actual population in the output [18:44:40] YuviPanda: you should add ?population in the first line "SELECT ..." [18:46:04] nvm figured it [18:46:41] Pyb: yup, it works, my client library had a bug [18:56:22] hi [18:56:49] is it possible to know how many statements are used on a specific Wikipedia [18:57:03] and on how many distinct articles ? [19:35:10] Why "Statements" is in English https://www.wikidata.org/wiki/Q21977752?uselang=fi when it should be in Finnish? Been so over a month already (after the message was renamed on twn: https://translatewiki.net/w/i.php?title=MediaWiki:Wikibase-statementsection-statements/fi&action=history). Other languages seems to be ok.. [20:44:27] Just started playing around with the SPARQL endpoint to do some querying on species in wikidata. When trying to see which species have a taxon identifier I noticed something see url ( https://query.wikidata.org/#PREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0APREFIX%20wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0ASELECT%20DISTINCT%20*%0AWHERE%20%7B%20%0A%20%20%3Fspecies%20wdt%3AP685%20%3F [20:44:45] Ok the url is too long just gimme a sec. [20:45:18] http://alturl.com/k6w4y [20:45:58] As can be seen is that some entries such as goat/Goat/goat appears more then once. [20:46:24] Now I am curious what the standard should be and if this should be fixed or noted somewhere... [20:49:33] jjkoehorst: you didn't use "select" [20:49:47] so you will have several times the same result [20:50:03] if they have several reason to pop up in the query [20:50:51] but I do an distinct [20:51:04] and if you do SELECT DISTINCT ?species ?label ?taxon it yields the same results as far as I can see [20:51:46] now these differences occurs mostly due to capitalisation but I was curious if there is a standard for this in wikidata, capitalise or lowercase all or.... [20:55:13] jjkoehorst: we lowercase things unless they're normally written with a capital letter, it's described on https://www.wikidata.org/wiki/Help:Label [20:56:56] I think it might be returning each of the english variants as labels too, e.g. lion has "lion" for en, "lion" for en-gb and "Lion" for en-ca [20:58:09] using filter (lang(?label) = "en") will return en (but not en-gb or en-ca) if you're not bothered about variants [20:59:46] Just wanted to say that yes I did a simple BIND(lang(?label) AS ?langg) and got more hits due to that: en , en-ca , en-gb [21:00:55] Just out of curiosity is there a delay between editing in wikidata and availability in the sparql end point? [21:01:42] in my experience it usually updates immediately, but occasionally misses changes entirely [21:03:01] well its still in beta so... Ill probably come back in an hour or 10 (tomorrow). Currently also downloading the latest RDF build and ill perform a structure recovery on it using RDF2Graph we recently published to explore the network.