Trends in EU-28 environmental protection expenditure (EPE) by organisation type, in absolute value (2010 fixed prices) and share of GDP

Data table via SPARQL Published 18 Jun 2018 Last modified 04 Oct 2018
Topics: ,

Download this dataset

Dataset preview

(Live Query)

date government specializedServiceProvider industry gdpShare
"2006"^^<http://www.w3.org/2001/XMLSchema#int> "105152.98"^^<http://www.w3.org/2001/XMLSchema#decimal> "118899.86"^^<http://www.w3.org/2001/XMLSchema#decimal> "43306.86"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.11"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2007"^^<http://www.w3.org/2001/XMLSchema#int> "103880.15"^^<http://www.w3.org/2001/XMLSchema#decimal> "119497.87"^^<http://www.w3.org/2001/XMLSchema#decimal> "41369.13"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.02"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2008"^^<http://www.w3.org/2001/XMLSchema#int> "107122.52"^^<http://www.w3.org/2001/XMLSchema#decimal> "121582.15"^^<http://www.w3.org/2001/XMLSchema#decimal> "42130.96"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.06"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009"^^<http://www.w3.org/2001/XMLSchema#int> "108561.87"^^<http://www.w3.org/2001/XMLSchema#decimal> "124989.91"^^<http://www.w3.org/2001/XMLSchema#decimal> "41220.81"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.18"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2010"^^<http://www.w3.org/2001/XMLSchema#int> "107082.12"^^<http://www.w3.org/2001/XMLSchema#decimal> "129918.07"^^<http://www.w3.org/2001/XMLSchema#decimal> "41329.61"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.17"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "105677.71"^^<http://www.w3.org/2001/XMLSchema#decimal> "134172.14"^^<http://www.w3.org/2001/XMLSchema#decimal> "42265.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.16"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int> "103901.85"^^<http://www.w3.org/2001/XMLSchema#decimal> "135552.77"^^<http://www.w3.org/2001/XMLSchema#decimal> "41343.62"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.16"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> "102408.81"^^<http://www.w3.org/2001/XMLSchema#decimal> "134056.92"^^<http://www.w3.org/2001/XMLSchema#decimal> "40261.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.12"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2014"^^<http://www.w3.org/2001/XMLSchema#int> "102854"^^<http://www.w3.org/2001/XMLSchema#decimal> "138158.04"^^<http://www.w3.org/2001/XMLSchema#decimal> "33051.37"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.06"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "103444.18"^^<http://www.w3.org/2001/XMLSchema#decimal> "131501.27"^^<http://www.w3.org/2001/XMLSchema#decimal> "41832.35"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.04"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 12 rows in 0.060 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/trends-in-eu-28-environmental/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 unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX ceparema: <http://dd.eionet.europa.eu/vocabulary/eurostat/ceparema/>
PREFIX env_econ: <http://dd.eionet.europa.eu/vocabulary/eurostat/env_econ/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX na_item: <http://dd.eionet.europa.eu/vocabulary/eurostat/na_item/>

SELECT
?date
round (?pepsgg/?PD10_EUR*10000000)/100.0 as ?government
round (?pepssp/?PD10_EUR*10000000)/100.0 as ?specializedServiceProvider
round (?pepsnsp/?PD10_EUR*10000000)/100.0 as ?industry
round(   ((((?pepsgg+?pepssp+?pepsnsp)/?PD10_EUR*10000000 )/?CLV10_MEUR))*100.0)/100.0 as ?gdpShare
{

  SELECT DISTINCT
    year(?date) as ?date
    sum(?pepsgg) as ?pepsgg
    (sum(?pepssp_EPS_P11)+sum(?pepssp_EPS_P51G_NP)-sum(?pepssp_EPS_P2_EPS_SP)) as ?pepssp
    sum(?pepsnsp) as ?pepsnsp
    sum(xsd:double(?PD10_EUR))*1000 as ?PD10_EUR
    sum(?CLV10_MEUR) as ?CLV10_MEUR
  WHERE {
   {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_pepsgg.rdf.gz>
      {
        _:env_ac_pepsgg sdmx-dimension:timePeriod ?date .
        _:env_ac_pepsgg property:ceparema ceparema:TOT_CEPA .
        _:env_ac_pepsgg sdmx-dimension:refArea geo:EU28 .
        _:env_ac_pepsgg sdmx-attribute:unitMeasure unit:MIO_EUR .
        _:env_ac_pepsgg property:env_econ ?env_econ .
        FILTER (?env_econ in (env_econ:EPS_P1, env_econ:EPS_P51G_NP))
        _:env_ac_pepsgg sdmx-measure:obsValue ?pepsgg .
      } 
   } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_pepssp.rdf.gz>
      {
        _:env_ac_pepssp sdmx-dimension:timePeriod ?date .
        _:env_ac_pepssp property:ceparema ceparema:TOT_CEPA .
        _:env_ac_pepssp sdmx-dimension:refArea geo:EU28 .
        _:env_ac_pepssp sdmx-attribute:unitMeasure unit:MIO_EUR .
        {
          _:env_ac_pepssp property:env_econ env_econ:EPS_P11 .
          _:env_ac_pepssp sdmx-measure:obsValue ?pepssp_EPS_P11 .
        } UNION {
          _:env_ac_pepssp property:env_econ env_econ:EPS_P2_EPS_SP .
          _:env_ac_pepssp sdmx-measure:obsValue ?pepssp_EPS_P2_EPS_SP .
        } UNION {
          _:env_ac_pepssp property:env_econ env_econ:EPS_P51G_NP .
          _:env_ac_pepssp sdmx-measure:obsValue ?pepssp_EPS_P51G_NP .
        }
      }      
   } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_pepsnsp.rdf.gz>
      {
        _:env_ac_pepsnsp sdmx-dimension:timePeriod ?date .
        _:env_ac_pepsnsp property:nace_r2 nace_r2:EP_BUS .
        _:env_ac_pepsnsp property:ceparema ceparema:TOT_CEPA .
        _:env_ac_pepsnsp sdmx-dimension:refArea geo:EU28 .
        _:env_ac_pepsnsp sdmx-attribute:unitMeasure unit:MIO_EUR .
        _:env_ac_pepsnsp property:env_econ ?env_econ .
        FILTER (?env_econ in (env_econ:EPS_P1_ANC, env_econ:EPS_P51G_NP))
        _:env_ac_pepsnsp sdmx-measure:obsValue ?pepsnsp .
      
      } 
   } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_10_gdp.rdf.gz>
      {
        _:nama_10_gdp sdmx-dimension:timePeriod ?date . 
        _:nama_10_gdp property:na_item na_item:B1GQ . 
        _:nama_10_gdp sdmx-dimension:refArea geo:EU28 .
        _:nama_10_gdp sdmx-attribute:unitMeasure ?unit .
        {
          _:nama_10_gdp sdmx-attribute:unitMeasure unit:PD10_EUR .
          _:nama_10_gdp sdmx-measure:obsValue ?PD10_EUR .
        } UNION {
          _:nama_10_gdp sdmx-attribute:unitMeasure unit:CLV10_MEUR .
          _:nama_10_gdp sdmx-measure:obsValue ?CLV10_MEUR .
        }
      }
    }
    FILTER (year(?date) >= 2006)
  }
}


Temporal coverage

Document Actions