Water Quality Risk Index (IRCA) for Urban Aqueducts in Norte de Santander, Colombia

Data from 40 municipalities in Norte de Santander, Colombia, reported to the Departmental Health Institute and the Secretariat for Drinking Water and Basic Sanitation. The dataset contains the Water Quality Risk Index (IRCA) for public utility companies and cooperative associations. It was last updated on 2026-05-18.

Use Cases

• Classify NIVEL DE RIESGO (risk level) using INDICE DE RIESGO POR CALIDAD DEL AGUA (risk index) for regulatory oversight.
• Analyze temporal trends in water quality by aggregating INDICE DE RIESGO POR CALIDAD DEL AGUA across MUNICIPIO (municipality) and FECHA DE TOMA DE MUESTRA (sample date).
• Map service provider performance by joining NOMBRE DE EMPRESA PRESTADORA (provider name) with MUNICIPIO and CÓDIGO DANE (municipality code).

Strengths

• Covers 40 municipalities, providing a departmental-scale view.
• Includes a standardized risk index (INDICE DE RIESGO POR CALIDAD DEL AGUA) for consistent measurement.
• Contains key identifiers like CÓDIGO DANE for linking with other Colombian geographic datasets.

Limitations

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

Provenance

Source

Reported to the Instituto Departamental de Salud and the Secretaría de Agua Potable y Saneamiento Básico, published via www.datos.gov.co.

Collection Method

Likely collected from mandatory reports by public service providers.

Freshness

Last updated 2026-05-18 18:45:01; freshness should be verified.

Geography

Norte de Santander department, Colombia (40 municipalities).