Data table via SPARQL

Trends in GVA and employment, EU28

Data table via SPARQL Published 09 Apr 2018 Last modified 24 Jun 2020

Topics: Environment and health

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_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.001 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/trends-in-gva-and-employment-2/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/>
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

Permalinks

Permalink to this version: aea0633fd65a4361838cd63f65078abb
Permalink to latest version: MKSHOTBF6P

Older versions

25 Apr 2017 - Trends in GVA and employment, EU28

30 Aug 2016 - Trends in GVA and employment, EU28

Geographic coverage

Austria Belgium Bulgaria Croatia Cyprus Czechia Denmark Estonia Finland France Germany Greece Hungary Ireland Italy Latvia Lithuania Luxembourg Malta Netherlands Poland Portugal Romania Slovakia Slovenia Spain Sweden United Kingdom