next
previous
items

Data table via SPARQL

Real price indices of passenger transport

Data table via SPARQL Published 03 Nov 2015 Last modified 14 Jul 2016
This is an old version, kept for reference only.

Go to latest version

Download this dataset

Dataset preview

(Live Query)

date ugeo coicop_label value total ratio
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Transport" "73.84"^^<http://www.w3.org/2001/XMLSchema#decimal> "71.77"^^<http://www.w3.org/2001/XMLSchema#decimal> "102.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Passenger transport by road" "62.64"^^<http://www.w3.org/2001/XMLSchema#decimal> "71.77"^^<http://www.w3.org/2001/XMLSchema#decimal> "87.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Passenger transport by railway" "59.87"^^<http://www.w3.org/2001/XMLSchema#decimal> "71.77"^^<http://www.w3.org/2001/XMLSchema#decimal> "83.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Operation of personal transport equipment" "62.14"^^<http://www.w3.org/2001/XMLSchema#decimal> "71.77"^^<http://www.w3.org/2001/XMLSchema#decimal> "86.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Motor cars" "91.79"^^<http://www.w3.org/2001/XMLSchema#decimal> "71.77"^^<http://www.w3.org/2001/XMLSchema#decimal> "127.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "Operation of personal transport equipment" "56.38"^^<http://www.w3.org/2001/XMLSchema#decimal> "70.48"^^<http://www.w3.org/2001/XMLSchema#decimal> "80"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "Passenger transport by road" "76.51"^^<http://www.w3.org/2001/XMLSchema#decimal> "70.48"^^<http://www.w3.org/2001/XMLSchema#decimal> "108.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "Transport" "66.58"^^<http://www.w3.org/2001/XMLSchema#decimal> "70.48"^^<http://www.w3.org/2001/XMLSchema#decimal> "94.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "Motor cars" "83.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "70.48"^^<http://www.w3.org/2001/XMLSchema#decimal> "118.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "Passenger transport by railway" "72.22"^^<http://www.w3.org/2001/XMLSchema#decimal> "70.48"^^<http://www.w3.org/2001/XMLSchema#decimal> "102.5"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 4852 rows in 0.621 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/real-price-indices-of-passenger-3/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 coicop: <http://dd.eionet.europa.eu/vocabulary/eurostat/coicop/> 
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>

SELECT DISTINCT
year(?date) as ?date
?ugeo
?coicop_label
?value
?total
round((?value/?total)*1000)/10.0 as ?ratio

WHERE {
{  
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/prc_hicp_aind.rdf.gz> 
  { 
    _:prc_hicp_aind sdmx-dimension:refArea ?geo .
    _:prc_hicp_aind sdmx-attribute:unitMeasure unit:INX_A_AVG .
    _:prc_hicp_aind sdmx-dimension:timePeriod ?date . 

    _:prc_hicp_aind property:coicop ?coicop .
    FILTER (?coicop in (coicop:CP07, coicop:CP0711, coicop:CP072, coicop:CP0731, 
             coicop:CP0732, coicop:CP0733, coicop:CP0734))
    _:prc_hicp_aind sdmx-measure:obsValue ?value .
  
    _:prc_hicp_aind_tot sdmx-dimension:refArea ?geo .
    _:prc_hicp_aind_tot sdmx-attribute:unitMeasure unit:INX_A_AVG .
    _:prc_hicp_aind_tot sdmx-dimension:timePeriod ?date .
    _:prc_hicp_aind_tot property:coicop coicop:CP00 .
    _:prc_hicp_aind_tot sdmx-measure:obsValue ?total .

   } 
  }
  ?geo rdfs:label ?ugeo . 
  ?coicop rdfs:label ?coicop_label .
  FILTER (year(?date) > 1995)

}
GROUP BY ?date ?ugeo ?coicop_label
ORDER BY ?date ?ugeo


Document Actions