Test ingestion of FERC1 tables into PUDL for full 2004-2015 date range

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

Test ingestion of FERC1 tables into PUDL for full 2004-2015 date range #45

Closed zaneselvans closed 7 years ago

zaneselvans commented 7 years ago

Many FERC1 data tables are now successfully importing into PUDL, but only for the year 2015. Once we have the glue tables updated with relationships between plants and utilities for the years 2004-2015 (See Issue #26 ), we'll need to revisit the imports of all of the other years of these older tables, and make sure they still work.

zaneselvans commented 7 years ago

With the completion of ingest_small_plants_ferc1() we now have all of our initial FERC tables of interest migrated into the database, and they appear to import successfully, at least from 2007-2015. Still need to address some changes in line number for early years in the accumulated depreciation table and maybe the FERC accounts. Not going after this right now because EIA923 only works as far back as 2009 for the moment.