The World Bank Working for a World Free of Poverty Microdata Library
  • Data Catalog
  • About
  • Collections
  • Citations
  • Terms of use
  • Login
    Login
    Home / Central Data Catalog / SIEF / ETH_2017-2019_ISCLTSH-IE_V01_M
sief

The Impact and Sustainability of Community-Led Total Sanitation and Hygiene (CLTSH) 2017-2019
Andilaye Impact Evaluation - Baseline, Midline, and Endline Surveys

Ethiopia, 2017 - 2019
Get Microdata
Reference ID
ETH_2017-2019_ISCLTSH-IE_v01_M
DOI
https://doi.org/10.48529/2366-tc77
Producer(s)
Matthew C. Freeman, Abebe Gebremariam Gobezayehu
Collection(s)
The Strategic Impact Evaluation Fund (SIEF) Impact Evaluation Surveys Fragility, Conflict and Violence
Metadata
Documentation in PDF DDI/XML JSON
Created on
Jan 09, 2024
Last modified
Jan 09, 2024
Page views
85639
Downloads
1045
  • Study Description
  • Data Description
  • Documentation
  • Get Microdata
  • Data files
  • all_hh_lat_baseline_0723.dta
  • all_hh_lat_endline_0723.dta
  • all_hh_lat_midline_0723.dta
  • all_hh_members_baseline_0723.dta
  • all_hh_members_endline_0723.dta
  • all_hh_members_midline_0723.dta

Data file: all_hh_lat_baseline_0723.dta

This dataset includes baseline survey data with latrine level information for each household.

Cases: 1695
Variables: 339

Variables

