next
previous
items

Data table via SPARQL

Final energy consumption by fuel type

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

Download this dataset

Dataset preview

(Live Query)

year solid_fuels oil gas electricity other total share_solid_fuels share_oil share_gas share_electricity share_other
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "124.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "448.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "211.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "185.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "114.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "1084.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.44"^^<http://www.w3.org/2001/XMLSchema#decimal> "41.38"^^<http://www.w3.org/2001/XMLSchema#decimal> "19.46"^^<http://www.w3.org/2001/XMLSchema#decimal> "17.13"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.58"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "110.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "458"^^<http://www.w3.org/2001/XMLSchema#decimal> "221.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "187.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "113.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "1091.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.15"^^<http://www.w3.org/2001/XMLSchema#decimal> "41.98"^^<http://www.w3.org/2001/XMLSchema#decimal> "20.33"^^<http://www.w3.org/2001/XMLSchema#decimal> "17.16"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.39"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "96.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "460.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "209.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "186.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "112.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "1065.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.07"^^<http://www.w3.org/2001/XMLSchema#decimal> "43.24"^^<http://www.w3.org/2001/XMLSchema#decimal> "19.67"^^<http://www.w3.org/2001/XMLSchema#decimal> "17.51"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.51"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "91.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "463.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "216"^^<http://www.w3.org/2001/XMLSchema#decimal> "186.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "112.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "1069.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "8.58"^^<http://www.w3.org/2001/XMLSchema#decimal> "43.31"^^<http://www.w3.org/2001/XMLSchema#decimal> "20.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "17.44"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.48"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "85.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "463.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "218.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "189.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "107.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "1064"^^<http://www.w3.org/2001/XMLSchema#decimal> "8.08"^^<http://www.w3.org/2001/XMLSchema#decimal> "43.53"^^<http://www.w3.org/2001/XMLSchema#decimal> "20.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "17.77"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.12"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "83"^^<http://www.w3.org/2001/XMLSchema#decimal> "465.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "232.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "194.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "107.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "1082.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.66"^^<http://www.w3.org/2001/XMLSchema#decimal> "43.03"^^<http://www.w3.org/2001/XMLSchema#decimal> "21.48"^^<http://www.w3.org/2001/XMLSchema#decimal> "17.93"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "82"^^<http://www.w3.org/2001/XMLSchema#decimal> "481.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "254"^^<http://www.w3.org/2001/XMLSchema#decimal> "200.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "112.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "1130.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.25"^^<http://www.w3.org/2001/XMLSchema#decimal> "42.62"^^<http://www.w3.org/2001/XMLSchema#decimal> "22.47"^^<http://www.w3.org/2001/XMLSchema#decimal> "17.72"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.94"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "77.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "484"^^<http://www.w3.org/2001/XMLSchema#decimal> "244.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "203.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "108.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "1119.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.96"^^<http://www.w3.org/2001/XMLSchema#decimal> "43.24"^^<http://www.w3.org/2001/XMLSchema#decimal> "21.88"^^<http://www.w3.org/2001/XMLSchema#decimal> "18.18"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.73"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "68.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "495.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "248.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "207.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "108"^^<http://www.w3.org/2001/XMLSchema#decimal> "1127.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.04"^^<http://www.w3.org/2001/XMLSchema#decimal> "43.93"^^<http://www.w3.org/2001/XMLSchema#decimal> "22.07"^^<http://www.w3.org/2001/XMLSchema#decimal> "18.39"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.57"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "63.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "496.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "251.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "211.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "105.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "1127.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "44.02"^^<http://www.w3.org/2001/XMLSchema#decimal> "22.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "18.74"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.34"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 27 rows in 0.002 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/final-energy-consumption-by-fuel-type-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
round(sum(?nrg_101a)/100)/10.0 as ?solid_fuels
round(sum(?nrg_102a)/100)/10.0 as ?oil
round(sum(?nrg_103a)/100)/10.0 as ?gas
round(sum(?nrg_105a)/100)/10.0 as ?electricity
round((sum(?nrg_100a)-( sum(?nrg_101a)+sum(?nrg_102a)+sum(?nrg_103a)+sum(?nrg_105a) ))/100)/10.0 as ?other
round(sum(?nrg_100a)/100)/10.0 as ?total

round((sum(?nrg_101a)/sum(?nrg_100a))*10000)/100.0 as ?share_solid_fuels
round((sum(?nrg_102a)/sum(?nrg_100a))*10000)/100.0 as ?share_oil
round((sum(?nrg_103a)/sum(?nrg_100a))*10000)/100.0 as ?share_gas
round((sum(?nrg_105a)/sum(?nrg_100a))*10000)/100.0 as ?share_electricity
round(((sum(?nrg_100a)-( sum(?nrg_101a)+sum(?nrg_102a)+sum(?nrg_103a)+sum(?nrg_105a) )) / sum(?nrg_100a))*10000)/100.0 as ?share_other

WHERE {
{  
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a.rdf.gz> 
  {
  _:nrg_100a sdmx-dimension:refArea geo:EU28 .
  _: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_101700 .
  _:nrg_100a sdmx-measure:obsValue ?nrg_100a .
  }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_101a.rdf.gz> 
  {
  _:nrg_101a sdmx-dimension:refArea geo:EU28 .
  _: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_101700 .
  _:nrg_101a sdmx-measure:obsValue ?nrg_101a .
  }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_102a.rdf.gz> 
  {
  _:nrg_102a sdmx-dimension:refArea geo:EU28 .
  _: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_101700 .
  _:nrg_102a sdmx-measure:obsValue ?nrg_102a .
  }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_103a.rdf.gz> 
  {
  _:nrg_103a sdmx-dimension:refArea geo:EU28 .
  _:nrg_103a sdmx-attribute:unitMeasure unit:KTOE .
  _:nrg_103a sdmx-dimension:timePeriod ?date .
  _:nrg_103a property:product product:4100 .
  _:nrg_103a property:indic_nrg indic_nrg:B_101700 .
  _:nrg_103a sdmx-measure:obsValue ?nrg_103a .
  }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_105a.rdf.gz> 
  {
  _:nrg_105a sdmx-dimension:refArea geo:EU28 .
  _: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_101700 .
  _:nrg_105a sdmx-measure:obsValue ?nrg_105a .
  }
 }
} 
GROUP BY year(?date)
ORDER BY ?date


Permalinks

Geographic coverage

Temporal coverage

Topics

Topics:

Tags

Filed under:
Filed under: energy
Document Actions