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

Created on

Feb 27, 2024

Last modified

Feb 27, 2024

Page views

18038

Downloads

83

Data file: all_hh_members_baseline_0723.dta

This dataset includes baseline survey data with household level information.

Cases:	4829
Variables:	326

Variables

A_1_5

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)

ID

de-identified individual ID, for administrative purposes

calculate_date

round

Data collection round:

A_1_11

Enumerator/Surveillance Officer name & code:

A_1_14

Was consent given?

A_1_13

Is at least one household member between the ages of 1 - 9 years?

A_1_3

HH# - non-specific HH id

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_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?

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_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_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_4f

If present, OBSERVE whether hoh_name is wearing shoes.

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_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

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

D_3_3e

D_3_3f

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

I_1a

Working electricity

I_1b

Functioning radio set

I_1c

Functioning television

I_1d

Functioning bicycle

I_1e

Functioning motorcycle/scooter

I_1f

Functioning car/truck

I_1g

Functioning mobile phone

I_1h

Functioning mitad

I_1i

Functioning kerosene or pressure lamp

I_1j

One or more beds and one or more tables

I_1k

An enclosed bathing area

I_1l

Number of cattle owned by household (cows/bulls/oxen)

I_1m

Number of horses, mules, or donkeys owned by household

I_1n

Number of sheep or goats owned by household

I_1o

Number of chickens owned by household

I_2a

A homestead/house

I_2b

I_2c

I_3

Do any of the members of your household work their own or their family’s agricul

I_4

What is the principal type of fuel for cooking used by your household?

I_5

What was the main source of cash income of all family members in the last one ye

I_6

How well off do you think your household is in relation to other households in t

randomized

Enumerator randomized (1=sanitation insecurity, 2=collective efficacy)

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.

CE_1

People in this community live in harmony with each other most of the time.

CE_2

In this community, you have to be careful, otherwise your neighbours may cheat y

CE_3

In this community, conflicts like stealing and fighting often occur.

CE_4

When I am at home alone, I feel safe from threats of crime.

CE_5

Most people in this community have similar beliefs about what is right and what

CE_6

If the people of this community see crime-like activities, they will do somethin

CE_7

If there is a big dispute between two persons, other people from the community w

CE_8

If there is a problem that affects the entire community, for instance, crop dise

CE_9

If someone in this community had a death in their family, the community will com

CE_10

When there is a problem in this community, people come together to discuss how i

CE_11

The people of this community will contribute their own money or labor for commun

CE_12

Differences between people, such as the amount of land they own, often causes pr

CE_13

I feel happy for my neighbour if they have a good harvest.

CE_14

People in this community can be trusted.

CE_15

I typically accept advice from others in this community.

CE_16

People in the community share new knowledge with their neighbour if they learn s

CE_17

This is a close-knit community (i.e., people in this community have close person

CE_18

In this community, people prioritise their own family’s welfare over community d

CE_19

If someone in this community loses a cow or goat, a neighbor will help him look

CE_20

If you suddenly need some money, you can borrow from a person or group in your c

CE_21

If you and your relatives suddenly had to go away for a day or two, you could co

CE_22

There are people in this community who show strong leadership.

CE_23

The community-based associations, such as the Edir, in this community is very ac

CE_24

The leaders of community-based associations, like Edir leaders, respond to this

CE_25

Formal administrative leaders, like the kebele manager, provide support to this

CE_26

This community’s leaders can be trusted.

CE_27

People in this community get to choose the leaders of their own community-based

CE_28

In this community, I have friends with whom I can share my problems.

CE_29

My neighbours sometimes come to me to share their problems and get help.

CE_30

Most people in this community participate in community associations.

CE_31

I attend meetings of a community-based association, such as the Edir.

CE_32

I participate in activities held by any community-based associations, such as th

CE_33

I attend the meetings of any government or NGO-initiated community development g

CE_34

I participate in activities held by any government or NGO-initiated community de

CE_35

When community groups make decisions, they are pleasing and good for most of the

CE_36

Sometimes people need to bribe community leaders in order to get things done.

CE_37

During a crisis situation, such as a drought, government services are distribute

CE_38

Some households in this community are restricted from community services, such a

CE_39

Most people in this community have common values, for example, they value hard w

CE_40

Most people in this community have similar hopes about the future development of

CE_41

People in this community share the same ideas on how village matters should be m

CE_42

People in this community accept me as a member of the community.

CE_43

I feel attached to this community and its people.

CE_44

I feel proud to be part of this community.

CE_45

Being a member of this community is part of who I am.

CE_46

I have the capacity to achieve my future aims.

CE_47

I have the ability to contribute to this community’s development.

CE_48

People in this community have the capacity to make positive changes by coming to

CE_49

This community needs assistance from others outside the community in order to ma

CE_50

People in this community should work together to develop the community.

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

F_1_7

Feeling tense or keyed up -

F_1_8

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

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

begin_lat_repeat_count

Latrine repeat count

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?

EY_1

EYE SWAB: Enter the number of the color on the scale that most closely matches t

NC_1

HAND SWAB: Enter the number of the color scale that most closely matches the dar

add_info

Enumerator: Please provide details regarding any issues related to this survey.

Z_1

end

hh_name

Household member name:

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

Total: 326

1 2 >

Back to Catalog