{ "cells": [ { "cell_type": "markdown", "id": "c7315d0f", "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": "a5dd3bd3", "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
..................................................................
1421583FultonErie Boulevard Hydropower, LPOswegoNYFay St. 34.5kVNM-NGHydro1.31.3...NaNNaN3/31/182023-08-012023-09-013/31/18C14FS2017-07-12 00:00:00
14220696Swinging 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
14230701KCE 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
14240731Branscomb 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
14250781Marcy 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", "

1426 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", "1421 583 Fulton \n", "1422 0696 Swinging Bridge Unit 3 \n", "1423 0701 KCE NY 1 \n", "1424 0731 Branscomb Solar \n", "1425 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", "1421 Erie Boulevard Hydropower, LP Oswego NY \n", "1422 Eagle Creek Hydro Power, LLC Orange NY \n", "1423 KCE NY 1, LLC Saratoga NY \n", "1424 Branscomb Solar, LLC Washington NY \n", "1425 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", "1421 Fay St. 34.5kV NM-NG Hydro \n", "1422 Swing Bridge 69 kV O&R Hydro \n", "1423 Luther - Forest Substation 34.5kV NYSEG Energy Storage \n", "1424 Battenkill - Eastover 115kV NM-NG Solar \n", "1425 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", "1421 1.3 1.3 ... NaN \n", "1422 1.2 1.2 ... NaN \n", "1423 20.0 20.0 ... NaN \n", "1424 20.0 20.0 ... NaN \n", "1425 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", "1421 NaN 3/31/18 2023-08-01 \n", "1422 NaN 2020-04-30 00:00:00 2023-11-01 \n", "1423 NaN 2020-04-30 00:00:00 2023-07-01 \n", "1424 NaN 2022-03-31 00:00:00 2023-08-01 \n", "1425 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", "1421 2023-09-01 3/31/18 C 14 \n", "1422 2023-11-01 2020-04-30 00:00:00 G 14 \n", "1423 2023-07-01 2020-04-30 00:00:00 F 14 \n", "1424 2023-10-01 2022-03-31 00:00:00 F 14 \n", "1425 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", "1421 FS 2017-07-12 00:00:00 \n", "1422 NaN 2018-06-20 00:00:00 \n", "1423 NaN 2018-06-20 00:00:00 \n", "1424 FES, SIS, FS 2020-04-29 00:00:00 \n", "1425 SIS NaN \n", "\n", "[1426 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": "c9fc3088", "metadata": {}, "source": [ "## CAISO" ] }, { "cell_type": "code", "execution_count": 2, "id": "8769f9cf", "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
032TULE WINDNoneSAN DIEGOCABoulevard East Substation 138 kVSDGEWind Turbine193.8None...2004-05-12 00:00:00ExecutedSerial LGIP2007-09-01 07:00:00CompleteCompleteNonePartial CapacityOff-Peak DeliverabilityWaived
172LAKE 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
2138SANDSTORM 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
3146DESERT SUNLIGHT PV INoneRIVERSIDECARed Bluff Substation 230kVSCEPhotovoltaic + Storage250.0None...2006-11-16 00:00:00ExecutedSerial LGIP2008-12-01 08:00:00CompleteCompleteNonePartial CapacityOff-Peak DeliverabilityRequired
4147DESERT SUNLIGHT PV IINoneRIVERSIDECARed Bluff Substation 230kVSCEPhotovoltaic + Storage300.0None...2006-11-16 00:00:00ExecutedSerial LGIP2010-02-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 32 TULE WIND \n", "1 72 LAKE ELSINORE ADVANCED PUMPED STORAGE PROJECT \n", "2 138 SANDSTORM WIND POWER \n", "3 146 DESERT SUNLIGHT PV I \n", "4 147 DESERT SUNLIGHT PV II \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 SAN DIEGO CA \n", "1 None RIVERSIDE 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 Boulevard East Substation 138 kV SDGE \n", "1 Proposed Lee Lake Substation 500 kV SDGE \n", "2 Devers - San Bernardino 230 kV line SCE \n", "3 Red Bluff Substation 230kV 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 193.8 None ... \n", "1 Storage 500.0 None ... \n", "2 Wind Turbine + Storage 150.0 None ... \n", "3 Photovoltaic + Storage 250.0 None ... \n", "4 Photovoltaic + Storage 300.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 2004-05-12 00:00:00 Executed \n", "1 2005-04-26 00:00:00 Executed \n", "2 2006-10-23 00:00:00 Executed \n", "3 2006-11-16 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 Serial LGIP 2007-09-01 07:00:00 \n", "1 Serial LGIP 2008-12-31 08:00:00 \n", "2 Serial LGIP 2008-12-31 08:00:00 \n", "3 Serial LGIP 2008-12-01 08:00:00 \n", "4 Serial LGIP 2010-02-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 None \n", "1 Re-Study None \n", "2 Complete 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 Partial Capacity \n", "1 Full Capacity \n", "2 Partial 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 NaN \n", "2 Off-Peak Deliverability \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 Waived \n", "1 Waived \n", "2 Waived \n", "3 Required \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": "834bfe17", "metadata": {}, "source": [ "## SPP" ] }, { "cell_type": "code", "execution_count": 3, "id": "62bc7481", "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
..................................................................
801GEN-2022-097NoneNoneRosebud and ClusterMontana230 kV gen-tie line (Miles City 2 - Rosebud Cr...WAPAWind400.00408.00...NoneNoneNone12/1/202610/1/2027NaNDISIS-2022-00101 NORTHNaNNR
802GEN-2022-GR1NoneNoneHallsvilleTXPirkey 138 kVNaN580.00580.00...NoneNoneNoneNaN3/30/20263/31/2023NaNNaNNaNERIS
803GEN-2022-GR2NoneNoneHarrahOKNaNNaN400.00400.00...NoneNoneNoneNaNNaNNaNNaNNaN12/31/2027NRIS
804GEN-2022-SR7NoneNoneCampbellNEMacon 345 kV SubstationNaNBattery/Storage210.00210.00...NoneNoneNoneNaN12/1/2018NaNSurplusNaNNaNER
805GEN-2022-SR8NoneNoneCampbellNEMacon 345 kV SubstationNaNSolar210.00210.00...NoneNoneNoneNaNNaNNaNSurplusNaNNaNER
\n", "

806 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", "801 GEN-2022-097 None None Rosebud and Cluster \n", "802 GEN-2022-GR1 None None Hallsville \n", "803 GEN-2022-GR2 None None Harrah \n", "804 GEN-2022-SR7 None None Campbell \n", "805 GEN-2022-SR8 None None Campbell \n", "\n", " State Interconnection Location \\\n", "0 OK Ft Supply 138kV \n", "1 KS Chanute NW Neosho Cnty By Tioga Sub \n", "2 AR SWEPCO Tontitown 161kV Substation \n", "3 OK Washita 138kV \n", "4 NE NaN \n", ".. ... ... \n", "801 Montana 230 kV gen-tie line (Miles City 2 - Rosebud Cr... \n", "802 TX Pirkey 138 kV \n", "803 OK NaN \n", "804 NE Macon 345 kV Substation \n", "805 NE Macon 345 kV Substation \n", "\n", " Transmission Owner Generation Type Capacity (MW) Summer Capacity (MW) \\\n", "0 WFEC Wind 94.50 94.50 \n", "1 WERE Thermal - Gas 47.00 47.00 \n", "2 AEP Thermal - CT 630.00 580.00 \n", "3 WFEC Wind 74.25 74.25 \n", "4 NPPD Thermal - Gas 250.00 250.00 \n", ".. ... ... ... ... \n", "801 WAPA Wind 400.00 408.00 \n", "802 NaN 580.00 580.00 \n", "803 NaN 400.00 400.00 \n", "804 NaN Battery/Storage 210.00 210.00 \n", "805 NaN Solar 210.00 210.00 \n", "\n", " ... Withdrawn Date Withdrawal Comment Actual Completion Date \\\n", "0 ... None None None \n", "1 ... None None None \n", "2 ... None None None \n", "3 ... None None None \n", "4 ... None None None \n", ".. ... ... ... ... \n", "801 ... None None None \n", "802 ... None None None \n", "803 ... None None None \n", "804 ... None None None \n", "805 ... None None None \n", "\n", " In-Service Date Commercial Operation Date Cessation Date \\\n", "0 6/30/2007 4/15/2007 NaN \n", "1 1/1/2002 1/1/2002 NaN \n", "2 5/1/2007 7/1/2007 NaN \n", "3 10/1/2003 10/1/2003 NaN \n", "4 1/1/2005 1/1/2005 NaN \n", ".. ... ... ... \n", "801 12/1/2026 10/1/2027 NaN \n", "802 NaN 3/30/2026 3/31/2023 \n", "803 NaN NaN NaN \n", "804 NaN 12/1/2018 NaN \n", "805 NaN NaN NaN \n", "\n", " Current Cluster Cluster Group \\\n", "0 ICS-2008-001 Prior Queued 04 SOUTHEAST \n", "1 NaN NaN \n", "2 NaN NaN \n", "3 ICS-2008-001 Prior Queued 04 SOUTHEAST \n", "4 NaN NaN \n", ".. ... ... \n", "801 DISIS-2022-001 01 NORTH \n", "802 NaN NaN \n", "803 NaN NaN \n", "804 Surplus NaN \n", "805 Surplus NaN \n", "\n", " Replacement Generator Commercial Op Date Service Type \n", "0 NaN ER \n", "1 NaN ER \n", "2 NaN ER \n", "3 NaN ER \n", "4 NaN ER \n", ".. ... ... \n", "801 NaN NR \n", "802 NaN ERIS \n", "803 12/31/2027 NRIS \n", "804 NaN ER \n", "805 NaN ER \n", "\n", "[806 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": "e18e4f68", "metadata": {}, "source": [ "## Ercot" ] }, { "cell_type": "code", "execution_count": 4, "id": "fc255bd9", "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": "88f7f973", "metadata": {}, "source": [ "## MISO" ] }, { "cell_type": "code", "execution_count": 5, "id": "7f44998a", "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
..................................................................
4247R66NoneNoneAdams CountyIACreston - Clarinda 161 kVMidAmerican Energy CompanyWind150.0150.0...NoneFeasibilityNRIS0.00.00.00.0
4248R67NoneNoneClay CountyIASheldon (Obrien county sub) 345 kVMidAmerican Energy CompanyWind148.8148.8...NoneSPA - SISNRIS0.00.00.00.0
4249R68NoneNoneHancock CountyIAMEC Webster 345 kV SubstationMidAmerican Energy CompanyWind249.6249.6...NoneSPA - SISNRIS0.00.00.00.0
4250Temp3257NoneNoneUnknownEwington Energy Systems, LLC0.00.0...None0.00.00.00.0
4251Test 1234NoneNoneJackson CountyTXtest line 1 - test line 2 138 kVEwington Energy Systems, LLC0.00.0...None125sssMTEP0.00.00.00.0
\n", "

4252 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", "4247 R66 None None Adams County IA \n", "4248 R67 None None Clay County IA \n", "4249 R68 None None Hancock County IA \n", "4250 Temp3257 None None \n", "4251 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", "4247 Creston - Clarinda 161 kV \n", "4248 Sheldon (Obrien county sub) 345 kV \n", "4249 MEC Webster 345 kV Substation \n", "4250 Unknown \n", "4251 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", "4247 MidAmerican Energy Company Wind \n", "4248 MidAmerican Energy Company Wind \n", "4249 MidAmerican Energy Company Wind \n", "4250 Ewington Energy Systems, LLC \n", "4251 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", "4247 150.0 150.0 ... None \n", "4248 148.8 148.8 ... None \n", "4249 249.6 249.6 ... None \n", "4250 0.0 0.0 ... None \n", "4251 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", "4247 Feasibility NRIS 0.0 0.0 0.0 \n", "4248 SPA - SIS NRIS 0.0 0.0 0.0 \n", "4249 SPA - SIS NRIS 0.0 0.0 0.0 \n", "4250 0.0 0.0 0.0 \n", "4251 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", "4247 0.0 \n", "4248 0.0 \n", "4249 0.0 \n", "4250 0.0 \n", "4251 0.0 \n", "\n", "[4252 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": "35119432", "metadata": {}, "source": [ "## ISONE" ] }, { "cell_type": "code", "execution_count": 6, "id": "a984810e", "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...FalseFalsePDSEMANaNNaNNaNNaNNaNNaN
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 NaN NaN NaN NaN NaN \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": "404c0524", "metadata": {}, "source": [ "## PJM" ] }, { "cell_type": "code", "execution_count": 7, "id": "59f4603e", "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 }