ZIP Code Residential Utility Customer Record Databases

Individual Records: Data on individual utility customers are available for every ZIP code area in the continental US that has more than 100 residential customers. Dwelling unit, demographics, appliance holdings, income and energy consumption are provided for each customer record. Energy consumption data includes annual and monthly electric consumption along with whole building and end-use (space heat, AC, water heat and AC) monthly electric load profiles and 8760 kW loads. A statistically-accurate sample of individual residential customers is provided for each ZIP area for a total of more than 3.3 million individual records. Individual record databases support in-house evaluation of individual customers for any geogrphic area.

ZIP Code Summary Databases provide median, average and distributions of these same variables for individual zip codes. ZIP code summary databases provide summary information to quickly differentiate various ZIP code areas.

Click here to see solar PV ZIP Marketing/Sales Databases that include information on current and forecast PV installations through 2022 along with marketing/sales metrics designed to assist in target marketing.



Databases are available for single-family owner-occupied dwelling units, all single family dwelling units (includes rental units) and multifamily dwelling units.

Data Items: Individual Residential Utility Customer Record Databases
(Data provided for each customer in the ZIP customer sample)

VARIABLE GROUPING	DATA ITEMS
LOCATION INFORMATION	ZIP Code ZIP Name County & State Metro Area % Area in Primary Utility Primary Utility Name
GENERAL INFORMATION	Annual kWh use Annual Electric Space Heating kWh Use Annual Water Heating kWh Use Annual Air Conditioning kWh Use Space Heating Fuel Annual Electric Bill Number of Household Members Household Income Number of Dwelling Unit Rooms Dwelling Unit Square Feet Construction Year
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	8760 hourly whole building kW loads 8760 hourly space heating kW loads 8760 hourly water heating kW loads 8760 hourly AC kW loads
ZIP Level Data (Same value for each record in the ZIP)	Elec Vehicle Registrations (CA only) 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% Typical Dwelling Unit Sales Price 6-2021 Typical Dwelling Unit 2021/2019 Price Ratio

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.

Click Here to see advantages of MAISY data compared to Department of Energy sources.