Employment In The Environmental Goods And Services Sector

Eurostat code: env_ac_egss1 · (2000 - 2023)

@eurostat.env_ac_egss1

Table List

2 tables(1.84 MB)

Employment In The Environmental Goods And Services Sector - Raw

Employment In The Environmental Goods And Services Sector - Unpivoted

Employment In The Environmental Goods And Services Sector - Unpivoted

@eurostat.env_ac_egss1.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

940.75 KB
920908 rows
9 columns

freq Freq	nace_r2 Nace R2	ceparema Ceparema	na_item Na Item	ty Ty	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Agriculture, forestry and fishing	Protection of ambient air and climate	Total employment domestic concept	Market activities	Full-time equivalent (FTE)	Switzerland	2000
Annual	Agriculture, forestry and fishing	Protection of ambient air and climate	Total employment domestic concept	Total environmental goods and services sector	Full-time equivalent (FTE)	Switzerland	2000
Annual	Agriculture, forestry and fishing	Protection of climate and ozone layer	Total employment domestic concept	Total environmental goods and services sector	Full-time equivalent (FTE)	Switzerland	2000
Annual	Agriculture, forestry and fishing	Wastewater management	Total employment domestic concept	Market activities	Full-time equivalent (FTE)	Switzerland	2000
Annual	Agriculture, forestry and fishing	Wastewater management	Total employment domestic concept	Total environmental goods and services sector	Full-time equivalent (FTE)	Switzerland	2000
Annual	Agriculture, forestry and fishing	Waste management	Total employment domestic concept	Market activities	Full-time equivalent (FTE)	Switzerland	2000
Annual	Agriculture, forestry and fishing	Waste management	Total employment domestic concept	Total environmental goods and services sector	Full-time equivalent (FTE)	Switzerland	2000
Annual	Agriculture, forestry and fishing	Protection and remediation of soil, groundwater and surface water	Total employment domestic concept	Market activities	Full-time equivalent (FTE)	Switzerland	2000	10642
Annual	Agriculture, forestry and fishing	Protection and remediation of soil, groundwater and surface water	Total employment domestic concept	Total environmental goods and services sector	Full-time equivalent (FTE)	Switzerland	2000	10642
Annual	Agriculture, forestry and fishing	Noise and vibration abatement (excluding workplace protection)	Total employment domestic concept	Market activities	Full-time equivalent (FTE)	Switzerland	2000


CREATE TABLE tidy (
  "freq" VARCHAR,
  "nace_r2" VARCHAR,
  "ceparema" VARCHAR,
  "na_item" VARCHAR,
  "ty" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.