Data table via SPARQL

Water use per capita and NUTS2 in 2007

Data table via SPARQL Published 03 Oct 2012 Last modified 09 Sep 2024

Eurostat datasets demo_r_pjanaggr3 and env_n2_wu

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.025 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/eionet/data/local-sparql-queries/water-use-per-capita-and-nuts2-in-2007/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 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