Transport energy consumption

Data table via SPARQL Last modified 16 Aug 2018
31 min read
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.8"^^<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.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.44"^^<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.8"^^<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 27 rows in 0.004 seconds.


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