out_rus12__yearly_utility_plant_changes
Return to SearchAnnual 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.