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.

A manually assigned PUDL plant ID. May not be constant over time.

Algorithmically assigned PUDL FERC Plant ID. WARNING: NOT STABLE BETWEEN PUDL DB INITIALIZATIONS.

Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant.

Asset retirement cost (USD).

The average number of employees assigned to each 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.).

Total installed (nameplate) capacity, in megawatts.

Annual capital addition into capex_total.

Year-to-date capital addition into capex_total.

Annual capital addition into capex_total per kw.

Annual capital addition into capex_total per MW.

Year-to-date capital addition into capex_total per MW.

Annual capital addition into capex_total per MWh.

Year-to-date capital addition into capex_total per MWh.

Cost of plant: equipment (USD).

Cost of plant: land and land rights (USD).

Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD.

Cost of plant: structures and improvements (USD).

Total cost of plant (USD).

Total cost of plant (USD) without retirements.

Type of plant construction ('outdoor', 'semioutdoor', or 'conventional'). Categorized by PUDL based on our best guess of intended value in FERC1 freeform strings.

Year the plant's oldest still operational unit was built.

Year the plant's most recently built unit was installed.

Net electricity generation for the specified period in megawatt-hours (MWh).

Plant capacity in MW when not limited by condenser water.

Allowances.

Maintenance of boiler (or reactor) plant.

Cost of coolants and water (nuclear plants only)

Production expenses: electric expenses (USD).

Production expenses: maintenance, supervision, and engineering (USD).

Production expenses: fuel (USD).

Derived from MCOE, a unit level value. Average fuel cost per MWh of heat content in nominal USD.

Miscellaneous steam (or nuclear) expenses.

Maintenance of miscellaneous steam (or nuclear) plant.

Investments in non-fuel production expenses per Mwh.

Production expenses: operations, supervision, and engineering (USD).

Total production expenses (USD per MWh generated).

Production expenses: maintenance of electric plant (USD).

Total operating expenses.

Production expenses: rents (USD).

Steam expenses.

Steam from other sources.

Production expenses: maintenance of structures (USD).

Total production expenses, excluding fuel (USD).

Steam transferred (Credit).

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.

Net plant capability in megawatts.

Hours the plant was connected to load while generating in the report year.

Type of plant.

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.

Plant capacity in MW when limited by condenser water.

Average fuel cost per MMBTU of heat content in nominal USD.

Type of fuel.

FERC issued operating license ID for the facility, if available. This value is extracted from the original plant name where possible.

Production expenses: Maintenance (USD).

Total production expenses, excluding fuel (USD).

Cost of plant: reservoirs, dams, and waterways (USD).

Cost of plant: roads, railroads, and bridges (USD).

Net plant capability under the least favorable operating conditions, in megawatts.

Net plant capability under the most favorable operating conditions, in megawatts.

Production expenses: maintenance of reservoirs, dams, and waterways (USD).

Production expenses: miscellaneous power generation expenses (USD).

Production expenses: hydraulic expenses (USD).

Production expenses: maintenance of miscellaneous hydraulic plant (USD).

Production expenses: water for power (USD).

The FERC license ID of a project.

Cost of plant: accessory electric equipment (USD).

Cost of plant: miscellaneous power plant equipment (USD).

Cost of plant: water wheels, turbines, and generators (USD).

Energy used for pumping, in megawatt-hours.

Net output for load (net generation - energy used for pumping) in megawatt-hours.

Total production expenses before pumping (USD).

Production expenses: pumped storage (USD).

Production expenses: We are here to PUMP YOU UP! (USD).

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.

Listing of utility plant types.

Functional role played by utility plant (steam production, nuclear production, distribution, transmission, etc.).

Utility plant financial status (in service, future, leased, total).

The name of type of value which is a derivative of the XBRL fact name.

Account balance at end of year.

Freeform description of type of utility reported in one of the other three other utility_type sections in the core_ferc1__yearly_utility_plant_summary_sched200 table. This field is reported only in the DBF reporting years (1994-2020).

A category of asset or liability that RMI compiled to use as a shorthand for various types of utility assets. These tags were compiled manually based on the xbrl_factoid and sometimes varies based on the utility_type, plant_function or plant_status as well.

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.

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.

Indicates whether or not records with null or total values in the utility_type column were disaggregated. See documentation for process: pudl.output.ferc1.disaggregate_null_or_total_tag

Indicates whether or not records with null values in the in_rate_base column were disaggregated. See documentation for process: pudl.output.ferc1.disaggregate_null_or_total_tag

The name of the PUDL database table where a given record originated from.

Date reported.

PUDL-assigned identifying a respondent to FERC Form 714. This ID associates natively reported respondent IDs from the original CSV and XBRL data sources.

Geospatial representation of the feature.

EIA utility or balancing area authority ID associated with this FERC Form 714 respondent. Note that many utilities are also balancing authorities and in many cases EIA uses the same integer ID to identify a utility in its role as a balancing authority AND as a utility, but there is no requirement that these IDs be the same, and in a number of cases they are different.

Whether a respondent to the FERC form 714 is a utility or a balancing authority.

