ENERGY STAR Certified Commercial Ovens
U.S. Environmental Protection Agency
@usgov.epa_gov_energy_star_certified_commercial_ovens_v3_0
U.S. Environmental Protection Agency
@usgov.epa_gov_energy_star_certified_commercial_ovens_v3_0
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" VARCHAR,
"product_type" VARCHAR,
"oven_classification" VARCHAR,
"size" VARCHAR,
"heat_source_fuel_type" VARCHAR,
"input_rate_kw" DOUBLE,
"input_rate_btu_hr" DOUBLE,
"gas_oven_convection_mode_pre_heat_energy_btu" DOUBLE,
"electric_oven_convection_mode_pre_heat_energy_kwh" DOUBLE,
"convection_mode_pre_heat_time_min" DOUBLE,
"gas_oven_steam_mode_pre_heat_energy_btu" DOUBLE,
"electric_oven_steam_mode_pre_heat_energy_kwh" DOUBLE,
"steam_mode_pre_heat_time_min" DOUBLE,
"electric_oven_convection_mode_idle_energy_rate_kw" DOUBLE,
"gas_oven_convection_mode_idle_energy_rate_btu_hr" DOUBLE,
"gas_oven_convection_mode_electric_idle_energy_rate_kw" DOUBLE,
"gas_oven_convection_mode_total_idle_energy_rate_btu_hr" DOUBLE,
"method_of_steam_generation" VARCHAR,
"half_size_and_full_size_steam_pan_capacity" DOUBLE,
"two_thirds_size_steam_pan_capacity" DOUBLE,
"half_size_sheet_pan_capacity" DOUBLE,
"full_size_sheet_pan_capacity" DOUBLE,
"electric_oven_steam_mode_idle_energy_rate_kw" DOUBLE,
"gas_oven_steam_mode_idle_energy_rate_btu_hr" DOUBLE,
"gas_oven_steam_mode_electric_idle_energy_rate_kw" DOUBLE,
"gas_oven_steam_mode_total_idle_energy_rate_btu_hr" DOUBLE,
"convection_mode_cooking_energy_efficiency" DOUBLE,
"steam_mode_cooking_energy_efficiency" DOUBLE,
"convection_mode_production_capacity_lbs_hr" DOUBLE,
"steam_mode_production_capacity_lbs_hr" DOUBLE,
"convection_mode_cooking_period_water_consumption_gal_pan" DOUBLE,
"convection_mode_idle_period_water_consumption_gal_hr_pan" DOUBLE,
"steam_mode_cooking_period_water_consumption_gal_pan" DOUBLE,
"steam_mode_idle_period_water_consumption_gal_hr_pan" DOUBLE,
"rack_oven_baking_energy_efficiency" DOUBLE,
"baking_production_capacity_lbs_hr" DOUBLE,
"set_back_idle_mode" VARCHAR,
"steam_injection_period_water_consumption_gal_min" DOUBLE,
"date_available_on_market" TIMESTAMP,
"date_certified" TIMESTAMP,
"markets" VARCHAR,
"cb_model_identifier" VARCHAR
);
Anyone who has the link will be able to view this.