Skip to main content
U.S. flag

An official website of the United States government

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Skip to content

FERC Form 1 Electric Utility Cost, Energy Sales, Peak Demand, and Customer Count Data 1994-2019

Metadata Updated: June 15, 2024

This spreadsheet contains information reported by over 200 investor-owned utilities to the Federal Energy Regulatory Commission in the annual filing FERC Form 1 for the years 1994-2019. It contains 1) annual capital costs for new transmission, distribution, and administrative infrastructure; 2) annual operation and maintenance costs for transmission, distribution, and utility business administration; 3) total annual MWh sales and sales by customer class; 4) annual peak demand in MW; and 5) total customer count and the number of customers by class.

Annual spending on new capital infrastructure is read from pages 204 to 207 of FERC Form 1, titled Electric Plant in Service. Annual transmission capital additions are recorded from Line 58, Column C - Total Transmission Plant Additions. Likewise, annual distribution capital additions are recorded from Line 75, Column C - Total Distribution Plant Additions. Administrative capital additions are recorded from Line 5, Column C - Total Intangible Plant Additions, and Line 99, Column C - Total General Plant Additions.

Operation and maintenance costs associated with transmission, distribution, and utility administration are read from pages 320 to 323 of FERC Form 1, titled Electric Operation and Maintenance Expenses. Annual transmission operation and maintenance are recorded from Line 99, Column B - Total Transmission Operation Expenses for Current Year, and Line 111, Column B - Total Transmission Maintenance Expenses for Current Year. Likewise, annual distribution operation and maintenance costs are recorded from Line 144, Column B - Total Distribution Operation Expenses, and Line 155, Column B - Total Distribution Maintenance Expenses. Administrative operation and maintenance costs are recorded from: Line 164, Column B - Total Customers Accounts Expenses; Line 171, Column B - Total Customer Service and Information Expenses; Line 178, Column B - Total Sales Expenses; and Line 197, Column B - Total Administrative and General Expenses.

The annual peak demand in MW over the year is read from page 401, titled Monthly Peaks and Output. The monthly peak demand is listed in Lines 29 to 40, Column D. The maximum of these monthly reports during each year is taken as the annual peak demand in MW. The annual energy sales and customer count data come from page 300, Electric Operating Revenues. The values are provided in Line 2 - Residential Sales, Line 4 - Commercial Sales, Line 5 - Industrial Sales, and Line 10 - Total Sales to Ultimate Consumers.

More information about the database is available in an associated report published by the University of Texas at Austin Energy Institute: https://live-energy-institute.pantheonsite.io/sites/default/files/UTAustin_FCe_TDA_2016.pdf

Also see an associated paper published in the journal Energy Policy:

Fares, Robert L., and Carey W. King. "Trends in transmission, distribution, and administration costs for US investor-owned electric utilities." Energy Policy 105 (2017): 354-362. https://doi.org/10.1016/j.enpol.2017.02.036

All data come from the Federal Energy Regulatory Commission FERC Form 1 Database available in Microsoft Visual FoxPro Format: https://www.ferc.gov/docs-filing/forms/form-1/data.asp

Access & Use Information

Public: This dataset is intended for public access and use. License: Creative Commons Attribution

Downloads & Resources

Dates

Metadata Created Date August 7, 2021
Metadata Updated Date June 15, 2024

Metadata Source

Harvested from OpenEI data.json

Additional Metadata

Resource Type Dataset
Metadata Created Date August 7, 2021
Metadata Updated Date June 15, 2024
Publisher National Renewable Energy Laboratory
Maintainer
Identifier https://data.openei.org/submissions/489
Data First Published 2017-01-04T07:00:00Z
Data Last Modified 2024-06-14T15:28:25Z
Public Access Level public
Bureau Code 019:20
Metadata Context https://openei.org/data.json
Metadata Catalog ID https://openei.org/data.json
Schema Version https://project-open-data.cio.gov/v1.1/schema
Catalog Describedby https://project-open-data.cio.gov/v1.1/schema/catalog.json
Data Quality True
Harvest Object Id 16b632b0-1646-44c5-9c4d-6f6a27960ac0
Harvest Source Id 7cbf9085-0290-4e9f-bec1-91653baeddfd
Harvest Source Title OpenEI data.json
Homepage URL https://data.openei.org/submissions/489
License https://creativecommons.org/licenses/by/4.0/
Old Spatial {"type":"Polygon","coordinates":-125.4514,24.5873,-66.5318,24.5873,-66.5318,49.2637,-125.4514,49.2637,-125.4514,24.5873}
Program Code 019:000
Source Datajson Identifier True
Source Hash 4cf495c2ffdf1ccbe9a92ce9fd12c6b5c7a239fa12870e83b8e9ce058060c67a
Source Schema Version 1.1
Spatial {"type":"Polygon","coordinates":-125.4514,24.5873,-66.5318,24.5873,-66.5318,49.2637,-125.4514,49.2637,-125.4514,24.5873}

Didn't find what you're looking for? Suggest a dataset here.