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
Service areas Sample of 25 rows out of about 419,776 · 14 columns
idvintagecounty_fipsstatelatlonpwsidprimacy_agency_codeepa_regionpws_activity_codepws_type_codeservice_area_type_codeis_primary_service_area_codeloaded_at
12026-10-09No dataNo dataNo dataNo data0101060010101ACWSRAY2026-10-09 05:00:46
22026-10-09No dataNo dataNo dataNo data0101090010101INTNCWSHMY2026-10-09 05:00:46
32026-10-09No dataNo dataNo dataNo data0101090050101ACWSRAY2026-10-09 05:00:46
42026-10-09No dataNo dataNo dataNo data0103070010101ACWSRAY2026-10-09 05:00:46
52026-10-09No dataNo dataNo dataNo data0105020010101ITNCWSOANo data2026-10-09 05:00:46
62026-10-09No dataNo dataNo dataNo data0105020020101ANTNCWSONY2026-10-09 05:00:46
72026-10-09No dataNo dataNo dataNo data0105020030101ANTNCWSDCY2026-10-09 05:00:46
82026-10-09No dataNo dataNo dataNo data0105020040101ITNCWSMFY2026-10-09 05:00:46
92026-10-09No dataNo dataNo dataNo data0200000010202ACWSDCY2026-10-09 05:00:46
102026-10-09No dataNo dataNo dataNo data0200000020202ICWSRAY2026-10-09 05:00:46
112026-10-09No dataNo dataNo dataNo data0200000030202ITNCWSOANo data2026-10-09 05:00:46
122026-10-09No dataNo dataNo dataNo data0200000030202ITNCWSRANo data2026-10-09 05:00:46
132026-10-09No dataNo dataNo dataNo data0200000040202ACWSRAY2026-10-09 05:00:46
142026-10-09No dataNo dataNo dataNo data0200000050202ACWSRAY2026-10-09 05:00:46
152026-10-09No dataNo dataNo dataNo data0200000060202ICWSPANo data2026-10-09 05:00:46
162026-10-09No dataNo dataNo dataNo data0200000060202ICWSSCNo data2026-10-09 05:00:46
172026-10-09No dataNo dataNo dataNo data0200000070202ANTNCWSOTY2026-10-09 05:00:46
182026-10-09No dataNo dataNo dataNo data0200000080202ACWSRAY2026-10-09 05:00:46
192026-10-09No dataNo dataNo dataNo data0200000120202ACWSRAY2026-10-09 05:00:46
202026-10-09No dataNo dataNo dataNo data0200000130202ITNCWSRSY2026-10-09 05:00:46
212026-10-09No dataNo dataNo dataNo data0200000140202ITNCWSRSY2026-10-09 05:00:46
222026-10-09No dataNo dataNo dataNo data0200000150202ANTNCWSSCY2026-10-09 05:00:46
232026-10-09No dataNo dataNo dataNo data0200000160202ACWSRAY2026-10-09 05:00:46
242026-10-09No dataNo dataNo dataNo data0200104640202ICWSMHNo data2026-10-09 05:00:46
252026-10-09No dataNo dataNo dataNo data0200111020202ACWSRAY2026-10-09 05:00: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?