Data table via SPARQL
Index trendline for Population
Data table via SPARQL
Published 27 Aug 2015
Last modified 15 Sep 2021
Download this dataset
Dataset preview
(Live Query)
Received 743 rows in 0.065 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
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 19 Sep 2021, 08:08 AM
Tags
Filed under:
population
Document Actions
Share with others