Data table via SPARQL

Employment by activity in the Environmental Goods and Services Sector, 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	nace_r2_label	obsValue
"2000"^^<http://www.w3.org/2001/XMLSchema#int>	"Agriculture, forestry and fishing"	"189"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int>	"Construction"	"503"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int>	"Electricity, gas, steam and air conditioning supply; water supply; sewerage, waste management and remediation activities"	"1093"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int>	"Mining and quarrying; manufacturing"	"401"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int>	"Services"	"600"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int>	"Total - All NACE activities"	"2786"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int>	"Agriculture, forestry and fishing"	"189"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int>	"Construction"	"574"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int>	"Electricity, gas, steam and air conditioning supply; water supply; sewerage, waste management and remediation activities"	"1100"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int>	"Mining and quarrying; manufacturing"	"402"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 84 rows in 0.003 seconds.

JSON Url:
https://eea.europa.eu./data-and-maps/daviz/sds/employment-by-activity-in-the/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 qb: <http://purl.org/linked-data/cube#> 
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 geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX env_dom: <http://dd.eionet.europa.eu/vocabulary/eurostat/env_dom/>
PREFIX env_exp: <http://dd.eionet.europa.eu/vocabulary/eurostat/env_exp/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX ty: <http://dd.eionet.europa.eu/vocabulary/eurostat/ty/>
PREFIX indic_pi: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_pi/>
PREFIX ceparema: <http://dd.eionet.europa.eu/vocabulary/eurostat/ceparema/>

SELECT DISTINCT
year(?date) as ?date
?nace_r2_label 
round(sum(?obsValue)/1000) as ?obsValue
WHERE {
{
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_egss3.rdf.gz>
  {
    _:env_ac_egss3 sdmx-dimension:timePeriod ?date . 
    _:env_ac_egss3 property:nace_r2 ?nace_r2 . 
    _:env_ac_egss3 property:ty ty:TOT_EGSS . 
    _:env_ac_egss3 property:ceparema ceparema:TOTAL . 
    _:env_ac_egss3 sdmx-dimension:refArea geo:EU28 . 
    _:env_ac_egss3 sdmx-attribute:unitMeasure unit:FTE . 
    _:env_ac_egss3 property:indic_pi indic_pi:EMP . 
    _:env_ac_egss3 sdmx-measure:obsValue ?obsValue .
  } 
  ?nace_r2 rdfs:label ?nace_r2_label .
 }
}
GROUP BY ?date ?nace_r2_label
ORDER BY ?date ?nace_r2_label