US Water Quality Contaminant Standards - Free Download
201 records of US water systems where measured contaminant levels exceed federal or state maximum contaminant limits (MCLs), with contaminant type, measured level, and regulatory thresholds. Contains 201 records. Download in Excel, CSV, PDF formats.
📥 Free Download
💡 Key Takeaways
- Contains 201 records / 15 fields
- Available for free download in Excel, CSV, and PDF formats
- Data sourced from: https://github.com/artakulov/us-water-quality-data
📋 ข้อมูลทั้งหมด
Showing 20
of 201
⚠️ Showing first 20 of 201 records. Download the file for complete data.
| Pwsid | System Name | State | Contaminant | Contaminant Id | Measured | Measured Raw | Measured Unit | Federal Mcl | State Mcl | Unit | Passes Federal | Fails State | Notes | Zip Code Count |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CA4510005 | City of Redding Water Utility | CA | Manganese | manganese | 128000 | 128 | ppm | 50 | ppb | true | true | CA enforces secondary standard as primary. Federal 50 ppb is non-enforceable. | 5 | |
| CA4510005 | City of Redding Water Utility | CA | Manganese (UCMR4) | manganese | 110000 | 110 | ppm | 50 | ppb | true | true | CA enforces secondary standard as primary. Federal 50 ppb is non-enforceable. | 5 | |
| CA3610041 | Fontana Water Company | CA | 1,2,3-Trichloropropane | 123tcp | 690 | 0.69 | ppb | 5 | ppt | true | true | CA MCL 5 ppt (0.005 ppb). No federal MCL. | 5 | |
| CA3310037 | City of Corona | CA | Manganese | manganese | 500 | 500 | ppb | 50 | ppb | true | true | CA enforces secondary standard as primary. Federal 50 ppb is non-enforceable. | 7 | |
| CA3010001 | City of Anaheim Public Utilities | CA | Manganese | manganese | 437 | 437 | ppb | 50 | ppb | true | true | CA enforces secondary standard as primary. Federal 50 ppb is non-enforceable. | 17 | |
| CA3310037 | City of Corona | CA | 1,2,3-Trichloropropane (1,2,3-TCP) | 123tcp | 19 | 0.019 | ppb | 5 | ppt | true | true | CA MCL 5 ppt (0.005 ppb). No federal MCL. | 7 | |
| CA4810008 | City of Vacaville | CA | Hexavalent Chromium | chromium6 | 30 | 30 | ppb | 10 | ppb | true | true | CA adopted Cr-6 MCL of 10 ppb effective Oct 2024. No federal Cr-6 MCL. | 4 | |
| CA1910043 | Glendale Water & Power | CA | Manganese | manganese | 120 | 120 | ppb | 50 | ppb | true | true | CA enforces secondary standard as primary. Federal 50 ppb is non-enforceable. | 14 | |
| CA3310001 | Coachella Valley Water District (CVWD) | CA | Chromium-6 | chromium6 | 23 | 23 | μg/L | 10 | ppb | true | true | CA adopted Cr-6 MCL of 10 ppb effective Oct 2024. No federal Cr-6 MCL. | 4 | |
| CA5010010 | Modesto System (Includes Empire) | CA | Manganese | manganese | 110 | 110 | ppb | 50 | ppb | true | true | CA enforces secondary standard as primary. Federal 50 ppb is non-enforceable. | 10 | |
| CA0710003 | Contra Costa Water District | CA | Manganese | manganese | 101 | 101 | μg/L | 50 | ppb | true | true | CA enforces secondary standard as primary. Federal 50 ppb is non-enforceable. | 8 | |
| CA1010007 | City of Fresno | CA | Manganese | manganese | 92 | 92 | ug/L | 50 | ppb | true | true | CA enforces secondary standard as primary. Federal 50 ppb is non-enforceable. | 58 | |
| CA1010007 | City of Fresno | CA | Manganese (Secondary) | manganese | 92 | 92 | ug/L | 50 | ppb | true | true | CA enforces secondary standard as primary. Federal 50 ppb is non-enforceable. | 58 | |
| CA3310037 | City of Corona | CA | Perchlorate | perchlorate | 9.4 | 9.4 | ppb | 6 | ppb | true | true | CA MCL 6 ppb. No federal MCL. | 7 | |
| CA0110001 | Alameda County Water District | CA | Manganese | manganese | 72 | 72 | ppb | 50 | ppb | true | true | CA enforces secondary standard as primary. Federal 50 ppb is non-enforceable. | 5 | |
| CA4210004 | Goleta Water District | CA | Manganese | manganese | 70 | 70 | ppb | 50 | ppb | true | true | CA enforces secondary standard as primary. Federal 50 ppb is non-enforceable. | 4 | |
| CA4110013 | Daly City Water Quality | CA | Fluoride | fluoride | 2.6 | 2.6 | ppm | 4 | 2 | ppm | true | true | CA primary MCL 2.0 mg/L vs federal primary 4.0 mg/L | 4 |
| CA4310012 | City of Santa Clara | CA | Fluoride | fluoride | 2.6 | 2.6 | ppm | 4 | 2 | ppm | true | true | CA primary MCL 2.0 mg/L vs federal primary 4.0 mg/L | 7 |
| CA1910102 | Palmdale Water District | CA | Chromium (Hexavalent) | chromium6 | 12 | 12 | μg/L | 10 | ppb | true | true | CA adopted Cr-6 MCL of 10 ppb effective Oct 2024. No federal Cr-6 MCL. | 6 | |
| CA3610052 | City of Victorville Water District | CA | Chromium 6 | chromium6 | 12 | 12 | ppb | 10 | ppb | true | true | CA adopted Cr-6 MCL of 10 ppb effective Oct 2024. No federal Cr-6 MCL. | 4 |