next
previous
items

Data table via SPARQL

Primary and final energy consumption in the European Union

Data table via SPARQL Published 21 Oct 2021 Last modified 21 Oct 2021
This is an old version, kept for reference only.

Go to latest version
Topics:

Download this dataset

Dataset preview

(Live Query)

date PEC20202030 FEC20202030 PECTARGET FECTARGET
"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> "1246"^^<http://www.w3.org/2001/XMLSchema#int> "935"^^<http://www.w3.org/2001/XMLSchema#int> "1305"^^<http://www.w3.org/2001/XMLSchema#int> "956"^^<http://www.w3.org/2001/XMLSchema#int>
"2019-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "1350"^^<http://www.w3.org/2001/XMLSchema#decimal> "983"^^<http://www.w3.org/2001/XMLSchema#decimal> "" ""
"2018-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "1376"^^<http://www.w3.org/2001/XMLSchema#decimal> "990"^^<http://www.w3.org/2001/XMLSchema#decimal> "" ""
"2017-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "1385"^^<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> "1365"^^<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> "1354"^^<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> "1385"^^<http://www.w3.org/2001/XMLSchema#decimal> "980"^^<http://www.w3.org/2001/XMLSchema#decimal> "" ""
"2012-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "1397"^^<http://www.w3.org/2001/XMLSchema#decimal> "982"^^<http://www.w3.org/2001/XMLSchema#decimal> "" ""

Received 32 rows in 0.002 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/primary-and-final-energy-consumption/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
                 1246000 AS ?PEC20202030
                 935000 AS ?FEC20202030
          WHERE {}
        }
      } UNION {
        {
          SELECT xsd:date('2020-01-01') AS ?date
                 geo:EU27_2020 AS ?geo
                 1305400 AS ?PECTARGET
                 956800 AS ?FECTARGET
          WHERE {}
        }
      } UNION {
        {
          SELECT xsd:date('2030-01-01') AS ?date
                 geo:EU27_2020 AS ?geo
                 1128000 AS ?PECTARGET
                 846000 AS ?FECTARGET
          WHERE {}
        }
      }
    }
ORDER BY DESC(?date)


Permalinks

Geographic coverage

Temporal coverage

Topics

Topics: