Baselight

Water Made Available For Use

Eurostat code: env_wat_use · (1980 - 2022)

@eurostat.env_wat_use

Water Made Available For Use - Unpivoted
@eurostat.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.

  • 45.04 KB
  • 12840 rows
  • 7 columns
freq

Freq

wat_proc

Wat Proc

wat_src

Wat Src

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualTotal gross abstractionDesalinated waterCubic metres per inhabitantBelgium1980
AnnualTotal gross abstractionDesalinated waterCubic metres per inhabitantTürkiye1980
AnnualTotal gross abstractionDesalinated waterMillion cubic metresBelgium1980
AnnualTotal gross abstractionDesalinated waterMillion cubic metresTürkiye1980
AnnualTotal gross abstractionNon fresh waterCubic metres per inhabitantBelgium1980
AnnualTotal gross abstractionNon fresh waterCubic metres per inhabitantNetherlands1980396.68
AnnualTotal gross abstractionNon fresh waterMillion cubic metresBelgium1980
AnnualTotal gross abstractionNon fresh waterMillion cubic metresNetherlands19805613
AnnualWater abstraction by agriculture, forestry, fishingNon fresh waterCubic metres per inhabitantBelgium1980
AnnualWater abstraction by agriculture, forestry, fishingNon fresh waterCubic metres per inhabitantNetherlands1980

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

Share link

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