3546e2a53f264edaf618aa706c0489ff2331f119,pudl/models/eia923.py,CoalMineEIA923,CoalMineEIA923_1,#,16

Before Change

    __tablename__ = "coalmine_eia923"
    id = Column(Integer, primary_key=True)  // surrogate key
    mine_name = Column(String)
    mine_type_code = Column(String, ForeignKey("coalmine_type_eia923.abbr"))
    state = Column(String, ForeignKey("coalmine_state_eia923.abbr"))
    // TODO check feasibility t add FK/constants or map to FIPS code used by EIA
    county_id_fips = Column(Integer)
    // TODO check feasibility to add FK/constants or map to MSHA ID// used by EIA
    mine_id_msha = Column(Integer)

After Change

    __tablename__ = "coalmine_eia923"
    id = Column(Integer, primary_key=True)  // surrogate key
    mine_name = Column(String)
    mine_type_code = Column(
        Enum(*pudl.constants.coalmine_type_eia923.keys(),
             name="coalmine_type_eia923"),
        comment="Type of mine. P: Preparation plant, U: Underground, S: Surface, SU: Mostly Surface with some Underground, US: Mostly Underground with some Surface."
    )
    state = Column(
        Enum(*pudl.constants.coalmine_country_eia923.values(),
             *pudl.constants.us_states.keys(),
             name="coalmine_location_eia923"),

Instances