Data table via SPARQL
Index trendline for Population
Data table via SPARQL
Published 27 Aug 2015
Last modified 05 Oct 2022
Download this dataset
Dataset preview
(Live Query)
Received 743 rows in 0.015 seconds.
https://www.eea.europa.eu/data-and-maps/daviz/sds/index-trendline-for-population-on/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.
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 rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#>
PREFIX age: <http://dd.eionet.europa.eu/vocabulary/eurostat/age/>
PREFIX sex: <http://purl.org/linked-data/sdmx/2009/code#>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
SELECT
year(?date) as ?date
bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
'Population' as ?category
round((?demo_pjan/?demo_pjan_idx)*1000)/10.0 as ?index
#?demo_pjan
#?demo_pjan_idx
WHERE {
{
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/demo_pjan.rdf.gz>
{
_:demo_pjan sdmx-dimension:timePeriod ?date . FILTER (year(?date) >= 2000)
_:demo_pjan sdmx-dimension:refArea ?geo .
_:demo_pjan sdmx-dimension:age age:TOTAL .
_:demo_pjan sdmx-dimension:sex sex:sex-T .
_:demo_pjan sdmx-measure:obsValue ?demo_pjan .
_:demo_pjan_idx sdmx-dimension:timePeriod ?date_idx . FILTER (year(?date_idx) = 2000)
_:demo_pjan_idx sdmx-dimension:refArea ?geo .
_:demo_pjan_idx sdmx-dimension:age age:TOTAL .
_:demo_pjan_idx sdmx-dimension:sex sex:sex-T .
_:demo_pjan_idx sdmx-measure:obsValue ?demo_pjan_idx .
}
?geo rdf-schema:label ?ugeo .
FILTER (?geo != geo:NO && ?geo != geo:RS && ?geo != geo:EU27 &&?geo != geo:EA19 && ?geo != geo:EA && ?geo != geo:EA12 && ?geo != geo:EA17 && ?geo != geo:EA18 && ?geo != geo:EU15 && ?geo != geo:JP && ?geo != geo:MK && ?geo != geo:US && ?geo != geo:ME && ?geo != geo:AL && ?geo != geo:AD && ?geo != geo:AM && ?geo != geo:AZ && ?geo != geo:EA16 && ?geo != geo:EEA30 && ?geo != geo:EEA31 && ?geo != geo:EFTA && ?geo != geo:ME && ?geo != geo:UA && ?geo != geo:RU && ?geo != geo:MD && ?geo != geo:DE_TOT && ?geo != geo:BY && ?geo != geo:BA && ?geo != geo:FX && ?geo != geo:GE && ?geo != geo:LI && ?geo != geo:IS)
}
}
GROUP BY ?ugeo ?geo
ORDER BY ?ugeo ?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 500:
Permalinks
- Permalink to this version
- c9a9425f84f242beb3b2625eba97e2e7
- Permalink to latest version
- 0OYNFBQEMS
Older versions
Geographic coverage
Temporal coverage
Dynamic
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/index-trendline-for-population-on or scan the QR code.
PDF generated on 06 Oct 2022, 08:26 PM
Tags
Filed under:
population
Document Actions
Share with others