Percentage of boil water advisories grouped by the reason for issuance, Canada – English (2.68 kB) (English, CSV)

Percentage of boil water advisories grouped by the reason for issuance, Canada – English (2.68 kB): English CSV file you can open as a table, filter, chart and export up to 10,000 rows. From Environment and Climate Change Canada, updated Feb 2025.

Format
CSV
Access
Table on demand (prepared when opened)
Publisher-reported update
2025-02-26

The Canadian Environmental Sustainability Indicators (CESI) program provides data and information to track Canada's performance on key environmental sustainability issues. The Boil water advisories indicators provide an overview of of the main reasons why boil water advisories are issued in Canada and also report on the relationship between community size and the percentage of boil water advisories issued each year. Drinking water advisories are public health protection messages issued by public health or regulatory authorities. The advisories inform those impacted about actions they should take to protect themselves from real or potential health risks related to their drinking water supply. Information is provided to Canadians in a number of formats including: static and interactive maps, charts and graphs, HTML and CSV data tables and downloadable reports. See the supplementary documentation for the data sources and details on how the data were collected and how the indicator was calculated. Canadian Environmental Sustainability Indicators: https://www.canada.ca/environmental-indicators

Access original file

Data overview

Formats
CSV
File languages
English
Available actions
Explore table (prepared automatically) · Access original file

Sample rows

The first 10 rows, as CanQuery read them from the start of the publisher's file on 2026-11-14.

Reason for boil water advisoryGeneral category of reason for boil water advisory2010 (percentage of boil water advisories)2011 (percentage of boil water advisories)2012 (percentage of boil water advisories)2013 (percentage of boil water advisories)2014 (percentage of boil water advisories)2015 (percentage of boil water advisories)2016 (percentage of boil water advisories)2017 (percentage of boil water advisories)2018 (percentage of boil water advisories)2019 (percentage of boil water advisories)2020 (percentage of boil water advisories)2021 (percentage of boil water advisories)2022 (percentage of boil water advisories)2023 (percentage of boil water advisories)
E. coli detected in drinking water systemWater quality, E. coli8.15.54.975.35.43.93.93.92.72.223.51.9
Unacceptable turbidity or particle countsWater quality, other microbiological parameters8.18.36.84.34.4543.63.23.33.72.51.93
Total coliforms detected in drinking waterWater quality, other microbiological parameters19.99.91112.79.111.711.297.27.35.45.99.17.8
Cross connection, backflow suspected or confirmedEquipment and process0.200.31.20.20.20.20.40.10.100.10.10
Insufficient quantityEquipment and process0.81.41.11.60.80.70.50.80.70.30.10.80.70.9
Significant deterioration of source water qualityEquipment and process1.240.322.20.51.40.50.90.20.30.40.30.2
Suspected contaminationEquipment and process15.39.39.121.11.71.21.11.40.60.40.50.81.1
No applicable water quality reasonEquipment and process10.914.814.820.717.718.819.12016.217.518.418.416.917.7
Water main breaks or pressure lossesEquipment and process35.546.851.748.559.25658.560.766.46869.569.566.767.5

Official sources and licences

Related open data