core_rus7__yearly_loans
Return to SearchAnnual time series of loans provided by RUS borrowers.
- 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 Q - Sections II & IV)
- Primary key:
This table has no primary key. Borrowers may receive multiple loans from lending_organizations in a given year.
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 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.