Data table via SPARQL

Share of renewable energy

Data table via SPARQL Published 22 Jul 2019 Last modified 24 Jun 2020

30 min read

This is an old version, kept for reference only.

Go to latest version

Topics: Energy

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

date	ugeo	obsValue
"2004"^^<http://www.w3.org/2001/XMLSchema#int>	"Estonia"	"0.181"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int>	"Italy"	"1.213"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int>	"Lithuania"	"0.41"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int>	"Portugal"	"0.424"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int>	"Germany"	"2.212"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int>	"France"	"1.475"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int>	"Ireland"	"0.04"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int>	"Slovenia"	"0.85"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int>	"Hungary"	"0.917"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int>	"Malta"	"0"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 517 rows in 0.042 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/share-of-renewable-energy-4/daviz.json

For system integrators

Linked Data query (SPARQL)

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

SPARQL Endpoint:
http://semantic.eea.europa.eu/sparql

SPARQL Query:


        PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX nrg_bal: <http://dd.eionet.europa.eu/vocabulary/eurostat/nrg_bal/>
PREFIX common_countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>

SELECT DISTINCT

year(?date) as ?date
#bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
?ugeo
?obsValue 

WHERE {
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_ind_ren.rdf.gz> 
 { 
    _:nrg_ind_ren sdmx-dimension:timePeriod ?date .
    
    _:nrg_ind_ren sdmx-dimension:refArea ?geo .
    _:nrg_ind_ren sdmx-attribute:unitMeasure unit:PC .
    _:nrg_ind_ren sdmx-measure:obsValue ?obsValue .

    _:nrg_ind_ren property:nrg_bal nrg_bal:REN_TRA .
       _:nrg_ind_ren sdmx-measure:obsValue ?obsValue .

 }

 ?geo skos:exactMatch ?eeauri .
 ?eeauri skos:inScheme common_countries: .
 ?eeauri rdfs:label ?ugeo .
}

order by ?date

Permalinks

Permalink to this version: 37016e90c4284a9cae04dfdef06eb6a1
Permalink to latest version: Y3ZU6EMVXA

Older versions

21 Sep 2018 - Share of renewable energy

08 Nov 2017 - Share of renewable energy

25 Aug 2016 - Share of renewable energy

03 Nov 2015 - Share of renewable energy

Geographic coverage

Austria Belgium Bulgaria Croatia 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