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
Violations
Sample of 25 rows out of about 1,914,919
· 41 columns
| id | vintage | county_fips | state | lat | lon | pwsid | violation_id | facility_id | population_served_count | npm_candidate | pws_activity_code | pws_deactivation_date | primary_source_code | pop_cat_5_code | primacy_agency_code | epa_region | pws_type_code | violation_code | violation_category_code | is_health_based_ind | contaminant_code | compliance_status_code | viol_measure | unit_of_measure | state_mcl | is_major_viol_ind | severity_ind_cnt | compl_per_begin_date | compl_per_end_date | latest_enforcement_id | rtc_enforcement_id | rtc_date | public_notification_tier | originator_code | sample_result_id | corrective_action_id | rule_code | rule_group_code | rule_family_code | loaded_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 0106001022950102018 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 02 | MCL | Y | 2950 | R | 0.083900000 | MG/L | No data | No data | 3 | 2018-10-01 00:00:00 | 2018-12-31 00:00:00 | 0106001OX02121923091 | 0106001OX02121923091 | 2019-02-12 00:00:00 | 2 | R | No data | No data | 220 | 200 | 220 | 2026-10-09 04:50:16 |
| 2 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600102295072018 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 02 | MCL | Y | 2950 | R | 0.088000000 | MG/L | No data | No data | 3 | 2018-07-01 00:00:00 | 2018-09-30 00:00:00 | 0106001OX02121923090 | 0106001OX02121923090 | 2019-02-12 00:00:00 | 2 | R | No data | No data | 220 | 200 | 220 | 2026-10-09 04:50:16 |
| 3 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103200512016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2005 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722926 | 0106001OX08031722926 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 4 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103201012016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2010 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722914 | 0106001OX08031722914 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 5 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103201512016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2015 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722915 | 0106001OX08031722915 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 6 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103202012016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2020 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722918 | 0106001OX08031722918 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 7 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103203112016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2031 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722920 | 0106001OX08031722920 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 8 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103203212016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2032 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722924 | 0106001OX08031722924 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 9 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103203312016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2033 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722925 | 0106001OX08031722925 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 10 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103203412016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2034 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722927 | 0106001OX08031722927 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 11 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103203512016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2035 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722921 | 0106001OX08031722921 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 12 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103203612016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2036 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722930 | 0106001OX08031722930 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 13 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103203712016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2037 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722932 | 0106001OX08031722932 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 14 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103203912016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2039 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722922 | 0106001OX08031722922 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 15 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103204012016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2040 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722931 | 0106001OX08031722931 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 16 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103204112016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2041 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722923 | 0106001OX08031722923 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 17 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103204212016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2042 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722929 | 0106001OX08031722929 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 18 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103204612016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2046 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722908 | 0106001OX08031722908 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 19 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103205012016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2050 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722907 | 0106001OX08031722907 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 20 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103205112016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2051 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722906 | 0106001OX08031722906 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 21 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103206512016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2065 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722912 | 0106001OX08031722912 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 22 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103206712016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2067 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722913 | 0106001OX08031722913 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 23 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103210512016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2105 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722905 | 0106001OX08031722905 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 24 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103211012016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2110 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722904 | 0106001OX08031722904 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
| 25 | 2026-10-09 | No data | No data | No data | No data | 010106001 | 010600103227412016 | No data | 22171 | N | A | No data | GU | 4 | 01 | 01 | CWS | 03 | MR | N | 2274 | R | No data | No data | No data | Y | No data | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 0106001OX08031722928 | 0106001OX08031722928 | 2017-08-03 00:00:00 | 3 | R | No data | No data | 320 | 300 | 320 | 2026-10-09 04:50:16 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing