next
previous
items

Data table via SPARQL

Share of total energy consumption by fuel

Data table via SPARQL Published 18 May 2016 Last modified 28 May 2016
This is an old version, kept for reference only.

Go to latest version

Download this dataset

Dataset preview

(Live Query)

year country coal_and_lignite oil gas nuclear renewables waste_not_renewable import_export_electricity share_coal_and_lignite share_oil share_gas share_nuclear share_renewables share_waste_not_renewable share_import_export_electricity primary_energy_consumption order
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "European Union (28 countries)" "453.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "548.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "282.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "205.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "71.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "28.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "35"^^<http://www.w3.org/2001/XMLSchema#decimal> "18"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "1569"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#int>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Euro area (19 countries)" "242.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "404.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "178.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "160.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "52"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "-0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "23.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "38.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "17.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1040"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "127.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "106.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "53.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "39.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "38.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "32"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "333"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Ukraine" "82.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "56.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "91.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "19.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "-2.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "33.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "22.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "36.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "-1"^^<http://www.w3.org/2001/XMLSchema#decimal> "249"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "France" "19.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "77.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "24.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "81"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "-3.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "36.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "37.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "-1.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "214"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "United Kingdom" "63.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "72"^^<http://www.w3.org/2001/XMLSchema#decimal> "45.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "17"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "31.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "36"^^<http://www.w3.org/2001/XMLSchema#decimal> "22.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "8.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "200"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Italy" "14.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "81.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "37.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "3"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "56.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "26.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "143"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Poland" "78.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "7"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "-0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "79.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "-0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "99"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Spain" "19.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "39.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "14"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "22.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "47.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "16.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "84"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Netherlands" "8.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "17"^^<http://www.w3.org/2001/XMLSchema#decimal> "28.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "29.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "50.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "57"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>

Received 975 rows in 0.063 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/share-of-total-energy-consumption-2/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 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/>

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

round((sum(?nrg_101a)-sum(?nrg_101a_non_energy) ) /100)/10.0 as ?coal_and_lignite
round((sum(?nrg_102a)-sum(?nrg_102a_non_energy))/100)/10.0 as ?oil
round((sum(?nrg_103a)-sum(?nrg_103a_non_energy))/100)/10.0 as ?gas
round(sum(?nrg_104a)/100)/10.0 as ?nuclear
round((sum(?nrg_107a)-sum(?nrg_107a_non_energy))/100)/10.0 as ?renewables
round(sum(?nrg_108a)/100)/10.0 as ?waste_not_renewable
round(sum(?nrg_105a)/100)/10.0 as ?import_export_electricity
(round( ( (sum(?nrg_101a) - sum(?nrg_101a_non_energy)) / (sum(?nrg_100a)-sum(?nrg_100a_non_energy)) )  *1000))/10.0 as ?share_coal_and_lignite
(round( ( (sum(?nrg_102a) - sum(?nrg_102a_non_energy)) / (sum(?nrg_100a)-sum(?nrg_100a_non_energy)) ) *1000))/10.0 as ?share_oil
(round( ( (sum(?nrg_103a) - sum(?nrg_103a_non_energy)) / (sum(?nrg_100a)-sum(?nrg_100a_non_energy)) ) *1000))/10.0 as ?share_gas
(round( ( sum(?nrg_104a ) / (sum(?nrg_100a)-sum(?nrg_100a_non_energy)) ) *1000))/10.0 as ?share_nuclear
(round( ( (sum(?nrg_107a) - sum(?nrg_107a_non_energy)) / (sum(?nrg_100a)-sum(?nrg_100a_non_energy)) ) *1000))/10.0 as ?share_renewables
(round( ( sum(?nrg_108a ) / (sum(?nrg_100a)-sum(?nrg_100a_non_energy)) ) *1000))/10.0 as ?share_waste_not_renewable
(round( ( sum(?nrg_105a ) / (sum(?nrg_100a)-sum(?nrg_100a_non_energy)) ) *1000))/10.0 as ?share_import_export_electricity
round((sum(?nrg_100a)-sum(?nrg_100a_non_energy))/1000.0) as ?primary_energy_consumption

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

