Data for: Effects of a school-based water and hygiene intervention on the health and school attendance of kindergarten pupils in Addis Ababa, Ethiopia: a cluster-randomised controlled trial – Data Codebook

Persistent identifier

10.17037/DATA.00004719

Description

Data and code to reproduce the analysis reported in “Effects of a school-based water and hygiene intervention on the health and school attendance of kindergarten pupils in Addis Ababa, Ethiopia: a cluster-randomised controlled trial”. These contain high-level information on 39 schools covered in the study (number of kindergarten pupils, kindergarten class sizes, gender parity in kindergarten enrolment) and pupil-level information on travel time to school, reported illnesses, number of days reported absent, and other information related to kindergarten pupils and their caregivers. These are supplemented by three STATA DO files intended to recreate the analysis.

Codebook

This Dataset is comprised of five files in total. This includes two data tables:

Three Stata do-file to reproduce the analysis:

WISE_KG_study_school_dataset

The “WISE_KG_study_school_dataset” file contains the following variables.

Variable name Variable description Answer code Answer label Variable type
school_ID Unique ID number for the school     String
arm Intervention arm     Numeric
    0 Control  
    1 Intervention  
strata Stratification variables     Numeric
    1 Small primary (<1200) with kindergarten (main study)  
    2 Large primary (≥1200) with kindergarten (main study)  
    3 Additional kindergarten schools (not enrolled in main study)  
total_pupils_KG Total number of pupils in kindergarten at enrolment Count   Numeric
class_size_KG Estimated mean class size for kindergarten at enrolment Continuous   Numeric
gender_parity_KG Adjusted gender parity index for kindergarten at enrolment Continuous (0–2)   Numeric
provided_contacts Provided caregiver contacts for enrolment     Numeric
    0 No  
    1 Yes  

WISE_KG_study_pupil_dataset_WIDE

The “WISE_KG_study_pupil_dataset_WIDE” file contains the following variables.

Variable name Variable description Answer code Answer label Variable type
school_ID Unique ID number for the school Open ended   Numeric
pupil_ID Unique ID number for the pupil Open ended   Numeric
arm Intervention arm     Numeric
    0 Control  
    1 Intervention  
strata Stratification variables     Numeric
    1 Small primary (<1200) with kindergarten (main study)  
    2 Large primary (≥1200) with kindergarten (main study)  
    3 Additional kindergarten schools (not enrolled in main study)  
completed_1 Participant completed telephone interview 1 (enrolment)     Numeric
    0 No  
    1 Yes  
reason_not_1 Reason for not completing telephone interview 1     Numeric
    0 Not attempted (end of study)  
    1 No working phone number  
    2 Call never answered  
    3 Wrong number / not caregiver  
    4 Rescheduled without successful follow-up  
    5 Pupil left school  
    6 Refusal  
    7 Conducted too early  
    8 Other reason (not specified)  
    . Not applicable (interview completed)  
completed_2 Participant completed telephone interview 2     Numeric
    0 No  
    1 Yes  
reason_not_2 Reason for not completing telephone interview 2     Numeric
    0 Not attempted (end of study)  
    1 No working phone number  
    2 Call never answered  
    3 Wrong number / not caregiver  
    4 Rescheduled without successful follow-up  
    5 Pupil left school  
    6 Refusal  
    7 Conducted too early  
    8 Other reason (not specified)  
    . Not applicable (interview completed)  
completed_3 Participant completed telephone interview 3     Numeric
    0 No  
    1 Yes  
reason_not_3 Reason for not completing telephone interview 3     Numeric
    0 Not attempted (end of study)  
    1 No working phone number  
    2 Call never answered  
    3 Wrong number / not caregiver  
    4 Rescheduled without successful follow-up  
    5 Pupil left school  
    6 Refusal  
    7 Conducted too early  
    8 Other reason (not specified)  
    . Not applicable (interview completed)  
completed_4 Participant completed telephone interview 4 (final)     Numeric
    0 No  
    1 Yes  
reason_not_4 Reason for not completing telephone interview 4     Numeric
    0 Not attempted (end of study)  
    1 No working phone number  
    2 Call never answered  
    3 Wrong number / not caregiver  
    4 Rescheduled without successful follow-up  
    5 Pupil left school  
    6 Refusal  
    7 Conducted too early  
    8 Other reason (not specified)  
    . Not applicable (interview completed)  
pupil_age Age of pupil at enrolment Continuous or Integer   Numeric
    . Not applicable (not enrolled)  
eligible Pupil eligible at enrolment (aged 3-6)     Numeric
    0 No  
    1 Yes  
    . Not applicable (not enrolled)  
pupil_gender Pupil gender     Numeric
    1 Female  
    2 Male  
    . Not applicable (not enrolled)  
caregiver_age Age of caregiver at enrolment     Numeric
      Continuous or Integer  
    . Not applicable (not enrolled)  
caregiver_gender Caregiver gender     Numeric
    1 Female  
    2 Male  
    . Not applicable (not enrolled)  
caregiver_relation Caregiver relation to enrolled pupil     Numeric
    1 Mother  
    2 Father  
    3 Other  
    . Not applicable (not enrolled)  
