Project Name: Attaining Sustainable Services from Ecosystems through Trade-off Scenarios (ASSETS) Funded by: Ecosystem Services for Poverty Alleviation (ESPA) programme. The ESPA programme was funded by the Department for International Development (DFID), the Economic and Social Research Council (ESRC) and the Natural Environment Research Council (NERC). Project No. NE/J002267/1 Country: Colombia This archive consists of (a) a primary dataset and (b) accompanying documents. The folder structure of the uploaded files is as follows: |-- 855395_ReadMe.txt |-- 855395_data |-- Wave1 |-- 01-COL_W1_A_InterviewDetails.csv |-- 02-COL_W1_B_HHRoster.csv |-- 03-COL_W1_C_HH_Education.csv |-- 04-COL_W1_D_HH_Health.csv |-- 05-COL_W1_E_HH_Maternity.csv |-- 06-COL_W1_F_HH_TimeUse.csv |-- 07-COL_W1_G_HH_Labour.csv |-- 08-COL_W1_H_HH_Housing.csv |-- 09-COL_W1_I_HH_Food.csv |-- 10-COL_W1_I_HH_FoodRoster.csv |-- 11-COL_W1_I_HH_StreetFoodRoster.csv |-- 12-COL_W1_J_HH_FoodSecurity.csv |-- 13-COL_W1_J_HH_FoodSec_CopingStrategies.csv |-- 14-COL_W1_K_HH_NonFoodExp_1Week.csv |-- 15-COL_W1_K_HH_NonFoodExp_1Month.csv |-- 16-COL_W1_K_HH_NonFoodExp_3Months.csv |-- 17-COL_W1_K_HH_NonFoodExp_6Months.csv |-- 18-COL_W1_L_HH_DurableGoods.csv |-- 19-COL_W1_M_HH_Business.csv |-- 20-COL_W1_M_HH_BusinessRoster.csv |-- 21-COL_W1_O_HH_OtherIncomeRoster.csv |-- 22-COL_W1_P_HH_TransfersRoster.csv |-- 23-COL_W1_Q_HH_Loans.csv |-- 24-COL_W1_Q_HH_LoansRoster.csv |-- 25-COL_W1_R_HH_WellBeing.csv |-- 26-COL_W1_R_HH_WellBeing_ShockRoster.csv |-- 27-COL_W1_S_HH_AnthropometricsRoster.csv |-- 28-COL_W1_T_HH_Migration.csv |-- 29-COL_W1_T_HH_MigratRoster.csv |-- 30-COL_W1_U_HH_Deaths.csv |-- 31-COL_W1_U_HH_DeathsRoster.csv |-- 32-COL_W1_AGa_HH_AgriPlots.csv |-- 33-COL_W1_AGa_HH_AgriPlotsRoster.csv |-- 34-COL_W1_AGb_HH_AgriInputs.csv |-- 35-COL_W1_AGb_HH_AgriInputsRoster.csv |-- 36-COL_W1_AGc_HH_AgriSeeds.csv |-- 37-COL_W1_AGc_HH_AgriSeedsRoster.csv |-- 38-COL_W1_AGd_HH_AgriHarvest.csv |-- 39-COL_W1_AGd_HH_AgriHarvestRoster.csv |-- 40-COL_W1_AGe_HH_Livestock.csv |-- 41-COL_W1_AGe_HH_LivestockRoster.csv |-- 42-COL_W1_AGf_HH_LivestockProductsRoster.csv |-- 43-COL_W1_AGg_HH_FarmStructures.csv |-- 44-COL_W1_AGg_HH_FarmStructuresRoster.csv |-- 45-COL_W1_AGh_HH_Fishing.csv |-- 46-COL_W1_AGh_HH_FishingRoster.csv |-- 47-COL_W1_AGi_HH_Hunting.csv |-- 48-COL_W1_AGi_HH_Hunting_GameRoster.csv |-- 49-COL_W1_AGj_HH_ToolsEquipmentRoster.csv |-- Wave2 |-- 01-COL_W2_A_InterviewDetails.csv |-- 02-COL_W2_B_HHRoster.csv |-- 03-COL_W2_C_HH_Education.csv |-- 04-COL_W2_D_HH_Health.csv |-- 05-COL_W2_E_HH_Maternity.csv |-- 06-COL_W2_F_HH_TimeUse.csv |-- 07-COL_W2_G_HH_Labour.csv |-- 08-COL_W2_H_HH_Housing.csv |-- 09-COL_W2_I_HH_Food.csv |-- 10-COL_W2_I_HH_FoodRoster.csv |-- 11-COL_W2_I_HH_StreetFoodRoster.csv |-- 12-COL_W2_J_HH_FoodSecurity.csv |-- 13-COL_W2_J_HH_FoodSec_CopingStrategies.csv |-- 14-COL_W2_K_HH_NonFoodExp_1Week.csv |-- 15-COL_W2_K_HH_NonFoodExp_1Month.csv |-- 16-COL_W2_K_HH_NonFoodExp_3Months.csv |-- 17-COL_W2_K_HH_NonFoodExp_6Months.csv |-- 18-COL_W2_L_HH_DurableGoods.csv |-- 19-COL_W2_M_HH_Business.csv |-- 20-COL_W2_M_HH_BusinessRoster.csv |-- 21-COL_W2_O_HH_OtherIncomeRoster.csv |-- 22-COL_W2_P_HH_TransfersRoster.csv |-- 23-COL_W2_Q_HH_Loans.csv |-- 24-COL_W2_Q_HH_LoansRoster.csv |-- 25-COL_W2_R_HH_WellBeing.csv |-- 26-COL_W2_R_HH_WellBeing_ShockRoster.csv |-- 27-COL_W2_S_HH_AnthropometricsRoster.csv |-- 28-COL_W2_T_U_HH_Migration_Deaths.csv |-- 29-COL_W2_W_HH_FreeTimeUse.csv |-- 30-COL_W2_X_HH_SocialCapital.csv |-- 31-COL_W2_Y_HH_Associational_Activity.csv |-- 32-COL-W2_Z_HH_SocialResources.csv |-- 33-COL_W2_AGa_HH_AgriPlots.csv |-- 34-COL_W2_AGa_HH_AgriPlotsRoster.csv |-- 35-COL_W2_AGb_HH_AgriInputs.csv |-- 36-COL_W2_AGb_HH_AgriInputsRoster.csv |-- 37-COL_W2_AGc_HH_AgriSeeds.csv |-- 38-COL_W2_AGc_HH_AgriSeedsRoster.csv |-- 39-COL_W2_AGd_HH_AgriHarvest.csv |-- 40-COL_W2_AGd_HH_AgriHarvestRoster.csv |-- 41-COL_W2_AGe_HH_Livestock.csv |-- 42-COL_W2_AGe_HH_LivestockRoster.csv |-- 43-COL_W2_AGf_HH_LivestockProductsRoster.csv |-- 44-COL_W2_AGg_HH_FarmStructures.csv |-- 45-COL_W2_AGg_HH_FarmStructuresRoster.csv |-- 46-COL_W2_AGh_HH_Fishing.csv |-- 47-COL_W2_AGh_HH_FishingRoster.csv |-- 48-COL_W2_AGi_HH_Hunting.csv |-- 49-COL_W2_AGi_HH_Hunting_GameRoster.csv |-- 50-COL_W2_AGj_HH_ToolsEquipmentRoster.csv |-- 855395_documentation |-- ASSETS_hh-survey_infosheet.docx |-- ASSETS_hh-survey_consent-form_SPANISH.doc |-- ASSETS_Schreckenberg_2016_PRA-Manual.pdf |-- ASSETS_topiclist.docx |-- ASSETS_website_materials.pdf |-- COL_datalist.xlsx |-- COL_methods_summary.docx |-- COL_synthesis-report.docx |-- COL_W1_Code_Book.docx |-- COL_W1_LaPedrera_Enumerators_Manual_SPANISH.docx |-- COL_W1_LaPedrera_Survey_Format_SPANISH.docx |-- COL_W2_Code_Book.docx |-- COL_W2_LaPedrera_Enumerators_Manual_SPANISH.docx |-- COL_W2_LaPedrera_Survey_Format_SPANISH.docx ### (a) Primary data (within '855395_data' folder) - Primary data from the household surveys (anonymised) is stored in 99 data sheets in comma-separated values (.csv) format. Names of the sheets and data contained within are as follows: + *01-COL_W1_A_InterviewDetails* : Information detailing the interview context: dwelling location, replacements, date of interview and comments on interview / case. + *02-COL_W1_B_HHRoster* : Data on socio-demographic household details. + *03-COL_W1_C_HH_Education* : Data on literacy, educational background and related expenditure for all HH members of 5 or more years of age. + *04-COL_W1_D_HH_Health* : Data on recent illnesses, forms of treatment (including use of medicinal plants), chronic illnesses and impediments and related expenditure. + *05-COL_W1_E_HH_Maternity* : Information on past and current pregnancies, access to antenatal care and child survival. + *06-COL_W1_F_HH_TimeUse* : Data on time spent on paid or unpaid activities. + *07-COL_W1_G_HH_Labour* : Data on paid or unpaid employment within the last 6 months. + *08-COL_W1_H_HH_Housing* : Data on housing situation, including rent, building materials, lighting and cooking fuel sources, availability of WASH services. + *09-COL_W1_I_HH_Food* : Data on frequency of consumption for main food groups, presence of guests during family meals, and consumption of meals outside the home. + *10-COL_W1_I_HH_FoodRoster* : Details about consumption of individual food items over a 7-day period in the household, detailing the amount consumed and main food sources. + *11-COL_W1_I_HH_StreetFoodRoster* : Information on meals consumed outside home, including amount spent and location. + *12-COL_W1_J_HH_FoodSecurity* : Information on food insecurity problems at the household level, including timing and causes. + *13-COL_W1_J_HH_FoodSec_CopingStrategies* : Details on adoption of coping strategies against food insecurity and their frequency. + *14-COL_W1_K_HH_NonFoodExp_1Week* : Details non-food expenditure on basic items: 7-day recall. + *15-COL_W1_K_HH_NonFoodExp_1Month* : Data on non-food expenditure on basic items: One-month recall. + *16-COL_W1_K_HH_NonFoodExp_3Months* : Data on non-food expenditure on basic items: Three-month recall. + *17-COL_W1_K_HH_NonFoodExp_6Months* : Data on non-food expenditure on basic items: 6-month recall. + *18-COL_W1_L_HH_DurableGoods* : Data on ownership of basic household items and related expenditure for past 6 months. + *19-COL_W1_M_HH_Business* : Information on the presence of a non-agricultural business. + *20-COL_W1_M_HH_BusinessRoster* : Data on non-agricultural businesses, such business start date, activity from May 2013-February 2014, type of products sold, sales. + *21-COL_W1_O_HH_OtherIncomeRoster* : Data on other income, such as cash or food transfers / gifts from friends or relatives or from government programmes, investment income, rental income, or asset sales. + *22-COL_W1_P_HH_TransfersRoster* : Data on transfers the HH made in favour of relatives or friends living elsewhere. + *23-COL_W1_Q_HH_Loans* : Information on requests and access to loans, including reasons for rejections. + *24-COL_W1_Q_HH_LoansRoster* : Information on each loan reported by informants, including amounts (to be) paid and reasons for borrowing money. + *25-COL_W1_R_HH_WellBeing* : Information on households’ perception of wellbeing and life satisfaction. + *26-COL_W1_R_HH_WellBeing_ShockRoster* : Information on households’ experiences of emergencies and responses. + *27-COL_W1_S_HH_AnthropometricsRoster* : Contains details of anthropometric measures for children under 5 years of age: weight, height (length), and middle-upper arm circumference (MUAC). + *28-COL_W1_T_HH_Migration* : Information on whether or not a HH reports cases of permanent migration in the previous 12 months. + *29-COL_W1_T_HH_MigratRoster* : Information on family members who left the household permanently. + *30-COL_W1_U_HH_Deaths* : Information on whether or not a HH reports any deaths in the previous 12 months. + *31-COL_W1_U_HH_DeathsRoster* : Information on reported deaths within the previous 12 months, including age at death and cause of death. + *32-COL_W1_AGa_HH_AgriPlots* : Information on whether or not a HH reports owning or having cultivated a plot of land in the past 6 months. + *33-COL_W1_AGa_HH_AgriPlotsRoster* : Information on plots of land owened or cultivated by the household, including size, type, location, irrigation source, crops, time spent on cultivation, and profits. + *34-COL_W1_AGb_HH_AgriInputs* : Information on whether or not a HH reports having cultivated a plot of land in the past 6 months. + *35-COL_W1_AGb_HH_AgriInputsRoster* : Information on the type, amount and cost of fertilisers, plaguicides or herbisides used in the past 6 months. + *36-COL_W1_AGc_HH_AgriSeeds* : Information on whether or not a HH reports having planted crops or trees in the past 6 months. + *37-COL_W1_AGc_HH_AgriSeedsRoster* : Information on all seeds and plantlets used in the past 6 months, including amounts, monetary expenses and sources. + *38-COL_W1_AGd_HH_AgriHarvest* : Information on whether or not a HH reports having harvested crops or trees in the past 6 months. + *39-COL_W1_AGd_HH_AgriHarvestRoster* : Details the amount of harvest obtained from crops and trees during a 6-month period prior to interview and their use, including sales. + *40-COL_W1_AGe_HH_Livestock* : Information on whether or not a HH reports owning or having raised livestock in the past 6 months. + *41-COL_W1_AGe_HH_LivestockRoster* : Details numbers of animals owned, reared, sold, and given away in the 6 months prior to interview as well as sale volumes. + *42-COL_W1_AGf_HH_LivestockProductsRoster* : Information on livestock products produced by the HH in the last 6 months prior to the interview, including total production quantity, self consumption, and sales. + *43-COL_W1_AGg_HH_FarmStructures* : Information on whether or not a HH reports owned or rented any farm structures in the past 6 months. + *44-COL_W1_AGg_HH_FarmStructuresRoster* : Reports on all farm structures owned, rented or built by the household in the 6 months prior to interview. It includes expenditure items and use of natural resources as construction materials. + *45-COL_W1_AGh_HH_Fishing* : Information on whether or not a HH have conducted any fishing activities in the past 6 months and total expenditure for this activity. + *46-COL_W1_AGh_HH_FishingRoster* : Reports on up to five species of fish most commonly fished in a 6-month period prior to interview, including total catchment, uses and sale volumes. + *47-COL_W1_AGi_HH_Hunting* : Information on whether or not a HH have conducted any hunting activities in the past 6 months and total expenditure for this activity. + *48-COL_W1_AGi_HH_Hunting_GameRoster* : Reports on up to five species of animals most commonly hunting in a 6-month period prior to interview, including total hunt and uses and bush-meat sales. + *49-COL_W1_AGj_HH_ToolsEquipmentRoster* : Reports on all tools and equipment owned or rented by the household in the past 6 months, including relevant expenditure. + *01-COL_W2_A_InterviewDetails* : Information on the interview context: dwelling location, replacements, date of interview and comments on interview / case. + *02-COL_W2_B_HHRoster* : Data on socio-demographic household details. + *03-COL_W2_C_HH_Education* : Data on literacy, educational background and related expenditure for all HH members of 5 or more years of age. + *04-COL_W2_D_HH_Health* : Data on recent illnesses, forms of treatment (including use of medicinal plants), chronic illnesses and impediments and related expenditure. + *05-COL_W2_E_HH_Maternity* : Information on marital statuso of HH members, past and current pregnancies, contraception methods, access to antenatal care and child survival. + *06-COL_W2_F_HH_TimeUse* : Data on time spent on paid or unpaid activities. + *07-COL_W2_G_HH_Labour* : Data on paid or unpaid employment within the last 6 months. + *08-COL_W2_H_HH_Housing* : Data on housing situation, including uilding materials, lighting and cooking fuel sources, availability of WASH services. + *09-COL_W2_I_HH_Food* : Data on frequency of consumption for main food groups, presence of guests during family meals, and consumption of meals outside the home. + *10-COL_W2_I_HH_FoodRoster* : Details about consumption of individual food items over a 7-day period in the household, detailing the amount consumed and main food sources. + *11-COL_W2_I_HH_StreetFoodRoster* : Information on meals consumed outside home, including amount spent and location. + *12-COL_W2_J_HH_FoodSecurity* : Information on food insecurity problems at the household level, including timing and causes. + *13-COL_W2_J_HH_FoodSec_CopingStrategies* : Details on adoption of coping strategies against food insecurity and their frequency. + *14-COL_W2_K_HH_NonFoodExp_1Week* : Details non-food expenditure on basic items: 7-day recall. + *15-COL_W2_K_HH_NonFoodExp_1Month* : Data on non-food expenditure on basic items: One-month recall. + *16-COL_W2_K_HH_NonFoodExp_3Months* : Data on non-food expenditure on basic items: Three-month recall. + *17-COL_W2_K_HH_NonFoodExp_6Months* : Data on non-food expenditure on basic items: 6-month recall. + *18-COL_W2_L_HH_DurableGoods* : Data on ownership of basic household items and related expenditure for past 6 months. + *19-COL_W2_M_HH_Business* : Information on the presence of a non-agricultural business. + *20-COL_W2_M_HH_BusinessRoster* : Data on non-agricultural businesses, such business start date, activity from January 2015-October 2014, type of products sold, sales. + *21-COL_W2_O_HH_OtherIncomeRoster* : Data on other income, such as cash or food transfers / gifts from friends or relatives or from government programmes, investment income, rental income, or asset sales. + *22-COL_W2_P_HH_TransfersRoster* : Data on transfers the HH made in favour of relatives or friends living elsewhere. + *23-COL_W2_Q_HH_Loans* : Information on requests and access to loans, including reasons for rejections. + *24-COL_W2_Q_HH_LoansRoster* : Information on each loan reported by informants, including amounts (to be) paid and reasons for borrowing money. + *25-COL_W2_R_HH_WellBeing* : Information on households’ perception of wellbeing and life satisfaction. + *26-COL_W2_R_HH_WellBeing_ShockRoster* : Information on households’ experiences of emergencies and responses. + *27-COL_W2_S_HH_AnthropometricsRoster* : Contains details of anthropometric measures for children under 5 years of age: weight, height (length), and middle-upper arm circumference (MUAC). + *28-COL_W2_T_U_HH_Migration_Deaths* : Contains details on permanent outmigration from and deaths in the HH since the previous survey round. + *29-COL_W2_W_HH_FreeTimeUse* : Information on free time use by the HH members, including hobbies, crafts and recreation. + *30-COL_W2_X_HH_SocialCapital* : Information on participation in community life, such as attendance of assemblies, participation in community work/services, or collaboration with other HHs. + *31-COL_W2_Y_HH_Associational_Activity* : Information on memberships in social organizations, including roles and contributions. + *32-COL-W2_Z_HH_SocialResources* : Information social resources, such as help with repairs around the house, cleaning, child care, or legal advice. + *33-COL_W2_AGa_HH_AgriPlots* : Information on whether or not a HH reports owning or having cultivated a plot of land in the past 6 months. + *34-COL_W2_AGa_HH_AgriPlotsRoster* : Information on plots of land owened or cultivated by the household, including size, type, location, irrigation source, crops, time spent on cultivation, and profits. + *35-COL_W2_AGb_HH_AgriInputs* : Information on whether or not a HH reports having used fertilisers, plaguicides or herbisides in the past 6 months. + *36-COL_W2_AGb_HH_AgriInputsRoster* : Information on the type, amount and cost of fertilisers, plaguicides or herbisides used in the past 6 months. + *37-COL_W2_AGc_HH_AgriSeeds* : Information on whether or not a HH reports having planted crops or trees in the past 6 months. + *38-COL_W2_AGc_HH_AgriSeedsRoster* : Information on all seeds and plantlets used in the past 6 months, including amounts, monetary expenses and sources. + *39-COL_W2_AGd_HH_AgriHarvest* : Information on whether or not a HH reports having harvested crops or trees in the past 6 months. + *40-COL_W2_AGd_HH_AgriHarvestRoster* : Details the amount of harvest obtained from crops and trees during a 6-month period prior to interview and their use, including sales. + *41-COL_W2_AGe_HH_Livestock* : Information on whether or not a HH reports owning or having raised livestock in the past 6 months. + *42-COL_W2_AGe_HH_LivestockRoster* : Details numbers of animals owned, reared, sold, and given away in the 6 months prior to interview as well as sale volumes. + *43-COL_W2_AGf_HH_LivestockProductsRoster* : Information on livestock products produced by the HH in the last 6 months prior to the interview, including total production quantity, self consumption, and sales. + *44-COL_W2_AGg_HH_FarmStructures* : Information on whether or not a HH reports owned or rented any farm structures in the past 6 months. + *45-COL_W2_AGg_HH_FarmStructuresRoster* : Reports on all farm structures owned, rented or built by the household in the 6 months prior to interview. It includes expenditure items and use of natural resources as construction materials. + *46-COL_W2_AGh_HH_Fishing* : Information on whether or not a HH have conducted any fishing activities in the past 6 months and total expenditure for this activity. + *47-COL_W2_AGh_HH_FishingRoster* : Reports on up to five species of fish most commonly fished in a 6-month period prior to interview, including total catchment, uses and sale volumes. + *48-COL_W2_AGi_HH_Hunting* : Information on whether or not a HH have conducted any hunting activities in the past 6 months and total expenditure for this activity. + *49-COL_W2_AGi_HH_Hunting_GameRoster* : Reports on up to five species of animals most commonly hunting in a 6-month period prior to interview, including total hunt and uses and bush-meat sales. + *50-COL_W2_AGj_HH_ToolsEquipmentRoster* : Reports on all tools and equipment owned or rented by the household in the past 6 months, including relevant expenditure. ### (b) Accompanying documents (within '855395_documentation' folder) - The variable description and coding is provided as a Word Workbook and the rest of the accompanying documents are in PDF format. A brief description of each document (name in parentheses) is provided below: + **Project info sheet** (*ASSETS_hh-survey_infosheet*): A PDF document containing a the project information sheet used for the household survey (2 pages). + **Consent form** (*ASSETS_hh-survey_consent-form_SPANISH*): A Word document containing the original Spanish-language consent form used for the household survey (3 pages). + **Practitioner's Manual for PRA exercises** (*ASSETS_Schreckenberg_2016_PRA-Manual*): A PDF file containing the Practitioner's Manual for the Participatory Rural Appraisal (PRA) exercises, which includes the project information sheet and consent forms used for the PRA exercises (127 pages). + **Household survey topic list** (*ASSETS_topiclist*): A Word document with a list of topics covered in the household survey (1 page). + **Website materials** (*ASSETS_website_materials*): A PDF archive of all website materials (10 pages). + **List of data collected in Colombia** (*COL_datalist*): An Excel document that contains an overview of the data the ASSETS project collected in Colombia (1 sheet). + **Methods descriptions** (*COL_methods_summary*): A PDF document with description of research questions, approach, and data collection methods (9 pages). + **Final synthesis report** (*COL_synthesis report*): A Word document containing the final synthesis report with detailed description of the study sites (460 pages). + **Variable descriptions and coding - Wave 1** (*COL_W1_Code_Book*): A Word document with sections containing variable descriptions and coding for each of the Wave 1 data files described above (209 pages). + **Variable descriptions and coding - Wave 2** (*COL_W2_Code_Book*): A Word document with sections containing variable descriptions and coding for each of the Wave 2 data files described above (220 pages). + **Questionnaire form - Wave 1** (*COL_W1_LaPedrera_Survey_Format_SPANISH*): A Word document containing the original Spanish-language Wave 1 questionnaire used in the household surveys (215 pages). + **Questionnaire form - Wave 2** (*COL_W2_LaPedrera_Survey_Format_SPANISH*): A Word document containing the original Spanish-language Wave 2 questionnaire used in the household surveys (218 pages). + **Enumerators' manual - Wave 1** (*COL_W1_LaPedrera_Enumerators_Manual_SPANISH*): A Word document containing the original Spanish-language manual for enumerators of the survey during Wave 1, including, for example, additional information for each module (55 pages). + **Enumerators' manual - Wave 2** (*COL_W2_LaPedrera_Enumerators_Manual_SPANISH*): A Word document containing the original Spanish-language manual for enumerators of the survey during Wave 2, including, for example, additional information for each module (61 pages).