Joint Monitoring Programme, WHO/UNICEF: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
 
(18 intermediate revisions by 3 users not shown)
Line 1: Line 1:
=== '''WHO/UNICEF Joint Monitoring Program: Water Supply and Sanitation''' ===
= Summary =
 
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 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.
Line 7: Line 6:
The most recent update was in Sept. 2024. There are 8 preprocessors and 100 non-preprocessors.
The most recent update was in Sept. 2024. There are 8 preprocessors and 100 non-preprocessors.


== '''Instructions on Downloading data''' ==
= Tables In IFs =
 
# Go to
#
 
== '''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.
 
'''<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>Types of Data</u>:&nbsp;'''The following categories of data need to be imported into IFs:
{| class="wikitable"
{| class="wikitable"
|Residence  Type
|+
|Service Type
!Variable
|Service level
!Defintion
|Facility type
!Ext Source Def
|Safely managed  element
!UsedInPreprocessor
|Column
!UsedInPreprocessorFileName
|Variable
!Code In Source
|Definition
|Extended Source Defn
|UsedInPreprocessor
|UsedInPreprocessorFileName
|Formula
|-
|-
|rural
|WSSJMPSanitationTotalPopImproved
|Drinking water
|Total population  served with Improved Sanitation
|At least basic
|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
|
|
|Coverage
|WSSJMPWaterRural%AtLeastBasic
|Proportion of Rural population served with at least basic drinking water (%)
|
|0
|0
|
|
|
|san_bas_n_pop
|-
|-
|total
|WSSJMPSanitationTotalPopOpenDefecation
|Drinking water
|Total population served with Open  Defecation Sanitation
|At least basic
|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
|
|
|Coverage
|WSSJMPWaterTotal%AtLeastBasic
|Proportion of Total population served with at least basic drinking water (%)
|
|0
|0
|
|
|
|san_od_n_pop
|-
|-
|urban
|WSSJMPSanitationTotalPopOtherUnimproved
|Drinking water
|Total population with Other Unimproved  Sanitation
|At least basic
|do not ensure hygenic separation of  human excreta from human contact. Unimproved facilities include pit latrines  without a slab or platfor, hanging latrines or bucket latrines
|
|
|Coverage
|WSSJMPWaterUrban%AtLeastBasic
|Proportion of Urban population served with at least basic drinking water (%)
|
|0
|0
|
|
|
|san_unimp_n_pop
|-
|-
|rural
|WSSJMPSanitationTotalPopShared
|Drinking water
|Total population served with Shared  Sanitation
|At least basis -  Limited service
|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
|
|
|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
|0
|
|
|
|san_lim_n_pop
|-
|-
|total
|WSSJMPSanitationTotalPopUnimproved
|Drinking water
|Total population served with Unimproved Sanitation. Total Unimproved Sanitation is the sum of Open Defecation, Other Unimproved, and Shared sanitation access.
|At least basis - Limited service
|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
|
|
|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
|0
|
|
|
|san_UnImp_n_pop
|-
|-
|urban
|WSSJMPWaterUrbanPopSurface
|Drinking water
|Urban population with Surface Water
|At least basis -  Limited service
|River, dam, lake, pond, stream, canal, irrigation channels.
|
|
|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
|0
|
|
|
|wat_sur_u_pop
|-
|-
|rural
|WSSJMPWaterUrbanPopImproved
|Drinking water
|Urban population served with Improved  Water
|Limited service
|Piped water on premises/other improved  drinking water
|
|
|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
|0
|
|
|
|wat_imp_u_pop
|-
|-
|total
|WSSJMPSanitationRuralPopImproved
|Drinking water
|Rural population served with Improved  Sanitation
|Limited service
|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
|
|
|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
|0
|
|
|
|san_bas_r_pop
|-
|-
|urban
|WSSJMPSanitationRuralPopOpenDefecation
|Drinking water
|Rural population served with Open  Defecation Sanitation
|Limited service
|when human feces are disposed of in  fields, forests, bushes, open bodies of water, beaches or other open spaces or disposed of with solid waste
|
|
|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
|0
|
|
|
|san_od_r_pop
|-
|-
|rural
|WSSJMPSanitationRuralPopOtherUnimproved
|Drinking water
|Rural population with Other Unimproved Sanitation
|Safely managed service
|do not ensure hygenic separation of  human excreta from human contact. Unimproved facilities include pit latrines without a slab or platfor, hanging latrines or bucket latrines
|
|
|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
|0
|
|
|
|san_unimp_r_pop
|-
|-
|total
|WSSJMPSanitationRuralPopShared
|Drinking water
|Rural population served with Shared  Sanitation
|Safely managed  service
|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
|
|
|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
|0
|
|
|
|san_lim_r_pop
|-
|-
|urban
|WSSJMPSanitationRuralPopUnimproved
|Drinking water
|Rural population served with Unimproved Sanitation. Total Unimproved Sanitation is the sum of Open Defecation, Other  Unimproved, and Shared sanitation access.
|Safely managed  service
|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
|
|
|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
|0
|
|
|
|san_UnImp_r_pop
|-
|-
|rural
|WSSJMPSanitationUrbanPopImproved
|Drinking water
|Urban population served with Improved Sanitation
|Surface and Unimproved
|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
|
|
|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
|0
|
|
|
|san_bas_u_pop
|-
|-
|rural
|WSSJMPSanitationUrbanPopOpenDefecation
|Drinking water
|Urban population served with Open Defecation Sanitation
|Surface and  Unimproved
|when human feces are disposed of in fields, forests, bushes, open bodies of water, beaches or other open spaces  or disposed of with solid waste
|
|
|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
|0
|
|
|/1000
|san_od_u_pop
|-
|-
|total
|WSSJMPSanitationUrbanPopOtherUnimproved
|Drinking water
|Urban population with Other Unimproved Sanitation
|Surface and Unimproved
|do not ensure hygenic separation of  human excreta from human contact. Unimproved facilities include pit latrines without a slab or platfor, hanging latrines or bucket latrines
|
|
|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
|0
|
|
|
|san_unimp_u_pop
|-
|-
|total
|WSSJMPWaterRuralPopImproved
|Drinking water
|Rural population served with Improved  Water
|Surface and  Unimproved
|Piped water on premises/other improved  drinking water
|
|
|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
|0
|
|
|/1000
|wat_imp_r_pop
|-
|-
|urban
|WSSJMPWaterRuralPopOtherImproved
|Drinking water
|Rural population served with Other  Improved Water
|Surface and  Unimproved
|Public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, rainwater collection
|
|
|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
|0
|
|
|
|wat_imp_r_pop - wat_pip_r_pop
|-
|-
|urban
|WSSJMPWaterRuralPopOtherUnimproved
|Drinking water
|Rural population with Other Unimproved Water
|Surface and  Unimproved
|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)
|
|
|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
|0
|
|
|
|wat_unimp_r_pop
|-
|-
|rural
|Drinking water
|Surface water
|
|
|Population
|WSSJMPWaterRuralPopSurface
|WSSJMPWaterRuralPopSurface
|Rural population with Surface Water
|Rural population with Surface Water
|Drinking water  directly from a river, dam, lake, pond, stream, canal or irrigation canal
|River, dam, lake, pond, stream, canal,  irrigation channels.
|0
|0
|
|
|/1000
|wat_sur_r_pop
|-
|-
|total
|WSSJMPWaterRuralPopUnimproved
|Drinking water
|Rural population served with Unimproved Water. Total Unimproved Water is the sum of Surface and Other Unimproved water access.
|Surface water
|Unimproved drinking water  sources/surface drinking water sources
|
|
|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
|0
|
|
|/1000
|wat_UnImp_r_pop
|-
|-
|urban
|WSSJMPWaterTotalPopOtherUnimproved
|Drinking water
|Total population served with Unimproved  Water
|Surface water
|Unimproved drinking water  sources/surface drinking water sources
|
|
|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
|0
|
|
|
|wat_unimp_n_pop
|-
|-
|urban
|WSSJMPWaterTotalPopPiped
|Drinking water
|Total population served with Piped Water
|Surface water
|Piped household water connection located inside the user's dwelling, plot or yard
|
|
|Population
|WSSJMPWaterUrbanPopSurface
|Urban population with Surface Water
|Drinking water  directly from a river, dam, lake, pond, stream, canal or irrigation canal
|0
|0
|
|
|/1000
|wat_pip_n_pop
|-
|-
|rural
|WSSJMPWaterTotalPopSurface
|Drinking water
|Total population with Surface Water
|Unimproved
|River, dam, lake, pond, stream, canal,  irrigation channels.
|
|
|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
|0
|
|
|
|wat_sur_n_pop
|-
|-
|rural
|WSSJMPWaterTotalPopUnimproved
|Drinking water
|Proportion of total population served  with Unimproved Water (%). Total Unimproved Water is the sum of Surface and Other Unimproved water access.
|Unimproved
|Unimproved drinking water sources/surface drinking water sources
|
|
|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
|0
|
|
|/1000
|wat_UnImp_n_pop
|-
|-
|total
|WSSJMPWaterUrban%Improved
|Drinking water
|Proportion of Urban population served with Improved Water (%)
|Unimproved
|Piped water on premises/other improved drinking water
|
|
|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
|0
|
|
|/1000
|wat_imp_u
|-
|-
|urban
|WSSJMPWaterUrbanPopOtherImproved
|Drinking water
|Urban population served with Other  Improved Water
|Unimproved
|Public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, rainwater collection
|
|
|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
|0
|
|
|
|wat_imp_u_pop - wat_pip_u_pop
|-
|-
|urban
|Drinking water
|Unimproved
|
|
|Population
|WSSJMPWaterUrbanPopOtherUnimproved
|WSSJMPWaterUrbanPopOtherUnimproved
|Urban population with  Unimproved Water
|Urban population with Other 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)
|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
|0
|
|
|/1000
|wat_unimp_u_pop
|-
|-
|rural
|WSSJMPWaterUrbanPopPiped
|Drinking water
|Urban population served with Piped Water
|
|Piped household water connection located inside the user's dwelling, plot or yard
|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
|0
|
|
|
|wat_pip_u_pop
|-
|-
|rural
|WSSJMPWaterUrbanPopUnimproved
|Drinking water
|Urban population served with Unimproved  Water. Total Unimproved Water is the sum of Surface and Other Unimproved water access.
|
|Unimproved drinking water sources/surface drinking water sources
|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
|0
|
|
|/1000
|wat_UnImp_u_pop
|-
|-
|total
|WSSJMPSanitationUrbanPopShared
|Drinking water
|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
|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
|0
|
|
|/1000
|san_lim_u_pop
|-
|-
|urban
|WSSJMPSanitationUrbanPopUnimproved
|Drinking water
|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
|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
|0
|
|
|
|san_UnImp_u_pop
|-
|-
|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
|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.
|Proportion of Rural population served with Improved Water (%)
|Piped water on premises/other improved drinking water
|Piped water on premises/other improved drinking water
|0
|0
|
|
|
|wat_imp_r
|-
|-
|rural
|WSSJMPWaterRuralPopPiped
|Drinking water
|Rural population served with Piped Water
|
|Piped household water connection located inside the user's dwelling, plot or yard
|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
|0
|
|
|/1000
|wat_pip_r_pop
|-
|-
|total
|Drinking water
|
|Non-piped improved,  Improved latrine and other, Piped improved, Septic tank, and Sewer
|
|Coverage
|WSSJMPWaterTotal%Improved
|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.
|Proportion of Total population served with Improved Water (%)
|Piped water on premises/other improved drinking water
|Piped water on premises/other improved drinking water
|0
|0
|
|
|
|wat_imp_n
|-
|-
|total
|Drinking water
|
|Non-piped improved,  Improved latrine and other, Piped improved, Septic tank, and Sewer
|
|Population
|WSSJMPWaterTotalPopImproved
|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.
|Total population served with Improved Water
|Piped water on premises/other improved drinking water
|Piped water on premises/other improved drinking water
|0
|0
|
|
|/1000
|wat_imp_n_pop
|-
|-
|urban
|WSSJMPWaterTotalPopOtherImproved
|Drinking water
|Total population served with Other  Improved Water
|Public taps or standpipes, tube wells or  boreholes, protected dug wells, protected springs, rainwater collection
|0
|
|
|Non-piped improved,  Improved latrine and other, Piped improved, Septic tank, and Sewer
|wat_imp_n_pop - wat_pip_n_pop
|
|-
|Coverage
|WSSJMPSanitationRural%AtLeastBasic
|WSSJMPWaterUrban%Improved
|Proportion of Rural population served with at least basic facilities (%)
|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.
|WSSJMPSanitationRural%SafelyManaged + WSSJMPSanitationRural%Basic
|Piped water on premises/other improved drinking water
|0
|0
|
|
|
|
|-
|-
|urban
|WSSJMPSanitationRural%Basic
|Drinking water
|Proportion of Rural population served  with basic but not safely managed facilities (%)
|
|Use of improved facilities which are not shared with other households
|Non-piped improved, Improved latrine and other, Piped improved, Septic tank, and Sewer
|0
|
|
|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
|WSSJMPSanitationRural%Improved
|Drinking water
|Proportion of Rural population served with improved facilities (%), 3-ladder system
|
|Improved facilities in the old 3-ladder system equals to At Least Basic in the new 5-ladder system
|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
|0
|
|
|
|
|-
|-
|rural
|WSSJMPSanitationRural%Limited
|Drinking water
|Proportion of Rural population served with limited facilities (%)
|
|Use of improved facilities shared between two or more households
|Piped improved
|
|Population
|WSSJMPWaterRuralPopPiped
|Rural population  served with Piped Water
|Piped household water connection located inside the user's dwelling, plot or yard
|0
|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
|WSSJMPSanitationRural%OpenDefecation
|Drinking water
|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
|Piped improved
|0
|
|
|Population
|WSSJMPWaterTotalPopPiped
|Total population  served with Piped Water
|Piped household water  connection located inside the user's dwelling, plot or yard
|0
|
|
|/1000
|-
|-
|urban
|WSSJMPSanitationRural%OtherUnimproved
|Drinking water
|Proportion of Rural population served with other unimproved facilities (%), 3-ladder system
|
|OtherUnimproved facilities in the old 3-ladder system equals to Unimproved in the new 5-ladder system
|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
|0
|
|
|
|
|-
|-
|urban
|WSSJMPSanitationRural%SafelyManaged
|Drinking water
|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
|
|
|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
|WSSJMPSanitationRural%Shared
|Drinking water
|Proportion of Rural population served with shared facilities (%), 3-ladder system
|
|Shared facilities in the old 3-ladder system equals to Limited in the new 5-ladder system
|
|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
|0
|
|
|
|
|-
|-
|total
|WSSJMPSanitationRural%SMDisposedInsitu
|Drinking water
|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
|
|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
|0
|
|
|
|
|-
|-
|urban
|WSSJMPSanitationRural%SMEmpTreated
|Drinking water
|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
|
|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
|0
|
|
|
|
|-
|-
|rural
|WSSJMPSanitationRural%SMWastewaterTreated
|Drinking water
|Proportion of Rural population served with safely managed facilities (%) that are wastewater treated
|
|Safely managed = disposed in situ + emptied and treated + wastewater and treated
|
|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
|0
|
|
|
|
|-
|-
|total
|WSSJMPSanitationRural%Unimproved
|Drinking water
|Proportion of Rural population served with unimproved facilities (%)
|
|Use of pit latrines without a slab or platform, hanging latrines or bucket latrines
|
|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
|0
|
|
|
|
|-
|-
|urban
|WSSJMPSanitationTotal%AtLeastBasic
|Drinking water
|Proportion of Total population served with at least basic facilities (%)
|
|WSSJMPSanitationTotal%SafelyManaged + WSSJMPSanitationTotal%Basic
|
|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
|0
|
|
|
|
|-
|-
|rural
|WSSJMPSanitationTotal%Basic
|Drinking water
|Proportion of total population served with basic but not safely managed facilities (%)
|
|Use of improved facilities which are not shared with other households
|
|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
|0
|
|
|
|
|-
|-
|total
|WSSJMPSanitationTotal%Improved
|Drinking water
|Proportion of Total population served  with improved facilities (%), 3-ladder system
|Improved facilities in the old 3-ladder  system equals to At Least Basic in the new 5-ladder system
|1
|INFRASTRUCTURE
|
|
|
|-
|On premises
|WSSJMPSanitationTotal%Limited
|Coverage
|Proportion of Total population served with limited facilities (%)
|WSSJMPWaterTotal%SMOnPremise
|Use of improved facilities shared between two or more households
|Proportion of Total population served with accessible on premises improved drinking water (%)
|From an improved  water source that is accessible on premises
|0
|0
|
|
|
|
|-
|-
|urban
|WSSJMPSanitationTotal%OpenDefecation
|Drinking water
|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
|
|
|-
|WSSJMPSanitationTotal%OtherUnimproved
|Proportion of Total population served  with other unimproved facilities (%), 3-ladder system
|OtherUnimproved facilities in the old  3-ladder system equals to Unimproved in the new 5-ladder system
|1
|ECONOMY, INFRASTRUCTURE
|
|
|On premises
|-
|Coverage
|WSSJMPSanitationTotal%SafelyManaged
|WSSJMPWaterUrban%SMOnPremise
|Proportion of Total population served with safely managed facilities (%)
|Proportion of Urban  population served with accessible on premises improved drinking water (%)
|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
|From an improved  water source that is accessible on premises
|0
|0
|
|
|
|
|}
<u>'''Issues in the data and their resolution:'''</u>
== '''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.
'''<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>Types of Data</u>:&nbsp;'''The following categories of data need to be imported into IFs:
#<u>'''WSSJMPSanitationTotal%Improved'''</u>- Describes the proportion of the total population served with improved sanitation (%).&nbsp;Sum of National Latrines, Septic Tanks, Sewer Connections.
#<u>'''WSSJMPSanitationTotal%Unimproved'''</u>- 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.
#<u>'''WSSJMPSanitationTotal%OtherUnimproved'''</u>- Describes the proportion of the total population with Other Unimproved Sanitation (%).&nbsp;National Unimproved
#<u>'''WSSJMPSanitationTotal%Shared-'''</u>&nbsp;Describes the proportion of the total population served with Shared Sanitation (%).&nbsp;National Limited (shared)
#<u>'''WSSJMPSanitationTotal%OpenDefecation'''</u>- Describes the proportion of the total population served with Open Defecation Sanitation (%).&nbsp;National Open Defecation
#<u>'''WSSJMPSanitationUrban%Improved-'''</u>&nbsp;Describes the proportion of the urban population served with Improved Sanitation (%).&nbsp;Sum of National Latrines, Septic Tanks, Sewer Connections.
#<u>'''WSSJMPSanitationUrban%Unimproved-'''</u>&nbsp;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.
#<u>'''WSSJMPSanitationUrban%OtherUnimproved-'''</u>&nbsp;Describes the proportion of the urban population with Other Unimproved Sanitation (%).&nbsp;National Unimproved
#<u>'''WSSJMPSanitationUrban%Shared-'''</u>&nbsp;Describes the proportion of the urban population served with Shared Sanitation (%).&nbsp;National Limited (shared)
#<u>'''WSSJMPSanitationUrban%OpenDefecation-'''</u>&nbsp;Describes the proportion of the urban population served with Open Defecation Sanitation (%).&nbsp;National Open Defecation
#<u>'''WSSJMPSanitationRural%Improved-'''</u>&nbsp;Describes the proportion of the rural population served with Improved Sanitation (%).&nbsp;Sum of National Latrines, Septic Tanks, Sewer Connections.
#<u>'''WSSJMPSanitationRural%Unimproved-'''</u>&nbsp;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.
#<u>'''WSSJMPSanitationRural%OtherUnimproved-'''</u>&nbsp;Describes the proportion of the rural population with Other Unimproved Sanitation (%).&nbsp;National Unimproved
#<u>'''WSSJMPSanitationRural%Shared-'''</u>&nbsp;Describes the proportion of the rural population served with Shared Sanitation (%).&nbsp;National Limited (shared)
#<u>'''WSSJMPSanitationRural%OpenDefecation-'''</u>&nbsp;Describes the&nbsp;proportion of the rural population served with Open Defecation Sanitation (%).&nbsp;National Open Defecation
#<u>'''WSSJMPSanitationTotalPopImproved-'''</u>&nbsp;Describes the total population served with Improved Sanitation. Calculated by the population*(Sum of Latrines, Septic Tanks, Sewer Connections/100).
#<u>'''WSSJMPSanitationTotalPopUnimproved-'''</u>&nbsp;Describes the total population served with Unimproved Sanitation. Total Unimproved Sanitation is the sum of Open Defecation, Other Unimproved, and Shared sanitation access.
#<u>'''WSSJMPSanitationTotalPopOtherUnimproved-'''</u>&nbsp;Describes the total population with Other Unimproved Sanitation. Calculated by the population*(National Unimproved/100).
#<u>'''WSSJMPSanitationTotalPopShared-'''</u>&nbsp;Describes the total population served with Shared Sanitation. Calculated by the population*(National Limited (shared)/100).
#<u>'''WSSJMPSanitationTotalPopOpenDefecation-'''</u>&nbsp;Describes the total population served with Open Defecation Sanitation. Calculated by the population*(National Open Defecation/100)
#<u>'''WSSJMPSanitationUrbanPopImproved-'''</u>&nbsp;Describes the urban population served with Improved Sanitation. Calculated by the population*(Urban Pop/100)*(Sum of Latrines, Septic Tanks, Sewer Connections/100)
#<u>'''WSSJMPSanitationUrbanPopUnimproved-'''</u>&nbsp;Describes the&nbsp;urban population served with Unimproved Sanitation. Urban Unimproved Sanitation is the sum of Open Defecation, Other Unimproved, and Shared sanitation access.
#<u>'''WSSJMPSanitationUrbanPopOtherUnimproved-'''</u>&nbsp;Describes the urban population with Other Unimproved Sanitation. Calculated by the population*(Urban Pop/100)*(Urban Unimproved).
#<u>'''WSSJMPSanitationUrbanPopShared-'''</u>&nbsp;Describes the urban population served with Shared Sanitation. Calculated by the population*(Urban Pop/100)*(Urban Limited (shared)/100).
#<u>'''WSSJMPSanitationUrbanPopOpenDefecation-'''</u>&nbsp;Describes the urban population served with Open Defecation Sanitation. Calculated by the population*(Urban Pop/100)*(Urban Open Defecation/100).
#<u>'''WSSJMPSanitationRuralPopImproved-'''</u>&nbsp;Describes the rural population served with Improved Sanitation. Calculated by the population*(100-Urban Pop)*(Sum of Latrines, Septic Tanks, Sewer Connections / 100).
#<u>'''WSSJMPSanitationRuralPopUnimproved-'''</u>&nbsp;Describes the rural population served with Unimproved Sanitation. Rural Unimproved Sanitation is the sum of Open Defecation, Other Unimproved, and Shared sanitation access.
#<u>'''WSSJMPSanitationRuralPopOtherUnimproved-'''</u>&nbsp;Describes the rural population with Other Unimproved Sanitation, Calculated by the population*(100-Urban Pop/100)*(Rural Unimproved/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)
{| class="wikitable"
|Residence  Type
|Service Type
|Service level
|Facility type
|Safely managed  element
|Column
|Variable
|Definition
|Extended Source  Defn
|UsedInPreprocessor
|UsedInPreprocessorFileName
|Formula
|-
|-
|rural
|WSSJMPSanitationTotal%Shared
|Sanitation
|Proportion of Total population served with shared facilities (%), 3-ladder system
|At least basic
|Shared facilities in the old 3-ladder  system equals to Limited in the new 5-ladder system
|
|1
|
|INFRASTRUCTURE
|Coverage
|WSSJMPSanitationRural%AtLeastBasic
|Proportion of Rural  population served with at least basic facilities (%)
|
|
|-
|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
|0
|
|
|
|
|-
|-
|total
|WSSJMPSanitationTotal%SMEmpTreated
|Sanitation
|Proportion of Total population served with safely managed facilities (%) that are emptied and treated
|At least basic
|Safely managed = disposed in situ +  emptied and treated + wastewater and treated
|
|
|Coverage
|WSSJMPSanitationTotal%AtLeastBasic
|Proportion of Total population served with at least basic facilities (%)
|
|0
|0
|
|
|
|
|-
|-
|urban
|WSSJMPSanitationTotal%SMWastewaterTreated
|Sanitation
|Proportion of Total population served with safely managed facilities (%) that are wastewater treated
|At least basic
|Safely managed = disposed in situ +  emptied and treated + wastewater and treated
|
|
|Coverage
|WSSJMPSanitationUrban%AtLeastBasic
|Proportion of Urban  population served with at least basic facilities (%)
|
|0
|0
|
|
|
|
|-
|-
|rural
|WSSJMPSanitationTotal%Unimproved
|Sanitation
|Proportion of Total population served with unimproved facilities (%)
|At least basis -  Limited service
|Use of pit latrines without a slab or platform, hanging latrines or bucket latrines
|
|
|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
|0
|
|
|
|
|-
|-
|total
|WSSJMPSanitationUrban%AtLeastBasic
|Sanitation
|Proportion of Urban population served with at least basic facilities (%)
|At least basis -  Limited service
|WSSJMPSanitationUrban%SafelyManaged + WSSJMPSanitationUrban%Basic
|
|
|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
|0
|
|
|
|
|-
|-
|urban
|Sanitation
|At least basis -  Limited service
|
|
|Coverage
|WSSJMPSanitationUrban%Basic
|WSSJMPSanitationUrban%Basic
|Proportion of Urban population served with at least basic and not shared with others (%)
|Proportion of Urban population served with basic but not safely managed facilities (%)
|Use of improved facilities which are not shared with other households
|Use of improved facilities which are not shared with other households
|0
|0
|
|
|
|
|-
|-
|rural
|WSSJMPSanitationUrban%Improved
|Sanitation
|Proportion of Urban population served  with improved facilities (%), 3-ladder system
|Limited service
|Improved facilities in the old 3-ladder  system equals to At Least Basic in the new 5-ladder system
|0
|
|
|
|
|Coverage
|-
|WSSJMPSanitationRural%Limited
|WSSJMPSanitationUrban%Limited
|Proportion of Rural  population served with limited facilities (%)
|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
|Use of improved facilities shared between two or more households
|0
|0
|
|
|
|
|-
|-
|rural
|WSSJMPSanitationUrban%OpenDefecation
|Sanitation
|Proportion of Urban population served with open defecation facilities (%)
|Limited service
|Disposal of human faeces in fields, forests, bushes, open bodies of water, beaches and other open spaces or with solid waste
|
|
|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
|0
|
|
|
|
|-
|-
|rural
|WSSJMPSanitationUrban%OtherUnimproved
|Sanitation
|Proportion of Urban population served  with other unimproved facilities (%), 3-ladder system
|Limited service
|OtherUnimproved facilities in the old  3-ladder system equals to Unimproved in the new 5-ladder system
|0
|
|
|
|
|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
|WSSJMPSanitationUrban%SafelyManaged
|Sanitation
|Proportion of Urban population served with safely managed facilities (%)
|Limited service
|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
|
|
|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
|0
|
|
|
|
|-
|-
|total
|WSSJMPSanitationUrban%Shared
|Sanitation
|Proportion of Urban population served  with shared facilities (%), 3-ladder system
|Limited service
|Shared facilities in the old 3-ladder  system equals to Limited in the new 5-ladder system
|0
|
|
|
|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
|WSSJMPSanitationUrban%SMDisposedInsitu
|Sanitation
|Proportion of Urban population served  with safely managed facilities (%) that are disposed in situ
|Limited service
|Safely managed = disposed in situ +  emptied and treated + wastewater and treated
|0
|
|
|
|
|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
|WSSJMPSanitationUrban%SMEmpTreated
|Sanitation
|Proportion of Urban population served with safely managed facilities (%) that are emptied and treated
|Limited service
|Safely managed = disposed in situ + emptied and treated + wastewater and treated
|
|
|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
|0
|
|
|
|
|-
|-
|urban
|WSSJMPSanitationUrban%SMWastewaterTreated
|Sanitation
|Proportion of Urban population served with safely managed facilities (%) that are wastewater treated
|Limited service
|Safely managed = disposed in situ + emptied and treated + wastewater and treated
|
|
|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
|0
|
|
|
|
|-
|-
|urban
|WSSJMPSanitationUrban%Unimproved
|Sanitation
|Proportion of Urban population served  with unimproved facilities (%)
|Limited service
|Use of pit latrines without a slab or  platform, hanging latrines or bucket latrines
|0
|
|
|
|
|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
|WSSJMPWaterRural%AtLeastBasic
|Sanitation
|Proportion of Rural population served with at least basic drinking water (%)
|Open defecation
|WSSJMPWaterRural%SafelyManaged + WSSJMPWaterRural%Basic
|
|
|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
|0
|
|
|
|
|-
|-
|rural
|WSSJMPWaterRural%Basic
|Sanitation
|Proportion of Rural population served with basic but not safely managed drinking water (%)
|Open defecation
|Drinking water from an improved source,  provided collection time is not more than 30 minutes for a roundtrip  including queuing
|
|
|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
|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
|WSSJMPWaterRural%Limited
|Sanitation
|Proportion of Rural population served  with limited drinking water (%)
|Open defecation
|Drinking water from an improved source  for which collection time exceeds 30 minutes for a roundtrip including  queuing
|0
|
|
|
|
|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
|WSSJMPWaterRural%OtherImproved
|Sanitation
|Proportion of Rural population served with other improved drinking water (%), old 3-ladder system
|Open defecation
|In the old 3-ladder system, other  improved means improved drinking water that is not piped
|
|
|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
|0
|
|
|
|
|-
|-
|urban
|WSSJMPWaterRural%OtherUnimproved
|Sanitation
|Proportion of Rural population served  with other unimproved drinking water (%), old 3-ladder system
|Open defecation
|In the old 3-ladder system, other  unimproved means unimproved drinking water in the new 5-ladder system
|0
|
|
|
|
|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
|WSSJMPWaterRural%Piped
|Sanitation
|Proportion of Rural population served with piped drinking water (%), old 3-ladder system
|Open Defecation,  Unimproved, and Limited service
|In the old 3-ladder system, this means improved drinking water that is piped
|
|
|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
|0
|
|
|
|
|-
|-
|rural
|WSSJMPWaterRural%SafelyManaged
|Sanitation
|Proportion of Rural population served  with safely managed drinking water (%)
|Open Defecation, Unimproved, and Limited service
|From an improved water source that is accessible on premises, available when needed and free from faecal and priority chemical contamination
|0
|
|
|
|
|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
|WSSJMPWaterRural%SMAsNeeded
|Sanitation
|Proportion of Rural population served with available when needed improved drinking water (%)
|Open Defecation,  Unimproved, and Limited service
|From an improved water source that is vailable when needed
|
|
|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
|0
|
|
|
|
|-
|-
|total
|WSSJMPWaterRural%SMNotContam
|Sanitation
|Proportion of Rural population served  with free from contamination improved drinking water (%)
|Open Defecation, Unimproved, and Limited service
|From an improved water source that is free from faecal and priority chemical contamination
|0
|
|
|
|
|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
|WSSJMPWaterRural%SMOnPremise
|Sanitation
|Proportion of Rural population served with accessible on premises improved drinking water (%)
|Open Defecation,  Unimproved, and Limited service
|From an improved water source that is accessible on premises
|
|
|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
|0
|
|
|
|
|-
|-
|urban
|WSSJMPWaterRural%Surface
|Sanitation
|Proportion of Rural population served  with surface drinking water (%)
|Open Defecation,  Unimproved, and Limited service
|Drinking water directly from a river,  dam, lake, pond, stream, canal or irrigation canal
|0
|
|
|
|
|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
|WSSJMPWaterRural%Unimproved
|Sanitation
|Proportion of Rural population served with unimproved drinking water (%)
|Safely managed  service
|Drinking water from an unprotected dug well or unprotected spring
|
|
|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
|0
|
|
|
|
|-
|-
|total
|WSSJMPWaterTotal%AtLeastBasic
|Sanitation
|Proportion of Total population served with at least basic drinking water (%)
|Safely managed  service
|WSSJMPWaterTotal%SafelyManaged + WSSJMPWaterTotal%Basic
|
|
|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
|0
|
|
|
|
|-
|-
|urban
|WSSJMPWaterTotal%Basic
|Sanitation
|Proportion of Total population served with basic but not safely managed drinking water (%)
|Safely managed  service
|Drinking water from an improved source, provided collection time is not more than 30 minutes for a roundtrip including queuing
|
|
|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
|0
|
|
|
|
|-
|-
|rural
|WSSJMPWaterTotal%Limited
|Sanitation
|Proportion of Total population served with limited drinking water (%)
|Unimproved
|Drinking water from an improved source for which collection time exceeds 30 minutes for a roundtrip including  queuing
|
|
|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
|0
|
|
|
|
|-
|-
|rural
|WSSJMPWaterTotal%OtherImproved
|Sanitation
|Proportion of Total population served  with other improved drinking water (%), old 3-ladder system
|Unimproved
|In the old 3-ladder system, other improved means improved drinking water that is not piped
|
|1
|
|INFRASTRUCTURE
|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
|WSSJMPWaterTotal%OtherUnimproved
|Sanitation
|Proportion of Total population served with other unimproved drinking water (%), old 3-ladder system
|Unimproved
|In the old 3-ladder system, other unimproved means unimproved drinking water in the new 5-ladder system
|
|
|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
|1
|ECONOMY, INFRASTRUCTURE
|ECONOMY, INFRASTRUCTURE
|
|
|-
|-
|total
|WSSJMPWaterTotal%Piped
|Sanitation
|Proportion of Total population served  with piped drinking water (%), old 3-ladder system
|Unimproved
|In the old 3-ladder system, this means  improved drinking water that is piped
|1
|INFRASTRUCTURE
|
|
|
|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
|WSSJMPWaterTotal%SafelyManaged
|Sanitation
|Proportion of Total population served with safely managed drinking water (%)
|Unimproved
|From an improved water source that is accessible on premises, available when needed and free from faecal and priority chemical contamination
|
|
|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
|0
|
|
|
|
|-
|-
|urban
|WSSJMPWaterTotal%SMAsNeeded
|Sanitation
|Proportion of Total population served  with available when needed improved drinking water (%)
|Unimproved
|From an improved water source that is  vailable when needed
|0
|
|
|
|
|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
|WSSJMPWaterTotal%SMNotContam
|Sanitation
|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
|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
|0
|
|
|
|
|-
|-
|rural
|WSSJMPWaterTotal%SMOnPremise
|Sanitation
|Proportion of Total population served  with accessible on premises improved drinking water (%)
|From an improved water source that is  accessible on premises
|0
|
|
|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
|WSSJMPWaterTotal%Surface
|Sanitation
|Proportion of Total population served with surface drinking water (%)
|
|Drinking water directly from a river, dam, lake, pond, stream, canal or irrigation canal
|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
|1
|INFRASTRUCTURE
|ECONOMY, INFRASTRUCTURE
|
|
|-
|-
|total
|WSSJMPWaterTotal%Unimproved
|Sanitation
|Proportion of Total population served  with unimproved drinking water (%)
|Drinking water from an unprotected dug  well or unprotected spring
|0
|
|
|Non-piped improved,  Improved latrine and other, Piped improved, Septic tank, and Sewer
|
|
|Population
|-
|WSSJMPSanitationTotalPopImproved
|WSSJMPWaterUrban%AtLeastBasic
|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.
|Proportion of Urban population served with at least basic drinking water (%)
|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
|WSSJMPWaterUrban%SafelyManaged + WSSJMPWaterUrban%Basic
|0
|0
|
|
|/1000
|
|-
|-
|urban
|WSSJMPWaterUrban%Basic
|Sanitation
|Proportion of Urban population served with basic but not safely managed drinking water (%)
|
|Drinking water from an improved source, provided collection time is not more than 30 minutes for a roundtrip including queuing
|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
|0
|
|
|
|
|-
|-
|urban
|WSSJMPWaterUrban%Limited
|Sanitation
|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
|
|
|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
|WSSJMPWaterUrban%OtherImproved
|Sanitation
|Proportion of Urban population served with other improved drinking water (%), old 3-ladder system
|
|In the old 3-ladder system, other improved means improved drinking water that is not piped
|
|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
|0
|
|
|
|
|-
|-
|total
|WSSJMPWaterUrban%OtherUnimproved
|Sanitation
|Proportion of Urban population served with other unimproved drinking water (%), old 3-ladder system
|
|In the old 3-ladder system, other unimproved means unimproved drinking water in the new 5-ladder system
|
|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
|0
|
|
|
|
|-
|-
|urban
|WSSJMPWaterUrban%Piped
|Sanitation
|Proportion of Urban population served with piped drinking water (%), old 3-ladder system
|
|In the old 3-ladder system, this means improved drinking water that is piped
|
|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
|0
|
|
|
|
|-
|-
|rural
|WSSJMPWaterUrban%SafelyManaged
|Sanitation
|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
|
|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
|0
|
|
|
|
|-
|-
|total
|WSSJMPWaterUrban%SMAsNeeded
|Sanitation
|Proportion of Urban population served with available when needed improved drinking water (%)
|
|From an improved water source that is vailable when needed
|
|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
|0
|
|
|
|
|-
|-
|urban
|WSSJMPWaterUrban%SMNotContam
|Sanitation
|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
|
|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
|0
|
|
|
|
|-
|-
|rural
|WSSJMPWaterUrban%SMOnPremise
|Sanitation
|Proportion of Urban population served with accessible on premises improved drinking water (%)
|
|From an improved water source that is accessible on premises
|
|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
|0
|
|
|
|
|-
|-
|total
|WSSJMPWaterUrban%Surface
|Sanitation
|Proportion of Urban population served with surface drinking water (%)
|
|Drinking water directly from a river, dam, lake, pond, stream, canal or irrigation canal
|
|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
|0
|
|
|
|
|-
|-
|urban
|WSSJMPWaterUrban%Unimproved
|Sanitation
|Proportion of Urban population served with unimproved drinking water (%)
|
|Drinking water from an unprotected dug well or unprotected spring
|
|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
|0
|
|
|
|
|}
|}
<u>'''Issues in the data and their resolution:'''</u>


