****************************************************************************************************************************************************

In this document you will find a description of the materials uploaded and the information required to reproduce econometric model results. We uploaded a read-me file plus the dataset in comma separated value(xls) format.

****************************************************************************************************************************************************
Data collection title: Choice experiment for repairing rural waterpoints (1,185 households, Kwale County Kenya, 2013-2014)

Data collection abstract and methodology:

This record contains water service preference data collected from 1,185 households in Kwale county on the south coast of Kenya. A sample of 531 handpump locations was used as a sampling frame for a household survey administered in late 2013 and early 2014 (see UKDS Reshare record: http://reshare.ukdataservice.ac.uk/853667/). 3,500 households took part in this survey of which a random draw of 1,185 households were selected to take part in a choice experiment on water service preferences. Choices included (1) reliability in days to repair pump (2, 4, 6, 8)(2) drinking water quality (potable, non-potable), (3) distance to handpump(current distance, half of current distance),(4) monthly household payment (USD 0.5, 1.0, 1.5, 2.0). An orthogonal, main effects design generated 10 choice cards, each with two alternatives and a status quo option eliciting 10 choice responses. Participating households could also select a status quo option. The data is presented as prepared for a conditional logit model estimating the main attributes followed by interactions across three hypotheses of behavioural change: (a) multidimensional wealth, (b)gender of respondent, (c), and  household concerns. The read-me file describes steps required for estimation of the econometric latent class model specified by a discrete distribution of preferences to estimate heterogeneity.

Ethical procedures 

Prior to data collection, research permits and approvals were obtained from the Government of Kenya’s National Council of Science and Technology and Oxford University’s Central University Research Ethics Committee. Disclosure assessment was conducted as part of the ethical procedures by Oxford University. In terms of ethical considerations, participation in the data collections campaigns was voluntary. Information about the study and its objectives was provided in all cases. Consent was obtained verbally (data collection campaigns were conducted in areas of low literacy in 
Kwale County). Consent discussion contained information about 1) the right to decline participation or withdraw participation at any point in time, 2) confidentiality procedures, 3) purposes of the research study structure, and 4) contact details for follow-up information.

*****************************************************************************************************************************************************

Here we list the STEPS required to carry out the estimation of the econometric model. 

*****************************************************************************************************************************************************

*******************************************************
*********STEPS to carry out estimation*****************
*******************************************************

To estimate the model reported in Table 2 of this paper
you need to open the dataset labelled Data.xls in 
NLOGIT version 5. 

Once you have imported the data, please run the code 
described in STEP 2 below.

*******************************************************
********************STEP 1*****************************
*******************************************************

Import the dataset Data.xls to NLOGIT.

This includes 1,185 households with 10 choice cards per household, 
comprising three choice options per card, leading to a total of 35,550 rows. 

Variables are labelled as follows:

*days_2: 	a value of 1 denotes preference for household´s handpump repair in 2 days, 0 otherwise.
*days_4: 	a value of 1 denotes preference for household´s handpump repair in 4 days, 0 otherwise.
*days_6: 	a value of 1 denotes preference for household´s handpump repair in 6 days, 0 otherwise.
*days_8: 	a value of 1 denotes preference for household´s handpump repair in 8 days, 0 otherwise.

*water_p: a value of 1 denotes preference for potable water, 0 otherwise.
*distance2:  denotes the households’s distance to the closest handpump (in meters).

*PAY_50: 	a value of 1 denotes preference for payment equal to 50 Kenyan Shillings, 0 otherwise.
*PAY_100: a value of 1 denotes preference for payment equal to 100 Kenyan Shillings, 0 otherwise.
*PAY_150: a value of 1 denotes preference for payment equal to 150 Kenyan Shillings, 0 otherwise.
*PAY_200: a value of 1 denotes preference for payment equal to 200 Kenyan Shillings, 0 otherwise.

*bttdd: 	denotes the interaction effect between being in the bottom 40% of the wealth distribution with having a repair of less than 4 days.

*bttpp: 	denotes the interaction effect between being in the bottom 40% of the wealth distribution with paying less than 100 Kenyan Shillings.

*lgenpm: denotes the interaction effect between being a female with paying less than 100 Kenyan Shillings.
*lgenda: denotes the interaction effect between being a female with having a repair of less than 4 days.

*seaspy: denotes the interaction effect between concern for seasonality and paying less than 100 Kenyan Shillings.
*seasday: denotes the interaction effect between concern for seasonality and having a repair of less than 4 days.

*relpay: denotes the interaction effect between concern for reliability and paying less than 100 Kenyan Shillings.
*relday: denotes the interaction effect between concern for reliability and having a repair of less than 4 days.

*safepay: denotes the interaction effect between concern for safety and paying less than 100 Kenyan Shillings.
*safeday: denotes the interaction effect between concern for safety and having a repair of less than 4 days.
*wsafet2: denotes the interaction effect between concern for safety and distance.

*costpay: denotes the interaction effect between concern for cost and paying less than 100 Kenyan Shillings.
*costday: denotes the interaction effect between concern for cost and having a repair of less than 4 days.
*wcostt2: denotes the interaction effect between concern for cost and distance.

*******************************************************
********************STEP 2*****************************
*******************************************************

*Run the code below using NLOGIT version 5.

LCLOGIT  ; Lhs = 	CHOICE
    	    ; Choices = 1,2,3 ;
    	    ; Rhs = 	days_2, days_4, days_6, days_8,  PAY_50, PAY_100, PAY_150, PAY_200, WATER_P, DISTANCE, BTTPP, BTTDD,
    		lgenpm, lgenday, wcostt2, wsafet2, SEASPAY, 			SEASDAY, 	SAFEPAY, SAFEDAY,
   		COSTPAY,COSTDAY, RELPAY, RELDAY;
 	 ;LCM=one;
    		;pts=3;
    		;pds=10;
   		;parameters;
    		;halton$

*******************************************************
********************END********************************
*******************************************************