City water profile
Compare local ZIP estimates, evidence quality, associated public systems, and compliance history for Columbia, Missouri.
Median indexed hardness
339PPM
5 indexed ZIPs
Range 328–347 PPM
City summary
Columbia has 5 published ZIP profiles across Boone County. The indexed median is 339 PPM, compared with 236 PPM across Missouri.
Among the 504 Missouricities with an indexed median, Columbia ranks #92from highest to lowest. Across all 556 state ZIP profiles, available estimates run from 38.3to 483 PPM.
The 328–347 PPM range shows how much the available ZIP estimates vary within the city label.
Hardness distribution
5 of 5 ZIP profiles have a hardness estimate. Bars count ZIP profiles, not households or laboratory samples.
Evidence quality
Confidence labels
Observation window: Apr 11, 2016 to Apr 9, 2026.
ZIP directory
Open a ZIP for site-level provenance and measurements.
ZIP code
328 PPM
View full ZIP evidence →
ZIP code
347 PPM
View full ZIP evidence →
ZIP code
328 PPM
View full ZIP evidence →
ZIP code
339 PPM
View full ZIP evidence →
ZIP code
347 PPM
View full ZIP evidence →
Public water systems
PWSID MO3010181
A municipal system, in-state city, and served county all agree with this Census ZCTA.
PWSID MO3069001
The system names this served city; Census place overlap links the city to this ZCTA.
PWSID MO3024055
The system names this served city; Census place overlap links the city to this ZCTA.
PWSID MO3024058
The system names this served city; Census place overlap links the city to this ZCTA.
PWSID MO3036153
The system names this served city; Census place overlap links the city to this ZCTA.
PWSID MO3048033
The system names this served city; Census place overlap links the city to this ZCTA.
Compliance history
No active health-based violation appears among the associated systems in the represented EPA reporting quarter. This does not mean every contaminant was tested at every tap.
| Record | System | Period | Status |
|---|---|---|---|
| Revised Total Coliform Rule | MO3024058 | Aug 1, 2025 | Resolved |
| LEAD AND COPPER RULE REVISIONS | MO3010181 | Jul 2, 2025 | Unaddressed |
| LEAD AND COPPER RULE REVISIONS | MO3024055 | Jul 2, 2025 | Unaddressed |
| LEAD AND COPPER RULE REVISIONS | MO3048033 | Oct 17, 2024 | Resolved |
| Lead and Copper Rule | MO3048033 | Oct 1, 2024 | Unaddressed |
| Revised Total Coliform Rule | MO3024058 | Sep 1, 2024 | Resolved |
| Lead and Copper Rule | MO3010181 | Jul 1, 2022 | Resolved |
| Revised Total Coliform Rule | MO3048033 | Oct 1, 2021 | Resolved |
| E. COLI | MO3024058 | Sep 1, 2021 | Resolved |
| Revised Total Coliform Rule | MO3048033 | Jan 1, 2021 | Resolved |
Practical next steps
Continue comparing
Questions people ask
The indexed city median is 339 PPM. Open the ZIP report to verify the distance and confidence behind that estimate.
Compliance history is utility-wide and cannot guarantee conditions at every tap. Check current notices and test when address-specific evidence is needed.
Choose treatment only after confirming the problem at the property. A softener targets hardness; contaminant treatment requires a matching, verified performance claim.