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

Data file: all_hh_members_endline_0723.dta

This dataset includes endline survey data with household level information.

Cases: 4461
Variables: 246

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)
start
start time
deviceid
device id
date
today
round
Data collection round:
A_1_11
Enumerator/Surveillance Officer code:
A_1_6
Kebele code:
A_1_7
Gott 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
A_2_2_3
What is hh_name's age (in years):?
A_2_2_4a
FOR ENUMERATORS: Indicate whether hh_name is the index child (index_name):
A_2_2_4
Indicate hh_name's sex:
A_2_2_2
Is hh_name present at the household at the moment (i.e., during the survey)?
A_2_2_9
Is hh_name currently enrolled in school?
A_2_2_12
During the last 7 days, including today, has hh_name gone to fetch water for the
A_2_2_10
Does hh_name have any animal herding or other animal husbandry responsibilities?
A_2_2_11
OBSERVE: whether hh_name is currently wearing shoes
A_2_2_13
During the LAST 2 days, has hh_name had nasal congestion?
A_2_2_15
During the LAST 2 days, has hh_name run a fever?
A_2_2_16a
In the LAST 2 days, has hh_name had three or more loose stools per day (diarrhoe
A_2_2_16b
During the last 7 days, including today, has hh_name had three or more loose sto
A_2_2_16c
During the last 7 days, including today, has hh_name had blood in the stool (dys
A_2_2_17b
During the last 7 days, including today, has hh_name been involved in any accid
A_2_2_17a
During the last 7 days, including today, has hh_name experienced heartburn?
G_2_1_2
During the LAST 2 DAYS, where was hh_name's primary place of defecation?
G_2_1_3
Does the primary place of defecation change for hh_name over the course of the y
G_2_1_4
During the LAST TWO DAYS, did hh_name openly defecate?
G_2_1_7
During the last 2 days, did hh_name openly defecate in or near a surface water s
G_2_1_8
During the last 2 days, did hh_name urinate in or near a surface water source?
G_2_1_5
During the LAST TWO DAYS, did hh_name defecate in ANY latrine?
G_2_1_1
During THE last 7 days, including today, did hh_name ALWAYS EXCLUSIVELY use a la
G_2_1_6
Enumerator: Enter the type of report for hh_name's information:
G_2_1_9
The last time hh_name passed stools, what happened to the stools?
A_2_2_19b
Left hand: fingernail cleanliness
A_2_2_19c
Right hand: fingernail cleanliness
A_2_2_19k
Left hand: length of nails
A_2_2_19l
Right hand: length of nails
A_2_2_19e
Left hand: finger pad cleanliness
A_2_2_19f
Right hand: finter pad cleanliness
A_2_2_19h
Left hand: palms cleanliness
A_2_2_19i
Right hand: palms cleanliness
A_2_2_18a
OBSERVE whether ocular discharge is absent or present on hh_name's face
A_2_2_18b
OBSERVE whether WET nasal discharge is absent or present on hh_name's face
A_2_2_18c
OBSERVE whether DRY nasal discharge is absent or present on hh_name's face
A_2_2_18d
OBSERVE whether other dirt/dust/other debris is absent or present on hh_name's f
A_2_2_18g
Enter the number of times you observed a fly land on index_name's face during th
A2218e
A.2.2.18e
A2218f
A.2.2.18f
hh_id
Unique HH id
enum_HH_members
variable that enumerates each participating HH member
Total: 246
Back to Catalog