core_rus7__yearly_investments
Return to SearchAnnual time series of investments, loan guarantees and loans.
- 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 P - Section I)
- Primary key:
This table has no primary key. This is a list of all investments or loans in each year and borrowers can have multiple records with the same investment_description.
Additional Details
Reporting of investments is required by 7 CFR 1717, Subpart N. Investment categories reported on this Part correspond to Balance Sheet items in Part C.
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.
Description of investment. This is a free-form text field and thus contains a wide variety of values.
Investment type code.
Included investment.
Excluded investment.
Income or loss from investment.
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.