Real price indices of passenger transport

Data table via SPARQL Published 19 Oct 2017 Last modified 13 Nov 2017
31 min read
This is an old version, kept for reference only.

Go to latest version
Topics: ,

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" "Passenger 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" "Passenger 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 5034 rows in 0.488 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/real-price-indices-of-passenger-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 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
bif:either(?coicop_label = 'Motor cars', 'Passenger cars', ?coicop_label) as ?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


Related content

Temporal coverage

Document Actions
Filed under: