Data table via SPARQL
Average annual growth rates for different fuels 2012-2013
Data table via SPARQL
Published 12 Oct 2015
Last modified 26 Aug 2017
This is an old version, kept for reference only.
Go to latest version
Go to latest version
This page was archived on 26 Aug 2017 with reason:
A new version has been published
Download this dataset
Dataset preview
(Live Query)
Received 5 rows in 0.001 seconds.
https://www.eea.europa.eu/data-and-maps/daviz/sds/average-annual-growth-rates-for-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.
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/>
SELECT
?product_label
'2012-2013' as ?period
round((((sum(?2013)/sum(?2012)))-1)*10000)/100.0 as ?value
{{
SELECT
?product_label
bif:either (year(?date) = 2012, sum(?B_100900) - COALESCE(sum(?B_101600),0), 0) as ?2012
bif:either (year(?date) = 2013, sum(?B_100900) - COALESCE(sum(?B_101600),0), 0) as ?2013
WHERE {
{
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a.rdf.gz>
{
_:nrg_100a sdmx-dimension:refArea geo:EU28 .
_:nrg_100a sdmx-attribute:unitMeasure unit:KTOE .
_:nrg_100a sdmx-dimension:timePeriod ?date .
_:nrg_100a property:product ?product .
FILTER (?product in (product:2000, product:3000, product:4000, product:5100, product:5500))
{
_:nrg_100a property:indic_nrg indic_nrg:B_100900 .
_:nrg_100a sdmx-measure:obsValue ?B_100900 .
} UNION {
_:nrg_100a property:indic_nrg indic_nrg:B_101600 .
_:nrg_100a sdmx-measure:obsValue ?B_101600 .
}
}
?product rdfs:label ?product_label .
}
}
GROUP BY ?date ?product_label ?product
}}
ORDER BY ?product_label
Permalinks
- Permalink to this version
- 698b45eddb6b4fcd8b851048aeb8d9d4
- Permalink to latest version
- X7I2KMF38G
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/average-annual-growth-rates-for-2 or scan the QR code.
PDF generated on 18 Jan 2022, 04:57 AM
Document Actions
Share with others