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
Areas served Sample of 25 rows out of about 574,676 · 18 columns
idvintagecounty_fipsstatelatlonsubmissionyearquarterpwsidgeo_idarea_type_codetribal_codestate_servedansi_entity_codezip_code_servedcity_servedcounty_servedlast_reported_dateloaded_at
12026-10-08No dataILNo dataNo data2026Q3IL097045019695776CTNo dataILNo dataNo dataHAWTHORN WOODSNo data09/08/20262026-10-09 05:01:46
22026-10-0817097ILNo dataNo data2026Q3IL097050019695777CNNo dataNo data097No dataNo dataLake09/08/20262026-10-09 05:01:46
32026-10-08No dataILNo dataNo data2026Q3IL097050019695778CTNo dataILNo dataNo dataHIGHLAND PARKNo data09/08/20262026-10-09 05:01:46
42026-10-0817097ILNo dataNo data2026Q3IL097055019695779CNNo dataNo data097No dataNo dataLake09/08/20262026-10-09 05:01:46
52026-10-08No dataILNo dataNo data2026Q3IL097055019695780CTNo dataILNo dataNo dataHIGHWOODNo data09/08/20262026-10-09 05:01:46
62026-10-0817097ILNo dataNo data2026Q3IL097075019695781CNNo dataNo data097No dataNo dataLake09/08/20262026-10-09 05:01:46
72026-10-08No dataILNo dataNo data2026Q3IL097075019695782CTNo dataILNo dataNo dataLAKE BLUFFNo data09/08/20262026-10-09 05:01:46
82026-10-0817097ILNo dataNo data2026Q3IL097080019695783CNNo dataNo data097No dataNo dataLake09/08/20262026-10-09 05:01:46
92026-10-08No dataILNo dataNo data2026Q3IL097080019695784CTNo dataILNo dataNo dataLAKE FORESTNo data09/08/20262026-10-09 05:01:46
102026-10-0817097ILNo dataNo data2026Q3IL097084019695785CNNo dataNo data097No dataNo dataLake09/08/20262026-10-09 05:01:46
112026-10-08No dataILNo dataNo data2026Q3IL097084019695786CTNo dataILNo dataNo dataLAKE VILLANo data09/08/20262026-10-09 05:01:46
122026-10-0817097ILNo dataNo data2026Q3IL097085019695787CNNo dataNo data097No dataNo dataLake09/08/20262026-10-09 05:01:46
132026-10-08No dataILNo dataNo data2026Q3IL097085019695788CTNo dataILNo dataNo dataLAKE ZURICHNo data09/08/20262026-10-09 05:01:46
142026-10-0817097ILNo dataNo data2026Q3IL097090019695789CNNo dataNo data097No dataNo dataLake09/08/20262026-10-09 05:01:46
152026-10-08No dataILNo dataNo data2026Q3IL097090019695790CTNo dataILNo dataNo dataLIBERTYVILLENo data09/08/20262026-10-09 05:01:46
162026-10-0817097ILNo dataNo data2026Q3IL097095019695791CNNo dataNo data097No dataNo dataLake09/08/20262026-10-09 05:01:46
172026-10-08No dataILNo dataNo data2026Q3IL097095019695792CTNo dataILNo dataNo dataLINCOLNSHIRENo data09/08/20262026-10-09 05:01:46
182026-10-0817097ILNo dataNo data2026Q3IL097100019695793CNNo dataNo data097No dataNo dataLake09/08/20262026-10-09 05:01:46
192026-10-08No dataILNo dataNo data2026Q3IL097100019695794CTNo dataILNo dataNo dataLINDENHURSTNo data09/08/20262026-10-09 05:01:46
202026-10-0817097ILNo dataNo data2026Q3IL097105019695795CNNo dataNo data097No dataNo dataLake09/08/20262026-10-09 05:01:46
212026-10-0817097ILNo dataNo data2026Q3IL097106019695796CNNo dataNo data097No dataNo dataLake09/08/20262026-10-09 05:01:46
222026-10-0817097ILNo dataNo data2026Q3IL097107019695797CNNo dataNo data097No dataNo dataLake09/08/20262026-10-09 05:01:46
232026-10-0824035MDNo dataNo data2026Q3MD117112619695798CNNo dataNo data035No dataNo dataQueen Anne's09/03/19982026-10-09 05:01:46
242026-10-0837151NCNo dataNo data2026Q3NC027662719695799CNNo dataNo data151No dataNo dataRandolph12/22/20012026-10-09 05:01:46
252026-10-0824035MDNo dataNo data2026Q3MD117112719695800CNNo dataNo data035No dataNo dataQueen Anne's09/03/19982026-10-09 05:01:46

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?