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: August 26, 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
Data Dictionary
List of all the data files available with definitions, units, sources and methodology for each data field.
Last updated: August 26, 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: November 11, 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, and for power purchased by each utility. Within each generator and for purchased power, data values are differentiated by fuel type.
Last updated: January 8, 2024
Operations Emissions by Tech
Capacity, generation, capacity factor, fuel consumption, and emissions of CO2, NOx, and SOx for each generator owned by each utility, and for power purchased by each utility. Each generator is identified by a single technology.
Last updated: January 8, 2024
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
Uneconomic Dispatch
Capacity and monthly cash flows used for monthly net revenues and gross losses for all operating coal plants above 5 MWs in the nation
Last updated: December 9, 2022
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: August 23, 2022
This work is licensed under Creative Commons Attribution 4.0 International Public License (CC BY 4.0). A copy of the license may be found here. By accessing and using this work, you agree to be bound by the terms of this license. RMI does not warrant or represent that the information is appropriate or sufficient for your purposes, and your use of this work is at your own risk. RMI shall not be liable for any claims, losses, costs, liabilities, or damages that may arise from or in connection with use of this work.