caregiver_education Caregiver's highest education level completed     String
    0 None / pre-primary  
    1 Primary school  
    2 Secondary school  
    3 Higher education / university  
    .p Prefer not to say  
    . Not applicable (not dropout)  
travel_time Time taken to travel to school (mins) Continuous   Numeric
    . Not applicable (not enrolled)  
hh_members Number of household members (including participant)   Count Numeric
    . Not applicable (not enrolled)  
water_basic Household has at least basic water supply     Numeric
    0 No  
    1 Yes  
    . Not applicable (not enrolled)  
treatment_boiling Household water treatment: boiling     Numeric
    0 No  
    1 Yes  
    . Not applicable (not enrolled)  
treatment_filtration Household water treatment: filtration, absorption, sedimentation     Numeric
    0 No  
    1 Yes  
    . Not applicable (not enrolled)  
treatment_chemical Household water treatment: chemical (e.g. Wuha Agar)     Numeric
    0 No  
    1 Yes  
    . Not applicable (not enrolled)  
treatment_other Household water treatment: other     Numeric
    0 No  
    1 Yes  
    . Not applicable (not enrolled)  
treatment_none Household water treatment: none     Numeric
    0 No  
    1 Yes  
    . Not applicable (not enrolled)  
sanitation_basic Household has at least basic sanitation     String
    0 No  
    1 Yes  
    .d Don’t know  
    .p Prefer not to say  
    . Not applicable (not enrolled)  
hygiene_basic Household has handwashing facility with soap and water     Numeric
    0 No  
    1 Yes  
    . Not applicable (not enrolled)  
school_days_1 Total school days in past week reported at telephone interview 1 Count   Numeric
    . Not applicable (interview not completed)  
school_days_2 Total school days in past week reported at telephone interview 2 Count   Numeric
    . Not applicable (interview not completed)  
school_days_3 Total school days in past week reported at telephone interview 3 Count   Numeric
    . Not applicable (interview not completed)  
school_days_4 Total school days in past week reported at telephone interview 4 Count   Numeric
    . Not applicable (interview not completed)  
school_days Total school days of reporting across follow-up period Count   Numeric
    . Not applicable (interview not completed)  
days_absent_1 Days caregiver reported that pupil was absent out of the total in past week at telephone interview 1 Count   Numeric
    . Not applicable (interview not completed)  
days_absent_2 Days caregiver reported that pupil was absent out of the total in past week at telephone interview 2 Count   Numeric
    . Not applicable (interview not completed)  
days_absent_3 Days caregiver reported that pupil was absent out of the total in past week at telephone interview 3 Count   Numeric
    . Not applicable (interview not completed)  
days_absent_4 Days caregiver reported that pupil was absent out of the total in past week at telephone interview 4 Count   Numeric
    . Not applicable (interview not completed)  
days_absent Total days reported absent across follow-up period Count   Numeric
    . Not applicable (not enrolled)  
absent_prop Caregiver-reported absence prevalence (proportion of total school days reported absent) Count   Numeric
    . Not applicable (not enrolled)  
total_days Total days of reporting across follow-up period Count   Numeric
    . Not applicable (not enrolled)  
days_diar_1 Days caregiver reported that pupil had diarrhoea out of the total in past week at telephone interview 1 Count   Numeric
    . Not applicable (interview not completed)  
days_diar_2 Days caregiver reported that pupil had diarrhoea out of the total in past week at telephone interview 2 Count   Numeric
    . Not applicable (interview not completed)  
days_diar_3 Days caregiver reported that pupil had diarrhoea out of the total in past week at telephone interview 3 Count   Numeric
    . Not applicable (interview not completed)  
days_diar_4 Days caregiver reported that pupil had diarrhoea out of the total in past week at telephone interview 4 Count   Numeric
    . Not applicable (interview not completed)  
days_diar Total days reported with diarrhoea across follow-up period Count   Numeric
    . Not applicable (not enrolled)  
diar_prop Caregiver-reported diarrhoea prevalence (proportion of total days reported with diarrhoea) Continuous   Numeric
    . Not applicable (not enrolled)  
days_resp_1 Days caregiver reported that pupil had respiratory illness out of the total in past week at telephone interview 1 Count   Numeric
    . Not applicable (interview not completed)  
days_resp_2 Days caregiver reported that pupil had respiratory illness out of the total in past week at telephone interview 2 Count   Numeric
    . Not applicable (interview not completed)  
days_resp_3 Days caregiver reported that pupil had respiratory illness out of the total in past week at telephone interview 3 Count   Numeric
    . Not applicable (interview not completed)  
days_resp_4 Days caregiver reported that pupil had respiratory illness out of the total in past week at telephone interview 4 Count   Numeric
    . Not applicable (interview not completed)  
days_resp Total days reported with respiratory illness across follow-up period Count   Numeric
    . Not applicable (not enrolled)  
resp_prop Caregiver-reported respiratory illness prevalence (proportion of total days reported with respiratory illness) Continuous   Numeric
    . Not applicable (not enrolled)