Name of the utility, balancing area authority, or planning authority responding to FERC Form 714.

EIA balancing authority ID. This is often (but not always!) the same as the utility ID associated with the same legal entity.

EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.

Name of the balancing authority.

The EIA Utility Identification number.

The name of the utility.

County population, sourced from Census DP1 data.

County area in km2.

Annual electricity demand in a given report year.

EIA utility or balancing area authority ID associated with this FERC Form 714 respondent. Note that many utilities are also balancing authorities and in many cases EIA uses the same integer ID to identify a utility in its role as a balancing authority AND as a utility, but there is no requirement that these IDs be the same, and in a number of cases they are different.

Whether a respondent to the FERC form 714 is a utility or a balancing authority.

PUDL-assigned identifying a respondent to FERC Form 714. This ID associates natively reported respondent IDs from the original CSV and XBRL data sources.

Name of the utility, balancing area authority, or planning authority responding to FERC Form 714.

Date reported.

EIA balancing authority ID. This is often (but not always!) the same as the utility ID associated with the same legal entity.

EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.

Name of the balancing authority.

The EIA Utility Identification number.

The name of the utility.

Two letter US state abbreviation.

County name.

Two digit state FIPS code.

County ID from the Federal Information Processing Standard Publication 6-4.

Date reported.

PUDL-assigned identifying a respondent to FERC Form 714. This ID associates natively reported respondent IDs from the original CSV and XBRL data sources.

Annual electricity demand in a given report year.

County population, sourced from Census DP1 data.

County area in km2.

Average population per sq. km area of a service territory.

Per-capita annual demand, averaged using Census county-level population estimates.

Annual demand per km2 of a given service territory.

EIA utility or balancing area authority ID associated with this FERC Form 714 respondent. Note that many utilities are also balancing authorities and in many cases EIA uses the same integer ID to identify a utility in its role as a balancing authority AND as a utility, but there is no requirement that these IDs be the same, and in a number of cases they are different.

Whether a respondent to the FERC form 714 is a utility or a balancing authority.

Name of the utility, balancing area authority, or planning authority responding to FERC Form 714.

EIA balancing authority ID. This is often (but not always!) the same as the utility ID associated with the same legal entity.

EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.

Name of the balancing authority.

The EIA Utility Identification number.

The name of the utility.

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.

The name of type of value which is a derivative of the XBRL fact name.

Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.

Functional role played by utility plant (steam production, nuclear production, distribution, transmission, etc.).

The technology type associated with components of a utility's revenue requirement. These categories were manually compiled by RMI utility accounting experts based on the xbrl_factoid and sometimes vary based on the utility_type or plant_function as well. This column is intended to be used to aggregate this table.

Dollar value of reported income, expense, asset, or liability.

Whether or not a record from the detailed income statement data is typically included in a utility's revenue requirement. This flag was manually compiled by RMI utility accounting experts based on the xbrl_factoid and sometimes varies based on the utility_type or plant_function.

The category of revenue requirement associated with each component of utility'sincome statements. These categories were manually compiled by RMI utility accounting experts based on the xbrl_factoid and sometimes vary based on the utility_type or plant_function. This column is intended to be used to aggregate this table.

The name of the PUDL database table where a given record originated from.

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.

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.

Label describing the type of amount being reported. This could be a balance or a change in value.

Reported amount of dollars. This could be a balance or a change in value.

Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy.

Indicates whether the value reported in the row is calculated, or uniquely reported within the table.

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.

Functional role played by utility plant (steam production, nuclear production, distribution, transmission, etc.).

Utility plant financial status (in service, future, leased, total).

Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.

Account balance at end of year.

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.

Indicates whether the value reported in the row is calculated, or uniquely reported within the table.

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.

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.

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.

Label of the factor of depreciation factors. This field contains is an unstructured, free-form strings. It often includes FERC account IDs, sometimes includes plant names and sometimes includes headers indicating the beginning of a new section - such as a plant or asset type header which is followed by sub-components like FERC account IDs or plant names depending on the section.

Depreciable plant balance (depreciable base) to which rates are applied.

Percentage representing the estimated value of utility plant at the end of its service life. Be aware that the formatting of this column is not expected to be standard - expect some values between 0-1 and some between 0-100.

Depreciation rate applied to utility plant balance.Be aware that the formatting of this column is not expected to be standard - expect some values between 0-1 and some between 0-100.

Description of the type of mortality curve selected in plant mortality studies prepared to assist in estimating average service lives.

This field is defined in FERC-XBRL documentation as a field that is used to sequence a table.FERC-XBRL documentation notes: 'This field is added to a table to control ordering of the items on the table.'FERC's documentation also notes that this field should always be an integer - although there are many instances of floating point values which seem to increment by decimal points. Nonetheless, this field can be used to help understand the original order of the table. This field did not exist prior to FERC publishing Form 1 as XBRL and thus is always null prior to 2021.

Account number(s) in connection with factors used in estimating depreciation charges.

Estimated average service life of utility plant. The original DBF data was reported as years while the XBRL data was reported as strings in this time duration format: PnYnMnDTnHnMnS. PUDL converts these string time durations into years.

