Data table via SPARQL

Trends in GVA and employment, EU28

Data table via SPARQL Published 30 Aug 2016 Last modified 26 Aug 2017

This is an old version, kept for reference only.

Go to latest version

This page was archived on 26 Aug 2017 with reason: A new version has been published

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)

date	env_ac_egss1	CLV10_MEUR	lfsi_emp_a	env_ac_egss2
"2003"^^<http://www.w3.org/2001/XMLSchema#int>	"100"^^<http://www.w3.org/2001/XMLSchema#decimal>	"100"^^<http://www.w3.org/2001/XMLSchema#decimal>	"100"^^<http://www.w3.org/2001/XMLSchema#decimal>	"100"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int>	"102.3"^^<http://www.w3.org/2001/XMLSchema#decimal>	"102.5"^^<http://www.w3.org/2001/XMLSchema#decimal>	"100.8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"105.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int>	"105.8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"104.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	"102.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"109.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006"^^<http://www.w3.org/2001/XMLSchema#int>	"110.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"108.1"^^<http://www.w3.org/2001/XMLSchema#decimal>	"104.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"116.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2007"^^<http://www.w3.org/2001/XMLSchema#int>	"113.7"^^<http://www.w3.org/2001/XMLSchema#decimal>	"111.5"^^<http://www.w3.org/2001/XMLSchema#decimal>	"106.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"122.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2008"^^<http://www.w3.org/2001/XMLSchema#int>	"120.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"112"^^<http://www.w3.org/2001/XMLSchema#decimal>	"107.3"^^<http://www.w3.org/2001/XMLSchema#decimal>	"131.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009"^^<http://www.w3.org/2001/XMLSchema#int>	"127.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"107.1"^^<http://www.w3.org/2001/XMLSchema#decimal>	"105.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"133"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2010"^^<http://www.w3.org/2001/XMLSchema#int>	"132.9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"109.3"^^<http://www.w3.org/2001/XMLSchema#decimal>	"104"^^<http://www.w3.org/2001/XMLSchema#decimal>	"142.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int>	"140.8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"111.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"103.9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"152.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int>	"140.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	"110.7"^^<http://www.w3.org/2001/XMLSchema#decimal>	"103.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	"151.3"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 13 rows in 0.029 seconds.

JSON Url:
https://eea.europa.eu./data-and-maps/daviz/sds/trends-in-gva-and-employment-eu28/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 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 skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX indic_pi: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_pi/>
PREFIX caparema: <http://dd.eionet.europa.eu/vocabulary/eurostat/ceparema/>
PREFIX nace_r2:<http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX ty: <http://dd.eionet.europa.eu/vocabulary/eurostat/ty/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX na_item: <http://dd.eionet.europa.eu/vocabulary/eurostat/na_item/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX age: <http://dd.eionet.europa.eu/vocabulary/eurostat/age/>
PREFIX sex: <http://purl.org/linked-data/sdmx/2009/code#>
PREFIX indic_em: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_em/>

SELECT DISTINCT
year(?date) as ?date

round(sum(?env_ac_egss1)/sum(?env_ac_egss1_idx)*1000)/10.0 as ?env_ac_egss1

round(sum(?CLV10_MEUR)/sum(?CLV10_MEUR_idx)*1000)/10.0 as ?CLV10_MEUR

round(sum(?lfsi_emp_a)/sum(?lfsi_emp_a_idx)*1000)/10.0 as ?lfsi_emp_a

round(( sum(?env_ac_egss2)/(sum(?CP_MEUR)/sum(?CLV10_MEUR)) ) /
( sum(?env_ac_egss2_idx)/(sum(?CP_MEUR_idx)/sum(?CLV10_MEUR_idx) ) )*1000)/10.0 as ?env_ac_egss2

#sum(?env_ac_egss1) as ?env_ac_egss1
#sum(?env_ac_egss1_idx) as ?env_ac_egss1_idx
#sum(?env_ac_egss2) as ?env_ac_egss2
#sum(?env_ac_egss2_idx) as ?env_ac_egss2_idx
#sum(?lfsi_emp_a) as ?lfsi_emp_a
#sum(?lfsi_emp_a_idx) as ?lfsi_emp_a_idx
#sum(?CLV10_MEUR) as ?CLV10_MEUR
#sum(?CLV10_MEUR_idx) as ?CLV10_MEUR_idx
#sum(?CP_MEUR) as ?CP_MEUR
#sum(?CP_MEUR_idx) as ?CP_MEUR_idx
#( sum(?CP_MEUR)/sum(?CLV10_MEUR) / sum(?CP_MEUR_idx)/sum(?CLV10_MEUR_idx) ) as ?deflator
#round(sum(?CP_MEUR)/sum(?CLV10_MEUR)*1000)/10.0 as ?deflator
#round(sum(?CP_MEUR_idx)/sum(?CLV10_MEUR_idx)*1000)/10.0 as ?deflator_idx

