out_rus12__yearly_plant_labor
Return to SearchAnnual time series of labor and payroll information for plants owned by RUS borrowers.
- 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 12 -- Financial and Operating Report: Electric Power Supply (Parts D, E, F, G - Section B)
- Primary key:
This table has no primary key. The primary key should be report_date, borrower_id_rus, plant_name_rus, and plant_type, but this table did not report plant_type before 2009 and there are respondents who report multiple rows per plant pre-2009. The data cannot be backfilled because there is no way to distinguish between duplicate rows pre-2009.
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
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
Note the lack of plant_type pre-2009 leading to a lack of reliable primary keys.
Plant-level data from core_rus12__yearly_plant_operations_by_plant can be matched to data from this table, but you must also join this data usingthe borrower_id_rus column as well as the report_date and plant_name. This is because the core_rus12__yearly_plant_operations_by_plant table includes records from each plant owner. The RUS instructions note that:
you should use caution when using total plant data since there are cases where more than one Borrower shares units at the same plant which means that you will be getting duplicate plant total records (and there is no guarantee that the total plant records entered by two borrowers for the same plant will be identical).
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.
Name of the plant as reported to RUS.
Type of plant.
Number of employees hired full-time for normal operations of the system.
Number employees regularly employed on a part-time basis. Exclude employees hired for short periods of time to complete special jobs.
Total number of hours worked by employees.
The amount of payroll spent on plant maintenance.
The amount of payroll spent on plant operations.
The amount of plant payroll spent on accounts other than maintenance and operations.