DIME-WaSSIP Impact Evaluation - Nairobi DDI_KEN_2015-2019_WASHIE_v01_M_WB Development Economics Data Group 2023-12-11 Metadata Editor Version 01 (December 2023) KEN_2015-2019_WASHIE_v01_M Water and Sanitation Impact Evaluation 2015-2019 Baseline and Endline Survey Aidan Coville Sebastian Galiani Paul Gertler

Nairobi City Water and Sewerage Company staff including Nahashon Muguna, Jackson Munuve, Kagiri Gicheha, Jason Mwangi, Beldina Owade, Christine Machio, Paul Mwarania, Ephantus Mugo, Martin Nangole, Lucy Njambi, Daisy Nyaboke and Owen Wanjala

Christine Ochieng, Paul Mbanga, Wendy Ayres, Rajesh Advani, Jessica Lopez and Clifford Mwaura

Kenya Innovations for Poverty Action (IPA) team provided professional field support throughout the program, with particular thanks to Frank Odhiambo, Bonnyface Mwangi, Geoffrey Onyambu, John Paul Buleti, Allison Stone and Alice Kirungu

Amy Dolinger, Marco Valenza and Duncan Webb. DIME Analytics provided technical support throughout the analysis with Luiza Andrade conducting code reproducibility checks

 Susumu Yoshida Strategic Impact Evaluation Fund Impact Evaluation to Development Impact J-PAL Urban Services Initiative International Growth Center Metadata Editor Other Household Survey [hh/oth] There are 3 rounds for this survey: Baseline Tenant and Property Owner survey (September 2015 - March 2017), Property Owner Listing (August - September 2018), and Endline property owner survey and tenant survey (August - October 2019). We estimate the impacts of two interventions implemented as field experiments in informal settlements by Nairobi’s water and sanitation utility to improve revenue collection efficiency and last mile connection loan repayment: (i) face-to-face engagement between utility staff and customers to encourage payment and (ii) contract enforcement for service disconnection due to nonpayment in the form of transparent and credible disconnection notices. While we find no effect of the engagement, we find large effects of enforcement on payment. We also find no effect on access to water, perceptions of utility fairness or quality of service delivery, on the relationships between tenants and property owners, or on tenant mental well-being nine months after the intervention. To counterbalance the increase in payments, property owners increased rental income by renting out additional space. Taken together these results suggest that transparent contract enforcement was effective at improving revenue collection efficiency without incurring large social or political costs. Kenya Informal settlements in Nairobi, Kenya Sample survey data [ssd] Innovations for Poverty Action Computer Assisted Personal Interview [capi] property_owner_bl.dta 2287 98 .dta Property owner survey baseline dataset property_owner_end.dta 589 181 .dta Property owner survey endline dataset property_owner_outreach.dta 5373 55 .dta Property owner outreach survey dataset tenant_bl.dta 4430 155 .dta Tenant survey baseline dataset tenant_end.dta 404 223 .dta Tenant survey endline dataset Number of compounds 2287 1 5 1 1918 2 226 3 83 4 29 5 31 Compound ID 2287 10001 90321 Survey type 2287 1 2 1 Face to face 1246 2 Phone survey 1041 Gender 2287 0 1 0 Female 921 1 Male 1366 Age 2255 32 25 80 Highest level of education 2266 21 1 6 -79 Refused to answer 0 1 No education 183 2 Some primary 387 3 Completed primary 461 4 Some secondary 251 5 Completed secondary 671 6 More than secondary 313 Sysmiss 21 Primary Occupation 2280 7 1 33 1 Farmer/farm worker 56 2 Public service 33 3 Carpenter/mason 4 4 Clerk 1 5 Policeman 5 6 Conductor 6 7 Cleaner/house help 110 8 Waiter/cook 45 9 Driver 39 10 Electrician 239 11 Mechanic 11 12 Industrial worker 56 13 Manager 81 14 Dairy farmer 361 15 Professional (specify) 6 16 Watchman 25 17 Messenger 2 18 Shop keeper/sales 3 19 Secretary 4 20 Tailor 59 21 Teacher 90 22 Health worker 5 23 Doctor 6 24 Nurse 619 25 Unemployed 1 26 Student 21 27 Business, specify 38 28 Salonist 117 29 Retired 25 30 Landlord 5 31 None 24 32 Housewife 0 33 Other (specify) 183 Sysmiss 7 Sole owner of compound 2287 0 1 0 No 132 1 Yes 2155 Number of co-owners 125 2162 1 5 1 25 2 32 3 14 4 10 5 44 Sysmiss 2162 Ownership share 122 2165 0 75 0 1 2 2 3 3 4 1 5 2 7 1 8 2 10 16 11 1 14 3 15 1 16 1 20 10 22 1 25 12 30 4 33 9 34 1 40 2 43 1 50 47 75 1 Sysmiss 2165 Time owned this compound: Years 2239 48 0 54 0 14 1 27 2 53 3 98 4 64 5 136 6 75 7 87 8 100 9 66 10 194 11 30 12 56 13 33 14 28 15 135 16 42 17 41 18 38 19 27 20 174 21 41 22 41 23 64 24 64 25 168 26 105 27 125 28 40 29 4 30 28 31 1 32 2 33 3 34 2 35 9 36 3 37 8 38 2 39 2 40 4 45 2 46 1 51 1 54 1 Sysmiss 48 Time owned this compound: Months 2263 24 0 35 0 1959 1 5 2 20 3 14 4 9 5 27 6 35 7 6 8 39 9 75 10 52 11 17 12 3 16 1 35 1 Sysmiss 24 How landlord acquired the compound 2275 12 1 3 -79 Refused to answer 0 1 Inherited 312 2 Free of charge 683 3 Purchased 1280 Sysmiss 12 Amount acquired this compound 1087 1200 1 15 -79 Refused to answer 0 1 0 - 100,000 349 2 100,001 - 200,000 233 3 200,001 - 300,000 183 4 300,001 - 400,000 95 5 400,001 - 500,000 98 6 0.5 - 1 million 85 7 1 - 1.5 million 24 8 1.5 - 2 million 14 9 2 - 2.5 million 2 10 2.5 - 3 million 1 11 3 - 3.5 million 0 12 3.5 - 4 million 1 13 4 - 4.5 million 1 14 4.5 - 5 million 0 15 5 - 6 million 1 16 6 - 7 million 0 17 7 - 8 million 0 18 8 - 9 million 0 19 9 - 10 million 0 20 Over 10 million 0 Sysmiss 1200 Compound is paid off fully 1280 1007 0 1 0 No 34 1 Yes 1246 Sysmiss 1007 Amount owed on mortgage 24 2263 1 6 -79 Refused to answer 0 1 0 - 100,000 10 2 100,001 - 200,000 3 3 200,001 - 300,000 3 4 300,001 - 400,000 2 5 400,001 - 500,000 1 6 0.5 - 1 million 5 7 1 - 1.5 million 0 8 1.5 - 2 million 0 9 2 - 2.5 million 0 10 2.5 - 3 million 0 11 3 - 3.5 million 0 12 3.5 - 4 million 0 13 4 - 4.5 million 0 14 4.5 - 5 million 0 15 5 - 6 million 0 16 6 - 7 million 0 17 7 - 8 million 0 18 8 - 9 million 0 19 9 - 10 million 0 20 Over 10 million 0 Sysmiss 2263 Estimated sale price of compound (if had to sell now) 1789 498 1 20 -79 Refused to answer 0 1 0 - 100,000 20 2 100,001 - 200,000 39 3 200,001 - 300,000 32 4 300,001 - 400,000 19 5 400,001 - 500,000 88 6 0.5 - 1 million 271 7 1 - 1.5 million 392 8 1.5 - 2 million 259 9 2 - 2.5 million 193 10 2.5 - 3 million 130 11 3 - 3.5 million 83 12 3.5 - 4 million 45 13 4 - 4.5 million 41 14 4.5 - 5 million 57 15 5 - 6 million 40 16 6 - 7 million 13 17 7 - 8 million 11 18 8 - 9 million 3 19 9 - 10 million 23 20 Over 10 million 30 Sysmiss 498 Number of stories in main structure 2287 1 5 -96 More than five 0 1 One 2094 2 Two 154 3 Three 25 4 Four 11 5 Five 3 Owner occupied (owner lives there without renting out) 2287 0 1 0 No 1204 1 Yes 1083 Months landlord has resided in compound (in last 12 months) 2280 7 0 12 0 1168 1 32 2 13 3 15 4 7 5 3 6 22 7 8 8 7 9 7 10 8 11 3 12 987 Sysmiss 7 Compound has rental dwellings 2287 0 1 0 No 406 1 Yes 1881 Number of rental dwellings in compound 1881 406 1 79 1 54 2 136 3 126 4 151 5 175 6 181 7 193 8 207 9 145 10 193 11 91 12 60 13 34 14 22 15 23 16 16 17 5 18 10 19 3 20 15 21 6 22 4 23 3 24 4 25 3 26 1 28 5 29 2 30 3 33 1 35 1 40 3 46 1 48 1 52 1 59 1 79 1 Sysmiss 406 Number of paying tenants 1880 407 0 59 0 66 1 93 2 176 3 152 4 198 5 211 6 206 7 173 8 161 9 116 10 127 11 61 12 33 13 15 14 11 15 21 16 12 17 6 18 5 19 2 20 10 21 4 23 3 24 4 25 3 27 1 28 2 29 1 30 1 39 1 40 2 43 1 52 1 59 1 Sysmiss 407 Had paying tenants in this compound last month 1881 406 0 1 0 No 89 1 Yes 1792 Sysmiss 406 Monthly rental income (KES) 1743 544 0 147500 Number of tenants failed to pay rent last month 1769 518 0 29 0 1004 1 272 2 231 3 143 4 58 5 29 6 11 7 6 8 5 9 2 10 4 11 2 18 1 29 1 Sysmiss 518 Non-paid rent (KES) 757 1530 500 58000 Percentage of total income from this property's rental 1698 589 0 100 Who collects rent for the compound 1812 475 1 5 1 Myself 1221 2 Another family member 206 3 A paid rent collector 281 4 Friend 66 5 Other (specify) 38 Sysmiss 475 Payment for rent collector 593 1694 0 1 0 No 268 1 Yes 325 Sysmiss 1694 Payment for rent collector (KES) 311 1976 0 10000 0 2 200 3 300 3 400 4 500 23 600 3 700 4 750 2 800 2 900 1 1000 47 1050 1 1200 6 1300 5 1400 3 1500 32 1600 1 1800 5 1960 1 2000 63 2300 3 2400 1 2500 17 2750 1 3000 28 3500 7 4000 12 4500 3 5000 9 5300 1 5600 1 6000 7 7000 5 7500 3 8000 1 10000 1 Sysmiss 1976 Compound is connected to electricity grid 2287 0 1 0 No 344 1 Yes 1943 Connection is in working condition 1943 344 0 1 0 No 88 1 Yes 1855 Sysmiss 344 How electricity is paid 1926 361 1 5 -79 Refused to answer 0 1 Landlord pays entire electricity bill 576 2 Landlord pays the electricity bill and charge separately 22 3 Landlord pays the electricity bill and it is included in the rent 189 4 Tenants pay the electricity bill directly to the utility company 1062 5 Shared payment between landlord and tenants 77 Sysmiss 361 Monthly electricity bill (KES) 1543 744 0 25000 Compound is connected to piped water 2287 0 1 0 No 498 1 Yes 1789 Water connection is in working condition 1789 498 0 1 0 No 335 1 Yes 1454 Sysmiss 498 Water is paid for the entire compound 1525 762 0 1 0 No 123 1 Yes 1402 Sysmiss 762 Water bill last month (KES) 1522 765 0 17000 Average water bill per month (KES) 1256 1031 0 8000 Average total monthly maintenance expenditure (KES) 2149 138 0 100000 Will connect to sewerage system when available 2287 0 1 0 No 68 1 Yes 2219 Number of toilet facilities (rooms) 2281 6 0 15 0 111 1 1280 2 721 3 72 4 45 5 12 6 18 7 2 8 11 9 3 10 1 12 2 13 1 15 2 Sysmiss 6 Number of pits or septic tanks 2278 9 0 6 0 445 1 1764 2 56 3 6 4 4 5 1 6 2 Sysmiss 9 Service payments for waste removal 2287 0 1 0 No 795 1 Yes 1492 Number of times per year for waste removal 1475 812 0 4500 0 46 1 262 2 314 3 286 4 207 5 57 6 124 7 3 8 12 9 1 10 10 12 133 20 1 24 14 36 1 48 1 96 1 4000 1 4500 1 Sysmiss 812 Payment for waste removal 1454 833 -1000 36000 Willing to pay Ksh 600/- monthly for connection and upgrade 2287 0 1 0 No 1377 1 Yes 910 Willing to pay Ksh 500/- monthly for connection and upgrade 1377 910 0 1 0 No 1214 1 Yes 163 Sysmiss 910 Willing to pay Ksh 400/- monthly for connection and upgrade 1214 1073 0 1 0 No 1040 1 Yes 174 Sysmiss 1073 Willing to pay Ksh 300/- monthly for connection and upgrade 1040 1247 0 1 0 No 656 1 Yes 384 Sysmiss 1247 Willing to pay Ksh 200/- monthly for connection and upgrade 656 1631 0 1 0 No 374 1 Yes 282 Sysmiss 1631 Willing to pay Ksh 100/- monthly for connection and upgrade 374 1913 0 1 0 No 197 1 Yes 177 Sysmiss 1913 Willing to pay Ksh 60/- monthly for connection and upgrade 197 2090 0 1 0 No 125 1 Yes 72 Sysmiss 2090 Frequency of communication with tenants 1873 414 1 7 -79 Refused to answer 0 1 Daily 755 2 Weekly 237 3 Few times a month 344 4 Once a month 271 5 Few times a year 180 6 Yearly 20 7 Never 66 Sysmiss 414 Number of paying tenants that moved out in the last 12 months 1797 490 0 30 0 427 1 274 2 327 3 265 4 125 5 136 6 80 7 24 8 28 9 5 10 55 11 3 12 24 15 12 18 2 20 9 30 1 Sysmiss 490 Average time tenants stay: Years 1829 458 0 21 0 407 1 381 2 325 3 236 4 106 5 162 6 41 7 30 8 34 9 7 10 64 11 3 12 5 13 4 14 2 15 9 16 1 18 3 20 8 21 1 Sysmiss 458 Average time tenants stay: Months 1835 452 0 12 0 1249 1 24 2 67 3 86 4 50 5 91 6 165 7 11 8 42 9 27 10 8 11 6 12 9 Sysmiss 452 Tenants pay their rent on time 1786 501 1 4 -99 Don't know (managed by somebody else) 0 -79 Refused to answer 0 1 Very likely 423 2 Somewhat likely 560 3 Somewhat unlikely 381 4 Very unlikely 422 Sysmiss 501 Tenants keep the compound in a good condition 1815 472 1 4 -99 Don't know (managed by somebody else) 0 -79 Refused to answer 0 1 Very likely 826 2 Somewhat likely 666 3 Somewhat unlikely 185 4 Very unlikely 138 Sysmiss 472 Tenants request improvements in the compound 1815 472 1 4 -99 Don't know (managed by somebody else) 0 -79 Refused to answer 0 1 Very likely 669 2 Somewhat likely 611 3 Somewhat unlikely 275 4 Very unlikely 260 Sysmiss 472 Tenants complain about conditions in the compound 1810 477 1 4 -99 Don't know (managed by somebody else) 0 -79 Refused to answer 0 1 Very likely 408 2 Somewhat likely 541 3 Somewhat unlikely 333 4 Very unlikely 528 Sysmiss 477 Number of properties owned 2286 1 0 5 0 11 1 893 2 948 3 279 4 78 5 77 Sysmiss 1 Number of properties receive rental income 2245 42 0 17 0 380 1 1381 2 332 3 102 4 23 5 9 6 4 7 2 8 8 10 2 13 1 17 1 Sysmiss 42 Total rental income last month (KES) 443 1844 49 800000 Percentage of total income came from rental income 1884 403 0 100 Ownership documents: Title deed 2287 0 1 0 No 2261 1 Yes 26 Ownership documents: Municipal (allotment) letter 2287 0 1 0 No 218 1 Yes 2069 Ownership documents: Letter from the chief 2287 0 1 0 No 2229 1 Yes 58 Ownership documents: No documentation 2287 0 1 0 No 2273 1 Yes 14 Reason will connect: Cheaper in the long run 2287 0 1 0 No 770 1 Yes 1517 Reason will connect: Healthier environment for tenants 2287 0 1 0 No 400 1 Yes 1887 Reason will connect: Better convenience for tenants 2287 0 1 0 No 1902 1 Yes 385 Reason will connect: Requirement by County Government 2287 0 1 0 No 2206 1 Yes 81 Reason will connect: Only available option 2287 0 1 0 No 2203 1 Yes 84 Reason will connect: Better rental income 2287 0 1 0 No 2084 1 Yes 203 Reason will connect: Attract better tenants 2287 0 1 0 No 1969 1 Yes 318 Reason will connect: Reduce tenant turnover rates 2287 0 1 0 No 2168 1 Yes 119 Reason will connect: Increase value of compound 2287 0 1 0 No 1974 1 Yes 313 Reason will not connect: Cannot afford the upfront costs 2287 0 1 0 No 2263 1 Yes 24 Reason will not connect: Not worth the additional costs 2287 0 1 0 No 2275 1 Yes 12 Reason will not connect: Current facilities are sufficient 2287 0 1 0 No 2261 1 Yes 26 Reason will not connect: Connection will be of poor quality 2287 0 1 0 No 2282 1 Yes 5 Reason will not connect: Connection will take too long to receive 2287 0 1 0 No 2277 1 Yes 10 Reason will not connect: Do not trust the water and sewerage company 2287 0 1 0 No 2286 1 Yes 1 Reason will not connect: Maintenance will be too costly 2287 0 1 0 No 2282 1 Yes 5 Reason will not connect: Connection will be of poor quality 2287 0 1 0 No 2281 1 Yes 6 Current toilet: Flush toilet 2287 0 1 0 No 2202 1 Yes 85 Current toilet: Pour flush 2287 0 1 0 No 1513 1 Yes 774 Current toilet: Ventilated improved pit latrine 2287 0 1 0 No 1838 1 Yes 449 Current toilet: Pit latrine with slab 2287 0 1 0 No 1494 1 Yes 793 Current toilet: Composting toilet 2287 0 1 0 No 2285 1 Yes 2 Current toilet: Pit latrine without slab / open pit 2287 0 1 0 No 2169 1 Yes 118 Current toilet: Bucket 2287 0 1 0 No 2286 1 Yes 1 Current toilet: Hanging toilet / hanging latrine 2287 0 1 0 No 2285 1 Yes 2 Current toilet: Plastic bag system (flying toilet) 2287 0 1 0 No 2286 1 Yes 1 Current toilet: Peepoo 2287 0 1 0 No 2286 1 Yes 1 Current toilet: No Facility 2287 0 0 No 2287 1 Yes 0 Account number (masked) 589 Survey type 589 1 2 1 Face to Face 509 2 Phone survey 80 Respondent is landlord 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 138 1 Yes 451 Relationship with landlord 138 451 1 2 0 Other 0 1 Spouse 35 2 Care Taker 103 Sysmiss 451 Landlord available to talk 586 3 1 1 -999 Don't know 0 -777 Not Applicable 0 0 No 0 1 Yes 586 Sysmiss 3 Compound type 589 1 3 1 Landord and tenants both stay in the compound 170 2 Only tenants stay in the compound 207 3 This is a landlord only compound 212 Gender 589 1 2 1 Male 387 2 Female 202 Age 570 19 25 80 Highest level of completed education 589 1 6 1 No education 40 2 Some primary 60 3 Completed primary 108 4 Some secondary 60 5 Completed secondary 174 6 More than secondary 147 Primary occupation 491 98 1 32 -888 Other 0 1 Farmer/farm worker 56 2 Public service 11 3 Carpenter/mason 11 4 Clerk 2 5 Policeman 7 6 Conductor 2 7 Cleaner/house help 2 8 Waiter/cook 3 9 Driver 22 10 Electrician 9 11 Mechanic 11 12 Industrial worker 12 13 Manager 2 14 Dairy farmer 0 15 Professional (specify) 20 16 Watchman 4 17 Messenger 1 18 Shop keeper/sales 31 19 Secretary 4 20 Tailor 7 21 Teacher 10 22 Health worker 2 23 Doctor 1 24 Nurse 1 25 Unemployed 15 26 Student 0 27 Business, specify 145 28 Salonist 3 29 Retired 21 30 Landlord 42 31 None 24 32 Housewife 10 Sysmiss 98 Ethnic group 579 10 1 37 -999 Dont Know 0 -998 Refused 0 -888 Other 0 1 Akamba(Kamba) 75 2 Boni 0 3 Boran 8 4 Elkony 0 5 Elmolo 0 6 Embu 4 7 Gabbra 0 8 Galla (Oromo) 0 9 Gikuyu (Kikuyu) 344 10 Giriama (Giryama) 0 11 Gusii (Kisii) 36 12 Iteso (Teso) 0 13 Kalenjin 0 14 Keiyo 0 15 Kikuyu (Gikuyu) 0 16 Kipsigis 2 17 Kuria 1 18 Luhya 35 19 Luo 63 20 Marakwet 0 21 Masai (Maasai) 2 22 Mbeere 0 23 Meru 5 24 Njemps 0 25 Orma 0 26 Oromo (Galla) 0 27 Pakot 0 28 Pokomo 0 29 Pokot 0 30 Rendille 0 31 Sabaot 0 32 Samburu 0 33 Segeju 0 34 Somali (Issa) 2 35 Swahili 0 36 Taita 1 37 Taveta 1 38 Terik 0 40 Tharaka 0 41 Tugen 0 42 Turkana 0 43 Nandi 0 Sysmiss 10 Sole owner of compound 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 37 1 Yes 552 Number of co-owners 37 552 1 13 1 8 2 12 3 4 4 5 5 4 8 1 9 1 10 1 13 1 Sysmiss 552 Ownership share 37 552 10 50 10 1 13 1 20 5 25 7 30 2 33 1 36 1 50 19 Sysmiss 552 Ownerhship docs: Title deed 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 578 1 Yes 11 Ownerhship docs: Municipal (allotment) letter 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 104 1 Yes 485 Ownerhship docs: Letter from the chief 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 565 1 Yes 24 Ownerhship docs: No documentation 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 584 1 Yes 5 Ownerhship docs: Share certificate 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 513 1 Yes 76 Ownerhship docs: Other 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 568 1 Yes 21 Ownership duration: Years 552 37 0 41 0 4 1 1 2 12 3 19 4 16 5 21 6 15 7 27 8 13 9 14 10 56 11 21 12 39 13 14 14 16 15 22 16 12 17 16 18 14 19 26 20 33 21 7 22 6 23 8 24 6 25 14 26 5 27 10 28 23 29 18 30 22 31 14 32 3 36 1 37 1 39 1 40 1 41 1 Sysmiss 37 Ownership duration: Months 485 104 0 11 0 327 1 12 2 24 3 22 4 10 5 26 6 24 7 5 8 23 9 3 10 4 11 5 Sysmiss 104 Ownership acquired 589 1 3 1 Inherited 78 2 Acquired free of charge 118 3 Purchased 393 4 Leased property (For mbotela residents) 0 Paid off fully 393 196 1 2 1 Owned and fully paid off 387 2 Currently paying off 6 Sysmiss 196 Mortgage balance 4 585 50000 1260000 50000 1 150000 1 200000 1 1260000 1 Sysmiss 585 Compound value 445 144 0 30000000 Compound is primary residence 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 285 1 Yes 304 Months resided in compound in the past 12 months 304 285 0 12 0 2 1 1 2 4 3 3 4 2 5 4 6 4 7 2 8 3 9 2 10 2 11 2 12 273 Sysmiss 285 Compound has rental dwellings 568 21 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 197 1 Yes 371 Sysmiss 21 Number of rental dwellings 371 218 0 56 0 1 1 37 2 28 3 46 4 30 5 35 6 30 7 36 8 33 9 23 10 24 11 7 12 12 13 5 14 6 15 2 16 1 17 1 18 3 20 2 21 1 22 1 23 1 26 1 27 1 30 1 33 1 35 1 56 1 Sysmiss 218 Number of paying tenants 369 220 0 54 0 10 1 47 2 55 3 53 4 32 5 42 6 29 7 24 8 23 9 12 10 15 11 6 12 5 14 1 15 4 16 1 18 1 19 2 20 1 21 1 27 1 28 1 30 2 54 1 Sysmiss 220 Paying tenants in last month 371 218 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 23 1 Yes 348 Sysmiss 218 Rental income received last month 328 261 0 149000 Tenants failed to pay rent last month 348 241 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 162 1 Yes 186 Sysmiss 241 Number of tenants failed to pay rent last month 184 405 1 17 1 74 2 53 3 32 4 9 5 5 6 6 7 2 10 2 17 1 Sysmiss 405 Value of non-paid rentals last month 179 410 2 110000 2 1 500 1 1000 2 1300 1 1500 10 1800 2 2000 25 2400 1 2500 9 2700 1 2850 1 3000 19 3500 1 3600 2 4000 15 4400 1 4500 6 4700 1 4800 1 5000 13 5100 1 6000 20 6500 1 6800 1 7500 8 8000 7 9000 5 10000 4 10500 2 11000 1 12000 2 13000 1 13500 1 14500 1 15000 5 16000 1 17500 1 19000 1 20000 1 21000 1 110000 1 Sysmiss 410 Percentage of total income from this property rental 320 269 0 100 Who collects rent 345 244 1 5 -888 Other 0 1 Myself (for LL only compounds) 186 2 Another family member 36 3 A paid rent collector(House Agents/Caretaker) 90 4 Friend; 2 5 Tenants pay directly to bank account/ mpesa 31 Sysmiss 244 Increased or decreased rents in this compound in the last 6 months 371 218 1 3 1 Increased 13 2 Decreased 17 3 No change 341 Sysmiss 218 Reasons decreased your rent 13 576 1 4 -888 Other 0 1 poor water/sanitation services 5 2 trying to retain good tenants 2 3 deterioration of living conditions other that water and sanitation services 2 4 hard to find new tenants 4 Sysmiss 576 Repair contact 185 404 1 2 -888 Other 0 1 Me directly 165 2 A repairman/caretaker 20 Sysmiss 404 Connected to electricity grid 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 51 1 Yes 538 Connected to electricity grid is in working condition 538 51 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 16 1 Yes 522 Sysmiss 51 Who pays electricity for the compound 537 52 1 4 -998 Refused to answer 0 1 Landlord pays the electricity bill and charge separately 7 2 Landlord pays the electricity bill and it is included in the rent 43 3 Tenants pay the electricity bill directly to the utility company 225 4 Myself 262 Sysmiss 52 Monthly electricity bill 6 583 500 2500 500 1 1000 2 1500 1 1800 1 2500 1 Sysmiss 583 Connected to piped water 538 51 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 21 1 Yes 517 Sysmiss 51 Connected to piped water is currently working 517 72 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 191 1 Yes 326 Sysmiss 72 Who pays for the water 517 72 1 5 -998 Refused to answer 0 1 Landlord pays the water bill and charge separately 13 2 Landlord pays the water bill and it is included in the rent 97 3 Tenants pay the water bill directly to the utility company 11 4 Don't pay since compound doesnt receive water 105 5 Myself 291 Sysmiss 72 Monthly water bill 289 300 100 12000 100 1 120 1 150 1 200 3 250 3 275 1 300 16 336 1 350 2 400 24 407 1 420 1 430 1 450 6 460 1 500 44 600 16 700 9 800 14 850 1 900 2 1000 42 1050 1 1200 11 1300 1 1400 1 1500 11 1543 1 1600 1 1700 1 1800 4 2000 29 2500 4 2600 1 2700 1 3000 12 3800 1 4000 4 4075 1 5000 7 6000 2 7000 1 8000 1 10000 1 12000 1 Sysmiss 300 Connected to the sewerage system 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 20 1 Yes 569 Why connected: It’s cheaper than current sanitation costs in the long run 569 20 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 399 1 Yes 170 Sysmiss 20 Why connected: To provide a healthier environment for tenants 569 20 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 204 1 Yes 365 Sysmiss 20 Why connected: To provide increased convenience for tenants 569 20 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 528 1 Yes 41 Sysmiss 20 Why connected: It is a requirement by County Government 569 20 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 426 1 Yes 143 Sysmiss 20 Why connected: It is the only available option 569 20 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 503 1 Yes 66 Sysmiss 20 Why connected: I can receive better rental income 569 20 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 562 1 Yes 7 Sysmiss 20 Why connected: To attract better tenants 569 20 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 563 1 Yes 6 Sysmiss 20 Why connected: To reduce tenant turnover rates 569 20 0 -999 Don't know 0 -777 Not Applicable 0 0 No 569 1 Yes 0 Sysmiss 20 Why connected: Increase value of compound 569 20 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 564 1 Yes 5 Sysmiss 20 Why connected: Other 569 20 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 452 1 Yes 117 Sysmiss 20 Why not connected: I cannot afford the upfront costs 20 569 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 15 1 Yes 5 Sysmiss 569 Why not connected: It is not worth the additional costs 20 569 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 19 1 Yes 1 Sysmiss 569 Why not connected: Current sanitation facilities are sufficient 20 569 0 -999 Don't know 0 -777 Not Applicable 0 0 No 20 1 Yes 0 Sysmiss 569 Why not connected: No water connection 20 569 0 -999 Don't know 0 -777 Not Applicable 0 0 No 20 1 Yes 0 Sysmiss 569 Why not connected: The connection will be of poor quality 20 569 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 18 1 Yes 2 Sysmiss 569 Why not connected: The connection will take too long to receive 20 569 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 17 1 Yes 3 Sysmiss 569 Why not connected: I do not trust the water and sewerage company 20 569 0 -999 Don't know 0 -777 Not Applicable 0 0 No 20 1 Yes 0 Sysmiss 569 Why not connected: Maintenance will be too costly 20 569 0 -999 Don't know 0 -777 Not Applicable 0 0 No 20 1 Yes 0 Sysmiss 569 Why not connected: The compound was disconnected by NCWSC 20 569 0 -999 Don't know 0 -777 Not Applicable 0 0 No 20 1 Yes 0 Sysmiss 569 Why not connected: Other 20 569 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 9 1 Yes 11 Sysmiss 569 How often speaks with tenants 371 218 1 5 1 Daily 129 2 Weekly 42 3 A few times a month 60 4 Once a month 64 5 Less than once a month 76 Sysmiss 218 Number of tenants moved out in the last 6 months 364 225 0 15 0 125 1 75 2 47 3 61 4 17 5 14 6 10 7 2 8 4 10 7 15 2 Sysmiss 225 Tenant stay duration: Years 354 235 0 16 0 113 1 85 2 63 3 28 4 14 5 24 6 9 7 1 8 3 10 12 14 1 16 1 Sysmiss 235 Tenant stay duration: Months 349 240 -99 11 -99 1 0 170 1 10 2 19 3 31 4 12 5 18 6 66 7 4 8 13 9 2 10 1 11 2 Sysmiss 240 Tenants pay their rent on time 371 218 1 4 1 Very likely 35 2 Somewhat likely 98 3 Somewhat unlikely 125 4 Very unlikely 113 Sysmiss 218 Tenants keep the compound in a good condition 371 218 1 4 1 Very likely 163 2 Somewhat likely 132 3 Somewhat unlikely 44 4 Very unlikely 32 Sysmiss 218 Tenants request improvements in the compound 371 218 1 4 1 Very likely 100 2 Somewhat likely 152 3 Somewhat unlikely 55 4 Very unlikely 64 Sysmiss 218 Tenants complain about conditions in the compound 371 218 1 4 1 Very likely 57 2 Somewhat likely 95 3 Somewhat unlikely 86 4 Very unlikely 133 Sysmiss 218 New tenant: Amount of deposit provided 371 218 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 339 1 Yes 32 Sysmiss 218 New tenant: Proof of income sources able to cover rent 371 218 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 217 1 Yes 154 Sysmiss 218 New tenant: Friend or family member 371 218 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 353 1 Yes 18 Sysmiss 218 New tenant: Good references 371 218 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 324 1 Yes 47 Sysmiss 218 New tenant: Nice person/people 371 218 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 243 1 Yes 128 Sysmiss 218 New tenant: Prominent member(s) of the community 371 218 0 -999 Don't know 0 -777 Not Applicable 0 0 No 371 1 Yes 0 Sysmiss 218 New tenant: Number of conditions for lease 371 218 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 324 1 Yes 47 Sysmiss 218 New tenant: Willingness to take a longer lease 371 218 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 367 1 Yes 4 Sysmiss 218 New tenant: Good behaviour/ Responsible 371 218 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 215 1 Yes 156 Sysmiss 218 New tenant: Other 371 218 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 216 1 Yes 155 Sysmiss 218 Properties owned 571 18 1 3 1 426 2 104 3 41 Sysmiss 18 Properties receive rental income 578 11 0 3 0 212 1 325 2 32 3 9 Sysmiss 11 Rental income from all properties last month 342 247 0 248000 Percentage of total income from rental income 368 221 1 100 Total income last month 458 131 0 748000 Water and sanitation fees applied by Nairobi Water are fair 537 52 1 4 -999 Don't know 0 -555 Not applicable 0 1 Strongly agree 49 2 Agree 183 3 Disagree 135 4 Strongly disagree 170 Sysmiss 52 If you don’t pay fees, there is a strong chance of disconnection 567 22 1 4 -999 Don't know 0 -555 Not applicable 0 1 Strongly agree 354 2 Agree 180 3 Disagree 19 4 Strongly disagree 14 Sysmiss 22 The approach Nairobi Water uses to enforce repayments is fair 544 45 1 4 -999 Don't know 0 -555 Not applicable 0 1 Strongly agree 78 2 Agree 206 3 Disagree 123 4 Strongly disagree 137 Sysmiss 45 I am satisfied with the water and/or sanitation services I receive 573 16 1 4 -999 Don't know 0 -555 Not applicable 0 1 Strongly agree 46 2 Agree 132 3 Disagree 142 4 Strongly disagree 253 Sysmiss 16 The government is interested in improving the living conditions 551 38 1 4 -999 Don't know 0 -555 Not applicable 0 1 Strongly agree 120 2 Agree 273 3 Disagree 79 4 Strongly disagree 79 Sysmiss 38 Water and sewer fees are affordable 536 53 1 4 -999 Don't know 0 -555 Not applicable 0 1 Strongly agree 70 2 Agree 250 3 Disagree 118 4 Strongly disagree 98 Sysmiss 53 Nairobi Water provides clear communication to us 555 34 1 4 -999 Don't know 0 -555 Not applicable 0 1 Strongly agree 81 2 Agree 200 3 Disagree 114 4 Strongly disagree 160 Sysmiss 34 The water and sanitation services improve people’s lives 573 16 1 4 -999 Don't know 0 -555 Not applicable 0 1 Strongly agree 179 2 Agree 252 3 Disagree 72 4 Strongly disagree 70 Sysmiss 16 The government is not interested in helping us 551 38 1 4 -999 Don't know 0 -555 Not applicable 0 1 Strongly agree 59 2 Agree 107 3 Disagree 236 4 Strongly disagree 149 Sysmiss 38 Water and sanitation services in general helps improve people’s lives 581 8 1 4 -999 Don't know 0 -555 Not applicable 0 1 Strongly agree 305 2 Agree 237 3 Disagree 30 4 Strongly disagree 9 Sysmiss 8 The water bills are accurate 463 126 1 4 -999 Don't know 0 -555 Not applicable 0 1 Strongly agree 49 2 Agree 137 3 Disagree 102 4 Strongly disagree 175 Sysmiss 126 The jisomee mita system is easy to use 440 149 1 4 -999 Don't know 0 -555 Not applicable 0 1 Strongly agree 175 2 Agree 173 3 Disagree 61 4 Strongly disagree 31 Sysmiss 149 Tenants appreciate the water and sanitation services provided in my compound 359 230 1 4 -999 Don't know 0 -555 Not applicable 0 1 Strongly agree 70 2 Agree 103 3 Disagree 102 4 Strongly disagree 84 Sysmiss 230 Illegal connections are common in settlement 428 161 1 4 -999 Don't know 0 -555 Not applicable 0 1 Strongly agree 34 2 Agree 106 3 Disagree 134 4 Strongly disagree 154 Sysmiss 161 Proportion of people in settlement have illegal water connnection 276 313 0 100 0 99 1 12 2 10 3 2 5 17 10 45 20 23 25 3 30 15 40 9 50 17 60 5 65 1 70 8 80 4 85 1 90 2 98 1 99 1 100 1 Sysmiss 313 Non-payment of water and sanitation bills are common in my settlement 455 134 1 4 -999 Don't know 0 -555 Not applicable 0 1 Strongly agree 90 2 Agree 210 3 Disagree 104 4 Strongly disagree 51 Sysmiss 134 Proportion of people in your settlement do you think pay all of their water 353 236 0 100 0 11 1 1 3 1 5 5 8 1 10 23 15 3 20 35 25 4 30 31 40 23 45 7 50 78 55 2 60 23 65 2 70 34 75 3 78 1 80 30 85 1 90 20 95 4 98 1 99 2 100 7 Sysmiss 236 Paid off sewer loan 554 35 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 484 1 Yes 70 Sysmiss 35 Paid off water loan 562 27 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 445 1 Yes 117 Sysmiss 27 Outstanding water/sewer loan balance 219 370 5000 35000 5000 68 15000 49 25000 89 35000 13 Sysmiss 370 Days in the last week received water 574 15 0 7 0 396 1 136 2 30 3 3 4 1 6 3 7 5 Sysmiss 15 Improve service: Water Services improvement 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 61 1 Yes 528 Improve service: Sewer Services improvement 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 270 1 Yes 319 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 468 1 Yes 121 Improve service: Customer Services improvement 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 519 1 Yes 70 Improve service: Other 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 428 1 Yes 161 Paid an upfront deposit to be connected to the sewer 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 57 1 Yes 532 Amount paid for an upfront deposit to be connected to the sewer 392 197 425 10000 Knows average monthly water and sanitation service charge 589 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 373 1 Yes 216 Average monthly water and sanitation service charge 196 393 50 3500 50 1 150 7 175 2 200 7 240 3 250 11 254 4 258 1 260 1 270 1 300 2 340 1 400 12 407 10 408 1 425 1 437 1 450 75 460 1 490 1 500 10 550 1 600 2 650 1 700 5 720 1 800 4 805 1 850 6 857 3 900 3 950 1 1000 5 1200 2 1300 1 1500 2 1590 1 2000 2 3400 1 3500 1 Sysmiss 393 Tenants have ever discussed water and sanitation bills 371 218 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 285 1 Yes 86 Sysmiss 218 What tenants discussed about water and sanitation bills 86 503 1 3 1 Water bills 52 2 Sewer bills 1 3 Both water and bill issues 33 Sysmiss 503 Tenants ever complained about the water and sewer facilities 371 218 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 83 1 Yes 288 Sysmiss 218 Complaints were justified 288 301 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 5 1 Yes 283 Sysmiss 301 Main source of water used by the members of this compound 186 403 1 7 -888 Other 0 1 Pipe connected 68 2 Piped, notin plot 16 3 Borehole on plot 10 4 Borehole off plot 43 5 Open well, on plot 0 6 Open well, off plot 0 7 Water vendor 49 Sysmiss 403 Source has running water at the time of the interview 144 445 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 120 1 Yes 24 Sysmiss 445 Days with water: Monday 193 396 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 160 1 Yes 33 Sysmiss 396 Days with water: Tuesday 193 396 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 153 1 Yes 40 Sysmiss 396 Days with water: Wednesday 193 396 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 161 1 Yes 32 Sysmiss 396 Days with water: Thursday 193 396 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 162 1 Yes 31 Sysmiss 396 Days with water: Friday 193 396 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 163 1 Yes 30 Sysmiss 396 Days with water: Saturday 193 396 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 139 1 Yes 54 Sysmiss 396 Days with water: Sunday 193 396 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 153 1 Yes 40 Sysmiss 396 Days with water: Don't know 193 396 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 133 1 Yes 60 Sysmiss 396 Number of households using this facility 176 413 0 500 0 5 1 144 2 7 3 2 5 1 10 2 50 1 80 1 100 2 200 3 250 1 300 2 500 5 Sysmiss 413 Main water source in the compound 212 377 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 130 1 Yes 82 Sysmiss 377 Time in minutes to collect water from this source 128 461 0 180 0 4 1 4 2 7 5 20 8 1 10 26 12 1 15 6 20 15 25 1 30 25 35 1 40 1 45 1 60 10 120 4 180 1 Sysmiss 461 Times in a typical week collect water from this source 124 465 0 35 0 5 1 24 2 16 3 13 4 10 5 6 6 5 7 22 9 1 10 5 12 1 13 1 14 4 20 1 21 5 28 1 30 2 32 1 35 1 Sysmiss 465 Satisfaction with main water source 212 377 1 4 1 Very satisfied 29 2 Somewhat satisfied 57 3 Somewhat unsatisfied 54 4 Very unsatisfied 72 Sysmiss 377 Pay for use of main water source 212 377 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 31 1 Yes 181 Sysmiss 377 Amount paid for use of main water source 168 421 2 6000 2 11 3 15 4 1 5 39 10 17 15 7 20 18 25 1 30 3 60 1 200 5 240 1 300 4 380 1 400 2 420 1 450 3 500 5 600 1 700 1 800 2 1000 7 1200 1 1500 4 1700 1 1800 1 2000 6 2400 1 2500 2 2800 1 3000 1 4000 1 5000 1 6000 2 Sysmiss 421 Units of measurement 190 399 1 3 -888 Other, specify 0 1 Per jerican 125 2 Per month for piped water 52 3 Per trip for water boozer/ water vendor 13 Sysmiss 399 Main sanitation facility is within the compound 212 377 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 3 1 Yes 209 Sysmiss 377 Time to walk to the sanitation facility 3 586 0 2 0 1 2 2 Sysmiss 586 Satisfaction with your main sanitation facilities 212 377 1 4 1 Very satisfied 119 2 Somewhat satisfied 54 3 Somewhat unsatisfied 21 4 Very unsatisfied 18 Sysmiss 377 Pay for use of your main sanitation facilities 212 377 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 210 1 Yes 2 Sysmiss 377 Amount paid for use of your main sanitation facilities per visit 2 587 400 450 400 1 450 1 Sysmiss 587 How often pay for use of main sanitation facilities per day 2 587 4 4 -888 Other, specify 0 1 Per use 0 2 Per day 0 3 Per week 0 4 Per month 2 Sysmiss 587 Number of toilet facilities in compound 211 378 0 16 0 2 1 47 2 145 3 8 4 5 5 1 6 1 16 2 Sysmiss 378 Main toilet facility currently used 212 377 1 3 1 Flush/Pour flush 207 2 Ventilated improved pit latrine 0 3 Pit latrine with slab 5 4 Composting toilet 0 5 Pit latrine without slab / open pit 0 6 Bucket 0 7 Hanging toilet / hanging latrine 0 8 Plastic bag system (flying toilet) 0 9 Peepoo 0 Sysmiss 377 Where flush toilet or pour flush is connected to 207 382 1 4 1 Connected to piped sewer system 197 2 Connected to septic tank 6 3 Connected to pit latrine 0 4 Flush/pour to don't know where 4 Sysmiss 382 Features: Latrine elevated (built above ground) 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 131 1 Yes 61 Sysmiss 397 Features: Foot rests 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 156 1 Yes 36 Sysmiss 397 Features: Seat 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 186 1 Yes 6 Sysmiss 397 Features: Floor tiles 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 169 1 Yes 23 Sysmiss 397 Features: Wall tiles 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 171 1 Yes 21 Sysmiss 397 Features: Hole cover 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 188 1 Yes 4 Sysmiss 397 Features: Water seal 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 70 1 Yes 122 Sysmiss 397 Features: Couldnotobserve 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 182 1 Yes 10 Sysmiss 397 Features: Other 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 189 1 Yes 3 Sysmiss 397 Superstructure: Roof 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 23 1 Yes 169 Sysmiss 397 Superstructure: Fully enclosed wall 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 41 1 Yes 151 Sysmiss 397 Superstructure: Partially enclosed wall 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 166 1 Yes 26 Sysmiss 397 Superstructure: Full door 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 43 1 Yes 149 Sysmiss 397 Superstructure: Half door 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 185 1 Yes 7 Sysmiss 397 Superstructure: Lockable door 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 62 1 Yes 130 Sysmiss 397 Superstructure: Curtain 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 183 1 Yes 9 Sysmiss 397 Superstructure: No superstructure 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 191 1 Yes 1 Sysmiss 397 Superstructure: Could not observe 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 182 1 Yes 10 Sysmiss 397 Superstructure: Other 192 397 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 188 1 Yes 4 Sysmiss 397 Handwashing station 212 377 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 95 1 Yes 117 Sysmiss 377 Water storage tank 212 377 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 30 1 Yes 182 Sysmiss 377 Toilet facility is private or shared 212 377 1 2 1 Private 205 2 Shared by several compounds 7 3 Public/used by all 0 Sysmiss 377 Households that use facility 211 378 0 100 0 12 1 174 2 9 3 5 4 3 5 2 6 1 7 1 8 1 9 1 50 1 100 1 Sysmiss 378 Toilet facility is flooded or blocked 212 377 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 197 1 Yes 15 Sysmiss 377 Water meter installed 212 377 0 1 -999 Don't know 0 -777 Not Applicable 0 0 No 21 1 Yes 191 Sysmiss 377 Water meter in working condition 191 398 0 2 0 No 50 1 Yes 123 2 Not observable 18 Sysmiss 398 Current meter reading 171 418 5 250 5 46 15 23 25 9 35 13 45 14 55 11 65 8 75 5 85 4 95 6 150 17 250 15 Sysmiss 418 Account number (masked) 5373 Plot owner 5373 1 3 1 Yes, and the details are correct 5133 2 Yes, but the plot details are incorrect 0 3 No, I do not own a plot 240 Representative for plot owner 240 5133 1 1 -9 Refuse to answer 0 -8 Don't Know 0 0 No 0 1 Yes 240 Sysmiss 5133 Relationship to plot owner 240 5133 1 8 -9 Refuse to answer 0 1 Parent 28 2 Child 51 3 Brother / Sister 37 4 Other family member 61 5 Friend 8 6 Caretaker 27 7 I don't know the plot owner 0 8 Other 28 Sysmiss 5133 Support the plot owner in maintaining/managing/financing the plot 240 5133 1 1 -9 Refuse to answer 0 -8 Don't Know 0 0 No 0 1 Yes 240 Sysmiss 5133 Baseline landlord known 288 5085 0 98 -9 Refuse to answer 0 -8 Don't Know 0 0 No 156 1 Yes 92 3 39 98 1 Sysmiss 5085 Relationship to baseline landlord 90 5283 1 98 -9 Refuse to answer 0 -8 Don't Know 0 1 Parent 13 2 Child 8 3 Brother / Sister 14 4 Spouse 15 5 Other family member 6 6 Friend 3 7 Caretaker 15 8 Former Plot Owner 6 98 Other (Specify) 10 Sysmiss 5283 Baseline landlord supports in maintaining/managing/financing the plot 91 5282 0 1 -9 Refuse to answer 0 -8 Don't Know 0 0 No 16 1 Yes 75 Sysmiss 5282 Residents in this plot 4904 469 0 800 Reason no residents 338 5035 1 98 -9 Refuse to answer 0 -8 Don't know 0 1 Plot in construction / refurbishment 205 2 Plot converted to building (e.g. school, church) 82 98 Other (Specify) 51 Sysmiss 5035 Households that pay rent 4762 611 0 300 0 2129 1 899 2 264 3 312 4 263 5 212 6 184 7 138 8 106 9 53 10 84 11 13 12 19 13 5 14 17 15 17 16 3 17 2 18 2 19 4 20 11 21 2 22 1 23 1 25 4 26 1 28 2 29 1 30 5 40 1 42 1 50 1 77 1 90 1 121 1 210 1 300 1 Sysmiss 611 Water connection from Nairobi Water 5334 39 0 1 -9 Refuse to answer 0 -8 Don't Know 0 0 No 67 1 Yes 5267 Sysmiss 39 Sewer connection from Nairobi Water 5310 63 0 1 -9 Refuse to answer 0 -8 Don't Know 0 0 No 159 1 Yes 5151 Sysmiss 63 Received water in the last week 4546 827 0 1 -9 Refuse to answer 0 -8 Don't Know 0 0 No 2482 1 Yes 2064 Sysmiss 827 Days received water: Monday 2064 3309 0 1 0 No 1673 1 Yes 391 Sysmiss 3309 Days received water: Tuesday 2064 3309 0 1 0 No 1692 1 Yes 372 Sysmiss 3309 Days received water: Wednesday 2064 3309 0 1 0 No 1703 1 Yes 361 Sysmiss 3309 Days received water: Thursday 2064 3309 0 1 0 No 1711 1 Yes 353 Sysmiss 3309 Days received water: Friday 2064 3309 0 1 0 No 1756 1 Yes 308 Sysmiss 3309 Days received water: Saturday 2064 3309 0 1 0 No 1276 1 Yes 788 Sysmiss 3309 Days received water: Sunday 2064 3309 0 1 0 No 1478 1 Yes 586 Sysmiss 3309 Days received water: Don't Know 2064 3309 0 1 0 No 1821 1 Yes 243 Sysmiss 3309 Days received water: Refuse to answer 2064 3309 0 1 0 No 2062 1 Yes 2 Sysmiss 3309 Resident of this plot 5352 21 0 1 -9 Refuse to answer 0 -8 Don't Know 0 0 No 1920 1 Yes 3432 Sysmiss 21 Plot owner is a resident of this plot 239 5134 0 1 -9 Refuse to answer 0 -8 Don't Know 0 0 No 134 1 Yes 105 Sysmiss 5134 Who pays the water bills 5317 56 1 7 -9 Refuse to answer 0 -8 Don't Know 0 1 Myself 4663 2 Plot Owner 87 3 Caretaker 120 4 Family Member / Spouse 279 5 Tenants 34 6 Nobody 98 7 Other 36 Sysmiss 56 Never paid: Don't have money 2429 2944 0 1 0 No 2036 1 Yes 393 Sysmiss 2944 Never paid: Don't have time 2429 2944 0 1 0 No 2358 1 Yes 71 Sysmiss 2944 Never paid: Don't know how to make payment 2429 2944 0 1 0 No 2098 1 Yes 331 Sysmiss 2944 Never paid: Account is not set up yet 2429 2944 0 1 0 No 2355 1 Yes 74 Sysmiss 2944 Never paid: Meter is broken 2429 2944 0 1 0 No 2398 1 Yes 31 Sysmiss 2944 Never paid: Didn't receive water 2429 2944 0 1 0 No 1205 1 Yes 1224 Sysmiss 2944 Never paid: Payment system was not working 2429 2944 0 1 0 No 2418 1 Yes 11 Sysmiss 2944 Never paid: Didn't know that I need to pay 2429 2944 0 1 0 No 2249 1 Yes 180 Sysmiss 2944 Never paid: I'm not responsible for making the payments 2429 2944 0 1 0 No 2384 1 Yes 45 Sysmiss 2944 Never paid: Other 2429 2944 0 1 0 No 2213 1 Yes 216 Sysmiss 2944 Never paid: Don't Know 2429 2944 0 1 0 No 2355 1 Yes 74 Sysmiss 2944 Never paid: Refuse to answer 2429 2944 0 1 0 No 2412 1 Yes 17 Sysmiss 2944 Not paid in 2 months: Don't have money 1357 4016 0 1 0 No 952 1 Yes 405 Sysmiss 4016 Not paid in 2 months: Don't have time 1357 4016 0 1 0 No 1297 1 Yes 60 Sysmiss 4016 Not paid in 2 months: Don't know how to make payment 1357 4016 0 1 0 No 1270 1 Yes 87 Sysmiss 4016 Not paid in 2 months: Account is not set up yet 1357 4016 0 1 0 No 1347 1 Yes 10 Sysmiss 4016 Not paid in 2 months: Meter is broken 1357 4016 0 1 0 No 1347 1 Yes 10 Sysmiss 4016 Not paid in 2 months: Didn't receive water 1357 4016 0 1 0 No 790 1 Yes 567 Sysmiss 4016 Not paid in 2 months: Payment system was not working 1357 4016 0 1 0 No 1347 1 Yes 10 Sysmiss 4016 Not paid in 2 months: Didn't know that I need to pay 1357 4016 0 1 0 No 1300 1 Yes 57 Sysmiss 4016 Not paid in 2 months: I'm not responsible for making the payments 1357 4016 0 1 0 No 1331 1 Yes 26 Sysmiss 4016 Not paid in 2 months: Other 1357 4016 0 1 0 No 1181 1 Yes 176 Sysmiss 4016 Not paid in 2 months: Don't Know 1357 4016 0 1 0 No 1325 1 Yes 32 Sysmiss 4016 Not paid in 2 months: Refuse to answer 1357 4016 0 1 0 No 1352 1 Yes 5 Sysmiss 4016 Need help in how to verify your account information 5324 49 0 1 -9 Refuse to answer 0 -8 Don't Know 0 0 No 759 1 Yes 4565 Sysmiss 49 Know how to read meter 5299 74 0 1 -9 Refuse to answer 0 -8 Don't Know 0 0 No 2695 1 Yes 2604 Sysmiss 74 Know how to check balance 5302 71 0 1 -9 Refuse to answer 0 -8 Don't Know 0 0 No 3800 1 Yes 1502 Sysmiss 71 Know how to pay bill 5305 68 0 1 -9 Refuse to answer 0 -8 Don't Know 0 0 No 3030 1 Yes 2275 Sysmiss 68 Tenants 5373 0 1 0 2740 1 2633 Compound ID 4430 10001 90321 Dwellings in compound 4430 0 66 0 6 1 126 2 96 3 102 4 144 5 175 6 275 7 393 8 478 9 539 10 467 11 547 12 284 13 232 14 91 15 84 16 67 17 37 18 35 19 9 20 52 21 28 22 21 23 10 24 13 25 10 26 6 27 3 28 26 29 3 30 7 32 9 33 6 34 5 35 7 36 3 39 6 40 3 41 1 44 2 45 6 50 1 54 3 55 3 57 3 62 3 66 3 Survey type 4430 1 4 1 Tenant_1 1840 2 Tenant_2 1511 3 Tenant_3 827 4 Landlord 252 Landlord resides in compound 3771 659 0 1 -99 Don't know 0 0 No 2257 1 Yes 1514 Sysmiss 659 Relationship with landlord 4430 * 1 Family 0 2 Friends 0 3 New owners, ${landlord_name} is old owner 0 4 Never heard of ${landlord_name} 0 5 other 0 Sysmiss 4430 Household size 4178 252 1 10 1 639 2 769 3 1068 4 915 5 468 6 199 7 67 8 40 9 10 10 3 Sysmiss 252 Household members 4143 287 1 10 1 631 2 759 3 1058 4 909 5 467 6 199 7 67 8 40 9 10 10 3 Sysmiss 287 Relationship to household head 4178 252 0 10 -99 Don't know 0 0 Not related 24 1 Head him/herself 3255 2 Wife or husband 786 3 Son or daughter 50 4 Son-in-law or daughter-in-law 1 5 Grandchild 0 6 Parent 4 7 Parent-in-law 0 8 Brother or sister 38 9 Other relative 19 10 Adopted/foster/stepchild 1 Sysmiss 252 Gender 4178 252 1 2 1 Male 2661 2 Female 1517 Sysmiss 252 Currently attending school 4178 252 0 1 -99 Don't know 0 0 No 4073 1 Yes 105 Sysmiss 252 Highest level of education completed 4135 295 1 19 -99 No education 0 0 Pre-Primary 0 1 Class 1 10 2 Class 2 9 3 Class 3 23 4 Class 4 34 5 Class 5 51 6 Class 6 105 7 Class 7 239 8 Class 8 1118 9 Form 1 156 10 Form 2 315 11 Form 3 192 12 Form 4 1427 13 University 1 13 14 University 2 19 15 University 3 12 16 University 4 39 17 Post-university 2 18 Vocational 335 19 Other 36 Sysmiss 295 Relationship to household head 3537 893 0 9 -99 Don't know 0 0 Not related 34 1 Head him/herself 664 2 Wife or husband 1966 3 Son or daughter 632 4 Son-in-law or daughter-in-law 0 5 Grandchild 9 6 Parent 1 7 Parent-in-law 0 8 Brother or sister 146 9 Other relative 85 10 Adopted/foster/stepchild 0 Sysmiss 893 Gender 3539 891 1 2 1 Male 1115 2 Female 2424 Sysmiss 891 Currently attending school 3539 891 0 1 -99 Don't know 0 0 No 3057 1 Yes 482 Sysmiss 891 Highest level of education completed 3342 1088 0 19 -99 No education 0 0 Pre-Primary 40 1 Class 1 36 2 Class 2 39 3 Class 3 46 4 Class 4 40 5 Class 5 65 6 Class 6 98 7 Class 7 168 8 Class 8 956 9 Form 1 131 10 Form 2 244 11 Form 3 159 12 Form 4 1025 13 University 1 12 14 University 2 14 15 University 3 6 16 University 4 21 17 Post-university 6 18 Vocational 218 19 Other 18 Sysmiss 1088 Relationship to household head 2770 1660 0 10 -99 Don't know 0 0 Not related 16 1 Head him/herself 113 2 Wife or husband 27 3 Son or daughter 2408 4 Son-in-law or daughter-in-law 1 5 Grandchild 24 6 Parent 6 7 Parent-in-law 0 8 Brother or sister 73 9 Other relative 101 10 Adopted/foster/stepchild 1 Sysmiss 1660 Gender 2770 1660 1 2 1 Male 1385 2 Female 1385 Sysmiss 1660 Currently attending school 2770 1660 0 1 -99 Don't know 0 0 No 1156 1 Yes 1614 Sysmiss 1660 Highest level of education completed 1751 2679 0 19 -99 No education 0 0 Pre-Primary 287 1 Class 1 127 2 Class 2 133 3 Class 3 125 4 Class 4 126 5 Class 5 106 6 Class 6 96 7 Class 7 85 8 Class 8 156 9 Form 1 70 10 Form 2 70 11 Form 3 60 12 Form 4 193 13 University 1 6 14 University 2 2 15 University 3 1 16 University 4 2 17 Post-university 0 18 Vocational 54 19 Other 52 Sysmiss 2679 Relationship to household head 1702 2728 0 10 -99 Don't know 0 0 Not related 5 1 Head him/herself 71 2 Wife or husband 13 3 Son or daughter 1505 4 Son-in-law or daughter-in-law 6 5 Grandchild 23 6 Parent 4 7 Parent-in-law 0 8 Brother or sister 26 9 Other relative 47 10 Adopted/foster/stepchild 2 Sysmiss 2728 Gender 1703 2727 1 2 1 Male 878 2 Female 825 Sysmiss 2727 Currently attending school 1703 2727 0 1 -99 Don't know 0 0 No 682 1 Yes 1021 Sysmiss 2727 Highest level of education completed 972 3458 0 19 -99 No education 0 0 Pre-Primary 200 1 Class 1 89 2 Class 2 76 3 Class 3 73 4 Class 4 51 5 Class 5 53 6 Class 6 65 7 Class 7 50 8 Class 8 85 9 Form 1 33 10 Form 2 33 11 Form 3 23 12 Form 4 75 13 University 1 3 14 University 2 1 15 University 3 0 16 University 4 1 17 Post-university 1 18 Vocational 18 19 Other 42 Sysmiss 3458 Relationship to household head 787 3643 0 10 -99 Don't know 0 0 Not related 2 1 Head him/herself 37 2 Wife or husband 8 3 Son or daughter 684 4 Son-in-law or daughter-in-law 1 5 Grandchild 14 6 Parent 3 7 Parent-in-law 0 8 Brother or sister 7 9 Other relative 29 10 Adopted/foster/stepchild 2 Sysmiss 3643 Gender 787 3643 1 2 1 Male 410 2 Female 377 Sysmiss 3643 Currently attending school 787 3643 0 1 -99 Don't know 0 0 No 342 1 Yes 445 Sysmiss 3643 Highest level of education completed 449 3981 0 19 -99 No education 0 0 Pre-Primary 80 1 Class 1 39 2 Class 2 42 3 Class 3 45 4 Class 4 34 5 Class 5 35 6 Class 6 26 7 Class 7 20 8 Class 8 27 9 Form 1 11 10 Form 2 10 11 Form 3 5 12 Form 4 41 13 University 1 2 14 University 2 2 15 University 3 0 16 University 4 0 17 Post-university 2 18 Vocational 6 19 Other 22 Sysmiss 3981 Relationship to household head 320 4110 0 10 -99 Don't know 0 0 Not related 2 1 Head him/herself 10 2 Wife or husband 4 3 Son or daughter 252 4 Son-in-law or daughter-in-law 4 5 Grandchild 14 6 Parent 1 7 Parent-in-law 0 8 Brother or sister 4 9 Other relative 27 10 Adopted/foster/stepchild 2 Sysmiss 4110 Gender 320 4110 1 2 1 Male 172 2 Female 148 Sysmiss 4110 Currently attending school 320 4110 0 1 -99 Don't know 0 0 No 120 1 Yes 200 Sysmiss 4110 Highest level of education completed 189 4241 0 19 -99 No education 0 0 Pre-Primary 44 1 Class 1 17 2 Class 2 16 3 Class 3 13 4 Class 4 22 5 Class 5 12 6 Class 6 5 7 Class 7 6 8 Class 8 16 9 Form 1 5 10 Form 2 3 11 Form 3 3 12 Form 4 11 13 University 1 0 14 University 2 0 15 University 3 0 16 University 4 1 17 Post-university 0 18 Vocational 7 19 Other 8 Sysmiss 4241 Relationship to household head 120 4310 1 9 -99 Don't know 0 0 Not related 0 1 Head him/herself 7 2 Wife or husband 2 3 Son or daughter 81 4 Son-in-law or daughter-in-law 0 5 Grandchild 13 6 Parent 0 7 Parent-in-law 0 8 Brother or sister 5 9 Other relative 12 10 Adopted/foster/stepchild 0 Sysmiss 4310 Gender 120 4310 1 2 1 Male 72 2 Female 48 Sysmiss 4310 Currently attending school 120 4310 0 1 -99 Don't know 0 0 No 55 1 Yes 65 Sysmiss 4310 Highest level of education completed 68 4362 0 19 -99 No education 0 0 Pre-Primary 11 1 Class 1 8 2 Class 2 6 3 Class 3 6 4 Class 4 2 5 Class 5 5 6 Class 6 4 7 Class 7 4 8 Class 8 6 9 Form 1 2 10 Form 2 4 11 Form 3 1 12 Form 4 6 13 University 1 0 14 University 2 0 15 University 3 0 16 University 4 0 17 Post-university 0 18 Vocational 2 19 Other 1 Sysmiss 4362 Relationship to household head 54 4376 0 10 -99 Don't know 0 0 Not related 1 1 Head him/herself 5 2 Wife or husband 1 3 Son or daughter 37 4 Son-in-law or daughter-in-law 1 5 Grandchild 3 6 Parent 0 7 Parent-in-law 0 8 Brother or sister 1 9 Other relative 4 10 Adopted/foster/stepchild 1 Sysmiss 4376 Gender 54 4376 1 2 1 Male 26 2 Female 28 Sysmiss 4376 Currently attending school 54 4376 0 1 -99 Don't know 0 0 No 28 1 Yes 26 Sysmiss 4376 Highest level of education completed 26 4404 0 18 -99 No education 0 0 Pre-Primary 4 1 Class 1 2 2 Class 2 4 3 Class 3 2 4 Class 4 0 5 Class 5 3 6 Class 6 1 7 Class 7 1 8 Class 8 3 9 Form 1 0 10 Form 2 1 11 Form 3 1 12 Form 4 3 13 University 1 0 14 University 2 0 15 University 3 0 16 University 4 0 17 Post-university 0 18 Vocational 1 19 Other 0 Sysmiss 4404 Relationship to household head 13 4417 2 9 -99 Don't know 0 0 Not related 0 1 Head him/herself 0 2 Wife or husband 1 3 Son or daughter 6 4 Son-in-law or daughter-in-law 0 5 Grandchild 3 6 Parent 0 7 Parent-in-law 1 8 Brother or sister 1 9 Other relative 1 10 Adopted/foster/stepchild 0 Sysmiss 4417 Gender 13 4417 1 2 1 Male 7 2 Female 6 Sysmiss 4417 Currently attending school 13 4417 0 1 -99 Don't know 0 0 No 8 1 Yes 5 Sysmiss 4417 Highest level of education completed 7 4423 0 12 -99 No education 0 0 Pre-Primary 1 1 Class 1 1 2 Class 2 1 3 Class 3 1 4 Class 4 1 5 Class 5 0 6 Class 6 1 7 Class 7 0 8 Class 8 0 9 Form 1 0 10 Form 2 0 11 Form 3 0 12 Form 4 1 13 University 1 0 14 University 2 0 15 University 3 0 16 University 4 0 17 Post-university 0 18 Vocational 0 19 Other 0 Sysmiss 4423 Relationship to household head 3 4427 3 9 -99 Don't know 0 0 Not related 0 1 Head him/herself 0 2 Wife or husband 0 3 Son or daughter 1 4 Son-in-law or daughter-in-law 0 5 Grandchild 1 6 Parent 0 7 Parent-in-law 0 8 Brother or sister 0 9 Other relative 1 10 Adopted/foster/stepchild 0 Sysmiss 4427 Gender 3 4427 1 2 1 Male 1 2 Female 2 Sysmiss 4427 Currently attending school 3 4427 0 1 -99 Don't know 0 0 No 2 1 Yes 1 Sysmiss 4427 Highest level of education completed 1 4429 0 -99 No education 0 0 Pre-Primary 1 1 Class 1 0 2 Class 2 0 3 Class 3 0 4 Class 4 0 5 Class 5 0 6 Class 6 0 7 Class 7 0 8 Class 8 0 9 Form 1 0 10 Form 2 0 11 Form 3 0 12 Form 4 0 13 University 1 0 14 University 2 0 15 University 3 0 16 University 4 0 17 Post-university 0 18 Vocational 0 19 Other 0 Sysmiss 4429 Dwellings in compound 4428 2 0 66 0 7 1 135 2 98 3 109 4 146 5 168 6 274 7 393 8 474 9 539 10 472 11 535 12 289 13 228 14 91 15 83 16 63 17 36 18 37 19 10 20 52 21 26 22 21 23 13 24 11 25 10 26 7 27 4 28 25 29 2 30 6 32 9 33 6 34 5 35 8 36 2 39 6 40 3 41 1 44 2 45 6 50 1 54 3 55 3 57 3 62 3 66 3 Sysmiss 2 Dwellings occupied in this compound 4178 252 1 5 1 3831 2 309 3 31 4 5 5 2 Sysmiss 252 Dwelling use 4178 252 1 3 1 Residential 3854 2 Business 142 3 Both residential and business 182 Sysmiss 252 Dwellings occupied by household 4143 287 1 5 1 3798 2 307 3 31 4 5 5 2 Sysmiss 287 Rooms in main dwelling 4178 252 0 9 0 1 1 3990 2 172 3 12 4 1 7 1 9 1 Sysmiss 252 Windows in main dwelling 4178 252 0 5 0 190 1 3756 2 211 3 14 4 5 5 2 Sysmiss 252 Dwelling has a window or entrance directly to the street 4178 252 0 1 -99 Don't know 0 0 No 3163 1 Yes 1015 Sysmiss 252 Deposit was paid 3958 472 0 1 -99 Don't know 0 0 No 2099 1 Yes 1859 Sysmiss 472 Deposit amount (KES) 1841 2589 0 20000 Monthly rent amount (KES) 4154 276 0 60000 Household has piped water 4430 1 3 1 Yes 3341 2 Yes, but not working 296 3 No 793 Rent includes water bill 3164 1266 1 3 1 Including with unlimited water usage 2516 2 Including with limited water usage - incur additional charge after certain amount 428 3 Not including water bill 220 Sysmiss 1266 Average water bill per month 709 3721 0 6000 Compound has electricity 4178 252 0 1 -99 Don't know 0 0 No 422 1 Yes 3756 Sysmiss 252 Dwelling has electricity 4178 252 0 1 -99 Don't know 0 0 No 529 1 Yes 3649 Sysmiss 252 Dwelling has its own pre-paid meter 3649 781 0 1 -99 Don't know 0 0 No 1373 1 Yes 2276 Sysmiss 781 Rent includes electricity bill 1373 3057 0 1 -99 Don't know 0 0 No 429 1 Yes 944 Sysmiss 3057 Average electrical bill per month 2604 1826 0 7000 Who collects rent 4178 252 1 3 1 Landlord 2844 2 Estate agent 226 3 Caretaker 1108 Sysmiss 252 Landlord is owner of compound 3278 1152 0 1 -99 Don't know 0 0 No 281 1 Yes 2997 Sysmiss 1152 Relationship to owner 4174 256 0 10 -99 Don't know 0 0 Not related 3960 1 Head him/herself 6 2 Wife or husband 1 3 Son or daughter 38 4 Son-in-law or daughter-in-law 11 5 Grandchild 14 6 Parent 14 7 Parent-in-law 18 8 Brother or sister 28 9 Other relative 83 10 Adopted/foster/stepchild 1 Sysmiss 256 Type of tenancy agreement 3920 510 1 4 -99 Don't know 0 1 Written agreement 299 2 Verbal agreement 2686 3 No agreement 931 4 Other 4 Sysmiss 510 Terms of rental agreement 2985 1445 1 3 1 Month to month 2971 2 Year to year 1 3 Other 13 Sysmiss 1445 Landlord can raise rent 2043 2387 0 1 -99 Don't know 0 0 No 1167 1 Yes 876 Sysmiss 2387 How often landlord can raise rent 726 3704 1 4 -89 Don't know 0 1 Anytime 485 2 Monthly 120 3 Yearly 97 4 Other 24 Sysmiss 3704 When the landlord last raised the rent: Years 1303 3127 0 18 0 457 1 432 2 204 3 93 4 34 5 33 6 20 7 10 8 7 9 2 10 8 11 1 14 1 18 1 Sysmiss 3127 When the landlord last raised the rent: Months 457 3973 0 11 0 12 1 133 2 61 3 60 4 30 5 30 6 57 7 38 8 18 9 5 10 6 11 7 Sysmiss 3973 Years living in compound 2826 1604 1 40 1 649 2 554 3 452 4 282 5 235 6 129 7 106 8 95 9 51 10 103 11 18 12 21 13 18 14 16 15 22 16 6 17 8 18 11 19 5 20 22 21 1 22 8 23 2 24 2 25 3 26 2 27 2 29 1 30 1 40 1 Sysmiss 1604 Months living in compound (if less than 1 year) 1350 3080 0 11 0 3 1 181 2 203 3 245 4 171 5 117 6 139 7 89 8 95 9 49 10 32 11 26 Sysmiss 3080 Other households living in this compound 4178 252 0 1 -99 Don't know 0 0 No 69 1 Yes 4109 Sysmiss 252 Number of people you know in this compound 4101 329 0 100 0 25 1 161 2 275 3 440 4 374 5 472 6 340 7 263 8 276 9 148 10 396 11 115 12 121 13 74 14 53 15 135 16 51 17 27 18 43 19 24 20 101 21 22 22 24 23 10 24 15 25 29 26 8 27 9 28 5 29 3 30 21 31 5 32 5 33 6 34 1 35 4 36 2 38 1 39 1 40 3 43 1 44 2 45 1 46 1 48 1 50 4 52 2 100 1 Sysmiss 329 Compound has a group responsible for dealing with issues 4109 321 0 1 -99 Don't know 0 0 No 3799 1 Yes 310 Sysmiss 321 You or anybody from your household is on this committee 310 4120 0 1 -99 Don't know 0 0 No 50 1 Yes 260 Sysmiss 4120 How often meet and socialize with people in your compound 4109 321 1 5 1 Everyday 3410 2 At least once a week 492 3 At least once a month 42 4 Infrequently (less regularly than once a month) 92 5 Never 73 Sysmiss 321 Ever been in an argument with somebody from this compound 4109 321 0 1 -99 Don't know 0 0 No 3627 1 Yes 482 Sysmiss 321 Most people who live in this compound can be trusted 3741 689 1 4 -99 Don't know 0 1 Strongly agree 1587 2 Agree 1686 3 Disagree 302 4 Strongly disagree 166 Sysmiss 689 People generally do not trust each other in this compound 2806 1624 1 4 -99 Don't know 0 1 Strongly agree 451 2 Agree 722 3 Disagree 1040 4 Strongly disagree 593 Sysmiss 1624 Received help with: Child care 4109 321 0 1 -99 Don't know 0 0 No 3090 1 Yes 1019 Sysmiss 321 Received help with: Transport 4109 321 0 1 -99 Don't know 0 0 No 3673 1 Yes 436 Sysmiss 321 Received help with: Sharing of food 4109 321 0 1 -99 Don't know 0 0 No 2742 1 Yes 1367 Sysmiss 321 Received help with: Medical care or emergency 4109 321 0 1 -99 Don't know 0 0 No 3387 1 Yes 722 Sysmiss 321 Received help with: Job search 4109 321 0 1 -99 Don't know 0 0 No 3493 1 Yes 616 Sysmiss 321 Received help with: Household chores 4109 321 0 1 -99 Don't know 0 0 No 3631 1 Yes 478 Sysmiss 321 Received help with: Compound maintenance issues 4109 321 0 1 -99 Don't know 0 0 No 2552 1 Yes 1557 Sysmiss 321 Received help with: Security 4109 321 0 1 -99 Don't know 0 0 No 2042 1 Yes 2067 Sysmiss 321 Primary activity of household head 4178 252 1 9 1 Paid work 2813 2 Voluntary work 12 3 Self-employed/Business 1054 4 Looking for work 159 5 Schooling 28 6 Vacation 33 7 Sick 34 8 Pensioner/retired 4 9 Other 41 Sysmiss 252 Household head work (if paid work) 2813 1617 1 2 1 Salaried worker 1090 2 Casual labour 1723 Sysmiss 1617 Houeshold head work location 3875 555 1 4 1 Within Soweto, kayole 1173 2 In neigbouring settlement 2094 3 In Nairobi Central Business District 436 4 Outside Nairobi 172 Sysmiss 555 Household head income (KES) 3208 1222 0 400000 Received money from: Work in salaried/formal employment 4178 252 1 8 1 Work in salaried/formal employment 112 2 Any other work for pay 390 3 Business profits from business owned by one or more household members 565 4 Transfers from other households 168 5 Pension or social security 2 6 Interest on investments or savings 83 7 Rental income 0 8 No, did not receive any income 2858 Sysmiss 252 Received money from: Any other work for pay 32 4398 2 6 1 Work in salaried/formal employment 0 2 Any other work for pay 1 3 Business profits from business owned by one or more household members 10 4 Transfers from other households 16 5 Pension or social security 2 6 Interest on investments or savings 3 7 Rental income 0 8 No, did not receive any income 0 Sysmiss 4398 Household income from other sources (KES) 1194 3236 0 150000 Main source of water 1844 2586 1 11 1 Piped into compound 1342 2 Public tap/standpipe 95 3 Water kiosk 299 4 Tube well or borehole 74 5 Dug well 1 6 Protected well 15 7 Unprotected well 0 8 Water from spring 0 9 Rainwater 0 10 Tanker truck 3 11 Cart with small tank 15 12 Surface water(river/dam/lake/pond/stream/canal/irrigation channel) 0 13 Bottled water 0 Sysmiss 2586 Running water at the time of the interview 1437 2993 0 1 -99 Don't know 0 0 No 1057 1 Yes 380 Sysmiss 2993 Days receive water 1 1420 3010 1 8 -99 Don't know 0 1 Monday 393 2 Tuesday 381 3 Wednesday 541 4 Thursday 58 5 Friday 3 6 Saturday 0 7 Sunday 0 8 None 44 Sysmiss 3010 Days receive water 2 771 3659 2 7 -99 Don't know 0 1 Monday 0 2 Tuesday 211 3 Wednesday 140 4 Thursday 402 5 Friday 13 6 Saturday 3 7 Sunday 2 8 None 0 Sysmiss 3659 Days receive water 3 245 4185 3 6 -99 Don't know 0 1 Monday 0 2 Tuesday 0 3 Wednesday 143 4 Thursday 45 5 Friday 53 6 Saturday 4 7 Sunday 0 8 None 0 Sysmiss 4185 Days receive water 4 106 4324 4 7 -99 Don't know 0 1 Monday 0 2 Tuesday 0 3 Wednesday 0 4 Thursday 79 5 Friday 10 6 Saturday 16 7 Sunday 1 8 None 0 Sysmiss 4324 Days receive water 5 41 4389 5 7 -99 Don't know 0 1 Monday 0 2 Tuesday 0 3 Wednesday 0 4 Thursday 0 5 Friday 38 6 Saturday 2 7 Sunday 1 8 None 0 Sysmiss 4389 Days receive water 6 25 4405 6 6 -99 Don't know 0 1 Monday 0 2 Tuesday 0 3 Wednesday 0 4 Thursday 0 5 Friday 0 6 Saturday 25 7 Sunday 0 8 None 0 Sysmiss 4405 Days receive water 7 10 4420 7 7 -99 Don't know 0 1 Monday 0 2 Tuesday 0 3 Wednesday 0 4 Thursday 0 5 Friday 0 6 Saturday 0 7 Sunday 10 8 None 0 Sysmiss 4420 Days receive water 8 4430 * -99 Don't know 0 1 Monday 0 2 Tuesday 0 3 Wednesday 0 4 Thursday 0 5 Friday 0 6 Saturday 0 7 Sunday 0 8 None 0 Sysmiss 4430 Main sanitation facility is within compound 2096 2334 0 1 -99 Don't know 0 0 No 126 1 Yes 1970 Sysmiss 2334 Satisfied with main sanitation facilities 2096 2334 1 5 1 Very Satisfied 696 2 Somewhat Satisfied 654 3 Less than Satisfied 298 4 Completely Dissatisfied 435 5 Don't know 13 Sysmiss 2334 Pay for use of main sanitation facilities 74 4356 0 1 -99 Don't know 0 0 No 70 1 Yes 4 Sysmiss 4356 Amount pay for use of main sanitation facilities per visit 3 4427 5 10 5 1 10 2 Sysmiss 4427 How often pay for use of main sanitation facilities per day 4 4426 1 3 1 1 2 2 3 1 Sysmiss 4426 Number of toilet facilities in this compound 1970 2460 1 15 1 1054 2 753 3 74 4 41 5 6 6 17 7 1 8 6 9 5 10 6 12 6 15 1 Sysmiss 2460 Types of toilet facilities in this compound 1970 2460 1 2 1 1943 2 27 Sysmiss 2460 Compound illegally connected to the sewer 1579 2851 1 2 -89 Could not observe 0 1 Yes 262 2 No 1317 Sysmiss 2851 Construction work for upgrading the sanitation facility 1060 3370 1 4 -99 Don't know 0 1 Yes, work has been completed 142 2 Yes, work has been started but still in progress 201 3 No, applied but work has not started 406 4 No, have not applied 311 Sysmiss 3370 Previous facilty before upgrading 327 4103 1 5 -99 Don't know 0 -79 No toilet 0 1 Flush/Pour flush 86 2 Ventilated improved pit latrine 41 3 Pit latrine with slab 164 4 Composting toilet 0 5 Pit latrine without slab / open pit 36 6 Bucket 0 7 Hanging toilet / hanging latrine 0 8 Plastic bag system (flying toilet) 0 9 Peepoo 0 Sysmiss 4103 Where was the previous flush toilet or pour flush connected to 86 4344 1 4 1 Connected to piped sewer system 37 2 Connected to septic tank 29 3 Connected to pit latrine 2 4 Flush/pour to don't know where 18 Sysmiss 4344 Total number of toilet features observable 1958 2472 1 2 1 1931 2 27 Sysmiss 2472 Current toilet facility 1968 2462 1 5 -99 Don't know 0 -79 No toilet 0 1 Flush/Pour flush 1175 2 Ventilated improved pit latrine 126 3 Pit latrine with slab 558 4 Composting toilet 2 5 Pit latrine without slab / open pit 107 6 Bucket 0 7 Hanging toilet / hanging latrine 0 8 Plastic bag system (flying toilet) 0 9 Peepoo 0 Sysmiss 2462 Where is flush toilet or pour flush connected to 1175 3255 1 4 1 Connected to piped sewer system 683 2 Connected to septic tank 246 3 Connected to pit latrine 26 4 Flush/pour to don't know where 220 Sysmiss 3255 Latrine special features 1 1840 2590 1 8 -89 Could not observe 0 1 Latrine elevated (built above ground) 1564 2 Foot rests 45 3 Seat 5 4 Floor tiles 20 5 Wall tiles 4 6 Hole cover 28 7 Water seal 162 8 Other 12 Sysmiss 2590 Latrine special features 2 680 3750 2 8 -89 Could not observe 0 1 Latrine elevated (built above ground) 0 2 Foot rests 341 3 Seat 2 4 Floor tiles 64 5 Wall tiles 24 6 Hole cover 4 7 Water seal 243 8 Other 2 Sysmiss 3750 Latrine special features 3 148 4282 3 8 -89 Could not observe 0 1 Latrine elevated (built above ground) 0 2 Foot rests 0 3 Seat 2 4 Floor tiles 7 5 Wall tiles 39 6 Hole cover 2 7 Water seal 97 8 Other 1 Sysmiss 4282 Latrine special features 4 19 4411 5 7 -89 Could not observe 0 1 Latrine elevated (built above ground) 0 2 Foot rests 0 3 Seat 0 4 Floor tiles 0 5 Wall tiles 4 6 Hole cover 0 7 Water seal 15 8 Other 0 Sysmiss 4411 Latrine special features 5 2 4428 7 7 -89 Could not observe 0 1 Latrine elevated (built above ground) 0 2 Foot rests 0 3 Seat 0 4 Floor tiles 0 5 Wall tiles 0 6 Hole cover 0 7 Water seal 2 8 Other 0 Sysmiss 4428 Latrine superstructure 1 1910 2520 1 8 -79 No superstructure 0 1 Roof 1862 2 Fully enclosed wall 23 3 Partially enclosed wall 11 4 Full door 1 5 Half door 0 6 Lockable door 0 7 Curtain 4 8 Other 9 Sysmiss 2520 Latrine superstructure 2 1857 2573 2 7 -79 No superstructure 0 1 Roof 0 2 Fully enclosed wall 1711 3 Partially enclosed wall 79 4 Full door 56 5 Half door 7 6 Lockable door 3 7 Curtain 1 8 Other 0 Sysmiss 2573 Latrine superstructure 3 1787 2643 3 8 -79 No superstructure 0 1 Roof 0 2 Fully enclosed wall 0 3 Partially enclosed wall 9 4 Full door 1658 5 Half door 58 6 Lockable door 52 7 Curtain 7 8 Other 3 Sysmiss 2643 Latrine superstructure 4 1312 3118 4 7 -79 No superstructure 0 1 Roof 0 2 Fully enclosed wall 0 3 Partially enclosed wall 0 4 Full door 4 5 Half door 11 6 Lockable door 1296 7 Curtain 1 8 Other 0 Sysmiss 3118 Latrine superstructure 5 6 4424 6 6 -79 No superstructure 0 1 Roof 0 2 Fully enclosed wall 0 3 Partially enclosed wall 0 4 Full door 0 5 Half door 0 6 Lockable door 6 7 Curtain 0 8 Other 0 Sysmiss 4424 Hand washing station installed during the upgrade 340 4090 0 1 -99 Don't know 0 0 No 236 1 Yes 104 Sysmiss 4090 A 200 litres tank to store water provided during the upgrade 340 4090 0 1 -99 Don't know 0 0 No 144 1 Yes 196 Sysmiss 4090 Toilet facility private or shared 1970 2460 1 3 1 Private 1856 2 Shared by several compounds 54 3 Public/used by all 60 Sysmiss 2460 Number of households use this facility 1856 2574 0 66 0 1 1 193 2 78 3 97 4 107 5 115 6 128 7 205 8 190 9 192 10 159 11 139 12 69 13 53 14 27 15 21 16 10 17 3 18 9 19 3 20 14 21 6 22 1 23 1 24 1 25 3 26 3 28 4 29 1 30 6 32 2 33 2 35 3 36 1 39 2 40 1 41 1 45 1 50 1 55 1 57 1 66 1 Sysmiss 2574 Toilet facility flooded or blocked 1970 2460 0 1 -99 Don't know 0 0 No 1681 1 Yes 289 Sysmiss 2460 Current toilet facility type 32 4398 1 3 -99 Don't know 0 -79 No toilet 0 1 Flush/Pour flush 23 2 Ventilated improved pit latrine 2 3 Pit latrine with slab 7 4 Composting toilet 0 5 Pit latrine without slab / open pit 0 6 Bucket 0 7 Hanging toilet / hanging latrine 0 8 Plastic bag system (flying toilet) 0 9 Peepoo 0 Sysmiss 4398 Where is flush toilet or pour flush connected to 23 4407 1 4 1 Connected to piped sewer system 6 2 Connected to septic tank 7 3 Connected to pit latrine 7 4 Flush/pour to don't know where 3 Sysmiss 4407 Latrine special features 1 25 4405 1 7 -89 Could not observe 0 1 Latrine elevated (built above ground) 18 2 Foot rests 1 3 Seat 2 4 Floor tiles 2 5 Wall tiles 0 6 Hole cover 1 7 Water seal 1 8 Other 0 Sysmiss 4405 Latrine special features 2 8 4422 2 7 -89 Could not observe 0 1 Latrine elevated (built above ground) 0 2 Foot rests 5 3 Seat 0 4 Floor tiles 0 5 Wall tiles 1 6 Hole cover 0 7 Water seal 2 8 Other 0 Sysmiss 4422 Latrine special features 3 3 4427 7 7 -89 Could not observe 0 1 Latrine elevated (built above ground) 0 2 Foot rests 0 3 Seat 0 4 Floor tiles 0 5 Wall tiles 0 6 Hole cover 0 7 Water seal 3 8 Other 0 Sysmiss 4427 Latrine superstructure 1 32 4398 1 4 -79 No superstructure 0 1 Roof 31 2 Fully enclosed wall 0 3 Partially enclosed wall 0 4 Full door 1 5 Half door 0 6 Lockable door 0 7 Curtain 0 8 Other 0 Sysmiss 4398 Latrine superstructure 2 32 4398 2 6 -79 No superstructure 0 1 Roof 0 2 Fully enclosed wall 30 3 Partially enclosed wall 0 4 Full door 1 5 Half door 0 6 Lockable door 1 7 Curtain 0 8 Other 0 Sysmiss 4398 Latrine superstructure 3 30 4400 4 6 -79 No superstructure 0 1 Roof 0 2 Fully enclosed wall 0 3 Partially enclosed wall 0 4 Full door 28 5 Half door 1 6 Lockable door 1 7 Curtain 0 8 Other 0 Sysmiss 4400 Latrine superstructure 4 19 4411 6 6 -79 No superstructure 0 1 Roof 0 2 Fully enclosed wall 0 3 Partially enclosed wall 0 4 Full door 0 5 Half door 0 6 Lockable door 19 7 Curtain 0 8 Other 0 Sysmiss 4411 Hand washing station installed during the upgrade 4 4426 0 -99 Don't know 0 0 No 4 1 Yes 0 Sysmiss 4426 A 200 litres tank to store water provided during the upgrade 4 4426 0 -99 Don't know 0 0 No 4 1 Yes 0 Sysmiss 4426 Toilet facility private or shared 33 4397 1 3 1 Private 31 2 Shared by several compounds 1 3 Public/used by all 1 Sysmiss 4397 Number of households use this facility 31 4399 0 20 0 1 1 8 2 2 4 2 5 3 6 2 7 3 8 1 9 2 10 4 12 2 20 1 Sysmiss 4399 Toilet facility flooded or blocked 33 4397 0 1 -99 Don't know 0 0 No 28 1 Yes 5 Sysmiss 4397 Amount willing to pay for upgrade 1753 2677 0 5000 0 615 10 1 20 1 50 26 100 201 150 9 200 363 250 4 300 134 350 1 400 13 500 320 600 4 700 8 800 2 1000 34 1500 2 2000 8 2500 1 3000 2 5000 4 Sysmiss 2677 Water meter installed 2096 2334 0 1 -99 Don't know 0 0 No 562 1 Yes 1534 Sysmiss 2334 Water meter in working condition 1534 2896 1 3 1 Yes 1249 2 No 109 3 Not observable 176 Sysmiss 2896 Account number (masked) 404 Compound type 182 222 1 4 1 Residential 165 2 Church 3 3 School 6 4 Business premises (e.g. shops) 8 Sysmiss 222 Number of households 404 1 56 1 54 2 56 3 48 4 39 5 41 6 31 7 30 8 25 9 21 10 16 11 6 12 3 13 6 14 3 15 4 16 4 17 3 19 3 21 1 22 1 23 2 24 1 26 3 28 1 30 1 56 1 Household head 404 0 1 -999 Don't know 0 0 No 159 1 Yes 245 Relationship to household head 159 245 2 2 -999 don't know 0 -888 other relative 0 1 I am the compound owner 0 2 wife or husband 159 3 son or daughter 0 4 son-in-law or daughter-in-law 0 5 grandchild 0 6 parent 0 7 parent-in-law 0 8 brother or sister 0 10 adopted/foster/stepchild 0 11 not related 0 Sysmiss 245 Reason household head not available 154 250 1 3 -888 Other (specify) 0 1 At work 141 2 Refuse to answer 0 3 Away from home for other personal reasons 13 4 Incapacitated 0 Sysmiss 250 Household members 404 1 337 1 69 2 72 3 101 4 77 5 52 6 12 7 4 8 4 9 1 14 1 15 1 20 1 35 1 40 1 60 2 70 1 72 1 78 1 113 1 337 1 Men 18 and older 394 10 0 10 0 59 1 297 2 32 3 4 4 1 10 1 Sysmiss 10 Women 18 and older 395 9 0 10 0 78 1 290 2 23 3 3 10 1 Sysmiss 9 Child under 5 395 9 0 15 0 212 1 151 2 29 3 2 15 1 Sysmiss 9 Child between 5 and 18 395 9 0 42 0 214 1 98 2 56 3 16 4 7 5 1 6 1 8 1 42 1 Sysmiss 9 Total household members 404 0 60 0 9 1 69 2 72 3 101 4 77 5 52 6 12 7 4 8 4 9 1 14 1 20 1 60 1 Highest level of education completed 404 1 6 1 No education 5 2 Some primary 36 3 Completed primary 108 4 Some secondary 43 5 Completed secondary 147 6 More than secondary 65 Age 396 8 25 45 25 64 26 31 27 22 28 16 29 16 30 32 31 10 32 27 33 19 34 21 35 22 36 10 37 8 38 10 39 7 40 9 41 4 42 12 43 5 44 7 45 44 Sysmiss 8 Marital status 403 1 1 5 -999 Don't know 0 -998 Refused to Answer 0 1 Married 290 2 Divorced or separated 27 3 Widowed 10 4 Never married and never engaged(Single) 70 5 Never married and engaged 6 Sysmiss 1 Spouse lives in compound 290 114 0 1 -999 Don't know 0 0 No 44 1 Yes 246 Sysmiss 114 Spouse not reside: Poor living conditions in this compound 44 360 0 -999 Don't know 0 0 No 44 1 Yes 0 Sysmiss 360 Spouse not reside: Settlement is unsafe 44 360 0 1 -999 Don't know 0 0 No 43 1 Yes 1 Sysmiss 360 Spouse not reside: Cannot afford for them to stay here 44 360 0 1 -999 Don't know 0 0 No 42 1 Yes 2 Sysmiss 360 Spouse not reside: To look after other family members elsewhere 44 360 0 1 -999 Don't know 0 0 No 32 1 Yes 12 Sysmiss 360 Spouse not reside: To be closer to work or education opportunities 44 360 0 1 -999 Don't know 0 0 No 31 1 Yes 13 Sysmiss 360 Spouse not reside: Other 44 360 0 1 -999 Don't know 0 0 No 23 1 Yes 21 Sysmiss 360 Spouse not reside factors: Too little space 404 * -999 Don't know 0 0 No 0 1 Yes 0 Sysmiss 404 Spouse not reside factors: Poor hygiene conditions 404 * -999 Don't know 0 0 No 0 1 Yes 0 Sysmiss 404 Spouse not reside factors: Poor water availability and/or quality 404 * -999 Don't know 0 0 No 0 1 Yes 0 Sysmiss 404 Spouse not reside factors: Poor sanitation facilities 404 * -999 Don't know 0 0 No 0 1 Yes 0 Sysmiss 404 Spouse not reside factors: No, or unreliable, electricity 404 * -999 Don't know 0 0 No 0 1 Yes 0 Sysmiss 404 Spouse not reside factors: No privacy 404 * -999 Don't know 0 0 No 0 1 Yes 0 Sysmiss 404 Spouse not reside factors: Far from education, health or other social services 404 * -999 Don't know 0 0 No 0 1 Yes 0 Sysmiss 404 Spouse not reside factors: Other 404 * -999 Don't know 0 0 No 0 1 Yes 0 Sysmiss 404 Has children under 18 that do not usually live in this compound 401 3 0 1 -999 Don't know 0 0 No 306 1 Yes 95 Sysmiss 3 Child not reside: Poor living conditions in this compound 95 309 0 1 -999 Don't know 0 0 No 94 1 Yes 1 Sysmiss 309 Child not reside: Settlement is unsafe 95 309 0 -999 Don't know 0 0 No 95 1 Yes 0 Sysmiss 309 Child not reside: Cannot afford for them to stay here 95 309 0 1 -999 Don't know 0 0 No 84 1 Yes 11 Sysmiss 309 Child not reside: To be looked after by other family members that live elsewhere 95 309 0 1 -999 Don't know 0 0 No 51 1 Yes 44 Sysmiss 309 Child not reside: To be closer to work or education opportunities 95 309 0 1 -999 Don't know 0 0 No 61 1 Yes 34 Sysmiss 309 Child not reside: Other 95 309 0 1 -999 Don't know 0 0 No 78 1 Yes 17 Sysmiss 309 Child not reside factors: Too little space 1 403 1 1 -999 Don't know 0 0 No 0 1 Yes 1 Sysmiss 403 Child not reside factors: Poor hygiene conditions 1 403 0 -999 Don't know 0 0 No 1 1 Yes 0 Sysmiss 403 Child not reside factors: Poor water availability and/or quality 1 403 0 -999 Don't know 0 0 No 1 1 Yes 0 Sysmiss 403 Child not reside factors: Poor Sanitation facilities 1 403 0 -999 Don't know 0 0 No 1 1 Yes 0 Sysmiss 403 Child not reside factors: No, or unreliable, electricity 1 403 0 -999 Don't know 0 0 No 1 1 Yes 0 Sysmiss 403 Child not reside factors: No privacy 1 403 0 -999 Don't know 0 0 No 1 1 Yes 0 Sysmiss 403 Child not reside factors: Far from education, health or other social services 1 403 1 1 -999 Don't know 0 0 No 0 1 Yes 1 Sysmiss 403 Child not reside factors: Other 1 403 0 -999 Don't know 0 0 No 1 1 Yes 0 Sysmiss 403 Child health count 404 -998 15 -998 9 0 212 1 151 2 29 3 2 15 1 Diarrhea in the past 2 weeks 180 224 0 1 -999 Don't know 0 0 No 145 1 Yes 35 Sysmiss 224 Fever in the past 2 weeks 181 223 0 1 -999 Don't know 0 0 No 124 1 Yes 57 Sysmiss 223 Diarrhea in the past 2 weeks 30 374 0 1 -999 Don't know 0 0 No 28 1 Yes 2 Sysmiss 374 Fever in the past 2 weeks 30 374 0 1 -999 Don't know 0 0 No 26 1 Yes 4 Sysmiss 374 Diarrhea in the past 2 weeks 2 402 0 1 -999 Don't know 0 0 No 1 1 Yes 1 Sysmiss 402 Fever in the past 2 weeks 2 402 0 -999 Don't know 0 0 No 2 1 Yes 0 Sysmiss 402 Dwellings in compound 403 1 1 33 1 41 2 32 3 42 4 34 5 36 6 43 7 39 8 27 9 28 10 27 11 11 12 11 13 3 14 3 15 2 16 5 17 3 18 1 19 1 20 2 21 2 22 1 23 2 24 1 26 1 28 1 30 1 32 2 33 1 Sysmiss 1 Dwellings occupied by household in compound 403 1 1 6 1 371 2 28 3 3 6 1 Sysmiss 1 Pay a deposit 404 0 1 -999 Don't know 0 0 No 218 1 Yes 186 Deposit amount 184 220 600 14000 600 1 1000 9 1500 3 1600 1 1700 2 1800 1 2000 18 2200 2 2300 2 2500 39 2600 1 2700 1 2800 3 3000 34 3200 2 3500 19 3600 2 4000 9 4500 5 4800 1 5000 6 5500 2 6000 7 6500 1 7000 6 7500 1 8000 2 9000 1 10000 1 13000 1 14000 1 Sysmiss 220 Pay rent 404 0 1 -999 Don't know 0 0 No 3 1 Yes 401 Rent amount 396 8 500 26000 500 1 1000 6 1200 1 1500 21 1600 3 1650 1 1700 6 1800 5 2000 59 2100 1 2200 4 2300 5 2400 2 2500 96 2600 3 2700 9 2800 5 3000 64 3200 3 3300 1 3400 1 3500 21 3600 1 3700 1 4000 13 4300 1 4500 10 5000 9 5200 1 5500 5 6000 13 6500 2 7000 8 7500 1 8000 4 10000 2 13000 1 13500 1 15000 1 16000 1 17000 1 22000 1 26000 1 Sysmiss 8 Late rental payments in the last 6 months 401 3 0 1 -999 Don't know 0 0 No 226 1 Yes 175 Sysmiss 3 Missed payment: I did not have the money available because of an emergency 175 229 0 1 -999 Don't know 0 0 No 143 1 Yes 32 Sysmiss 229 Missed payment: I did not have the money available, which is a general challenge 175 229 0 1 -999 Don't know 0 0 No 43 1 Yes 132 Sysmiss 229 Missed payment: I did not feel the need to pay 175 229 0 -999 Don't know 0 0 No 175 1 Yes 0 Sysmiss 229 Missed payment: I forgot 175 229 0 1 -999 Don't know 0 0 No 174 1 Yes 1 Sysmiss 229 Missed payment: I was away 175 229 0 -999 Don't know 0 0 No 175 1 Yes 0 Sysmiss 229 Missed payment: Other 175 229 0 1 -999 Don't know 0 0 No 154 1 Yes 21 Sysmiss 229 Piped water in this compound 404 1 3 1 Yes 212 2 Yes, but not working 141 3 No 51 Rent includes the cost of water 353 51 1 3 1 Including with unlimited water usage 286 2 Including with limited water usage – incur additional charge after certain amoun 5 3 Not including water bill 62 Sysmiss 51 Amount household spend on water (for all uses) last month 334 70 0 6000 Electricity connection 404 0 1 -999 Don't know 0 0 No 15 1 Yes 389 Electricity in dwelling 389 15 0 1 -999 Don't know 0 0 No 11 1 Yes 378 Sysmiss 15 Dwelling has its own meter 378 26 0 1 -999 Don't know 0 0 No 139 1 Yes 239 Sysmiss 26 Rent includes the electricity bill 389 15 0 1 -999 Don't know 0 0 No 272 1 Yes 117 Sysmiss 15 Average electrical bill per month 265 139 0 3000 0 3 50 2 100 18 150 14 200 51 250 8 300 59 350 4 400 28 450 1 500 34 550 1 600 17 700 1 800 7 900 1 1000 10 1500 2 2000 3 3000 1 Sysmiss 139 Who collects your rent 404 1 6 1 Landlord 268 2 Estate Agent 27 3 Caretaker 94 4 Spouse/Child 8 5 Other relative 6 6 Not related 1 Relationship to the owner of this compound 401 3 4 11 -999 don't know 0 -888 other relative 0 1 I am the compound owner 0 2 wife or husband 0 3 son or daughter 0 4 son-in-law or daughter-in-law 1 5 grandchild 2 6 parent 0 7 parent-in-law 0 8 brother or sister 1 10 adopted/foster/stepchild 0 11 not related 397 Sysmiss 3 Type of tenancy agreement 390 14 1 3 -999 Don't know 0 -888 Other(specify) 0 1 Written agreement 37 2 Verbal agreement 197 3 No agreement 156 Sysmiss 14 Terms of rental agreement 228 176 1 2 -888 Other(specify) 0 1 Month to month 224 2 Year to year 4 Sysmiss 176 Landlord can raise the rent 192 212 0 1 -999 Don't know 0 0 No 164 1 Yes 28 Sysmiss 212 How often landlord can raise the rent 24 380 1 3 -999 Don't know 0 -888 Other(specify) 0 1 Anytime 13 2 Monthly 4 3 Yearly 7 Sysmiss 380 Time lived in compound: Years 402 2 0 28 0 138 1 81 2 37 3 41 4 22 5 20 6 15 7 7 8 10 9 6 10 12 11 2 12 1 14 4 16 1 20 1 22 1 24 1 27 1 28 1 Sysmiss 2 Time lived in compound: Months 390 14 0 11 0 109 1 37 2 45 3 31 4 22 5 31 6 35 7 17 8 25 9 15 10 12 11 11 Sysmiss 14 Landlord raised rent during this period 404 0 1 -999 Don't know 0 0 No 346 1 Yes 58 How often raise rent: Years 55 349 0 10 0 12 1 16 2 10 3 4 4 6 5 2 7 1 8 2 10 2 Sysmiss 349 How often raise rent: Months 53 351 0 10 0 22 1 3 2 3 3 4 4 3 5 5 6 2 7 3 8 6 10 2 Sysmiss 351 Number of people you know in this compound 401 3 0 100 0 27 1 30 2 37 3 38 4 31 5 38 6 25 7 19 8 24 9 10 10 25 11 10 12 8 13 6 14 10 15 16 16 5 17 6 18 4 19 2 20 11 21 2 22 2 23 1 25 2 26 1 27 1 30 4 35 1 40 1 70 1 90 1 100 2 Sysmiss 3 Compound has a group responsible for dealing with issues 400 4 0 1 -999 Don't know 0 0 No 372 1 Yes 28 Sysmiss 4 You or anybody from household is on this committee 28 376 0 1 -999 Don't know 0 0 No 2 1 Yes 26 Sysmiss 376 How often meet and socialize with people in your compound 28 376 1 4 1 Every day, 5 2 At least once a week, 4 3 At least once a month, 6 4 Infrequently (less regularly than once a month), 13 5 Never 0 Sysmiss 376 Ever been in an argument with somebody from this compound 404 0 1 -999 Don't know 0 0 No 361 1 Yes 43 Most people who live in this compound can be trusted 360 44 1 4 -999 Don't know 0 -998 Not applicable 0 1 Strongly agree 131 2 Agree 153 3 Disagree 51 4 Strongly disagree 25 Sysmiss 44 Ever approached a leader in this community about your needs 404 0 1 -999 Don't know 0 0 No 376 1 Yes 28 Attended any meetings for this community in the last 6 months 404 0 1 -999 Don't know 0 0 No 363 1 Yes 41 Anyone in household a member of a community committee 404 0 1 -999 Don't know 0 0 No 387 1 Yes 17 Relationship with landlord (scale of 1 to 10) 404 1 10 1 12 2 5 3 3 4 4 5 37 6 23 7 27 8 48 9 25 10 220 Ever experienced a dispute with your landlord 404 0 1 -999 Don't know 0 0 No 389 1 Yes 15 Dispute: General housing conditions 15 389 0 1 -999 Don't know 0 0 No 14 1 Yes 1 Sysmiss 389 Dispute: Rental amount 15 389 0 1 -999 Don't know 0 0 No 12 1 Yes 3 Sysmiss 389 Dispute: Personal 15 389 0 1 -999 Don't know 0 0 No 11 1 Yes 4 Sysmiss 389 Dispute: Related to other people living in the compound 15 389 0 1 -999 Don't know 0 0 No 14 1 Yes 1 Sysmiss 389 Dispute: Leasing agreement conditions 15 389 0 -999 Don't know 0 0 No 15 1 Yes 0 Sysmiss 389 Dispute: Poor water services 15 389 0 -999 Don't know 0 0 No 15 1 Yes 0 Sysmiss 389 Dispute: Poor sanitation services 15 389 0 1 -999 Don't know 0 0 No 14 1 Yes 1 Sysmiss 389 Dispute: Poor electricity provision 15 389 0 1 -999 Don't know 0 0 No 13 1 Yes 2 Sysmiss 389 Dispute: Other 15 389 0 1 -999 Don't know 0 0 No 12 1 Yes 3 Sysmiss 389 Water and sanitation fees applied by Nairobi Water are fair 269 135 1 4 -999 Don't know 0 -998 Not applicable 0 1 Strongly agree 38 2 Agree 126 3 Disagree 55 4 Strongly disagree 50 Sysmiss 135 If you don’t pay fees, there is a strong chance of disconnection 351 53 1 4 -999 Don't know 0 -998 Not applicable 0 1 Strongly agree 219 2 Agree 104 3 Disagree 18 4 Strongly disagree 10 Sysmiss 53 The approach Nairobi Water uses to enforce repayments is fair 317 87 1 4 -999 Don't know 0 -998 Not applicable 0 1 Strongly agree 60 2 Agree 143 3 Disagree 58 4 Strongly disagree 56 Sysmiss 87 I am satisfied with the water and/or sanitation services I receive 389 15 1 4 -999 Don't know 0 -998 Not applicable 0 1 Strongly agree 55 2 Agree 108 3 Disagree 85 4 Strongly disagree 141 Sysmiss 15 The government is interested in improving the living conditions 371 33 1 4 -999 Don't know 0 -998 Not applicable 0 1 Strongly agree 82 2 Agree 172 3 Disagree 52 4 Strongly disagree 65 Sysmiss 33 Water and sewer fees are affordable 269 135 1 4 -999 Don't know 0 -998 Not applicable 0 1 Strongly agree 37 2 Agree 138 3 Disagree 56 4 Strongly disagree 38 Sysmiss 135 Nairobi Water provides clear communication to us 297 107 1 4 -999 Don't know 0 -998 Not applicable 0 1 Strongly agree 34 2 Agree 117 3 Disagree 71 4 Strongly disagree 75 Sysmiss 107 The water and sanitation services improve people’s lives 378 26 1 4 -999 Don't know 0 -998 Not applicable 0 1 Strongly agree 138 2 Agree 159 3 Disagree 39 4 Strongly disagree 42 Sysmiss 26 The government is not interested in helping us 366 38 1 4 -999 Don't know 0 -998 Not applicable 0 1 Strongly agree 57 2 Agree 71 3 Disagree 150 4 Strongly disagree 88 Sysmiss 38 Water and sanitation services in general helps improve people’s lives 393 11 1 4 -999 Don't know 0 -998 Not applicable 0 1 Strongly agree 205 2 Agree 160 3 Disagree 15 4 Strongly disagree 13 Sysmiss 11 The water bills are accurate 223 181 1 4 -999 Don't know 0 -998 Not applicable 0 1 Strongly agree 29 2 Agree 111 3 Disagree 40 4 Strongly disagree 43 Sysmiss 181 The jisomee mita system is easy to use 195 209 1 4 -999 Don't know 0 -998 Not applicable 0 1 Strongly agree 57 2 Agree 106 3 Disagree 24 4 Strongly disagree 8 Sysmiss 209 Tenants appreciate the water and sanitation services provided in my compound 382 22 1 4 -999 Don't know 0 -998 Not applicable 0 1 Strongly agree 87 2 Agree 116 3 Disagree 80 4 Strongly disagree 99 Sysmiss 22 Illegal connections are common in settlement 273 131 1 4 -999 Don't know 0 -998 Not applicable 0 1 Strongly agree 42 2 Agree 67 3 Disagree 87 4 Strongly disagree 77 Sysmiss 131 Proportion of people in settlement have illegal water connnection 187 217 0 99 0 50 1 3 2 2 3 1 4 1 5 7 10 28 15 1 17 1 20 21 25 3 30 12 35 1 40 4 50 21 60 7 65 1 70 9 75 1 80 5 85 1 90 5 96 1 99 1 Sysmiss 217 Non-payment of water and sanitation bills are common in my settlement 297 107 1 4 -999 Don't know 0 -998 Not applicable 0 1 Strongly agree 46 2 Agree 118 3 Disagree 97 4 Strongly disagree 36 Sysmiss 107 Proportion of people in your settlement do you think pay all of their water 240 164 0 100 0 4 1 1 4 1 5 4 7 1 8 1 10 14 15 3 20 15 25 3 30 12 35 1 40 17 50 51 55 2 56 1 60 15 70 29 75 10 78 2 80 23 86 2 90 15 95 1 98 3 99 2 100 7 Sysmiss 164 Primary activity of household head 391 13 1 7 -888 Other, specify 0 1 Paid work 344 2 Voluntary work 2 3 Looking for work 27 4 Schooling 2 5 Vacation 7 6 Sick 8 7 Pensioner/retired 1 Sysmiss 13 Household head work 344 60 1 3 1 Salaried worker 81 2 Casual labour 163 3 Self employed 100 Sysmiss 60 Household head work location 344 60 1 5 1 Within this informal settlement 107 2 In neigbouring settlement 100 3 In Nairobi Central Business District 33 4 Outside Nairobi 14 5 Other settlement in Nairobi (not neighbouring this settlement) 90 Sysmiss 60 Household head income amount 265 139 0 180000 0 3 500 3 1000 3 1200 1 1500 4 2000 5 2500 2 3000 7 4000 9 4500 1 4800 1 5000 23 5600 2 6000 13 6500 1 7000 9 8000 10 9000 9 10000 42 10500 1 12000 14 12400 1 13000 1 14000 1 14400 1 15000 27 16000 2 17000 3 18000 6 20000 24 21000 1 22000 3 23000 2 24000 1 25000 3 27000 2 28000 5 30000 10 32000 1 35000 1 36000 1 45000 1 50000 1 60000 1 75000 1 100000 1 180000 1 Sysmiss 139 Income source: Work in salaried/formal employment 404 0 1 -999 Don't know 0 0 No 378 1 Yes 26 Income source: Any other work for pay 404 0 1 -999 Don't know 0 0 No 325 1 Yes 79 Income source: Business profits from business owned by one or more household mem 404 0 1 -999 Don't know 0 0 No 359 1 Yes 45 Income source: Transfers from other households 404 0 1 -999 Don't know 0 0 No 397 1 Yes 7 Income source: Pension or social security 404 0 -999 Don't know 0 0 No 404 1 Yes 0 Income source: Interest on investments or savings 404 0 1 -999 Don't know 0 0 No 403 1 Yes 1 Income source: Rental income 404 0 -999 Don't know 0 0 No 404 1 Yes 0 Income source: No, did not receive any income 404 0 1 -999 Don't know 0 0 No 165 1 Yes 239 Income source: Don't know 404 0 1 -999 Don't know 0 0 No 400 1 Yes 4 Income source: Other 404 0 1 -999 Don't know 0 0 No 394 1 Yes 10 Total household income amount 135 269 0 180000 0 1 500 1 1000 1 1400 1 1500 1 2000 3 2500 1 3000 7 3500 2 3800 1 4000 2 5000 6 6000 8 7000 5 7500 2 7800 1 8000 2 9000 4 10000 11 11000 1 12000 6 13000 1 14000 1 15000 17 16000 1 17000 1 18000 2 19000 2 20000 8 21500 1 22000 1 23000 3 24000 1 25000 3 26000 1 27000 3 28000 2 30000 5 32000 2 34000 1 35000 5 38000 1 40000 1 45000 2 65000 1 75000 1 180000 1 Sysmiss 269 Main source of water used by the members of this compound 394 10 1 14 -888 Other, specify 0 1 Piped into compound 130 2 Public tap/standpipe 16 3 Water kiosk 4 4 Tube well or borehole 156 5 Dug well 1 6 Protected well 5 7 Unprotected well 0 8 Water from spring 0 9 Rainwater 0 10 Tanker truck (reported) 6 11 Cart with small tank (reported) 2 12 Surface water(river/dam/lake/pond/stream/canal/irrigation channel) 0 13 Bottled water 0 14 Water vendor (with jericans) 74 Sysmiss 10 Source has running water at the time of the interview 130 274 0 1 -999 Don't know 0 0 No 112 1 Yes 18 Sysmiss 274 Days with water: Monday 130 274 0 1 -999 Don't know 0 0 No 100 1 Yes 30 Sysmiss 274 Days with water: Tuesday 130 274 0 1 -999 Don't know 0 0 No 83 1 Yes 47 Sysmiss 274 Days with water: Wednesday 130 274 0 1 -999 Don't know 0 0 No 108 1 Yes 22 Sysmiss 274 Days with water: Thursday 130 274 0 1 -999 Don't know 0 0 No 105 1 Yes 25 Sysmiss 274 Days with water: Friday 130 274 0 1 -999 Don't know 0 0 No 120 1 Yes 10 Sysmiss 274 Days with water: Saturday 130 274 0 1 -999 Don't know 0 0 No 104 1 Yes 26 Sysmiss 274 Days with water: Sunday 130 274 0 1 -999 Don't know 0 0 No 115 1 Yes 15 Sysmiss 274 Days with water: Don't know 130 274 0 1 -999 Don't know 0 0 No 126 1 Yes 4 Sysmiss 274 Days water: Don’tknow 130 274 0 1 -999 Don't know 0 0 No 128 1 Yes 2 Sysmiss 274 Number of households using this facility 356 48 0 2000 0 1 1 30 2 43 3 37 4 39 5 25 6 26 7 22 8 18 9 16 10 14 11 3 12 3 13 3 14 1 15 2 16 2 17 1 18 1 19 2 20 5 22 2 23 2 26 1 28 1 30 1 40 1 50 3 56 1 70 1 100 6 150 2 200 16 250 1 300 5 400 3 500 7 600 3 700 1 1000 4 2000 1 Sysmiss 48 Main water source in the compound 404 0 1 -999 Don't know 0 0 No 297 1 Yes 107 Time in minutes to collect water from this source 295 109 0 180 0 1 1 13 2 15 3 7 4 1 5 43 6 3 10 64 12 1 15 31 20 36 30 44 40 1 45 2 60 22 90 2 120 5 180 4 Sysmiss 109 Times in a typical week collect water from this source 297 107 1 70 1 46 2 31 3 49 4 13 5 14 6 12 7 69 8 3 9 3 10 10 12 3 14 5 15 5 16 1 18 1 20 3 21 5 25 1 28 10 30 5 35 3 49 3 70 2 Sysmiss 107 Satisfaction with main water source 404 1 4 -999 Don't know 0 1 Very Satisfied 70 2 Somewhat Satisfied 123 3 Less than Satisfied 78 4 Completely Dissatisfied 133 Pay for use of main water source 404 0 2 0 No 12 1 Yes 322 2 Included in rent 70 Amount paid for use of main water source 320 84 1 3000 1 1 2 44 3 23 4 1 5 125 10 36 15 19 20 41 30 2 100 1 150 1 200 5 210 1 300 1 450 1 500 3 540 1 600 1 700 1 800 2 900 1 1200 4 1300 1 1550 1 1800 1 2000 1 3000 1 Sysmiss 84 Units of measurement 321 83 1 3 -888 Other (specify) 0 1 Jerrican (20litre) 311 2 Tanker 0 3 Cubic metre 10 Sysmiss 83 Main sanitation facility is within the compound 404 0 1 -999 Don't know 0 0 No 28 1 Yes 376 Time to walk to the sanitation facility 28 376 1 3 1 24 2 3 3 1 Sysmiss 376 Satisfaction with your main sanitation facilities 404 1 4 -999 Don't know 0 1 Very Satisfied 211 2 Somewhat Satisfied 130 3 Less than Satisfied 37 4 Completely Dissatisfied 26 Pay for use of your main sanitation facilities 404 0 2 0 No 263 1 Yes 1 2 Included in rent 140 Amount paid for use of your main sanitation facilities per visit 1 403 450 450 450 1 Sysmiss 403 How often pay for use of main sanitation facilities per day 1 403 4 4 1 Per use 0 2 Per day 0 3 Per week 0 4 Per month 1 Sysmiss 403 Number of toilet facilities in compound 376 28 1 22 1 60 2 265 3 29 4 9 5 1 6 4 7 1 8 3 9 2 12 1 22 1 Sysmiss 28 Main toilet facility currently used 404 1 3 1 Flush/Pour flush 399 2 Ventilated improved pit latrine 3 3 Pit latrine with slab 2 4 Composting toilet 0 5 Pit latrine without slab / open pit 0 6 Bucket 0 7 Hanging toilet / hanging latrine 0 8 Plastic bag system (flying toilet) 0 9 Peepoo 0 Where flush toilet or pour flush is connected to 399 5 1 4 1 Connected to piped sewer system 396 2 Connected to septic tank 2 3 Connected to pit latrine 0 4 Flush/pour to don't know where 1 Sysmiss 5 Features: Latrine elevated (built above ground) 404 0 1 -999 Don't know 0 0 No 256 1 Yes 148 Features: Foot rests 404 0 1 -999 Don't know 0 0 No 315 1 Yes 89 Features: Seat 404 0 1 -999 Don't know 0 0 No 398 1 Yes 6 Features: Floor tiles 404 0 1 -999 Don't know 0 0 No 366 1 Yes 38 Features: Wall tiles 404 0 1 -999 Don't know 0 0 No 372 1 Yes 32 Features: Hole cover 404 0 1 -999 Don't know 0 0 No 396 1 Yes 8 Features: Water seal 404 0 1 -999 Don't know 0 0 No 127 1 Yes 277 Features: No superstructure 404 0 -999 Don't know 0 0 No 404 1 Yes 0 Features: Could not observe 404 0 1 -999 Don't know 0 0 No 402 1 Yes 2 Features: Other 404 0 1 -999 Don't know 0 0 No 403 1 Yes 1 Superstructure: Roof 404 0 1 -999 Don't know 0 0 No 37 1 Yes 367 Superstructure: Fully enclosed wall 404 0 1 -999 Don't know 0 0 No 46 1 Yes 358 Superstructure: Partially enclosed wall 404 0 1 -999 Don't know 0 0 No 366 1 Yes 38 Superstructure: Full door 404 0 1 -999 Don't know 0 0 No 19 1 Yes 385 Superstructure: Half door 404 0 1 -999 Don't know 0 0 No 395 1 Yes 9 Superstructure: Lockable door 404 0 1 -999 Don't know 0 0 No 79 1 Yes 325 Superstructure: Curtain 404 0 1 -999 Don't know 0 0 No 402 1 Yes 2 Superstructure: No superstructure 404 0 -999 Don't know 0 0 No 404 1 Yes 0 Superstructure: Could not observe 404 0 1 -999 Don't know 0 0 No 402 1 Yes 2 Superstructure: Other 404 0 -999 Don't know 0 0 No 404 1 Yes 0 Handwashing station 404 0 1 -999 Don't know 0 0 No 305 1 Yes 99 Water storage tank 404 0 1 -999 Don't know 0 0 No 125 1 Yes 279 Toilet facility is private or shared 404 1 3 1 Private 393 2 Shared by several compounds 8 3 Public/used by all 3 Households that use facility 403 1 1 70 1 45 2 48 3 62 4 39 5 38 6 39 7 32 8 28 9 21 10 16 11 8 12 7 13 5 14 4 15 2 16 2 19 2 20 1 26 1 28 1 30 1 70 1 Sysmiss 1 Toilet facility is flooded or blocked 404 0 1 -999 Don't know 0 0 No 384 1 Yes 20 Water meter installed 404 0 1 -999 Don't know 0 0 No 63 1 Yes 341 Water meter in working condition 341 63 0 2 0 No 69 1 Yes 248 2 Not observable 24 Sysmiss 63 Satisfaction with life 402 2 1 10 1 52 2 39 3 36 4 29 5 151 6 27 7 18 8 14 9 6 10 30 Sysmiss 2 Satisfaction with the financial situation of your household 399 5 1 10 1 65 2 42 3 47 4 64 5 114 6 14 7 14 8 12 9 9 10 18 Sysmiss 5 Income group 400 4 1 10 1 73 2 59 3 61 4 64 5 95 6 15 7 12 8 9 9 2 10 10 Sysmiss 4 I did not feel like eating; my appetite was poor 399 5 1 4 -999 Dont Know 0 -998 Refused to Answer 0 1 243 2 Some or a little of the time (1-2 days) 88 3 Occasionally or a moderate amount of time (3-4 days) 46 4 All of the time (5-7 days) 22 Sysmiss 5 I had trouble keeping my mind on what I was doing 399 5 1 4 -999 Dont Know 0 -998 Refused to Answer 0 1 164 2 Some or a little of the time (1-2 days) 104 3 Occasionally or a moderate amount of time (3-4 days) 78 4 All of the time (5-7 days) 53 Sysmiss 5 I felt depressed 399 5 1 4 -999 Dont Know 0 -998 Refused to Answer 0 1 205 2 Some or a little of the time (1-2 days) 93 3 Occasionally or a moderate amount of time (3-4 days) 52 4 All of the time (5-7 days) 49 Sysmiss 5 I felt that everything I did was an effort 401 3 1 4 -999 Dont Know 0 -998 Refused to Answer 0 1 112 2 Some or a little of the time (1-2 days) 98 3 Occasionally or a moderate amount of time (3-4 days) 61 4 All of the time (5-7 days) 130 Sysmiss 3 My sleep was restless 399 5 1 4 -999 Dont Know 0 -998 Refused to Answer 0 1 214 2 Some or a little of the time (1-2 days) 93 3 Occasionally or a moderate amount of time (3-4 days) 51 4 All of the time (5-7 days) 41 Sysmiss 5 I could not sleep out of stress. 401 3 1 4 -999 Dont Know 0 -998 Refused to Answer 0 1 215 2 Some or a little of the time (1-2 days) 94 3 Occasionally or a moderate amount of time (3-4 days) 45 4 All of the time (5-7 days) 47 Sysmiss 3 I could not start doing what I was supposed to do 401 3 1 4 -999 Dont Know 0 -998 Refused to Answer 0 1 171 2 Some or a little of the time (1-2 days) 142 3 Occasionally or a moderate amount of time (3-4 days) 59 4 All of the time (5-7 days) 29 Sysmiss 3 Most people can be trusted 404 1 2 1 Most people can be trusted 10 2 Need to be very careful in dealing with people 394 Happiness 404 1 4 1 Very happy 90 2 Quite happy 255 3 Not very happy 47 4 Not at all happy 12 I do not know what will happen in the future but I usually think good things wil 401 3 1 5 -999 Don't know 0 1 193 2 182 3 14 4 8 5 4 Sysmiss 3 It's easy for me to relax 401 3 1 5 -999 Don't know 0 1 98 2 181 3 29 4 65 5 28 Sysmiss 3 I have bad luck all the time 399 5 1 5 -999 Don't know 0 1 18 2 44 3 27 4 142 5 168 Sysmiss 5 I am optimistic about my future 403 1 1 5 -999 Don't know 0 1 228 2 153 3 5 4 11 5 6 Sysmiss 1 I enjoy my friends a lot 402 2 1 5 -999 Don't know 0 1 155 2 167 3 24 4 39 5 17 Sysmiss 2 I like keeping myself busy 403 1 1 4 -999 Don't know 0 1 220 2 168 3 9 4 6 Sysmiss 1 I am not a lucky person 400 4 1 5 -999 Don't know 0 1 24 2 35 3 29 4 136 5 176 Sysmiss 4 I don't get upset too easily 399 5 1 5 -999 Don't know 0 1 126 2 138 3 20 4 62 5 53 Sysmiss 5 In the future I do not think my life would be good 400 4 1 5 -999 Don't know 0 1 17 2 14 3 7 4 148 5 214 Sysmiss 4 In the future I expect my life to be good 402 2 1 5 -999 Don't know 0 1 260 2 125 3 4 4 7 5 6 Sysmiss 2 I feel that I am a person that others usually respect 392 12 1 5 -999 Don't know 0 1 155 2 177 3 40 4 14 5 6 Sysmiss 12 I feel that I have a number of good qualities 394 10 1 5 -999 Don't know 0 1 154 2 195 3 22 4 18 5 5 Sysmiss 10 I am able to do things as well as most other people 401 3 1 5 -999 Don't know 0 1 183 2 183 3 12 4 19 5 4 Sysmiss 3 I am not proud of myself 401 3 1 5 -999 Don't know 0 1 35 2 59 3 15 4 134 5 158 Sysmiss 3 I am satisfied with myself 403 1 1 5 -999 Don't know 0 1 215 2 150 3 6 4 24 5 8 Sysmiss 1 Sometimes I think that others do not respect me 390 14 1 5 -999 Don't know 0 1 39 2 151 3 50 4 87 5 63 Sysmiss 14 How often you feel not successful in managing life 399 5 0 4 -999 Don't answer 0 0 Never 74 1 Almost Never 34 2 Sometimes 159 3 Fairly Often 61 4 Very Often 71 Sysmiss 5 How often you feel confident about your ability to handle problems 396 8 0 4 -999 Don't answer 0 0 Never 22 1 Almost Never 36 2 Sometimes 141 3 Fairly Often 86 4 Very Often 111 Sysmiss 8 How often you feel that you are lucky 397 7 0 4 -999 Don't answer 0 0 Never 51 1 Almost Never 39 2 Sometimes 137 3 Fairly Often 88 4 Very Often 82 Sysmiss 7 How often you fell that problems in your life were too many 398 6 0 4 -999 Don't answer 0 0 Never 79 1 Almost Never 36 2 Sometimes 131 3 Fairly Often 81 4 Very Often 71 Sysmiss 6