WSS/JMP: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
=== '''WHO/UNICEF Joint Monitoring Program: Water Supply and Sanitation''' ===
=== '''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) from 2000 to 2015. 
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 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''' ==
# Go to https://washdata.org/data/household#!/table?geo0=region&geo1=sdg
# Use the web scrapping scripts to download the data. The scripts can be acssed [https://github.com/shangkexin/JMP_WHO-UNICEF here].
# The current website does '''NOT''' allow to download all the countries, Measure (Drinking Water and Sanitation), Inequality (Total, Rural, and Urban), and Time period (2000 - 2022) at once. Thus, the scripts seperate all the years to 3 groups and you will download 3 files for each Ladder Type (Analyse by Service level, Analyse by Facility type, and Analyse by Safely managed criteria).
# There are instructions on the scripts, please read it carfully and modify the scripts according different situations. (different most recent year or missing years)
# Make sure you have download all the years in case the scripts don't wait for enough time for the website loads the data.
# The scripts also contain the code for importing data into IFs.


== '''Instructions on Importing Water Data into IFs''' ==
== '''Instructions on Importing Water Data into IFs''' ==
Line 9: Line 20:
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.
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.


'''<u>Source</u>:&nbsp;'''Water supply data is published by the WHO/UNICEF JMP.
'''<u>Source</u>:&nbsp;'''Water supply 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.


'''<u>Country List to be Used:</u>'''&nbsp;WSS JMP
'''<u>Country List to be Used:</u>'''&nbsp;WSS JMP


'''<u>Types of Data</u>:&nbsp;'''The following categories of data need to be imported into IFs:
'''<u>Types of Data</u>:&nbsp;'''The following categories of data need to be imported into IFs:
 
