next
previous
items

Data table via SPARQL

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

Data table via SPARQL Published 09 Apr 2018 Last modified 24 Jun 2020
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.002 seconds.


https://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


Permalinks

Geographic coverage

Temporal coverage

Topics

Tags

Filed under:
Filed under: environment and health
Document Actions