{ "cells": [ { "cell_type": "markdown", "id": "fdc3d465", "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": "38021cb5", "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-Sync DateLast Updated DateZSAvailability of StudiesSGIA Tender Date
00276Homer Solar Energy CenterNaNCortlandNYNaNNM-NGSolar90.090.0...NaNNaNNaNNaT2023-09-019/30/2022C10.0FES, SRIS, FSNaN
10393Berrians East ReplacementNaNQueensNYNaNCONEDDual Fuel94.294.2...NaNNaNNaNNaT2024-08-016/30/2022J11.0FES, SRIS, FSNaN
20396Baron WindsNaNSteubenNYNaNNYSEGWind238.4238.4...NaNNaNNaNNaT2022-11-2912/31/2022C13.0FES, SRIS, FSNaN
30396AWood Street TransformerNaNPutnamNYNaNNYSEGAC Transmission0.0NaN...NaNNaNNaNNaTNaT4/30/2021G12.0SISNaN
40422Eight Point Wind Energy CenterNaNSteuben-AlleganyNYNaNNYSEGWind101.8101.8...NaNNaNNaNNaT2022-11-013/31/2021C12.0FES, SRIS, FSNaN
..................................................................
1464583FultonNaNOswegoNYNaNNM-NGHydro1.31.3...NaNNaN3/31/18NaTNaT3/31/18C14FS2017-07-12 00:00:00
14650696Swinging Bridge Unit 3NaNOrangeNYNaNO&RHydro1.21.2...NaNNaN2020-04-30 00:00:00NaTNaT2020-04-30 00:00:00G14NaN2018-06-20 00:00:00
14660701KCE NY 1NaNSaratogaNYNaNNYSEGEnergy Storage20.020.0...NaNNaN2020-04-30 00:00:00NaTNaT2020-04-30 00:00:00F14NaN2018-06-20 00:00:00
14670731Branscomb SolarNaNWashingtonNYNaNNM-NGSolar20.020.0...NaNNaN2022-03-31 00:00:00NaTNaT2022-03-31 00:00:00F14FES, SIS, FS2020-04-29 00:00:00
14680781Marcy South SSR DetectionNaNDelawareNYNaNNYPAAC Transmission0.0NaN...NaNNaN2020-04-30 00:00:00NaTNaT2020-04-30 00:00:00E14SISNaN
\n", "

1469 rows × 24 columns

\n", "
" ], "text/plain": [ " Queue ID Project Name Interconnecting Entity \\\n", "0 0276 Homer Solar Energy Center NaN \n", "1 0393 Berrians East Replacement NaN \n", "2 0396 Baron Winds NaN \n", "3 0396A Wood Street Transformer NaN \n", "4 0422 Eight Point Wind Energy Center NaN \n", "... ... ... ... \n", "1464 583 Fulton NaN \n", "1465 0696 Swinging Bridge Unit 3 NaN \n", "1466 0701 KCE NY 1 NaN \n", "1467 0731 Branscomb Solar NaN \n", "1468 0781 Marcy South SSR Detection NaN \n", "\n", " County State Interconnection Location Transmission Owner \\\n", "0 Cortland NY NaN NM-NG \n", "1 Queens NY NaN CONED \n", "2 Steuben NY NaN NYSEG \n", "3 Putnam NY NaN NYSEG \n", "4 Steuben-Allegany NY NaN NYSEG \n", "... ... ... ... ... \n", "1464 Oswego NY NaN NM-NG \n", "1465 Orange NY NaN O&R \n", "1466 Saratoga NY NaN NYSEG \n", "1467 Washington NY NaN NM-NG \n", "1468 Delaware NY NaN NYPA \n", "\n", " Generation Type Capacity (MW) Summer Capacity (MW) ... Withdrawn Date \\\n", "0 Solar 90.0 90.0 ... NaN \n", "1 Dual Fuel 94.2 94.2 ... NaN \n", "2 Wind 238.4 238.4 ... NaN \n", "3 AC Transmission 0.0 NaN ... NaN \n", "4 Wind 101.8 101.8 ... NaN \n", "... ... ... ... ... ... \n", "1464 Hydro 1.3 1.3 ... NaN \n", "1465 Hydro 1.2 1.2 ... NaN \n", "1466 Energy Storage 20.0 20.0 ... NaN \n", "1467 Solar 20.0 20.0 ... NaN \n", "1468 AC Transmission 0.0 NaN ... NaN \n", "\n", " Withdrawal Comment Actual Completion Date Proposed In-Service \\\n", "0 NaN NaN NaT \n", "1 NaN NaN NaT \n", "2 NaN NaN NaT \n", "3 NaN NaN NaT \n", "4 NaN NaN NaT \n", "... ... ... ... \n", "1464 NaN 3/31/18 NaT \n", "1465 NaN 2020-04-30 00:00:00 NaT \n", "1466 NaN 2020-04-30 00:00:00 NaT \n", "1467 NaN 2022-03-31 00:00:00 NaT \n", "1468 NaN 2020-04-30 00:00:00 NaT \n", "\n", " Proposed Initial-Sync Date Last Updated Date Z S \\\n", "0 2023-09-01 9/30/2022 C 10.0 \n", "1 2024-08-01 6/30/2022 J 11.0 \n", "2 2022-11-29 12/31/2022 C 13.0 \n", "3 NaT 4/30/2021 G 12.0 \n", "4 2022-11-01 3/31/2021 C 12.0 \n", "... ... ... .. ... \n", "1464 NaT 3/31/18 C 14 \n", "1465 NaT 2020-04-30 00:00:00 G 14 \n", "1466 NaT 2020-04-30 00:00:00 F 14 \n", "1467 NaT 2022-03-31 00:00:00 F 14 \n", "1468 NaT 2020-04-30 00:00:00 E 14 \n", "\n", " Availability of Studies SGIA Tender Date \n", "0 FES, SRIS, FS NaN \n", "1 FES, SRIS, FS NaN \n", "2 FES, SRIS, FS NaN \n", "3 SIS NaN \n", "4 FES, SRIS, FS NaN \n", "... ... ... \n", "1464 FS 2017-07-12 00:00:00 \n", "1465 NaN 2018-06-20 00:00:00 \n", "1466 NaN 2018-06-20 00:00:00 \n", "1467 FES, SIS, FS 2020-04-29 00:00:00 \n", "1468 SIS NaN \n", "\n", "[1469 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": "d1e28ad9", "metadata": {}, "source": [ "## CAISO" ] }, { "cell_type": "code", "execution_count": 2, "id": "ab346eb6", "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
..................................................................
22702189LA FUENTE ENERGY STORAGENoneSAN DIEGOCAOtay Mesa Switchyard 230 kVSDGEStorage100.0None...2021-04-14 00:00:00NaNC142024-06-01 07:00:00NaNNaNNaNFull CapacityNaNNaN
22712190HERMES ENERGY STORAGENoneSAN DIEGOCABorder Substation 69 kVSDGEStorage150.0None...2021-04-15 00:00:00NaNC142024-06-01 07:00:00NaNNaNNaNFull CapacityOff-Peak DeliverabilityNaN
22722191FREIGHT ENERGY STORAGENoneSAN DIEGOCABorder Substation 69 kVSDGEStorage50.0None...2021-04-15 00:00:00NaNC142025-06-01 07:00:00NaNNaNNaNFull CapacityNaNNaN
22732193VENTANA ENERGY STORAGENoneSAN BERNARDINOCALugoSCEStorage250.0None...2021-11-19 00:00:00NaNISP2024-06-01 07:00:00NaNNaNNaNFull CapacityOff-Peak DeliverabilityNaN
22742194PRONGHORN ENERGY STORAGENoneLOS ANGELESCAAntelopeSCEStorage120.0None...2022-05-07 00:00:00NaNISP2026-06-01 07:00:00NaNNaNNaNFull CapacityOff-Peak DeliverabilityNaN
\n", "

2275 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", "2270 2189 LA FUENTE ENERGY STORAGE \n", "2271 2190 HERMES ENERGY STORAGE \n", "2272 2191 FREIGHT ENERGY STORAGE \n", "2273 2193 VENTANA ENERGY STORAGE \n", "2274 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", "2270 None SAN DIEGO CA \n", "2271 None SAN DIEGO CA \n", "2272 None SAN DIEGO CA \n", "2273 None SAN BERNARDINO CA \n", "2274 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", "2270 Otay Mesa Switchyard 230 kV SDGE \n", "2271 Border Substation 69 kV SDGE \n", "2272 Border Substation 69 kV SDGE \n", "2273 Lugo SCE \n", "2274 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", "2270 Storage 100.0 None ... \n", "2271 Storage 150.0 None ... \n", "2272 Storage 50.0 None ... \n", "2273 Storage 250.0 None ... \n", "2274 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", "2270 2021-04-14 00:00:00 NaN \n", "2271 2021-04-15 00:00:00 NaN \n", "2272 2021-04-15 00:00:00 NaN \n", "2273 2021-11-19 00:00:00 NaN \n", "2274 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", "2270 C14 2024-06-01 07:00:00 \n", "2271 C14 2024-06-01 07:00:00 \n", "2272 C14 2025-06-01 07:00:00 \n", "2273 ISP 2024-06-01 07:00:00 \n", "2274 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", "2270 NaN \n", "2271 NaN \n", "2272 NaN \n", "2273 NaN \n", "2274 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", "2270 NaN NaN \n", "2271 NaN NaN \n", "2272 NaN NaN \n", "2273 NaN NaN \n", "2274 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", "2270 Full Capacity \n", "2271 Full Capacity \n", "2272 Full Capacity \n", "2273 Full Capacity \n", "2274 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", "2270 NaN \n", "2271 Off-Peak Deliverability \n", "2272 NaN \n", "2273 Off-Peak Deliverability \n", "2274 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", "2270 NaN \n", "2271 NaN \n", "2272 NaN \n", "2273 NaN \n", "2274 NaN \n", "\n", "[2275 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": "40faf3e4", "metadata": {}, "source": [ "## SPP" ] }, { "cell_type": "code", "execution_count": 3, "id": "aa6bb1ff", "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-2023-SR7NoneNoneNaNNaNHoskins 345 kV SubstationNaNBattery/Storage100.80100.80...NoneNoneNoneNaNNaNNaNSurplusNaNNaNER
1GEN-2023-SR6NoneNoneNaNNaNHoskins 345 kV SubstationNaNSolar100.24100.24...NoneNoneNoneNaNNaNNaNSurplusNaNNaNER
2GEN-2023-SR5NoneNoneSeilingOKTatonga 345 kV SubstationNaNBattery/Storage85.0085.00...NoneNoneNoneNaN12/31/2022NaNSurplusNaNNaNER
3GEN-2023-SR4NoneNoneBurkeNDTande 345 kV SubstationBEPCBattery/Storage104.40104.40...NoneNoneNone11/30/2022NaNNaNSurplusNaNNaNER
4GEN-2023-SR3NoneNoneBlackwellOKNardin 69 kV SubstationNaNBattery/Storage50.0050.00...NoneNoneNoneNaN12/31/2022NaNSurplusNaNNaNER
..................................................................
800GEN-2001-029NNoneNoneBeatriceNENaNNPPDThermal - Gas250.00250.00...NoneNoneNone1/1/20051/1/2005NaNNaNNaNNaNER
801GEN-2001-026NoneNoneMeersOKWashita 138kVWFECWind74.2574.25...NoneNoneNone10/1/200310/1/2003NaNICS-2008-001 Prior Queued04 SOUTHEASTNaNER
802GEN-2001-024NoneNoneWashington CountyARSWEPCO Tontitown 161kV SubstationAEPThermal - CT630.00580.00...NoneNoneNone5/1/20077/1/2007NaNNaNNaNNaNER
803GEN-2001-018NoneNoneNeosho CountyKSChanute NW Neosho Cnty By Tioga SubWEREThermal - Gas47.0047.00...NoneNoneNone1/1/20021/1/2002NaNNaNNaNNaNER
804GEN-2001-014NoneNoneSleeping BearOKFt Supply 138kVWFECWind94.5094.50...NoneNoneNone6/30/20074/15/2007NaNICS-2008-001 Prior Queued04 SOUTHEASTNaNER
\n", "

805 rows × 24 columns

\n", "
" ], "text/plain": [ " Queue ID Project Name Interconnecting Entity County \\\n", "0 GEN-2023-SR7 None None NaN \n", "1 GEN-2023-SR6 None None NaN \n", "2 GEN-2023-SR5 None None Seiling \n", "3 GEN-2023-SR4 None None Burke \n", "4 GEN-2023-SR3 None None Blackwell \n", ".. ... ... ... ... \n", "800 GEN-2001-029N None None Beatrice \n", "801 GEN-2001-026 None None Meers \n", "802 GEN-2001-024 None None Washington County \n", "803 GEN-2001-018 None None Neosho County \n", "804 GEN-2001-014 None None Sleeping Bear \n", "\n", " State Interconnection Location Transmission Owner \\\n", "0 NaN Hoskins 345 kV Substation NaN \n", "1 NaN Hoskins 345 kV Substation NaN \n", "2 OK Tatonga 345 kV Substation NaN \n", "3 ND Tande 345 kV Substation BEPC \n", "4 OK Nardin 69 kV Substation NaN \n", ".. ... ... ... \n", "800 NE NaN NPPD \n", "801 OK Washita 138kV WFEC \n", "802 AR SWEPCO Tontitown 161kV Substation AEP \n", "803 KS Chanute NW Neosho Cnty By Tioga Sub WERE \n", "804 OK Ft Supply 138kV WFEC \n", "\n", " Generation Type Capacity (MW) Summer Capacity (MW) ... \\\n", "0 Battery/Storage 100.80 100.80 ... \n", "1 Solar 100.24 100.24 ... \n", "2 Battery/Storage 85.00 85.00 ... \n", "3 Battery/Storage 104.40 104.40 ... \n", "4 Battery/Storage 50.00 50.00 ... \n", ".. ... ... ... ... \n", "800 Thermal - Gas 250.00 250.00 ... \n", "801 Wind 74.25 74.25 ... \n", "802 Thermal - CT 630.00 580.00 ... \n", "803 Thermal - Gas 47.00 47.00 ... \n", "804 Wind 94.50 94.50 ... \n", "\n", " Withdrawn Date Withdrawal Comment Actual Completion Date In-Service Date \\\n", "0 None None None NaN \n", "1 None None None NaN \n", "2 None None None NaN \n", "3 None None None 11/30/2022 \n", "4 None None None NaN \n", ".. ... ... ... ... \n", "800 None None None 1/1/2005 \n", "801 None None None 10/1/2003 \n", "802 None None None 5/1/2007 \n", "803 None None None 1/1/2002 \n", "804 None None None 6/30/2007 \n", "\n", " Commercial Operation Date Cessation Date Current Cluster \\\n", "0 NaN NaN Surplus \n", "1 NaN NaN Surplus \n", "2 12/31/2022 NaN Surplus \n", "3 NaN NaN Surplus \n", "4 12/31/2022 NaN Surplus \n", ".. ... ... ... \n", "800 1/1/2005 NaN NaN \n", "801 10/1/2003 NaN ICS-2008-001 Prior Queued \n", "802 7/1/2007 NaN NaN \n", "803 1/1/2002 NaN NaN \n", "804 4/15/2007 NaN ICS-2008-001 Prior Queued \n", "\n", " Cluster Group Replacement Generator Commercial Op Date Service Type \n", "0 NaN NaN ER \n", "1 NaN NaN ER \n", "2 NaN NaN ER \n", "3 NaN NaN ER \n", "4 NaN NaN ER \n", ".. ... ... ... \n", "800 NaN NaN ER \n", "801 04 SOUTHEAST NaN ER \n", "802 NaN NaN ER \n", "803 NaN NaN ER \n", "804 04 SOUTHEAST 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": "654dbe5a", "metadata": {}, "source": [ "## Ercot" ] }, { "cell_type": "code", "execution_count": 4, "id": "f0235c0d", "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 WindFGE Goodnight I, LLCArmstrongTexastap 345kV 79500 Alibates - 79503 Tule Canyon CKT2NoneWind - Wind Turbine531.00None...2019-08-18Not 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
..................................................................
107827INR0003Becerra Creek Storage 2Bordas Renewable Energy, LLCWebbTexas345 kV Cenizo Substation (#80220)NoneOther - Energy Storage125.62None...NaTNaNNaNNaNNaNNaNSOUTHNaTNaTNaN
107927INR0004Dundee North WindFelix 2, LLCWilbargerTexas345 kV Riley Substation (#6101); AEPNoneWind - Wind Turbine307.72None...NaTNaNNaNNot RequiredNaNNaNWESTNaTNaTNaN
108027INR0005Dundee South A WindFelix 2, LLCBaylorTexas345 kV Riley Substation (#6101); AEPNoneWind - Wind Turbine307.23None...NaTNaNNaNNot RequiredNaNNaNWESTNaTNaTNaN
108127INR0007Felix East SolarFelix 1, LLCWilbargerTexasThe 345 kV Riley Substation (#6101); AEPNoneSolar - Photovoltaic Solar301.44None...NaTNaNNaNNot RequiredNaNNaNWESTNaTNaTNaN
108227INR0009Felix StorageFelix 1, LLCWilbargerTexasThe 345 kV Riley Substation (#6101); AEPNoneOther - Battery Energy Storage100.54None...NaTNaNNaNNot RequiredNaNNaNWESTNaTNaTNaN
\n", "

1083 rows × 35 columns

\n", "
" ], "text/plain": [ " Queue ID Project Name Interconnecting Entity \\\n", "0 14INR0033 Goodnight Wind FGE Goodnight I, LLC \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", "1078 27INR0003 Becerra Creek Storage 2 Bordas Renewable Energy, LLC \n", "1079 27INR0004 Dundee North Wind Felix 2, LLC \n", "1080 27INR0005 Dundee South A Wind Felix 2, LLC \n", "1081 27INR0007 Felix East Solar Felix 1, LLC \n", "1082 27INR0009 Felix Storage Felix 1, 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", "1078 Webb Texas 345 kV Cenizo Substation (#80220) \n", "1079 Wilbarger Texas 345 kV Riley Substation (#6101); AEP \n", "1080 Baylor Texas 345 kV Riley Substation (#6101); AEP \n", "1081 Wilbarger Texas The 345 kV Riley Substation (#6101); AEP \n", "1082 Wilbarger Texas The 345 kV Riley Substation (#6101); AEP \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", "1078 None Other - Energy Storage 125.62 \n", "1079 None Wind - Wind Turbine 307.72 \n", "1080 None Wind - Wind Turbine 307.23 \n", "1081 None Solar - Photovoltaic Solar 301.44 \n", "1082 None Other - Battery Energy Storage 100.54 \n", "\n", " Summer Capacity (MW) ... IA Signed Air Permit GHG Permit \\\n", "0 None ... 2019-08-18 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", "1078 None ... NaT NaN NaN \n", "1079 None ... NaT NaN NaN \n", "1080 None ... NaT NaN NaN \n", "1081 None ... NaT NaN NaN \n", "1082 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", "1078 NaN NaN NaN \n", "1079 Not Required NaN NaN \n", "1080 Not Required NaN NaN \n", "1081 Not Required NaN NaN \n", "1082 Not Required 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", "1078 SOUTH NaT \n", "1079 WEST NaT \n", "1080 WEST NaT \n", "1081 WEST NaT \n", "1082 WEST 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", "1078 NaT NaN \n", "1079 NaT NaN \n", "1080 NaT NaN \n", "1081 NaT NaN \n", "1082 NaT NaN \n", "\n", "[1083 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": "036b7ecf", "metadata": {}, "source": [ "## MISO" ] }, { "cell_type": "code", "execution_count": 5, "id": "4faf9f18", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Queue IDProject NameInterconnecting EntityCountyStateInterconnection LocationTransmission OwnerGeneration TypeCapacity (MW)Summer Capacity (MW)...giaToExecstudyCyclestudyGroupstudyPhasesvcTypedp1ErisMwdp1NrisMwdp2ErisMwdp2NrisMwsisPhase1
0E002NoneNonePointe CoupeeLA500 kV switchyard at Big Cajon IIEntergyGas15.015.0...2013-12-16T05:00:00ZERIS0.00.00.00.0
1E291NoneNoneTXRich 138 kV substationEntergyHydro27.027.0...2013-10-22T04:00:00ZERIS0.00.00.00.0
2G001NoneNoneBrown CountyWIUnknownAmerican Transmission Co. LLC255.0255.0...NoneSPA - SISERIS0.00.00.00.0
3G002NoneNoneTrimble CountyKYUnknownLG&E and KU Services Company as agent for Loui...Coal174.0174.0...NoneERIS0.00.00.00.0
4G003NoneNoneTrimble CountyKYUnknownLG&E and KU Services Company as agent for Loui...Coal174.0174.0...NoneERIS0.00.00.00.0
..................................................................
4248R66NoneNoneAdams CountyIACreston - Clarinda 161 kVMidAmerican Energy CompanyWind150.0150.0...NoneFeasibilityNRIS0.00.00.00.0
4249R67NoneNoneClay CountyIASheldon (Obrien county sub) 345 kVMidAmerican Energy CompanyWind148.8148.8...NoneSPA - SISNRIS0.00.00.00.0
4250R68NoneNoneHancock CountyIAMEC Webster 345 kV SubstationMidAmerican Energy CompanyWind249.6249.6...NoneSPA - SISNRIS0.00.00.00.0
4251Temp3257NoneNoneUnknownEwington Energy Systems, LLC0.00.0...None0.00.00.00.0
4252Test 1234NoneNoneJackson CountyTXtest line 1 - test line 2 138 kVEwington Energy Systems, LLC0.00.0...None125sssMTEP0.00.00.00.0
\n", "

4253 rows × 31 columns

\n", "
" ], "text/plain": [ " Queue ID Project Name Interconnecting Entity County State \\\n", "0 E002 None None Pointe Coupee LA \n", "1 E291 None None TX \n", "2 G001 None None Brown County WI \n", "3 G002 None None Trimble County KY \n", "4 G003 None None Trimble County KY \n", "... ... ... ... ... ... \n", "4248 R66 None None Adams County IA \n", "4249 R67 None None Clay County IA \n", "4250 R68 None None Hancock County IA \n", "4251 Temp3257 None None \n", "4252 Test 1234 None None Jackson County TX \n", "\n", " Interconnection Location \\\n", "0 500 kV switchyard at Big Cajon II \n", "1 Rich 138 kV substation \n", "2 Unknown \n", "3 Unknown \n", "4 Unknown \n", "... ... \n", "4248 Creston - Clarinda 161 kV \n", "4249 Sheldon (Obrien county sub) 345 kV \n", "4250 MEC Webster 345 kV Substation \n", "4251 Unknown \n", "4252 test line 1 - test line 2 138 kV \n", "\n", " Transmission Owner Generation Type \\\n", "0 Entergy Gas \n", "1 Entergy Hydro \n", "2 American Transmission Co. LLC \n", "3 LG&E and KU Services Company as agent for Loui... Coal \n", "4 LG&E and KU Services Company as agent for Loui... Coal \n", "... ... ... \n", "4248 MidAmerican Energy Company Wind \n", "4249 MidAmerican Energy Company Wind \n", "4250 MidAmerican Energy Company Wind \n", "4251 Ewington Energy Systems, LLC \n", "4252 Ewington Energy Systems, LLC \n", "\n", " Capacity (MW) Summer Capacity (MW) ... giaToExec \\\n", "0 15.0 15.0 ... 2013-12-16T05:00:00Z \n", "1 27.0 27.0 ... 2013-10-22T04:00:00Z \n", "2 255.0 255.0 ... None \n", "3 174.0 174.0 ... None \n", "4 174.0 174.0 ... None \n", "... ... ... ... ... \n", "4248 150.0 150.0 ... None \n", "4249 148.8 148.8 ... None \n", "4250 249.6 249.6 ... None \n", "4251 0.0 0.0 ... None \n", "4252 0.0 0.0 ... None \n", "\n", " studyCycle studyGroup studyPhase svcType dp1ErisMw dp1NrisMw dp2ErisMw \\\n", "0 ERIS 0.0 0.0 0.0 \n", "1 ERIS 0.0 0.0 0.0 \n", "2 SPA - SIS ERIS 0.0 0.0 0.0 \n", "3 ERIS 0.0 0.0 0.0 \n", "4 ERIS 0.0 0.0 0.0 \n", "... ... ... ... ... ... ... ... \n", "4248 Feasibility NRIS 0.0 0.0 0.0 \n", "4249 SPA - SIS NRIS 0.0 0.0 0.0 \n", "4250 SPA - SIS NRIS 0.0 0.0 0.0 \n", "4251 0.0 0.0 0.0 \n", "4252 125 sss MTEP 0.0 0.0 0.0 \n", "\n", " dp2NrisMw sisPhase1 \n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "... ... ... \n", "4248 0.0 \n", "4249 0.0 \n", "4250 0.0 \n", "4251 0.0 \n", "4252 0.0 \n", "\n", "[4253 rows x 31 columns]" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "miso = gridstatus.MISO()\n", "miso.get_interconnection_queue()" ] }, { "cell_type": "markdown", "id": "3355028a", "metadata": {}, "source": [ "## ISONE" ] }, { "cell_type": "code", "execution_count": 6, "id": "b49fa947", "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...FalseFalsePDWMAIn ProgressNaNNaNNaNNaNUnder Study
12981314Offshore WindNoneNaNMAEversource 115kV Acushnet, lines 112/114NaNWND470.000000470.000000...FalseFalsePDSEMANaNNot StartedNaNNaNNaNUnder Study
12991315Battery StorageNoneWindhamCTEversource Killingly Substation,115kV BUS, Tra...NaNBAT106.970001106.970001...FalseFalsePDCTIn ProgressNaNNaNNaNNaNUnder Study
13001316Solar plus BatteryNoneCheshireNHEversource 115kV line L163NaNSUN BAT102.000000102.000000...FalseFalseNaNNHIn ProgressNaNNaNNaNNaNUnder Study
\n", "

1301 rows × 32 columns

\n", "
" ], "text/plain": [ " Queue ID Project Name \\\n", "0 1 Millennium+K117 \n", "1 2 EMI-Tiverton \n", "2 3 Androscoggin Energy Center \n", "3 4 EMI Dighton Power Project \n", "4 5 Brayton Pt \n", "... ... ... \n", "1296 1308 Uxbridge Substation – NG Hopedale West Group S... \n", "1297 1310 Battery Storage \n", "1298 1314 Offshore Wind \n", "1299 1315 Battery Storage \n", "1300 1316 Solar plus Battery \n", "\n", " Interconnecting Entity County State \\\n", "0 None Worcester MA \n", "1 None Newport RI \n", "2 None Franklin ME \n", "3 None Bristol MA \n", "4 None Bristol MA \n", "... ... ... ... \n", "1296 None Worcester MA \n", "1297 None Berkshire MA \n", "1298 None NaN MA \n", "1299 None Windham CT \n", "1300 None Cheshire NH \n", "\n", " Interconnection Location Transmission Owner \\\n", "0 W 123 Line NGRID \n", "1 Near Tiverton 115 kV Substation NGRID \n", "2 Jay 115 kV Substation CMP \n", "3 U6 Line NGRID \n", "4 Brayton Point 345 kV Station NGRID \n", "... ... ... \n", "1296 NG Feeder 321W6, Uxbridge T2 NaN \n", "1297 115 kV Transmission line (1211 - Present betwe... NaN \n", "1298 Eversource 115kV Acushnet, lines 112/114 NaN \n", "1299 Eversource Killingly Substation,115kV BUS, Tra... NaN \n", "1300 Eversource 115kV line L163 NaN \n", "\n", " Generation Type Capacity (MW) Summer Capacity (MW) ... SIS Complete \\\n", "0 DFO NG NaN NaN ... True \n", "1 NG NaN NaN ... True \n", "2 DFO NG NaN NaN ... True \n", "3 NG NaN NaN ... True \n", "4 NaN NaN NaN ... True \n", "... ... ... ... ... ... \n", "1296 BAT 6.994000 6.994000 ... False \n", "1297 BAT 118.750000 118.750000 ... False \n", "1298 WND 470.000000 470.000000 ... False \n", "1299 BAT 106.970001 106.970001 ... False \n", "1300 SUN BAT 102.000000 102.000000 ... False \n", "\n", " I39 Dev Zone FS SIS OS FAC IA Project Status \n", "0 True NaN WMA NaN NaN NaN NaN NaN NaN \n", "1 True NaN SEMA NaN NaN NaN NaN NaN NaN \n", "2 True NaN ME NaN NaN NaN NaN NaN NaN \n", "3 True NaN SEMA NaN NaN NaN NaN NaN NaN \n", "4 True NaN RI NaN NaN NaN NaN NaN NaN \n", "... ... ... ... ... ... ... ... ... ... \n", "1296 False PD SEMA NaN NaN NaN NaN NaN NaN \n", "1297 False PD WMA In Progress NaN NaN NaN NaN Under Study \n", "1298 False PD SEMA NaN Not Started NaN NaN NaN Under Study \n", "1299 False PD CT In Progress NaN NaN NaN NaN Under Study \n", "1300 False NaN NH In Progress NaN NaN NaN NaN Under Study \n", "\n", "[1301 rows x 32 columns]" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "isone = gridstatus.ISONE()\n", "isone.get_interconnection_queue()" ] }, { "cell_type": "markdown", "id": "0818a726", "metadata": {}, "source": [ "## PJM" ] }, { "cell_type": "code", "execution_count": 7, "id": "1419fdca", "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
..................................................................
8688903384PJM-WECNoneNaNNaNNoneNaNNaN320.0NaN...NaNNaNNaNNaNNaNNaNNaN5/15/20105/31/2011NaN
8689988887PJM-CINNoneNaNNaNNoneNaNNaN20.0NaN...NaNNaNNaNNaNNaNNaNNaN6/1/20096/1/2014NaN
8690994856PJM-TVANoneNaNNaNNoneNaNNaN138.0NaN...NaNNaNNaNNaNNaNNaNNaN2/1/20092/1/2014NaN
8691994857PJM-TVANoneNaNNaNNoneNaNNaN90.0NaN...NaNNaNNaNNaNNaNNaNNaN2/1/20092/1/2014NaN
8692994858PJM-TVANoneNaNNaNNoneNaNNaN90.0NaN...NaNNaNNaNNaNNaNNaNNaN2/1/20092/1/2014NaN
\n", "

8693 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", "8688 903384 PJM-WEC None NaN NaN \n", "8689 988887 PJM-CIN None NaN NaN \n", "8690 994856 PJM-TVA None NaN NaN \n", "8691 994857 PJM-TVA None NaN NaN \n", "8692 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", "8688 None NaN NaN \n", "8689 None NaN NaN \n", "8690 None NaN NaN \n", "8691 None NaN NaN \n", "8692 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", "8688 320.0 NaN ... \n", "8689 20.0 NaN ... \n", "8690 138.0 NaN ... \n", "8691 90.0 NaN ... \n", "8692 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", "8688 NaN \n", "8689 NaN \n", "8690 NaN \n", "8691 NaN \n", "8692 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", "8688 NaN NaN \n", "8689 NaN NaN \n", "8690 NaN NaN \n", "8691 NaN NaN \n", "8692 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", "8688 NaN \n", "8689 NaN \n", "8690 NaN \n", "8691 NaN \n", "8692 NaN \n", "\n", " Upgrade Construction Service Agreement \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "... ... \n", "8688 NaN \n", "8689 NaN \n", "8690 NaN \n", "8691 NaN \n", "8692 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", "8688 NaN NaN \n", "8689 NaN NaN \n", "8690 NaN NaN \n", "8691 NaN NaN \n", "8692 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", "8688 5/15/2010 5/31/2011 \n", "8689 6/1/2009 6/1/2014 \n", "8690 2/1/2009 2/1/2014 \n", "8691 2/1/2009 2/1/2014 \n", "8692 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", "8688 NaN \n", "8689 NaN \n", "8690 NaN \n", "8691 NaN \n", "8692 NaN \n", "\n", "[8693 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 }