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
18033
Downloads
83

Data file: all_hh_lat_endline_0723.dta

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

Cases: 1570
Variables: 493

Variables

A_1_5
Woreda name:
rand_var
randomization variable, 1=int 0=cont
cltsh
were they cltsh Triggered and/or ODF Certified
cltsh_bin
previous cltsh and ODF, binary (yes vs no)
calculate_date
Date
round
Data collection round:
A_1_11
Enumerator/Surveillance Officer code:
A_1_6
Kebele code:
A_1_3
HH# - non-specific HH id
base_hoh_name
code of the HEAD OF HOUSEHOLD during BASELINE
end_1
Before going to the household, enumerator ASKs THE GUIDE: Does HoH name's househ
A_1_14
Was consent given?
base_hoh
Re-enter the name of the HEAD OF HOUSEHOLD during BASELINE
end_3
Enumerator, ask respondent: Does HH's index child still live in this household?
new_index_end
Is there another child aged 1-10 years living in this household?
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_5a
What is your (respondent's) age?
A_2_1_5b
Indicate respondent's sex:
A_2_1_5g
What is your (respondent's) highest educational attainment?
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_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?
resp_yrs_lived_keb
How long has the primary caregiver/mother of lived in the kebele?
A_2_1_7a
During the last 7 days, how many days has the primary caregiver/mother of index_
A_2_1_7b
Has caregiver held a leadership role in any organization or group established by
A_2_1_7b2
Was the primary caregiver/mother of leadership role in a government or NGO-estab
A_2_1_7b2a
Is the primary caregiver/mother of mid_index_name still currently a leader in th
A_2_1_7b3
Was the primary caregiver/mother of mid_index_name's leadership role in a commun
A_2_1_7b3a
Is the primary caregiver/mother of mid_index_name still currently a leader in th
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_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_1_4o
What is mid_hoh_name's / your (if respondent is HoH) primary source of income?
hoh_yrs_lived_keb
How long has mid_hoh_name / you (if respondent is HoH) lived in kebele?
A_1_4q
During the last 7 days, how many days has mid_hoh_name / your spent in school_le
A_1_4r
During the past 1 year, has mid_hoh_name / have you held a leadership role in an
A_1_4r2
Was mid_hoh_name's / your (if respondent is HoH) leadership role in a governmen
A_1_4r2a
Is mid_hoh_name / are you (if respondent is HoH) still currently a leader in th
A_1_4r3
Was mid_hoh_name's / your (if respondent is HoH) leadership role in a community
A_1_4r3a
Is mid_hoh_name / are you (if respondent is HoH) still currently a leader in thi
A_1_4f
If present, OBSERVE whether hoh_name is wearing shoes.
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
A_2_1_9
past 1 year, has any household member aside from the head of household held a le
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
HWISE_1
In the last 4 weeks, how frequently did you or anyone in your household worry yo
HWISE_2
In the last 4 weeks, how frequently has your household water supply from your ma
HWISE_3
In the last 4 weeks, how frequently has there not been enough water in the house
HWISE_4
In the last 4 weeks, how frequently has your or anyone in your household’s day b
HWISE_5
In the last 4 weeks, how frequently have you or anyone in your household had to
HWISE_6
In the last 4 weeks, how frequently have you or anyone in your household had to
HWISE_7
In the last 4 weeks, how frequently have you or anyone in your household had to
HWISE_8
In the last 4 weeks, how frequently has there not been as much water to drink as
HWISE_9
In the last 4 weeks, how frequently did you or anyone in your household feel ups
HWISE_10
In the last 4 weeks, how frequently have you or anyone in your household gone to
HWISE_11
In the last 4 weeks, how frequently has there been no water whatsoever in your h
HWISE_12
In the last 4 weeks, how frequently have problems with water caused you or anyon
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
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
C_2_4_2_1
OBSERVE and Ask: Does the household have an Andilaye household goalcard?
C_2_4_2_2
Monitoring Matrix
C_2_4_3
Observe: Was the Andilaye Household Goal Card hung in a visible location?
C_2_4_4
Observe: Are there any marks on the Goal Card?
C_2_4_4_1
Sanitation
C_2_4_4_2
Personal Hygiene
C_2_4_4_3
Household Environmental Sanitation
C_2_4_5
Observe: Have any of the aspirational goals been achieved (Gobez large circles)?
C_2_4_6_1
Sanitation
C_2_4_6_2
Personal Hygiene
C_2_4_6_3
Household Environmental Sanitation
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?
EY1
EYE SWAB: Enter the number of the color on the scale that most closely matches t
NC1
HAND SWAB: Enter the number of the color scale that most closely matches the dar
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?
G_5_1
Has this latrine’s pit ever filled completely?
G_5_2
Did you empty the latrine pit?
G_5_3
What was done with the sludge?
G_3_1_3
OBSERVE: Location of latrine:
G_3_1_4
OBSERVE: Type of latrine:
G_3_1_18
OBSERVE: Does the latrine require any obvious repairs?
G_3_1_5
OBSERVE: Is this latrine serviceable, meaning the pit is not overflowing, and th
G_4_1_6
OBSERVE: Status of reserve pit covering:
G_4_1_7
OBSERVE: What material are the walls of the latrine made of?
G_4_1_7a
OBSERVE: Height of latrine super-structure:
G_4_1_8
OBSERVE: Material of latrine door:
G_4_1_9
OBSERVE: Does door close completely?
G_4_1_10
OBSERVE: Material of latrine roof:
G_4_1_10a
OBSERVE: does the latrine roof fully cover the latrine (i.e., no holes or gaps,
G_4_1_11
OBSERVE: Material of latrine floor around pit:
G_4_1_12
OBSERVE: Is the latrine floor a smooth and cleanable surface?
G_4_2_1
OBSERVE: Presence of stagnant water (water log) over the floor, latrine slab?
G_4_2_2
OBSERVE: Evidence of discoloration of slab or floor (e.g., yellow, green or brow
G_4_2_3
OBSERVE: Presence of flies in latrine?
G_4_2_4
OBSERVE: Presence of drop hole cover in the latrine?
G_4_2_5
OBSERVE: Is the drop hole cover currently situated over the latrine drop hole (i
G_4_2_6
OBSERVE: Presence of cleaning agents for washing latrine (inside or within 10 pa
G_4_2_7
OBSERVE: Presence of faeces on floor/slab or other place in the latrine aside fr
G_4_2_8
OBSERVE: Evidence latrine is used for storage or other non-sanitation-related pu
G_4_2_9
OBSERVE: Presence of well-worn path to latrine?
G_4_2_10
OBSERVE: Presence of fresh faeces in the pit or on the floor inside the latrine?
G_4_2_11
OBSERVE: Is the pit that is in use full or close to being full?
G_4_2_12
OBSERVE: Presence of items for anal cleansing, wiping in, near toilet?
G_4_2_13
OBSERVE: Presence of odour from stools or urine in the latrine?
G_4_2_14
OBSERVE: Presence of leaves, spider webs, rubbish, other dirt in or on latrine d
G_4_2_15
OBSERVE: Wet latrine floor?
G_4_2_16
OBSERVE: Presence of water available inside or within 10 paces of the latrine fo
G_4_2_17
OBSERVE: Presence of cleansing agent (soap, detergent, soapy water) inside or wi
G_4_2_18
OBSERVE: Water available inside or within 10 paces of the latrine for flushing o
G_3_1_2
OBSERVE: Enter the number of minutes it takes to walk FROM the latrine to the FR
lat_repeat_num
marks the first latrine in each HH
lat_count
number of latrines per HH
hh_id
Unique HH id
calculate
random number calculation
A_1_7
Gott name:
p2A_1_14
Was consent given by at least one household member who is 18 years or older to p
same_respondent
Is the respondent for this survey the same as the respondent for the day 1 endli
p2A_2_2_7
What is your (respondent's) relation to the head of household?
p2A_2_2_6
What is your marital status?
p2A_2_1_4
What is your (respondent's) role with regard to household caregiving responsibil
p2A_2_1_5b
Indicate respondent's sex:
p2A_2_1_5a
What is your (respondent's) age?
p2A_2_edu
What is your (respondent's) highest level of education?
p2G_1_1
How many household latrines does your household have access to?
BA_4
An improved latrine must have a smooth and cleanable slab.
BA_5
If my children's faces are not washed when they are dirty, others in the communi
BA_6
Leaving animal faeces around the household compound can cause people to become s
BA_7
Having animals around the homestead living quarters brings more flies into the h
BA_8
Flies in the compound can spread disease throughout the community
BA_9
Open defecation can cause members of the community to get sick.
BA_10
Allowing animals to stay in or walk through the homestead living quarters can ma
BA_11
If other households do not use a latrine, it can cause my children to get sick.
BA_12
My children may become sick or lose their eyesight if they have dirty faces.
BA_13
Having dirty hands can cause my children to become sick.
BA_14
Washing my children's faces when they are dirty can keep them healthy.
BA_15
Other people in this community can become sick if I do not wash my hands.
BA_16
My family may become sick if they come in contact with animal faeces.
BA_17
I have the ability to defecate exclusively in a latrine
BA_18
I have the ability to wash my face whenever it is dirty.
BA_19
I have the ability to wash my children's faces whenever they are dirty.
BA_20
I have the ability to wash my hands with soap or ash after defecation.
BA_21
I have the ability to wash my hands with soap or ash after handling child or an
BA_22
I am confident in my ability to wash my hands before preparing and eating food.
BA_23
I have the ability to ensure my children's hands are washed with soap or ash aft
BA_24
I have the ability to ensure my children's hands are washed with soap or ash bef
BA_25
I have the ability to collect and appropriately dispose of animal faeces within
BA_26
My household has the ability to keep animals out of the homestead living quarter
BA_28
At least one member of my household has the skills necessary to build a latrine.
BA_29
When our household latrine pit fills, at least one member of my household has th
BA_30
I know how and when to appropriately dispose of animal faeces within my househol
BA_31
My household lacks the capacity to modify our homestead walls and doors to preve
BA_32
Using a latrine is a disgusting experience.
BA_33
I prefer openly defecating to using my latrine
BA_34
Defecating in the open provides enough privacy for me.
Total: 493
Back to Catalog