Estimated weighted average of remaining life of utility plant assets.The original DBF data was reported as years while the XBRL data was reported as strings in this time duration format: PnYnMnDTnHnMnS. PUDL converts these string time durations into years.

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.

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.

Functional role played by utility plant (steam production, nuclear production, distribution, transmission, etc.).

Long FERC account identifier derived from values reported in the XBRL taxonomies. May also refer to aggregations of individual FERC accounts.

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.

Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.

Dollar value of reported income, expense, asset, or liability.

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.

The name of type of value which is a derivative of the XBRL fact name.

Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.

Functional role played by utility plant (steam production, nuclear production, distribution, transmission, etc.).

Utility plant financial status (in service, future, leased, total).

Account balance at end of year.

Freeform description of type of utility reported in one of the other three other utility_type sections in the core_ferc1__yearly_utility_plant_summary_sched200 table. This field is reported only in the DBF reporting years (1994-2020).

Whether or not a record from the detailed FERC1 accounting tables should be considered allowable in a utility's rate base based on utility accounting standards. This flag was manually compiled by RMI utility accounting experts based on the xbrl_factoid and sometimes varies based on the utility_type, plant_status or plant_function.

A category of asset or liability that RMI compiled to use as a shorthand for various types of utility assets. These tags were compiled manually based on the xbrl_factoid and sometimes varies based on the utility_type, plant_function or plant_status as well.

The name of the PUDL database table where a given record originated from.

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.

The name of type of value which is a derivative of the XBRL fact name.

Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.

Account balance at end of year.

Whether or not a record from the detailed FERC1 accounting tables should be considered allowable in a utility's rate base based on utility accounting standards. This flag was manually compiled by RMI utility accounting experts based on the xbrl_factoid and sometimes varies based on the utility_type, plant_status or plant_function.

A category of asset or liability that RMI compiled to use as a shorthand for various types of utility assets. These tags were compiled manually based on the xbrl_factoid and sometimes varies based on the utility_type, plant_function or plant_status as well.

The name of the PUDL database table where a given record originated from.

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 energy disposition reported in the core_ferc1__yearly_energy_dispositions_sched401. Dispositions include sales to customers, re-sales of energy, energy used internally, losses, etc.

Indicates whether the value reported in the row is calculated, or uniquely reported within the table.

Sources and uses of energy in MWh.

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.

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 energy source reported in the core_ferc1__yearly_energy_sources_sched401 table. There are three groups of energy sources: generation, power exchanges and transmission.

Indicates whether the value reported in the row is calculated, or uniquely reported within the table.

Sources and uses of energy in MWh.

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.

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.

Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant.

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.

Asset retirement cost (USD).

The average number of employees assigned to each 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.).

Total installed (nameplate) capacity, in megawatts.

Cost of plant: equipment (USD).

Cost of plant: reservoirs, dams, and waterways (USD).

Cost of plant: land and land rights (USD).

Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD.

Cost of plant: roads, railroads, and bridges (USD).

Cost of plant: structures and improvements (USD).

Total cost of plant (USD).

Type of plant construction ('outdoor', 'semioutdoor', or 'conventional'). Categorized by PUDL based on our best guess of intended value in FERC1 freeform strings.

Year the plant's oldest still operational unit was built.

Year the plant's most recently built unit was installed.

Net plant capability under the least favorable operating conditions, in megawatts.

Net plant capability under the most favorable operating conditions, in megawatts.

Net electricity generation for the specified period in megawatt-hours (MWh).

Production expenses: maintenance of reservoirs, dams, and waterways (USD).

Production expenses: electric expenses (USD).

Production expenses: maintenance, supervision, and engineering (USD).

Production expenses: miscellaneous power generation expenses (USD).

Production expenses: hydraulic expenses (USD).

Production expenses: maintenance of miscellaneous hydraulic plant (USD).

Production expenses: operations, supervision, and engineering (USD).

Total production expenses (USD per MWh generated).

Production expenses: maintenance of electric plant (USD).

Production expenses: rents (USD).

Production expenses: maintenance of structures (USD).

Total production expenses, excluding fuel (USD).

Total production expenses, excluding fuel (USD).

Production expenses: water for power (USD).

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.

Hours the plant was connected to load while generating in the report year.

A manually assigned PUDL plant ID. May not be constant over time.

Type of plant.

FERC Licensed Project Number.

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.

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.

Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.

Type of income reported in core_ferc1__yearly_income_statements_sched114 table.

Dollar value of reported income, expense, asset, or liability.

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.

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.

Dollar value of reported income, expense, asset, or liability.

The type of expense.

Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.

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.

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.

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.

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.

Label describing types of revenues.

Dollar value of reported income, expense, asset, or liability.

Quantity of electricity sold in MWh.

Average number of customers per month.

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.

Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.

Indicates whether the value reported in the row is calculated, or uniquely reported within the table.

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.

Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.

Utility plant financial status (in service, future, leased, total).

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.

Cost of acquisition of items classified within the account.

Cost of adjustments to the account.

Account balance at end of year.

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.

Long FERC account identifier derived from values reported in the XBRL taxonomies. May also refer to aggregations of individual FERC accounts.

Cost of disposal of items classified within the account.

Indicates whether the value reported in the row is calculated, or uniquely reported within the table.

Account balance at beginning of year.

Cost of transfers into (out of) the account.

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.

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.

Label describing types of earnings.

Account balance at beginning of year.

Account balance at end of year.

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.

Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.

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.

A manually assigned PUDL plant ID. May not be constant over time.

Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant.

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.

Total installed (nameplate) capacity, in megawatts.

Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD.

Total cost of plant (USD).

Year the plant's oldest still operational unit was built.

Average fuel cost per MMBTU of heat content in nominal USD.

Type of fuel.

FERC issued operating license ID for the facility, if available. This value is extracted from the original plant name where possible.

Net electricity generation for the specified period in megawatt-hours (MWh).

Production expenses: fuel (USD).

Production expenses: Maintenance (USD).

Production expenses: operations, supervision, and engineering (USD).

Total production expenses, excluding fuel (USD).

Total production expenses, excluding fuel (USD).

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.

Type of plant.

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.

A manually assigned PUDL plant ID. May not be constant over time.

Algorithmically assigned PUDL FERC Plant ID. WARNING: NOT STABLE BETWEEN PUDL DB INITIALIZATIONS.

Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant.

Asset retirement cost (USD).

The average number of employees assigned to each 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.).

Total installed (nameplate) capacity, in megawatts.

Annual capital addition into capex_total.

Year-to-date capital addition into capex_total.

Annual capital addition into capex_total per kw.

Annual capital addition into capex_total per MW.

Year-to-date capital addition into capex_total per MW.

Annual capital addition into capex_total per MWh.

Year-to-date capital addition into capex_total per MWh.

Cost of plant: equipment (USD).

Cost of plant: land and land rights (USD).

Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD.

Cost of plant: structures and improvements (USD).

Total cost of plant (USD).

Total cost of plant (USD) without retirements.

Type of plant construction ('outdoor', 'semioutdoor', or 'conventional'). Categorized by PUDL based on our best guess of intended value in FERC1 freeform strings.

Year the plant's oldest still operational unit was built.

Year the plant's most recently built unit was installed.

Net electricity generation for the specified period in megawatt-hours (MWh).

Plant capacity in MW when not limited by condenser water.

Allowances.

Maintenance of boiler (or reactor) plant.

Cost of coolants and water (nuclear plants only)

Production expenses: electric expenses (USD).

Production expenses: maintenance, supervision, and engineering (USD).

Production expenses: fuel (USD).

Production expenses: fuel (USD) per megawatt-hour (Mwh).

Miscellaneous steam (or nuclear) expenses.

Maintenance of miscellaneous steam (or nuclear) plant.

Investments in non-fuel production expenses per Mwh.

Production expenses: operations, supervision, and engineering (USD).

Total production expenses (USD per MWh generated).

Maintenance of electrical plant.

Total operating expenses.

Production expenses: rents (USD).

Steam expenses.

Steam from other sources.

Production expenses: maintenance of structures (USD).

Total production expenses, excluding fuel (USD).

Steam transferred (Credit).

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.

Net plant capability in megawatts.

Hours the plant was connected to load while generating in the report year.

Type of plant.

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.

Plant capacity in MW when limited by condenser water.

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.

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.

The starting point of a transmission line.

The end point of a transmission line.

The operating voltage, expressed kilo-volts, for three-phase 60 cycle alternative current transmission lines.

Manufactured (Designed) voltage, expressed in kilo-volts, for three-phase 60 cycle alternative current transmission lines

Supporting structure of the transmission line.

Length (in pole miles or circuit miles (if transmission lines are underground)) for lines that are stand alone structures (whose cost are reported on a stand-alone basis).

Length (in pole miles or circuit miles (if transmission lines are underground)) for lines that are agrregated with other lines / structures (whose cost are aggregated and combined with other structures).

Number of circuits in a transmission line.

Size of transmission conductor and material of the transmission line.

Cost of plant: land and land rights (USD).

Other costs associated with the plant (USD).

Total cost of plant (USD).

Production expenses: operations, supervision, and engineering (USD).

Production expenses: Maintenance (USD).

Production expenses: rents (USD).

Total production expenses, excluding fuel (USD).

Two digit state FIPS code.

Date and time converted to Coordinated Universal Time (UTC).

Electricity demand (energy) within a given timeframe.

Estimated electricity demand scaled by the total sales within a state.

PUDL-assigned identifying a respondent to FERC Form 714. This ID associates natively reported respondent IDs from the original CSV and XBRL data sources.

FERC Form 714 respondent ID from CSV reported data - published from years: 2006-2020. This ID is linked to the newer years of reported XBRL data through the PUDL-assigned respondent_id_ferc714 ID. This ID was originally reported as respondent_id. Note that this ID does not correspond to FERC respondent IDs from other forms.

FERC Form 714 respondent ID from XBRL reported data - published from years: 2021-present. This ID is linked to the older years of reported CSV data through the PUDL-assigned respondent_id_ferc714 ID. This ID was originally reported as entity_id. Note that this ID does not correspond to FERC respondent IDs from other forms.

