Retrieve the population and total (accumulated) number of cases for second-order administrative divisions

lock_open

By nikolay.vl.nikolov@gmail.com

Last modification about 1 month ago -  2022-11-04 11:53:12 UTC
Description

Retrieves the population and total (accumulated) number of cases for second-order administrative divisions


Query text


SPARQL Endpoint

PREFIX base: <http://covid19spread.sintef.cloud#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX owl-time: <http://www.w3.org/2006/time#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX sw: <http://sws.geonames.org/>

SELECT distinct ?continent ?country ?municipality ?date ?totalNumberOfCases ?population WHERE {
?measurement rdf:type base:ADM2Measurement ;
owl-time:hasTime ?date ;
base:totalNumberOfCases ?totalNumberOfCases ;
base:inAdm2 ?adm2 ;
base:inCountry ?countryNode ;
base:inContinent ?continentNode .
?adm2 rdfs:label ?municipality ;
sw:population ?population .
?continentNode rdfs:label ?continent .
?countryNode rdfs:label ?country .
}
ORDER BY ASC (?date) LIMIT 100