ENERGY STAR Certified Computers V9.0

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,
  "integrated_desktop_category" VARCHAR,
  "product_marketed_as_a_workstation" VARCHAR,
  "installed_npu" VARCHAR,
  "motherboard_form_factor" VARCHAR,
  "product_dimm_count" DOUBLE,
  "operating_system_name" VARCHAR,
  "processor_brand" VARCHAR,
  "processor_name" VARCHAR,
  "physical_cpu_cores_count" DOUBLE  -- Physical CPU Cores (count),
  "cpu_packages_count" BIGINT  -- CPU Packages (count),
  "cpu_base_clock_speed_ghz" DOUBLE  -- CPU Base Clock Speed (GHz),
  "cpu_maximum_clock_speed_ghz" DOUBLE  -- CPU Maximum Clock Speed (GHz),
  "system_memory_gb" BIGINT  -- System Memory (GB),
  "multi_channel_memory_support" VARCHAR,
  "capable_of_switchable_graphics" VARCHAR,
  "switchable_graphics_enabled_by_default_in_ac_mode" VARCHAR,
  "discrete_graphics_frame_buffer_bandwidth_gb_s" DOUBLE  -- Discrete Graphics Frame Buffer Bandwidth (GB/s),
  "discrete_graphics_frame_buffer_data_width_bits" DOUBLE  -- Discrete Graphics Frame Buffer Data Width (bits),
  "fast_ethernet_ports_count" DOUBLE  -- Fast Ethernet Ports (count),
  "gigabit_ethernet_ports_count" DOUBLE  -- Gigabit Ethernet Ports (count),
  "n_10_gigabit_ethernet_ports_count" DOUBLE  -- 10 Gigabit Ethernet Ports (count),
  "energy_efficient_ethernet_eee" VARCHAR  -- Energy Efficient Ethernet (EEE),
  "number_of_installed_storage_drives" DOUBLE,
  "number_of_integrated_displays_count" DOUBLE  -- Number Of Integrated Displays (count),
  "integrated_display_resolution_megapixels" DOUBLE  -- Integrated Display Resolution (megapixels),
  "integrated_display_viewable_screen_area_sq_in" DOUBLE  -- Integrated Display Viewable Screen Area (sq In),
  "enhanced_performance_display_present" VARCHAR,
  "integrated_display_diagonal_screen_size_in" DOUBLE  -- Integrated Display Diagonal Screen Size (in),
  "internal_power_supply_efficiency_at_10_load" DOUBLE  -- Internal Power Supply Efficiency At 10% Load,
  "internal_power_supply_efficiency_at_20_load" DOUBLE  -- Internal Power Supply Efficiency At 20% Load,
  "internal_power_supply_efficiency_at_50_load" DOUBLE  -- Internal Power Supply Efficiency At 50% Load,
  "internal_power_supply_efficiency_at_100_load" DOUBLE  -- Internal Power Supply Efficiency At 100% Load,
  "category_i1_1_internal_power_supply_efficiency_at_50_load" DOUBLE  -- Category I1/1 Internal Power Supply Efficiency At 50% Load,
  "category_i1_1_internal_power_supply_efficiency_at_100_load" DOUBLE  -- Category I1/1 Internal Power Supply Efficiency At 100% Load,
  "external_power_supply_rated_power_w" DOUBLE  -- External Power Supply Rated Power (W),
  "internal_power_supply_rated_power_w" DOUBLE  -- Internal Power Supply Rated Power (W),
  "mux_device" VARCHAR,
  "storage_technology" VARCHAR,
  "total_battery_capacity_watt_hours" DOUBLE  -- Total Battery Capacity (watt-hours),
  "default_low_power_mode" VARCHAR,
  "long_idle_power_used_for_sleep_mode" VARCHAR,
  "off_mode_watts" DOUBLE  -- Off Mode (watts),
  "sleep_mode_watts" DOUBLE  -- Sleep Mode (watts),
  "long_idle_watts" DOUBLE  -- Long Idle (watts),
  "short_idle_watts" DOUBLE  -- Short Idle (watts),
  "additional_measured_power_in_short_idle_at_115v_w" DOUBLE  -- Additional Measured Power In Short Idle At 115V (W),
  "base_tec_allowance_kwh" DOUBLE  -- Base TEC Allowance (kWh),
  "functional_adder_allowances_kwh" DOUBLE  -- Functional Adder Allowances (kWh),
  "tec_of_model_kwh" DOUBLE  -- TEC Of Model (kWh),
  "maximum_tec_requirements_etec_max_kwh" DOUBLE  -- Maximum TEC Requirements (Etec Max) (kWh),
  "ethernet_capability" VARCHAR,
  "touch_screen" VARCHAR,
  "sleep_mode_default_time_upon_shipment_min" DOUBLE  -- Sleep Mode Default Time Upon Shipment (min.),
  "display_sleep_mode_default_time_upon_shipment_min" DOUBLE  -- Display Sleep Mode Default Time Upon Shipment (min.),
  "wol_wake_on_lan_from_sleep" VARCHAR  -- WOL (Wake On LAN) From Sleep,
  "will_the_speed_of_any_active_1_gb_s_or_higher_ethernet_abbbefd6" VARCHAR  -- Will The Speed Of Any Active 1 GB/s Or Higher Ethernet Network Links Be Reduced To Less Than 1 GB/s When Transitioning To Sleep Or Off Mode?,
  "date_available_on_market" TIMESTAMP,
  "date_certified" TIMESTAMP,
  "markets" VARCHAR,
  "cb_model_identifier" VARCHAR
);