WHERE {
{  
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a.rdf.gz> 
  {
    _:nrg_100a sdmx-dimension:refArea ?geo .
    _:nrg_100a sdmx-attribute:unitMeasure unit:KTOE .
    _:nrg_100a sdmx-dimension:timePeriod ?date .
    _:nrg_100a property:product product:0000 .
    {
      _:nrg_100a property:indic_nrg indic_nrg:B_100900 .
      _:nrg_100a sdmx-measure:obsValue ?nrg_100a .
    } UNION {
      _:nrg_100a property:indic_nrg indic_nrg:B_101600 .
      _:nrg_100a sdmx-measure:obsValue ?nrg_100a_non_energy .

    }
  } 

  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_101a.rdf.gz> 
  {
    _:nrg_101a sdmx-dimension:refArea ?geo .
    _:nrg_101a sdmx-attribute:unitMeasure unit:KTOE .
    _:nrg_101a sdmx-dimension:timePeriod ?date .
    _:nrg_101a property:product product:2000 .
    { 
      _:nrg_101a property:indic_nrg indic_nrg:B_100900 .
      _:nrg_101a sdmx-measure:obsValue ?nrg_101a .
    } UNION {
      _:nrg_101a property:indic_nrg indic_nrg:B_101600 .
      _:nrg_101a sdmx-measure:obsValue ?nrg_101a_non_energy .

    }
  }

  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_102a.rdf.gz> 
  {
    _:nrg_102a sdmx-dimension:refArea ?geo .
    _:nrg_102a sdmx-attribute:unitMeasure unit:KTOE .
    _:nrg_102a sdmx-dimension:timePeriod ?date .
    _:nrg_102a property:product product:3000 .
    {  
      _:nrg_102a property:indic_nrg indic_nrg:B_100900 .
      _:nrg_102a sdmx-measure:obsValue ?nrg_102a .
    } UNION {
      _:nrg_102a property:indic_nrg indic_nrg:B_101600 .
      _:nrg_102a sdmx-measure:obsValue ?nrg_102a_non_energy .
    }
  }

  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_103a.rdf.gz> 
  {
    _:nrg_103a sdmx-dimension:refArea ?geo .
    _:nrg_103a sdmx-attribute:unitMeasure unit:KTOE .
    _:nrg_103a sdmx-dimension:timePeriod ?date .
    _:nrg_103a property:product product:4000 .
    {  
      _:nrg_103a property:indic_nrg indic_nrg:B_100900 .
      _:nrg_103a sdmx-measure:obsValue ?nrg_103a .
    } UNION {
      _:nrg_103a property:indic_nrg indic_nrg:B_101600 .
      _:nrg_103a sdmx-measure:obsValue ?nrg_103a_non_energy .
    }
  }

  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_104a.rdf.gz> 
  {
    _:nrg_104a sdmx-dimension:refArea ?geo .
    _:nrg_104a sdmx-attribute:unitMeasure unit:KTOE .
    _:nrg_104a sdmx-dimension:timePeriod ?date .
    _:nrg_104a property:product product: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 sdmx-dimension:refArea ?geo .
    _:nrg_105a sdmx-attribute:unitMeasure unit:KTOE .
    _:nrg_105a sdmx-dimension:timePeriod ?date .
    _:nrg_105a property:product product: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 sdmx-dimension:refArea ?geo .
    _:nrg_106a sdmx-attribute:unitMeasure unit:KTOE .
    _:nrg_106a sdmx-dimension:timePeriod ?date .
    _:nrg_106a property:product product:5200 .
    {  
      _:nrg_106a property:indic_nrg indic_nrg:B_100900 .
      _:nrg_106a sdmx-measure:obsValue ?nrg_106a .
    } UNION {
      _:nrg_106a property:indic_nrg indic_nrg:B_101600 .
      _:nrg_106a sdmx-measure:obsValue ?nrg_106a_non_energy .
    }
  }

  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_107a.rdf.gz> 
  {
    _:nrg_107a sdmx-dimension:refArea ?geo .
    _:nrg_107a sdmx-attribute:unitMeasure unit:KTOE .
    _:nrg_107a sdmx-dimension:timePeriod ?date .
    _:nrg_107a property:product product:5500 .
    {  
      _:nrg_107a property:indic_nrg indic_nrg:B_100900 .
      _:nrg_107a sdmx-measure:obsValue ?nrg_107a .
    } UNION {
      _:nrg_107a property:indic_nrg indic_nrg:B_101600 .
      _:nrg_107a sdmx-measure:obsValue ?nrg_107a_non_energy .
    }
  }

  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_108a.rdf.gz> 
  {
    _:nrg_108a sdmx-dimension:refArea ?geo .
    _:nrg_108a sdmx-attribute:unitMeasure unit:KTOE .
    _:nrg_108a sdmx-dimension:timePeriod ?date .
    _:nrg_108a property:product product:7200 .
    _:nrg_108a property:indic_nrg indic_nrg:B_100900 .
    _:nrg_108a sdmx-measure:obsValue ?nrg_108a .
  }
 
}
?geo skos:notation ?ugeo . 
?geo skos:prefLabel ?country .
#FILTER (?country = 'European Union (28 countries)')
#FILTER (year(?date) = 2013)
} 
GROUP BY year(?date) ?country ?ugeo
HAVING sum(?nrg_100a)-sum(?nrg_100a_non_energy) > 0
ORDER BY ?date ?order DESC(?primary_energy_consumption)


Permalinks

Geographic coverage

Document Actions