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.035476
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 Documentation

@usgov.doe_gov_better_buildings_neighborhood_program_single_f_eaa5d100.bbnp_single_family_home_project_data_documentation

1.15 MB
75110 rows
31 columns


CREATE TABLE bbnp_single_family_home_project_data_documentation (
  "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
);

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

761.23 KB
75110 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

34.94 KB
5500 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.15 MB
75110 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
);