{| class="wikitable"
 
|Residence  Type
|Service Type
|Service level
|Facility type
|Safely managed  element
|Column
|Variable
|Definition
|Extended Source  Defn
|UsedInPreprocessor
|UsedInPreprocessorFileName
|Formula
|-
|rural
|Drinking water
|At least basic
|
|
|Coverage
|WSSJMPWaterRural%AtLeastBasic
|Proportion of Rural  population served with at least basic drinking water (%)
|
|0
|
|
|-
|total
|Drinking water
|At least basic
|
|
|Coverage
|WSSJMPWaterTotal%AtLeastBasic
|Proportion of Total  population served with at least basic drinking water (%)
|
|0
|
|
|-
|urban
|Drinking water
|At least basic
|
|
|Coverage
|WSSJMPWaterUrban%AtLeastBasic
|Proportion of Urban  population served with at least basic drinking water (%)
|
|0
|
|
|-
|rural
|Drinking water
|At least basis -  Limited service
|
|
|Coverage
|WSSJMPWaterRural%Basic
|Proportion of Rural  population served with at least basic and not shared with others (%)
|Use of improved  facilities which are not shared with other households
|0
|
|
|-
|total
|Drinking water
|At least basis -  Limited service
|
|
|Coverage
|WSSJMPWaterTotal%Basic
|Proportion of total  population served with at least basic and not shared with others (%)
|Use of improved  facilities which are not shared with other households
|0
|
|
|-
|urban
|Drinking water
|At least basis -  Limited service
|
|
|Coverage
|WSSJMPWaterUrban%Basic
|Proportion of Urban  population served with at least basic and not shared with others (%)
|Use of improved  facilities which are not shared with other households
|0
|
|
|-
|rural
|Drinking water
|Limited service
|
|
|Coverage
|WSSJMPWaterRural%Limited
|Proportion of Rural  population served with limited drinking water (%)
|Drinking water from  an improved source for which collection time exceeds 30 minutes for a  roundtrip including queuing
|0
|
|
|-
|total
|Drinking water
|Limited service
|
|
|Coverage
|WSSJMPWaterTotal%Limited
|Proportion of Total  population served with limited drinking water (%)
|Drinking water from  an improved source for which collection time exceeds 30 minutes for a  roundtrip including queuing
|0
|
|
|-
|urban
|Drinking water
|Limited service
|
|
|Coverage
|WSSJMPWaterUrban%Limited
|Proportion of Urban  population served with limited drinking water (%)
|Drinking water from  an improved source for which collection time exceeds 30 minutes for a  roundtrip including queuing
|0
|
|
|-
|rural
|Drinking water
|Safely managed  service
|
|
|Coverage
|WSSJMPWaterRural%SafelyManaged
|Proportion of Rural  population served with safely managed drinking water (%)
|From an improved  water source that is accessible on premises, available when needed and free  from faecal and priority chemical contamination
|0
|
|
|-
|total
|Drinking water
|Safely managed  service
|
|
|Coverage
|WSSJMPWaterTotal%SafelyManaged
|Proportion of Total  population served with safely managed drinking water (%)
|From an improved  water source that is accessible on premises, available when needed and free  from faecal and priority chemical contamination
|0
|
|
|-
|urban
|Drinking water
|Safely managed  service
|
|
|Coverage
|WSSJMPWaterUrban%SafelyManaged
|Proportion of Urban  population served with safely managed drinking water (%)
|From an improved  water source that is accessible on premises, available when needed and free  from faecal and priority chemical contamination
|0
|
|
|-
|rural
|Drinking water
|Surface and  Unimproved
|
|
|Coverage
|WSSJMPWaterRural%Unimproved
|Proportion of Rural  population served with unimproved drinking water (%). Total Unimproved Water  is the sum of Surface and Unimproved water access.
|Unimproved drinking  water sources/surface drinking water sources
|0
|
|
|-
|rural
|Drinking water
|Surface and  Unimproved
|
|
|Population
|WSSJMPWaterRuralPopUnimproved
|Rural population  served with Unimproved Water. Total Unimproved Water is the sum of Surface  and Unimproved water access.
|Unimproved drinking  water sources/surface drinking water sources
|0
|
|/1000
|-
|total
|Drinking water
|Surface and  Unimproved
|
|
|Coverage
|WSSJMPWaterTotal%Unimproved
|Proportion of Total  population served with unimproved drinking water (%). Total Unimproved Water  is the sum of Surface and Unimproved water access.
|Unimproved drinking  water sources/surface drinking water sources
|0
|
|
|-
|total
|Drinking water
|Surface and  Unimproved
|
|
|Population
|WSSJMPWaterTotalPopUnimproved
|Proportion of total  population served with Unimproved Water (%). Total Unimproved Water is the  sum of Surface and Unimproved water access.
|Unimproved drinking  water sources/surface drinking water sources
|0
|
|/1000
|-
|urban
|Drinking water
|Surface and  Unimproved
|
|
|Coverage
|WSSJMPWaterUrban%Unimproved
|Proportion of Urban  population served with unimproved drinking water (%). Total Unimproved Water  is the sum of Surface and Unimproved water access.
|Unimproved drinking  water sources/surface drinking water sources
|0
|
|
|-
|urban
|Drinking water
|Surface and  Unimproved
|
|
|Population
|WSSJMPWaterUrbanPopUnimproved
|Urban population  served with Unimproved Water. Total Unimproved Water is the sum of Surface  and Unimproved water access.
|Unimproved drinking  water sources/surface drinking water sources
|0
|
|/1000
|-
|rural
|Drinking water
|Surface water
|
|
|Coverage
|WSSJMPWaterRural%Surface
|Proportion of Rural  population served with surface drinking water (%)
|Drinking water  directly from a river, dam, lake, pond, stream, canal or irrigation canal
|0
|
|
|-
|rural
|Drinking water
|Surface water
|
|
|Population
|WSSJMPWaterRuralPopSurface
|Rural population with  Surface Water
|Drinking water  directly from a river, dam, lake, pond, stream, canal or irrigation canal
|0
|
|/1000
|-
|total
|Drinking water
|Surface water
|
|
|Coverage
|WSSJMPWaterTotal%Surface
|Proportion of Total  population served with surface drinking water (%)
|Drinking water  directly from a river, dam, lake, pond, stream, canal or irrigation canal
|1
|ECONOMY,  INFRASTRUCTURE
|
|-
|total
|Drinking water
|Surface water
|
|
|Population
|WSSJMPWaterTotalPopSurface
|Total population with  Surface Water
|Drinking water  directly from a river, dam, lake, pond, stream, canal or irrigation canal
|0
|
|/1000
|-
|urban
|Drinking water
|Surface water
|
|
|Coverage
|WSSJMPWaterUrban%Surface
|Proportion of Urban  population served with surface drinking water (%)
|Drinking water  directly from a river, dam, lake, pond, stream, canal or irrigation canal
|0
|
|
|-
|urban
|Drinking water
|Surface water
|
|
|Population
|WSSJMPWaterUrbanPopSurface
|Urban population with  Surface Water
|Drinking water  directly from a river, dam, lake, pond, stream, canal or irrigation canal
|0
|
|/1000
|-
|rural
|Drinking water
|Unimproved
|
|
|Coverage
|WSSJMPWaterRural%OtherUnimproved
|Proportion of Rural  population with Unimproved Water (%)
|Unprotected dug well,  unprotected spring, cart with small tank/drum, tanker truck, bottled water  (Bottled water is considered 'improved' for drinking only when the household  used an improved source for cooking and personal hygiene)
|0
|
|
|-
|rural
|Drinking water
|Unimproved
|
|
|Population
|WSSJMPWaterRuralPopOtherUnimproved
|Rural population with  Unimproved Water
|Unprotected dug well,  unprotected spring, cart with small tank/drum, tanker truck, bottled water  (Bottled water is considered 'improved' for drinking only when the household  used an improved source for cooking and personal hygiene)
|0
|
|/1000
|-
|total
|Drinking water
|Unimproved
|
|
|Coverage
|WSSJMPWaterTotal%OtherUnimproved
|Proportion of Total  population with Unimproved Water (%)
|Unprotected dug well,  unprotected spring, cart with small tank/drum, tanker truck, bottled water  (Bottled water is considered 'improved' for drinking only when the household  used an improved source for cooking and personal hygiene)
|1
|ECONOMY,  INFRASTRUCTURE
|
|-
|total
|Drinking water
|Unimproved
|
|
|Population
|WSSJMPWaterTotalPopOtherUnimproved
|Total population  served with Unimproved Water
|Unprotected dug well,  unprotected spring, cart with small tank/drum, tanker truck, bottled water  (Bottled water is considered 'improved' for drinking only when the household  used an improved source for cooking and personal hygiene)
|0
|
|/1000
|-
|urban
|Drinking water
|Unimproved
|
|
|Coverage
|WSSJMPWaterUrban%OtherUnimproved
|Proportion of Urban  population with Unimproved Water (%)
|Unprotected dug well,  unprotected spring, cart with small tank/drum, tanker truck, bottled water  (Bottled water is considered 'improved' for drinking only when the household  used an improved source for cooking and personal hygiene)
|0
|
|
|-
|urban
|Drinking water
|Unimproved
|
|
|Population
|WSSJMPWaterUrbanPopOtherUnimproved
|Urban population with  Unimproved Water
|Unprotected dug well,  unprotected spring, cart with small tank/drum, tanker truck, bottled water  (Bottled water is considered 'improved' for drinking only when the household  used an improved source for cooking and personal hygiene)
|0
|
|/1000
|-
|rural
|Drinking water
|
|Non-piped improved  and Improved latrine and other
|
|Coverage
|WSSJMPWaterRural%OtherImproved
|Proportion of Rural  population served with Other Improved Water (%). Total Other Improved Water  is the sum of Non-piped improved and Improved latrine and other.
|Public taps or  standpipes, tube wells or boreholes, protected dug wells, protected springs,  rainwater collection
|0
|
|
|-
|rural
|Drinking water
|
|Non-piped improved  and Improved latrine and other
|
|Population
|WSSJMPWaterRuralPopOtherImproved
|Rural population  served with Other Improved Water. Total Other Improved Water is the sum of  Non-piped improved and Improved latrine and other.
|Public taps or  standpipes, tube wells or boreholes, protected dug wells, protected springs,  rainwater collection
|0
|
|/1000
|-
|total
|Drinking water
|
|Non-piped improved  and Improved latrine and other
|
|Coverage
|WSSJMPWaterTotal%OtherImproved
|Proportion of Total  population served with Other Improved Water (%). Total Other Improved Water  is the sum of Non-piped improved and Improved latrine and other.
|Public taps or  standpipes, tube wells or boreholes, protected dug wells, protected springs,  rainwater collection
|1
|INFRASTRUCTURE
|
|-
|total
|Drinking water
|
|Non-piped improved  and Improved latrine and other
|
|Population
|WSSJMPWaterTotalPopOtherImproved
|Total population  served with Other Improved Water. Total Other Improved Water is the sum of  Non-piped improved and Improved latrine and other.
|Public taps or  standpipes, tube wells or boreholes, protected dug wells, protected springs,  rainwater collection
|0
|
|/1000
|-
|urban
|Drinking water
|
|Non-piped improved  and Improved latrine and other
|
|Coverage
|WSSJMPWaterUrban%OtherImproved
|Proportion of Urban  population served with Other Improved Water (%). Total Other Improved Water  is the sum of Non-piped improved and Improved latrine and other.
|Public taps or  standpipes, tube wells or boreholes, protected dug wells, protected springs,  rainwater collection
|0
|
|
|-
|urban
|Drinking water
|
|Non-piped improved  and Improved latrine and other
|
|Population
|WSSJMPWaterUrbanPopOtherImproved
|Urban population  served with Other Improved Water. Total Other Improved Water is the sum of  Non-piped improved and Improved latrine and other.
|Public taps or  standpipes, tube wells or boreholes, protected dug wells, protected springs,  rainwater collection
|0
|
|/1000
|-
|rural
|Drinking water
|
|Non-piped improved,  Improved latrine and other, Piped improved, Septic tank, and Sewer
|
|Coverage
|WSSJMPWaterRural%Improved
|Proportion of Rural  population served with Improved Water (%). Total Improved Water is the sum of  Non-piped improved,Improved latrine and other, Piped improved, Septic tank,  and Sewer.
|Piped water on  premises/other improved drinking water
|0
|
|
|-
|rural
|Drinking water
|
|Non-piped improved,  Improved latrine and other, Piped improved, Septic tank, and Sewer
|
|Population
|WSSJMPWaterRuralPopImproved
|Rural population  served with Improved Water. Total Improved Water is the sum of Non-piped  improved,Improved latrine and other, Piped improved, Septic tank, and Sewer.
|Piped water on  premises/other improved drinking water
|0
|
|/1000
|-
|total
|Drinking water
|
|Non-piped improved,  Improved latrine and other, Piped improved, Septic tank, and Sewer
|
|Coverage
|WSSJMPWaterTotal%Improved
|Proportion of Total  population served with Improved Water. (%) Total Improved Water is the sum of  Non-piped improved,Improved latrine and other, Piped improved, Septic tank,  and Sewer.
|Piped water on  premises/other improved drinking water
|0
|
|
|-
|total
|Drinking water
|
|Non-piped improved,  Improved latrine and other, Piped improved, Septic tank, and Sewer
|
|Population
|WSSJMPWaterTotalPopImproved
|Total population  served with Improved Water Total Improved Water is the sum of Non-piped  improved,Improved latrine and other, Piped improved, Septic tank, and Sewer.
|Piped water on  premises/other improved drinking water
|0
|
|/1000
|-
|urban
|Drinking water
|
|Non-piped improved,  Improved latrine and other, Piped improved, Septic tank, and Sewer
|
|Coverage
|WSSJMPWaterUrban%Improved
|Proportion of Urban  population served with Improved Water (%). Total Improved Water is the sum of  Non-piped improved,Improved latrine and other, Piped improved, Septic tank,  and Sewer.
|Piped water on  premises/other improved drinking water
|0
|
|
|-
|urban
|Drinking water
|
|Non-piped improved,  Improved latrine and other, Piped improved, Septic tank, and Sewer
|
|Population
|WSSJMPWaterUrbanPopImproved
|Urban population  served with Improved Water. Total Improved Water is the sum of Non-piped  improved,Improved latrine and other, Piped improved, Septic tank, and Sewer.
|Piped water on  premises/other improved drinking water
|0
|
|/1000
|-
|rural
|Drinking water
|
|Piped improved
|
|Coverage
|WSSJMPWaterRural%Piped
|Proportion of Rural  population served with Piped Water (%)
|Piped household water  connection located inside the user's dwelling, plot or yard
|0
|
|
|-
|rural
|Drinking water
|
|Piped improved
|
|Population
|WSSJMPWaterRuralPopPiped
|Rural population  served with Piped Water
|Piped household water  connection located inside the user's dwelling, plot or yard
|0
|
|/1000
|-
|total
|Drinking water
|
|Piped improved
|
|Coverage
|WSSJMPWaterTotal%Piped
|Proportion of Total  population served with Piped Water (%)
|Piped household water  connection located inside the user's dwelling, plot or yard
|1
|INFRASTRUCTURE
|
|-
|total
|Drinking water
|
|Piped improved
|
|Population
|WSSJMPWaterTotalPopPiped
|Total population  served with Piped Water
|Piped household water  connection located inside the user's dwelling, plot or yard
|0
|
|/1000
|-
|urban
|Drinking water
|
|Piped improved
|
|Coverage
|WSSJMPWaterUrban%Piped
|Proportion of Urban  population served with Piped Water (%)
|Piped household water  connection located inside the user's dwelling, plot or yard
|0
|
|
|-
|urban
|Drinking water
|
|Piped improved
|
|Population
|WSSJMPWaterUrbanPopPiped
|Urban population  served with Piped Water
|Piped household water  connection located inside the user's dwelling, plot or yard
|0
|
|/1000
|-
|rural
|Drinking water
|
|
|Available
|Coverage
|WSSJMPWaterRural%SMAsNeeded
|Proportion of Rural  population served with available when needed improved drinking water (%)
|From an improved  water source that is vailable when needed
|0
|
|
|-
|total
|Drinking water
|
|
|Available
|Coverage
|WSSJMPWaterTotal%SMAsNeeded
|Proportion of Total  population served with available when needed improved drinking water (%)
|From an improved  water source that is vailable when needed
|0
|
|
|-
|urban
|Drinking water
|
|
|Available
|Coverage
|WSSJMPWaterUrban%SMAsNeeded
|Proportion of Urban  population served with available when needed improved drinking water (%)
|From an improved  water source that is vailable when needed
|0
|
|
|-
|rural
|Drinking water
|
|
|Free from  contamination
|Coverage
|WSSJMPWaterRural%SMNotContam
|Proportion of Rural  population served with free from contamination improved drinking water (%)
|From an improved  water source that is free from faecal and priority chemical contamination
|0
|
|
|-
|total
|Drinking water
|
|
|Free from  contamination
|Coverage
|WSSJMPWaterTotal%SMNotContam
|Proportion of Total  population served with free from contamination improved drinking water (%)
|From an improved  water source that is free from faecal and priority chemical contamination
|0
|
|
|-
|urban
|Drinking water
|
|
|Free from  contamination
|Coverage
|WSSJMPWaterUrban%SMNotContam
|Proportion of Urban  population served with free from contamination improved drinking water (%)
|From an improved  water source that is free from faecal and priority chemical contamination
|0
|
|
|-
|rural
|Drinking water
|
|
|On premises
|Coverage
|WSSJMPWaterRural%SMOnPremise
|Proportion of Rural  population served with accessible on premises improved drinking water (%)
|From an improved  water source that is accessible on premises
|0
|
|
|-
|total
|Drinking water
|
|
|On premises
|Coverage
|WSSJMPWaterTotal%SMOnPremise
|Proportion of Total  population served with accessible on premises improved drinking water (%)
|From an improved  water source that is accessible on premises
|0
|
|
|-
|urban
|Drinking water
|
|
|On premises
|Coverage
|WSSJMPWaterUrban%SMOnPremise
|Proportion of Urban  population served with accessible on premises improved drinking water (%)
|From an improved  water source that is accessible on premises
|0
|
|
|}


