Coal and lignite 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
"Coal and lignite" "-1.74"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.11"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.38"^^<http://www.w3.org/2001/XMLSchema#decimal> "-12.29"^^<http://www.w3.org/2001/XMLSchema#decimal> "-2.18"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 1 rows in 0.001 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/coal-and-lignite-component-in/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
'Coal and lignite' as ?label

round(((bif:power((sum(?coal_and_lignite_2011)/sum(?coal_and_lignite_2005)),(1/6.0)))-1)*10000)/100.0 as ?2005_2011
round((((sum(?coal_and_lignite_2011)/sum(?coal_and_lignite_2010)))-1)*10000)/100.0 as ?2010_2011
round((((sum(?coal_and_lignite_2010)/sum(?coal_and_lignite_2009)))-1)*10000)/100.0 as ?2009_2010
round((((sum(?coal_and_lignite_2009)/sum(?coal_and_lignite_2008)))-1)*10000)/100.0 as ?2008_2009
round(((bif:power((sum(?coal_and_lignite_2011)/sum(?coal_and_lignite_1990)),(1/21.0)))-1)*10000)/100.0 as ?1990_2011

{{

SELECT
year(?date) as ?date
bif:either (year(?date) = 1990, sum(?nrg_101a), 0) as ?coal_and_lignite_1990
bif:either (year(?date) = 2005, sum(?nrg_101a), 0) as ?coal_and_lignite_2005
bif:either (year(?date) = 2008, sum(?nrg_101a), 0) as ?coal_and_lignite_2008
bif:either (year(?date) = 2009, sum(?nrg_101a), 0) as ?coal_and_lignite_2009
bif:either (year(?date) = 2010, sum(?nrg_101a), 0) as ?coal_and_lignite_2010
bif:either (year(?date) = 2011, sum(?nrg_101a), 0) as ?coal_and_lignite_2011

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

}}


Related content

Document Actions