ENERGY STAR Certified Water Heaters
U.S. Environmental Protection Agency
@usgov.epa_gov_energy_star_certified_water_heaters_upcoming_v_c4d14663
U.S. Environmental Protection Agency
@usgov.epa_gov_energy_star_certified_water_heaters_upcoming_v_c4d14663
CREATE TABLE table_1 (
"energy_star_unique_id" BIGINT,
"energy_star_partner" VARCHAR,
"brand_name" VARCHAR,
"model_name" VARCHAR,
"model_number" VARCHAR,
"additional_model_information" VARCHAR,
"upc" DOUBLE,
"type" VARCHAR,
"heat_pump_type" VARCHAR,
"fuel" VARCHAR,
"vent_type" VARCHAR,
"storage_volume_gallons" DOUBLE,
"first_hour_rating_gallons" DOUBLE,
"maximum_gallons_per_minute" DOUBLE,
"minimum_gallons_per_minute" DOUBLE,
"draw_pattern_intended_usage" VARCHAR,
"uniform_energy_factor_uef" DOUBLE,
"electric_usage_kwh_yr" DOUBLE,
"therms_year_for_natural_gas" DOUBLE,
"gallons_year_for_propane" DOUBLE,
"max_input_rate_for_gas_products_btu_hr" DOUBLE,
"electric_input_kw" DOUBLE,
"input_voltage_for_hpwh_v" DOUBLE,
"lower_compressor_cut_off_temperature_for_hpwh_f" DOUBLE,
"upper_compressor_cut_off_temperature_for_hpwh_f" DOUBLE,
"max_amps" DOUBLE,
"recovery_efficiency" DOUBLE,
"tank_height_inches" DOUBLE,
"height_to_vent_inches" DOUBLE,
"tank_diameter_inches" DOUBLE,
"vent_size_1_inches" DOUBLE,
"vent_size_2_inches" DOUBLE,
"solar_system_type" VARCHAR,
"solar_collector_type" VARCHAR,
"solar_collector_panel_area_sq_feet" DOUBLE,
"solar_uniform_energy_factor_suef" DOUBLE,
"og_300_number" VARCHAR,
"freeze_tolerance_limit_f" DOUBLE,
"solar_tank_volume_gallons" DOUBLE,
"solar_type_of_backup" VARCHAR,
"solar_auxiliary_tank_volume_gallons" DOUBLE,
"solar_auxiliary_tank_input_kw" DOUBLE,
"solar_auxiliary_tank_input_btu_hr" DOUBLE,
"water_heater_depth_inches" DOUBLE,
"water_heater_height_inches" DOUBLE,
"water_heater_width_inches" DOUBLE,
"connected_capable" VARCHAR,
"connects_using" VARCHAR,
"dr_protocol" VARCHAR,
"communication_hardware_architecture" VARCHAR,
"load_up_functionality" VARCHAR,
"optional_operational_mode_functionality" VARCHAR,
"time_of_use_schedule" VARCHAR,
"primary_communication_module_device_brand_name_and_model_number" VARCHAR,
"is_broadband_internet_connection_needed_for_demand_response" VARCHAR,
"refrigerant_type" VARCHAR,
"refrigerant_with_gwp" VARCHAR,
"sound_pressure_level" DOUBLE,
"date_available_on_market" TIMESTAMP,
"date_certified" TIMESTAMP,
"markets" VARCHAR,
"cb_model_identifier" VARCHAR,
"tax_credit_eligible" VARCHAR
);
Anyone who has the link will be able to view this.