=========================================================================================== USDA RUS Form 7 -- Financial and Operating Report: Electric Distribution =========================================================================================== .. list-table:: :widths: auto :header-rows: 0 :stub-columns: 1 * - 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 ^^^^^^^^^^^^^^^^^^^^ .. list-table:: :header-rows: 1 :widths: auto * - Data Dictionary - Browse Online * - :ref:`core_rus7__entity_borrowers` - https://data.catalyst.coop/preview/pudl/core_rus7__entity_borrowers * - :ref:`core_rus7__yearly_balance_sheet_assets` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_balance_sheet_assets * - :ref:`core_rus7__yearly_balance_sheet_liabilities` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_balance_sheet_liabilities * - :ref:`core_rus7__yearly_customer_energy_efficiency_and_conservation_loans` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_customer_energy_efficiency_and_conservation_loans * - :ref:`core_rus7__yearly_distribution_services` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_distribution_services * - :ref:`core_rus7__yearly_employee_statistics` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_employee_statistics * - :ref:`core_rus7__yearly_energy_efficiency` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_energy_efficiency * - :ref:`core_rus7__yearly_energy_purchased` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_energy_purchased * - :ref:`core_rus7__yearly_external_financial_risk_ratio` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_external_financial_risk_ratio * - :ref:`core_rus7__yearly_investments` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_investments * - :ref:`core_rus7__yearly_loans` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_loans * - :ref:`core_rus7__yearly_long_term_debt` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_long_term_debt * - :ref:`core_rus7__yearly_long_term_leases` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_long_term_leases * - :ref:`core_rus7__yearly_materials_and_supplies` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_materials_and_supplies * - :ref:`core_rus7__yearly_meeting_and_board` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_meeting_and_board * - :ref:`core_rus7__yearly_owed_by_customers` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_owed_by_customers * - :ref:`core_rus7__yearly_patronage_capital` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_patronage_capital * - :ref:`core_rus7__yearly_power_requirements` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_power_requirements * - :ref:`core_rus7__yearly_power_requirements_electric_customers` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_power_requirements_electric_customers * - :ref:`core_rus7__yearly_power_requirements_electric_sales` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_power_requirements_electric_sales * - :ref:`core_rus7__yearly_service_interruptions` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_service_interruptions * - :ref:`core_rus7__yearly_statement_of_operations` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_statement_of_operations * - :ref:`core_rus7__yearly_transmission_and_distribution_mileage` - https://data.catalyst.coop/preview/pudl/core_rus7__yearly_transmission_and_distribution_mileage * - :ref:`out_rus7__yearly_balance_sheet_assets` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_balance_sheet_assets * - :ref:`out_rus7__yearly_balance_sheet_liabilities` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_balance_sheet_liabilities * - :ref:`out_rus7__yearly_customer_energy_efficiency_and_conservation_loans` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_customer_energy_efficiency_and_conservation_loans * - :ref:`out_rus7__yearly_distribution_services` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_distribution_services * - :ref:`out_rus7__yearly_employee_statistics` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_employee_statistics * - :ref:`out_rus7__yearly_energy_efficiency` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_energy_efficiency * - :ref:`out_rus7__yearly_energy_purchased` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_energy_purchased * - :ref:`out_rus7__yearly_external_financial_risk_ratio` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_external_financial_risk_ratio * - :ref:`out_rus7__yearly_investments` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_investments * - :ref:`out_rus7__yearly_loans` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_loans * - :ref:`out_rus7__yearly_long_term_debt` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_long_term_debt * - :ref:`out_rus7__yearly_long_term_leases` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_long_term_leases * - :ref:`out_rus7__yearly_materials_and_supplies` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_materials_and_supplies * - :ref:`out_rus7__yearly_meeting_and_board` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_meeting_and_board * - :ref:`out_rus7__yearly_owed_by_customers` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_owed_by_customers * - :ref:`out_rus7__yearly_patronage_capital` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_patronage_capital * - :ref:`out_rus7__yearly_power_requirements` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_power_requirements * - :ref:`out_rus7__yearly_power_requirements_electric_customers` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_power_requirements_electric_customers * - :ref:`out_rus7__yearly_power_requirements_electric_sales` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_power_requirements_electric_sales * - :ref:`out_rus7__yearly_service_interruptions` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_service_interruptions * - :ref:`out_rus7__yearly_statement_of_operations` - https://data.catalyst.coop/preview/pudl/out_rus7__yearly_statement_of_operations * - :ref:`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 --------------------------------- * :download:`Rus7 Blank 2014 (PDF) ` * :download:`Rus7 Blank Pre2014 (PDF) ` * :download:`Uep Bulletin 1717B-2 2002-02-14 (PDF) ` 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 :mod:`pudl.transform.rus7` created for each table's respective transform function.