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
73613
Downloads
960

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

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.