next
previous
items

Data table via SPARQL

Member states primary energy consumption and indicative national energy efficiency targets for 2020

Data table via SPARQL Published 16 Jul 2019 Last modified 24 Jun 2020
Topics:

Download this dataset

Dataset preview

(Live Query)

date ugeo primary_energy_consumption target distance percentage_distance
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "32.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "31.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.27188"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "49.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "43.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.475918"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "18.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "16.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.521708"^^<http://www.w3.org/2001/XMLSchema#decimal> "8.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Croatia" "8.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "-3.167477"^^<http://www.w3.org/2001/XMLSchema#decimal> "-27.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Cyprus" "2.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.322579"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Czechia" "40.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "39.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.881822"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Denmark" "18"^^<http://www.w3.org/2001/XMLSchema#decimal> "17.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.160572"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Estonia" "5.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "-0.856181"^^<http://www.w3.org/2001/XMLSchema#decimal> "-13.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries" "1572.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "1483"^^<http://www.w3.org/2001/XMLSchema#decimal> "89.716267"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "Finland" "32.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "35.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "-3.421175"^^<http://www.w3.org/2001/XMLSchema#decimal> "-9.5"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 31 rows in 0.032 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/member-states-primary-energy-consumption-3/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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
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 siec: <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/>
PREFIX nrg_bal: <http://dd.eionet.europa.eu/vocabulary/eurostat/nrg_bal/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX tableFile: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/ENER/national_energy_efficiency_targets_2020_2017.txt#>

SELECT
year(?date) as ?date
bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
round((sum(?GIC)-sum(?FC_NE))/100.0)/10.0 as ?primary_energy_consumption
round(xsd:double(?primary)/100)/10.0 as ?target
(( (sum(?GIC)-sum(?FC_NE)) - sum(xsd:double(?primary))/2.0 )/100)/10.0 as ?distance
round(((?primary_energy_consumption/?target)-1)*1000)/10.0 as ?percentage_distance

WHERE {
  { 
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_bal_c.rdf.gz> {
    ?nrg_bal_c sdmx-dimension:refArea ?geo .
    ?nrg_bal_c sdmx-attribute:unitMeasure unit:KTOE .
    ?nrg_bal_c sdmx-dimension:timePeriod ?date .
    ?nrg_bal_c property:siec siec:TOTAL .
    {
      ?nrg_bal_c property:nrg_bal nrg_bal:GIC .
      ?nrg_bal_c sdmx-measure:obsValue ?GIC .
    } UNION {
      ?nrg_bal_c property:nrg_bal nrg_bal:FC_NE .
      ?nrg_bal_c sdmx-measure:obsValue ?FC_NE .
    }
   }
  } 
     {{
       SELECT DISTINCT
         xsd:date(?date) as ?date
         ?geo
         ?primary
         ?final
       WHERE {
         { 
         GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/ENER/national_energy_efficiency_targets_2020_2017.txt> 
           {
              _:rec tableFile:date ?date .
              _:rec tableFile:geo ?geo .
              _:rec tableFile:primary ?primary .
              _:rec tableFile:final ?final .
           }
         }
      }}
 }
 #FILTER (BOUND(?final) && BOUND(?primary))
 ?geo rdfs:label ?ugeo
 FILTER (year(?date) = 2017)
}
ORDER BY ?ugeo ?date


Permalinks

Geographic coverage

Temporal coverage

Topics

Topics:

Tags

Document Actions