USDA RUS Form 7 – Financial and Operating Report: Electric Distribution

Source URL

https://www.rd.usda.gov/resources/forms/rus-forms

Source Description

The United States Department of Agriculture (USDA) Financial and Operating Report for Electric Distribution (formerly known as Form 7) is an annual report submitted by rural electric utilities that receive funding from the USDA Rural Utilities Service (RUS) for distribution services. This data was obtained through multiple Freedom of Information Access (FOIA) requests.

Respondents

Rural electric utilities borrowing from USDA RUS.

Source Format

Comma Separated Value (.csv)

Download Size

27 MB

Temporal Coverage

2006-2021

PUDL Code

rus7

Unprocessed Source Data Archive

10.5281/zenodo.18248545

Issues

Open USDA RUS Form 7 – Financial and Operating Report: Electric Distribution issues

PUDL Database Tables

Data Dictionary

Browse Online

core_rus7__entity_borrowers

https://data.catalyst.coop/preview/pudl/core_rus7__entity_borrowers

core_rus7__yearly_balance_sheet_assets

https://data.catalyst.coop/preview/pudl/core_rus7__yearly_balance_sheet_assets

core_rus7__yearly_balance_sheet_liabilities

https://data.catalyst.coop/preview/pudl/core_rus7__yearly_balance_sheet_liabilities

core_rus7__yearly_employee_statistics

https://data.catalyst.coop/preview/pudl/core_rus7__yearly_employee_statistics

core_rus7__yearly_energy_efficiency

https://data.catalyst.coop/preview/pudl/core_rus7__yearly_energy_efficiency

core_rus7__yearly_external_financial_risk_ratio

https://data.catalyst.coop/preview/pudl/core_rus7__yearly_external_financial_risk_ratio

core_rus7__yearly_investments

https://data.catalyst.coop/preview/pudl/core_rus7__yearly_investments

core_rus7__yearly_loans

https://data.catalyst.coop/preview/pudl/core_rus7__yearly_loans

core_rus7__yearly_long_term_debt

https://data.catalyst.coop/preview/pudl/core_rus7__yearly_long_term_debt

core_rus7__yearly_long_term_leases

https://data.catalyst.coop/preview/pudl/core_rus7__yearly_long_term_leases

core_rus7__yearly_meeting_and_board

https://data.catalyst.coop/preview/pudl/core_rus7__yearly_meeting_and_board

core_rus7__yearly_patronage_capital

https://data.catalyst.coop/preview/pudl/core_rus7__yearly_patronage_capital

core_rus7__yearly_power_requirements

https://data.catalyst.coop/preview/pudl/core_rus7__yearly_power_requirements

core_rus7__yearly_power_requirements_electric_customers

https://data.catalyst.coop/preview/pudl/core_rus7__yearly_power_requirements_electric_customers

core_rus7__yearly_power_requirements_electric_sales

https://data.catalyst.coop/preview/pudl/core_rus7__yearly_power_requirements_electric_sales

core_rus7__yearly_statement_of_operations

https://data.catalyst.coop/preview/pudl/core_rus7__yearly_statement_of_operations

Background

The United States Department of Agriculture (USDA) Rural Utilities Service (RUS) Form 7, now known as the Financial and Operating Report - Distribution, collects detailed annual financial and operational data about rural electric distribution utilities. The form was created to provide financial oversight to loan officers lending money to rural cooperatives. RUS does not publish the responses to these forms it collects - this data was obtained by submitting annual FOIA requests. The resulting data provides financial and operational insight into utilities that are otherwise excluded from the FERC Form 1 filings due to their limited service territory, lack of wholesale power sales subject to federal jurisdiction, and classification as non-public utilities.

Download additional documentation

What data is available through PUDL?

We’ve integrated all RUS 12 tables with the exception of six totals tables containing aggregated versions of values present in other tables. RUS data is only available through 2021 because this is the last year a FOIA request was submitted. Future updates of this data will require additional FOIA requests. If you are interesting in supporting this please contact pudl@catalyst.coop.

Who is required to fill out the form?

RUS-7 is completed by rural electric distribution utilities that receive loans or financial support from the USDA Rural Utilities Service (RUS) program.

What does the original data look like?

The raw data are accessed via FOIA request and are formatted as a collection of annualized CSVs. Each file in the collection corresponds to a different part of the original form.

Notable Irregularities

PUDL Data Transformations

To see the transformations applied to the data in each table, you can read the docstrings for pudl.transform.rus7 created for each table’s respective transform function.