catalyst-cooperative / pudl

The Public Utility Data Liberation Project provides analysis-ready energy system data to climate advocates, researchers, policymakers, and journalists.
https://catalyst.coop/pudl
MIT License
456 stars 105 forks source link

Standardize and separate state and country codes in coal_mines_eia923 table #525

Open zaneselvans opened 4 years ago

zaneselvans commented 4 years ago

The coal_mines_eia923 table includes a field for the location of the mine, which is a mix of 2-letter US state abbreviations, and 3-letter country abbreviations for non-US locations. This is a little bit of a mess to parse... we could use here (and in other mixed contexts) the ISO 3166-2 combination principal subdivision codes instead, or separate country / subdivision fields.

zaneselvans commented 2 years ago

This is related to #1013