PREFIX skos: PREFIX xsd: PREFIX schema: PREFIX rdf: PREFIX rdfs: PREFIX iisgv: PREFIX iisgv2: PREFIX gg: PREFIX geo: PREFIX bio: PREFIX bif: SELECT ?municipality ?mean ?november_1918 ?excess_death_rate WHERE { FILTER(?mean_ >1) # to avoid 'division by 0' error FILTER(?november_1918_ >1) FILTER(?month = "11"^^xsd:integer) { select ?amco ?municipality ?month (sum(if(?year = "1918"^^, 1, 0)) as ?november_1918_) (sum(if(?year = "1910"^^, 1, 0)) as ?1910) (sum(if(?year = "1911"^^, 1, 0)) as ?1911) (sum(if(?year = "1912"^^, 1, 0)) as ?1912) (sum(if(?year = "1913"^^, 1, 0)) as ?1913) (sum(if(?year = "1914"^^, 1, 0)) as ?1914) (sum(if(?year = "1915"^^, 1, 0)) as ?1915) (sum(if(?year = "1916"^^, 1, 0)) as ?1916) (sum(if(?year = "1917"^^, 1, 0)) as ?1917) { ?death a bio:Death . ?death iisgv:deceased ?deceased . ?death bio:date ?date . ?death iisgv:event_location ?gemeente . ?gemeente gg:amsterdamCode ?amco . ?amco gg:identifies ?gg_gemeente . ?gg_gemeente gg:name ?municipality . FILTER NOT EXISTS { ?gg_gemeente gg:startDate ?startdate FILTER(?startdate >= "1920-01-01"^^) } FILTER NOT EXISTS { ?gg_gemeente gg:endDate ?enddate FILTER(?enddate <= "1920-01-01"^^) } BIND(year(xsd:dateTime(?date)) as ?year) BIND(month(xsd:dateTime(?date)) as ?month) } GROUP BY ?amco ?municipality ?month } BIND(xsd:float(?1910+?1911+?1912+?1913+?1914+?1915+?1916+?1917)/8 as ?mean_) BIND(xsd:float(?november_1918_/?mean_) as ?excess_death_rate_) bind(str(?mean_) as ?mean) bind(str(?november_1918_) as ?november_1918) bind(round(?excess_death_rate_) as ?excess_death_rate_1) bind(str(?excess_death_rate_1) as ?excess_death_rate) } ORDER BY DESC (?excess_death_rate_)

Excess mortality in November 1918 per municipality

API

Variables