About this Dataset

Better Buildings Neighborhood Program Single-Family Home Upgrade Project Dataset

Building project data for 75,110 single-family homes upgraded between July 1, 2010, and September 30, 2013 from the Better Building Neighborhood Program. This dataset includes a documentation file and three data tables. Reported data for some elements have been transformed and data for some upgraded homes have been omitted to protect privacy. See documentation file for details.
Organization: Department of Energy
Last updated: 2023-05-17T00:59:32.035480
Tags: arra, bbnp, better-buildings-neighborhood-program, build, building, building-data, building-efficiency, buildings, built, data, efficiency, energy, energy-efficiency, home, outreach, raw-data, recovery-act, residential, sing-family, size, specifications, specs, united-states, year

Tables

BBNP Single-family Home Project Data Installed Measures Table

@usgov.doe_gov_better_buildings_neighborhood_program_single_f_eaa5d100.bbnp_single_family_home_project_data_installed_measures_table

779.5 kB
75,110 rows
89 columns

CREATE TABLE bbnp_single_family_home_project_data_installed_measures_table (
  "awardeenumber" BIGINT,
  "projectid" BIGINT,
  "inst_furnace" BIGINT,
  "inst_furnace_afue" DOUBLE,
  "inst_furnace_fuel" VARCHAR,
  "inst_boiler" BIGINT,
  "inst_boiler_afue" DOUBLE,
  "inst_boiler_fuel" VARCHAR,
  "inst_wood_stove" BIGINT,
  "inst_water_heater" BIGINT,
  "inst_water_heater_fuel" VARCHAR,
  "inst_water_heater_ef" DOUBLE,
  "inst_heat_pump" BIGINT,
  "inst_heat_pump_type" VARCHAR,
  "inst_heat_pump_cop" DOUBLE,
  "inst_heat_pump_eer" DOUBLE,
  "inst_heat_pump_hspf" DOUBLE,
  "inst_heat_pump_seer" DOUBLE,
  "inst_ac" BIGINT,
  "inst_ac_seer" DOUBLE,
  "inst_ac_eer" DOUBLE,
  "inst_vent_sys" BIGINT,
  "inst_vent_sys_cat" VARCHAR,
  "inst_vent_sys_type" VARCHAR,
  "inst_insul_attic" DOUBLE,
  "inst_insul_attic_r" DOUBLE,
  "inst_insul_attic_thick" DOUBLE,
  "inst_duct_insul" BIGINT,
  "inst_duct_insul_r" DOUBLE,
  "inst_insul_wall" DOUBLE,
  "inst_insul_wall_r" DOUBLE,
  "inst_insul_wall_ext_r" DOUBLE,
  "inst_insul_wall_thick" DOUBLE,
  "inst_insul_flr_fnd" DOUBLE,
  "inst_insul_flr_fnd_r" DOUBLE,
  "inst_windows" DOUBLE,
  "rep_windows" DOUBLE,
  "inst_windows_u" DOUBLE,
  "inst_windows_shgc" DOUBLE,
  "inst_windows_storm" DOUBLE,
  "inst_air_sealing" BIGINT,
  "inst_air_sealing_cfm50pre" DOUBLE,
  "inst_air_sealing_cfm50post" DOUBLE,
  "inst_duct_sealing" BIGINT,
  "inst_duct_sealing_cfm25pre" DOUBLE,
  "inst_duct_sealing_cfm25post" DOUBLE,
  "inst_refrig" BIGINT,
  "rmv_furnace" BIGINT,
  "rmv_boiler" BIGINT,
  "rmv_wood_stove" BIGINT,
  "rmv_heat_pump" BIGINT,
  "rmv_water_heater" BIGINT,
  "rmv_ac" BIGINT,
  "rmv_vent_sys" BIGINT,
  "rmv_insul_attic" BIGINT,
  "rmv_insul_wall" BIGINT,
  "rmv_insul_flr_fnd" BIGINT,
  "rmv_windows" BIGINT,
  "rmv_refrig" BIGINT,
  "inst_furnace_tune" BIGINT,
  "inst_ac_tune" BIGINT,
  "inst_dishwasher" BIGINT,
  "inst_doors" BIGINT,
  "inst_fireplace_insert" BIGINT,
  "inst_freezer" BIGINT,
  "inst_hvac_upgrade" BIGINT,
  "inst_hvac_tune" BIGINT,
  "inst_lighting" BIGINT,
  "inst_other" BIGINT,
  "inst_pckg_unit_ht" BIGINT,
  "inst_clth_wash" BIGINT,
  "inst_water_conserv" BIGINT,
  "inst_dhw_insul" BIGINT,
  "inst_wthr_strpng" BIGINT,
  "inst_lowflow" BIGINT,
  "inst_prgm_tstat" BIGINT,
  "inst_thermo_vlv" BIGINT,
  "inst_insul_bsmt" BIGINT,
  "inst_rad_barrier" BIGINT,
  "inst_core_energy" BIGINT,
  "inst_health_safety" BIGINT,
  "inst_insul_other" BIGINT,
  "inst_chimney_liner" BIGINT,
  "inst_smart_strips" BIGINT,
  "rmv_air_sealing" BIGINT,
  "rmv_duct_insul" BIGINT,
  "rmv_duct_sealing" BIGINT,
  "rmv_dhw_insul" BIGINT,
  "inst_other_value" BIGINT
);

BBNP Single-family Home Project Data Marketing Outreach Table

@usgov.doe_gov_better_buildings_neighborhood_program_single_f_eaa5d100.bbnp_single_family_home_project_data_marketing_outreach_table

35.78 kB
5,500 rows
4 columns

CREATE TABLE bbnp_single_family_home_project_data_marketing_outreach_table (
  "awardeenumber" BIGINT,
  "projectid" BIGINT,
  "reasonforparticipation" VARCHAR,
  "outreachchannel" VARCHAR
);

BBNP Single-family Home Project Data Table

@usgov.doe_gov_better_buildings_neighborhood_program_single_f_eaa5d100.bbnp_single_family_home_project_data_table

1.21 MB
75,110 rows
31 columns

CREATE TABLE bbnp_single_family_home_project_data_table (
  "awardeenumber" BIGINT,
  "projectid" BIGINT,
  "retrofitjobhours" DOUBLE,
  "retrofitinvoicedcost" DOUBLE,
  "buildingactivitytype" DOUBLE,
  "occupancy" DOUBLE,
  "islowincome" VARCHAR,
  "floorarea" VARCHAR,
  "floorareaunit" VARCHAR,
  "isdirectinstallationused" VARCHAR,
  "loanamount" DOUBLE,
  "install_elect_savings_kwh" DOUBLE,
  "install_ng_savings_therms" DOUBLE,
  "install_fo_savings_gal" BIGINT,
  "install_lpg_savings_gal" BIGINT,
  "install_kero_savings_gal" BIGINT,
  "install_wood_savings_mmbtu" BIGINT,
  "auditsoftwarename" VARCHAR,
  "predictionmethodtypedesc" VARCHAR,
  "decadebuilt" VARCHAR,
  "state" VARCHAR,
  "state_based_on" VARCHAR,
  "annualcostsavings" DOUBLE,
  "retrofitstartmonthyear" VARCHAR,
  "retrofitcompletionmonthyear" VARCHAR,
  "daysfromretrofitstarttocompletion" DOUBLE,
  "auditcompletionmonthyear" VARCHAR,
  "daysfromauditcompletiontoretrofitstart" DOUBLE,
  "loanapprovalmonthyear" VARCHAR,
  "auditjobhours" DOUBLE,
  "auditinvoicedcost" DOUBLE
);