next
previous
items

Data table via SPARQL

Share of renewable energy

Data table via SPARQL Published 15 Oct 2021 Last modified 19 Jan 2022
30 min read
This is an old version, kept for reference only.

Go to latest version
Topics:

Download this dataset

Dataset preview

(Live Query)

date_original date ugeo obsValue target
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2020 proxy" "Austria" "12"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2020 proxy" "Belgium" "11.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2020 proxy" "Bulgaria" "7.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2020 proxy" "Cyprus" "8.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2020 proxy" "Czechia" "8.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2020 proxy" "Germany" "9.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2020 proxy" "Denmark" "8.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2020 proxy" "Estonia" "5.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2020 proxy" "Greece" "5.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2020 proxy" "Spain" "7.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#int>

Received 576 rows in 0.013 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/share-of-renewable-energy-6/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



http://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 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/>
PREFIX proxy: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/CSI037/proxy_2020.tsv#>

SELECT 
?date as ?date_original

bif:either(year(?date) = 2021, '2020 target', bif:either(year(?date) = 2020, '2020 proxy' ,year(?date))) as ?date



bif:either(?geo = geo:DE, 'Germany', bif:either(?geo = geo:EU28, 'EU-28', bif:either(?geo = geo:EU27_2020, 'EU-27',?ugeo)) ) as ?ugeo
round(?obsValue*10)/10 as ?obsValue
#?proxy
10 AS ?target
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 property:nrg_bal nrg_bal:REN_TRA .
      _:nrg_ind_ren sdmx-measure:obsValue ?obsValue .
    }
  } UNION {
    GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/CSI037/proxy_2020.tsv> 
    {
      _:rec proxy:date ?date  .
      _:rec proxy:geo ?geo  .
      _:rec proxy:obsValue ?obsValue  .
      #_:rec proxy:obsValue ?proxy  .
    }
  } UNION {
    GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/CSI037/proxy_2020.tsv> 
    {
      {
        SELECT 
          xsd:date('2021-01-01') as ?date
          10 AS ?target
          10 AS ?obsValue
          WHERE {} 
      }
      _:rec proxy:geo ?geo  .
    }
  }
  ?geo rdfs:label ?ugeo .
  FILTER (?geo IN (  geo:EU28, geo:EU27_2020, geo:BE, geo:BG,
                     geo:CZ,	geo:DK,	geo:DE,	geo:EE,
                     geo:IE,	geo:EL,	geo:ES,	geo:FR,	
                     geo:HR,	geo:IT,	geo:CY,	geo:LV,
                     geo:LT,	geo:LU,	geo:HU,	geo:MT,		
                     geo:NL,	geo:AT,	geo:PL,	geo:PT,	
                     geo:RO,	geo:SI,	geo:SK,	geo:FI,
                     geo:SE,	geo:UK, geo:TR, geo:NO, 
                     geo:IS))
} 
ORDER BY ?date


Permalinks

Geographic coverage

Temporal coverage

Topics

Topics:

Tags

Filed under:
Filed under: renewable energies
Document Actions