next
previous
items

Data table via SPARQL

Transport energy consumption

Data table via SPARQL Published 23 Oct 2019 Last modified 24 Jun 2020
31 min read
Topics:

Download this dataset

Dataset preview

(Live Query)

date road_gasoline biogasoline road_diesel biodiesel natural_gas lpg electricity_road electricity_rail rail_diesel_gas_oil rail_residual_fuel_oil aviation_gasoline aviation_kerosene ship_diesel_gas_oil ship_residual_fuel_oil ship_gasoline other_liquid_biofuels oil_derived_fuels total annotation_line
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "5695887.007"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "4153945.049"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "9044.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "113497.12"^^<http://www.w3.org/2001/XMLSchema#decimal> "932.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "173682"^^<http://www.w3.org/2001/XMLSchema#decimal> "166161.278"^^<http://www.w3.org/2001/XMLSchema#decimal> "202"^^<http://www.w3.org/2001/XMLSchema#decimal> "42065.92"^^<http://www.w3.org/2001/XMLSchema#decimal> "1221801.336"^^<http://www.w3.org/2001/XMLSchema#decimal> "541829.108"^^<http://www.w3.org/2001/XMLSchema#decimal> "1190840.422"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "13147849.03"^^<http://www.w3.org/2001/XMLSchema#decimal> "14039699.916"^^<http://www.w3.org/2001/XMLSchema#decimal> "5207783"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "5716585.963"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "4256040.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "9104.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "110225.116"^^<http://www.w3.org/2001/XMLSchema#decimal> "892.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "179978.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "163095.692"^^<http://www.w3.org/2001/XMLSchema#decimal> "242.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "25332.921"^^<http://www.w3.org/2001/XMLSchema#decimal> "1196454.991"^^<http://www.w3.org/2001/XMLSchema#decimal> "548511.162"^^<http://www.w3.org/2001/XMLSchema#decimal> "1180234.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "13217061.025"^^<http://www.w3.org/2001/XMLSchema#decimal> "14118885.669"^^<http://www.w3.org/2001/XMLSchema#decimal> "5207783"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "5810998.571"^^<http://www.w3.org/2001/XMLSchema#decimal> "216"^^<http://www.w3.org/2001/XMLSchema#decimal> "4428867.537"^^<http://www.w3.org/2001/XMLSchema#decimal> "138"^^<http://www.w3.org/2001/XMLSchema#decimal> "9156.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "104328.114"^^<http://www.w3.org/2001/XMLSchema#decimal> "903.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "178952.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "167720.475"^^<http://www.w3.org/2001/XMLSchema#decimal> "242.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "21868.721"^^<http://www.w3.org/2001/XMLSchema#decimal> "1275335.169"^^<http://www.w3.org/2001/XMLSchema#decimal> "572990.424"^^<http://www.w3.org/2001/XMLSchema#decimal> "1170366.31"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "75.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "13572261.041"^^<http://www.w3.org/2001/XMLSchema#decimal> "14502655.93"^^<http://www.w3.org/2001/XMLSchema#decimal> "5207783"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "5788887.513"^^<http://www.w3.org/2001/XMLSchema#decimal> "1026"^^<http://www.w3.org/2001/XMLSchema#decimal> "4562715.604"^^<http://www.w3.org/2001/XMLSchema#decimal> "438"^^<http://www.w3.org/2001/XMLSchema#decimal> "9307.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "109682.87"^^<http://www.w3.org/2001/XMLSchema#decimal> "774"^^<http://www.w3.org/2001/XMLSchema#decimal> "183358.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "162715.45"^^<http://www.w3.org/2001/XMLSchema#decimal> "363.18"^^<http://www.w3.org/2001/XMLSchema#decimal> "16948.141"^^<http://www.w3.org/2001/XMLSchema#decimal> "1332185.256"^^<http://www.w3.org/2001/XMLSchema#decimal> "536707.476"^^<http://www.w3.org/2001/XMLSchema#decimal> "1189129.594"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "112.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "13719067.504"^^<http://www.w3.org/2001/XMLSchema#decimal> "14613871.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "5207783"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "5729737.74"^^<http://www.w3.org/2001/XMLSchema#decimal> "1053"^^<http://www.w3.org/2001/XMLSchema#decimal> "4701625.285"^^<http://www.w3.org/2001/XMLSchema#decimal> "2594"^^<http://www.w3.org/2001/XMLSchema#decimal> "9778.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "114426.546"^^<http://www.w3.org/2001/XMLSchema#decimal> "734.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "188096.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "154964.789"^^<http://www.w3.org/2001/XMLSchema#decimal> "242.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "10472.305"^^<http://www.w3.org/2001/XMLSchema#decimal> "1388687.938"^^<http://www.w3.org/2001/XMLSchema#decimal> "519016.876"^^<http://www.w3.org/2001/XMLSchema#decimal> "1181354.86"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "112.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "13820557.639"^^<http://www.w3.org/2001/XMLSchema#decimal> "14697150.594"^^<http://www.w3.org/2001/XMLSchema#decimal> "5207783"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "5694563.903"^^<http://www.w3.org/2001/XMLSchema#decimal> "1026"^^<http://www.w3.org/2001/XMLSchema#decimal> "4834927.507"^^<http://www.w3.org/2001/XMLSchema#decimal> "4662"^^<http://www.w3.org/2001/XMLSchema#decimal> "10353.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "125196.292"^^<http://www.w3.org/2001/XMLSchema#decimal> "734.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "192096"^^<http://www.w3.org/2001/XMLSchema#decimal> "154406.954"^^<http://www.w3.org/2001/XMLSchema#decimal> "322.99"^^<http://www.w3.org/2001/XMLSchema#decimal> "9163.633"^^<http://www.w3.org/2001/XMLSchema#decimal> "1452358.84"^^<http://www.w3.org/2001/XMLSchema#decimal> "532304.502"^^<http://www.w3.org/2001/XMLSchema#decimal> "1170255.814"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "188"^^<http://www.w3.org/2001/XMLSchema#decimal> "13994461.935"^^<http://www.w3.org/2001/XMLSchema#decimal> "14890556.381"^^<http://www.w3.org/2001/XMLSchema#decimal> "5207783"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "5758232.655"^^<http://www.w3.org/2001/XMLSchema#decimal> "1647"^^<http://www.w3.org/2001/XMLSchema#decimal> "5102583.68"^^<http://www.w3.org/2001/XMLSchema#decimal> "6811"^^<http://www.w3.org/2001/XMLSchema#decimal> "11248.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "130982.256"^^<http://www.w3.org/2001/XMLSchema#decimal> "730.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "197388"^^<http://www.w3.org/2001/XMLSchema#decimal> "155136.138"^^<http://www.w3.org/2001/XMLSchema#decimal> "201.79"^^<http://www.w3.org/2001/XMLSchema#decimal> "9895.333"^^<http://www.w3.org/2001/XMLSchema#decimal> "1514440.948"^^<http://www.w3.org/2001/XMLSchema#decimal> "563737.336"^^<http://www.w3.org/2001/XMLSchema#decimal> "1239636.929"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "188"^^<http://www.w3.org/2001/XMLSchema#decimal> "14496592.765"^^<http://www.w3.org/2001/XMLSchema#decimal> "15433681.029"^^<http://www.w3.org/2001/XMLSchema#decimal> "5207783"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "5738005.709"^^<http://www.w3.org/2001/XMLSchema#decimal> "2322"^^<http://www.w3.org/2001/XMLSchema#decimal> "5277231.476"^^<http://www.w3.org/2001/XMLSchema#decimal> "8858"^^<http://www.w3.org/2001/XMLSchema#decimal> "12231"^^<http://www.w3.org/2001/XMLSchema#decimal> "143324.456"^^<http://www.w3.org/2001/XMLSchema#decimal> "712.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "198540"^^<http://www.w3.org/2001/XMLSchema#decimal> "154908.829"^^<http://www.w3.org/2001/XMLSchema#decimal> "40.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "12583.789"^^<http://www.w3.org/2001/XMLSchema#decimal> "1585540.918"^^<http://www.w3.org/2001/XMLSchema#decimal> "568621.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "1343745.639"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "376"^^<http://www.w3.org/2001/XMLSchema#decimal> "14845734.116"^^<http://www.w3.org/2001/XMLSchema#decimal> "15792344.945"^^<http://www.w3.org/2001/XMLSchema#decimal> "5207783"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "5759131.12"^^<http://www.w3.org/2001/XMLSchema#decimal> "2673"^^<http://www.w3.org/2001/XMLSchema#decimal> "5626488.879"^^<http://www.w3.org/2001/XMLSchema#decimal> "7565"^^<http://www.w3.org/2001/XMLSchema#decimal> "12529.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "146855.166"^^<http://www.w3.org/2001/XMLSchema#decimal> "637.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "195973.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "153121.158"^^<http://www.w3.org/2001/XMLSchema#decimal> "40.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "16712.389"^^<http://www.w3.org/2001/XMLSchema#decimal> "1681768.315"^^<http://www.w3.org/2001/XMLSchema#decimal> "573508.354"^^<http://www.w3.org/2001/XMLSchema#decimal> "1422071.968"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "413.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "15392676.149"^^<http://www.w3.org/2001/XMLSchema#decimal> "16339137.861"^^<http://www.w3.org/2001/XMLSchema#decimal> "5207783"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "5783693.146"^^<http://www.w3.org/2001/XMLSchema#decimal> "2511"^^<http://www.w3.org/2001/XMLSchema#decimal> "5878076.845"^^<http://www.w3.org/2001/XMLSchema#decimal> "8286"^^<http://www.w3.org/2001/XMLSchema#decimal> "12810.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "146239.778"^^<http://www.w3.org/2001/XMLSchema#decimal> "615.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "193874.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "148156.002"^^<http://www.w3.org/2001/XMLSchema#decimal> "40.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "12021.589"^^<http://www.w3.org/2001/XMLSchema#decimal> "1805698.485"^^<http://www.w3.org/2001/XMLSchema#decimal> "532896.782"^^<http://www.w3.org/2001/XMLSchema#decimal> "1385104.502"^^<http://www.w3.org/2001/XMLSchema#decimal> "44.59"^^<http://www.w3.org/2001/XMLSchema#decimal> "526.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "15704951.109"^^<http://www.w3.org/2001/XMLSchema#decimal> "16604712.883"^^<http://www.w3.org/2001/XMLSchema#decimal> "5207783"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 28 rows in 0.003 seconds.


