Opendatabay APP

UK Wastewater Overflow & Rainfall Analysis

Data Science and Analytics

Tags and Keywords

Pollution

Environment

Rainfall

Sewage

Water

Trusted By
Trusted by company1Trusted by company2Trusted by company3
UK Wastewater Overflow & Rainfall Analysis Dataset on Opendatabay data marketplace

"No reviews yet"

Free

About

This environmental monitoring resource provides daily time series data detailing sewage overflow events managed by Thames Water, one of the UK's largest water providers. It integrates crucial operational metrics, such as the number and duration of spills, with corresponding precipitation measurements from across the catchment area. This combination allows for analysis of the relationship between rainfall conditions and wastewater infrastructure stress. The resource promotes transparency and supports efforts to address significant sewage pollution issues in South East England.

Columns

  • start_day: The date for which the overflow and rainfall data are aggregated. The data includes 366 unique dates.
  • chenies_rain: Total Precipitation (mm) recorded in Chenies. The mean precipitation is 2.75 mm.
  • crossness_rain: Total Precipitation (mm) recorded in Crossness. The mean precipitation is 1.8 mm.
  • edenvale_rain: Total Precipitation (mm) recorded in Edenvale. The mean precipitation is 3.01 mm.
  • haveringbower_rain: Total Precipitation (mm) recorded in Haveringbower. The mean precipitation is 2.05 mm.
  • hollandpark_rain: Total Precipitation (mm) recorded in Holland Park. The mean precipitation is 1.89 mm.
  • leatherhead_rain: Total Precipitation (mm) recorded in Leatherhead. The mean precipitation is 2.39 mm.
  • northmymms_rain: Total Precipitation (mm) recorded in North Mymms. The mean precipitation is 2.05 mm.
  • num_active_events: The number of sewage overflows that occurred at some point on that specific date. The maximum observed count is 459 events.
  • num_unique_locs: The number of distinct locations where a sewage overflow occurred on that date. The maximum observed count is 276 unique locations.
  • num_start_events: The number of sewage overflow events that began on that date.
  • median_spill_duration: The median duration (in minutes) of a sewage overflow event on that date. The maximum median duration is 1050 minutes.
  • mean_spill_duration: The mean duration (in minutes) of a sewage overflow event on that date.
  • sum_spill_duration: The total cumulative duration (in minutes) of all sewage overflows on that date. The maximum total duration observed is 173,377 minutes.

Distribution

The data is delivered as a daily aggregated version in CSV format, specifically the file thames_water_aggregated_daily_sewage_spills.csv, with a file size of approximately 23.81 kB. It contains 14 columns and 366 records, where all records are valid. The dataset is expected to be updated quarterly.

Usage

This resource is ideal for various analytical projects, including:
  • Exploring temporal trends over time to identify how operational practices change.
  • Developing regression models to predict future sewage overflow durations based on changing precipitation conditions.
  • Conducting focused time series analysis related to environment and pollution.
  • Creating visualisations that map environmental impact and water infrastructure stress.

Coverage

The dataset covers daily aggregated events reported by Thames Water, which provides services to over 15 million customers in South East England. The temporal scope includes records from April 2022 through to January 2024. Geographic coverage includes rainfall metrics collected from specific monitoring stations within the catchment area.

License

CC0: Public Domain

Who Can Use It

  • Environmental Researchers: To study the correlation between high rainfall and sewage discharge volumes.
  • Policy Analysts: To evaluate the success and accountability of wastewater infrastructure improvement schemes.
  • Data Journalists: To report on public interest issues related to water quality and corporate environmental performance.
  • Public Awareness Groups: To raise awareness and support charities focused on reducing sewage pollution.

Dataset Name Suggestions

  • Thames Water Daily Sewage Spill Metrics
  • UK Wastewater Overflow & Rainfall Analysis
  • South East England Environmental Discharge Data
  • Daily Pollution Events Time Series

Attributes

Listing Stats

VIEWS

5

DOWNLOADS

1

LISTED

26/11/2025

REGION

GLOBAL

Universal Data Quality Score Logo UDQSQUALITY

5 / 5

VERSION

1.0

Loading...

Free

Download Dataset in ZIP Format