Residential ZIP Energy Use and Hourly Loads Databases

 


ZIP Code Residential Owner-Occupied Utility Customer Databases



ZIP Code Summary Databases provide ZIP average data for owner-occupied residential dwelling units, demographic, income and appliance data, energy consumption, including annual and monthly electric consumption for whole building and end-use (space heat, AC, water heat, etc.) monthly electric load profiles and 8760 kW loads. Annual whole building and end-use energy use of fossil fuels is also provided. A statistically accurate sample of individual residential customers is provided for each ZIP area reflecting more than 3.6 million individual households. Individual record databases support in-house evaluation of individual customers for any geographic area.


Data Items: ZIP Code Summary Databases
(Data provided for each ZIP code)


VARIABLE GROUPING DATA ITEMS
LOCATION INFORMATION ZIP Code
ZIP Name
County & State
Metro Area
% Area in Primary Utility
Primary Utility Name
GENERAL ZIP CODE INFORMATION Owner Occupied Dwelling Units
Owner Occupied Dwelling Units as % of Total ZIP Dwelling Units
Elec Vehicle Registrations (CA only)
Average Annual kWh Use
Average Annual Electric Space Heating kWh Use
Average Annual Water Heating kWh Use
Average Annual Air Conditioning kWh Use
Percent Dwelling Units With Electric Space Heating
Average Annual Electric Bill
Average Number of Household Members
Median Household Income
Median Number of Dwelling Unit Rooms
Average Dwelling Unit Square Feet
Median Dwelling Unit Construction Year
Typical Dwelling Unit Sales Price 6-2021
Typical Dwelling Unit 2021/2019 Price Ratio
MORTGAGE DATA 2018 - 2019 Number of FAFH Mortgages
Mortgages as % of Owner-Occupied Dwelling Units
Applicant Average Annual Income
Cashout Mortgages as % of Total Mortgages
Average Loan to Value
Average Debt to Income
% Loan to Value < 60%
% Loan to Value < 80%
% Debt to Income < 20%
% Debt to Income < 36%
MONTHLY ELECTRICITY USE DATA kWh for 12 Months
Peak kW
Avg kW 9am-5pm
24 HOURLY KW LOAD PROFILES BY MONTH Average 24 hourly whole building kW loads for each month
Average 24 hourly space heating kW loads for each month
Average 24 hourly water heating kW loads for each month
Average 24 hourly AC kW loads for each month
8760 HOURLY KW LOADS Average 8760 hourly whole building kW loads
Average 8760 hourly space heating kW loads
Average 8760 hourly water heating kW loads
Average 8760 hourly AC kW loads
ZIP DISTRIBUTION DATA FOR OWNER OCCUPIED DWELLING UNITS Number of Dwelling Units by Annual Electric kWh Use: less than 10,000 kWh 10,000 - 15,999 kWh 16,000 - 23,999 kWh 24,000+ kWh
Number of Dwelling Units by Annual Electric kWh Use: less than 10,000 kWh 10,000 - 15,999 kWh 16,000 - 23,999 kWh 24,000+ kWh
% of Dwelling Units by Annual Electric kWh Use: less than 10,000 kWh 10,000 - 15,999 16,000 - 23,999 kWh 24,0000+ kWh
Number of Dwelling Units by Annual Electric Bill: less than $1,000 $1,000 - $1,599 $1,600 - $2,399 $2,400+
% of Dwelling Units by Annual Electric Bill: less than $1,000 kWh $1,000 - $1,599 $1,600 - $2,399 $2,400+
Number of Dwelling Units by Square Foot Category: less than 1,800 1,800 - 2,599 2,600+ % of Dwelling Units by Square Foot Category: less than 1,800 1,800 - 2,599 2,600+ Number of Dwelling Units by Number of Bedrooms: 1 or 2 bedrooms 3 bedrooms 4+ bedrooms % of Dwelling Units by Number of Bedrooms: 1 or 2 bedrooms 3 bedrooms 4+ bedrooms Number of Dwelling Units by Year of Construction: less than 1980 1980 - 2000 2000+
% of Dwelling Units by Year of Construction: less than 1980 1980 - 2000 2000+
Number of Household by Annual Income: less than $50,000 $50,000 - $99,999 $100,000 - $149,999 $150,000+
% of Household by Annual Income: less than $50,000 $50,000 - $99,999 $100,000 - $149,99 $150,000+
Number of Households by Householder Age: less than 35 35 - 64 65+
% of Households by Householder Age: less than 35 35 - 64 65+
Number of Households by Householder Education: less High School High School Graduates Some College College Graduates+
% of Households by Householder Education: less High School High School Graduates Some College College Graduates+

Geographic Coverage

MAISY ZIP code area individual customer and ZIP summary databases provide utility customer energy consumption, energy bills, demographic, dwelling unit, appliance, income and other information for each ZIP code area in the continental US. ZIP databases are available for the following geographic areas:

  • Single ZIP areas
  • All ZIPs in a county
  • All ZIPs in a metro area
  • All ZIPs in a utility service area
  • All ZIPs in a state
  • All ZIPs in the US
  • Client specified ZIP-defined geographic areas

Applications

Reduce marketing/sales costs by applying ZIP level market intelligence in easy-to-use Excel databases. For the first time, organizations can easily conduct in-house evaluations of residential customer ZIP code “micro markets” with information on utility bills, household income and demographics, dwelling unit characteristics, new construction activity, ownership, and many other characteristics. Market characteristics can be used to:

  • Evaluate current market share in each ZIP code area
  • Compare current customer energy sales and bills with averages in each ZIP area
  • Identify attractive new ZIP-area target markets
  • Evaluate ZIP-area weather risk (% sales in space heat, AC)
  • Correlate write-offs with ZIP market characteristics to revise deposit requirements
  • Evaluate market characteristics in underperforming ZIP areas to revise messaging and sales activities
  • Identify high growth markets
  • Distinguish between stable and transient markets
  • Apply ZIP-detailed customer data to refine pricing models.
  • Conduct other market and sales analysis

License Fee

MAISY ZIP Area Market Databases include proprietary information belonging to Jackson Associates and are licensed to individual users who agree to use the information only within their own organization. Databases are provided for client-specified ZIP codes with licensing fees are based on the number of ZIP codes.

Hourly-15min-0.5sec loads Click Here to see advantages of MAISY data compared to Department of Energy sources.