Urban Wastewater Treatment

Eurostat code: med_en46 · (2000 - 2012)

@eurostat.med_en46

Table List

2 tables(18.77 KB)

Urban Wastewater Treatment - Unpivoted

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

5.96 KB
173 rows
6 columns

freq Freq	cons Cons	pl_capa Pl Capa	geo Geo	time_period Time Period	value Value
Annual	Primary treatment	Number of plants	Algeria	2000	43
Annual	Primary treatment	Number of plants	Israel	2000	16
Annual	Primary treatment	Design capacity vol. (34) (1 000 m3/d)	Algeria	2000	510
Annual	Primary treatment	Actual occupation vol. (1 000 m3/d)	Algeria	2000	350
Annual	Primary treatment	Actual occupation vol. (1 000 m3/d)	Israel	2000	48
Annual	Secondary and tertiary treatment	Number of plants	Israel	2000	53
Annual	Secondary and tertiary treatment	Number of plants	Tunisia	2000	61
Annual	Secondary and tertiary treatment	Design capacity BOD (1 000 kg O2/day)	Tunisia	2000	234.9
Annual	Secondary and tertiary treatment	Actual occupation BOD (1 000 kg O2/day)	Tunisia	2000	204.7
Annual	Secondary and tertiary treatment	Design capacity vol. (34) (1 000 m3/d)	Tunisia	2000	535


CREATE TABLE tidy (
  "freq" VARCHAR,
  "cons" VARCHAR,
  "pl_capa" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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