core_rus7__yearly_owed_by_customers
Return to SearchAnnual time series of debt owed by customers.
- 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 J)
- Primary key:
report_date, borrower_id_rus
Columns
report_date
Date reported.
borrower_id_rus
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
amount_due_over_60_days
Reported amount of dollars due over 60 days from consumers for electric service. Includes both connected and disconnected customers.
amount_written_off_ytd
Total charges due from consumers for electric service written off during the current year to Account 144.1, representing the write-off of uncollectible accounts.