pudl.models.ferc1 module¶

Database models for PUDL tables derived from FERC Form 1 data.

class pudl.models.ferc1.AccumulatedDepreciationFERC1(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

Balances and changes to FERC Accumulated Provision for Depreciation.

This data comes from the f1_accumdepr_prvsn table in the ferc1 DB.

electric_plant¶

future_plant¶

leased_plant¶

line_id¶

record_id¶

report_year¶

total¶

utility_id_ferc1¶

class pudl.models.ferc1.FuelFERC1(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

Annual fuel consumed by plant, as reported to FERC in Form 1.

This information comes from the f1_fuel table in the FERC DB, which is populated from page 402 of the paper FERC Form 1.

fuel_cost_per_mmbtu¶

fuel_cost_per_unit_burned¶

fuel_cost_per_unit_delivered¶

fuel_mmbtu_per_unit¶

fuel_qty_burned¶

fuel_type_code_pudl¶

fuel_unit¶

id¶

plant_name¶

record_id¶

report_year¶

utility_id_ferc1¶

class pudl.models.ferc1.PlantHydroFERC1(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

Annual data on hydro plants from FERC form 1.

asset_retirement_cost¶

avg_num_employees¶

capacity_mw¶

capex_equipment¶

capex_facilities¶

capex_land¶

capex_per_mw¶

capex_roads¶

capex_structures¶

capex_total¶

construction_type¶

construction_year¶

id¶

installation_year¶

net_capacity_adverse_conditions_mw¶

net_capacity_favorable_conditions_mw¶

net_generation_mwh¶

opex_dams¶

opex_electric¶

opex_engineering¶

opex_generation_misc¶

opex_hydraulic¶

opex_misc_plant¶

opex_operations¶

opex_per_mwh¶

opex_plant¶

opex_rents¶

opex_structures¶

opex_total¶

opex_water_for_power¶

peak_demand_mw¶

plant_hours_connected_while_generating¶

plant_name¶

plant_type¶

project_num¶

record_id¶

report_year¶

utility_id_ferc1¶

class pudl.models.ferc1.PlantInServiceFERC1(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

Balances and changes to FERC Electric Plant In Service accounts.

This data comes from f1_plant_in_srvce in the ferc1 DB. It corresponds to the balances of the FERC Uniform System of Accounts for Electric Plant which is well documented here:

https://www.law.cornell.edu/cfr/text/18/part-101

Each FERC respondent reports starting & ending balances, and changes to the account balances, each year.

additions¶

adjustments¶

beginning_year_balance¶

ferc_account_id¶

record_id¶

report_year¶

retirements¶

transfers¶

utility_id_ferc1¶

year_end_balance¶

class pudl.models.ferc1.PlantPumpedStorage(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

Annual data on pumped storage from the f1_pumped_storage table.

asset_retirement_cost¶

avg_num_employees¶

capacity_mw¶

capex_equipment_electric¶

capex_equipment_misc¶

capex_facilities¶

capex_land¶

capex_per_mw¶

capex_roads¶

capex_structures¶

capex_total¶

capex_wheels_turbines_generators¶

construction_type¶

construction_year¶

energy_used_for_pumping_mwh¶

id¶

installation_year¶

net_generation_mwh¶

net_load_mwh¶

opex_dams¶

opex_electric¶

opex_engineering¶

opex_generation_misc¶

opex_misc_plant¶

opex_operations¶

opex_per_mwh¶

opex_plant¶

opex_production_before_pumping¶

opex_pumped_storage¶

opex_pumping¶

opex_rents¶

opex_structures¶

opex_total¶

opex_water_for_power¶

peak_demand_mw¶

plant_capability_mw¶

plant_hours_connected_while_generating¶

plant_name¶

project_num¶

record_id¶

report_year¶

utility_id_ferc1¶

class pudl.models.ferc1.PlantSmallFERC1(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

Annual data on “small plants” imported from the f1_gnrt_plant table.

Capacity and generation data related to a heterogenous collection of small plants that have to report to FERC. Includes many renewable energy facilities, as well as smaller thermal generation stations.

capacity_mw¶

capex_per_mw¶

construction_year¶

ferc_license_id¶

fuel_cost_per_mmbtu¶

fuel_type¶

id¶

net_generation_mwh¶

opex_fuel¶

opex_maintenance¶

opex_total¶

peak_demand_mw¶

plant_name¶

plant_name_original¶

plant_type¶

record_id¶

report_year¶

total_cost_of_plant¶

utility_id_ferc1¶

class pudl.models.ferc1.PlantSteamFERC1(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

A large thermal generating plant, as reported to FERC on Form 1.

asset_retirement_cost¶

avg_num_employees¶

capacity_mw¶

capex_equipment¶

capex_land¶

capex_per_mw¶

capex_structures¶

capex_total¶

construction_type¶

construction_year¶

id¶

installation_year¶

net_generation_mwh¶

not_water_limited_capacity_mw¶

opex_allowances¶

opex_boiler¶

opex_coolants¶

opex_electric¶

opex_engineering¶

opex_fuel¶

opex_misc_power¶

opex_misc_steam¶

opex_operations¶

opex_per_mwh¶

opex_plants¶

opex_production_total¶

opex_rents¶

opex_steam¶

opex_steam_other¶

opex_structures¶

opex_transfer¶

peak_demand_mw¶

plant_capability_mw¶

plant_hours_connected_while_generating¶

plant_id_ferc1¶

plant_name¶

plant_type¶

record_id¶

report_year¶

utility_id_ferc1¶

water_limited_capacity_mw¶

class pudl.models.ferc1.PurchasedPowerFERC1(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

Utility power purchase data, from FERC1 DB f1_purchased_pwr table.

billing_demand_mw¶

coincident_peak_demand_mw¶

delivered_mwh¶

demand_charges¶

energy_charges¶

id¶

non_coincident_peak_demand_mw¶

other_charges¶

purchase_type¶

purchased_mwh¶

received_mwh¶

record_id¶

report_year¶

seller_name¶

tariff¶

total_settlement¶

utility_id_ferc1¶