Biomass and wastes component in total primary energy consumption by energy source

Data table via SPARQL Published 06 Nov 2013 Last modified 15 Oct 2019
Topics: ,

Download this dataset

Dataset preview

(Live Query)

date biofuels wood__wood_waste biogas msw
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "0.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "89.31"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.49"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.19"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "0.02"^^<http://www.w3.org/2001/XMLSchema#decimal> "89.21"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.55"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.23"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "0.04"^^<http://www.w3.org/2001/XMLSchema#decimal> "88.86"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.79"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.31"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "0.09"^^<http://www.w3.org/2001/XMLSchema#decimal> "89.03"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.86"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.02"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "0.25"^^<http://www.w3.org/2001/XMLSchema#decimal> "88.53"^^<http://www.w3.org/2001/XMLSchema#decimal> "2"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.22"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "0.41"^^<http://www.w3.org/2001/XMLSchema#decimal> "87.57"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.13"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.89"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "0.55"^^<http://www.w3.org/2001/XMLSchema#decimal> "87.12"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.25"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.07"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "0.67"^^<http://www.w3.org/2001/XMLSchema#decimal> "86.62"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.22"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "0.66"^^<http://www.w3.org/2001/XMLSchema#decimal> "86.05"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.64"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.65"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "0.74"^^<http://www.w3.org/2001/XMLSchema#decimal> "84.64"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.92"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.7"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 22 rows in 0.002 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/biomass-and-wastes-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 
year(?date) as ?date
(round((sum(?nrg_1073a))/((sum(?nrg_1071a_5541)+sum(?nrg_1071a_5542)+sum(?nrg_1071a_55431)+sum(?nrg_1071a_55432)+sum(?nrg_1073a)))*10000))/100.0 as ?biofuels
(round((sum(?nrg_1071a_5541))/((sum(?nrg_1071a_5541)+sum(?nrg_1071a_5542)+sum(?nrg_1071a_55431)+sum(?nrg_1071a_55432)+sum(?nrg_1073a)))*10000))/100.0 as ?wood__wood_waste

(round((sum(?nrg_1071a_5542))/((sum(?nrg_1071a_5541)+sum(?nrg_1071a_5542)+sum(?nrg_1071a_55431)+sum(?nrg_1071a_55432)+sum(?nrg_1073a)))*10000))/100.0 as ?biogas

(round(((sum(?nrg_1071a_55431)+sum(?nrg_1071a_55432)))/((sum(?nrg_1071a_5541)+sum(?nrg_1071a_5542)+sum(?nrg_1071a_55431)+sum(?nrg_1071a_55432)+sum(?nrg_1073a)))*10000))/100.0 as ?msw

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

  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_1071a.rdf.gz> 
  {
  _:nrg_1071a property:geo g:EU27 .
  _:nrg_1071a property:unit u:1000TOE .
  _:nrg_1071a sdmx-dimension:timePeriod ?date .
  _:nrg_1071a property:indic_nrg indic_nrg:B_100900 .
  { 
     _:nrg_1071a property:product p:5541 .
     _:nrg_1071a sdmx-measure:obsValue ?nrg_1071a_5541 .
  } UNION {
     _:nrg_1071a property:product p:5542 .
     _:nrg_1071a sdmx-measure:obsValue ?nrg_1071a_5542 .
  }  UNION {
     _:nrg_1071a property:product p:55431 .
     _:nrg_1071a sdmx-measure:obsValue ?nrg_1071a_55431 .
  }  UNION {
     _:nrg_1071a property:product p:55432 .
     _:nrg_1071a sdmx-measure:obsValue ?nrg_1071a_55432 .
  } 
 }
}
} 
GROUP BY year(?date)
ORDER BY ?date

Error when running query:

Query timeout. 


Related content

Document Actions