query-dc680f2bdec38cd84d69ef173f0fc1f8

rq turtle/ttl

Countries of Europe (1900 to present)I wonder what would be a good way to query them. Based on the query, we can try to fix items that don't quite match it. 08:58, 11 January 2022 (UTC) JuraI used 1900 as starting point as it obviously gets harder further one goes back. --- 10:18, 11 January 2022 (UTC)) talk (Infrastruktur. Any former country without these two properties should be treated like an error. Likewise any current country without a replaces claim is an error. --(Q33946)Czechoslovakia I won't bore you with anything obvious, but if this is meant for maintenance, you might be interested in following the replaces/replaced-by chains as they appear to be broken in several places such as Maybe this as a start?

Use at

• https://query.wikidata.org/sparql

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel WHERE {
  ?item p:P31/wdt:P279* ?st ;
        wdt:P30 wd:Q46 .

  ?st ps:P31/wdt:P279* wd:Q6256 .

  OPTIONAL { ?item wdt:P576 ?dissolvedDate }
  FILTER ( !BOUND(?dissolvedDate)|| ?dissolvedDate > "1900-01-01"^^xsd:date )

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?itemLabel

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2022/01