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_customer_energy_efficiency_and_conservation_loans

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

core_rus7__yearly_distribution_services

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

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_energy_purchased

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

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_materials_and_supplies

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

core_rus7__yearly_meeting_and_board

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

core_rus7__yearly_owed_by_customers

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

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_service_interruptions

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

core_rus7__yearly_statement_of_operations

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

core_rus7__yearly_transmission_and_distribution_mileage

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

out_rus7__yearly_balance_sheet_assets

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

out_rus7__yearly_balance_sheet_liabilities

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

out_rus7__yearly_customer_energy_efficiency_and_conservation_loans

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

out_rus7__yearly_distribution_services

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

out_rus7__yearly_employee_statistics

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

out_rus7__yearly_energy_efficiency

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

out_rus7__yearly_energy_purchased

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

out_rus7__yearly_external_financial_risk_ratio

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

out_rus7__yearly_investments

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

out_rus7__yearly_loans

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

out_rus7__yearly_long_term_debt

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

out_rus7__yearly_long_term_leases

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

out_rus7__yearly_materials_and_supplies

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

out_rus7__yearly_meeting_and_board

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

out_rus7__yearly_owed_by_customers

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

out_rus7__yearly_patronage_capital

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

out_rus7__yearly_power_requirements

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

out_rus7__yearly_power_requirements_electric_customers

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

out_rus7__yearly_power_requirements_electric_sales

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

out_rus7__yearly_service_interruptions

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

out_rus7__yearly_statement_of_operations

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

out_rus7__yearly_transmission_and_distribution_mileage

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

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-7 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.