###Title: Baseline and endline socio-economic data from a Randomised Control Trial of the Watershared scheme (a form of Payment for watershed Services scheme in the Bolivian Andes).
###This document explains the socio-economic data collected as part of a Randomised Control Trial investigating the effectiveness of a Payment for Watershed Services type intervention known as Watershared (Acuerdos Reciprocos por Agua, or Reciprocal Water Agreements is the name in Spanish).
###The baseline data (2010) was collected under a grant from espa (Ecosystem Services for Poverty Alleviation) to Fundacion Natura Bolivia “What types of investment can most cost-effectively ensure ecosystem service provision? A randomized program evaluation” (NE/I00436X/1) 
###The endline data (2015/2016) was collected with funding from two projects: an Ecosystem Services for Poverty Alleviation funded project to Natura “Under what conditions can Payments for Environmental Services deliver sustainable improvements in welfare? Learning from a Randomized Control Trial” (NE/L001470/1) and a Leverhulme Trust funded research project to Bangor University “Can payment for ecosystem services deliver environmental and livelihood benefits” (RPG-2014-056). The latter project funded the cleaning and archiving of the dataset.
###The data consists of a) primary data and b) accompanying documentation. There is an additional file which is not archived as it contains individually identifying information. The file name is CONFIDENTIAL_ID_NAMES and a copy is held with Fundacion Natura Bolivia and Bangor University.
|--ReadMe.txt
|-- data
	|-- HOUSEHOLD.xlsx
    	|-- CHILD_DIARRHEA.xlsx
    	|-- CONSERVATION_CONTRACT.xlsx
 
|-- docs
    	|-- METADATA_HOUSEHOLD.xlsx
    	|-- METADATA_CHILD_DIARRHEA.xlsx
    	|-- METADATA_CONSERVATION_CONTRACT.xlsx
    	|-- CONSENT_ES.pdf
    	|-- SURVEY_EN.xlsx
    	|-- SURVEY_ES_ODK.xlsx


#### (a) Primary data (within 'data' folder)
- Primary data is arranged in three datasheets
    + *HOUSEHOLD.xlsx*: This contains all the information which was collected at the household level. Some variables were not collected in the endline; they were dropped following piloting as we found that they did not appear to work well in the field and respondents struggled to give reliable answers. These are not included in this datasheet. Some variables were added in the endline. Some data were processed to generate derived variables. The sheet therefore contains all variables which were collected in both the baseline and the endline, additional variables which were added in the endline and some additional calculated variables. 2623 households were surveyed in the baseline and there are entering here for all these households. In the endline we attempted to reach all 2623 households but some had moved away, been disbanded due to the death of the household head, or could not be refound despite up to 5 attempts (872 could not be re-found). The endline survey therefore includes only 1751 households.
    + *CHILD_DIARRHEA.xlsx* : This is a sub-table of the HOUSEHOLD table which provides information on each incidents of diarrhea in the last 12 months for each child under 16 years old belonging to each household. The identical data was collected in the baseline and endline. The children are linked to a specific household via the unique identifier ID_HOGAR.
    + *CONSERVATION_CONTRACT.xlsx* : This sheet provides information (from the endline only) on the management of a selected number of conservation contracts per household. It is structured according to the conservation agreements (each entry corresponds to one agreement). Each household in the HOUSEHOLD sheet (linked here through the unique identifier ID_HOGAR can have several contracts). This information was collected on a maximum of three contracts per household (if a household had more than three contracts, their level 1 contracts were prioritised). A total of 913 contracts were reported (representing 509 families)

-- Detailed distribution of survey data (baseline and follow-up)
-----------------------------------Baseline    Follow-up    Follow-up coverage in %

Control                              1137         681           60%
Treatment with contract               592         500           84%
Treatment without contract            894         513           57%
Total                                2623        1694           64%

Additionally, some households that did not exist in the baseline were surveyed in the follow-up (a total 57). These households are not included in the above stats. Among these households (19 are control; 28 are treatment with a contract and 10 are treatment without contract). The households are market with the code "FU" in the variable A_FU_BL_FB signifying "only follow-up". The main reason we created these entry was that some households had several contracts that were split into the children's families. The other case were surveyed at the beginning of the datacollection process to 'compensate' lost of baseline data but we decided to stop this after a few days of data collection. 


#### (b) Accompanying documents (within 'docs' folder)
- Brief description of each document (name in parentheses) is provided below:
	+ **METADATA_HOUSEHOLD.xlsx**: Metadata explaining each variable in the HOUSEHOLD datasheet.
    	+ **METADATA_CHILD_DIARRHEA.xlsx**: Metadata explaining each variable in the CHILD_DIARRHEA datasheet.
       	+ **METADATA_CONSERVATION_CONTRACT.xlsx**: Metadata explaining each variable in the CONSERVATION_CONTRACTS datasheet.
       	+ **CONSENT_ES.pdf**: The initial consent form used in the baseline. In the survey oral consent was gained before each survey began (all enumerators were trained to ensure they understood the importance of informed consent).
       	+ **SURVEY_EN.xlsx**: The endline survey (in English) showing the coding for each variable. NB Only those variables included in both baseline and endline survey are included in this archived dataset. 
       	+ **SURVEY_ES_ODK.xlsx**: The survey was conducted in Spanish with enumerators using ODK (Open Data Kit) on android devices to enter the data. The initial Spanish language ODK code is provided here.


###The data was organised and prepared for archiving by David Crespo (independent) and Patrick Bottazzi (Bangor University) working with Julia P G Jones, Edwin Pynegar and Emma Wiik (Bangor University).
###The data collection was managed by Fundacion Natura Bolivia (with input for the endline from Bangor University). The process was managed by Tito Vidaurre, Máximo García, Rafael Miler Guzmán Lucindo Gonzuales, Hugo Vallejos, Basilio Pérez Guzman, Fidel Avila Becerra, Dionicio Toledo, Julio Cesar García, Benigno Mojica Garía, Johnny Severiche, Edgar Talavera and Miguel Velásquez under supervision of Nigel Asquith, Tito Vidaurre and María Teresa Vargas Rios.