Data table via SPARQL

Annual average growth rates in gross inland renewable energy consumption

Data table via SPARQL Published 08 Oct 2014 Last modified 29 Jan 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)

product_code	product_label	1990	2005	2010	2012	2010_2012	2005_2012	1990_2012
"5500"	"Total Renewable"	"71258"^^<http://www.w3.org/2001/XMLSchema#decimal>	"117146"^^<http://www.w3.org/2001/XMLSchema#decimal>	"168884"^^<http://www.w3.org/2001/XMLSchema#decimal>	"184432"^^<http://www.w3.org/2001/XMLSchema#decimal>	"9.21"	"6.7"	"4.42"
"5510"	"Hydro power"	"24890"^^<http://www.w3.org/2001/XMLSchema#decimal>	"26803"^^<http://www.w3.org/2001/XMLSchema#decimal>	"32266"^^<http://www.w3.org/2001/XMLSchema#decimal>	"28811"^^<http://www.w3.org/2001/XMLSchema#decimal>	"-10.71"	"1.04"	"0.67"
"5520"	"Wind power"	"67"^^<http://www.w3.org/2001/XMLSchema#decimal>	"6058"^^<http://www.w3.org/2001/XMLSchema#decimal>	"12836"^^<http://www.w3.org/2001/XMLSchema#decimal>	"17693"^^<http://www.w3.org/2001/XMLSchema#decimal>	"37.84"	"16.55"	"28.85"
"5532"	"Solar thermal"	"137"^^<http://www.w3.org/2001/XMLSchema#decimal>	"699"^^<http://www.w3.org/2001/XMLSchema#decimal>	"1829"^^<http://www.w3.org/2001/XMLSchema#decimal>	"3320"^^<http://www.w3.org/2001/XMLSchema#decimal>	"81.52"	"24.93"	"15.59"
"5534"	"Solar photovoltaic"	"1"^^<http://www.w3.org/2001/XMLSchema#decimal>	"126"^^<http://www.w3.org/2001/XMLSchema#decimal>	"1935"^^<http://www.w3.org/2001/XMLSchema#decimal>	"5781"^^<http://www.w3.org/2001/XMLSchema#decimal>	"198.76"	"72.73"	"48.25"
"5535"	"Tide, Wave and Ocean"	"43"^^<http://www.w3.org/2001/XMLSchema#decimal>	"41"^^<http://www.w3.org/2001/XMLSchema#decimal>	"41"^^<http://www.w3.org/2001/XMLSchema#decimal>	"40"^^<http://www.w3.org/2001/XMLSchema#decimal>	"-2.44"	"-0.35"	"-0.33"
"5541"	"Solid biofuels (excluding charcoal)"	"40170"^^<http://www.w3.org/2001/XMLSchema#decimal>	"64337"^^<http://www.w3.org/2001/XMLSchema#decimal>	"83218"^^<http://www.w3.org/2001/XMLSchema#decimal>	"86321"^^<http://www.w3.org/2001/XMLSchema#decimal>	"3.73"	"4.29"	"3.54"
"5542"	"Biogas"	"665"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4006"^^<http://www.w3.org/2001/XMLSchema#decimal>	"8531"^^<http://www.w3.org/2001/XMLSchema#decimal>	"12092"^^<http://www.w3.org/2001/XMLSchema#decimal>	"41.74"	"17.1"	"14.09"
"55431"	"Municipal waste (renewable)"	"2085"^^<http://www.w3.org/2001/XMLSchema#decimal>	"6175"^^<http://www.w3.org/2001/XMLSchema#decimal>	"7959"^^<http://www.w3.org/2001/XMLSchema#decimal>	"8840"^^<http://www.w3.org/2001/XMLSchema#decimal>	"11.07"	"5.26"	"6.79"
"5544"	"Charcoal"	"8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"46"^^<http://www.w3.org/2001/XMLSchema#decimal>	"104"^^<http://www.w3.org/2001/XMLSchema#decimal>	"126"^^<http://www.w3.org/2001/XMLSchema#decimal>	"21.15"	"15.48"	"13.35"

Received 15 rows in 0.002 seconds.

JSON Url:
https://eea.europa.eu./data-and-maps/daviz/sds/annual-average-growth-rates-in/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 geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX product: <http://dd.eionet.europa.eu/vocabulary/eurostat/product/>
PREFIX indic_nrg: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>

SELECT
?product_code
bif:either(?product_code = '5500', 'Total Renewable', ?product_label) as ?product_label
sum(?1990) as ?1990
sum(?2005) as ?2005
sum(?2010) as ?2010
sum(?2012) as ?2012

if(sum(?2010) != 0, round((((sum(?2012)/sum(?2010)))-1)*10000)/100.0, '') as ?2010_2012
if(sum(?2005) != 0, round(((bif:power((sum(?2012)/sum(?2005)),(1/7.0)))-1)*10000)/100.0, '') as ?2005_2012
if(sum(?1990) != 0, round(((bif:power((sum(?2012)/sum(?1990)),(1/22.0)))-1)*10000)/100.0, '') as ?1990_2012

{{
  SELECT
    ?product_code
    ?product_label
    bif:either (year(?date) = 1990, sum(?nrg_107a), 0) as ?1990
    bif:either (year(?date) = 2005, sum(?nrg_107a), 0) as ?2005
    bif:either (year(?date) = 2010, sum(?nrg_107a), 0) as ?2010
    bif:either (year(?date) = 2012, sum(?nrg_107a), 0) as ?2012

    WHERE {
     {  
      GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_107a.rdf.gz> 
      {
        _:nrg_107a sdmx-dimension:refArea geo:EU28 .
        _:nrg_107a sdmx-attribute:unitMeasure unit:1000TOE .
        _:nrg_107a sdmx-dimension:timePeriod ?date .
        _:nrg_107a property:indic_nrg indic_nrg:B_100900 .
        _:nrg_107a property:product ?product . 
        _:nrg_107a sdmx-measure:obsValue ?nrg_107a .
      }
     ?product rdf-schema:label ?product_label .
     ?product skos:notation ?product_code .
     }
    }
    GROUP BY ?product_label ?date ?product_code
}}
GROUP BY ?product_label ?product_code
ORDER BY ?product_code