Do something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Data table via SPARQL
Received 849 rows in 0.227 seconds.
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.
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 skos: <http://www.w3.org/2004/02/skos/core#>
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 product: <http://dd.eionet.europa.eu/vocabulary/eurostat/product/>
PREFIX indic_nrg: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>
SELECT
year(?date) as ?year
bif:either (?ugeo = 'DE', 'Germany', ?country) as ?country
round((sum(?nrg_101a)-sum(?nrg_101a_non_energy) ) /100)/10.0 as ?coal_and_lignite
round((sum(?nrg_102a)-sum(?nrg_102a_non_energy))/100)/10.0 as ?oil
round((sum(?nrg_103a)-sum(?nrg_103a_non_energy))/100)/10.0 as ?gas
round(sum(?nrg_104a)/100)/10.0 as ?nuclear
round((sum(?nrg_107a)-sum(?nrg_107a_non_energy))/100)/10.0 as ?renewables
round(sum(?nrg_108a)/100)/10.0 as ?waste_not_renewable
round(sum(?nrg_105a)/100)/10.0 as ?import_export_electricity
(round( ( (sum(?nrg_101a) - sum(?nrg_101a_non_energy)) / (sum(?nrg_100a)-sum(?nrg_100a_non_energy)) ) *100))/10.0 as ?share_coal_and_lignite
(round( ( (sum(?nrg_102a) - sum(?nrg_102a_non_energy)) / (sum(?nrg_100a)-sum(?nrg_100a_non_energy)) ) *100))/10.0 as ?share_oil
(round( ( (sum(?nrg_103a) - sum(?nrg_103a_non_energy)) / (sum(?nrg_100a)-sum(?nrg_100a_non_energy)) ) *100))/10.0 as ?share_gas
(round( ( sum(?nrg_104a ) / (sum(?nrg_100a)-sum(?nrg_100a_non_energy)) ) *100))/10.0 as ?share_nuclear
(round( ( (sum(?nrg_107a) - sum(?nrg_107a_non_energy)) / (sum(?nrg_100a)-sum(?nrg_100a_non_energy)) ) *100))/10.0 as ?share_renewables
(round( ( sum(?nrg_108a ) / (sum(?nrg_100a)-sum(?nrg_100a_non_energy)) ) *100))/10.0 as ?share_waste_not_renewable
(round( ( sum(?nrg_105a ) / (sum(?nrg_100a)-sum(?nrg_100a_non_energy)) ) *100))/10.0 as ?share_import_export_electricity
round((sum(?nrg_100a)-sum(?nrg_100a_non_energy))/1000.0) as ?primary_energy_consumption
bif:either (?ugeo = 'EU28', 0, 1) as ?order
WHERE {
{
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a.rdf.gz>
{
_:nrg_100a sdmx-dimension:refArea ?geo .
_:nrg_100a sdmx-attribute:unitMeasure unit:KTOE .
_:nrg_100a sdmx-dimension:timePeriod ?date .
_:nrg_100a property:product product:0000 .
{
_:nrg_100a property:indic_nrg indic_nrg:B_100900 .
_:nrg_100a sdmx-measure:obsValue ?nrg_100a .
} UNION {
_:nrg_100a property:indic_nrg indic_nrg:B_101600 .
_:nrg_100a sdmx-measure:obsValue ?nrg_100a_non_energy .
}
}
} UNION {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_101a.rdf.gz>
{
_:nrg_101a sdmx-dimension:refArea ?geo .
_:nrg_101a sdmx-attribute:unitMeasure unit:KTOE .
_:nrg_101a sdmx-dimension:timePeriod ?date .
_:nrg_101a property:product product:2000 .
{
_:nrg_101a property:indic_nrg indic_nrg:B_100900 .
_:nrg_101a sdmx-measure:obsValue ?nrg_101a .
} UNION {
_:nrg_101a property:indic_nrg indic_nrg:B_101600 .
_:nrg_101a sdmx-measure:obsValue ?nrg_101a_non_energy .
}
}
} UNION {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_102a.rdf.gz>
{
_:nrg_102a sdmx-dimension:refArea ?geo .
_:nrg_102a sdmx-attribute:unitMeasure unit:KTOE .
_:nrg_102a sdmx-dimension:timePeriod ?date .
_:nrg_102a property:product product:3000 .
{
_:nrg_102a property:indic_nrg indic_nrg:B_100900 .
_:nrg_102a sdmx-measure:obsValue ?nrg_102a .
} UNION {
_:nrg_102a property:indic_nrg indic_nrg:B_101600 .
_:nrg_102a sdmx-measure:obsValue ?nrg_102a_non_energy .
}
}
} UNION {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_103a.rdf.gz>
{
_:nrg_103a sdmx-dimension:refArea ?geo .
_:nrg_103a sdmx-attribute:unitMeasure unit:KTOE .
_:nrg_103a sdmx-dimension:timePeriod ?date .
_:nrg_103a property:product product:4000 .
{
_:nrg_103a property:indic_nrg indic_nrg:B_100900 .
_:nrg_103a sdmx-measure:obsValue ?nrg_103a .
} UNION {
_:nrg_103a property:indic_nrg indic_nrg:B_101600 .
_:nrg_103a sdmx-measure:obsValue ?nrg_103a_non_energy .
}
}
} UNION {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_104a.rdf.gz>
{
_:nrg_104a sdmx-dimension:refArea ?geo .
_:nrg_104a sdmx-attribute:unitMeasure unit:KTOE .
_:nrg_104a sdmx-dimension:timePeriod ?date .
_:nrg_104a property:product product:5100 .
_:nrg_104a property:indic_nrg indic_nrg:B_100900 .
_:nrg_104a sdmx-measure:obsValue ?nrg_104a .
}
} UNION {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_105a.rdf.gz>
{
_:nrg_105a sdmx-dimension:refArea ?geo .
_:nrg_105a sdmx-attribute:unitMeasure unit:KTOE .
_:nrg_105a sdmx-dimension:timePeriod ?date .
_:nrg_105a property:product product:6000 .
_:nrg_105a property:indic_nrg indic_nrg:B_100900 .
_:nrg_105a sdmx-measure:obsValue ?nrg_105a .
}
} UNION {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_106a.rdf.gz>
{
_:nrg_106a sdmx-dimension:refArea ?geo .
_:nrg_106a sdmx-attribute:unitMeasure unit:KTOE .
_:nrg_106a sdmx-dimension:timePeriod ?date .
_:nrg_106a property:product product:5200 .
{
_:nrg_106a property:indic_nrg indic_nrg:B_100900 .
_:nrg_106a sdmx-measure:obsValue ?nrg_106a .
} UNION {
_:nrg_106a property:indic_nrg indic_nrg:B_101600 .
_:nrg_106a sdmx-measure:obsValue ?nrg_106a_non_energy .
}
}
} UNION {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_107a.rdf.gz>
{
_:nrg_107a sdmx-dimension:refArea ?geo .
_:nrg_107a sdmx-attribute:unitMeasure unit:KTOE .
_:nrg_107a sdmx-dimension:timePeriod ?date .
_:nrg_107a property:product product:5500 .
{
_:nrg_107a property:indic_nrg indic_nrg:B_100900 .
_:nrg_107a sdmx-measure:obsValue ?nrg_107a .
} UNION {
_:nrg_107a property:indic_nrg indic_nrg:B_101600 .
_:nrg_107a sdmx-measure:obsValue ?nrg_107a_non_energy .
}
}
} UNION {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_108a.rdf.gz>
{
_:nrg_108a sdmx-dimension:refArea ?geo .
_:nrg_108a sdmx-attribute:unitMeasure unit:KTOE .
_:nrg_108a sdmx-dimension:timePeriod ?date .
_:nrg_108a property:product product:7200 .
_:nrg_108a property:indic_nrg indic_nrg:B_100900 .
_:nrg_108a sdmx-measure:obsValue ?nrg_108a .
}
}
?geo skos:notation ?ugeo .
?geo skos:prefLabel ?country .
#FILTER (?country = 'European Union (28 countries)')
#FILTER (year(?date) = 2013)
}
GROUP BY year(?date) ?country ?ugeo
HAVING sum(?nrg_100a)-sum(?nrg_100a_non_energy) > 0
ORDER BY ?date ?order DESC(?primary_energy_consumption)
For references, please go to https://eea.europa.eu./data-and-maps/daviz/sds/share-of-total-energy-consumption-1 or scan the QR code.
PDF generated on 23 Nov 2024, 12:20 PM
Engineered by: EEA Web Team
Software updated on 26 September 2023 08:13 from version 23.8.18
Software version: EEA Plone KGS 23.9.14
Document Actions
Share with others