core_eia860__scd_boilers

package: pudl

Slowly changing dimension (SCD) table describing attributes of boilers which may vary from year to year. Compiled from across all EIA-860 data.

Most-recent data:

2025

Processing:

Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.

Source:

EIA Form 860 -- Annual Electric Generator Report

Primary key:

plant_id_eia, boiler_id, report_date

Usage Warnings

  • Data has been drawn from several EIA sources which are not always consistent with each other, and PUDL chooses the most consistent or relevant value to facilitate cross-referencing even if that means some values will differ from the raw sources. See Harvesting for details, and see Entity Resolution Methodology for a fuller conceptual overview.

  • Contains information from multiple raw inputs.

Additional Details

This is one of two tables where canonical values for boilers are set. It contains values which are expected to vary slowly, while core_eia__entity_boilers contains those expected to remain fixed. EIA reports many attributes in many different tables across EIA-860 and EIA-923. 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. If an attribute was reported inconsistently across the original EIA tables, then it will show up as a null value. See /methodology/entity_resolution for a conceptual overview of this process. All tables downstream of this one inherit the canonical values established here.

Columns
plant_id_eia

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

boiler_id

Alphanumeric boiler ID.

report_date

Date reported.

boiler_operating_date

Date the boiler began or is planned to begin commercial operation.

boiler_status

EIA short code identifying boiler operational status.

boiler_retirement_date

Date of the scheduled or effected retirement of the boiler.

boiler_type

EIA short code indicating the standards under which the boiler is operating as described in the U.S. EPA regulation under 40 CFR.

firing_type_1

EIA short code indicating the type of firing used by this boiler.

firing_type_2

EIA short code indicating the type of firing used by this boiler.

firing_type_3

EIA short code indicating the type of firing used by this boiler.

firing_rate_using_coal_tons_per_hour

Design firing rate at maximum continuous steam flow for coal to the nearest 0.1 ton per hour.

firing_rate_using_oil_bbls_per_hour

Design firing rate at maximum continuous steam flow for pet coke to the nearest 0.1 barrels per hour.

firing_rate_using_gas_mcf_per_hour

Design firing rate at maximum continuous steam flow for gas to the nearest 0.1 cubic feet per hour.

firing_rate_using_other_fuels

Design firing rate at maximum continuous steam flow for energy sources other than coal, petroleum, or natural gas.

boiler_fuel_code_1

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

boiler_fuel_code_2

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

boiler_fuel_code_3

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

boiler_fuel_code_4

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

waste_heat_input_mmbtu_per_hour

Design waste-heat input rate at maximum continuous steam flow where a waste-heat boiler is a boiler that receives all or a substantial portion of its energy input from the noncumbustible exhaust gases of a separate fuel-burning process (MMBTU per hour).

wet_dry_bottom

Wet or Dry Bottom where Wet Bottom is defined as slag tanks that are installed at furnace throat to contain and remove molten ash from the furnace, and Dry Bottom is defined as having no slag tanks at furnace throat area, throat area is clear, and bottom ash drops through throat to bottom ash water hoppers.

fly_ash_reinjection

Indicates whether the boiler is capable of re-injecting fly ash.

hrsg

indicates if the boiler is a heat recovery steam generator (HRSG).

max_steam_flow_lbs_per_hour

Maximum continuous steam flow at 100 percent load.

turndown_ratio

The turndown ratio for the boiler.

efficiency_100pct_load

Boiler efficiency percentage when burning at 100 percent load to the nearest 0.1 percent.

efficiency_50pct_load

Boiler efficiency percentage when burning at 50 percent load to the nearest 0.1 percent.

air_flow_100pct_load_cubic_feet_per_minute

Total air flow including excess air at 100 percent load, reported at standard temperature and pressure (i.e. 68 F and one atmosphere pressure).

new_source_review

Indicates whether the boiler is subject to New Source Review requirements.

new_source_review_date

Month of issued New Source Review permit.

new_source_review_permit

New Source Review permit number.

regulation_particulate

EIA short code for most stringent type of statute or regulation code under which the boiler is operating for particulate matter control standards.

regulation_so2

EIA short code for most stringent type of statute or regulation code under which the boiler is operating for sulfur dioxide control standards.

regulation_nox

EIA short code for most stringent type of statute or regulation code under which the boiler is operating for nitrogen oxide control standards.

standard_particulate_rate

Numeric value for the unit of measurement specified for particulate matter.

standard_so2_rate

Numeric value for the unit of measurement specified for sulfur dioxide.

standard_nox_rate

Numeric value for the unit of measurement specified for nitrogen oxide.

unit_particulate

Numeric value for the unit of measurement specified for particulate matter.

unit_so2

Numeric value for the unit of measurement specified for sulfur dioxide.

unit_nox

Numeric value for the unit of measurement specified for nitrogen oxide.

compliance_year_particulate

Year boiler was or is expected to be in compliance with federal, state and/or local regulations for particulate matter emissions.

compliance_year_nox

Year boiler was or is expected to be in compliance with federal, state and/or local regulations for nitrogen oxide emissions.

compliance_year_so2

Year boiler was or is expected to be in compliance with federal, state and/or local regulations for sulfur dioxide emissions.

