next
previous
items

Data table via SPARQL

Share of renewable energy

Data table via SPARQL Published 14 Aug 2020 Last modified 07 Dec 2020
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 ugeo obsValue target
"target" "Poland" "10"^^<http://www.w3.org/2001/XMLSchema#int> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"target" "Austria" "10"^^<http://www.w3.org/2001/XMLSchema#int> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"target" "Belgium" "10"^^<http://www.w3.org/2001/XMLSchema#int> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"target" "Bulgaria" "10"^^<http://www.w3.org/2001/XMLSchema#int> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"target" "Cyprus" "10"^^<http://www.w3.org/2001/XMLSchema#int> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"target" "Czechia" "10"^^<http://www.w3.org/2001/XMLSchema#int> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"target" "Germany" "10"^^<http://www.w3.org/2001/XMLSchema#int> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"target" "Denmark" "10"^^<http://www.w3.org/2001/XMLSchema#int> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"target" "Estonia" "10"^^<http://www.w3.org/2001/XMLSchema#int> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"target" "Greece" "10"^^<http://www.w3.org/2001/XMLSchema#int> "10"^^<http://www.w3.org/2001/XMLSchema#int>

Received 544 rows in 0.064 seconds.


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

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

bif:either(?geo = geo:DE, 'Germany', bif:either(?geo = geo:EU28, 'EU-28', ?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_2019.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_2019.tsv> 
    {
      {
        SELECT 
          xsd:date('2020-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: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