Water Use Balance

Eurostat code: med_en42 · (2005 - 2018)

@eurostat.med_en42

Table List

2 tables(17.88 KB)

Water Use Balance - Unpivoted

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

5.25 KB
80 rows
6 columns

freq Freq	unit Unit	src Src	geo Geo	time_period Time Period	value Value
Annual	Million cubic metres	Total gross abstraction of freshwater	Algeria	2005	6450
Annual	Million cubic metres	Total gross abstraction of freshwater	Israel	2005	1728
Annual	Million cubic metres	Total gross abstraction of freshwater	Jordan	2005	857.4
Annual	Million cubic metres	Total gross abstraction of freshwater	Lebanon	2005	1250
Annual	Million cubic metres	Total gross abstraction of freshwater	Tunisia	2005	2448.3
Annual	Million cubic metres	Reused water	Jordan	2005	940.5
Annual	Million cubic metres	Reused water	Tunisia	2005	2092
Annual	Million cubic metres	Total gross abstraction of freshwater	Algeria	2006	6500
Annual	Million cubic metres	Total gross abstraction of freshwater	Israel	2006	1637
Annual	Million cubic metres	Total gross abstraction of freshwater	Jordan	2006	845.3


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

Share link

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