Dataset · Files and open data
Drinking water and sanitation access by country, 2000-2024
Safely managed and basic drinking water, sanitation and handwashing shares for 217 economies, 2000-2024, from the World Bank.
Downloads are included in the $19.85 yearly membership. Sign in
XLSXCSVODSXMLNumbers| Drinking water and sanitation access by country, 2000-2024 | |||||||||||
| Source: World Bank, World Development Indicators (SH.H2O.SMDW.ZS, SH.H2O.BASW.ZS, SH.STA.SMSS.ZS, SH.STA.BASS.ZS, SH.STA.HYGN.ZS; WHO/UNICEF JMP) · Retrieved 2026-10-09 · License: CC BY 4.0 | |||||||||||
| Percent of population. Values are the World Bank's published figures, unmodified. Latest year is 2024 unless a row says otherwise. | |||||||||||
| WORLD: SAFELY MANAGED WATER, % | WORLD: AT LEAST BASIC WATER, % | WORLD: SAFELY MANAGED SANITATION, % | WORLD: HANDWASHING, % | ||||||||
| 73.7 | 91.5 | 58.5 | 78.0 | ||||||||
| 2024, World Bank WLD aggregate | 2024, World Bank WLD aggregate | 2024, World Bank WLD aggregate | 2024, World Bank WLD aggregate | ||||||||
| World trend, 2000 to 2024 (World Bank WLD aggregate) | |||||||||||
| Indicator | 2000 | 2004 | 2008 | 2012 | 2016 | 2020 | 2024 | Change, points | Trend | ||
| Safely managed drinking water | 61.2 | 62.5 | 63.8 | 65.9 | 68.2 | 70.5 | 73.7 | 12.4 | ▁▁▁▁▂▂▂▂▂▃▃▃▄▄▄▅▅▅▆▆▆▆▇▇█ | ||
| At least basic drinking water | 80.6 | 82.6 | 85.2 | 86.9 | 88.5 | 90.0 | 91.5 | 10.8 | ▁▁▂▂▂▃▃▄▄▄▅▅▅▅▆▆▆▆▇▇▇▇███ | ||
| Safely managed sanitation | 31.3 | 34.0 | 38.9 | 44.1 | 49.9 | 55.2 | 58.5 | 27.2 | ▁▁▁▁▂▂▂▃▃▃▄▄▄▅▅▅▆▆▇▇▇▇███ | ||
| At least basic sanitation | 54.8 | 59.6 | 64.3 | 68.9 | 73.8 | 78.3 | 82.2 | 27.4 | ▁▁▂▂▂▃▃▃▃▄▄▄▅▅▅▆▆▆▆▇▇▇███ | ||
| Handwashing with soap and water | 72.5 | 78.0 | ▁▂▃▄▅▆██ | ||||||||
Showing the first 16 of 48 rows and 12 of 41 columns. Cells with formulas show the formula on hover.
| Safely managed drinking water, % of population, 2000-2024 | 0-25 | 25-50 | |||||||||
| Source: World Bank, World Development Indicators (SH.H2O.SMDW.ZS; WHO/UNICEF JMP) · Retrieved 2026-10-09 · License: CC BY 4.0 · Cell colors are fixed value bands computed from the published values when this file was built | |||||||||||
| Country | ISO3 | Region | Income group | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 11.5 | 11.5 | 12.3 | 13.1 | 13.9 | 14.7 | 15.5 | 16.7 |
| Albania | ALB | Europe & Central Asia | Upper middle income | 49.1 | 49.1 | 49.0 | 48.9 | 50.7 | 52.6 | 54.5 | 56.4 |
| Algeria | DZA | Middle East, North Africa, Afghanistan & Pakistan | Upper middle income | 69.5 | 70.0 | 70.5 | 70.9 | 71.4 | 71.8 | 72.3 | 72.7 |
| American Samoa | ASM | East Asia & Pacific | High income | 81.9 | 82.6 | 83.3 | 84.0 | 84.6 | 85.3 | 86.0 | 86.7 |
| Andorra | AND | Europe & Central Asia | High income | 90.6 | 90.6 | 90.6 | 90.6 | 90.6 | 90.6 | 90.6 | 90.6 |
| Angola | AGO | Sub-Saharan Africa | Lower middle income | ||||||||
| Antigua and Barbuda | ATG | Latin America & Caribbean | High income | ||||||||
| Argentina | ARG | Latin America & Caribbean | Upper middle income | ||||||||
| Armenia | ARM | Europe & Central Asia | Upper middle income | 82.7 | 82.7 | 82.8 | 82.9 | 83.0 | 83.0 | 83.1 | 83.2 |
| Aruba | ABW | Latin America & Caribbean | High income | ||||||||
| Australia | AUS | East Asia & Pacific | High income | ||||||||
| Austria | AUT | Europe & Central Asia | High income | 96.9 | 97.0 | 97.2 | 97.3 | 97.5 | 97.6 | 97.8 | 97.9 |
| Azerbaijan | AZE | Europe & Central Asia | Upper middle income | 48.8 | 49.2 | 49.5 | 49.9 | 50.3 | 50.6 | 51.0 | 51.3 |
Showing the first 16 of 220 rows and 12 of 29 columns. Cells with formulas show the formula on hover.
| At least basic drinking water, % of population, 2000-2024 | 0-25 | 25-50 | |||||||||
| Source: World Bank, World Development Indicators (SH.H2O.BASW.ZS; WHO/UNICEF JMP) · Retrieved 2026-10-09 · License: CC BY 4.0 · Cell colors are fixed value bands computed from the published values when this file was built | |||||||||||
| Country | ISO3 | Region | Income group | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 29.7 | 29.8 | 31.8 | 33.9 | 36.0 | 38.1 | 40.2 | 42.4 |
| Albania | ALB | Europe & Central Asia | Upper middle income | 86.4 | 86.9 | 87.5 | 88.0 | 88.5 | 89.0 | 89.5 | 90.0 |
| Algeria | DZA | Middle East, North Africa, Afghanistan & Pakistan | Upper middle income | 89.0 | 89.2 | 89.3 | 89.5 | 89.7 | 89.9 | 90.0 | 90.2 |
| American Samoa | ASM | East Asia & Pacific | High income | 95.0 | 95.3 | 95.5 | 95.7 | 96.0 | 96.2 | 96.4 | 96.7 |
| Andorra | AND | Europe & Central Asia | High income | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
| Angola | AGO | Sub-Saharan Africa | Lower middle income | 37.8 | 38.3 | 38.8 | 40.4 | 42.0 | 43.6 | 45.0 | 46.5 |
| Antigua and Barbuda | ATG | Latin America & Caribbean | High income | 97.5 | 97.5 | 97.6 | 97.7 | 97.7 | 97.8 | 97.9 | 97.9 |
| Argentina | ARG | Latin America & Caribbean | Upper middle income | 96.3 | 96.5 | 96.8 | 97.0 | 97.2 | 97.4 | 97.6 | 97.8 |
| Armenia | ARM | Europe & Central Asia | Upper middle income | 95.7 | 95.9 | 96.1 | 96.3 | 96.6 | 96.8 | 97.1 | 97.3 |
| Aruba | ABW | Latin America & Caribbean | High income | 95.2 | 95.4 | 95.5 | 95.6 | 95.7 | 95.9 | 96.0 | 96.1 |
| Australia | AUS | East Asia & Pacific | High income | 99.7 | 99.7 | 99.7 | 99.7 | 99.8 | 99.8 | 99.8 | 99.8 |
| Austria | AUT | Europe & Central Asia | High income | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
| Azerbaijan | AZE | Europe & Central Asia | Upper middle income | 75.6 | 76.5 | 77.4 | 78.3 | 79.2 | 80.1 | 81.1 | 82.0 |
Showing the first 16 of 220 rows and 12 of 29 columns. Cells with formulas show the formula on hover.
| Safely managed sanitation, % of population, 2000-2024 | 0-25 | 25-50 | |||||||||
| Source: World Bank, World Development Indicators (SH.STA.SMSS.ZS; WHO/UNICEF JMP) · Retrieved 2026-10-09 · License: CC BY 4.0 · Cell colors are fixed value bands computed from the published values when this file was built | |||||||||||
| Country | ISO3 | Region | Income group | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 10.1 | 10.1 | 10.9 | 11.6 | 12.3 | 13.0 | 13.7 | 14.4 |
| Albania | ALB | Europe & Central Asia | Upper middle income | 22.9 | 23.5 | 24.0 | 24.6 | 25.1 | 25.9 | 26.7 | 27.4 |
| Algeria | DZA | Middle East, North Africa, Afghanistan & Pakistan | Upper middle income | 58.9 | 59.2 | 59.5 | 59.9 | 60.2 | 60.5 | 60.8 | 61.1 |
| American Samoa | ASM | East Asia & Pacific | High income | 42.9 | 42.8 | 42.8 | 42.8 | 42.7 | 42.7 | 42.7 | 42.6 |
| Andorra | AND | Europe & Central Asia | High income | 21.3 | 26.2 | 31.1 | 36.0 | 40.9 | 45.8 | 50.7 | 55.6 |
| Angola | AGO | Sub-Saharan Africa | Lower middle income | ||||||||
| Antigua and Barbuda | ATG | Latin America & Caribbean | High income | ||||||||
| Argentina | ARG | Latin America & Caribbean | Upper middle income | 48.1 | 48.3 | 48.5 | 48.6 | 48.8 | 49.0 | 49.1 | 49.3 |
| Armenia | ARM | Europe & Central Asia | Upper middle income | 15.0 | 14.9 | 14.7 | 14.5 | 14.2 | 14.0 | 13.8 | 13.6 |
| Aruba | ABW | Latin America & Caribbean | High income | ||||||||
| Australia | AUS | East Asia & Pacific | High income | 93.7 | 93.8 | 93.9 | 94.0 | 94.1 | 94.2 | 94.2 | 94.3 |
| Austria | AUT | Europe & Central Asia | High income | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
| Azerbaijan | AZE | Europe & Central Asia | Upper middle income | 37.9 | 38.7 | 39.5 | 40.9 | 42.2 | 43.7 | 45.2 | 46.7 |
Showing the first 16 of 220 rows and 12 of 29 columns. Cells with formulas show the formula on hover.
| At least basic sanitation, % of population, 2000-2024 | 0-25 | 25-50 | |||||||||
| Source: World Bank, World Development Indicators (SH.STA.BASS.ZS; WHO/UNICEF JMP) · Retrieved 2026-10-09 · License: CC BY 4.0 · Cell colors are fixed value bands computed from the published values when this file was built | |||||||||||
| Country | ISO3 | Region | Income group | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 22.3 | 22.3 | 23.7 | 25.2 | 26.6 | 28.0 | 29.5 | 30.9 |
| Albania | ALB | Europe & Central Asia | Upper middle income | 89.5 | 90.0 | 90.6 | 91.2 | 91.7 | 92.3 | 92.9 | 93.5 |
| Algeria | DZA | Middle East, North Africa, Afghanistan & Pakistan | Upper middle income | 84.5 | 84.8 | 85.0 | 85.3 | 85.6 | 85.8 | 86.1 | 86.3 |
| American Samoa | ASM | East Asia & Pacific | High income | 62.3 | 62.3 | 62.3 | 62.3 | 62.3 | 62.3 | 62.2 | 62.2 |
| Andorra | AND | Europe & Central Asia | High income | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
| Angola | AGO | Sub-Saharan Africa | Lower middle income | 33.8 | 34.3 | 34.7 | 35.8 | 36.8 | 37.8 | 38.7 | 39.6 |
| Antigua and Barbuda | ATG | Latin America & Caribbean | High income | 84.8 | 85.5 | 86.3 | 87.1 | 87.9 | 88.6 | 89.4 | 90.2 |
| Argentina | ARG | Latin America & Caribbean | Upper middle income | 87.7 | 88.1 | 88.6 | 89.1 | 89.5 | 90.0 | 90.5 | 90.9 |
| Armenia | ARM | Europe & Central Asia | Upper middle income | 88.0 | 88.2 | 88.5 | 88.7 | 88.9 | 89.1 | 89.4 | 89.6 |
| Aruba | ABW | Latin America & Caribbean | High income | 98.0 | 98.0 | 98.1 | 98.1 | 98.1 | 98.2 | 98.2 | 98.2 |
| Australia | AUS | East Asia & Pacific | High income | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
| Austria | AUT | Europe & Central Asia | High income | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
| Azerbaijan | AZE | Europe & Central Asia | Upper middle income | 68.4 | 69.4 | 70.5 | 71.5 | 72.6 | 73.9 | 75.2 | 76.6 |
Showing the first 16 of 220 rows and 12 of 29 columns. Cells with formulas show the formula on hover.
| Handwashing with soap and water, % of population, 2000-2024 | 0-25 | 25-50 | |||||||||
| Source: World Bank, World Development Indicators (SH.STA.HYGN.ZS; WHO/UNICEF JMP) · Retrieved 2026-10-09 · License: CC BY 4.0 · Cell colors are fixed value bands computed from the published values when this file was built | |||||||||||
| Country | ISO3 | Region | Income group | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 35.3 | 35.4 | 35.5 | |||||
| Albania | ALB | Europe & Central Asia | Upper middle income | ||||||||
| Algeria | DZA | Middle East, North Africa, Afghanistan & Pakistan | Upper middle income | 82.9 | |||||||
| American Samoa | ASM | East Asia & Pacific | High income | ||||||||
| Andorra | AND | Europe & Central Asia | High income | ||||||||
| Angola | AGO | Sub-Saharan Africa | Lower middle income | ||||||||
| Antigua and Barbuda | ATG | Latin America & Caribbean | High income | ||||||||
| Argentina | ARG | Latin America & Caribbean | Upper middle income | ||||||||
| Armenia | ARM | Europe & Central Asia | Upper middle income | 83.2 | 83.8 | 84.4 | 85.0 | 85.7 | 86.3 | 86.9 | 87.6 |
| Aruba | ABW | Latin America & Caribbean | High income | ||||||||
| Australia | AUS | East Asia & Pacific | High income | ||||||||
| Austria | AUT | Europe & Central Asia | High income | ||||||||
| Azerbaijan | AZE | Europe & Central Asia | Upper middle income | 88.0 |
Showing the first 16 of 220 rows and 12 of 29 columns. Cells with formulas show the formula on hover.
| Latest published value of each indicator, by country (through 2024) | |||||||||||
| Source: World Bank, World Development Indicators (SH.H2O.SMDW.ZS, SH.H2O.BASW.ZS, SH.STA.SMSS.ZS, SH.STA.BASS.ZS, SH.STA.HYGN.ZS; WHO/UNICEF JMP) · Retrieved 2026-10-09 · License: CC BY 4.0 · Values are read from the data tabs by formula;… | |||||||||||
| Country | ISO3 | Region | Income group | Safely managed drinking water: latest year | Safely managed drinking water, % | Safely managed drinking water: gap to 100 | At least basic drinking water: latest year | At least basic drinking water, % | At least basic drinking water: gap to 100 | Safely managed sanitation: latest year | Safely managed sanitation, % |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2024 | 30.6 | 69.4 | 2024 | 80.8 | 19.2 | 2024 | 24.8 |
| Albania | ALB | Europe & Central Asia | Upper middle income | 2024 | 70.8 | 29.2 | 2024 | 95.1 | 4.9 | 2024 | 69.3 |
| Algeria | DZA | Middle East, North Africa, Afghanistan & Pakistan | Upper middle income | 2024 | 69.0 | 31.0 | 2024 | 92.4 | 7.6 | 2024 | 62.5 |
| American Samoa | ASM | East Asia & Pacific | High income | 2024 | 90.5 | 9.5 | 2024 | 100.0 | 0.0 | 2024 | 42.9 |
| Andorra | AND | Europe & Central Asia | High income | 2024 | 90.6 | 9.4 | 2024 | 100.0 | 0.0 | 2024 | 100.0 |
| Angola | AGO | Sub-Saharan Africa | Lower middle income | 2024 | 68.0 | 32.0 | |||||
| Antigua and Barbuda | ATG | Latin America & Caribbean | High income | 2024 | 98.9 | 1.1 | |||||
| Argentina | ARG | Latin America & Caribbean | Upper middle income | 2016 | 99.0 | 1.0 | 2016 | 48.5 | |||
| Armenia | ARM | Europe & Central Asia | Upper middle income | 2024 | 82.1 | 17.9 | 2024 | 99.9 | 0.1 | 2024 | 10.7 |
| Aruba | ABW | Latin America & Caribbean | High income | 2016 | 96.7 | 3.3 | |||||
| Australia | AUS | East Asia & Pacific | High income | 2024 | 100.0 | 0.0 | 2024 | 95.8 | |||
| Austria | AUT | Europe & Central Asia | High income | 2024 | 98.9 | 1.1 | 2024 | 100.0 | 0.0 | 2024 | 98.5 |
| Azerbaijan | AZE | Europe & Central Asia | Upper middle income | 2024 | 57.8 | 42.2 | 2024 | 97.7 | 2.3 | 2024 | 68.0 |
Showing the first 16 of 220 rows and 12 of 22 columns. Cells with formulas show the formula on hover.
| World Bank regional, income-group and world aggregates | |||||||||||
| Source: World Bank, World Development Indicators (SH.H2O.SMDW.ZS, SH.H2O.BASW.ZS, SH.STA.SMSS.ZS, SH.STA.BASS.ZS, SH.STA.HYGN.ZS) · Retrieved 2026-10-09 · License: CC BY 4.0 · Aggregates as published by the World Bank, not summed from the… | |||||||||||
| Aggregate | Code | Type | Indicator | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 |
| World | WLD | World | Safely managed drinking water (SH.H2O.SMDW.ZS) | 61.2 | 61.5 | 61.8 | 62.1 | 62.5 | 62.8 | 63.1 | 63.4 |
| East Asia & Pacific | EAS | Region | Safely managed drinking water (SH.H2O.SMDW.ZS) | 68.4 | 68.9 | 70.0 | 70.6 | 71.3 | 71.9 | 72.5 | 73.0 |
| Europe & Central Asia | ECS | Region | Safely managed drinking water (SH.H2O.SMDW.ZS) | 86.5 | 86.6 | 86.8 | 86.9 | 87.3 | 88.4 | 88.7 | 89.1 |
| Latin America & Caribbean | LCN | Region | Safely managed drinking water (SH.H2O.SMDW.ZS) | 70.2 | 70.5 | 70.7 | 71.0 | 71.3 | 71.9 | 72.1 | 72.4 |
| Middle East, North Africa, Afghanistan & Pakistan | MEA | Region | Safely managed drinking water (SH.H2O.SMDW.ZS) | 62.1 | 62.3 | 62.4 | 62.5 | 62.6 | 62.8 | 63.1 | 63.3 |
| North America | NAC | Region | Safely managed drinking water (SH.H2O.SMDW.ZS) | 95.4 | 95.4 | 95.4 | |||||
| South Asia | SAS | Region | Safely managed drinking water (SH.H2O.SMDW.ZS) | 41.0 | 42.3 | 43.7 | 45.0 | 46.4 | 47.8 | 49.3 | 50.8 |
| Sub-Saharan Africa | SSF | Region | Safely managed drinking water (SH.H2O.SMDW.ZS) | 17.9 | 18.1 | 18.5 | 18.9 | 19.4 | 19.9 | 20.5 | 21.0 |
| High income | HIC | Income group | Safely managed drinking water (SH.H2O.SMDW.ZS) | 92.7 | 92.9 | 93.0 | 93.2 | 93.4 | 94.0 | 94.2 | 94.3 |
| Upper middle income | UMC | Income group | Safely managed drinking water (SH.H2O.SMDW.ZS) | 69.9 | 70.2 | 71.0 | 71.6 | 72.1 | 72.7 | 73.2 | 73.8 |
| Lower middle income | LMC | Income group | Safely managed drinking water (SH.H2O.SMDW.ZS) | 43.8 | 44.8 | 45.9 | 46.9 | 48.0 | 49.1 | 50.2 | 51.4 |
| Low income | LIC | Income group | Safely managed drinking water (SH.H2O.SMDW.ZS) | 22.3 | 22.4 | 22.5 | 22.7 | 22.9 | 23.2 | 23.6 | 24.1 |
| World | WLD | World | At least basic drinking water (SH.H2O.BASW.ZS) | 80.6 | 80.9 | 81.6 | 82.1 | 82.6 | 83.9 | 84.3 | 84.8 |
Showing the first 16 of 63 rows and 12 of 29 columns. Cells with formulas show the formula on hover.
| About this dataset | |
| Source: World Bank WDI · Retrieved 2026-10-09 · License: CC BY 4.0 | |
| What this workbook is | |
| Summary | Shares of each country's population using safely managed or at least basic drinking water and sanitation services, and the share with a handwashing facility with soap and water, for 217 World Bank-listed economies, 2000-2024. Five indicato… |
| Tabs | |
| Dashboard | KPI tiles for the world in 2024, a world trend, regions compared, and the 15 countries with the lowest safely managed drinking water (formulas over the Latest year tab). |
| Drinking water (safely managed) | Wide table: one row per country, one column per year. Indicator SH.H2O.SMDW.ZS. |
| Drinking water (basic) | Same layout. Indicator SH.H2O.BASW.ZS. Includes the people counted as safely managed. |
| Sanitation (safely managed) | Same layout. Indicator SH.STA.SMSS.ZS. |
| Sanitation (basic) | Same layout. Indicator SH.STA.BASS.ZS. Includes the people counted as safely managed. |
| Handwashing | Same layout. Indicator SH.STA.HYGN.ZS: households with a handwashing facility with soap and water. |
| Latest year | One row per country: the latest published year and value of each indicator (year is fixed at build time; the value is read from the data tab by formula), the gap to 100 (formula), two bar columns, and a tie-break sort key. |
| Regions & income groups | The World Bank's aggregate series for the world (WLD), seven regions and four income groups, one block per indicator, with an Indicator column. |
Showing the first 16 of 84 rows and 2 of 2 columns. Cells with formulas show the formula on hover.
What does this dataset do?
This workbook holds the share of each country's population using drinking water and sanitation services, and the share with a handwashing facility with soap and water, for 217 economies from 2000 to 2024. The figures are the World Bank's World Development Indicators, which republish the WHO/UNICEF Joint Monitoring Programme (JMP) estimates. Five indicators each have their own tab, laid out as one row per country and one column per year.
The Latest year tab gives each country's most recent value and year for every indicator, the gap to universal coverage (100 minus the value) and two text bar columns. The Dashboard shows world figures for the latest year, a world trend, regional comparisons and the 15 countries with the lowest safely managed drinking water, all computed by formula from the data tabs.
Every number is the published value, unmodified. Where no value is published the cell is blank, and nothing is estimated. The heat-map colors reflect the published values when the file was built. The About tab quotes the official indicator definitions and gives a ready-to-use credit line under CC BY 4.0.
What’s inside
- 217 economies, 2000-2024, with ISO3 code, World Bank region and income group
- Five WDI indicators: SH.H2O.SMDW.ZS, SH.H2O.BASW.ZS, SH.STA.SMSS.ZS, SH.STA.BASS.ZS and SH.STA.HYGN.ZS
- Dashboard with KPI tiles, a world trend, regional bars and a formula-driven lowest-15 ranking
- Latest year tab with the year and value of each indicator, gap to 100 and two bar columns
- Heat-map colors on every data tab, with a legend and a note on when they were computed
- CC BY 4.0 with a ready-made credit line and the official definitions on the About tab
Which tabs does the workbook have?
| Tab | What it holds |
|---|---|
| Dashboard | World KPIs for 2024, world trend, regional bars and the 15 lowest countries for safely managed drinking water. |
| Drinking water (safely managed) | Percent of population using safely managed drinking water, 2000-2024. |
| Drinking water (basic) | Percent of population using at least basic drinking water, 2000-2024. |
| Sanitation (safely managed) | Percent of population using safely managed sanitation, 2000-2024. |
| Sanitation (basic) | Percent of population using at least basic sanitation, 2000-2024. |
| Handwashing | Percent of population with a handwashing facility with soap and water, 2000-2024. |
| Latest year | Latest year, value and gap to 100 for each indicator per country, with bar columns and a sort key. |
| Regions & income groups | World Bank aggregates for the world, seven regions and four income groups, for all five indicators. |
| About | Official indicator definitions, sources, license, credit line and known gaps. |
What formulas does this dataset use?
This dataset holds 3,157 formulas in 30,646 cells across 9 tabs, so 10% of its cells calculate. They use 14 distinct functions; the longest formula is 2,854 characters and 1,355 of them read from another tab.
| Function | Uses | What it does |
|---|---|---|
IF | 3,227 | one result when a test is true, another when false |
ISNUMBER | 1,437 | true for a number |
INDEX | 1,205 | value at a position in a range |
MATCH | 1,100 | position of a value in a range |
MAX | 610 | largest value |
ROUND | 605 | rounds to a number of digits |
MIN | 485 | smallest value |
OR | 480 | true when any test is true |
REPT | 480 | repeats text |
COUNTIF | 217 | counts cells meeting one condition |
CHOOSE | 125 | picks the nth value from a list |
SMALL | 15 | nth smallest value |
The 12 most used of 14 functions. Counted from the workbook itself. Only functions that Excel, LibreOffice Calc, Google Sheets and Apple Numbers evaluate the same way are used, so the formulas survive every download format.
How do you use it?
- Open the Dashboard for world figures and the lowest-ranked countries, then open a data tab for the full series.
- Pick one indicator tab and read across a row for one country's time series, or down a column for one year.
- Use the Latest year tab to compare countries on their most recent value; the year column says which year each value is from.
- Filter the Region or Income group columns with the header drop-downs to compare groups.
- Copy the credit line from the About tab when you publish anything based on the data.
What do the columns and units mean?
| Column | Unit | Meaning |
|---|---|---|
| Country | text | Country or territory name as used by the World Bank. |
| ISO3 | code | World Bank three-letter country code (ISO 3166-1 alpha-3, with XKX for Kosovo and CHI for the Channel Islands). |
| Region | text | World Bank region. |
| Income group | text | World Bank income classification. |
| Safely managed drinking water 2000-2024 | % of population | People using safely managed drinking water services (SH.H2O.SMDW.ZS). |
| At least basic drinking water 2000-2024 | % of population | People using at least basic drinking water services, including safely managed (SH.H2O.BASW.ZS). |
| Safely managed sanitation 2000-2024 | % of population | People using safely managed sanitation services (SH.STA.SMSS.ZS). |
| At least basic sanitation 2000-2024 | % of population | People using at least basic sanitation services, including safely managed (SH.STA.BASS.ZS). |
| Handwashing with soap and water 2000-2024 | % of population | People with a basic handwashing facility with soap and water on the premises (SH.STA.HYGN.ZS). |
| Latest year | year | Most recent year with a published value, per country and indicator (Latest year tab). |
| Gap to 100 | percentage points | 100 minus the latest value (Latest year tab). |
Where does the data come from?
World Bank, World Development Indicators (WHO/UNICEF JMP estimates), licensed CC BY 4.0. Retrieved 9 Oct 2026.
Cite as: World Bank, World Development Indicators (SH.H2O.SMDW.ZS, SH.H2O.BASW.ZS, SH.STA.SMSS.ZS, SH.STA.BASS.ZS, SH.STA.HYGN.ZS; WHO/UNICEF Joint Monitoring Programme for Water Supply, Sanitation and Hygiene), database last updated 2026-10-08; retrieved 2026-10-09 from https://api.worldbank.org/v2/. Licensed CC BY 4.0.
Underlying source per the World Bank: WHO/UNICEF Joint Monitoring Programme (JMP) for Water Supply, Sanitation and Hygiene. Values are unmodified; blank means not published. Country list and region and income-group assignments come from the World Bank country API (entries with a region other than 'NA').
What is it good for?
- Comparing drinking water and sanitation access across countries
- Tracking progress toward universal safely managed services over 25 years
- Building a regional comparison for a water or health report
- Joining coverage data to other country data on ISO3 codes
- Ranking countries by the gap to universal access
Questions about this sheet
What does safely managed mean?
Safely managed drinking water comes from an improved source that is on premises, available when needed and free from contamination. Safely managed sanitation means improved facilities not shared with other households, with excreta safely disposed of in place or treated off site.
Why is the basic figure higher than the safely managed figure?
The at-least-basic indicators include everyone counted as safely managed, so the basic share is never lower. The difference is people who use basic services that do not meet every safely managed condition.
Why are some countries blank?
The World Bank publishes no value for them in that year or in any year, so this file does not estimate them. 66 economies have no safely managed drinking water value in any year.
Can I use these figures commercially?
Yes. The World Bank publishes this data under CC BY 4.0, which allows commercial use and adaptation with attribution. The About tab has a credit line you can copy.
Will the numbers match the World Bank website?
They match the API response retrieved on 2026-10-09 (database updated 2026-10-08). The JMP and the World Bank revise past years when new survey data arrive, so later downloads may differ.