Nepal Earthquake Survey Codebook

Nepal Household Reconstruction Program Survey Codebook

Main Project Website

Individual Level Data

Individual Demographics

VariableDescriptionType
individual_idA unique ID that identifies every individual from the surveyText
district_idDistrict of residence of the individualText
vdcmun_idMunicipality of residence of the individualText
ward_idWard NumberText
gender_individualGender of the individualCategorical
age_individualAge of the individualNumber
presence_in_householdA categorical variable that captures information about the individual’s presence in the householdCategorical
disability_individualA categorical variable that captures information about an individual’s disability status (if any)Categorical
has_registered_birthFlag variable that indicates if individual’s birth registration has been doneBoolean
education_level_individualA categorical variable that captures the highest level of education that the individual has attainedCategorical
marital_status_individualA categorical variable that captures the marital status of the individualCategorical
idA unique ID that identifies a unique information from all tableNumber

Individual Social Security

VariableDescriptionType
indiviual_idA unique ID that identifies every individual from the surveyText
district_idDistrict of residence of the individualText
vdcmun_idMunicipality of residence of the individualText
ward_idWard NumberText
has_social_security_elder_citizenFlag variable that indicates if the individual is recieving social security provided for elder citizensBoolean
has_social_security_child_securityFlag variable that indicates if the individual is recieving social security benefits provided for childrenBoolean
has_social_security_extinct_casteFlag variable that indicates if the individual is recieving social security benefits provided for extinct castesBoolean
has_social_security_single_womanFlag variable that indicates if the individual is recieving social security benefits provided for single womenBoolean
has_social_security_handicapFlag variable that indicates if the individual is recieving social security benefits provided for handicapped individualsBoolean
has_social_security_pensionFlag variable that indicates if the individual is recieving social security benefits in the form of pensionBoolean
has_social_security_otherFlag variable that indicates if the individual is recieving any other form of social securityBoolean
has_social_security_not_applicableFlag variable that indicates if a person is not applicable for social securityBoolean
has_social_security_noneFlag variable that indicates if a person is not recieving any form of social securityBoolean
idA unique ID that identifies a unique information from all tableNumber

Buildings

Building Structural Data

VariableDescriptionType
building_id A unique ID that identifies a unique building from the surveyText
district_id District where the building is locatedText
vdcmun_id Municipality where the building is locatedText
ward_id Ward Number in which the building is locatedText
count_floors_pre_eq Number of floors that the building had before the earthquakeNumber
count_floors_post_eq Number of floors that the building had after the earthquakeNumber
age_building Age of the building (in years)Number
plinth_area_sq_ft Plinth area of the building (in square feet)Number
height_ft_pre_eq Height of the building before the earthquake (in feet)Number
height_ft_post_eq Height of the building after the earthquake (in feet)Number
land_surface_condition Surface condition of the land in which the building is builtcategorical
foundation_type Type of foundation used in the buildingCategorical
roof_type Type of roof used in the buildingCategorical
ground_floor_type Ground floor typeCategorical
other_floor_type Type of construction used in other floors (except ground floor and roof)Categorical
position Position of the buildingCategorical
plan_configuration Building plan configurationCategorical
has_superstructure_adobe_mud Flag variable that indicates if the superstructure of the building is made of Adobe/MudBoolean
has_superstructure_mud_mortar_stone Flag variable that indicates if the superstructure of the building is made of Mud Mortar - StoneBoolean
has_superstructure_stone_flag Flag variable that indicates if the superstructure of the building is made of StoneBoolean
has_superstructure_cement_mortar_stone Flag variable that indicates if the superstructure of the building is made of StoneBoolean
has_superstructure_mud_mortar_brick Flag variable that indicates if the superstructure of the building is made of Cement Mortar - StoneBoolean
has_superstructure_cement_mortar_brick Flag variable that indicates if the superstructure of the building is made of Mud Mortar - BrickBoolean
has_superstructure_timber Flag variable that indicates if the superstructure of the building is made of TimberBoolean
has_superstructure_bamboo Flag variable that indicates if the superstructure of the building is made of BambooBoolean
has_superstructure_rc_non_engineered Flag variable that indicates if the superstructure of the building is made of RC (Non Engineered)Boolean
has_superstructure_rc_engineered Flag variable that indicates if the superstructure of the building is made of RC (Engineered)Boolean
has_superstructure_other Flag variable that indicates if the superstructure of the building is made of any other materialBoolean
condition_post_eq Actual contition of the building after the earthquakeCategorical
damage_grade Damage grade assigned to the building by the surveyor after assessmentCategorical
technical_solution_proposed Technical solution proposed by the surveyor after assessmentCategorical
id A unique ID that identifies a unique information from all tableNumber

