Joint Monitoring Programme, WHO/UNICEF

WHO/UNICEF Joint Monitoring Program: Water Supply and Sanitation

The water and sanitation series is developed using data from the WHO/UNICEF Joint Monitoring Program for water supply and sanitation (JMP). The JMP reports country, regional and global estimates of progress on drinking water, sanitation and hygiene (WASH) since 2000. 

The WSS JMP dataset provides substantial information on water, sanitation and hygiene, broken into national, urban and rural subgroups. Within these subgroups, global estimates are provided that show the proportion of a country's population using improved and unimproved access to water, sanitation and hygiene. For the water dataset, IFs draws primarily on...... For the sanitation dataset, IFs uses the sanitation estimates to break the data down into the proportion of population (%) and the amount of people within a population. To construct these data series, IFs draws primarily on the population served with improved sanitation, unimproved sanitation, other unimproved sanitation, shared sanitation, and open defication sanitation.

The most recent update was in Sept. 2024. There are 8 preprocessors and 100 non-preprocessors.

Instructions on Downloading data

1. Go to https://washdata.org/data/downloads#WLD
2. Click "World file" under "Household" to download all the data.
   
3. Open the downloaded file. "Enable Editing". Hover the mouse to the tab and right-click. The file will show several options:
   
4. Click "Unhide", and a view will pop up.
   
5. Press "ctrl" and select "wat" and "san". Click "OK".
6. In these 2 tabs, you may find the columns we will use in "Code in Source" listed below.

Instructions on Importing Water Data into IFs

This section explains the methodology to be followed when importing WSS JMP  water supply data into IFs. It also describes certain problems that a user might face in interpreting and understanding the data.

Source: Water supply data is published by the WHO/UNICEF JMP. The data is available at the website https://washdata.org/data/downloads#WLD

Country List to be Used: WSS JMP

Ladder and Related code in downloaded data:

TAB	Ladder	Ladder(Code)
wat	AtLeastBasic	basal
wat	Basic	basal - sm
wat	Improved	basal + lim
wat	Limited	lim
wat	OtherUnimproved	unimp
wat	Piped	pip
wat	SafelyManaged	sm
wat	SMAsNeeded	imp_av
wat	SMNotContam	imp_qual
wat	SMOnPremise	imp_prem
wat	Surface	ns
wat	OtherImproved	imp_npip
wat	Unimproved	100 - Improved - ns

Types of Data: The following categories of data need to be imported into IFs:

- Can be directly found

• Units is "Percent" - 30 in total

• Units is "Thousands" - 12 in total

- Need Calculation

• Units is 'Percent" - 9 in total

• Units is "Thousands" - 6 in total

Notes:

1. Any Pop series cannot be directly found in the excel. Thus, we need to manually calculated.
2. pop_t is total population in thousands.
3. prop_u is the percentage of urban population in total population.
4. 100 - prop_u is the percentage of rural population in total population.
5. Except pop_t, the rest of data we will use is in "Percent". To do the calculation for "Pop" series, we need to /100 first to convert the percent to decimal.
6. wat_bas changed to wat_basal.
7. wat_sur changed to wat_ns.
8. Calculated Ladders:
   1. Basic = At least basic + Safely managed
   2. Improved = At least basic + Limited = Piped + Non-piped
   3. Unimproved = 100 - Improved - Surface

Instructions on Importing Sanitation Data into IFs

This section explains the methodology to be followed when importing WSS JMP sanitation data into IFs. It also describes certain problems that a user might face in interpreting and understanding the data.

Source: Sanitation data is published by the WHO/UNICEF JMP. The data is available at the website https://washdata.org/data/household#!/table?geo0=region&geo1=sdg.

Country List to be Used: WSS JMP

Ladder and Related code in downloaded data:

TAB	Ladder	Ladder(Code)
san	AtLeastBasic	basal
san	Basic	basal - sm
san	Improved	basal + lim
san	Limited	lim
san	OpenDefecation	ns
san	OtherUnimproved	unimp
san	SafelyManaged	sm
san	Shared	lim
san	SMDisposedInsitu	sdo_sm
san	SMEmpTreated	fst_sm
san	SMWastewaterTreated	sew_sm
san	Unimproved	100 - Improved - ns

- Can be directly found

• Units is "Percent" - 27 in total

• Units is "Thousands" - 9 in total

- Calculation

• Units is "Percent" - 9 in total

• Units is "Thousands" - 6 in total

Notes:

1. Any Pop series cannot be directly found in the excel. Thus, we need to manually calculated.
2. pop_t is total population in thousands.
3. prop_u is the percentage of urban population in total population.
4. 100 - prop_u is the percentage of rural population in total population.
5. Except pop_t, the rest of data we will use is in "Percent". To do the calculation for "Pop" series, we need to /100 first to convert the percent to decimal.
6. san_bas changed to san_basal.
7. san_od changed to san_ns.
8. Calculated Ladders:
   1. Basic = At least basic + Safely managed
   2. Improved = At least basic + Limited = Sum of Latrines (san_othimp), Septic Tanks (san_sep), Sewer Connections (san_sew)
   3. Unimproved = 100 - Improved - Open Defecation