Questionnaire Wave 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Household Information and History
household_id(PK) | no_of_electricity_meters | own_the_house_or_living_on_rent | occupy_renters_boarders | awareness_of_electricity_consumption_of_renters | built_year_of_the_house | type_of_house | floor_which_house_located | no_of_storeys | floor_area | no_of_household_members | charging_method_of_renters_for_electricity | charged_method_for_rent_for_electricity | is_there_business_carried_out_in_the_household | type_of_business | whom_or_how_the_house_was_designed | availability_of_certificate_of_compliance | main_material_used_for_walls_of_the_house | main_material_used_for_roof_of_the_house | any_constructions_or_renovations_in_the_household | highest_level_of_education_of_the_chief_wage_earner | occupation_of_education_of_the_chief_wage_earner | socio_economic_class | total_monthly_expenditure_of_last_month | type_of_electricity_meter | LECO_CSC_area
ACCOUNT_NO/ LA_Unique_ID | W1_EM_1/ W1_EM_2 | W1_B_1 | W1_C_3 | W1_C_5 | W1_B_2 | W1_B_5 | W1_B_6 | W1_B_7 | W1_B_8 | W1_C_1 | W1_C_4 | W1_C_6 | W1_C_7 | W1_C_8 | W1_E_1_a | W1_E_1_b | W1_E_2 | W1_E_3 | W1_E_8 | W1_H_1 | W1_H_2 | W1_H_3 | W1_H_4 | W1_H_5 | T_PData_8
Demographics |  |  |  |  |  |  |  |
household_id(FK)(PK) | member_id(PK) | name | relationship_to_the_head_of_household | gender | year_of_birth | age | ethnicity | religion | marital_status | current_attendance_in_any_education_instituition | highest_level_of_education | main_activity_engaged_in | main_occupation | daily_wage_owner_or_not | employment_status_of_the_main_occupation | no_of_hours_stayed_at_home_during_last_week | member_went_out_for_work_or_not_during_last_week |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | ACCOUNT_NO_member_id | W1_C.2.a | W1_C.2.b | W1_C.2.c | W1_C.2.d | W1_C.2.d.1 | W1_C.2.e | W1_C.2.f | W1_C.2.g | W1_C.2.h | W1_C.2.i | W1_C.2.j | W1_C.2.k | W1_C.2.l | W1_C.2.m | W1_C.2.n | W1_C.2.o |  |  |  |  |  |  |  |
Appliances |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
household_id(FK)(PK) | appliance(PK) | appliance_type | no_of_appliances_of_that_type | no_of_hours_used_during_last_week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | get the appliance list | W1_D1 | W1_D2 | W1_D3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Room Roster |  |  |  |  |  |  |  |  |
household_id(FK)(PK) | room_id(PK) | room_type | main_purpose_of_the_room | storey_which_the_room_located | main_material_used_for_the_roof_of_the_room | type_of_ceiling_of_the_room | main_material_used_for_the_floor_of_the_room | no_of_doors_opened_to_external_environment | no_of_windows | main_material_used_for_window_panes | have_curtains_or_blinds_for_windows | have_other_ventelation_holes | no_of_bulbs_in_the_room | no_of_bulbs_used_during_last_week | no_of_fans_in_the_room | no_of_ACs_in_the_room |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | ACCOUNT_NO_room_id | get the room type list | W1_E.6.a | W1_E.6.b | W1_E.6.c_1 | W1_E.6.c_2 | W1_E.6.d | W1_E.6.e | W1_E.6.f | W1_E.6.g | W1_E.6.h | W1_E.6.i | W1_E.6.j | W1_E.6.j_1 | W1_E.6.k | W1_E.6.l |  |  |  |  |  |  |  |  |
Light Roster |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
household_id(FK)(PK) | room_id(FK)(PK) | light_id(PK) | type_of_the_bulb | wattage_of_the_bulb | no_of_hours_bulbs_was_on_during_daytime_last_week | no_of_hours_bulbs_was_on_during_night_last_week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | ACCOUNT_NO_room_id | might need to generate this | W1_E.6. n | W1_E.6. o | W1_E.6. p | W1_E.6. q |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Fan Roster |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
household_id(FK)(PK) | room_id(FK)(PK) | fan_id(PK) | type_of_the_fan | no_of_hours_bulbs_was_on_during_daytime_last_week | no_of_hours_bulbs_was_on_during_night_last_week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | ACCOUNT_NO_room_id | might need to generate this | W1_E.6. r | W1_E.6. s | W1_E.6. t |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
AC Roster |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
household_id(FK)(PK) | room_id(FK)(PK) | AC_id(PK) | type_of_the_AC | is_the_AC_inverter_or_not | is_room_fully_sealed | wattage_of_the_AC | BTU_of_the_AC | no_of_hours_bulbs_was_on_during_daytime_last_week | no_of_hours_bulbs_was_on_during_night_last_week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | ACCOUNT_NO_room_id | might need to generate this | W1_E.6. u | W1_E.6. v | W1_E.6. w | W1_E.6. x_1 | W1_E.6. x_2 | W1_E.6. y | W1_E.6. z |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Other Methods of Generating Electricity and Backup Electricity |  |  |  |  |  |
household_id(FK)(PK) | have_backup_generator | generate_electicity_using_solar_energy | generate_electicity_using_bio_energy | generate_electicity_using_mini_hydropower | generate_electicity_using_wind_power | generate_electicity_using_other_methods | solar_system_ongrid_or_offgird | solar_system_invertor_or_noninvertor | solar_energy_used_for_water_heating | solar_energy_used_for_cooking | solar_energy_used_for_outdoor_lighting | solar_energy_used_for_car_charging | solar_energy_used_for_agricultural_systems | solar_energy_used_for_all_above | solar_energy_used_for_other_purposes | aware_of_no_of_units_generated_by_solar_system | no_of_units_generated_by_solar_system | when_was_solar_system_installed | have_system_to_store_backup_energy_availabilty |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | W1_E_10 | T_W1_E_11_1 | T_W1_E_11_2 | T_W1_E_11_3 | T_W1_E_11_4 | T_W1_E_11_5 | W1_E_13 | W1_E_14 | W1_E_15_O1 | W1_E_15_O2 | W1_E_15_O3 | W1_E_15_O4 | W1_E_15_O5 | W1_E_15_O6 | W1_E_15_O7 | W1_E_15a | W1_E_15b | W1_E_16 | W1_E_17 |  |  |  |  |  |
Water Heating |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
household_id(FK)(PK) | method_of_receiving_water | water_heating_method_for_bathing | does_water_heating_equipment_serve_other_housing_units | household_members_used_hot_water_last_week | boil_water_before_drinking | source_of_energy_for_boiling_drinking_water |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | W1_F_1 | W1_F_2 | W1_F_3 | W1_F_4 | W1_F_5 | W1_F_6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Cooking |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
household_id(FK)(PK) | no_of_times_food_cooked_last_week | source_of_energy_used_for_cooking |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | W1_G_1 | W1_G_2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |