core_rus12__yearly_plant_operations_by_borrower
Return to SearchAnnual time series of borrower portion of plant operational data including fuel consumption and operational hours.
- 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 12 -- Financial and Operating Report: Electric Power Supply (Part D, E, F (CC), F (IC) & G - Section A)
- Primary key:
This table has no primary key. This table has no primary key because there are a handful of plants that have duplicate records. The primary key of this table otherwise would be: [report_date, borrower_id_rus, plant_name_rus, plant_name_rus, unit_id_rus, plant_type, is_full_ownership_portion, is_partly_owned_by_borrower].
Additional Details
The data in this table comes from five different portions of RUS 12 corresponding to different plant types (steam, hydroelectric, combined_cycle, internal_combustion and nuclear). The original form includes plant operations data for each plant type reported in multiple ways: with records corresponding to the portion of plants that borrowers own as well as the whole plant. We split these records into two tables, core_rus12__yearly_plant_operations_by_borrower, which contains records reported at the borrower level, and core_rus12__yearly_plant_operations_by_plant, which contains records reported at the plant level.Records that are wholly owned by one borrower show up in both core_rus12__yearly_plant_operations_by_borrower and core_rus12__yearly_plant_operations_by_plant.
There are two boolean columns used to delineate which records are associated with the borrowers' share vs the whole plant - which is documented in _OR_PowerSupply Plant File Documentation.rtf in the newer years in the RUS 12 archive. One of these two fields - is_partly_owned_by_borrower - was not reported before 2009. For the pre-2009 years, we assume that all records that report TRUE for is_full_ownership_portion should end up in the by-plant table while all records should end up in the by-borrower portion of the table.Like the post-2009 records, this involves records from the original tables ending up in both of these PUDL tables.
Also there are two cleaning steps that we performed that alter the original data slightly:
One dropped with unexpected ownership label and duplicate data: There is a Wisdom steam plant record that is labeled to be both fully owned by borrower and partly owned for one year, which is an unexpected combo based on the _OR_PowerSupply Plant File Documentation.rst documentation file in the rus12 archive. Luckily this plant has exactly the same records as the other Wisdom steam plant that year with more expected ownership labels.* Replaced two string values for unit_id_rus: There are two instances from 2018 of unit_id_rus's that have string values in them - WSL GT 12 and WSL ST 10. Based on pre-cleaned data, we were able to clearly identify that we can use just the numeric values in these bad strings - 12 and 10 respectively. This enables us to have an integer type for this unit_id_rus column.
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.
Name of the plant as reported to RUS.
RUS-assigned unit identification code.
Type of plant.
Total installed (nameplate) capacity, in megawatts.
Gross electricity generation for the specified period in megawatt-hours (MWh).
Percentage of the plant owned by the respondent.
Whether or not the plant record represents the full plant - regardless of whether its fully owned by the borrower.
Whether or not the plant record is partially owned by the borrower. This column was not reported before 2009.
Annual pounds of coal consumed for fuel.This field is only reported for plant_type steam.
Annual cubic feet of natural gas consumed for fuel.This field is only reported for plant_type's combined_cycle, combined_cycle and steam.
Annual gallons of oil consumed for fuel.This field is only reported for plant_type's combined_cycle, combined_cycle and steam.
Annual other fuel consumed. Neither units nor type of fuel are documented.This field is only reported for plant_type's combined_cycle, combined_cycle and steam.
Number of operating hours in service.
Number of operating hours on standby.
Number of operating hours out of service which were scheduled.
Number of operating hours out of service which were unscheduled.
Number of times the plant was started. This field is only reported for plant_type's steam and nuclear.