Urban Wastewater Treatment

Eurostat code: med_en46 · (2000 - 2012)

@eurostat.med_en46

Table List

2 tables(18.77 KB)

Urban Wastewater Treatment - Raw

Urban Wastewater Treatment - Unpivoted

Urban Wastewater Treatment - Raw

@eurostat.med_en46.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

12.82 KB
18 rows
17 columns

freq Freq	cons Cons	pl_capa Pl Capa	geo Geo	n_2000 2000	n_2001 2001	n_2002 2002	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012
Annual	Primary treatment	Number of plants	Algeria	43	43	43	43	46	48	52	58	61	62	112	138	185
Annual	Primary treatment	Number of plants	Israel	16	15	15
Annual	Primary treatment	Number of plants	Morocco		1	1	2	13	21	28	31	39	40	41	46	51
Annual	Primary treatment	Design capacity BOD (1 000 kg O2/day)	Algeria								25			35	45	55
Annual	Primary treatment	Design capacity BOD (1 000 kg O2/day)	Morocco		600	600	2087	11560	14068	27970	29521	43093	45283	54695	54695
Annual	Primary treatment	Design capacity vol. (34) (1 000 m3/d)	Algeria	510	510	510	560	660	560	870	1100	1417	1500	1822	1918	2500
Annual	Primary treatment	Design capacity vol. (34) (1 000 m3/d)	Morocco		1500	1500	3300	23990	33001	107350	117634	98000	102000	152300	177000	211000
Annual	Primary treatment	Actual occupation vol. (1 000 m3/d)	Algeria	350	350	410	410	520	520	610	880	1090	420	693	781	800
Annual	Primary treatment	Actual occupation vol. (1 000 m3/d)	Israel	48	47.9	49.3
Annual	Primary treatment	Actual occupation vol. (1 000 m3/d)	Morocco		2200	2200	4350	22890	27940	43550	47520	76780	86156	107057	107057


CREATE TABLE raw (
  "freq" VARCHAR,
  "cons" VARCHAR,
  "pl_capa" VARCHAR,
  "geo" VARCHAR,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE
);

Share link

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