out_rus7__yearly_investments
Annual 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.
out_rus7__yearly_loans
Annual time series of loans provided 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 7 -- Financial and Operating Report: Electric Distribution (Part Q - Sections II & IV)
- Primary key:
This table has no primary key. Borrowers may receive multiple loans from lending_organizations in a given year.
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 also includes loan guarantees where the RUS borrower backs a loan from another entity and is therefore liable to pay any remaining balance should the original borrower default.
In 2006, the loan maturity date for borrower ND0051's loan from ERC - Paulson, David was reported as 2/8/2820. There is no clear way to determine the correct maturity date given that 2006 is the first year of data we have and the same loan does not appear in future years. For this reason we've nulled the date.
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 organization that received a loan.
The amount of money still owned on a loan at the end of the reporting year.
The date on which a loan is scheduled to be fully paid.
The original amount of a loan.
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.
Indicates a third-party loan that the reporting utility (referred as a borrower) has co-signed, taking on responsibility for repayment if the primary borrower defaults.
out_rus12__yearly_investments
Annual 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 12 -- Financial and Operating Report: Electric Power Supply (Part H - Section F, Sub-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
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
Reporting of investments is required by 7 CFR 1717, Subpart N. Investment categories reported on this Part correspond to Balance Sheet items in Part A Section B in table core_rus12__yearly_balance_sheet_assets.
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.
out_rus12__yearly_loans
Annual time series of loans provided 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 (Part H - Section F - Subsections II & IV)
- Primary key:
This table has no primary key. This table has no primary key because some borrowers report multiple loan values from the same entity in a given year.
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 also includes loan guarantees where the RUS borrower backs a loan from another entity and is therefore liable to pay any remaining balance should the original borrower default.
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 organization that received a loan.
The date on which a loan is scheduled to be fully paid.
The original amount of a loan.
The amount of money still owned on a loan at the end of the reporting year.
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.
Indicates a third-party loan that the reporting utility (referred as a borrower) has co-signed, taking on responsibility for repayment if the primary borrower defaults.
out_rus7__yearly_distribution_services
Annual time series of distribution services.
- 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 B)
- Primary key:
report_date, borrower_id_rus, service_status
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.
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.
Status of services (e.g., idle, retired) in report period. Idle services exclude seasonals.
Number of services in system at end of year.
Whether or not this record represents a total.
out_rus7__yearly_employee_statistics
Annual time series of statistics about employment and payroll.
- 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 H)
- Primary key:
report_date, 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.
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 number of full time employees.
The number of regular (non-overtime) hours worked by employees.
The number of overtime hours worked by employees.
The amount of payroll spent that was expensed.
The amount of payroll spent that was capitalized.
The amount of payroll spent that was funded by other means - not capitalized or expensed.
out_rus7__yearly_energy_efficiency
Annual time series of investments in and impacts of energy efficiency programs.
- 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)
- Primary key:
report_date, borrower_id_rus, customer_class, observation_period
Usage Warnings
The savings_mmbtu likely contains values with incorrect units.
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.
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.
High level categorization of customer type.
The date range that any given record pertains to. Ex: 'december' implies that this record covers the month of December only, while 'avg' implies this record pertains to the average of the reporting period.
Number of customers.
The amount of money invested.
The estimated amount of energy savings from energy efficiency programs. Warning: We found values much larger than expected that we have not yet cleaned - this is likely a reporting unit error.
out_rus7__yearly_energy_purchased
Annual 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.
out_rus7__yearly_materials_and_supplies
Annual time series of cost of electric vs. other materials that were purchased, salvaged, used, or sold.
- 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 F)
- Primary key:
report_date, borrower_id_rus, electric_or_other_materials
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.
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.
Whether the cost is for electric materials or other materials
An adjustment value for the cost of materials and supplies.
The balance at the end of the report year for materials and supplies.
The cost of materials and supplies purchased.
The cost of materials and supplies salvaged.
The cost of materials and supplies sold.
The cost of materials and supplies used.
out_rus7__yearly_meeting_and_board
Annual time series of governance information about RUS borrowers' annual member meetings as well as information about their board.
- 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 M)
- Primary key:
report_date, 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.
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 date of the last annual meeting.
The total number of members.
The number of members present at the last annual meeting.
Whether or not quorum was met.
The number of members voting by mail or by proxy.
The total number of board members.
The total amount of fees and expenses for board members.
Whether or not the RUS borrower's manager has a written contract.
out_rus7__yearly_owed_by_customers
Annual time series of debt owed by customers.
- 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 J)
- Primary key:
report_date, 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.
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.
Reported amount of dollars due over 60 days from consumers for electric service. Includes both connected and disconnected customers.
Total charges due from consumers for electric service written off during the current year to Account 144.1, representing the write-off of uncollectible accounts.
out_rus7__yearly_patronage_capital
Annual time series of patronage capital distributed and received.
- 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 I)
- Primary key:
report_date, borrower_id_rus, patronage_type
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.
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.
Type of patronage capital distributed or received.
Amount of patronage distributed or received within report year.
Amount of patronage distributed or received cumulatively. Received patronage capital is not reported cumulatively and thus will be null.
Whether or not this record represents a total.
out_rus7__yearly_power_requirements
Annual time series of power requirements - revenue and generation summary.
- 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 O)
- Primary key:
report_date, 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 includes totals of electric sales and revenue which also appear in core_rus7__yearly_power_requirements_electric_sales with a customer_class of total. This table includes all other power requirements - not broken out by customer class, so we include these electric requirements in this table as well.
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.
Total Revenue Received From Sales of Electric Energy. Total of lines 1c thru 9c on the original form.
Transmission revenue.
Electric revenue other than electric_sales_revenue.
The cost of purchases and generation of electricity.
Total MWh Sold to electric sales. Total of lines 1b thru 9b on the original form.
The electricity in MWh used for the borrower's own internal use.
The total electricity purchased.
The total electricity generated.
The net interchange of electricity. The net amount of electricity exchanged in purchases and sales.
The peak system MWh - the sum of all MW.
Whether or not the peak_mw is coincident or non-coincident peak.
out_rus7__yearly_service_interruptions
Annual time series of service interruptions by cause.
- 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 G)
- Primary key:
report_date, borrower_id_rus, service_interruption_cause, observation_period
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.
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.
Source of service interruption.
The date range that any given record pertains to. Ex: 'december' implies that this record covers the month of December only, while 'avg' implies this record pertains to the average of the reporting period.
Cumulative duration (minutes) of interruption for the average customer during the report year.
Whether or not this record represents a total.
out_rus7__yearly_statement_of_operations
Annual time series of opex and cost of electric service for RUS borrowers by time period.
- 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 A)
- Primary key:
report_date, borrower_id_rus, opex_group, opex_type
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.
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.
High level section from the statement of operations table. Most of these types have subcomponents broken out in the opex_type column.
Type of item from the statement of operations.
Amount of operational expense, cost or income during the report month.
The year-to-date amount of operational expense, cost or income.
The year-to-date budget for amount of operational expense, cost or income.
Whether or not this record represents a total.
out_rus12__yearly_depreciation_changes
Annual time series of changes in accumulated depreciation.
- 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 (Part H - Section B)
- Primary key:
report_date, borrower_id_rus, depreciation_and_amortization_group, depreciation_and_amortization_item
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.
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.
High-level category of depreciation and amortization items.
Category of depreciation and amortization items.
The composite depreciation rate within a given category. This is typically expressed as a number between 0 and 100.
Value of additions into an asset class a.k.a accruals.
Cost of retirements minus any net salvage value.
Amount of adjustments and transfers within a class of assets.
Account balance at end of year.
Whether or not this record represents a total.
out_rus12__yearly_depreciation_misc
Annual time series of accumulated depreciation.
- 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 (Part H - 2nd part of Section B)
- Primary key:
report_date, borrower_id_rus, depreciation_and_amortization_item
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 is the second half of the depreciation table. It includes ending balances of six depreciation and amortization values.
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.
Category of depreciation and amortization items.
Account balance at end of year.
out_rus12__yearly_meeting_and_board
Annual time series of annual meeting and board information for 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 (Part H - Section I)
- Primary key:
report_date, 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.
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 date of the last annual meeting.
The total number of members.
The number of members present at the last annual meeting.
Whether or not quorum was met.
The number of members voting by mail or by proxy.
The total number of board members.
The total amount of fees and expenses for board members.
Whether or not the RUS borrower's manager has a written contract.
out_rus12__yearly_plant_costs
Annual time series of costs of net energy generated by plant.
- 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 (Part F - Section D)
- Primary key:
This table has no primary key. This table has no primary key because there is one plant (Walter Scott) that has duplicate records every year. Based on other RUS-12 tables, it is likely that these duplicate records are the borrowers' ownership portion of the plant as well as the total plant but there is no clear indication in this table.
The primary key of this table otherwise would be: ['report_date', 'borrower_id_rus', 'plant_name_rus', 'cost_group', 'cost_type'].
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
The cost column in this table is expected to be largely non-null, the cost_per_mwh and cost_per_mmbtu columns only apply to some cost_type's and even plant_type's and thus are expected to contain many nulls.
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.
High-level category of cost type.
Detailed category of cost type.
Cost value.
Unit cost of energy production in cost per MWh
Unit cost of energy production in cost per MMBTU
Whether or not this record represents a total.
out_rus12__yearly_plant_labor
Annual 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.
out_rus12__yearly_renewable_plants
Annual time series of renewable energy plant generation information for 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 (Part C RE)
- Primary key:
report_date, borrower_id_rus, plant_name_rus, prime_mover_id
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.
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.
Unique numeric identifier for each prime mover type used by RUS borrowers.
Type of prime mover (e.g. Hydro, Internal Combustion).
Unique numeric identifier for each renewable fuel type.
Primary renewable fuel type used by the plant.
Percentage of renewable fuel used.
Total installed (nameplate) capacity, in megawatts.
Net electricity generation for the specified period in megawatt-hours (MWh).
Fraction of potential generation that was actually reported for a plant part. Energy generated over time period / nameplate capacity * time period (hours/years/etc.).
Number of employees.
Total production expenses (USD per MWh generated).
The cost of power per mwh.
The amount of money invested.
Percentage of the plant owned by the respondent.
Amount of funding received from the Rural Utilities Service (RUS).
General comments field.
out_rus12__yearly_sources_and_distribution
Annual time series of MWh and cost of energy sources and distribution 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 (Part C)
- Primary key:
report_date, borrower_id_rus, source_of_energy
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
See the sources_and_distribution_by_plant_type table for a breakdown of plant-type-specific cost, capacity, plant_num, and net_energy_received values. Also note that there are several source_of_energy values that don't have a corresponding cost value.
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 source of energy (not plant type).
The net amount of energy received into the system.
Cost value.
out_rus12__yearly_statement_of_operations
Annual time series of opex and cost of electric service for RUS borrowers by time period.
- 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 (Part A - Section A)
- Primary key:
report_date, borrower_id_rus, opex_group, opex_type
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.
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.
High level section from the statement of operations table. Most of these types have subcomponents broken out in the opex_type column.
Type of item from the statement of operations.
Amount of operational expense, cost or income during the report month.
The year-to-date amount of operational expense, cost or income.
The year-to-date budget for amount of operational expense, cost or income.
Whether or not this record represents a total.
out_rus7__yearly_balance_sheet_assets
Annual time series of assets and other debts from the balance sheet.
- 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 C)
- Primary key:
report_date, borrower_id_rus, asset_type
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.
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.
Type of asset being reported to the core_ferc1__yearly_balance_sheet_assets_sched110 table.
Account balance at end of year.
Whether or not this record represents a total.
out_rus7__yearly_balance_sheet_liabilities
Annual time series of liabilities and other credits from the balance sheet.
- 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 C)
- Primary key:
report_date, borrower_id_rus, liability_type
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.
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.
Type of liability being reported to the core_ferc1__yearly_balance_sheet_liabilities_sched110 table.
Account balance at end of year.
Whether or not this record represents a total.
out_rus7__yearly_long_term_debt
Annual time series of long term debt and debt service requirements.
- 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 N)
- Primary key:
This table has no primary key. This table has no native primary key. It is a list of all debts 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.
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 debt or loan. On the original form, there are nine provided descriptions and a section to add other free-form descriptions.
The amount of principal still owned on the debt at the end of the report year.
The interest expense on the debt for the report year.
The principal paid on the debt during the report year.
The total amount of debt.
out_rus7__yearly_long_term_leases
Annual time series of long term leases by property type.
- 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 L)
- Primary key:
This table has no primary key. Borrowers may receive multiple leases from lending_organizations in a given year.
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.
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 organization that provided a lease or loan.
The type of property leased.
Year-to-date rental cost for leased property.
out_rus7__yearly_transmission_and_distribution_mileage
Annual time series of miles of transmission and distribution infrastructure.
- 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 B)
- Primary key:
report_date, borrower_id_rus, line_type
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 that according to RUS, 'underbuild in overhead lines or joint runs in underground installations do not increase the number of line miles except for distribution underbuild on transmission poles. In such cases, distribution pole line miles would be increased by the number of underbuild miles involved.'
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 type of line mileage reported (e.g., transmission, overhead distribution).
Line length at the end of the reported period, in miles.
Whether or not this record represents a total.
out_rus7__yearly_utility_plant_changes
Annual time series of changes in utility plant
- 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 E)
- Primary key:
report_date, borrower_id_rus, utility_plant_group, utility_plant_item
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.
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.
High-level category of utility plant asset type.
Sub-category of utility_plant_group describing utility plant asset item.
Cost of disposal of items classified within the account.
Cost of acquisition of items classified within the account.
Amount of adjustments and transfers within a class of assets.
Account balance at end of year.
Whether or not this record represents a total.
out_rus12__yearly_balance_sheet_assets
Annual time series of assets and other debts from the balance sheet.
- 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 (Part A - Section B)
- Primary key:
report_date, borrower_id_rus, asset_type
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
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.
Type of asset being reported to the core_ferc1__yearly_balance_sheet_assets_sched110 table.
Account balance at end of year.
Whether or not this record represents a total.
out_rus12__yearly_balance_sheet_liabilities
Annual time series of liabilities and other credits from the balance sheet.
- 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 (Part A - Section B)
- Primary key:
report_date, borrower_id_rus, liability_type
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
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.
Type of liability being reported to the core_ferc1__yearly_balance_sheet_liabilities_sched110 table.
Account balance at end of year.
Whether or not this record represents a total.
out_rus12__yearly_long_term_debt
Annual time series of long-term debt and debt service requirements for 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 (Part H - Section H)
- Primary key:
This table has no primary key. This table has no primary key because some borrowers report multiple debt values from the same entity in a given year.
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.
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 debt or loan. On the original form, there are nine provided descriptions and a section to add other free-form descriptions.
The amount of principal still owned on the debt at the end of the report year.
The interest expense on the debt for the report year.
The principal paid on the debt during the report year.
The total amount of debt.
out_rus12__yearly_plant_operations_by_borrower
Annual time series of borrower portion of plant operational data including fuel consumption and operational hours.
- 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 (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].
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
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.
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.
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.
out_rus12__yearly_plant_operations_by_plant
Annual time series of whole plant operational data including fuel consumption and operational hours.
- 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 (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].
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
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..
Plant-level data can be matched to the :ref:core_rus12__yearly_plant_labor` and forthcoming core_rus12__yearly_plant_factors_and_maximum_demand, which report Section B and C data for all plants. 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.
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 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.
out_rus12__yearly_utility_plant_changes
Annual time series of changes in utility plant
- 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 (Part H - Section A)
- Primary key:
report_date, borrower_id_rus, utility_plant_group, utility_plant_item
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
There are a few layers of nesting in this table, which can be distinguished by the categories in the utility_plant_group column:
intangible_plant: only has one total utility_plant_item
production_plant: has several sub-component utility_plant_item and a standard total
transmission_plant: has several sub-component utility_plant_item and a standard total
distribution_plant: has several sub-component utility_plant_item and a standard total
electric_plant_in_service: has two sub-components and a total which includes those sub-components and the totals of the above categories
utility_plant_in_service: has several sub-components and the total is the sum of those sub-components as well as the total of electric_plant_in_service
total_utility_plant: has one sub-component and the total is the sum of the sub-component and utility_plant_in_service
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.
High-level category of utility plant asset type.
Sub-category of utility_plant_group describing utility plant asset item.
Cost of disposal of items classified within the account.
Cost of acquisition of items classified within the account.
Amount of adjustments and transfers within a class of assets.
Account balance at end of year.
Whether or not this record represents a total.
out_rus7__yearly_external_financial_risk_ratio
Annual time series of ratio of investments and loan guarantee balances to total utility plant assets.
- 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 Q - Section III)
- Primary key:
report_date, 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.
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.
total investments + loan guarantee balances / total utility plant assets. This ratio shows how much a utility is financially exposed to outside entities relative to its own assets.
out_rus7__yearly_power_requirements_electric_customers
Annual time series of power requirements - number of customers served by customer type.
- 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 O)
- Primary key:
report_date, borrower_id_rus, customer_class, observation_period
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.
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.
High level categorization of customer type.
The date range that any given record pertains to. Ex: 'december' implies that this record covers the month of December only, while 'avg' implies this record pertains to the average of the reporting period.
Number of customers.
out_rus7__yearly_power_requirements_electric_sales
Annual time series of power requirements - revenue and energy sold by customer type.
- 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 O)
- Primary key:
report_date, borrower_id_rus, customer_class
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.
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.
High level categorization of customer type.
Quantity of electricity sold in MWh.
Amount of revenue.
out_rus12__monthly_demand_and_energy_at_delivery_points
Monthly time series of demand and energy delivered to distribution utilities.
- 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 (Part H - Section E)
- Primary key:
report_date, borrower_id_rus, delivery_recipient
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.
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 recipient of the delivered energy or demand.
The amount of demand delivered in MW.
The amount of energy delivered in MWh.
out_rus12__monthly_demand_and_energy_at_power_sources
Monthly time series of demand and energy at point of generation.
- 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 (Part H - Section D)
- Primary key:
report_date, 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
There are some peak demand dates that have an hour component and others that don't. This is because there is inconsistent reporting of peak_demand_hour in the raw data. If there is no hour reported, we record the hour as 0 and only the date will show in the data.
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 amount of energy output in MWh.
Net peak demand for 60 minutes. Note: in some cases peak demand for other time periods may have been reported instead, if hourly peak demand was unavailable.
The date of the peak demand.
Whether or not the peak_mw is coincident or non-coincident peak.
out_rus12__yearly_external_financial_risk_ratio
Annual time series of ratio of investments and loan guarantee balances to total utility plant assets.
- 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 (Part H - Section F - Subsection III)
- Primary key:
report_date, 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.
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.
total investments + loan guarantee balances / total utility plant assets. This ratio shows how much a utility is financially exposed to outside entities relative to its own assets.
out_rus12__yearly_non_utility_plant_changes
Annual time series of changes in non-utility plant.
- 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 (Part H - Section C)
- Primary key:
report_date, borrower_id_rus, non_utility_plant_item
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.
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.
Category describing non-utility plant asset items.
Cost of acquisition of items classified within the account.
Cost of disposal of items classified within the account.
Amount of adjustments and transfers within a class of assets.
Account balance at end of year.
out_rus12__yearly_plant_factors_and_maximum_demand
Annual time series of plant factors and maximum demand 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 IC, F CC, G - Section C)
- Primary key:
This table has no primary key. The primary key for this table would be report_date, borrower_id_rus, plant_name_rus, and plant_type but the plant_type column is not reported before 2009 causing lots of duplicate records. Because none of the other fields are static year-over-year, there is no reliable way to backfill the plant_type column in instances where there are different plant_types reported for the same plant in later years.
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
The plant_type field was only included in the data starting in 2009. We backfill records with only one reported plant_type per borrower/plant name/year. Records with multiple plant_types per borrower/plant name/year are left with null plant_type because there is no reliable way to determine which plant_type is associated with which record back in time. Plants who's names are reported differently pre and post 2009 will also miss being backfilled.
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.
Fraction of potential generation that was actually reported for a plant part. Energy generated over time period / nameplate capacity * time period (hours/years/etc.).
Fraction of potential generation over the time period a plant was in operation. Energy generated over time period / nameplate capacity * time period (hours/years/etc.).
Fraction of consumption vs demand reported for a plant over a given timeframe. Energy consumed over time period / peak demand * time period (hours/years/etc.).
The highest average power output recorded over any single 15 minute interval during the reporting period.
The theoretical or nameplate peak the plant could produce under the best operating conditions during the reporting period.
out_rus12__yearly_sources_and_distribution_by_plant_type
Annual time series of capacity, plant num, MWh, and cost of energy by plant type for 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 (Part C)
- Primary key:
report_date, borrower_id_rus, plant_type
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
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.
Type of plant.
Total installed (nameplate) capacity, in megawatts.
Number of plants.
Cost value.
The net amount of energy received into the system.
out_rus7__yearly_customer_energy_efficiency_and_conservation_loans
Annual time series of the repayment status of loans made by a borrower to customers for investments in energy efficiency and conservation initiatives.
- 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 J)
- Primary key:
report_date, borrower_id_rus, loan_status
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
Energy Resources Conservation (ERC) loans are defined by the RUS as loans made by an RUS borrower to its consumers for the cost of labor and materials for the following energy conservation measures: caulking, weather-stripping, ceiling insulation, wall insulation, floor insulation, duct insulation, pipe insulation, water heater insulation storm windows, thermal windows, storm or thermal doors, clock thermostats and attic ventilation fans.
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 repayment status of a loan.
Observed percentage.
Expected percentage.
Balance this current year, in U.S. dollars.
out_rus12__yearly_lines_stations_labor_materials_cost
Annual time series of labor and material cost for lines and stations operated 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 (Part I - Section C)
- Primary key:
report_date, borrower_id_rus, labor_or_material, operation_or_maintenance, lines_or_stations
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.
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.
Indicates whether the cost reported is for labor or material.
Indicates whether the expenditure is for operation or maintenance.
Indicates whether the cost reported pertains to lines or stations.
Cost value.
core_rus7__entity_borrowers
Entity 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.
core_rus7__yearly_investments
Annual time series of investments, loan guarantees and loans.
- 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 (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.
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.
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.
core_rus7__yearly_loans
Annual time series of loans provided by 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 (Part Q - Sections II & IV)
- Primary key:
This table has no primary key. Borrowers may receive multiple loans from lending_organizations in a given year.
Additional Details
This table also includes loan guarantees where the RUS borrower backs a loan from another entity and is therefore liable to pay any remaining balance should the original borrower default.
In 2006, the loan maturity date for borrower ND0051's loan from ERC - Paulson, David was reported as 2/8/2820. There is no clear way to determine the correct maturity date given that 2006 is the first year of data we have and the same loan does not appear in future years. For this reason we've nulled the date.
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 organization that received a loan.
The amount of money still owned on a loan at the end of the reporting year.
The date on which a loan is scheduled to be fully paid.
The original amount of a loan.
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.
Indicates a third-party loan that the reporting utility (referred as a borrower) has co-signed, taking on responsibility for repayment if the primary borrower defaults.
core_rus12__entity_borrowers
Entity 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 12 -- Financial and Operating Report: Electric Power Supply
- 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 12. 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.