Population Connected To Wastewater Collection And Treatment Systems

Eurostat code: enps_env_ww_con · (2005 - 2022)

@eurostat.enps_env_ww_con

Table List

2 tables(21.82 KB)

Population Connected To Wastewater Collection And Treatment Systems - Raw

Population Connected To Wastewater Collection And Treatment Systems - Unpivoted

Population Connected To Wastewater Collection And Treatment Systems - Unpivoted

@eurostat.enps_env_ww_con.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.83 KB
205 rows
6 columns

freq Freq	unit Unit	ww_tp Ww Tp	geo Geo	time_period Time Period	value Value
Annual	Percentage	Independent wastewater treatment - total	Algeria	2005	16
Annual	Percentage	Independent wastewater treatment - total	Israel	2005	2.1
Annual	Percentage	Urban wastewater collecting system	Algeria	2005	72
Annual	Percentage	Urban wastewater collecting system	Israel	2005	97
Annual	Percentage	Urban wastewater collecting system	Jordan	2005	59
Annual	Percentage	Urban wastewater collecting system	Morocco	2005	87.2
Annual	Percentage	Urban wastewater collecting system	Tunisia	2005	53.9
Annual	Percentage	Urban and other wastewater treatment plants - tertiary treatment	Israel	2005	39.1
Annual	Percentage	Urban and other wastewater treatment plants - tertiary treatment	Tunisia	2005	1.6
Annual	Percentage	Urban and other wastewater treatment plants - at least secondary treatment	Israel	2005	82


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

Share link

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