search

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 106 forks source link

Flesh out static tables needed for EIA923 #28

Closed zaneselvans closed 7 years ago

zaneselvans commented 7 years ago

There are many static tables (e.g. abbreviations of NERC regions) that we should have available as foreign keys within the PUDL Database. They are summarized in the back of the EIA923 spreadsheet. Because they're simple, they'll also provide a good practice run for defining tables using the ORM, and getting those tables populated when init_db() runs.

zaneselvans commented 7 years ago

@swinter2011 has added many of these values as static lists or dictionaries to the constants.py module, so you should be able to move right on to the table definitions.