Name: Freshwater Resources By River Basin District (RBD)
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Freshwater Resources By River Basin District (RBD)

This Eurostat dataset contains data on freshwater resources by river basin district (rbd), as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-08-01T11:00:00+0200

Tables

Freshwater Resources By River Basin District (RBD) - Raw

@eurostat.env_watres_rb.raw

158.3 KB
1445 rows
28 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "wat_proc" VARCHAR,
  "rbd" VARCHAR,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

Freshwater Resources By River Basin District (RBD) - Unpivoted

@eurostat.env_watres_rb.tidy

154.18 KB
24075 rows
6 columns


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