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

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

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.116 seconds.

JSON Url:
https://eea.europa.eu./data-and-maps/daviz/sds/real-price-indices-of-passenger-3/daviz.json

For system integrators

Linked Data query (SPARQL)

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

SPARQL Endpoint:
http://semantic.eea.europa.eu/sparql

SPARQL Query:


        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