next
previous
items

Data table via SPARQL

Transport energy consumption

Data table via SPARQL Published 24 Jun 2015 Last modified 26 Aug 2017
This is an old version, kept for reference only.

Go to latest version
This page was archived on 26 Aug 2017 with reason: A new version has been published

Download this dataset

Dataset preview

(Live Query)

year 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 oil_derived_fuels annotation_line_computed annotation_line liquid_biofuels
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "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> "13.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.93"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "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> "13.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.93"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "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> "13.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.08"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "5.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.5"^^<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> "13.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.11"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "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> "13.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.14"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "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.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> "14"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "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> "14.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.35"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "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> "14.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.47"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "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> "15.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.62"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "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> "15.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.71"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 24 rows in 0.002 seconds.


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

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(?date) as ?year

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

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

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

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

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

round((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))/100000)/10.0 as ?oil_derived_fuels

round((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))/100000)/10.0*0.3 AS ?annotation_line_computed

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

round(sum(?liquid_biofuels)/100000)/10.0 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


Permalinks

Document Actions