Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
# RDF Query Template
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/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 .
[add variable uri here, see examples and mappings]
?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
# Number of Inhabited Houses per municipality across the years
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/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 cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-BewoondeHuizen> .
?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
# Number of Uninhabited Houses per municipality across the years
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/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 cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-OnbewoondeHuizen> .
?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
# Number of Houses under Construction per municipality across the years
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/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 cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-HuizenAanbouw> .
?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
# Number of Inhabbited Houseboats
# INFERENCE ALERT: BewoondeSchepen ALONE means BewoondeSchepen+AltijdAanwezig. In 1899 we might have BewoondeSchepen+TijdelijkAanwezig and BewoondeSchepen+AltijdAanwezig, so we have to filter
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/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 cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-BewoondeSchepen> .
FILTER NOT EXISTS { ?obs cedar:residenceStatus <http://lod.cedar-project.nl/vocab/cedar-residenceStatus#TijdelijkAanwezig> . }
?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
# Number of Temporary Present Houseboats
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/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 cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-BewoondeSchepen> .
?obs cedar:residenceStatus <http://lod.cedar-project.nl/vocab/cedar-residenceStatus#TijdelijkAanwezig> .
?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)) .
FILTER (NOT EXISTS {?obs sdmx-dimension:sex ?sex }) .
} GROUP BY ?municipality ?year ORDER BY ?municipality
# Number of Inhabbited Wagons
# INFERENCE ALERT: BewoondeSchepen ALONE means BewoondeSchepen+AltijdAanwezig. In 1899 we might have BewoondeSchepen+TijdelijkAanwezig and BewoondeSchepen+AltijdAanwezig, so we have to filter
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/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 cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-BewoondeWagens> .
FILTER NOT EXISTS { ?obs cedar:residenceStatus <http://bit.ly/cedar-residenceStatus#TijdelijkAanwezig> . }
?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
# Number of Temporary Present Wagons
# Query contains a restriction for 1879
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/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 cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-BewoondeWagens> .
?obs cedar:residenceStatus <http://lod.cedar-project.nl/vocab/cedar-residenceStatus#TijdelijkAanwezig> .
?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)) .
FILTER (NOT EXISTS {?obs sdmx-dimension:sex ?sex }) .
} GROUP BY ?municipality ?year ORDER BY ?municipality
# Bewoonde Huizen per municipality in Friesland 1879
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
SELECT ?municipality (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 cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-BewoondeHuizen> .
?slice a qb:Slice.
?slice qb:observation ?obs.
?slice sdmx-dimension:refPeriod 1879 .
FILTER (NOT EXISTS {?obs cedar:isTotal ?total }) .
FILTER (regex(?obs, "VT_1879_01_H1-S0", "i"))
} GROUP BY ?municipality
# Total number of Bewoonde Schepen in a certain municipality (Achtkarspelen) in 1879 Friesland
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
SELECT (SUM(?pop) AS ?tot)
FROM <urn:graph:cedar-mini:release>
WHERE { ?obs a qb:Observation .
?obs cedar:population ?pop .
?obs sdmx-dimension:refArea <http://www.gemeentegeschiedenis.nl/amco/10199> .
?obs cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-BewoondeSchepen> .
?slice a qb:Slice.
?slice qb:observation ?obs.
?slice sdmx-dimension:refPeriod 1879 .
FILTER (NOT EXISTS {?obs cedar:residenceStatus ?residenceStatus }) .
FILTER (NOT EXISTS {?obs cedar:isTotal ?total }) .
FILTER (regex(?obs, "VT_1879_01_H1-S0", "i"))
}
# Bewoonde Schepen per municipality in Friesland 1879
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
SELECT ?municipality (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 cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-BewoondeSchepen> .
?slice a qb:Slice.
?slice qb:observation ?obs.
?slice sdmx-dimension:refPeriod 1879 .
FILTER (NOT EXISTS {?obs cedar:residenceStatus ?residenceStatus }) .
FILTER (NOT EXISTS {?obs cedar:isTotal ?total }) .
FILTER (regex(?obs, "VT_1879_01_H1-S0", "i"))
} GROUP BY ?municipality
# Number of Inhabited Houses per municipality across the years
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/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 cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-BewoondeHuizen> .
?obs cedar:Kom <http://lod.cedar-project.nl/vocab/cedar-Kom#BinnenKom> .
?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
# Total number of Bewoonde Schepen in a certain municipality (Achtkarspelen) in 1879 Friesland
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
SELECT *
FROM <urn:graph:cedar-mini:release>
WHERE { ?obs a qb:Observation .
?obs cedar:population ?pop .
?obs sdmx-dimension:refArea <http://www.gemeentegeschiedenis.nl/amco/10199> .
?obs cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-BewoondeSchepen> .
?obs cedar:Kom <http://lod.cedar-project.nl/vocab/cedar-Kom#BuitenKom> .
?slice a qb:Slice.
?slice qb:observation ?obs.
?slice sdmx-dimension:refPeriod 1889 .
FILTER (NOT EXISTS {?obs cedar:residenceStatus ?residenceStatus }) .
FILTER (NOT EXISTS {?obs cedar:isTotal ?total }) .
}
# Feitelijk (actual) Aanwezige Bevolking per municipality in Friesland 1879
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
SELECT ?municipality (SUM(?pop) AS ?tot)
FROM <urn:graph:cedar-mini:release>
WHERE { ?obs a qb:Observation .
?obs cedar:population ?pop .
?obs sdmx-dimension:sex sdmx-code:sex-M .
?obs sdmx-dimension:refArea ?municipality .
?obs cedar:residenceStatus <http://lod.cedar-project.nl/vocab/cedar-residenceStatus#FeitelijkeAanwezig> .
?slice a qb:Slice.
?slice qb:observation ?obs.
?slice sdmx-dimension:refPeriod 1879 .
FILTER (NOT EXISTS {?obs cedar:isTotal ?total }) .
FILTER (regex(?obs, "VT_1879_01_H1-S0", "i"))
} GROUP BY ?municipality
# Huizen in Aanbouw per municipality in Friesland 1879
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
SELECT ?municipality (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 cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-HuizenAanbouw> .
?slice a qb:Slice.
?slice qb:observation ?obs.
?slice sdmx-dimension:refPeriod 1879 .
FILTER (NOT EXISTS {?obs cedar:isTotal ?total }) .
FILTER (regex(?obs, "VT_1879_01_H1-S0", "i"))
} GROUP BY ?municipality
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/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 cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-BewoondeHuizen> .
?obs cedar:Kom <http://lod.cedar-project.nl/vocab/cedar-Kom#BuitenKom> .
?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
# Number of Bewoonde Huizen per municipality across the years
# INFERENCE ALERT: BewoondeSchepen ALONE means BewoondeSchepen+AltijdAanwezig. In 1899 we might have BewoondeSchepen+TijdelijkAanwezig and BewoondeSchepen+AltijdAanwezig, so we have to filter
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/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 cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-BewoondeSchepen> .
FILTER NOT EXISTS { ?obs cedar:residenceStatus <http://bit.ly/cedar-residenceStatus#TijdelijkAanwezig> . }
?slice a qb:Slice.
?slice qb:observation ?obs.
?slice sdmx-dimension:refPeriod ?year .
FILTER (NOT EXISTS {?obs cedar:isTotal ?total }) .
FILTER (?year IN (1869, 1879, 1889, 1899, 1909, 1920)) .
} GROUP BY ?municipality ?year ORDER BY ?municipality
# Onbewoonde Huizen per municipality in Friesland 1879
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
SELECT ?municipality (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 cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-OnbewoondeHuizen> .
?slice a qb:Slice.
?slice qb:observation ?obs.
?slice sdmx-dimension:refPeriod 1879 .
FILTER (NOT EXISTS {?obs cedar:isTotal ?total }) .
FILTER (regex(?obs, "VT_1879_01_H1-S0", "i"))
} GROUP BY ?municipality
# Bewoonde Schepen per municipality in Friesland 1899
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
SELECT ?municipality (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 cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-BewoondeSchepen> .
?obs cedar:residenceStatus <http://lod.cedar-project.nl/vocab/cedar-residenceStatus#TijdelijkAanwezig> .
?slice a qb:Slice.
?slice qb:observation ?obs.
?slice sdmx-dimension:refPeriod 1899 .
FILTER (NOT EXISTS {?obs cedar:isTotal ?total }) .
FILTER (regex(?obs, "VT_1899_07_H1-S0", "i"))
} GROUP BY ?municipality
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
PREFIX oa: <http://www.w3.org/ns/openannotation/core/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX tablink: <http://lod.cedar-project.nl/vocab/cedar-tablink#>
PREFIX dcterms: <http://purl.org/dc/terms/>
SELECT *
FROM <urn:graph:cedar-mini:raw-data>
WHERE {
?cell a ?celltype .
?cell rdfs:label ?label .
?cell tablink:sheet ?sheet.
FILTER (regex(?label, "Totaal[.]", "i"))
}
# Number of Inhabited Houses per municipality across the years
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/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 <http://lod.cedar-project.nl/vocab/cedar-residenceStatus#TijdelijkAanwezig> .
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
# Tijdelijk Afwezige Bevolking per municipality in Friesland 1879
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
SELECT ?municipality (SUM(?pop) AS ?tot)
FROM <urn:graph:cedar-mini:release>
WHERE { ?obs a qb:Observation .
?obs cedar:population ?pop .
?obs sdmx-dimension:sex sdmx-code:sex-M .
?obs sdmx-dimension:refArea ?municipality .
?obs cedar:residenceStatus <http://lod.cedar-project.nl/vocab/cedar-residenceStatus#TijdelijkAfwezig> .
?slice a qb:Slice.
?slice qb:observation ?obs.
?slice sdmx-dimension:refPeriod 1879 .
FILTER (NOT EXISTS {?obs cedar:isTotal ?total }) .
FILTER (regex(?obs, "VT_1879_01_H1-S0", "i"))
} GROUP BY ?municipality
# Tijdelijk Aanwezige Bevolking per municipality in Friesland 1879
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
SELECT ?municipality (SUM(?pop) AS ?tot)
FROM <urn:graph:cedar-mini:release>
WHERE { ?obs a qb:Observation .
?obs cedar:population ?pop .
?obs sdmx-dimension:sex sdmx-code:sex-M .
?obs sdmx-dimension:refArea ?municipality .
?obs cedar:residenceStatus <http://lod.cedar-project.nl/vocab/cedar-residenceStatus#TijdelijkAanwezig> .
?slice a qb:Slice.
?slice qb:observation ?obs.
?slice sdmx-dimension:refPeriod 1879 .
FILTER (NOT EXISTS {?obs cedar:isTotal ?total }) .
FILTER (regex(?obs, "VT_1879_01_H1-S0", "i"))
} GROUP BY ?municipality
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
SELECT ?municipality ?year ?houseType (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 cedar:houseType ?houseType .
?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 ?houseType ORDER BY ?municipality
# Number of Inhabited Houses per municipality across the years
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/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:sex ?sex .
?obs sdmx-dimension:refArea ?municipality .
?obs cedar:residenceStatus <http://lod.cedar-project.nl/vocab/cedar-residenceStatus#TijdelijkAfwezig> .
?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)) .
FILTER (?sex IN (sdmx-code:sex-M, sdmx-code:sex-F)) .
} GROUP BY ?municipality ?year ORDER BY ?municipality
# Bewoonde Wagens per municipality in Friesland 1899
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
SELECT ?municipality (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 cedar:houseType <http://lod.cedar-project.nl/vocab/cedar#house-BewoondeWagens> .
?obs cedar:residenceStatus <http://lod.cedar-project.nl/vocab/cedar-residenceStatus#TijdelijkAanwezig> .
?slice a qb:Slice.
?slice qb:observation ?obs.
?slice sdmx-dimension:refPeriod 1899 .
FILTER (NOT EXISTS {?obs cedar:isTotal ?total }) .
FILTER (regex(?obs, "VT_1899_07_H1-S0", "i"))
} GROUP BY ?municipality
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX cedar: <http://lod.cedar-project.nl/vocab/cedar#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
SELECT ?municipality (SUM(?pop) AS ?tot)
FROM <urn:graph:cedar-mini:release>
WHERE { ?obs a qb:Observation .
?obs cedar:population ?pop .
?obs sdmx-dimension:sex sdmx-code:sex-M .
?obs sdmx-dimension:refArea ?municipality .
?obs cedar:residenceStatus <http://lod.cedar-project.nl/vocab/cedar-residenceStatus#WerkelijkTotaal> .
?slice a qb:Slice.
?slice qb:observation ?obs.
?slice sdmx-dimension:refPeriod 1879 .
FILTER (NOT EXISTS {?obs cedar:isTotal ?total }) .
FILTER (regex(?obs, "VT_1879_01_H1-S0", "i"))
} GROUP BY ?municipality
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment