The World Bank Working for a World Free of Poverty Microdata Library
  • Data Catalog
  • About
  • Collections
  • Citations
  • Terms of use
  • Login
    Login
    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
75847
Downloads
966
  • Study Description
  • Data Description
  • Documentation
  • Get Microdata
  • Data files
  • all_hh_lat_baseline_0723.dta
  • all_hh_lat_endline_0723.dta
  • all_hh_lat_midline_0723.dta
  • all_hh_members_baseline_0723.dta
  • all_hh_members_endline_0723.dta
  • all_hh_members_midline_0723.dta

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
The World Bank Working for a World Free of Poverty
  • IBRD IDA IFC MIGA ICSID

© The World Bank Group, All Rights Reserved.

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.