particulate_control_out_of_compliance_strategy_1

If boiler is not in compliance with particulate matter regulations, strategy for compliance.

particulate_control_out_of_compliance_strategy_2

If boiler is not in compliance with particulate matter regulations, strategy for compliance.

particulate_control_out_of_compliance_strategy_3

If boiler is not in compliance with particulate matter regulations, strategy for compliance.

so2_control_out_of_compliance_strategy_1

If boiler is not in compliance with sulfur dioxide regulations, strategy for compliance.

so2_control_out_of_compliance_strategy_2

If boiler is not in compliance with sulfur dioxide regulations, strategy for compliance.

so2_control_out_of_compliance_strategy_3

If boiler is not in compliance with sulfur dioxide regulations, strategy for compliance.

so2_control_existing_caaa_compliance_strategy_1

Existing strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990.

so2_control_existing_caaa_compliance_strategy_2

Existing strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990.

so2_control_existing_caaa_compliance_strategy_3

Existing strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990.

so2_control_planned_caaa_compliance_strategy_1

Planned strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990.

so2_control_planned_caaa_compliance_strategy_2

Planned strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990.

so2_control_planned_caaa_compliance_strategy_3

Planned strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990.

nox_control_out_of_compliance_strategy_1

If boiler is not in compliance with nitrogen oxide regulations, strategy for compliance.

nox_control_out_of_compliance_strategy_2

If boiler is not in compliance with nitrogen oxide regulations, strategy for compliance.

nox_control_out_of_compliance_strategy_3

If boiler is not in compliance with nitrogen oxide regulations, strategy for compliance.

nox_control_existing_caaa_compliance_strategy_1

Existing strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990.

nox_control_existing_caaa_compliance_strategy_2

Existing strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990.

nox_control_existing_caaa_compliance_strategy_3

Existing strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990.

nox_control_planned_caaa_compliance_strategy_1

Planned strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990.

nox_control_planned_caaa_compliance_strategy_2

Planned strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990.

nox_control_planned_caaa_compliance_strategy_3

Planned strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990.

compliance_year_mercury

Year boiler was or is expected to be in compliance with federal, state and/or local regulations for mercury emissions.

mercury_control_existing_strategy_1

Existing strategy to comply with the most stringent mercury regulation.

mercury_control_existing_strategy_2

Existing strategy to comply with the most stringent mercury regulation.

mercury_control_existing_strategy_3

Existing strategy to comply with the most stringent mercury regulation.

mercury_control_existing_strategy_4

Existing strategy to comply with the most stringent mercury regulation.

mercury_control_existing_strategy_5

Existing strategy to comply with the most stringent mercury regulation.

mercury_control_existing_strategy_6

Existing strategy to comply with the most stringent mercury regulation.

mercury_control_proposed_strategy_1

Proposed strategy to comply with the most stringent mercury regulation.

mercury_control_proposed_strategy_2

Proposed strategy to comply with the most stringent mercury regulation.

mercury_control_proposed_strategy_3

Proposed strategy to comply with the most stringent mercury regulation.

nox_control_existing_strategy_1

Existing strategy to comply with the most stringent nitrogen oxide regulation.

nox_control_existing_strategy_2

Existing strategy to comply with the most stringent nitrogen oxide regulation.

nox_control_existing_strategy_3

Existing strategy to comply with the most stringent nitrogen oxide regulation.

nox_control_manufacturer

Name of nitrogen oxide control manufacturer.

nox_control_manufacturer_code

Code indicating the nitrogen oxide control burner manufacturer.

nox_control_proposed_strategy_1

Proposed strategy to comply with the most stringent nitrogen oxide regulation.

nox_control_proposed_strategy_2

Proposed strategy to comply with the most stringent nitrogen oxide regulation.

nox_control_proposed_strategy_3

Proposed strategy to comply with the most stringent nitrogen oxide regulation.

nox_control_status_code

Nitrogen oxide control status code.

regulation_mercury

Most stringent type of statute or regulation code under which the boiler is operating for mercury control standards.

so2_control_existing_strategy_1

Existing strategy to comply with the most stringent sulfur dioxide regulation.

so2_control_existing_strategy_2

Existing strategy to comply with the most stringent sulfur dioxide regulation.

so2_control_existing_strategy_3

Existing strategy to comply with the most stringent sulfur dioxide regulation.

so2_control_proposed_strategy_1

Proposed strategy to comply with the most stringent sulfur dioxide regulation.

so2_control_proposed_strategy_2

Proposed strategy to comply with the most stringent sulfur dioxide regulation.

so2_control_proposed_strategy_3

Proposed strategy to comply with the most stringent sulfur dioxide regulation.

standard_so2_percent_scrubbed

The percent of sulfur dioxide to be scrubbed specified by the most stringent sulfur dioxide regulation.

data_maturity

Maturity of the source data published by EIA that is reflected in this record. EIA releases data incrementally over time, including monthly updates, annual year-to-date updates, provisional early releases of annual data, and final annual release data that is not expected to change further. Records sourced from multiple upstream EIA datasets may have no well defined data maturity. Records whose values have been inferred within PUDL will also have no data maturity.