ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
Home Energy Score Partner Data Dump
2
3
Header Definitions
4
5
For data elements with yes/no inputs, 0 = No 1 = Yes
6
If the data was submitted by API and no upgrade scenario was "requested", the "package" fields will be blank
7
Construction codes translations and expected field values are provided on 2nd tab.
Light Green Cells indicate new columns for this version (2023)
8
9
qualified_assessor_idlabel_numberbuilding_idweather_station_locationcreate_label_datecooling_presentsource_energy_total_basesource_energy_total_packagesource_energy_asset_basesource_energy_asset_packagebase_costpackage_costsource_eui_basesource_eui_packagebase_scorepackage_scoresite_energy_basesite_energy_packagesite_eui_basesite_eui_packagecarbon_basecarbon_packageutility_electric_baseutility_natural_gas_baseutility_fuel_oil_baseutility_lpg_baseutility_cord_wood_baseutility_pellet_wood_baseutility_electric_packageutility_natural_gas_packageutility_fuel_oil_packageutility_lpg_packageutility_cord_wood_packageutility_pellet_wood_packageutility_generated_baseutility_generated_packageassessment_typeassessment_datecommentsaddresscitystatezip_codeshapetown_house_wallsyear_builtnumber_bedroomsnum_floor_above_gradefloor_to_ceiling_heightconditioned_floor_areaorientationblower_door_testair_sealing_presentenvelope_leakagewall_construction_samewindow_construction_samehvac.0.heating.typehvac.0.heating.fuel_primaryhvac.0.heating.efficiency_methodhvac.0.heating.yearhvac.0.heating.efficiencyhvac.0.cooling.typehvac.0.cooling.efficiency_methodhvac.0.cooling.yearhvac.0.cooling.efficiencyhvac.0.hvac_namehvac.0.hvac_fractionhvac.1.heating.typehvac.1.heating.fuel_primaryhvac.1.heating.efficiency_methodhvac.1.heating.yearhvac.1.heating.efficiencyhvac.1.cooling.typehvac.1.cooling.efficiency_methodhvac.1.cooling.yearhvac.1.cooling.efficiencyhvac.1.hvac_namehvac.1.hvac_fractiondomestic_hot_water.categorydomestic_hot_water.typedomestic_hot_water.fuel_primarydomestic_hot_water.efficiency_methoddomestic_hot_water.yeardomestic_hot_water.energy_factorroof.0.roof_nameroof.0.roof_arearoof.0.roof_assembly_coderoof.0.roof_colorroof.0.roof_absorptanceroof.0.roof_typeroof_0_ceiling_arearoof.0.ceiling_assembly_coderoof_0_knee_wall_arearoof_0_knee_wall_assembly_coderoof.0.skylight_arearoof.0.skylight_methodroof.0.skylight_coderoof.0.skylight_u_valueroof.0.skylight_shgcroof.1.roof_name
10
Units
11
Mbtu/yrMbtu/yrMbtu/yrMbtu/yr$$kBtu/sq ft/yrkBtu/sq ft/yrMbtu/yrMbtu/yrkBtu/sq ft/yrkBtu/sq ft/yrlbs/yrlbs/yrkWh/yrtherms/yrgals/yrgals/yr#/yrlbs/yrkWh/yrtherms/yrgals/yrgals/yr#/yrlbs/yrkwhkwh
12
GeneralEnergy Use NumbersScoreEnergy Use NumbersGeneralHouse addressPrimary House CharacteristicsHVAC System 1 CharacteristicsHVAC System 2 CharacteristicsWater Heating SystemFirst Roof Characteristics2nd Roof Characteristics
13
ID used to identify the assessor who created the Home Energy ScoreHome Energy Score Label #Same as label#Name of the weather station used to calculate the energy useThe date the label was created in the Home Energy Scoring ToolIs the house air conditioned?estimated total source energy in the existing house in Mbtusesitmated total source energy for the upgraded houseTotal source energy for heating, cooling and hot water for the existing houseTotal source energy for heating, cooling and hot water for the upgraded houseestimated total utility bills for all fuels for existing houseestimated total energy cost of the upgraded house.estimated total source energy intensity for all fuels in the existing houseestimated total source energy intensity for all fuels in the upgraded houseThe Home Energy Score for the existing houseThe Home Energy Score if all retrofit recommendations are implementedestimated total site energy for the existing houseestimated total site energy of the upgraded houseestimated total site energy intesity for the existing houseestimated total site energy intensity for the upgraded houseestimated CO2 equivalent emissions of the existing houseestimated CO2 equivalent emissions of the upgraded house. estimated site electricity use for existing houseestimated site fuel oil use for existing house estimated site natural gas use for existing houseestimated site propane/lpg use for existing houseestimated site wood (cord) use for existing houseestimated site wood pellet use for existing houseestimated site electricity use in the upgraded houseestimated site fuel oil use in the upgraded houseestimated site natural gas use in the upgraded houseestimated site propane/lpb use in the upgraded houseestimated site cord wood use in the upgraded houseestimated site pellet wood use in the upgrade house estimated site energy from the PV systemestimated site energy from the PV systemassessment typeassessment date, the date the assessor entered as the date he/she was on sitecomments provided by assessorrectangle (single family) or townhouseif it is a townhouse, what walls are exposed to outside conditionsyear builtHow many bedrooms are in the houseHome many strories are above ground levelaverage ceiling heightconditioned floor areahouse orientation in degreeswas a blower door test conducted?has the house been professionally air sealed?blower door leakage rate in CFM50are the walls the same on all 4 sides of the house? are the windows the same on all 4 sides of the house?heating system typeheating fuelDid the assessor provide the efficiency or the installation dateheating equipment purchase/install yearheating equipment efficiency as AFUE, HSPF or COP depending on system typea/c system typeDid the assessor provide the efficiency or the installation datea/c install/purchase yeara/c efficiency in SEER, EER or COP, depending on equipment typeFirst HVAC system name, always "hvac1"How much of the house conditioning load is provided by the first HVAC systemheating system typeheating fuelDid the assessor provide the efficiency or the installation dateheating equipment purchase/install yearheating equipment efficiency as AFUE, HSPF or COP depending on system typea/c system typeDid the assessor provide the efficiency or the installation datea/c install/purchase yeara/c efficiency in SEER, EER or COP, depending on equip typeSecond HVAC system name - always "hvac2"How much of the house conditioning load is provided by the second HVAC systemdoes the water heater work on its own or is it attached to the heating systemdoes the water heater have a storage tank?what fuel is used to heat waterDid the assessor provide the efficiency or the installation datedhw equipment purchase/install yearwater heater efficiency (Energy Factor)The "name" for the first roof characterized, always "roof1"The roof area (cathedral ceilings)The code used to characterize the roof construction and insulation levelThe color of the roofif the roof color is "cool roof", the roof absorptance will be shown hereWhat type of attic overlies this portion of the houseThe ceiling area (unconditioned attics)The code used to characterize the attic constrution and insulation levelThe knee wall area attached to undonditioned attic over this portion of the houseThe code used to characterize the kneewall constrution and insulation levelThe combined area of the skylightsDid the assessor use the construction code or SHGC and U-factor to characterize the skylightsThe code to characterize the skylight characteristicsU-value of the skylighsSkylight Solar Heat Gain Coefficient of the skylightsThe "name" for the second roof characterized, always "roof2"
14
combine all fuels usedcombine all fuels usedcombine all fuels usedcombine all fuels usedcombine all fuels usedcombine all fuels usedcombine all fuels usedcombine all fuels usedcombine all fuels usedcombine all fuels usedcombine all fuels usedcombine all fuels usedthese are the same because HEScore does not provide PV recommendationsuser = efficency, shipment_weighted = dateuser = efficency, shipment_weighted = dateuser = efficency, shipment_weighted = dateuser = efficency, shipment_weighted = dateuser = efficency, shipment_weighted = datecode = window components code
custom = SHGC/Ufactor
15
16
17
Example Data
18
qualified_assessor_idlabel_numberbuilding_idweather_station_locationcreate_label_datecooling_presentsource_energy_total_basesource_energy_total_packagesource_energy_asset_basesource_energy_asset_packagebase_costpackage_costsource_eui_basesource_eui_packagebase_scorepackage_scoresite_energy_basesite_energy_packagesite_eui_basesite_eui_packagecarbon_basecarbon_packageutility_electric_baseutility_natural_gas_baseutility_fuel_oil_baseutility_lpg_baseutility_cord_wood_baseutility_pellet_wood_baseutility_electric_packageutility_natural_gas_packageutility_fuel_oil_packageutility_lpg_packageutility_cord_wood_packageutility_pellet_wood_packageutility_generated_baseutility_generated_packageassessment_typeassessment_datecommentsaddresscitystatezip_codeshapetown_house_wallsyear_builtnumber_bedroomsnum_floor_above_gradefloor_to_ceiling_heightconditioned_floor_areaorientationblower_door_testair_sealing_presentenvelope_leakagewall_construction_samewindow_construction_samehvac.0.heating.typehvac.0.heating.fuel_primaryhvac.0.heating.efficiency_methodhvac.0.heating.yearhvac.0.heating.efficiencyhvac.0.cooling.typehvac.0.cooling.efficiency_methodhvac.0.cooling.yearhvac.0.cooling.efficiencyhvac.0.hvac_namehvac.0.hvac_fractionhvac.1.heating.typehvac.1.heating.fuel_primaryhvac.1.heating.efficiency_methodhvac.1.heating.yearhvac.1.heating.efficiencyhvac.1.cooling.typehvac.1.cooling.efficiency_methodhvac.1.cooling.yearhvac.1.cooling.efficiencyhvac.1.hvac_namehvac.1.hvac_fractiondomestic_hot_water.categorydomestic_hot_water.typedomestic_hot_water.fuel_primarydomestic_hot_water.efficiency_methoddomestic_hot_water.yeardomestic_hot_water.energy_factorroof.0.roof_nameroof.0.roof_arearoof.0.roof_assembly_coderoof.0.roof_colorroof.0.roof_absorptanceroof.0.roof_typeroof_0_ceiling_arearoof.0.ceiling_assembly_coderoof_0_knee_wall_arearoof_0_knee_wall_assembly_coderoof.0.skylight_arearoof.0.skylight_methodroof.0.skylight_coderoof.0.skylight_u_valueroof.0.skylight_shgcroof.1.roof_name
19
101019.98851.98851.
Walnut Ridge(AWOS)
2015-12-141.212.156.144.88.1995.1454.118.87.2.6.126.84.70.47.21821.15842.11312.869.....9506.517.....8074.8074.initial2015-11-20123 Any StreetSmithvilleAR72466.rectangle1980.3.2.8.1800.north1..4200.1.1.central_furnacenatural_gasuser.8split_dxuser12.hvac11.hvac2unitstoragenatural_gasuser.55roof1900.rfwf00comedium_darkvented_atticecwf03roof2
20
101019.99011.99011.
Walnut Ridge(AWOS)
2015-12-151.212.156.144.88.1995.1454.118.87.2.6.126.84.70.47.21821.15842.11312.869.....9506.517.....initial2015-11-20123 Any StreetSmithvilleAR72466.rectangle1985.3.2.8.1800.south1..4200.1.1.central_furnacenatural_gasuser.8split_dxuser12.hvac11.hvac2unitheat_pumpelectricuser1990.2.5roof1900.rfwf00comedium_darkvented_atticecwf03roof2
21
PNNL000196517.96517.
Kansas City Downtown AP
2015-12-151.196.153.123.79.1943.1512.94.73.4.7.63.49.30.23.15453.12026.18331......14266......test2015-08-04123 Any StreetKansas CityMO64110.rectangle1950.3.1.8.2100.east.1.1.1.heat_pumpelectricuser7.2heat_pumpuser10.hvac11.hvac2unitstorageelectric
shipment_weighted
2015.roof12100.rfwf00comediumvented_atticecwf21roof2
22
PNNL000196518.96518.
Kansas City Downtown AP
2015-12-151.223.169.150.95.2251.1696.106.80.2.6.126.90.60.43.20434.15168.12706.831.....10346.551.....test2015-08-04123 Any StreetKansas CityMO64110.rectangle1948.3.1.8.2100.west..1.1.central_furnacenatural_gas
shipment_weighted
2015.split_dx
shipment_weighted
2015.hvac11.hvac2unitstoragenatural_gasuser.55roof12200.rfwf11comediumcath_ceilingroof2
23
PNNL000196519.96519.
Kansas City Downtown AP
2015-12-151.274.153.200.79.2757.1531.130.73.1.7.155.78.74.37.25025.13508.15557.1018.....9972.436.....test2015-08-04123 Any StreetKansas CityMO64110.rectangle2000.3.1.8.2100.northwest....central_furnacenatural_gas
shipment_weighted
1985.split_dx
shipment_weighted
1985.hvac11.hvac2.unitstoragenatural_gasuser.55roof1900.rfwf00comedium_darkvented_atticecwf03.roof2
24
PNNL000196521.96521.Pasco2015-12-011.187.176.115.104.1744.1639.93.88.3.4.113.105.57.52.17453.16384.9497.807.....9305.730.....test2015-11-04123 Any StreetKennewickWA99338.rectangle2010.3.2.8.2000.southeast.1...central_furnacenatural_gasuser.95split_dxuser13.hvac1.75boilerhvac2.unitstoragenatural_gasuser.55roof1900.rfwf00comedium_darkvented_atticecwf03.roof2
25
PNNL000196526.96526.Cahokia St Louis2015-12-111.186.186.94.94.1875.1875.93.93.6.6.104.104.52.52.16964.16964.10787.673.....10787.673.....test2015-08-04123 Any StreetSaint LouisMO63103.rectangle1995.10.2.8.2000.northeast..1.1.central_furnacenatural_gasuser.95split_dxuser15.hvac11.hvac2.unitheat_pumpelectricuser1990.2.5roof12100.rfwf00comediumvented_atticecwf21.roof2
26
PNNL000196527.96527.Cahokia St Louis2015-12-111.178.178.86.86.1795.1795.89.89.7.7.98.98.49.49.16147.16147.10637.614.....10637.614.....test2015-08-04123 Any StreetSaint LouisMO63103.rectangle1986.10.2.8.2000.southwest..1.1.central_furnacenatural_gasuser.95split_dxuser15.hvac11.hvac2.unitstorageelectric
shipment_weighted
2015.roof12100.rfwf00comediumvented_atticecwf11.roof2
27
PNNL000196528.96528.Cahokia St Louis2015-12-011.186.186.94.94.1875.1875.93.93.6.6.104.104.52.52.16964.16964.10787.673.....10787.673.....test2015-08-04123 Any StreetSaint LouisMO63103.townhouseback_front1960.10.2.8.2000.north..1.1.central_furnacenatural_gasuser.95split_dxuser15.hvac11.hvac2.unitstorageelectricuser.86roof12100.rfwf00comediumvented_atticecwf11.roof2
28
29
30
Easy Headers - The headers below can be cut and pasted over the data download headers for easier deciphering
31
Assessor IDLabel #Session #StationDate CreatedCooling No/YesTotal Source EnergyTotal Source Energy UpgradeSource Energy HVAC & DHWSource Energy HVAC & DHW UpgradeTotal Utility CostTotal Utility Cost after upgradeSource Energy IntensitySource Energy Intensity UpgradeScoreScore UpgradeSite EnergySite Energy UpgradeSite Energy IntensitySite Energy Intensity UpgradeCO2 EmissionsCO2 Emissions UpgradeElectric UseFuel Oil UseNatural Gas UsePropane/LPG UseWood Cord UseWood Pellet UseElectric Use UpgradeFuel Oil Use UpgradeNatural Gas Use UpgradePropane/LPG Use UpgradeWood Cord Use UpgradeWood Pellet Use UpgradeAssessment TypeAssessment DateCommentsStreet AddressCityStateZip CodeShapeTH Exterior WallsYear BuiltBedroomsStoriesCeiling HeightConditioned Floor AreaOrientationBlower Door Test No/YesAir Sealing No/YesAir Leakage CFM50Same Walls No/YesSame Windows No/YesHeating TypeHeating FuelHeating Efficiency/DateHeating YearHeating EfficiencyCooling TypeCooling Eff/DateCooling YearCooling EfficiencySystem #1System #1 %2nd Heating Type2nd Heating Fuel2nd Heating Eff/Date2nd Heating Year2nd Heating Efficiency2nd Cooling Type2nd Cooling Eff/Date2nd Cooling Year2nd Cooling EfficiencySystem #2System #2 %DHW alone or combinedDHW StorageDHW FuelDHW Eff/DateDHW YearDHW Energy FactorRoof #1Roof AreaRoof CodeRoof ColorRoof Cool Abs.Attic TypeCeiling AreaAttic CodeKnee Wall AreaKnee Wall CodeSkylight AreaSkylight Code/ValuesSkylight CodeSkylight U-FactorSkylight SHGCRoof #2
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100