You are here: Home / Data and maps / Data visualisation / Semantic Data Service (sparql repository) / Trends in total energy intensity, gross domestic product and total energy consumption, EU-27

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

SPARQL
Topics: ,

Download this dataset

Dataset preview

(Live Query)

date total_energy_consumption gross_domestic_product_at_2000_market_prices total_energy_intensity annotation_line

Received 0 rows in 0.000 seconds.


http://www.eea.europa.eu/data-and-maps/daviz/sds/trends-in-total-energy-intensity/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

#http://www.eea.europa.eu/data-and-maps/figures/trends-in-total-energy-intensity-4 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://rdfdata.eionet.europa.eu/eurostat/dic/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) = 2011, '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:EU27 . 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:EU27 . 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:EU27 . _: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:EU27 . _:nrg_100a_idx property:unit u:1000TOE . OPTIONAL { _:nrg_100a_idx sdmx-measure:obsValue ?obsValue_nrg_idx . } }} }} GROUP BY ?date ORDER BY ?date


Geographic coverage

Austria, Belgium, Bulgaria, Cyprus, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia, Lithuania, Luxembourg, Malta, Netherlands, Poland, Portugal, Romania, Slovakia, Slovenia, Spain, Sweden, United Kingdom
Filed under: ,
European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100