core_rus7__entity_borrowers
Return to SearchEntity table containing static information about active 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
- Primary key:
borrower_id_rus
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 contains canonical values for borrowers are set. It contains values which are expected to remain fixed over time.RUS reports many attributes in many different tables across throughout RUS-7 and RUS-12. In order to compile tidy, well-normalized database tables, PUDL collects all instances of these values and and chooses a canonical value. By default, PUDL chooses the most consistently reported value of a given attribute as long as it is at least 70% of the given instances reported. For the borrower_name_rus PUDL chooses the most consistently reported value regardless of if it meets this 70% threshold so that all borrowers will have a name. We chose this because most name changes were insignificant (eg. "and" changed to "&" or "coop" changed to "cooperative"). All tables downstream of this one inherit the canonical values established here..
This table contains all of the Active Distribution Borrowers as of each report year who were eligible to report to RUS Form 7. If these Borrowers have reported to RUS they will have records in the enclosed data tables, however a small number of these Borrowers did not report for various reasons and these Borrowers will not be represented in any of the other tables.
Columns
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.