Name: ENERGY STAR Certified Computers
Creator: US Government
License: https://edg.epa.gov/EPA_Data_License.html
About this Dataset

ENERGY STAR Certified Computers

Certified models meet all ENERGY STAR requirements as listed in the Version 8.0 ENERGY STAR Program Requirements for Computers that are effective as of October 15, 2020 and the Version 9.0 Requirements that are effective as of October 27, 2025.
Organization: U.S. Environmental Protection Agency
Last updated: 2020-11-12T14:52:25.234859
Tags: computers
Tables

Table 1

@usgov.epa_gov_energy_star_certified_version_8_0_computers.table_1
614.68 kB
2,973 rows
176 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,
  "type" VARCHAR,
  "touch_screen" VARCHAR,
  "notebooks_desktops_integrated_computers_slate_tablets__9ce66c2d" VARCHAR  -- Notebooks, Desktops, Integrated Computers, Slate/Tablets, Two-in-one Notebooks, And Portable All-in-ones Category For TEC (Typical Energy Consumption) Criteria,
  "category_0_processor_brand" VARCHAR  -- Category 0: Processor Brand,
  "category_0_processor_name" VARCHAR  -- Category 0: Processor Name,
  "category_0_operating_system_name" VARCHAR  -- Category 0: Operating System Name,
  "category_0_base_processor_speed_per_core_ghz" DOUBLE  -- Category 0: Base Processor Speed Per Core (GHz),
  "category_0_physical_cpu_cores_count" DOUBLE  -- Category 0: Physical CPU Cores (count),
  "category_0_system_memory_gb" DOUBLE  -- Category 0: System Memory (GB),
  "category_0_graphics_category" VARCHAR  -- Category 0: Graphics Category,
  "category_0_default_low_power_mode" VARCHAR  -- Category 0: Default Low-power Mode,
  "category_0_long_idle_power_used_for_sleep_mode" VARCHAR  -- Category 0: Long Idle Power Used For Sleep Mode,
  "category_0_off_mode_watts" DOUBLE  -- Category 0: Off Mode (watts),
  "category_0_sleep_mode_watts" DOUBLE  -- Category 0: Sleep Mode (watts),
  "category_0_long_idle_watts" DOUBLE  -- Category 0: Long Idle (watts),
  "category_0_short_idle_watts" DOUBLE  -- Category 0: Short Idle (watts),
  "category_0_base_tec_allowance_kwh" DOUBLE  -- Category 0: Base TEC Allowance (kWh),
  "category_0_functional_adder_allowances_kwh" DOUBLE  -- Category 0: Functional Adder Allowances (kWh),
  "category_0_tec_of_model_kwh" DOUBLE  -- Category 0: TEC Of Model (kWh),
  "category_1_processor_brand" VARCHAR  -- Category 1: Processor Brand,
  "category_1_processor_name" VARCHAR  -- Category 1: Processor Name,
  "category_1_operating_system_name" VARCHAR  -- Category 1: Operating System Name,
  "category_1_base_processor_speed_per_core_ghz" DOUBLE  -- Category 1: Base Processor Speed Per Core (GHz),
  "category_1_physical_cpu_cores_count" DOUBLE  -- Category 1: Physical CPU Cores (count),
  "category_1_system_memory_gb" DOUBLE  -- Category 1: System Memory (GB),
  "category_1_default_low_power_mode" VARCHAR  -- Category 1: Default Low-power Mode,
  "category_1_long_idle_power_used_for_sleep_mode" VARCHAR  -- Category 1: Long Idle Power Used For Sleep Mode,
  "category_1_off_mode_watts" DOUBLE  -- Category 1: Off Mode (watts),
  "category_1_sleep_mode_watts" DOUBLE  -- Category 1: Sleep Mode (watts),
  "category_1_long_idle_watts" DOUBLE  -- Category 1: Long Idle (watts),
  "category_1_short_idle_watts" DOUBLE  -- Category 1: Short Idle (watts),
  "category_1_base_tec_allowance_kwh" DOUBLE  -- Category 1: Base TEC Allowance (kWh),
  "category_1_functional_adder_allowances_kwh" DOUBLE  -- Category 1: Functional Adder Allowances (kWh),
  "category_1_tec_of_model_kwh" DOUBLE  -- Category 1: TEC Of Model (kWh),
  "category_2_processor_brand" VARCHAR  -- Category 2: Processor Brand,
  "category_2_processor_name" VARCHAR  -- Category 2: Processor Name,
  "category_2_operating_system_name" VARCHAR  -- Category 2: Operating System Name,
  "category_2_base_processor_speed_per_core_ghz" DOUBLE  -- Category 2: Base Processor Speed Per Core (GHz),
  "category_2_physical_cpu_cores_count" DOUBLE  -- Category 2: Physical CPU Cores (count),
  "category_2_system_memory_gb" DOUBLE  -- Category 2: System Memory (GB),
  "category_2_default_low_power_mode" VARCHAR  -- Category 2: Default Low-power Mode,
  "category_2_long_idle_power_used_for_sleep_mode" VARCHAR  -- Category 2: Long Idle Power Used For Sleep Mode,
  "category_2_off_mode_watts" DOUBLE  -- Category 2: Off Mode (watts),
  "category_2_sleep_mode_watts" DOUBLE  -- Category 2: Sleep Mode (watts),
  "category_2_long_idle_watts" DOUBLE  -- Category 2: Long Idle (watts),
  "category_2_short_idle_watts" DOUBLE  -- Category 2: Short Idle (watts),
  "category_2_base_tec_allowance_kwh" DOUBLE  -- Category 2: Base TEC Allowance (kWh),
  "category_2_functional_adder_allowances_kwh" DOUBLE  -- Category 2: Functional Adder Allowances (kWh),
  "category_2_tec_of_model_kwh" DOUBLE  -- Category 2: TEC Of Model (kWh),
  "category_i1_processor_brand" VARCHAR  -- Category I1: Processor Brand,
  "category_i1_processor_name" VARCHAR  -- Category I1: Processor Name,
  "category_i1_operating_system_name" VARCHAR  -- Category I1: Operating System Name,
  "category_i1_base_processor_speed_per_core_ghz" DOUBLE  -- Category I1: Base Processor Speed Per Core (GHz),
  "category_i1_physical_cpu_cores_count" DOUBLE  -- Category I1: Physical CPU Cores (count),
  "category_i1_system_memory_gb" DOUBLE  -- Category I1: System Memory (GB),
  "category_i1_default_low_power_mode" VARCHAR  -- Category I1: Default Low-power Mode,
  "category_i1_long_idle_power_used_for_sleep_mode" VARCHAR  -- Category I1: Long Idle Power Used For Sleep Mode,
  "category_i1_off_mode_watts" DOUBLE  -- Category I1: Off Mode (watts),
  "category_i1_sleep_mode_watts" DOUBLE  -- Category I1: Sleep Mode (watts),
  "category_i1_long_idle_watts" DOUBLE  -- Category I1: Long Idle (watts),
  "category_i1_short_idle_watts" DOUBLE  -- Category I1: Short Idle (watts),
  "category_i1_base_tec_allowance_kwh" DOUBLE  -- Category I1: Base TEC Allowance (kWh),
  "category_i1_functional_adder_allowances_kwh" DOUBLE  -- Category I1: Functional Adder Allowances (kWh),
  "category_i1_tec_of_model_kwh" DOUBLE  -- Category I1: TEC Of Model (kWh),
  "category_i2_processor_brand" VARCHAR  -- Category I2: Processor Brand,
  "category_i2_processor_name" VARCHAR  -- Category I2: Processor Name,
  "category_i2_operating_system_name" VARCHAR  -- Category I2: Operating System Name,
  "category_i2_base_processor_speed_per_core_ghz" DOUBLE  -- Category I2: Base Processor Speed Per Core (GHz),
  "category_i2_physical_cpu_cores_count" DOUBLE  -- Category I2: Physical CPU Cores (count),
  "category_i2_system_memory_gb" DOUBLE  -- Category I2: System Memory (GB),
  "category_i2_default_low_power_mode" VARCHAR  -- Category I2: Default Low-power Mode,
  "category_i2_long_idle_power_used_for_sleep_mode" VARCHAR  -- Category I2: Long Idle Power Used For Sleep Mode,
  "category_i2_off_mode_watts" DOUBLE  -- Category I2: Off Mode (watts),
  "category_i2_sleep_mode_watts" DOUBLE  -- Category I2: Sleep Mode (watts),
  "category_i2_long_idle_watts" DOUBLE  -- Category I2: Long Idle (watts),
  "category_i2_short_idle_watts" DOUBLE  -- Category I2: Short Idle (watts),
  "category_i2_base_tec_allowance_kwh" DOUBLE  -- Category I2: Base TEC Allowance (kWh),
  "category_i2_functional_adder_allowances_kwh" DOUBLE  -- Category I2: Functional Adder Allowances (kWh),
  "category_i2_tec_of_model_kwh" DOUBLE  -- Category I2: TEC Of Model (kWh),
  "category_d1_processor_brand" VARCHAR  -- Category D1: Processor Brand,
  "category_d1_processor_name" VARCHAR  -- Category D1: Processor Name,
  "category_d1_operating_system_name" VARCHAR  -- Category D1: Operating System Name,
  "category_d1_base_processor_speed_per_core_ghz" DOUBLE  -- Category D1: Base Processor Speed Per Core (GHz),
  "category_d1_physical_cpu_cores_count" DOUBLE  -- Category D1: Physical CPU Cores (count),
  "category_d1_system_memory_gb" DOUBLE  -- Category D1: System Memory (GB),
  "category_d1_default_low_power_mode" VARCHAR  -- Category D1: Default Low-power Mode,
  "category_d1_long_idle_power_used_for_sleep_mode" VARCHAR  -- Category D1: Long Idle Power Used For Sleep Mode,
  "category_d1_off_mode_watts" DOUBLE  -- Category D1: Off Mode (watts),
  "category_d1_sleep_mode_watts" DOUBLE  -- Category D1: Sleep Mode (watts),
  "category_d1_long_idle_watts" DOUBLE  -- Category D1: Long Idle (watts),
  "category_d1_short_idle_watts" DOUBLE  -- Category D1: Short Idle (watts),
  "category_d1_base_tec_allowance_kwh" DOUBLE  -- Category D1: Base TEC Allowance (kWh),
  "category_d1_functional_adder_allowances_kwh" DOUBLE  -- Category D1: Functional Adder Allowances (kWh)
);