MAISY Utility Customer Databases

Connect customer characteristics to energy use and hourly demand.

Residential and commercial customer data for load forecasting, technology analysis, customer segmentation and utility planning. Select the geography, variables and load detail your project needs—or have Jackson Associates prepare the analysis.

Identity-protected records · Whole-building and end-use loads · CSV and Excel deliverables
Four complementary resources

Choose the database that fits the question

The database families serve different purposes. Select them by customer population, geographic requirements and analytical use rather than assuming every product includes the same fields.

01

Residential household databases

More than 7 million identity-protected household records combine demographic, income, dwelling, equipment, commuting and energy-use information. Block group and ZIP-defined selections support geographic and customer-segment analysis, with whole-home and end-use load options.

02

EV ownership and charging-load data

Household ownership probabilities and modeled charging profiles connect adoption potential and travel patterns to hourly demand. Optional baseline whole-home loads show how charging combines with existing residential use.

03

RECS hourly-load and emissions extensions

Extensions of EIA’s 2020 Residential Energy Consumption Survey add whole-home hourly profiles, optional end-use detail and emissions estimates to the survey’s 18,400+ household records. This resource supports analysis anchored to RECS building, equipment and occupant variables.

04

Commercial customer databases

The commercial offering includes 600,000+ customer records with building, equipment, operating and energy-use characteristics. Whole-building and end-use hourly profiles support technology, market, forecasting and customer-class studies.

GIM coverage: Current Grid Impact Model applications cover single-family residential customers. The broader MAISY residential and commercial database portfolio supports additional populations and applications; those should not be interpreted as extensions of GIM’s current customer scope.
Combine people, buildings and loads

Data categories that work together

Available fields vary by database. A project can request selected variables, data groups, customer records or prepared summaries.

Data categoryRepresentative contentWhat it supports
Customer characteristicsHousehold income, composition, education and travel characteristics; commercial establishment and operating characteristics.Customer segmentation, program targeting and market-potential analysis.
Buildings and equipmentFloor area, heating fuel, HVAC equipment, appliances and other product-specific building variables.Electrification, efficiency and technology studies.
Annual and end-use energyElectricity and other fuel use, energy costs and end-use breakdowns such as space conditioning and water heating.Baseline analysis, fuel switching, savings estimates and technology sizing.
Time-specific electric loads8,760 hourly profiles, optional 15-minute detail, whole-building and end-use loads, and selected summary profiles.Peak coincidence, customer-class profiles, load-factor analysis and flexible-load studies.
Geographic informationZIP, county, metropolitan area, state and other identifiers available with the selected resource.Geographic comparisons and area-specific customer analysis.
EV and travel dataOwnership probabilities, commuting characteristics and modeled charging profiles where specified.EV scenarios, localized demand and managed-charging analysis.
Emissions estimatesFuel-specific and total CO2e estimates where included in the selected database.Comparisons of energy use, fuel choices and technology scenarios.
How the data are developed

Customer-detailed energy Use and load profiles with a metered-load foundation

MAISY integrates public and proprietary household, building, equipment, energy, travel and utility data. Proprietary machine-learning integration methods extend actual identity-protected individual customer records with fields from supporting sources.

Hourly end-use profiles draw on metered source samples and are calibrated to annual energy use.

This approach provides a robust customer-level analytical foundation.

Actual customer characteristics The records reflect actual household and building information from source datasets rather than a single engineering-based customer prototype.
Dozens of data sources and millions of data points MAISY Databases apply proprietary machine-learning integration methods to more than 7 million actual US households and dozens of supporting primary data sources.
Modeled time-specific profiles Actual end-use metered source data informs household hourly load development.
Application-specific validation Database results are vetted with available utility totals, interval data and customer-class information.
Current Grid Impact Model applications

From customer data to localized planning decisions

GIM combines the single-family residential data foundation with an Excel interface, forecasting engine and analytical worksheets.

EV adoption and hourly loads

Allocate utility-wide adoption scenarios to representative customers and develop customer, block-group, ZIP and service-area charging-load results.

Local transformer-risk screening

Combine localized forecasts with utility-selected capacity, existing loading and planning limits to identify areas deserving asset-specific engineering review.

Managed-charging economics

Evaluate avoided wholesale demand charges, energy margins, participation, control effectiveness and program costs through payback, NPV and cash-flow outputs.

Future load and flexible resources

Compare electrification, weather stress, customer growth, demand response, batteries and VPP scenarios on a common hourly-load foundation.

GIM supports planning without utility AMI interval data or customer contact. Its transformer analysis is planning-level screening; actual circuit connectivity, voltage, thermal and protection studies require utility asset information and detailed engineering.
Broader MAISY applications

A resource for utilities, technology firms and energy analysts

JA’s historical assignments span multiple databases, models and consulting services. They demonstrate analytical experience across the portfolio, rather than implying that every client used the current GIM.

Utility planning and forecasting

Customer-class hourly loads, cost-of-service studies, end-use forecasts and efficiency or demand-response program analysis.

Technology and market analysis