<u>'''Issues in the data and their resolution:'''</u>
<u>'''Issues in the data and their resolution:'''</u>
Line 23: Line 787:
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.
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.


'''<u>Source</u>:&nbsp;'''Sanitation data is published by the WHO/UNICEF JMP. The data is available at the website&nbsp;[https://washdata.org/data.&nbsp https://washdata.org/data]
'''<u>Source</u>:&nbsp;'''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.


'''<u>Country List to be Used:</u>'''&nbsp;WSS JMP
'''<u>Country List to be Used:</u>'''&nbsp;WSS JMP
Line 59: Line 823:
#<u>'''WSSJMPSanitationRuralPopShared-'''</u>&nbsp;Describes the rural population served with Shared Sanitation. Calculated by the population*(100-Urban Pop/100)*(Rural Limited (shared)/100).
#<u>'''WSSJMPSanitationRuralPopShared-'''</u>&nbsp;Describes the rural population served with Shared Sanitation. Calculated by the population*(100-Urban Pop/100)*(Rural Limited (shared)/100).
#<u>'''WSSJMPSanitationRuralPopOpenDefecation-'''</u>&nbsp;Describes the rural population served with Open Defecation Sanitation. Calculated by the population*(100-Urban Pop/100)*(Rural Open Defecation/100)
#<u>'''WSSJMPSanitationRuralPopOpenDefecation-'''</u>&nbsp;Describes the rural population served with Open Defecation Sanitation. Calculated by the population*(100-Urban Pop/100)*(Rural Open Defecation/100)
{| class="wikitable"
|Residence  Type
|Service Type
|Service level
|Facility type
|Safely managed  element
|Column
|Variable
|Definition
|Extended Source  Defn
|UsedInPreprocessor
|UsedInPreprocessorFileName
|Formula
|-
|rural
|Sanitation
|At least basic
|
|
|Coverage
|WSSJMPSanitationRural%AtLeastBasic
|Proportion of Rural  population served with at least basic facilities (%)
|
|0
|
|
|-
|total
|Sanitation
|At least basic
|
|
|Coverage
|WSSJMPSanitationTotal%AtLeastBasic
|Proportion of Total  population served with at least basic facilities (%)
|
|0
|
|
|-
|urban
|Sanitation
|At least basic
|
|
|Coverage
|WSSJMPSanitationUrban%AtLeastBasic
|Proportion of Urban  population served with at least basic facilities (%)
|
|0
|
|
|-
|rural
|Sanitation
|At least basis -  Limited service
|
|
|Coverage
|WSSJMPSanitationRural%Basic
|Proportion of Rural  population served with at least basic and not shared with others (%)
|Use of improved  facilities which are not shared with other households
|0
|
|
|-
|total
|Sanitation
|At least basis -  Limited service
|
|
|Coverage
|WSSJMPSanitationTotal%Basic
|Proportion of total  population served with at least basic and not shared with others (%)
|Use of improved  facilities which are not shared with other households
|0
|
|
|-
|urban
|Sanitation
|At least basis -  Limited service
|
|
|Coverage
|WSSJMPSanitationUrban%Basic
|Proportion of Urban  population served with at least basic and not shared with others (%)
|Use of improved  facilities which are not shared with other households
|0
|
|
|-
|rural
|Sanitation
|Limited service
|
|
|Coverage
|WSSJMPSanitationRural%Limited
|Proportion of Rural  population served with limited facilities (%)
|Sanitation facilities  of an otherwise acceptable type shared between two or more households. Only  facilities that are not shared or not public are considered improved
|0
|
|
|-
|rural
|Sanitation
|Limited service
|
|
|Coverage
|WSSJMPSanitationRural%Shared
|Proportion of Rural  population served with Shared Sanitation (%)
|Sanitation facilities  of an otherwise acceptable type shared between two or more households. Only  facilities that are not shared or not public are considered improved
|0
|
|
|-
|rural
|Sanitation
|Limited service
|
|
|Population
|WSSJMPSanitationRuralPopShared
|Rural population  served with Shared Sanitation
|Sanitation facilities  of an otherwise acceptable type shared between two or more households. Only  facilities that are not shared or not public are considered improved
|0
|
|/1000
|-
|total
|Sanitation
|Limited service
|
|
|Coverage
|WSSJMPSanitationTotal%Limited
|Proportion of Total  population served with limited facilities (%)
|Sanitation facilities  of an otherwise acceptable type shared between two or more households. Only  facilities that are not shared or not public are considered improved
|0
|
|
|-
|total
|Sanitation
|Limited service
|
|
|Coverage
|WSSJMPSanitationTotal%Shared
|Proportion of Total  population served with Shared Sanitation (%)
|Sanitation facilities  of an otherwise acceptable type shared between two or more households. Only  facilities that are not shared or not public are considered improved
|1
|INFRASTRUCTURE
|
|-
|total
|Sanitation
|Limited service
|
|
|Population
|WSSJMPSanitationTotalPopShared
|Total population  served with Shared Sanitation
|Sanitation facilities  of an otherwise acceptable type shared between two or more households. Only  facilities that are not shared or not public are considered improved
|0
|
|/1000
|-
|urban
|Sanitation
|Limited service
|
|
|Coverage
|WSSJMPSanitationUrban%Limited
|Proportion of Urban  population served with limited facilities (%)
|Sanitation facilities  of an otherwise acceptable type shared between two or more households. Only  facilities that are not shared or not public are considered improved
|0
|
|
|-
|urban
|Sanitation
|Limited service
|
|
|Coverage
|WSSJMPSanitationUrban%Shared
|Proportion of Urban  population served with Shared Sanitation (%)
|Sanitation facilities  of an otherwise acceptable type shared between two or more households. Only  facilities that are not shared or not public are considered improved
|0
|
|
|-
|urban
|Sanitation
|Limited service
|
|
|Population
|WSSJMPSanitationUrbanPopShared
|Urban population  served with Shared Sanitation
|Sanitation facilities  of an otherwise acceptable type shared between two or more households. Only  facilities that are not shared or not public are considered improved
|0
|
|/1000
|-
|rural
|Sanitation
|Open defecation
|
|
|Coverage
|WSSJMPSanitationRural%OpenDefecation
|Proportion of Rural  population served with open defecation facilities (%)
|Disposal of human  faeces in fields, forests, bushes, open bodies of water, beaches and other  open spaces or with solid waste
|0
|
|
|-
|rural
|Sanitation
|Open defecation
|
|
|Population
|WSSJMPSanitationRuralPopOpenDefecation
|Rural population  served with Open Defecation Sanitation
|Disposal of human  faeces in fields, forests, bushes, open bodies of water, beaches and other  open spaces or with solid waste
|0
|
|/1000
|-
|total
|Sanitation
|Open defecation
|
|
|Coverage
|WSSJMPSanitationTotal%OpenDefecation
|Proportion of Total  population served with open defecation facilities (%)
|Disposal of human  faeces in fields, forests, bushes, open bodies of water, beaches and other  open spaces or with solid waste
|1
|ECONOMY,  INFRASTRUCTURE
|
|-
|total
|Sanitation
|Open defecation
|
|
|Population
|WSSJMPSanitationTotalPopOpenDefecation
|Total population  served with Open Defecation Sanitation
|Disposal of human  faeces in fields, forests, bushes, open bodies of water, beaches and other  open spaces or with solid waste
|0
|
|/1000
|-
|urban
|Sanitation
|Open defecation
|
|
|Coverage
|WSSJMPSanitationUrban%OpenDefecation
|Proportion of Urban  population served with open defecation facilities (%)
|Disposal of human  faeces in fields, forests, bushes, open bodies of water, beaches and other  open spaces or with solid waste
|0
|
|
|-
|urban
|Sanitation
|Open defecation
|
|
|Population
|WSSJMPSanitationUrbanPopOpenDefecation
|Urban population  served with Open Defecation Sanitation
|Disposal of human  faeces in fields, forests, bushes, open bodies of water, beaches and other  open spaces or with solid waste
|0
|
|/1000
|-
|rural
|Sanitation
|Open Defecation,  Unimproved, and Limited service
|
|
|Coverage
|WSSJMPSanitationRural%Unimproved
|Proportion of Rural  population served with unimproved facilities (%) Total Unimproved Sanitation  is the sum of Open Defecation, Other Unimproved, and Shared sanitation  access.
|Use of pit latrines  without a slab or platform, hanging latrines or bucket latrines
|0
|
|
|-
|rural
|Sanitation
|Open Defecation,  Unimproved, and Limited service
|
|
|Population
|WSSJMPSanitationRuralPopUnimproved
|Rural population  served with Unimproved Sanitation. Total Unimproved Sanitation is the sum of  Open Defecation, Other Unimproved, and Shared sanitation access.
|do not ensure hygenic  separation of human excreta from human contact. Unimproved facilities include  pit latrines without a slab or platform, hanging latrines or bucket latrines
|0
|
|/1000
|-
|total
|Sanitation
|Open Defecation,  Unimproved, and Limited service
|
|
|Coverage
|WSSJMPSanitationTotal%Unimproved
|Proportion of Total  population served with unimproved facilities (%) Total Unimproved Sanitation  is the sum of Open Defecation, Other Unimproved, and Shared sanitation  access.
|Use of pit latrines  without a slab or platform, hanging latrines or bucket latrines
|0
|
|
|-
|total
|Sanitation
|Open Defecation,  Unimproved, and Limited service
|
|
|Population
|WSSJMPSanitationTotalPopUnimproved
|Total population  served with Unimproved Sanitation. Total Unimproved Sanitation is the sum of  Open Defecation, Other Unimproved, and Shared sanitation access.
|do not ensure hygenic  separation of human excreta from human contact. Unimproved facilities include  pit latrines without a slab or platform, hanging latrines or bucket latrines
|0
|
|/1000
|-
|urban
|Sanitation
|Open Defecation,  Unimproved, and Limited service
|
|
|Coverage
|WSSJMPSanitationUrban%Unimproved
|Proportion of Urban  population served with unimproved facilities (%) Total Unimproved Sanitation  is the sum of Open Defecation, Other Unimproved, and Shared sanitation  access.
|Use of pit latrines  without a slab or platform, hanging latrines or bucket latrines
|0
|
|
|-
|urban
|Sanitation
|Open Defecation,  Unimproved, and Limited service
|
|
|Population
|WSSJMPSanitationUrbanPopUnimproved
|Urban population  served with Unimproved Sanitation. Total Unimproved Sanitation is the sum of  Open Defecation, Other Unimproved, and Shared sanitation access.
|do not ensure hygenic  separation of human excreta from human contact. Unimproved facilities include  pit latrines without a slab or platform, hanging latrines or bucket latrines
|0
|
|/1000
|-
|rural
|Sanitation
|Safely managed  service
|
|
|Coverage
|WSSJMPSanitationRural%SafelyManaged
|Proportion of Rural  population served with safely managed facilities (%)
|Use of improved  facilities that are not shared with other households and where excreta are  safely disposed of in situ or removed and treated offsite
|0
|
|
|-
|total
|Sanitation
|Safely managed  service
|
|
|Coverage
|WSSJMPSanitationTotal%SafelyManaged
|Proportion of Total  population served with safely managed facilities (%)
|Use of improved  facilities that are not shared with other households and where excreta are  safely disposed of in situ or removed and treated offsite
|0
|
|
|-
|urban
|Sanitation
|Safely managed  service
|
|
|Coverage
|WSSJMPSanitationUrban%SafelyManaged
|Proportion of Urban  population served with safely managed facilities (%)
|Use of improved  facilities that are not shared with other households and where excreta are  safely disposed of in situ or removed and treated offsite
|0
|
|
|-
|rural
|Sanitation
|Unimproved
|
|
|Coverage
|WSSJMPSanitationRural%OtherUnimproved
|Proportion of Rural  population with Unimproved Sanitation (%)
|do not ensure hygenic  separation of human excreta from human contact. Unimproved facilities include  pit latrines without a slab or platform, hanging latrines or bucket latrines
|0
|
|
|-
|rural
|Sanitation
|Unimproved
|
|
|Population
|WSSJMPSanitationRuralPopOtherUnimproved
|Rural population with  Unimproved Sanitation
|do not ensure hygenic  separation of human excreta from human contact. Unimproved facilities include  pit latrines without a slab or platform, hanging latrines or bucket latrines
|0
|
|/1000
|-
|total
|Sanitation
|Unimproved
|
|
|Coverage
|WSSJMPSanitationTotal%OtherUnimproved
|Proportion of Total  population with Unimproved Sanitation (%)
|do not ensure hygenic  separation of human excreta from human contact. Unimproved facilities include  pit latrines without a slab or platform, hanging latrines or bucket latrines
|1
|ECONOMY,  INFRASTRUCTURE
|
|-
|total
|Sanitation
|Unimproved
|
|
|Population
|WSSJMPSanitationTotalPopOtherUnimproved
|Total population with  Unimproved Sanitation
|do not ensure hygenic  separation of human excreta from human contact. Unimproved facilities include  pit latrines without a slab or platform, hanging latrines or bucket latrines
|0
|
|/1000
|-
|urban
|Sanitation
|Unimproved
|
|
|Coverage
|WSSJMPSanitationUrban%OtherUnimproved
|Proportion of Urban  population with Unimproved Sanitation (%)
|do not ensure hygenic  separation of human excreta from human contact. Unimproved facilities include  pit latrines without a slab or platform, hanging latrines or bucket latrines
|0
|
|
|-
|urban
|Sanitation
|Unimproved
|
|
|Population
|WSSJMPSanitationUrbanPopOtherUnimproved
|Urban population with  Unimproved Sanitation
|do not ensure hygenic  separation of human excreta from human contact. Unimproved facilities include  pit latrines without a slab or platform, hanging latrines or bucket latrines
|0
|
|/1000
|-
|rural
|Sanitation
|
|Non-piped improved,  Improved latrine and other, Piped improved, Septic tank, and Sewer
|
|Coverage
|WSSJMPSanitationRural%Improved
|Proportion of Rural  population served with Improved Sanitation (%). Total Improved Sanitation is  the sum of Non-piped improved,Improved latrine and other, Piped improved,  Septic tank, and Sewer.
|Likely to ensure  hygenic separation of human excreta from human contact. They include: 1)  Flush/pour flush to (piped sewer system septic tank or pit latrine) 2)  Ventilated improved pit (VIP) latrine 3) Pit latrine with slab 4) Composing  toilet
|0
|
|
|-
|rural
|Sanitation
|
|Non-piped improved,  Improved latrine and other, Piped improved, Septic tank, and Sewer
|
|Population
|WSSJMPSanitationRuralPopImproved
|Rural population  served with Improved Sanitation. Total Improved Sanitation is the sum of  Non-piped improved,Improved latrine and other, Piped improved, Septic tank,  and Sewer.
|Likely to ensure  hygenic separation of human excreta from human contact. They include: 1)  Flush/pour flush to (piped sewer system septic tank or pit latrine) 2)  Ventilated improved pit (VIP) latrine 3) Pit latrine with slab 4) Composing  toilet
|0
|
|/1000
|-
|total
|Sanitation
|
|Non-piped improved,  Improved latrine and other, Piped improved, Septic tank, and Sewer
|
|Coverage
|WSSJMPSanitationTotal%Improved
|Proportion of Total  population served with Improved Sanitation (%). Total Improved Sanitation is  the sum of Non-piped improved,Improved latrine and other, Piped improved,  Septic tank, and Sewer.
|Likely to ensure  hygenic separation of human excreta from human contact. They include: 1)  Flush/pour flush to (piped sewer system septic tank or pit latrine) 2)  Ventilated improved pit (VIP) latrine 3) Pit latrine with slab 4) Composing  toilet
|1
|INFRASTRUCTURE
|
|-
|total
|Sanitation
|
|Non-piped improved,  Improved latrine and other, Piped improved, Septic tank, and Sewer
|
|Population
|WSSJMPSanitationTotalPopImproved
|Total population  served with Improved Sanitation. Total Improved Sanitation is the sum of  Non-piped improved,Improved latrine and other, Piped improved, Septic tank,  and Sewer.
|Likely to ensure  hygenic separation of human excreta from human contact. They include: 1)  Flush/pour flush to (piped sewer system septic tank or pit latrine) 2)  Ventilated improved pit (VIP) latrine 3) Pit latrine with slab 4) Composing  toilet
|0
|
|/1000
|-
|urban
|Sanitation
|
|Non-piped improved,  Improved latrine and other, Piped improved, Septic tank, and Sewer
|
|Coverage
|WSSJMPSanitationUrban%Improved
|Proportion of Urban  population served with Improved Sanitation (%). Total Improved Sanitation is  the sum of Non-piped improved,Improved latrine and other, Piped improved,  Septic tank, and Sewer.
|Likely to ensure  hygenic separation of human excreta from human contact. They include: 1)  Flush/pour flush to (piped sewer system septic tank or pit latrine) 2)  Ventilated improved pit (VIP) latrine 3) Pit latrine with slab 4) Composing  toilet
|0
|
|
|-
|urban
|Sanitation
|
|Non-piped improved,  Improved latrine and other, Piped improved, Septic tank, and Sewer
|
|Population
|WSSJMPSanitationUrbanPopImproved
|Urban population  served with Improved Sanitation. Total Improved Sanitation is the sum of  Non-piped improved,Improved latrine and other, Piped improved, Septic tank,  and Sewer.
|Likely to ensure  hygenic separation of human excreta from human contact. They include: 1)  Flush/pour flush to (piped sewer system septic tank or pit latrine) 2)  Ventilated improved pit (VIP) latrine 3) Pit latrine with slab 4) Composing  toilet
|0
|
|/1000
|-
|rural
|Sanitation
|
|
|Disposed insitu
|Coverage
|WSSJMPSanitationRural%SMDisposedInsitu
|Proportion of Rural  population served with safely managed facilities (%) that are disposed in  situ
|Safely managed =  disposed in situ + emptied and treated + wastewater and treated
|0
|
|
|-
|total
|Sanitation
|
|
|Disposed insitu
|Coverage
|WSSJMPSanitationTotal%SMDisposedInsitu
|Proportion of Total  population served with safely managed facilities (%) that are disposed in  situ
|Safely managed =  disposed in situ + emptied and treated + wastewater and treated
|0
|
|
|-
|urban
|Sanitation
|
|
|Disposed insitu
|Coverage
|WSSJMPSanitationUrban%SMDisposedInsitu
|Proportion of Urban  population served with safely managed facilities (%) that are disposed in  situ
|Safely managed =  disposed in situ + emptied and treated + wastewater and treated
|0
|
|
|-
|rural
|Sanitation
|
|
|Faecal sludge treated
|Coverage
|WSSJMPSanitationRural%SMEmpTreated
|Proportion of Rural  population served with safely managed facilities (%) that are emptied and  treated
|Safely managed =  disposed in situ + emptied and treated + wastewater and treated
|0
|
|
|-
|total
|Sanitation
|
|
|Faecal sludge treated
|Coverage
|WSSJMPSanitationTotal%SMEmpTreated
|Proportion of Total  population served with safely managed facilities (%) that are emptied and  treated
|Safely managed =  disposed in situ + emptied and treated + wastewater and treated
|0
|
|
|-
|urban
|Sanitation
|
|
|Faecal sludge treated
|Coverage
|WSSJMPSanitationUrban%SMEmpTreated
|Proportion of Urban  population served with safely managed facilities (%) that are emptied and  treated
|Safely managed =  disposed in situ + emptied and treated + wastewater and treated
|0
|
|
|-
|rural
|Sanitation
|
|
|Sewage treated
|Coverage
|WSSJMPSanitationRural%SMWastewaterTreated
|Proportion of Rural  population served with safely managed facilities (%) that are wastewater  treated
|Safely managed =  disposed in situ + emptied and treated + wastewater and treated
|0
|
|
|-
|total
|Sanitation
|
|
|Sewage treated
|Coverage
|WSSJMPSanitationTotal%SMWastewaterTreated
|Proportion of Total  population served with safely managed facilities (%) that are wastewater  treated
|Safely managed =  disposed in situ + emptied and treated + wastewater and treated
|0
|
|
|-
|urban
|Sanitation
|
|
|Sewage treated
|Coverage
|WSSJMPSanitationUrban%SMWastewaterTreated
|Proportion of Urban  population served with safely managed facilities (%) that are wastewater  treated
|Safely managed =  disposed in situ + emptied and treated + wastewater and treated
|0
|
|
|}
<u>'''Issues in the data and their resolution:'''</u>


