query-d99e968494d273f56bb420465d285ad6

rq turtle/ttl

Propertieslocated in the administrative territorial entity (P131)instance of (P31)population (P1082)point in time (P585)

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT ?municipality WHERE {

 ?municipality wdt:P131+ wd:Q980;
               wdt:P31 wd:Q262166;
               p:P1082 ?populationStatement.
 ?populationStatement pq:P585 ?pointInTime1, ?pointInTime2.
 FILTER(?pointInTime1 != ?pointInTime2)
}

Query found at

https://www.wikidata.org/wiki/User:Looniverse/SPARQL

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?municipality"):::projected v1("?pointInTime1") v2("?pointInTime2") v4("?populationStatement") c4(["wd:Q262166"]):::iri c2(["wd:Q980"]):::iri f0[["?pointInTime1 != ?pointInTime2"]] f0 --> v1 f0 --> v2 v3 --"p:direct/P131"--> c2 v3 --"p:direct/P31"--> c4 v3 --"p:P1082"--> v4 v4 --"p:qualifier/P585"--> v1 v4 --"p:qualifier/P585"--> v2