next
previous
items

Data table via SPARQL

Real price indices of passenger transport

Data table via SPARQL Published 27 Aug 2018 Last modified 24 Jun 2020
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 5383 rows in 0.129 seconds.


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