Fresh Water Abstraction By Source Per Capita - M³ Per Capita

Eurostat code: ten00003 · (2011 - 2022)

@eurostat.ten00003

Table List

2 tables(29.98 KB)

Fresh Water Abstraction By Source Per Capita - M³ Per Capita - Raw

Fresh Water Abstraction By Source Per Capita - M³ Per Capita - Unpivoted

Fresh Water Abstraction By Source Per Capita - M³ Per Capita - Unpivoted

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

11.66 KB
920 rows
7 columns

freq Freq	unit Unit	wat_proc Wat Proc	wat_src Wat Src	geo Geo	time_period Time Period	value Value
Annual	Cubic metres per inhabitant	Total gross abstraction	Fresh groundwater	Belgium	2011	57.07
Annual	Cubic metres per inhabitant	Total gross abstraction	Fresh groundwater	Bulgaria	2011	74.13
Annual	Cubic metres per inhabitant	Total gross abstraction	Fresh groundwater	Cyprus	2011	182.16
Annual	Cubic metres per inhabitant	Total gross abstraction	Fresh groundwater	Czechia	2011	36.03
Annual	Cubic metres per inhabitant	Total gross abstraction	Fresh groundwater	Germany	2011	73.07
Annual	Cubic metres per inhabitant	Total gross abstraction	Fresh groundwater	Denmark	2011	127.92
Annual	Cubic metres per inhabitant	Total gross abstraction	Fresh groundwater	Estonia	2011	225.32
Annual	Cubic metres per inhabitant	Total gross abstraction	Fresh groundwater	Greece	2011	505.95
Annual	Cubic metres per inhabitant	Total gross abstraction	Fresh groundwater	Spain	2011	131.43
Annual	Cubic metres per inhabitant	Total gross abstraction	Fresh groundwater	France	2011	90.72


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.