Population Connected To Wastewater Treatment

Eurostat code: med_en47 · (2005 - 2018)

@eurostat.med_en47

Table List

2 tables(18.55 KB)

Population Connected To Wastewater Treatment - Raw

Population Connected To Wastewater Treatment - Unpivoted

Population Connected To Wastewater Treatment - Unpivoted

@eurostat.med_en47.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.48 KB
152 rows
6 columns

freq Freq	src Src	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Urban wastewater treatment, total	Percentage	Algeria	2005	39
Annual	Urban wastewater treatment, total	Percentage	Israel	2005	92.9
Annual	Urban wastewater treatment, total	Percentage	Jordan	2005	59
Annual	Urban wastewater treatment, total	Percentage	Tunisia	2005	48.4
Annual	Urban wastewater treatment, of which with tertiary treatment	Percentage	Israel	2005	39.1
Annual	Urban wastewater treatment, of which with tertiary treatment	Percentage	Tunisia	2005	1.6
Annual	Urban wastewater collecting system, total	Percentage	Algeria	2005	72
Annual	Urban wastewater collecting system, total	Percentage	Israel	2005	97
Annual	Urban wastewater collecting system, total	Percentage	Jordan	2005	59
Annual	Urban wastewater collecting system, total	Percentage	Morocco	2005	87.2


CREATE TABLE tidy (
  "freq" VARCHAR,
  "src" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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