next
previous
items

Data table via SPARQL

WASTE003 - Trend in the amount of WEEE collected from households in 28 European countries (kg/capita/year), 2006-2008-2010

Data table via SPARQL Published 18 Jun 2013 Last modified 26 Aug 2017
This is an old version, kept for reference only.

Go to latest version
This page was archived on 26 Aug 2017 with reason: A new version has been published

Download this dataset

Dataset preview

(Live Query)

country collected_from_private_households_2006 collected_from_private_households_2008 collected_from_private_households_2010 collection_target
"AT" "7.4"^^<http://www.w3.org/2001/XMLSchema#double> "8.8"^^<http://www.w3.org/2001/XMLSchema#double> "8.7"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"BE" "7.2"^^<http://www.w3.org/2001/XMLSchema#double> "8.1"^^<http://www.w3.org/2001/XMLSchema#double> "9.3"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"BG" "" "5.1"^^<http://www.w3.org/2001/XMLSchema#double> "5.9"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"CY" "" "2.9"^^<http://www.w3.org/2001/XMLSchema#double> "3.1"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"CZ" "" "4.3"^^<http://www.w3.org/2001/XMLSchema#double> "5.0"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"DE" "8.6"^^<http://www.w3.org/2001/XMLSchema#double> "7.8"^^<http://www.w3.org/2001/XMLSchema#double> "8.8"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"DK" "10.8"^^<http://www.w3.org/2001/XMLSchema#double> "13.9"^^<http://www.w3.org/2001/XMLSchema#double> "14.8"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"EE" "4.3"^^<http://www.w3.org/2001/XMLSchema#double> "4.4"^^<http://www.w3.org/2001/XMLSchema#double> "4.2"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"EL" "0.9"^^<http://www.w3.org/2001/XMLSchema#double> "3.9"^^<http://www.w3.org/2001/XMLSchema#double> "3.9"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>
"ES" "3.6"^^<http://www.w3.org/2001/XMLSchema#double> "6.3"^^<http://www.w3.org/2001/XMLSchema#double> "3.2"^^<http://www.w3.org/2001/XMLSchema#double> "4"^^<http://www.w3.org/2001/XMLSchema#int>

Received 28 rows in 0.083 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/waste003-trend-in-the-amount/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 skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX wo: <http://rdfdata.eionet.europa.eu/eurostat/dic/wst_oper#> 
PREFIX w: <http://rdfdata.eionet.europa.eu/eurostat/dic/waste#> 
PREFIX u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#> 

SELECT 

?geo as ?country
sum(xsd:double(?v2006)) as ?collected_from_private_households_2006
sum(xsd:double(?v2008)) as ?collected_from_private_households_2008
sum(xsd:double(?v2010)) as ?collected_from_private_households_2010
4 as ?collection_target

WHERE { 
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_waselee.rdf.gz> { 

        
        _:env_waselee sdmx-attribute:unitMeasure u:KG_HAB .
        _:env_waselee property:waste w:TOTAL .
        _:env_waselee property:geo ?ugeo .
        _:env_waselee property:wst_oper wo:COL_HH .
        { 
        _:env_waselee sdmx-measure:obsValue ?v2006 .
        _:env_waselee sdmx-dimension:timePeriod ?date . FILTER (?date = "2006-01-01"^^xsd:date)
        } UNION { 
        _:env_waselee sdmx-measure:obsValue ?v2008 .
        _:env_waselee sdmx-dimension:timePeriod ?date . FILTER (?date = "2008-01-01"^^xsd:date)
        } UNION { 
        _:env_waselee sdmx-measure:obsValue ?v2010 .        
        _:env_waselee sdmx-dimension:timePeriod ?date . FILTER (?date = "2010-01-01"^^xsd:date)
        } 
  } 
  ?ugeo skos:prefLabel ?country .
  ?ugeo skos:notation ?geo .
}  group by ?ugeo ?geo order by ?geo


Permalinks

Document Actions