Transport energy consumption

Data table via SPARQL Published 03 Sep 2013 Last modified 01 Feb 2016
EEA-32 excluding Iceland and Liechtenstein

Download this dataset

Dataset preview

(Live Query)

year road_gasoline road_diesel rail_gas_diesel_residual_fuel_electricity aviation_kerosene ship_diesel_residual_fuel_gasoline biogasoline_biodiesel_natural_gas_lpg oil_derived_fuels annotation_line_computed annotation_line
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "6028220"^^<http://www.w3.org/2001/XMLSchema#decimal> "4378468"^^<http://www.w3.org/2001/XMLSchema#decimal> "355279"^^<http://www.w3.org/2001/XMLSchema#decimal> "1313624"^^<http://www.w3.org/2001/XMLSchema#decimal> "1783998"^^<http://www.w3.org/2001/XMLSchema#decimal> "122436"^^<http://www.w3.org/2001/XMLSchema#decimal> "13801474"^^<http://www.w3.org/2001/XMLSchema#decimal> "4140442.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "5312301"^^<http://www.w3.org/2001/XMLSchema#int>
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "6058228"^^<http://www.w3.org/2001/XMLSchema#decimal> "4479434"^^<http://www.w3.org/2001/XMLSchema#decimal> "359910"^^<http://www.w3.org/2001/XMLSchema#decimal> "1277346"^^<http://www.w3.org/2001/XMLSchema#decimal> "1771807"^^<http://www.w3.org/2001/XMLSchema#decimal> "118931"^^<http://www.w3.org/2001/XMLSchema#decimal> "13875653"^^<http://www.w3.org/2001/XMLSchema#decimal> "4162695.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "5312301"^^<http://www.w3.org/2001/XMLSchema#int>
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "6173866"^^<http://www.w3.org/2001/XMLSchema#decimal> "4637754"^^<http://www.w3.org/2001/XMLSchema#decimal> "363540"^^<http://www.w3.org/2001/XMLSchema#decimal> "1361800"^^<http://www.w3.org/2001/XMLSchema#decimal> "1803847"^^<http://www.w3.org/2001/XMLSchema#decimal> "112922"^^<http://www.w3.org/2001/XMLSchema#decimal> "14263596"^^<http://www.w3.org/2001/XMLSchema#decimal> "4279078.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "5312301"^^<http://www.w3.org/2001/XMLSchema#int>
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "6161886"^^<http://www.w3.org/2001/XMLSchema#decimal> "4812732"^^<http://www.w3.org/2001/XMLSchema#decimal> "363213"^^<http://www.w3.org/2001/XMLSchema#decimal> "1419737"^^<http://www.w3.org/2001/XMLSchema#decimal> "1824009"^^<http://www.w3.org/2001/XMLSchema#decimal> "118877"^^<http://www.w3.org/2001/XMLSchema#decimal> "14504635"^^<http://www.w3.org/2001/XMLSchema#decimal> "4351390.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5312301"^^<http://www.w3.org/2001/XMLSchema#int>
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "6104263"^^<http://www.w3.org/2001/XMLSchema#decimal> "4947629"^^<http://www.w3.org/2001/XMLSchema#decimal> "360915"^^<http://www.w3.org/2001/XMLSchema#decimal> "1478390"^^<http://www.w3.org/2001/XMLSchema#decimal> "1769310"^^<http://www.w3.org/2001/XMLSchema#decimal> "127111"^^<http://www.w3.org/2001/XMLSchema#decimal> "14583505"^^<http://www.w3.org/2001/XMLSchema#decimal> "4375051.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5312301"^^<http://www.w3.org/2001/XMLSchema#int>
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "6078858"^^<http://www.w3.org/2001/XMLSchema#decimal> "5105079"^^<http://www.w3.org/2001/XMLSchema#decimal> "365607"^^<http://www.w3.org/2001/XMLSchema#decimal> "1554097"^^<http://www.w3.org/2001/XMLSchema#decimal> "1790273"^^<http://www.w3.org/2001/XMLSchema#decimal> "139969"^^<http://www.w3.org/2001/XMLSchema#decimal> "14821896"^^<http://www.w3.org/2001/XMLSchema#decimal> "4446568.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "5312301"^^<http://www.w3.org/2001/XMLSchema#int>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "6151941"^^<http://www.w3.org/2001/XMLSchema#decimal> "5379788"^^<http://www.w3.org/2001/XMLSchema#decimal> "372096"^^<http://www.w3.org/2001/XMLSchema#decimal> "1622888"^^<http://www.w3.org/2001/XMLSchema#decimal> "1886494"^^<http://www.w3.org/2001/XMLSchema#decimal> "153773"^^<http://www.w3.org/2001/XMLSchema#decimal> "15345165"^^<http://www.w3.org/2001/XMLSchema#decimal> "4603549.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5312301"^^<http://www.w3.org/2001/XMLSchema#int>
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "6135167"^^<http://www.w3.org/2001/XMLSchema#decimal> "5499306"^^<http://www.w3.org/2001/XMLSchema#decimal> "370358"^^<http://www.w3.org/2001/XMLSchema#decimal> "1713735"^^<http://www.w3.org/2001/XMLSchema#decimal> "2008037"^^<http://www.w3.org/2001/XMLSchema#decimal> "186469"^^<http://www.w3.org/2001/XMLSchema#decimal> "15687397"^^<http://www.w3.org/2001/XMLSchema#decimal> "4706219.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "5312301"^^<http://www.w3.org/2001/XMLSchema#int>
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "6155543"^^<http://www.w3.org/2001/XMLSchema#decimal> "5808130"^^<http://www.w3.org/2001/XMLSchema#decimal> "364823"^^<http://www.w3.org/2001/XMLSchema#decimal> "1827166"^^<http://www.w3.org/2001/XMLSchema#decimal> "2084171"^^<http://www.w3.org/2001/XMLSchema#decimal> "198468"^^<http://www.w3.org/2001/XMLSchema#decimal> "16215667"^^<http://www.w3.org/2001/XMLSchema#decimal> "4864700.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "5312301"^^<http://www.w3.org/2001/XMLSchema#int>
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "6166176"^^<http://www.w3.org/2001/XMLSchema#decimal> "6100021"^^<http://www.w3.org/2001/XMLSchema#decimal> "357819"^^<http://www.w3.org/2001/XMLSchema#decimal> "1926321"^^<http://www.w3.org/2001/XMLSchema#decimal> "2005467"^^<http://www.w3.org/2001/XMLSchema#decimal> "206551"^^<http://www.w3.org/2001/XMLSchema#decimal> "16541175"^^<http://www.w3.org/2001/XMLSchema#decimal> "4962352.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5312301"^^<http://www.w3.org/2001/XMLSchema#int>