<u>'''Issues in the data and their resolution:'''</u>
The 3 groups of series below are duplicated: '''"Shared" is "Limited service".'''
{| class="wikitable"
|Residence  Type
|Service Type
|Service level
|Facility type
|Safely managed  element
|Column
|Variable
|Definition
|Extended Source  Defn
|UsedInPreprocessor
|UsedInPreprocessorFileName
|Formula
|-
|rural
|Sanitation
|Limited service
|
|
|Coverage
|WSSJMPSanitationRural%Limited
|Proportion of Rural  population served with limited facilities (%)
|Sanitation facilities  of an otherwise acceptable type shared between two or more households. Only  facilities that are not shared or not public are considered improved
|0
|
|
|-
|rural
|Sanitation
|Limited service
|
|
|Coverage
|WSSJMPSanitationRural%Shared
|Proportion of Rural  population served with Shared Sanitation (%)
|Sanitation facilities  of an otherwise acceptable type shared between two or more households. Only  facilities that are not shared or not public are considered improved
|0
|
|
|-
|total
|Sanitation
|Limited service
|
|
|Coverage
|WSSJMPSanitationTotal%Limited
|Proportion of Total  population served with limited facilities (%)
|Sanitation facilities  of an otherwise acceptable type shared between two or more households. Only  facilities that are not shared or not public are considered improved
|0
|
|
|-
|total
|Sanitation
|Limited service
|
|
|Coverage
|WSSJMPSanitationTotal%Shared
|Proportion of Total  population served with Shared Sanitation (%)
|Sanitation facilities  of an otherwise acceptable type shared between two or more households. Only  facilities that are not shared or not public are considered improved
|1
|INFRASTRUCTURE
|
|-
|urban
|Sanitation
|Limited service
|
|
|Coverage
|WSSJMPSanitationUrban%Limited
|Proportion of Urban  population served with limited facilities (%)
|Sanitation facilities  of an otherwise acceptable type shared between two or more households. Only  facilities that are not shared or not public are considered improved
|0
|
|
|-
|urban
|Sanitation
|Limited service
|
|
|Coverage
|WSSJMPSanitationUrban%Shared
|Proportion of Urban  population served with Shared Sanitation (%)
|Sanitation facilities  of an otherwise acceptable type shared between two or more households. Only  facilities that are not shared or not public are considered improved
|0
|
|
|}

