Renewable Freshwater Resources

Eurostat code: med_en41 · (2000 - 2012)

@eurostat.med_en41

Table List

2 tables(20.42 KB)

Renewable Freshwater Resources - Raw

Renewable Freshwater Resources - Unpivoted

Renewable Freshwater Resources - Raw

@eurostat.med_en41.raw

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

13.77 KB
45 rows
17 columns

freq Freq	unit Unit	src Src	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	Million cubic metres	Precipitation	Algeria													80000
Annual	Million cubic metres	Precipitation	Egypt				1.3	1.3	1.3	1.3	1.3	1.3
Annual	Million cubic metres	Precipitation	Israel	4700	5100	6600	8400	5700	5700	5300	5700	4202	4808	6201	5292	6111
Annual	Million cubic metres	Precipitation	Jordan	3651	7375	7545	9708	6951	9304	6258	7683	5194	6379	8727.7	6477	5943
Annual	Million cubic metres	Precipitation	Lebanon	8600									8600	8200
Annual	Million cubic metres	Precipitation	Morocco								139000	162000	165000	165000	146000	91000
Annual	Million cubic metres	Precipitation	Syria	31089	38908	44202	54978	60397	50405	41991	39131
Annual	Million cubic metres	Precipitation	Tunisia	24960	18960	18960	34200	38280	26400	30600	31680	21120	34080	21600	29280	18360
Annual	Million cubic metres	Regular freshwater resources 95 per cent time	Algeria							9200	9200	9200	9500	9500	9500
Annual	Million cubic metres	Regular freshwater resources 95 per cent time	Egypt				55.5	55.5	55.5	55.5	55.5	55.5


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "src" 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.