"energystar-gov/energy-star-certified-room-air-cleaners-jmck-i55n:latest"."energy_star_certified_room_air_cleaners"

SELECT
    ":id", -- Socrata column ID
    "need_module_for_network", -- Indicates if a module is needed to provide communication to enable entities outside the connected room air cleaner to provide energy consumption reporting to consumers and consumer-authorized energy use reporting third-parties.
    "meets_most_efficient_criteria", -- Indicates models meeting the Most Efficient criteria. The ENERGY STAR Most Efficient criteria recognizes the most efficient products among those that qualify for the ENERGY STAR. These exceptional products represent the leading edge in energy efficient products this year. For more information, please visit www.energystar.gov/mostefficient
    "additional_model_information", -- This column includes for the qualified model or family, family members, additional model names, model numbers and other identifying information associated with a product or family/series of products for sales and marketing purposes. Other identifying information includes, but is not limited to, SKUs, UPC codes, retail numbers, and/or descriptions of models included/not included in the reported Model Family.
    "date_available_on_market", -- The date that the model is available for purchase.
    "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.
    "date_qualified", -- The date on which the product was confirmed to meet the ENERGY STAR specification.
    "room_size_sq_ft", -- Room size in square feet is calculated by multiplying the Smoke CADR by 1.55 or by 0.144 for square meters. This room size formula is based on the CADR requirement to remove 80% of smoke particles, assuming one room air exchange per hour. 
    "dust_free_clean_air_delivery", -- The Rated Dust-Free Clean Air Delivery Rate or Dust CADR is the manufacturer-reported delivery of dust-free air produced by a household electric, cord-connected room air cleaner.
    "smoke_free_clean_air_delivery", -- The Rated Smoke-Free Clean Air Delivery Rate or Smoke CADR is the manufacturer-reported delivery of smoke-free air produced by a household electric, cord-connected room air cleaner.
    "dust_free_clean_air_delivery_1", -- The Dust-Free Clean Air Delivery Rate per Watt or Dust CADR/W is the energy efficiency metric for room air cleaners. More efficient units have higher Dust CADR/W.
    "smoke_free_clean_air_delivery_1", -- The Smoke-Free Clean Air Delivery Rate per Watt or Smoke CADR/W is the energy efficiency metric for room air cleaners. More efficient units have higher Smoke CADR/W.
    "pollen_free_clean_air_delivery_1", -- The Pollen-Free Clean Air Delivery Rate per Watt or Pollen CADR/W is the energy efficiency metric for room air cleaners. More efficient units have higher Pollen CADR/W.
    "partial_on_mode_power_watts", -- The average power in partial on mode, measured in Watts. Partial on mode includes standby and network connected power. 
    "filter_1_type", -- Indicates the primary type of filter, if the air cleaner has a filter. High-Efficiency Particulate Air filters or HEPA filters sometimes, also called True HEPA filters, have a minimum fractional particle removal efficiency of 99.97% for all particles of 0.3 μm diameter. Filters described as HEPA-Type or something other than “HEPA” or “True HEPA” have not demonstrated they meet the HEPA standard. Consumers should look to the product literature for documentation of the efficacy of these filters. 
    "replacement_model_number", -- A distinguishing identifier, usually alphanumeric, assigned to a replacement filter by the manufacturer.
    "filter_2_type", -- Indicates the secondary type of filter, if the air cleaner has more than one filter. High-Efficiency Particulate Air filters or HEPA filters sometimes, also called True HEPA filters, have a minimum fractional particle removal efficiency of 99.97% for all particles of 0.3 μm diameter. Filters described as HEPA-Type or something other than “HEPA” or “True HEPA” have not demonstrated they meet the HEPA standard. Consumers should look to the product literature for documentation of the efficacy of these filters. 
    "replacement_model_number_1", -- A distinguishing identifier, usually alphanumeric, assigned to a replacement filter by the manufacturer.
    "replacement_model_number_2", -- A distinguishing identifier, usually alphanumeric, assigned to a replacement filter by the manufacturer.
    "filter_4_type", -- Indicates the fourth type of filter, if the air cleaner has more than three filters. High-Efficiency Particulate Air filters or HEPA filters sometimes, also called True HEPA filters, have a minimum fractional particle removal efficiency of 99.97% for all particles of 0.3 μm diameter. Filters described as HEPA-Type or something other than “HEPA” or “True HEPA” have not demonstrated they meet the HEPA standard. Consumers should look to the product literature for documentation of the efficacy of these filters. 
    "replacement_model_number_3", -- A distinguishing identifier, usually alphanumeric, assigned to a replacement filter by the manufacturer.
    "network_capability", -- Indicates whether the model is able to connect to a network.
    "network_connection_types", -- Indicates which communication standards (e.g., Wi-Fi, Bluetooth, etc.) are offered.
    "cyber_security_and_or_privacy", -- Indicates all the standards and frameworks that apply for cyber security purposes.
    "markets", -- Includes products sold in the U.S. and/or Canada and other ENERGY STAR partner countries.
    "connected_functions", -- To be recognized as connected, a room air cleaner needs to include the base room air cleaner plus all elements (hardware, software) required to enable communication in response to consumer authorized energy related commands (not including third-party remote management which may be made available solely at the discretion of the manufacturer).
    "pollen_free_clean_air_delivery", -- The Rated Pollen-Free Clean Air Delivery Rate or Pollen CADR is the manufacturer-reported delivery of pollen-free air produced by a household electric, cord-connected room air cleaner.
    "ozone_emissions_ppb", -- The ozone emissions, measured in parts per billion.
    "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.
    "technology_types", -- Indicates the air cleaning technologies used by the room air cleaner, such as, fan and filter, fan with electrostatic plates, ion generator, and other technologies.
    "energy_star_partner", -- An organization that signed a Partnership Agreement with EPA to manufacture or private label ENERGY STAR qualified products.
    "annual_energy_use_kwh_year", -- This is the estimated annual energy use of the room air cleaner under typical conditions, including the energy used in active modes and partial on modes. It is calculated by multiplying the active mode hours by the smoke CADR divided by the smoke CADR/W and added to the inactive model hours multiplied by the partial on mode power. The active mode hours are assumed to be 5,840 hours per year and 2,920 for inactive mode hours, which is on average 16 hours active and 8 hours inactive per day. Actual energy consumption will vary depending on various factors such as the amount of usage in active mode and the settings chosen.
    "brand_name", -- An identifier assigned by the manufacturer or private labeler to a product or family/series of products for sales and marketing purposes.
    "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 it is 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.
    "model_name", -- An identifier assigned by the manufacturer or private labeler to a product or family/series of products for sales and marketing purposes.
    "model_number", -- A distinguishing, alphanumeric identifier, assigned to a product by the manufacturer or private labeler. The model number may include a wildcard that can be replaced by any letter or digit and still accurately capture what is covered by the model’s ENERGY STAR certification; an asterisk symbol (*) represents a letter, and a number symbol (#) a digit.
    "filter_3_type" -- Indicates the third type of filter, if the air cleaner has more than two filters. High-Efficiency Particulate Air filters or HEPA filters sometimes, also called True HEPA filters, have a minimum fractional particle removal efficiency of 99.97% for all particles of 0.3 μm diameter. Filters described as HEPA-Type or something other than “HEPA” or “True HEPA” have not demonstrated they meet the HEPA standard. Consumers should look to the product literature for documentation of the efficacy of these filters. 
FROM
    "energystar-gov/energy-star-certified-room-air-cleaners-jmck-i55n:latest"."energy_star_certified_room_air_cleaners"
LIMIT 100;

sgr mount socrata \
  "energystar-gov/energy-star-certified-room-air-cleaners-jmck-i55n" \
  --handler-options '{
    "domain": "data.energystar.gov",
    "tables": {
        "energy_star_certified_room_air_cleaners": "jmck-i55n"
    }
}'