Retrieve MISO interconnection queue project data and track the status of generator projects awaiting interconnection approval

Steps

1. Access the MISO Generator Interconnection Queue report from https://www.misoenergy.org/planning/generator-interconnection/GI_Queue/; MISO publishes a regularly updated queue report in Excel and CSV format — download the current file programmatically by constructing the URL from the queue report page.
2. Parse the queue report CSV which contains columns including Queue Number, Project Name, County/State, Fuel, Summer Capacity (MW), Winter Capacity (MW), Status (e.g., 'Active', 'Withdrawn', 'Completed'), Study Cluster, and In-Service Date Request.
3. Filter by status to identify active projects awaiting interconnection study completion; track the Study Cluster (or Study Phase) to understand which projects are in Feasibility Study, System Impact Study, or Facilities Study phases under MISO's Definitive Planning Phase (DPP) process.
4. For projects of interest, cross-reference the queue number with MISO's eLibrary at https://www.misoenergy.org/stakeholder-engagement/regulatory-libraries/ to find associated interconnection study documents and cost allocation decisions.
5. Automate weekly downloads of the queue report and diff against the prior week's snapshot to detect newly added projects, status changes (e.g., Active to Withdrawn), and In-Service Date Request changes — these changes are market-relevant signals for capacity and transmission planning.
6. For large-scale analysis, supplement MISO queue data with Lawrence Berkeley National Laboratory's Queued Up database (emp.lbl.gov) which aggregates interconnection queue data across all ISOs and provides standardized project-level attributes for multi-ISO comparison.