Received 22 rows in 0.045 seconds.


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



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 skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX c: <http://rdfdata.eionet.europa.eu/eurostat/dic/coicop#> 
PREFIX g: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>
PREFIX i: <http://rdfdata.eionet.europa.eu/eurostat/dic/infotype#>
PREFIX u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX p: <http://rdfdata.eionet.europa.eu/eurostat/dic/product#>
PREFIX indic_nrg: <http://rdfdata.eionet.europa.eu/eurostat/dic/indic_nrg#>


SELECT 
year(?date) as ?year

sum(?road_gasoline) as ?road_gasoline
sum(?road_diesel) as ?road_diesel

(sum(?rail_gas_diesel_oil)+sum(?rail_residual_fuel_oil)+sum(?rail_electricity)) as ?rail_gas_diesel_residual_fuel_electricity

sum(?aviation_kerosene) as ?aviation_kerosene

(sum(?ship_diesel_gas_oil)+sum(?ship_residual_fuel_oil)+sum(?ship_gasoline)) as ?ship_diesel_residual_fuel_gasoline

(sum(?biogasoline)+sum(?biodiesel)+sum(?natural_gas)+sum(?lpg)) as ?biogasoline_biodiesel_natural_gas_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 2009 as constant for all the years
5312301 as ?annotation_line

