[00:34:45] PROBLEM - wikidata.org dispatch lag is higher than 300s on www.wikidata.org is CRITICAL: HTTP CRITICAL: HTTP/1.1 200 OK - pattern not found - 1954 bytes in 0.121 second response time [01:04:58] RECOVERY - wikidata.org dispatch lag is higher than 300s on www.wikidata.org is OK: HTTP OK: HTTP/1.1 200 OK - 1925 bytes in 0.122 second response time [09:12:44] I cannot figure out how to filter a SPARKQL query which also can look into qualifiers for any statements. Can anyone help [09:48:06] Lucas_WMDE: I just saw your given name tweets... did you look at country distribution at all? I think that would probably show some differences [09:48:15] nikki: no, that could be interesting [09:48:29] like mika is female in japan and iirc male in finland [09:48:36] and I only know kim as a female name [09:48:58] perhaps I can search for greatest discrepancy in that percentage between two countries [09:49:24] same for dominique, andrea (although I've heard that's a male italian name?), jess, jocelyn, aubrey... [09:49:57] oh, Andrea reminds me [09:50:32] there are plenty of men with male first given name and then some names that would usually be female in Germany [09:50:36] like Christoph Maria Herbst [09:51:01] as far as I know it’s more of a south-german thing, perhaps in Austria and Switzerland too [09:51:27] but the rank should take care of that, right? or what’s our policy on given name ranks? [09:53:04] I'm not sure how we handle multiple names, possibly with "series ordinal" (since ranks won't help if there are more than two parts) [09:53:29] yeah, but I thought the “main” name (usually the first) could have preferred rank [09:56:50] also I think we normally split names based on gender (i.e. that example would have a new item for christoph), I'm still half asleep but it doesn't look like the query takes that into account [09:58:35] some marked as unisex... hm [10:00:54] seems there are some pairs of items too though - http://tinyurl.com/y7bw8btd [10:01:35] although I didn't filter out ones where both items are the same [10:17:43] nikki: 6781 direct instances of “given name”, 492 direct instances of “unisex given name”, 175 cases with separate items for male and female given name, 43 cases with one item instance of both http://tinyurl.com/y9onwlnb (full list: http://tinyurl.com/yd7oj8zm ) [10:42:15] Tpt[m]: thanks a lot for your help the other day - now I can unleash the power of Wikidata-Toolkit :-) [10:42:24] bye bye quickstatements! https://www.wikidata.org/w/index.php?title=Q4041&diff=prev&oldid=559383361 [10:45:00] maybe you could even add the retrieved date :P [10:45:51] nikki: yeah, I'm working on that :) [10:45:51] how easy is it to do edits like that? I've wondered how to add more complex references and haven't really found a solution [10:46:17] it's going to be super easy with the next version of OpenRefine [10:46:19] #teaser [11:23:03] pintosh: great! Congrats [11:23:58] You could add a nice revision comments generator ;-) [11:26:17] Tpt[m]: yeah I have to figure out how to get that right [11:27:02] that's the issue with big single edits, they are not as transparent as incremental changes [11:27:04] You could the same special comments as Wikibase when it's possible [11:27:35] It would be a great feature to add to the Toolkit [11:27:55] yeah that's true, it should go in the toolkit rather than openrefine actually [11:29:02] You are more than welcome to do pull requests ;-) [11:30:35] it's not clear to me how it should work - for that sort of edit, in general, you add N new statements, update M existing statements, and delete P others… [12:03:11] yes, you could maybe say "add XX {{P|31}} statements and remove YY {{P|10}} statements" [12:03:15] 10[4] 1010https://www.wikidata.org/wiki/Template:Property - Redirección desde 10https://www.wikidata.org/wiki/Template:P?redirect=no [13:22:10] hello world! can i ask here for guidance for a SPARQL query on wikidata? [13:22:26] I mostly bother Lucas_WMDE :P [13:22:43] yes, hello, SPARQL? [13:22:44] :D [13:23:00] haha [13:23:39] im going to do a introduction to wikidata to fellow wikipemians on my city and im tryng to figure out some cool "localized" examples [13:23:46] *wikimedians [13:24:08] oh, cool! [13:25:54] one that poped on my mind was answering the question "what is the P19 with most presidents come from" [13:29:18] im tryng to figure out how to use the (COUNT thingy, but keep getting "Bad aggregate" error. That means i'm messing up my query, right? [13:30:41] can you post the query? [13:32:40] lahi: wild guess – if you have SELECT ?place ?placeLabel (COUNT(*) AS ?count) … GROUP BY ?place, you need to GROUP BY ?placeLabel as well (i. e. GROUP BY ?place ?placeLabel) [14:00:38] @Lucas_WMDE sorry the delay, i'm @ work. The query: https://pastebin.com/Tkf3sH2Z [14:02:06] lahi: http://tinyurl.com/y7qozopj [14:03:16] you need to specify all the variable which you’re not counting (the ones that appear in the result directly) in the GROUP BY [14:04:15] Lucas_WMDE: oh! many thanks! [14:04:22] no problem :) [19:53:54] is "serial number" better as a separate statement or as a qualifier for a "manufacturer" statement? [20:15:34] hawke: if that serial number is specific to manufacturer, better as qualifier. that's usually the case. But if somehow it is a global serial number - e.g. there's a global registry etc. then as statement, maybe as external id property if the registry is accessible online [20:16:40] That's what I was thinking, and that's how I've been using it. Thanks. [20:30:42] why can't I restore https://www.wikidata.org/w/index.php?title=Q9177152&oldid=474873054 ? [20:31:03] It says "Недопустимые данные" [20:35:56] infovarius: https://www.wikidata.org/wiki/Wikidata:Project_chat#Can.E2.80.99t_undo_a_redirect_creation_.E2.80.94_anyone_able_to_help.3F / https://phabricator.wikimedia.org/T175887 ? [20:36:34] I suspected about redirect but I removed #REDIRECT word and still I can't [20:36:47] rollback works, apparently [20:41:12] can you please do mentioned revert (you can refer to my will in the summary)? [20:45:06] Must have been a giant. https://www.wikidata.org/w/index.php?title=Q5822614&type=revision&diff=559694819&oldid=543981049 [20:53:25] infovarius: I’m not sure why they’re different, sorry… what’s the difference between nuclear bomb / explosive / weapon? [20:53:57] (also, afaik there’s no way to specify an edit summary for rollback) [20:58:29] infovarius: sorry, going offline now… I can check on the item tomorrow [20:58:57] or feel free to leave a message on my talk page (preferably User:TweetsFactsAndQueries, I don’t want to do the rollback from a WMDE account) [20:59:53] ah, rollback, not revert!