out_rus7__yearly_energy_purchased
Return to SearchAnnual time series of energy purchased by RUS borrowers.
- Most-recent data:
2020
- 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 K)
- Primary key:
This table has no primary key. The primary key would probably be report_date, borrower_id_rus, fuel_type_code, supplier_code_rus, renewable_energy_program if not for certain EIA utilities represented as Miscellaneous (supplier code 700000).
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
A number of records report purchases from an unspecified entity. These fields all have reported utility names beginning with an *, including *Miscellaneous, *Adjustments, and *Residential Renewable Supplier.
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 total electricity purchased.
The total cost of purchased energy. Includes fuel cost adjustment and wheeling and other charges.
The average cost of energy per MWh.
The cost of wheeling and other charges or credits related to fuel. Included in the total cost.
The variable fuel surcharge component of a distribution cooperative's wholesale purchased power bill, reflecting pass-through of actual fuel cost fluctuations from the supplying utility, reported separately from base power charges and wheeling costs. Included in the total cost.
Unique numeric identifier for RUS fuel types.
Whether the utility supplying energy to a RUS borrower is an EIA respondent.
Unique numeric identifier for the utility supplying energy to a RUS borrower.
The name of the utility.
General comments field.