Colombia/ co-ins-calidad-agua

Drinking water: urban and rural health-risk index

Annual IRCA by municipality and department, with separate total, urban and rural indices and risk classifications. Published history starts in 2007.

Oct 8, 2026DQ pass

Open in the editor

Initial chart

Drinking-water risk: department IRCA · 0–100 index, latest cutoff

Annual IRCA by municipality and department, with separate total, urban and rural indices and risk classifications. Published history starts in 2007.

Quick read

Vaupés has the highest value, 51.4; followed by Chocó (44.8) and Guainía (32.8).

Preview

IRCA is a 0–100 risk index, not the share of people without water. ND is unknown. Department totals and municipalities are alternative levels and cannot be summed.

Search records

46,597 records

Year	Department	Geography	Geography level	Indicator	Value	Category	Indicator group
2007	Antioquia	Medellín	municipality	IRCA Total	2.3	Sin riesgo	Riesgo de calidad del agua
2007	Antioquia	Medellín	municipality	IRCA Urbano	0.2	Sin riesgo	Riesgo de calidad del agua
2007	Antioquia	Medellín	municipality	IRCA Rural	3.9	Sin riesgo	Riesgo de calidad del agua
2008	Antioquia	Medellín	municipality	IRCA Total	1.8	Sin riesgo	Riesgo de calidad del agua
2008	Antioquia	Medellín	municipality	IRCA Urbano	0.1	Sin riesgo	Riesgo de calidad del agua
2008	Antioquia	Medellín	municipality	IRCA Rural	4	Sin riesgo	Riesgo de calidad del agua
2009	Antioquia	Medellín	municipality	IRCA Total	1.3	Sin riesgo	Riesgo de calidad del agua
2009	Antioquia	Medellín	municipality	IRCA Urbano	0.4	Sin riesgo	Riesgo de calidad del agua
2009	Antioquia	Medellín	municipality	IRCA Rural	2.7	Sin riesgo	Riesgo de calidad del agua
2010	Antioquia	Medellín	municipality	IRCA Total	1.4	Sin riesgo	Riesgo de calidad del agua
2010	Antioquia	Medellín	municipality	IRCA Urbano	0.5	Sin riesgo	Riesgo de calidad del agua
2010	Antioquia	Medellín	municipality	IRCA Rural	2.6	Sin riesgo	Riesgo de calidad del agua
2011	Antioquia	Medellín	municipality	IRCA Total	1.9	Sin riesgo	Riesgo de calidad del agua
2011	Antioquia	Medellín	municipality	IRCA Urbano	0.5	Sin riesgo	Riesgo de calidad del agua
2011	Antioquia	Medellín	municipality	IRCA Rural	3.6	Sin riesgo	Riesgo de calidad del agua
2012	Antioquia	Medellín	municipality	IRCA Total	0.4	Sin riesgo	Riesgo de calidad del agua
2012	Antioquia	Medellín	municipality	IRCA Urbano	0	Sin riesgo	Riesgo de calidad del agua
2012	Antioquia	Medellín	municipality	IRCA Rural	0.8	Sin riesgo	Riesgo de calidad del agua
2013	Antioquia	Medellín	municipality	IRCA Total	0	Sin riesgo	Riesgo de calidad del agua
2013	Antioquia	Medellín	municipality	IRCA Rural	0	Sin riesgo	Riesgo de calidad del agua
2014	Antioquia	Medellín	municipality	IRCA Total	1.8	Sin riesgo	Riesgo de calidad del agua
2014	Antioquia	Medellín	municipality	IRCA Urbano	1	Sin riesgo	Riesgo de calidad del agua
2014	Antioquia	Medellín	municipality	IRCA Rural	2.9	Sin riesgo	Riesgo de calidad del agua
2015	Antioquia	Medellín	municipality	IRCA Total	1.4	Sin riesgo	Riesgo de calidad del agua
2015	Antioquia	Medellín	municipality	IRCA Urbano	0.5	Sin riesgo	Riesgo de calidad del agua

1 / 1864

Schema

Field	Type	Description
Country`country`	Text
Dataset`dataset_id`	Text
Record identifier`record_id`	Text
Period`period`	Date
Year`year`	Integer	May be empty.
Month`month`	Integer	May be empty.
Frequency`frequency`	Text	daily \| weekly \| monthly \| quarterly \| semiannual \| annual \| biennial \| edition
Indicator key`indicator_key`	Text
Indicator`indicator_name`	Text
Indicator group`indicator_group`	Text	May be empty.
Indicator direction`indicator_direction`	Text	higher_is_better \| higher_is_worse where the source direction has been explicitly reviewed.
Geography`geography_name`	Text	May be empty.
Geography level`geography_level`	Text	May be empty.
Sex`sex`	Text	Source-published sex dimension where available; Total is the aggregate.
Age`age`	Text	Source-published age dimension where available; Total is the aggregate.
Source-estimated`source_estimated`	Boolean	True when the source publishes a modeled or fractional disaggregation rather than a direct integer count.
Published rank`source_rank`	Integer	Source-published rank retained for context, not promoted as a trend measure.
Source edition`source_edition`	Text	Edition identifier published by the source.
Source action area`source_action_area`	Text	Source-published thematic or action area.
Source indicator identifier`source_indicator_id`	Text	Stable indicator identifier published by the source.
Publisher`publisher`	Text
Value`value`	Number	Published value after applying `unit_scale` (e.g. millions → units).
Unit`unit`	Text	Currency code, "index", "percent", "ratio" or a physical unit.
Published scale`unit_scale`	Text	Scale the source published in: units \| thousands \| millions \| billions.
Published value before conversion`source_value_text`	Text	Published numeric value before applying unit scale.
Published unit`source_unit`	Text	Original unit label, including index bases and currency scale.
Source link`source_url`	Text	May be empty.
Geography code`geography_code`	Text	May be empty.
Category`category`	Text	May be empty.
Breakdown code`category_key`	Text	Stable source dimension/category identities, separate from display labels.
Published dimensions`source_dimensions`	Text	Published dimension names and category labels, retained together for provenance.
Project identifier`project_id`	Text	May be empty.
Project`project_name`	Text	May be empty.
Agreement number`agreement_id`	Text	May be empty.
Published owner`owner_name`	Text	May be empty.
Status`status`	Text	May be empty.
Status detail`substatus`	Text	May be empty.
District`district`	Text	May be empty.
Locality`locality`	Text	May be empty.
Addressed hazard`hazard`	Text	May be empty.
Record cutoff date`source_cutoff`	Date	May be empty.
Snapshot date`snapshot_date`	Date	May be empty.
Record period basis`period_basis`	Text	Reporting month, fiscal year, row cutoff or publication date; these are different time concepts.
Start date`start_date`	Date	May be empty.
End date`end_date`	Date	May be empty.
Planned end date`planned_end_date`	Date	May be empty.
Published event date`source_event_date`	Date	May be empty.
Department`department`	Text	May be empty.
Province`province`	Text	May be empty.
Facility`facility_name`	Text	May be empty.
Facility ID`facility_id`	Text	May be empty.
Company`company_name`	Text	May be empty.
Company identifier`company_identifier`	Text	May be empty.
Economic activity`activity`	Text	May be empty.
Reported standard`regulatory_basis`	Text	May be empty.
Published period`source_period_label`	Text	May be empty.
Facility role`waste_role`	Text	May be empty.
Declared or estimated`waste_data_type`	Text	May be empty.
Waste treatment`waste_treatment`	Text	May be empty.
Destination facility`destination_facility`	Text	May be empty.
Destination company`destination_company`	Text	May be empty.
Destination municipality`destination_municipality`	Text	May be empty.
Estimated population (not additive)`reported_population`	Integer	Published stock denominator, repeated by week; never sum as population.
Alternative source estimate (not additive)`source_estimate_value`	Number	Alternative source estimate; do not add to the validated main measure.
Published record data and context`source_context`	Text	Original published environmental or statistical attributes.
Preliminary`preliminary`	Boolean	May be empty.
Source file`source_file`	Text