pudl.models.eia860 module¶

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

class pudl.models.eia860.BoilerGeneratorAssociationEIA860(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

EIA boiler generator associations.

Compiled from 860 and 923.

bga_source¶

boiler_id¶

generator_id¶

id¶

plant_id_eia¶

report_date¶

unit_id_eia¶

unit_id_pudl¶

class pudl.models.eia860.GeneratorEIA860(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

EIA generators per year, listed in 923 or 860.

A compilation of EIA generators ids and yearly info.

capacity_mw¶

carbon_capture¶

cofire_fuels¶

current_planned_operating_date¶

deliver_power_transgrid¶

energy_source_code_1¶

energy_source_code_2¶

energy_source_code_3¶

energy_source_code_4¶

energy_source_code_5¶

energy_source_code_6¶

fuel_type_code_pudl¶

generator_id¶

id¶

minimum_load_mw¶

multiple_fuels¶

nameplate_power_factor¶

operating_switch¶

operational_status¶

operational_status_code¶

other_modifications_date¶

other_planned_modifications¶

ownership_code¶

planned_derate_date¶

planned_energy_source_code_1¶

planned_modifications¶

planned_net_summer_capacity_derate_mw¶

planned_net_summer_capacity_uprate_mw¶

planned_net_winter_capacity_derate_mw¶

planned_net_winter_capacity_uprate_mw¶

planned_new_capacity_mw¶

planned_new_prime_mover_code¶

planned_repower_date¶

planned_retirement_date¶

planned_uprate_date¶

plant_id_eia¶

report_date¶

retirement_date¶

startup_source_code_1¶

startup_source_code_2¶

startup_source_code_3¶

startup_source_code_4¶

summer_capacity_mw¶

summer_estimated_capability_mw¶

switch_oil_gas¶

syncronized_transmission_grid¶

technology_description¶

time_cold_shutdown_full_load_code¶

turbines_inverters_hydrokinetics¶

turbines_num¶

uprate_derate_completed_date¶

uprate_derate_during_year¶

winter_capacity_mw¶

winter_estimated_capability_mw¶

class pudl.models.eia860.OwnershipEIA860(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

The schedule of generator ownership shares from EIA860.

fraction_owned¶

generator_id¶

id¶

operational_status_code¶

owner_city¶

owner_name¶

owner_state¶

owner_street_address¶

owner_utility_id_eia¶

owner_zip_code¶

plant_id_eia¶

report_date¶

utility_id_eia¶

class pudl.models.eia860.PlantEIA860(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

EIA Plants per year, listed in 923 or 860.

A compliation of yearly plant info.

ash_impoundment¶

ash_impoundment_lined¶

ash_impoundment_status¶

energy_storage¶

ferc_cogen_docket_no¶

ferc_exempt_wholesale_generator_docket_no¶

ferc_small_power_producer_docket_no¶

id¶

liquefied_natural_gas_storage¶

natural_gas_local_distribution_company¶

natural_gas_pipeline_name_1¶

natural_gas_pipeline_name_2¶

natural_gas_pipeline_name_3¶

natural_gas_storage¶

net_metering¶

pipeline_notes¶

plant_id_eia¶

regulatory_status_code¶

report_date¶

transmission_distribution_owner_id¶

transmission_distribution_owner_name¶

transmission_distribution_owner_state¶

utility_id_eia¶

water_source¶

class pudl.models.eia860.UtilityEIA860(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

EIA Plants per year, listed in 923 or 860.

A compliation of yearly plant info.

city¶

id¶

plants_reported_asset_manager¶

plants_reported_operator¶

plants_reported_other_relationship¶

plants_reported_owner¶

report_date¶

state¶

street_address¶

utility_id_eia¶

zip_code¶