Questionnaire Wave 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Changes in housing ownership and structure
Customer_reference(PK) | new_electricity_meters/no_of_electricity_meters | own_the_house_or_living_on_rent | occupy_renters_boarders | renters_were_there_during_w1_or_not | since_when_renters_are_living_in_household | awareness_of_electricity_consumption_of_renters | changes_to_the_structure_of_household_after_w1 | renovations_done_after_w1 | new_type_of_house | new_no_of_storeys | new_floor_area | built_house_or_purchased_house | considered_natural_lighting | considered_ventilation | used_insulation_material | new_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 | other_business_activity | is_there_any_construction_or_renovation_ongoing | last_month_expenditure | smart_metered_or_non_smart_metered
ACCOUNT_NO/ LA_Unique_ID | W1_EM_1/ W1_EM_2 | W1_B_1 | W1_C_3 | W1_C_3b | W1_C_3c / W1_C_3cOth | W1_C_5 | W1_B_5a | W1_B_5b | W1_B_5 | W1_B_7 | W1_B_8 | W2_B_9 | T_W2_B_10_1 | T_W2_B_10_2 | T_W2_B_10_3 | W1_C_1 | W1_C_4 | W1_C_6 | W1_C_7 | W1_C_8 | W1_C_8Oth | W2_E_8 | W1_H_4 | W1_H_5
Demographics Changes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
members_who_were_in_w1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Customer_reference(PK) | member_id(PK) | still_living_in_house_or_not | changed_main_activity_engaged_in_or_not | new_main_activity | new_main_occupation | daily_wage_earner_or_not | employment_status_of_the_new_main_occupation | no_of_hours_stayed_at_home_during_last_week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | member_id | W2_C1_4 | W2_C.3.j_1 | W2_C.3.j | W2_C.3.k | W2_C.3.l | W2_C.3m | W2_C.3.n |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
New household members |  |  |  |  |  |  |  |
Customer_reference(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 |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | member_id(may be continue above) | 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 |  |  |  |  |  |  |  |
Appliance Roster |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Change in appliance list |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
customer_reference(FK)(PK) | appliance(PK) | appliance_type_and_no_of_appliances | still_have_the_same_number_of_appliances_or_not | new_no_of_appliances |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | get the appliance list | W2_D | W1_D1a | W1.D2a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
New appliance list |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
customer_reference(FK)(PK) | appliance(PK) | is_the_appliance_available_in_the_household | no_of_appliances_of_that_type | no_of_hours_used_during_last_week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | get the appliance list | W2_D1 | W2_D2, W1.D2a | W2_D3, W1_D3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Appliance specifications |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
customer_reference(FK)(PK) | appliance(PK) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | get the appliance list |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Room Roster |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Changes in room roster |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
customer_reference(FK)(PK) | room_id(PK) | room_type | no_of_rooms_of_each_type | is_there_change_of_no_of_rooms_of_each_type | new_no_of_rooms |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | ACCOUNT_NO_room_id | list the types | T_W1_E_5_1 - T_W1_E_5_10 | W2_E.5c | W2_E.5d |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
New room roster |  |  |  |  |  |  |  |
customer_reference(FK)(PK) | room_id(PK) | room_type | main_purpose_of_the_room | was_this_available_during_w1_and_was there_any_changes_done_in_this_part | 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 | have_curtains_or_blinds_for_windows | have_other_ventelation_openings | no_of_bulbs_in_the_room | no_of_bulbs_used_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_a_1 | 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.h | W1_E.6.i | W1_E.6.j | W1_E.6.j_1 | W1_E.6.k | W1_E.6.l |  |  |  |  |  |  |  |
Light Roster |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
customer_reference(FK)(PK) | room_id(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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
customer_reference(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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
customer_reference(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 |  |  |  |  |  |  |  |
customer_reference(FK)(PK) | had_solar_energy_when_w1_was_done | installed_a_solar_system_after_w1 | still_have_the_solar_system_from_w1 | increased_or_decreased_no_of_panels_after_w1 | solar_system_ongrid_or_offgrid | solar_system_inverter_or_non_inverter | 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_last_month | capacity_of_the_solar_system |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | W1_E_18 | W1_E_19 | W1_E_20a | W1_E_20b | W1_E_13 | W1_E_14 | W2_E_12_O1 | W2_E_12_O2 | W2_E_12_O3 | W2_E_12_O4 | W2_E_12_O5 | W2_E_12_O6 | W2_E_12_O7 | W1_E_15a | W1_E_15b | W1_E_15c |  |  |  |  |  |  |  |
Behaviour |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
customer_reference(FK)(PK) | behaviour_of_ironing_clothes | behaviour_around_drying_clothes | behaviour_around_night_lighting | how_often_members_turn_off_unnecesary_lights_when_leaving_a_room | how_conscious_about_reducing_number_of_time_refrigerator_door_is_opened | look_at_wattage_or_energy_rating_when_buying_appliances |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | W2_L_1 | W2_L_2 | W2_L_3 | W2_L_4 | W2_L_5 | W2_L_6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |