Integrate bulk EIA Annual Energy Outlook (AEO) data

[zaneselvans]

Design Considerations

• For the GridLab project, we only need a small subset of the data that's part of AEO, but we'll probably find other parts that we want to extract over time, so building some reusable transformations would be useful if it's not extra work.
• We should reach out to @gschivley and @grgmiller and see what data they're currently using from AEO and whether we can prepare ourselves to share their use cases as well.
• There's annual data spanning a decade (2014-2023), but is there any reason to extract more than just the most recent version at the moment? Seems like it would be interesting to track how predictions have changed over time, but that's not what we're doing right now.

Tasks

Preview Give feedback

1. Define eia_aeo, nrel_atb and eia930 data source metadata #3473
   eia930 eiaaeo gridlab metadata nrelatb +5
   
2. Archive the EIA AEO bulk data pudl-archiver#293
   eiaaeo gridlab new-data zenodo +4
   
3. Extract AEO Table 54 into a dataframe #3368
   2 of 2
   eiaaeo gridlab new-data +3
   
4. Transform high-priority AEO Table 54 data into normalized assets #3581
   3 of 3
   eiaaeo epic gridlab new-data +4
   
5. Define denormalized output tables for the extracted AEO data, if appropriate
6. Integrate Table 13: Natural Gas Supply, Disposition, and Prices (Henry Hub, not by region)
7. Integrate Table 15: Coal Supply, Disposition, and Price (average minemouth and delivered prices, not by region)
8. Integrate Table 20: Macroeconomic Indicators

[zaneselvans]

We descoped the additional tables above from the initial MVP. So this is done for now.