Water Exploitation Index, Plus (WEI+)

Eurostat code: sdg_06_60 · (2000 - 2022)

@eurostat.sdg_06_60

Table List

2 tables(30.92 KB)

Water Exploitation Index, Plus (WEI+) - Raw

Water Exploitation Index, Plus (WEI+) - Unpivoted

Water Exploitation Index, Plus (WEI+) - Unpivoted

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

7.97 KB
851 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Percentage	Albania	2000	3.55
Annual	Percentage	Austria	2000	1.25
Annual	Percentage	Bosnia and Herzegovina	2000	0.43
Annual	Percentage	Belgium	2000	7.12
Annual	Percentage	Bulgaria	2000	1.44
Annual	Percentage	Switzerland	2000	0.79
Annual	Percentage	Cyprus	2000	59.54
Annual	Percentage	Czechia	2000	3.09
Annual	Percentage	Germany	2000	4.32
Annual	Percentage	Denmark	2000	3.39


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

Share link

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