Date reported.

Date and time converted to Coordinated Universal Time (UTC).

IANA timezone name

Originally reported electricity demand, calculated by taking the net generation within the BA and subtracting the interchange with adjacent BAs.

Electricity demand calculated by subtracting BA interchange from net generation, with outliers and missing values imputed in PUDL.

Code describing why a demand value was flagged for imputation.

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.

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.

Type of asset being reported to the core_ferc1__yearly_balance_sheet_assets_sched110 table.

Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy.

Account balance at end of year.

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.

Account balance at beginning of year.

Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.

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.

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.

Account balance at beginning of year.

Account balance at end of year.

Type of liability being reported to the core_ferc1__yearly_balance_sheet_liabilities_sched110 table.

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.

Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.

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.

Long human-readable description of the meaning of a code/label.

Additional free-form description column. In most instances, the values in this column are exactly the same as the description column,but it differs from the standard description enough that we kept both columns. This field did not exist prior to FERC publishing Form 1 as XBRL and thus is always null prior to 2021.

Account balance at end of year.

Account balance at beginning of year.

The increase (decrease) during the period in the value of other assets resulting from the ratemaking actions of regulatory agencies.

Recovered amount of divestiture of other assets lacking physical substance resulting from the ratemaking actions of regulatory agencies.

Description of the account number credited from making debit adjustment to other regulatory liabilities.

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.

Long human-readable description of the meaning of a code/label.

Account balance at end of year.

Account balance at beginning of year.

The increase during the reporting period of other regulatory liabilities.

Description of the account number credited from making debit adjustment to other regulatory liabilities.

The decrease during the reporting period of other regulatory liabilities.

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.

Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant.

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.

Asset retirement cost (USD).

The average number of employees assigned to each 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.).

Total installed (nameplate) capacity, in megawatts.

Cost of plant: accessory electric equipment (USD).

Cost of plant: miscellaneous power plant equipment (USD).

Cost of plant: reservoirs, dams, and waterways (USD).

Cost of plant: land and land rights (USD).

Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD.

Cost of plant: roads, railroads, and bridges (USD).

Cost of plant: structures and improvements (USD).

Total cost of plant (USD).

Cost of plant: water wheels, turbines, and generators (USD).

Type of plant construction ('outdoor', 'semioutdoor', or 'conventional'). Categorized by PUDL based on our best guess of intended value in FERC1 freeform strings.

Year the plant's oldest still operational unit was built.

Energy used for pumping, in megawatt-hours.

Year the plant's most recently built unit was installed.

Net electricity generation for the specified period in megawatt-hours (MWh).

Net output for load (net generation - energy used for pumping) in megawatt-hours.

Production expenses: maintenance of reservoirs, dams, and waterways (USD).

Production expenses: electric expenses (USD).

Production expenses: maintenance, supervision, and engineering (USD).

Production expenses: miscellaneous power generation expenses (USD).

Production expenses: maintenance of miscellaneous hydraulic plant (USD).

Production expenses: operations, supervision, and engineering (USD).

Total production expenses (USD per MWh generated).

Production expenses: maintenance of electric plant (USD).

Total production expenses before pumping (USD).

Production expenses: pumped storage (USD).

Production expenses: We are here to PUMP YOU UP! (USD).

Production expenses: rents (USD).

Production expenses: maintenance of structures (USD).

Total production expenses, excluding fuel (USD).

Total production expenses, excluding fuel (USD).

Production expenses: water for power (USD).

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.

Net plant capability in megawatts.

Hours the plant was connected to load while generating in the report year.

A manually assigned PUDL plant ID. May not be constant over time.

FERC Licensed Project Number.

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.

Name of the seller, or the other party in an exchange transaction.

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.

Monthly average billing demand (for requirements purchases, and any transactions involving demand charges). In megawatts.

Average monthly coincident peak (CP) demand (for requirements purchases, and any transactions involving demand charges). Monthly CP demand is the metered demand during the hour (60-minute integration) in which the supplier's system reaches its monthly peak. In megawatts.

Gross megawatt-hours delivered in power exchanges and used as the basis for settlement.

Demand charges (USD).

Energy charges (USD).

Average monthly non-coincident peak (NCP) demand (for requirements purhcases, and any transactions involving demand charges). Monthly NCP demand is the maximum metered hourly (60-minute integration) demand in a month. In megawatts.

Other charges, including out-of-period adjustments (USD).

Categorization based on the original contractual terms and conditions of the service. Must be one of 'requirements', 'long_firm', 'intermediate_firm', 'short_firm', 'long_unit', 'intermediate_unit', 'electricity_exchange', 'other_service', or 'adjustment'. Requirements service is ongoing high reliability service, with load integrated into system resource planning. 'Long term' means 5+ years. 'Intermediate term' is 1-5 years. 'Short term' is less than 1 year. 'Firm' means not interruptible for economic reasons. 'unit' indicates service from a particular designated generating unit. 'exchange' is an in-kind transaction.

