On 3/20/15 4:09 PM, Markus Kroetzsch wrote:
Hi Dmitriy,Yes, you are right. There are some countries that have a value for "dissolved or abolished" (P576) but no end date for "instance of" "sovereign state". This includes the "United Kingdom of the Netherlands". Probably these should get an end date for their P31, or we should use P576 in the query.A list of all states that have no end date to their P31 sovereign state but that do have a P576 date:PREFIX : <http://www.wikidata.org/entity/> SELECT ?country ?countryName WHERE { ?country :P576c ?disolutionDate . ?country :P31s ?statement . ?statement :P31v :Q3624078 . FILTER NOT EXISTS { ?statement :P582q ?endDate } ?country rdfs:label ?countryName FILTER(lang(?countryName)="en") }
See:[1] http://milenio.dcc.uchile.cl/sparql?default-graph-uri=&query=%0D%0APREFIX+%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0D%0ASELECT+%3Fcountry+%3FcountryName%0D%0AWHERE+%7B%0D%0A++%3Fcountry+%3AP576c+%3FdisolutionDate+.%0D%0A++%3Fcountry+%3AP31s+%3Fstatement+.%0D%0A++%3Fstatement+%3AP31v+%3AQ3624078+.%0D%0A+++++FILTER+NOT+EXISTS+%7B+%3Fstatement+%3AP582q+%3FendDate+%7D%0D%0A++%3Fcountry+rdfs%3Alabel+%3FcountryName+FILTER%28lang%28%3FcountryName%29%3D%22en%22%29%0D%0A%7D+&format=text%2Fhtml&timeout=0&debug=on
A list of all states that have an end date to their P31 sovereign state but that do not have a P576 date:PREFIX : <http://www.wikidata.org/entity/> SELECT ?country ?countryName WHERE { ?country :P31s ?statement . ?statement :P31v :Q3624078 . ?statement :P582q ?endDate . FILTER NOT EXISTS { ?country :P576c ?disolutionDate } ?country rdfs:label ?countryName FILTER(lang(?countryName)="en") }
See: http://milenio.dcc.uchile.cl/sparql?default-graph-uri=&query=%0D%0APREFIX+%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0D%0ASELECT+%3Fcountry+%3FcountryName%0D%0AWHERE+%7B%0D%0A++%3Fcountry+%3AP31s+%3Fstatement+.%0D%0A++%3Fstatement+%3AP31v+%3AQ3624078+.%0D%0A++%3Fstatement+%3AP582q+%3FendDate+.%0D%0A+++++FILTER+NOT+EXISTS+%7B+%3Fcountry+%3AP576c+%3FdisolutionDate+%7D%0D%0A++%3Fcountry+rdfs%3Alabel+%3FcountryName+FILTER%28lang%28%3FcountryName%29%3D%22en%22%29%0D%0A%7D+&format=text%2Fhtml&timeout=0&debug=on -- Regards, Kingsley Idehen Founder & CEO OpenLink Software Company Web: http://www.openlinksw.com Personal Weblog 1: http://kidehen.blogspot.com Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen Twitter Profile: https://twitter.com/kidehen Google+ Profile: https://plus.google.com/+KingsleyIdehen/about LinkedIn Profile: http://www.linkedin.com/in/kidehen Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
