core_rus7__yearly_statement_of_operations
Return to SearchAnnual 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 7 -- Financial and Operating Report: Electric Distribution (Part 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.