Renewable Freshwater Resources

Eurostat code: med_en41 · (2000 - 2012)

@eurostat.med_en41

Table List

2 tables(20.42 KB)

Renewable Freshwater Resources - Unpivoted

Renewable Freshwater Resources - Unpivoted

@eurostat.med_en41.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.65 KB
343 rows
6 columns

freq Freq	unit Unit	src Src	geo Geo	time_period Time Period	value Value
Annual	Million cubic metres	Precipitation	Israel	2000	4700
Annual	Million cubic metres	Precipitation	Jordan	2000	3651
Annual	Million cubic metres	Precipitation	Lebanon	2000	8600
Annual	Million cubic metres	Precipitation	Syria	2000	31089
Annual	Million cubic metres	Precipitation	Tunisia	2000	24960
Annual	Million cubic metres	Regular freshwater resources 95 per cent time	Lebanon	2000	2600
Annual	Million cubic metres	Regular freshwater resources 95 per cent time	Syria	2000	4778
Annual	Million cubic metres	Regular freshwater resources 95 per cent time	Tunisia	2000	3586
Annual	Million cubic metres	Actual evapotranspiration	Lebanon	2000	4300
Annual	Million cubic metres	Actual evapotranspiration	Syria	2000	26463


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.