Baselight

Production, Value Added And Employment By Industry Groups In The Environmental Goods And Services Sector

Eurostat code: env_ac_egss3 ยท (2000 - 2022)

@eurostat.env_ac_egss3

Production, Value Added And Employment By Industry Groups In The Environmental Goods And Services Sector - Unpivoted
@eurostat.env_ac_egss3.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.

  • 11.45 KB
  • 529 rows
  • 9 columns
freq

Freq

ty

Ty

na_item

Na Item

unit

Unit

nace_r2

Nace R2

ceparema

Ceparema

geo

Geo

time_period

Time Period

value

Value

AnnualTotal environmental goods and services sectorValue added, grossChain linked volumes (2015), million euroAgriculture, forestry and fishingTotal environmental protection and resource management activitiesEuropean Union - 27 countries (from 2020)20006582
AnnualTotal environmental goods and services sectorValue added, grossChain linked volumes (2015), million euroConstructionTotal environmental protection and resource management activitiesEuropean Union - 27 countries (from 2020)200031312
AnnualTotal environmental goods and services sectorValue added, grossChain linked volumes (2015), million euroTotal - all NACE activitiesTotal environmental protection and resource management activitiesEuropean Union - 27 countries (from 2020)2000160333
AnnualTotal environmental goods and services sectorValue added, grossMillion euroAgriculture, forestry and fishingTotal environmental protection and resource management activitiesEuropean Union - 27 countries (from 2020)20006208
AnnualTotal environmental goods and services sectorValue added, grossMillion euroMining and quarrying; manufacturingTotal environmental protection and resource management activitiesEuropean Union - 27 countries (from 2020)200015252
AnnualTotal environmental goods and services sectorValue added, grossMillion euroElectricity, gas, steam and air conditioning supply; water supply; sewerage, waste management and remediation activitiesTotal environmental protection and resource management activitiesEuropean Union - 27 countries (from 2020)200050466
AnnualTotal environmental goods and services sectorValue added, grossMillion euroConstructionTotal environmental protection and resource management activitiesEuropean Union - 27 countries (from 2020)200020439
AnnualTotal environmental goods and services sectorValue added, grossMillion euroServicesTotal environmental protection and resource management activitiesEuropean Union - 27 countries (from 2020)200032698
AnnualTotal environmental goods and services sectorValue added, grossMillion euroTotal - all NACE activitiesTotal environmental protection and resource management activitiesEuropean Union - 27 countries (from 2020)2000125064
AnnualTotal environmental goods and services sectorValue added, grossPercentage of gross domestic product (GDP)Total - all NACE activitiesTotal environmental protection and resource management activitiesEuropean Union - 27 countries (from 2020)20001.59

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

Share link

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