# Retrieves the population and number of daily cases for first-order administrative divisions in a country
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 ?continent ?country ?county ?date ?numberOfCases ?countyPopulation WHERE {
?measurement rdf:type base:ADM1Measurement ;
owl-time:hasTime ?date ;
base:numberOfCases ?numberOfCases ;
base:inAdm1 ?adm1 ;
base:inCountry ?countryNode ;
base:inContinent ?continentNode .
?adm1 rdfs:label ?county ;
sw:population ?countyPopulation .
?continentNode rdfs:label ?continent .
?countryNode rdfs:label ?country .
filter (lang(?county) = "en")
}
ORDER BY ASC (?date) LIMIT 100