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.

operational_status_eia#

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

Code Mappings#

code

label

description

operational_status

CN

cancelled

Cancelled, but previously reported as ‘planned’

proposed

IP

indefinitely_postponed

Planned new indefinitely postponed, or no longer in resource plan

proposed

L

planned_approvals_pending

Not under construction but site preparation could be underway

proposed

OA

out_of_service_short_term

Was not used for some or all of the reporting period but is expected to be returned to service in the next calendar year.

existing

OP

operating

In service (commercial operation) and producing some electricity. Includes peaking units that are run on an as needed (intermittent or seasonal) basis.

existing

OS

out_of_service_long_term

Was not used for some or all of the reporting period and is NOT expected to be returned to service in the next calendar year.

existing

OT

other

proposed

proposed

P

planned_approvals_not_initiated

Planned for installation but regulatory approvals not initiated; Not under construction

proposed

RE

retired

No longer in service and not expected to be returned to service.

retired

SB

standby

Standby/Backup. Available for service but not normally used (has little or no generation during the year) for this reporting period. Includes old code BU from 2004-2006.

existing

T

planned_approvals_received

Regulatory approvals received. Not under construction but site preparation could be underway

proposed

TS

construction_complete

Construction complete, but not yet in commercial operation (including low power testing of nuclear units)

proposed

U

under_construction_less_than_half_complete

Under construction, less than or equal to 50 percent complete (based on construction time to date of operation)

proposed

V

under_construction_more_than_half_complete

Under construction, more than 50 percent complete (based on construction time to date of operation)

proposed

Fixed Codes#

Non Standard Code

Standard Code

  1. Regulatory approvals pending. Not under construction

L

(OA) Out of service but expected to return to service in next calendar year

OA

(OP) Operating

OP

(OS) Out of service and NOT expected to return to service in next calendar year

OS

(OT) Other

OT

  1. Planned for installation, but regulatory approvals not initiated

P

(SB) Standby/Backup: available for service but not normally used

SB

  1. Regulatory approvals received. Not under construction

T

(TS) Construction complete, but not yet in commercial operation

TS

  1. Under construction, less than or equal to 50 percent complete

U

  1. Under construction, more than 50 percent complete

V

BU

SB

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

Fixed Codes#

Non Standard Code

Standard Code

ic

IC

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