Name: Sewage Sludge Production And Disposal
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Sewage Sludge Production And Disposal

This Eurostat dataset contains data on sewage sludge production and disposal, 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-07-31T23:00:00+0200

Tables

Sewage Sludge Production And Disposal - Raw

@eurostat.env_ww_spd.raw

85.56 KB
652 rows
44 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "ww_tpar" VARCHAR,
  "ww_tp" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1970" DOUBLE,
  "n_1975" DOUBLE,
  "n_1980" DOUBLE,
  "n_1985" DOUBLE,
  "n_1989" DOUBLE,
  "n_1990" DOUBLE,
  "n_1991" DOUBLE,
  "n_1992" DOUBLE,
  "n_1993" DOUBLE,
  "n_1994" DOUBLE,
  "n_1995" DOUBLE,
  "n_1996" DOUBLE,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "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
);

Sewage Sludge Production And Disposal - Unpivoted

@eurostat.env_ww_spd.tidy

48.27 KB
12448 rows
7 columns


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