{ "cells": [ { "cell_type": "markdown", "id": "29a2d62c", "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": "04674591", "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": "842d152b", "metadata": {}, "source": [ "## CAISO" ] }, { "cell_type": "code", "execution_count": 2, "id": "3a7b22c2", "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
..................................................................
22692183HELIX STORAGENoneSAN DIEGOCASpring Valley Substation 69 kVSDGEStorage80.0None...2021-04-09 00:00:00NaNC142025-11-01 07:00:00NaNNaNNaNFull CapacityOff-Peak DeliverabilityNaN
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 2183 HELIX 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 Spring Valley Substation 69 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 80.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-09 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 2025-11-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 Off-Peak Deliverability \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": "26dd9ece", "metadata": {}, "source": [ "## SPP" ] }, { "cell_type": "code", "execution_count": 3, "id": "ae718327", "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
..................................................................
800GEN-2022-098NoneNoneJohnstonOKBison 345kV SubstationOGESolar200.00200.00...NoneNoneNone3/1/202412/1/2024NaNDISIS-2022-00104 SOUTHEASTNaNER/NR
801GEN-2022-GR1NoneNoneHallsvilleTXPirkey 138 kVNaN580.00580.00...NoneNoneNoneNaN3/30/20263/31/2023NaNNaNNaNERIS
802GEN-2022-GR2NoneNoneHarrahOKNaNNaN400.00400.00...NoneNoneNoneNaNNaNNaNNaNNaN12/31/2027NRIS
803GEN-2022-SR7NoneNoneCampbellNEMacon 345 kV SubstationNaNBattery/Storage210.00210.00...NoneNoneNoneNaN12/1/2018NaNSurplusNaNNaNER
804GEN-2022-SR8NoneNoneCampbellNEMacon 345 kV SubstationNaNSolar210.00210.00...NoneNoneNoneNaNNaNNaNSurplusNaNNaNER
\n", "

805 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", "800 GEN-2022-098 None None Johnston \n", "801 GEN-2022-GR1 None None Hallsville \n", "802 GEN-2022-GR2 None None Harrah \n", "803 GEN-2022-SR7 None None Campbell \n", "804 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", "800 OK Bison 345kV Substation OGE \n", "801 TX Pirkey 138 kV NaN \n", "802 OK NaN NaN \n", "803 NE Macon 345 kV Substation NaN \n", "804 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", "800 Solar 200.00 200.00 ... \n", "801 580.00 580.00 ... \n", "802 400.00 400.00 ... \n", "803 Battery/Storage 210.00 210.00 ... \n", "804 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", "800 None None None 3/1/2024 \n", "801 None None None NaN \n", "802 None None None NaN \n", "803 None None None NaN \n", "804 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", "800 12/1/2024 NaN DISIS-2022-001 \n", "801 3/30/2026 3/31/2023 NaN \n", "802 NaN NaN NaN \n", "803 12/1/2018 NaN Surplus \n", "804 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", "800 04 SOUTHEAST NaN ER/NR \n", "801 NaN NaN ERIS \n", "802 NaN 12/31/2027 NRIS \n", "803 NaN NaN ER \n", "804 NaN NaN ER \n", "\n", "[805 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": "cc940630", "metadata": {}, "source": [ "## Ercot" ] }, { "cell_type": "code", "execution_count": 4, "id": "23fc16d0", "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": "64dd670f", "metadata": {}, "source": [ "## MISO" ] }, { "cell_type": "code", "execution_count": 5, "id": "47d67821", "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.0015.00...2013-12-16T05:00:00ZERIS0.000.000.000.00
1E291NoneNoneTXRich 138 kV substationEntergyHydro27.0027.00...2013-10-22T04:00:00ZERIS0.000.000.000.00
2G001NoneNoneBrown CountyWIUnknownAmerican Transmission Co. LLC255.00255.00...NoneSPA - SISERIS0.000.000.000.00
3G002NoneNoneTrimble CountyKYUnknownLG&E and KU Services Company as agent for Loui...Coal174.00174.00...NoneERIS0.000.000.000.00
4G003NoneNoneTrimble CountyKYUnknownLG&E and KU Services Company as agent for Loui...Coal174.00174.00...NoneERIS0.000.000.000.00
..................................................................
4248J513NoneNoneWhite County255173(17REYNOLDS)Northern Indiana Public Service CompanyWind100.05100.05...2018-08-15T04:00:00ZDPP-2016-AUGCentralGIANRIS100.05100.05100.05100.05
4249J514NoneNoneMarshall CountyIAExisting ITC Midwest Marshalltown substationITC MidwestCombined Cycle65.0030.00...2019-01-23T05:00:00ZDPP-2016-FEBWestGIANRIS65.0030.0030.0030.00
4250J515NoneNoneBenton County,Warren CountyIN345 kV bus in Cayuga substation on north side ...Duke Energy CorporationWind400.00400.00...2017-02-23T05:00:00ZDPP-2016-FEBCentralGIAERIS0.000.000.000.00
4251J516NoneNoneSt. James ParishLAVacherie Substation 230kVEntergySolar100.00100.00...NoneDPP-2016-AUGSouthGIANRIS0.000.000.000.00
4252J517NoneNoneJefferson County, Liberty CountyTXUnknownEntergySolar100.00100.00...NoneFES-2015-NOVFeasibilityNRIS0.000.000.000.00
\n", "

4253 rows × 31 columns

\n", "
" ], "text/plain": [ " Queue ID Project Name Interconnecting Entity \\\n", "0 E002 None None \n", "1 E291 None None \n", "2 G001 None None \n", "3 G002 None None \n", "4 G003 None None \n", "... ... ... ... \n", "4248 J513 None None \n", "4249 J514 None None \n", "4250 J515 None None \n", "4251 J516 None None \n", "4252 J517 None None \n", "\n", " County State \\\n", "0 Pointe Coupee LA \n", "1 TX \n", "2 Brown County WI \n", "3 Trimble County KY \n", "4 Trimble County KY \n", "... ... ... \n", "4248 White County \n", "4249 Marshall County IA \n", "4250 Benton County,Warren County IN \n", "4251 St. James Parish LA \n", "4252 Jefferson County, Liberty 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 255173(17REYNOLDS) \n", "4249 Existing ITC Midwest Marshalltown substation \n", "4250 345 kV bus in Cayuga substation on north side ... \n", "4251 Vacherie Substation 230kV \n", "4252 Unknown \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 Northern Indiana Public Service Company Wind \n", "4249 ITC Midwest Combined Cycle \n", "4250 Duke Energy Corporation Wind \n", "4251 Entergy Solar \n", "4252 Entergy Solar \n", "\n", " Capacity (MW) Summer Capacity (MW) ... giaToExec \\\n", "0 15.00 15.00 ... 2013-12-16T05:00:00Z \n", "1 27.00 27.00 ... 2013-10-22T04:00:00Z \n", "2 255.00 255.00 ... None \n", "3 174.00 174.00 ... None \n", "4 174.00 174.00 ... None \n", "... ... ... ... ... \n", "4248 100.05 100.05 ... 2018-08-15T04:00:00Z \n", "4249 65.00 30.00 ... 2019-01-23T05:00:00Z \n", "4250 400.00 400.00 ... 2017-02-23T05:00:00Z \n", "4251 100.00 100.00 ... None \n", "4252 100.00 100.00 ... None \n", "\n", " studyCycle studyGroup studyPhase svcType dp1ErisMw dp1NrisMw \\\n", "0 ERIS 0.00 0.00 \n", "1 ERIS 0.00 0.00 \n", "2 SPA - SIS ERIS 0.00 0.00 \n", "3 ERIS 0.00 0.00 \n", "4 ERIS 0.00 0.00 \n", "... ... ... ... ... ... ... \n", "4248 DPP-2016-AUG Central GIA NRIS 100.05 100.05 \n", "4249 DPP-2016-FEB West GIA NRIS 65.00 30.00 \n", "4250 DPP-2016-FEB Central GIA ERIS 0.00 0.00 \n", "4251 DPP-2016-AUG South GIA NRIS 0.00 0.00 \n", "4252 FES-2015-NOV Feasibility NRIS 0.00 0.00 \n", "\n", " dp2ErisMw dp2NrisMw sisPhase1 \n", "0 0.00 0.00 \n", "1 0.00 0.00 \n", "2 0.00 0.00 \n", "3 0.00 0.00 \n", "4 0.00 0.00 \n", "... ... ... ... \n", "4248 100.05 100.05 \n", "4249 30.00 30.00 \n", "4250 0.00 0.00 \n", "4251 0.00 0.00 \n", "4252 0.00 0.00 \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": "0564a9b4", "metadata": {}, "source": [ "## ISONE" ] }, { "cell_type": "code", "execution_count": 6, "id": "a856a722", "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...FalseFalsePDCTNaNNaNNaNNaNNaNNaN
13001316Solar plus BatteryNoneCheshireNHEversource 115kV line L163NaNSUN BAT102.000000102.000000...FalseFalseNaNNHNaNNaNNaNNaNNaNNaN
\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 NaN NaN NaN NaN NaN NaN \n", "1300 False NaN NH NaN NaN NaN NaN NaN NaN \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": "ebdfaec1", "metadata": {}, "source": [ "## PJM" ] }, { "cell_type": "code", "execution_count": 7, "id": "081ef89e", "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
..................................................................
8677903384PJM-WECNoneNaNNaNNoneNaNNaN320.0NaN...NaNNaNNaNNaNNaNNaNNaN5/15/20105/31/2011NaN
8678988887PJM-CINNoneNaNNaNNoneNaNNaN20.0NaN...NaNNaNNaNNaNNaNNaNNaN6/1/20096/1/2014NaN
8679994856PJM-TVANoneNaNNaNNoneNaNNaN138.0NaN...NaNNaNNaNNaNNaNNaNNaN2/1/20092/1/2014NaN
8680994857PJM-TVANoneNaNNaNNoneNaNNaN90.0NaN...NaNNaNNaNNaNNaNNaNNaN2/1/20092/1/2014NaN
8681994858PJM-TVANoneNaNNaNNoneNaNNaN90.0NaN...NaNNaNNaNNaNNaNNaNNaN2/1/20092/1/2014NaN
\n", "

8682 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", "8677 903384 PJM-WEC None NaN NaN \n", "8678 988887 PJM-CIN None NaN NaN \n", "8679 994856 PJM-TVA None NaN NaN \n", "8680 994857 PJM-TVA None NaN NaN \n", "8681 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", "8677 None NaN NaN \n", "8678 None NaN NaN \n", "8679 None NaN NaN \n", "8680 None NaN NaN \n", "8681 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", "8677 320.0 NaN ... \n", "8678 20.0 NaN ... \n", "8679 138.0 NaN ... \n", "8680 90.0 NaN ... \n", "8681 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", "8677 NaN \n", "8678 NaN \n", "8679 NaN \n", "8680 NaN \n", "8681 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", "8677 NaN NaN \n", "8678 NaN NaN \n", "8679 NaN NaN \n", "8680 NaN NaN \n", "8681 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", "8677 NaN \n", "8678 NaN \n", "8679 NaN \n", "8680 NaN \n", "8681 NaN \n", "\n", " Upgrade Construction Service Agreement \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "... ... \n", "8677 NaN \n", "8678 NaN \n", "8679 NaN \n", "8680 NaN \n", "8681 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", "8677 NaN NaN \n", "8678 NaN NaN \n", "8679 NaN NaN \n", "8680 NaN NaN \n", "8681 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", "8677 5/15/2010 5/31/2011 \n", "8678 6/1/2009 6/1/2014 \n", "8679 2/1/2009 2/1/2014 \n", "8680 2/1/2009 2/1/2014 \n", "8681 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", "8677 NaN \n", "8678 NaN \n", "8679 NaN \n", "8680 NaN \n", "8681 NaN \n", "\n", "[8682 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 }