pudl.models.entities module

Database models for PUDL tables for .

class pudl.models.entities.BoilerEntityEIA(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

An EIA Boiler, listed in 923 or 860.

A compilation of all EIA plant ids and static info.

boiler_id

plant_id_eia

prime_mover_code

class pudl.models.entities.DataSets(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

Active datasets ingest into PUDL.

A compilation of the active or inactive datasets in the databaseself.

active

datasource

class pudl.models.entities.GeneratorEntityEIA(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

An EIA Generator, listed in 923 or 860.

A compilation of all EIA plant ids and static info.

associated_combined_heat_power

duct_burners

fluidized_bed_tech

generator_id

heat_bypass_recovery

operating_date

operating_switch

original_planned_operating_date

other_combustion_tech

plant_id_eia

previously_canceled

prime_mover_code

pulverized_coal_tech

rto_iso_lmp_node_id

rto_iso_location_wholesale_reporting_id

solid_fuel_gasification

stoker_tech

subcritical_tech

supercritical_tech

topping_bottoming_code

ultrasupercritical_tech

class pudl.models.entities.PlantEntityEIA(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

An EIA Plant, listed in 923 or 860.

A compilation of all EIA plant ids and static info.

balancing_authority_code

balancing_authority_name

city

county

ferc_cogen_status

ferc_exempt_wholesale_generator

ferc_small_power_producer

grid_voltage_2_kv

grid_voltage_3_kv

grid_voltage_kv

iso_rto_code

iso_rto_name

latitude

longitude

nerc_region

plant_id_eia

plant_name

primary_purpose_naics_id

sector_id

sector_name

state

street_address

timezone

zip_code

class pudl.models.entities.RegionEntityIPM(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

A region in EPA’s Integrated Planning Model.

region_id_ipm

class pudl.models.entities.UtilityEntityEIA(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base

An EIA Utility, listed in 923 or 860.

A compilation of all EIA utilities ids and static info.

entity_type

utility_id_eia

utility_name