Revision as of 19:41, 5 September 2024

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/household#!/table?geo0=region&geo1=sdg
  2. Use the web scrapping scripts to download the data. The scripts can be acssed here.
  3. The current website does NOT allow to download all the countries, Measure (Drinking Water and Sanitation), Inequality (Total, Rural, and Urban), and Time period (2000 - 2022) at once. Thus, the scripts seperate all the years to 3 groups and you will download 3 files for each Ladder Type (Analyse by Service level, Analyse by Facility type, and Analyse by Safely managed criteria).
  4. There are instructions on the scripts, please read it carfully and modify the scripts according different situations. (different most recent year or missing years)
  5. Make sure you have download all the years in case the scripts don't wait for enough time for the website loads the data.
  6. The scripts also contain the code for importing data into IFs.

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.

SourceWater supply 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

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

Residence Type Service Type Service level Facility type Safely managed element Column Variable Definition Extended Source Defn UsedInPreprocessor UsedInPreprocessorFileName Formula
rural Drinking water At least basic Coverage WSSJMPWaterRural%AtLeastBasic Proportion of Rural population served with at least basic drinking water (%) 0
total Drinking water At least basic Coverage WSSJMPWaterTotal%AtLeastBasic Proportion of Total population served with at least basic drinking water (%) 0
urban Drinking water At least basic Coverage WSSJMPWaterUrban%AtLeastBasic Proportion of Urban population served with at least basic drinking water (%) 0
rural Drinking water At least basis - Limited service Coverage WSSJMPWaterRural%Basic Proportion of Rural population served with at least basic and not shared with others (%) Use of improved facilities which are not shared with other households 0
total Drinking water At least basis - Limited service Coverage WSSJMPWaterTotal%Basic Proportion of total population served with at least basic and not shared with others (%) Use of improved facilities which are not shared with other households 0
urban Drinking water At least basis - Limited service Coverage WSSJMPWaterUrban%Basic Proportion of Urban population served with at least basic and not shared with others (%) Use of improved facilities which are not shared with other households 0
rural Drinking water Limited service Coverage WSSJMPWaterRural%Limited Proportion of Rural population served with limited drinking water (%) Drinking water from an improved source for which collection time exceeds 30 minutes for a roundtrip including queuing 0
total Drinking water Limited service Coverage WSSJMPWaterTotal%Limited Proportion of Total population served with limited drinking water (%) Drinking water from an improved source for which collection time exceeds 30 minutes for a roundtrip including queuing 0
urban Drinking water Limited service Coverage WSSJMPWaterUrban%Limited Proportion of Urban population served with limited drinking water (%) Drinking water from an improved source for which collection time exceeds 30 minutes for a roundtrip including queuing 0
rural Drinking water Safely managed service Coverage WSSJMPWaterRural%SafelyManaged Proportion of Rural population served with safely managed drinking water (%) From an improved water source that is accessible on premises, available when needed and free from faecal and priority chemical contamination 0
total Drinking water Safely managed service Coverage WSSJMPWaterTotal%SafelyManaged Proportion of Total population served with safely managed drinking water (%) From an improved water source that is accessible on premises, available when needed and free from faecal and priority chemical contamination 0
urban Drinking water Safely managed service Coverage WSSJMPWaterUrban%SafelyManaged Proportion of Urban population served with safely managed drinking water (%) From an improved water source that is accessible on premises, available when needed and free from faecal and priority chemical contamination 0
rural Drinking water Surface and Unimproved Coverage WSSJMPWaterRural%Unimproved Proportion of Rural population served with unimproved drinking water (%). Total Unimproved Water is the sum of Surface and Unimproved water access. Unimproved drinking water sources/surface drinking water sources 0
rural Drinking water Surface and Unimproved Population WSSJMPWaterRuralPopUnimproved Rural population served with Unimproved Water. Total Unimproved Water is the sum of Surface and Unimproved water access. Unimproved drinking water sources/surface drinking water sources 0 /1000
total Drinking water Surface and Unimproved Coverage WSSJMPWaterTotal%Unimproved Proportion of Total population served with unimproved drinking water (%). Total Unimproved Water is the sum of Surface and Unimproved water access. Unimproved drinking water sources/surface drinking water sources 0
total Drinking water Surface and Unimproved Population WSSJMPWaterTotalPopUnimproved Proportion of total population served with Unimproved Water (%). Total Unimproved Water is the sum of Surface and Unimproved water access. Unimproved drinking water sources/surface drinking water sources 0 /1000
urban Drinking water Surface and Unimproved Coverage WSSJMPWaterUrban%Unimproved Proportion of Urban population served with unimproved drinking water (%). Total Unimproved Water is the sum of Surface and Unimproved water access. Unimproved drinking water sources/surface drinking water sources 0
urban Drinking water Surface and Unimproved Population WSSJMPWaterUrbanPopUnimproved Urban population served with Unimproved Water. Total Unimproved Water is the sum of Surface and Unimproved water access. Unimproved drinking water sources/surface drinking water sources 0 /1000
rural Drinking water Surface water Coverage WSSJMPWaterRural%Surface Proportion of Rural population served with surface drinking water (%) Drinking water directly from a river, dam, lake, pond, stream, canal or irrigation canal 0
rural Drinking water Surface water Population WSSJMPWaterRuralPopSurface Rural population with Surface Water Drinking water directly from a river, dam, lake, pond, stream, canal or irrigation canal 0 /1000
total Drinking water Surface water Coverage WSSJMPWaterTotal%Surface Proportion of Total population served with surface drinking water (%) Drinking water directly from a river, dam, lake, pond, stream, canal or irrigation canal 1 ECONOMY, INFRASTRUCTURE
total Drinking water Surface water Population WSSJMPWaterTotalPopSurface Total population with Surface Water Drinking water directly from a river, dam, lake, pond, stream, canal or irrigation canal 0 /1000
urban Drinking water Surface water Coverage WSSJMPWaterUrban%Surface Proportion of Urban population served with surface drinking water (%) Drinking water directly from a river, dam, lake, pond, stream, canal or irrigation canal 0
urban Drinking water Surface water Population WSSJMPWaterUrbanPopSurface Urban population with Surface Water Drinking water directly from a river, dam, lake, pond, stream, canal or irrigation canal 0 /1000
rural Drinking water Unimproved Coverage WSSJMPWaterRural%OtherUnimproved Proportion of Rural population with Unimproved Water (%) Unprotected dug well, unprotected spring, cart with small tank/drum, tanker truck, bottled water (Bottled water is considered 'improved' for drinking only when the household used an improved source for cooking and personal hygiene) 0
rural Drinking water Unimproved Population WSSJMPWaterRuralPopOtherUnimproved Rural population with Unimproved Water Unprotected dug well, unprotected spring, cart with small tank/drum, tanker truck, bottled water (Bottled water is considered 'improved' for drinking only when the household used an improved source for cooking and personal hygiene) 0 /1000
total Drinking water Unimproved Coverage WSSJMPWaterTotal%OtherUnimproved Proportion of Total population with Unimproved Water (%) Unprotected dug well, unprotected spring, cart with small tank/drum, tanker truck, bottled water (Bottled water is considered 'improved' for drinking only when the household used an improved source for cooking and personal hygiene) 1 ECONOMY, INFRASTRUCTURE
total Drinking water Unimproved Population WSSJMPWaterTotalPopOtherUnimproved Total population served with Unimproved Water Unprotected dug well, unprotected spring, cart with small tank/drum, tanker truck, bottled water (Bottled water is considered 'improved' for drinking only when the household used an improved source for cooking and personal hygiene) 0 /1000
urban Drinking water Unimproved Coverage WSSJMPWaterUrban%OtherUnimproved Proportion of Urban population with Unimproved Water (%) Unprotected dug well, unprotected spring, cart with small tank/drum, tanker truck, bottled water (Bottled water is considered 'improved' for drinking only when the household used an improved source for cooking and personal hygiene) 0
urban Drinking water Unimproved Population WSSJMPWaterUrbanPopOtherUnimproved Urban population with Unimproved Water Unprotected dug well, unprotected spring, cart with small tank/drum, tanker truck, bottled water (Bottled water is considered 'improved' for drinking only when the household used an improved source for cooking and personal hygiene) 0 /1000
rural Drinking water Non-piped improved and Improved latrine and other Coverage WSSJMPWaterRural%OtherImproved Proportion of Rural population served with Other Improved Water (%). Total Other Improved Water is the sum of Non-piped improved and Improved latrine and other. Public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, rainwater collection 0
rural Drinking water Non-piped improved and Improved latrine and other Population WSSJMPWaterRuralPopOtherImproved Rural population served with Other Improved Water. Total Other Improved Water is the sum of Non-piped improved and Improved latrine and other. Public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, rainwater collection 0 /1000
total Drinking water Non-piped improved and Improved latrine and other Coverage WSSJMPWaterTotal%OtherImproved Proportion of Total population served with Other Improved Water (%). Total Other Improved Water is the sum of Non-piped improved and Improved latrine and other. Public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, rainwater collection 1 INFRASTRUCTURE
total Drinking water Non-piped improved and Improved latrine and other Population WSSJMPWaterTotalPopOtherImproved Total population served with Other Improved Water. Total Other Improved Water is the sum of Non-piped improved and Improved latrine and other. Public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, rainwater collection 0 /1000
urban Drinking water Non-piped improved and Improved latrine and other Coverage WSSJMPWaterUrban%OtherImproved Proportion of Urban population served with Other Improved Water (%). Total Other Improved Water is the sum of Non-piped improved and Improved latrine and other. Public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, rainwater collection 0
urban Drinking water Non-piped improved and Improved latrine and other Population WSSJMPWaterUrbanPopOtherImproved Urban population served with Other Improved Water. Total Other Improved Water is the sum of Non-piped improved and Improved latrine and other. Public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, rainwater collection 0 /1000
rural Drinking water Non-piped improved, Improved latrine and other, Piped improved, Septic tank, and Sewer Coverage WSSJMPWaterRural%Improved Proportion of Rural population served with Improved Water (%). Total Improved Water is the sum of Non-piped improved,Improved latrine and other, Piped improved, Septic tank, and Sewer. Piped water on premises/other improved drinking water 0
rural Drinking water Non-piped improved, Improved latrine and other, Piped improved, Septic tank, and Sewer Population WSSJMPWaterRuralPopImproved Rural population served with Improved Water. Total Improved Water is the sum of Non-piped improved,Improved latrine and other, Piped improved, Septic tank, and Sewer. Piped water on premises/other improved drinking water 0 /1000
total Drinking water Non-piped improved, Improved latrine and other, Piped improved, Septic tank, and Sewer Coverage WSSJMPWaterTotal%Improved Proportion of Total population served with Improved Water. (%) Total Improved Water is the sum of Non-piped improved,Improved latrine and other, Piped improved, Septic tank, and Sewer. Piped water on premises/other improved drinking water 0
total Drinking water Non-piped improved, Improved latrine and other, Piped improved, Septic tank, and Sewer Population WSSJMPWaterTotalPopImproved Total population served with Improved Water Total Improved Water is the sum of Non-piped improved,Improved latrine and other, Piped improved, Septic tank, and Sewer. Piped water on premises/other improved drinking water 0 /1000
urban Drinking water Non-piped improved, Improved latrine and other, Piped improved, Septic tank, and Sewer Coverage WSSJMPWaterUrban%Improved Proportion of Urban population served with Improved Water (%). Total Improved Water is the sum of Non-piped improved,Improved latrine and other, Piped improved, Septic tank, and Sewer. Piped water on premises/other improved drinking water 0
urban Drinking water Non-piped improved, Improved latrine and other, Piped improved, Septic tank, and Sewer Population WSSJMPWaterUrbanPopImproved Urban population served with Improved Water. Total Improved Water is the sum of Non-piped improved,Improved latrine and other, Piped improved, Septic tank, and Sewer. Piped water on premises/other improved drinking water 0 /1000
rural Drinking water Piped improved Coverage WSSJMPWaterRural%Piped Proportion of Rural population served with Piped Water (%) Piped household water connection located inside the user's dwelling, plot or yard 0
rural Drinking water Piped improved Population WSSJMPWaterRuralPopPiped Rural population served with Piped Water Piped household water connection located inside the user's dwelling, plot or yard 0 /1000
total Drinking water Piped improved Coverage WSSJMPWaterTotal%Piped Proportion of Total population served with Piped Water (%) Piped household water connection located inside the user's dwelling, plot or yard 1 INFRASTRUCTURE
total Drinking water Piped improved Population WSSJMPWaterTotalPopPiped Total population served with Piped Water Piped household water connection located inside the user's dwelling, plot or yard 0 /1000
urban Drinking water Piped improved Coverage WSSJMPWaterUrban%Piped Proportion of Urban population served with Piped Water (%) Piped household water connection located inside the user's dwelling, plot or yard 0
urban Drinking water Piped improved Population WSSJMPWaterUrbanPopPiped Urban population served with Piped Water Piped household water connection located inside the user's dwelling, plot or yard 0 /1000
rural Drinking water Available Coverage WSSJMPWaterRural%SMAsNeeded Proportion of Rural population served with available when needed improved drinking water (%) From an improved water source that is vailable when needed 0
total Drinking water Available Coverage WSSJMPWaterTotal%SMAsNeeded Proportion of Total population served with available when needed improved drinking water (%) From an improved water source that is vailable when needed 0
urban Drinking water Available Coverage WSSJMPWaterUrban%SMAsNeeded Proportion of Urban population served with available when needed improved drinking water (%) From an improved water source that is vailable when needed 0
rural Drinking water Free from contamination Coverage WSSJMPWaterRural%SMNotContam Proportion of Rural population served with free from contamination improved drinking water (%) From an improved water source that is free from faecal and priority chemical contamination 0
total Drinking water Free from contamination Coverage WSSJMPWaterTotal%SMNotContam Proportion of Total population served with free from contamination improved drinking water (%) From an improved water source that is free from faecal and priority chemical contamination 0
urban Drinking water Free from contamination Coverage WSSJMPWaterUrban%SMNotContam Proportion of Urban population served with free from contamination improved drinking water (%) From an improved water source that is free from faecal and priority chemical contamination 0
rural Drinking water On premises Coverage WSSJMPWaterRural%SMOnPremise Proportion of Rural population served with accessible on premises improved drinking water (%) From an improved water source that is accessible on premises 0
total Drinking water On premises Coverage WSSJMPWaterTotal%SMOnPremise Proportion of Total population served with accessible on premises improved drinking water (%) From an improved water source that is accessible on premises 0
urban Drinking water On premises Coverage WSSJMPWaterUrban%SMOnPremise Proportion of Urban population served with accessible on premises improved drinking water (%) From an improved water source that is accessible on premises 0

