Trends in GVA and employment, EU28

Data table via SPARQL Last modified 09 Apr 2018

Download this dataset

Dataset preview

(Live Query)

date env_ac_egss2 env_ac_egss1 CLV10_MEUR lfsi_emp_a
"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> "105.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "102.1"^^<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>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "110.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "105.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "104.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "102.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006"^^<http://www.w3.org/2001/XMLSchema#int> "116.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "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>
"2007"^^<http://www.w3.org/2001/XMLSchema#int> "122.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "113.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "111.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "106.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2008"^^<http://www.w3.org/2001/XMLSchema#int> "130.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "119.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "111.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "107.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009"^^<http://www.w3.org/2001/XMLSchema#int> "132.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "126"^^<http://www.w3.org/2001/XMLSchema#decimal> "107"^^<http://www.w3.org/2001/XMLSchema#decimal> "105.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2010"^^<http://www.w3.org/2001/XMLSchema#int> "141.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "130.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "109.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "104"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "152.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "139.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "111.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "103.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int> "150.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "137.3"^^<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>

Received 14 rows in 0.046 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/trends-in-gva-and-employment-2/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 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/>
PREFIX na_item: <http://dd.eionet.europa.eu/vocabulary/eurostat/na_item/>

SELECT DISTINCT
year(?date) as ?date

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

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


#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:FTE . 
    _:env_ac_egss1 property:na_item na_item:EMP_DC . 
    _: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:FTE . 
    _:env_ac_egss1_idx property:na_item na_item:EMP_DC . 
    _: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:MIO_EUR . 
    _:env_ac_egss2 property:na_item na_item:B1G . 
    _: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:MIO_EUR . 
    _:env_ac_egss2_idx property:na_item na_item:B1G .
    _: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_idx sdmx-attribute:unitMeasure unit:CP_MEUR .
      _:nama_10_gdp_idx sdmx-measure:obsValue ?CP_MEUR_idx .
    }

  }

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


Temporal coverage

Document Actions
Filed under: