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

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.001 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

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: , ,
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