The 3 groups of series below are duplicated: '''"Shared" is "Limited service".'''
= Data Pulling Instructions: Downloading Data =
# Go to https://washdata.org/data/downloads#WLD
## Detailed instructions on how to find the "Household" [[Joint Monitoring Programme|here]]
#Click "World file" under "Household" to download all the data.[[File:Imagellsjfewa.png|none|thumb|679x679px]]
#Open the downloaded file. "Enable Editing". Hover the mouse to the tab and right-click. The file will show several options:[[File:ImagefheqFNLIA.png|none|thumb]]
#Click "Unhide", and a view will pop up. [[File:Image-unhide.png|none|thumb]]
#Press "ctrl" and select "wat" and "san". Click "OK".
#In these 2 tabs, you may find the columns we will use in "Code in Source" listed below.
 
= Data Pulling Instructions: 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.
 
'''<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/downloads#WLD
 
'''<u>Country List to be Used:</u>'''&nbsp;WSS JMP
 
'''<u>Ladder and Related code in downloaded data:</u>'''
 
IFs include both old and new water systems from WSS JMP. The new system is developed based on the old system, thus, you can find some overlapping variable labels between two systems. Below we listed a mapping between the ladders used in IFs and those being used in WSS JMP.  
 
'''New system-'''
{| class="wikitable"
{| class="wikitable"
|Residence  Type
|TAB
|Service Type
|Ladder in IFs
|Service level
|WSS JMP Variable
|Facility type
|Safely managed  element
|Column
|Variable
|Definition
|Extended Source  Defn
|UsedInPreprocessor
|UsedInPreprocessorFileName
|Formula
|-
|-
|rural
|wat
|Sanitation
|SafelyManaged
|Limited service
|sm
|
|-
|
|wat
|Coverage
|AtLeastBasic
|WSSJMPSanitationRural%Limited
|basal
|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
|wat
|0
|Basic
|
|basal - sm
|
|-
|wat
|Limited
|lim
|-
|wat
|Unimproved
|unimp
|-
|wat
|Surface
|ns
|}
In which, SafelyManaged is the intersaction of following 3 categories (most of time the result is just the minimal among three)
 
* SMOnPremise = imp_prem; used to be premises
* SMAsNeeded = imp_av; used to be available
* SMNotContam = imp_qual; used to be quality
 
You can also observe that unimp + imp + ns = 100%, where imp = basal + lim = pip + imp_npip
 
'''Old system-'''
{| class="wikitable"
|-
|TAB
|Ladder in IFs
|WSS JMP Variable
|-
|wat
|OtherImproved
|imp_npip
|-
|wat
|Piped
|pip
|-
|wat
|OtherUnimproved
|unimp
|-
|wat
|Surface
|ns
|}
 
<u>'''Notes:'''</u>
 
* All indicators use suffices to indicate regional levels, with
** _t means national indicators (Total%); used to be _n being national
** _r means Rural%
** _u means Urban%
* Prefix pop_ means Population in Thousands
* prop_u is the percentage of urban population in total population.
* 100 - prop_u is the percentage of rural population in total population.
* The rest of data are in percentages
 
Thus, under the raw data (the Excel file downloaded following the instruction above), the TAB column in the mapping above represents the name of the spreadsheet, while the other two columns represent the one-to-one mapping between IFs data table name and WSS JMP variable name. For example, table SeriesWSSJMPWaterTotal%SafelyManaged from IFsHistSeries equals to the variable wat_sm_t. Same rules apply to the sanitation data introduced below.
 
= Data Pulling Instructions: 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.
 
'''<u>Source</u>:''' 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>Ladder and Related code in downloaded data:</u>'''
 
