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

SPARQL
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.004 seconds.


http://www.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


Related content

Geographic coverage

Austria, Belgium, Bulgaria, Cyprus, Czechia, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia, Lithuania, Luxembourg, Malta, Netherlands, Poland, Portugal, Romania, Slovakia, Slovenia, Spain, Sweden, United Kingdom
Dynamic

Temporal coverage

1990, 1995, 2000, 2005, 2009-2011

Document Actions
Subscriptions
Sign up to receive our reports (print and/or electronic) and quarterly e-newsletter.
Follow us
 
 
 
 
 
European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100