TemplateQuery.rq

#+ summary: All variables included
#+ tags: 
#+   - Harmonized Tables 1859-1920

PREFIX cedar: <http://lod.cedar-project.nl:8888/cedar/resource/>
PREFIX maritalstatus: <http://lod.cedar-project.nl/vocab/cedar-maritalstatus#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
PREFIX cedarterms: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX gg: <http://www.gemeentegeschiedenis.nl/amco/>
 
SELECT (SUM(?pop) AS ?tot) FROM <urn:graph:cedar-mini:release> WHERE {
	?obs a qb:Observation.
	?obs sdmx-dimension:refArea ?_location_iri.
	?obs cedar:Kom ?_Kom_iri
	?obs cedarterms:population ?pop.
	?slice a qb:Slice.
	?slice qb:observation ?obs.
	?slice sdmx-dimension:refPeriod ?_year_integer.
	?obs sdmx-dimension:sex ?_sex_iri.
	?obs cedarterms:residenceStatus ?_residenceStatus_iri.
	?obs cedarterms:houseType ?_houseType_iri.
	FILTER (NOT EXISTS {?obs cedarterms:isTotal ?total })
}