Annual Freshwater Use, ENP-East Countries

Eurostat code: enpe_env_wat_use · (2005 - 2023)

@eurostat.enpe_env_wat_use

Table List

2 tables(19.83 KB)

Annual Freshwater Use, ENP-East Countries - Raw

Annual Freshwater Use, ENP-East Countries - Unpivoted

Annual Freshwater Use, ENP-East Countries - Unpivoted

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

4.7 KB
104 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Million cubic metres	Armenia	2005	1905
Annual	Million cubic metres	Azerbaijan	2005	8231
Annual	Million cubic metres	Belarus	2005	1600
Annual	Million cubic metres	Moldova	2005	785
Annual	Million cubic metres	Ukraine	2005	9360
Annual	Million cubic metres	Armenia	2006	1991
Annual	Million cubic metres	Azerbaijan	2006	8658
Annual	Million cubic metres	Belarus	2006	1546
Annual	Million cubic metres	Moldova	2006	787
Annual	Million cubic metres	Ukraine	2006	9335


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.