"energystar-gov/energy-star-certified-computers-j7nq-iepp:latest"."energy_star_certified_computers"

SELECT
    ":id", -- Socrata column ID
    "touch_screen", -- If "Yes", the model includes a touch screen.
    "category_1_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
    "type", -- Desktop: A computer whose main unit is designed to be located in a permanent location, often on a desk or on the floor. Desktop computers are not designed for portability and are designed for use with an external display, keyboard, and mouse.  Integrated Computer: A desktop computer in which the computing hardware and display are integrated into a single housing, and which is connected to ac mains power through a single cable. Integrated desktop computers come in one of two possible forms: (1) a system where the display and computer are physically combined into a single unit; or (2) a system packaged as a single system where the display is separate but is connected to the main chassis by a dc power cord and both the computer and display are powered from a single power supply.  Notebook: A computer designed specifically for portability and to be operated for extended periods of time both with and without a direct connection to an ac mains power source.  Slate/tablet: A computing device designed for portability.  Portable All-in-one Computer: A computing device designed for limited portability.  Small-scale Server: A computer that typically uses desktop components in a desktop form factor, but is designed primarily to be a storage host for other computers. Small-scale Servers are designed to perform functions such as providing network infrastructure services (e.g., archiving) and hosting data/media.  Thin Client: An independently-powered computer that relies on a connection to remote computing resources to obtain primary functionality. Main computing functions (e.g., program execution, data storage, interaction with other Internet resources) are provided by the remote computing resources.  Workstation: A high-performance, single-user computer typically used for graphics, CAD, software development, financial and scientific applications among other compute intensive tasks.
    "product_total_usb_2_0_header_count", -- The number of USB 2.0 headers in the product. This includes all headers, whether they have accompanying ports or not. 
    "product_usb_x_x_port_speed", -- The reported speed of the USB X.X ports in the product. USB X.X represents a placeholder for future versions of USB and is not a specific USB port type.
    "product_usb_2_0_port_count", -- The number of USB 2.0 ports in the product. 
    "product_pciex16_slot_count", -- The number of PCI Express x 16 interface slots in the product. 
    "comp_cat_d1_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
    "comp_cat_i1_tec_of_model_kwh", -- Typical energy consumption of the model configuration tested as meeting Category I1 requirements.
    "category_2_base_tec_allowance_kwh", -- The energy allowance provided by the ENERGY STAR specification for the model configuration tested as meeting Category 2 requirements, based on the Computer's processor and graphics capabilities.
    "category_1_long_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition and the Display has entered a low-power state.
    "product_pciex8_slot_count", -- The number of PCI Express x 8 interface slots in the product. 
    "wol_wake_on_lan_from_sleep", -- Whether the model is shipped with Wake on LAN functionality enabled, which allows the computer to be turned on remotely by a system administrator.
    "work_off_mode_watts", -- The lowest power mode which cannot be switched off (influenced) by the user and that may persist for an indefinite time when the appliance is connected to the main electricity supply and used in accordance with the manufacturer’s instructions.
    "work_processor_brand", -- The brand of the central processing unit (CPU).
    "tc_tec_requirement_kwh", -- The energy allowance provided by the ENERGY STAR specification.
    "work_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
    "comp_cat_i1_physical_cpu_cores_count", -- The number of physical - not logical - CPU cores.
    "multi_channel_memory_support", -- Does the product support multi-channel memory functionality?
    "comp_cat_0_system_memory_gb", -- The amount of memory installed in the model configuration tested as meeting Category 0 requirements.
    "comp_cat_d2_system_memory_gb", -- The amount of memory installed in the model configuration tested as meeting Category D2 requirements.
    "comp_cat_i2_long_idle_power_used_for_sleep_mode", -- Power measurements in Long Idle State can be used instead of Sleep Mode if below 10 watts.
    "category_2_default_low_power_mode", -- The default power-saving mode used by the computer.
    "pd_id", -- The ENERGY STAR Unique ID (ESUID) is a string of seven numbers EPA assigns to an ENERGY STAR model or set of models with unique performance characteristics. This ESUID is unique to both the model and product specification version and is assigned by EPA upon receipt of certification information from the certification body. Each row within the product list will have a unique ESUID. Developers may wish to use this ESUID to track information on certified models in their information systems. 
    "comp_cat_i1_processor_brand", -- The brand of the central processing unit (CPU) installed in the model configuration tested as meeting Category I1 requirements
    "comp_cat_0_functional_adder_allowances_kwh", -- The energy allowance provided by the ENERGY STAR specification for the model configuration tested as meeting Category 0 requirements, based on the Computer's other capabilities.
    "comp_cat_i1_base_tec_allowance_kwh", -- The energy allowance provided by the ENERGY STAR specification for the model configuration tested as meeting Category I1 requirements, based on the Computer's processor and graphics capabilities.
    "sleep_mode_default_time_upon_shipment_min", -- Sleep Mode shall be set to activate after no more than 30 minutes of user inactivity.
    "comp_cat_0_sleep_mode_watts", -- A low power mode that the computer enters automatically after a period of inactivity or by manual selection. A computer with Sleep capability can quickly “wake” in response to network connections or user interface devices with a latency of less than or equal to 5 seconds from initiation of wake event to system becoming fully usable including rendering of display.	
    "comp_cat_i2_system_memory_gb", -- The amount of memory installed in the model configuration tested as meeting Category I2 requirements.
    "tc_processor_brand", -- The name of the central processing unit (CPU).
    "comp_cat_0_tec_of_model_kwh", -- Typical energy consumption of the model configuration tested as meeting Category 0 requirements.
    "work_short_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition, but the Display is on, and Long Idle power management features have not engaged.
    "tc_long_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition and the Display has entered a low-power state.
    "comp_cat_d1_off_mode_watts", -- The lowest power mode which cannot be switched off (influenced) by the user and that may persist for an indefinite time when the appliance is connected to the main electricity supply and used in accordance with the manufacturer’s instructions.
    "comp_cat_i1_off_mode_watts", -- The lowest power mode which cannot be switched off (influenced) by the user and that may persist for an indefinite time when the appliance is connected to the main electricity supply and used in accordance with the manufacturer’s instructions. 
    "model_number", -- A distinguishing identifier, usually alphanumeric, assigned to a product by the manufacturer or private labeler.
    "display_sleep_mode_default_time_upon_shipment_min", -- Display Sleep Mode shall be set to activate after no more than 15 minutes of user inactivity.
    "work_system_memory_gb", -- The amount of memory installed in the model configuration tested.
    "upc", -- UPC codes provided by partners for ENERGY STAR certified products. The brand, model name and model number continue to serve as the identifiers used to establish certification. The UPC code data below is intended to aid in identification of ENERGY STAR models. UPC code data is not provided for all certified models.
    "comp_cat_for_tec_typical_energy_consumption_criteria", -- A second-order classification or sub-type within a product type that is based on product features and installed components. Product categories are used in this specification to determine qualification and test requirements. TEC (Typical Energy Consumption) is a method of testing and comparing the energy performance of computers, which focuses on the typical electricity consumed by a product while in normal operation during a representative period of time.
    "comp_cat_0_operating_system_name", -- The name of the operating system installed in the model configuration tested as meeting Category 0 requirements.
    "comp_cat_0_default_low_power_mode", -- The default power-saving mode used by the computer.
    "comp_cat_0_long_idle_power_used_for_sleep_mode", -- Power measurements in Long Idle State can be used instead of Sleep Mode if below 10 watts.
    "comp_cat_0_base_tec_allowance_kwh", -- The energy allowance provided by the ENERGY STAR specification for the model configuration tested as meeting Category 0 requirements, based on the Computer's processor and graphics capabilities. 
    "category_1_processor_brand", -- The brand of the central processing unit (CPU) installed in the model configuration tested as meeting Category 1 requirements.
    "category_2_processor_brand", -- The brand of the central processing unit (CPU) installed in the model configuration tested as meeting Category 2 requirements.
    "category_1_physical_cpu_cores_count", -- The number of physical - not logical - CPU cores.
    "category_1_base_tec_allowance_kwh", -- The energy allowance provided by the ENERGY STAR specification for the model configuration tested as meeting Category 0 requirements, based on the Computer's processor and graphics capabilities.
    "comp_cat_d2_base_tec_allowance_kwh", -- The energy allowance provided by the ENERGY STAR specification for the model configuration tested as meeting Category D2 requirements, based on the Computer's processor and graphics capabilities.
    "category_2_processor_name", -- The name of the central processing unit (CPU) installed in the model configuration tested as meeting Category 2 requirements.
    "category_2_physical_cpu_cores_count", -- The number of physical - not logical - CPU cores.
    "category_2_long_idle_power_used_for_sleep_mode", -- Power measurements in Long Idle State can be used instead of Sleep Mode if below 10 watts.
    "category_2_off_mode_watts", -- The lowest power mode which cannot be switched off (influenced) by the user and that may persist for an indefinite time when the appliance is connected to the main electricity supply and used in accordance with the manufacturer’s instructions.
    "comp_cat_i1_default_low_power_mode", -- The default power-saving mode used by the computer.
    "comp_cat_i2_processor_brand", -- The brand of the central processing unit (CPU) installed in the model configuration tested as meeting Category I2 requirements.
    "comp_cat_i2_physical_cpu_cores_count", -- The number of physical - not logical - CPU cores.
    "comp_cat_i2_base_tec_allowance_kwh", -- The energy allowance provided by the ENERGY STAR specification for the model configuration tested as meeting Category I2 requirements, based on the Computer's processor and graphics capabilities.
    "comp_cat_d1_physical_cpu_cores_count", -- The number of physical - not logical - CPU cores.
    "comp_cat_d1_default_low_power_mode", -- The default power-saving mode used by the computer.
    "comp_cat_d1_long_idle_power_used_for_sleep_mode", -- Power measurements in Long Idle State can be used instead of Sleep Mode if below 10 watts.
    "comp_cat_d2_processor_brand", -- The brand of the central processing unit (CPU) installed in the model configuration tested as meeting Category D2 requirements.
    "comp_cat_d2_default_low_power_mode", -- The default power-saving mode used by the computer.
    "comp_cat_d2_long_idle_power_used_for_sleep_mode", -- Power measurements in Long Idle State can be used instead of Sleep Mode if below 10 watts.
    "wlan_capability", -- Does the product have integrated wireless 802.11 support?
    "motherboard_form_factor", -- The industry standard form factor of the motherboard in the product. 
    "product_m_2_except_key_m_port_count", -- The number of M.2 ports in the product, excluding Key M type M.2 ports. 
    "product_m_2_key_m_port_count", -- The number of Key M type M.2 ports in the product. 
    "product_usb_3_x_5gb_s_port_count", -- The number of USB 3.X ports with a speed of 5 Gb/s in the product. 
    "product_sata_and_esata_port_count", -- The number of SATA and eSATA ports in the product. 
    "product_usb_x_x_10_gb_s_header_count", -- The number of USB X.X headers with a speed greater than 10 Gb/s in the product. USB X.X represents a placeholder for future versions of USB and is not a specific USB port type. This includes all headers, whether they have accompanying ports or not. 
    "product_thunderbolt_port_count", -- The number of Thunderbolt ports in the product. 
    "product_thunderbolt_2_port_count", -- The number of Thunderbolt 2 ports in the product. 
    "product_thunderbolt_3_port_count", -- The number of Thunderbolt 3 ports in the product. 
    "product_usb_3_x_5_gb_s_header_count", -- The number of USB 3.X headers with a speed of 5 Gb/s in the product. This includes all headers, whether they have accompanying ports or not. 
    "product_usb_3_x_10_gb_s_header_count_2", -- The number of USB 3.X headers with a speed of 10 Gb/s in the product. This includes all headers, whether they have accompanying ports or not. 
    "comp_cat_i2_default_low_power_mode", -- The default power-saving mode used by the computer.
    "desktops_notebooks_and_integrated_desktops_category_i2_long_idl", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition and the Display has entered a low-power state.
    "comp_cat_d2_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
    "tc_tec_of_model_kwh", -- Typical energy consumption of a model.
    "product_pciex4_slot_count", -- The number of PCI Express x 4 interface slots in the product. 
    "product_thunderbolt_x_port_speed", -- The reported speed of the Thunderbolt X ports in the product. Thunderbolt X is a placeholder for future versions of Thunderbolt and is not a specific Thunderbolt port type.
    "product_sata_express_port_count", -- The number of SATA Express ports in the product. 
    "category_1_tec_of_model_kwh", -- Typical energy consumption of the model configuration tested as meeting Category 1 requirements.
    "comp_cat_d2_physical_cpu_cores_count", -- The number of physical - not logical - CPU cores.
    "comp_cat_i2_processor_name", -- The name of the central processing unit (CPU) installed in the model configuration tested as meeting Category I2 requirements.
    "bluetooh_capability", -- Does the product have integrated Bluetooth support?
    "comp_cat_d1_sleep_mode_watts", -- A low power mode that the computer enters automatically after a period of inactivity or by manual selection. A computer with Sleep capability can quickly “wake” in response to network connections or user interface devices with a latency of less than or equal to 5 seconds from initiation of wake event to system becoming fully usable including rendering of display.
    "comp_cat_i1_long_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition and the Display has entered a low-power state.
    "date_qualified", -- The date on which the product was confirmed to meet the ENERGY STAR specification.
    "work_sleep_mode_watts", -- A low power mode that the computer enters automatically after a period of inactivity or by manual selection. A computer with Sleep capability can quickly “wake” in response to network connections or user interface devices with a latency of less than or equal to 5 seconds from initiation of wake event to system becoming fully usable including rendering of display.
    "comp_cat_d1_tec_of_model_kwh", -- Typical energy consumption of the model configuration tested as meeting Category D1 requirements.
    "comp_cat_i1_system_memory_gb", -- The amount of memory installed in the model configuration tested as meeting Category I1 requirements.
    "category_2_long_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition and the Display has entered a low-power state.	
    "category_2_short_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition, but the Display is on, and Long Idle power management features have not engaged.
    "comp_cat_0_short_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition, but the Display is on, and Long Idle power management features have not engaged.
    "category_2_tec_of_model_kwh", -- Typical energy consumption of the model configuration tested as meeting Category 2 requirements.
    "category_2_sleep_mode_watts", -- A low power mode that the computer enters automatically after a period of inactivity or by manual selection. A computer with Sleep capability can quickly “wake” in response to network connections or user interface devices with a latency of less than or equal to 5 seconds from initiation of wake event to system becoming fully usable including rendering of display
    "category_2_operating_system_name", -- The name of the operating system installed in the model configuration tested as meeting Category 2 requirements.
    "category_1_operating_system_name", -- The name of the operating system installed in the model configuration tested as meeting Category 1 requirements.
    "work_weighted_power_of_model_watts", -- The weighted power consumption of the model based on its power consumption in Off and Sleep Modes and Long and Short Idle States.
    "category_2_functional_adder_allowances_kwh", -- The energy allowance provided by the ENERGY STAR specification for the model configuration tested as meeting Category 2 requirements, based on the Computer's other capabilities.  
    "comp_cat_i1_operating_system_name", -- The name of the operating system installed in the model configuration tested as meeting Category I1 requirements.
    "tc_long_idle_power_used_for_sleep_mode", -- Power measurements in Long Idle State can be used instead of Sleep Mode if below 10 watts.
    "comp_cat_i1_sleep_mode_watts", -- A low power mode that the computer enters automatically after a period of inactivity or by manual selection. A computer with Sleep capability can quickly “wake” in response to network connections or user interface devices with a latency of less than or equal to 5 seconds from initiation of wake event to system becoming fully usable including rendering of display.
    "comp_cat_i2_operating_system_name", -- The name of the operating system installed in the model configuration tested as meeting Category I2 requirements.
    "comp_cat_i2_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
    "comp_cat_0_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
    "comp_cat_0_physical_cpu_cores_count", -- The number of physical - not logical - CPU cores.
    "comp_cat_0_graphics_category", -- The processing capability of the discrete graphics card installed in the model configuration tested as meeting Category 0 requirements, with a higher 'G number' indicating higher performance.
    "category_1_system_memory_gb", -- The amount of memory installed in the model configuration tested as meeting Category 1 requirements.
    "category_1_long_idle_power_used_for_sleep_mode", -- Power measurements in Long Idle State can be used instead of Sleep Mode if below 10 watts.
    "comp_cat_i1_functional_adder_allowances_kwh", -- The energy allowance provided by the ENERGY STAR specification for the model configuration tested as meeting Category I1 requirements, based on the Computer's other capabilities.
    "comp_cat_d1_operating_system_name", -- The name of the operating system installed in the model configuration tested as meeting Category D1 requirements.
    "motherboard_form_factor_other", -- The product's motherboard form factor if not a listed industry standard size. 
    "product_thunderbolt_x_port_count", -- The number of Thunderbolt X ports in the product. Thunderbolt X is a placeholder for future versions of Thunderbolt and is not a specific Thunderbolt port type.
    "tc_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
    "category_2_system_memory_gb", -- The amount of memory installed in the model configuration tested as meeting Category 2 requirements.
    "tc_sleep_mode_watts", -- A low power mode that the computer enters automatically after a period of inactivity or by manual selection. A computer with Sleep capability can quickly “wake” in response to network connections or user interface devices with a latency of less than or equal to 5 seconds from initiation of wake event to system becoming fully usable including rendering of display.	
    "comp_cat_i2_off_mode_watts", -- The lowest power mode which cannot be switched off (influenced) by the user and that may persist for an indefinite time when the appliance is connected to the main electricity supply and used in accordance with the manufacturer’s instructions.
    "comp_cat_i2_sleep_mode_watts", -- A low power mode that the computer enters automatically after a period of inactivity or by manual selection. A computer with Sleep capability can quickly “wake” in response to network connections or user interface devices with a latency of less than or equal to 5 seconds from initiation of wake event to system becoming fully usable including rendering of display.
    "comp_cat_i2_short_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition, but the Display is on, and Long Idle power management features have not engaged.
    "comp_cat_i2_functional_adder_allowances_kwh", -- The energy allowance provided by the ENERGY STAR specification for the model configuration tested as meeting Category I2 requirements, based on the Computer's other capabilities.
    "comp_cat_i2_tec_of_model_kwh", -- Typical energy consumption of the model configuration tested as meeting Category I2 requirements.
    "comp_cat_d1_processor_name", -- The name of the central processing unit (CPU) installed in the model configuration tested as meeting Category D1 requirements.
    "comp_cat_d1_long_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition and the Display has entered a low-power state.
    "comp_cat_d1_functional_adder_allowances_kwh", -- The energy allowance provided by the ENERGY STAR specification for the model configuration tested as meeting Category D1 requirements, based on the Computer's other capabilities.
    "comp_cat_d2_processor_name", -- The name of the central processing unit (CPU) installed in the model configuration tested as meeting Category D2 requirements.
    "comp_cat_d2_operating_system_name", -- The name of the operating system installed in the model configuration tested as meeting Category D2 requirements.
    "comp_cat_d2_sleep_mode_watts", -- A low power mode that the computer enters automatically after a period of inactivity or by manual selection. A computer with Sleep capability can quickly “wake” in response to network connections or user interface devices with a latency of less than or equal to 5 seconds from initiation of wake event to system becoming fully usable including rendering of display.
    "comp_cat_d2_short_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition, but the Display is on, and Long Idle power management features have not engaged.
    "category_1_short_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition, but the Display is on, and Long Idle power management features have not engaged.
    "comp_cat_d2_functional_adder_allowances_kwh", -- The energy allowance provided by the ENERGY STAR specification for the model configuration tested as meeting Category D2 requirements, based on the Computer's other capabilities.
    "category_1_sleep_mode_watts", -- A low power mode that the computer enters automatically after a period of inactivity or by manual selection. A computer with Sleep capability can quickly “wake” in response to network connections or user interface devices with a latency of less than or equal to 5 seconds from initiation of wake event to system becoming fully usable including rendering of display.
    "comp_cat_d2_tec_of_model_kwh", -- Typical energy consumption of the model configuration tested as meeting Category D2 requirements.
    "tc_processor_name", -- The name of the central processing unit (CPU).
    "category_1_default_low_power_mode", -- The default power-saving mode used by the computer.
    "tc_short_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition, but the Display is on, and Long Idle power management features have not engaged.
    "model_name", -- An identifier assigned by the manufacturer or private labeler to a product or family/series of products for sales and marketing purposes.
    "work_processor_name", -- The name of the central processing unit (CPU).
    "brand_name", -- An identifier assigned by the manufacturer or private labeler to a product or family/series of products for sales and marketing purposes.
    "comp_cat_0_off_mode_watts", -- The lowest power mode which cannot be switched off (influenced) by the user and that may persist for an indefinite time when the appliance is connected to the main electricity supply and used in accordance with the manufacturer’s instructions. 
    "product_usb_x_x_10gb_s_port_count", -- The number of USB X.X ports with a speed greater than 10 Gb/s in the product. USB X.X represents a placeholder for future versions of USB and is not a specific USB port type. 
    "product_usb_3_x_10gb_s_port_count", -- The number of USB 3.X ports with a speed of 10 Gb/s in the product. 
    "work_operating_system_name", -- The name of the operating system.
    "comp_cat_0_processor_brand", -- The brand of the central processing unit (CPU) installed in the model configuration tested as meeting Category 0 requirements
    "will_the_speed_of_any_active_1_gb_s_or_higher_ethernet_network_", -- The date that the model is available for purchase.
    "work_hard_drives_count", -- The number of hard drives installed in the model configuration tested.
    "energy_star_partner", -- An organization that signed a Partnership Agreement with EPA to manufacture or private label ENERGY STAR qualified products.
    "comp_cat_d2_off_mode_watts", -- The lowest power mode which cannot be switched off (influenced) by the user and that may persist for an indefinite time when the appliance is connected to the main electricity supply and used in accordance with the manufacturer’s instructions.
    "energy_star_model_identifier", -- A unique string of characters assigned by certification bodies (CBs) to identify a model or set of models with the same performance characteristics. This identifier should remain the same for a model even if itis recertified to a new version of an ENERGY STAR specification. This string of characters is determined by CBs and is not the ENERGY STAR Unique ID assigned by EPA.
    "comp_cat_d1_base_tec_allowance_kwh", -- The energy allowance provided by the ENERGY STAR specification for the model configuration tested as meeting Category D1 requirements, based on the Computer's processor and graphics capabilities.
    "ethernet_capability", -- Does the product have an ethernet port?
    "comp_cat_i1_short_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition, but the Display is on, and Long Idle power management features have not engaged.
    "comp_cat_i1_processor_name", -- The name of the central processing unit (CPU) installed in the model configuration tested as meeting Category I1 requirements.
    "comp_cat_d1_processor_brand", -- The brand of the central processing unit (CPU) installed in the model configuration tested as meeting Category D1 requirements.
    "category_1_functional_adder_allowances_kwh", -- The energy allowance provided by the ENERGY STAR specification for the model configuration tested as meeting Category 1 requirements, based on the Computer's other capabilities.
    "category_1_off_mode_watts", -- The lowest power mode which cannot be switched off (influenced) by the user and that may persist for an indefinite time when the appliance is connected to the main electricity supply and used in accordance with the manufacturer’s instructions.
    "comp_cat_d2_long_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition and the Display has entered a low-power state.
    "category_1_processor_name", -- The name of the central processing unit (CPU) installed in the model configuration tested as meeting Category 1 requirements.
    "comp_cat_0_long_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition and the Display has entered a low-power state.	
    "additional_model_information", -- An identifier assigned by the manufacturer or private labeler to a product or family/series of products for sales and marketing purposes. This column includes alternative means to identify the model/model family (e.g., additional model names, additional model numbers, retailer SKUs, product descriptions).
    "tc_off_mode_watts", -- The lowest power mode which cannot be switched off (influenced) by the user and that may persist for an indefinite time when the appliance is connected to the main electricity supply and used in accordance with the manufacturer’s instructions. Note: In Computers 4.0 this field was labeled Standby. In Computers 5.2 this field is labeled Off.
    "tc_operating_system_name", -- The name of the operating system.
    "comp_cat_d1_short_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition, but the Display is on, and Long Idle power management features have not engaged.
    "product_dimm_count", -- The number of dual in-line memory modules (DIMMs) in the product. 
    "comp_cat_i1_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
    "category_2_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
    "work_long_idle_watts", -- The power state in which the operating system and other software have completed loading, a user profile has been created, activity is limited to those basic applications that the system starts by default, and the computer is not in Sleep Mode. Furthermore, the Computer has reached an Idle condition and the Display has entered a low-power state.
    "date_available_on_market", -- The date that the model is available for purchase.
    "comp_cat_i1_long_idle_power_used_for_sleep_mode", -- Power measurements in Long Idle State can be used instead of Sleep Mode if below 10 watts.
    "comp_cat_d1_system_memory_gb", -- The amount of memory installed in the model configuration tested as meeting Category D1 requirements.
    "markets", -- Includes products sold in the U.S. and/or Canada and other ENERGY STAR partner countries.
    "tc_system_memory_gb", -- The amount of memory installed in the model configuration tested as meeting Thin Clients requirements.
    "product_pciex1_slot_count", -- The number of PCI Express x 1 interface slots in the product. 
    "comp_cat_0_processor_name" -- The name of the central processing unit (CPU) installed in the model configuration tested as meeting Category 0 requirements.
FROM
    "energystar-gov/energy-star-certified-computers-j7nq-iepp:latest"."energy_star_certified_computers"
LIMIT 100;

sgr clone energystar-gov/energy-star-certified-computers-j7nq-iepp

sgr checkout energystar-gov/energy-star-certified-computers-j7nq-iepp:latest

sgr checkout --layered energystar-gov/energy-star-certified-computers-j7nq-iepp:latest