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

Data table via SPARQL
Topics: ,
Used for CSI 028/ENER 017

Download this dataset

Dataset preview

(Live Query)

date total_energy_consumption gross_domestic_product_at_2000_market_prices total_energy_intensity annotation_line
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "99.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" ""
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "99.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" ""
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "97.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" ""
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "97.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" ""
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "97.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" ""
"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> "104.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "97.8"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "103.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "107.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "95.7"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "102.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "111"^^<http://www.w3.org/2001/XMLSchema#decimal> "92.3"^^<http://www.w3.org/2001/XMLSchema#decimal> ""

Received 26 rows in 0.058 seconds.


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

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(?obsValue_nrg > 0, '',1000000) 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 {{
    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 >= "1990-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 . }
    _: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 . }
    }}
  } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_gdp_k.rdf.gz> { 
    {
    _:nama_gdp_k sdmx-dimension:timePeriod ?date FILTER (?date >= "1990-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:EU27 . 
    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:EU27 . 
    OPTIONAL { _:nama_gdp_k_idx sdmx-measure:obsValue ?obsValue_gdp_idx . }
    }}
  }} 
}}  GROUP BY ?date ORDER BY ?date

Error when running query:

unknown url type: semantic.eea.europa.eu/sparql


Related content

Geographic coverage

Austria, Belgium, Bulgaria, 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: , ,
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