Query the Data Delivery Network
Query the DDNThe easiest way to query any data on Splitgraph is via the "Data Delivery Network" (DDN). The DDN is a single endpoint that speaks the PostgreSQL wire protocol. Any Splitgraph user can connect to it at data.splitgraph.com:5432 and query any version of over 40,000 datasets that are hosted or proxied by Splitgraph.
For example, you can query the rsbs_hvac_new_york_state_residential_statewide table in this repository, by referencing it like:
"ny-gov/rsbs-hvac-new-york-state-residential-statewide-aee3-5gf5:latest"."rsbs_hvac_new_york_state_residential_statewide"or in a full query, like:
SELECT
":id", -- Socrata column ID
"number_of_residential_split_system_central_air_tier_2_sold_2013", -- The number of residential split system central air units sold in 2013 that qualify for Tier Two efficiency - 15 SEER but less than 16 SEER or 12.5 EER but less than 13 EER [0-400; Programmed skip; Refused]
"number_of_residential_oil_fired_furnaces_serviced_past_year", -- Number of residential oil furnace units serviced in the past 12 months in New York State if "Month of Survey Completion" is "September" [Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in July fielding; Refused]
"increase_residential_furnaces_other", -- Firm expects an increase in efficient residential furnace sales compared to standard efficiency equipment over the next two years because of other reasons [Yes; No; Programmed skip]
"increase_residential_furnaces_federal_tax_credits", -- Firm expects an increase in efficient residential furnace sales compared to standard efficiency equipment over the next two years because of Federal Tax Credits [Yes; No; Programmed skip]
"distributor_order_of_residential_boilers", -- Firm orders from distributor for residential gas- and oil-fired boilers [Yes; No; Programmed skip; Refused]
"increase_residential_furnaces_federal_standards", -- Firm expects an increase in efficient residential furnace sales compared to standard efficiency equipment over the next two years because of New Federal Standards for minimum efficiency of manufactured units [Yes; No; Programmed skip]
"manufacturer_order_of_residential_boilers", -- Firm orders from manufacturer representative for residential gas- and oil-fired boilers [Yes; No; Programmed skip; Refused]
"expect_increase_in_efficient_residential_boilers_sales", -- Whether or not the firm expects an increase in efficient residential boiler sales compared to standard efficiency equipment over the next two years [Yes; No; Programmed skip; Refused]
"increase_residential_boilers_equipment_costs_fall", -- Firm expects an increase in efficient residential boiler sales compared to standard efficiency equipment over the next two years because equipment costs will come down [Yes; No; Programmed skip]
"increase_residential_furnaces_customer_demand", -- Firm expects an increase in efficient residential furnace sales compared to standard efficiency equipment over the next two years because customers will demand higher efficiency [Yes; No; Programmed skip]
"increase_residential_boilers_customer_demand", -- Firm expects an increase in efficient residential boiler sales compared to standard efficiency equipment over the next two years because customers will demand higher efficiency [Yes; No; Programmed skip]
"increase_residential_furnaces_equipment_costs_fall", -- Firm expects an increase in efficient residential furnace sales compared to standard efficiency equipment over the next two years because equipment costs will come down [Yes; No; Programmed skip]
"number_of_residential_split_system_central_air_not_high_efficie", -- The number of residential split system central air units sold in 2013 that are not high efficiency - less than 14.5 SEER or less than 12 EER [0-200; Programmed skip; Refused]
"increase_residential_non_electric_water_heaters_hvac_business_k", -- Firm expects an increase in efficient residential non-electric water heater sales compared to standard efficiency equipment over the next two years because HVAC business will be better informed/educated on high efficiency [Yes; No; Programmed skip]
"increase_residential_non_electric_water_heaters_customer_demand", -- Firm expects an increase in efficient residential non-electric water heater sales compared to standard efficiency equipment over the next two years because customers will demand higher efficiency [Yes; No; Programmed skip]
"type_of_residential_water_heater_recommended", -- Efficiency level of residential water heaters that is typically recommended to customers for purchase if "Month of Survey Completion" is "July" [Standard efficiency; Tier 1; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in September fielding; Programmed skip; Refused]
"number_of_residential_condensing_gas_water_heaters_tier_1_sold_", -- The number of residential condensing gas water heater units sold in 2013 that qualify for Tier One efficiency - .80 EF and above [0-50; Programmed skip; Refused]
"number_of_residential_gas_tankless_water_heaters_tier_1_sold_20", -- The number of residential gas tankless water heater units sold in 2013 that qualify for Tier One efficiency - .82 EF and above [0-100; Don't know; Programmed skip; Refused]
"increase_residential_boilers_other", -- Firm expects an increase in efficient residential boiler sales compared to standard efficiency equipment over the next two years because of other reasons [Yes; No; Programmed skip]
"stock_of_residential_boilers", -- Firm maintains a stock of residential gas- and oil-fired boilers [Yes; No; Programmed skip; Refused]
"number_of_residential_gas_boilers_tier_3_sold_2013", -- The number of residential gas boiler units sold in 2013 that qualify for Tier Three efficiency - 94% AFUE and above [0-400; Not applicable-question not asked in July fielding; Programmed skip; Refused]
"number_of_residential_gas_boilers_tier_2_sold_2013", -- The number of residential gas boiler units sold in 2013 that qualify for Tier Two efficiency - 90% AFUE and above [0-1500; Programmed skip; Refused]
"number_of_residential_gas_furnaces_serviced_past_year", -- Number of residential gas furnace units serviced in the past 12 months in New York State if "Month of Survey Completion" is "September" [Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in July fielding; Refused]
"number_of_residential_furnaces_serviced_past_year", -- Number of residential furnace units serviced in the past 12 months in New York State if "Month of Survey Completion" is "July" [Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in September fielding; Refused]
"number_of_residential_split_system_central_air_serviced_past_ye", -- Number of residential split system central air units serviced in the past 12 months in New York State if "Month of Survey Completion" is "September" [None; Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in July fielding; Refused]
"required_technician_certification_epa_hvac", -- Firm-required industry certification from EPA HVAC Certification for its HVAC technicians if "Required Technician Certification" is "Yes" [e.g., Affirmative answer; training is required - Answer not chosen]
"required_technician_certification_bpi", -- Firm-required industry certification from Building Performance Institute (BPI) for its HVAC technicians if "Required Technician Certification" is "Yes" [e.g., Affirmative answer; training is required - Answer not chosen]
"required_technician_certification_nate", -- Firm-required industry certification from North American Technician Excellence (NATE) for its HVAC technicians if "Required Technician Certification" is "Yes" [e.g., Affirmative answer; training is required - Answer not chosen]
"required_technician_certification", -- Firm-required industry certification for its HVAC technicians [Yes; No; Refused]
"required_technician_training_utility_sponsored", -- Firm requires utility-sponsored training on efficiency for its technicians if "Required Technician Training" is "Yes" [e.g., Affirmative answer; training is required - Answer not chosen]
"required_technician_training_acca", -- Firm requires Air Conditioning Contractors of America (ACCA) training for its technicians if "Required Technician Training" is "Yes" [e.g., Affirmative answer; training is required - Answer not chosen]
"company_skill_level_sizing_new_systems", -- Firm self-rating in skills regarding practices, techniques, and experiences with sizing new systems on a scale of one to five where one is not at all proficient and five is extremely proficient [Not at all proficient; Somewhat proficient; Proficient; Very proficient; Extremely proficient; Refused]
"company_skill_level_system_efficiencies", -- Firm self-rating in skills regarding recommending and specifying system efficiencies on a scale of one to five where one is not at all proficient and five is extremely proficient [Not at all proficient; Somewhat proficient; Proficient; Very proficient; Extremely proficient; Refused]
"type_of_residential_gas_boiler_recommended", -- Efficiency level of residential gas boilers that is typically recommended to customers for purchase if "Month of Survey Completion" is "September" [Standard efficiency; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in July fielding; Programmed skip; Refused]
"number_of_residential_gas_boilers_tier_1_sold_2013", -- The number of residential gas boiler units sold in 2013 that qualify for Tier One efficiency - greater than 85% AFUE but less than 90% [0-400; Programmed skip; Refused]
"number_of_residential_gas_boilers_not_high_efficiency_sold_2013", -- The number of residential gas boiler units sold in 2013 that are not high efficiency - less than 85% AFUE [0-200; Programmed skip; Refused]
"store_purchase_of_residential_boilers", -- Firm purchases directly from store for residential gas- and oil-fired boilers [Yes; No; Programmed skip; Refused]
"awareness_of_new_federal_standards_for_non_electric_heating", -- Awareness of new federal standards that may affect the manufacture of energy efficient non-electric heating and water heating equipment in New York State [Yes; No; Not sure; Refused]
"event_frequency_level_during_new_residential_hvac_installat_000", -- Frequency of performing the test of conducting heat loss and heat gain load calculations for installations or replacements when installing new residential HVAC equipment on a scale of one to five where one is usually not done and five is always done [Always done; Often done; Sometimes done; Rarely done; Usually not done; Refused]
"percentage_of_equipment_incentivized_by_programs", -- Approximate percentage of the equipment sold that is rebated or incentivized through each of these programs if "Familiarity with Non-Electric Heating Programs" is "Somewhat familiar" or "Very familiar" [0-100%; Don't know; Programmed skip; Refused]
"test_frequency_level_during_residential_hvac_installation_o_000", -- Frequency of performing the test of measuring water flows when installing or servicing residential HVAC equipment on a scale of one to five where one is usually not usually conducted and five is always conducted [Always done; Often done; Sometimes done; Rarely done; Usually not done; Refused]
"test_frequency_level_during_residential_hvac_installation_o_001", -- Frequency of performing the test of measuring airflows when installing or servicing residential HVAC equipment on a scale of one to five where one is usually not usually conducted and five is always conducted [Always done; Often done; Sometimes done; Rarely done; Usually not done; Refused]
"event_frequency_level_during_new_residential_hvac_installat_001", -- Frequency of performing the test of conducting duct leakage tests when installing new residential HVAC equipment on a scale of one to five where one is usually not done and five is always done [Always done; Often done; Sometimes done; Rarely done; Usually not done; Refused]
"event_frequency_level_during_new_residential_hvac_installat_002", -- Frequency of performing the test of ensuring the load equipment is properly sized and selected prior to installation when installing new residential HVAC equipment on a scale of one to five where one is usually not done and five is always done [Always done; Often done; Sometimes done; Rarely done; Usually not done; Refused]
"required_technician_training_ahri", -- Firm requires Air-Conditioning, Heating, and Refrigeration Institute (AHRI) training for its technicians if "Required Technician Training" is "Yes" [e.g., Affirmative answer; training is required - Answer not chosen]
"required_technician_training_plumbing", -- Firm requires plumbing training for its technicians if "Required Technician Training" is "Yes" [e.g., Affirmative answer; training is required - Answer not chosen]
"industry_reference_bpi", -- Building Performance Institute (BPI) used as an industry reference to ensure quality installation of residential HVAC equipment [e.g., Affirmative answer; source is used - No, or source not mentioned]
"percentage_gas_water_heaters_sold_oil_to_gas_conversion_past_ye", -- Approximate percentage of residential gas water heater units sold in New York State in the past 12 months that have been oil-to-gas conversions [0-100%; Programmed skip; Refused]
"percentage_furnace_sales_oil_to_gas_conversions_past_year", -- Approximate percentage of gas furnaces sold in New York State in the past 12 months that have been oil-to-gas conversions [0-100%; Programmed skip; Refused]
"number_of_boiler_reset_controls_installed_past_year", -- Number of Boiler Reset Controls installed in the past 12 months for residential homes in New York State [0-600; Programmed skip; Refused]
"number_of_wi_fi_thermostats_sold_past_year", -- Number of Wi-Fi Communicating Thermostats sold in the past 12 months for residential homes in New York State [0-100; Programmed skip; Refused]
"increase_residential_heat_pumps_new_technology", -- Firm expects an increase in efficient residential heat pump unit sales compared to standard efficiency equipment over the next two years because of the availability of improved or new technologies [Yes; No; Not applicable-question not asked in July fielding]
"increase_residential_heat_pumps_customer_demand", -- Firm expects an increase in efficient residential heat pump unit sales compared to standard efficiency equipment over the next two years because customers will demand higher efficiency [Yes; No; Not applicable-question not asked in July fielding]
"total_number_of_residential_gas_boilers_sold_2013", -- Total number of residential gas boiler units sold in 2013 [1-2000; Programmed skip; Refused]
"distributor_order_of_residential_heat_pump", -- Firm orders from distributor for residential heat pump units [Yes; No; Not applicable-question not asked in July fielding; Programmed skip]
"number_of_residential_packaged_heat_pump_not_high_efficiency_so", -- The number of residential packaged heat pump units sold in 2013 that are not high efficiency - less than 14.5 SEER or less than 12 EER or less than 8.2 HSPF [0-10; Programmed skip; Refused]
"number_of_residential_central_air_serviced_past_year", -- Number of residential central air units serviced in the past 12 months in New York State if "Month of Survey Completion" is "July" [None; Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in September fielding; Refused]
"number_of_residential_split_system_central_air_tier_3_sold_2013", -- The number of residential split system central air units sold in 2013 that qualify for Tier Three efficiency - 16 SEER and above or 13 EER and above [0-200; Programmed skip; Refused]
"month_of_survey_completion", -- Month flag for when survey was completed [January - December]
"number_of_boiler_reset_controls_sold_past_year", -- Number of Boiler Reset Controls sold in the past 12 months for residential homes in New York State [0-600; Programmed skip; Refused]
"unique_case_id", -- Unique number assigned to case upon survey completion [1-47]
"number_of_wi_fi_thermostats_installed_past_year", -- Number of Wi-Fi Communicating Thermostats installed in the past 12 months for residential homes in New York State [0-100; Programmed skip; Refused]
"type_of_residential_condensing_gas_water_heater_recommended", -- Efficiency level of residential condensing gas water heaters that is typically recommended to customers for purchase if "Month of Survey Completion" is "September" [Standard efficiency; Tier 1; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in July fielding; Programmed skip; Refused]
"stock_of_residential_non_electric_water_heaters", -- Firm maintains a stock of residential non-electric water heaters [Yes; No; Refused]
"contractor_climate_zone", -- Climate Zone where the HVAC contractor is located [4-6]
"percentage_of_residential_business_multifamily_high_rise", -- Percentage of residential business in terms of percent of jobs that is attributable to multifamily high-rise buildings with more than four stories and five or more units [1-100%; Not applicable-question not asked in September fielding]
"store_purchase_of_residential_non_electric_water_heaters", -- Firm purchases directly from store for residential non-electric water heaters [Yes; No; Refused
"industry_reference_ashrae", -- American Society of Heating, Refrigerating, and Air-Conditioning Engineers (ASHRAE) used as an industry reference to ensure quality installation of residential HVAC equipment [e.g., Affirmative answer; source is used - No, or source not mentioned]
"number_of_residential_gas_tankless_water_heaters_not_high_effic", -- The number of residential gas tankless water heater units sold in 2013 that are not high efficiency - less than .82 EF [0-10; Don't know; Programmed skip; Refused]
"distributor_order_of_residential_non_electric_water_heaters", -- Firm orders from distributor for residential non-electric water heaters [Yes; No; Refused]
"early_retirement_by_percentage_of_units_heat_pumps", -- Size of impact in terms of percentage of heat pump units retired early as opposed to replaced on failure if "Observed Increase in Early Retirement of Equipment" is "Yes" [0-100%; Programmed skip; Refused]
"other_source_of_residential_non_electric_water_heaters", -- Description of other source of residential non-electric water heaters [Yes; No; Refused]
"early_retirement_by_percentage_of_units_residential_boilers", -- Size of impact in terms of percentage of residential boiler units retired early as opposed to replaced on failure if "Observed Increase in Early Retirement of Equipment" is "Yes" [0-100%; Programmed skip]
"expect_increase_in_efficient_residential_non_electric_water_hea", -- Whether or not the firm expects an increase in efficient residential non-electric water heater sales compared to standard efficiency equipment over the next two years [Yes; No; Refused]
"increase_residential_non_electric_water_heaters_equipment_costs", -- Firm expects an increase in efficient residential non-electric water heater sales compared to standard efficiency equipment over the next two years because equipment costs will come down [Yes; No; Programmed skip]
"increase_residential_non_electric_water_heaters_federal_tax_cre", -- Firm expects an increase in efficient residential non-electric water heater sales compared to standard efficiency equipment over the next two years because of Federal Tax Credits [Yes; No; Programmed skip]
"early_retirement_by_percentage_of_units_tank_water_heaters", -- Size of impact in terms of percentage of tank (storage) water heater units retired early as opposed to replaced on failure if "Observed Increase in Early Retirement of Equipment" is "Yes" [0-100%; Programmed skip]
"hvac_sales_to_single_family_residential", -- Company sells, installs, or services air conditioners, heat pumps, furnaces, boilers, or water heaters for single family residential customers - residential dwellings that include one to four living units in the building - in the State of New York [Yes, No]
"increase_residential_non_electric_water_heaters_rebates_and_inc", -- Firm expects an increase in efficient residential non-electric water heater sales compared to standard efficiency equipment over the next two years because of utility or state rebates and incentives [Yes; No; Programmed skip]
"increase_residential_non_electric_water_heaters_new_technology", -- Firm expects an increase in efficient residential non-electric water heater sales compared to standard efficiency equipment over the next two years because of the availability of improved or new technologies [Yes; No; Programmed skip]
"increase_residential_non_electric_water_heaters_other", -- Firm expects an increase in efficient residential non-electric water heater sales compared to standard efficiency equipment over the next two years because of other reasons [Yes; No; Programmed skip]
"residential_furnace_sales_to_single_family_residential", -- Residential furnaces sold to single family homes of one to four units [Yes, No]
"observed_increase_in_early_retirement_of_equipment", -- Whether or not the firm has observed any increase in the number of units of equipment that are now being retired early versus replaced on failure [Yes; No; Refused]
"number_of_residential_non_electric_water_heaters_serviced_past_", -- Number of residential non-electric water heater units serviced in the past 12 months in New York State if "Month of Survey Completion" is "July" [Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in September fielding; Refused]
"number_of_residential_oil_tank_water_heaters_serviced_2013", -- Number of residential oil tank water heater units serviced in the past 12 months in New York State if "Month of Survey Completion" is "September" [None; Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in July fielding; Refused]
"number_of_residential_gas_tankless_water_heaters_serviced_2013", -- Number of residential gas tankless water heater units serviced in the past 12 months in New York State if "Month of Survey Completion" is "September" [None; Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in July fielding; Refused]
"number_of_residential_condensing_gas_water_heaters_serviced_201", -- Number of residential condensing gas water heater units serviced in the past 12 months in New York State if "Month of Survey Completion" is "September" [None; Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in July fielding; Refused]
"total_number_of_residential_split_system_central_air_sold_2013", -- Total number of residential split system central air units sold in 2013 [0-1000; Programmed skip; Refused]
"number_of_residential_split_system_central_air_tier_1_sold_2013", -- The number of residential split system central air units sold in 2013 that qualify for Tier One efficiency - 14.5 SEER but less than 15 SEER or 12 EER but less than 12.5 EER [0-200; Programmed skip; Refused]
"number_of_residential_packaged_central_air_tier_2_sold_2013", -- The number of residential packaged central air units sold in 2013 that qualify for Tier Two efficiency - 14 SEER and above or 12 EER and above [0-10; Programmed skip; Refused]
"type_of_residential_central_air_recommended", -- Efficiency level of residential central air units that is typically recommended to customers for purchase if "Month of Survey Completion" is "July" [Standard efficiency; Tier 1; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in September fielding; Programmed skip; Refused]
"type_of_residential_split_system_central_air_recommended", -- Efficiency level of residential split system central air units that is typically recommended to customers for purchase if "Month of Survey Completion" is "September" [Standard efficiency; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in July fielding; Programmed skip; Refused]
"store_purchase_of_residential_central_air", -- Firm purchases directly from store for residential central air units [Yes; No; Programmed skip; Refused]
"manufacturer_order_of_residential_central_air", -- Firm orders from manufacturer representative for residential central air units [Yes; No; Programmed skip; Refused]
"distributor_order_of_residential_central_air", -- Firm orders from distributor for residential central air units [Yes; No; Programmed skip; Refused]
"other_source_of_residential_central_air", -- Description of other source of residential central air units [Yes; No; Programmed skip; Refused]
"increase_residential_central_ac_equipment_costs_fall", -- Firm expects an increase in efficient residential central air unit sales compared to standard efficiency equipment over the next two years because equipment costs will come down [Yes; No; Programmed skip]
"type_of_residential_packaged_central_air_recommended", -- Efficiency level of residential packaged central air units that is typically recommended to customers for purchase if "Month of Survey Completion" is "September" [Standard efficiency; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in July fielding; Programmed skip; Refused]
"percentage_of_residential_business_single_family", -- Percentage of residential business in terms of percent of jobs that is attributable to single family homes defined as one- to four-family buildings, including free-standing homes and townhouses [0-100%; Not applicable-question not asked in September fielding]
"increase_residential_central_ac_customer_demand", -- Firm expects an increase in efficient residential central air unit sales compared to standard efficiency equipment over the next two years because customers will demand higher efficiency [Yes; No; Programmed skip]
"industry_reference_nate", -- North American Technician Excellence (NATE) used as an industry reference to ensure quality installation of residential HVAC equipment [e.g., Affirmative answer; source is used - No, or source not mentioned]
"increase_residential_central_ac_federal_tax_credits", -- Firm expects an increase in efficient residential central air unit sales compared to standard efficiency equipment over the next two years because of Federal Tax Credits [Yes; No; Programmed skip]
"increase_residential_central_ac_federal_standards", -- Firm expects an increase in efficient residential central air unit sales compared to standard efficiency equipment over the next two years because of New Federal Standards for minimum efficiency of manufactured units [Yes; No; Programmed skip]
"increase_residential_central_ac_hvac_business_knowledge", -- Firm expects an increase in efficient residential central air unit sales compared to standard efficiency equipment over the next two years because HVAC business will be better informed/educated on high efficiency [Yes; No; Programmed skip]
"increase_residential_central_ac_new_technology", -- Firm expects an increase in efficient residential central air unit sales compared to standard efficiency equipment over the next two years because of the availability of improved or new technologies [Yes; No; Programmed skip]
"increase_residential_central_ac_other", -- Firm expects an increase in efficient residential central air unit sales compared to standard efficiency equipment over the next two years because of other reasons [Yes; No; Programmed skip]
"total_number_of_residential_split_system_heat_pump_sold_2013", -- Total number of residential split system heat pump units sold in 2013 [0-300; Programmed skip; Refused]
"industry_reference_other", -- Other source used as an industry reference to ensure quality installation of residential HVAC equipment [e.g., Affirmative answer; source is used - No, or source not mentioned]
"tank_water_heater_sales_to_single_family_residential", -- Storage tank water heaters sold to single family homes of one to four units [Does not sell equipment type; Does sell equipment type; Not applicable-question not asked in September fielding]
"number_of_residential_oil_boilers_tier_1_sold_2013", -- The number of residential oil boiler units sold in 2013 that qualify for Tier One efficiency - 85% AFUE and above [0-1600; Programmed skip; Refused]
"tankless_water_heater_sales_to_single_family_residential", -- Tankless water heaters sold to single family homes of one to four units [Does not sell equipment type; Does sell equipment type; Not applicable-question not asked in September fielding]
"number_of_residential_split_system_heat_pump_not_high_efficienc", -- The number of residential split system heat pump units sold in 2013 that are not high efficiency - less than 14.5 SEER or less than 12 EER or less than 8.2 HSPF [0-200; Programmed skip; Refused]
"industry_reference_phcc", -- Plumbing, Heating-Cooling Contractors National Association (PHCC) used as an industry reference to ensure quality installation of residential HVAC equipment [e.g., Affirmative answer; source is used - No, or source not mentioned]
"increase_residential_boilers_hvac_business_knowledge", -- Firm expects an increase in efficient residential boiler sales compared to standard efficiency equipment over the next two years because HVAC business will be better informed/educated on high efficiency [Yes; No; Programmed skip]
"number_of_residential_split_system_heat_pump_tier_1_sold_2013", -- The number of residential split system heat pump units sold in 2013 that qualify for Tier One efficiency - 14.5 SEER to less than 15 SEER or 12 EER to less than 12.5 EER or 8.2 HSPF to less than 8.5 HSPF [0-50; Programmed skip; Refused]
"percentage_boiler_sales_oil_to_gas_conversion_past_year", -- Approximate percentage of gas furnaces sold in New York State in the past 12 months that have been oil-to-gas conversions [0-100%; Programmed skip; Refused]
"heat_pump_sales_to_single_family_residential", -- Heat pumps sold to single family homes of one to four units [Does not sell equipment type; Does sell equipment type; Not applicable-question not asked in September fielding]
"effect_of_unnatural_weather_event_on_2013_sales", -- Whether or not any major weather events or other events affected inventory or sales of high efficient equipment in 2013 in any way (e.g. events such as Hurricane Sandy in late 2012 and the particularly cold 2013-2014 winter season) [Yes; No; Not sure; Refused]
"no_sales_and_installations_to_single_family_residential", -- None of the mentioned types of equipment sold to and installed in single family homes of one to four units [Does not sell and install equipment type; Does sell and install equipment type]
"early_retirement_by_percentage_of_units_central_air_conditioner", -- Size of impact in terms of percentage of central air conditioner units retired early as opposed to replaced on failure if "Observed Increase in Early Retirement of Equipment" is "Yes" [0-100%; Programmed skip]
"other_source_of_residential_heat_pump", -- Description of other source of residential heat pump units [Yes; No; Not applicable-question not asked in July fielding; Programmed skip]
"early_retirement_by_percentage_of_units_residential_furnaces", -- Size of impact in terms of percentage of residential furnace units retired early as opposed to replaced on failure if "Observed Increase in Early Retirement of Equipment" is "Yes" [0-100%; Programmed skip]
"number_of_residential_split_system_heat_pump_tier_2_sold_2014", -- The number of residential split system heat pump units sold in 2013 that qualify for Tier Two efficiency - 15 SEER or 12.5 EER or 8.5 HSPF [0-100; Programmed skip; Refused]
"wi_fi_thermostat_sales_to_single_family_residential", -- Wi-Fi communicating thermostats sold to single family homes of one to four units [Does not sell equipment type; Does sell equipment type; Not applicable-question not asked in September fielding]
"total_number_of_residential_packaged_heat_pump_sold_2013", -- Total number of residential packaged heat pump units sold in 2013 [0-300; Programmed skip; Refused]
"number_of_residential_packaged_heat_pump_tier_1_sold_2013", -- The number of residential packaged heat pump units sold in 2013 that qualify for Tier One efficiency - 14.5 SEER to less than 15 SEER or 12 EER to less than 12.5 EER or 8.2 HSPF to less than 8.5 HSPF [0-30; Programmed skip; Refused]
"number_of_residential_packaged_heat_pump_tier_2_sold_2014", -- The number of residential packaged heat pump units sold in 2013 that qualify for Tier Two efficiency - 15 SEER or 12.5 EER or 8.5 HSPF [0-30; Programmed skip; Refused]
"number_of_residential_ductless_mini_split_heat_pumps_serviced_p", -- Number of residential ductless mini-split heat pump units serviced in the past 12 months in New York State if "Month of Survey Completion" is "September" [None; Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in July fielding; Refused]
"type_of_residential_split_system_heat_pump_recommended", -- Efficiency level of residential split system heat pump units that is typically recommended to customers for purchase if "Month of Survey Completion" is "September" [Standard efficiency; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in July fielding; Programmed skip; Refused]
"increase_residential_central_ac_rebates_and_incentives", -- Firm expects an increase in efficient residential central air unit sales compared to standard efficiency equipment over the next two years because of utility or state rebates and incentives [Yes; No; Programmed skip]
"boiler_reset_control_sales_to_single_family_residential", -- Boiler reset controls sold to single family homes of one to four units [Does not sell equipment type; Does sell equipment type; Not applicable-question not asked in September fielding]
"total_number_of_residential_ductless_mini_split_heat_pump_sold_", -- Total number of residential ductless mini-split heat pump units sold in 2013 [0-300; Programmed skip; Refused]
"no_sales_to_single_family_residential", -- None of the mentioned types of equipment sold to single family homes of one to four units [Does not sell equipment type; Does sell equipment type; Not applicable-question not asked in September fielding]
"central_air_sales_to_single_family_residential", -- Central air conditioners sold to single family homes of one to four units [Does not sell equipment type; Does sell equipment type; Not applicable-question not asked in September fielding]
"number_of_residential_ductless_mini_split_heat_pump_not_high_ef", -- The number of residential ductless mini-split heat pump units sold in 2013 that are not high efficiency - less than 14 SEER or less than 11 EER or less than 8.0 HSPF [0-100; Programmed skip; Refused]
"residential_boilers_sales_and_installations_to_single_family_re", -- Boilers sold to and installed in single family homes of one to four units [Does not sell equipment type; Does sell equipment type]
"tank_water_heater_sales_and_installations_to_single_family_resi", -- Storage tank water heaters sold to and installed in single family homes of one to four units [Does not sell equipment type; Does sell equipment type]
"heat_pump_sales_and_installations_to_single_family_residential", -- Heat pumps sold to and installed in single family homes of one to four units [Does not sell and install equipment type; Does sell and install equipment type]
"number_of_residential_ductless_mini_split_heat_pump_tier_1_sold", -- The number of residential ductless mini-split heat pump units sold in 2013 that qualify for Tier One efficiency - 14 SEER or 11 EER or 8 HSPF [0-50; Programmed skip; Refused]
"boiler_reset_control_sales_and_installations_to_single_family_r", -- Boiler reset controls sold to and installed in single family homes of one to four units [Does not sell and install equipment type; Does sell and install equipment type]
"number_of_residential_ductless_mini_split_heat_pump_tier_2_sold", -- The number of residential ductless mini-split heat pump units sold in 2013 that qualify for Tier Two efficiency - 14+ SEER or 12+ EER or 8+ HSPF [0-200; Programmed skip; Refused]
"type_of_residential_packaged_heat_pump_recommended", -- Efficiency level of residential packaged heat pump units that is typically recommended to customers for purchase if "Month of Survey Completion" is "September" [Standard efficiency; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in July fielding; Programmed skip; Refused]
"type_of_residential_ductless_mini_split_heat_pump_recommended", -- Efficiency level of residential ductless mini-split heat pump units that is typically recommended to customers for purchase if "Month of Survey Completion" is "September" [Standard efficiency; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in July fielding; Programmed skip; Refused]
"stock_of_residential_heat_pump", -- Firm maintains a stock of residential heat pump units [Yes; No; Not applicable-question not asked in July fielding; Programmed skip]
"store_purchase_of_residential_heat_pump", -- Firm purchases directly from store for residential heat pump units [Yes; No; Not applicable-question not asked in July fielding; Programmed skip]
"manufacturer_order_of_residential_heat_pump", -- Firm orders from manufacturer representative for residential heat pump units [Yes; No; Not applicable-question not asked in July fielding; Programmed skip]
"wi_fi_thermostat_maintenance_to_single_family_residential", -- Wi-Fi communicating thermostats repaired or maintained in single family homes of one to four units [Does not sell equipment type; Does sell equipment type; Not applicable-question not asked in September fielding]
"number_of_residential_packaged_heat_pumps_serviced_past_year", -- Number of residential packaged heat pump units serviced in the past 12 months in New York State if "Month of Survey Completion" is "September" [None; Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in July fielding; Refused]
"increase_residential_heat_pumps_other", -- Firm expects an increase in efficient residential heat pump unit sales compared to standard efficiency equipment over the next two years because of other reasons [Yes; No; Not applicable-question not asked in July fielding]
"number_of_residential_split_system_heat_pumps_serviced_past_yea", -- Number of residential split system heat pump units serviced in the past 12 months in New York State if "Month of Survey Completion" is "September" [None; Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in July fielding; Refused]
"heat_pump_maintenance_to_single_family_residential", -- Heat pumps repaired or maintained in single family homes of one to four units [Does not sell equipment type; Does sell equipment type; Not applicable-question not asked in September fielding]
"central_air_maintenance_to_single_family_residential", -- Central air conditioners repaired or maintained in single family homes of one to four units [Does not sell equipment type; Does sell equipment type; Not applicable-question not asked in September fielding]
"tankless_water_heater_maintenance_to_single_family_residential", -- Tankless water heaters repaired or maintained in single family homes of one to four units [Does not sell equipment type; Does sell equipment type; Not applicable-question not asked in September fielding]
"increase_residential_heat_pumps_hvac_business_knowledge", -- Firm expects an increase in efficient residential heat pump unit sales compared to standard efficiency equipment over the next two years because HVAC business will be better informed/educated on high efficiency [Yes; No; Not applicable-question not asked in July fielding]
"tank_water_heater_maintenance_to_single_family_residential", -- Storage tank water heaters repaired or maintained in single family homes of one to four units [Does not sell equipment type; Does sell equipment type; Not applicable-question not asked in September fielding]
"increase_residential_heat_pumps_rebates_and_incentives", -- Firm expects an increase in efficient residential heat pump unit sales compared to standard efficiency equipment over the next two years because of utility or state rebates and incentives [Yes; No; Not applicable-question not asked in July fielding]
"expect_increase_in_efficient_residential_central_ac_sales", -- Whether or not the firm expects an increase in efficient residential central air unit sales compared to standard efficiency equipment over the next two years [Yes; No; Programmed skip; Refused]
"residential_boiler_maintenance_to_single_family_residential", -- Boilers repaired or maintained in single family homes of one to four units [Does not sell equipment type; Does sell equipment type; Not applicable-question not asked in September fielding]
"stock_of_residential_central_air", -- Firm maintains a stock of residential central air units [Yes; No; Programmed skip; Refused]
"increase_residential_heat_pumps_federal_tax_credits", -- Firm expects an increase in efficient residential heat pump unit sales compared to standard efficiency equipment over the next two years because of Federal Tax Credits [Yes; No; Not applicable-question not asked in July fielding]
"increase_residential_heat_pumps_federal_standards", -- Firm expects an increase in efficient residential heat pump unit sales compared to standard efficiency equipment over the next two years because of New Federal Standards for minimum efficiency of manufactured units [Yes; No; Not applicable-question not asked in July fielding]
"increase_residential_heat_pumps_equipment_costs_fall", -- Firm expects an increase in efficient residential heat pump unit sales compared to standard efficiency equipment over the next two years because equipment costs will come down [Yes; No; Not applicable-question not asked in July fielding]
"residential_furnace_sales_and_installations_to_single_family_re", -- Furnaces sold to and installed in single family homes of one to four units [Does not sell equipment type; Does sell equipment type]
"residential_furnace_maintenance_to_single_family_residential", -- Furnaces repaired or maintained in single family homes of one to four units [Does not sell equipment type; Does sell equipment type; Not applicable-question not asked in September fielding]
"number_of_residential_oil_boilers_not_high_efficiency_sold_2013", -- The number of residential oil boiler units sold in 2013 that are not high efficiency - less than 85% AFUE [0-20; Programmed skip; Refused]
"increase_residential_boilers_federal_standards", -- Firm expects an increase in efficient residential boiler sales compared to standard efficiency equipment over the next two years because of New Federal Standards for minimum efficiency of manufactured units [Yes; No; Programmed skip]
"expect_increase_in_efficient_residential_furnaces_sales", -- Whether or not the firm expects an increase in efficient residential furnace sales compared to standard efficiency equipment over the next two years [Yes; No; Programmed skip; Refused]
"total_number_of_residential_gas_furnaces_sold_2013", -- Total number of residential gas furnace units sold in 2013 [1-2500; Programmed skip; Refused]
"other_source_of_residential_furnaces", -- Whether or not there is another source of residential gas- and oil-fired furnaces [Yes; No; Programmed skip; Refused]
"manufacturer_order_of_residential_furnaces", -- Firm orders from manufacturer representative for residential gas- and oil-fired furnaces [Yes; No; Programmed skip; Refused]
"event_frequency_level_during_new_residential_hvac_installat_003", -- Frequency of performing the test of verifying the airflow through the indoor blower unit (e.g. furnaces, fan coil, air handler) is within acceptable CFM ranges when installing new residential HVAC equipment on a scale of one to five where one is usually not done and five is always done [Always done; Often done; Sometimes done; Rarely done; Usually not done; Refused]
"number_of_part_time_employees_in_new_york", -- Number of part-time employees that work for the firm within the State of New York [0-3; Refused]
"residential_customers_county_4", -- Fourth New York State county in which the company's residential single family home customers are located [e.g, Albany - Yates; No more counties mentioned]
"distributor_order_of_residential_furnaces", -- Firm orders from distributor for residential gas- and oil-fired furnaces [Yes; No; Programmed skip; Refused]
"residential_customers_county_3", -- Third New York State county in which the company's residential single family home customers are located [e.g, Albany - Yates; No more counties mentioned]
"stock_of_residential_furnaces", -- Firm maintains a stock of residential gas- and oil-fired furnaces [Yes; No; Programmed skip; Refused]
"central_air_sales_and_installations_to_single_family_residentia", -- Central air conditioners sold to and installed in single family homes of one to four units [Does not sell and install equipment type; Does sell and install equipment type]
"tankless_water_heater_sales_and_installations_to_single_family_", -- Tankless water heaters sold to and installed in single family homes of one to four units [Does not sell and install equipment type; Does sell and install equipment type]
"store_purchase_of_residential_furnaces", -- Firm purchases directly from store for residential gas- and oil-fired furnaces [Yes; No; Programmed skip; Refused]
"type_of_residential_oil_furnace_recommended", -- Efficiency level of residential oil furnaces that is typically recommended to customers for purchase if "Month of Survey Completion" is "September" [Standard efficiency; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in July fielding; Programmed skip; Refused]
"type_of_residential_gas_furnace_recommended", -- Efficiency level of residential gas furnaces that is typically recommended to customers for purchase if "Month of Survey Completion" is "September" [Standard efficiency; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in July fielding; Programmed skip; Refused]
"increase_residential_boilers_federal_tax_credits", -- Firm expects an increase in efficient residential boiler sales compared to standard efficiency equipment over the next two years because of Federal Tax Credits [Yes; No; Programmed skip]
"increase_residential_boilers_rebates_and_incentives", -- Firm expects an increase in efficient residential boiler sales compared to standard efficiency equipment over the next two years because of utility or state rebates and incentives [Yes; No; Programmed skip]
"residential_boiler_sales_to_single_family_residential", -- Boilers sold to single family homes of one to four units [Does not sell equipment type; Does sell equipment type; Not applicable-question not asked in September fielding]
"increase_residential_boilers_new_technology", -- Firm expects an increase in efficient residential boiler sales compared to standard efficiency equipment over the next two years because of the availability of improved or new technologies [Yes; No; Programmed skip]
"event_frequency_level_during_new_residential_hvac_installat_004", -- Frequency of performing the test of confirming heating and cooling equipment are properly matched systems using industry-recognized product certification database such as AHRI, CEE, or OEM performance data when installing new residential HVAC equipment on a scale of one to five where one is usually not done and five is always done [Always done; Often done; Sometimes done; Rarely done; Usually not done; Refused]
"event_frequency_level_during_new_residential_hvac_installat_005", -- Frequency of performing the test of conducting building ventilation calculations when installing new residential HVAC equipment on a scale of one to five where one is usually not done and five is always done [Always done; Often done; Sometimes done; Rarely done; Usually not done; Refused]
"number_of_residential_boilers_serviced_past_year", -- Number of residential furnace units serviced in the past 12 months in New York State if "Month of Survey Completion" is "July" [Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in September fielding; Refused]
"number_of_residential_oil_furnaces_not_high_efficiency_sold_201", -- The number of residential oil furnace units sold in 2013 that are not high efficiency - less than 85% AFUE [e.g., 0-10; Programmed skip; Refused]
"total_number_of_residential_oil_furnaces_sold_2013", -- Total number of residential oil furnace units sold in 2013 [0-40; Programmed skip; Refused]
"number_of_residential_oil_fired_boilers_serviced_past_year", -- Number of residential oil furnace units serviced in the past 12 months in New York State if "Month of Survey Completion" is "September" [Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in July fielding; Refused]
"number_of_residential_gas_furnaces_tier_3_sold_2013", -- The number of residential gas furnace units sold in 2013 that qualify for Tier Three efficiency - 94% AFUE and above [0-800; Programmed skip; Refused]
"number_of_residential_gas_furances_tier_2_sold_2013", -- The number of residential gas furnace units sold in 2013 that qualify for Tier Two efficiency - greater than 92% AFUE but less than 94% [0-800; Programmed skip; Refused]
"total_number_of_residential_gas_tank_water_heaters_sold_2013", -- Total number of residential gas tank water heater units sold in 2013 [1-6500; Programmed skip; Refused]
"number_of_residential_gas_furnaces_tier_1_sold_2013", -- The number of residential gas furnace units sold in 2013 that qualify for Tier One efficiency - greater than 90% AFUE but less than 92% [0-800; Programmed skip; Refused]
"number_of_residential_gas_furnaces_not_high_efficiency_sold_201", -- The number of residential gas furnace units sold in 2013 that are not high efficiency - less than 90% AFUE [0-50; Programmed skip; Refused]
"required_technician_certification_other", -- Firm-required industry certification from another source for its HVAC technicians if "Required Technician Certification" is "Yes" [e.g., Affirmative answer; training is required - Answer not chosen]
"number_of_full_time_employees_in_new_york", -- Number of full-time employees that work for the firm within the State of New York [0-50; Refused]
"residential_customers_county_5", -- Fifth New York State county in which the company's residential single family home customers are located [e.g, Albany - Yates; No more counties mentioned]
"residential_customers_county_2", -- Second New York State county in which the company's residential single family home customers are located [e.g, Albany - Yates; No more counties mentioned]
"event_frequency_level_during_new_residential_hvac_installat_006", -- Frequency of performing the test of verifying the water flow through indoor heat exchangers are within acceptable ranges - referring to boilers - when installing new residential HVAC equipment on a scale of one to five where one is usually not done and five is always done [Always done; Often done; Sometimes done; Rarely done; Usually not done; Refused]
"residential_customers_county_1", -- First New York State county in which the company's residential single family home customers are located [e..g, Albany - Yates; Refused]
"event_frequency_level_during_new_residential_hvac_installat_007", -- Frequency of performing the test of ensuring the HVAC system has the proper refrigerant charge when installing new residential HVAC equipment on a scale of one to five where one is usually not done and five is always done [Always done; Often done; Sometimes done; Rarely done; Usually not done; Refused]
"test_frequency_level_during_residential_hvac_installation_o_002", -- Frequency of performing the test of conducting duct pressurization tests when installing or servicing residential HVAC equipment on a scale of one to five where one is usually not usually conducted and five is always conducted [Always done; Often done; Sometimes done; Rarely done; Usually not done; Refused]
"familiarity_with_non_electric_heating_programs", -- Level of familiarity with programs offered in New York State to promote energy efficient non-electric heating and water heating equipment [Very familiar; Somewhat familiar; Not at all familiar; Refused]
"number_of_residential_gas_tank_water_heaters_not_high_efficienc", -- The number of residential gas tank water heater units sold in 2013 that are not high efficiency - less than .67 EF [0-200; Programmed skip; Refused]
"number_of_residential_gas_tank_water_heaters_tier_1_sold_2013", -- The number of residential gas tank water heater units sold in 2013 that qualify for Tier One efficiency - greater than .67 EF but less than .80 EF [0-6500; Programmed skip; Refused]
"number_of_residential_gas_tank_water_heaters_tier_2_sold_2013", -- The number of residential gas tank water heater units sold in 2013 that qualify for Tier Two efficiency - .80 EF and above [0-250; Programmed skip; Refused]
"type_of_residential_boiler_recommended", -- Efficiency level of residential boilers that is typically recommended to customers for purchase if "Month of Survey Completion" is "July" [Standard efficiency; Tier 1; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in September fielding; Don't know; Programmed skip; Refused]
"type_of_residential_oil_boiler_recommended", -- Efficiency level of residential oil boilers that is typically recommended to customers for purchase if "Month of Survey Completion" is "September" [Standard efficiency; Tier 1; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in July fielding; Programmed skip; Refused]
"total_number_of_residential_oil_tank_water_heaters_sold_2013", -- Total number of residential oil tank water heater units sold in 2013 [0-10; Programmed skip; Refused]
"awareness_of_new_federal_standards_for_water_heaters", -- Awareness of new federal standards that may affect the manufacture of energy efficient non-electric water heating equipment in New York State if "Awareness of New Federal Standards for Non-Electric Heating" is "No" or "Not Sure" or "Awareness of New Federal Standards for Non-Electric Heating" is "Yes" and "Awareness of New Federal Standards for Non-Electric Heating" is unanswered [Yes; No; Not sure; Programmed skip; Refused]
"total_number_of_residential_oil_boilers_sold_2013", -- Total number of residential oil boiler units sold in 2013 [0-500; Programmed skip; Refused]
"company_skill_level_system_refrigerant", -- Firm self-rating in skills regarding diagnosing techniques for ensuring adequate system refrigerant charging on a scale of one to five where one is not at all proficient and five is extremely proficient [Not at all proficient; Somewhat proficient; Proficient; Very proficient; Extremely proficient; Refused]
"speaking_with_employee_most_familiar_hvac_sales_practices", -- Verification that the survey respondent is the person most familiar with the company's heating and cooling equipment sales, installation, servicing, and maintenance practices in the State of New York [ Yes, No]
"survey_completion", -- Completion status of the survey [Completed survey - Partial survey]; 1 = Complete, 0 = Partial.
"increase_residential_furnaces_hvac_business_knowledge", -- Firm expects an increase in efficient residential furnace sales compared to standard efficiency equipment over the next two years because HVAC business will be better informed/educated on high efficiency [Yes; No; Programmed skip]
"type_of_residential_furnace_recommended", -- Efficiency level of residential furnaces that is typically recommended to customers for purchase if "Month of Survey Completion" is "July" [Tier 1; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in September fielding; Programmed skip; Refused]
"number_of_residential_oil_furnaces_tier_1_sold_2013", -- The number of residential oil furnace units sold in 2013 that qualify for Tier One efficiency - 85% AFUE and above [e.g., 0-40; Programmed skip; Refused]
"wi_fi_thermostat_sales_and_installations_to_single_family_resid", -- Wi-Fi communicating thermostats sold to and installed in single family homes of one to four units [Does not sell and install equipment type; Does sell and install equipment type]
"increase_residential_furnaces_new_technology", -- Firm expects an increase in efficient residential furnace sales compared to standard efficiency equipment over the next two years because of the availability of improved or new technologies [Yes; No; Programmed skip]
"increase_residential_non_electric_water_heaters_federal_standar", -- Firm expects an increase in efficient residential non-electric water heater sales compared to standard efficiency equipment over the next two years because of New Federal Standards for minimum efficiency of manufactured units [Yes; No; Programmed skip]
"number_of_residential_oil_tank_water_heaters_not_high_efficienc", -- The number of residential oil tank water heater units sold in 2013 that are not high efficiency - less than .59 EF [0-5; Programmed skip; Refused]
"manufacturer_order_of_residential_non_electric_water_heaters", -- Firm orders from manufacturer representative for residential non-electric water heaters [Yes; No; Refused]
"number_of_residential_oil_tank_water_heaters_tier_1_sold_2013", -- The number of residential oil tank water heater units sold in 2013 that qualify for Tier One efficiency - .59 EF and above [0-10; Programmed skip; Refused]
"required_technician_training_other", -- Firm requires another type of training for its technicians if "Required Technician Training" is "Yes" [e.g., Affirmative answer; training is required - Answer not chosen]
"industry_reference_none", -- No sources used as industry references to ensure quality installation of residential HVAC equipment [e.g., Affirmative answer; source is used - No, or source not mentioned]
"early_retirement_by_percentage_of_units_tankless_water_heaters", -- Size of impact in terms of percentage of tankless water heater units retired early as opposed to replaced on failure if "Observed Increase in Early Retirement of Equipment" is "Yes" [0-100%; Don't know; Programmed skip; Refused]
"total_number_of_residential_packaged_central_air_sold_2013", -- Total number of residential packaged central air units sold in 2013 [0-500; Programmed skip; Refused]
"total_number_of_residential_gas_tankless_water_heaters_sold_201", -- Total number of residential gas tankless water heater units sold in 2013 [0-100; Programmed skip; Refused]
"number_of_residential_gas_tank_water_heaters_serviced_2013", -- Number of residential gas tank water heater units serviced in the past 12 months in New York State if "Month of Survey Completion" is "September" [Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in July fielding; Refused]
"type_of_residential_oil_tank_water_heater_recommended", -- Efficiency level of residential oil tank water heaters that is typically recommended to customers for purchase if "Month of Survey Completion" is "September" [Standard efficiency; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in July fielding; Programmed skip; Refused]
"number_of_residential_gas_boilers_serviced_past_year", -- Number of residential gas furnace units serviced in the past 12 months in New York State if "Month of Survey Completion" is "September" [Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in July fielding; Refused]
"increase_residential_furnaces_rebates_and_incentives", -- Firm expects an increase in efficient residential furnace sales compared to standard efficiency equipment over the next two years because of utility or state rebates and incentives [Yes; No; Programmed skip]
"number_of_seasonal_employees_in_new_york", -- Number of seasonal employees that work for the firm within the State of New York [0-3; Refused]
"years_providing_hvac_to_new_york", -- Length of time in years that the company has been providing HVAC services to customers located in the State of New York [0-150]
"percentage_of_residential_business_multifamily_low_rise", -- Percentage of residential business in terms of percent of jobs that is attributable to multifamily low-rise buildings with five or more units in three stories or less [0-100%; Not applicable-question not asked in September fielding]
"company_skill_level_air_distribution_systems", -- Firm self-rating in skills regarding designing, installing, replacing, and fixing air distribution systems on a scale of one to five where one is not at all proficient and five is extremely proficient [Not at all proficient; Somewhat proficient; Proficient; Very proficient; Extremely proficient; Refused]
"number_of_residential_packaged_central_air_not_high_efficiency_", -- The number of residential packaged central air units sold in 2013 that are not high efficiency - less than 14 SEER or less than 11 EER [0-10; Programmed skip; Refused]
"number_of_residential_packaged_central_air_tier_1_sold_2013", -- The number of residential packaged central air units sold in 2013 that qualify for Tier One efficiency - 14 SEER or 11 EER but less than 12 [0-500; Programmed skip; Refused]
"total_number_of_residential_condensing_gas_water_heaters_sold_2", -- Total number of residential condensing gas water heater units sold in 2013 [0-50; Programmed skip; Refused]
"number_of_residential_condensing_gas_water_heaters_not_high_eff", -- The number of residential condensing gas water heater units sold in 2013 that are not high efficiency - less than .80 EF [0-50; Programmed skip; Refused]
"type_of_residential_gas_tank_water_heater_recommended", -- Efficiency level of residential gas tank water heaters that is typically recommended to customers for purchase if "Month of Survey Completion" is "September" [Standard efficiency; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in July fielding; Programmed skip; Refused]
"other_source_of_residential_boilers", -- Description of other source of residential gas- and oil-fired boilers [Yes; No; Programmed skip; Refused]
"required_technician_training_electrical", -- Firm requires electrical training for its technicians if "Required Technician Training" is "Yes" [e.g., Affirmative answer; training is required - Answer not chosen]
"required_technician_training", -- Firm-required HVAC training courses on energy efficiency, quality maintenance, or quality installation for its technicians Firm-required HVAC training courses on energy efficiency, quality maintenance, or quality installation for its technicians
"contractor_size_small_10_large", -- Contractor size is either small (<= 10 employees) or large (>10 employees) [Small - Large]
"contractor_county", -- NYS County where the HVAC contractor is located [e.g., Albany - Yates]
"familiarity_with_tiered_efficiency_levels", -- Familiarity with the Consortium for Energy Efficiency (CEE) and ENERGY STAR® tiered efficiency levels - these are generally categorized into two or three tiers of efficiency levels. NYSERDA and many of the electric and gas utilities in New York State used these tiers to establish rebate levels [Very familiar; Somewhat familiar; Not too familiar; Not at all familiar; Don't know; Refused]
"industry_reference_acca", -- Air Conditioning Contractors of America (ACCA) used as an industry reference to ensure quality installation of residential HVAC equipment [e.g., Affirmative answer; source is used - No, or source not mentioned]
"number_of_residential_packaged_central_air_serviced_past_year", -- Number of residential packaged central air units serviced in the past 12 months in New York State if "Month of Survey Completion" is "September" [None; Less than 5; 5 to 20; 21 to 50; 51 to 100; More than 100; Not applicable-question not asked in July fielding; Refused]
"type_of_residential_gas_tankless_water_heater_recommended", -- Efficiency level of residential gas tankless water heaters that is typically recommended to customers for purchase if "Month of Survey Completion" is "September" [Standard efficiency; Tier 2 or Tier 3 if available (Highest Efficiency); Not applicable-question not asked in July fielding; Programmed skip; Refused]
"percentage_water_heaters_sold_with_heat_pump_past_year" -- Approximate percentage of residential water heater units sold in 2013 that were heat pump water heaters [0-100%; Programmed skip; Refused]
FROM
"ny-gov/rsbs-hvac-new-york-state-residential-statewide-aee3-5gf5:latest"."rsbs_hvac_new_york_state_residential_statewide"
LIMIT 100;Connecting to the DDN is easy. All you need is an existing SQL client that can connect to Postgres. As long as you have a SQL client ready, you'll be able to query ny-gov/rsbs-hvac-new-york-state-residential-statewide-aee3-5gf5 with SQL in under 60 seconds.
Query Your Local Engine
Install Splitgraph Locally
bash -c "$(curl -sL https://github.com/splitgraph/splitgraph/releases/latest/download/install.sh)"Read the installation docs.
Splitgraph Cloud is built around Splitgraph Core (GitHub), which includes a local Splitgraph Engine packaged as a Docker image. Splitgraph Cloud is basically a scaled-up version of that local Engine. When you query the Data Delivery Network or the REST API, we mount the relevant datasets in an Engine on our servers and execute your query on it.
It's possible to run this engine locally. You'll need a Mac, Windows or Linux system to install sgr, and a Docker installation to run the engine. You don't need to know how to actually use Docker; sgrcan manage the image, container and volume for you.
There are a few ways to ingest data into the local engine.
For external repositories, the Splitgraph Engine can "mount" upstream data sources by using sgr mount. This feature is built around Postgres Foreign Data Wrappers (FDW). You can write custom "mount handlers" for any upstream data source. For an example, we blogged about making a custom mount handler for HackerNews stories.
For hosted datasets (like this repository), where the author has pushed Splitgraph Images to the repository, you can "clone" and/or "checkout" the data using sgr cloneand sgr checkout.
Cloning Data
Because ny-gov/rsbs-hvac-new-york-state-residential-statewide-aee3-5gf5:latest is a Splitgraph Image, you can clone the data from Spltgraph Cloud to your local engine, where you can query it like any other Postgres database, using any of your existing tools.
First, install Splitgraph if you haven't already.
Clone the metadata with sgr clone
This will be quick, and does not download the actual data.
sgr clone ny-gov/rsbs-hvac-new-york-state-residential-statewide-aee3-5gf5Checkout the data
Once you've cloned the data, you need to "checkout" the tag that you want. For example, to checkout the latest tag:
sgr checkout ny-gov/rsbs-hvac-new-york-state-residential-statewide-aee3-5gf5:latestThis will download all the objects for the latest tag of ny-gov/rsbs-hvac-new-york-state-residential-statewide-aee3-5gf5 and load them into the Splitgraph Engine. Depending on your connection speed and the size of the data, you will need to wait for the checkout to complete. Once it's complete, you will be able to query the data like you would any other Postgres database.
Alternatively, use "layered checkout" to avoid downloading all the data
The data in ny-gov/rsbs-hvac-new-york-state-residential-statewide-aee3-5gf5:latest is 0 bytes. If this is too big to download all at once, or perhaps you only need to query a subset of it, you can use a layered checkout.:
sgr checkout --layered ny-gov/rsbs-hvac-new-york-state-residential-statewide-aee3-5gf5:latestThis will not download all the data, but it will create a schema comprised of foreign tables, that you can query as you would any other data. Splitgraph will lazily download the required objects as you query the data. In some cases, this might be faster or more efficient than a regular checkout.
Read the layered querying documentation to learn about when and why you might want to use layered queries.
Query the data with your existing tools
Once you've loaded the data into your local Splitgraph Engine, you can query it with any of your existing tools. As far as they're concerned, ny-gov/rsbs-hvac-new-york-state-residential-statewide-aee3-5gf5 is just another Postgres schema.