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

Data table via SPARQL
Topics: ,

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.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "102.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "101"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "102.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "105.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "97.4"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "103.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "108.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "95.2"^^<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.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "91.8"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "103.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "116.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "88.9"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "105.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "118.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "89.1"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2002"^^<http://www.w3.org/2001/XMLSchema#int> "105.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "120.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "87.7"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2003"^^<http://www.w3.org/2001/XMLSchema#int> "107.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "121.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "88.2"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "108.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "125"^^<http://www.w3.org/2001/XMLSchema#decimal> "87"^^<http://www.w3.org/2001/XMLSchema#decimal> ""

Received 19 rows in 0.078 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 sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#> 
PREFIX sdmx-unit: <http://purl.org/linked-data/sdmx/2009/code#>
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX indic_na: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_na/> 
PREFIX indic_nrg: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/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:timePeriod ?date FILTER (year(?date) >= 1995) 
    _:nrg_100a property:indic_nrg indic_nrg:B_100900 . 
    _:nrg_100a sdmx-dimension:refArea ?geo . 
    _:nrg_100a sdmx-attribute:unitMeasure unit:KTOE . 
    _:nrg_100a sdmx-measure:obsValue ?obsValue_nrg .

    _:nrg_100a_idx sdmx-dimension:timePeriod ?date_nrg_idx FILTER (year(?date_nrg_idx) = 1995) 
    _:nrg_100a_idx property:indic_nrg indic_nrg:B_100900 . 
    _:nrg_100a_idx sdmx-dimension:refArea ?geo . 
    _:nrg_100a_idx sdmx-attribute:unitMeasure unit:KTOE . 
    _: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 (year(?date) >= 1995) 
    _:nama_gdp_k property:indic_na indic_na:B1GM . 
    _:nama_gdp_k sdmx-attribute:unitMeasure unit:MIO_EUR_CLV2005 . 
    _:nama_gdp_k sdmx-dimension:refArea ?geo . 
    _:nama_gdp_k sdmx-measure:obsValue ?obsValue_gdp .   
 
    _:nama_gdp_k_idx sdmx-dimension:timePeriod ?date_gdp_idx FILTER (year(?date_gdp_idx) = 1995)
    _:nama_gdp_k_idx property:indic_na indic_na:B1GM . 
    _:nama_gdp_k_idx sdmx-attribute:unitMeasure unit:MIO_EUR_CLV2005 . 
    _:nama_gdp_k_idx sdmx-dimension:refArea ?geo . 
    _: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

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