Transport energy consumption

Data table via SPARQL Published 19 Oct 2017 Last modified 08 Nov 2017
31 min read
This is an old version, kept for reference only.

Go to latest version
Topics: ,

Download this dataset

Dataset preview

(Live Query)

year oil_derived_fuels annotation_line_computed road_gasoline road_diesel rail_gas_diesel_oil rail_residual_fuel_oil rail_electricity aviation_gasoline aviation_kerosene ship_diesel_gas_oil ship_residual_fuel_oil ship_gasoline biogasoline biodiesel natural_gas lpg annotation_line liquid_biofuels
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "13.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.93"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.2"^^<http://www.w3.org/2001/XMLSchema#double> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "13.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.96"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.2"^^<http://www.w3.org/2001/XMLSchema#double> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "13.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.08"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.2"^^<http://www.w3.org/2001/XMLSchema#double> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "13.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.11"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.2"^^<http://www.w3.org/2001/XMLSchema#double> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "13.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.14"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.2"^^<http://www.w3.org/2001/XMLSchema#double> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "14"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.2"^^<http://www.w3.org/2001/XMLSchema#double> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "14.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.35"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.2"^^<http://www.w3.org/2001/XMLSchema#double> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "14.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.47"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.2"^^<http://www.w3.org/2001/XMLSchema#double> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "15.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.62"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.2"^^<http://www.w3.org/2001/XMLSchema#double> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "15.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.71"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.2"^^<http://www.w3.org/2001/XMLSchema#double> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 26 rows in 0.004 seconds.


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



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

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 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
round((?road_gasoline+?road_diesel+?rail_gas_diesel_oil+?rail_residual_fuel_oil+?aviation_gasoline+?aviation_kerosene+?ship_diesel_gas_oil+?ship_residual_fuel_oil+?ship_gasoline+?lpg)/100000)/10.0 as ?oil_derived_fuels

round((?road_gasoline+?road_diesel+?rail_gas_diesel_oil+?rail_residual_fuel_oil+?aviation_gasoline+?aviation_kerosene+?ship_diesel_gas_oil+?ship_residual_fuel_oil+?ship_gasoline+?lpg)/100000)/10.0*0.3 AS ?annotation_line_computed

round(?road_gasoline/100000)/10.0 as ?road_gasoline
round(?road_diesel/100000)/10.0 as ?road_diesel

round(?rail_gas_diesel_oil/100000)/10.0 as ?rail_gas_diesel_oil
round(?rail_residual_fuel_oil/100000)/10.0 as ?rail_residual_fuel_oil
round(?rail_electricity/100000)/10.0 as ?rail_electricity

round(?aviation_gasoline/100000)/10.0 as ?aviation_gasoline
round(?aviation_kerosene/100000)/10.0 as ?aviation_kerosene

round(?ship_diesel_gas_oil/100000)/10.0 as ?ship_diesel_gas_oil
round(?ship_residual_fuel_oil/100000)/10.0 as ?ship_residual_fuel_oil
round(?ship_gasoline/100000)/10.0 as ?ship_gasoline

round(?biogasoline/100000)/10.0 as ?biogasoline
round(?biodiesel/100000)/10.0 as ?biodiesel
round(?natural_gas/100000)/10.0 as ?natural_gas
round(?lpg/100000)/10.0 as ?lpg

?annotation_line
round(?liquid_biofuels/100000)/10.0 as ?liquid_biofuels