IFs include both old and new sanitation systems from WSS JMP. The new system is developed based on the old system, thus, you can find some overlapping variable labels between two systems. Below we listed a mapping between the ladders used in IFs and those being used in WSS JMP.
 
'''New system-'''
{| class="wikitable"
|TAB
|Ladder in IFs
|WSS JMP Variable
|-
|san
|AtLeastBasic
|basal
|-
|san
|Basic
|basal - sm
|-
|san
|Limited
|lim
|-
|san
|OpenDefecation
|ns
|-
|-
|rural
|san
|Sanitation
|OtherUnimproved
|Limited service
|unimp
|
|}
|
In which, SafelyManaged is the union of following 3 categories (normally adding three together)
|Coverage
 
|WSSJMPSanitationRural%Shared
* SMDisposedInsitu = sdo_sm; Disposed in situ
|Proportion of Rural  population served with Shared Sanitation (%)
* SMEmpTreated = fst_sm; Emptied and treated
|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
* SMWastewaterTreated = sew_sm; Wastewater treated
|0
 
|
You can also find that imp + unimp + ns = 100, where imp = basal + lim; Additionally, Improved (imp) is the union of following 3 categories (normally adding three together, if all 3 exist)
|
 
* Latrines and other = othimp; used to be lat
* Septic tanks = sep
* Sewer connections = sew
 
