Annual Freshwater Abstraction By Source

Eurostat code: enps_env_wat_abs · (2005 - 2022)

@eurostat.enps_env_wat_abs

Table List

2 tables(22.62 KB)

Annual Freshwater Abstraction By Source - Raw

Annual Freshwater Abstraction By Source - Unpivoted

Annual Freshwater Abstraction By Source - Unpivoted

@eurostat.enps_env_wat_abs.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.3 KB
269 rows
6 columns

freq Freq	unit Unit	wat_src Wat Src	geo Geo	time_period Time Period	value Value
Annual	Million cubic metres	Fresh groundwater	Algeria	2005	2800
Annual	Million cubic metres	Fresh groundwater	Israel	2005	883
Annual	Million cubic metres	Fresh groundwater	Jordan	2005	506
Annual	Million cubic metres	Fresh groundwater	Morocco	2005	4100
Annual	Million cubic metres	Fresh groundwater	Tunisia	2005	1930.3
Annual	Million cubic metres	Fresh surface and groundwater	Algeria	2005	6450
Annual	Million cubic metres	Fresh surface and groundwater	Israel	2005	1728
Annual	Million cubic metres	Fresh surface and groundwater	Jordan	2005	857.4
Annual	Million cubic metres	Fresh surface and groundwater	Lebanon	2005	1250
Annual	Million cubic metres	Fresh surface and groundwater	Morocco	2005	7498


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

Share link

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