next
previous
items

Data table via SPARQL

Primary energy consumption by fuel

Data table via SPARQL Published 16 Sep 2014 Last modified 01 Feb 2016
Topics:

Download this dataset

Dataset preview

(Live Query)

year all_products solid_fuels total_petroleum_products gas nuclear_heat renewable_energies others electrical_energy derived_heat industrial_wastes
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "1667"^^<http://www.w3.org/2001/XMLSchema#decimal> "455"^^<http://www.w3.org/2001/XMLSchema#decimal> "630"^^<http://www.w3.org/2001/XMLSchema#decimal> "298"^^<http://www.w3.org/2001/XMLSchema#decimal> "205"^^<http://www.w3.org/2001/XMLSchema#decimal> "71"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "4"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "1669"^^<http://www.w3.org/2001/XMLSchema#decimal> "434"^^<http://www.w3.org/2001/XMLSchema#decimal> "637"^^<http://www.w3.org/2001/XMLSchema#decimal> "307"^^<http://www.w3.org/2001/XMLSchema#decimal> "212"^^<http://www.w3.org/2001/XMLSchema#decimal> "74"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "1637"^^<http://www.w3.org/2001/XMLSchema#decimal> "404"^^<http://www.w3.org/2001/XMLSchema#decimal> "638"^^<http://www.w3.org/2001/XMLSchema#decimal> "299"^^<http://www.w3.org/2001/XMLSchema#decimal> "213"^^<http://www.w3.org/2001/XMLSchema#decimal> "76"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "1638"^^<http://www.w3.org/2001/XMLSchema#decimal> "380"^^<http://www.w3.org/2001/XMLSchema#decimal> "639"^^<http://www.w3.org/2001/XMLSchema#decimal> "310"^^<http://www.w3.org/2001/XMLSchema#decimal> "222"^^<http://www.w3.org/2001/XMLSchema#decimal> "80"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "1631"^^<http://www.w3.org/2001/XMLSchema#decimal> "370"^^<http://www.w3.org/2001/XMLSchema#decimal> "641"^^<http://www.w3.org/2001/XMLSchema#decimal> "310"^^<http://www.w3.org/2001/XMLSchema#decimal> "222"^^<http://www.w3.org/2001/XMLSchema#decimal> "81"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "1671"^^<http://www.w3.org/2001/XMLSchema#decimal> "365"^^<http://www.w3.org/2001/XMLSchema#decimal> "652"^^<http://www.w3.org/2001/XMLSchema#decimal> "336"^^<http://www.w3.org/2001/XMLSchema#decimal> "227"^^<http://www.w3.org/2001/XMLSchema#decimal> "83"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "1729"^^<http://www.w3.org/2001/XMLSchema#decimal> "362"^^<http://www.w3.org/2001/XMLSchema#decimal> "665"^^<http://www.w3.org/2001/XMLSchema#decimal> "370"^^<http://www.w3.org/2001/XMLSchema#decimal> "239"^^<http://www.w3.org/2001/XMLSchema#decimal> "87"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "1716"^^<http://www.w3.org/2001/XMLSchema#decimal> "349"^^<http://www.w3.org/2001/XMLSchema#decimal> "665"^^<http://www.w3.org/2001/XMLSchema#decimal> "362"^^<http://www.w3.org/2001/XMLSchema#decimal> "242"^^<http://www.w3.org/2001/XMLSchema#decimal> "91"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "1727"^^<http://www.w3.org/2001/XMLSchema#decimal> "333"^^<http://www.w3.org/2001/XMLSchema#decimal> "681"^^<http://www.w3.org/2001/XMLSchema#decimal> "374"^^<http://www.w3.org/2001/XMLSchema#decimal> "241"^^<http://www.w3.org/2001/XMLSchema#decimal> "93"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "1715"^^<http://www.w3.org/2001/XMLSchema#decimal> "313"^^<http://www.w3.org/2001/XMLSchema#decimal> "672"^^<http://www.w3.org/2001/XMLSchema#decimal> "385"^^<http://www.w3.org/2001/XMLSchema#decimal> "243"^^<http://www.w3.org/2001/XMLSchema#decimal> "93"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> ""

Received 23 rows in 0.024 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/primary-energy-consumption-by-fuel-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



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 indic_nrg: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX product:	<http://dd.eionet.europa.eu/vocabulary/eurostat/product/>

SELECT 
year(?date) as ?year
round(sum(?all_products)/1000) as ?all_products
round(sum(?solid_fuels)/1000)  as ?solid_fuels
round(sum(?total_petroleum_products)/1000) as ?total_petroleum_products
round(sum(?gas)/1000) as ?gas
round(sum(?nuclear_heat)/1000) as ?nuclear_heat
round(sum(?renewable_energies)/1000) as ?renewable_energies
round((sum(?electrical_energy)+sum(?derived_heat)+sum(?industrial_wastes))/1000) as ?others

round(sum(?electrical_energy)/1000) as ?electrical_energy
round(sum(?derived_heat)/1000) as ?derived_heat
round(sum(?industrial_wastes)/1000) as ?industrial_wastes

WHERE {
{  
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a.rdf.gz> 
  {
  _:nrg_100a sdmx-dimension:timePeriod ?date . 
  _:nrg_100a property:indic_nrg indic_nrg:B_100900 . 
  _:nrg_100a sdmx-dimension:refArea geo:EU28 . 
  _:nrg_100a sdmx-attribute:unitMeasure unit:1000TOE . 

  {
    _:nrg_100a property:product product:0000 . 
    _:nrg_100a sdmx-measure:obsValue ?all_products .
  } UNION {
    _:nrg_100a property:product product:2000 . 
    _:nrg_100a sdmx-measure:obsValue ?solid_fuels .
  } UNION {
    _:nrg_100a property:product product:3000 . 
    _:nrg_100a sdmx-measure:obsValue ?total_petroleum_products .
  } UNION {
    _:nrg_100a property:product product:4000 . 
    _:nrg_100a sdmx-measure:obsValue ?gas .
  } UNION {
    _:nrg_100a property:product product:5100 . 
    _:nrg_100a sdmx-measure:obsValue ?nuclear_heat .
  } UNION {
    _:nrg_100a property:product product:6000 . 
    _:nrg_100a sdmx-measure:obsValue ?electrical_energy .
  } UNION {
    _:nrg_100a property:product product:5200 . 
    _:nrg_100a sdmx-measure:obsValue ?derived_heat .
  } UNION {
    _:nrg_100a property:product product:5500 . 
    _:nrg_100a sdmx-measure:obsValue ?renewable_energies .
  }
  } 

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

} 
GROUP BY year(?date)
ORDER BY ?date


Permalinks

Geographic coverage

Topics

Topics:
Document Actions