A_1_5
Woreda name:
rand_var
randomization variable, 1=int, 0=cont
cltsh
were they previous cltsh and ODF
cltsh_bin
previous cltsh and ODF, binary (yes vs no)
ID
de-identified individual ID, for administrative purposes
calculate_date
Date
round
Data collection round:
A_1_11
Enumerator/Surveillance Officer name & code:
A_1_14
Was consent given?
A_1_13
Is at least one household member between the ages of 1 - 9 years?
A_1_3
HH# - non-specific HH id
G_1_1
How many household latrines does your household have access to?
A_2_2_7
What is your (respondent's) relation to hoh_name?
A_2_1_4
What is your (respondent's) role with regard to household caregiving responsibil
A_2_1_7
What is the highest education of primary caregiver/mother index_name?
A_2_2_6
What is the marital status of the primary caregiver/mother of index_name?
A_2_1_5a
What is your (respondent's) age?
A_2_1_5b
Indicate respondent's sex:
A_2_1_5c
What is your religion?
A_2_1_5d
What is your ethnicity?
A_2_1_5e
During the last 7 days, including today, have you gone to fetch water for the ho
A_2_1_5f
Do you have any animal herding or other animal husbandry responsibilities?
A_2_1_6a
During the LAST 2 DAYS, where was YOUR primary place of defecation?
A_2_1_6b
Does the primary place of defecation change for YOU over the course of the year?
A_2_1_6c
During the LAST TWO DAYS, did YOU openly defecate?
A_2_1_6d
During the last 2 days, did YOU openly defecate in or near a surface water sourc
A_2_1_6e
During the last 2 days, did YOU urinate in or near a surface water source (e.g.
A_2_1_6f
During the LAST TWO DAYS, did YOU defecate in ANY latrine?
A_2_1_6g
During THE last 7 days, including today, did YOU ALWAYS EXCLUSIVELY use a latrin
HC_1a
Left hand: finger nail cleanliness
HC_1b
Right hand: finger nail cleanliness
HC_2a
Left hand: length of nails
HC_2b
Right hand: length of nails
HC_3a
Left hand: finger pad cleanliness
HC_3b
Right hand: finger pad cleanliness
HC_4a
Left hand: palm cleanliness
HC_4b
Right hand: palm cleanliness
A_1_4a
What is the highest education of hoh_name?
A_1_4b
What is the age of hoh_name?
A_1_4c
What is the sex of hoh_name?
A_1_4d
During the last 7 days, including today, has hoh_name gone to fetch water for th
A_1_4e
Does hoh_name have any animal herding or other animal husbandry responsibilities
A_1_4f
If present, OBSERVE whether hoh_name is wearing shoes.
A_1_4g
During the LAST 2 DAYS, where was hoh_name's primary place of defecation?
A_1_4h
Does the primary place of defecation change for hoh_name over the course of the
A_1_4i
During the LAST TWO DAYS, did hoh_name openly defecate?
A_1_4j
During the last 2 days, did hoh_name openly defecate in or near a surface water
A_1_4k
During the last 2 days, did hoh_name urinate in or near a surface water source (
A_1_4l
During the LAST TWO DAYS, did hoh_name defecate in ANY latrine?
A_1_4m
During THE last 7 days, including today, did hoh_name ALWAYS EXCLUSIVELY use a l
A_1_4n
Enumerator: Enter the type of report for hoh_name's information:
A_2_1_8b
How many children between 0 and 9 years of age live in the household?
A_2_1_8c
How many people 10 to 17 years of age live in the household?
A_2_1_8d
How many people 18 years or older live in the household?
totHHmem
total number of HH members
C_1_1
Number of containers used to collect/fetch water:
C_1_2
Estimated volume of all containers used to collect/fetch water, in liters:
C_1_2a
Number of small-necked containers used to fetch water:
C_SW_1
Please show me all of the containers your household uses to STORE water.
C_SW_1a
Number of small-necked containers used to store water:
C_SW_2
Did you do anything to treat THIS water?
C_SW_3
What method of treatment did you use to treat THIS water?
C_1_3
During the last 7 days, including today, on how many days did a member of your h
C_1_4
On the LAST DAY your household collected water, how many trips did members of yo
C_1_5
What is the main source of DRINKING WATER for members of your household?
C_1_5a
How many months is this main source of DRINKING WATER available for use?
C_1_5b
Is this main source of DRINKING WATER located within your own household compound
C_1_5c
Currently, how long does it take to go to the main source of DRINKING WATER, get
C_1_5c_hours
Currently, how long does it take to go to the main source of DRINKING WATER, get
C_1_6
What is the main source of water used by your household for other purposes, such
C_1_6a
Is this main source of water used for other purposes, such as cooking and handwa
C_1_6c
Currently, how long does it take to go to the source used for other purposes, ge
C_1_6c_hours
Currently, how long does it take to go to the source used for other purposes, ge
C_2_1
In the past 3 months, did you worry that you would not have enough water for all
C_2_1b
Was that just a few times or often?
C_2_2
In the past 3 months, did you ever do less cleaning, drinking, cooking, or perso
C_2_2b
Was that just a few times or often?
C_2_3
In the past 3 months, did you or anyone in your household drink water that you t
C_2_3b
Was that just a few times or often?
C_2_4
In the past 3 months, did you or someone in your household not cook a desirable
C_2_4b
Was that just a few times or often?
C_2_11
In the past 3 months, did you or anyone else in your household go to sleep thirs
C_2_11b
Was that just a few times or often?
FS_1
In the past 3 months, did you or any household member go to sleep hungry at nigh
FS_1b
Was that just a few times or often?
D_1_2a
Yesterday, did index_name's HANDS get washed (by you, the child, or anyone else)
D_1_3
The LAST time index_name's hands got washed, was soap/ash/or soapy water used?
D_1_4
Yesterday, did YOU wash YOUR hands with water?
D_1_4_1
The LAST time you washed your hands, did you use soap/ash/or soapy water?
D_1_4b
Yesterday, was surface water (e.g., pond,river or lake) used for handwashing?
D_1_4a
Yesterday, did you have sufficient water for handwashing?
D_1_5
The last time index_name defecated, did s/he clean his/her hands with water and
D_1_6
The last time you defecated, did you clean your hands with water and soap, soapy
D_1_7
The last time you prepared food, did you clean your hands with water and soap, s
D_2_1
Yesterday, did index_name's FACE get cleaned by you, the child, or anyone else?
D_2_3
Yesterday, how did index_name's FACE get cleaned ?
D_2_4
Yesterday, after index_name’s FACE was washed, was it wiped dry with a cloth suc
D_2_5
Yesterday, did YOU clean YOUR face?
D_2_7
Yesterday, how did you clean your face?
D_2_8
Yesterday, after you washed YOUR FACE, did you wipe it dry with a cloth such as
D_2_5_b
Yesterday, was surface water (e.g., pond,river or lake) used for facewashing?
D_2_5_a
Yesterday did you have sufficient water for facewashing?
D_3_1
During the last 7 days, including today, how many times did index_name bathe or
D_3_2
During the last 7 days, including today, how many times did YOU bathe your body?
D_3_2_a
During the last 7 days, including today, did you have sufficient water for bathi
D_3_2_b
During the last 7 days, including today, was surface water (e.g., pond,river or
D_3_3a
index_name's clothes
D_3_3b
YOUR own clothes
D_3_3d
Towels
D_3_3e
Bedsheets
D_3_3f
Baby carrier
D_3_3g
Children's toys
D_3_3_h
During the last 7 days, including today, did you have sufficient water for washi
D_3_3_i
During the last 7 days, including today, was surface water (e.g., pond,river or
I_1a
Working electricity
I_1b
Functioning radio set
I_1c
Functioning television
I_1d
Functioning bicycle
I_1e
Functioning motorcycle/scooter
I_1f
Functioning car/truck
I_1g
Functioning mobile phone
I_1h
Functioning mitad
I_1i
Functioning kerosene or pressure lamp
I_1j
One or more beds and one or more tables
I_1k
An enclosed bathing area
I_1l
Number of cattle owned by household (cows/bulls/oxen)
I_1m
Number of horses, mules, or donkeys owned by household
I_1n
Number of sheep or goats owned by household
I_1o
Number of chickens owned by household
I_2a
A homestead/house
I_2b
Crop land
I_2c
Cash crops
I_3
Do any of the members of your household work their own or their family’s agricul
I_4
What is the principal type of fuel for cooking used by your household?
I_5
What was the main source of cash income of all family members in the last one ye
I_6
How well off do you think your household is in relation to other households in t
randomized
Enumerator randomized (1=sanitation insecurity, 2=collective efficacy)
SIU_1
Worried about not having any place to urinate.
SIU_2
Could not always go to urinate when there was a need.
SIU_3
Worried someone would see me while urinating.
SIU_4
Experienced difficulty controlling the urge to urinate.
SIU_14
Had difficulty finding a private place to urinate where others will not see me.
SIU_5
Had difficulty finding a clean place to urinate.
SIU_6
Worried that I would step on urine.
SIU_7
Worried people would talk about me if they saw me urinating.
SIU_8
Concerned I would get an infection if I was urinating in an unsuitable/dirty pla
SIU_9
Feared I would be harmed by animals or insects when I went to urinate.
SIU_10
Feared I would be harmed by someone when I went to urinate.
SIU_11
Feared urinating in the dark at night.
SIU_12
Concerned I would get an infection if I urinated on someone else's urine.
SIU_13
Scared of ghosts when I urinate at night.
SIU_15
Had pain sitting or standing for urination.
SIU_17
Had to suppress urge because people were around and could not go to urinate.
SIU_19
Worried about leaving children, sick, or elderly alone when going for urination.
SIU_20
Had to stop urinating because someone came.
SIU_21
Had trouble finding someone to watch like children, sick or elderly so I could u
SIU_22
Withheld water to control the urge to urinate.
SIU_23
Had to suppress urination when workload was high.
SIU_24
Worried others would get upset if asked to accompany for urination.
SIU_25
Had to suppress urination when I got an urge at night.
SID_26
Worried about not having toilet to defecate.
SID_27
Worried I had to go to a far place to defecate.
SID_28
Worried that defecation process, took a long time to complete.
SID_50
Have had to go back and forth to defecation location because could not find priv
SID_29
Had difficulty getting a clean place for defeaction.
SID_30
Could not access preferred defecation location.
SID_31
Worried I would fall when going to defecate.
SID_32
Had to suppress urge to defecate when workload was high.
SID_33
Feared defecating in the dark at night.
SID_34
Worried people would talk about me if they saw me defecating.
SID_35
Feared I would be harmed by animals or insects when I went to defecate.
SID_37
Worried about getting an infection when going to defecate.
SID_38
Had pain sitting and getting up for defecation.
SID_39
Scared of ghosts when I went to defecate at night.
SID_40
Had difficulty accessing water for washing private parts after defecation.
SID_41
Had difficulty cleaning/washing myself after defecation.
SID_42
Had to suppress urge because I can only defecate at the common defecation times.
SID_43
Feared I would be harmed by someone when I went to defecate.
SID_44
Had trouble finding someone to watch children, sick or elderly so I could defeca
SID_45
Had trouble controlling urge to defecate.
SID_46
Worried about defecating in the same place as others.
SID_47
Withheld food to control urge to defecate.
SID_48
Worried about children, sick or elderly who need me when I go to defecate.
SID_49
Worried that have no money to build or maintain toilet.
CE_1
People in this community live in harmony with each other most of the time.
CE_2
In this community, you have to be careful, otherwise your neighbours may cheat y
CE_3
In this community, conflicts like stealing and fighting often occur.
CE_4
When I am at home alone, I feel safe from threats of crime.
CE_5
Most people in this community have similar beliefs about what is right and what
CE_6
If the people of this community see crime-like activities, they will do somethin
CE_7
If there is a big dispute between two persons, other people from the community w
CE_8
If there is a problem that affects the entire community, for instance, crop dise
CE_9
If someone in this community had a death in their family, the community will com
CE_10
When there is a problem in this community, people come together to discuss how i
CE_11
The people of this community will contribute their own money or labor for commun
CE_12
Differences between people, such as the amount of land they own, often causes pr
CE_13
I feel happy for my neighbour if they have a good harvest.
CE_14
People in this community can be trusted.
CE_15
I typically accept advice from others in this community.
CE_16
People in the community share new knowledge with their neighbour if they learn s
CE_17
This is a close-knit community (i.e., people in this community have close person
CE_18
In this community, people prioritise their own family’s welfare over community d
CE_19
If someone in this community loses a cow or goat, a neighbor will help him look
CE_20
If you suddenly need some money, you can borrow from a person or group in your c
CE_21
If you and your relatives suddenly had to go away for a day or two, you could co
CE_22
There are people in this community who show strong leadership.
CE_23
The community-based associations, such as the Edir, in this community is very ac
CE_24
The leaders of community-based associations, like Edir leaders, respond to this
CE_25
Formal administrative leaders, like the kebele manager, provide support to this
CE_26
This community’s leaders can be trusted.
CE_27
People in this community get to choose the leaders of their own community-based
CE_28
In this community, I have friends with whom I can share my problems.
CE_29
My neighbours sometimes come to me to share their problems and get help.
CE_30
Most people in this community participate in community associations.
CE_31
I attend meetings of a community-based association, such as the Edir.
CE_32
I participate in activities held by any community-based associations, such as th
CE_33
I attend the meetings of any government or NGO-initiated community development g
CE_34
I participate in activities held by any government or NGO-initiated community de
CE_35
When community groups make decisions, they are pleasing and good for most of the
CE_36
Sometimes people need to bribe community leaders in order to get things done.
CE_37
During a crisis situation, such as a drought, government services are distribute
CE_38
Some households in this community are restricted from community services, such a
CE_39
Most people in this community have common values, for example, they value hard w
CE_40
Most people in this community have similar hopes about the future development of
CE_41
People in this community share the same ideas on how village matters should be m
CE_42
People in this community accept me as a member of the community.
CE_43
I feel attached to this community and its people.
CE_44
I feel proud to be part of this community.
CE_45
Being a member of this community is part of who I am.
CE_46
I have the capacity to achieve my future aims.
CE_47
I have the ability to contribute to this community’s development.
CE_48
People in this community have the capacity to make positive changes by coming to
CE_49
This community needs assistance from others outside the community in order to ma
CE_50
People in this community should work together to develop the community.
F_1_1
Suddenly scared for no reason -
F_1_2
Feeling fearful -
F_1_3
Faintness, dizziness or weakness -
F_1_4
Nervousness or shakiness inside -
F_1_5
Heart pounding or racing -
F_1_6
Trembling -
F_1_7
Feeling tense or keyed up -
F_1_8
Headaches -
F_1_9
Spell of terror or panic -
F_1_10
Feeling restless or can’t sit still -
F_2_1
Feeling low in energy, slowed down -
F_2_2
Blaming yourself for things -
F_2_3
Crying easily -
F_2_4
Poor appetite -
F_2_5
Difficulty falling asleep, staying asleep -
F_2_6
Feeling hopeless about future -
F_2_7
Feeling blue -
F_2_8
Feeling lonely -
F_2_9
Feeling of being trapped or caught -
F_2_10
Worry too much about things -
F_2_11
Feeling no interest in things -
F_2_12
Feeling everything is an effort -
F_2_13
Feeling of worthlessness -
F_3_1
I have felt cheerful and in good spirits -
F_3_2
I have felt calm and relaxed -
F_3_3
I have felt active and vigorous -
F_3_4
I woke up feeling fresh and rested -
F_3_5
My daily life has been filled with things that interest me -
F_3_6
Are you currenlty ill?
An_1
Last night, where did you keep your animals?
H_1
Ask: How do you dispose of the animal faeces/waste in your compound?
H_3
ASK: How do you dispose of solid waste (e.g., rubbish)?
wash_stat
Does your household have any hand or facewashing stations?
G_4_3_1a
OBSERVE: What are the components of the washing station:
G_4_3_2
OBSERVE: Location of the handwashing/facewashing station
G_4_3_2a
OBSERVE: Whether this a mobile or fixed-point washing station
G_4_3_1
OBSERVE: Presence/absence of water at handwashing/facewashing stations
G_4_3_3
OBSERVE: Prsenece/absence of soap or soap substitute (e.g., soapy water, ash) at
G_4_2_19
OBSERVE: Is there evidence of open defecation (i.e., human faeces) in or near th
H_2
OBSERVE: How does the household appear to be disposing of the animal faeces/wast
H_4
OBSERVE: How does the household appear to be disposing of solid waste?
H_5
OBSERVE: Is there animal faeces present in the compound?
EY_1
EYE SWAB: Enter the number of the color on the scale that most closely matches t
NC_1
HAND SWAB: Enter the number of the color scale that most closely matches the dar
add_info
Enumerator: Please provide details regarding any issues related to this survey.
Z_1
SURVEY RESULT
end
end time
resp_shoe
OBSERVE: Did the respondent wear shoes to walk to the latrine?
G_3_1_7
Who OWNS this household latrine?
G_3_1_6
Has any member of your household used this latrine for 3 or more days during the
G_3_1_8
During the LAST 7 days, how many households have USED this household latrine?
G_1_2
During the LAST 7 days, NOT INCLUDING your household members, how many people us
G_3_1_9
Who chose the design for this latrine?
G_3_1_10
During the last 7 days, including today, how many times was this latrine cleaned
G_3_1_11
In what month and year was the ORIGINAL latrine construction completed?
G_3_1_12
What is the MAIN reason you decided to construct the latrine at that time?
G_3_1_13
Did someone from your household contribute labor for the ORIGINAL construction o
G_3_1_14
Was this person trained in latrine construction?
G_3_1_16
Are you satisfied, dissatisfied, or neither satisfied nor dissatisfied in the la
G_3_1_17
Have you ever fixed anything that became broken, damaged, our worn out on this l
G_3_1_15
Have you added or improved anything on this latrine to upgrade it since its orig
G_4_1_1
Is your latrine facility working (operating) correctly now?
G_4_1_2
Do you consider your latrine facility, as it is today, fully constructed?
G_4_1_4
What is the below ground structure of the facility?
G_4_1_5
How many pits does this latrine have?
G_4_1_3
How deep is this latrine pit?
Total: 339
12>
Back to Catalog
The World Bank Working for a World Free of Poverty
  • IBRD IDA IFC MIGA ICSID

© The World Bank Group, All Rights Reserved.

This site uses cookies to optimize functionality and give you the best possible experience. If you continue to navigate this website beyond this page, cookies will be placed on your browser. To learn more about cookies, click here.