Employment by activity in the Environmental Goods and Services Sector, EU28

Data table via SPARQL Last modified 16 Aug 2018
32 min read

Download this dataset

Dataset preview

(Live Query)

date nace_r2_label obsValue
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Agriculture, forestry and fishing" "0.19"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Mining and quarrying; manufacturing" "0.407"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Electricity, water and waste" "1.114"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Construction" "0.492"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Services" "0.605"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Total - all NACE activities" "2.807"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "Agriculture, forestry and fishing" "0.189"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "Mining and quarrying; manufacturing" "0.411"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "Electricity, water and waste" "1.121"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "Construction" "0.553"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 96 rows in 0.058 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/employment-by-activity-in-the-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 property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX ceparema: <http://dd.eionet.europa.eu/vocabulary/eurostat/ceparema/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX na_item: <http://dd.eionet.europa.eu/vocabulary/eurostat/na_item/>
PREFIX ty: <http://dd.eionet.europa.eu/vocabulary/eurostat/ty/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>

SELECT DISTINCT
year(?date) as ?date
bif:either(?nace_r2 = nace_r2:D_E, 'Electricity, water and waste', ?nace_r2_label) as ?nace_r2_label
(?obsValue/1000000.0) 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:ceparema ceparema:TOTAL .
    _:env_ac_egss3 property:nace_r2 ?nace_r2 . 

    _:env_ac_egss3 property:ceparema ceparema:TOTAL . 
    _:env_ac_egss3 sdmx-dimension:refArea geo:EU28 . 
    _:env_ac_egss1_idx property:na_item na_item:EMP_DC .
    _:env_ac_egss3 property:ty ty:TOT_EGSS . 
    _:env_ac_egss3 sdmx-attribute:unitMeasure unit:FTE . 

    _:env_ac_egss3 sdmx-measure:obsValue ?obsValue .
  } 
  ?nace_r2 rdfs:label ?nace_r2_label .
 }
}
ORDER BY ?date


Related content

Temporal coverage

Document Actions
Filed under: