water_violations: 19
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19 | CA0202552 | PG&E MIDDLE BLUE LAKES C.G. | CA | Alpine | 25 | 2014 | 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 |