ENERGY STAR Certified Pool Pumps
U.S. Environmental Protection Agency
@usgov.epa_gov_energy_star_certified_pool_pumps
U.S. Environmental Protection Agency
@usgov.epa_gov_energy_star_certified_pool_pumps
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,
"motor_design" VARCHAR,
"weighted_energy_factor_wef_kgal_kwh" DOUBLE,
"field_no_longer_used" VARCHAR,
"minimum_wef_for_federal_standard" DOUBLE,
"flow_gpm_at_low_speed_measurement_point" DOUBLE,
"head_fth20_at_low_speed_measurement_point" DOUBLE,
"rpm_at_low_speed_measurement_point" DOUBLE,
"power_w_at_low_speed_measurement_point" DOUBLE,
"flow_gpm_at_high_speed_measurement_point" DOUBLE,
"rpm_at_high_speed_measurement_point" DOUBLE,
"head_ft_h20_at_high_speed_point" DOUBLE,
"power_w_at_high_speed_measurement_point" DOUBLE,
"speed_rpm" VARCHAR,
"curve_a_flow_gpm" DOUBLE,
"curve_a_power_w" DOUBLE,
"curve_a_energy_factor_gal_wh" VARCHAR,
"curve_c_flow_gpm" DOUBLE,
"curve_c_power_w" DOUBLE,
"curve_c_energy_factor_gal_wh" VARCHAR,
"curve_b_flow_gpm" DOUBLE,
"curve_b_power_w" DOUBLE,
"curve_b_energy_factor_gal_wh" VARCHAR,
"standby_average_power_w" DOUBLE,
"motor_construction" VARCHAR,
"hydraulic_horsepower_hhp" DOUBLE,
"rated_horsepower_hp" DOUBLE,
"freeze_protection" VARCHAR,
"pcbp_number_of_stages" DOUBLE,
"connected_capable" VARCHAR,
"connects_using" VARCHAR,
"dr_protocol" VARCHAR,
"communication_hardware_architecture" VARCHAR,
"primary_communication_module_device_brand_name" VARCHAR,
"primary_communication_module_device_model_number" VARCHAR,
"features_enabled_by_primary_communication_module_device" VARCHAR,
"secondary_communication_module_device_brand_name" VARCHAR,
"secondary_communication_module_device_model_number" VARCHAR,
"features_enabled_by_secondary_communication_module_device" VARCHAR,
"tertiary_communication_module_device_brand_name" VARCHAR,
"tertiary_communication_module_device_model_number" VARCHAR,
"features_enabled_by_tertiary_communication_module_device" VARCHAR,
"network_standby_power_w" DOUBLE,
"is_broadband_internet_connection_needed_for_demand_response" VARCHAR,
"date_available_on_market" TIMESTAMP,
"date_certified" TIMESTAMP,
"markets" VARCHAR,
"energy_star_model_identifier" VARCHAR
);
Anyone who has the link will be able to view this.