water_violations: 22
This data as json
| rowid | muni_id | pwsid | system_name | state | city_served | county_served | population_served | year | violation_count | health_based_count | source_url | data_license | updated_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22 | CA0210001 | LAKE ALPINE WATER COMPANY | CA | Alpine | 625 | 1996 | 1 | 1 | https://data.epa.gov/efservice/VIOLATION/STATE/CA/JSON | US EPA — PUBLIC DOMAIN (safe for CC-BY public dataset + commercial) | 2026-08-01 08:18:24 |