'''Old system-'''
{| class="wikitable"
|TAB
|Ladder in IFs
|WSS JMP Variable
|-
|-
|total
|san
|Sanitation
|Improved
|Limited service
|basal
|
|
|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
|san
|Sanitation
|Shared
|Limited service
|lim
|
|
|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
|san
|Sanitation
|OtherUnimproved
|Limited service
|unimp
|
|
|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
|san
|Sanitation
|OpenDefecation
|Limited service
|ns
|
|
|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
|
|
|}
|}
Hence, the table SeriesWSSJMPSanitationTotal%SafelyManaged from IFsHistSeries is the equivalent to the variable san_sm_t from WSS JMP.
= Data Notes =

Latest revision as of 15:41, 19 August 2025

Summary

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.

Tables In IFs

Variable Defintion Ext Source Def UsedInPreprocessor UsedInPreprocessorFileName Code In Source
WSSJMPSanitationTotalPopImproved Total population served with Improved Sanitation 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 san_bas_n_pop
WSSJMPSanitationTotalPopOpenDefecation Total population served with Open Defecation Sanitation 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 san_od_n_pop
WSSJMPSanitationTotalPopOtherUnimproved Total population with Other Unimproved Sanitation do not ensure hygenic separation of human excreta from human contact. Unimproved facilities include pit latrines without a slab or platfor, hanging latrines or bucket latrines 0 san_unimp_n_pop
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 san_lim_n_pop
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 san_UnImp_n_pop
WSSJMPWaterUrbanPopSurface Urban population with Surface Water River, dam, lake, pond, stream, canal, irrigation channels. 0 wat_sur_u_pop
WSSJMPWaterUrbanPopImproved Urban population served with Improved Water Piped water on premises/other improved drinking water 0 wat_imp_u_pop
WSSJMPSanitationRuralPopImproved Rural population served with Improved Sanitation 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 san_bas_r_pop
WSSJMPSanitationRuralPopOpenDefecation Rural population served with Open Defecation Sanitation when human feces are disposed of in fields, forests, bushes, open bodies of water, beaches or other open spaces or disposed of with solid waste 0 san_od_r_pop
WSSJMPSanitationRuralPopOtherUnimproved Rural population with Other Unimproved Sanitation do not ensure hygenic separation of human excreta from human contact. Unimproved facilities include pit latrines without a slab or platfor, hanging latrines or bucket latrines 0 san_unimp_r_pop
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 san_lim_r_pop
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 san_UnImp_r_pop
WSSJMPSanitationUrbanPopImproved Urban population served with Improved Sanitation 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 san_bas_u_pop
WSSJMPSanitationUrbanPopOpenDefecation Urban population served with Open Defecation Sanitation when human feces are disposed of in fields, forests, bushes, open bodies of water, beaches or other open spaces or disposed of with solid waste 0 san_od_u_pop
WSSJMPSanitationUrbanPopOtherUnimproved Urban population with Other Unimproved Sanitation do not ensure hygenic separation of human excreta from human contact. Unimproved facilities include pit latrines without a slab or platfor, hanging latrines or bucket latrines 0 san_unimp_u_pop
WSSJMPWaterRuralPopImproved Rural population served with Improved Water Piped water on premises/other improved drinking water 0 wat_imp_r_pop
WSSJMPWaterRuralPopOtherImproved Rural population served with Other Improved Water Public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, rainwater collection 0 wat_imp_r_pop - wat_pip_r_pop
WSSJMPWaterRuralPopOtherUnimproved Rural population with Other 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 wat_unimp_r_pop
WSSJMPWaterRuralPopSurface Rural population with Surface Water River, dam, lake, pond, stream, canal, irrigation channels. 0 wat_sur_r_pop
WSSJMPWaterRuralPopUnimproved Rural population served with Unimproved Water. Total Unimproved Water is the sum of Surface and Other Unimproved water access. Unimproved drinking water sources/surface drinking water sources 0 wat_UnImp_r_pop
WSSJMPWaterTotalPopOtherUnimproved Total population served with Unimproved Water Unimproved drinking water sources/surface drinking water sources 0 wat_unimp_n_pop
WSSJMPWaterTotalPopPiped Total population served with Piped Water Piped household water connection located inside the user's dwelling, plot or yard 0 wat_pip_n_pop
WSSJMPWaterTotalPopSurface Total population with Surface Water River, dam, lake, pond, stream, canal, irrigation channels. 0 wat_sur_n_pop
WSSJMPWaterTotalPopUnimproved Proportion of total population served with Unimproved Water (%). Total Unimproved Water is the sum of Surface and Other Unimproved water access. Unimproved drinking water sources/surface drinking water sources 0 wat_UnImp_n_pop
WSSJMPWaterUrban%Improved Proportion of Urban population served with Improved Water (%) Piped water on premises/other improved drinking water 0 wat_imp_u
WSSJMPWaterUrbanPopOtherImproved Urban population served with Other Improved Water Public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, rainwater collection 0 wat_imp_u_pop - wat_pip_u_pop
WSSJMPWaterUrbanPopOtherUnimproved Urban population with Other 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 wat_unimp_u_pop
WSSJMPWaterUrbanPopPiped Urban population served with Piped Water Piped household water connection located inside the user's dwelling, plot or yard 0 wat_pip_u_pop
WSSJMPWaterUrbanPopUnimproved Urban population served with Unimproved Water. Total Unimproved Water is the sum of Surface and Other Unimproved water access. Unimproved drinking water sources/surface drinking water sources 0 wat_UnImp_u_pop
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 san_lim_u_pop
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 san_UnImp_u_pop
WSSJMPWaterRural%Improved Proportion of Rural population served with Improved Water (%) Piped water on premises/other improved drinking water 0 wat_imp_r
WSSJMPWaterRuralPopPiped Rural population served with Piped Water Piped household water connection located inside the user's dwelling, plot or yard 0 wat_pip_r_pop
WSSJMPWaterTotal%Improved Proportion of Total population served with Improved Water (%) Piped water on premises/other improved drinking water 0 wat_imp_n
WSSJMPWaterTotalPopImproved Total population served with Improved Water Piped water on premises/other improved drinking water 0 wat_imp_n_pop
WSSJMPWaterTotalPopOtherImproved Total population served with Other Improved Water Public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, rainwater collection 0 wat_imp_n_pop - wat_pip_n_pop
WSSJMPSanitationRural%AtLeastBasic Proportion of Rural population served with at least basic facilities (%) WSSJMPSanitationRural%SafelyManaged + WSSJMPSanitationRural%Basic 0
WSSJMPSanitationRural%Basic Proportion of Rural population served with basic but not safely managed facilities (%) Use of improved facilities which are not shared with other households 0
WSSJMPSanitationRural%Improved Proportion of Rural population served with improved facilities (%), 3-ladder system Improved facilities in the old 3-ladder system equals to At Least Basic in the new 5-ladder system 0
WSSJMPSanitationRural%Limited Proportion of Rural population served with limited facilities (%) Use of improved facilities shared between two or more households 0
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
WSSJMPSanitationRural%OtherUnimproved Proportion of Rural population served with other unimproved facilities (%), 3-ladder system OtherUnimproved facilities in the old 3-ladder system equals to Unimproved in the new 5-ladder system 0
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
WSSJMPSanitationRural%Shared Proportion of Rural population served with shared facilities (%), 3-ladder system Shared facilities in the old 3-ladder system equals to Limited in the new 5-ladder system 0
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
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
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
WSSJMPSanitationRural%Unimproved Proportion of Rural population served with unimproved facilities (%) Use of pit latrines without a slab or platform, hanging latrines or bucket latrines 0
WSSJMPSanitationTotal%AtLeastBasic Proportion of Total population served with at least basic facilities (%) WSSJMPSanitationTotal%SafelyManaged + WSSJMPSanitationTotal%Basic 0
WSSJMPSanitationTotal%Basic Proportion of total population served with basic but not safely managed facilities (%) Use of improved facilities which are not shared with other households 0
WSSJMPSanitationTotal%Improved Proportion of Total population served with improved facilities (%), 3-ladder system Improved facilities in the old 3-ladder system equals to At Least Basic in the new 5-ladder system 1 INFRASTRUCTURE
WSSJMPSanitationTotal%Limited Proportion of Total population served with limited facilities (%) Use of improved facilities shared between two or more households 0
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
WSSJMPSanitationTotal%OtherUnimproved Proportion of Total population served with other unimproved facilities (%), 3-ladder system OtherUnimproved facilities in the old 3-ladder system equals to Unimproved in the new 5-ladder system 1 ECONOMY, INFRASTRUCTURE
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
WSSJMPSanitationTotal%Shared Proportion of Total population served with shared facilities (%), 3-ladder system Shared facilities in the old 3-ladder system equals to Limited in the new 5-ladder system 1 INFRASTRUCTURE
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
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
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
WSSJMPSanitationTotal%Unimproved Proportion of Total population served with unimproved facilities (%) Use of pit latrines without a slab or platform, hanging latrines or bucket latrines 0
WSSJMPSanitationUrban%AtLeastBasic Proportion of Urban population served with at least basic facilities (%) WSSJMPSanitationUrban%SafelyManaged + WSSJMPSanitationUrban%Basic 0
WSSJMPSanitationUrban%Basic Proportion of Urban population served with basic but not safely managed facilities (%) Use of improved facilities which are not shared with other households 0
WSSJMPSanitationUrban%Improved Proportion of Urban population served with improved facilities (%), 3-ladder system Improved facilities in the old 3-ladder system equals to At Least Basic in the new 5-ladder system 0
WSSJMPSanitationUrban%Limited Proportion of Urban population served with limited facilities (%) Use of improved facilities shared between two or more households 0
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
WSSJMPSanitationUrban%OtherUnimproved Proportion of Urban population served with other unimproved facilities (%), 3-ladder system OtherUnimproved facilities in the old 3-ladder system equals to Unimproved in the new 5-ladder system 0
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
WSSJMPSanitationUrban%Shared Proportion of Urban population served with shared facilities (%), 3-ladder system Shared facilities in the old 3-ladder system equals to Limited in the new 5-ladder system 0
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
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
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
WSSJMPSanitationUrban%Unimproved Proportion of Urban population served with unimproved facilities (%) Use of pit latrines without a slab or platform, hanging latrines or bucket latrines 0
WSSJMPWaterRural%AtLeastBasic Proportion of Rural population served with at least basic drinking water (%) WSSJMPWaterRural%SafelyManaged + WSSJMPWaterRural%Basic 0
WSSJMPWaterRural%Basic Proportion of Rural population served with basic but not safely managed drinking water (%) Drinking water from an improved source, provided collection time is not more than 30 minutes for a roundtrip including queuing 0
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
WSSJMPWaterRural%OtherImproved Proportion of Rural population served with other improved drinking water (%), old 3-ladder system In the old 3-ladder system, other improved means improved drinking water that is not piped 0
WSSJMPWaterRural%OtherUnimproved Proportion of Rural population served with other unimproved drinking water (%), old 3-ladder system In the old 3-ladder system, other unimproved means unimproved drinking water in the new 5-ladder system 0
WSSJMPWaterRural%Piped Proportion of Rural population served with piped drinking water (%), old 3-ladder system In the old 3-ladder system, this means improved drinking water that is piped 0
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
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
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
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
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
WSSJMPWaterRural%Unimproved Proportion of Rural population served with unimproved drinking water (%) Drinking water from an unprotected dug well or unprotected spring 0
WSSJMPWaterTotal%AtLeastBasic Proportion of Total population served with at least basic drinking water (%) WSSJMPWaterTotal%SafelyManaged + WSSJMPWaterTotal%Basic 0
WSSJMPWaterTotal%Basic Proportion of Total population served with basic but not safely managed drinking water (%) Drinking water from an improved source, provided collection time is not more than 30 minutes for a roundtrip including queuing 0
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
WSSJMPWaterTotal%OtherImproved Proportion of Total population served with other improved drinking water (%), old 3-ladder system In the old 3-ladder system, other improved means improved drinking water that is not piped 1 INFRASTRUCTURE
WSSJMPWaterTotal%OtherUnimproved Proportion of Total population served with other unimproved drinking water (%), old 3-ladder system In the old 3-ladder system, other unimproved means unimproved drinking water in the new 5-ladder system 1 ECONOMY, INFRASTRUCTURE
WSSJMPWaterTotal%Piped Proportion of Total population served with piped drinking water (%), old 3-ladder system In the old 3-ladder system, this means improved drinking water that is piped 1 INFRASTRUCTURE
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
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
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
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
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
WSSJMPWaterTotal%Unimproved Proportion of Total population served with unimproved drinking water (%) Drinking water from an unprotected dug well or unprotected spring 0
WSSJMPWaterUrban%AtLeastBasic Proportion of Urban population served with at least basic drinking water (%) WSSJMPWaterUrban%SafelyManaged + WSSJMPWaterUrban%Basic 0
WSSJMPWaterUrban%Basic Proportion of Urban population served with basic but not safely managed drinking water (%) Drinking water from an improved source, provided collection time is not more than 30 minutes for a roundtrip including queuing 0
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
WSSJMPWaterUrban%OtherImproved Proportion of Urban population served with other improved drinking water (%), old 3-ladder system In the old 3-ladder system, other improved means improved drinking water that is not piped 0
WSSJMPWaterUrban%OtherUnimproved Proportion of Urban population served with other unimproved drinking water (%), old 3-ladder system In the old 3-ladder system, other unimproved means unimproved drinking water in the new 5-ladder system 0
WSSJMPWaterUrban%Piped Proportion of Urban population served with piped drinking water (%), old 3-ladder system In the old 3-ladder system, this means improved drinking water that is piped 0
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
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
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
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
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
WSSJMPWaterUrban%Unimproved Proportion of Urban population served with unimproved drinking water (%) Drinking water from an unprotected dug well or unprotected spring 0

