next
previous
items

Data table via SPARQL

Share of total energy consumption by fuel

Data table via SPARQL Published 07 Nov 2013 Last modified 26 Aug 2017
This is an old version, kept for reference only.

Go to latest version
This page was archived on 26 Aug 2017 with reason: A new version has been published
Share of total energy consumption by fuel in 2011

Download this dataset

Dataset preview

(Live Query)

year country coal_and_lignite oil gas nuclear renewables industrial_waste import_export_electricity primary_energy_consumption order
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "European Union (27 countries)"@en "16.81"^^<http://www.w3.org/2001/XMLSchema#decimal> "35.22"^^<http://www.w3.org/2001/XMLSchema#decimal> "23.42"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.78"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.96"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.34"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1698"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#int>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "European Union (25 countries)"@en "16.39"^^<http://www.w3.org/2001/XMLSchema#decimal> "35.62"^^<http://www.w3.org/2001/XMLSchema#decimal> "23.38"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.81"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.35"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.07"^^<http://www.w3.org/2001/XMLSchema#decimal> "1642"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "European Economic Area (EU-15 plus IS, LI, NO)"@en "12.69"^^<http://www.w3.org/2001/XMLSchema#decimal> "37.07"^^<http://www.w3.org/2001/XMLSchema#decimal> "24.03"^^<http://www.w3.org/2001/XMLSchema#decimal> "14.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.34"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.13"^^<http://www.w3.org/2001/XMLSchema#decimal> "1456"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "European Union (15 countries)"@en "12.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "37.06"^^<http://www.w3.org/2001/XMLSchema#decimal> "24.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "14.72"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.34"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.15"^^<http://www.w3.org/2001/XMLSchema#decimal> "1425"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "Euro area (17 countries)"@en "13.14"^^<http://www.w3.org/2001/XMLSchema#decimal> "37.37"^^<http://www.w3.org/2001/XMLSchema#decimal> "23.12"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.26"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.03"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.41"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.14"^^<http://www.w3.org/2001/XMLSchema#decimal> "1193"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "Euro area (EA11-2000, EA12-2006, EA13-2007, EA15-2008, EA16-2010, EA17)"@en "13.14"^^<http://www.w3.org/2001/XMLSchema#decimal> "37.37"^^<http://www.w3.org/2001/XMLSchema#decimal> "23.12"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.26"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.03"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.41"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.14"^^<http://www.w3.org/2001/XMLSchema#decimal> "1193"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "Euro area (16 countries)"@en "12.86"^^<http://www.w3.org/2001/XMLSchema#decimal> "37.47"^^<http://www.w3.org/2001/XMLSchema#decimal> "23.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.34"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.41"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.17"^^<http://www.w3.org/2001/XMLSchema#decimal> "1187"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "Euro area (15 countries)"@en "12.74"^^<http://www.w3.org/2001/XMLSchema#decimal> "37.72"^^<http://www.w3.org/2001/XMLSchema#decimal> "23.15"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.22"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.05"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.41"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.17"^^<http://www.w3.org/2001/XMLSchema#decimal> "1169"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "Euro area (13 countries)"@en "12.78"^^<http://www.w3.org/2001/XMLSchema#decimal> "37.53"^^<http://www.w3.org/2001/XMLSchema#decimal> "23.22"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.27"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.07"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.41"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.17"^^<http://www.w3.org/2001/XMLSchema#decimal> "1165"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "Euro area (12 countries)"@en "12.73"^^<http://www.w3.org/2001/XMLSchema#decimal> "37.54"^^<http://www.w3.org/2001/XMLSchema#decimal> "23.31"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.23"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.05"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.41"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.18"^^<http://www.w3.org/2001/XMLSchema#decimal> "1158"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>

Received 42 rows in 0.040 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/share-of-total-energy-consumption/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 skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX g: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>
PREFIX u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX p: <http://rdfdata.eionet.europa.eu/eurostat/dic/product#>
PREFIX indic_nrg: <http://rdfdata.eionet.europa.eu/eurostat/dic/indic_nrg#>

SELECT 
year(?date) as ?year
bif:either (?ugeo = 'DE', 'Germany', ?country) as ?country