Issues in the data and their resolution:

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.

SourceSanitation 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

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

  1. WSSJMPSanitationTotal%Improved- Describes the proportion of the total population served with improved sanitation (%). Sum of National Latrines, Septic Tanks, Sewer Connections.
  2. WSSJMPSanitationTotal%Unimproved- Describes the proportion of the total population served with Unimproved Sanitation (%). Total Unimproved Sanitation is the sum of Open Defecation, Other Unimproved, and Shared sanitation access.
  3. WSSJMPSanitationTotal%OtherUnimproved- Describes the proportion of the total population with Other Unimproved Sanitation (%). National Unimproved
  4. WSSJMPSanitationTotal%Shared- Describes the proportion of the total population served with Shared Sanitation (%). National Limited (shared)
  5. WSSJMPSanitationTotal%OpenDefecation- Describes the proportion of the total population served with Open Defecation Sanitation (%). National Open Defecation
  6. WSSJMPSanitationUrban%Improved- Describes the proportion of the urban population served with Improved Sanitation (%). Sum of National Latrines, Septic Tanks, Sewer Connections.
  7. WSSJMPSanitationUrban%Unimproved- Describes the proportion of the urban population served with Unimproved Sanitation (%). Urban Unimproved Sanitation is the sum of Open Defecation, Other Unimproved, and Shared sanitation access.
  8. WSSJMPSanitationUrban%OtherUnimproved- Describes the proportion of the urban population with Other Unimproved Sanitation (%). National Unimproved
  9. WSSJMPSanitationUrban%Shared- Describes the proportion of the urban population served with Shared Sanitation (%). National Limited (shared)
  10. WSSJMPSanitationUrban%OpenDefecation- Describes the proportion of the urban population served with Open Defecation Sanitation (%). National Open Defecation
  11. WSSJMPSanitationRural%Improved- Describes the proportion of the rural population served with Improved Sanitation (%). Sum of National Latrines, Septic Tanks, Sewer Connections.
  12. WSSJMPSanitationRural%Unimproved- Describes the proportion of the rural population served with Unimproved Sanitation (%). Rural Unimproved Sanitation is the sum of Open Defecation, Other Unimproved, and Shared sanitation access.
  13. WSSJMPSanitationRural%OtherUnimproved- Describes the proportion of the rural population with Other Unimproved Sanitation (%). National Unimproved
  14. WSSJMPSanitationRural%Shared- Describes the proportion of the rural population served with Shared Sanitation (%). National Limited (shared)
  15. WSSJMPSanitationRural%OpenDefecation- Describes the proportion of the rural population served with Open Defecation Sanitation (%). National Open Defecation
  16. WSSJMPSanitationTotalPopImproved- Describes the total population served with Improved Sanitation. Calculated by the population*(Sum of Latrines, Septic Tanks, Sewer Connections/100).
  17. WSSJMPSanitationTotalPopUnimproved- Describes the total population served with Unimproved Sanitation. Total Unimproved Sanitation is the sum of Open Defecation, Other Unimproved, and Shared sanitation access.
  18. WSSJMPSanitationTotalPopOtherUnimproved- Describes the total population with Other Unimproved Sanitation. Calculated by the population*(National Unimproved/100).
  19. WSSJMPSanitationTotalPopShared- Describes the total population served with Shared Sanitation. Calculated by the population*(National Limited (shared)/100).
  20. WSSJMPSanitationTotalPopOpenDefecation- Describes the total population served with Open Defecation Sanitation. Calculated by the population*(National Open Defecation/100)
  21. WSSJMPSanitationUrbanPopImproved- Describes the urban population served with Improved Sanitation. Calculated by the population*(Urban Pop/100)*(Sum of Latrines, Septic Tanks, Sewer Connections/100)
  22. WSSJMPSanitationUrbanPopUnimproved- Describes the urban population served with Unimproved Sanitation. Urban Unimproved Sanitation is the sum of Open Defecation, Other Unimproved, and Shared sanitation access.
  23. WSSJMPSanitationUrbanPopOtherUnimproved- Describes the urban population with Other Unimproved Sanitation. Calculated by the population*(Urban Pop/100)*(Urban Unimproved).
  24. WSSJMPSanitationUrbanPopShared- Describes the urban population served with Shared Sanitation. Calculated by the population*(Urban Pop/100)*(Urban Limited (shared)/100).
  25. WSSJMPSanitationUrbanPopOpenDefecation- Describes the urban population served with Open Defecation Sanitation. Calculated by the population*(Urban Pop/100)*(Urban Open Defecation/100).
  26. WSSJMPSanitationRuralPopImproved- Describes the rural population served with Improved Sanitation. Calculated by the population*(100-Urban Pop)*(Sum of Latrines, Septic Tanks, Sewer Connections / 100).
  27. WSSJMPSanitationRuralPopUnimproved- Describes the rural population served with Unimproved Sanitation. Rural Unimproved Sanitation is the sum of Open Defecation, Other Unimproved, and Shared sanitation access.
  28. WSSJMPSanitationRuralPopOtherUnimproved- Describes the rural population with Other Unimproved Sanitation, Calculated by the population*(100-Urban Pop/100)*(Rural Unimproved/100).
  29. WSSJMPSanitationRuralPopShared- Describes the rural population served with Shared Sanitation. Calculated by the population*(100-Urban Pop/100)*(Rural Limited (shared)/100).
  30. WSSJMPSanitationRuralPopOpenDefecation- Describes the rural population served with Open Defecation Sanitation. Calculated by the population*(100-Urban Pop/100)*(Rural Open Defecation/100)
