Created byrmi-logo

Download the Hub's Data

We are excited to launch the Utility Transition Hub™ Data Download, a collection of all Hub data made available and downloadable as CSV files with an accompanying data dictionary in PDF and XLSX formats.

The Data Download includes detailed data sets on:

  • Utility finances & investments
  • Utility operations & emissions
  • Customer & community impacts
  • Alignment of utility commitments with 1.5°C
  • The policy & regulatory frameworks utilities operate in

For a complete list of data fields and sources, download the data dictionary XLSX.

Disclaimer: This data set is not comprehensive of all utilities in the United States. If aggregating data to parent companies, values will be the sum of their regulated subsidiaries, not actual total values for the parent company.

Downloadable Files

Data Methodology

Detailed description of methodology and assumptions used for all data in the Utility Transition Hub Portal.

Last updated: March 7, 2022

Data Dictionary

List of all the data files available with definitions, units, sources and methodology for each data field.

Last updated: March 7, 2022

Assets Earnings Investments

Detailed breakdown of utility assets in electric rate base, earnings on these assets, and annual investments (capital additions) by technology.

Last updated: January 19, 2022

Customers Sales

Number of customers, MWh electricity sales, and revenues by customer type.

Last updated: January 19, 2022

Debt Equity Returns

Rate base, equity, debt, returns, earnings, interest expense, tax expense, and the rates of return used for earnings and revenue calculations.

Last updated: January 19, 2022

Emissions Targets

CO2 emissions and projections, as well as electricity generation and projections and comparison to RMI's 1.5°C decarbonization pathway for the US electricity sector.

Last updated: March 7, 2022

Employees

Number of employees that work at large power plants, by technology, for each utility

Last updated: January 19, 2022

Expenditure Bills Burden

Expenditure, average residential customer energy bill, and average residential customer energy burden for each utility by technology and customer group.

Last updated: January 19, 2022

Expenditure Bills Burden Detail

Expenditure, average residential customer energy bill, and average residential customer energy burden for each utility by technology and customer group. Broken down into additional components and details compared to expenditure_bills_burden, leading a large file size (575 MB) that cannot be opened in Excel.

Last updated: January 19, 2022

Housing Units Income

Number of housing units and income by customer group for each utility.

Last updated: January 19, 2022

Net Plant Balance

Original cost, accumulated depreciation, and remaining net plant balance of electric plants in service, by FERC classification.

Last updated: January 19, 2022

Operations Emissions by Fuel

Generation, fuel consumption, and emissions of CO2, NOx, and SOx for each generator owned by each utility. Within each generator, fuel consumption is differentiated by fuel type.

Last updated: January 19, 2022

Operations Emissions by Tech

Capacity, generation, capacity factor, fuel consumption, and emissions of CO2, NOx, and SOx for each generator owned by each utility. Each generator is identified by a single technology.

Last updated: January 19, 2022

Revenue by Tech

Revenues for each utility, by technology and component, for each utility.

Last updated: January 19, 2022

State Targets

Greenhouse gas (GHG) and renewable portfolio standard (RPS) data by state, including baseline, interim, and final target years.

Last updated: November 20, 2021

State Utility Policies

Policy data shown on the "Policy & Regulations" dashboard of the Utility Transition Hub Portal, by state and utility.

Last updated: November 20, 2021

Utility Information

Utility identifiers such as name, ID numbers from various sources, and utility type. Includes connections from operating companies to parent companies.

Last updated: January 19, 2022

Utility State Map

A list of states that each utility operates in, including capacity owned in state, capacity operated in state, and energy sales in state.

Last updated: January 19, 2022

This work is licensed under Creative Commons Attribution-Noncommercial 4.0 International Public License (CC BY-NC). A copy of the license may be found here. By accessing and using this portal, you agree to be bound by the terms of this license.