https://eea.europa.eu./data-and-maps/daviz/sds/transport-energy-consumption-eea-5/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 siec: <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/>
PREFIX nrg_bal: <http://dd.eionet.europa.eu/vocabulary/eurostat/nrg_bal/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT 
year(?date) as ?date

?road_gasoline
?biogasoline
?road_diesel
?biodiesel
?natural_gas
?lpg
?electricity_road
?electricity_rail
?rail_diesel_gas_oil
?rail_residual_fuel_oil
?aviation_gasoline
?aviation_kerosene
?ship_diesel_gas_oil
?ship_residual_fuel_oil
?ship_gasoline 
?other_liquid_biofuels

#(?road_gasoline + ?road_diesel + ?natural_gas + ?lpg + ?rail_diesel_gas_oil + ?rail_residual_fuel_oil + ?aviation_gasoline + ?aviation_kerosene + ?ship_diesel_gas_oil + ?ship_residual_fuel_oil + ?ship_gasoline  + ?other_liquid_biofuels) as ?oil_derived_fuels

(?aviation_gasoline + ?ship_residual_fuel_oil + ?diesel + ?aviation_kerosene + ?lpg + ?gasoline) as ?oil_derived_fuels


(?gasoline + ?biogasoline + ?diesel + ?biodiesel_blended + ?natural_gas + ?lpg + ?electricity_road + ?electricity_rail + ?rail_diesel_gas_oil + ?rail_residual_fuel_oil + ?aviation_gasoline + ?aviation_kerosene + ?ship_diesel_gas_oil + ?ship_residual_fuel_oil + ?ship_gasoline  + ?other_liquid_biofuels) as ?total

