Personal tools

Notifications
Get notifications on new reports and products. Frequency: 3-4 emails / month.
Subscriptions
Sign up to receive our reports (print and/or electronic) and quarterly e-newsletter.
Follow us
Twitter icon Twitter
Facebook icon Facebook
YouTube icon YouTube channel
RSS logo RSS Feeds
More

Write to us Write to us

For the public:


For media and journalists:

Contact EEA staff
Contact the web team
FAQ

Call us Call us

Reception:

Phone: (+45) 33 36 71 00
Fax: (+45) 33 36 71 99


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

Document Actions
Filed under: , ,

Comments

Sign up now!
Get notifications on new reports and products. Currently we have 33017 subscribers. Frequency: 3-4 emails / month.
Notifications archive
Follow us
 
 
 
 
 
European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100