next
previous
items

Data table via SPARQL

Share of renewable energy

Data table via SPARQL Last modified 22 Oct 2021
30 min read
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.010 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