Residence Type Service Type Service level Facility type Safely managed element Column Variable Definition Extended Source Defn UsedInPreprocessor UsedInPreprocessorFileName Formula
rural Sanitation At least basic Coverage WSSJMPSanitationRural%AtLeastBasic Proportion of Rural population served with at least basic facilities (%) 0
total Sanitation At least basic Coverage WSSJMPSanitationTotal%AtLeastBasic Proportion of Total population served with at least basic facilities (%) 0
urban Sanitation At least basic Coverage WSSJMPSanitationUrban%AtLeastBasic Proportion of Urban population served with at least basic facilities (%) 0
rural Sanitation At least basis - Limited service Coverage WSSJMPSanitationRural%Basic Proportion of Rural population served with at least basic and not shared with others (%) Use of improved facilities which are not shared with other households 0
total Sanitation At least basis - Limited service Coverage WSSJMPSanitationTotal%Basic Proportion of total population served with at least basic and not shared with others (%) Use of improved facilities which are not shared with other households 0
urban Sanitation At least basis - Limited service Coverage WSSJMPSanitationUrban%Basic Proportion of Urban population served with at least basic and not shared with others (%) Use of improved facilities which are not shared with other households 0
rural Sanitation Limited service Coverage WSSJMPSanitationRural%Limited Proportion of Rural population served with limited facilities (%) Sanitation facilities of an otherwise acceptable type shared between two or more households. Only facilities that are not shared or not public are considered improved 0
rural Sanitation Limited service Coverage WSSJMPSanitationRural%Shared Proportion of Rural population served with Shared Sanitation (%) Sanitation facilities of an otherwise acceptable type shared between two or more households. Only facilities that are not shared or not public are considered improved 0
rural Sanitation Limited service Population WSSJMPSanitationRuralPopShared Rural population served with Shared Sanitation Sanitation facilities of an otherwise acceptable type shared between two or more households. Only facilities that are not shared or not public are considered improved 0 /1000
total Sanitation Limited service Coverage WSSJMPSanitationTotal%Limited Proportion of Total population served with limited facilities (%) Sanitation facilities of an otherwise acceptable type shared between two or more households. Only facilities that are not shared or not public are considered improved 0
total Sanitation Limited service Coverage WSSJMPSanitationTotal%Shared Proportion of Total population served with Shared Sanitation (%) Sanitation facilities of an otherwise acceptable type shared between two or more households. Only facilities that are not shared or not public are considered improved 1 INFRASTRUCTURE
total Sanitation Limited service Population WSSJMPSanitationTotalPopShared Total population served with Shared Sanitation Sanitation facilities of an otherwise acceptable type shared between two or more households. Only facilities that are not shared or not public are considered improved 0 /1000
urban Sanitation Limited service Coverage WSSJMPSanitationUrban%Limited Proportion of Urban population served with limited facilities (%) Sanitation facilities of an otherwise acceptable type shared between two or more households. Only facilities that are not shared or not public are considered improved 0
urban Sanitation Limited service Coverage WSSJMPSanitationUrban%Shared Proportion of Urban population served with Shared Sanitation (%) Sanitation facilities of an otherwise acceptable type shared between two or more households. Only facilities that are not shared or not public are considered improved 0
urban Sanitation Limited service Population WSSJMPSanitationUrbanPopShared Urban population served with Shared Sanitation Sanitation facilities of an otherwise acceptable type shared between two or more households. Only facilities that are not shared or not public are considered improved 0 /1000
rural Sanitation Open defecation Coverage WSSJMPSanitationRural%OpenDefecation Proportion of Rural population served with open defecation facilities (%) Disposal of human faeces in fields, forests, bushes, open bodies of water, beaches and other open spaces or with solid waste 0
rural Sanitation Open defecation Population WSSJMPSanitationRuralPopOpenDefecation Rural population served with Open Defecation Sanitation Disposal of human faeces in fields, forests, bushes, open bodies of water, beaches and other open spaces or with solid waste 0 /1000
total Sanitation Open defecation Coverage WSSJMPSanitationTotal%OpenDefecation Proportion of Total population served with open defecation facilities (%) Disposal of human faeces in fields, forests, bushes, open bodies of water, beaches and other open spaces or with solid waste 1 ECONOMY, INFRASTRUCTURE
total Sanitation Open defecation Population WSSJMPSanitationTotalPopOpenDefecation Total population served with Open Defecation Sanitation Disposal of human faeces in fields, forests, bushes, open bodies of water, beaches and other open spaces or with solid waste 0 /1000
urban Sanitation Open defecation Coverage WSSJMPSanitationUrban%OpenDefecation Proportion of Urban population served with open defecation facilities (%) Disposal of human faeces in fields, forests, bushes, open bodies of water, beaches and other open spaces or with solid waste 0
urban Sanitation Open defecation Population WSSJMPSanitationUrbanPopOpenDefecation Urban population served with Open Defecation Sanitation Disposal of human faeces in fields, forests, bushes, open bodies of water, beaches and other open spaces or with solid waste 0 /1000
rural Sanitation Open Defecation, Unimproved, and Limited service Coverage WSSJMPSanitationRural%Unimproved Proportion of Rural population served with unimproved facilities (%) Total Unimproved Sanitation is the sum of Open Defecation, Other Unimproved, and Shared sanitation access. Use of pit latrines without a slab or platform, hanging latrines or bucket latrines 0
rural Sanitation Open Defecation, Unimproved, and Limited service Population WSSJMPSanitationRuralPopUnimproved Rural population served with Unimproved Sanitation. Total Unimproved Sanitation is the sum of Open Defecation, Other Unimproved, and Shared sanitation access. do not ensure hygenic separation of human excreta from human contact. Unimproved facilities include pit latrines without a slab or platform, hanging latrines or bucket latrines 0 /1000
total Sanitation Open Defecation, Unimproved, and Limited service Coverage WSSJMPSanitationTotal%Unimproved Proportion of Total population served with unimproved facilities (%) Total Unimproved Sanitation is the sum of Open Defecation, Other Unimproved, and Shared sanitation access. Use of pit latrines without a slab or platform, hanging latrines or bucket latrines 0
total Sanitation Open Defecation, Unimproved, and Limited service Population WSSJMPSanitationTotalPopUnimproved Total population served with Unimproved Sanitation. Total Unimproved Sanitation is the sum of Open Defecation, Other Unimproved, and Shared sanitation access. do not ensure hygenic separation of human excreta from human contact. Unimproved facilities include pit latrines without a slab or platform, hanging latrines or bucket latrines 0 /1000
urban Sanitation Open Defecation, Unimproved, and Limited service Coverage WSSJMPSanitationUrban%Unimproved Proportion of Urban population served with unimproved facilities (%) Total Unimproved Sanitation is the sum of Open Defecation, Other Unimproved, and Shared sanitation access. Use of pit latrines without a slab or platform, hanging latrines or bucket latrines 0
urban Sanitation Open Defecation, Unimproved, and Limited service Population WSSJMPSanitationUrbanPopUnimproved Urban population served with Unimproved Sanitation. Total Unimproved Sanitation is the sum of Open Defecation, Other Unimproved, and Shared sanitation access. do not ensure hygenic separation of human excreta from human contact. Unimproved facilities include pit latrines without a slab or platform, hanging latrines or bucket latrines 0 /1000
rural Sanitation Safely managed service Coverage WSSJMPSanitationRural%SafelyManaged Proportion of Rural population served with safely managed facilities (%) Use of improved facilities that are not shared with other households and where excreta are safely disposed of in situ or removed and treated offsite 0
total Sanitation Safely managed service Coverage WSSJMPSanitationTotal%SafelyManaged Proportion of Total population served with safely managed facilities (%) Use of improved facilities that are not shared with other households and where excreta are safely disposed of in situ or removed and treated offsite 0
urban Sanitation Safely managed service Coverage WSSJMPSanitationUrban%SafelyManaged Proportion of Urban population served with safely managed facilities (%) Use of improved facilities that are not shared with other households and where excreta are safely disposed of in situ or removed and treated offsite 0
rural Sanitation Unimproved Coverage WSSJMPSanitationRural%OtherUnimproved Proportion of Rural population with Unimproved Sanitation (%) do not ensure hygenic separation of human excreta from human contact. Unimproved facilities include pit latrines without a slab or platform, hanging latrines or bucket latrines 0
rural Sanitation Unimproved Population WSSJMPSanitationRuralPopOtherUnimproved Rural population with Unimproved Sanitation do not ensure hygenic separation of human excreta from human contact. Unimproved facilities include pit latrines without a slab or platform, hanging latrines or bucket latrines 0 /1000
total Sanitation Unimproved Coverage WSSJMPSanitationTotal%OtherUnimproved Proportion of Total population with Unimproved Sanitation (%) do not ensure hygenic separation of human excreta from human contact. Unimproved facilities include pit latrines without a slab or platform, hanging latrines or bucket latrines 1 ECONOMY, INFRASTRUCTURE
total Sanitation Unimproved Population WSSJMPSanitationTotalPopOtherUnimproved Total population with Unimproved Sanitation do not ensure hygenic separation of human excreta from human contact. Unimproved facilities include pit latrines without a slab or platform, hanging latrines or bucket latrines 0 /1000
urban Sanitation Unimproved Coverage WSSJMPSanitationUrban%OtherUnimproved Proportion of Urban population with Unimproved Sanitation (%) do not ensure hygenic separation of human excreta from human contact. Unimproved facilities include pit latrines without a slab or platform, hanging latrines or bucket latrines 0
urban Sanitation Unimproved Population WSSJMPSanitationUrbanPopOtherUnimproved Urban population with Unimproved Sanitation do not ensure hygenic separation of human excreta from human contact. Unimproved facilities include pit latrines without a slab or platform, hanging latrines or bucket latrines 0 /1000
rural Sanitation Non-piped improved, Improved latrine and other, Piped improved, Septic tank, and Sewer Coverage WSSJMPSanitationRural%Improved Proportion of Rural population served with Improved Sanitation (%). Total Improved Sanitation is the sum of Non-piped improved,Improved latrine and other, Piped improved, Septic tank, and Sewer. Likely to ensure hygenic separation of human excreta from human contact. They include: 1) Flush/pour flush to (piped sewer system septic tank or pit latrine) 2) Ventilated improved pit (VIP) latrine 3) Pit latrine with slab 4) Composing toilet 0
rural Sanitation Non-piped improved, Improved latrine and other, Piped improved, Septic tank, and Sewer Population WSSJMPSanitationRuralPopImproved Rural population served with Improved Sanitation. Total Improved Sanitation is the sum of Non-piped improved,Improved latrine and other, Piped improved, Septic tank, and Sewer. Likely to ensure hygenic separation of human excreta from human contact. They include: 1) Flush/pour flush to (piped sewer system septic tank or pit latrine) 2) Ventilated improved pit (VIP) latrine 3) Pit latrine with slab 4) Composing toilet 0 /1000
total Sanitation Non-piped improved, Improved latrine and other, Piped improved, Septic tank, and Sewer Coverage WSSJMPSanitationTotal%Improved Proportion of Total population served with Improved Sanitation (%). Total Improved Sanitation is the sum of Non-piped improved,Improved latrine and other, Piped improved, Septic tank, and Sewer. Likely to ensure hygenic separation of human excreta from human contact. They include: 1) Flush/pour flush to (piped sewer system septic tank or pit latrine) 2) Ventilated improved pit (VIP) latrine 3) Pit latrine with slab 4) Composing toilet 1 INFRASTRUCTURE
total Sanitation Non-piped improved, Improved latrine and other, Piped improved, Septic tank, and Sewer Population WSSJMPSanitationTotalPopImproved Total population served with Improved Sanitation. Total Improved Sanitation is the sum of Non-piped improved,Improved latrine and other, Piped improved, Septic tank, and Sewer. Likely to ensure hygenic separation of human excreta from human contact. They include: 1) Flush/pour flush to (piped sewer system septic tank or pit latrine) 2) Ventilated improved pit (VIP) latrine 3) Pit latrine with slab 4) Composing toilet 0 /1000
urban Sanitation Non-piped improved, Improved latrine and other, Piped improved, Septic tank, and Sewer Coverage WSSJMPSanitationUrban%Improved Proportion of Urban population served with Improved Sanitation (%). Total Improved Sanitation is the sum of Non-piped improved,Improved latrine and other, Piped improved, Septic tank, and Sewer. Likely to ensure hygenic separation of human excreta from human contact. They include: 1) Flush/pour flush to (piped sewer system septic tank or pit latrine) 2) Ventilated improved pit (VIP) latrine 3) Pit latrine with slab 4) Composing toilet 0
urban Sanitation Non-piped improved, Improved latrine and other, Piped improved, Septic tank, and Sewer Population WSSJMPSanitationUrbanPopImproved Urban population served with Improved Sanitation. Total Improved Sanitation is the sum of Non-piped improved,Improved latrine and other, Piped improved, Septic tank, and Sewer. Likely to ensure hygenic separation of human excreta from human contact. They include: 1) Flush/pour flush to (piped sewer system septic tank or pit latrine) 2) Ventilated improved pit (VIP) latrine 3) Pit latrine with slab 4) Composing toilet 0 /1000
rural Sanitation Disposed insitu Coverage WSSJMPSanitationRural%SMDisposedInsitu Proportion of Rural population served with safely managed facilities (%) that are disposed in situ Safely managed = disposed in situ + emptied and treated + wastewater and treated 0
total Sanitation Disposed insitu Coverage WSSJMPSanitationTotal%SMDisposedInsitu Proportion of Total population served with safely managed facilities (%) that are disposed in situ Safely managed = disposed in situ + emptied and treated + wastewater and treated 0
urban Sanitation Disposed insitu Coverage WSSJMPSanitationUrban%SMDisposedInsitu Proportion of Urban population served with safely managed facilities (%) that are disposed in situ Safely managed = disposed in situ + emptied and treated + wastewater and treated 0
rural Sanitation Faecal sludge treated Coverage WSSJMPSanitationRural%SMEmpTreated Proportion of Rural population served with safely managed facilities (%) that are emptied and treated Safely managed = disposed in situ + emptied and treated + wastewater and treated 0
total Sanitation Faecal sludge treated Coverage WSSJMPSanitationTotal%SMEmpTreated Proportion of Total population served with safely managed facilities (%) that are emptied and treated Safely managed = disposed in situ + emptied and treated + wastewater and treated 0
urban Sanitation Faecal sludge treated Coverage WSSJMPSanitationUrban%SMEmpTreated Proportion of Urban population served with safely managed facilities (%) that are emptied and treated Safely managed = disposed in situ + emptied and treated + wastewater and treated 0
rural Sanitation Sewage treated Coverage WSSJMPSanitationRural%SMWastewaterTreated Proportion of Rural population served with safely managed facilities (%) that are wastewater treated Safely managed = disposed in situ + emptied and treated + wastewater and treated 0
total Sanitation Sewage treated Coverage WSSJMPSanitationTotal%SMWastewaterTreated Proportion of Total population served with safely managed facilities (%) that are wastewater treated Safely managed = disposed in situ + emptied and treated + wastewater and treated 0
urban Sanitation Sewage treated Coverage WSSJMPSanitationUrban%SMWastewaterTreated Proportion of Urban population served with safely managed facilities (%) that are wastewater treated Safely managed = disposed in situ + emptied and treated + wastewater and treated 0

