core_eia923__entity_coalmine
Return to SearchEntity table containing static information about coal mines reporting deliveries in the Fuel Receipts and Costs table.
- 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 923 -- Power Plant Operations Report (Schedule 2, Part C)
- Primary key:
mine_id_pudl
Usage Warnings
Mine ID's are not as well defined and consistent as other EIA ID's.
Additional Details
This table is produced during the transformation of fuel delivery data, in order to produce a better normalized database. The same coalmines report many individual deliveries, and repeating their attributes many times in the fuel receipts and costs table is duplicative. Unfortunately the coalmine attributes do not generally use a controlled vocabulary or well defined IDs and so in practice there are many distinct records in this table that correspond to the same mines in reality.
We have not yet taken the time to rigorously clean this data, but it could be linked with both Mining Safety and Health Administration (MSHA) and USGS data to provide more insight into where coal is coming from, and what the employment and geological context is for those supplies.
Columns
Dynamically assigned PUDL mine identifier.
Coal mine name.
Type of coal mine.
Two letter US state abbreviation.
County ID from the Federal Information Processing Standard Publication 6-4.
MSHA issued mine identifier.
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.