Water Use By Economic Activity

Eurostat code: enps_env_wat_cat · (2005 - 2023)

@eurostat.enps_env_wat_cat

Table List

2 tables(23.04 KB)

Water Use By Economic Activity - Unpivoted

Water Use By Economic Activity - Unpivoted

@eurostat.enps_env_wat_cat.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.27 KB
219 rows
6 columns

freq Freq	unit Unit	nace_r2 Nace R2	geo Geo	time_period Time Period	value Value
Annual	Million cubic metres	Agriculture, forestry and fishing	Jordan	2005	610.5
Annual	Million cubic metres	Agriculture, forestry and fishing	Morocco	2005	8685
Annual	Million cubic metres	Agriculture, forestry and fishing	Tunisia	2005	1706.8
Annual	Million cubic metres	Irrigation in agriculture	Algeria	2005	3714
Annual	Million cubic metres	Irrigation in agriculture	Jordan	2005	603
Annual	Million cubic metres	Irrigation in agriculture	Tunisia	2005	1706.8
Annual	Million cubic metres	Manufacturing	Jordan	2005	39
Annual	Million cubic metres	Manufacturing	Tunisia	2005	88.5
Annual	Million cubic metres	Households	Algeria	2005	1656
Annual	Million cubic metres	Households	Jordan	2005	291


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

Share link

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