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

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