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
Go to latest version
Topics:
Energy
Download this dataset
Dataset preview
(Live Query)
Received 32 rows in 0.001 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.
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
- Permalink to this version
- 8cac80ba06934e6086d301d8a77bc702
- Permalink to latest version
- 0K1S6OAZTV
Geographic coverage
Temporal coverage
2008-2020
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/primary-and-final-energy-consumption or scan the QR code.
PDF generated on 04 Feb 2023, 11:52 PM
Topics
Topics:
Energy
Document Actions
Share with others