out_rus7__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 7 -- Financial and Operating Report: Electric Distribution (Part E)
- 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.
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.