Water Use Balance

Eurostat code: med_en42 · (2005 - 2018)

@eurostat.med_en42

Table List

2 tables(17.88 KB)

Water Use Balance - Raw

Water Use Balance - Unpivoted

Water Use Balance - Raw

@eurostat.med_en42.raw

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

12.63 KB
9 rows
18 columns

freq Freq	unit Unit	src Src	geo Geo	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018
Annual	Million cubic metres	Total gross abstraction of freshwater	Algeria	6450	6500	6850	6950	7150	7203	7515	7800	4643	4820	8954	9230	9802
Annual	Million cubic metres	Total gross abstraction of freshwater	Egypt						61.8	61.8	63	63.2	62.2	62.4	62.4
Annual	Million cubic metres	Total gross abstraction of freshwater	Israel	1728	1637	1689	1595	1313	1340	1259	1318	1296	1271	1173	1199	1201	1112
Annual	Million cubic metres	Total gross abstraction of freshwater	Jordan	857.4	845.3	838.3	823.3	758.5	788.8	782.8	733.9	847	847.1	875.8	875.8	906.8	923
Annual	Million cubic metres	Total gross abstraction of freshwater	Lebanon	1250
Annual	Million cubic metres	Total gross abstraction of freshwater	Tunisia	2448.3	2506.6	2540.7	2555.3	2562.2	2721
Annual	Million cubic metres	Reused water	Algeria				5768	6013	6187	6227	6422
Annual	Million cubic metres	Reused water	Jordan	940.5	925.2	940.3	936	871.1	900.7	898.8	848.4	1043.9	1022.3	985	985	964.6	1076.4
Annual	Million cubic metres	Reused water	Tunisia	2092	2070.6	2098.7	2108.3	2117.2	2272


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "src" VARCHAR,
  "geo" VARCHAR,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE
);

Share link

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