next
previous
items

Data table via SPARQL

Total central government debt % of GDP (OECD)

Download this dataset

Dataset preview

(Live Query)

country period year_label year value
"Austria" "2000-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2000" "2000"^^<http://www.w3.org/2001/XMLSchema#int> "61.188"^^<http://www.w3.org/2001/XMLSchema#double>
"Austria" "2001-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2001" "2001"^^<http://www.w3.org/2001/XMLSchema#int> "60.659"^^<http://www.w3.org/2001/XMLSchema#double>
"Austria" "2002-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2002" "2002"^^<http://www.w3.org/2001/XMLSchema#int> "60.401"^^<http://www.w3.org/2001/XMLSchema#double>
"Austria" "2003-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2003" "2003"^^<http://www.w3.org/2001/XMLSchema#int> "60.882"^^<http://www.w3.org/2001/XMLSchema#double>
"Austria" "2004-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2004" "2004"^^<http://www.w3.org/2001/XMLSchema#int> "62.242"^^<http://www.w3.org/2001/XMLSchema#double>
"Austria" "2005-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2005" "2005"^^<http://www.w3.org/2001/XMLSchema#int> "62.116"^^<http://www.w3.org/2001/XMLSchema#double>
"Austria" "2006-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2006" "2006"^^<http://www.w3.org/2001/XMLSchema#int> "60.434"^^<http://www.w3.org/2001/XMLSchema#double>
"Austria" "2007-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2007" "2007"^^<http://www.w3.org/2001/XMLSchema#int> "57.829"^^<http://www.w3.org/2001/XMLSchema#double>
"Austria" "2008-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2008" "2008"^^<http://www.w3.org/2001/XMLSchema#int> "59.319"^^<http://www.w3.org/2001/XMLSchema#double>
"Austria" "2009-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "2009" "2009"^^<http://www.w3.org/2001/XMLSchema#int> "64.916"^^<http://www.w3.org/2001/XMLSchema#double>

Received 239 rows in 0.049 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/eionet/data/eionet-data/total-central-government-debt-of-gdp-oecd-4/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://cr.eionet.europa.eu/sparql

PREFIX tableFile: <http://cr.eionet.europa.eu/home/roug/OECD_GOV_DEBT_Data.csv#>

SELECT ?country xsd:date(concat(STR(?period),'-01-01')) AS ?period xsd:string(?period) AS ?year_label ?period AS ?year ?value
FROM <http://cr.eionet.europa.eu/home/roug/OECD_GOV_DEBT_Data.csv>
WHERE { 
 ?GovernmentDebt tableFile:Variable "Total central government debt % of GDP" . 
 ?GovernmentDebt tableFile:Unit "Percentage" . 
 ?GovernmentDebt tableFile:Country ?country . 
 ?GovernmentDebt tableFile:period ?period . 
 ?GovernmentDebt tableFile:Value ?value . 
 ?GovernmentDebt tableFile:Flags ?Flags . 
FILTER(?country IN ("Austria", "Belgium", "Czech Republic", "Denmark", "Estonia", "Finland", "France", "Germany",
"Greece", "Hungary", "Iceland", "Ireland", "Italy", "Netherlands", "Poland", "Portugal", "Slovak Republic",
"Slovenia", "Spain", "Sweden", "United Kingdom", "United States"))
} ORDER BY ?country ?period

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 429, in open
    response = self._open(req, data)
  File "/usr/local/lib/python2.7/urllib2.py", line 447, in _open
    '_open', req)
  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 1241, in https_open
    context=self._context)
  File "/usr/local/lib/python2.7/urllib2.py", line 1198, in do_open
    raise URLError(err)
URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:727)>


Document Actions