Megawatt-hours shown on bills rendered to the respondent. Includes both electricity purchased for storage and non-storage purposes, which were lumped together prior to 2021.

Number of megawatt hours purchased during the period for energy storage.

Number of megawatt hours purchased during the period for other than energy storage.

Gross megawatt-hours received in power exchanges and used as the basis for settlement.

FERC Rate Schedule Number or Tariff. (Note: may be incomplete if originally reported on multiple lines.)

Sum of demand, energy, and other charges (USD). For power exchanges, the settlement amount for the net receipt of energy. If more energy was delivered than received, this amount is negative.

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.

Categorization of rate schedule type.

Whether an amount is billed, unbilled, or both. Billed amounts pertain to the exchange of energy and unbilled amounts pertain to other sources of revenue such as contracts with peaker plants to keep them on standby or charging rent to host cell antennas on transmission towers.

Free-form description of what the rate schedule name is. Not standardized. Often a sub-category of rate_schedule_type.

Quantity of electricity sold in MWh.

Dollar value of reported income, expense, asset, or liability.

Average number of customers per month.

kWh per customer.

The amount of revenue per kWh by rate schedule acquired in the given report year.

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.

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.

A manually assigned PUDL plant ID. May not be constant over time.

Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant.

Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production.

Total cost of consumed fuel.

Consumption of the fuel type in physical unit. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production.

Average fuel cost per MMBTU of heat content in nominal USD.

Average cost of fuel consumed in the report year per reported fuel unit (USD).

Average cost of fuel delivered in the report year per reported fuel unit (USD).

Heat content of the fuel in millions of Btus per physical unit.

Simplified fuel type code used in PUDL

Reported unit of measure for fuel.

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.

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.

Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.

Freeform description of type of utility reported in one of the other three other utility_type sections in the core_ferc1__yearly_utility_plant_summary_sched200 table. This field is reported only in the DBF reporting years (1994-2020).

Type of utility plant asset reported in the core_ferc1__yearly_utility_plant_summary_sched200 table. Assets include those leased to others, held for future use, construction work-in-progress and details of accumulated depreciation.

Indicates whether the value reported in the row is calculated, or uniquely reported within the table.

Account balance at end of year.

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.

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.

Identifier for EIA plant parts analysis records.

Indicates the source and validation of the match between EIA and FERC. Match types include matches was generated from the model, verified by the training data, overridden by the training data, etc.

Derived plant name that includes EIA plant name and other strings associated with ID and PK columns of the plant part.

The part of the plant a record corresponds to.

Four-digit year in which the data was reported.

Date reported.

Whether each generator record is for one owner or represents a total of all ownerships.

Plant name.

The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration.

Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string!

Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time.

Code for the type of prime mover (e.g. CT, CG)

The code representing the most predominant type of energy that fuels the generator.

High level description of the technology used by the generator to produce electricity.

Name of FERC account, derived from technology description and prime mover code.

Year a generator went into service.

The EIA Utility Identification number.

A manually assigned PUDL utility ID. May not be stable over time.

Indicates whether a plant part list record is associated with the highest priority plant part for all identical records.

Plant part of the associated true granularity record.

EIA record ID of the associated true granularity record.

Number of distinct generator IDs that participated in the aggregation for a plant part list record.

Proportion of generator ownership attributable to this utility.

Whether a plant part record has a duplicate record with different ownership status.

The operating status of the asset. For generators this is based on which tab the generator was listed in in EIA 860.

The operating status of the asset using PUDL categories.

A manually assigned PUDL plant ID. May not be constant over time.

Total annual reported fuel costs for the plant part. Includes costs from all fuels.

Average fuel cost per MMBTU of heat content in nominal USD.

Net electricity generation for the specified period in megawatt-hours (MWh).

Total installed (nameplate) capacity, in megawatts.

Fraction of potential generation that was actually reported for a plant part. Energy generated over time period / nameplate capacity * time period (hours/years/etc.).

Total annual heat content of fuel consumed by a plant part record in the plant parts list.

Fuel content per unit of electricity generated. Coming from MCOE calculation.

Simplified fuel type code used in PUDL

Year the plant's most recently built unit was installed.

Contains EIA plant ID, plant part, ownership, and EIA utility id

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.

Name of the responding utility, as it is reported in FERC Form 1. For human readability only.

Algorithmically assigned PUDL FERC Plant ID. WARNING: NOT STABLE BETWEEN PUDL DB INITIALIZATIONS.

Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant.

Asset retirement cost (USD).

The average number of employees assigned to each 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.).

Total installed (nameplate) capacity, in megawatts.

Annual capital addition into capex_total.

Year-to-date capital addition into capex_total.

Annual capital addition into capex_total per kw.

Annual capital addition into capex_total per MW.

Year-to-date capital addition into capex_total per MW.

Annual capital addition into capex_total per MWh.

Year-to-date capital addition into capex_total per MWh.

Cost of plant: equipment (USD).

Cost of plant: land and land rights (USD).

Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD.

Cost of plant: structures and improvements (USD).

Total cost of plant (USD).

Total cost of plant (USD) without retirements.

