Water Abstracted By Sector Of Use

Eurostat code: ten00006 · (2011 - 2022)

@eurostat.ten00006

Table List

2 tables(40.36 KB)

Water Abstracted By Sector Of Use - Unpivoted

Water Abstracted By Sector Of Use - Unpivoted

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

16.79 KB
1759 rows
7 columns

freq Freq	unit Unit	wat_proc Wat Proc	wat_src Wat Src	geo Geo	time_period Time Period	value Value
Annual	Million cubic metres	Total gross abstraction	Fresh surface water	Belgium	2011	4757.2
Annual	Million cubic metres	Total gross abstraction	Fresh surface water	Bulgaria	2011	5840.35
Annual	Million cubic metres	Total gross abstraction	Fresh surface water	Cyprus	2011	65.8
Annual	Million cubic metres	Total gross abstraction	Fresh surface water	Czechia	2011	1508.4
Annual	Million cubic metres	Total gross abstraction	Fresh surface water	Germany	2011	24600.38
Annual	Million cubic metres	Total gross abstraction	Fresh surface water	Denmark	2011	248
Annual	Million cubic metres	Total gross abstraction	Fresh surface water	Estonia	2011	1574.7
Annual	Million cubic metres	Total gross abstraction	Fresh surface water	Greece	2011	4409.54
Annual	Million cubic metres	Total gross abstraction	Fresh surface water	Spain	2011	28926
Annual	Million cubic metres	Total gross abstraction	Fresh surface water	France	2011	22407.92


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

Share link

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