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
Enforcement
Sample of 25 rows out of about 2,243,338
· 13 columns
| id | vintage | county_fips | state | lat | lon | pwsid | enforcement_id | originator_code | enforcement_date | enforcement_action_type_code | enforcement_comment_text | loaded_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001FG09262523399 | R | 2025-09-26 00:00:00 | EFG | No data | 2026-10-09 04:59:00 |
| 2 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001FG09262523400 | R | 2025-09-26 00:00:00 | EFG | No data | 2026-10-09 04:59:00 |
| 3 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722841 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 4 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722842 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 5 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722843 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 6 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722844 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 7 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722845 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 8 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722846 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 9 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722847 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 10 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722848 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 11 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722849 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 12 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722850 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 13 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722851 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 14 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722852 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 15 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722853 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 16 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722854 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 17 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722855 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 18 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722856 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 19 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722857 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 20 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722858 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 21 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722860 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 22 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722861 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 23 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722862 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 24 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722863 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
| 25 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001IA07131722864 | R | 2017-07-13 00:00:00 | EIA | NOV sent to the tribe. Requires them to take an additional sample and acknowledges the receipt of their PN | 2026-10-09 04:59:00 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing