next
previous
items

Data table via SPARQL

Primary and final energy consumption in the European Union

Data table via SPARQL Last modified 04 Mar 2022
Topics:

Download this dataset

Dataset preview

(Live Query)

date PEC20202030 FEC20202030 PECTARGET FECTARGET
"2050-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "" "" "" ""
"2030-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "" "" "1128"^^<http://www.w3.org/2001/XMLSchema#int> "846"^^<http://www.w3.org/2001/XMLSchema#int>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "1237"^^<http://www.w3.org/2001/XMLSchema#decimal> "907"^^<http://www.w3.org/2001/XMLSchema#decimal> "1312"^^<http://www.w3.org/2001/XMLSchema#int> "959"^^<http://www.w3.org/2001/XMLSchema#int>
"2019-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "1354"^^<http://www.w3.org/2001/XMLSchema#decimal> "987"^^<http://www.w3.org/2001/XMLSchema#decimal> "" ""
"2018-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "1377"^^<http://www.w3.org/2001/XMLSchema#decimal> "992"^^<http://www.w3.org/2001/XMLSchema#decimal> "" ""
"2017-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "1384"^^<http://www.w3.org/2001/XMLSchema#decimal> "990"^^<http://www.w3.org/2001/XMLSchema#decimal> "" ""
"2016-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "1364"^^<http://www.w3.org/2001/XMLSchema#decimal> "978"^^<http://www.w3.org/2001/XMLSchema#decimal> "" ""
"2015-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "1353"^^<http://www.w3.org/2001/XMLSchema#decimal> "958"^^<http://www.w3.org/2001/XMLSchema#decimal> "" ""
"2014-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "1331"^^<http://www.w3.org/2001/XMLSchema#decimal> "939"^^<http://www.w3.org/2001/XMLSchema#decimal> "" ""
"2013-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "1384"^^<http://www.w3.org/2001/XMLSchema#decimal> "981"^^<http://www.w3.org/2001/XMLSchema#decimal> "" ""

Received 33 rows in 0.025 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/primary-and-final-energy-consumption-1/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



https://semantic.eea.europa.eu/sparql

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 siec: <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/>
PREFIX nrg_bal: <http://dd.eionet.europa.eu/vocabulary/eurostat/nrg_bal/>
PREFIX measure: <http://purl.org/linked-data/sdmx/2009/measure#>

SELECT DISTINCT
?date
ROUND(SUM(?PEC20202030)/1000) AS ?PEC20202030
ROUND(SUM(?FEC20202030)/1000) AS ?FEC20202030
SUM(?PECTARGET)/1000 AS ?PECTARGET
SUM(?FECTARGET)/1000 AS ?FECTARGET
  WHERE {
      {
      GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_bal_c.rdf.gz>
        {{
          _:nrg_bal_c sdmx-dimension:timePeriod ?date .
          _:nrg_bal_c sdmx-attribute:unitMeasure unit:KTOE .
          _:nrg_bal_c sdmx-dimension:refArea geo:EU27_2020 .
          _:nrg_bal_c property:siec siec:TOTAL .
          {
              _:nrg_bal_c property:nrg_bal nrg_bal:PEC2020-2030 .
              _:nrg_bal_c measure:obsValue ?PEC20202030 .
          } UNION {
              _:nrg_bal_c property:nrg_bal nrg_bal:FEC2020-2030 .
              _:nrg_bal_c measure:obsValue ?FEC20202030 .
          }
          


        }}
      } UNION {
        {
          SELECT xsd:date('2020-01-01') AS ?date
                 geo:EU27_2020 AS ?geo
                 1312000 AS ?PECTARGET
                 959000 AS ?FECTARGET
          WHERE {}
        }
      } UNION {
        {
          SELECT xsd:date('2030-01-01') AS ?date
                 geo:EU27_2020 AS ?geo
                 1128000 AS ?PECTARGET
                 846000 AS ?FECTARGET
          WHERE {}
        }
      } UNION {
        {
          SELECT xsd:date('2050-01-01') AS ?date
                 geo:EU27_2020 AS ?geo
          WHERE {}
        }
      }
    }
ORDER BY DESC(?date)


Permalinks

Geographic coverage

Temporal coverage

Topics

Topics: