"ny-gov/rsbs-mom-part-2-of-2-new-york-state-residential-hc4z-b2p5:latest"."rsbs_mom_part_2_of_2_new_york_state_residential"

SELECT
    ":id", -- Socrata column ID
    "common_area_laundry", -- Presence of laundry in common area of the multifamily property [Yes; No; Don't know]
    "building_efficiency_leed", -- LEED certified building or buildings at the multifamily property [Not mentioned; Mentioned; Don't know]
    "number_of_all_in_one_printers", -- Number of combination printer/copier/scanner/fax machines available for tenant use or used in the business office at the multifamily property [0-75; Don't know]
    "number_of_laptops", -- Number of laptop computers available for tenant use or used in the business office at the multifamily property [0-75; Don't know]
    "number_of_clothes_washers_in_common_area_laundry", -- Number of clothes washers in the common area of the multifamily property if "Common Area Laundry" is "Yes" [0-150; Don't know; Programmed skip]
    "building_efficiency_energy_star", -- ENERGY STAR® qualified building or buildings at the multifamily property [Not mentioned; Mentioned; Don't know]
    "familiarity_with_energy_star", -- Equipment having the ENERGY STAR® logo meets strict energy efficiency guidelines set by the U.S. Environmental Protection Agency and the U.S. Department of Energy. Level of familiarity with ENERGY STAR® or the ENERGY STAR logo® before the survey [Very familiar; somewhat familiar; Not at all familiar]
    "energy_efficient_equipment_policy", -- Policy that specifies that energy efficient equipment should be purchased when purchasing new equipment such as appliances, heating and cooling systems, and lighting for multifamily properties [Yes; No; Don't know; Refused]
    "sources_for_real_estate_information_none", -- No sources used for real estate management and industry information [Not mentioned; Mentioned; Don't know]
    "sources_for_real_estate_information_word_of_mouth", -- Word of mouth as a source used for real estate management and industry information [Not mentioned; Mentioned; Don't know]
    "sources_for_real_estate_information_tradeshows", -- Tradeshows as a source used for real estate management and industry information [Not mentioned; Mentioned; Don't know]
    "sources_for_real_estate_information_government_regulations", -- Government regulations as a source used for real estate management and industry information [Not mentioned; Mentioned; Don't know]
    "sources_for_real_estate_information_industry_publications", -- Real estate or trade publications, magazines, or newspapers as a source used for real estate management and industry information [Not mentioned; Mentioned; Don't know]
    "sources_for_energy_information_other", -- Some other source as a typical source of research done by respondent if "Researched Energy Information" is "Yes" [Not mentioned; Mentioned; Don't know; Refused]
    "sources_for_energy_information_new_york_city", -- New York City information as a typical source of research done by respondent if "Researched Energy Information" is "Yes" [Not mentioned; Mentioned; Don't know; Refused]
    "importance_equipment_value", -- Level of importance of the resiliency, quality, and durability of the equipment when evaluating types of energy-using equipment on a scale of one to five with one being "not at all important" and five being "very important" [1-5]
    "importance_supplier_recommendation", -- Level of importance of the recommendation of a contractor or supplier when evaluating types of energy-using equipment on a scale of one to five with one being "not at all important" and five being "very important" [1-5]
    "average_age_of_clothes_dryers", -- Age of the majority of clothes dryers in the common area of the multifamily property if "Number of Clothes Dryers in Common Area Laundry" is "1-100" [0-100; Don't know; Programmed skip]
    "ownership_of_laundry_machines", -- Ownership of laundry machines (e.g. clothes washers and/or clothes dryers) if "Common Area Laundry" is "Yes" [ Own all; Own some and lease some; Lease all; Don't know; Programmed skip]
    "sources_for_energy_information_new_york_state", -- New York State information as a typical source of research done by respondent if "Researched Energy Information" is "Yes" [Not mentioned; Mentioned; Don't know; Refused]
    "efficiency_improvement_needed_doors", -- Energy efficiency improvements are needed for the doors at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "common_area_efficiency_improvement_appliances", -- Energy efficiency improvements have been made to the appliances of the common areas at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "common_area_efficiency_improvement_cooling", -- Energy efficiency improvements have been made to the cooling equipment of the common areas at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "tenant_laundry_payment", -- Inclusion of laundry payment within tenants' rent [Tenant pays for laundry; Laundry included in rent; Programmed skip]
    "sources_for_energy_information_national_fuel", -- National Fuel as a typical source of research done by respondent if "Researched Energy Information" is "Yes" [Not mentioned; Mentioned; Don't know; Refused]
    "electric_utility", -- Electric utility [Central Hudson; ConEd; LIPA; National Grid; NYSEG; RG&E]
    "sources_for_energy_information_suppliers", -- Suppliers as a typical source of research done by respondent if "Researched Energy Information" is "Yes" [Not mentioned; Mentioned; Don't know; Refused] 
    "number_of_clothes_dryers_in_common_area_laundry", -- Number of clothes dryers in the common area of the multifamily property if "Common Area Laundry" is "Yes" [0-100; Don't know; Programmed skip]
    "sources_for_real_estate_information_web_search", -- Web search as a source used for real estate management and industry information [Not mentioned; Mentioned; Don't know]
    "efficiency_program_past_5_years_water_heating", -- Respondent has participated in water heating equipment energy efficiency/saving programs in the past five years if "Participated in Efficiency Program Past 5 Years" is "Yes" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "sources_for_energy_information_word_of_mouth", -- Word of mouth as a typical source of research done by respondent if "Researched Energy Information" is "Yes" [Not mentioned; Mentioned; Don't know; Refused]
    "importance_tenant_dissatisfaction", -- Level of importance of tenant dissatisfaction with current conditions when evaluating types of energy-using equipment on a scale of one to five with one being "not at all important" and five being "very important" [1-5]
    "importance_initial_cost", -- Level of importance of the initial purchase cost when evaluating types of energy-using equipment on a scale of one to five with one being "not at all important" and five being "very important" [1-5]
    "sources_for_energy_information_tradeshows", -- Tradeshows as a typical source of research done by respondent if "Researched Energy Information" is "Yes" [Not mentioned; Mentioned; Don't know; Refused]
    "sources_for_energy_information_leed", -- LEED as a typical source of research done by respondent if "Researched Energy Information" is "Yes" [Not mentioned; Mentioned; Don't know; Refused]
    "sources_for_energy_information_general_web_search", -- General web search as a form of research typically done by respondent if "Researched Energy Information" is "Yes" [Not mentioned; Mentioned; Don't know; Refused]
    "researched_energy_information", -- Whether or not the respondent has ever researched or looked for energy-related information [Yes; No; Don't know]
    "non_improvement_other", -- Reason for not making needed energy efficiency improvements is something else if "Efficiency Improvement Needed - None" is "Not mentioned" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "efficiency_program_past_5_years_other", -- Respondent has participated in some other energy efficiency/saving programs in the past five years if "Participated in Efficiency Program Past 5 Years" is "Yes" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "efficiency_program_past_5_years_energy_star_homes", -- Respondent has participated in ENERGY STAR® homes energy efficiency/saving programs in the past five years if "Participated in Efficiency Program Past 5 Years" is "Yes" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "efficiency_program_past_5_years_multifamily_performance", -- Respondent has participated in Multifamily Performance program energy efficiency/saving programs in the past five years if "Participated in Efficiency Program Past 5 Years" is "Yes" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "efficiency_program_past_5_years_natural_gas_conversion", -- Respondent has participated in natural gas conversion energy efficiency/saving programs in the past five years if "Participated in Efficiency Program Past 5 Years" is "Yes" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "efficiency_program_past_5_years_lighting", -- Respondent has participated in lighting energy efficiency/saving programs in the past five years if "Participated in Efficiency Program Past 5 Years" is "Yes" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "efficiency_program_past_5_years_energy_audit", -- Respondent has participated in energy audit energy efficiency/saving programs in the past five years if "Participated in Efficiency Program Past 5 Years" is "Yes" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "efficiency_program_past_5_years_weatherization", -- Respondent has participated in windows, doors, and weatherization energy efficiency/saving programs in the past five years if "Participated in Efficiency Program Past 5 Years" is "Yes" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "efficiency_program_past_5_years_appliances", -- Respondent has participated in appliances energy efficiency/saving programs in the past five years if "Participated in Efficiency Program Past 5 Years" is "Yes" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "efficiency_program_past_5_years_hvac", -- Respondent has participated in HVAC energy efficiency/saving programs in the past five years if "Participated in Efficiency Program Past 5 Years" is "Yes" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "gas_utility", -- Gas utility of the single family case from which multifamily data originated [e.g., Ambit New York - Rochester Gas & Electric Corporation]
    "participated_in_efficiency_program_past_5_years", -- Participation in any energy efficiency or energy saving programs offered by NYSERDA or utilities within the past five years  [Not mentioned; Mentioned; Don't know; Programmed skip]
    "number_of_desktops", -- Number of desktop computers available for tenant use or used in the business office at the multifamily property [0-75; Don't know]
    "preferred_promotion_billboard_ad", -- Respondent prefers to learn about energy efficiency programs through a billboard ad  [Not mentioned; Mentioned; Don't know; Programmed skip]
    "preferred_promotion_subway_ad", -- Respondent prefers to learn about energy efficiency programs a subway ad  [Not mentioned; Mentioned; Don't know; Programmed skip]
    "preferred_promotion_independent_contractor", -- Respondent prefers to learn about energy efficiency programs through an independent contractor  [Not mentioned; Mentioned; Don't know; Programmed skip]
    "preferred_promotion_direct_mail_from_utility", -- Respondent prefers to learn about energy efficiency programs through direct mailing from utilities  [Not mentioned; Mentioned; Don't know; Programmed skip]
    "preferred_promotion_website", -- Respondent prefers to learn about energy efficiency programs from a website  [Not mentioned; Mentioned; Don't know; Programmed skip]
    "common_area_efficiency_improvement_windows", -- Energy efficiency improvements have been made to the windows of the common areas at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "non_improvement_intrusive", -- Reason for not making needed energy efficiency improvements is that they are too intrusive if "Efficiency Improvement Needed - None" is "Not mentioned" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "sources_for_real_estate_information_professional_organizations", -- Real estate organizations, trade associations, or management companies as a source used for real estate management and industry information [Not mentioned; Mentioned; Don't know]
    "efficiency_program_past_5_years_thermostats", -- Respondent has participated in thermostats energy efficiency/saving programs in the past five years if "Participated in Efficiency Program Past 5 Years" is "Yes" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "common_area_efficiency_improvement_doors", -- Energy efficiency improvements have been made to the doors of the common areas at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "efficiency_decisions_corporate", -- Corporate of the multifamily property involved in making the decision to install energy efficient equipment in the common areas and tenant units 
    "number_of_individual_printers", -- Number of individual printers available for tenant use or used in the business office at the multifamily property [0-75; Don't know]
    "preferred_promotion_utility_bill_insert", -- Respondent prefers to learn about energy efficiency programs from a utility bill insert  [Not mentioned; Mentioned; Don't know; Programmed skip]
    "preferred_promotion_property_owner", -- Respondent prefers to learn about energy efficiency programs through the property owner  [Not mentioned; Mentioned; Don't know; Programmed skip]
    "common_area_efficiency_improvement_water_conservation", -- Energy efficiency improvements have been made to the water saving devices of the common areas at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "preferred_promotion_phone", -- Respondent prefers to learn about energy efficiency programs over the phone  [Not mentioned; Mentioned; Don't know; Programmed skip]
    "efficiency_program_past_5_years_water_conservation", -- Respondent has participated in water saving devices energy efficiency/saving programs in the past five years if "Participated in Efficiency Program Past 5 Years" is "Yes" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "sources_for_energy_information_consultants_contractors", -- Consultants and contractors as a typical source of research done by respondent if "Researched Energy Information" is "Yes" [Not mentioned; Mentioned; Don't know; Refused]
    "sources_for_energy_information_utilities", -- Utility (NYSERDA, ConEd, LIPA, National Grid, Central Hudson, PSE&G) information used as a form of research typically done by respondent if "Researched Energy Information" is "Yes" [Not mentioned; Mentioned; Don't know; Refused]
    "building_efficiency_zero_net_energy", -- Zero net energy building or buildings at the multifamily property [Not mentioned; Mentioned; Don't know]
    "building_efficiency_none", -- Building or buildings at the multifamily property are not classified or rated for their energy efficiency [Not mentioned; Mentioned; Don't know]
    "number_of_crt_computer_monitors", -- Number of CRT computer monitors available for tenant use or used in the business office at the multifamily property [0-75; Don't know]
    "importance_operating_cost", -- Level of importance of the operating cost when evaluating types of energy-using equipment on a scale of one to five with one being "not at all important" and five being "very important" [1-5]
    "non_improvement_in_process", -- Reason for not making needed energy efficiency improvements is that the property is in the process now if "Efficiency Improvement Needed - None" is "Not mentioned" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "preferred_promotion_utility_account_manager", -- Respondent prefers to learn about energy efficiency programs through their utility account manager  [Not mentioned; Mentioned; Don't know; Programmed skip]
    "preferred_promotion_apartment_association", -- Respondent prefers to learn about energy efficiency programs through the Apartment association  [Not mentioned; Mentioned; Don't know; Programmed skip]
    "preferred_promotion_personal_explanation", -- Respondent prefers to learn about energy efficiency programs by someone coming to tell them and explain the program  [Not mentioned; Mentioned; Don't know; Programmed skip]
    "awareness_unknown", -- Respondent is unable to name any specific energy efficiency programs if "Awareness of Efficiency Programs" is "Yes [e.g., Which ones?]" [Not mentioned; Mentioned; Programmed skip]
    "awareness_thermostats", -- Respondent awareness of thermostats energy efficiency programs if "Awareness of Efficiency Programs" is "Yes [e.g., Which ones?]" [Not mentioned; Mentioned; Programmed skip]
    "awareness_water_conservation", -- Respondent awareness of water saving devices energy efficiency programs if "Awareness of Efficiency Programs" is "Yes [e.g., Which ones?]" [Not mentioned; Mentioned; Programmed skip]
    "awareness_energy_star_homes", -- Respondent awareness of ENERGY STAR® homes energy efficiency programs if "Awareness of Efficiency Programs" is "Yes [e.g., Which ones?]" [Not mentioned; Mentioned; Programmed skip]
    "efficiency_improvement_needed_none", -- No energy efficiency improvements are needed at the multifamily property  [Not mentioned; Mentioned; Don't know; Refused] 
    "awareness_weatherization", -- Respondent awareness of windows, doors, and weatherization energy efficiency programs if "Awareness of Efficiency Programs" is "Yes [e.g., Which ones?]" [Not mentioned; Mentioned; Programmed skip]
    "awareness_natural_gas_conversion", -- Respondent awareness of natural gas conversion energy efficiency programs if "Awareness of Efficiency Programs" is "Yes [e.g., Which ones?]" [Not mentioned; Mentioned; Programmed skip]
    "common_area_efficiency_improvement_lighting", -- Energy efficiency improvements have been made to the lighting of the common areas at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "common_area_efficiency_improvement_none", -- No energy efficiency improvements have been made to the common areas at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "awareness_water_heating", -- Respondent awareness of water heating equipment energy efficiency programs if "Awareness of Efficiency Programs" is "Yes [e.g., Which ones?]" [Not mentioned; Mentioned; Programmed skip]
    "common_area_efficiency_improvement_insulation", -- Energy efficiency improvements have been made to the insulation of the common areas at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "preferred_promotion_email", -- Respondent prefers to learn about energy efficiency programs via email  [Not mentioned; Mentioned; Don't know; Programmed skip]
    "awareness_lighting", -- Respondent awareness of lighting energy efficiency programs if "Awareness of Efficiency Programs" is "Yes [e.g., Which ones?]" [Not mentioned; Mentioned; Programmed skip]
    "awareness_energy_audit", -- Respondent awareness of energy audit energy efficiency programs if "Awareness of Efficiency Programs" is "Yes [e.g., Which ones?]" [Not mentioned; Mentioned; Programmed skip]
    "awareness_appliances", -- Respondent awareness of appliances energy efficiency programs if "Awareness of Efficiency Programs" is "Yes [e.g., Which ones?]" [Not mentioned; Mentioned; Programmed skip]
    "preferred_promotion_other", -- Respondent prefers to learn about energy efficiency programs from some other source  [Not mentioned; Mentioned; Don't know; Programmed skip]
    "awareness_hvac", -- Respondent awareness of HVAC energy efficiency programs if "Awareness of Efficiency Programs" is "Yes [e.g., Which ones?]" [Not mentioned; Mentioned; Programmed skip]
    "importance_societal_pressure", -- Level of importance of the societal pressure to purchase equipment that is environmentally friendly when evaluating types of energy-using equipment on a scale of one to five with one being "not at all important" and five being "very important" [1-5]
    "efficiency_decisions_other", -- Other employee or stakeholder of the multifamily property involved in making the decision to install energy efficient equipment in the common areas and tenant units [Not mentioned; Mentioned; Refused] 
    "importance_raising_price", -- Level of importance of the ability to charge a higher rent for a more comfortable property when evaluating types of energy-using equipment on a scale of one to five with one being "not at all important" and five being "very important" [1-5]
    "importance_peer_recommendation", -- Level of importance of the recommendations of others that had experience with the equipment when evaluating types of energy-using equipment on a scale of one to five with one being "not at all important" and five being "very important" [1-5]
    "importance_efficiency", -- Level of importance of the efficiency level of the equipment when evaluating types of energy-using equipment on a scale of one to five with one being "not at all important" and five being "very important" [1-5]
    "importance_payback_period", -- Level of importance of the length of the payback period when evaluating types of energy-using equipment on a scale of one to five with one being "not at all important" and five being "very important" [1-5]
    "importance_compatabile", -- Level of importance of the compatibility with existing equipment and property systems when evaluating types of energy-using equipment on a scale of one to five with one being "not at all important" and five being "very important" [1-5]
    "common_area_efficiency_improvement_heating", -- Energy efficiency improvements have been made to the heating equipment of the common areas at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "awareness_of_efficiency_programs", -- Awareness of energy efficiency programs offered to multifamily properties by NYSERDA and utilities [Yes; No; Don't know]
    "non_improvement_recent_ownership", -- Reason for not making needed energy efficiency improvements is that the property is under new ownership if "Efficiency Improvement Needed - None" is "Not mentioned" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "non_improvement_other_priorities", -- Reason for not making needed energy efficiency improvements is that the property has not gotten to it yet if "Efficiency Improvement Needed - None" is "Not mentioned" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "non_improvement_no_support_from_upper_management", -- Reason for not making needed energy efficiency improvements is that there is no approval from upper management if "Efficiency Improvement Needed - None" is "Not mentioned" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "importance_rebate", -- Level of importance of the rebate from a utility or other source when evaluating types of energy-using equipment on a scale of one to five with one being "not at all important" and five being "very important" [1-5]
    "efficiency_improvement_needed_windows", -- Energy efficiency improvements are needed for the windows at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "awareness_other", -- Respondent awareness of other energy efficiency programs if "Awareness of Efficiency Programs" is "Yes [e.g., Which ones?]" [Not mentioned; Mentioned; Programmed skip]
    "efficiency_decisions_managing_agent", -- Managing agent of the multifamily property involved in making the decision to install energy efficient equipment in the common areas and tenant units [Not mentioned; Mentioned; Refused] 
    "efficiency_decisions_tenants", -- Tenants of the multifamily property involved in making the decision to install energy efficient equipment in the common areas and tenant units [Not mentioned; Mentioned; Refused] 
    "efficiency_improvement_needed_other", -- Energy efficiency improvements are needed for other aspects at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "efficiency_decisions_board", -- Condo or co-op board of the multifamily property involved in making the decision to install energy efficient equipment in the common areas and tenant units [Not mentioned; Mentioned; Refused] 
    "efficiency_decisions_purchasing_manager", -- Purchasing manager of the multifamily property involved in making the decision to install energy efficient equipment in the common areas and tenant units [Not mentioned; Mentioned; Refused] 
    "awareness_multifamily_performance", -- Respondent awareness of Multifamily Performance program energy efficiency programs if "Awareness of Efficiency Programs" is "Yes [e.g., Which ones?]" [Not mentioned; Mentioned; Programmed skip]
    "unit_efficiency_improvement_other", -- Energy efficiency improvements have been made to other aspects of the individual units at the multifamily property  [Not mentioned; Mentioned; Don't know]
    "non_improvement_not_needed", -- Reason for not making needed energy efficiency improvements is that they are not really needed if "Efficiency Improvement Needed - None" is "Not mentioned" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "non_improvement_incompatible", -- Reason for not making needed energy efficiency improvements is that they are not compatible with existing equipment if "Efficiency Improvement Needed - None" is "Not mentioned" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "non_improvement_no_rebate", -- Reason for not making needed energy efficiency improvements is that there is no rebate offered if "Efficiency Improvement Needed - None" is "Not mentioned" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "non_improvement_long_payback", -- Reason for not making needed energy efficiency improvements is the length of the payback period if "Efficiency Improvement Needed - None" is "Not mentioned" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "non_improvement_tenant_responsibility", -- Reason for not making needed energy efficiency improvements is that the tenant is responsible for paying utility bills if "Efficiency Improvement Needed - None" is "Not mentioned" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "non_improvement_initial_cost", -- Reason for not making needed energy efficiency improvements is that the initial purchase cost is too high if "Efficiency Improvement Needed - None" is "Not mentioned" [Not mentioned; Mentioned; Don't know; Programmed skip]
    "efficiency_improvement_needed_water_conservation", -- Energy efficiency improvements are needed for the water conservation at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "efficiency_improvement_needed_appliances", -- Energy efficiency improvements are needed for the appliances at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "efficiency_improvement_needed_lighting", -- Energy efficiency improvements are needed for the lighting at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "unique_case_id", -- Unique case identifier for the multifamily study [1-376]
    "county", -- County in New York where the survey respondent's home is located [e.g, Albany-Yates]
    "region", -- Region in New York [Capital District, Central New York, Finger Lakers, Long Island, Mid-Hudson, Mohawk Valley, North Country, New York City, Southern Tier, Western New York]
    "efficiency_improvement_needed_water_heating", -- Energy efficiency improvements are needed for the water heating equipment at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "efficiency_improvement_needed_insulation", -- Energy efficiency improvements are needed for the insulation at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "efficiency_improvement_needed_cooling", -- Energy efficiency improvements are needed for the cooling equipment at the multifamily property  [Not mentioned; Mentioned; Don't know; Refused]
    "efficiency_improvement_needed_heating", -- Energy efficiency improvements are needed for the heating equipment at the multifamily property  [Not mentioned; Mentioned; Don't know; Refused]
    "unit_efficiency_improvement_water_conservation", -- Energy efficiency improvements have been made to the water saving devices of the individual units at the multifamily property  [Not mentioned; Mentioned; Don't know]
    "climate_zone", -- IECC Climate zone; see https://energycode.pnl.gov/EnergyCodeReqs/?state=New%20York for a map and details for each zone [4-6]
    "efficiency_decisions_owner", -- Owner of the multifamily property involved in making the decision to install energy efficient equipment in the common areas and tenant units [Not mentioned; Mentioned; Refused]
    "construction_type", -- Flag indicating construction type [Existing; New]
    "alternative_electricity_sources", -- Use of a generator, including natural gas, solar, or wind to supply electric needs at the multifamily property [Yes; No; Don't know]
    "efficiency_decisions_property_leasing_manager_associate", -- Property or leasing manager or associate of the multifamily property involved in making the decision to install energy efficient equipment in the common areas and tenant units [Not mentioned; Mentioned; Refused] 
    "solar_for_water_or_space_heating", -- Use of solar panels, including PV or active solar for hot water or space heating at the  multifamily property [Yes; No; Don't know]
    "other_office_equipment", -- Number of any other type of computer or home office equipment that is available for tenant use or used in the business office at the multifamily property [0-75; Don't know]
    "number_of_individual_scanners", -- Number of individual scanners available for tenant use or used in the business office at the multifamily property [0-75; Don't know]
    "number_of_individual_fax_machines", -- Number of individual fax machines available for tenant use or used in the business office at the multifamily property [0-75; Don't know]
    "number_of_tablets", -- Number of tablet computers (e.g. iPads) available for tenant use or used in the business office at the multifamily property [0-75; Don't know]
    "number_of_led_lcd_computer_monitors", -- Number of LED or LCD flat screen computer monitors available for tenant use or used in the business office at the multifamily property [0-75; Don't know]
    "unit_efficiency_improvement_doors", -- Energy efficiency improvements have been made to the doors of the individual units at the multifamily property  [Not mentioned; Mentioned; Don't know]
    "unit_efficiency_improvement_windows", -- Energy efficiency improvements have been made to the windows of the individual units at the multifamily property  [Not mentioned; Mentioned; Don't know]
    "efficiency_decisions_senior_property_manager", -- Senior property manager of the multifamily property involved in making the decision to install energy efficient equipment in the common areas and tenant units [Not mentioned; Mentioned; Refused] 
    "unit_efficiency_improvement_appliances", -- Energy efficiency improvements have been made to the appliances of the individual units at the multifamily property  [Not mentioned; Mentioned; Don't know]
    "unit_efficiency_improvement_lighting", -- Energy efficiency improvements have been made to the lighting of the individual units at the multifamily property  [Not mentioned; Mentioned; Don't know]
    "unit_efficiency_improvement_insulation", -- Energy efficiency improvements have been made to the insulation of the individual units at the multifamily property  [Not mentioned; Mentioned; Don't know]
    "number_of_individual_copiers", -- Number of individual copiers available for tenant use or used in the business office at the multifamily property [0-75; Don't know]
    "unit_efficiency_improvement_water_heating", -- Energy efficiency improvements have been made to the water heating equipment of the individual units at the multifamily property  [Not mentioned; Mentioned; Don't know]
    "unit_efficiency_improvement_cooling", -- Energy efficiency improvements have been made to the cooling equipment of the individual units at the multifamily property  [Not mentioned; Mentioned; Don't know]
    "unit_efficiency_improvement_heating", -- Energy efficiency improvements have been made to the heating equipment of the individual units at the multifamily property  [Not mentioned; Mentioned; Don't know]
    "unit_efficiency_improvement_none", -- No energy efficiency improvements have been made to the individual units at the multifamily property [Not mentioned; Mentioned; Don't know]
    "common_area_efficiency_improvement_other", -- Energy efficiency improvements have been made to other aspects of the common areas at the multifamily property [Not mentioned; Mentioned; Don't know; Refused]
    "efficiency_decisions_maintenance_supervisor", -- Maintenance supervisor of the multifamily property involved in making the decision to install energy efficient equipment in the common areas and tenant units [Not mentioned; Mentioned; Refused] 
    "common_area_efficiency_improvement_water_heating", -- Energy efficiency improvements have been made to the water heating equipment of the common areas at the multifamily property  [Not mentioned; Mentioned; Don't know; Refused] 
    "year_of_latest_efficiency_improvement", -- Year of the most recent energy efficiency improvements made to the multifamily property [1900-2013; Don't know; Never; Refused]
    "efficiency_decisions_district_regional_manager", -- District or regional manager of the multifamily property involved in making the decision to install energy efficient equipment in the common areas and tenant units [Not mentioned; Mentioned; Refused] 
    "efficiency_decisions_president_vice_president", -- President or vice president of the multifamily property involved in making the decision to install energy efficient equipment in the common areas and tenant units [Not mentioned; Mentioned; Refused] 
    "majority_clothes_dryers_fuel_type", -- Fuel type of the majority of clothes dryers in the common area of the multifamily property if "Number of Clothes Dryers in Common Area Laundry" is "1-75" [Electricity; Natural gas; Propane; Don't know; Programmed skip]
    "majority_energy_star_clothes_washers", -- ENERGY STAR® status of the majority of clothes washers in the common area of the multifamily property if "Number of Clothes Washers in Common Area Laundry" is "1-150" and "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Average Age of Clothes Washers" is "Less than 2 years old," 2 to 4 years old," or "5 to 9 years old" [Yes; No; Don't know; Programmed skip]
    "average_age_of_clothes_washers", -- Age of the majority of clothes washers in the common area of the multifamily property if "Number of Clothes Washers in Common Area Laundry" is "1-150" [Less than 2 years old; 2 to 4 years old; 5 to 9 years old; 10 to 14 years old; 15 to 19 years old; 20 years old or more; Don’t know; Programmed skip]
    "majority_style_of_clothes_washers" -- Style of the majority of clothes washers (e.g. top load or front load) in the common area of the multifamily property if "Number of Clothes Washers in Common Area Laundry" is "1-75" [Top loading; Front loading; Don't know; Programmed skip]
FROM
    "ny-gov/rsbs-mom-part-2-of-2-new-york-state-residential-hc4z-b2p5:latest"."rsbs_mom_part_2_of_2_new_york_state_residential"
LIMIT 100;

sgr clone ny-gov/rsbs-mom-part-2-of-2-new-york-state-residential-hc4z-b2p5

sgr checkout ny-gov/rsbs-mom-part-2-of-2-new-york-state-residential-hc4z-b2p5:latest

sgr checkout --layered ny-gov/rsbs-mom-part-2-of-2-new-york-state-residential-hc4z-b2p5:latest