Query the Data Delivery Network
Query the DDNThe easiest way to query any data on Splitgraph is via the "Data Delivery Network" (DDN). The DDN is a single endpoint that speaks the PostgreSQL wire protocol. Any Splitgraph user can connect to it at data.splitgraph.com:5432 and query any version of over 40,000 datasets that are hosted or proxied by Splitgraph.
For example, you can query the energy_star_certified_computers table in this repository, by referencing it like:
"energystar-gov/energy-star-certified-computers-j7nq-iepp:latest"."energy_star_certified_computers"or in a full query, like:
SELECT
":id", -- Socrata column ID
"comp_cat_i1_physical_cpu_cores_count", -- The number of physical - not logical - CPU cores.
"tc_processor_brand", -- The name of the central processing unit (CPU).
"comp_cat_i1_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
"comp_cat_i2_system_memory_gb", -- The amount of memory installed in the model configuration tested as meeting Category I2 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.
"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.
"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_0_system_memory_gb", -- The amount of memory installed in the model configuration tested as meeting Category 0 requirements.
"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).
"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", -- The industry standard form factor of the motherboard in the product.
"comp_cat_d2_default_low_power_mode", -- The default power-saving mode used by the computer.
"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.
"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.
"category_1_tec_of_model_kwh", -- Typical energy consumption of 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_system_memory_gb", -- The amount of memory installed in the model configuration tested as meeting Category 1 requirements.
"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.
"category_2_tec_of_model_kwh", -- Typical energy consumption of the model configuration tested as meeting Category 2 requirements.
"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_0_operating_system_name", -- The name of the operating system installed in the model configuration tested as meeting Category 0 requirements.
"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.
"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_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_i2_default_low_power_mode", -- The default power-saving mode used by the computer.
"product_sata_express_port_count", -- The number of SATA Express ports in the product.
"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_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_brand", -- The brand of the central processing unit (CPU) installed in the model configuration tested as meeting Category D2 requirements.
"comp_cat_i1_system_memory_gb", -- The amount of memory installed in the model configuration tested as meeting Category I1 requirements.
"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.
"comp_cat_d2_tec_of_model_kwh", -- Typical energy consumption of the model configuration tested as meeting Category D2 requirements.
"product_m_2_except_key_m_port_count", -- The number of M.2 ports in the product, excluding Key M type M.2 ports.
"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.
"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.
"date_available_on_market", -- The date that the model is available for purchase.
"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.
"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.
"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.
"multi_channel_memory_support", -- Does the product support multi-channel memory functionality?
"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.
"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.
"work_processor_name", -- The name of the central processing unit (CPU).
"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.
"comp_cat_i2_physical_cpu_cores_count", -- The number of physical - not logical - CPU cores.
"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.
"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.
"work_hard_drives_count", -- The number of hard drives installed in the model configuration tested.
"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.
"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.
"tc_tec_of_model_kwh", -- Typical energy consumption of a model.
"tc_tec_requirement_kwh", -- The energy allowance provided by the ENERGY STAR specification.
"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.
"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_pciex16_slot_count", -- The number of PCI Express x 16 interface slots in the product.
"product_thunderbolt_3_port_count", -- The number of Thunderbolt 3 ports in the product.
"tc_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
"product_pciex8_slot_count", -- The number of PCI Express x 8 interface slots in the product.
"product_m_2_key_m_port_count", -- The number of Key M type M.2 ports in the product.
"comp_cat_i2_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
"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_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_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_default_low_power_mode", -- The default power-saving mode used by the computer.
"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.
"product_dimm_count", -- The number of dual in-line memory modules (DIMMs) in the product.
"product_thunderbolt_port_count", -- The number of Thunderbolt ports in the product.
"comp_cat_d2_physical_cpu_cores_count", -- The number of physical - not logical - CPU cores.
"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_system_memory_gb", -- The amount of memory installed in the model configuration tested as meeting Category D2 requirements.
"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.
"ethernet_capability", -- Does the product have an ethernet port?
"product_usb_2_0_port_count", -- The number of USB 2.0 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_sata_and_esata_port_count", -- The number of SATA and eSATA ports in the product.
"category_1_processor_brand", -- The brand of the central processing unit (CPU) installed in the model configuration tested as meeting Category 1 requirements.
"work_system_memory_gb", -- The amount of memory installed in the model configuration tested.
"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.
"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_0_tec_of_model_kwh", -- Typical energy consumption of the model configuration tested as meeting Category 0 requirements.
"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.
"date_qualified", -- The date on which the product was confirmed to meet the ENERGY STAR specification.
"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.
"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.
"comp_cat_d2_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
"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.
"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.
"model_number", -- A distinguishing identifier, usually alphanumeric, assigned to a product by the manufacturer or private labeler.
"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.
"category_2_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
"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.
"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.
"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.
"comp_cat_0_default_low_power_mode", -- The default power-saving mode used by the computer.
"motherboard_form_factor_other", -- The product's motherboard form factor if not a listed industry standard size.
"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.
"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.
"category_2_default_low_power_mode", -- The default power-saving mode used by the computer.
"tc_operating_system_name", -- The name of the operating system.
"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.
"tc_processor_name", -- The name of the central processing unit (CPU).
"will_the_speed_of_any_active_1_gb_s_or_higher_ethernet_network_", -- The date that the model is available for purchase.
"markets", -- Includes products sold in the U.S. and/or Canada and other ENERGY STAR partner countries.
"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.
"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.
"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.
"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.
"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.
"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_operating_system_name", -- The name of the operating system 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.
"comp_cat_i2_tec_of_model_kwh", -- Typical energy consumption of the model configuration tested as meeting Category I2 requirements.
"category_2_system_memory_gb", -- The amount of memory installed in 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
"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_i1_operating_system_name", -- The name of the operating system installed in the model configuration tested as meeting Category I1 requirements.
"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_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.
"comp_cat_i1_tec_of_model_kwh", -- Typical energy consumption of the model configuration tested as meeting Category I1 requirements.
"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_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.
"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_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_d1_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
"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.
"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_i2_processor_name", -- The name of the central processing unit (CPU) installed in the model configuration tested as meeting Category I2 requirements.
"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_physical_cpu_cores_count", -- The number of physical - not logical - CPU cores.
"category_1_default_low_power_mode", -- The default power-saving mode used by the computer.
"comp_cat_0_physical_cpu_cores_count", -- The number of physical - not logical - CPU cores.
"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_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.
"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.
"comp_cat_0_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
"product_thunderbolt_2_port_count", -- The number of Thunderbolt 2 ports in the product.
"wlan_capability", -- Does the product have integrated wireless 802.11 support?
"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.
"work_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
"energy_star_partner", -- An organization that signed a Partnership Agreement with EPA to manufacture or private label ENERGY STAR qualified products.
"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_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.
"work_processor_brand", -- The brand of the central processing unit (CPU).
"model_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_d1_processor_brand", -- The brand of the central processing unit (CPU) installed in the model configuration tested as meeting Category D1 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_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.
"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.
"tc_system_memory_gb", -- The amount of memory installed in the model configuration tested as meeting Thin Clients requirements.
"touch_screen", -- If "Yes", the model includes a touch screen.
"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.
"comp_cat_d1_physical_cpu_cores_count", -- The number of physical - not logical - CPU cores.
"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_0_processor_name", -- The name of the central processing unit (CPU) installed in the model configuration tested as meeting Category 0 requirements.
"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.
"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_i1_default_low_power_mode", -- The default power-saving mode used by the computer.
"category_1_operating_system_name", -- The name of the operating system installed in the model configuration tested as meeting Category 1 requirements.
"category_1_base_processor_speed_per_core_ghz", -- The minimum processing speed of the central processing unit (CPU).
"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_d1_processor_name", -- The name of the central processing unit (CPU) installed in the model configuration tested as meeting Category D1 requirements.
"product_pciex1_slot_count", -- The number of PCI Express x 1 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.
"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_pciex4_slot_count", -- The number of PCI Express x 4 interface slots in the product.
"bluetooh_capability", -- Does the product have integrated Bluetooth support?
"work_operating_system_name", -- The name of the operating system.
"comp_cat_d1_tec_of_model_kwh", -- Typical energy consumption of the model configuration tested as meeting Category D1 requirements.
"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_0_processor_brand", -- The brand of the central processing unit (CPU) installed in the model configuration tested as meeting Category 0 requirements
"category_1_processor_name", -- The name of the central processing unit (CPU) installed in the model configuration tested as meeting Category 1 requirements.
"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_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.
FROM
"energystar-gov/energy-star-certified-computers-j7nq-iepp:latest"."energy_star_certified_computers"
LIMIT 100;Connecting to the DDN is easy. All you need is an existing SQL client that can connect to Postgres. As long as you have a SQL client ready, you'll be able to query energystar-gov/energy-star-certified-computers-j7nq-iepp with SQL in under 60 seconds.
Query Your Local Engine
Install Splitgraph Locally
bash -c "$(curl -sL https://github.com/splitgraph/splitgraph/releases/latest/download/install.sh)"Read the installation docs.
Splitgraph Cloud is built around Splitgraph Core (GitHub), which includes a local Splitgraph Engine packaged as a Docker image. Splitgraph Cloud is basically a scaled-up version of that local Engine. When you query the Data Delivery Network or the REST API, we mount the relevant datasets in an Engine on our servers and execute your query on it.
It's possible to run this engine locally. You'll need a Mac, Windows or Linux system to install sgr, and a Docker installation to run the engine. You don't need to know how to actually use Docker; sgrcan manage the image, container and volume for you.
There are a few ways to ingest data into the local engine.
For external repositories, the Splitgraph Engine can "mount" upstream data sources by using sgr mount. This feature is built around Postgres Foreign Data Wrappers (FDW). You can write custom "mount handlers" for any upstream data source. For an example, we blogged about making a custom mount handler for HackerNews stories.
For hosted datasets (like this repository), where the author has pushed Splitgraph Images to the repository, you can "clone" and/or "checkout" the data using sgr cloneand sgr checkout.
Cloning Data
Because energystar-gov/energy-star-certified-computers-j7nq-iepp:latest is a Splitgraph Image, you can clone the data from Spltgraph Cloud to your local engine, where you can query it like any other Postgres database, using any of your existing tools.
First, install Splitgraph if you haven't already.
Clone the metadata with sgr clone
This will be quick, and does not download the actual data.
sgr clone energystar-gov/energy-star-certified-computers-j7nq-ieppCheckout the data
Once you've cloned the data, you need to "checkout" the tag that you want. For example, to checkout the latest tag:
sgr checkout energystar-gov/energy-star-certified-computers-j7nq-iepp:latestThis will download all the objects for the latest tag of energystar-gov/energy-star-certified-computers-j7nq-iepp and load them into the Splitgraph Engine. Depending on your connection speed and the size of the data, you will need to wait for the checkout to complete. Once it's complete, you will be able to query the data like you would any other Postgres database.
Alternatively, use "layered checkout" to avoid downloading all the data
The data in energystar-gov/energy-star-certified-computers-j7nq-iepp:latest is 0 bytes. If this is too big to download all at once, or perhaps you only need to query a subset of it, you can use a layered checkout.:
sgr checkout --layered energystar-gov/energy-star-certified-computers-j7nq-iepp:latestThis will not download all the data, but it will create a schema comprised of foreign tables, that you can query as you would any other data. Splitgraph will lazily download the required objects as you query the data. In some cases, this might be faster or more efficient than a regular checkout.
Read the layered querying documentation to learn about when and why you might want to use layered queries.
Query the data with your existing tools
Once you've loaded the data into your local Splitgraph Engine, you can query it with any of your existing tools. As far as they're concerned, energystar-gov/energy-star-certified-computers-j7nq-iepp is just another Postgres schema.