King County Streams Water Quality Index: Parameter and Annual Scores

WQI scores for water quality monitoring data collected through King County's ambient stream water quality monitoring program. The dataset includes parameter-specific, monthly, and annual scores for streams, with columns suggesting geospatial and temporal dimensions. Data is available in multiple formats and is hosted on multiple government data platforms.

Use Cases

• Analyzing water quality trends over time using WaterYear and Month columns
• Comparing WQI scores across different StreamName and SiteName locations
• Mapping water quality data spatially using lat, lng, and GeoLocation columns
• Investigating specific pollutant groups using the ParameterGroup column

Strengths

• Contains a specific Water Quality Index (WQI) metric for standardized assessment
• Available on multiple government platforms (Socrata, Data.gov), indicating official provenance and cross-checking
• Includes geospatial coordinates (lat, lng) enabling map-based analysis

Limitations

• Key metadata conflicts: last updated date differs between sources (2026-05-28 vs 2026-03-22)
• Critical metadata missing: total row count, file size, license, and author are unknown
• Column list is incomplete for the Data.gov source, limiting full understanding of the schema

Provenance

Source

King County's ambient stream water quality monitoring program

Collection Method

Collected through the County's ambient stream water quality monitoring program

Time Range

Implied by WaterYear and Month columns, but specific range not stated

Freshness

2026-05-28 04:33:10

Geography

Streams in King County, as indicated by StreamName and SiteName columns