Building Ownership and Use

VariableDescriptionType
building_idA unique ID that identifies every individual buildingText
district_idDistrict where the building is locatedText
vdcmun_idMunicipality where the building is locatedText
ward_idWard Number in which the building is locatedText
legal_ownership_statusLegal ownership status of the land in which the building was builtCategorical
count_familiesNumber of families in the buildingNumber
has_secondary_useFlag variable that indicates if the building is used for any secondary purposeBoolean
has_secondary_use_agricultureFlag variable that indicates if the building is secondarily used for agricultural purposeBoolean
has_secondary_use_hotelFlag variable that indicates if the building is secondarily used as hotelBoolean
has_secondary_use_rentalFlag variable that indicates if the building is secondarily used for rental purposeBoolean
has_secondary_use_institutionFlag variable that indicates if the building is secondarily used for institutional purposeBoolean
has_secondary_use_schoolFlag variable that indicates if the building is secondarily used as schoolBoolean
has_secondary_use_industryFlag variable that indicates if the building is secondarily used for industrial purposeBoolean
has_secondary_use_health_postFlag variable that indicates if the building is secondarily used as health postBoolean
has_secondary_use_gov_officeFlag variable that indicates if the building is secondarily used as government officeBoolean
has_secondary_use_use_policeFlag variable that indicates if the building is secondarily used as police stationBoolean
has_secondary_use_otherFlag variable that indicates if the building is secondarily used for other purposeBoolean
idA unique ID that identifies a unique information from all tableNumber

Households

Household Demographics

VariableDescriptionType
household_idA unique ID that identifies every individual householdText
district_idDistrict of residence of the householdText
vdcmun_idMunicipality of residence of the householdText
ward_idWard Number of residence of the householdText
gender_household_headGender of household headCategorical
age_household_headAge of household headNumber
caste_householdCaste/Ethnicity of householdCategorical
education_level_household_headEducation level of household headCategorical
income_level_householdHousehold’s average monthly incomeCategorical
size_householdSize of householdNumber
is_bank_account_present_in_householdFlag variable that indicates if the household has bank accountBoolean
idA unique ID that identifies a unique information from all tableNumber

Household Resources

VariableDescriptionType
household_idA unique ID that identifies every individual householdText
district_idDistrict of residence of the householdText
vdcmun_idMunicipality of residence of the householdText
ward_idWard Number of residence of the householdText
source_water_pre_eqHousehold’s source of water before the earthquakeCategorical
source_water_post_eqHousehold’s source of water after the earthquakeCategorical
source_cooking_fuel_pre_eqType of cooking fuel used by the household before the earthquakeCategorical
source_cooking_fuel_post_eqType of cooking fuel used by the household after the earthquakeCategorical
source_light_pre_eqSource of light used by the household before the earthquakeCategorical
source_light_post_eqSource of light used by the household after the earthquakeCategorical
type_toilet_pre_eqType of toilet used by the household before the earthquakeCategorical
type_toilet_post_eqType of toilet used by the household after the earthquakeCategorical
has_asset_land_pre_eqFlag variable that indicates if the household had land before earthquakeBoolean
has_asset_tv_pre_eqFlag variable that indicates if the household had TV before earthquakeBoolean
has_asset_cable_pre_eqFlag variable that indicates if the household had cable before earthquakeBoolean
has_asset_computer_pre_eqFlag variable that indicates if the household had computer before earthquakeBoolean
has_asset_internet_pre_eqFlag variable that indicates if the household had internet before earthquakeBoolean
has_asset_telephone_pre_eqFlag variable that indicates if the household had telephone before earthquakeBoolean
has_asset_mobile_phone_pre_eqFlag variable that indicates if the household had mobile phone before earthquakeBoolean
has_asset_fridge_pre_eqFlag variable that indicates if the household had fridge before earthquakeBoolean
has_asset_motorcycle_pre_eqFlag variable that indicates if the household had motorcycle before earthquakeBoolean
has_asset_four_wheeler_family_use_pre_eqFlag variable that indicates if the household had four wheeler for family use before earthquakeBoolean
has_asset_four_wheeler_commercial_use_pre_eqFlag variable that indicates if the household had four wheeler for commercial use before earthquakeBoolean
has_asset_none_pre_eqFlag variable that indicates if the household had none of the assets mentioned above before earthquakeBoolean
has_asset_land_post_eqFlag variable that indicates if the household has land after earthquakeBoolean
has_asset_tv_post_eqFlag variable that indicates if the household has TV after earthquakeBoolean
has_asset_cable_post_eqFlag variable that indicates if the household has cable after earthquakeBoolean
has_asset_computer_post_eqFlag variable that indicates if the household has computer after earthquakeBoolean
has_asset_internet_post_eqFlag variable that indicates if the household has internet after earthquakeBoolean
has_asset_telephone_post_eqFlag variable that indicates if the household has telephone after earthquakeBoolean
has_asset_mobile_phone_post_eqFlag variable that indicates if the household has mobile phone after earthquakeBoolean
has_asset_fridge_post_eqFlag variable that indicates if the household has fridge after earthquakeBoolean
has_asset_motorcycle_post_eqFlag variable that indicates if the household has motorcycle after earthquakeBoolean
has_asset_four_wheeler_family_use_post_eqFlag variable that indicates if the household has four wheeler family use after earthquakeBoolean
has_asset_four_wheeler_commercial_post_eqFlag variable that indicates if the household has four wheeler for commercial use after earthquakeBoolean
has_asset_none_post_eqFlag variable that indicates if the household has no assets after earthquakeBoolean
idA unique ID that identifies a unique information from all tableNumber

