Freshwater Abstraction

Eurostat code: med_en43 · (2005 - 2018)

@eurostat.med_en43

Table List

2 tables(20.76 KB)

Freshwater Abstraction - Raw

Freshwater Abstraction - Unpivoted

Freshwater Abstraction - Raw

@eurostat.med_en43.raw

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

14.14 KB
21 rows
19 columns

freq Freq	unit Unit	src Src	cons Cons	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	Fresh surface water	Total gross abstraction	Algeria	3650	3700	3850	2800	2950	4600	4600	4800	1596	1702	1730	2900	1699
Annual	Million cubic metres	Fresh surface water	Total gross abstraction	Egypt						55.5	55.5	55.5	55.5	55.5	55.5	55.5
Annual	Million cubic metres	Fresh surface water	Total gross abstraction	Israel	845	651	625	634	479	504	521	516	645	470	381	331	339	343
Annual	Million cubic metres	Fresh surface water	Total gross abstraction	Jordan	351.4	365.3	345	335.9	274.4	286.8	279.1	238.9	258.5	258.6	274	274	288	298.1
Annual	Million cubic metres	Fresh surface water	Total gross abstraction	Tunisia	518	551	570	546	546	546
Annual	Million cubic metres	Fresh ground water	Total gross abstraction	Algeria	2800	2800	3000	4150	4200	2603	2915	3000	3047	3117	7224	6330	8103
Annual	Million cubic metres	Fresh ground water	Total gross abstraction	Egypt						6.3	6.3	7.5	7.7	6.7	6.9	6.9
Annual	Million cubic metres	Fresh ground water	Total gross abstraction	Israel	883	986	1064	961	834	836	738	802	651	801	792	868	862	769
Annual	Million cubic metres	Fresh ground water	Total gross abstraction	Jordan	506	480	493.3	487.4	484.2	502	503.7	495	588.5	588.5	601.8	601.8	618.8	624.9
Annual	Million cubic metres	Fresh ground water	Total gross abstraction	Morocco	4100	4100	4100	4100	4100	4100


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