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
Facilities
Sample of 25 rows out of about 1,546,929
· 26 columns
| id | vintage | county_fips | state | lat | lon | submissionyearquarter | pwsid | facility_id | facility_name | state_facility_id | facility_activity_code | facility_deactivation_date | facility_type_code | submission_status_code | is_source_ind | water_type_code | availability_code | seller_treatment_code | seller_pwsid | seller_pws_name | filtration_status_code | is_source_treated_ind | first_reported_date | last_reported_date | loaded_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220113 | 1 | BF877 | 1 | A | No data | WL | Y | Y | GW | P | No data | No data | No data | No data | Y | No data | 08/31/2026 | 2026-10-09 05:01:01 |
| 2 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220113 | 12201134 | 12201134 | 12201134 | A | No data | DS | Y | N | No data | No data | No data | No data | No data | No data | No data | 12/20/2005 | 08/31/2026 | 2026-10-09 05:01:01 |
| 3 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220113 | 1T | BF877 | 1T | A | No data | TP | Y | N | No data | No data | No data | No data | No data | No data | No data | No data | 08/31/2026 | 2026-10-09 05:01:01 |
| 4 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220114 | 1 | BN870 | 1 | I | 03/18/2005 | WL | Y | Y | GW | P | No data | No data | No data | No data | N | No data | 03/05/2008 | 2026-10-09 05:01:01 |
| 5 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220114 | 12201145 | 12201145 | 12201145 | A | No data | DS | Y | N | No data | No data | No data | No data | No data | No data | No data | 12/20/2005 | 08/31/2026 | 2026-10-09 05:01:01 |
| 6 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220114 | 2 | BN871 | 2 | I | 08/11/2001 | WL | Y | Y | GW | P | No data | No data | No data | No data | N | No data | 02/27/2006 | 2026-10-09 05:01:01 |
| 7 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220114 | 200 | 200 | 200 | I | 09/02/1999 | OT | Y | N | No data | No data | No data | No data | No data | No data | No data | No data | 02/27/2006 | 2026-10-09 05:01:01 |
| 8 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220114 | 3 | RP170 | 3 | A | No data | WL | Y | Y | GW | P | No data | No data | No data | No data | N | No data | 08/31/2026 | 2026-10-09 05:01:01 |
| 9 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220115 | 12201156 | 12201156 | 12201156 | A | No data | DS | Y | N | No data | No data | No data | No data | No data | No data | No data | 12/20/2005 | 08/31/2026 | 2026-10-09 05:01:01 |
| 10 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220115 | 2 | BF878 | 2 | I | 01/01/2013 | WL | Y | Y | GW | P | No data | No data | No data | No data | N | No data | 02/26/2016 | 2026-10-09 05:01:01 |
| 11 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220115 | 200 | 200 | 200 | I | 05/23/1995 | TP | Y | N | No data | No data | No data | No data | No data | No data | No data | No data | 02/27/2006 | 2026-10-09 05:01:01 |
| 12 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220115 | 2T | BF878 | 2T | I | 01/01/2013 | TP | Y | N | No data | No data | No data | No data | No data | No data | No data | No data | 02/26/2016 | 2026-10-09 05:01:01 |
| 13 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220115 | 3 | BF879 | 3 | A | No data | WL | Y | Y | GW | P | No data | No data | No data | No data | Y | No data | 08/31/2026 | 2026-10-09 05:01:01 |
| 14 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220115 | 3T | BF879 | 3T | A | No data | TP | Y | N | No data | No data | No data | No data | No data | No data | No data | No data | 08/31/2026 | 2026-10-09 05:01:01 |
| 15 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220115 | 4 | BF880 | 4 | I | 11/07/2017 | WL | Y | Y | GW | P | No data | No data | No data | No data | N | No data | 12/15/2020 | 2026-10-09 05:01:01 |
| 16 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220115 | 4T | BF880 | 4T | I | 11/07/2017 | TP | Y | N | No data | No data | No data | No data | No data | No data | No data | No data | 12/15/2020 | 2026-10-09 05:01:01 |
| 17 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220117 | 1 | BF881 | 1 | I | 12/08/2005 | WL | Y | Y | GW | E | No data | No data | No data | No data | N | No data | 12/09/2008 | 2026-10-09 05:01:01 |
| 18 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220117 | 12201178 | 12201178 | 12201178 | A | No data | DS | Y | N | No data | No data | No data | No data | No data | No data | No data | 12/20/2005 | 08/31/2026 | 2026-10-09 05:01:01 |
| 19 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220117 | 1T | BF881 | 1T | I | 12/08/2005 | TP | Y | N | No data | No data | No data | No data | No data | No data | No data | No data | 12/09/2008 | 2026-10-09 05:01:01 |
| 20 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220117 | 2 | BF882 | 2 | A | No data | WL | Y | Y | GW | P | No data | No data | No data | No data | Y | No data | 08/31/2026 | 2026-10-09 05:01:01 |
| 21 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220117 | 2T | BF882 | 2T | A | No data | TP | Y | N | No data | No data | No data | No data | No data | No data | No data | No data | 08/31/2026 | 2026-10-09 05:01:01 |
| 22 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220118 | 1 | BN872 | 1 | I | 07/14/2006 | WL | Y | Y | GW | P | No data | No data | No data | No data | N | No data | 09/24/2009 | 2026-10-09 05:01:01 |
| 23 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220118 | 12201189 | 12201189 | 12201189 | A | No data | DS | Y | N | No data | No data | No data | No data | No data | No data | No data | 12/20/2005 | 08/31/2026 | 2026-10-09 05:01:01 |
| 24 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220118 | 1T | BN872 | 1T | I | 01/13/2006 | TP | Y | N | No data | No data | No data | No data | No data | No data | No data | No data | 03/17/2009 | 2026-10-09 05:01:01 |
| 25 | 2026-10-08 | 55043 | WI | No data | No data | 2026Q3 | WI1220118 | 2 | BN873 | 2 | I | 07/10/2006 | WL | Y | Y | GW | P | No data | No data | No data | No data | N | No data | 09/24/2009 | 2026-10-09 05:01:01 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing