Skip to content
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Go to file
Cannot retrieve contributors at this time
#+ summary: Feitelijk Aanwezige Mannen Totaal
#+ tags:
#+ - Harmonized Tables 1859-1920
PREFIX qb: <>
PREFIX cedar: <>
PREFIX sdmx-dimension: <>
PREFIX sdmx-code: <>
SELECT ?municipality ?year (SUM(?pop) AS ?tot)
FROM <urn:graph:cedar-mini:release>
WHERE { ?obs a qb:Observation .
?obs cedar:population ?pop .
?obs sdmx-dimension:refArea ?municipality .
?obs sdmx-dimension:sex sdmx-code:sex-M .
?obs cedar:residenceStatus <> .
FILTER (NOT EXISTS {?obs cedar:houseType ?house })
?slice a qb:Slice.
?slice qb:observation ?obs.
?slice sdmx-dimension:refPeriod ?year .
FILTER (NOT EXISTS {?obs cedar:isTotal ?total }) .
FILTER (?year IN (1859, 1869, 1879, 1889, 1899, 1909, 1920)) .
} GROUP BY ?municipality ?year ORDER BY ?municipality