out_rus12__yearly_investments
Annual time series of investments, loan guarantees and loans.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section F, Sub-section I)
- Primary key:
This table has no primary key. This is a list of all investments or loans in each year and borrowers can have multiple records with the same investment_description.
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Additional Details
Reporting of investments is required by 7 CFR 1717, Subpart N. Investment categories reported on this Part correspond to Balance Sheet items in Part A Section B in table core_rus12__yearly_balance_sheet_assets.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
Description of investment. This is a free-form text field and thus contains a wide variety of values.
Investment type code.
Included investment.
Excluded investment.
Income or loss from investment.
Whether or not the investment or loan is for rural development. This includes investments in any/all types of projects or products that were made to improve the economy and/or quality of life in the specified area.
out_rus12__yearly_loans
Annual time series of loans provided by RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section F - Subsections II & IV)
- Primary key:
This table has no primary key. This table has no primary key because some borrowers report multiple loan values from the same entity in a given year.
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Additional Details
This table also includes loan guarantees where the RUS borrower backs a loan from another entity and is therefore liable to pay any remaining balance should the original borrower default.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
The organization that received a loan.
The date on which a loan is scheduled to be fully paid.
The original amount of a loan.
The amount of money still owned on a loan at the end of the reporting year.
Whether or not the investment or loan is for rural development. This includes investments in any/all types of projects or products that were made to improve the economy and/or quality of life in the specified area.
Indicates a third-party loan that the reporting utility (referred as a borrower) has co-signed, taking on responsibility for repayment if the primary borrower defaults.
out_rus12__yearly_depreciation_changes
Annual time series of changes in accumulated depreciation.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section B)
- Primary key:
report_date, borrower_id_rus, depreciation_and_amortization_group, depreciation_and_amortization_item
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
High-level category of depreciation and amortization items.
Category of depreciation and amortization items.
The composite depreciation rate within a given category. This is typically expressed as a number between 0 and 100.
Value of additions into an asset class a.k.a accruals.
Cost of retirements minus any net salvage value.
Amount of adjustments and transfers within a class of assets.
Account balance at end of year.
Whether or not this record represents a total.
out_rus12__yearly_depreciation_misc
Annual time series of accumulated depreciation.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - 2nd part of Section B)
- Primary key:
report_date, borrower_id_rus, depreciation_and_amortization_item
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Additional Details
This is the second half of the depreciation table. It includes ending balances of six depreciation and amortization values.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
Category of depreciation and amortization items.
Account balance at end of year.
out_rus12__yearly_meeting_and_board
Annual time series of annual meeting and board information for RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section I)
- Primary key:
report_date, borrower_id_rus
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
The date of the last annual meeting.
The total number of members.
The number of members present at the last annual meeting.
Whether or not quorum was met.
The number of members voting by mail or by proxy.
The total number of board members.
The total amount of fees and expenses for board members.
Whether or not the RUS borrower's manager has a written contract.
out_rus12__yearly_plant_costs
Annual time series of costs of net energy generated by plant.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part F - Section D)
- Primary key:
This table has no primary key. This table has no primary key because there is one plant (Walter Scott) that has duplicate records every year. Based on other RUS-12 tables, it is likely that these duplicate records are the borrowers' ownership portion of the plant as well as the total plant but there is no clear indication in this table.
The primary key of this table otherwise would be: ['report_date', 'borrower_id_rus', 'plant_name_rus', 'cost_group', 'cost_type'].
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Additional Details
The cost column in this table is expected to be largely non-null, the cost_per_mwh and cost_per_mmbtu columns only apply to some cost_type's and even plant_type's and thus are expected to contain many nulls.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
Name of the plant as reported to RUS.
Type of plant.
High-level category of cost type.
Detailed category of cost type.
Cost value.
Unit cost of energy production in cost per MWh
Unit cost of energy production in cost per MMBTU
Whether or not this record represents a total.
out_rus12__yearly_plant_labor
Annual time series of labor and payroll information for plants owned by RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Parts D, E, F, G - Section B)
- Primary key:
This table has no primary key. The primary key should be report_date, borrower_id_rus, plant_name_rus, and plant_type, but this table did not report plant_type before 2009 and there are respondents who report multiple rows per plant pre-2009. The data cannot be backfilled because there is no way to distinguish between duplicate rows pre-2009.
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Additional Details
Note the lack of plant_type pre-2009 leading to a lack of reliable primary keys.
Plant-level data from core_rus12__yearly_plant_operations_by_plant can be matched to data from this table, but you must also join this data usingthe borrower_id_rus column as well as the report_date and plant_name. This is because the core_rus12__yearly_plant_operations_by_plant table includes records from each plant owner. The RUS instructions note that:
you should use caution when using total plant data since there are cases where more than one Borrower shares units at the same plant which means that you will be getting duplicate plant total records (and there is no guarantee that the total plant records entered by two borrowers for the same plant will be identical).
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
Name of the plant as reported to RUS.
Type of plant.
Number of employees hired full-time for normal operations of the system.
Number employees regularly employed on a part-time basis. Exclude employees hired for short periods of time to complete special jobs.
Total number of hours worked by employees.
The amount of payroll spent on plant maintenance.
The amount of payroll spent on plant operations.
The amount of plant payroll spent on accounts other than maintenance and operations.
out_rus12__yearly_renewable_plants
Annual time series of renewable energy plant generation information for RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part C RE)
- Primary key:
report_date, borrower_id_rus, plant_name_rus, prime_mover_id
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
Name of the plant as reported to RUS.
Unique numeric identifier for each prime mover type used by RUS borrowers.
Type of prime mover (e.g. Hydro, Internal Combustion).
Unique numeric identifier for each renewable fuel type.
Primary renewable fuel type used by the plant.
Percentage of renewable fuel used.
Total installed (nameplate) capacity, in megawatts.
Net electricity generation for the specified period in megawatt-hours (MWh).
Fraction of potential generation that was actually reported for a plant part. Energy generated over time period / nameplate capacity * time period (hours/years/etc.).
Number of employees.
Total production expenses (USD per MWh generated).
The cost of power per mwh.
The amount of money invested.
Percentage of the plant owned by the respondent.
Amount of funding received from the Rural Utilities Service (RUS).
General comments field.
out_rus12__yearly_sources_and_distribution
Annual time series of MWh and cost of energy sources and distribution by RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part C)
- Primary key:
report_date, borrower_id_rus, source_of_energy
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Additional Details
See the sources_and_distribution_by_plant_type table for a breakdown of plant-type-specific cost, capacity, plant_num, and net_energy_received values. Also note that there are several source_of_energy values that don't have a corresponding cost value.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
The source of energy (not plant type).
The net amount of energy received into the system.
Cost value.
out_rus12__yearly_statement_of_operations
Annual time series of opex and cost of electric service for RUS borrowers by time period.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part A - Section A)
- Primary key:
report_date, borrower_id_rus, opex_group, opex_type
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
High level section from the statement of operations table. Most of these types have subcomponents broken out in the opex_type column.
Type of item from the statement of operations.
Amount of operational expense, cost or income during the report month.
The year-to-date amount of operational expense, cost or income.
The year-to-date budget for amount of operational expense, cost or income.
Whether or not this record represents a total.
out_rus12__yearly_balance_sheet_assets
Annual time series of assets and other debts from the balance sheet.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part A - Section B)
- Primary key:
report_date, borrower_id_rus, asset_type
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Additional Details
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
Type of asset being reported to the core_ferc1__yearly_balance_sheet_assets_sched110 table.
Account balance at end of year.
Whether or not this record represents a total.
out_rus12__yearly_balance_sheet_liabilities
Annual time series of liabilities and other credits from the balance sheet.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part A - Section B)
- Primary key:
report_date, borrower_id_rus, liability_type
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Additional Details
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
Type of liability being reported to the core_ferc1__yearly_balance_sheet_liabilities_sched110 table.
Account balance at end of year.
Whether or not this record represents a total.
out_rus12__yearly_long_term_debt
Annual time series of long-term debt and debt service requirements for RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section H)
- Primary key:
This table has no primary key. This table has no primary key because some borrowers report multiple debt values from the same entity in a given year.
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
Description of debt or loan. On the original form, there are nine provided descriptions and a section to add other free-form descriptions.
The amount of principal still owned on the debt at the end of the report year.
The interest expense on the debt for the report year.
The principal paid on the debt during the report year.
The total amount of debt.
out_rus12__yearly_plant_operations_by_borrower
Annual time series of borrower portion of plant operational data including fuel consumption and operational hours.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part D, E, F (CC), F (IC) & G - Section A)
- Primary key:
This table has no primary key. This table has no primary key because there are a handful of plants that have duplicate records. The primary key of this table otherwise would be: [report_date, borrower_id_rus, plant_name_rus, plant_name_rus, unit_id_rus, plant_type, is_full_ownership_portion, is_partly_owned_by_borrower].
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Additional Details
The data in this table comes from five different portions of RUS 12 corresponding to different plant types (steam, hydroelectric, combined_cycle, internal_combustion and nuclear). The original form includes plant operations data for each plant type reported in multiple ways: with records corresponding to the portion of plants that borrowers own as well as the whole plant. We split these records into two tables, core_rus12__yearly_plant_operations_by_borrower, which contains records reported at the borrower level, and core_rus12__yearly_plant_operations_by_plant, which contains records reported at the plant level.Records that are wholly owned by one borrower show up in both core_rus12__yearly_plant_operations_by_borrower and core_rus12__yearly_plant_operations_by_plant.
There are two boolean columns used to delineate which records are associated with the borrowers' share vs the whole plant - which is documented in _OR_PowerSupply Plant File Documentation.rtf in the newer years in the RUS 12 archive. One of these two fields - is_partly_owned_by_borrower - was not reported before 2009. For the pre-2009 years, we assume that all records that report TRUE for is_full_ownership_portion should end up in the by-plant table while all records should end up in the by-borrower portion of the table.Like the post-2009 records, this involves records from the original tables ending up in both of these PUDL tables.
Also there are two cleaning steps that we performed that alter the original data slightly:
One dropped with unexpected ownership label and duplicate data: There is a Wisdom steam plant record that is labeled to be both fully owned by borrower and partly owned for one year, which is an unexpected combo based on the _OR_PowerSupply Plant File Documentation.rst documentation file in the rus12 archive. Luckily this plant has exactly the same records as the other Wisdom steam plant that year with more expected ownership labels.* Replaced two string values for unit_id_rus: There are two instances from 2018 of unit_id_rus's that have string values in them - WSL GT 12 and WSL ST 10. Based on pre-cleaned data, we were able to clearly identify that we can use just the numeric values in these bad strings - 12 and 10 respectively. This enables us to have an integer type for this unit_id_rus column.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
Name of the plant as reported to RUS.
RUS-assigned unit identification code.
Type of plant.
Total installed (nameplate) capacity, in megawatts.
Gross electricity generation for the specified period in megawatt-hours (MWh).
Percentage of the plant owned by the respondent.
Whether or not the plant record represents the full plant - regardless of whether its fully owned by the borrower.
Whether or not the plant record is partially owned by the borrower. This column was not reported before 2009.
Annual pounds of coal consumed for fuel.This field is only reported for plant_type steam.
Annual cubic feet of natural gas consumed for fuel.This field is only reported for plant_type's combined_cycle, combined_cycle and steam.
Annual gallons of oil consumed for fuel.This field is only reported for plant_type's combined_cycle, combined_cycle and steam.
Annual other fuel consumed. Neither units nor type of fuel are documented.This field is only reported for plant_type's combined_cycle, combined_cycle and steam.
Number of operating hours in service.
Number of operating hours on standby.
Number of operating hours out of service which were scheduled.
Number of operating hours out of service which were unscheduled.
Number of times the plant was started. This field is only reported for plant_type's steam and nuclear.
out_rus12__yearly_plant_operations_by_plant
Annual time series of whole plant operational data including fuel consumption and operational hours.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part D, E, F (CC), F (IC) & G - Section A)
- Primary key:
This table has no primary key. This table has no primary key because there are a handful of plants that have duplicate records. The primary key of this table otherwise would be: [report_date, borrower_id_rus, plant_name_rus, plant_name_rus, unit_id_rus, plant_type, is_full_ownership_portion, is_partly_owned_by_borrower].
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Additional Details
The data in this table comes from five different portions of RUS 12 corresponding to different plant types (steam, hydroelectric, combined_cycle, internal_combustion and nuclear). The original form includes plant operations data for each plant type reported in multiple ways: with records corresponding to the portion of plants that borrowers own as well as the whole plant. We split these records into two tables, core_rus12__yearly_plant_operations_by_borrower, which contains records reported at the borrower level, and core_rus12__yearly_plant_operations_by_plant, which contains records reported at the plant level.Records that are wholly owned by one borrower show up in both core_rus12__yearly_plant_operations_by_borrower and core_rus12__yearly_plant_operations_by_plant.
There are two boolean columns used to delineate which records are associated with the borrowers' share vs the whole plant - which is documented in _OR_PowerSupply Plant File Documentation.rtf in the newer years in the RUS 12 archive. One of these two fields - is_partly_owned_by_borrower - was not reported before 2009. For the pre-2009 years, we assume that all records that report TRUE for is_full_ownership_portion should end up in the by-plant table while all records should end up in the by-borrower portion of the table.Like the post-2009 records, this involves records from the original tables ending up in both of these PUDL tables.
Also there are two cleaning steps that we performed that alter the original data slightly:
One dropped with unexpected ownership label and duplicate data: There is a Wisdom steam plant record that is labeled to be both fully owned by borrower and partly owned for one year, which is an unexpected combo based on the _OR_PowerSupply Plant File Documentation.rst documentation file in the rus12 archive. Luckily this plant has exactly the same records as the other Wisdom steam plant that year with more expected ownership labels.* Replaced two string values for unit_id_rus: There are two instances from 2018 of unit_id_rus's that have string values in them - WSL GT 12 and WSL ST 10. Based on pre-cleaned data, we were able to clearly identify that we can use just the numeric values in these bad strings - 12 and 10 respectively. This enables us to have an integer type for this unit_id_rus column..
Plant-level data can be matched to the :ref:core_rus12__yearly_plant_labor` and forthcoming core_rus12__yearly_plant_factors_and_maximum_demand, which report Section B and C data for all plants. The RUS instructions note that:
you should use caution when using total plant data since there are cases where more than one Borrower shares units at the same plant which means that you will be getting duplicate plant total records (and there is no guarantee that the total plant records entered by two borrowers for the same plant will be identical).
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
Name of the plant as reported to RUS.
RUS-assigned unit identification code.
Type of plant.
Total installed (nameplate) capacity, in megawatts.
Gross electricity generation for the specified period in megawatt-hours (MWh).
Percentage of the plant owned by the respondent.
Whether or not the plant record is partially owned by the borrower. This column was not reported before 2009.
Annual pounds of coal consumed for fuel.This field is only reported for plant_type steam.
Annual cubic feet of natural gas consumed for fuel.This field is only reported for plant_type's combined_cycle, combined_cycle and steam.
Annual gallons of oil consumed for fuel.This field is only reported for plant_type's combined_cycle, combined_cycle and steam.
Annual other fuel consumed. Neither units nor type of fuel are documented.This field is only reported for plant_type's combined_cycle, combined_cycle and steam.
Number of operating hours in service.
Number of operating hours on standby.
Number of operating hours out of service which were scheduled.
Number of operating hours out of service which were unscheduled.
Number of times the plant was started. This field is only reported for plant_type's steam and nuclear.
out_rus12__yearly_utility_plant_changes
Annual time series of changes in utility plant
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section A)
- Primary key:
report_date, borrower_id_rus, utility_plant_group, utility_plant_item
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Additional Details
There are a few layers of nesting in this table, which can be distinguished by the categories in the utility_plant_group column:
intangible_plant: only has one total utility_plant_item
production_plant: has several sub-component utility_plant_item and a standard total
transmission_plant: has several sub-component utility_plant_item and a standard total
distribution_plant: has several sub-component utility_plant_item and a standard total
electric_plant_in_service: has two sub-components and a total which includes those sub-components and the totals of the above categories
utility_plant_in_service: has several sub-components and the total is the sum of those sub-components as well as the total of electric_plant_in_service
total_utility_plant: has one sub-component and the total is the sum of the sub-component and utility_plant_in_service
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
High-level category of utility plant asset type.
Sub-category of utility_plant_group describing utility plant asset item.
Cost of disposal of items classified within the account.
Cost of acquisition of items classified within the account.
Amount of adjustments and transfers within a class of assets.
Account balance at end of year.
Whether or not this record represents a total.
out_rus12__monthly_demand_and_energy_at_delivery_points
Monthly time series of demand and energy delivered to distribution utilities.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section E)
- Primary key:
report_date, borrower_id_rus, delivery_recipient
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
The recipient of the delivered energy or demand.
The amount of demand delivered in MW.
The amount of energy delivered in MWh.
out_rus12__monthly_demand_and_energy_at_power_sources
Monthly time series of demand and energy at point of generation.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section D)
- Primary key:
report_date, borrower_id_rus
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Additional Details
There are some peak demand dates that have an hour component and others that don't. This is because there is inconsistent reporting of peak_demand_hour in the raw data. If there is no hour reported, we record the hour as 0 and only the date will show in the data.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
The amount of energy output in MWh.
Net peak demand for 60 minutes. Note: in some cases peak demand for other time periods may have been reported instead, if hourly peak demand was unavailable.
The date of the peak demand.
Whether or not the peak_mw is coincident or non-coincident peak.
out_rus12__yearly_external_financial_risk_ratio
Annual time series of ratio of investments and loan guarantee balances to total utility plant assets.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section F - Subsection III)
- Primary key:
report_date, borrower_id_rus
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
total investments + loan guarantee balances / total utility plant assets. This ratio shows how much a utility is financially exposed to outside entities relative to its own assets.
out_rus12__yearly_non_utility_plant_changes
Annual time series of changes in non-utility plant.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section C)
- Primary key:
report_date, borrower_id_rus, non_utility_plant_item
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
Category describing non-utility plant asset items.
Cost of acquisition of items classified within the account.
Cost of disposal of items classified within the account.
Amount of adjustments and transfers within a class of assets.
Account balance at end of year.
out_rus12__yearly_plant_factors_and_maximum_demand
Annual time series of plant factors and maximum demand for plants owned by RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Parts D, E, F IC, F CC, G - Section C)
- Primary key:
This table has no primary key. The primary key for this table would be report_date, borrower_id_rus, plant_name_rus, and plant_type but the plant_type column is not reported before 2009 causing lots of duplicate records. Because none of the other fields are static year-over-year, there is no reliable way to backfill the plant_type column in instances where there are different plant_types reported for the same plant in later years.
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Additional Details
The plant_type field was only included in the data starting in 2009. We backfill records with only one reported plant_type per borrower/plant name/year. Records with multiple plant_types per borrower/plant name/year are left with null plant_type because there is no reliable way to determine which plant_type is associated with which record back in time. Plants who's names are reported differently pre and post 2009 will also miss being backfilled.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
Name of the plant as reported to RUS.
Type of plant.
Fraction of potential generation that was actually reported for a plant part. Energy generated over time period / nameplate capacity * time period (hours/years/etc.).
Fraction of potential generation over the time period a plant was in operation. Energy generated over time period / nameplate capacity * time period (hours/years/etc.).
Fraction of consumption vs demand reported for a plant over a given timeframe. Energy consumed over time period / peak demand * time period (hours/years/etc.).
The highest average power output recorded over any single 15 minute interval during the reporting period.
The theoretical or nameplate peak the plant could produce under the best operating conditions during the reporting period.
out_rus12__yearly_sources_and_distribution_by_plant_type
Annual time series of capacity, plant num, MWh, and cost of energy by plant type for RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part C)
- Primary key:
report_date, borrower_id_rus, plant_type
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Additional Details
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
Type of plant.
Total installed (nameplate) capacity, in megawatts.
Number of plants.
Cost value.
The net amount of energy received into the system.
out_rus12__yearly_lines_stations_labor_materials_cost
Annual time series of labor and material cost for lines and stations operated by RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part I - Section C)
- Primary key:
report_date, borrower_id_rus, labor_or_material, operation_or_maintenance, lines_or_stations
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
Indicates whether the cost reported is for labor or material.
Indicates whether the expenditure is for operation or maintenance.
Indicates whether the cost reported pertains to lines or stations.
Cost value.
core_rus12__entity_borrowers
Entity table containing static information about active RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply
- Primary key:
borrower_id_rus
Usage Warnings
Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.
Additional Details
This table contains canonical values for borrowers are set. It contains values which are expected to remain fixed over time.RUS reports many attributes in many different tables across throughout RUS-7 and RUS-12. In order to compile tidy, well-normalized database tables, PUDL collects all instances of these values and and chooses a canonical value. By default, PUDL chooses the most consistently reported value of a given attribute as long as it is at least 70% of the given instances reported. For the borrower_name_rus PUDL chooses the most consistently reported value regardless of if it meets this 70% threshold so that all borrowers will have a name. We chose this because most name changes were insignificant (eg. "and" changed to "&" or "coop" changed to "cooperative"). All tables downstream of this one inherit the canonical values established here..
This table contains all of the Active Distribution Borrowers as of each report year who were eligible to report to RUS Form 12. If these Borrowers have reported to RUS they will have records in the enclosed data tables, however a small number of these Borrowers did not report for various reasons and these Borrowers will not be represented in any of the other tables.
Columns
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The name of the RUS (Rural Utilities Service) borrower.
Two letter US state or territory abbreviation, or ISO 3166-1 alpha-two code for Micronesia and the Marshall Islands.
core_rus12__yearly_investments
Annual time series of investments, loan guarantees and loans.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section F, Sub-section I)
- Primary key:
This table has no primary key. This is a list of all investments or loans in each year and borrowers can have multiple records with the same investment_description.
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
Additional Details
Reporting of investments is required by 7 CFR 1717, Subpart N. Investment categories reported on this Part correspond to Balance Sheet items in Part A Section B in table core_rus12__yearly_balance_sheet_assets.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
Description of investment. This is a free-form text field and thus contains a wide variety of values.
Investment type code.
Included investment.
Excluded investment.
Income or loss from investment.
Whether or not the investment or loan is for rural development. This includes investments in any/all types of projects or products that were made to improve the economy and/or quality of life in the specified area.
core_rus12__yearly_loans
Annual time series of loans provided by RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section F - Subsections II & IV)
- Primary key:
This table has no primary key. This table has no primary key because some borrowers report multiple loan values from the same entity in a given year.
Additional Details
This table also includes loan guarantees where the RUS borrower backs a loan from another entity and is therefore liable to pay any remaining balance should the original borrower default.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The organization that received a loan.
The date on which a loan is scheduled to be fully paid.
The original amount of a loan.
The amount of money still owned on a loan at the end of the reporting year.
Whether or not the investment or loan is for rural development. This includes investments in any/all types of projects or products that were made to improve the economy and/or quality of life in the specified area.
Indicates a third-party loan that the reporting utility (referred as a borrower) has co-signed, taking on responsibility for repayment if the primary borrower defaults.
core_rus12__yearly_depreciation_changes
Annual time series of changes in accumulated depreciation.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section B)
- Primary key:
report_date, borrower_id_rus, depreciation_and_amortization_group, depreciation_and_amortization_item
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
High-level category of depreciation and amortization items.
Category of depreciation and amortization items.
The composite depreciation rate within a given category. This is typically expressed as a number between 0 and 100.
Value of additions into an asset class a.k.a accruals.
Cost of retirements minus any net salvage value.
Amount of adjustments and transfers within a class of assets.
Account balance at end of year.
Whether or not this record represents a total.
core_rus12__yearly_depreciation_misc
Annual time series of accumulated depreciation.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - 2nd part of Section B)
- Primary key:
report_date, borrower_id_rus, depreciation_and_amortization_item
Additional Details
This is the second half of the depreciation table. It includes ending balances of six depreciation and amortization values.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
Category of depreciation and amortization items.
Account balance at end of year.
core_rus12__yearly_meeting_and_board
Annual time series of annual meeting and board information for RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section I)
- Primary key:
report_date, borrower_id_rus
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The date of the last annual meeting.
The total number of members.
The number of members present at the last annual meeting.
Whether or not quorum was met.
The number of members voting by mail or by proxy.
The total number of board members.
The total amount of fees and expenses for board members.
Whether or not the RUS borrower's manager has a written contract.
core_rus12__yearly_plant_costs
Annual time series of costs of net energy generated by plant.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part F - Section D)
- Primary key:
This table has no primary key. This table has no primary key because there is one plant (Walter Scott) that has duplicate records every year. Based on other RUS-12 tables, it is likely that these duplicate records are the borrowers' ownership portion of the plant as well as the total plant but there is no clear indication in this table.
The primary key of this table otherwise would be: ['report_date', 'borrower_id_rus', 'plant_name_rus', 'cost_group', 'cost_type'].
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
Additional Details
The cost column in this table is expected to be largely non-null, the cost_per_mwh and cost_per_mmbtu columns only apply to some cost_type's and even plant_type's and thus are expected to contain many nulls.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
Name of the plant as reported to RUS.
Type of plant.
High-level category of cost type.
Detailed category of cost type.
Cost value.
Unit cost of energy production in cost per MWh
Unit cost of energy production in cost per MMBTU
Whether or not this record represents a total.
core_rus12__yearly_plant_labor
Annual time series of labor and payroll information for plants owned by RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Parts D, E, F, G - Section B)
- Primary key:
This table has no primary key. The primary key should be report_date, borrower_id_rus, plant_name_rus, and plant_type, but this table did not report plant_type before 2009 and there are respondents who report multiple rows per plant pre-2009. The data cannot be backfilled because there is no way to distinguish between duplicate rows pre-2009.
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
Additional Details
Note the lack of plant_type pre-2009 leading to a lack of reliable primary keys.
Plant-level data from core_rus12__yearly_plant_operations_by_plant can be matched to data from this table, but you must also join this data usingthe borrower_id_rus column as well as the report_date and plant_name. This is because the core_rus12__yearly_plant_operations_by_plant table includes records from each plant owner. The RUS instructions note that:
you should use caution when using total plant data since there are cases where more than one Borrower shares units at the same plant which means that you will be getting duplicate plant total records (and there is no guarantee that the total plant records entered by two borrowers for the same plant will be identical).
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
Name of the plant as reported to RUS.
Type of plant.
Number of employees hired full-time for normal operations of the system.
Number employees regularly employed on a part-time basis. Exclude employees hired for short periods of time to complete special jobs.
Total number of hours worked by employees.
The amount of payroll spent on plant maintenance.
The amount of payroll spent on plant operations.
The amount of plant payroll spent on accounts other than maintenance and operations.
core_rus12__yearly_renewable_plants
Annual time series of renewable energy plant generation information for RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part C RE)
- Primary key:
report_date, borrower_id_rus, plant_name_rus, prime_mover_id
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
Name of the plant as reported to RUS.
Unique numeric identifier for each prime mover type used by RUS borrowers.
Type of prime mover (e.g. Hydro, Internal Combustion).
Unique numeric identifier for each renewable fuel type.
Primary renewable fuel type used by the plant.
Percentage of renewable fuel used.
Total installed (nameplate) capacity, in megawatts.
Net electricity generation for the specified period in megawatt-hours (MWh).
Fraction of potential generation that was actually reported for a plant part. Energy generated over time period / nameplate capacity * time period (hours/years/etc.).
Number of employees.
Total production expenses (USD per MWh generated).
The cost of power per mwh.
The amount of money invested.
Percentage of the plant owned by the respondent.
Amount of funding received from the Rural Utilities Service (RUS).
General comments field.
core_rus12__yearly_sources_and_distribution
Annual time series of MWh and cost of energy sources and distribution by RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part C)
- Primary key:
report_date, borrower_id_rus, source_of_energy
Additional Details
See the sources_and_distribution_by_plant_type table for a breakdown of plant-type-specific cost, capacity, plant_num, and net_energy_received values. Also note that there are several source_of_energy values that don't have a corresponding cost value.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The source of energy (not plant type).
The net amount of energy received into the system.
Cost value.
core_rus12__yearly_statement_of_operations
Annual time series of opex and cost of electric service for RUS borrowers by time period.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part A - Section A)
- Primary key:
report_date, borrower_id_rus, opex_group, opex_type
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
High level section from the statement of operations table. Most of these types have subcomponents broken out in the opex_type column.
Type of item from the statement of operations.
Amount of operational expense, cost or income during the report month.
The year-to-date amount of operational expense, cost or income.
The year-to-date budget for amount of operational expense, cost or income.
Whether or not this record represents a total.
_core_rus12__forensics_entity_resolution_borrowers
Forensic table of the statistics determining how we choose a single consistent value during entity resolution.
- Most-recent data:
2021
- Processing:
Data has been cleaned but not tidied/normalized. Published only temporarily and may be removed without notice.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply
- Primary key:
This table has no primary key.
Usage Warnings
This table is meant for forensic purposes only. It contains all values which were used to choose canonical or golden-record. See Entity Resolution Methodology for a fuller conceptual overview.
Additional Details
This is a forensic table containing the input values used to choose canonical values during entity resolution. It is not a cleaned up table - it is meant for forensic purposes only. If you have a question about why a value is reported in an scd, entity or out table, you can find out all of the inputs that were used as ingredients to find the canonical value. You can filter by the column_name and the entity id to find all of the possible input values.
Columns
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
Date reported.
The record in the changelog is valid until this date. The record is valid from the report_date up until but not including the valid_until_date.
The name of the column.
The original values found in PUDL _core table records that were used as ingredients to the entity resolution process.
The number of times this entity - aka this particular utility, plant, etc - occurs across the pre-entity resolution tables.
The number of times this particular record_value occurs across the pre-entity resolution tables in association with this particular entity.
What portion of the entity's records were reported with this particular record_value. This is calculated by dividing the record_occurrences by the entity_occurrences.
Is this record a candidate for being the canonical value? This is based on consistent_rate. By default PUDL requires values to be at least 70 percent consistent to pass this consistency check. There are exceptions to the default 70 percent consistency check for columns like plant or utility names when we always want a value - for those instances we choose the most frequently occurring value regardless of how consistently it was reported.
core_rus12__yearly_balance_sheet_assets
Annual time series of assets and other debts from the balance sheet.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part A - Section B)
- Primary key:
report_date, borrower_id_rus, asset_type
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
Additional Details
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
Type of asset being reported to the core_rus12__yearly_balance_sheet_assets table.
Account balance at end of year.
Whether or not this record represents a total.
core_rus12__yearly_balance_sheet_liabilities
Annual time series of liabilities and other credits from the balance sheet.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part A - Section B)
- Primary key:
report_date, borrower_id_rus, liability_type
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
Additional Details
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
Type of liability being reported to the core_rus12__yearly_balance_sheet_liabilities table.
Account balance at end of year.
Whether or not this record represents a total.
core_rus12__yearly_long_term_debt
Annual time series of long-term debt and debt service requirements for RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section H)
- Primary key:
This table has no primary key. This table has no primary key because some borrowers report multiple debt values from the same entity in a given year.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
Description of debt or loan. On the original form, there are nine provided descriptions and a section to add other free-form descriptions.
The amount of principal still owned on the debt at the end of the report year.
The interest expense on the debt for the report year.
The principal paid on the debt during the report year.
The total amount of debt.
core_rus12__yearly_plant_operations_by_borrower
Annual time series of borrower portion of plant operational data including fuel consumption and operational hours.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part D, E, F (CC), F (IC) & G - Section A)
- Primary key:
This table has no primary key. This table has no primary key because there are a handful of plants that have duplicate records. The primary key of this table otherwise would be: [report_date, borrower_id_rus, plant_name_rus, plant_name_rus, unit_id_rus, plant_type, is_full_ownership_portion, is_partly_owned_by_borrower].
Additional Details
The data in this table comes from five different portions of RUS 12 corresponding to different plant types (steam, hydroelectric, combined_cycle, internal_combustion and nuclear). The original form includes plant operations data for each plant type reported in multiple ways: with records corresponding to the portion of plants that borrowers own as well as the whole plant. We split these records into two tables, core_rus12__yearly_plant_operations_by_borrower, which contains records reported at the borrower level, and core_rus12__yearly_plant_operations_by_plant, which contains records reported at the plant level.Records that are wholly owned by one borrower show up in both core_rus12__yearly_plant_operations_by_borrower and core_rus12__yearly_plant_operations_by_plant.
There are two boolean columns used to delineate which records are associated with the borrowers' share vs the whole plant - which is documented in _OR_PowerSupply Plant File Documentation.rtf in the newer years in the RUS 12 archive. One of these two fields - is_partly_owned_by_borrower - was not reported before 2009. For the pre-2009 years, we assume that all records that report TRUE for is_full_ownership_portion should end up in the by-plant table while all records should end up in the by-borrower portion of the table.Like the post-2009 records, this involves records from the original tables ending up in both of these PUDL tables.
Also there are two cleaning steps that we performed that alter the original data slightly:
One dropped with unexpected ownership label and duplicate data: There is a Wisdom steam plant record that is labeled to be both fully owned by borrower and partly owned for one year, which is an unexpected combo based on the _OR_PowerSupply Plant File Documentation.rst documentation file in the rus12 archive. Luckily this plant has exactly the same records as the other Wisdom steam plant that year with more expected ownership labels.* Replaced two string values for unit_id_rus: There are two instances from 2018 of unit_id_rus's that have string values in them - WSL GT 12 and WSL ST 10. Based on pre-cleaned data, we were able to clearly identify that we can use just the numeric values in these bad strings - 12 and 10 respectively. This enables us to have an integer type for this unit_id_rus column.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
Name of the plant as reported to RUS.
RUS-assigned unit identification code.
Type of plant.
Total installed (nameplate) capacity, in megawatts.
Gross electricity generation for the specified period in megawatt-hours (MWh).
Percentage of the plant owned by the respondent.
Whether or not the plant record represents the full plant - regardless of whether its fully owned by the borrower.
Whether or not the plant record is partially owned by the borrower. This column was not reported before 2009.
Annual pounds of coal consumed for fuel.This field is only reported for plant_type steam.
Annual cubic feet of natural gas consumed for fuel.This field is only reported for plant_type's combined_cycle, combined_cycle and steam.
Annual gallons of oil consumed for fuel.This field is only reported for plant_type's combined_cycle, combined_cycle and steam.
Annual other fuel consumed. Neither units nor type of fuel are documented.This field is only reported for plant_type's combined_cycle, combined_cycle and steam.
Number of operating hours in service.
Number of operating hours on standby.
Number of operating hours out of service which were scheduled.
Number of operating hours out of service which were unscheduled.
Number of times the plant was started. This field is only reported for plant_type's steam and nuclear.
core_rus12__yearly_plant_operations_by_plant
Annual time series of whole plant operational data including fuel consumption and operational hours.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part D, E, F (CC), F (IC) & G - Section A)
- Primary key:
This table has no primary key. This table has no primary key because there are a handful of plants that have duplicate records. The primary key of this table otherwise would be: [report_date, borrower_id_rus, plant_name_rus, plant_name_rus, unit_id_rus, plant_type, is_full_ownership_portion, is_partly_owned_by_borrower].
Additional Details
The data in this table comes from five different portions of RUS 12 corresponding to different plant types (steam, hydroelectric, combined_cycle, internal_combustion and nuclear). The original form includes plant operations data for each plant type reported in multiple ways: with records corresponding to the portion of plants that borrowers own as well as the whole plant. We split these records into two tables, core_rus12__yearly_plant_operations_by_borrower, which contains records reported at the borrower level, and core_rus12__yearly_plant_operations_by_plant, which contains records reported at the plant level.Records that are wholly owned by one borrower show up in both core_rus12__yearly_plant_operations_by_borrower and core_rus12__yearly_plant_operations_by_plant.
There are two boolean columns used to delineate which records are associated with the borrowers' share vs the whole plant - which is documented in _OR_PowerSupply Plant File Documentation.rtf in the newer years in the RUS 12 archive. One of these two fields - is_partly_owned_by_borrower - was not reported before 2009. For the pre-2009 years, we assume that all records that report TRUE for is_full_ownership_portion should end up in the by-plant table while all records should end up in the by-borrower portion of the table.Like the post-2009 records, this involves records from the original tables ending up in both of these PUDL tables.
Also there are two cleaning steps that we performed that alter the original data slightly:
One dropped with unexpected ownership label and duplicate data: There is a Wisdom steam plant record that is labeled to be both fully owned by borrower and partly owned for one year, which is an unexpected combo based on the _OR_PowerSupply Plant File Documentation.rst documentation file in the rus12 archive. Luckily this plant has exactly the same records as the other Wisdom steam plant that year with more expected ownership labels.* Replaced two string values for unit_id_rus: There are two instances from 2018 of unit_id_rus's that have string values in them - WSL GT 12 and WSL ST 10. Based on pre-cleaned data, we were able to clearly identify that we can use just the numeric values in these bad strings - 12 and 10 respectively. This enables us to have an integer type for this unit_id_rus column..
Plant-level data can be matched to the :ref:core_rus12__yearly_plant_labor` and forthcoming core_rus12__yearly_plant_factors_and_maximum_demand, which report Section B and C data for all plants. The RUS instructions note that:
you should use caution when using total plant data since there are cases where more than one Borrower shares units at the same plant which means that you will be getting duplicate plant total records (and there is no guarantee that the total plant records entered by two borrowers for the same plant will be identical).
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
Name of the plant as reported to RUS.
RUS-assigned unit identification code.
Type of plant.
Total installed (nameplate) capacity, in megawatts.
Gross electricity generation for the specified period in megawatt-hours (MWh).
Percentage of the plant owned by the respondent.
Whether or not the plant record is partially owned by the borrower. This column was not reported before 2009.
Annual pounds of coal consumed for fuel.This field is only reported for plant_type steam.
Annual cubic feet of natural gas consumed for fuel.This field is only reported for plant_type's combined_cycle, combined_cycle and steam.
Annual gallons of oil consumed for fuel.This field is only reported for plant_type's combined_cycle, combined_cycle and steam.
Annual other fuel consumed. Neither units nor type of fuel are documented.This field is only reported for plant_type's combined_cycle, combined_cycle and steam.
Number of operating hours in service.
Number of operating hours on standby.
Number of operating hours out of service which were scheduled.
Number of operating hours out of service which were unscheduled.
Number of times the plant was started. This field is only reported for plant_type's steam and nuclear.
core_rus12__yearly_utility_plant_changes
Annual time series of changes in utility plant
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section A)
- Primary key:
report_date, borrower_id_rus, utility_plant_group, utility_plant_item
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
Additional Details
There are a few layers of nesting in this table, which can be distinguished by the categories in the utility_plant_group column:
intangible_plant: only has one total utility_plant_item
production_plant: has several sub-component utility_plant_item and a standard total
transmission_plant: has several sub-component utility_plant_item and a standard total
distribution_plant: has several sub-component utility_plant_item and a standard total
electric_plant_in_service: has two sub-components and a total which includes those sub-components and the totals of the above categories
utility_plant_in_service: has several sub-components and the total is the sum of those sub-components as well as the total of electric_plant_in_service
total_utility_plant: has one sub-component and the total is the sum of the sub-component and utility_plant_in_service
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
High-level category of utility plant asset type.
Sub-category of utility_plant_group describing utility plant asset item.
Cost of disposal of items classified within the account.
Cost of acquisition of items classified within the account.
Amount of adjustments and transfers within a class of assets.
Account balance at end of year.
Whether or not this record represents a total.
core_rus12__monthly_demand_and_energy_at_delivery_points
Monthly time series of demand and energy delivered to distribution utilities.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section E)
- Primary key:
report_date, borrower_id_rus, delivery_recipient
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The recipient of the delivered energy or demand.
The amount of demand delivered in MW.
The amount of energy delivered in MWh.
core_rus12__monthly_demand_and_energy_at_power_sources
Monthly time series of demand and energy at point of generation.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section D)
- Primary key:
report_date, borrower_id_rus
Additional Details
There are some peak demand dates that have an hour component and others that don't. This is because there is inconsistent reporting of peak_demand_hour in the raw data. If there is no hour reported, we record the hour as 0 and only the date will show in the data.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
The amount of energy output in MWh.
peak demand in a given timeframe.
The date of the peak demand.
Whether or not the peak_mw is coincident or non-coincident peak.
core_rus12__yearly_external_financial_risk_ratio
Annual time series of ratio of investments and loan guarantee balances to total utility plant assets.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section F - Subsection III)
- Primary key:
report_date, borrower_id_rus
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
total investments + loan guarantee balances / total utility plant assets. This ratio shows how much a utility is financially exposed to outside entities relative to its own assets.
core_rus12__yearly_non_utility_plant_changes
Annual time series of changes in non-utility plant.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section C)
- Primary key:
report_date, borrower_id_rus, non_utility_plant_item
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
Category describing non-utility plant asset items.
Cost of acquisition of items classified within the account.
Cost of disposal of items classified within the account.
Amount of adjustments and transfers within a class of assets.
Account balance at end of year.
core_rus12__yearly_plant_factors_and_maximum_demand
Annual time series of plant factors and maximum demand for plants owned by RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Parts D, E, F IC, F CC, G - Section C)
- Primary key:
This table has no primary key. The primary key for this table would be report_date, borrower_id_rus, plant_name_rus, and plant_type but the plant_type column is not reported before 2009 causing lots of duplicate records. Because none of the other fields are static year-over-year, there is no reliable way to backfill the plant_type column in instances where there are different plant_types reported for the same plant in later years.
Additional Details
The plant_type field was only included in the data starting in 2009. We backfill records with only one reported plant_type per borrower/plant name/year. Records with multiple plant_types per borrower/plant name/year are left with null plant_type because there is no reliable way to determine which plant_type is associated with which record back in time. Plants who's names are reported differently pre and post 2009 will also miss being backfilled.
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
Name of the plant as reported to RUS.
Type of plant.
Fraction of potential generation that was actually reported for a plant part. Energy generated over time period / nameplate capacity * time period (hours/years/etc.).
Fraction of potential generation over the time period a plant was in operation. Energy generated over time period / nameplate capacity * time period (hours/years/etc.).
Fraction of consumption vs demand reported for a plant over a given timeframe. Energy consumed over time period / peak demand * time period (hours/years/etc.).
The highest average power output recorded over any single 15 minute interval during the reporting period.
The theoretical or nameplate peak the plant could produce under the best operating conditions during the reporting period.
core_rus12__yearly_sources_and_distribution_by_plant_type
Annual time series of capacity, plant num, MWh, and cost of energy by plant type for RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part C)
- Primary key:
report_date, borrower_id_rus, plant_type
Additional Details
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
Type of plant.
Total installed (nameplate) capacity, in megawatts.
Number of plants.
Cost value.
The net amount of energy received into the system.
core_rus12__yearly_lines_stations_labor_materials_cost
Annual time series of labor and material cost for lines and stations operated by RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Part I - Section C)
- Primary key:
report_date, borrower_id_rus, labor_or_material, operation_or_maintenance, lines_or_stations
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
Indicates whether the cost reported is for labor or material.
Indicates whether the expenditure is for operation or maintenance.
Indicates whether the cost reported pertains to lines or stations.
Cost value.