Data table via SPARQL
Efficiency of conventional thermal power production for district heating, EEA33
Go to latest version
Download this dataset
Dataset preview
(Live Query)
Received 25 rows in 0.032 seconds.
https://www.eea.europa.eu/data-and-maps/daviz/sds/efficiency-of-conventional-thermal-power-5/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.
http://semantic.eea.europa.eu/sparql
PREFIX owl: <http://www.w3.org/2002/07/owl#>
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 property: <http://rdfdata.eionet.europa.eu/eurostat/property#>
PREFIX indic_nrg: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>
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/>
SELECT DISTINCT
year(?date) as ?year
'EEA33' as ?geo
#sum(?nrg_100a_B_101109)
#sum(?nrg_100a_B_101009)
round(( ( sum(?nrg_100a_B_101109) ) / ( sum(?nrg_100a_B_101009) ) )*1000)/10.0 as ?efficiency_rate
WHERE {{
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a.rdf.gz> {
{
_:nrg_100a sdmx-dimension:timePeriod ?date .
_:nrg_100a sdmx-dimension:refArea ?geo .
FILTER (?geo in (geo:EU28, geo:TR, geo:IS, geo:LI, geo:CH, geo:NO))
_:nrg_100a sdmx-attribute:unitMeasure unit:KTOE .
_:nrg_100a property:product product:0000 .
{
_:nrg_100a property:indic_nrg indic_nrg:B_101109 .
_:nrg_100a sdmx-measure:obsValue ?nrg_100a_B_101109 .
} UNION {
_:nrg_100a property:product product:0000 .
_:nrg_100a property:indic_nrg indic_nrg:B_101009 .
_:nrg_100a sdmx-measure:obsValue ?nrg_100a_B_101009 .
}
}}
}}
GROUP BY ?date
ORDER BY ?date
Permalinks
- Permalink to this version
- 368379991e764d439daed2dcb40fac68
- Permalink to latest version
- MAVY618JPF
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/efficiency-of-conventional-thermal-power-5 or scan the QR code.
PDF generated on 08 Feb 2023, 08:07 AM
Document Actions
Share with others