User:Arybolab/Dutch Municipalities

SELECT ?population ?date ?municipalityLabel ?municipality ?inception ?dissolved ?cbscode ?amsterdamse_code ?located_in_the_administrative_territorial_entityLabel ?located_in_the_administrative_territorial_entity ?start_time ?end_time WHERE {

SERVICE wikibase:label { bd:serviceParam wikibase:language "nl,en". }
 ?municipality wdt:P31 wd:Q2039348.
 
 OPTIONAL { ?municipality wdt:P571 ?inception. }
OPTIONAL { ?municipality  p:P1082 ?popStatement .
 ?popStatement ps:P1082 ?population;
               pq:P585 ?date . }
OPTIONAL { ?municipality wdt:P576 ?dissolved. }
OPTIONAL { ?municipality wdt:P382 ?cbscode. }
OPTIONAL { ?municipality wdt:P6434 ?amsterdamse_code. }
OPTIONAL { ?municipality wdt:P131 ?located_in_the_administrative_territorial_entity. }  
OPTIONAL { ?municipality wdt:P580 ?start_time. }
OPTIONAL { ?municipality wdt:P582 ?end_time. }

}