Data table via SPARQL

Water use per capita and NUTS2 in 2007 (Eurostat demo_r_pjangroup and env_n2_wu)

Data table via SPARQL Published 17 Jan 2013 Last modified 26 Sep 2023

This page was archived on 26 Sep 2023 with reason: Other (Content is outdated. SPARQL endpoint is deprecated.)

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

nuts2code	nuts2	population	wateruse	percapita
"MK00"	"Poranesna jugoslovenska Republika Makedonija"	"2041941"^^<http://www.w3.org/2001/XMLSchema#decimal>	"226.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"110.87489795248736373871"^^<http://www.w3.org/2001/XMLSchema#decimal>
"PT15"	"Algarve"	"421528"^^<http://www.w3.org/2001/XMLSchema#decimal>	"45.03"^^<http://www.w3.org/2001/XMLSchema#decimal>	"106.82564384809550018029"^^<http://www.w3.org/2001/XMLSchema#decimal>
"CY00"	"Kypros"	"778684"^^<http://www.w3.org/2001/XMLSchema#decimal>	"73.9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"94.90370933523740053731"^^<http://www.w3.org/2001/XMLSchema#decimal>
"PT17"	"Lisboa"	"2794226"^^<http://www.w3.org/2001/XMLSchema#decimal>	"205.04"^^<http://www.w3.org/2001/XMLSchema#decimal>	"73.37989124716468889774"^^<http://www.w3.org/2001/XMLSchema#decimal>
"PT30"	"Regi\u00e3o Aut\u00f3noma da Madeira (PT)"	"245806"^^<http://www.w3.org/2001/XMLSchema#decimal>	"17.94"^^<http://www.w3.org/2001/XMLSchema#decimal>	"72.9843860605518172868"^^<http://www.w3.org/2001/XMLSchema#decimal>
"PT20"	"Regi\u00e3o Aut\u00f3noma dos A\u00e7ores (PT)"	"243018"^^<http://www.w3.org/2001/XMLSchema#decimal>	"13.47"^^<http://www.w3.org/2001/XMLSchema#decimal>	"55.42799298817371552724"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DE60"	"Hamburg"	"1754182"^^<http://www.w3.org/2001/XMLSchema#decimal>	"95.06"^^<http://www.w3.org/2001/XMLSchema#decimal>	"54.19050018755180477282"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DE21"	"Oberbayern"	"4279112"^^<http://www.w3.org/2001/XMLSchema#decimal>	"225.34"^^<http://www.w3.org/2001/XMLSchema#decimal>	"52.66045852503977460744"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DE91"	"Braunschweig"	"1641776"^^<http://www.w3.org/2001/XMLSchema#decimal>	"84.51"^^<http://www.w3.org/2001/XMLSchema#decimal>	"51.47474442311253179483"^^<http://www.w3.org/2001/XMLSchema#decimal>
"HU10"	"K\u00f6z\u00e9p-Magyarorsz\u00e1g"	"2872678"^^<http://www.w3.org/2001/XMLSchema#decimal>	"144.87"^^<http://www.w3.org/2001/XMLSchema#decimal>	"50.43029535506590018094"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 25 rows in 0.001 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/eionet/data/eea-data/water-use-per-capita-and-nuts2-in-2007-eurostat-demo_r_pjangroup-and-env_n2_wu/daviz.json

For system integrators

Linked Data query (SPARQL)

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

SPARQL Endpoint:
http://semantic.eea.europa.eu/sparql

SPARQL Query:


        PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX estat: <http://rdfdata.eionet.europa.eu/eurostat/property#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX g: <http://rdfdata.eionet.europa.eu/ramon/ontology/>
PREFIX dataset: <http://rdfdata.eionet.europa.eu/eurostat/data/>

SELECT ?nuts2code ?nuts2
       ?population
       ?wateruse
       xsd:decimal(?wateruse)*1000000/SUM(xsd:decimal(?population)) AS ?percapita
WHERE {
 GRAPH dataset:demo_r_pjangroup.rdf.gz {
  ?observation qb:dataSet dataset:demo_r_pjangroup ;
            sdmx-dimension:timePeriod "2007-01-01"^^xsd:date;
            estat:age <http://rdfdata.eionet.europa.eu/eurostat/dic/age#TOTAL>; 
            estat:sex <http://rdfdata.eionet.europa.eu/eurostat/dic/sex#T>;
            estat:geo ?ugeo;
            sdmx-measure:obsValue ?population.
 }

 GRAPH dataset:env_n2_wu.rdf.gz {
  ?wuregion qb:dataSet dataset:env_n2_wu ;
            estat:geo ?ugeo;
            estat:cons <http://rdfdata.eionet.europa.eu/eurostat/dic/cons#W18_2_7_2>; 
            sdmx-dimension:timePeriod "2007-01-01"^^xsd:date;
            sdmx-measure:obsValue ?wateruse.
 }
 ?ugeo rdfs:label ?nuts2;
       skos:notation ?nuts2code
} ORDER BY DESC(?percapita)
LIMIT 25

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 1201, in do_open
    r = h.getresponse(buffering=True)
  File "/usr/local/lib/python2.7/httplib.py", line 1148, in getresponse
    response.begin()
  File "/usr/local/lib/python2.7/httplib.py", line 448, in begin
    version, status, reason = self._read_status()
  File "/usr/local/lib/python2.7/httplib.py", line 404, in _read_status
    line = self.fp.readline(_MAXLINE + 1)
  File "/usr/local/lib/python2.7/socket.py", line 480, in readline
    data = self._sock.recv(self._rbufsize)
  File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/green/ssl.py", line 194, in recv
    return self._base_recv(buflen, flags, into=False)
  File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/green/ssl.py", line 227, in _base_recv
    read = self.read(nbytes)
  File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/green/ssl.py", line 139, in read
    super(GreenSSLSocket, self).read, *args, **kwargs)
  File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/green/ssl.py", line 119, in _call_trampolining
    timeout_exc=timeout_exc('timed out'))
  File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/hubs/__init__.py", line 163, in trampoline
    return hub.switch()
  File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/hubs/hub.py", line 295, in switch
    return self.greenlet.switch()
SSLError: ('timed out',)