PUDL Code Metadata

The following tables map from codes used in raw data to labels used in the PUDL database. Also included is a table of non-standard codes that are mapped to canonical, standardized codes.

coalmine_types_eia

A coding table describing different types of coalmines reported as fuel sources in the EIA-923.

Code Mappings

code	label	description
P	preparation_plant	A coal preparation plant.
S	surface	A surface mine.
U	underground	An underground mine.
US	underground_and_surface	Both an underground and surface mine with most coal extracted from underground
SU	surface_and_underground	Both an underground and surface mine with most coal extracted from surface

Fixed Codes

Non Standard Code	Standard Code
p	P
U/S	US
S/U	SU
Su	S

contract_types_eia

A coding table describing the various types of fuel supply contracts reported in EIA-923.

Code Mappings

code	label	description
C	contract	Fuel received under a purchase order or contract with a term of one year or longer. Contracts with a shorter term are considered spot purchases
NC	new_contract	Fuel received under a purchase order or contract with duration of one year or longer, under which deliveries were first made during the reporting month
S	spot_purchase	Fuel obtained through a spot market purchase
T	tolling_agreement	Fuel received under a tolling agreement (bartering arrangement of fuel for generation)

Fixed Codes

Non Standard Code	Standard Code
N	NC

energy_sources_eia

Codes and metadata pertaining to energy sources reported to EIA. Compiled from EIA-860 instructions and EIA-923 file layout spreadsheets.

Code Mappings

code	label	fuel_units	min_fuel_mmbtu_per_unit	max_fuel_mmbtu_per_unit	fuel_group_eia	fuel_derived_from	fuel_phase	fuel_type_code_pudl	description
AB	agricultural_byproducts	short_tons	7.0	18.0	renewable	biomass	solid	waste	Agricultural by-products
ANT	anthracite	short_tons	22.0	28.0	fossil	coal	solid	coal	Anthracite coal
BFG	blast_furnace_gas	mcf	0.07	0.12	fossil	gas	gas	gas	Blast furnace gas
BIT	bituminous_coal	short_tons	20.0	29.0	fossil	coal	solid	coal	Bituminous coal
BLQ	black_liquor	short_tons	10.0	14.0	renewable	biomass	liquid	waste	Black liquor
DFO	distillate_fuel_oil	barrels	5.5	6.2	fossil	petroleum	liquid	oil	Distillate fuel oil, including diesel, No. 1, No. 2, and No. 4 fuel oils
GEO	geothermal				renewable	other		other	Geothermal
JF	jet_fuel	barrels	5.0	6.0	fossil	petroleum	liquid	oil	Jet fuel
KER	kerosene	barrels	5.6	6.1	fossil	petroleum	liquid	oil	Kerosene
LFG	landfill_gas	mcf	0.3	0.6	renewable	biomass	gas	waste	Landfill gas
LIG	lignite	short_tons	10.0	14.5	fossil	coal	solid	coal	Lignite coal
MSB	municipal_solid_waste_biogenic	short_tons	9.0	12.0	renewable	biomass	solid	waste	Municipal solid waste (biogenic)
MSN	municipal_solid_nonbiogenic	short_tons	9.0	12.0	fossil	petroleum	solid	waste	Municipal solid waste (non-biogenic)
MSW	municipal_solid_waste	short_tons	9.0	12.0	renewable	biomass	solid	waste	Municipal solid waste (all types)
MWH	electricity_storage	mwh			other	other		other	Electricity used for electricity storage
NG	natural_gas	mcf	0.8	1.1	fossil	gas	gas	gas	Natural gas
NUC	nuclear				other	other		nuclear	Nuclear, including uranium, plutonium, and thorium
OBG	other_biomass_gas	mcf	0.36	1.6	renewable	biomass	gas	waste	Other biomass gas, including digester gas, methane, and other biomass gasses
OBL	other_biomass_liquid	barrels	3.5	4.0	renewable	biomass	liquid	waste	Other biomass liquids
OBS	other_biomass_solid	short_tons	8.0	25.0	renewable	biomass	solid	waste	Other biomass solids
OG	other_gas	mcf	0.32	3.3	fossil	other	gas	gas	Other gas
OTH	other				other	other		other	Other
PC	petroleum_coke	short_tons	24.0	30.0	fossil	petroleum	solid	coal	Petroleum coke
PG	propane_gas	mcf	2.5	2.75	fossil	petroleum	gas	gas	Gaseous propane
PUR	purchased_steam				other	other		other	Purchased steam
RC	refined_coal	short_tons	20.0	29.0	fossil	coal	solid	coal	Refined coal
RFO	residual_fuel_oil	barrels	5.7	6.9	fossil	petroleum	liquid	oil	Residual fuel oil, including Nos. 5 & 6 fuel oils and bunker C fuel oil
SC	coal_synfuel	short_tons			fossil	coal	solid	coal	Coal synfuel. Coal-based solid fuel that has been processed by a coal synfuel plant, and coal-based fuels such as briquettes, pellets, or extrusions, which are formed from fresh or recycled coal and binding materials.
SG	syngas_other	mcf			fossil	other	gas	gas	Synthetic gas, other than coal-derived
SGC	syngas_coal	mcf	0.2	0.3	fossil	coal	gas	gas	Coal-derived synthesis gas
SGP	syngas_petroleum_coke	mcf	0.2	1.1	fossil	petroleum	gas	gas	Synthesis gas from petroleum coke
SLW	sludge_waste	short_tons	10.0	16.0	renewable	biomass	liquid	waste	Sludge waste
SUB	subbituminous_coal	short_tons	15.0	20.0	fossil	coal	solid	coal	Sub-bituminous coal
SUN	solar				renewable	other		solar	Solar
TDF	tire_derived_fuels	short_tons	16.0	32.0	other	other	solid	waste	Tire-derived fuels
WAT	water				renewable	other		hydro	Water at a conventional hydroelectric turbine, and water used in wave buoy hydrokinetic technology, current hydrokinetic technology, and tidal hydrokinetic technology, or pumping energy for reversible (pumped storage) hydroelectric turbine
WC	waste_coal	short_tons	6.5	16.0	fossil	coal	solid	coal	Waste/Other coal, including anthracite culm, bituminous gob, fine coal, lignite waste, waste coal.
WDL	wood_liquids	barrels	8.0	14.0	renewable	biomass	liquid	waste	Wood waste liquids excluding black liquor, including red liquor, sludge wood, spent sulfite liquor, and other wood-based liquids
WDS	wood_solids	short_tons	7.0	18.0	renewable	biomass	solid	waste	Wood/Wood waste solids, including paper pellets, railroad ties, utility poles, wood chips, park, and wood waste solids
WH	waste_heat				other	other		other	Waste heat not directly attributed to a fuel source. WH should only be reported when the fuel source is undetermined, and for combined cycle steam turbines that do not have supplemental firing.
WND	wind				renewable	other		wind	Wind
WO	waste_oil	barrels	3.0	5.8	fossil	petroleum	liquid	oil	Waste/Other oil, including crude oil, liquid butane, liquid propane, naptha, oil waste, re-refined motor oil, sludge oil, tar oil, or other petroleum-based liquid wastes

