Table 1.

Description of data sets

Data set	Data level	Data description	Sample size (n)	Sampling frame	Data use
1	Individual	Hematuria via dipstick; name; age; grade; school	260 boys	442 boys enrolled in school (3–19 years)	Data set 1 was used to describe UGS prevalence at the community level. It was also matched with data sets 2, 3, and 4 and used to determine whether infected children had poorer access to boreholes and/or better access to the river.
			255 girls	368 girls enrolled in school (3–19 years)
2	Household	GPS coordinates of household	394 households	395 households	Household data (data set 2) was matched to the infection status of children (data set 1). Household data (data set 2) was also matched with borehole and river data (data sets 3 and 4) to assess household access to water sources.
		Demographic info. for children in household	394 households
		Household water use preferences	247 households
		Household attitudes re. UGS	206 households
3	Borehole	GPS coordinates; turbidity; E. coli; total coliforms; O&M observations	8 boreholes	8 boreholes	Borehole data (data set 3) was matched with data sets 1 and 2 to assess access by children and households.
4	River Access Point	GPS coordinates	9 access points	9 river access points	River data (data set 4) was used with both household data (data set 2) and infection data (data set 1).
5	Community	Notes from focus group discussions	13 focus groups	adults and older teenagers (~1,200)	Data from all focus groups was assessed at the community level.