"ny-gov/rsbs-smo-part-1-of-2-new-york-state-residential-3m6x-h3qa:latest"."rsbs_smo_part_1_of_2_new_york_state_residential"

SELECT
    ":id", -- Socrata column ID
    "recruitment", -- Flag of whether recruited for onsite scheduling or not [Not recruited,Recruited, Programmed Skip]
    "interest_in_natural_gas_conversion", -- Interest in converting to natural gas if "Natural Gas Available in Street" is "No" [No; Not asked in mini-survey; Programmed skip; Yes]
    "other_fuel_type", -- Other type of fuel used to heat home on a regular basis  [Yes; No; Not asked in mini-survey; Refused]
    "data_origin", -- Origin of initial case data [Utility data, Tax record data]
    "running_standalone_freezer", -- Existence of standalone freezer (one that is not part of a refrigerator) plugged in and running in the home [Yes; No; Not asked in mini-survey; Refused]
    "past_other_equipment", -- Participation in other type of install or recycle if "Efficiency Program Participation in Past Five Years" is "Yes" [Not mentioned, Mentioned, Programmed skip, Refused]
    "future_heating", -- Considering replacing or purchasing heating equipment in the next five years [Not mentioned, Mentioned, Refused]
    "other_fuel_type_other", -- Other fuel type as fuel used to heat home on a regular basis if "Other Fuel Type" is "Yes" [Mentioned; Not mentioned; Not asked in mini-survey; Programmed skip; Refused]
    "other_fuel_type_solar", -- Solar as fuel used to heat home on a regular basis if "Other Fuel Type" is "Yes" [Mentioned; Not mentioned; Not asked in mini-survey; Programmed skip; Refused]
    "shared_central_heating", -- Receive primary heat from a central heating system that is used by other families if the "Home Description" is "Apartment building or condominium with 2 to 4 units" or "Apartment building or condominium with 5 or more units"  [Yes; No; Don't know; Not asked in mini-survey; Programmed skip; Refused]
    "other_fuel_type_wood_pellets", -- Wood/wood pellets as fuel used to heat home on a regular basis if "Other Fuel Type" is "Yes" [Not mentioned; Mentioned; Not asked in mini-survey; Programmed skip; Refused] 
    "other_fuel_type_kerosene", -- Kerosene as fuel used to heat home on a regular basis if "Other Fuel Type" is "Yes" [Not mentioned; Mentioned; Not asked in mini-survey; Programmed skip; Refused]
    "other_fuel_type_fuel_oil", -- Fuel oil as fuel used to heat home on a regular basis if "Other Fuel Type" is "Yes" [Not mentioned; Mentioned; Not asked in mini-survey; Programmed skip; Refused]
    "other_fuel_type_district_steam", -- District steam as fuel used to heat home on a regular basis if "Other Fuel Type" is "Yes" [Not mentioned; Mentioned; Not asked in mini-survey; Programmed skip; Refused]
    "other_fuel_type_propane", -- Propane (bottled gas) as fuel used to heat home on a regular basis if "Other Fuel Type" is "Yes" [Not mentioned; Mentioned; Not asked in mini-survey; Programmed skip; Refused]
    "number_of_compact_fridges", -- Number of other compact refrigerators plugged in and running in the home if "Other Running Fridges" is "Yes" [0-9; Not asked in mini-survey; Programmed skip; Refused]
    "other_fuel_type_natural_gas", -- Natural gas from underground pipes as fuel used to heat home on a regular basis if "Other Fuel Type" is "Yes" [Not mentioned; Mentioned; Not asked in mini-survey; Programmed skip; Refused]
    "electric_utility", -- Electric utility [Central Hudson, ConEd, LIPA, National Grid, NYSEG, )&R,RG&E]
    "age_of_primary_heating_system", -- Age of primary heating system if "Shared Central Heating" is not "Yes" or "Don't know" [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; Not asked in mini-survey; Programmed skip; Refused]
    "efficiency_program_participation_in_past_five_years", -- Household participation in the past five years in any energy efficiency or energy saving programs offered by NYSERDA or utility company to make the home or appliances more energy efficient [No; Refused; Yes]
    "age_of_third_fridge", -- Age of third refrigerator if "Number of Other Running Fridges" is "3-9"  [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; Not asked in mini-survey; Programmed skip]
    "programmed_thermostat", -- automatically change the temperature settings at different times of the day or days of the week or temperature is manually changed as needed if "Programmable Thermostat" is "Yes" [Programmed to change temperature automatically; Manually change the temperature;  Both; Not asked in mini-survey; Programmed skip; Refused]
    "county", -- County in New York where the survey respondent's home is located; see county list at end of data dictionary.
    "climate_zone", -- Climate zone [Climate zone 4-6]
    "kwh_category", -- kWh category [500 kWh or less; 501 to 2,500 kWh; 2,501 to 6,000 kWh; 6,001 to 12,000 kWh; 12,001 to 20,000 kWh; 20,000 kWh or more; Not asked in mini-survey]
    "survey_method", -- The medium by which the respondent completed the survey [Phone Complete; Web Complete; Mini-Survey Complete]
    "other_fuel_type_electricity", -- Electricity as fuel used to heat home on a regular basis if "Other Fuel Type" is "Yes" [Not mentioned; Mentioned; Not asked in mini-survey; Programmed skip; Refused] 
    "number_of_portable_kerosene_heaters_in_winter", -- Number of portable kerosene heaters used in home on a regular basis during the winter [0-9; Not asked in mini-survey; Refused]
    "case_disposition", -- Final disposition of case [Phone complete, Mini-survey complete]
    "dwelling_type", -- Flag of dwelling type [Single family, Tenant]
    "number_of_portable_electric_heaters_in_winter", -- Number of portable electric heaters used in home on a regular basis during the winter  [0-9; Not asked in mini-survey; Refused]
    "utility_electric", -- Electric service provided by a utility if "Data Origin" is "Utility data" [Yes; No, utility does not provide my electric service at that address; No, I no longer live at that address; Not asked in mini-survey; Programmed skip; Refused]
    "number_of_heat_stoves_in_winter", -- Number of heat stoves used in home on a regular basis during the winter [0-9; Not asked in mini-survey; Refused]
    "electric_providers", -- The electric provider that provides electric service at the home’s address [name of specific electric provider/electric supply company (ESCO); Don't Know; Not asked in mini-survey; Refused; Programmed Skip]
    "number_of_electric_fireplaces_in_winter", -- Number of electric fireplaces used in home on a regular basis during the winter [0-9; Not asked in mini-survey; Refused]
    "homes_owned_in_county", -- Number of homes owned in your county of New York if "Data Origin" is "Tax record data" [number; Programmed Skip]
    "number_of_propane_fireplaces_in_winter", -- Number of propane fireplaces used in home on a regular basis during the winter [0-9; Not asked in mini-survey; Programming change; Refused]
    "number_of_natural_gas_fireplaces_in_winter", -- Number of natural gas fireplaces used in home on a regular basis during the winter [0-9; Not asked in mini-survey; Refused]
    "number_of_wood_fireplaces_in_winter", -- Number of wood fireplaces used in home on a regular basis during the winter [0-9; Not asked in mini-survey; Refused]
    "annual_tune_up_heating_system", -- Annual tune up done on heating system each year by a heating contractor, someone in household, or landlord  [Yes, done by someone in the household; Yes, done by a heating contractor; Yes, done by landlord; No; Don't know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused] 
    "purpose_of_home", -- Intention of this home to occupy at least part of the year or to sell it [Occupy this home at least part of the year; Built the home with the intent to sell; Not asked in mini-survey; Programmed skip]
    "age_of_fourth_fridge", -- Age of fourth refrigerator if "Number of Other Running Fridges" is "4-9"  [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; Not asked in mini-survey; Programmed skip; Refused]
    "future_water_heating", -- Considering replacing or purchasing water heating equipment in the next five years [Not mentioned, Mentioned, Refused]
    "future_none", -- Not considering replacing or purchasing any of the suggested appliances or equipment in the next five years [Not mentioned, Mentioned, Refused]
    "desired_insulation_or_weatherization", -- Desire program and would consider using to help pay part of replacement costs for insulation or weatherization measures in the next five years [Not mentioned, Mentioned, Refused]
    "desired_heating", -- Desire program and would consider using to help pay part of replacement costs for heating equipment in the next five years [Not mentioned, Mentioned, Refused]
    "desired_air_conditioning", -- Desire program and would consider using to help pay part of replacement costs for air conditioning equipment in the next five years [Not mentioned, Mentioned, Refused]
    "desired_water_heating", -- Desire program and would consider using to help pay part of replacement costs for water heating equipment in the next five years [Not mentioned, Mentioned, Refused]
    "desired_clothes_washer", -- Desire program and would consider using to help pay part of replacement costs for clothes washer in the next five years [Not mentioned, Mentioned, Refused]
    "desired_appliances", -- Desire program and would consider using to help pay part of replacement costs for appliances in the next five years [Not mentioned, Mentioned, Refused]
    "desired_none", -- Not considering using a program to help pay part of replacement costs for any suggested appliances or equipment in the next five years even if the program existed [Not mentioned, Mentioned, Refused]
    "annual_electricity_cost", -- Best estimate of the total electric costs household paid in the last 12 months, not including natural gas or other fuels if "Data Origin" is "Tax record data" [$500 or less; $501-1,000; $1,001-$1,500; $1.501-$2,000; $2,001-$2,500; $2,501-$3,000; $3,001-$3,500; $3,501-$4,000; $4,000 or more; Don't know; Not asked in mini-survey; Programmed skip; Refused]
    "electricity_consumption_rate", -- Consumption rate categories calculated by dividing dollar amounts in U14 by 0.183 $/kWh [2737 kWh or less; 2737 kWh to 5470 kWh; 5470 kWh to 8202 kWh; 8202 kWh to 10934 kWh; 10934 kWh to 13667 kWh; 13667 kWh to 16399 kWh; 16399 kWh to 19131 kWh; 19131 kWh to 21858 kWh; 21858 kWh or more; Not asked in mini-survey; Programmed skip]
    "number_of_people_age_5", -- Number of individuals less than five years old currently living in the home year-round (excluding those who are just visiting, children who may be away at college, or those deployed in the military) [0-25; Not asked in mini-survey; Refused]
    "number_of_people_age_6_17", -- Number of individuals six to 17 years old currently living in the home year-round (excluding those who are just visiting, children who may be away at college, or those deployed in the military)  [0-25; Not asked in mini-survey; Refused]
    "number_of_people_age_18_24", -- Number of individuals 18 to 24 years old currently living in the home year-round (excluding those who are just visiting, children who may be away at college, or those deployed in the military)  [0-25; Not asked in mini-survey; Refused]
    "number_of_people_age_35_44", -- Number of individuals 35 to 44 years old currently living in the home year-round (excluding those who are just visiting, children who may be away at college, or those deployed in the military)  [0-25; Not asked in mini-survey; Refused] 
    "ownership", -- Description of home ownership. [Occupied without payment of rent; Own/buying; Rent; Other, specify; Refused]
    "months_of_occupation", -- Number of months per year the home is occupied [0-12; Refused]
    "season_of_occupation_spring", -- If number of Months of Occupation is fewer than nine, is the home usually occupied in spring? [Not mentioned, Mentioned, Programmed skip]
    "season_of_occupation_summer", -- If number of Months of Occupation is fewer than nine, is the home usually occupied in summer?  [Not mentioned, Mentioned, Programmed skip]
    "season_of_occupation_fall", -- If number of Months of Occupation is fewer than nine, is the home usually occupied in fall?  [Not mentioned, Mentioned, Programmed skip]
    "season_of_occupation_varies", -- If number of Months of Occupation is fewer than nine, does the season of occupation vary?  [Not mentioned, Mentioned, Programmed skip]
    "home_description", -- Description of the home's building style [Apartment building or condominium with 2 to 4 units; Apartment building or condominium with 5 or more units; Mobile home; Single-family attached house]
    "estimated_number_of_housing_units", -- Total number of housing units believed to be in the building if response to "Number of Housing Units" is "Don't know" [Less than 5; 5-49; 50-99; 100 or more; Not asked in mini-survey; Programmed skip]
    "number_of_stories", -- Number of stories in the building or condominium not including the basement if response to "Home Description" is "Apartment building or condominium with 2 to 4 units" or "Apartment building or condominium with 5 or more units" [1-120; Not asked in mini-survey; Programmed skip; Refused]
    "multiple_buildings_with_housing", -- Existence of multiple buildings in this apartment or condominium complex that include other housing units [Yes, No, Not asked in mini-survey, Programmed skip]
    "number_of_buildings", -- Number of buildings in apartment or condominium complex if response to "Multiple Buildings with Housing" is "Yes" [1-75; Not asked in mini-survey; Programmed skip; Refused]
    "number_of_bedrooms", -- Number of bedrooms in home [0-25; Not asked in mini-survey; Refused]
    "approximate_square_feet_of_home", -- Estimated square footage of home if the "Square Feet of Home" is "Don't know" [Less than 1,000 square feet; 1,000 to less than 1,500 square feet; 1,500 to less than 2,000 square feet; 2,000 to less than 2,500 square feet; 2,500 to less than 3,000 square feet; 3,000 to less than 4,000 square feet; 4,000 or more square feet; Don't know; Programmed skip; Refused]
    "basement_heating", -- Heating of basement if "Number of Housing Units" is two or fewer [Yes, a heated basement; Yes, an unheated basement; No basement; Don't know; Not asked in mini-survey; Programmed skip; Refused]
    "major_renovations", -- Major renovations or additions in the home within the past five years. A major renovation or addition means construction activities like adding a room, increasing the size of your home’s living space, or reconstruction due to flooding or hurricane. [Yes; No; Don't know; Not asked in mini-survey; Refused]
    "number_of_microwave_ovens", -- Number of microwave ovens used in the home [0-9; Refused]
    "number_of_ovens_with_burners", -- Number of ovens with burners on top used in the home [0-9; Refused]
    "number_of_separate_stove_tops", -- Number of separate oven units used in the home [0-9; Refused]
    "number_of_separate_oven_units", -- Number of separate stove tops used in the home [0-9; Refused]
    "number_of_whole_house_fans", -- Number of whole house fans used in the home. A whole-house fan is a type of fan, or exhaust system commonly venting into a building's attic, designed to pull hot air out of the building. [0-25; Not asked in mini-survey; Refused]
    "number_of_attic_fans", -- Number of attic fans used in the home. An attic fan removes air from the attic only. [0-25; Not asked in mini-survey; Refused]
    "age_of_third_standalone_freezer", -- Age of third standalone freezer if "Number of Running Standalone Freezers" is "3-9" [0-100; Don’t know; Not asked in mini-survey; Programmed skip; Refused]
    "number_of_exhaust_fans_in_other_rooms", -- Number of exhaust fans in the bathrooms or other rooms used in the home [0-25; Not asked in mini-survey; Refused]
    "number_of_exhaust_fans_in_kitchen", -- Number of exhaust fans in the kitchen used in the home [0-25; Not asked in mini-survey; Refused]
    "number_of_ceiling_fans", -- Number of ceiling fans used in the home [0-25; Not asked in mini-survey; Refused]
    "energy_star_standalone_freezer", -- ENERGY STAR® status of standalone freezer if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Age of First Standalone Freezer" is "0-9" [[Yes; No; Don't know; Not asked in mini-survey; Programmed skip; Refused]
    "number_of_humidifiers", -- Number of humidifiers used in the home  [0-9; Not asked in mini-survey; Refused]
    "energy_star_dehumidifers", -- ENERGY STAR® status of dehumidifiers if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Number of Dehumidifiers" is "2-9" and "Age of [all]  Dehumidifier[s]" is "0-9" [Yes, all; Yes, some; No; Don't know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
    "age_of_fourth_dehumidifier", -- Age of fourth dehumidifier if "Number of Dehumidifiers" is "4-9" [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; Not asked in mini-survey; Programmed skip; Refused]
    "age_of_third_dehumidifier", -- Age of third dehumidifier if "Number of Dehumidifiers" is "3-9" [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; Not asked in mini-survey; Programmed skip; Refused]
    "age_of_first_dehumidifier", -- Age of first dehumidifier if "Number of Dehumidifiers" is "1-9" [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; Not asked in mini-survey; Programmed skip; Refused]
    "number_of_dehumidifiers", -- Number of dehumidifiers used in the home [0-9; Not asked in mini-survey; Refused]
    "programmable_thermostat", -- Existence of a programmable thermostat that can control heating and/or cooling equipment within the home. This type of thermostat can be programmed to automatically adjust the temperature setting at the times of the day or night that you choose.  [Yes; No; Not asked in mini-survey; Refused]
    "other_air_conditioning_type_other", -- Other type of air conditioning system used to cool home if "Other Air Conditioning" is "Yes"  [Not mentioned; Mentioned; Not asked in mini-survey; Programmed skip; Refused]
    "other_air_conditioning_type_heat_pump", -- Heat pump as other type of air conditioning system used to cool home if "Other Air Conditioning" is "Yes"  [Not mentioned; Mentioned; Not asked in mini-survey; Programmed skip; Refused]
    "other_air_conditioning_type_room_window_unit", -- Room or window air conditioner as other type of air conditioning system used to cool home if "Other Air Conditioning" is "Yes"  [Not mentioned; Mentioned; Not asked in mini-survey; Programmed skip; Refused]
    "energy_star_standalone_freezers", -- ENERGY STAR® status of standalone freezers if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Number of Standalone Freezers" is "2-9" and "Age of [all] Standalone Freezers" is "0-9" [Yes, all; No; Don't know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
    "number_of_running_standalone_freezers", -- Number of standalone freezers plugged in and running in the home if "Running Standalone Freezer" is "Yes" [0-9; Not asked in mini-survey; Programmed skip; Refused]
    "energy_star_chiller_cooler", -- ENERGY STAR® status of chiller/cooler if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Age of First Dehumidifier" is "0-9" [Yes; No; Don't know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
    "number_of_running_chillers_coolers", -- Number of wine chillers/coolers plugged in and running in the home [0-9; Not asked in mini-survey; Refused]
    "age_of_second_standalone_freezer", -- Age of second standalone freezer if "Number of Running Standalone Freezers" is "2-9" [0-100; Don’t know; Not asked in mini-survey; Programmed skip; Refused]
    "energy_star_chillers_coolers", -- ENERGY STAR® status of chillers/coolers if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Number of Coolers/Chillers" is "2-9" and "Age of [all] Cooler[s]/Chiller[s]" is "0-9" [Yes, all; No; Don't know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
    "age_of_second_fridge", -- Age of second refrigerator if "Number of Other Running Fridges" is "2-9"  [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; Not asked in mini-survey; Programmed skip; Refused]
    "square_feet_of_home", -- Square footage of home not counting unfinished basement [1-113,000; Don't know; Nonsensical answer; Refused]
    "highest_education_level", -- Highest level of education a person still living in the household has completed [Less than high school; Some high school; High school graduate or equivalent (e.g., GED); Some college, no degree; Trade or technical school (e.g. Associate's degree); College degree (e.g. Bachelor's degree); Some graduate school; Graduate degree (e.g. Masters or Doctorate degree); Not asked in mini-survey; Refused]
    "number_of_people_age_45_54", -- Number of individuals 45 to 55 years old currently living in the home year-round (excluding those who are just visiting, children who may be away at college, or those deployed in the military)   [0-25; Not asked in mini-survey; Refused]
    "non_particpation_other", -- Respondent has other reason for not participating in any energy efficiency programs if "Efficiency Program Participation in Past Five Years" is "No" [Interviewer mistake, Not mentioned, Mentioned, Programmed skip, Refused]
    "natural_gas_provider", -- Natural gas provider to which payment is made if "Natural Gas Inclusion" is not "Natural gas included in rent or condo fee" and “Fuel for Ovens with Burners – Natural Gas” is “Mentioned,” “Fuel for Separate Stove Top – Natural Gas” is “Mentioned,” “Fuel for Separate Oven Units – Natural Gas” is “Mentioned,” “Primary Fuel Type” is “Natural Gas from Underground Pipes,” “Number of Natural Gas Fireplaces in Winter” is “1-9,”“Other Fuel Type – Natural Gas” is “Mentioned,” “Water Heating Fuel Type” is “Natural gas from underground pipes,” “Clothes Dryer Fuel Type” is “Natural gas from underground pipes,” “Pool Heater Fuel Type” is “Natural gas from underground pipes,” or “Spa Heater Fuel Type” is “Natural gas from underground pipes” [name of provider/ESCO; Don't know; Interviewer mistake; Not asked in mini-survey; Other-specify; Programmed skip; Refused]
    "survey_weight", -- Computed survey weight, based on climate zone, new/existing construction, and single family or tenant dwelling type
    "therm_category", -- Therm cat [300 or less therms annually; 300 to 600 therms annually; 600 to 900 therms annually; 900 to 1,200 therms annually; 1,200 to 1,500 therms annually; 1,500 to 1,800 therms annually; 1,800 to 2,100 therms annually; 2,100 or more therms annually; Not asked in mini-survey]
    "region", -- Region in New York: Capital District, Central New York, Finger Lakes, Long Island, Mid-Hudson, Mohawk Valley, New York City, North Country, Southern Tier, Western New York.
    "other_air_conditioning_type_central_air", -- Central air conditioning system as other type of air conditioning system used to cool home if "Other Air Conditioning" is "Yes"  [Not mentioned; Mentioned; Not asked in mini-survey; Programmed skip; Refused]
    "other_air_conditioning", -- Existence of other air conditioning system used to cool the home, not including ventilation  systems such as fans [Yes; No; Not asked in mini-survey; Programmed skip; Refused]
    "annual_tune_up_air_conditioning", -- Annual tune up done on air conditioning system each year by an air conditioning contractor, someone in household, or landlord [Yes, done by an air conditioning contractor; Yes, done by someone in the household; Yes, done by landlord; No; Don't know; Interviewer mistake; Not asked on mini-survey; Programmed skip; Refused]
    "age_of_first_standalone_freezer", -- Age of first standalone freezer if "Number of Running Standalone Freezers" is "1-9" [0-100; Don’t know; Not asked in mini-survey; Programmed skip; Refused]
    "other_running_fridges", -- Existence of other full-size or compact refrigerators plugged in and running in the home [Yes, No, Not asked in mini-survey, Refused]
    "natural_gas_available_in_street", -- Natural gas availability on street if “Fuel for Ovens with Burners – Natural Gas” is “Not Mentioned,” “Fuel for Separate Stove Top – Natural Gas” is “Not Mentioned,” “Fuel for Separate Oven Units – Natural Gas” is “Not Mentioned,” “Primary Fuel Type” is not “Natural Gas from Underground Pipes,” “Number of Natural Gas Fireplaces in Winter” is “0,” “Other Fuel Type – Natural Gas” is “Not Mentioned,” “Water Heating Fuel Type” is not “Natural gas from underground pipes,” “Clothes Dryer Fuel Type” is not “Natural gas from underground pipes,” “Pool Heater Fuel Type” is not “Natural gas from underground pipes,” and “Spa Heater Fuel Type” is not “Natural gas from underground pipes” [Don't know; Interviewer mistake; No; Not asked in mini-survey; Other-specify; Programmed skip; Refused; Yes]
    "energy_star_air_conditioning", -- ENERGY STAR® status of primary air conditioning system if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Age of Primary Air Conditioning" is "0-9" [Yes; No; Don't know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
    "household_income_2012", -- Total household income range for 2012 [Less than $25,000; $25,000 to less than $30,000; $30,000 to less than $35,000; $35,000 to less than $50,000; $50,000 to less than $75,000; $75,000 to less than $100,000; $100,000 to less than $150,000; $150,000 to less than $200,000; $200,000 or more; Not asked in mini-survey; Refused]
    "age_of_primary_air_conditioning", -- Age of primary air conditioner system if "Shared Air Conditioning" is "No" [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; interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
    "number_of_room_window_units", -- Total number of room or window air conditioners used in the home if "Primary Air Conditioning Type" is "Room or window air conditioner" or "Other Air Conditioning Type - Room/Window Unit" is "Mentioned" [0-9; Interviewer/Respondent error; Nonsensical answer; Not asked in mini-survey; Programmed skip; Refused] ]
    "energy_star_dehumidifier", -- ENERGY STAR® status of dehumidifiers if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Number of Dehumidifiers" is "2-9" and "Age of [all] Dehumidifier[s]" is "0-9" [Yes; No; Don't know; Not asked in mini-survey; Programmed skip; Refused] 
    "past_air_conditioning",
    "primary_air_conditioning_type", -- Primary type of air conditioning equipment used in home if "Shared Air Conditioning" is "No" [Central air conditioning system; Heat pump; Room or window air conditioner; Other, specify; Don't know; Not asked in mini-survey; Programmed skip; Refused]
    "shared_air_conditioning", -- Receive shared air conditioning from a central cooling system that is used by other families if the "Home Description" is "Apartment building or condominium with 2 to 4 units" or "Apartment building or condominium with 5 or more units" [Yes; No; Don't know; Not asked in mini-survey; Programmed skip; Refused]
    "air_conditioning_in_home", -- Presence of air conditioning (including central air conditioning and room or window units) within the home  [Yes; No; Not asked in mini-survey; Refused]
    "past_lighting", -- Participation in air conditioning equipment install or recycle if "Efficiency Program Participation in Past Five Years" is "Yes" [Not mentioned, Mentioned, Programmed skip, Refused]
    "future_insulation_or_weatherization", -- Considering replacing or purchasing insulation or weatherization measures in the next five years [Not mentioned, Mentioned, Refused]
    "gender", -- Gender of the respondent [Female, Male, Not asked in mini-survey, Refused]
    "season_of_occupation_winter", -- If number of Months of Occupation is fewer than nine, is the home usually occupied in Winter?  [Not mentioned, Mentioned, Programmed skip]
    "number_of_people_age_25_34", -- Number of individuals 25 to 34 years old currently living in the home year-round (excluding those who are just visiting, children who may be away at college, or those deployed in the military)  [0-25; Not asked in mini-survey; Refused]
    "renovation_completion_date", -- Year of major renovation or addition completion if "Major Renovations" is "Yes" [2008 - 2014; Not asked in mini-survey; Programmed skip; Refused]
    "year_of_home", -- Year the home was built [1939 or earlier; 1940 to 1949; 1950 to 1959; 1960 to 1969; 1970 to 1979; 1980 to 1989; 1990 to 1999; 2000 to 2009; 2010; 2011; 2012; 2013; 2014; Don't know; Refused]
    "number_of_housing_units", -- Number of housing units if the "Home Description" is "Apartment building or condominium with 2 to 4 units" or "Apartment building or condominium with 5 or more units" [1-2,000; Don't know; Interviewer/Respondent Error; Nonsensical answer; Not asked in mini-survey; Programmed skip]
    "other_space", -- Inclusion of shops, restaurants, other retail space, or space used by businesses within apartment or condominium [Yes, No, Not asked in mini-survey, Programmed skip]
    "past_heating", -- Participation in heating equipment install or recycle if "Efficiency Program Participation in Past Five Years" is "Yes" [Not mentioned, Mentioned, Programmed skip, Refused]
    "propane_inclusion", -- Propane payment made directly to the propane company or included in rent or condominium fee if "Home Description" is "Apartment building or condominium with 2 to 4 units" or "Apartment building or condominium with 5 or more units" and "Primary Fuel Type" is "Propane (bottled gas)," "Other Fuel Type - Propane" is "Mentioned," or "Water Heater Fuel Type" is "Propane (bottled gas)" [Included in rent or condo fee; Not asked in mini-survey; Pay directly; Programmed skip]
    "construction_type", -- Flag of construction type [Existing construction - built prior to 2012; New construction - built 2012 or later]
    "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 [Not at all familiar, Somewhat familiar, Very familiar, Refused]
    "natural_gas_inclusion", -- Natural gas payment made directly to the gas company or included in rent or condominium fee if "Ownership" is not "Own/buying," "Occupied without payment of rent (e.g. Living with someone without making payment," or "Other, specify" or "Home Description" is "Apartment building or condominium with 2 to 4 units" or "Apartment building or condominium with 5 or more units" and “Fuel for Ovens with Burners – Natural Gas” is “Mentioned,” “Fuel for Separate Stove Top – Natural Gas” is “Mentioned,” “Fuel for Separate Oven Units – Natural Gas” is “Mentioned,” “Primary Fuel Type” is “Natural Gas from Underground Pipes,” “Number of Natural Gas Fireplaces in Winter” is “1-9,” “Other Fuel Type – Natural Gas” is “Mentioned,” “Water Heating Fuel Type” is “Natural gas from underground pipes,” “Clothes Dryer Fuel Type” is “Natural gas from underground pipes,” “Pool Heater Fuel Type” is “Natural gas from underground pipes,” or “Spa Heater Fuel Type” is “Natural gas from underground pipes” [Interviewer mistake; Pay directly to natural gas company; Natural gas included in rent or condo fee; Not asked in mini-survey; Programmed skip; Refused]
    "future_clothes_washer", -- Considering replacing or purchasing clothes washer in the next five years [Not mentioned, Mentioned, Refused]
    "fuel_for_separate_stove_tops_natural_gas", -- Natural gas from underground pipes as fuel used if "Number of Separate Stove Tops" is "1-9" [Don't know, Not mentioned, Mentioned, Programmed skip, Refused]
    "age_of_second_dehumidifier", -- Age of second dehumidifier if "Number of Dehumidifiers" is "2-9" [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; Not asked in mini-survey; Programmed skip; Refused]
    "multiple_electric_meters", -- Multiple electric meters at address if "Home Description" is "Single family detached house" or "Mobile home" [Yes; No; Not asked in mini-survey; Programmed skip; Refused]
    "non_participation_rent", -- Respondent is a renter as reason for not participating in any energy efficiency programs if "Efficiency Program Participation in Past Five Years" is "No" [Interviewer mistake, Not mentioned, Mentioned, Programmed skip, Refused]
    "future_appliances", -- Considering replacing or purchasing appliances in the next five years [Not mentioned, Mentioned, Refused]
    "number_of_people_age_65", -- Number of individuals 65 years or older currently living in the home year-round (excluding those who are just visiting, children who may be away at college, or those deployed in the military)   [0-25; Not asked in mini-survey; Refused]
    "number_of_people_age_55_64", -- Number of individuals 55 to 64 years old currently living in the home year-round (excluding those who are just visiting, children who may be away at college, or those deployed in the military)  [0-25; Not asked in mini-survey; Refused]
    "fuel_for_ovens_with_burners_other", -- Other fuel used if "Number of Ovens with Burners" is "1-9" [Don't know, Not mentioned, Mentioned, Programmed skip, Refused]
    "fuel_for_separate_oven_units_propane", -- Propane (bottled gas) as fuel used if "Number of Separate Oven Units" is "1-9" [Don't know, Not mentioned, Mentioned, Programmed skip, Refused]
    "water_dispenser", -- Existence of water dispenser in primary refrigerator [Yes, No, Not asked in mini-survey, Refused]
    "unique_case_id", -- Unique case identifier for each survey respondent [e.g., ST#####]. The first two letters of the ID represent a New York State Regional Economic Development Council: CD=Capital District, CN= Central New York, FL=Finger Lakers, LI=Long Island, MH=Mid-Hudson, MV=Mohawk Valley, NC=North Country, NY=New York City, ST=Southern Tier, WN=Western New York.
    "home_electric_provider", -- Utility company that provides electric service to the home [Central Hudson, ConEd, LIPA, National Grid, NYSEG, )&R,RG&E, Not asked in mini-survey, Programmed skip]
    "fuel_oil_inclusion", -- Fuel oil payment made directly to the fuel oil company or included in rent or condominium fee if "Home Description" is "Apartment building or condominium with 2 to 4 units" or "Apartment building or condominium with 5 or more units" and "Primary Fuel Type" is "Fuel oil," "Other Fuel Type - Fuel Oil" is "Mentioned," or "Water Heater Fuel Type" is "Fuel oil" [Included in rent or condo fee; Not asked in mini-survey; Pay directly; Programmed skip]
    "number_of_other_running_fridges", -- Number of other full-size refrigerators plugged in and running in the home if "Other Running Fridges" is "Yes" [0-9; Not asked in mini-survey; Programmed skip; Refused]
    "energy_star_fridge", -- ENERGY STAR® status of primary refrigerator if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" or "Age of Fridge" is not "10 to 14 years old," "15 to 19 years old," or "20 years old or more" [Yes, No, Don't know, Not asked in mini-survey, Programmed skip, Refused]
    "age_of_fridge", -- Age of primary refrigerator [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; Not asked in mini-survey; Refused]
    "automatic_ice_maker", -- Existence of automatic icemaker in primary refrigerator [Yes, No, Not asked in mini-survey, Refused]
    "fridge_description", -- Description of primary refrigerator (not wine cooler) [Half-size or compact; Full-size with one door; Full-size with two doors, freezer next to the refrigerator (; Full-size with two doors, bottom freezer; Full size, two refrigerator doors and a freezer door on bott; Full-size with two doors, top freezer; Other, specify; Not asked in mini-survey; Refused]
    "fuel_for_separate_oven_units_other", -- Other fuel used if "Number of Separate Oven Units" is "1-9" [Don't know, Not mentioned, Mentioned, Programmed skip, Refused]
    "past_insulation_or_weatherization", -- Participation in insulation or weatherization measures if "Efficiency Program Participation in Past Five Years" is "Yes" [Not mentioned, Mentioned Programmed skip, Refused]
    "past_water_heating", -- Participation in water heating equipment install or recycle if "Efficiency Program Participation in Past Five Years" is "Yes" [Not mentioned, Mentioned, Programmed skip, Refused]
    "past_clothes_washer", -- Participation in clothes washer install or recycle if "Efficiency Program Participation in Past Five Years" is "Yes" [Not mentioned, Mentioned, Programmed skip, Refused]
    "past_appliances", -- Participation in appliances install or recycle if "Efficiency Program Participation in Past Five Years" is "Yes"    [Not mentioned, Mentioned, Programmed skip, Refused]
    "past_refrigeration", -- Participation in refrigerator or freezer install or recycle if "Efficiency Program Participation in Past Five Years" is "Yes" [Not mentioned, Mentioned, Programmed skip, Refused]
    "non_participation_awareness", -- Respondent is not aware of any as reason for not participating in any energy efficiency programs if "Efficiency Program Participation in Past Five Years" is "No" [Interviewer mistake, Not mentioned, Mentioned, Programmed skip, Refused]
    "non_participation_not_needed", -- Respondent does not need anything done as reason for not participating in any energy efficiency programs if "Efficiency Program Participation in Past Five Years" is "No" [Interviewer mistake, Not mentioned, Mentioned, Programmed skip, Refused]
    "non_participation_initiation", -- Respondent does not know who to contact to participate as reason for not participating in any energy efficiency programs if "Efficiency Program Participation in Past Five Years" is "No" [Interviewer mistake, Not mentioned, Mentioned, Programmed skip, Refused]
    "non_participation_high_cost", -- Respondent cannot afford to install new equipment or appliances as reason for not participating in any energy efficiency programs if "Efficiency Program Participation in Past Five Years" is "No" [Interviewer mistake, Not mentioned, Mentioned, Programmed skip, Refused]
    "fuel_for_separate_oven_units_natural_gas", -- Natural gas from underground pipes as fuel used if "Number of Separate Oven Units" is "1-9" [Don't know, Not mentioned, Mentioned, Programmed skip, Refused]
    "energy_star_primary_heating_system", -- ENERGY STAR® status of standalone freezer if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Age of Primary Heating System" is "0-9" [Yes; No; Don't know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
    "primary_heating_system_type", -- Type of primary heating system in the home if "Shared Central Heating" is not "Yes" or "Don't know" [Air source Heat pump; Baseboard heat; Central forced air furnace with ducts to individual rooms; District steam with radiators or pipes in each room; Fireplace; Ground source Heat pump; Heating stove burning wood or coal; Other, specify; Portable electric heater; Portable kerosene heater; Solar panels; Steam/hot water system with radiators or pipes in each room; Don’t know; Not asked in mini-survey; Programmed skip; Refused]
    "primary_fuel_type", -- Primary type of fuel used for heating the home if "Shared Central Heating" is not "Yes" or "Don't know" [District Steam; Electricity; Fuel oil; Geothermal; Kerosene; Natural gas from underground pipes; Other, specify; Propane (bottled gas); Solar; Wood/wood pellets; Don’t know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
    "fuel_for_separate_oven_units_electricity", -- Electricity as fuel used if "Number of Separate Oven Units" is "1-9" [Don't know, Not mentioned, Mentioned, Programmed skip, Refused]
    "fuel_for_separate_stove_tops_other", -- Other fuel used if "Number of Separate Stove Tops" is "1-9" [Don't know, Not mentioned, Mentioned, Programmed skip, Refused]
    "fuel_for_separate_stove_tops_propane", -- Propane (bottled gas) as fuel used if "Number of Separate Stove Tops" is "1-9" [Don't know, Not mentioned, Mentioned, Programmed skip, Refused]
    "fuel_for_separate_stove_tops_electric", -- Other fuel used if "Number of Ovens with Burners" is "1-9" [Don't know, Not mentioned, Mentioned, Programmed skip, Refused]
    "fuel_for_ovens_with_burners_propane", -- Propane (bottled gas) as fuel used if "Number of Ovens with Burners" is "1-9" [Don't know, Not mentioned, Mentioned, Programmed skip, Refused]
    "type_of_first_standalone_freezer", -- Type of standalone freezer plugged in and running if "Running Standalone Freezer" is "Yes" [Chest, UprightNot asked in mini-survey; Programmed skip; Refused]
    "non_participation_low_bills", -- Respondent does not have that high of energy bills as reason for not participating in any energy efficiency programs if "Efficiency Program Participation in Past Five Years" is "No" [Interviewer mistake, Not mentioned, Mentioned, Programmed skip, Refused]
    "non_participation_too_busy", -- Respondent is too busy as reason for not participating in any energy efficiency programs if "Efficiency Program Participation in Past Five Years" is "No" [Interviewer mistake, Not mentioned, Mentioned, Programmed skip, Refused]
    "non_participation_new_residence", -- Respondent recently moved to the home as reason for not participating in any energy efficiency programs if "Efficiency Program Participation in Past Five Years" is "No" [Interviewer mistake, Not mentioned, Mentioned, Programmed skip, Refused]
    "fuel_for_ovens_with_burners_natural_gas", -- Natural gas from underground pipes as fuel used if "Number of Ovens with Burners" is "1-9" [Don't know, Not mentioned, Mentioned, Programmed skip, Refused]
    "type_of_second_standalone_freezer", -- Type of second standalone freezer plugged in and running if "Number of Running Standalone Freezers" is "2-9" [Chest, Upright, Not asked in mini-survey; Programmed skip; Refused]
    "type_of_third_standalone_freezer", --  Type of third standalone freezer plugged in and running if "Number of Running Standalone Freezers" is "3-9"  [Chest, Upright, Not asked in mini-survey; Programmed skip; Refused]
    "fuel_for_ovens_with_burners_electric", -- Electricity as fuel used if "Number of Ovens with Burners" is "1-9" [[Don't know, Not mentioned, Mentioned, Programmed skip, Refused]
    "future_air_conditioning" -- Considering replacing or purchasing air conditioning equipment in the next five years [Not mentioned, Mentioned, Refused]
FROM
    "ny-gov/rsbs-smo-part-1-of-2-new-york-state-residential-3m6x-h3qa:latest"."rsbs_smo_part_1_of_2_new_york_state_residential"
LIMIT 100;

sgr clone ny-gov/rsbs-smo-part-1-of-2-new-york-state-residential-3m6x-h3qa

sgr checkout ny-gov/rsbs-smo-part-1-of-2-new-york-state-residential-3m6x-h3qa:latest

sgr checkout --layered ny-gov/rsbs-smo-part-1-of-2-new-york-state-residential-3m6x-h3qa:latest