Population growth in percent from 2005 to 2006 in Mediterranean countries (Eurostat)

Data table via SPARQL Published 04 Oct 2012 Last modified 21 May 2019

Download this dataset

Dataset preview

(Live Query)

country sex year2005 year2006 pctGrowth

Received 0 rows in 0.064 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/population-growth-in-percent-from/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 qb: <http://purl.org/linked-data/cube#>
PREFIX estat: <http://eurostat.linked-statistics.org/property#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX dataset: <http://eurostat.linked-statistics.org/data/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT ?country ?sex sum(?lowyear) AS ?year2005
  sum(?highyear) AS ?year2006 
((sum(?highyear) - sum(?lowyear)) / sum(?lowyear) * 100) AS ?pctGrowth
FROM <http://eurostat.linked-statistics.org/data/med_ps112.rdf>
FROM <http://eurostat.linked-statistics.org/dic/geo.rdf>
FROM <http://eurostat.linked-statistics.org/dic/sex.rdf>
WHERE {
  ?popobs qb:dataSet dataset:med_ps112;
        sdmx-dimension:freq <http://purl.org/linked-data/sdmx/2009/code#freq-A>;
        estat:sex <http://eurostat.linked-statistics.org/dic/sex#T>, ?usex;
        estat:age <http://eurostat.linked-statistics.org/dic/age#TOTAL>;
        estat:geo ?ucountry
 {
  ?popobs sdmx-dimension:timePeriod "2005-01-01"^^xsd:date;
        sdmx-measure:obsValue ?lowyear
 } UNION
 {
  ?popobs sdmx-dimension:timePeriod "2006-01-01"^^xsd:date;
        sdmx-measure:obsValue ?highyear
 }
  ?ucountry rdfs:label ?country.
  ?usex rdfs:label ?sex.
} GROUP BY ?country ?sex ORDER BY ?country


Document Actions