USDA RUS Form 12 – Financial and Operating Report: Electric Power Supply#

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 Power Supply (formerly known as Form 12) is an annual report submitted by rural electric utilities that receive funding from the USDA Rural Utilities Service (RUS) for power supply (generation). 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

13 MB

Temporal Coverage

2006-2021

PUDL Code

rus12

Unprocessed Source Data Archive

10.5281/zenodo.18315222

Issues

Open USDA RUS Form 12 – Financial and Operating Report: Electric Power Supply issues

PUDL Database Tables#

Data Dictionary

Browse Online

core_rus12__entity_borrowers

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

core_rus12__monthly_demand_and_energy_at_delivery_points

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

core_rus12__monthly_demand_and_energy_at_power_sources

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

core_rus12__yearly_balance_sheet_assets

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

core_rus12__yearly_balance_sheet_liabilities

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

core_rus12__yearly_external_financial_risk_ratio

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

core_rus12__yearly_investments

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

core_rus12__yearly_lines_stations_labor_materials_cost

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

core_rus12__yearly_loans

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

core_rus12__yearly_long_term_debt

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

core_rus12__yearly_meeting_and_board

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

core_rus12__yearly_plant_costs

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

core_rus12__yearly_plant_factors_and_maximum_demand

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

core_rus12__yearly_plant_labor

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

core_rus12__yearly_plant_operations_by_borrower

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

core_rus12__yearly_plant_operations_by_plant

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

core_rus12__yearly_renewable_plants

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

core_rus12__yearly_sources_and_distribution

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

core_rus12__yearly_sources_and_distribution_by_plant_type

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

core_rus12__yearly_statement_of_operations

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

out_rus12__monthly_demand_and_energy_at_delivery_points

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

out_rus12__monthly_demand_and_energy_at_power_sources

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

out_rus12__yearly_balance_sheet_assets

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

out_rus12__yearly_balance_sheet_liabilities

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

out_rus12__yearly_external_financial_risk_ratio

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

out_rus12__yearly_investments

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

out_rus12__yearly_lines_stations_labor_materials_cost

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

out_rus12__yearly_loans

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

out_rus12__yearly_long_term_debt

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

out_rus12__yearly_meeting_and_board

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

out_rus12__yearly_plant_costs

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

out_rus12__yearly_plant_factors_and_maximum_demand

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

out_rus12__yearly_plant_labor

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

out_rus12__yearly_plant_operations_by_borrower

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

out_rus12__yearly_plant_operations_by_plant

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

out_rus12__yearly_renewable_plants

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

out_rus12__yearly_sources_and_distribution

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

out_rus12__yearly_sources_and_distribution_by_plant_type

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

out_rus12__yearly_statement_of_operations

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

Background#

The United States Department of Agriculture (USDA) Rural Utilities Service (RUS) Form 12, now known as the Financial and Operating Report - Power Supply, 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 eight 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-12 is completed by rural electric cooperatives that generate or purchase power for distribution and 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.rus12 created for each table’s respective transform function.