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