out_rus7__yearly_loans
Return to SearchAnnual time series of loans provided by RUS borrowers.
- 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 Q - Sections II & IV)
- Primary key:
This table has no primary key. Borrowers may receive multiple loans from lending_organizations in a given year.
Usage Warnings
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
This table also includes loan guarantees where the RUS borrower backs a loan from another entity and is therefore liable to pay any remaining balance should the original borrower default.
In 2006, the loan maturity date for borrower ND0051's loan from ERC - Paulson, David was reported as 2/8/2820. There is no clear way to determine the correct maturity date given that 2006 is the first year of data we have and the same loan does not appear in future years. For this reason we've nulled the date.
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.
The organization that received a loan.
The amount of money still owned on a loan at the end of the reporting year.
The date on which a loan is scheduled to be fully paid.
The original amount of a loan.
Whether or not the investment or loan is for rural development. This includes investments in any/all types of projects or products that were made to improve the economy and/or quality of life in the specified area.
Indicates a third-party loan that the reporting utility (referred as a borrower) has co-signed, taking on responsibility for repayment if the primary borrower defaults.