next
previous
items

Data table via SPARQL

Real price indices of passenger transport

Data table via SPARQL Published 31 Jul 2019 Last modified 24 Jun 2020
31 min read
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 5862 rows in 0.141 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/real-price-indices-of-passenger-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 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


Permalinks

Geographic coverage

Temporal coverage

Topics

Topics:

Tags

Filed under:
Filed under: passenger transport
Document Actions