next
previous
items

Data table via SPARQL

Gas component in average annual growth rates for different fuels

Data table via SPARQL Published 07 Nov 2013 Last modified 01 Feb 2016
Topics:

Download this dataset

Dataset preview

(Live Query)

label 2005_2011 2010_2011 2009_2010 2008_2009 1990_2011
"Gas" "-1.61"^^<http://www.w3.org/2001/XMLSchema#decimal> "-9.69"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.61"^^<http://www.w3.org/2001/XMLSchema#decimal> "-6.39"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.46"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 1 rows in 0.001 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/gas-component-in-average-annual/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 skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX g: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>
PREFIX u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX p: <http://rdfdata.eionet.europa.eu/eurostat/dic/product#>
PREFIX indic_nrg: <http://rdfdata.eionet.europa.eu/eurostat/dic/indic_nrg#>

SELECT
'Gas' as ?label

round(((bif:power((sum(?gas_2011)/sum(?gas_2005)),(1/6.0)))-1)*10000)/100.0 as ?2005_2011
round((((sum(?gas_2011)/sum(?gas_2010)))-1)*10000)/100.0 as ?2010_2011
round((((sum(?gas_2010)/sum(?gas_2009)))-1)*10000)/100.0 as ?2009_2010
round((((sum(?gas_2009)/sum(?gas_2008)))-1)*10000)/100.0 as ?2008_2009
round(((bif:power((sum(?gas_2011)/sum(?gas_1990)),(1/21.0)))-1)*10000)/100.0 as ?1990_2011

{{

SELECT
year(?date) as ?date
bif:either (year(?date) = 1990, sum(?nrg_103a), 0) as ?gas_1990
bif:either (year(?date) = 2005, sum(?nrg_103a), 0) as ?gas_2005
bif:either (year(?date) = 2008, sum(?nrg_103a), 0) as ?gas_2008
bif:either (year(?date) = 2009, sum(?nrg_103a), 0) as ?gas_2009
bif:either (year(?date) = 2010, sum(?nrg_103a), 0) as ?gas_2010
bif:either (year(?date) = 2011, sum(?nrg_103a), 0) as ?gas_2011

WHERE {
  {  
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_103a.rdf.gz> 
    {
    _:nrg_103a property:geo g:EU28 .
    _:nrg_103a property:unit u:1000TOE .
    _:nrg_103a sdmx-dimension:timePeriod ?date .
    _:nrg_103a property:product p:4000 .
    _:nrg_103a property:indic_nrg <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/B_100900> .
    _:nrg_103a sdmx-measure:obsValue ?nrg_103a .
    }
  }
}

}}


Permalinks

Geographic coverage

Topics

Topics:
Document Actions