next
previous
items

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

Download this dataset

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.


https://eea.europa.eu./data-and-maps/daviz/sds/annual-average-growth-rates-in/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



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 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


Permalinks

Document Actions