{{
SELECT 
year(?date) as ?year
sum(?road_gasoline) as ?road_gasoline
sum(?road_diesel) as ?road_diesel
sum(?rail_gas_diesel_oil) as ?rail_gas_diesel_oil
sum(?rail_residual_fuel_oil) as ?rail_residual_fuel_oil
sum(?rail_electricity) as ?rail_electricity
sum(?aviation_gasoline) as ?aviation_gasoline
sum(?aviation_kerosene) as ?aviation_kerosene
sum(?ship_diesel_gas_oil) as ?ship_diesel_gas_oil
sum(?ship_residual_fuel_oil) as ?ship_residual_fuel_oil
sum(?ship_gasoline) as ?ship_gasoline
sum(?biogasoline) as ?biogasoline
sum(?biodiesel) as ?biodiesel
sum(?natural_gas) as ?natural_gas
sum(?lpg) as ?lpg

#(sum(?road_gasoline)+sum(?road_diesel)+sum(?rail_gas_diesel_oil)+sum(?rail_residual_fuel_oil)+sum(?aviation_#gasoline)+sum(?aviation_kerosene)+sum(?ship_diesel_gas_oil)+sum(?ship_residual_fuel_oil)+sum(?ship_gasoline)#+sum(?lpg)) as ?oil_derived_fuels

#(sum(?road_gasoline)+sum(?road_diesel)+sum(?rail_gas_diesel_oil)+sum(?rail_residual_fuel_oil)+sum(?aviation_#gasoline)+sum(?aviation_kerosene)+sum(?ship_diesel_gas_oil)+sum(?ship_residual_fuel_oil)+sum(?ship_gasoline)#+sum(?lpg))*0.3 AS ?annotation_line_computed


#use of the computed value for 2008 as constant for all the years
xsd:double(5.2) as ?annotation_line

sum(?liquid_biofuels) as ?liquid_biofuels

WHERE {
{
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_102a.rdf.gz> 
    {
    _:nrg_102a sdmx-dimension:refArea ?geo .
    _:nrg_102a sdmx-attribute:unitMeasure unit:TJ .
    _:nrg_102a sdmx-dimension:timePeriod ?date .
    { 
      _:nrg_102a property:indic_nrg indic_nrg:B_101920 .
      {
      _:nrg_102a property:product product:3234 .
      _:nrg_102a sdmx-measure:obsValue ?road_gasoline .
      } UNION { 
      _:nrg_102a property:product product:3260 .
      _:nrg_102a sdmx-measure:obsValue ?road_diesel .
      } UNION {
      _:nrg_102a property:product product:3220 .
      _:nrg_102a sdmx-measure:obsValue ?lpg .
      }
    } UNION {
      _:nrg_102a property:indic_nrg indic_nrg:B_101910 .
      {
      _:nrg_102a property:product product:3260 .
      _:nrg_102a sdmx-measure:obsValue ?rail_gas_diesel_oil .
      } UNION {
      _:nrg_102a property:product product:3270A .
      _:nrg_102a sdmx-measure:obsValue ?rail_residual_fuel_oil .
      }
    } UNION {
      _:nrg_102a property:indic_nrg ?indic_nrg 
      FILTER (?indic_nrg IN (indic_nrg:B_101931,indic_nrg:B_101932)) .
      {
      _:nrg_102a property:product product:3235 .
      _:nrg_102a sdmx-measure:obsValue ?aviation_gasoline .
      } UNION {
      _:nrg_102a property:product product:3247 .
      _:nrg_102a sdmx-measure:obsValue ?aviation_kerosene .
      }
    }  UNION {
      _:nrg_102a property:indic_nrg ?indic_nrg 
      FILTER (?indic_nrg IN (indic_nrg:B_101940,indic_nrg:B_100800)) .
      {
      _:nrg_102a property:product product:3260 .
      _:nrg_102a sdmx-measure:obsValue ?ship_diesel_gas_oil .
      } UNION {
      _:nrg_102a property:product product:3270A .
      _:nrg_102a sdmx-measure:obsValue ?ship_residual_fuel_oil .
      } UNION {
      _:nrg_102a property:product product:3234 .
      _:nrg_102a sdmx-measure:obsValue ?ship_gasoline .
      }
    } 
  }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_105a.rdf.gz> 
    {
    _:nrg_105a sdmx-dimension:refArea ?geo .
    _:nrg_105a sdmx-dimension:timePeriod ?date .
    _:nrg_105a sdmx-attribute:unitMeasure unit:TJ .    
    _:nrg_105a property:indic_nrg indic_nrg:B_101910 .
    _:nrg_105a property:product product:6000 .
    _:nrg_105a sdmx-measure:obsValue ?rail_electricity .
    }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_107a.rdf.gz> 
    {
    _:nrg_107a sdmx-dimension:refArea ?geo .
    _:nrg_107a sdmx-dimension:timePeriod ?date .
    _:nrg_107a sdmx-attribute:unitMeasure unit:TJ . 
    _:nrg_107a property:indic_nrg ?indic_nrg 
    FILTER(?indic_nrg in (indic_nrg:B_101900, indic_nrg:B_101940)) .   
    { 
      _:nrg_107a property:product product:5546 .
      _:nrg_107a sdmx-measure:obsValue ?biogasoline .
    } UNION {
      _:nrg_107a property:product product:5547 .
      _:nrg_107a sdmx-measure:obsValue ?biodiesel .
    } UNION {
      _:nrg_107a property:product product:5545.
      _:nrg_107a sdmx-measure:obsValue ?liquid_biofuels .
    }
  } 
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_103a.rdf.gz>
    {
    _:nrg_103a sdmx-dimension:refArea ?geo .
    _:nrg_103a sdmx-dimension:timePeriod ?date .
    _:nrg_103a sdmx-attribute:unitMeasure unit:TJ . 
    _:nrg_103a property:indic_nrg indic_nrg:B_101920 .   
    _:nrg_103a property:product product:4100 .
    _:nrg_103a sdmx-measure:obsValue ?natural_gas .
    } 
 } 
 ?geo skos:notation ?ugeo FILTER (?ugeo in ('EU28')) .
} GROUP BY YEAR(?date)

}}
ORDER BY ?date


Related content

Visualisations produced

Temporal coverage

Document Actions
Filed under: