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
Download this dataset
Dataset preview
(Live Query)
Received 19 rows in 0.025 seconds.
https://www.eea.europa.eu/data-and-maps/daviz/sds/trends-in-total-energy-intensity-4/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.
semantic.eea.europa.eu/sparql
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
Permalinks
- Permalink to this version
- 1404ae72d9774690ab092ade3605c289
- Permalink to latest version
- I95HYKZN70
Older versions
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/trends-in-total-energy-intensity-4 or scan the QR code.
PDF generated on 25 May 2022, 04:13 PM
Document Actions
Share with others