10.17037/DATA.00004719
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.
This Dataset is comprised of five files in total. This includes two data tables:
Three Stata do-file to reproduce the analysis:
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 |
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) |