core_eia860__scd_emissions_control_equipment
Return to SearchSlowly changing dimension (SCD) table describing attributes of emissions control equipment reported to EIA, including cost, type, operating status, retirement date, and install year.
- Most-recent data:
2024
- 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:
report_date, plant_id_eia, emission_control_id_pudl
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.
Additional Details
Includes control ids for sulfur dioxide (SO2), particulate matter, mercury, nitrogen oxide (NOX), and acid (HCl) gas monitoring.
This table inherits canonicalized values for plants and utilities. 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.
Columns
Date reported.
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration.
A PUDL-generated ID used to distinguish emission control units in the same report year and plant id. This ID should not be used to track units over time or between plants.
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.
Short code indicating the type of emission control equipment installed.
The operating status of the asset.
Mercury control identification number. This ID is not a unique identifier.
Nitrogen oxide control identification number. This ID is not a unique identifier.
Particulate matter control identification number. This ID is not a unique identifier.
Sulfur dioxide control identification number. This ID is not a unique identifier.
Indicates whether the emissions control equipment controls acid (HCl) gas.
The total cost to install a piece of emission control equipment.
The date a piece of emissions control equipment began operating. Derived from month and year columns in the raw data.
The expected or actual retirement date for a piece of emissions control equipment. Derived from month and year columns in the raw data.