Environmental Protection Expenditure By Environmental Domains (NACE Rev. 2, B-E) (2008-2015)

Eurostat code: sbs_env_dom_r2 · (2008 - 2018)

@eurostat.sbs_env_dom_r2

Table List

2 tables(228.15 KB)

Environmental Protection Expenditure By Environmental Domains (NACE Rev. 2, B-E) (2008-2015) - Raw

Environmental Protection Expenditure By Environmental Domains (NACE Rev. 2, B-E) (2008-2015) - Unpivoted

Environmental Protection Expenditure By Environmental Domains (NACE Rev. 2, B-E) (2008-2015) - Unpivoted

@eurostat.sbs_env_dom_r2.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.

115.34 KB
73405 rows
7 columns

freq Freq	indic_sb Indic Sb	nace_r2 Nace R2	ceparema Ceparema	geo Geo	time_period Time Period	value Value
Annual	Investment in equipment and plant for pollution control - million euro	Mining and quarrying	Protection of ambient air and climate	Austria	2008	0.2
Annual	Investment in equipment and plant for pollution control - million euro	Mining and quarrying	Protection of ambient air and climate	Cyprus	2008	0.1
Annual	Investment in equipment and plant for pollution control - million euro	Mining and quarrying	Protection of ambient air and climate	Germany	2008	6.2
Annual	Investment in equipment and plant for pollution control - million euro	Mining and quarrying	Protection of ambient air and climate	Greece	2008
Annual	Investment in equipment and plant for pollution control - million euro	Mining and quarrying	Protection of ambient air and climate	Spain	2008	3.3
Annual	Investment in equipment and plant for pollution control - million euro	Mining and quarrying	Protection of ambient air and climate	Finland	2008	4.2
Annual	Investment in equipment and plant for pollution control - million euro	Mining and quarrying	Protection of ambient air and climate	Hungary	2008
Annual	Investment in equipment and plant for pollution control - million euro	Mining and quarrying	Protection of ambient air and climate	Italy	2008	74.2
Annual	Investment in equipment and plant for pollution control - million euro	Mining and quarrying	Protection of ambient air and climate	Lithuania	2008
Annual	Investment in equipment and plant for pollution control - million euro	Mining and quarrying	Protection of ambient air and climate	Poland	2008	5.2


CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_sb" 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.