Personal tools

next
previous
items

Skip to content. | Skip to navigation

Sound and independent information
on the environment

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

Trends in total energy intensity, gross domestic product and total energy consumption

Topics: ,
Used for CSI 028/ENER 017

Download this dataset

Dataset preview

(Live Query)

date total_energy_consumption gross_domestic_product_at_2005_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.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "101.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "101.5"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "102.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "105.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "97.6"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "103.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "108.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "95.4"^^<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.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "92"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "103.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "115.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "89.2"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "105.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "118.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "89.4"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2002"^^<http://www.w3.org/2001/XMLSchema#int> "105.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "119.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "88.1"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2003"^^<http://www.w3.org/2001/XMLSchema#int> "107.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "121.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "88.8"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "109.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "124.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "87.6"^^<http://www.w3.org/2001/XMLSchema#decimal> ""

Received 20 rows in 0.000 seconds.


http://www.eea.europa.eu/data-and-maps/daviz/sds/trends-in-total-energy-intensity-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 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#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> 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_2005_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) > 2010, 1000000,'') AS ?annotation_line {{ SELECT ?date #?geo #?memberOfcode #?country 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 {{ GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a.rdf.gz> { { _: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 . _:nrg_100a property:unit u:1000TOE . OPTIONAL { _:nrg_100a sdmx-measure:obsValue ?obsValue_nrg . } _: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 . _:nrg_100a_idx property:unit u:1000TOE . OPTIONAL { _:nrg_100a_idx sdmx-measure:obsValue ?obsValue_nrg_idx . } }} } UNION { GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_gdp_k.rdf.gz> { { _: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_CLV2005 . _:nama_gdp_k property:geo ?geo . OPTIONAL { _:nama_gdp_k sdmx-measure:obsValue ?obsValue_gdp . } _: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_CLV2005 . _:nama_gdp_k_idx property:geo ?geo . OPTIONAL { _:nama_gdp_k_idx sdmx-measure:obsValue ?obsValue_gdp_idx . } } } } ?geo skos:prefLabel ?country . ?geo skos:notation ?ugeo . ?eeageo owl:sameAs ?geo . ?eeageo skos:inScheme <http://rdfdata.eionet.europa.eu/eea/countries/> . ?memberOf skos:member ?eeageo . ?memberOf skos:notation ?memberOfcode . FILTER (?memberOfcode = 'EU28') } }} GROUP BY ?date ORDER BY ?date


Related content

Geographic coverage

Austria Belgium Bulgaria Croatia Cyprus Czechia Denmark Estonia Finland France Germany Greece Hungary Ireland Italy Latvia Lithuania Luxembourg Malta Netherlands Poland Portugal Romania Slovakia Slovenia Spain Sweden United Kingdom
Document Actions
Filed under: , ,

Comments

Subscriptions
Sign up to receive our reports (print and/or electronic) and quarterly e-newsletter.
Follow us
 
 
 
 
 
European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100