Freshwater Abstraction

Eurostat code: med_en43 · (2005 - 2018)

@eurostat.med_en43

Table List

2 tables(20.76 KB)

Freshwater Abstraction - Unpivoted

@eurostat.med_en43.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.

6.62 KB
197 rows
7 columns

freq Freq	unit Unit	src Src	cons Cons	geo Geo	time_period Time Period	value Value
Annual	Million cubic metres	Fresh surface water	Total gross abstraction	Algeria	2005	3650
Annual	Million cubic metres	Fresh surface water	Total gross abstraction	Israel	2005	845
Annual	Million cubic metres	Fresh surface water	Total gross abstraction	Jordan	2005	351.4
Annual	Million cubic metres	Fresh surface water	Total gross abstraction	Tunisia	2005	518
Annual	Million cubic metres	Fresh ground water	Total gross abstraction	Algeria	2005	2800
Annual	Million cubic metres	Fresh ground water	Total gross abstraction	Israel	2005	883
Annual	Million cubic metres	Fresh ground water	Total gross abstraction	Jordan	2005	506
Annual	Million cubic metres	Fresh ground water	Total gross abstraction	Morocco	2005	4100
Annual	Million cubic metres	Fresh ground water	Total gross abstraction	Palestine*	2005	268.3
Annual	Million cubic metres	Fresh ground water	Total gross abstraction	Tunisia	2005	1930.3


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "src" VARCHAR,
  "cons" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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