ENERGY STAR Certified Large Network Equipment
U.S. Environmental Protection Agency
@usgov.epa_gov_energy_star_certified_large_network_equipment
U.S. Environmental Protection Agency
@usgov.epa_gov_energy_star_certified_large_network_equipment
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" DOUBLE,
"product_type" VARCHAR,
"product_classification" VARCHAR,
"product_characteristics" VARCHAR,
"single_lne_product" VARCHAR,
"modular_product_family" VARCHAR,
"end_user_configurable_power_management_features" VARCHAR,
"software_firmware_version" VARCHAR,
"connection_topology_used_during_variable_load_test" VARCHAR,
"model_number_of_compatible_modular_chassis_that_meet_e_76f59758" VARCHAR,
"maximum_number_modular_slots" DOUBLE,
"model_number_of_compatible_modular_modules_that_meet_e_b2f000ef" VARCHAR,
"min_power_config_model_number_or_config_id" VARCHAR,
"min_power_config_modular_chassis_name" VARCHAR,
"min_power_config_modular_chassis_model_number" VARCHAR,
"min_power_config_number_of_downlink_ports" DOUBLE,
"min_power_config_speed_of_downlink_ports" DOUBLE,
"min_power_config_downlink_port_type" VARCHAR,
"min_power_config_number_of_uplink_ports" DOUBLE,
"min_power_config_speed_of_uplink_ports" DOUBLE,
"min_power_config_uplink_port_type" VARCHAR,
"min_power_config_total_number_of_uplink_and_downlink_ports" DOUBLE,
"min_power_config_total_number_of_poe_ports_supported" VARCHAR,
"min_power_config_maximum_poe_class_supported" VARCHAR,
"min_power_config_max_total_poe_power_supported_w" VARCHAR,
"min_power_config_additional_built_in_interface_ports" VARCHAR,
"min_power_config_eee_capability_on_all_copper_ports" VARCHAR,
"min_power_config_redundant_power_supply" VARCHAR,
"min_power_config_power_supply_type" VARCHAR,
"min_power_config_power_supply_manufacturer" VARCHAR,
"min_power_config_power_supply_model_name" VARCHAR,
"min_power_config_power_supply_model_number" VARCHAR,
"min_power_config_power_supply_rated_output_w" DOUBLE,
"min_power_config_number_power_supplies" DOUBLE,
"min_power_config_number_of_psus_for_redundancy" DOUBLE,
"min_power_config_psu_80plus_certification_status" VARCHAR,
"min_power_config_test_voltage" VARCHAR,
"min_power_config_test_frequency" DOUBLE,
"min_power_config_variable_load_energy_efficiency_test" VARCHAR,
"min_power_config_full_port_maximum_non_drop_rate_gb_s" DOUBLE,
"min_power_config_full_port_full_load_throughput_applied_gb_s" DOUBLE,
"min_power_config_full_port_full_load_power_measured_watts" DOUBLE,
"min_power_config_full_port_30_percent_load_throughput__a46bc54c" DOUBLE,
"min_power_config_full_port_30_percent_load_power_measu_fec1db45" DOUBLE,
"min_power_config_full_port_very_low_util_throughput_ap_5b0a430b" DOUBLE,
"min_power_config_full_port_very_low_util_power_measured_watts" DOUBLE,
"min_power_config_half_port_maximum_non_drop_rate_gb_s" VARCHAR,
"min_power_config_half_port_full_load_throughput_applied_gb_s" VARCHAR,
"min_power_config_half_port_full_load_power_measured_watts" VARCHAR,
"min_power_config_half_port_30_percent_load_throughput__3c769d3f" VARCHAR,
"min_power_config_half_port_30_percent_load_power_measu_1520af0f" VARCHAR,
"min_power_config_half_port_very_low_util_throughput_ap_5f18ef17" VARCHAR,
"min_power_config_half_port_very_low_util_power_measured_watts" DOUBLE,
"min_power_config_modular_maximum_non_drop_rate_gb_s" VARCHAR,
"min_power_config_modular_full_load_throughput_applied_gb_s" VARCHAR,
"min_power_config_modular_full_load_power_measured_watts" VARCHAR,
"min_power_config_modular_30_percent_load_throughput_ap_ffb3ee29" VARCHAR,
"min_power_config_modular_30_percent_load_power_measured_watts" VARCHAR,
"min_power_config_modular_very_low_util_throughput_applied_gb_s" VARCHAR,
"min_power_config_modular_very_low_util_power_measured_watts" VARCHAR,
"min_power_config_modular_maximum_non_drop_rate_for_mut_1_gb_s" VARCHAR,
"min_power_config_modular_maximum_non_drop_rate_for_mut_2_gb_s" VARCHAR,
"min_power_config_modular_maximum_non_drop_rate_for_mut_3_gb_s" VARCHAR,
"min_power_config_modular_maximum_non_drop_rate_for_mut_4_gb_s" VARCHAR,
"min_power_config_modular_maximum_non_drop_rate_for_mut_5_gb_s" VARCHAR,
"min_power_config_modular_maximum_non_drop_rate_for_mut_6_gb_s" DOUBLE,
"min_power_config_modular_aggregate_maximum_throughput_gb_s" DOUBLE,
"min_power_config_module_1_model_name" VARCHAR,
"min_power_config_module_1_model_number" VARCHAR,
"min_power_config_module_2_model_name" VARCHAR,
"min_power_config_module_2_model_number" VARCHAR,
"min_power_config_module_3_model_name" VARCHAR,
"min_power_config_module_3_model_number" VARCHAR,
"min_power_config_module_4_model_name" VARCHAR,
"min_power_config_module_4_model_number" VARCHAR,
"min_power_config_module_5_model_name" VARCHAR,
"min_power_config_module_5_model_number" VARCHAR,
"min_power_config_module_6_model_name" VARCHAR,
"min_power_config_module_6_model_number" VARCHAR,
"max_power_config_model_number_or_config_id" VARCHAR,
"max_power_config_modular_chassis_name" VARCHAR,
"max_power_config_modular_chassis_model_number" VARCHAR,
"max_power_config_number_of_downlink_ports" DOUBLE,
"max_power_config_speed_of_downlink_ports" DOUBLE,
"max_power_config_downlink_port_type" VARCHAR,
"max_power_config_number_of_uplink_ports" DOUBLE,
"max_power_config_speed_of_uplink_ports" DOUBLE,
"max_power_config_uplink_port_type" VARCHAR,
"max_power_config_total_number_of_uplink_and_downlink_ports" DOUBLE,
"max_power_config_total_number_of_poe_ports_supported" VARCHAR,
"max_power_config_maximum_poe_class_supported" VARCHAR,
"max_power_config_max_total_poe_power_supported_w" VARCHAR,
"max_power_config_additional_built_in_interface_ports" VARCHAR,
"max_power_config_eee_capability_on_all_copper_ports" VARCHAR
);
Anyone who has the link will be able to view this.