Issues in the data and their resolution:

The 3 groups of series below are duplicated: "Shared" is "Limited service".

Residence Type Service Type Service level Facility type Safely managed element Column Variable Definition Extended Source Defn UsedInPreprocessor UsedInPreprocessorFileName Formula
rural Sanitation Limited service Coverage WSSJMPSanitationRural%Limited Proportion of Rural population served with limited facilities (%) Sanitation facilities of an otherwise acceptable type shared between two or more households. Only facilities that are not shared or not public are considered improved 0
rural Sanitation Limited service Coverage WSSJMPSanitationRural%Shared Proportion of Rural population served with Shared Sanitation (%) Sanitation facilities of an otherwise acceptable type shared between two or more households. Only facilities that are not shared or not public are considered improved 0
total Sanitation Limited service Coverage WSSJMPSanitationTotal%Limited Proportion of Total population served with limited facilities (%) Sanitation facilities of an otherwise acceptable type shared between two or more households. Only facilities that are not shared or not public are considered improved 0
total Sanitation Limited service Coverage WSSJMPSanitationTotal%Shared Proportion of Total population served with Shared Sanitation (%) Sanitation facilities of an otherwise acceptable type shared between two or more households. Only facilities that are not shared or not public are considered improved 1 INFRASTRUCTURE
urban Sanitation Limited service Coverage WSSJMPSanitationUrban%Limited Proportion of Urban population served with limited facilities (%) Sanitation facilities of an otherwise acceptable type shared between two or more households. Only facilities that are not shared or not public are considered improved 0
urban Sanitation Limited service Coverage WSSJMPSanitationUrban%Shared Proportion of Urban population served with Shared Sanitation (%) Sanitation facilities of an otherwise acceptable type shared between two or more households. Only facilities that are not shared or not public are considered improved 0