next
previous
items

Data table via SPARQL

Share of total energy consumption by fuel

Data table via SPARQL Published 17 Sep 2018 Last modified 24 Jun 2020
Topics:

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 (current composition)" "452.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "549.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "282.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "205.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "72.1"^^<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.8"^^<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> "1570"^^<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"^^<http://www.w3.org/2001/XMLSchema#decimal> "405.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "178.2"^^<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> "39"^^<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.8"^^<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.2"^^<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.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "18"^^<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> "14.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "31.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "49.4"^^<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> "58"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#int>

Received 1039 rows in 0.068 seconds.


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

Temporal coverage

Topics

Topics:

Tags

Filed under:
Filed under: energy consumption
Document Actions