Persons Served By Municipal Waste Collection - % Of Population, ENP-East Countries

Eurostat code: enpe_env_wasacc · (2005 - 2023)

@eurostat.enpe_env_wasacc

Table List

2 tables(18.98 KB)

Persons Served By Municipal Waste Collection - % Of Population, ENP-East Countries - Raw

Persons Served By Municipal Waste Collection - % Of Population, ENP-East Countries - Unpivoted

Persons Served By Municipal Waste Collection - % Of Population, ENP-East Countries - Unpivoted

@eurostat.enpe_env_wasacc.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.19 KB
62 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Percentage	Armenia	2005	75
Annual	Percentage	Belarus	2005	73
Annual	Percentage	Armenia	2006	77
Annual	Percentage	Belarus	2006	76
Annual	Percentage	Armenia	2007	79
Annual	Percentage	Belarus	2007	77
Annual	Percentage	Ukraine	2007	69
Annual	Percentage	Armenia	2008	78
Annual	Percentage	Belarus	2008	79
Annual	Percentage	Ukraine	2008	72


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.