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
Water systems
Sample of 25 rows out of about 420,958
· 52 columns
| id | vintage | county_fips | state | lat | lon | pwsid | pws_name | npm_candidate | primacy_agency_code | epa_region | season_begin_date | season_end_date | pws_activity_code | pws_deactivation_date | pws_type_code | dbpr_schedule_cat_code | cds_id | gw_sw_code | lt2_schedule_cat_code | owner_type_code | population_served_count | pop_cat_2_code | pop_cat_3_code | pop_cat_4_code | pop_cat_5_code | pop_cat_11_code | primacy_type | primary_source_code | is_grant_eligible_ind | is_wholesaler_ind | is_school_or_daycare_ind | service_connections_count | submission_status_code | org_name | admin_name | email_addr | phone_number | phone_ext_number | fax_number | alt_phone_number | address_line1 | address_line2 | city_name | zip_code | country_code | state_code | source_water_protection_code | source_protection_begin_date | outstanding_performer | outstanding_perform_begin_date | loaded_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2026-10-09 | No data | CT | No data | No data | 010106001 | Mashantucket Pequot Water System | Y | 01 | 01 | No data | No data | A | No data | CWS | No data | No data | SW | No data | N | 22171 | 2 | 2 | 2 | 4 | 6 | Tribal | GU | Y | Y | N | 119 | Y | Mashantucket Pequot Tribal Utilities | Rodney Butler | No data | 8603966740 | No data | No data | No data | Tribal Office | Indiantown Rd, - PO BOX 3060 | MASHANTUCKET | 06339-3060 | US | CT | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 2 | 2026-10-09 | No data | No data | No data | No data | 010109001 | Mohegan Sun RETAIL/CASINO/HOTEL/ETC | N | 01 | 01 | No data | No data | I | 2000-01-01 00:00:00 | NTNCWS | No data | No data | GW | No data | N | 41185 | 2 | 2 | 2 | 4 | 6 | Tribal | GW | N | N | N | 1 | Y | No data | No data | No data | No data | No data | No data | No data | No data | No data | No data | No data | No data | No data | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 3 | 2026-10-09 | No data | CT | No data | No data | 010109005 | Mohegan Tribal Utility Authority | Y | 01 | 01 | No data | No data | A | No data | CWS | No data | No data | SW | No data | N | 31961 | 2 | 2 | 2 | 4 | 6 | Tribal | SWP | Y | N | N | 34 | Y | Mohegan Tribe | Kevin Brown | No data | No data | No data | No data | No data | 5 Crow Hill Road | No data | Uncasville | 06382 | US | CT | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 4 | 2026-10-09 | No data | MA | No data | No data | 010307001 | Aquinnah Wampanoag | Y | 01 | 01 | No data | No data | A | No data | CWS | No data | No data | GW | No data | N | 89 | 1 | 1 | 1 | 1 | 1 | Tribal | GW | Y | N | N | 32 | Y | Aquinnah Wampanoag Tribal Housing Authority | Dave Zimmerman | awtha.dave@wampanoagtribe-nsn.gov | 5086452711 | No data | No data | No data | P.O. Box 479 | No data | Chilmark | 02535 | US | MA | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 5 | 2026-10-09 | No data | RI | No data | No data | 010502001 | NARRAGANSETT INDIAN LONGHOUSE | N | 01 | 01 | No data | No data | I | 2005-08-02 00:00:00 | TNCWS | No data | No data | GW | No data | N | 30 | 1 | 1 | 1 | 1 | 1 | Tribal | GW | N | N | N | 2 | Y | No data | NARRAGANSETT INDIAN LONGHOUSE | No data | 401-364-1117 | No data | No data | No data | BOX 231 | SOUTH COUNTY TRAIL,RT.112,RT.2 | CHARLESTOWN | 02813 | US | RI | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 6 | 2026-10-09 | No data | RI | No data | No data | 010502002 | Narragansett Indian Admin Building | Y | 01 | 01 | No data | No data | A | No data | NTNCWS | No data | No data | GW | No data | N | 25 | 1 | 1 | 1 | 1 | 1 | Tribal | GW | Y | N | N | 3 | Y | Narragansett Indian Tribe | Anthony Dean Stanton | adstanton@nitribe.org | 4013641100 | No data | No data | No data | P.O. Box 268 | No data | Charlestown | 02813 | US | RI | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 7 | 2026-10-09 | No data | RI | No data | No data | 010502003 | Narragansett Four Winds Community Center | Y | 01 | 01 | No data | No data | A | No data | NTNCWS | No data | No data | GW | No data | N | 50 | 1 | 1 | 1 | 1 | 1 | Tribal | GW | Y | N | Y | 4 | Y | Narragansett Indian Tribe | Anthony Dean Stanton | adstanton@nitribe.org | 4013641100 | No data | No data | No data | P.O. Box 268 | No data | Charlestown | 02813 | US | RI | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 8 | 2026-10-09 | No data | RI | No data | No data | 010502004 | Narragansett Indian Health Center | N | 01 | 01 | No data | No data | I | 1995-01-01 00:00:00 | TNCWS | No data | No data | GW | No data | N | 40 | 1 | 1 | 1 | 1 | 1 | Tribal | GW | N | N | N | 1 | Y | Narragansett Indian Tribe | Matthew Thomas | No data | 4013641100 | No data | No data | No data | PO Box 268 | No data | Charlestown | 02813 | US | RI | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 9 | 2026-10-09 | No data | NY | No data | No data | 020000001 | JIMMERSONTOWN WS | Y | 02 | 02 | No data | No data | A | No data | CWS | No data | No data | GW | No data | N | 296 | 1 | 1 | 1 | 1 | 2 | Tribal | GW | Y | N | Y | 180 | Y | SENECA NATION OF INDIANS | Theresa Lay | No data | No data | No data | No data | No data | SENECA NATION HEALTH DEPT | PO BOX 231 | SALAMANCA | 14779 | US | NY | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 10 | 2026-10-09 | No data | NY | No data | No data | 020000002 | RICHARDSON ROAD WS | N | 02 | 02 | No data | No data | I | 2008-09-22 00:00:00 | CWS | No data | No data | GW | No data | P | 20 | 1 | 1 | 1 | 1 | 1 | Tribal | GW | N | N | N | 90 | Y | PATTERSON, PATRICIA | PATTERSON, PATRICIA | No data | No data | No data | No data | No data | SENECA NATION HEALTH DEPT | PO BOX 231 | SALAMANCA | 14779 | US | NY | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 11 | 2026-10-09 | No data | NY | No data | No data | 020000003 | IRVING INDUSTRIAL PARK | N | 02 | 02 | No data | No data | I | 1995-12-01 00:00:00 | TNCWS | No data | No data | GW | No data | P | 100 | 1 | 1 | 1 | 1 | 1 | Tribal | GW | N | N | N | 2 | Y | No data | IRVING INDUSTRIAL PARK | No data | 716-549-5862 | No data | No data | No data | No data | 1510 ROUTE 438 | IRVING | 14081 | US | NY | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 12 | 2026-10-09 | No data | NY | No data | No data | 020000004 | STEAMBURG WS | Y | 02 | 02 | No data | No data | A | No data | CWS | No data | No data | GW | No data | N | 288 | 1 | 1 | 1 | 1 | 2 | Tribal | GW | Y | N | N | 116 | Y | SENECA NATION OF INDIANS | Theresa Lay | No data | No data | No data | No data | No data | SENECA NATION HEALTH DEPT | PO BOX 231 | SALAMANCA | 14779 | US | NY | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 13 | 2026-10-09 | No data | NY | No data | No data | 020000005 | SAINT REGIS MOHAWK TRIBE | Y | 02 | 02 | No data | No data | A | No data | CWS | No data | No data | SW | No data | N | 5500 | 1 | 2 | 1 | 3 | 5 | Tribal | SW | Y | N | N | 1200 | Y | SAINT REGIS MOHAWK TRIBE | Colleen Thomas | colleen.thomas@srmt-nsn.gov | 5183584205 | No data | No data | No data | 71 Margaret Terrance Memorial Way | No data | Akwesasne | 13655 | US | NY | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 14 | 2026-10-09 | No data | NY | No data | No data | 020000006 | THOMAS INDIAN SCHOOL | N | 02 | 02 | No data | No data | I | 1995-12-01 00:00:00 | CWS | No data | No data | GW | No data | N | 280 | 1 | 1 | 1 | 1 | 2 | Tribal | GW | N | N | N | 70 | Y | No data | THOMAS INDIAN SCHOOL | No data | 716-532-5862 | No data | No data | No data | SENECA NATION OF INDIANS | P.O. BOX 231 | SALAMANCA | 14779 | US | NY | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 15 | 2026-10-09 | No data | NY | No data | No data | 020000007 | HIGHBANKS CAMPGROUND | Y | 02 | 02 | No data | No data | A | No data | NTNCWS | No data | No data | GW | No data | N | 200 | 1 | 1 | 1 | 1 | 2 | Tribal | GW | Y | N | N | 90 | Y | No data | David Bova | No data | No data | No data | No data | No data | PO BOX 231 | No data | SALAMANCA | 14779 | US | NY | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 16 | 2026-10-09 | No data | NY | No data | No data | 020000008 | CATTARAUGUS CWS | Y | 02 | 02 | No data | No data | A | No data | CWS | No data | No data | SW | No data | N | 4999 | 1 | 2 | 1 | 3 | 5 | Tribal | SWP | Y | N | N | 1221 | Y | SENECA NATION OF INDIANS | Theresa Lay | No data | No data | No data | No data | No data | SENECA NATION HEALTH DEPT | PO BOX 231 | SALAMANCA | 14779 | US | NY | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 17 | 2026-10-09 | No data | No data | No data | No data | 020000009 | HIGHBANKS CAMPGROUND | N | 02 | 02 | No data | No data | I | 1995-12-01 00:00:00 | CWS | No data | No data | GW | No data | N | 600 | 1 | 1 | 1 | 2 | 3 | Tribal | GW | N | N | N | 1 | Y | No data | HIGHBANKS CAMPGROUND | No data | No data | No data | No data | No data | No data | No data | No data | No data | US | No data | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 18 | 2026-10-09 | No data | No data | No data | No data | 020000010 | HIGHBANKS CAMPGROUND | N | 02 | 02 | No data | No data | I | 1995-12-01 00:00:00 | TNCWS | No data | No data | GW | No data | P | 200 | 1 | 1 | 1 | 1 | 2 | Tribal | GW | N | N | N | 1 | Y | No data | HIGHBANKS CAMPGROUND | No data | No data | No data | No data | No data | No data | No data | No data | No data | US | No data | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 19 | 2026-10-09 | No data | NY | No data | No data | 020000012 | ONONDAGA NATION WS | Y | 02 | 02 | No data | No data | A | No data | CWS | No data | No data | GW | No data | N | 1200 | 1 | 1 | 1 | 2 | 4 | Tribal | GW | Y | N | N | 250 | Y | ONONDAGA NATION | Irving Powless | No data | 3154924210 | No data | No data | No data | BOX 319B | No data | NEDROW | 13120 | US | NY | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 20 | 2026-10-09 | No data | NY | No data | No data | 020000013 | ISTAS RESTAURANT | N | 02 | 02 | No data | No data | I | 2005-09-30 00:00:00 | TNCWS | No data | No data | GW | No data | P | 75 | 1 | 1 | 1 | 1 | 1 | Tribal | GW | N | N | N | 1 | Y | No data | ST. REGIS MOHAWK TRIBE | No data | No data | No data | No data | No data | ST. REGIS MOHAWK TRIBE | BOX 8A, COMMUNITY BUILDING | HOGANSBURG | 13655 | US | NY | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 21 | 2026-10-09 | No data | NY | No data | No data | 020000014 | WOLFCLAN TRUCKSTOP | N | 02 | 02 | No data | No data | I | 2005-09-30 00:00:00 | TNCWS | No data | No data | GW | No data | P | 75 | 1 | 1 | 1 | 1 | 1 | Tribal | GW | N | N | N | 1 | Y | No data | ST. REGIS MOHAWK TRIBE | No data | No data | No data | No data | No data | ST. REGIS MOHAWK TRIBE | BOX 8A, COMMUNITY BUILDING | HOGANSBURG | 13655 | US | NY | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 22 | 2026-10-09 | No data | NY | No data | No data | 020000015 | TUSCARORA NATION SCHOOL | Y | 02 | 02 | No data | No data | A | No data | NTNCWS | No data | No data | GW | No data | N | 175 | 1 | 1 | 1 | 1 | 2 | Tribal | GW | Y | N | Y | 1 | Y | TUSCARORA NATION | TUSCARORA Nation | No data | No data | No data | No data | No data | PO BOX 309 | No data | SANBORN | 14132 | US | NY | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 23 | 2026-10-09 | No data | NY | No data | No data | 020000016 | SULLIVAN HOLLOW | Y | 02 | 02 | No data | No data | A | No data | CWS | No data | No data | GW | No data | N | 64 | 1 | 1 | 1 | 1 | 1 | Tribal | GW | Y | N | N | 20 | Y | SENECA NATION OF INDIANS | Theresa Lay | No data | No data | No data | No data | No data | SENECA NATION HEALTH DEPT | PO BOX 231 | SALAMANCA | 14779 | US | NY | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 24 | 2026-10-09 | No data | NY | No data | No data | 020010464 | BOB HOAG | N | 02 | 02 | No data | No data | I | 1986-09-01 00:00:00 | CWS | No data | No data | GW | No data | P | 28 | 1 | 1 | 1 | 1 | 1 | Tribal | GW | N | N | N | 7 | Y | No data | BOB HOAG | No data | 716-945-1174 | No data | No data | No data | No data | 464 FAIR OAK ROAD | SALAMANCA | 14779 | US | NY | No data | No data | N | No data | 2026-10-09 04:37:18 |
| 25 | 2026-10-09 | No data | NY | No data | No data | 020011102 | SHELTON TRAILER PARK | Y | 02 | 02 | No data | No data | A | No data | CWS | No data | No data | GW | No data | N | 40 | 1 | 1 | 1 | 1 | 1 | Tribal | GW | N | N | N | 20 | U | No data | David Bova | No data | No data | No data | No data | No data | PO BOX 231 | No data | SALAMANCA | 14779 | US | NY | No data | No data | N | No data | 2026-10-09 04:37:18 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing