next
previous
items

Data table via SPARQL

Average efficiency of the electric sector in EEA33 (without pumped hydro)

Data table via SPARQL Published 21 Oct 2015 Last modified 19 Apr 2016

Download this dataset

Dataset preview

(Live Query)

date ugeo energy efficency el_energy total_el_energy
"2013"^^<http://www.w3.org/2001/XMLSchema#int> "EEA33" "702583.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "44.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "312690.066"^^<http://www.w3.org/2001/XMLSchema#decimal> "312690.066"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 1 rows in 0.001 seconds.


https://eea.europa.eu./data-and-maps/daviz/sds/average-efficiency-of-the-electric-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



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 indic_nrg: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>
PREFIX product: <http://dd.eionet.europa.eu/vocabulary/eurostat/product/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>

SELECT DISTINCT
year(?date) as ?date
'EEA33' as ?ugeo 
sum(?energy) as ?energy
round(( ( sum(?el_energy)*86/1000 + ( ( sum(?total_el_energy) - sum(?el_energy) ) *86/1000 ) ) / sum(?energy) )*1000)/10.0 AS ?efficency
( sum(?el_energy)*86/1000 + ( ( sum(?total_el_energy) - sum(?el_energy) ) *86/1000 ) ) as ?el_energy
sum(?total_el_energy)*86/1000 as ?total_el_energy


WHERE {
{  
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a.rdf.gz> 
  { 
    _:nrg_100a sdmx-dimension:timePeriod ?date . FILTER (year(?date) in (2013))
    _:nrg_100a sdmx-attribute:unitMeasure unit:KTOE .
    _:nrg_100a sdmx-dimension:refArea ?geo .
    {
      _:nrg_100a property:product ?product . FILTER (?product in (product:2000, product:3000 , product:4000 , product:5500))
      _:nrg_100a property:indic_nrg ?indic_nrg . FILTER (?indic_nrg in (indic_nrg:B_101001))
    } UNION {
      _:nrg_100a property:product ?product . FILTER (?product in (product:5100))
      _:nrg_100a property:indic_nrg ?indic_nrg . FILTER (?indic_nrg in (indic_nrg:B_100100))
    } UNION {
      _:nrg_100a property:product ?product . FILTER (?product in (product:6000))
      _:nrg_100a property:indic_nrg ?indic_nrg . FILTER (?indic_nrg in (indic_nrg:15_107036, indic_nrg:15_107037))
    }
    _:nrg_100a sdmx-measure:obsValue ?energy .
  }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_107a.rdf.gz> 
    { 
     _:nrg_107a sdmx-dimension:timePeriod ?date . FILTER (year(?date) in (2013))
     _:nrg_107a sdmx-attribute:unitMeasure unit:KTOE .
     _:nrg_107a sdmx-dimension:refArea ?geo .
      _:nrg_107a property:product ?product . FILTER (?product in (product:5510, product:5520))
     _:nrg_107a property:indic_nrg ?indic_nrg . FILTER (?indic_nrg in (indic_nrg:B_100100))
      _:nrg_107a sdmx-measure:obsValue ?energy .
   } 
 } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_105a.rdf.gz> 
    { 
     _:nrg_105a sdmx-dimension:timePeriod ?date . FILTER (year(?date) in (2013))
     _:nrg_105a sdmx-attribute:unitMeasure unit:GWH .
     _:nrg_105a sdmx-dimension:refArea ?geo .
     _:nrg_105a property:product ?product . FILTER (?product in (product:6000))
     { 
       _:nrg_105a property:indic_nrg ?indic_nrg . 
       FILTER (?indic_nrg in (indic_nrg:22_108701, indic_nrg:22_108702, indic_nrg:22_108703, indic_nrg:22_108704, indic_nrg:22_108711, indic_nrg:22_108712, indic_nrg:22_108713, indic_nrg:22_108714, indic_nrg:22_108721, indic_nrg:22_108722, indic_nrg:22_108723, indic_nrg:22_108724, indic_nrg:22_108731, indic_nrg:22_108732, indic_nrg:22_108733, indic_nrg:22_108734, indic_nrg:22_108741, indic_nrg:22_108742, indic_nrg:22_108743, indic_nrg:22_108744, indic_nrg:22_108751, indic_nrg:22_108752, indic_nrg:22_108753, indic_nrg:22_108754, indic_nrg:22_108761, indic_nrg:22_108762, indic_nrg:22_108763, indic_nrg:22_108764, indic_nrg:22_108771, indic_nrg:22_108772, indic_nrg:22_108773, indic_nrg:22_108774, indic_nrg:22_108781, indic_nrg:22_108782, indic_nrg:22_108783, indic_nrg:22_108784, indic_nrg:22_108791, indic_nrg:22_108792, indic_nrg:22_108793, indic_nrg:22_108794, indic_nrg:22_108801, indic_nrg:22_108802, indic_nrg:22_108803, indic_nrg:22_108804, indic_nrg:22_108811, indic_nrg:22_108812, indic_nrg:22_108813, indic_nrg:22_108814, indic_nrg:22_108501,indic_nrg:22_108502,indic_nrg:22_108503,indic_nrg:22_108504,indic_nrg:22_108511,indic_nrg:22_108512,indic_nrg:22_108513,indic_nrg:22_108514,indic_nrg:22_108521,indic_nrg:22_108522,indic_nrg:22_108523,indic_nrg:22_108524,indic_nrg:22_108531,indic_nrg:22_108532,indic_nrg:22_108533,indic_nrg:22_108534,indic_nrg:22_108541,indic_nrg:22_108542,indic_nrg:22_108543,indic_nrg:22_108544,indic_nrg:22_108551,indic_nrg:22_108552,indic_nrg:22_108553,indic_nrg:22_108554,indic_nrg:22_108561,indic_nrg:22_108562,indic_nrg:22_108563,indic_nrg:22_108564,indic_nrg:22_108571,indic_nrg:22_108572,indic_nrg:22_108573,indic_nrg:22_108574,indic_nrg:22_108581,indic_nrg:22_108582,indic_nrg:22_108583,indic_nrg:22_108584,indic_nrg:22_108591,indic_nrg:22_108592,indic_nrg:22_108593,indic_nrg:22_108594,indic_nrg:22_108601,indic_nrg:22_108602,indic_nrg:22_108603,indic_nrg:22_108604,indic_nrg:22_108891,indic_nrg:22_108892,indic_nrg:22_108893,indic_nrg:22_108894,indic_nrg:22_108611,indic_nrg:22_108612,indic_nrg:22_108613,indic_nrg:22_108614,indic_nrg:22_108621,indic_nrg:22_108622,indic_nrg:22_108623,indic_nrg:22_108624,indic_nrg:22_108631,indic_nrg:22_108632,indic_nrg:22_108633,indic_nrg:22_108634,indic_nrg:22_108641,indic_nrg:22_108642,indic_nrg:22_108643,indic_nrg:22_108644,indic_nrg:15_107030,indic_nrg:15_107031,indic_nrg:15_107032,indic_nrg:15_107033,indic_nrg:15_107034,indic_nrg:15_107035,indic_nrg:14_1070421,indic_nrg:14_1070422,indic_nrg:14_1070431,indic_nrg:14_1070432,indic_nrg:15_107046,indic_nrg:15_107047,indic_nrg:22_108911,indic_nrg:22_108912,indic_nrg:22_108913,indic_nrg:22_108914,indic_nrg:22_108931,indic_nrg:22_108932,indic_nrg:22_108933,indic_nrg:22_108934,indic_nrg:22_108941,indic_nrg:22_108942,indic_nrg:22_108943,indic_nrg:22_108944,indic_nrg:22_108951,indic_nrg:22_108952,indic_nrg:22_108953,indic_nrg:22_108954,indic_nrg:22_108971,indic_nrg:22_108972,indic_nrg:22_108973,indic_nrg:22_108974,indic_nrg:15_107038,indic_nrg:15_107039,indic_nrg:15_107040,indic_nrg:15_107041,indic_nrg:15_107045,indic_nrg:15_107045))
       _:nrg_105a sdmx-measure:obsValue ?el_energy .
     } UNION {
       _:nrg_105a property:indic_nrg ?indic_nrg . FILTER (?indic_nrg in (indic_nrg:17_107000))
       _:nrg_105a sdmx-measure:obsValue ?total_el_energy .
     }
   } 
  }
?geo rdfs:label ?ugeo . FILTER (?geo in (geo:EU28, geo:IS, geo:TR, geo:NO, geo:CH, geo:LI))
}
GROUP BY ?date


Permalinks

Document Actions