(round((sum(?nrg_101a)/sum(?nrg_100a))*10000))/100.0 as ?coal_and_lignite
(round((sum(?nrg_102a)/sum(?nrg_100a))*10000))/100.0 as ?oil
(round((sum(?nrg_103a)/sum(?nrg_100a))*10000))/100.0 as ?gas
(round((sum(?nrg_104a)/sum(?nrg_100a))*10000))/100.0 as ?nuclear
(round((sum(?nrg_1071a_5500)/sum(?nrg_100a))*10000))/100.0 as ?renewables
(round((sum(?nrg_1071a_7100)/sum(?nrg_100a))*10000))/100.0 as ?industrial_waste
(round(((sum(?nrg_105a))/sum(?nrg_100a))*10000))/100.0 as ?import_export_electricity

round(sum(?nrg_100a)/1000.0) as ?primary_energy_consumption

bif:either (?ugeo = 'EU27', 0, 1) as ?order

WHERE {
{  
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a.rdf.gz> 
  {
  _:nrg_100a property:geo ?geo .
  _:nrg_100a property:unit u:1000TOE .
  _:nrg_100a sdmx-dimension:timePeriod ?date .
  _:nrg_100a property:product p:0000 .
  _:nrg_100a property:indic_nrg indic_nrg:B_100900 .
  _:nrg_100a sdmx-measure:obsValue ?nrg_100a .
  } 

  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_101a.rdf.gz> 
  {
  _:nrg_101a property:geo ?geo .
  _:nrg_101a property:unit u:1000TOE .
  _:nrg_101a sdmx-dimension:timePeriod ?date .
  _:nrg_101a property:product p:2000 .
  _:nrg_101a property:indic_nrg indic_nrg:B_100900 .
  _:nrg_101a sdmx-measure:obsValue ?nrg_101a .
  }

  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_102a.rdf.gz> 
  {
  _:nrg_102a property:geo ?geo .
  _:nrg_102a property:unit u:1000TOE .
  _:nrg_102a sdmx-dimension:timePeriod ?date .
  _:nrg_102a property:product p:3000 .
  _:nrg_102a property:indic_nrg indic_nrg:B_100900 .
  _:nrg_102a sdmx-measure:obsValue ?nrg_102a .
  }

  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_103a.rdf.gz> 
  {
  _:nrg_103a property:geo ?geo .
  _:nrg_103a property:unit u:1000TOE .
  _:nrg_103a sdmx-dimension:timePeriod ?date .
  _:nrg_103a property:product p:4000 .
  _:nrg_103a property:indic_nrg indic_nrg:B_100900 .
  _:nrg_103a sdmx-measure:obsValue ?nrg_103a .
  }

  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_104a.rdf.gz> 
  {
  _:nrg_104a property:geo ?geo .
  _:nrg_104a property:unit u:1000TOE .
  _:nrg_104a sdmx-dimension:timePeriod ?date .
  _:nrg_104a property:product p:5100 .
  _:nrg_104a property:indic_nrg indic_nrg:B_100900 .
  _:nrg_104a sdmx-measure:obsValue ?nrg_104a .
  }

  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_105a.rdf.gz> 
  {
  _:nrg_105a property:geo ?geo .
  _:nrg_105a property:unit u:1000TOE .
  _:nrg_105a sdmx-dimension:timePeriod ?date .
  _:nrg_105a property:product p:6000 .
  _:nrg_105a property:indic_nrg indic_nrg:B_100900 .
  _:nrg_105a sdmx-measure:obsValue ?nrg_105a .
  }

  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_106a.rdf.gz> 
  {
  _:nrg_106a property:geo ?geo .
  _:nrg_106a property:unit u:1000TOE .
  _:nrg_106a sdmx-dimension:timePeriod ?date .
  _:nrg_106a property:product p:5200 .
  _:nrg_106a property:indic_nrg indic_nrg:B_100900 .
  _:nrg_106a sdmx-measure:obsValue ?nrg_106a .
  }

  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_1071a.rdf.gz> 
  {
  _:nrg_1071a property:geo ?geo .
  _:nrg_1071a property:unit u:1000TOE .
  _:nrg_1071a sdmx-dimension:timePeriod ?date .
  _:nrg_1071a property:indic_nrg indic_nrg:B_100900 .
  { 
     _:nrg_1071a property:product p:5500 .
     _:nrg_1071a sdmx-measure:obsValue ?nrg_1071a_5500 .
  } UNION {
     _:nrg_1071a property:product p:7100 .
     _:nrg_1071a sdmx-measure:obsValue ?nrg_1071a_7100 .
  } 
 }
}
?geo skos:notation ?ugeo . 
?geo skos:prefLabel ?country .
FILTER (year(?date) = 2011)
} 
GROUP BY year(?date) ?country ?ugeo
ORDER BY ?date ?order DESC(?primary_energy_consumption)


Permalinks

Geographic coverage

Document Actions