next
previous
items

Data table via SPARQL

Share of renewable energies in GEIC, compared to target in COM(97) 599 final

Data table via SPARQL Published 07 Nov 2013 Last modified 29 Jan 2016
Topics:

Download this dataset

Dataset preview

(Live Query)

country 1990 1995 2000 2005 2009 2010 2011 target order
"European Economic Area (EU-15 plus IS, LI, NO)"@en "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "7"^^<http://www.w3.org/2001/XMLSchema#decimal> "7"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "11"^^<http://www.w3.org/2001/XMLSchema#decimal> "11"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "1"^^<http://www.w3.org/2001/XMLSchema#int>
"European Union (25 countries)"@en "4"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "9"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "1"^^<http://www.w3.org/2001/XMLSchema#int>
"European Union (27 countries)"@en "4"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "9"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "1"^^<http://www.w3.org/2001/XMLSchema#int>
"Euro area (13 countries)"@en "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "9"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "1"^^<http://www.w3.org/2001/XMLSchema#int>
"Euro area (12 countries)"@en "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "9"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "1"^^<http://www.w3.org/2001/XMLSchema#int>
"Euro area (EA11-2000, EA12-2006, EA13-2007, EA15-2008, EA16-2010, EA17)"@en "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "9"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "1"^^<http://www.w3.org/2001/XMLSchema#int>
"Euro area (15 countries)"@en "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "9"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "1"^^<http://www.w3.org/2001/XMLSchema#int>
"European Union (15 countries)"@en "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "9"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "12"^^<http://www.w3.org/2001/XMLSchema#int> "1"^^<http://www.w3.org/2001/XMLSchema#int>
"Euro area (16 countries)"@en "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "9"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "1"^^<http://www.w3.org/2001/XMLSchema#int>
"Euro area (17 countries)"@en "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "9"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "1"^^<http://www.w3.org/2001/XMLSchema#int>

Received 44 rows in 0.002 seconds.


https://eea.europa.eu./data-and-maps/daviz/sds/share-of-eenewable-energies-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
?country
sum(?1990) as ?1990
sum(?1995) as ?1995
sum(?2000) as ?2000
sum(?2005) as ?2005
sum(?2009) as ?2009
sum(?2010) as ?2010
sum(?2011) as ?2011
bif:either (?ugeo in ('EU15', 'SE', 'AT', 'FI', 'PT','DK', 'ES', 'DE', 'IT','IE', 'FR', 'EL', 'IE', 'BE', 'NL', 'UK', 'LU' ), 12, '') as ?target
bif:either (regex(str(?country), "^Eur", "i"), 1, 0) as ?order


{{

SELECT 
bif:either (?ugeo = 'DE', 'Germany', ?country) as ?country
bif:either (year(?date) = 1990, (round((sum(?nrg_1071a_5500)/sum(?nrg_100a))*10000))/100.0, 0) as ?1990
bif:either (year(?date) = 1995, (round((sum(?nrg_1071a_5500)/sum(?nrg_100a))*10000))/100.0, 0) as ?1995
bif:either (year(?date) = 2000, (round((sum(?nrg_1071a_5500)/sum(?nrg_100a))*10000))/100.0, 0) as ?2000
bif:either (year(?date) = 2005, (round((sum(?nrg_1071a_5500)/sum(?nrg_100a))*10000))/100.0, 0) as ?2005
bif:either (year(?date) = 2009, (round((sum(?nrg_1071a_5500)/sum(?nrg_100a))*10000))/100.0, 0) as ?2009
bif:either (year(?date) = 2010, (round((sum(?nrg_1071a_5500)/sum(?nrg_100a))*10000))/100.0, 0) as ?2010
bif:either (year(?date) = 2011, (round((sum(?nrg_1071a_5500)/sum(?nrg_100a))*10000))/100.0, 0) as ?2011
?ugeo 
WHERE {
{  
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a.rdf.gz> 
  {
  _:nrg_100a property:geo ?geo .
  _:nrg_100a property:unit u:1000TOE .
  _:nrg_100a sdmx-dimension:timePeriod ?date .
  _:nrg_100a property:product p:0000 .
  _:nrg_100a property:indic_nrg indic_nrg:B_100900 .
  _:nrg_100a sdmx-measure:obsValue ?nrg_100a .
  } 

  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_1071a.rdf.gz> 
  {
  _:nrg_1071a property:geo ?geo .
  _: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:5500 .
  _:nrg_1071a sdmx-measure:obsValue ?nrg_1071a_5500 .
 }
}
?geo skos:notation ?ugeo . 
?geo skos:prefLabel ?country .
} 
GROUP BY year(?date) ?country ?ugeo
}} 
GROUP BY ?country ?ugeo
ORDER BY desc(?order) desc(?2011) ?country


Permalinks

Geographic coverage

Temporal coverage

Topics

Topics:
Document Actions