Data table via SPARQL

Number of countries reporting at different levels of the MSW management hierarchy

Data table via SPARQL Published 15 Aug 2014 Last modified 19 Apr 2016

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)

date	RCY_TOT_25	INC_RCV_25	DSP_D_50	DSP_D_75
"1995"^^<http://www.w3.org/2001/XMLSchema#int>	"11"^^<http://www.w3.org/2001/XMLSchema#decimal>	"7"^^<http://www.w3.org/2001/XMLSchema#decimal>	"15"^^<http://www.w3.org/2001/XMLSchema#decimal>	"7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int>	"9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"7"^^<http://www.w3.org/2001/XMLSchema#decimal>	"15"^^<http://www.w3.org/2001/XMLSchema#decimal>	"8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1997"^^<http://www.w3.org/2001/XMLSchema#int>	"10"^^<http://www.w3.org/2001/XMLSchema#decimal>	"7"^^<http://www.w3.org/2001/XMLSchema#decimal>	"12"^^<http://www.w3.org/2001/XMLSchema#decimal>	"6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1998"^^<http://www.w3.org/2001/XMLSchema#int>	"9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"7"^^<http://www.w3.org/2001/XMLSchema#decimal>	"13"^^<http://www.w3.org/2001/XMLSchema#decimal>	"8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1999"^^<http://www.w3.org/2001/XMLSchema#int>	"10"^^<http://www.w3.org/2001/XMLSchema#decimal>	"7"^^<http://www.w3.org/2001/XMLSchema#decimal>	"16"^^<http://www.w3.org/2001/XMLSchema#decimal>	"12"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int>	"11"^^<http://www.w3.org/2001/XMLSchema#decimal>	"7"^^<http://www.w3.org/2001/XMLSchema#decimal>	"19"^^<http://www.w3.org/2001/XMLSchema#decimal>	"14"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int>	"11"^^<http://www.w3.org/2001/XMLSchema#decimal>	"8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"16"^^<http://www.w3.org/2001/XMLSchema#decimal>	"11"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2002"^^<http://www.w3.org/2001/XMLSchema#int>	"11"^^<http://www.w3.org/2001/XMLSchema#decimal>	"8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"16"^^<http://www.w3.org/2001/XMLSchema#decimal>	"10"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2003"^^<http://www.w3.org/2001/XMLSchema#int>	"12"^^<http://www.w3.org/2001/XMLSchema#decimal>	"7"^^<http://www.w3.org/2001/XMLSchema#decimal>	"18"^^<http://www.w3.org/2001/XMLSchema#decimal>	"9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int>	"14"^^<http://www.w3.org/2001/XMLSchema#decimal>	"9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"19"^^<http://www.w3.org/2001/XMLSchema#decimal>	"8"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 18 rows in 0.001 seconds.

JSON Url:
https://eea.europa.eu./data-and-maps/daviz/sds/number-of-countries-reporting-at/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:
semantic.eea.europa.eu/sparql

SPARQL Query:


        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 rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX unit: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX wst_oper: <http://rdfdata.eionet.europa.eu/eurostat/dic/wst_oper#>
PREFIX geo: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>

SELECT
?date
#ugeo
#?RCY_TOT
sum(?RCY_TOT_25) as ?RCY_TOT_25
#?INC_RCV
sum(?INC_RCV_25) as ?INC_RCV_25
#?DSP_D
sum(?DSP_D_50) as ?DSP_D_50
sum(?DSP_D_75) as ?DSP_D_75
{{
  SELECT
  ?date
  ?ugeo
  bif:either(?RCY_TOT >= 25, 1, 0) as ?RCY_TOT_25
  ?RCY_TOT
  bif:either(?INC_RCV >= 25, 1, 0) as ?INC_RCV_25
  ?INC_RCV
  bif:either(?DSP_D >= 50, 1, 0) as ?DSP_D_50
  bif:either(?DSP_D >= 75, 1, 0) as ?DSP_D_75
  ?DSP_D
  {{
    SELECT
    year(?date) as ?date
    bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
    round(sum(?RCY_M) / sum(?GEN)*100) as ?RCY_M
    round(sum(?RCY_OC) / sum(?GEN)*100) as ?RCY_OC
    round(sum(?INC_RCV) / sum(?GEN)*100) as ?INC_RCV
    round(sum(?DSP_D) / sum(?GEN)*100) as ?DSP_D
    round(( ( sum(?RCY_OC) / sum(?GEN) ) + ( sum(?RCY_M) / sum(?GEN) ) ) *100)  as ?RCY_TOT

    WHERE { 
     { 
      GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wasmun.rdf.gz> 
     {    
      _:env_wasmun sdmx-dimension:timePeriod ?date . 
      #FILTER (year(?date) in (2012)) 
      #FILTER (year(?date) in (2001, 2010, 2012)) 
      _:env_wasmun sdmx-attribute:unitMeasure unit:1000T . 
      _:env_wasmun sdmx-dimension:refArea ?geo . 
      {
        _:env_wasmun property:wst_oper wst_oper:GEN .
        _:env_wasmun sdmx-measure:obsValue ?GEN  .
      } UNION {
        _:env_wasmun property:wst_oper wst_oper:DSP_D .
        _:env_wasmun sdmx-measure:obsValue ?DSP_D .
      } UNION {
        _:env_wasmun property:wst_oper wst_oper:INC_RCV .
        _:env_wasmun sdmx-measure:obsValue ?INC_RCV .
      } UNION {
        _:env_wasmun property:wst_oper wst_oper:RCY_M .
        _:env_wasmun sdmx-measure:obsValue ?RCY_M .
      } UNION {
        _:env_wasmun property:wst_oper wst_oper:RCY_OC .
        _:env_wasmun sdmx-measure:obsValue ?RCY_OC .
      }
     }
     FILTER (?geo != geo:EU28 and ?geo != geo:EU27 and ?geo != geo:MK and ?geo != geo:RS and ?geo != geo:BA  and ?geo != geo:HR)
     ?geo rdf-schema:label ?ugeo .
   }} 
 }} 
}}
ORDER BY ?date