next
previous
items

Data table via SPARQL

Waste generation and decoupling - population

Data table via SPARQL Published 22 Jul 2019 Last modified 22 Apr 2024

Download this dataset

Dataset preview

(Live Query)

date ugeo label index
"2010"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries (2013-2020)" "Average population - total" "100"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries (2013-2020)" "Average population - total" "99.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries (2013-2020)" "Average population - total" "100.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries (2013-2020)" "Average population - total" "100.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2014"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries (2013-2020)" "Average population - total" "100.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries (2013-2020)" "Average population - total" "101.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries (2013-2020)" "Average population - total" "101.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries (2013-2020)" "Average population - total" "101.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2018"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries (2013-2020)" "Average population - total" "101.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2019"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries (2013-2020)" "Average population - total" "102"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 10 rows in 0.001 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/waste-generation-and-decoupling-population/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 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 property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/> 
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/> 
PREFIX hazard: <http://dd.eionet.europa.eu/vocabulary/eurostat/hazard/>
PREFIX waste: <http://dd.eionet.europa.eu/vocabulary/eurostat/waste/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX indic_de: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_de/> 


SELECT DISTINCT
year(?date) as ?date
?ugeo
?label
round((sum(?obsValue)/sum(?obsValue_idx))*1000)/10.0 as ?index

  {{
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/demo_gind.rdf.gz> 
      {
        _:demo_gind sdmx-dimension:timePeriod ?date .
        _:demo_gind sdmx-dimension:refArea ?geo .
        _:demo_gind property:indic_de ?indic_de .
        _:demo_gind sdmx-measure:obsValue ?obsValue .

        _:demo_gind_idx sdmx-dimension:timePeriod ?date_idx .
        FILTER (year(?date_idx) = 2010)
        _:demo_gind_idx sdmx-dimension:refArea ?geo .
        _:demo_gind_idx property:indic_de ?indic_de .
        _:demo_gind_idx sdmx-measure:obsValue ?obsValue_idx .

        FILTER (?indic_de = indic_de:AVG)
      }
      

  }
  ?indic_de rdfs:label ?label .
  ?geo rdfs:label ?ugeo .
  FILTER (?geo = geo:EU28)
  FILTER (year(?date) >= 2010)
}
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 558, 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 308: Permanent Redirect


Permalinks

Geographic coverage

Temporal coverage

Tags

Filed under:
Filed under: population
Document Actions