Data Pulling Instructions: Downloading Data

  1. Go to https://washdata.org/data/downloads#WLD
    1. Detailed instructions on how to find the "Household" here
  2. Click "World file" under "Household" to download all the data.
    Imagellsjfewa.png
  3. Open the downloaded file. "Enable Editing". Hover the mouse to the tab and right-click. The file will show several options:
    ImagefheqFNLIA.png
  4. Click "Unhide", and a view will pop up.
    Image-unhide.png
  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.

Data Pulling Instructions: 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:

IFs include both old and new water systems from WSS JMP. The new system is developed based on the old system, thus, you can find some overlapping variable labels between two systems. Below we listed a mapping between the ladders used in IFs and those being used in WSS JMP.

New system-

TAB Ladder in IFs WSS JMP Variable
wat SafelyManaged sm
wat AtLeastBasic basal
wat Basic basal - sm
wat Limited lim
wat Unimproved unimp
wat Surface ns

In which, SafelyManaged is the intersaction of following 3 categories (most of time the result is just the minimal among three)

  • SMOnPremise = imp_prem; used to be premises
  • SMAsNeeded = imp_av; used to be available
  • SMNotContam = imp_qual; used to be quality

You can also observe that unimp + imp + ns = 100%, where imp = basal + lim = pip + imp_npip

Old system-

TAB Ladder in IFs WSS JMP Variable
wat OtherImproved imp_npip
wat Piped pip
wat OtherUnimproved unimp
wat Surface ns

Notes:

  • All indicators use suffices to indicate regional levels, with
    • _t means national indicators (Total%); used to be _n being national
    • _r means Rural%
    • _u means Urban%
  • Prefix pop_ means Population in Thousands
  • prop_u is the percentage of urban population in total population.
  • 100 - prop_u is the percentage of rural population in total population.
  • The rest of data are in percentages

Thus, under the raw data (the Excel file downloaded following the instruction above), the TAB column in the mapping above represents the name of the spreadsheet, while the other two columns represent the one-to-one mapping between IFs data table name and WSS JMP variable name. For example, table SeriesWSSJMPWaterTotal%SafelyManaged from IFsHistSeries equals to the variable wat_sm_t. Same rules apply to the sanitation data introduced below.

Data Pulling Instructions: 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:

IFs include both old and new sanitation systems from WSS JMP. The new system is developed based on the old system, thus, you can find some overlapping variable labels between two systems. Below we listed a mapping between the ladders used in IFs and those being used in WSS JMP.

New system-

TAB Ladder in IFs WSS JMP Variable
san AtLeastBasic basal
san Basic basal - sm
san Limited lim
san OpenDefecation ns
san OtherUnimproved unimp

In which, SafelyManaged is the union of following 3 categories (normally adding three together)

  • SMDisposedInsitu = sdo_sm; Disposed in situ
  • SMEmpTreated = fst_sm; Emptied and treated
  • SMWastewaterTreated = sew_sm; Wastewater treated

You can also find that imp + unimp + ns = 100, where imp = basal + lim; Additionally, Improved (imp) is the union of following 3 categories (normally adding three together, if all 3 exist)

  • Latrines and other = othimp; used to be lat
  • Septic tanks = sep
  • Sewer connections = sew

Old system-

TAB Ladder in IFs WSS JMP Variable
san Improved basal
san Shared lim
san OtherUnimproved unimp
san OpenDefecation ns

Hence, the table SeriesWSSJMPSanitationTotal%SafelyManaged from IFsHistSeries is the equivalent to the variable san_sm_t from WSS JMP.

Data Notes

Retrieved from "https://pardeewiki.du.edu//index.php?title=Joint_Monitoring_Programme,_WHO/UNICEF&oldid=13305"