Unemployment vs. government debt (Eurostat)

Data table via SPARQL Published 06 Oct 2012 Last modified 14 May 2019
This query combines unemployment data with government debt and population. It is intended to be used in a motion chart.

Download this dataset

Dataset preview

(Live Query)

country quarter PctDebt Unemployment DebtColor Population
"Austria" "2007-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "66.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "66.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "8404252"^^<http://www.w3.org/2001/XMLSchema#int>
"Belgium" "2007-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "90"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "90"^^<http://www.w3.org/2001/XMLSchema#decimal> "11000638"^^<http://www.w3.org/2001/XMLSchema#int>
"Bulgaria" "2007-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "19.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "19.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "7369431"^^<http://www.w3.org/2001/XMLSchema#int>
"Cyprus" "2007-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "65.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "65.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "839751"^^<http://www.w3.org/2001/XMLSchema#int>
"Czech Republic" "2007-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "27.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "27.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "10486731"^^<http://www.w3.org/2001/XMLSchema#int>
"Denmark" "2007-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "30.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "30.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "5560628"^^<http://www.w3.org/2001/XMLSchema#int>
"Estonia" "2007-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "3.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "1340194"^^<http://www.w3.org/2001/XMLSchema#int>
"Finland" "2007-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "36.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "36.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "5375276"^^<http://www.w3.org/2001/XMLSchema#int>
"France" "2007-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "65.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "8.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "65.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "64994907"^^<http://www.w3.org/2001/XMLSchema#int>
"Germany" "2007-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "67.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "67.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "81751602"^^<http://www.w3.org/2001/XMLSchema#int>

Received 675 rows in 0.111 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/eionet/data/local-sparql-queries/unemployment-vs.-government-debt-eurostat/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 owl: <http://www.w3.org/2002/07/owl#>
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-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX geo: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>
PREFIX dataset: <http://rdfdata.eionet.europa.eu/eurostat/data/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>

SELECT ?country ?quarter xsd:decimal(?debtpct) AS ?PctDebt xsd:decimal(?percentage) AS ?Unemployment xsd:decimal(?debtpct) AS ?DebtColor xsd:int(?population) AS ?Population
WHERE {
 GRAPH dataset:tipsgo20.rdf.gz {
  ?obsdebt qb:dataSet dataset:tipsgo20 ;
        sdmx-dimension:timePeriod ?quarter FILTER(?quarter >= "2007-01-01"^^xsd:date)
  ?obsdebt sdmx-dimension:freq <http://purl.org/linked-data/sdmx/2009/code#freq-Q>;
        estat:unit <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#PC_GDP>;
        estat:sector <http://rdfdata.eionet.europa.eu/eurostat/dic/sector#S13>;
        estat:geo ?ucountry;
        sdmx-measure:obsValue ?debtpct.
 }
 GRAPH dataset:une_rt_m.rdf.gz {
  ?obsrec qb:dataSet dataset:une_rt_m ;
        sdmx-dimension:timePeriod ?quarter;
        sdmx-dimension:freq <http://purl.org/linked-data/sdmx/2009/code#freq-M>;
        estat:age <http://rdfdata.eionet.europa.eu/eurostat/dic/age#TOTAL>;
        estat:sex <http://rdfdata.eionet.europa.eu/eurostat/dic/sex#T>;
        estat:s_adj <http://rdfdata.eionet.europa.eu/eurostat/dic/s_adj#SA>;
        estat:geo ?ucountry;
        sdmx-measure:obsValue ?percentage.
 }
 GRAPH dataset:demo_pjanbroad.rdf.gz {
  ?popobs qb:dataSet dataset:demo_pjanbroad ;
        sdmx-dimension:timePeriod "2011-01-01"^^xsd:date;
        sdmx-dimension:freq <http://purl.org/linked-data/sdmx/2009/code#freq-A>;
        estat:age <http://rdfdata.eionet.europa.eu/eurostat/dic/age#TOTAL>;
        estat:sex <http://rdfdata.eionet.europa.eu/eurostat/dic/sex#T>;
        estat:geo ?ucountry;
        sdmx-measure:obsValue ?population.
 }
 GRAPH <http://rdfdata.eionet.europa.eu/eea/countries.rdf> {
  ?eeacountry owl:sameAs ?ucountry.
  <http://rdfdata.eionet.europa.eu/eea/countries/EU27> skos:member ?eeacountry. 
  ?eeacountry rdfs:label ?country.
 }
 
} ORDER BY ?quarter ?country

Error when running query:

Query timeout. unknown url type: timed out


Document Actions