Resource productivity (GDP/DMC), latest year

Data table via SPARQL Published 24 Jul 2017 Last modified 22 Aug 2017
29 min read
This is an old version, kept for reference only.

Go to latest version

Download this dataset

Dataset preview

(Live Query)

country date date_original tsdpc100
"Austria" "2016"^^<http://www.w3.org/2001/XMLSchema#int> "2016"^^<http://www.w3.org/2001/XMLSchema#int> "1.6739"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Belgium" "2016"^^<http://www.w3.org/2001/XMLSchema#int> "2016"^^<http://www.w3.org/2001/XMLSchema#int> "2.7232"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Bulgaria" "2016"^^<http://www.w3.org/2001/XMLSchema#int> "2016"^^<http://www.w3.org/2001/XMLSchema#int> "0.2903"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Croatia" "2016"^^<http://www.w3.org/2001/XMLSchema#int> "2016"^^<http://www.w3.org/2001/XMLSchema#int> "1.0768"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Cyprus" "2016"^^<http://www.w3.org/2001/XMLSchema#int> "2016"^^<http://www.w3.org/2001/XMLSchema#int> "1.4126"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Czech Republic" "2016"^^<http://www.w3.org/2001/XMLSchema#int> "2016"^^<http://www.w3.org/2001/XMLSchema#int> "1.0786"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Denmark" "2016"^^<http://www.w3.org/2001/XMLSchema#int> "2016"^^<http://www.w3.org/2001/XMLSchema#int> "2.1733"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Estonia" "2016"^^<http://www.w3.org/2001/XMLSchema#int> "2016"^^<http://www.w3.org/2001/XMLSchema#int> "0.534"^^<http://www.w3.org/2001/XMLSchema#decimal>
"European Union (28 countries)" "2016"^^<http://www.w3.org/2001/XMLSchema#int> "2016"^^<http://www.w3.org/2001/XMLSchema#int> "2.0728"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Finland" "2016"^^<http://www.w3.org/2001/XMLSchema#int> "2016"^^<http://www.w3.org/2001/XMLSchema#int> "1.0461"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 34 rows in 0.003 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/resource-productivity-gdp-dmc-latest-year/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 indic_nv: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nv/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX common_countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>

SELECT 
bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?country
2016 as ?date
year(?date) as ?date_original
?tsdpc100
#round((?tsdpc100/?tsdpc100_idx)*1000)/10.0 as ?index

WHERE {
{  
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/tsdpc100.rdf.gz> 
  {
    _:tsdpc100 sdmx-dimension:refArea ?geo .
    _:tsdpc100 sdmx-dimension:timePeriod ?date .
    _:tsdpc100 sdmx-attribute:unitMeasure unit:EUR_KG_CLV10 .
    _:tsdpc100 sdmx-measure:obsValue ?tsdpc100  .

    {
      SELECT DISTINCT
        max(?date) as ?date
        ?geo
      WHERE {{
        GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/tsdpc100.rdf.gz> 
        {{
           _:tsdpc100 sdmx-dimension:timePeriod ?date .
           _:tsdpc100 sdmx-dimension:refArea ?geo . 
        }}
      }}
      GROUP BY ?geo 
    }

    #_:tsdpc100_idx sdmx-dimension:refArea ?geo .
    #_:tsdpc100_idx sdmx-dimension:timePeriod ?date_idx .
    #_:tsdpc100_idx sdmx-attribute:unitMeasure unit:EUR_KG_CLV10 .
    #_:tsdpc100_idx sdmx-measure:obsValue ?tsdpc100_idx  .
    #FILTER (year(?date_idx) = 2000)

  } 
  ?geo rdfs:label ?ugeo .
 }
}
GROUP BY ?country
ORDER BY ?country ?date


Related content

Visualisations produced

Temporal coverage

Document Actions
Filed under: