Lead 90th percentile measurements for public water systems across Michigan counties, as reported by data.michigan.gov. The dataset tracks monitoring periods and upcoming sampling due dates for each supply system. It was last updated in March 2026.
Use Cases
- Identify high-risk counties by analyzing the 'Lead 90th Percentile (ppb)' column across 'County' and 'System Name'.
- Schedule regulatory inspections by filtering systems where 'Sampling Next Due' dates are approaching.
- Assess temporal trends in water safety by comparing 'Lead 90th Percentile (ppb)' values across different 'Last Monitoring Period End' dates.
- Estimate population exposure by correlating 'Lead 90th Percentile (ppb)' with the 'Population' served by each 'Public Water Supply ID'.
Strengths
- Includes key regulatory metric 'Lead 90th Percentile (ppb)' for risk assessment.
- Provides temporal context with 'Last Monitoring Period End' and future 'Sampling Next Due' dates.
- Covers multiple jurisdictions with 'County' and 'System Name' identifiers.
Limitations
- Unknown total row count and sample size for statistical reliability.
- Data completeness for columns like 'Includes 5th liter?' is unclear.
- Geographic scope is limited to the state of Michigan.
Provenance
- Source
- data.michigan.gov
- Collection Method
- null
- Time Range
- null
- Freshness
- Last updated March 2026.
- Geography
- Michigan, United States