round(17359275.323 *0.3) as ?annotation_line
{{

SELECT DISTINCT
  ?date
  sum(?road_gasoline) as ?road_gasoline
  sum(?biogasoline) as ?biogasoline
  sum(?road_diesel) as ?road_diesel
  sum(?biodiesel) as ?biodiesel
  sum(?natural_gas) as ?natural_gas
  sum(?lpg) as ?lpg
  sum(?electricity_road) as ?electricity_road
  sum(?electricity_rail) as ?electricity_rail
  sum(?rail_diesel_gas_oil) as ?rail_diesel_gas_oil
  sum(?rail_residual_fuel_oil) as ?rail_residual_fuel_oil
  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(?other_liquid_biofuels) as ?other_liquid_biofuels

  sum(?diesel) as ?diesel #<- not shown as single value
  sum(?gasoline) as ?gasoline #<- not shown as single value
  sum(?biodiesel_blended) as ?biodiesel_blended #<- not shown as single value
WHERE {
  {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_bal_c.rdf.gz> 
      {

        _:nrg_bal_c sdmx-dimension:timePeriod ?date .
        _:nrg_bal_c sdmx-attribute:unitMeasure unit:TJ .
        _:nrg_bal_c sdmx-dimension:refArea ?geo .
        {
            _:nrg_bal_c property:nrg_bal ?nrg_bal
            FILTER (?nrg_bal IN (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E)) .
            _:nrg_bal_c property:siec ?siec .
            FILTER (?siec IN (siec:O4651, siec:O4653)) .
            _:nrg_bal_c sdmx-measure:obsValue ?aviation_gasoline .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal in (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E, 
                     nrg_bal:INTMARB, nrg_bal:FC_TRA_ROAD_E, 
                     nrg_bal:FC_TRA_DNAVI_E))
            _:nrg_bal_c property:siec siec:R5210B .
            _:nrg_bal_c sdmx-measure:obsValue ?biogasoline .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal in (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E, 
                     nrg_bal:INTMARB, nrg_bal:FC_TRA_ROAD_E, 
                     nrg_bal:FC_TRA_DNAVI_E, nrg_bal:FC_TRA_RAIL_E))
            _:nrg_bal_c property:siec siec:R5220B .
            _:nrg_bal_c sdmx-measure:obsValue ?biodiesel .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal in (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E, 
                     nrg_bal:INTMARB, nrg_bal:FC_TRA_ROAD_E, 
                     nrg_bal:FC_TRA_DNAVI_E))
            _:nrg_bal_c property:siec siec:R5220B .
            _:nrg_bal_c sdmx-measure:obsValue ?biodiesel_blended .
        } UNION {
            _:nrg_bal_c property:nrg_bal nrg_bal:FC_TRA_ROAD_E .
            _:nrg_bal_c property:siec siec:E7000 .
            _:nrg_bal_c sdmx-measure:obsValue ?electricity_road .
        } UNION {
            _:nrg_bal_c property:nrg_bal nrg_bal:FC_TRA_RAIL_E .
            _:nrg_bal_c property:siec siec:E7000 .
            _:nrg_bal_c sdmx-measure:obsValue ?electricity_rail .
        } UNION {
            _:nrg_bal_c property:nrg_bal nrg_bal:FC_TRA_RAIL_E . 
            _:nrg_bal_c property:siec siec:O4680 .
            _:nrg_bal_c sdmx-measure:obsValue ?rail_residual_fuel_oil .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal IN (nrg_bal:INTMARB, nrg_bal:FC_TRA_DNAVI_E)) . 
            _:nrg_bal_c property:siec siec:O4680 .
            _:nrg_bal_c sdmx-measure:obsValue ?ship_residual_fuel_oil .
        } UNION {
            _:nrg_bal_c property:nrg_bal nrg_bal:FC_TRA_RAIL_E.
            _:nrg_bal_c property:siec siec:O4671XR5220B .
            _:nrg_bal_c sdmx-measure:obsValue ?rail_diesel_gas_oil .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal IN (nrg_bal:INTMARB, nrg_bal:FC_TRA_DNAVI_E)) .
            _:nrg_bal_c property:siec siec:O4671XR5220B .
            _:nrg_bal_c sdmx-measure:obsValue ?ship_diesel_gas_oil .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal IN (nrg_bal:FC_TRA_ROAD_E)) .
            _:nrg_bal_c property:siec siec:O4671XR5220B .
            _:nrg_bal_c sdmx-measure:obsValue ?road_diesel .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal IN (nrg_bal:FC_TRA_ROAD_E, nrg_bal:FC_TRA_DNAVI_E, 
                     nrg_bal:INTMARB, nrg_bal:FC_TRA_RAIL_E)) .
            _:nrg_bal_c property:siec siec:O4671XR5220B .
            _:nrg_bal_c sdmx-measure:obsValue ?diesel .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal IN (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E)) .
            _:nrg_bal_c property:siec siec:O4661XR5230B .
            _:nrg_bal_c sdmx-measure:obsValue ?aviation_kerosene.
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
             FILTER (?nrg_bal in (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E, 
                     nrg_bal:INTMARB, nrg_bal:FC_TRA_ROAD_E, 
                     nrg_bal:FC_TRA_DNAVI_E))
            _:nrg_bal_c property:siec siec:O4630 .
            _:nrg_bal_c sdmx-measure:obsValue ?lpg .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal in (nrg_bal:FC_TRA_ROAD_E))
            _:nrg_bal_c property:siec siec:O4652XR5210B .
            _:nrg_bal_c sdmx-measure:obsValue ?road_gasoline .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal in (nrg_bal:INTAVI, nrg_bal:FC_TRA_ROAD_E, 
                     nrg_bal:FC_TRA_DAVI_E, nrg_bal:FC_TRA_DNAVI_E))
            _:nrg_bal_c property:siec siec:O4652XR5210B .
            _:nrg_bal_c sdmx-measure:obsValue ?gasoline .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal IN (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E)) .
            _:nrg_bal_c property:siec siec:O4652XR5210B .
            _:nrg_bal_c sdmx-measure:obsValue ?ship_gasoline .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
             FILTER (?nrg_bal in (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E, 
                     nrg_bal:INTMARB, nrg_bal:FC_TRA_ROAD_E, 
                     nrg_bal:FC_TRA_DNAVI_E))
            _:nrg_bal_c property:siec siec:G3000 .
            _:nrg_bal_c sdmx-measure:obsValue ?natural_gas .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
             FILTER (?nrg_bal in (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E, 
                     nrg_bal:INTMARB, nrg_bal:FC_TRA_ROAD_E, 
                     nrg_bal:FC_TRA_DNAVI_E))
            _:nrg_bal_c property:siec siec:R5290 .
            _:nrg_bal_c sdmx-measure:obsValue ?other_liquid_biofuels .
        }

      }
   #FILTER (?geo in (geo:EU28, geo:LI, geo:NO, geo:CH, geo:TR, geo:IS))
   FILTER (?geo in (geo:EU28))
   #FILTER (year(?date) in (1990, 2008, 2017))
   }
}


}}
GROUP BY ?date 
ORDER BY ?date


Permalinks

Geographic coverage

Temporal coverage

Topics

Topics:

Tags

Filed under:
Filed under: transport energy
Document Actions