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
Systems — search file Sample of 25 rows out of about 424,199 · 83 columns
idvintagecounty_fipsstatelatlonpws_namepwsidcities_servedstate_codezip_codes_servedcounties_servedepa_regionregistry_idindian_countrypws_type_codepws_type_descprimary_source_codeprimary_source_descpopulation_served_countpws_activity_codepws_activity_descowner_type_codeowner_descqtrs_with_vioqtrs_with_sncserious_violatorhealth_flagmr_flagpn_flagother_flagnew_vio_flgrules_vio_3yrrules_vioviopaccrvioremainviofeanotviortcfeaviortcnofeaifeafeassdw_date_last_ieasdw_date_last_iea_epasdw_date_last_iea_stsdw_date_last_feasdw_date_last_fea_epasdw_date_last_fea_stsdwa_contaminants_in_viol_3yrsdwa_contaminants_in_cur_violpb_alecu_alerc_350_violdfr_urlfips_codessncgw_sw_codesdwa_3yr_compl_qtrs_historysdwa_contaminantstribal_flagfea_flagiea_flagsnc_flagcurr_vio_flagvio_flaginsp_5yr_flagservice_area_type_codeservice_area_type_descviolation_categoriessansurvey5yrdate_last_sansurveydate_last_survey_actsignificant_deficiency_countsignificant_deficiency_count_ilssig_def_count_ils_actsdw_date_last_visitsdw_date_last_visit_epasdw_date_last_visit_statesdw_date_last_visit_localsite_visits_5yr_allsite_visits_5yr_inspectionssite_visits_5yr_otherweb_docsloaded_at
12026-10-0753029WANo dataNo dataOLYMPIC VIEW ESTATESWA5342421No dataWANo dataIsland10110049825668NCWSCommunity water systemGWGround water33AActivePPrivate00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11004982566853029No ViolationGW_____________No data0000001RAResidential AreaNo data104/18/202404/18/2024No dataNo dataNo data04/18/2024No data04/18/2024No data101No data2026-10-09 05:02:20
22026-10-0740115OKNo dataNo dataQUAPAW TRIBEOK2005812No dataOKNo dataOttawa06110011008033NCWSCommunity water systemGWGround water55AActiveLLocal government60NoNoNoNoNoNo50120No dataNo data1213No data07/11/202511/04/199407/11/202510/13/2004No data10/13/20040999=Chlorine; 8000=Revised Total Coliform RuleNo dataNo dataNo data1https://echo.epa.gov/detailed-facility-report?fid=11001100803340115No ViolationGW_____VVVVVV_U0999=Chlorine; 2456=Total Haloacetic Acids (HAA5); 2950=TTHM; 5000=Lead and Copper Rule; 5200=LEAD AND COPPER RULE REVISIONS; 7000=Consumer Confidence Rule; 8000=Revised Total Coliform Rule0010011RAResidential AreaMonitoring Violation | Monitoring and Reporting | Other Violation | Reporting Violation | Treatment Technique Violation208/24/202308/24/2023No dataNo dataNo data02/26/2025No data02/26/2025No data422No data2026-10-09 05:02:20
32026-10-0704013AZNo dataNo dataCARL T HAYDEN VETERANS MEDICAL CENTERAZ0407580No dataAZNo dataMaricopa09110072197061NNTNCWSNon-Transient non-community systemSWPSurface water purchased6293AActiveFFederal government00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data1No datahttps://echo.epa.gov/detailed-facility-report?fid=11007219706104013No ViolationSW____________UNo data0000000MFMedical FacilityNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
42026-10-0727029MNNo dataNo dataSportsman's Lodge on Pine LakeMN5150026No dataMNNo dataClearwater05110052194905NTNCWSTransient non-community systemGWGround water25AActivePPrivate00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005219490527029No ViolationGW_____________No data0000001OTOther Transient AreaNo data205/13/202405/13/2024No dataNo dataNo data05/13/2024No data05/13/2024No data202No data2026-10-09 05:02:20
52026-10-0717179ILNo dataNo dataROSEWOOD LANESIL0055830No dataILNo dataTazewell05110051346717NTNCWSTransient non-community systemGWGround water25IInactiveNo dataNo data00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005134671717179InactiveGW No data0000000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
62026-10-0717109ILNo dataNo dataCOLMAR CHRISTIAN CHURCHIL0014399No dataILNo dataMcDonough05110054023837NTNCWSTransient non-community systemGWGround water50IInactiveNo dataNo data00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005402383717109InactiveGW No data0000000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
72026-10-0717181ILNo dataNo dataBOB OWENIL0002329No dataILNo dataUnion05110054045573NTNCWSTransient non-community systemGWGround water200IInactiveSState or Territorial Government00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005404557317181InactiveGW No data0000000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
82026-10-0717177ILNo dataNo dataSHIPPY'S TAVERNIL0050922No dataILNo dataStephenson05110054025014NTNCWSTransient non-community systemGWGround water50IInactiveNo dataNo data00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005402501417177InactiveGW No data0000000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
92026-10-0717117ILNo dataNo dataHEYENSIL0005124No dataILNo dataMacoupin05110051302489NTNCWSTransient non-community systemGWGround water25IInactiveNo dataNo data00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005130248917117InactiveGW No data0000000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
102026-10-0717103ILNo dataNo dataWELL'S MOTELIL0006478No dataILNo dataLee05110053959926NTNCWSTransient non-community systemGWGround water25IInactiveNo dataNo data00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005395992617103InactiveGW No data0000000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
112026-10-0717103ILNo dataNo dataLEE CENTER F S CENTERIL0006494No dataILNo dataLee05110053959953NTNCWSTransient non-community systemGWGround water25IInactiveNo dataNo data00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005395995317103InactiveGW No data0000000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
122026-10-0717021ILNo dataNo dataKEMMERER VILLAGEIL0051391No dataILNo dataChristian05110051341641NTNCWSTransient non-community systemGWGround water60IInactiveNo dataNo data00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005134164117021InactiveGW No data0000000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
132026-10-0712017FLNo dataNo dataSURBERS TRAILER PARKFL6092051No dataFLNo dataCitrus04110053797511NCWSCommunity water systemGWGround water25IInactivePPrivate00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005379751112017InactiveGW No data0000000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
142026-10-0712131FLNo dataNo dataEDGEWOOD TERRACEFL1664070No dataFLNo dataWalton04110053690975NCWSCommunity water systemGWGround water50IInactivePPrivate00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005369097512131InactiveGW No data0000000SUSubdivisionNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
152026-10-0712073FLNo dataNo dataKING'S MOBILE HOME PARKFL1370394No dataFLNo dataLeon04110053710551NCWSCommunity water systemGWGround water32IInactivePPrivate00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo data09/30/1986No data09/30/1986No dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005371055112073InactiveGW No data0000000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
162026-10-0754089WVNo dataNo dataBILL GRIMMWV9945019No dataWVNo dataSummers03110050845939NTNCWSTransient non-community systemGWGround water25IInactivePPrivate00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005084593954089InactiveGW No data0000000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
172026-10-0754089WVNo dataNo dataBLUESTONE STATE PARKWV9945056No dataWVNo dataSummers03110050594549NTNCWSTransient non-community systemSWPSurface water purchased1000NChanged from public to non-publicPPrivate00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo data12/20/1994No data12/20/1994No dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005059454954089InactiveSW No data0000000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
182026-10-0755113WINo dataNo dataMUSKY JOES TWIN PINES(TAVERN/HOUSE)WI8580797No dataWINo dataSawyer05110052033054NTNCWSTransient non-community systemGWGround water31IInactivePPrivate00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo data02/26/1996No data02/26/1996No dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005203305455113InactiveGW No data0000000OAOther AreaNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data10/12/1995No data00No dataNo data2026-10-09 05:02:20
192026-10-0755029WINo dataNo dataHILLSIDE COTTAGESWI4151013No dataWINo dataDoor05110050842344NTNCWSTransient non-community systemGWGround water25IInactivePPrivate00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005084234455029InactiveGW No data0000000OAOther AreaNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
202026-10-0755137WINo dataNo dataDAHLKE FRASER GARAGEWI4700338No dataWINo dataWaushara05110049916249NTNCWSTransient non-community systemGWGround water25IInactivePPrivate00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11004991624955137InactiveGW No data0000000OAOther AreaNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
212026-10-0755085WINo dataNo dataCARROUSEL DAY CAREWI7440645No dataWINo dataOneida05110050597181NNTNCWSNon-Transient non-community systemGWGround water28IInactivePPrivate00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo data03/08/1996No data03/08/1996No dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005059718155085InactiveGW No data0000000DCDaycare CenterNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
222026-10-0710001DENo dataNo dataPETERSBURG STOREDE0000214No dataDENo dataKent03110050023489NTNCWSTransient non-community systemGWGround water25IInactivePPrivate00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005002348910001InactiveGW No data0000000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
232026-10-0712031FLNo dataNo dataHOBBY HOUSE RESTAURANTFL2164198SAMEFLNo dataDuval04110053801711NTNCWSTransient non-community systemGWGround water92IInactivePPrivate00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo data04/15/1982No data04/15/1982No dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005380171112031InactiveGW No data0000000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
242026-10-0717091ILNo dataNo dataSACRED HEART CATHOLIC CHURCHIL0078667No dataILNo dataKankakee05110051324660NTNCWSTransient non-community systemGWGround water25IInactiveNo dataNo data00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005132466017091InactiveGW No data0000000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20
252026-10-0716001IDNo dataNo dataMR KREIZENBECKID5542855No dataIDNo dataAda10110053933892NTNCWSTransient non-community systemGWGround water25IInactiveFFederal government00NoNoNoNoNoNo0000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo datahttps://echo.epa.gov/detailed-facility-report?fid=11005393389216001InactiveGW No data0000000No dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo dataNo data00No dataNo data2026-10-09 05:02:20

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?