Final energy consumption by transport modes

Data table via SPARQL Published 19 Oct 2017 Last modified 20 Oct 2017
This is an old version, kept for reference only.

Go to latest version
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#decimal>
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "1.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.4"^^<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.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#decimal>
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "1.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.4"^^<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#decimal>
"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> "14"^^<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#decimal>
"1994"^^<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.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#decimal>
"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#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "1.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.4"^^<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#decimal>
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "1.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.2"^^<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.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.47"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"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#decimal>
"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#decimal>

Received 25 rows in 0.090 seconds.


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


Document Actions