Customer-segment potential, equipment sizing and economics for PV, storage, heat pumps, CHP and other energy technologies.

Government and research studies

Energy scenarios, technology assessment, efficiency-program evaluation and analysis of policies and standards.

Retail energy markets

Geographic and customer-segment analysis, load shapes and market potential for electricity suppliers and energy-service firms.

Electrification and emissions

Fuel-use baselines, heating and equipment changes, and emissions comparisons under defined assumptions.

Customized analysis

Cross-tabs, segment profiles, geographic comparisons and client-specified summaries prepared by Jackson Associates.

Example Applications
Application Areas Applications Clients Database Scope JA Deliverables
Electric vehicles Mkt sizing, mkt potential 3 EV companies Residential States Databases & analysis
PV solar Product sizing, mkt potential, profit analysis 3 manufacturer-retailers Residential States Databases & analysis
Battery storage Product sizing, mkt potential, profit analysis 1 manufacturer, 1 PV solar company Residential & Commercial States Databases & analysis
Microgrids Product evaluation, mkt potential 1 electric/gas utility Residential States Databases
Ground source ht pumps Mkt potential, profit analysis 1 electric/gas utility Residential Florida Analysis
Smart grid tech (2-way thermostats, etc) Business case analysis for individual technologies 20 Electric Utilities Residential & commercial Utilities/states Analysis & Software
Electricity forecasts (AB models through 2060) Utility electricity forecasts/ energy efficiency regulations impacts 26+ electric utilities, utility organizations Residential & commercial Utilities/states Forecasting software
Retail electricity suppliers Mkt potential, profit analysis 13 retail electricity suppliers Residential & commercial States/ national Databases
Govt energy forecasts, technology, program analysis Tech analysis, energy forecasts and regulation impact analysis 2 national labs, DOE, 9 state agencies Residential & commercial National Databases & analysis
Energy efficiency firms Mkt potential, profit analysis 5 firms Residential & commercial States/national Databases analysis
Small CHP (cogeneration) Product sizing, mkt potential, profit analysis 2 manufacturers Residential & commercial National Analysis
Commercial CHP (cogeneration) Product sizing, mkt potential, profit analysis 2 manufacturers Commercial National Databases & Analysis
Fuel cells Product sizing, mkt potential, profit analysis 3 manufacturers Residential & Commercial National Databases & Analysis
Cool storage Product sizing, mkt potential, profit analysis 1 manufacturer Commercial National Databases
Site-based wind Mkt potential, profit analysis 1 manufacturer Commercial Texas Databases
Cost-of-service analysis 8760 hourly loads by customer class 3 electric utilities Residential & commercial Utilities/states Databases & analysis
Scope and delivery

Request the information your project will actually use

Database cost and licensing are defined for the geography, fields, time detail and required outputs.

01

Define the decision

Describe the planning, market or technology question and the customer population.

02

Select coverage

Identify block groups, ZIPs, states or other requested areas and the appropriate database family.

03

Choose data detail

Select customer variables, energy fields, end uses and hourly or 15-minute requirements.

04

Agree on outputs

Specify CSV records, Excel summaries, cross-tabs, load files or prepared analysis.

05

Confirm scope

Agree on data vintage, assumptions, deliverables, permitted use and project cost.

Geographic identifiers correspond to standard Federal Information Processing Standards (fips) definitions.
Choosing a load-data resource

Compare sources against the task

Customer-based profiles and engineering simulation datasets can both be useful. Evaluate their geographic detail, source vintages, available variables, load calibration, processing requirements and suitability for the decision.

Where MAISY adds practical detail

  • Customer characteristics linked to energy and time-specific demand.
  • Selections by geography and combinations of customer attributes.
  • Whole-building and end-use load options.
  • Data delivery or analysis prepared for the client’s workflow.

Questions to ask of any dataset

  • Which fields are observed, matched, estimated or simulated?
  • How representative is the selected customer segment?
  • What year, weather and behavior assumptions do the loads reflect?
  • What validation is available for the intended geography and application?
Frequently asked questions

Database coverage and use

Do all products include 7+ million records?

No. That figure describes the broad residential database resource. RECS extensions, commercial data and geographic selections have different populations and record counts.

Can I obtain only selected fields or ZIPs?

Yes. The engagement can specify data groups, individual variables and geographic coverage, or request summaries instead of the full customer-level dataset.

Are the hourly profiles direct measurements?

Proprietary machine-learning methods integrate actual metered end-use 15-minute loads source data with end use appliances and energy use available in each household record and calibrate to whole building household energy use.

Are 15-minute loads available?

They are an option in selected MAISY offerings. Confirm the database, end-use coverage, time convention and file structure in the project scope.

Does the commercial database expand GIM’s scope?

No. The commercial data support separate analysis applications. Current GIM applications cover single-family residential utility customers.

Can JA prepare the analysis?

Yes. JA can supply client-specified tables, cross-tabs and analysis outputs. A GIM-based report is also available for questions within the model’s current scope.

Tell us the question. We’ll help define the data.

Discuss a database selection, customized analysis or utility-specific Grid Impact Model application.

Contact Jackson Associates