"\nCREATE TABLE recs_responses\n (\n id INTEGER NOT NULL PRIMARY KEY,\n air_conditioner_use_id CHARACTER VARYING(255),\n annual_energy_from_electricity_for_air_conditioners FLOAT,\n annual_energy_from_electricity_for_air_conditioners_units CHARACTER VARYING( 255),\n annual_energy_from_electricity_for_clothes_driers FLOAT,\n annual_energy_from_electricity_for_clothes_driers_units CHARACTER VARYING(255),\n annual_energy_from_electricity_for_dishwashers FLOAT,\n annual_energy_from_electricity_for_dishwashers_units CHARACTER VARYING(255),\n annual_energy_from_electricity_for_freezers FLOAT,\n annual_energy_from_electricity_for_freezers_units CHARACTER VARYING(255),\n annual_energy_from_electricity_for_heating_space FLOAT,\n annual_energy_from_electricity_for_heating_space_units CHARACTER VARYING(255),\n annual_energy_from_electricity_for_heating_water FLOAT,\n annual_energy_from_electricity_for_heating_water_units CHARACTER VARYING(255),\n annual_energy_from_electricity_for_other_appliances FLOAT,\n annual_energy_from_electricity_for_other_appliances_units CHARACTER VARYING( 255),\n annual_energy_from_electricity_for_refrigerators FLOAT,\n annual_energy_from_electricity_for_refrigerators_units CHARACTER VARYING(255),\n annual_energy_from_fuel_oil_for_appliances FLOAT,\n annual_energy_from_fuel_oil_for_appliances_units CHARACTER VARYING(255),\n annual_energy_from_fuel_oil_for_heating_space FLOAT,\n annual_energy_from_fuel_oil_for_heating_space_units CHARACTER VARYING(255),\n annual_energy_from_fuel_oil_for_heating_water FLOAT,\n annual_energy_from_fuel_oil_for_heating_water_units CHARACTER VARYING(255),\n annual_energy_from_kerosene FLOAT,\n annual_energy_from_kerosene_units CHARACTER VARYING(255),\n annual_energy_from_natural_gas_for_appliances FLOAT,\n annual_energy_from_natural_gas_for_appliances_units CHARACTER VARYING(255),\n annual_energy_from_natural_gas_for_heating_space FLOAT,\n annual_energy_from_natural_gas_for_heating_space_units CHARACTER VARYING(255),\n annual_energy_from_natural_gas_for_heating_water FLOAT,\n annual_energy_from_natural_gas_for_heating_water_units CHARACTER VARYING(255),\n annual_energy_from_propane_for_appliances FLOAT,\n annual_energy_from_propane_for_appliances_units CHARACTER VARYING(255),\n annual_energy_from_propane_for_heating_space FLOAT,\n annual_energy_from_propane_for_heating_space_units CHARACTER VARYING(255),\n annual_energy_from_propane_for_heating_water FLOAT,\n annual_energy_from_propane_for_heating_water_units CHARACTER VARYING(255),\n annual_energy_from_wood FLOAT,\n annual_energy_from_wood_units CHARACTER VARYING(255),\n attached_1car_garage INTEGER,\n attached_2car_garage INTEGER,\n attached_3car_garage INTEGER,\n bathrooms FLOAT,\n bedrooms INTEGER,\n census_division_name CHARACTER VARYING(255),\n census_division_number INTEGER,\n census_region_name CHARACTER VARYING(255),\n census_region_number INTEGER,\n central_ac_use CHARACTER VARYING(255),\n clothes_dryer_use CHARACTER VARYING(255),\n clothes_machine_use_id CHARACTER VARYING(255),\n clothes_washer_use CHARACTER VARYING(255),\n construction_period CHARACTER VARYING(255),\n construction_year DATE,\n cooling_degree_days INTEGER,\n cooling_degree_days_units CHARACTER VARYING(255),\n detached_1car_garage INTEGER,\n detached_2car_garage INTEGER,\n detached_3car_garage INTEGER,\n dishwasher_use_id CHARACTER VARYING(255),\n efficient_lights_on_1_to_4_hours INTEGER,\n efficient_lights_on_4_to_12_hours INTEGER,\n efficient_lights_on_over_12_hours INTEGER,\n floorspace FLOAT,\n floorspace_units CHARACTER VARYING(255),\n freezer_count INTEGER,\n full_bathrooms INTEGER,\n half_bathrooms INTEGER,\n heated_garage INTEGER,\n heating_degree_days INTEGER,\n heating_degree_days_units CHARACTER VARYING(255),\n lighting_efficiency FLOAT,\n lighting_use FLOAT,\n lighting_use_units CHARACTER VARYING(255),\n lights_on_1_to_4_hours INTEGER,\n lights_on_4_to_12_hours INTEGER,\n lights_on_over_12_hours INTEGER,\n outdoor_all_night_gas_lights INTEGER,\n outdoor_all_night_lights INTEGER,\n ownership BOOLEAN,\n refrigerator_count INTEGER,\n residence_class_id CHARACTER VARYING(255),\n residents INTEGER,\n rooms FLOAT,\n thermostat_programmability BOOLEAN,\n total_rooms INTEGER,\n urbanity_id CHARACTER VARYING(255),\n weighting FLOAT,\n window_ac_use CHARACTER VARYING(255)\n );\n\n"