EPM Water Service Tariffs by Municipality, Consumption, and Socioeconomic Stratum

EPM's reference costs for setting residential water service tariffs, updated semiannually according to tariff changes and the Consumer Price Index. The dataset includes fixed charges, consumption rates for basic, complementary, and luxury tiers, and reconnection fees, organized by municipality and socioeconomic stratum. It was last updated on May 18, 2026, via the Colombian open data portal www.datos.gov.co.

Use Cases

• Modeling total water bill costs using CargoFijo, Consumo Basico, Consumo Complementario, and Consumo Suntuario for different Estrato groups.
• Analyzing geographic price variation by comparing tariff structures across different Municipio entries.
• Forecasting utility revenue or consumer expenditure by simulating price changes over time using Mes and Año columns.
• Assessing the financial impact of service interruptions by analyzing Corte, Suspención, and Reconexión fee structures.

Strengths

• Contains detailed breakdown of water tariffs including fixed and variable consumption charges across three tiers.
• Data is updated on a semiannual basis, with the last update recorded in May 2026.
• Includes socioeconomic (Estrato) and geographic (Municipio) dimensions for stratified analysis.

Limitations

• Row count and total data size are unknown, which may limit suitability assessment for large-scale modeling.
• Description metadata is limited; actual data quality, such as completeness of records for all municipalities, requires manual inspection after download.

Provenance

Source

www.datos.gov.co (Colombian open data portal), likely from Empresas Públicas de Medellín (EPM).

Collection Method

Reference costs set by public utility companies for tariff determination.

Time Range

Data is current as of the last update in March 2025, with records organized by Mes and Año.

Freshness

Last updated 2026-05-18 18:41:46; updated semiannually.

Geography

Coverage likely includes municipalities served by EPM's Aguas Nacionales in Colombia, as indicated by the Municipio column.