Fixed Codes

Non Standard Code	Standard Code
BL	BLQ
HPS	WAT
ng	NG
WOC	WC
OW	WO
WT	WND
H2	OG
OOG	OG

entity_types_eia

Descriptive labels for EIA entity type and ownership codes, taken from the EIA-861 form instructions, valid through 2023-05-31.

Code Mappings

code	label	description
A	municipal_marketing_authority	Municipal Marketing Authority. Voted into existence by the residents of a municipality and given authority for creation by the state government. They are nonprofit organizations
B	behind_the_meter	Behind the Meter. Entities that install, own, and/or operate a system (usually photovoltaic), and sell, under a long term power purchase agreement (PPA) or lease, all the production from the system to the homeowner or business with which there is a net metering agreement. Third Party Owners (TPOs) of PV solar installations use this ownership code.
C	cooperative	Cooperative. Member-owned organizations.
COM	commercial	Commercial facility.
D	nonutility_dsm_administrator	Non-utility DSM Administrator. Only involved with Demand-Side Management activities.
F	federal	Federal. Government agencies with the authority to deliver energy to end-use customers.
G	community_choice_aggregator	Community Choice Aggregator.
I	investor_owned	Investor-owned Utilities. Entities that are privately owned and provide a public service.
IND	industrial	Industrial facility.
M	municipal	Municipal: Entities that are organized under authority of state statute to provide a public service to residents of that area.
O	other	Other entity type.
P	political_subdivision	Political Subdivision. (also called “public utility district”): Independent of city or county government and voted into existence by a majority of the residents of any given area for the specific purpose of providing utility service to the voters. State laws provide for the formation of such districts.
PO	power_marketer	Power marketer.
PR	private	Private entity.
Q	independent_power_producer	Independent Power Producer or Qualifying Facility. Entities that own power plants and sell their power into the wholesale market.
R	retail_power_marketer	Retail Power Marketer or Energy Service Provider: Entities that market power to customers in restructured markets.
S	state	State entities that own or operate facilities or provide a public service.
T	transmission	Transmission: Entities that operate or own high voltage transmission wires that provide bulk power services.
U	unknown	Unknown entity type.
W	wholesale_power_marketer	Wholesale Power Marketer: Entities that buy and sell power in the wholesale market.

Fixed Codes

Non Standard Code	Standard Code
Behind the Meter	B
Community Choice Aggregator	G
Cooperative	C
Facility	Q
Federal	F
Investor Owned	I
Municipal	M
Political Subdivision	P
Power Marketer	PO
Retail Power Marketer	R
State	S
Unregulated	Q
Wholesale Power Marketer	W

fuel_transportation_modes_eia

Long descriptions of the fuel transportation modes reported in the EIA-860 and EIA-923.

Code Mappings

code	label	description
GL	great_lakes	Shipments of coal moved to consumers via the Great Lakes. These shipments are moved via the Great Lakes coal loading docks.
OP	onsite_production	Fuel is produced on-site, making fuel shipment unnecessary.
RR	rail	Shipments of fuel moved to consumers by rail (private or public/commercial). Included is coal hauled to or away from a railroad siding by truck if the truck did not use public roads.
RV	river	Shipments of fuel moved to consumers via river by barge. Not included are shipments to Great Lakes coal loading docks, tidewater piers, or coastal ports.
PL	pipeline	Shipments of fuel moved to consumers by pipeline
SP	slurry_pipeline	Shipments of coal moved to consumers by slurry pipeline.
TC	tramway_conveyor	Shipments of fuel moved to consumers by tramway or conveyor.
TP	tidewater_port	Shipments of coal moved to Tidewater Piers and Coastal Ports for further shipments to consumers via coastal water or ocean.
TR	truck	Shipments of fuel moved to consumers by truck. Not included is fuel hauled to or away from a railroad siding by truck on non-public roads.
WT	other_waterway	Shipments of fuel moved to consumers by other waterways.

Fixed Codes

Non Standard Code	Standard Code
TK	TR
tk	TR
tr	TR
WA	WT
wa	WT
CV	TC
cv	TC
rr	RR
pl	PL
rv	RV

fuel_types_aer_eia

Descriptive labels for aggregated fuel types used in the Annual Energy Review. See EIA-923 Fuel Code table for additional information.

Code Mappings

code	description
SUN	Solar PV and thermal
COL	Coal
DFO	Distillate Petroleum
GEO	Geothermal
HPS	Hydroelectric Pumped Storage
HYC	Hydroelectric Conventional
MLG	Biogenic Municipal Solid Waste and Landfill Gas
NG	Natural Gas
NUC	Nuclear
OOG	Other Gases
ORW	Other Renewables
OTH	Other (including Nonbiogenic Municipal Solid Waste)
PC	Petroleum Coke
RFO	Residual Petroleum
WND	Wind
WOC	Waste Coal
WOO	Waste Oil
WWW	Wood and Wood Waste

momentary_interruptions_eia

A coding table for utility definitions of momentary service interruptions.

Code Mappings

code	label	description
L	less_than_1_minute	Respondent defines a momentary interruption as less than 1 minute.
F	less_than_5_minutes	Respondent defines a momentary interruption as less than 5 minutes.
O	other	Respondent defines a momentary interruption using some other criteria.

power_purchase_types_ferc1

Coding table defining different types of electricity power purchases.

Code Mappings

