Home / Central Data Catalog / ETH_2017-2019_ISCLTSH-IE_V01_M
central

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
Producer(s)
Matthew C. Freeman, Abebe Gebremariam Gobezayehu
Metadata
Documentation in PDF DDI/XML JSON
Study website
Created on
Feb 27, 2024
Last modified
Feb 27, 2024
Page views
18040
Downloads
83

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
Back to Catalog