This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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")) | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 }) . | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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")) | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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