Data table via SPARQL
Primary and final energy consumption in the European Union
Download this dataset
Dataset preview
(Live Query)
Received 33 rows in 0.001 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.
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
- Permalink to this version
- 0c57d8fcda6a4e6ba9580059a05a2cee
- Permalink to latest version
- 0K1S6OAZTV
Geographic coverage
Temporal coverage
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/primary-and-final-energy-consumption-1 or scan the QR code.
PDF generated on 09 Feb 2023, 01:14 AM
Document Actions
Share with others