IRCA Historical Data: Water Quality Risk Index for San Pedro de los Milagros, 2011-2023

Historical records of the Water Quality Risk Index for Human Consumption (IRCA) for the municipality of San Pedro de los Milagros, Colombia, from 2011 to 2023. The data includes both rural villages with aqueducts and the urban zone, detailing risk levels and water suitability for human consumption. It was published on the Colombian open data portal www.datos.gov.co to promote citizen oversight and informed decision-making for water service improvement.

Use Cases

• Classify water as APTA PARA CONSUMO HUMANO (fit for human consumption) based on % IRCA ACUMULADO and NIVEL DE RIESGO using decision trees.
• Analyze temporal trends in water quality risk (% IRCA ACUMULADO) by AÑO and LOCALIDAD/VEREDA for longitudinal studies.
• Compare risk levels (NIVEL DE RIESGO) and service providers (PRESTADOR DEL SERVICIO) across different localities using the FECHA DE CONSULTA for time-sliced analysis.

Strengths

• Data covers a 13-year time range from 2011 to 2023.
• Includes granular location data distinguishing between urban zones and specific rural villages (LOCALIDAD/VEREDA).
• Provides a direct metric for human consumption suitability (APTA PARA CONSUMO HUMANO) and a cumulative risk percentage (% IRCA ACUMULADO).

Limitations

• Row count is unknown, which may limit suitability assessment.
• Description metadata is limited; actual data quality requires manual inspection after download.

Provenance

Source

www.datos.gov.co (Colombian open data portal).

Collection Method

Likely collected through municipal water quality monitoring programs.

Time Range

2011 to 2023.

Freshness

Last updated 2026-05-18 17:53:03; freshness should be verified.

Geography

Municipality of San Pedro de los Milagros, Colombia, including urban zones and rural villages (veredas).