Type of plant construction ('outdoor', 'semioutdoor', or 'conventional'). Categorized by PUDL based on our best guess of intended value in FERC1 freeform strings.

Year the plant's oldest still operational unit was built.

Year the plant's oldest still operational unit was built.

Year the plant's most recently built unit was installed.

Net electricity generation for the specified period in megawatt-hours (MWh).

Plant capacity in MW when not limited by condenser water.

Allowances.

Maintenance of boiler (or reactor) plant.

Cost of coolants and water (nuclear plants only)

Production expenses: electric expenses (USD).

Production expenses: maintenance, supervision, and engineering (USD).

Production expenses: fuel (USD).

Derived from MCOE, a unit level value. Average fuel cost per MWh of heat content in nominal USD.

Derived from MCOE, a unit level value. Average fuel cost per MWh of heat content in nominal USD.

Miscellaneous steam (or nuclear) expenses.

Maintenance of miscellaneous steam (or nuclear) plant.

Investments in non-fuel production expenses per Mwh.

Production expenses: operations, supervision, and engineering (USD).

Total production expenses (USD per MWh generated).

Production expenses: maintenance of electric plant (USD).

Total operating expenses.

Production expenses: rents (USD).

Steam expenses.

Steam from other sources.

Production expenses: maintenance of structures (USD).

Total production expenses, excluding fuel (USD).

Steam transferred (Credit).

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.

Net plant capability in megawatts.

Hours the plant was connected to load while generating in the report year.

Type of plant.

Plant capacity in MW when limited by condenser water.

Average fuel cost per MMBTU of heat content in nominal USD.

Type of fuel.

FERC issued operating license ID for the facility, if available. This value is extracted from the original plant name where possible.

Production expenses: Maintenance (USD).

Total production expenses, excluding fuel (USD).

Cost of plant: reservoirs, dams, and waterways (USD).

Cost of plant: roads, railroads, and bridges (USD).

Net plant capability under the least favorable operating conditions, in megawatts.

Net plant capability under the most favorable operating conditions, in megawatts.

Production expenses: maintenance of reservoirs, dams, and waterways (USD).

Production expenses: miscellaneous power generation expenses (USD).

Production expenses: hydraulic expenses (USD).

Production expenses: maintenance of miscellaneous hydraulic plant (USD).

Production expenses: water for power (USD).

The FERC license ID of a project.

Cost of plant: accessory electric equipment (USD).

Cost of plant: miscellaneous power plant equipment (USD).

Cost of plant: water wheels, turbines, and generators (USD).

Energy used for pumping, in megawatt-hours.

Net output for load (net generation - energy used for pumping) in megawatt-hours.

Total production expenses before pumping (USD).

Production expenses: pumped storage (USD).

Production expenses: We are here to PUMP YOU UP! (USD).

Total annual reported fuel costs for the plant part. Includes costs from all fuels.

Total annual heat content of fuel consumed by a plant part record in the plant parts list.

Simplified fuel type code used in PUDL

Fuel content per unit of electricity generated. Calculated from FERC reported fuel consumption and net generation.

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.

A manually assigned PUDL plant ID. May not be constant over time.

Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant.

Coal cost as a percentage of overall fuel cost.

Coal heat content as a percentage of overall fuel heat content (MMBTU).

Total fuel cost for plant (in $USD).

Total heat content for plant (in MMBTU).

Natural gas cost as a percentage of overall fuel cost.

Natural gas heat content as a percentage of overall fuel heat content (MMBTU).

Nuclear cost as a percentage of overall fuel cost.

Nuclear heat content as a percentage of overall fuel heat content (MMBTU).

Oil cost as a percentage of overall fuel cost.

Oil heat content as a percentage of overall fuel heat content (MMBTU).

Primary fuel for plant as a percentage of cost.

Primary fuel for plant as a percentage of heat content.

Waste-heat cost as a percentage of overall fuel cost.

Waste-heat heat content as a percentage of overall fuel heat content (MMBTU).

Account identifier from FERC's Uniform System of Accounts for Electric Plant. Includes higher level labeled categories.

Description of the FERC account.

The Company Identifier (CID) obtained through FERC's Company Registration system.

The name of the FERC-reporting organization or company.

The specific program or initiative associated with the FERC organization, which can provide context for the company's activities.

The website URL of the company, which can provide additional information about the organization.

Physical street address.

Second line of the address.

Name of the city.

Two letter US state abbreviation.

Five digit US Zip Code.

Four digit US Zip Code suffix.

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.

Four-digit year in which the data was reported.

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.

Name of the responding utility, as it is reported in FERC Form 1. For human readability only.

Former name of the responding utility, when it changed within the last year.

Date of last name change of the company.

The Company Identifier (CID) obtained through FERC's Company Registration system.

Legal Entity Identification Number issued by Global Legal Entity Identifier Foundation (GLEIF). The Legal Entity Identifier (LEI) is a 20-character, alpha-numeric code based on the ISO 17442 standard developed by the International Organization for Standardization (ISO).

Name of contact person for the respondent.

Title of contact person for the respondent.

Email for contact identified in contact_name.