WHERE {
{
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_102a.rdf.gz> 
    {
    _:nrg_102a property:geo ?geo .
    _:nrg_102a property:unit u:TJ .
    _:nrg_102a sdmx-dimension:timePeriod ?date .
    { 
      _:nrg_102a property:indic_nrg indic_nrg:B_101920 .
      {
      _:nrg_102a property:product p:3234 .
      _:nrg_102a sdmx-measure:obsValue ?road_gasoline .
      } UNION { 
      _:nrg_102a property:product p:3260 .
      _:nrg_102a sdmx-measure:obsValue ?road_diesel .
      } UNION {
      _:nrg_102a property:product p:3220 .
      _:nrg_102a sdmx-measure:obsValue ?lpg .
      }
    } UNION {
      _:nrg_102a property:indic_nrg indic_nrg:B_101910 .
      {
      _:nrg_102a property:product p:3260 .
      _:nrg_102a sdmx-measure:obsValue ?rail_gas_diesel_oil .
      } UNION {
      _:nrg_102a property:product p: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 p:3235 .
      _:nrg_102a sdmx-measure:obsValue ?aviation_gasoline .
      } UNION {
      _:nrg_102a property:product p:3240 .
      _: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 p:3260 .
      _:nrg_102a sdmx-measure:obsValue ?ship_diesel_gas_oil .
      } UNION {
      _:nrg_102a property:product p:3270A .
      _:nrg_102a sdmx-measure:obsValue ?ship_residual_fuel_oil .
      } UNION {
      _:nrg_102a property:product p:3234 .
      _:nrg_102a sdmx-measure:obsValue ?ship_gasoline .
      }
    } 
  }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_105a.rdf.gz> 
    {
    _:nrg_105a property:geo ?geo .
    _:nrg_105a sdmx-dimension:timePeriod ?date .
    _:nrg_105a property:unit u:TJ .    
    _:nrg_105a property:indic_nrg indic_nrg:B_101910 .
    _:nrg_105a property:product p:6000 .
    _:nrg_105a sdmx-measure:obsValue ?rail_electricity .
    }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_1073a.rdf.gz> 
    {
    _:nrg_1073a property:geo ?geo .
    _:nrg_1073a sdmx-dimension:timePeriod ?date .
    _:nrg_1073a property:unit u:TJ . 
    _:nrg_1073a property:indic_nrg indic_nrg:B_101900 .   
    { 
      _:nrg_1073a property:product p:5546 .
      _:nrg_1073a sdmx-measure:obsValue ?biogasoline .
    } UNION {
      _:nrg_1073a property:product p:5547 .
      _:nrg_1073a sdmx-measure:obsValue ?biodiesel .
    }
  } 
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_103a.rdf.gz>
    {
    _:nrg_103a property:geo ?geo .
    _:nrg_103a sdmx-dimension:timePeriod ?date .
    _:nrg_103a property:unit u:TJ . 
    _:nrg_103a property:indic_nrg indic_nrg:B_101920 .   
    _:nrg_103a property:product p:4100 .
    _:nrg_103a sdmx-measure:obsValue ?natural_gas .
    } 
  
 } 
 ?geo skos:notation ?ugeo FILTER (?ugeo != 'IS' && ?ugeo != 'LI') .
 ?eeageo owl:sameAs ?geo . 
 ?eeageo skos:inScheme <http://rdfdata.eionet.europa.eu/eea/countries/> . 
 ?memberOf skos:member ?eeageo . 
 ?memberOf skos:notation ?memberOfcode FILTER (?memberOfcode IN ('EEA32')) .
} GROUP BY YEAR(?date)
  ORDER BY ?date


Related content

Document Actions