Trends in share of household expenditure on transport (percentage of total spending, EEA-32)

Data table via SPARQL Published 22 Jan 2013 Last modified 07 May 2019

Download this dataset

Dataset preview

(Live Query)

year CP07 CP071 CP072 CP073 TOTAL share_cp07 share_cp071 share_cp072 share_cp073
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "15972"^^<http://www.w3.org/2001/XMLSchema#decimal> "1775"^^<http://www.w3.org/2001/XMLSchema#decimal> "3011"^^<http://www.w3.org/2001/XMLSchema#decimal> "1207"^^<http://www.w3.org/2001/XMLSchema#decimal> "230419"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "15062"^^<http://www.w3.org/2001/XMLSchema#decimal> "1642"^^<http://www.w3.org/2001/XMLSchema#decimal> "3289"^^<http://www.w3.org/2001/XMLSchema#decimal> "1365"^^<http://www.w3.org/2001/XMLSchema#decimal> "245465"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "15371"^^<http://www.w3.org/2001/XMLSchema#decimal> "1675"^^<http://www.w3.org/2001/XMLSchema#decimal> "3420"^^<http://www.w3.org/2001/XMLSchema#decimal> "1452"^^<http://www.w3.org/2001/XMLSchema#decimal> "247943"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "16139"^^<http://www.w3.org/2001/XMLSchema#decimal> "1795"^^<http://www.w3.org/2001/XMLSchema#decimal> "3458"^^<http://www.w3.org/2001/XMLSchema#decimal> "1492"^^<http://www.w3.org/2001/XMLSchema#decimal> "278209"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "17601"^^<http://www.w3.org/2001/XMLSchema#decimal> "2235"^^<http://www.w3.org/2001/XMLSchema#decimal> "3518"^^<http://www.w3.org/2001/XMLSchema#decimal> "1625"^^<http://www.w3.org/2001/XMLSchema#decimal> "259611"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "542227"^^<http://www.w3.org/2001/XMLSchema#decimal> "180901"^^<http://www.w3.org/2001/XMLSchema#decimal> "263900"^^<http://www.w3.org/2001/XMLSchema#decimal> "86478"^^<http://www.w3.org/2001/XMLSchema#decimal> "4294652"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "587490"^^<http://www.w3.org/2001/XMLSchema#decimal> "202371"^^<http://www.w3.org/2001/XMLSchema#decimal> "281983"^^<http://www.w3.org/2001/XMLSchema#decimal> "92236"^^<http://www.w3.org/2001/XMLSchema#decimal> "4541443"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "625341"^^<http://www.w3.org/2001/XMLSchema#decimal> "215442"^^<http://www.w3.org/2001/XMLSchema#decimal> "298662"^^<http://www.w3.org/2001/XMLSchema#decimal> "100447"^^<http://www.w3.org/2001/XMLSchema#decimal> "4800333"^^<http://www.w3.org/2001/XMLSchema#decimal> "13"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "682002"^^<http://www.w3.org/2001/XMLSchema#decimal> "233648"^^<http://www.w3.org/2001/XMLSchema#decimal> "306361"^^<http://www.w3.org/2001/XMLSchema#decimal> "106726"^^<http://www.w3.org/2001/XMLSchema#decimal> "5070343"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "730358"^^<http://www.w3.org/2001/XMLSchema#decimal> "251090"^^<http://www.w3.org/2001/XMLSchema#decimal> "327866"^^<http://www.w3.org/2001/XMLSchema#decimal> "113410"^^<http://www.w3.org/2001/XMLSchema#decimal> "5327142"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.1"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 23 rows in 0.003 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/eionet/data/local-sparql-queries/trends-in-share-of-household-expenditure-on-transport-percentage-of-total-spending-eea-32/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 skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX c: <http://rdfdata.eionet.europa.eu/eurostat/dic/coicop#> 
PREFIX u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#> 

SELECT 
YEAR(?date) as ?year 
sum(?valCP07) as ?CP07 
sum(?valCP071) as ?CP071 
sum(?valCP072) as ?CP072 
sum(?valCP073) as ?CP073 
sum(?valTOTAL) as ?TOTAL 
(round((sum(?valCP07)/sum(?valTOTAL))*1000))/10.0 as ?share_cp07
(round((sum(?valCP071)/sum(?valTOTAL))*1000))/10.0 as ?share_cp071
(round((sum(?valCP072)/sum(?valTOTAL))*1000))/10.0 as ?share_cp072
(round((sum(?valCP073)/sum(?valTOTAL))*1000))/10.0 as ?share_cp073
WHERE { 
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_co3_c.rdf.gz> { 
	_:total sdmx-dimension:timePeriod ?date. 
	_:total property:geo ?ugeo . 
	_:total property:coicop c:TOTAL . 
	_:total property:unit u:MIO_EUR . 
	_:total sdmx-measure:obsValue ?totalFake. 
	
        _:guard sdmx-dimension:timePeriod ?date . 
	_:guard property:geo ?ugeo .
	_:guard property:coicop c:TOTAL . 
	_:guard property:unit u:MIO_EUR. 
	_:guard sdmx-measure:obsValue ?total. 
	{ 
	_:x sdmx-dimension:timePeriod ?date . 
	_:x property:geo ?ugeo . 
	_:x property:coicop c:CP07, _:l . 
	_:x property:unit u:MIO_EUR . 
        _:x sdmx-measure:obsValue ?valCP07. 
	} UNION { 
	_:x sdmx-dimension:timePeriod ?date . 
	_:x property:geo ?ugeo . 
	_:x property:coicop c:CP071, _:l . 
	_:x property:unit u:MIO_EUR . 
        _:x sdmx-measure:obsValue ?valCP071. 
	} UNION { 
	_:x sdmx-dimension:timePeriod ?date . 
	_:x property:geo ?ugeo . 
	_:x property:coicop c:CP072, _:l . 
	_:x property:unit u:MIO_EUR . 
        _:x sdmx-measure:obsValue ?valCP072.
	} UNION { 
	_:x sdmx-dimension:timePeriod ?date . 
	_:x property:geo ?ugeo. 
	_:x property:coicop c:CP073, _:l . 
	_:x property:unit u:MIO_EUR . 
        _:x sdmx-measure:obsValue ?valCP073.
	} UNION { 
	_:x sdmx-dimension:timePeriod ?date . 
	_:x property:geo ?ugeo. 
	_:x property:coicop c:TOTAL, _:l . 
	_:x property:unit u:MIO_EUR . 
        _:x sdmx-measure:obsValue ?valTOTAL.
	} 
  } 
FILTER((?date >= "1990-01-01"^^xsd:date) && (regex(?ugeo , "EU27") || regex(?ugeo , "IS") || regex(?ugeo , "CH") || regex(?ugeo , "NO") || regex(?ugeo , "TR")))
} group by ?date order by ?date

Error when running query:

Query timeout. unknown url type: 


Related content

Document Actions