Population Connected To Public Water Supply - %, ENP-East Countries

Eurostat code: enpe_env_wat_cov · (2005 - 2023)

@eurostat.enpe_env_wat_cov

Table List

2 tables(18.97 KB)

Population Connected To Public Water Supply - %, ENP-East Countries - Raw

Population Connected To Public Water Supply - %, ENP-East Countries - Unpivoted

Population Connected To Public Water Supply - %, ENP-East Countries - Unpivoted

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

4.2 KB
57 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Percentage	Armenia	2005	89
Annual	Percentage	Belarus	2005	78
Annual	Percentage	Armenia	2006	91
Annual	Percentage	Belarus	2006	79
Annual	Percentage	Armenia	2007	94
Annual	Percentage	Belarus	2007	81
Annual	Percentage	Armenia	2008	97
Annual	Percentage	Belarus	2008	82
Annual	Percentage	Armenia	2009	98
Annual	Percentage	Belarus	2009	84


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

Share link

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