out_ferc1__yearly_depreciation_changes_sched219
Return to SearchAnnual time series of changes in accumulated provision for depreciation of electric utility plant.
- Most-recent data:
2024
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
FERC Form 1 -- Annual Report of Major Electric Utilities (Schedule 219 - Section A)
- Primary key:
utility_id_ferc1, report_year, depreciation_type, plant_status, utility_type
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
FERC data is notoriously difficult to extract cleanly, and often contains free-form strings, non-labeled total rows and lack of IDs. See Notable Irregularities for details.
Additional Details
Electric utility plant refers to FERC Account 108.
Columns
Four-digit year in which the data was reported.
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year.
FERC-assigned respondent_id from DBF reporting years, identifying the reporting entity. Stable from year to year.
FERC-assigned entity_id from XBRL reporting years, identifying the reporting entity. Stable from year to year.
A manually assigned PUDL utility ID. May not be stable over time.
Name of the responding utility, as it is reported in FERC Form 1. For human readability only.
Type of depreciation provision within FERC Account 108, including cost ofremoval, depreciation expenses, salvage, cost of retired plant, etc.
Utility plant financial status (in service, future, leased, total).
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.
Dollar value of reported income, expense, asset, or liability.
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped.
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy.
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting.
Indicates whether the value reported in the row is calculated, or uniquely reported within the table.