Data table via SPARQL

Trends in total energy intensity, gross domestic product and total energy consumption, EU-28

Data table via SPARQL Published 25 Aug 2014 Last modified 19 Apr 2016

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

date	total_energy_consumption	gross_domestic_product_at_2000_market_prices	total_energy_intensity	annotation_line
"1995"^^<http://www.w3.org/2001/XMLSchema#int>	"100"^^<http://www.w3.org/2001/XMLSchema#decimal>	"100"^^<http://www.w3.org/2001/XMLSchema#decimal>	"100"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"1996"^^<http://www.w3.org/2001/XMLSchema#int>	"103.5"^^<http://www.w3.org/2001/XMLSchema#decimal>	"101.9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"101.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"1997"^^<http://www.w3.org/2001/XMLSchema#int>	"102.7"^^<http://www.w3.org/2001/XMLSchema#decimal>	"104.8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"98"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"1998"^^<http://www.w3.org/2001/XMLSchema#int>	"103.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"107.9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"95.8"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"1999"^^<http://www.w3.org/2001/XMLSchema#int>	"102.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	"111"^^<http://www.w3.org/2001/XMLSchema#decimal>	"92.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"2000"^^<http://www.w3.org/2001/XMLSchema#int>	"103.3"^^<http://www.w3.org/2001/XMLSchema#decimal>	"115.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"89.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"2001"^^<http://www.w3.org/2001/XMLSchema#int>	"105.7"^^<http://www.w3.org/2001/XMLSchema#decimal>	"117.7"^^<http://www.w3.org/2001/XMLSchema#decimal>	"89.8"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"2002"^^<http://www.w3.org/2001/XMLSchema#int>	"105.3"^^<http://www.w3.org/2001/XMLSchema#decimal>	"119.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"88.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"2003"^^<http://www.w3.org/2001/XMLSchema#int>	"107.5"^^<http://www.w3.org/2001/XMLSchema#decimal>	"121"^^<http://www.w3.org/2001/XMLSchema#decimal>	"88.9"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"2004"^^<http://www.w3.org/2001/XMLSchema#int>	"108.8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"124.1"^^<http://www.w3.org/2001/XMLSchema#decimal>	"87.7"^^<http://www.w3.org/2001/XMLSchema#decimal>	""

Received 19 rows in 0.001 seconds.

JSON Url:
https://eea.europa.eu./data-and-maps/daviz/sds/trends-in-total-energy-intensity-4/daviz.json

For system integrators

Linked Data query (SPARQL)

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

SPARQL Endpoint:
semantic.eea.europa.eu/sparql

SPARQL Query:


        PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX sdmx-unit: <http://purl.org/linked-data/sdmx/2009/code#>
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX i_na: <http://rdfdata.eionet.europa.eu/eurostat/dic/indic_na#> 
PREFIX i_ng: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>
PREFIX u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX geo: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>

SELECT 
year(?date) as ?date
(round((?obsValue_nrg/?obsValue_nrg_idx)*1000))/10.0 as ?total_energy_consumption
(round((?obsValue_gdp/?obsValue_gdp_idx)*1000))/10.0 as ?gross_domestic_product_at_2000_market_prices
(round(((?obsValue_nrg/(?obsValue_gdp/1000))/(?obsValue_nrg_idx/(?obsValue_gdp_idx/1000)))*1000))/10.0 as ?total_energy_intensity
#GDP Forecast - Annotation Line
bif:either(year(?date) = 2013, 'GDP Forecast','') AS ?annotation_line
{{
  SELECT
    ?date
    sum(?obsValue_nrg) as ?obsValue_nrg
    sum(?obsValue_gdp) as ?obsValue_gdp
    sum(?obsValue_nrg_idx) as ?obsValue_nrg_idx
    sum(?obsValue_gdp_idx) as ?obsValue_gdp_idx
  WHERE {
    { 
    _:nama_gdp_k qb:dataSet <http://rdfdata.eionet.europa.eu/eurostat/data/nama_gdp_k> .
    _:nama_gdp_k sdmx-dimension:timePeriod ?date FILTER (?date >= "1995-01-01"^^xsd:date) 
    _:nama_gdp_k property:indic_na i_na:B1GM . 
    _:nama_gdp_k property:unit u:MIO_EUR_CLV2000 . 
    _:nama_gdp_k property:geo geo:EU28 . 
    OPTIONAL { _:nama_gdp_k sdmx-measure:obsValue ?obsValue_gdp . }
    #index value on 1995
    _:nama_gdp_k_idx qb:dataSet <http://rdfdata.eionet.europa.eu/eurostat/data/nama_gdp_k> .
    _:nama_gdp_k_idx sdmx-dimension:timePeriod ?date_gdp_idx FILTER (?date_gdp_idx = "1995-01-01"^^xsd:date)
    _:nama_gdp_k_idx property:indic_na i_na:B1GM . 
    _:nama_gdp_k_idx property:unit u:MIO_EUR_CLV2000 . 
    _:nama_gdp_k_idx property:geo geo:EU28 . 
    OPTIONAL { _:nama_gdp_k_idx sdmx-measure:obsValue ?obsValue_gdp_idx . }
    } UNION {
    _:nrg_100a qb:dataSet <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a> .
    _:nrg_100a sdmx-dimension:freq sdmx-unit:freq-A . 
    _:nrg_100a sdmx-dimension:timePeriod ?date FILTER (?date >= "1995-01-01"^^xsd:date) 
    _:nrg_100a property:indic_nrg i_ng:B_100900 . 
    _:nrg_100a property:geo geo:EU28 . 
    _:nrg_100a property:unit u:1000TOE . 
    OPTIONAL { _:nrg_100a sdmx-measure:obsValue ?obsValue_nrg . }
    #index value on 1995
    _:nrg_100a_idx qb:dataSet <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a> . 
    _:nrg_100a_idx sdmx-dimension:freq sdmx-unit:freq-A . 
    _:nrg_100a_idx sdmx-dimension:timePeriod ?date_nrg_idx FILTER (?date_nrg_idx = "1995-01-01"^^xsd:date) 
    _:nrg_100a_idx property:indic_nrg i_ng:B_100900 . 
    _:nrg_100a_idx property:geo geo:EU28 . 
    _:nrg_100a_idx property:unit u:1000TOE . 
    OPTIONAL { _:nrg_100a_idx sdmx-measure:obsValue ?obsValue_nrg_idx . }
  }}
}} GROUP BY ?date ORDER BY ?date