next
previous
items

Data table via SPARQL

Renewable electricity as a percentage of gross electricity consumption, country breakdown, 2012

Data table via SPARQL Published 24 Nov 2014 Last modified 02 Feb 2016

Download this dataset

Dataset preview

(Live Query)

ugeo hydro_power other_renewable renewable hydro_power_abs other_renewable_abs total_power_abs target
"Austria" "63.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "73.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "47681"^^<http://www.w3.org/2001/XMLSchema#decimal> "7441"^^<http://www.w3.org/2001/XMLSchema#decimal> "75426"^^<http://www.w3.org/2001/XMLSchema#decimal> "78"^^<http://www.w3.org/2001/XMLSchema#int>
"Belgium" "1.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "1659"^^<http://www.w3.org/2001/XMLSchema#decimal> "10100"^^<http://www.w3.org/2001/XMLSchema#decimal> "92810"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#int>
"Bulgaria" "10.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "3976"^^<http://www.w3.org/2001/XMLSchema#decimal> "2101"^^<http://www.w3.org/2001/XMLSchema#decimal> "39021"^^<http://www.w3.org/2001/XMLSchema#decimal> "11"^^<http://www.w3.org/2001/XMLSchema#int>
"Croatia" "26.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "28.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "4801"^^<http://www.w3.org/2001/XMLSchema#decimal> "425"^^<http://www.w3.org/2001/XMLSchema#decimal> "18186"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#int>
"Cyprus" "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "257"^^<http://www.w3.org/2001/XMLSchema#decimal> "4717"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#int>
"Czech Republic" "4.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "8.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "2860"^^<http://www.w3.org/2001/XMLSchema#decimal> "5936"^^<http://www.w3.org/2001/XMLSchema#decimal> "70453"^^<http://www.w3.org/2001/XMLSchema#decimal> "8"^^<http://www.w3.org/2001/XMLSchema#int>
"Denmark" "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "41.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "41.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "17"^^<http://www.w3.org/2001/XMLSchema#decimal> "14819"^^<http://www.w3.org/2001/XMLSchema#decimal> "35941"^^<http://www.w3.org/2001/XMLSchema#decimal> "29"^^<http://www.w3.org/2001/XMLSchema#int>
"Estonia" "0.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "14.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "42"^^<http://www.w3.org/2001/XMLSchema#decimal> "1435"^^<http://www.w3.org/2001/XMLSchema#decimal> "9727"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#int>
"European Union (28 countries)" "11.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "13"^^<http://www.w3.org/2001/XMLSchema#decimal> "24.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "366370"^^<http://www.w3.org/2001/XMLSchema#decimal> "432366"^^<http://www.w3.org/2001/XMLSchema#decimal> "3314397"^^<http://www.w3.org/2001/XMLSchema#decimal> "21"^^<http://www.w3.org/2001/XMLSchema#int>
"Finland" "19.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "32.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "16859"^^<http://www.w3.org/2001/XMLSchema#decimal> "11679"^^<http://www.w3.org/2001/XMLSchema#decimal> "87843"^^<http://www.w3.org/2001/XMLSchema#decimal> "32"^^<http://www.w3.org/2001/XMLSchema#int>

Received 34 rows in 0.036 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/renewable-electricity-as-a-percentage/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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
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://rdfdata.eionet.europa.eu/eurostat/dic/geo#>
PREFIX unit: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX product: <http://dd.eionet.europa.eu/vocabulary/eurostat/product/>
PREFIX indic_nrg: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>
PREFIX tableFile: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/ENER030/renewable_electricity_Indicative_target_2010.tsv#>

SELECT
bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
round(sum(?hydro_power)/sum(?total_power)*1000)/10.0 as ?hydro_power
round(sum(?other_renewable)/sum(?total_power)*1000)/10.0 as ?other_renewable
round((sum(?hydro_power)+sum(?other_renewable))/sum(?total_power)*1000)/10.0 as ?renewable
sum(?hydro_power) as ?hydro_power_abs
sum( ?other_renewable) as ?other_renewable_abs
sum(?total_power) as ?total_power_abs
#bif:either(sum(xsd:integer(?target)) = 0, '', sum(xsd:integer(?target))) as ?target
sum(xsd:integer(?target)) as ?target
WHERE {
{  
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_105a.rdf.gz> 
  { 
    _:nrg_105a sdmx-dimension:timePeriod ?date . FILTER (year(?date) in (2012))
    _:nrg_105a property:product product:6000 . 
    _:nrg_105a sdmx-attribute:unitMeasure unit:GWH .
    _:nrg_105a property:indic_nrg ?indic_nrg .
    _:nrg_105a sdmx-dimension:refArea ?geo . 
    FILTER (?geo != geo:EA18 and ?geo != geo:EU15 and ?geo != geo:MK and ?geo != geo:RS and ?geo != geo:ME)
    {
      FILTER (?indic_nrg in (indic_nrg:15_107034, indic_nrg:15_107035)) 
      _:nrg_105a sdmx-measure:obsValue ?hydro_power .
    } UNION {
      FILTER (?indic_nrg in (indic_nrg:15_107044, indic_nrg:15_107045,indic_nrg:14_1070421, indic_nrg:14_1070431,indic_nrg:14_1070422, indic_nrg:14_1070432,indic_nrg:15_107038, indic_nrg:15_107039, indic_nrg:15_107040, indic_nrg:15_107041,
indic_nrg:22_108911, indic_nrg:22_108912, indic_nrg:22_108913, indic_nrg:22_108914,indic_nrg:22_108931, indic_nrg:22_108932, indic_nrg:22_108933, indic_nrg:22_108934,indic_nrg:15_107046, indic_nrg:15_107047,indic_nrg:22_108941, 
indic_nrg:22_108942, indic_nrg:22_108943, indic_nrg:22_108944, indic_nrg:22_108951, indic_nrg:22_108952, indic_nrg:22_108953, indic_nrg:22_108954, indic_nrg:22_108971, indic_nrg:22_108972, indic_nrg:22_108973, indic_nrg:22_108974))
      _:nrg_105a sdmx-measure:obsValue ?other_renewable .
    } UNION {
      FILTER (?indic_nrg in (indic_nrg:B_100900, indic_nrg:17_107000)) 
      _:nrg_105a sdmx-measure:obsValue ?total_power .
    }
  }
 } UNION {
 GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/ENER030/renewable_electricity_Indicative_target_2010.tsv> 
   { 
     OPTIONAL { _:rec tableFile:geo ?geo } .
     OPTIONAL { _:rec tableFile:target ?target } .
   } 
 }
?geo rdfs:label ?ugeo .
}
GROUP BY ?ugeo ?geo
ORDER BY ?ugeo


Permalinks

Document Actions