Data Doughnut
Data catalog › Environment & energy

EPA Safe Drinking Water Information System

Drinking water systems & violations

Every public water system: who it serves, its facilities and service areas, violations, enforcement, and lead and copper test results.

Published by EPA Safe Drinking Water Information System Finest detail facility Tables 9
Events and milestones Sample of 25 rows out of about 430,247 · 17 columns
idvintagecounty_fipsstatelatlonsubmissionyearquarterpwsidevent_schedule_idevent_end_dateevent_actual_dateevent_comments_textevent_milestone_codeevent_reason_codefirst_reported_datelast_reported_dateloaded_at
12026-10-0829185MONo dataNo data2026Q3MO5010612964No data07/01/1994No dataDEEMB112/30/2005No data2026-10-09 05:00:51
22026-10-0829043MONo dataNo data2026Q3MO5010619965No data07/01/1993No dataDEEMB112/30/2005No data2026-10-09 05:00:51
32026-10-0838061NDNo dataNo data2026Q3ND3100838345No data07/18/1994MIGRATEDDEEMB108/15/200311/18/20052026-10-09 05:00:51
42026-10-0838061NDNo dataNo data2026Q3ND3100898346No data12/31/1995MIGRATEDDONEB108/15/200308/14/20072026-10-09 05:00:51
52026-10-0838063NDNo dataNo data2026Q3ND3200023347No data07/18/1994MIGRATEDDEEMB108/15/200311/18/20052026-10-09 05:00:51
62026-10-0838063NDNo dataNo data2026Q3ND3200536348No data12/31/1995MIGRATEDDONEB108/15/200308/14/20072026-10-09 05:00:51
72026-10-0838063NDNo dataNo data2026Q3ND3200636349No data08/03/1994MIGRATEDDEEMB108/15/200311/18/20052026-10-09 05:00:51
82026-10-0838063NDNo dataNo data2026Q3ND3200653350No data08/03/1994MIGRATEDDEEMB108/15/200311/18/20052026-10-09 05:00:51
92026-10-0829109MONo dataNo data2026Q3MO5010641966No data07/01/1994No dataDEEMB112/30/2005No data2026-10-09 05:00:51
102026-10-0829119MONo dataNo data2026Q3MO5010645967No data07/01/1994No dataDEEMB112/30/2005No data2026-10-09 05:00:51
112026-10-0829167MONo dataNo data2026Q3MO5010650968No data07/01/1994No dataDEEMB112/30/2005No data2026-10-09 05:00:51
122026-10-0829097MONo dataNo data2026Q3MO5010665969No data07/01/1994No dataDEEMB112/30/2005No data2026-10-09 05:00:51
132026-10-0829009MONo dataNo data2026Q3MO5010667970No data07/01/1994No dataDEEMB112/30/2005No data2026-10-09 05:00:51
142026-10-0829145MONo dataNo data2026Q3MO5010678971No data01/01/1997No dataDEEMB112/30/2005No data2026-10-09 05:00:51
152026-10-0829209MONo dataNo data2026Q3MO5010679972No data07/01/1997No dataDEEMB112/30/2005No data2026-10-09 05:00:51
162026-10-0829077MONo dataNo data2026Q3MO5010681973No data07/01/1993No dataDEEMB112/30/2005No data2026-10-09 05:00:51
172026-10-0829213MONo dataNo data2026Q3MO5010697974No data07/01/1994No dataDEEMB112/30/2005No data2026-10-09 05:00:51
182026-10-0829225MONo dataNo data2026Q3MO5010699975No data07/01/1994No dataDEEMB112/30/2005No data2026-10-09 05:00:51
192026-10-0829097MONo dataNo data2026Q3MO5010723976No data07/01/1994No dataDEEMB112/30/2005No data2026-10-09 05:00:51
202026-10-0829217MONo dataNo data2026Q3MO5010725977No data07/01/1994No dataDEEMB112/30/2005No data2026-10-09 05:00:51
212026-10-0829009MONo dataNo data2026Q3MO5010730978No data07/01/1994No dataDEEMB112/30/2005No data2026-10-09 05:00:51
222026-10-0817059ILNo dataNo data2026Q3IL05903005205No data10/18/20072007E61 AND 2007E62 2 GOOD ROUNDS NOCCT.DEEMB102/21/200811/24/20102026-10-09 05:00:51
232026-10-0829099MONo dataNo data2026Q3MO60303652No data07/01/1994No dataDONENo data08/17/200108/17/20012026-10-09 05:00:51
242026-10-0817059ILNo dataNo data2026Q3IL05903005206No data10/18/20072007E61 AND 2007E62 2 GOOD ROUNDS NOCCT.DONENo data02/21/200811/24/20102026-10-09 05:00:51
252026-10-0829183MONo dataNo data2026Q3MO60304842No data07/01/1994No dataDONENo data08/17/200108/17/20012026-10-09 05:00:51

Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.

See pricing

Source data published by EPA Safe Drinking Water Information System. Data Doughnut shows it as published; US states + DC. · Support · Terms · Privacy Policy · What is Data Doughnut?