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
73461
Downloads
956

Data file: all_hh_lat_midline_0723.dta

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

Cases: 1595
Variables: 309

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)
calculate_date
Date
round
Data collection round:
A_1_11
Enumerator/Surveillance Officer name & code:
A_1_6
Kebele name:
A_1_7
Gott name:
A_1_3
HH# - non-specific HH id
A_1_3_check
HH# - non-specific HH id, double check
base_hoh_name
name of the HEAD OF HOUSEHOLD during BASELINE
base_hoh_check
name of the HEAD OF HOUSEHOLD during BASELINE, double check
mid_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
mid_3
Enumerator, ask respondent: Does HH's index child still live in this household?
new_index
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_5c
What is your religion?
A_2_1_5d
What is your ethnicity?
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
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
BA_2
If even one person in my household defecates in the open, it may make people in
BA_6
Leaving animal faeces around the household compound can cause people to become s
BA_36
Animal faeces within the household compound does not need to be collected and di
BA_39
There are benefits of maintaining an improved household latrine.
BA_44
Facewashing takes too much water.
BA_45
Handwashing with soap or ash takes too much water.
BA_46
It is not a priority for my family to collect and dispose of animal faeces on ou
BA_52
Most of my relatives, neighbours, and friends believe that all community members
BA_54
Most of my relatives, neighbours, and friends believe that everyone's household
BA_55
Most of my relatives, neighbours, and friends defecate exclusively in a latrine.
BA_57
Most of my relatives, neighbours, and friends collect animal faeces within their
BA_58
Some believe that people should always use a latrine for defecation, others do n
BA_60
Some believe that household compounds should be free of animal faeces, others do
BA_61
This community is committed to having everyone defecate exclusively in a latrine
BA_62
My household is committed to having everyone defecate exclusively in a latrine.
BA_63
My household is committed to repairing our household latrine when it becomes dam
BA_64
My household is committed to upgrading our latrine to improve it.
BA_80
My household intends to construct a latrine.
BA_81
My household intends to continuously repair our household latrine whenever it be
BA_86
My household intends to ensure every member of the household only ever defecates
BA_87
My household intends to ensure we collect and dispose of animal faeces within ou
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.
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
Andilaye_goalcard
OBSERVE and Ask: Does the household have an Andilaye household goalcard?
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?
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?
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?
Total: 309
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.