Final energy consumption by transport modes

Data table via SPARQL Last modified 16 Aug 2018
31 min read
Topics: ,

Download this dataset

Dataset preview

(Live Query)

year International_Marine_Bunkers Rail_Transport Road_Transport Domestic_International_Aviation Domestic_Navigation Total oil_derived_fuels annotation_line_computed annotation_line
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "1.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.3"^^<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.2"^^<http://www.w3.org/2001/XMLSchema#double>
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "1.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.96"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.2"^^<http://www.w3.org/2001/XMLSchema#double>
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "1.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.8"^^<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.2"^^<http://www.w3.org/2001/XMLSchema#double>
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "1.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.9"^^<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.2"^^<http://www.w3.org/2001/XMLSchema#double>
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "1.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "14.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.2"^^<http://www.w3.org/2001/XMLSchema#double>
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "1.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "14.2"^^<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.2"^^<http://www.w3.org/2001/XMLSchema#double>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "1.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "14.7"^^<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.2"^^<http://www.w3.org/2001/XMLSchema#double>
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "1.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "14.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.44"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.2"^^<http://www.w3.org/2001/XMLSchema#double>
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "1.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.6"^^<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.2"^^<http://www.w3.org/2001/XMLSchema#double>
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "1.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.9"^^<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.2"^^<http://www.w3.org/2001/XMLSchema#double>

Received 27 rows in 0.068 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/final-energy-consumption-by-transport-6/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 geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX infotype: <http://rdfdata.eionet.europa.eu/eurostat/dic/infotype#>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX indic_nrg: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>
PREFIX product: <http://dd.eionet.europa.eu/vocabulary/eurostat/product/>


SELECT
year(?date) as ?year 
round(sum(?B_100800)/100000)/10.0  as ?International_Marine_Bunkers 
round(sum(?B_101910)/100000)/10.0 as ?Rail_Transport 
round((sum(?B_101920) + sum(?B_101920_el))/100000)/10.0 as ?Road_Transport 
##round(sum(?B_101931)/100000)/10.0 as ?International_Aviation 
##round(sum(?B_101932)/100000)/10.0 as ?Domestic_Aviation 
round(( sum(?B_101931)+sum(?B_101932) )/100000)/10.0 as ?Domestic_International_Aviation 
round(sum(?B_101940)/100000)/10.0 as ?Domestic_Navigation
round(sum(?total)/100000)/10.0 as ?Total
round((sum(?road)+sum(?rail)+sum(?aviation)+sum(?ship))/100000)/10.0 as ?oil_derived_fuels
round((sum(?road)+sum(?rail)+sum(?aviation)+sum(?ship))/100000)/10.0*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

  WHERE {{{
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a.rdf.gz> { 
    {
        _:nrg_100a sdmx-attribute:unitMeasure unit:TJ .
        _:nrg_100a property:product product:0000 .
        _:nrg_100a sdmx-dimension:refArea ?geo . 
        _:nrg_100a sdmx-dimension:timePeriod ?date .
        { 
          _:nrg_100a property:indic_nrg indic_nrg:B_100800 .
	  _:nrg_100a sdmx-measure:obsValue ?B_100800 .
	} UNION { 
           _:nrg_100a property:indic_nrg indic_nrg:B_101910 .
	  _:nrg_100a sdmx-measure:obsValue ?B_101910 .
	} UNION { 
          _:nrg_100a property:indic_nrg indic_nrg:B_101920 .
	  _:nrg_100a sdmx-measure:obsValue ?B_101920 .
	} UNION { 
          _:nrg_100a property:indic_nrg indic_nrg:B_101931 .
	  _:nrg_100a sdmx-measure:obsValue ?B_101931 .
	} UNION { 
          _:nrg_100a property:indic_nrg indic_nrg:B_101932 .
	  _:nrg_100a sdmx-measure:obsValue ?B_101932 .
	} UNION { 
          _:nrg_100a property:indic_nrg indic_nrg:B_101940 .
    	  _:nrg_100a sdmx-measure:obsValue ?B_101940 .
	} UNION { 
        _:nrg_100a property:indic_nrg ?indic_nrg . 
        FILTER (?indic_nrg IN (indic_nrg:B_100800,indic_nrg:B_101910,
                indic_nrg:B_101920, indic_nrg:B_101932,indic_nrg:B_101931,
                indic_nrg:B_101940))
	_:nrg_100a sdmx-measure:obsValue ?total .
     }
    }}
  } 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:TJ .
    _:nrg_102a sdmx-dimension:timePeriod ?date .
    { 
      _:nrg_102a property:indic_nrg indic_nrg:B_101920 .
      {
        _:nrg_102a property:product ?product . 
        FILTER (?product in (product:3234, product:3260, product:3220))
        _:nrg_102a sdmx-measure:obsValue ?road .
      }
    } UNION {
      _:nrg_102a property:indic_nrg indic_nrg:B_101910 .
      {
        _:nrg_102a property:product ?product . 
        FILTER (?product in (product:3260, product:3270A))
        _:nrg_102a sdmx-measure:obsValue ?rail .
      }
    } 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 . 
        FILTER (?product in (product:3235, product:3247))
        _:nrg_102a sdmx-measure:obsValue ?aviation .
      }
    }  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 . 
        FILTER (?product in (product:3260, product:3270A, product:3234))
        _:nrg_102a sdmx-measure:obsValue ?ship .
      }
    }
   }}
  } 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:TJ .
        _:nrg_105a sdmx-dimension:timePeriod ?date .
        _:nrg_105a property:indic_nrg indic_nrg:B_101920 .
        _:nrg_105a property:product product:6000 .
        _:nrg_105a sdmx-measure:obsValue ?B_101920_el .
      }
     }
  }} 
  FILTER (?geo in (geo:EU28))
}
GROUP BY ?date 
ORDER BY ?date


Related content

Temporal coverage

Document Actions
Filed under: