Waste generation and decoupling - population

Data table via SPARQL Published 22 Jul 2019 Last modified 22 Jul 2019

Download this dataset

HTML CSV TSV
JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

date ugeo label index
"2010"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries" "Average population - total" "100"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries" "Average population - total" "99.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries" "Average population - total" "100.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries" "Average population - total" "100.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2014"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries" "Average population - total" "100.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries" "Average population - total" "101.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries" "Average population - total" "101.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries" "Average population - total" "101.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2018"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries" "Average population - total" "101.8"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 9 rows in 0.001 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/waste-generation-and-decoupling-population/daviz.json

For system integrators

The following info can be used by a system developer / database administrator in order to retrieve this dataset programmatically over the web using a SPARQL client.

Are you new to Linked Data technology? visit http://linkeddata.org



http://semantic.eea.europa.eu/sparql 

PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/> 
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/> 
PREFIX hazard: <http://dd.eionet.europa.eu/vocabulary/eurostat/hazard/>
PREFIX waste: <http://dd.eionet.europa.eu/vocabulary/eurostat/waste/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX indic_de: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_de/> 


SELECT DISTINCT
year(?date) as ?date
?ugeo
?label
round((sum(?obsValue)/sum(?obsValue_idx))*1000)/10.0 as ?index

  {{
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/demo_gind.rdf.gz> 
      {
        _:demo_gind sdmx-dimension:timePeriod ?date .
        _:demo_gind sdmx-dimension:refArea ?geo .
        _:demo_gind property:indic_de ?indic_de .
        _:demo_gind sdmx-measure:obsValue ?obsValue .

        _:demo_gind_idx sdmx-dimension:timePeriod ?date_idx .
        FILTER (year(?date_idx) = 2010)
        _:demo_gind_idx sdmx-dimension:refArea ?geo .
        _:demo_gind_idx property:indic_de ?indic_de .
        _:demo_gind_idx sdmx-measure:obsValue ?obsValue_idx .

        FILTER (?indic_de = indic_de:AVG)
      }
      

  }
  ?indic_de rdfs:label ?label .
  ?geo rdfs:label ?ugeo .
  FILTER (?geo = geo:EU28)
  FILTER (year(?date) >= 2010)
}
ORDER BY ?date

Related content

Visualisations produced

Permalinks

Geographic coverage

, , , , , , , , , , , , , , , , , , , , , , , , , , ,

Temporal coverage

Document Actions

For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/waste-generation-and-decoupling-population or scan the QR code.

PDF generated on 23 Sep 2019, 04:24 PM

EEA Page URL QR
Filed under:
The EEA is an agency of the European Union

Engineered by: EEA Web Team

Software updated on 29 August 2019 16:49 from version 19.8.19

Software version: EEA Plone KGS 19.8.29

Code for developers

Systems Status

Legal notice

Creative commons license

CMS login