Data table via SPARQL

Electric and electronic equipment put on the market, WEEE collected and recycled/reused, 2010

Data table via SPARQL Published 12 Jun 2014 Last modified 26 Aug 2017

This is an old version, kept for reference only.

Go to latest version

Topics: Resource efficiency and waste

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

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

country	put_on_the_market	total_collected	collected_from_private_households	reuse_and_recycling	collection_target
"Austria"	"19.8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"8.9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"8.7"	"7.1"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4"^^<http://www.w3.org/2001/XMLSchema#int>
"Belgium"	"27"^^<http://www.w3.org/2001/XMLSchema#decimal>	"9.7"^^<http://www.w3.org/2001/XMLSchema#decimal>	"9.3"	"7.8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4"^^<http://www.w3.org/2001/XMLSchema#int>
"Bulgaria"	"6.9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"6.1"^^<http://www.w3.org/2001/XMLSchema#decimal>	"6"	"4.8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4"^^<http://www.w3.org/2001/XMLSchema#int>
"Cyprus"	"23.1"^^<http://www.w3.org/2001/XMLSchema#decimal>	"3.1"^^<http://www.w3.org/2001/XMLSchema#decimal>	"3.1"	"2.3"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4"^^<http://www.w3.org/2001/XMLSchema#int>
"Czech Republic"	"15.9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"5.1"^^<http://www.w3.org/2001/XMLSchema#decimal>	"5"	"4.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4"^^<http://www.w3.org/2001/XMLSchema#int>
"Denmark"	"26.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	"14.9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"14.8"	"12.5"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4"^^<http://www.w3.org/2001/XMLSchema#int>
"Estonia"	"9.9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4.2"	"3.5"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4"^^<http://www.w3.org/2001/XMLSchema#int>
"Finland"	"27.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	"9.5"^^<http://www.w3.org/2001/XMLSchema#decimal>	"9.1"	"8.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4"^^<http://www.w3.org/2001/XMLSchema#int>
"France"	"25.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"6.7"^^<http://www.w3.org/2001/XMLSchema#decimal>	"6.4"	"5.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4"^^<http://www.w3.org/2001/XMLSchema#int>
"Germany"	"21.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"9.5"^^<http://www.w3.org/2001/XMLSchema#decimal>	"8.8"	"7.9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4"^^<http://www.w3.org/2001/XMLSchema#int>

Received 27 rows in 0.001 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/electric-and-electronic-equipment/daviz.json

For system integrators

Linked Data query (SPARQL)

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

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

SPARQL Query:


        PREFIX tableFile: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/wst003/2014/env_waselee_CH_gap_filling_EEE_put_on_market.csv#> 
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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#>
PREFIX wst_oper: <http://dd.eionet.europa.eu/vocabulary/eurostat/wst_oper/>
PREFIX waste: <http://dd.eionet.europa.eu/vocabulary/eurostat/waste/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>


SELECT DISTINCT

IF(?geo = geo:DE, 'Germany', ?ugeo) AS ?country
#unrelable data for Netherlands
(round(?MKT*10))/10.0 AS ?put_on_the_market
(round(?COL*10))/10.0 AS ?total_collected
IF(?COL_HH != '', (round(?COL_HH*10))/10.0,'') AS ?collected_from_private_households
(round(?RCY_REU*10))/10.0 AS ?reuse_and_recycling
4 as ?collection_target

WHERE {
    {
        GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_waselee.rdf.gz> {
          {
            _:env_waselee_MKT sdmx-dimension:timePeriod ?date .
            _:env_waselee_MKT sdmx-attribute:unitMeasure unit:KG_HAB .
            _:env_waselee_MKT property:waste waste:TOTAL .
            _:env_waselee_MKT sdmx-dimension:refArea ?geo .
            _:env_waselee_MKT property:wst_oper wst_oper:MKT .
            _:env_waselee_MKT sdmx-measure:obsValue ?MKT .
          
            _:env_waselee_COL sdmx-dimension:timePeriod ?date .
            _:env_waselee_COL sdmx-attribute:unitMeasure unit:KG_HAB .
            _:env_waselee_COL property:waste waste:TOTAL .
            _:env_waselee_COL sdmx-dimension:refArea ?geo .
            _:env_waselee_COL property:wst_oper wst_oper:COL .
            _:env_waselee_COL sdmx-measure:obsValue ?COL .
          
            _:env_waselee_COL_HH sdmx-dimension:timePeriod ?date .
            _:env_waselee_COL_HH sdmx-attribute:unitMeasure unit:KG_HAB .
            _:env_waselee_COL_HH property:waste waste:TOTAL .
            _:env_waselee_COL_HH sdmx-dimension:refArea ?geo .
            _:env_waselee_COL_HH property:wst_oper wst_oper:COL_HH .
            _:env_waselee_COL_HH sdmx-measure:obsValue ?COL_HH .
          
            _:env_waselee_RCY_REU sdmx-dimension:timePeriod ?date .
            _:env_waselee_RCY_REU sdmx-attribute:unitMeasure unit:KG_HAB .
            _:env_waselee_RCY_REU property:waste waste:TOTAL .
            _:env_waselee_RCY_REU sdmx-dimension:refArea ?geo .
            _:env_waselee_RCY_REU property:wst_oper wst_oper:RCY_REU .
            _:env_waselee_RCY_REU sdmx-measure:obsValue ?RCY_REU .
            FILTER (year(?date) = 2010)
          }
        }
        ?geo rdfs:label ?ugeo .
        } UNION {
        GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/wst003/2014/env_waselee_CH_gap_filling_EEE_put_on_market.csv> 
          {
          _:env_waselee_gap_filling tableFile:Country ?geo
          OPTIONAL { _:env_waselee_gap_filling tableFile:Put_on_the_market_2010 ?MKT }
          OPTIONAL { _:env_waselee_gap_filling tableFile:Total_collected_2010 ?COL }
          OPTIONAL { _:env_waselee_gap_filling tableFile:Collected_from_private_households_2010 ?COL_HH }
          OPTIONAL { _:env_waselee_gap_filling tableFile:Reuse_and_recycling_2010 ?RCY_REU }
        }  
  }
  ?geo rdfs:label ?ugeo .
}
ORDER BY ?ugeo