pudl.models.eia923 module

Database models for PUDL tables derived from EIA Form 923 Data.

class pudl.models.eia923.BoilerFuelEIA923(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

Monthly fuel consumption by boiler reported on Page 3 of EIA 923.

ash_content_pct

boiler_id

fuel_consumed_units

fuel_mmbtu_per_unit

fuel_type_code

fuel_type_code_pudl

id

plant_id_eia

report_date

sulfur_content_pct

class pudl.models.eia923.CoalMineEIA923(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

Information pertaining to individual coal mines listed in EIA 923.

county_id_fips

mine_id_msha

mine_id_pudl

mine_name

mine_type_code

state

class pudl.models.eia923.EnergySourceEIA923(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

Fuel code associated with fuel receipts in EIA Form 923.

abbr

source

class pudl.models.eia923.FuelReceiptsCostsEIA923(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

Fuel receipts & costs by plant &purchase from Page 5 of EIA Form 923.

ash_content_pct

chlorine_content_ppm

contract_expiration_date

contract_type_code

energy_source_code

fuel_cost_per_mmbtu

fuel_group_code

fuel_group_code_simple

fuel_qty_units

fuel_type_code_pudl

heat_content_mmbtu_per_unit

id

mercury_content_ppm

mine_id_pudl

moisture_content_pct

natural_gas_delivery_contract_type_code

natural_gas_transport_code

plant_id_eia

primary_transportation_mode_code

report_date

secondary_transportation_mode_code

sulfur_content_pct

supplier_name

class pudl.models.eia923.FuelTypeAER(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

Static list of fuel types using AER codes, reported in EIA Form 923.

abbr

fuel_type

class pudl.models.eia923.FuelTypeEIA923(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

Static list of fuel types used by EIA in Form 923.

Enumerated on Page 7 of EIA Form 923.

abbr

fuel_type

fuel_unit

class pudl.models.eia923.GenerationEIA923(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

Monthly electricity generation by generator from EIA923 Page 4.

generator_id

id

net_generation_mwh

plant_id_eia

report_date

class pudl.models.eia923.GenerationFuelEIA923(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

Monthly fuel consumption and electricity generation by plant.

Reported on Page 1 of EIA Form 923.

fuel_consumed_for_electricity_mmbtu

fuel_consumed_for_electricity_units

fuel_consumed_mmbtu

fuel_consumed_units

fuel_mmbtu_per_unit

fuel_type

fuel_type_code_aer

fuel_type_code_pudl

id

net_generation_mwh

nuclear_unit_id

plant_id_eia

prime_mover_code

report_date

class pudl.models.eia923.NaturalGasTransportEIA923(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

Contract type for natural gas capacity service.

abbr

status

class pudl.models.eia923.PrimeMoverEIA923(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

Static list of prime movers used by EIA in Form 923.

abbr

prime_mover

class pudl.models.eia923.TransportModeEIA923(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

Mode used for longest & 2nd longest distance in EIA Form 923.

abbr

mode