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%0APREFI...
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%0APREFI...