Alcohol-related hospital discharges by Council area - 2016/17

sparql-sg-training-exercise-3

PREFIX dcat: <http://www.w3.org/ns/dcat#>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx: <http://purl.org/linked-data/sdmx/2009/concept#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX void: <http://rdfs.org/ns/void#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

SELECT ?areaname ?value
WHERE {
  ?obs <http://statistics.gov.scot/def/measure-properties/ratio> ?value ;
  	<http://purl.org/linked-data/cube#dataSet> <http://statistics.gov.scot/data/alcohol-related-discharge> ;
    <http://purl.org/linked-data/sdmx/2009/dimension#refArea> ?area ;
    <http://purl.org/linked-data/sdmx/2009/dimension#refPeriod> <http://reference.data.gov.uk/id/government-year/2016-2017> .
  ?area rdfs:label ?areaname ;
        <http://statistics.data.gov.uk/def/statistical-entity#code> <http://statistics.gov.scot/id/statistical-entity/S12> .
  
}