code	label	description
AD	adjustment	Out-of-period adjustment. Use this code for any accounting adjustments or “true-ups” for service provided in prior reporting years. Provide an explanation in a footnote for each adjustment.
EX	electricity_exchange	Exchanges of electricity. Use this category for transactions involving a balancing of debits and credits for energy, capacity, etc. and any settlements for imbalanced exchanges.
IF	intermediate_firm	Intermediate-term firm service. The same as LF service expect that “intermediate-term” means longer than one year but less than five years.
IU	intermediate_unit	Intermediate-term service from a designated generating unit. The same as LU service expect that “intermediate-term” means longer than one year but less than five years.
LF	long_firm	Long-term firm service. “Long-term” means five years or longer and “firm” means that service cannot be interrupted for economic reasons and is intended to remain reliable even under adverse conditions (e.g., the supplier must attempt to buy emergency energy from third parties to maintain deliveries of LF service). This category should not be used for long-term firm service firm service which meets the definition of RQ service. For all transaction identified as LF, provide in a footnote the termination date of the contract defined as the earliest date that either buyer or seller can unilaterally get out of the contract.
LU	long_unit	Long-term service from a designated generating unit. “Long-term” means five years or longer. The availability and reliability of service, aside from transmission constraints, must match the availability and reliability of the designated unit.
OS	other_service	Other service. Use this category only for those services which cannot be placed in the above-defined categories, such as all non-firm service regardless of the Length of the contract and service from designated units of Less than one year. Describe the nature of the service in a footnote for each adjustment.
RQ	requirement	Requirements service. Requirements service is service which the supplier plans to provide on an ongoing basis (i.e., the supplier includes projects load for this service in its system resource planning). In addition, the reliability of requirement service must be the same as, or second only to, the supplier’s service to its own ultimate consumers.
SF	short_firm	Short-term service. Use this category for all firm services, where the duration of each period of commitment for service is one year or less.

prime_movers_eia

Long descriptions explaining the short prime mover codes reported in the EIA-860 and EIA-923.

Code Mappings

code	label	description
BA	battery_storage	Energy Storage, Battery
BT	binary_cycle_turbine	Turbines Used in a Binary Cycle. Including those used for geothermal applications
CA	combined_cycle_steam_turbine	Combined-Cycle, Steam Turbine Part
CC	combined_cycle_total	Combined-Cycle, Total Unit
CE	compressed_air_storage	Energy Storage, Compressed Air
CP	concentrated_solar_storage	Energy Storage, Concentrated Solar Power
CS	combined_cycle_single_shaft	Combined-Cycle Single-Shaft Combustion Turbine and Steam Turbine share of single
CT	combined_cycle_combustion_turbine	Combined-Cycle Combustion Turbine Part
ES	other_storage	Energy Storage, Other (Specify on Schedule 9, Comments)
FC	fuel_cell	Fuel Cell
FW	flywheel_storage	Energy Storage, Flywheel
GT	gas_combustion_turbine	Combustion (Gas) Turbine. Including Jet Engine design
HA	hydrokinetic_axial_flow	Hydrokinetic, Axial Flow Turbine
HB	hydrokinetic_wave_buoy	Hydrokinetic, Wave Buoy
HK	hydrokinetic_other	Hydrokinetic, Other
HY	hydraulic_turbine	Hydraulic Turbine. Including turbines associated with delivery of water by pipeline.
IC	internal_combustion	Internal Combustion (diesel, piston, reciprocating) Engine
OT	other	Other
PS	pumped_storage	Energy Storage, Reversible Hydraulic Turbine (Pumped Storage)
PV	solar_pv	Solar Photovoltaic
ST	steam_turbine	Steam Turbine. Including Nuclear, Geothermal, and Solar Steam (does not include Combined Cycle).
UNK	unknown	Unknown prime mover.
WS	wind_offshore	Wind Turbine, Offshore
WT	wind_onshore	Wind Turbine, Onshore

sector_consolidated_eia

Long descriptions for the EIA consolidated NAICS sector codes. Codes and descriptions taken from the EIA-923 File Layout spreadsheet.

Code Mappings

code	label	description
1	electric_utility	Traditional regulated electric utilities.
2	ipp_non_cogen	Independent power producers which are not cogenerators.
3	ipp_cogen	Independent power producers which are cogenerators, but whose primary business purpose is the same of electricity to the public.
4	commercial_non_cogen	Commercial non-cogeneration facilities that produce electric power, are connected to the grid, and can sell power to the public.
5	commercial_cogen	Commercial cogeneration facilities that produce electric power, are connected to the grid, and can sell power to the public.
6	industrial_non_cogen	Industrial non-cogeneration facilities that produce electric power, are connected to the grid, and can sell power to the public.
7	industrial_cogen	Industrial cogeneration facilities that produce electric power, are connected to the grid, and can sell power to the public