Street address for contact identified in contact_name.

Phone number for contact identified in contact_name.

City for contact identified in contact_name.

State for contact identified in contact_name.

Zip code for contact identified in contact_name.

Street address of principal office at end of period.

City of principal office at end of period.

State of principal office at end of period.

Zipcode of principal office at end of period.

Name of person signing the corporate officer's certification.

Title of person signing the corporate officer's certification.

Date that corporate officer's certification was signed.

Signature of corporate officer to certify the report.

Name of software company used for creating the instance file submitted. If the filer created the submission, is null

Type of report submitted: O (original) or R (revision).

Date on which the filing was submitted.

PUDL-assigned identifying a respondent to FERC Form 714. This ID associates natively reported respondent IDs from the original CSV and XBRL data sources.

FERC Form 714 respondent ID from CSV reported data - published from years: 2006-2020. This ID is linked to the newer years of reported XBRL data through the PUDL-assigned respondent_id_ferc714 ID. This ID was originally reported as respondent_id. Note that this ID does not correspond to FERC respondent IDs from other forms.

FERC Form 714 respondent ID from XBRL reported data - published from years: 2021-present. This ID is linked to the older years of reported CSV data through the PUDL-assigned respondent_id_ferc714 ID. This ID was originally reported as entity_id. Note that this ID does not correspond to FERC respondent IDs from other forms.

Name of the utility, balancing area authority, or planning authority responding to FERC Form 714.

EIA utility or balancing area authority ID associated with this FERC Form 714 respondent. Note that many utilities are also balancing authorities and in many cases EIA uses the same integer ID to identify a utility in its role as a balancing authority AND as a utility, but there is no requirement that these IDs be the same, and in a number of cases they are different.

Originally reported short code.

Longer human-readable code using snake_case

Long human-readable description of the meaning of a code/label.

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.

Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant.

A manually assigned PUDL plant ID. May not be constant over time.

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.

Name of the responding utility, as it is reported in FERC Form 1. For human readability only.

A manually assigned PUDL utility ID. May not be stable over time.

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.

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.

Label describing the type of amount being reported. This could be a balance or a change in value.

Reported amount of dollars. This could be a balance or a change in value.

Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy.

Indicates whether the value reported in the row is calculated, or uniquely reported within the table.

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.

Four-digit year in which the data was reported.

Type of depreciation provision within FERC Account 108, including cost ofremoval, depreciation expenses, salvage, cost of retired plant, etc.

Functional role played by utility plant (steam production, nuclear production, distribution, transmission, etc.).

Utility plant financial status (in service, future, leased, total).

Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.

Account balance at end of year.

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.

Indicates whether the value reported in the row is calculated, or uniquely reported within the table.

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.

Four-digit year in which the data was reported.

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.

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.

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.

Label of the factor of depreciation factors. This field contains is an unstructured, free-form strings. It often includes FERC account IDs, sometimes includes plant names and sometimes includes headers indicating the beginning of a new section - such as a plant or asset type header which is followed by sub-components like FERC account IDs or plant names depending on the section.

Depreciable plant balance (depreciable base) to which rates are applied.

Percentage representing the estimated value of utility plant at the end of its service life. Be aware that the formatting of this column is not expected to be standard - expect some values between 0-1 and some between 0-100.

Depreciation rate applied to utility plant balance.Be aware that the formatting of this column is not expected to be standard - expect some values between 0-1 and some between 0-100.

Description of the type of mortality curve selected in plant mortality studies prepared to assist in estimating average service lives.

This field is defined in FERC-XBRL documentation as a field that is used to sequence a table.FERC-XBRL documentation notes: 'This field is added to a table to control ordering of the items on the table.'FERC's documentation also notes that this field should always be an integer - although there are many instances of floating point values which seem to increment by decimal points. Nonetheless, this field can be used to help understand the original order of the table. This field did not exist prior to FERC publishing Form 1 as XBRL and thus is always null prior to 2021.

Account number(s) in connection with factors used in estimating depreciation charges.

Estimated average service life of utility plant. The original DBF data was reported as years while the XBRL data was reported as strings in this time duration format: PnYnMnDTnHnMnS. PUDL converts these string time durations into years.

Estimated weighted average of remaining life of utility plant assets.The original DBF data was reported as years while the XBRL data was reported as strings in this time duration format: PnYnMnDTnHnMnS. PUDL converts these string time durations into years.

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.

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.

Functional role played by utility plant (steam production, nuclear production, distribution, transmission, etc.).

Long FERC account identifier derived from values reported in the XBRL taxonomies. May also refer to aggregations of individual FERC accounts.

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.

Dollar value of reported income, expense, asset, or liability.

Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility.

Indicates whether the value reported in the row is calculated, or uniquely reported within the table.

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.

Four-digit year in which the data was reported.

Type of energy disposition reported in the core_ferc1__yearly_energy_dispositions_sched401. Dispositions include sales to customers, re-sales of energy, energy used internally, losses, etc.

Indicates whether the value reported in the row is calculated, or uniquely reported within the table.

Sources and uses of energy in MWh.

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.