WHERE {
 {
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_egss1.rdf.gz>
  {
    _:env_ac_egss1 sdmx-dimension:timePeriod ?date . 
    _:env_ac_egss1 property:nace_r2 nace_r2:TOTAL . 
    _:env_ac_egss1 property:ty ty:TOT_EGSS . 
    _:env_ac_egss1 property:ceparema caparema:TOTAL . 
    _:env_ac_egss1 sdmx-dimension:refArea geo:EU28 . 
    _:env_ac_egss1 sdmx-attribute:unitMeasure ?unit . 
    _:env_ac_egss1 property:indic_pi indic_pi:EMP . 
    _:env_ac_egss1 sdmx-measure:obsValue ?env_ac_egss1 .

    _:env_ac_egss1_idx sdmx-dimension:timePeriod ?date_idx .
    FILTER (year(?date_idx) = 2003)
    _:env_ac_egss1_idx property:nace_r2 nace_r2:TOTAL . 
    _:env_ac_egss1_idx property:ty ty:TOT_EGSS . 
    _:env_ac_egss1_idx property:ceparema caparema:TOTAL . 
    _:env_ac_egss1_idx sdmx-dimension:refArea geo:EU28 . 
    _:env_ac_egss1_idx sdmx-attribute:unitMeasure ?unit . 
    _:env_ac_egss1_idx property:indic_pi indic_pi:EMP . 
    _:env_ac_egss1_idx sdmx-measure:obsValue ?env_ac_egss1_idx .
  }
 } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_egss2.rdf.gz>
  {
    _:env_ac_egss2 sdmx-dimension:timePeriod ?date . 
    _:env_ac_egss2 property:nace_r2 nace_r2:TOTAL . 
    _:env_ac_egss2 property:ty ty:TOT_EGSS . 
    _:env_ac_egss2 property:ceparema caparema:TOTAL . 
    _:env_ac_egss2 sdmx-dimension:refArea geo:EU28 . 
    _:env_ac_egss2 sdmx-attribute:unitMeasure ?unit . 
    _:env_ac_egss2 property:indic_pi indic_pi:VA . 
    _:env_ac_egss2 sdmx-measure:obsValue ?env_ac_egss2 .
    
    _:env_ac_egss2_idx sdmx-dimension:timePeriod ?date_idx .
    FILTER (year(?date_idx) = 2003)
    _:env_ac_egss2_idx property:nace_r2 nace_r2:TOTAL . 
    _:env_ac_egss2_idx property:ty ty:TOT_EGSS . 
    _:env_ac_egss2_idx property:ceparema caparema:TOTAL . 
    _:env_ac_egss2_idx sdmx-dimension:refArea geo:EU28 . 
    _:env_ac_egss2_idx sdmx-attribute:unitMeasure ?unit . 
    _:env_ac_egss2_idx property:indic_pi indic_pi:VA . 
    _:env_ac_egss2_idx sdmx-measure:obsValue ?env_ac_egss2_idx .
  }
 } UNION {
   GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/lfsi_emp_a.rdf.gz>
  {
    _:lfsi_emp_a sdmx-dimension:timePeriod ?date . 
    _:lfsi_emp_a sdmx-dimension:age age:Y15-64 . 
    _:lfsi_emp_a sdmx-dimension:sex sex:sex-T .
    _:lfsi_emp_a property:indic_em indic_em:EMP_LFS . 
    _:lfsi_emp_a sdmx-dimension:refArea geo:EU28 . 
    _:lfsi_emp_a sdmx-attribute:unitMeasure unit:THS_PER . 
    _:lfsi_emp_a sdmx-measure:obsValue ?lfsi_emp_a .

    _:lfsi_emp_a_idx sdmx-dimension:timePeriod ?date_idx .
    FILTER (year(?date_idx) = 2003) 
    _:lfsi_emp_a_idx sdmx-dimension:age age:Y15-64 . 
    _:lfsi_emp_a_idx sdmx-dimension:sex sex:sex-T .
    _:lfsi_emp_a_idx property:indic_em indic_em:EMP_LFS . 
    _:lfsi_emp_a_idx sdmx-dimension:refArea geo:EU28 . 
    _:lfsi_emp_a_idx sdmx-attribute:unitMeasure unit:THS_PER . 
    _:lfsi_emp_a_idx sdmx-measure:obsValue ?lfsi_emp_a_idx .
  }
 } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_10_gdp.rdf.gz>
  {
    _:nama_10_gdp sdmx-dimension:timePeriod ?date . 
    _:nama_10_gdp property:na_item na_item:B1GQ . 
    _:nama_10_gdp sdmx-dimension:refArea geo:EU28 .
    _:nama_10_gdp sdmx-attribute:unitMeasure ?unit .
    {
      _:nama_10_gdp sdmx-attribute:unitMeasure unit:CLV10_MEUR .
      _:nama_10_gdp sdmx-measure:obsValue ?CLV10_MEUR .
    } UNION {
      _:nama_10_gdp sdmx-attribute:unitMeasure unit:CP_MEUR .
      _:nama_10_gdp sdmx-measure:obsValue ?CP_MEUR .
    }

    _:nama_10_gdp_idx sdmx-dimension:timePeriod ?date_idx .
    FILTER (year(?date_idx) = 2003) 
    _:nama_10_gdp_idx property:na_item na_item:B1GQ . 
    _:nama_10_gdp_idx sdmx-dimension:refArea geo:EU28 .
    _:nama_10_gdp_idx sdmx-attribute:unitMeasure ?unit .
    {
      _:nama_10_gdp_idx sdmx-attribute:unitMeasure unit:CLV10_MEUR .
      _:nama_10_gdp_idx sdmx-measure:obsValue ?CLV10_MEUR_idx .
    } UNION {
      _:nama_10_gdp sdmx-attribute:unitMeasure unit:CP_MEUR .
      _:nama_10_gdp_idx sdmx-measure:obsValue ?CP_MEUR_idx .
    }
  }

 }
 FILTER (year(?date) >= 2003)
}
GROUP BY ?date ?date_idx
ORDER BY ?date