{ "cells": [ { "cell_type": "markdown", "id": "4801b581", "metadata": {}, "source": [ "# Interconnection Queues\n", "\n", "All ISOs support retrieving interconnection queues with `iso.get_interconnection_queue` methods.\n", "\n", "Each of the ISOs report slightly differently fields for their queues, so a best effort was made to standardize column names. When a column couldn't be standardized, it is appended to end of the returned dataframe.\n", "\n", "Below you can see preview of each of ISOs interconnection queues\n", "\n", "## NYISO" ] }, { "cell_type": "code", "execution_count": 1, "id": "ed4f95e7", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Queue IDProject NameInterconnecting EntityCountyStateInterconnection LocationTransmission OwnerGeneration TypeCapacity (MW)Summer Capacity (MW)...Withdrawn DateWithdrawal CommentActual Completion DateProposed In-ServiceProposed Initial-SyncLast UpdateZSAvailability of StudiesFS Complete/ SGIA Tender
00276Homer Solar Energy CenterHomer Solar Energy Center, LLCCortlandNYCortland - Fenner 115kVNM-NGSolar90.090.0...NaNNaNNaN2023-08-012023-09-012022-09-30 00:00:00C10.0FES, SRIS, FS2021-02-08 00:00:00
10393Berrians East ReplacementNRG Berrians East Development, LLCQueensNYAstoria East 138kVConEdDual Fuel94.294.2...NaNNaNNaN2024-05-012024-08-012022-06-30 00:00:00J11.0FES, SRIS, FS2019-07-09 00:00:00
20396Baron WindsBaron Winds, LLCSteubenNYHillside - Meyer 230kVNYSEGWind238.4238.4...NaNNaNNaN2022-05-012022-06-012021-11-30 00:00:00C11.0FES, SRIS, FS2019-07-09 00:00:00
30396AWood Street TransformerNew York State Electric & GasPutnamNYWood St. 345/115kVNYSEGAC TransmissionNaNNaN...NaNNaNNaN2022-12-01NaT2021-04-30 00:00:00G12.0SISNaT
40422Eight Point Wind Energy CenterNextEra Energy Resources, LLCSteuben-AlleganyNYBennett 115kVNYSEGWind101.8101.8...NaNNaNNaN2022-11-012022-11-012022-10-31 00:00:00C12.0FES, SRIS, FS2019-07-09 00:00:00
..................................................................
1430583FultonErie Boulevard Hydropower, LPOswegoNYFay St. 34.5kVNM-NGHydro1.31.3...NaNNaN3/31/182023-08-012023-09-013/31/18C14FS2017-07-12 00:00:00
14310696Swinging Bridge Unit 3Eagle Creek Hydro Power, LLCOrangeNYSwing Bridge 69 kVO&RHydro1.21.2...NaNNaN2020-04-30 00:00:002023-11-012023-11-012020-04-30 00:00:00G14NaN2018-06-20 00:00:00
14320701KCE NY 1KCE NY 1, LLCSaratogaNYLuther - Forest Substation 34.5kVNYSEGEnergy Storage20.020.0...NaNNaN2020-04-30 00:00:002023-07-012023-07-012020-04-30 00:00:00F14NaN2018-06-20 00:00:00
14330731Branscomb SolarBranscomb Solar, LLCWashingtonNYBattenkill - Eastover 115kVNM-NGSolar20.020.0...NaNNaN2022-03-31 00:00:002023-08-012023-10-012022-03-31 00:00:00F14FES, SIS, FS2020-04-29 00:00:00
14340781Marcy South SSR DetectionNew York Power AuthorityDelawareNYFraser - Annex 345 kV SubstationNYPAAC TransmissionNaNNaN...NaNNaN2020-04-30 00:00:002024-11-012024-12-012020-04-30 00:00:00E14SISNaN
\n", "

1435 rows × 24 columns

\n", "
" ], "text/plain": [ " Queue ID Project Name \\\n", "0 0276 Homer Solar Energy Center \n", "1 0393 Berrians East Replacement \n", "2 0396 Baron Winds \n", "3 0396A Wood Street Transformer \n", "4 0422 Eight Point Wind Energy Center \n", "... ... ... \n", "1430 583 Fulton \n", "1431 0696 Swinging Bridge Unit 3 \n", "1432 0701 KCE NY 1 \n", "1433 0731 Branscomb Solar \n", "1434 0781 Marcy South SSR Detection \n", "\n", " Interconnecting Entity County State \\\n", "0 Homer Solar Energy Center, LLC Cortland NY \n", "1 NRG Berrians East Development, LLC Queens NY \n", "2 Baron Winds, LLC Steuben NY \n", "3 New York State Electric & Gas Putnam NY \n", "4 NextEra Energy Resources, LLC Steuben-Allegany NY \n", "... ... ... ... \n", "1430 Erie Boulevard Hydropower, LP Oswego NY \n", "1431 Eagle Creek Hydro Power, LLC Orange NY \n", "1432 KCE NY 1, LLC Saratoga NY \n", "1433 Branscomb Solar, LLC Washington NY \n", "1434 New York Power Authority Delaware NY \n", "\n", " Interconnection Location Transmission Owner Generation Type \\\n", "0 Cortland - Fenner 115kV NM-NG Solar \n", "1 Astoria East 138kV ConEd Dual Fuel \n", "2 Hillside - Meyer 230kV NYSEG Wind \n", "3 Wood St. 345/115kV NYSEG AC Transmission \n", "4 Bennett 115kV NYSEG Wind \n", "... ... ... ... \n", "1430 Fay St. 34.5kV NM-NG Hydro \n", "1431 Swing Bridge 69 kV O&R Hydro \n", "1432 Luther - Forest Substation 34.5kV NYSEG Energy Storage \n", "1433 Battenkill - Eastover 115kV NM-NG Solar \n", "1434 Fraser - Annex 345 kV Substation NYPA AC Transmission \n", "\n", " Capacity (MW) Summer Capacity (MW) ... Withdrawn Date \\\n", "0 90.0 90.0 ... NaN \n", "1 94.2 94.2 ... NaN \n", "2 238.4 238.4 ... NaN \n", "3 NaN NaN ... NaN \n", "4 101.8 101.8 ... NaN \n", "... ... ... ... ... \n", "1430 1.3 1.3 ... NaN \n", "1431 1.2 1.2 ... NaN \n", "1432 20.0 20.0 ... NaN \n", "1433 20.0 20.0 ... NaN \n", "1434 NaN NaN ... NaN \n", "\n", " Withdrawal Comment Actual Completion Date Proposed In-Service \\\n", "0 NaN NaN 2023-08-01 \n", "1 NaN NaN 2024-05-01 \n", "2 NaN NaN 2022-05-01 \n", "3 NaN NaN 2022-12-01 \n", "4 NaN NaN 2022-11-01 \n", "... ... ... ... \n", "1430 NaN 3/31/18 2023-08-01 \n", "1431 NaN 2020-04-30 00:00:00 2023-11-01 \n", "1432 NaN 2020-04-30 00:00:00 2023-07-01 \n", "1433 NaN 2022-03-31 00:00:00 2023-08-01 \n", "1434 NaN 2020-04-30 00:00:00 2024-11-01 \n", "\n", " Proposed Initial-Sync Last Update Z S \\\n", "0 2023-09-01 2022-09-30 00:00:00 C 10.0 \n", "1 2024-08-01 2022-06-30 00:00:00 J 11.0 \n", "2 2022-06-01 2021-11-30 00:00:00 C 11.0 \n", "3 NaT 2021-04-30 00:00:00 G 12.0 \n", "4 2022-11-01 2022-10-31 00:00:00 C 12.0 \n", "... ... ... .. ... \n", "1430 2023-09-01 3/31/18 C 14 \n", "1431 2023-11-01 2020-04-30 00:00:00 G 14 \n", "1432 2023-07-01 2020-04-30 00:00:00 F 14 \n", "1433 2023-10-01 2022-03-31 00:00:00 F 14 \n", "1434 2024-12-01 2020-04-30 00:00:00 E 14 \n", "\n", " Availability of Studies FS Complete/ SGIA Tender \n", "0 FES, SRIS, FS 2021-02-08 00:00:00 \n", "1 FES, SRIS, FS 2019-07-09 00:00:00 \n", "2 FES, SRIS, FS 2019-07-09 00:00:00 \n", "3 SIS NaT \n", "4 FES, SRIS, FS 2019-07-09 00:00:00 \n", "... ... ... \n", "1430 FS 2017-07-12 00:00:00 \n", "1431 NaN 2018-06-20 00:00:00 \n", "1432 NaN 2018-06-20 00:00:00 \n", "1433 FES, SIS, FS 2020-04-29 00:00:00 \n", "1434 SIS NaN \n", "\n", "[1435 rows x 24 columns]" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import gridstatus\n", "nyiso = gridstatus.NYISO()\n", "nyiso.get_interconnection_queue()" ] }, { "cell_type": "markdown", "id": "a7cd5fdd", "metadata": {}, "source": [ "## CAISO" ] }, { "cell_type": "code", "execution_count": 2, "id": "a8d72349", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Queue IDProject NameInterconnecting EntityCountyStateInterconnection LocationTransmission OwnerGeneration TypeCapacity (MW)Summer Capacity (MW)...Interconnection Request Receive DateInterconnection Agreement StatusStudy ProcessProposed On-line Date (as filed with IR)System Impact Study or Phase I Cluster StudyFacilities Study (FAS) or Phase II Cluster StudyOptional Study (OS)Full Capacity, Partial or Energy Only (FC/P/EO)Off-Peak Deliverability and Economic OnlyFeasibility Study or Supplemental Review
022MONTEZUMA (HIGH WINDS III)NoneSOLANOCABirds Landing Sub 230 kV BusPGAEWind Turbine + Storage38.0None...2003-11-18 00:00:00ExecutedAMEND 392005-06-30 07:00:00CompleteCompleteNaNNaNOff-Peak DeliverabilityNaN
132TULE WINDNoneSAN DIEGOCABoulevard East Substation 138 kVSDGEWind Turbine193.8None...2004-05-12 00:00:00ExecutedSerial LGIP2007-09-01 07:00:00CompleteCompleteNonePartial CapacityOff-Peak DeliverabilityWaived
272LAKE ELSINORE ADVANCED PUMPED STORAGE PROJECTNoneRIVERSIDECAProposed Lee Lake Substation 500 kVSDGEStorage500.0None...2005-04-26 00:00:00ExecutedSerial LGIP2008-12-31 08:00:00CompleteRe-StudyNoneFull CapacityNaNWaived
3138SANDSTORM WIND POWERNoneRIVERSIDECADevers - San Bernardino 230 kV lineSCEWind Turbine + Storage150.0None...2006-10-23 00:00:00ExecutedSerial LGIP2008-12-31 08:00:00CompleteCompleteNonePartial CapacityOff-Peak DeliverabilityWaived
4146DESERT SUNLIGHT PV INoneRIVERSIDECARed Bluff Substation 230kVSCEPhotovoltaic + Storage250.0None...2006-11-16 00:00:00ExecutedSerial LGIP2008-12-01 08:00:00CompleteCompleteNonePartial CapacityOff-Peak DeliverabilityRequired
..................................................................
22692189LA FUENTE ENERGY STORAGENoneSAN DIEGOCAOtay Mesa Switchyard 230 kVSDGEStorage100.0None...2021-04-14 00:00:00NaNC142024-06-01 07:00:00NaNNaNNaNFull CapacityNaNNaN
22702190HERMES ENERGY STORAGENoneSAN DIEGOCABorder Substation 69 kVSDGEStorage150.0None...2021-04-15 00:00:00NaNC142024-06-01 07:00:00NaNNaNNaNFull CapacityOff-Peak DeliverabilityNaN
22712191FREIGHT ENERGY STORAGENoneSAN DIEGOCABorder Substation 69 kVSDGEStorage50.0None...2021-04-15 00:00:00NaNC142025-06-01 07:00:00NaNNaNNaNFull CapacityNaNNaN
22722193VENTANA ENERGY STORAGENoneSAN BERNARDINOCALugoSCEStorage250.0None...2021-11-19 00:00:00NaNISP2024-06-01 07:00:00NaNNaNNaNFull CapacityOff-Peak DeliverabilityNaN
22732194PRONGHORN ENERGY STORAGENoneLOS ANGELESCAAntelopeSCEStorage120.0None...2022-05-07 00:00:00NaNISP2026-06-01 07:00:00NaNNaNNaNFull CapacityOff-Peak DeliverabilityNaN
\n", "

2274 rows × 36 columns

\n", "
" ], "text/plain": [ " Queue ID Project Name \\\n", "0 22 MONTEZUMA (HIGH WINDS III) \n", "1 32 TULE WIND \n", "2 72 LAKE ELSINORE ADVANCED PUMPED STORAGE PROJECT \n", "3 138 SANDSTORM WIND POWER \n", "4 146 DESERT SUNLIGHT PV I \n", "... ... ... \n", "2269 2189 LA FUENTE ENERGY STORAGE \n", "2270 2190 HERMES ENERGY STORAGE \n", "2271 2191 FREIGHT ENERGY STORAGE \n", "2272 2193 VENTANA ENERGY STORAGE \n", "2273 2194 PRONGHORN ENERGY STORAGE \n", "\n", " Interconnecting Entity County State \\\n", "0 None SOLANO CA \n", "1 None SAN DIEGO CA \n", "2 None RIVERSIDE CA \n", "3 None RIVERSIDE CA \n", "4 None RIVERSIDE CA \n", "... ... ... ... \n", "2269 None SAN DIEGO CA \n", "2270 None SAN DIEGO CA \n", "2271 None SAN DIEGO CA \n", "2272 None SAN BERNARDINO CA \n", "2273 None LOS ANGELES CA \n", "\n", " Interconnection Location Transmission Owner \\\n", "0 Birds Landing Sub 230 kV Bus PGAE \n", "1 Boulevard East Substation 138 kV SDGE \n", "2 Proposed Lee Lake Substation 500 kV SDGE \n", "3 Devers - San Bernardino 230 kV line SCE \n", "4 Red Bluff Substation 230kV SCE \n", "... ... ... \n", "2269 Otay Mesa Switchyard 230 kV SDGE \n", "2270 Border Substation 69 kV SDGE \n", "2271 Border Substation 69 kV SDGE \n", "2272 Lugo SCE \n", "2273 Antelope SCE \n", "\n", " Generation Type Capacity (MW) Summer Capacity (MW) ... \\\n", "0 Wind Turbine + Storage 38.0 None ... \n", "1 Wind Turbine 193.8 None ... \n", "2 Storage 500.0 None ... \n", "3 Wind Turbine + Storage 150.0 None ... \n", "4 Photovoltaic + Storage 250.0 None ... \n", "... ... ... ... ... \n", "2269 Storage 100.0 None ... \n", "2270 Storage 150.0 None ... \n", "2271 Storage 50.0 None ... \n", "2272 Storage 250.0 None ... \n", "2273 Storage 120.0 None ... \n", "\n", " Interconnection Request Receive Date Interconnection Agreement Status \\\n", "0 2003-11-18 00:00:00 Executed \n", "1 2004-05-12 00:00:00 Executed \n", "2 2005-04-26 00:00:00 Executed \n", "3 2006-10-23 00:00:00 Executed \n", "4 2006-11-16 00:00:00 Executed \n", "... ... ... \n", "2269 2021-04-14 00:00:00 NaN \n", "2270 2021-04-15 00:00:00 NaN \n", "2271 2021-04-15 00:00:00 NaN \n", "2272 2021-11-19 00:00:00 NaN \n", "2273 2022-05-07 00:00:00 NaN \n", "\n", " Study Process Proposed On-line Date (as filed with IR) \\\n", "0 AMEND 39 2005-06-30 07:00:00 \n", "1 Serial LGIP 2007-09-01 07:00:00 \n", "2 Serial LGIP 2008-12-31 08:00:00 \n", "3 Serial LGIP 2008-12-31 08:00:00 \n", "4 Serial LGIP 2008-12-01 08:00:00 \n", "... ... ... \n", "2269 C14 2024-06-01 07:00:00 \n", "2270 C14 2024-06-01 07:00:00 \n", "2271 C14 2025-06-01 07:00:00 \n", "2272 ISP 2024-06-01 07:00:00 \n", "2273 ISP 2026-06-01 07:00:00 \n", "\n", " System Impact Study or Phase I Cluster Study \\\n", "0 Complete \n", "1 Complete \n", "2 Complete \n", "3 Complete \n", "4 Complete \n", "... ... \n", "2269 NaN \n", "2270 NaN \n", "2271 NaN \n", "2272 NaN \n", "2273 NaN \n", "\n", " Facilities Study (FAS) or Phase II Cluster Study Optional Study (OS) \\\n", "0 Complete NaN \n", "1 Complete None \n", "2 Re-Study None \n", "3 Complete None \n", "4 Complete None \n", "... ... ... \n", "2269 NaN NaN \n", "2270 NaN NaN \n", "2271 NaN NaN \n", "2272 NaN NaN \n", "2273 NaN NaN \n", "\n", " Full Capacity, Partial or Energy Only (FC/P/EO) \\\n", "0 NaN \n", "1 Partial Capacity \n", "2 Full Capacity \n", "3 Partial Capacity \n", "4 Partial Capacity \n", "... ... \n", "2269 Full Capacity \n", "2270 Full Capacity \n", "2271 Full Capacity \n", "2272 Full Capacity \n", "2273 Full Capacity \n", "\n", " Off-Peak Deliverability and Economic Only \\\n", "0 Off-Peak Deliverability \n", "1 Off-Peak Deliverability \n", "2 NaN \n", "3 Off-Peak Deliverability \n", "4 Off-Peak Deliverability \n", "... ... \n", "2269 NaN \n", "2270 Off-Peak Deliverability \n", "2271 NaN \n", "2272 Off-Peak Deliverability \n", "2273 Off-Peak Deliverability \n", "\n", " Feasibility Study or Supplemental Review \n", "0 NaN \n", "1 Waived \n", "2 Waived \n", "3 Waived \n", "4 Required \n", "... ... \n", "2269 NaN \n", "2270 NaN \n", "2271 NaN \n", "2272 NaN \n", "2273 NaN \n", "\n", "[2274 rows x 36 columns]" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "caiso = gridstatus.CAISO()\n", "caiso.get_interconnection_queue()" ] }, { "cell_type": "markdown", "id": "8a808554", "metadata": {}, "source": [ "## SPP" ] }, { "cell_type": "code", "execution_count": 3, "id": "116fb3ee", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Queue IDProject NameInterconnecting EntityCountyStateInterconnection LocationTransmission OwnerGeneration TypeCapacity (MW)Summer Capacity (MW)...Withdrawn DateWithdrawal CommentActual Completion DateIn-Service DateCommercial Operation DateCessation DateCurrent ClusterCluster GroupReplacement Generator Commercial Op DateService Type
0GEN-2001-014NoneNoneSleeping BearOKFt Supply 138kVWFECWind94.5094.50...NoneNoneNone6/30/20074/15/2007NaNICS-2008-001 Prior Queued04 SOUTHEASTNaNER
1GEN-2001-018NoneNoneNeosho CountyKSChanute NW Neosho Cnty By Tioga SubWEREThermal - Gas47.0047.00...NoneNoneNone1/1/20021/1/2002NaNNaNNaNNaNER
2GEN-2001-024NoneNoneWashington CountyARSWEPCO Tontitown 161kV SubstationAEPThermal - CT630.00580.00...NoneNoneNone5/1/20077/1/2007NaNNaNNaNNaNER
3GEN-2001-026NoneNoneMeersOKWashita 138kVWFECWind74.2574.25...NoneNoneNone10/1/200310/1/2003NaNICS-2008-001 Prior Queued04 SOUTHEASTNaNER
4GEN-2001-029NNoneNoneBeatriceNENaNNPPDThermal - Gas250.00250.00...NoneNoneNone1/1/20051/1/2005NaNNaNNaNNaNER
..................................................................
797GEN-2022-100NoneNonePittsburgOKTo Be DefinedWFECHybrid - Solar/Storage150.00150.00...NoneNoneNone10/25/202510/1/2025NaNDISIS-2022-00104 SOUTHEASTNaNER/NR
798GEN-2022-GR1NoneNoneHallsvilleTXPirkey 138 kVNaN580.00580.00...NoneNoneNoneNaN3/30/20263/31/2023NaNNaNNaNERIS
799GEN-2022-GR2NoneNoneHarrahOKNaNNaN400.00400.00...NoneNoneNoneNaNNaNNaNNaNNaN12/31/2027NRIS
800GEN-2022-SR7NoneNoneCampbellNEMacon 345 kV SubstationNaNBattery/Storage210.00210.00...NoneNoneNoneNaN12/1/2018NaNSurplusNaNNaNER
801GEN-2022-SR8NoneNoneCampbellNEMacon 345 kV SubstationNaNSolar210.00210.00...NoneNoneNoneNaNNaNNaNSurplusNaNNaNER
\n", "

802 rows × 24 columns

\n", "
" ], "text/plain": [ " Queue ID Project Name Interconnecting Entity County \\\n", "0 GEN-2001-014 None None Sleeping Bear \n", "1 GEN-2001-018 None None Neosho County \n", "2 GEN-2001-024 None None Washington County \n", "3 GEN-2001-026 None None Meers \n", "4 GEN-2001-029N None None Beatrice \n", ".. ... ... ... ... \n", "797 GEN-2022-100 None None Pittsburg \n", "798 GEN-2022-GR1 None None Hallsville \n", "799 GEN-2022-GR2 None None Harrah \n", "800 GEN-2022-SR7 None None Campbell \n", "801 GEN-2022-SR8 None None Campbell \n", "\n", " State Interconnection Location Transmission Owner \\\n", "0 OK Ft Supply 138kV WFEC \n", "1 KS Chanute NW Neosho Cnty By Tioga Sub WERE \n", "2 AR SWEPCO Tontitown 161kV Substation AEP \n", "3 OK Washita 138kV WFEC \n", "4 NE NaN NPPD \n", ".. ... ... ... \n", "797 OK To Be Defined WFEC \n", "798 TX Pirkey 138 kV NaN \n", "799 OK NaN NaN \n", "800 NE Macon 345 kV Substation NaN \n", "801 NE Macon 345 kV Substation NaN \n", "\n", " Generation Type Capacity (MW) Summer Capacity (MW) ... \\\n", "0 Wind 94.50 94.50 ... \n", "1 Thermal - Gas 47.00 47.00 ... \n", "2 Thermal - CT 630.00 580.00 ... \n", "3 Wind 74.25 74.25 ... \n", "4 Thermal - Gas 250.00 250.00 ... \n", ".. ... ... ... ... \n", "797 Hybrid - Solar/Storage 150.00 150.00 ... \n", "798 580.00 580.00 ... \n", "799 400.00 400.00 ... \n", "800 Battery/Storage 210.00 210.00 ... \n", "801 Solar 210.00 210.00 ... \n", "\n", " Withdrawn Date Withdrawal Comment Actual Completion Date In-Service Date \\\n", "0 None None None 6/30/2007 \n", "1 None None None 1/1/2002 \n", "2 None None None 5/1/2007 \n", "3 None None None 10/1/2003 \n", "4 None None None 1/1/2005 \n", ".. ... ... ... ... \n", "797 None None None 10/25/2025 \n", "798 None None None NaN \n", "799 None None None NaN \n", "800 None None None NaN \n", "801 None None None NaN \n", "\n", " Commercial Operation Date Cessation Date Current Cluster \\\n", "0 4/15/2007 NaN ICS-2008-001 Prior Queued \n", "1 1/1/2002 NaN NaN \n", "2 7/1/2007 NaN NaN \n", "3 10/1/2003 NaN ICS-2008-001 Prior Queued \n", "4 1/1/2005 NaN NaN \n", ".. ... ... ... \n", "797 10/1/2025 NaN DISIS-2022-001 \n", "798 3/30/2026 3/31/2023 NaN \n", "799 NaN NaN NaN \n", "800 12/1/2018 NaN Surplus \n", "801 NaN NaN Surplus \n", "\n", " Cluster Group Replacement Generator Commercial Op Date Service Type \n", "0 04 SOUTHEAST NaN ER \n", "1 NaN NaN ER \n", "2 NaN NaN ER \n", "3 04 SOUTHEAST NaN ER \n", "4 NaN NaN ER \n", ".. ... ... ... \n", "797 04 SOUTHEAST NaN ER/NR \n", "798 NaN NaN ERIS \n", "799 NaN 12/31/2027 NRIS \n", "800 NaN NaN ER \n", "801 NaN NaN ER \n", "\n", "[802 rows x 24 columns]" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "spp = gridstatus.SPP()\n", "spp.get_interconnection_queue()" ] }, { "cell_type": "markdown", "id": "2a4a4ad6", "metadata": {}, "source": [ "## Ercot" ] }, { "cell_type": "code", "execution_count": 4, "id": "0d6053a9", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Queue IDProject NameInterconnecting EntityCountyStateInterconnection LocationTransmission OwnerGeneration TypeCapacity (MW)Summer Capacity (MW)...IA SignedAir PermitGHG PermitWater AvailabilityMeets PlanningMeets All PlanningCDR Reporting ZoneApproved for EnergizationApproved for SynchronizationComment
014INR0033Goodnight WindGoodnight WindArmstrongTexastap 345kV 79500 Alibates - 79503 Tule Canyon CKT2NoneWind - Wind Turbine531.00None...2018-03-07Not RequiredNot RequiredNot RequiredNaNNaNPANHANDLENaTNaTNaN
115INR0059Emerald Grove SolarEmerald Grove Solar, LLCPecosTexas76602 Horse Crossing 138kVNoneSolar - Photovoltaic Solar108.00None...2017-12-04Not RequiredNot RequiredNot Required1900-01-01 00:00:002019-04-17 00:00:00WEST2021-12-102022-01-04NaN
215INR0064bHarald (BearKat Wind B)CIPGlasscockTexas59903 Bearkat 345kVNoneWind - Wind Turbine162.10None...2018-05-30Not RequiredNot RequiredNot Required2018-05-30 00:00:002018-09-19 00:00:00WEST2020-02-102020-05-12NaN
316INR0049Nazareth SolarTX Nazareth Solar, LLCCastroTexastap 345kV 23914 Tule Canyon - 23912 Ogallala C2NoneSolar - Photovoltaic Solar204.00None...2018-05-10Not RequiredNot RequiredNot RequiredNaNNaNPANHANDLENaTNaTNaN
416INR0081Mesteno WindMesteno Windpower, LLCStarrTexas80355 Del Sol 345kVNoneWind - Wind Turbine201.60None...2018-04-25Not RequiredNot RequiredNot Required2018-04-25 00:00:002019-03-28 00:00:00SOUTH2019-11-262019-12-12NaN
..................................................................
103326INR0022Bowhead Storage 2Baffin Bay Solar, LLCKlebergTexasTap 138kV 8519 Kleberg-8518 KingsvilleNoneOther - Battery Energy Storage0.00None...NaTNaNNaNNot RequiredNaNNaNCOASTALNaTNaTNaN
103426INR0023Leon Solar ParkMISAE SOLAR IVLeonTexasTap 138kV GRPLMGTA_8 3355 - PLSNTSPG_8\\n3357\\nNoneSolar - Photovoltaic Solar209.00None...NaTNaNNaNNot RequiredNaNNaNNORTHNaTNaTNaN
103526INR0024Becerra Creek Storage 1Bordas Renewable Energy, LLCWebbTexas345 kV Cenizo Substation (#80220)NoneOther - Energy Storage125.62None...NaTNaNNaNNaNNaNNaNSOUTHNaTNaTNaN
103626INR0030Perry Creek Solar SLFPerry Creek Solar, LLCFreestoneTexas345kV Navarro (#68091) to Limestone (# 46020)NoneSolar - Photovoltaic Solar102.04None...NaTNot RequiredNot RequiredNot RequiredNaNNaNNORTHNaTNaTNaN
103727INR0003Becerra Creek Storage 2Bordas Renewable Energy, LLCWebbTexas345 kV Cenizo Substation (#80220)NoneOther - Energy Storage125.62None...NaTNaNNaNNaNNaNNaNSOUTHNaTNaTNaN
\n", "

1038 rows × 35 columns

\n", "
" ], "text/plain": [ " Queue ID Project Name Interconnecting Entity \\\n", "0 14INR0033 Goodnight Wind Goodnight Wind \n", "1 15INR0059 Emerald Grove Solar Emerald Grove Solar, LLC \n", "2 15INR0064b Harald (BearKat Wind B) CIP \n", "3 16INR0049 Nazareth Solar TX Nazareth Solar, LLC \n", "4 16INR0081 Mesteno Wind Mesteno Windpower, LLC \n", "... ... ... ... \n", "1033 26INR0022 Bowhead Storage 2 Baffin Bay Solar, LLC \n", "1034 26INR0023 Leon Solar Park MISAE SOLAR IV \n", "1035 26INR0024 Becerra Creek Storage 1 Bordas Renewable Energy, LLC \n", "1036 26INR0030 Perry Creek Solar SLF Perry Creek Solar, LLC \n", "1037 27INR0003 Becerra Creek Storage 2 Bordas Renewable Energy, LLC \n", "\n", " County State Interconnection Location \\\n", "0 Armstrong Texas tap 345kV 79500 Alibates - 79503 Tule Canyon CKT2 \n", "1 Pecos Texas 76602 Horse Crossing 138kV \n", "2 Glasscock Texas 59903 Bearkat 345kV \n", "3 Castro Texas tap 345kV 23914 Tule Canyon - 23912 Ogallala C2 \n", "4 Starr Texas 80355 Del Sol 345kV \n", "... ... ... ... \n", "1033 Kleberg Texas Tap 138kV 8519 Kleberg-8518 Kingsville \n", "1034 Leon Texas Tap 138kV GRPLMGTA_8 3355 - PLSNTSPG_8\\n3357\\n \n", "1035 Webb Texas 345 kV Cenizo Substation (#80220) \n", "1036 Freestone Texas 345kV Navarro (#68091) to Limestone (# 46020) \n", "1037 Webb Texas 345 kV Cenizo Substation (#80220) \n", "\n", " Transmission Owner Generation Type Capacity (MW) \\\n", "0 None Wind - Wind Turbine 531.00 \n", "1 None Solar - Photovoltaic Solar 108.00 \n", "2 None Wind - Wind Turbine 162.10 \n", "3 None Solar - Photovoltaic Solar 204.00 \n", "4 None Wind - Wind Turbine 201.60 \n", "... ... ... ... \n", "1033 None Other - Battery Energy Storage 0.00 \n", "1034 None Solar - Photovoltaic Solar 209.00 \n", "1035 None Other - Energy Storage 125.62 \n", "1036 None Solar - Photovoltaic Solar 102.04 \n", "1037 None Other - Energy Storage 125.62 \n", "\n", " Summer Capacity (MW) ... IA Signed Air Permit GHG Permit \\\n", "0 None ... 2018-03-07 Not Required Not Required \n", "1 None ... 2017-12-04 Not Required Not Required \n", "2 None ... 2018-05-30 Not Required Not Required \n", "3 None ... 2018-05-10 Not Required Not Required \n", "4 None ... 2018-04-25 Not Required Not Required \n", "... ... ... ... ... ... \n", "1033 None ... NaT NaN NaN \n", "1034 None ... NaT NaN NaN \n", "1035 None ... NaT NaN NaN \n", "1036 None ... NaT Not Required Not Required \n", "1037 None ... NaT NaN NaN \n", "\n", " Water Availability Meets Planning Meets All Planning \\\n", "0 Not Required NaN NaN \n", "1 Not Required 1900-01-01 00:00:00 2019-04-17 00:00:00 \n", "2 Not Required 2018-05-30 00:00:00 2018-09-19 00:00:00 \n", "3 Not Required NaN NaN \n", "4 Not Required 2018-04-25 00:00:00 2019-03-28 00:00:00 \n", "... ... ... ... \n", "1033 Not Required NaN NaN \n", "1034 Not Required NaN NaN \n", "1035 NaN NaN NaN \n", "1036 Not Required NaN NaN \n", "1037 NaN NaN NaN \n", "\n", " CDR Reporting Zone Approved for Energization \\\n", "0 PANHANDLE NaT \n", "1 WEST 2021-12-10 \n", "2 WEST 2020-02-10 \n", "3 PANHANDLE NaT \n", "4 SOUTH 2019-11-26 \n", "... ... ... \n", "1033 COASTAL NaT \n", "1034 NORTH NaT \n", "1035 SOUTH NaT \n", "1036 NORTH NaT \n", "1037 SOUTH NaT \n", "\n", " Approved for Synchronization Comment \n", "0 NaT NaN \n", "1 2022-01-04 NaN \n", "2 2020-05-12 NaN \n", "3 NaT NaN \n", "4 2019-12-12 NaN \n", "... ... ... \n", "1033 NaT NaN \n", "1034 NaT NaN \n", "1035 NaT NaN \n", "1036 NaT NaN \n", "1037 NaT NaN \n", "\n", "[1038 rows x 35 columns]" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ercot = gridstatus.Ercot()\n", "ercot.get_interconnection_queue()" ] }, { "cell_type": "markdown", "id": "82cd60a0", "metadata": {}, "source": [ "## MISO" ] }, { "cell_type": "code", "execution_count": 5, "id": "1a15bbc5", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Queue IDProject NameInterconnecting EntityCountyStateInterconnection LocationTransmission OwnerGeneration TypeCapacity (MW)Summer Capacity (MW)...giaToExecstudyCyclestudyGroupstudyPhasesvcTypedp1ErisMwdp1NrisMwdp2ErisMwdp2NrisMwsisPhase1
0E002NoneNonePointe CoupeeLA500 kV switchyard at Big Cajon IIEntergyGas15.015.0...2013-12-16T05:00:00ZERIS0.00.00.00.0
1E291NoneNoneTXRich 138 kV substationEntergyHydro27.027.0...2013-10-22T04:00:00ZERIS0.00.00.00.0
2G001NoneNoneBrown CountyWIUnknownAmerican Transmission Co. LLC255.0255.0...NoneSPA - SISERIS0.00.00.00.0
3G002NoneNoneTrimble CountyKYUnknownLG&E and KU Services Company as agent for Loui...Coal174.0174.0...NoneERIS0.00.00.00.0
4G003NoneNoneTrimble CountyKYUnknownLG&E and KU Services Company as agent for Loui...Coal174.0174.0...NoneERIS0.00.00.00.0
..................................................................
4248R66NoneNoneAdams CountyIACreston - Clarinda 161 kVMidAmerican Energy CompanyWind150.0150.0...NoneFeasibilityNRIS0.00.00.00.0
4249R67NoneNoneClay CountyIASheldon (Obrien county sub) 345 kVMidAmerican Energy CompanyWind148.8148.8...NoneSPA - SISNRIS0.00.00.00.0
4250R68NoneNoneHancock CountyIAMEC Webster 345 kV SubstationMidAmerican Energy CompanyWind249.6249.6...NoneSPA - SISNRIS0.00.00.00.0
4251Temp3257NoneNoneUnknownEwington Energy Systems, LLC0.00.0...None0.00.00.00.0
4252Test 1234NoneNoneJackson CountyTXtest line 1 - test line 2 138 kVEwington Energy Systems, LLC0.00.0...None125sssMTEP0.00.00.00.0
\n", "

4253 rows × 31 columns

\n", "
" ], "text/plain": [ " Queue ID Project Name Interconnecting Entity County State \\\n", "0 E002 None None Pointe Coupee LA \n", "1 E291 None None TX \n", "2 G001 None None Brown County WI \n", "3 G002 None None Trimble County KY \n", "4 G003 None None Trimble County KY \n", "... ... ... ... ... ... \n", "4248 R66 None None Adams County IA \n", "4249 R67 None None Clay County IA \n", "4250 R68 None None Hancock County IA \n", "4251 Temp3257 None None \n", "4252 Test 1234 None None Jackson County TX \n", "\n", " Interconnection Location \\\n", "0 500 kV switchyard at Big Cajon II \n", "1 Rich 138 kV substation \n", "2 Unknown \n", "3 Unknown \n", "4 Unknown \n", "... ... \n", "4248 Creston - Clarinda 161 kV \n", "4249 Sheldon (Obrien county sub) 345 kV \n", "4250 MEC Webster 345 kV Substation \n", "4251 Unknown \n", "4252 test line 1 - test line 2 138 kV \n", "\n", " Transmission Owner Generation Type \\\n", "0 Entergy Gas \n", "1 Entergy Hydro \n", "2 American Transmission Co. LLC \n", "3 LG&E and KU Services Company as agent for Loui... Coal \n", "4 LG&E and KU Services Company as agent for Loui... Coal \n", "... ... ... \n", "4248 MidAmerican Energy Company Wind \n", "4249 MidAmerican Energy Company Wind \n", "4250 MidAmerican Energy Company Wind \n", "4251 Ewington Energy Systems, LLC \n", "4252 Ewington Energy Systems, LLC \n", "\n", " Capacity (MW) Summer Capacity (MW) ... giaToExec \\\n", "0 15.0 15.0 ... 2013-12-16T05:00:00Z \n", "1 27.0 27.0 ... 2013-10-22T04:00:00Z \n", "2 255.0 255.0 ... None \n", "3 174.0 174.0 ... None \n", "4 174.0 174.0 ... None \n", "... ... ... ... ... \n", "4248 150.0 150.0 ... None \n", "4249 148.8 148.8 ... None \n", "4250 249.6 249.6 ... None \n", "4251 0.0 0.0 ... None \n", "4252 0.0 0.0 ... None \n", "\n", " studyCycle studyGroup studyPhase svcType dp1ErisMw dp1NrisMw dp2ErisMw \\\n", "0 ERIS 0.0 0.0 0.0 \n", "1 ERIS 0.0 0.0 0.0 \n", "2 SPA - SIS ERIS 0.0 0.0 0.0 \n", "3 ERIS 0.0 0.0 0.0 \n", "4 ERIS 0.0 0.0 0.0 \n", "... ... ... ... ... ... ... ... \n", "4248 Feasibility NRIS 0.0 0.0 0.0 \n", "4249 SPA - SIS NRIS 0.0 0.0 0.0 \n", "4250 SPA - SIS NRIS 0.0 0.0 0.0 \n", "4251 0.0 0.0 0.0 \n", "4252 125 sss MTEP 0.0 0.0 0.0 \n", "\n", " dp2NrisMw sisPhase1 \n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "... ... ... \n", "4248 0.0 \n", "4249 0.0 \n", "4250 0.0 \n", "4251 0.0 \n", "4252 0.0 \n", "\n", "[4253 rows x 31 columns]" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "miso = gridstatus.MISO()\n", "miso.get_interconnection_queue()" ] }, { "cell_type": "markdown", "id": "f4b13b0d", "metadata": {}, "source": [ "## ISONE" ] }, { "cell_type": "code", "execution_count": 6, "id": "f33cf66a", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Queue IDProject NameInterconnecting EntityCountyStateInterconnection LocationTransmission OwnerGeneration TypeCapacity (MW)Summer Capacity (MW)...SIS CompleteI39DevZoneFSSISOSFACIAProject Status
01Millennium+K117NoneWorcesterMAW 123 LineNGRIDDFO NGNaNNaN...TrueTrueNaNWMANaNNaNNaNNaNNaNNaN
12EMI-TivertonNoneNewportRINear Tiverton 115 kV SubstationNGRIDNGNaNNaN...TrueTrueNaNSEMANaNNaNNaNNaNNaNNaN
23Androscoggin Energy CenterNoneFranklinMEJay 115 kV SubstationCMPDFO NGNaNNaN...TrueTrueNaNMENaNNaNNaNNaNNaNNaN
34EMI Dighton Power ProjectNoneBristolMAU6 LineNGRIDNGNaNNaN...TrueTrueNaNSEMANaNNaNNaNNaNNaNNaN
45Brayton PtNoneBristolMABrayton Point 345 kV StationNGRIDNaNNaNNaN...TrueTrueNaNRINaNNaNNaNNaNNaNNaN
..................................................................
12961308Uxbridge Substation – NG Hopedale West Group S...NoneWorcesterMANG Feeder 321W6, Uxbridge T2NaNBAT6.9940006.994000...FalseFalsePDSEMANaNNaNNaNNaNNaNNaN
12971310Battery StorageNoneBerkshireMA115 kV Transmission line (1211 - Present betwe...NaNBAT118.750000118.750000...FalseFalsePDWMANaNNaNNaNNaNNaNNaN
12981314Offshore WindNoneNaNMAEversource 115kV Acushnet, lines 112/114NaNWND470.000000470.000000...FalseFalsePDSEMANaNNot StartedNaNNaNNaNUnder Study
12991315Battery StorageNoneWindhamCTEversource Killingly Substation,115kV BUS, Tra...NaNBAT106.970001106.970001...FalseFalsePDCTIn ProgressNaNNaNNaNNaNUnder Study
13001316Solar plus BatteryNoneCheshireNHEversource 115kV line L163NaNSUN BAT102.000000102.000000...FalseFalseNaNNHIn ProgressNaNNaNNaNNaNUnder Study
\n", "

1301 rows × 32 columns

\n", "
" ], "text/plain": [ " Queue ID Project Name \\\n", "0 1 Millennium+K117 \n", "1 2 EMI-Tiverton \n", "2 3 Androscoggin Energy Center \n", "3 4 EMI Dighton Power Project \n", "4 5 Brayton Pt \n", "... ... ... \n", "1296 1308 Uxbridge Substation – NG Hopedale West Group S... \n", "1297 1310 Battery Storage \n", "1298 1314 Offshore Wind \n", "1299 1315 Battery Storage \n", "1300 1316 Solar plus Battery \n", "\n", " Interconnecting Entity County State \\\n", "0 None Worcester MA \n", "1 None Newport RI \n", "2 None Franklin ME \n", "3 None Bristol MA \n", "4 None Bristol MA \n", "... ... ... ... \n", "1296 None Worcester MA \n", "1297 None Berkshire MA \n", "1298 None NaN MA \n", "1299 None Windham CT \n", "1300 None Cheshire NH \n", "\n", " Interconnection Location Transmission Owner \\\n", "0 W 123 Line NGRID \n", "1 Near Tiverton 115 kV Substation NGRID \n", "2 Jay 115 kV Substation CMP \n", "3 U6 Line NGRID \n", "4 Brayton Point 345 kV Station NGRID \n", "... ... ... \n", "1296 NG Feeder 321W6, Uxbridge T2 NaN \n", "1297 115 kV Transmission line (1211 - Present betwe... NaN \n", "1298 Eversource 115kV Acushnet, lines 112/114 NaN \n", "1299 Eversource Killingly Substation,115kV BUS, Tra... NaN \n", "1300 Eversource 115kV line L163 NaN \n", "\n", " Generation Type Capacity (MW) Summer Capacity (MW) ... SIS Complete \\\n", "0 DFO NG NaN NaN ... True \n", "1 NG NaN NaN ... True \n", "2 DFO NG NaN NaN ... True \n", "3 NG NaN NaN ... True \n", "4 NaN NaN NaN ... True \n", "... ... ... ... ... ... \n", "1296 BAT 6.994000 6.994000 ... False \n", "1297 BAT 118.750000 118.750000 ... False \n", "1298 WND 470.000000 470.000000 ... False \n", "1299 BAT 106.970001 106.970001 ... False \n", "1300 SUN BAT 102.000000 102.000000 ... False \n", "\n", " I39 Dev Zone FS SIS OS FAC IA Project Status \n", "0 True NaN WMA NaN NaN NaN NaN NaN NaN \n", "1 True NaN SEMA NaN NaN NaN NaN NaN NaN \n", "2 True NaN ME NaN NaN NaN NaN NaN NaN \n", "3 True NaN SEMA NaN NaN NaN NaN NaN NaN \n", "4 True NaN RI NaN NaN NaN NaN NaN NaN \n", "... ... ... ... ... ... ... ... ... ... \n", "1296 False PD SEMA NaN NaN NaN NaN NaN NaN \n", "1297 False PD WMA NaN NaN NaN NaN NaN NaN \n", "1298 False PD SEMA NaN Not Started NaN NaN NaN Under Study \n", "1299 False PD CT In Progress NaN NaN NaN NaN Under Study \n", "1300 False NaN NH In Progress NaN NaN NaN NaN Under Study \n", "\n", "[1301 rows x 32 columns]" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "isone = gridstatus.ISONE()\n", "isone.get_interconnection_queue()" ] }, { "cell_type": "markdown", "id": "288d5e6e", "metadata": {}, "source": [ "## PJM" ] }, { "cell_type": "code", "execution_count": 7, "id": "8af32a50", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Queue IDProject NameInterconnecting EntityCountyStateInterconnection LocationTransmission OwnerGeneration TypeCapacity (MW)Summer Capacity (MW)...Interim/Interconnection Service Agreement StatusWholesale Market Participation AgreementConstruction Service AgreementConstruction Service Agreement StatusUpgrade Construction Service AgreementUpgrade Construction Service Agreement StatusBackfeed DateLong-Term Firm Service Start DateLong-Term Firm Service End DateTest Energy Date
0A01South Lebanon 230 KVNoneLebanonPANoneMENatural Gas673.0673.0...Document PostedNaNNaNNot RequiredNaNNaNNaNNaNNaNNaN
1A02Oak Hall 138 kV (Oil CT)NoneUnknownVANoneDPLOil311.8315.0...Document PostedNaNNaNNot RequiredNaNNaNNaNNaNNaNNaN
2A03Linden 230 kV or 138 kVNoneUnionNJNonePSEGNatural Gas114.0120.0...Document PostedNaNNaNNot RequiredNaNNaNNaNNaNNaNNaN
3A04Linden 230 kV or 138 kVNoneUnionNJNoneUnknownNatural Gas750.0750.0...Document PostedNaNNaNNot RequiredNaNNaN6/10/2004NaNNaN3/11/2005
4A05BergenNoneBergenNJNonePSEGNatural Gas500.0500.0...Document PostedNaNNaNNot RequiredNaNNaNNaNNaNNaNNaN
..................................................................
8680903384PJM-WECNoneNaNNaNNoneNaNNaN320.0NaN...NaNNaNNaNNaNNaNNaNNaN5/15/20105/31/2011NaN
8681988887PJM-CINNoneNaNNaNNoneNaNNaN20.0NaN...NaNNaNNaNNaNNaNNaNNaN6/1/20096/1/2014NaN
8682994856PJM-TVANoneNaNNaNNoneNaNNaN138.0NaN...NaNNaNNaNNaNNaNNaNNaN2/1/20092/1/2014NaN
8683994857PJM-TVANoneNaNNaNNoneNaNNaN90.0NaN...NaNNaNNaNNaNNaNNaNNaN2/1/20092/1/2014NaN
8684994858PJM-TVANoneNaNNaNNoneNaNNaN90.0NaN...NaNNaNNaNNaNNaNNaNNaN2/1/20092/1/2014NaN
\n", "

8685 rows × 37 columns

\n", "
" ], "text/plain": [ " Queue ID Project Name Interconnecting Entity County State \\\n", "0 A01 South Lebanon 230 KV None Lebanon PA \n", "1 A02 Oak Hall 138 kV (Oil CT) None Unknown VA \n", "2 A03 Linden 230 kV or 138 kV None Union NJ \n", "3 A04 Linden 230 kV or 138 kV None Union NJ \n", "4 A05 Bergen None Bergen NJ \n", "... ... ... ... ... ... \n", "8680 903384 PJM-WEC None NaN NaN \n", "8681 988887 PJM-CIN None NaN NaN \n", "8682 994856 PJM-TVA None NaN NaN \n", "8683 994857 PJM-TVA None NaN NaN \n", "8684 994858 PJM-TVA None NaN NaN \n", "\n", " Interconnection Location Transmission Owner Generation Type \\\n", "0 None ME Natural Gas \n", "1 None DPL Oil \n", "2 None PSEG Natural Gas \n", "3 None Unknown Natural Gas \n", "4 None PSEG Natural Gas \n", "... ... ... ... \n", "8680 None NaN NaN \n", "8681 None NaN NaN \n", "8682 None NaN NaN \n", "8683 None NaN NaN \n", "8684 None NaN NaN \n", "\n", " Capacity (MW) Summer Capacity (MW) ... \\\n", "0 673.0 673.0 ... \n", "1 311.8 315.0 ... \n", "2 114.0 120.0 ... \n", "3 750.0 750.0 ... \n", "4 500.0 500.0 ... \n", "... ... ... ... \n", "8680 320.0 NaN ... \n", "8681 20.0 NaN ... \n", "8682 138.0 NaN ... \n", "8683 90.0 NaN ... \n", "8684 90.0 NaN ... \n", "\n", " Interim/Interconnection Service Agreement Status \\\n", "0 Document Posted \n", "1 Document Posted \n", "2 Document Posted \n", "3 Document Posted \n", "4 Document Posted \n", "... ... \n", "8680 NaN \n", "8681 NaN \n", "8682 NaN \n", "8683 NaN \n", "8684 NaN \n", "\n", " Wholesale Market Participation Agreement Construction Service Agreement \\\n", "0 NaN NaN \n", "1 NaN NaN \n", "2 NaN NaN \n", "3 NaN NaN \n", "4 NaN NaN \n", "... ... ... \n", "8680 NaN NaN \n", "8681 NaN NaN \n", "8682 NaN NaN \n", "8683 NaN NaN \n", "8684 NaN NaN \n", "\n", " Construction Service Agreement Status \\\n", "0 Not Required \n", "1 Not Required \n", "2 Not Required \n", "3 Not Required \n", "4 Not Required \n", "... ... \n", "8680 NaN \n", "8681 NaN \n", "8682 NaN \n", "8683 NaN \n", "8684 NaN \n", "\n", " Upgrade Construction Service Agreement \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "... ... \n", "8680 NaN \n", "8681 NaN \n", "8682 NaN \n", "8683 NaN \n", "8684 NaN \n", "\n", " Upgrade Construction Service Agreement Status Backfeed Date \\\n", "0 NaN NaN \n", "1 NaN NaN \n", "2 NaN NaN \n", "3 NaN 6/10/2004 \n", "4 NaN NaN \n", "... ... ... \n", "8680 NaN NaN \n", "8681 NaN NaN \n", "8682 NaN NaN \n", "8683 NaN NaN \n", "8684 NaN NaN \n", "\n", " Long-Term Firm Service Start Date Long-Term Firm Service End Date \\\n", "0 NaN NaN \n", "1 NaN NaN \n", "2 NaN NaN \n", "3 NaN NaN \n", "4 NaN NaN \n", "... ... ... \n", "8680 5/15/2010 5/31/2011 \n", "8681 6/1/2009 6/1/2014 \n", "8682 2/1/2009 2/1/2014 \n", "8683 2/1/2009 2/1/2014 \n", "8684 2/1/2009 2/1/2014 \n", "\n", " Test Energy Date \n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 3/11/2005 \n", "4 NaN \n", "... ... \n", "8680 NaN \n", "8681 NaN \n", "8682 NaN \n", "8683 NaN \n", "8684 NaN \n", "\n", "[8685 rows x 37 columns]" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pjm = gridstatus.PJM()\n", "pjm.get_interconnection_queue()" ] } ], "metadata": { "file_format": "mystnb", "kernelspec": { "display_name": "python3", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.10.8" }, "source_map": [ 5, 17, 21, 24, 27, 30, 33, 37, 41, 44, 48, 51, 55, 58 ] }, "nbformat": 4, "nbformat_minor": 5 }