Management Of Waste

Eurostat code: med_en25 · (2005 - 2018)

@eurostat.med_en25

Table List

2 tables(19.23 KB)

Management Of Waste - Unpivoted

@eurostat.med_en25.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.94 KB
90 rows
7 columns

freq Freq	unit Unit	hazard Hazard	wst_oper Wst Oper	geo Geo	time_period Time Period	value Value
Annual	Thousand tonnes	Non-hazardous	Waste collected	Israel	2005	4085.9
Annual	Thousand tonnes	Non-hazardous	Waste collected	Jordan	2005	2358.9
Annual	Thousand tonnes	Non-hazardous	Waste collected	Lebanon	2005	1474
Annual	Thousand tonnes	Non-hazardous	Waste collected	Palestine*	2005	1119
Annual	Thousand tonnes	Non-hazardous	Waste collected	Tunisia	2005	1333.1
Annual	Thousand tonnes	Non-hazardous	Recycling	Palestine*	2005	11.2
Annual	Thousand tonnes	Non-hazardous	Waste collected	Israel	2006	4226.5
Annual	Thousand tonnes	Non-hazardous	Waste collected	Jordan	2006	2309.5
Annual	Thousand tonnes	Non-hazardous	Waste collected	Palestine*	2006	1147.4
Annual	Thousand tonnes	Non-hazardous	Waste collected	Tunisia	2006	1350.4


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

Share link

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