Household Earthquake Impact

VariableDescriptionType
household_idA unique ID that identifies every individual householdText
district_idDistrict of residence of the householdText
vdcmun_idMunicipality of residence of the householdText
ward_idWard Number of residence of the householdText
shelter_condition_household_post_eqHousehold’s shelter condition after earthquakeCategorical
residence_household_pre_eqHousehold’s residence before earthquakeCategorical
residence_household_post_eqHousehold’s Residence after EarthquakeCategorical
household_eq_id_typeType of ID card received by a householdCategorical
has_death_occurred_last_12_monthsFlag variable that indicates if anyone has died in last 12 monthsBoolean
count_death_last_12_monthsNumber of people within the household who have died in last 12 monthsNumber
has_injury_loss_occurred_last_12_monthsFlag variable that indicates if anyone from the household was injured or went missing in the last 12 monthsBoolean
count_injury_loss_last_12_monthsNumber of people within the household who were injured or missing in the last 12 monthsNUmber
has_education_drop_occurred_last_12_monthsFlag variable that indicates if anyone from the household has left school in the last 12 monthsBoolean
count_education_drop_last_12_monthsNumber of people within the household who have left school in the last 12 monthsNumber
has_pregnancy_treatment_drop_occurred_last_12_monthsFlag variable that indicates if any pregnant woman in the household has stopped going for checkups in the last 12 monthsBoolean
count_pregnancy_treatment_drop_last_12_monthsNumber of pregnant women in the household that have stopped going for checkups in the last 12 monthsNumber
has_vaccination_drop_occurred_last_12_monthsFlag variable that indicates if any children have stopped getting vaccinated in the last 12 monthsBoolean
count_vaccination_drop_last_12_monthsNumber of children within the household that have stopped getting vaccination in the last 12 monthsNumber
has_occupation_change_occurred_last_12_monthsFlag variable that indicates if anyone in the household has had to change their occupation in the last 12 monthsBoolean
count_occupation_change_last_12_monthsNumber of people from the household who have changed their occupation in the last 12 monthsNumber
residence_district_household_head_pre_eqHousehold Head’s district of residence before the earthquakeCategorical
residence_district_household_head_post_eqHousehold Head’s district of residence after the earthquakeCategorical
is_recipient_rahat_15kFlag variable that indicates if the household has recieved rahat of Rs. 15,000Boolean
is_recipient_rahat_10kFlag variable that indicates if the household has recieved rahat of Rs. 10,000Boolean
is_recipient_rahat_200kFlag variable that indicates if the household has recieved rahat of Rs. 200,000Boolean
is_recipient_rahat_social_security_3kFlag variable that indicates if the household has recieved rahat of Rs. 3,000 (social security)Boolean
is_recipient_rahat_noneFlag variable that indicates if the household hasn’t received any rahatBoolean
is_ineligible_rahatFlag variable that indicates if the recipient is not elligible for rahatBoolean
idA unique ID that identifies a unique information from all tableNumber