About this Dataset

Reported Sewer Overflows

NOTE: This dataset is no longer updated. Due to a change in databases, overflows after after January 31, 2023 are reported at https://opendata.maryland.gov/dataset/Reported-Sewer-Overflows-New-for-2023-/stgj-u72u/data_preview

Reported sewer overflows from January 1, 2005 through January 31, 2023. Although MDE requires that all public sewer system owners or operators report overflows to us, there may be incidents that were not reported. Note that overflow amounts provided by the person reporting the overflow may be estimated using best professional judgment or they may be actual readings from flow measurement devices when available. Penalty information started during 2013.
Organization: State of Maryland
Last updated: 2020-11-10T17:23:52.746379
Tags: cso, mde, sewer-overflow, sso, water, water-quality

Tables

Table 1

@usgov.state_of_maryland_reported_sewer_overflows.table_1

1.08 MB
27,479 rows
22 columns

CREATE TABLE table_1 (
  "overflow_type" VARCHAR,
  "municipality_facility" VARCHAR,
  "npdes" VARCHAR  -- NPDES #,
  "date_discovered" TIMESTAMP,
  "time_discovered" VARCHAR,
  "duration_days" DOUBLE  -- Duration - Days,
  "duration_hours" DOUBLE  -- Duration - Hours,
  "duration_minutes" DOUBLE  -- Duration - Minutes,
  "location" VARCHAR,
  "zip_code" DOUBLE,
  "collection_system" VARCHAR,
  "quantity_in_gallons_estimated" DOUBLE  -- Quantity In Gallons (Estimated),
  "net_in_gallons_estimated" DOUBLE  -- Net In Gallons (Estimated),
  "cause" VARCHAR,
  "watershed" VARCHAR,
  "receiving_waters" VARCHAR,
  "county" VARCHAR,
  "notes" VARCHAR,
  "penalty_collected" DOUBLE,
  "penalty_comments" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);