DDI_BGD_2015_LCCSIE-FU_v01_M_WB Development Data Group 2023-02-17 NADA Version 01 (2023-02-17) Impact Evaluation of Low-Cost In-Line Chlorination Systems in Urban Dhaka on Water Quality and Child Health 2015, Follow-up Survey LCCSIE-FU 2015 BGD_2015_LCCSIE-FU_v01_M Stephen P. Luby Amy Pickering Sonia Sultana Pratibha Mistry World Bank NADA World Bank Strategic Impact Evaluation Fund Strategic Impact Evaluation Fund Pratibha Mistry Strategic Impact Evaluation Fund Impact Evaluation Study Version 1.2: Edited data, second version, for internal use only. Bangladesh Two urban communities in or near Dhaka. Face-to-face [f2f] Strategic Impact Evaluation Fund Pratibha Mistry dhaka_follow_up_submit Household Data 5746 257 dhaka_chlorine_residual_followup_submit Chlorine Residual Data 12235 14 dhaka_chlorine_followup_microbial_water Microbial Water Quality 1072 9 start_timedate 5746 2012-01-01 2016-12-22 Full survey or anthropometry only 5746 1 1 1 New survey Study site 5746 1 2 1 Tongi 2 Dhaka Uddan survey_round 4798 948 2 7 month 5746 1 12 day 5746 1 31 pumpid 5746 2 125 newHH 5746 1 Unique household ID 5746 20101 1250105 Gender of respondent 5746 1 Female 1 Male consent 5617 129 1 1 consent_tostool 1042 4704 1 age_oryear 5617 129 1 2 age_birth 5581 165 6 72 age_birthyear 36 5710 1974 1999 age_years 5581 165 6 72 age_yearsbirth 36 5710 16 42 Number of households in compound 5617 129 1 94 Number of people in household 5617 129 1 27 Number of children under 2 in household 5617 129 2 Number of children over 2 and under 5 in household 5617 129 3 Total number of children under 5 in household 5617 129 4 Number of children between 5 and 18 years in household 630 5116 5 Number of adults over 18 or older in household 630 5116 10 Number of people in household 630 5116 2 15 Education level of respondent 630 5116 1 9 1 No formal schooling 2 Some primary education 3 Completed primary education 4 Some secondary school 5 Completed secondary school 6 Some college 7 Completed college 8 Some university 9 Completed university Sysmiss Other education level of respondent 5746 Education level of respondent's spouse 630 5116 999 Respondent is not married/does not have spouse 1 No formal schooling 2 Some primary education 3 Completed primary education 4 Some secondary school 5 Completed secondary school 6 Some college 7 Completed college 8 Some university 9 Completed university 999 Sysmiss Other education level of respondent's spouse 5746 Number of rooms in house, excluding bathrooms and kitchens 630 5116 1 13 Time respondent has lived in Dhaka 630 5116 60 Units of time lived in Dhaka 630 5116 1 2 1 Months 2 Years Sysmiss Time respondent has lived in compound 630 5116 45 Units of time lived in compound 630 5116 1 2 1 Months 2 Years Sysmiss Time respondent has lived in house 630 5116 45 Units of time lived in house 630 5116 1 2 1 Months 2 Years Sysmiss Relationship to landlord/property manager 5617 129 1 777 1 No relation/tenant-landlord only 2 Landlord is a relative (cousin, uncle, father, etc.) 3 Landlord is a friend 4 Landlord is a work colleague 5 Respondent is landlord 6 Landlord is an in-law (mother-in-law, father-in-law,etc.) 777 Other Sysmiss Other relationship of respondent to landlord/property manager 5746 Primary water source 5617 129 1 6 1 Tap in public location 2 Tap in compound 3 Tap in the household 4 Tap in neighboring compound 6 Shallow tubewell Sysmiss Other type of primary source 5746 Location of primary tap 5002 744 1 3 1 Kitchen 2 Bathing area 3 Toilet Sysmiss Overhead or underground tank 2300 3446 1 1 1 Overhead Sysmiss Owner of water tank 2300 3446 1 2 1 Landlord 2 Neighboring compound Sysmiss Number of households using water tank 2300 3446 4 73 Volume of water tank 2300 3446 20000 Connected to WASA system 2300 3446 1 No 1 Yes Sysmiss Unique water point ID 5607 139 18 96014 Compound ID when water point is in neighboring compound 10 5736 221 1931 Cooks with primary water source 630 5116 999 1 Yes 999 Don't know Sysmiss Washes dishes with primary water source 630 5116 999 1 Yes 999 Don't know Sysmiss Does laundry with primary water source 630 5116 999 1 Yes 999 Don't know Sysmiss Bathes with primary water source 630 5116 999 1 Yes 999 Don't know Sysmiss Drinks primary water source 630 5116 999 1 Yes 999 Don't know Sysmiss Cleans the house with primary water source 630 5116 999 1 Yes 999 Don't know Sysmiss Household uses a secondary source 5617 129 1 No 1 Yes Sysmiss Type of secondary source 222 5524 1 777 1 Tap in public location 2 Tap in compound 3 Tap in the household 4 Tap in neighboring compound 5 Deep tubewell 6 Shallow tubewell 777 Other Sysmiss Other type of secondary source 5746 Drinks secondary source water 222 5524 1 No 1 Yes Sysmiss Number of days water was collected from secondary source for drinking in last 7 222 5524 7 drinking_weeks 95 5651 104 Secondary source connected to same submersible pump/tank system 222 5524 1 No 1 Yes Sysmiss Location of secondary source 222 5524 1 777 1 In the compound 2 In a neighboring compound 3 In a public location 777 Other Sysmiss Other location of secondary source 5746 Main reason for using a secondary source 222 5524 1 999 1 Water is often not available 2 Bad smell/taste 3 Water from tap is not safe 4 Wait times at the tap are too long 777 Other 999 Don't know/could not respond Sysmiss Other reason for using secondary source 5746 Days per week water is available 5616 130 7 Hours per day water is available 5617 129 24 Water comes at predictable times 5617 129 1 999 1 Always/almost always 2 Sometimes 555 Rarely/never 999 Don't know Sysmiss Number of unexpected interruptions in water service in past month 5617 129 999 Taste of water 5617 129 1 999 1 Good/no problems 2 Salty 3 Chemical/chlorine 4 Soil/dirt 5 Sometimes good, sometimes bad 777 Other 999 Don't know Sysmiss Other water taste 5746 Safety of water without treatment 630 5116 1 3 1 Very safe 2 Somewhat safe 3 Unsafe Sysmiss How often the household treats water before drinking 5617 129 1 555 1 Always/almost always 2 Sometimes 3 Rarely 555 Never Sysmiss Treats by boiling 1272 4474 1 555 1 Always 2 Often 3 Sometimes 4 Rarely 555 Never Sysmiss Treats by liquid bleach 1272 4474 1 999 1 Always 4 Rarely 555 Never 999 Don't know Sysmiss Treats by chlorine tablets 1272 4474 1 555 1 Always 3 Sometimes 555 Never Sysmiss Treats by alum/fitkiri 1272 4474 1 999 1 Always 555 Never 999 Don't know Sysmiss Treats by ceramic filter 1272 4474 1 999 1 Always 2 Often 3 Sometimes 4 Rarely 555 Never 999 Don't know Sysmiss Treats by cloth filter 1272 4474 1 999 1 Always 2 Often 3 Sometimes 4 Rarely 555 Never 999 Don't know Sysmiss Treats by other method 1272 4474 1 555 1 Always 555 Never Sysmiss Other type of water treatment 5746 Type of toilet used by household 630 5116 1 6 1 Household doesn't have access to a toilet 2 Flush/pour flush toilet connected to tank/pit 3 Pit latrine 5 Composting toilet 6 Flush toilet connected to sewerage line/pipe/drain Sysmiss Other type of toilet 5746 Location of toilet 625 5121 1 3 1 In respondent's compound 2 In neighboring compound 3 In public location outside compound Sysmiss Number of households, other than respondent's own, the toilet is shared with 625 5121 111 Ownership of home 630 5116 1 777 1 Rent 2 Owned house 777 Other Sysmiss Other ownership arrangement 5746 Monthly rent payment (taka) 446 5300 11040 Amount household pays to use water from tap 630 5116 999 40 46 50 60 65 70 75 80 85 86 99 100 120 150 160 200 250 900 999 Don't know Sysmiss Units for water payment 346 5400 1 777 1 Per week 2 Per month 777 Other arrangement Sysmiss Other units for payment 5746 Main source of income 630 5116 1 777 1 Fixed term job 2 Self employed/own business 3 Contract job 4 Remittance from abroad 7 Agricultural income 8 Day labour/rickshaw puller 777 Other Sysmiss Other main source of income 5746 Number of household members earning income 630 5116 1 7 Monthly income of household (taka) 630 5116 1 400000 Regularly sends money to relatives/friends elsewhere 630 5116 1 Owns motorcycle 630 5116 1 No 1 Yes Sysmiss Owns television/VCD 630 5116 1 No 1 Yes Sysmiss Owns mobile phone 630 5116 1 No 1 Yes Sysmiss Owns radio/cassette player/CD player 630 5116 1 No 1 Yes Sysmiss Owns refrigerator 630 5116 1 No 1 Yes Sysmiss Owns sewing machine 630 5116 1 No 1 Yes Sysmiss Owns alna 630 5116 1 No 1 Yes Sysmiss Owns almira/wardrobe (wooden/steel) 630 5116 1 No 1 Yes Sysmiss Household owns land 630 5116 999 Amount of land household owns 95 5651 1 1800 Units of area of land owned 95 5651 3 999 3 Bighas 4 Kathas/cottahs 5 Koras 6 Gondas 7 Shatangsho 999 Don't know Sysmiss Unique ID of youngest child 5616 130 201011 12501051 Gender of youngest child 5616 130 1 2 1 Girl 2 Boy Sysmiss Age of youngest child 5616 130 1 251 Units for youngest child's age 5616 130 1 3 1 Months 2 Weeks 3 Days Sysmiss Vaccination card for youngest child 5616 130 1 No, card NOT available 1 Yes, card is observed Sysmiss Day of birth of youngest child 5616 130 1 99 Month of birth of youngest child 5616 130 1 99 Year of birth of youngest child 5616 130 2010 9999 Source of date of birth for youngest child 5616 130 1 4 1 Clinic card/vaccination booklet 2 Respondent recall 3 Other written source 4 Date of birth unknown Sysmiss Other source of birthdate 5746 In past 7 days, youngest child showed fever 5616 130 1 No 1 Yes Sysmiss In past 7 days, youngest child showed toothache 5616 130 1 No 1 Yes Sysmiss In past 7 days, youngest child showed diarrhea 5616 130 1 No 1 Yes Sysmiss In past 7 days, youngest child showed congestion/runny nose 5616 130 1 No 1 Yes Sysmiss In past 7 days, child had 3 or more bowel movements in 24 hour period 3840 1906 1 In past 24 hours, child had 3 or more bowel movements 5616 130 3 No 1 Yes 3 Sysmiss Number of bowel movements for youngest child in last 24 hours 5616 130 20 In past 7 days, youngest child showed watery/soft stool 5616 130 1 No 1 Yes Sysmiss In past 7 days, youngest child showed constant coughs 5616 130 1 No 1 Yes Sysmiss In past 7 days, youngest child showed blood in stool 5616 130 1 No 1 Yes Sysmiss In past 7 days, youngest child showed bruising, scrapes, cuts 5616 130 1 No 1 Yes Sysmiss In past 7 days, youngest child showed skin rash 5616 130 1 No 1 Yes Sysmiss In past 7 days, youngest child showed difficulty breathing 5616 130 1 No 1 Yes Sysmiss Number of days child was sick with symptoms 810 4936 75 Color of youngest child's last stool 5616 130 1 999 1 Brown 2 Yellow 3 Green 4 Black 5 Gray 999 Don't know Sysmiss Youngest child is breastfeeding 5616 130 999 1 Yes 999 Don't know Sysmiss Youngest child is exclusively breastfeeding 2766 2980 1 1 Yes Sysmiss Caregiver reports child has had liquid stool similar to pictured on chart in pas 3723 2023 999 Child has consumed anitibiotics in mast 2 months 3724 2022 999 Youngest child has visible runny nose 5591 155 1 No 1 Yes Sysmiss Child has visited health care facility for illness treatment in past 2 months 5616 130 5 What type of illness did the child have? 3858 1888 1 777 1 gastrointestinal 2 respiratory 3 dengue 4 fever 777 other Sysmiss money spent on provider fees for child in past 2 months, taka 5616 130 2600 money spent on medicine for child in past 2 months, taka 5616 130 15700 money spent on diagnostic tests for child in past 2 months, taka 5616 130 12000 money spent on transport to health facility for child in past 2 months, taka 5616 130 5000 money spent on other illness related costs for child in past 2 months, taka 5616 130 8400 Possible to take youngest child's weight 5591 155 1 4 1 Yes 3 No, mother refused this measurement 4 No, child refused this measurement Sysmiss Youngest child wearing clothes during weight measurement 5585 161 1 4 1 No clothes 2 Only shirt 3 Only pants 4 Both shirt and pants Sysmiss Youngest child wearing shoes during weight measurement 5586 160 1 No 1 Yes Sysmiss weight11 5575 171 1.9 119 weight21 5575 171 107 weight31 5571 175 107 Possible to take youngest child's height 1041 4705 1 4 1 Yes 3 No, mother refused this measurement 4 No, child refused this measurement Sysmiss height11 775 4971 111.5 height21 771 4975 111.5 height31 767 4979 111.7 Child cough during height/weight measurements 5583 163 1 No 1 Yes Sysmiss Youngest child referred for severe illness 5616 130 1 No 1 Yes Sysmiss Youngest child referred for low weight-to-age z-scores 5615 131 1 No 1 Yes Sysmiss Gender of second youngest child 561 5185 1 2 1 Girl 2 Boy Sysmiss Age of second youngest child 561 5185 1 59 Units for second youngest child's age 561 5185 1 3 1 Months 3 Days Sysmiss Vaccination card for second youngest child 561 5185 1 No, card NOT available 1 Yes, card is observed Sysmiss Day of birth of second youngest child 561 5185 1 99 Month of birth of second youngest child 561 5185 1 99 Year of birth of second youngest child 561 5185 2010 2016 Source of date of birth for second youngest child 561 5185 1 4 1 Clinic card/vaccination booklet 2 Respondent recall 4 Date of birth unknown Sysmiss Other source of birthdate 5746 In past 7 days, second youngest child showed fever 561 5185 1 No 1 Yes Sysmiss In past 7 days, second youngest child showed toothache 561 5185 1 No 1 Yes Sysmiss In past 7 days, second youngest child showed diarrhea 561 5185 1 No 1 Yes Sysmiss In past 7 days, second youngest child showed congestion/runny nose 561 5185 1 No 1 Yes Sysmiss In past 7 days, child had 3 or more bowel movements in 24 hour period 368 5378 1 In past 24 hours, child had 3 or more bowel movements 561 5185 1 No 1 Yes Sysmiss Number of bowel movements for second youngest child in last 24 hours 561 5185 99 In past 7 days, second youngest child showed watery/soft stool 561 5185 1 No 1 Yes Sysmiss In past 7 days, second youngest child showed constant coughs 561 5185 1 No 1 Yes Sysmiss In past 7 days, second youngest child showed blood in stool 561 5185 1 No 1 Yes Sysmiss In past 7 days, second youngest child showed bruising, scrapes, cuts 561 5185 1 No 1 Yes Sysmiss In past 7 days, second youngest child showed skin rash 561 5185 1 No 1 Yes Sysmiss In past 7 days, second youngest child showed difficulty breathing 561 5185 1 No 1 Yes Sysmiss Number of days child was sick with symptoms 112 5634 25 Color of second youngest child's last stool 561 5185 1 999 1 Brown 2 Yellow 3 Green 4 Black 5 Gray 999 Don't know Sysmiss Second youngest child is breastfeeding 561 5185 1 1 Yes Sysmiss Second youngest child is exclusively breastfeeding 168 5578 1 1 Yes Sysmiss Caregiver reports child has had liquid stool similar to pictured on chart in pas 356 5390 1 Child has consumed anitibiotics in mast 2 months 356 5390 1 second youngest child has visible runny nose 532 5214 1 No 1 Yes Sysmiss Child has visited health care facility for illness treatment in past 2 months 561 5185 5 What type of illness did the child have? 302 5444 1 777 1 gastrointestinal 2 respiratory 4 fever 777 other Sysmiss money spent on provider fees for child in past 2 months,taka 561 5185 1000 money spent on medicine for child in past 2 months, taka 561 5185 6000 money spent on diagnostic tests for child in past 2 months, taka 561 5185 2200 money spent on transport to health facility for child in past 2 months, taka 561 5185 500 money spent on other illness related costs for child in past 2 months, taka 561 5185 3000 Possible to take second youngest child's weight 531 5215 1 4 1 Yes 2 No, child not available 4 No, child refused this measurement Sysmiss Second youngest child wearing clothes during weight measurement 528 5218 1 4 1 No clothes 2 Only shirt 3 Only pants 4 Both shirt and pants Sysmiss Second youngest child wearing shoes during weight measurement 528 5218 No Sysmiss weight12 528 5218 2.2 18 weight22 528 5218 2.2 18 weight32 528 5218 2.2 62 Possible to take second youngest child's height 85 5661 1 4 1 Yes 4 No, child refused this measurement Sysmiss height12 63 5683 109.1 height22 63 5683 109.1 height32 63 5683 109.2 Child cough during height/weight measurements 528 5218 1 No 1 Yes Sysmiss Unique ID of third youngest child 28 5718 214011 11001123 Gender of third youngest child 28 5718 1 2 1 Girl 2 Boy Sysmiss Age of third youngest child 28 5718 1 58 Units for third youngest child's age 28 5718 1 3 1 Months 3 Days Sysmiss Vaccination card for third youngest child 28 5718 1 No, card NOT available 1 Yes, card is observed Sysmiss Day of birth of third youngest child 28 5718 3 27 Month of birth of third youngest child 28 5718 1 12 Year of birth of third youngest child 28 5718 2010 2016 Source of date of birth for third youngest child 28 5718 1 2 1 Clinic card/vaccination booklet 2 Respondent recall Sysmiss Other source of birthdate 5746 In past 7 days, third youngest child showed fever 28 5718 1 No 1 Yes Sysmiss In past 7 days, third youngest child showed toothache 28 5718 No Sysmiss In past 7 days, third youngest child showed diarrhea 28 5718 1 No 1 Yes Sysmiss In past 7 days, third youngest child showed congestion/runny nose 28 5718 1 No 1 Yes Sysmiss In past 7 days, child had 3 or more bowel movements in 24 hour period 19 5727 1 In past 24 hours, child had 3 or more bowel movements 28 5718 1 No 1 Yes Sysmiss Number of bowel movements for third youngest child in last 24 hours 28 5718 6 In past 7 days, third youngest child showed watery/soft stool 28 5718 1 No 1 Yes Sysmiss In past 7 days, third youngest child showed constant coughs 28 5718 No Sysmiss In past 7 days, third youngest child showed blood in stool 28 5718 No Sysmiss In past 7 days, third youngest child showed bruising, scrapes, cuts 28 5718 1 No 1 Yes Sysmiss In past 7 days, third youngest child showed skin rash 28 5718 1 No 1 Yes Sysmiss In past 7 days, third youngest child showed difficulty breathing 28 5718 No Sysmiss Number of days child was sick with symptoms 9 5737 10 Color of second youngest child's last stool 28 5718 2 3 2 Yellow 3 Green Sysmiss Third youngest child is breastfeeding 28 5718 1 1 Yes Sysmiss Third youngest child is exclusively breastfeeding 15 5731 1 1 Yes Sysmiss Caregiver reports child has had liquid stool similar to pictured on chart in pas 19 5727 1 Child has consumed anitibiotics in mast 2 months 19 5727 1 Third youngest child has visible runny nose 27 5719 1 No 1 Yes Sysmiss Child has visited health care facility for illness treatment in past 2 months 28 5718 5 What type of illness did the child have? 14 5732 1 777 1 gastrointestinal 2 respiratory 4 fever 777 other Sysmiss money spent on provider fees for child in past 2 months, taka 28 5718 1500 money spent on medicine for child in past 2 months, taka 28 5718 1100 money spent on diagnostic tests for child in past 2 months,taka 28 5718 money spent on transport to health facility for child in past 2 months, taka 28 5718 600 money spent on other illness related costs for child in past 2 months, taka 28 5718 Possible to take third youngest child's weight 27 5719 1 1 1 Yes Sysmiss Third youngest child wearing clothes during weight measurement 27 5719 1 4 1 No clothes 2 Only shirt 3 Only pants 4 Both shirt and pants Sysmiss Third youngest child wearing shoes during weight measurement 27 5719 No Sysmiss weight13 27 5719 2.9 16.4 weight23 27 5719 2.9 16.4 weight33 27 5719 2.9 16.4 Possible to take third youngest child's height 6 5740 1 4 1 Yes 4 No, child refused this measurement Sysmiss height13 4 5742 95.1 height23 4 5742 95.2 height33 4 5742 95.4 Child cough during height/weight measurements 27 5719 No Sysmiss Do you know what the doser at your water point is dosing? 3725 2021 1 no 1 yes Sysmiss If you had to guess, what do you think your doser is dosing? 3725 2021 1 2 1 chlorine 2 vitamins Sysmiss follow up survey round 5746 1 7 treatment assignment 5746 1 1 chlorine randomization block 5746 1 50 date of sample collection 12235 12235 1 12 12235 1 31 pump_ID 12235 2 125 household ID 7282 4953 201 6030101 tap ID from which stored water was collected 7204 5031 5 99999 tap ID 4953 7282 2 13244 follow up survey round 11452 783 7 free chlorine residual ppm 12065 170 4 total chlorine residual ppm 12066 169 5 treatment assignment 12235 1 vitamins (control) 1 chlorine Block 12235 1 50 month of data collection since follow up started 12235 2 14 whether sample was collected from tap or stored water 12235 1 stored drinking water 1 tap water study site 1072 CFU e.coli per 100ml water 1072 0.5 213 CFU total coliform per 100ml water 1072 0.5 200 household ID or tap ID 1072 207 1250103 date of sample collection 1072 follow up survey data collection round 1072 1 7 water point ID 1072 2 125 treatment assignment 1072 1 vitamins (control) 1 chlorine whether sample was collected from tap or stored water 1072 1 stored drinking water 1 tap water