About this Dataset

ENERGY STAR Certified Pool Pumps

Certified models meet all ENERGY STAR requirements as listed in the Version 3.0 ENERGY STAR Program Requirements, effective on July 19, 2021, or Version 3.1 ENERGY STAR Program Requirements, also effective on July 19, 2021. A detailed listing of key efficiency criteria are available at https://www.energystar.gov/products/other/pool_pumps/key_product_criteria
Organization: U.S. Environmental Protection Agency
Last updated: 2020-11-12T14:52:27.488019
Tags: pool-pumps

Tables

Table 1

@usgov.epa_gov_energy_star_certified_pool_pumps.table_1

76.27 kB
342 rows
55 columns

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  -- Weighted Energy Factor (WEF) (kgal/kWh),
  "field_no_longer_used" VARCHAR,
  "minimum_wef_for_federal_standard" DOUBLE,
  "flow_gpm_at_low_speed_measurement_point" DOUBLE  -- Flow (GPM) At Low Speed Measurement Point,
  "head_fth20_at_low_speed_measurement_point" DOUBLE  -- Head (ftH20) At Low Speed Measurement Point,
  "rpm_at_low_speed_measurement_point" DOUBLE,
  "power_w_at_low_speed_measurement_point" DOUBLE  -- Power (W) At Low Speed Measurement Point,
  "flow_gpm_at_high_speed_measurement_point" DOUBLE  -- Flow (GPM) At High Speed Measurement Point,
  "rpm_at_high_speed_measurement_point" DOUBLE,
  "head_ft_h20_at_high_speed_point" DOUBLE  -- Head (ft.H20) At High Speed Point,
  "power_w_at_high_speed_measurement_point" DOUBLE  -- Power (W) At High Speed Measurement Point,
  "speed_rpm" VARCHAR  -- Speed (RPM),
  "curve_a_flow_gpm" DOUBLE  -- Curve-A Flow (GPM),
  "curve_a_power_w" DOUBLE  -- Curve-A Power (W),
  "curve_a_energy_factor_gal_wh" VARCHAR  -- Curve-A Energy Factor (Gal/Wh),
  "curve_c_flow_gpm" DOUBLE  -- Curve-C Flow (GPM),
  "curve_c_power_w" DOUBLE  -- Curve-C Power (W),
  "curve_c_energy_factor_gal_wh" VARCHAR  -- Curve-C Energy Factor (Gal/Wh),
  "curve_b_flow_gpm" DOUBLE  -- Curve-B Flow (GPM),
  "curve_b_power_w" DOUBLE  -- Curve-B Power (W),
  "curve_b_energy_factor_gal_wh" VARCHAR  -- Curve-B Energy Factor (Gal/Wh),
  "standby_average_power_w" DOUBLE  -- Standby Average Power (W),
  "motor_construction" VARCHAR,
  "hydraulic_horsepower_hhp" DOUBLE  -- Hydraulic Horsepower (HHP),
  "rated_horsepower_hp" DOUBLE  -- Rated Horsepower (HP),
  "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  -- Network Standby Power (W),
  "is_broadband_internet_connection_needed_for_demand_response" VARCHAR  -- Is Broadband Internet Connection Needed For Demand Response?,
  "date_available_on_market" TIMESTAMP,
  "date_certified" TIMESTAMP,
  "markets" VARCHAR,
  "energy_star_model_identifier" VARCHAR
);