[09:20:55] Hi [09:21:08] Is it the good place to ask questions about the sparql endpoint ? [09:22:12] unless it is a really technical question it is probably the best of all wikimedia-chats [09:22:40] I'm trying to get the "Also Known as" column for countries (e.g.: https://www.wikidata.org/wiki/Q757) in all possible lanuages [09:22:43] languages* [09:23:16] but I can't seem to find a way to do that [09:26:45] Hmm.. this gets you one alias: http://tinyurl.com/kf26f8d [09:28:16] Ah, simpler: http://tinyurl.com/m34ujv2 [09:30:16] altLabel ... [09:30:18] ok thanks [09:31:48] so I guess this is all countries and all aliases: http://tinyurl.com/lznhtw3 [09:32:33] thanks !! [09:33:03] would there be a way to get a column with the language of the alias too ? [09:33:19] nvm, it's in the alt text [09:33:21] thanks [09:37:34] Ainali: would it be possible to have the name in english of the country in a colum, for each alias ? [09:39:12] Found how [09:39:22] thanks a lot for the help this is going to be super handy [09:40:34] Is there a reason why I only get 332 results instead of all countries ? [09:40:43] https://query.wikidata.org/#SELECT%20%3Fcountry%20%3FcCode%20%3Falias%0A%20%20%20WHERE%20%7B%0A%20%20%20%20%20%20%3Fcountry%20wdt%3AP31%20wd%3AQ7275%20.%0A%20%20%20%20%20%20%3Fcountry%20wdt%3AP297%20%3FcCode%20.%0A%20%20%20%20%20%20%3Fcountry%20skos%3AaltLabel%20%3Falias%20.%0A%20%20%20%20%7D%0A [10:21:55] Nazral: Yes, not all countries have the language code. This gives you more results: http://tinyurl.com/mae8c58 [10:23:22] also, here is the same query with the english contry name in a column: http://tinyurl.com/kgwmjhh [10:53:56] PROBLEM - puppet last run on wdqs1002 is CRITICAL: CRITICAL: Catalog fetch fail. Either compilation failed or puppetmaster has issues [11:22:56] RECOVERY - puppet last run on wdqs1002 is OK: OK: Puppet is currently enabled, last run 35 seconds ago with 0 failures [12:22:14] hi, I'm trying to setup my vagrant for wikidata, I enabled the role wikidata but Wikibase remote points to github [12:22:55] should I add new remotes to enable gerrit or maybe I did something wrong when enabling the vagrant role? [12:42:11] ah got it, enabled wikibase_repo and remotes are properly set [13:58:03] Ainali: thanks for the help :) [13:58:38] my pleasure, I learned something too [14:28:38] Reminder: IRC office hour at 16:00 UTC on the channel #wikimedia-office :) in 1,5 hours. See you there! [18:26:58] Hello! I have a question about how to express the claim that a person was homeschooled. The current statement in {{Q4396503}} uses {{P1066}}, but that's a constraint violation. Thoughts? [18:26:59] 10[1] 04https://www.wikidata.org/wiki/Template:Q439650313 => [18:27:02] 10[2] 04https://www.wikidata.org/wiki/Template:P1066