out_rus7__yearly_investments
Return to SearchAnnual time series of investments, loan guarantees and loans.
- 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 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.
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
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.
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.
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.