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: November 20, 2021

Data Dictionary

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

Last updated: November 20, 2021

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: November 20, 2021

Customers Sales

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

Last updated: November 20, 2021

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: November 20, 2021

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 20, 2021

Employees

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

Last updated: November 22, 2021

Expenditure Bills Burden

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

Last updated: November 20, 2021

Housing Units Income

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

Last updated: November 20, 2021

Net Plant Balance

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

Last updated: November 20, 2021

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: November 20, 2021

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: November 20, 2021

Revenue by Tech

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

Last updated: November 20, 2021

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: November 20, 2021

Utility State Map

A list of states that each utility owns generation plants in.

Last updated: November 20, 2021