Final energy intensity all sectors (2005=100), EU28

Data table via SPARQL Last modified 18 Jun 2019
Topics: ,

Download this dataset

Dataset preview

(Live Query)

date sector index nrg_bal_c nama_10_gdp
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Total" "100"^^<http://www.w3.org/2001/XMLSchema#decimal> "1123805.047"^^<http://www.w3.org/2001/XMLSchema#decimal> "12284342"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006"^^<http://www.w3.org/2001/XMLSchema#int> "Total" "96.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "1124072.99"^^<http://www.w3.org/2001/XMLSchema#decimal> "12691107.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2007"^^<http://www.w3.org/2001/XMLSchema#int> "Total" "92.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "1102670.379"^^<http://www.w3.org/2001/XMLSchema#decimal> "13083504.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2008"^^<http://www.w3.org/2001/XMLSchema#int> "Total" "92.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "1109796.681"^^<http://www.w3.org/2001/XMLSchema#decimal> "13149166.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009"^^<http://www.w3.org/2001/XMLSchema#int> "Total" "91.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "1057202.334"^^<http://www.w3.org/2001/XMLSchema#decimal> "12580511.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2010"^^<http://www.w3.org/2001/XMLSchema#int> "Total" "93.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "1099535.215"^^<http://www.w3.org/2001/XMLSchema#decimal> "12841529.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "Total" "87.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "1045577.348"^^<http://www.w3.org/2001/XMLSchema#decimal> "13066950.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int> "Total" "87.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "1047086.395"^^<http://www.w3.org/2001/XMLSchema#decimal> "13015403"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> "Total" "87.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "1046949.114"^^<http://www.w3.org/2001/XMLSchema#decimal> "13052055.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2014"^^<http://www.w3.org/2001/XMLSchema#int> "Total" "82.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "1001619.519"^^<http://www.w3.org/2001/XMLSchema#decimal> "13285681.5"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 14 rows in 0.070 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/final-energy-intensity-all-sectors-1/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://semantic7.eea.europa.eu/sparql

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
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 siec: <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/>
PREFIX nrg_bal: <http://dd.eionet.europa.eu/vocabulary/eurostat/nrg_bal/>
PREFIX na_item: <http://dd.eionet.europa.eu/vocabulary/eurostat/na_item/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>

SELECT DISTINCT
year(?date) as ?date
'Total' as ?sector
round(( ( sum(?nrg_bal_c)/ sum(?nama_10_gdp )  ) / ( sum(?nrg_bal_c_idx)/ sum(?nama_10_gdp_idx ) ) )*1000)/10.0 as ?index
sum(?nrg_bal_c) as ?nrg_bal_c
sum(?nama_10_gdp ) as ?nama_10_gdp 
#sum(?nrg_bal_c_idx)
#sum(?nama_10_gdp_idx )

WHERE 
  {{  
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_bal_c.rdf.gz>
    {
      _:nrg_bal_c sdmx-dimension:timePeriod ?date .
      _:nrg_bal_c sdmx-attribute:unitMeasure unit:KTOE .
      _:nrg_bal_c sdmx-dimension:refArea geo:EU28 .
      _:nrg_bal_c property:siec siec:TOTAL .
      _:nrg_bal_c property:nrg_bal nrg_bal:FC_E   .
      _:nrg_bal_c sdmx-measure:obsValue ?nrg_bal_c .

      _:nrg_bal_c_idx sdmx-dimension:timePeriod ?date_idx .
      _:nrg_bal_c_idx sdmx-attribute:unitMeasure unit:KTOE .
      _:nrg_bal_c_idx sdmx-dimension:refArea geo:EU28 .
      _:nrg_bal_c_idx property:siec siec:TOTAL .
      _:nrg_bal_c_idx property:nrg_bal nrg_bal:FC_E .
      _:nrg_bal_c_idx sdmx-measure:obsValue ?nrg_bal_c_idx .
     }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_10_gdp.rdf.gz> 
    {
      _:nama_10_gdp sdmx-dimension:timePeriod ?date . 
      _:nama_10_gdp sdmx-dimension:refArea geo:EU28 . 
      _:nama_10_gdp property:na_item na_item:B1GQ . 
      _:nama_10_gdp sdmx-attribute:unitMeasure unit:CLV10_MEUR . 
      _:nama_10_gdp sdmx-measure:obsValue ?nama_10_gdp .

      _:nama_10_gdp_idx sdmx-dimension:timePeriod ?date_idx . 
      _:nama_10_gdp_idx sdmx-dimension:refArea geo:EU28 . 
      _:nama_10_gdp_idx property:na_item na_item:B1GQ . 
      _:nama_10_gdp_idx sdmx-attribute:unitMeasure unit:CLV10_MEUR . 
      _:nama_10_gdp_idx sdmx-measure:obsValue ?nama_10_gdp_idx .
    } 
  }
  FILTER (year(?date) >= 2005)
  FILTER (year(?date_idx) = 2005)

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


Temporal coverage

Document Actions
Filed under: