next
previous
items

Data table via SPARQL

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

Data table via SPARQL Published 29 Jan 2013 Last modified 31 Aug 2022

Download this dataset

Dataset preview

(Live Query)

year CP07 CP071 CP072 CP073 TOTAL Transport_total Purchase_of_vehicles Operation_of_personal_transport_equipment Transport_services
"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.93"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.77"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.31"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.52"^^<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.14"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.67"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.34"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.56"^^<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.68"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.38"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.59"^^<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.65"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.24"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.54"^^<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.78"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.86"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.36"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.63"^^<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.63"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.21"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.14"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.01"^^<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.94"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.46"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.21"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.03"^^<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.03"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.49"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.22"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.09"^^<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.45"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.61"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.04"^^<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.71"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.71"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.15"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.13"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 23 rows in 0.048 seconds.


https://eea.europa.eu./data-and-maps/daviz/sds/term024-trends-in-share-of/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

#http://www.eea.europa.eu/data-and-maps/figures/term24-trends-in-share-of-household-expenditure-on-transport-percentage-of-total-spending-eea#
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
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#> 
PREFIX g: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#> 

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))*10000))/100.0 as ?Transport_total
(round((sum(?valCP071)/sum(?valTOTAL))*10000))/100.0 as ?Purchase_of_vehicles
(round((sum(?valCP072)/sum(?valTOTAL))*10000))/100.0 as ?Operation_of_personal_transport_equipment
(round((sum(?valCP073)/sum(?valTOTAL))*10000))/100.0 as ?Transport_services
WHERE { 
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_co3_c.rdf.gz> { 
        _:x sdmx-dimension:timePeriod ?date . FILTER (?date >= "1990-01-01"^^xsd:date)
	_:x property:geo ?ugeo . FILTER ( ?ugeo IN (g:EU27, g:IS, g:CH, g:NO, g:TR)) 
        _:x property:unit u:MIO_EUR. 
	{ 
	_:x property:coicop c:CP07 . 
        _:x sdmx-measure:obsValue ?valCP07. 
	} UNION { 
	_:x property:coicop c:CP071 . 
        _:x sdmx-measure:obsValue ?valCP071. 
	} UNION { 
	_:x property:coicop c:CP072 . 
        _:x sdmx-measure:obsValue ?valCP072.
	} UNION { 
	_:x property:coicop c:CP073 . 
        _:x sdmx-measure:obsValue ?valCP073.
	} UNION { 
	_:x property:coicop c:TOTAL . 
        _:x sdmx-measure:obsValue ?valTOTAL.
	} 
  } 
} group by ?date order by ?date

Error when running query:

Error. Traceback (most recent call last):
  File "/plone/buildout-cache/eggs/Products.ZSPARQLMethod-2.3-py2.7.egg/Products/ZSPARQLMethod/Method.py", line 287, in run_with_timeout
    ret = func(*args, **kwargs)
  File "/plone/buildout-cache/eggs/Products.ZSPARQLMethod-2.3-py2.7.egg/Products/ZSPARQLMethod/Method.py", line 215, in query_and_get_result
    result = sparql.query(*args, timeout = kwargs.get("timeout", 0) or 0)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 747, in query
    return s.query(query, timeout, raw=raw)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 416, in query
    return q.query(query, timeout, raw=raw)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 571, in query
    response = self._request(statement, timeout)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 561, in _request
    response = self._build_response(query, opener, buf, timeout)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 543, in _build_response
    timeout if timeout > 0 else None)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 514, in _get_response
    response = opener.open(request, timeout=timeout)
  File "/usr/local/lib/python2.7/urllib2.py", line 435, in open
    response = meth(req, response)
  File "/usr/local/lib/python2.7/urllib2.py", line 548, in http_response
    'http', request, response, code, msg, hdrs)
  File "/usr/local/lib/python2.7/urllib2.py", line 473, in error
    return self._call_chain(*args)
  File "/usr/local/lib/python2.7/urllib2.py", line 407, in _call_chain
    result = func(*args)
  File "/usr/local/lib/python2.7/urllib2.py", line 556, in http_error_default
    raise HTTPError(req.get_full_url(), code, msg, hdrs, fp)
HTTPError: HTTP Error 503: Service Unavailable


Permalinks

Document Actions