Skip to content

Clean up states in EIA861 balancing authority association table #2414

@zaneselvans

Description

@zaneselvans

The state column in balancing_authority_assn_eia861 contains some invalid values and needs to be constrained / encoded appropriately. It looks like it should include US states, territories, and outlying areas abbreviations from the POLITICAL_SUBDIVISIONS table, but it also has some NA values which we've replaced with NA, and a few codes that just look bad, including CN (China? Connecticut?) and should be re-coded appropriately.

Metadata

Metadata

Assignees

No one assigned

    Labels

    data-cleaningTasks related to cleaning & regularizing data during ETL.eia861Anything having to do with EIA Form 861

    Type

    No type

    Projects

    Status

    Icebox

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions