next
previous
items

Data table via SPARQL

Final energy intensity of services sector (2005=100), EU28

Data table via SPARQL Published 10 Sep 2018 Last modified 24 Jun 2020
This is an old version, kept for reference only.

Go to latest version
Topics:

Download this dataset

Dataset preview

(Live Query)

date sector index nrg_100a nama_10_a64 nrg_100a_idx nama_10_a64_idx
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Services" "100"^^<http://www.w3.org/2001/XMLSchema#decimal> "153850"^^<http://www.w3.org/2001/XMLSchema#decimal> "7923329.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "153850"^^<http://www.w3.org/2001/XMLSchema#decimal> "7923329.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006"^^<http://www.w3.org/2001/XMLSchema#int> "Services" "99.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "158381.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "8171420.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "153850"^^<http://www.w3.org/2001/XMLSchema#decimal> "7923329.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2007"^^<http://www.w3.org/2001/XMLSchema#int> "Services" "89.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "146435.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "8438090.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "153850"^^<http://www.w3.org/2001/XMLSchema#decimal> "7923329.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2008"^^<http://www.w3.org/2001/XMLSchema#int> "Services" "93.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "155471.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "8548117.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "153850"^^<http://www.w3.org/2001/XMLSchema#decimal> "7923329.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009"^^<http://www.w3.org/2001/XMLSchema#int> "Services" "94.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "153932"^^<http://www.w3.org/2001/XMLSchema#decimal> "8351832.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "153850"^^<http://www.w3.org/2001/XMLSchema#decimal> "7923329.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2010"^^<http://www.w3.org/2001/XMLSchema#int> "Services" "98.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "162426"^^<http://www.w3.org/2001/XMLSchema#decimal> "8454822"^^<http://www.w3.org/2001/XMLSchema#decimal> "153850"^^<http://www.w3.org/2001/XMLSchema#decimal> "7923329.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "Services" "90.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "150404.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "8598981.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "153850"^^<http://www.w3.org/2001/XMLSchema#decimal> "7923329.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int> "Services" "91.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "153414.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "8642950.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "153850"^^<http://www.w3.org/2001/XMLSchema#decimal> "7923329.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> "Services" "91.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "154369.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "8701509.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "153850"^^<http://www.w3.org/2001/XMLSchema#decimal> "7923329.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2014"^^<http://www.w3.org/2001/XMLSchema#int> "Services" "84.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "144959.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "8845462.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "153850"^^<http://www.w3.org/2001/XMLSchema#decimal> "7923329.5"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 12 rows in 0.002 seconds.


https://eea.europa.eu./data-and-maps/daviz/sds/final-energy-intensity-of-services-3/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



http://semantic.eea.europa.eu/sparql

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
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 skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX product: <http://dd.eionet.europa.eu/vocabulary/eurostat/product/>
PREFIX indic_nrg: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>
PREFIX na_item: <http://dd.eionet.europa.eu/vocabulary/eurostat/na_item/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>

SELECT DISTINCT
year(?date) as ?date
'Services' as ?sector
round(( ( sum(?nrg_100a)/ sum(?nama_10_a64)  ) / ( sum(?nrg_100a_idx)/ sum(?nama_10_a64_idx) ) )*1000)/10.0 as ?index
sum(?nrg_100a) as ?nrg_100a
sum(?nama_10_a64) as ?nama_10_a64
sum(?nrg_100a_idx) as ?nrg_100a_idx

sum(?nama_10_a64_idx) as ?nama_10_a64_idx


WHERE 
  {{  
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a.rdf.gz> 
    {
      _:nrg_100a sdmx-dimension:timePeriod ?date .
      _:nrg_100a sdmx-attribute:unitMeasure unit:KTOE .
      _:nrg_100a sdmx-dimension:refArea geo:EU28 .
      _:nrg_100a property:product product:0000 .
      _:nrg_100a property:indic_nrg ?indic_nrg  .
      _:nrg_100a sdmx-measure:obsValue ?nrg_100a .

      _:nrg_100a_idx sdmx-dimension:timePeriod ?date_idx .
      _:nrg_100a_idx sdmx-attribute:unitMeasure unit:KTOE .
      _:nrg_100a_idx sdmx-dimension:refArea geo:EU28 .
      _:nrg_100a_idx property:product product:0000 .
      _:nrg_100a_idx property:indic_nrg ?indic_nrg  .
      _:nrg_100a_idx sdmx-measure:obsValue ?nrg_100a_idx .
      FILTER (?indic_nrg in (indic_nrg:B_102035, indic_nrg:B_102040))
    }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_10_a64.rdf.gz> 
    {
      _:nama_10_a64 sdmx-dimension:timePeriod ?date . 
      _:nama_10_a64 property:na_item na_item:B1G . 
      _:nama_10_a64 sdmx-dimension:refArea geo:EU28 . 
      _:nama_10_a64 property:nace_r2 ?nace_r2 . 
      _:nama_10_a64 sdmx-attribute:unitMeasure unit:CLV10_MEUR . 
      _:nama_10_a64 sdmx-measure:obsValue ?nama_10_a64 .

      _:nama_10_a64_idx sdmx-dimension:timePeriod ?date_idx . 
      _:nama_10_a64_idx property:na_item na_item:B1G . 
      _:nama_10_a64_idx sdmx-dimension:refArea geo:EU28 . 
      _:nama_10_a64_idx property:nace_r2 ?nace_r2 . 
      _:nama_10_a64_idx sdmx-attribute:unitMeasure unit:CLV10_MEUR . 
      _:nama_10_a64_idx sdmx-measure:obsValue ?nama_10_a64_idx .

      FILTER (?nace_r2 in (nace_r2:G-I, nace_r2:J, nace_r2:K, nace_r2:L, 
                           nace_r2:M_N, nace_r2:O-Q, nace_r2:R-U))
    } 
  }
  FILTER (year(?date) >= 2005)
  FILTER (year(?date_idx) = 2005)
} 

GROUP BY year(?date)
ORDER BY ?date


Permalinks

Geographic coverage

Temporal coverage

Topics

Topics:

Tags

Filed under:
Filed under: services, energy intensity
Document Actions