Data table via SPARQL

Sweden's counties joined with population and summary from DBPedia

Data table via SPARQL Published 05 Jul 2012 Last modified 18 Nov 2024

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)

len	name	dbpedia	population	dblabel
<http://www.viss.lansstyrelsen.se/rdf/counties.rdf#_01>	"01 - Stockholm"	<http://dbpedia.org/resource/Stockholm_County>	"2084526"^^<http://www.w3.org/2001/XMLSchema#int>	"Stockholm County (Stockholms l\u00e4n) is a county or l\u00e4n on the Baltic sea coast of Sweden. It borders Uppsala County and S\u00f6dermanland County. It also borders M\u00e4laren and the Baltic Sea. The city of Stockholm is the capital of Sweden. Stockholm County is divided by the historic provinces of Uppland and S\u00f6dermanland. More than one fifth of the Swedish population lives in the county. Stockholm County is also one of the statistical riksomr\u00e5den (national areas) according to NUTS:SE, Nomenclature of Territorial Units for Statistics within the EU. Stockholm County is, with its more than two million inhabitants, the most densely populated of the 21 administrative counties of Sweden."@en
<http://www.viss.lansstyrelsen.se/rdf/counties.rdf#_03>	"03 - Uppsala"	<http://dbpedia.org/resource/Uppsala_County>	"336533"^^<http://www.w3.org/2001/XMLSchema#int>	"Uppsala County (Uppsala l\u00e4n) is a county or l\u00e4n on the eastern coast of Sweden. It borders the counties of Stockholm, S\u00f6dermanland, V\u00e4stmanland, G\u00e4vleborg, and the Baltic Sea."@en
<http://www.viss.lansstyrelsen.se/rdf/counties.rdf#_04>	"04 - S\u00f6dermanland"	<http://dbpedia.org/resource/S%C3%B6dermanland_County>	"270981"^^<http://www.w3.org/2001/XMLSchema#int>	"S\u00f6dermanland County (S\u00f6dermanlands l\u00e4n) is a county or l\u00e4n on the south east coast of Sweden. It borders the counties of \u00d6sterg\u00f6tland, \u00d6rebro, V\u00e4stmanland, Uppsala, Stockholm and to the Baltic sea. It is an administrative unit, covering most of the province S\u00f6dermanland. The eastern parts of the S\u00f6dermanland province, largely corresponding to the S\u00f6dert\u00f6rn area, belong to Stockholm County. S\u00f6dermanland is the wealthiest county in Sweden at the moment due to wealthy cities such as Trosa, which holds the position of 4th wealthiest community in Sweden, within its borders."@en
<http://www.viss.lansstyrelsen.se/rdf/counties.rdf#_05>	"05 - \u00d6sterg\u00f6tland"	<http://dbpedia.org/resource/%C3%96sterg%C3%B6tland_County>	"429852"^^<http://www.w3.org/2001/XMLSchema#int>	"\u00d6sterg\u00f6tland County (\u00d6sterg\u00f6tlands l\u00e4n) is a county or l\u00e4n in southeastern Sweden. It borders the counties of Kalmar to the southeast, J\u00f6nk\u00f6ping to the southwest, V\u00e4stra G\u00f6taland to the west, \u00d6rebro to the northwest, S\u00f6dermanland to the northeast, and the Baltic Sea to the east. \u00d6sterg\u00f6tland County has a population of 429 852 (March 31, 2011) and the capital and biggest city is Link\u00f6ping. Link\u00f6ping and neighbouring twin city Norrk\u00f6ping together form one of Sweden's biggest metropolitan areas; The Link\u00f6ping-Norrk\u00f6ping Corridor is therefore often referred to as The Fourth Metropolitan Region of Sweden, the other three being Stockholm, Gothenburg and Malm\u00f6."@en
<http://www.viss.lansstyrelsen.se/rdf/counties.rdf#_06>	"06 - J\u00f6nk\u00f6ping"	<http://dbpedia.org/resource/J%C3%B6nk%C3%B6ping_County>	"337013"^^<http://www.w3.org/2001/XMLSchema#int>	"J\u00f6nk\u00f6ping County (J\u00f6nk\u00f6pings l\u00e4n) is a county or l\u00e4n in southern Sweden. It borders the counties of Halland, V\u00e4stra G\u00f6taland, \u00d6sterg\u00f6tland, Kalmar and Kronoberg. The capital is J\u00f6nk\u00f6ping."@en
<http://www.viss.lansstyrelsen.se/rdf/counties.rdf#_07>	"07 - Kronoberg"	<http://dbpedia.org/resource/Kronoberg_County>	"183988"^^<http://www.w3.org/2001/XMLSchema#int>	"Kronoberg County (Kronobergs l\u00e4n) is a County or l\u00e4n in southern Sweden. It borders the counties of Sk\u00e5ne, Halland, J\u00f6nk\u00f6ping, Kalmar and Blekinge. Its capital is the city V\u00e4xj\u00f6."@en
<http://www.viss.lansstyrelsen.se/rdf/counties.rdf#_08>	"08 - Kalmar"	<http://dbpedia.org/resource/Kalmar_County>	"233168"^^<http://www.w3.org/2001/XMLSchema#int>	"Kalmar County (Kalmar l\u00e4n) is a county or l\u00e4n in southern Sweden. It borders the counties of Kronoberg, J\u00f6nk\u00f6ping, Blekinge and \u00d6sterg\u00f6tland. To the east in the Baltic Sea is the island Gotland. The counties are mainly administrative units. Geographically Kalmar County covers the eastern part in the Sm\u00e5land province, and the entire island of \u00d6land. For the areas history and culture, see those areas."@en
<http://www.viss.lansstyrelsen.se/rdf/counties.rdf#_09>	"09 - Gotland"	<http://dbpedia.org/resource/Gotland_County>	"57203"^^<http://www.w3.org/2001/XMLSchema#int>	"Gotland County (Gotlands l\u00e4n) is a county or l\u00e4n of Sweden. Gotland is located in the Baltic Sea to the east of \u00d6land, and is the largest of Sweden's islands. Counties are usually sub-divided into municipalities, but Gotland County only consists of one municipality: Gotland Municipality. Gotland County at present is unique in Sweden as there is no county council. The municipality handles the tasks that otherwise is handled by the county council, mainly health care and public transport. However, for Gotland County, there is a County Administrative Board which is a national authority. Both the County Administrative Board and the municipality have their seat in the largest city Visby, with 22,000 inhabitants."@en
<http://www.viss.lansstyrelsen.se/rdf/counties.rdf#_10>	"10 - Blekinge"	<http://dbpedia.org/resource/Blekinge_County>	"153131"^^<http://www.w3.org/2001/XMLSchema#int>	"Blekinge County (Blekinge l\u00e4n) is a county or l\u00e4n in the south of Sweden. It borders the Counties of Sk\u00e5ne, Kronoberg, Kalmar and the Baltic Sea. The capital is Karlskrona. It is the smallest of the present administrative counties of Sweden, covering only 0,7\u00a0% of the total area"@en
<http://www.viss.lansstyrelsen.se/rdf/counties.rdf#_12>	"12 - Sk\u00e5ne"	<http://dbpedia.org/resource/Sk%C3%A5ne_County>	"1251213"^^<http://www.w3.org/2001/XMLSchema#int>	"Sk\u00e5ne County (Sk\u00e5ne l\u00e4n), also known as Scania County in English, is the southernmost administrative county or l\u00e4n, of Sweden, basically corresponding to the traditional province Scania (which in Swedish is called Sk\u00e5ne). It borders the counties of Halland, Kronoberg and Blekinge. The seat of residence for the Sk\u00e5ne Governor is the town of Malm\u00f6. The headquarters of Region Sk\u00e5ne is the town of Kristianstad. The present county was created in 1997 when Kristianstad County and Malm\u00f6hus County were merged, and it covers around 3% of Sweden's total area, but its population of 1,250,000 comprises 13% of Sweden's total population."@en

Received 21 rows in 0.039 seconds.

JSON Url:
https://eea.europa.eu./data-and-maps/daviz/eionet/data/eionet-data/swedens-counties-joined-with-population-and-summary-from-dbpedia/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://cr.eionet.europa.eu/sparql

SPARQL Query:


        PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX cr: <http://cr.eionet.europa.eu/ontologies/contreg.rdf#>
PREFIX v: <http://www.viss.lansstyrelsen.se/rdf/schemas/viss.rdf#>
PREFIX dbo: <http://dbpedia.org/ontology/>
SELECT ?len ?name ?dbpedia ?population ?dblabel WHERE {
  ?len a v:County ;
         v:code ?code;
         rdfs:label ?name;
         owl:sameAs ?dbpedia .
 ?dbpedia dbo:abstract ?dblabel FILTER(LANG(?dblabel) = 'en')
 ?dbpedia dbo:populationTotal ?population
} ORDER BY ?code

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