out_eia923__monthly_fuel_receipts_costs

package: pudl

Monthly time series of fuel deliveries to power plants aggregated by plant, fuel type, and time period.

Most-recent data:

2025

Processing:

Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.

Source:

EIA Form 923 -- Power Plant Operations Report (Schedule 2 - Part A)

Primary key:

plant_id_eia, fuel_type_code_pudl, report_date

Usage Warnings

  • Date column arbitrarily uses the first of the month.

  • Contains estimated values.

  • Some values have been redacted.

  • Time of fuel deliveries is not necessarily connected with time of fuel consumption.

  • 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

This table is an aggregation of the more detailed data in the core_eia923__fuel_receipts_costs table. It provides a tidy timeseries of deliveries by fuel type for each plant. However, not all values in the original table can be aggregated meaningfully, so this table contains only a subset of the source table columns -- primarily numerical values and a handful of categorical variables, plus additional attributes that are constant within each plant-fuel-time period grouping and associated with the plant or utility. When aggregating numerical values any sum that contains an NA value is treated as NA.

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
report_date

Date reported.

plant_id_eia

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

plant_id_pudl

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

plant_name_eia

Plant name.

utility_id_eia

The EIA Utility Identification number.

utility_id_pudl

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

utility_name_eia

The name of the utility.

state

Two letter US state abbreviation.

fuel_type_code_pudl

Simplified fuel type code used in PUDL

fuel_received_units

Quantity of fuel received in tons, barrel, or Mcf.

fuel_mmbtu_per_unit

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

fuel_cost_per_mmbtu

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

fuel_received_mmbtu

Aggregated fuel receipts, in MMBTU, in EIA bulk electricity data.

total_fuel_cost

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

fuel_cost_per_mmbtu_source

Indicates the source of the values in the fuel_cost_per_mmbtu column. The fuel cost either comes directly from the EIA forms (original), was filled in from the EIA's API using state-level averages (eiaapi), was filled in using a rolling average (rolling_avg) or When the records get aggregated together and contain multiple sources (mixed).

sulfur_content_pct

Sulfur content percentage by weight to the nearest 0.01 percent.

ash_content_pct

Ash content percentage by weight to the nearest 0.1 percent.

mercury_content_ppm

Mercury content in parts per million (ppm) to the nearest 0.001 ppm.

moisture_content_pct

For coal only: the moisture content of the fuel in terms of moisture percentage by weight. Reported to the nearest 0.01 percent.

chlorine_content_ppm

For coal only: the chlorine content in parts per million (ppm) to the nearest 0.001 ppm. If lab tests of the coal do not include the chlorine content, this field contains the amount specified in the contract with the supplier.

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.