Individual Residential Customer Record ZIP Databases
ZIP Code Summary Databases

 

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.

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