{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "26010d12",
   "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": "21fff034",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Queue ID</th>\n",
       "      <th>Project Name</th>\n",
       "      <th>Interconnecting Entity</th>\n",
       "      <th>County</th>\n",
       "      <th>State</th>\n",
       "      <th>Interconnection Location</th>\n",
       "      <th>Transmission Owner</th>\n",
       "      <th>Generation Type</th>\n",
       "      <th>Capacity (MW)</th>\n",
       "      <th>Summer Capacity (MW)</th>\n",
       "      <th>...</th>\n",
       "      <th>Withdrawn Date</th>\n",
       "      <th>Withdrawal Comment</th>\n",
       "      <th>Actual Completion Date</th>\n",
       "      <th>Proposed  In-Service</th>\n",
       "      <th>Proposed Initial-Sync</th>\n",
       "      <th>Last Update</th>\n",
       "      <th>Z</th>\n",
       "      <th>S</th>\n",
       "      <th>Availability of Studies</th>\n",
       "      <th>FS Complete/ SGIA Tender</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0276</td>\n",
       "      <td>Homer Solar Energy Center</td>\n",
       "      <td>Homer Solar Energy Center, LLC</td>\n",
       "      <td>Cortland</td>\n",
       "      <td>NY</td>\n",
       "      <td>Cortland - Fenner 115kV</td>\n",
       "      <td>NM-NG</td>\n",
       "      <td>Solar</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2023-08-01</td>\n",
       "      <td>2023-09-01</td>\n",
       "      <td>2022-09-30 00:00:00</td>\n",
       "      <td>C</td>\n",
       "      <td>10.0</td>\n",
       "      <td>FES, SRIS, FS</td>\n",
       "      <td>2021-02-08 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0386</td>\n",
       "      <td>Grand Isle Intertie</td>\n",
       "      <td>Vermont Green Line Devco, LLC</td>\n",
       "      <td>Clinton</td>\n",
       "      <td>NY</td>\n",
       "      <td>Plattsburgh 230kV-New Haven, VT 345kV</td>\n",
       "      <td>NYPA</td>\n",
       "      <td>DC Transmission</td>\n",
       "      <td>400.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2023-12-01</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018-11-30 00:00:00</td>\n",
       "      <td>D</td>\n",
       "      <td>6.0</td>\n",
       "      <td>FES, SIS</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0393</td>\n",
       "      <td>Berrians East Replacement</td>\n",
       "      <td>NRG Berrians East Development, LLC</td>\n",
       "      <td>Queens</td>\n",
       "      <td>NY</td>\n",
       "      <td>Astoria East 138kV</td>\n",
       "      <td>ConEd</td>\n",
       "      <td>Dual Fuel</td>\n",
       "      <td>94.2</td>\n",
       "      <td>94.2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2024-05-01</td>\n",
       "      <td>2024-08-01</td>\n",
       "      <td>2022-06-30 00:00:00</td>\n",
       "      <td>J</td>\n",
       "      <td>11.0</td>\n",
       "      <td>FES, SRIS, FS</td>\n",
       "      <td>2019-07-09 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0396</td>\n",
       "      <td>Baron Winds</td>\n",
       "      <td>Baron Winds, LLC</td>\n",
       "      <td>Steuben</td>\n",
       "      <td>NY</td>\n",
       "      <td>Hillside - Meyer 230kV</td>\n",
       "      <td>NYSEG</td>\n",
       "      <td>Wind</td>\n",
       "      <td>238.4</td>\n",
       "      <td>238.4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-05-01</td>\n",
       "      <td>2022-06-01</td>\n",
       "      <td>2021-11-30 00:00:00</td>\n",
       "      <td>C</td>\n",
       "      <td>11.0</td>\n",
       "      <td>FES, SRIS, FS</td>\n",
       "      <td>2019-07-09 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0396A</td>\n",
       "      <td>Wood Street Transformer</td>\n",
       "      <td>New York State Electric &amp; Gas</td>\n",
       "      <td>Putnam</td>\n",
       "      <td>NY</td>\n",
       "      <td>Wood St. 345/115kV</td>\n",
       "      <td>NYSEG</td>\n",
       "      <td>AC Transmission</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-12-01</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2021-04-30 00:00:00</td>\n",
       "      <td>G</td>\n",
       "      <td>12.0</td>\n",
       "      <td>SIS</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1413</th>\n",
       "      <td>583</td>\n",
       "      <td>Fulton</td>\n",
       "      <td>Erie Boulevard Hydropower, LP</td>\n",
       "      <td>Oswego</td>\n",
       "      <td>NY</td>\n",
       "      <td>Fay St. 34.5kV</td>\n",
       "      <td>NM-NG</td>\n",
       "      <td>Hydro</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3/31/18</td>\n",
       "      <td>2025-07-01</td>\n",
       "      <td>2025-11-01</td>\n",
       "      <td>3/31/18</td>\n",
       "      <td>C</td>\n",
       "      <td>14</td>\n",
       "      <td>FS</td>\n",
       "      <td>2017-07-12 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1414</th>\n",
       "      <td>0696</td>\n",
       "      <td>Swinging Bridge Unit 3</td>\n",
       "      <td>Eagle Creek Hydro Power, LLC</td>\n",
       "      <td>Orange</td>\n",
       "      <td>NY</td>\n",
       "      <td>Swing Bridge 69 kV</td>\n",
       "      <td>O&amp;R</td>\n",
       "      <td>Hydro</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-04-30 00:00:00</td>\n",
       "      <td>2024-11-01</td>\n",
       "      <td>2024-12-01</td>\n",
       "      <td>2020-04-30 00:00:00</td>\n",
       "      <td>G</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-06-20 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1415</th>\n",
       "      <td>0701</td>\n",
       "      <td>KCE NY 1</td>\n",
       "      <td>KCE NY 1, LLC</td>\n",
       "      <td>Saratoga</td>\n",
       "      <td>NY</td>\n",
       "      <td>Luther - Forest Substation 34.5kV</td>\n",
       "      <td>NYSEG</td>\n",
       "      <td>Energy Storage</td>\n",
       "      <td>20.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-04-30 00:00:00</td>\n",
       "      <td>2022-10-01</td>\n",
       "      <td>2022-11-01</td>\n",
       "      <td>2020-04-30 00:00:00</td>\n",
       "      <td>F</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-06-20 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1416</th>\n",
       "      <td>0731</td>\n",
       "      <td>Branscomb Solar</td>\n",
       "      <td>Branscomb Solar, LLC</td>\n",
       "      <td>Washington</td>\n",
       "      <td>NY</td>\n",
       "      <td>Battenkill - Eastover 115kV</td>\n",
       "      <td>NM-NG</td>\n",
       "      <td>Solar</td>\n",
       "      <td>20.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-03-31 00:00:00</td>\n",
       "      <td>2024-11-01</td>\n",
       "      <td>2025-02-01</td>\n",
       "      <td>2022-03-31 00:00:00</td>\n",
       "      <td>F</td>\n",
       "      <td>14</td>\n",
       "      <td>FES, SIS, FS</td>\n",
       "      <td>2020-04-29 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1417</th>\n",
       "      <td>0781</td>\n",
       "      <td>Marcy South SSR Detection</td>\n",
       "      <td>New York Power Authority</td>\n",
       "      <td>Delaware</td>\n",
       "      <td>NY</td>\n",
       "      <td>Fraser - Annex 345 kV Substation</td>\n",
       "      <td>NYPA</td>\n",
       "      <td>AC Transmission</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-04-30 00:00:00</td>\n",
       "      <td>2023-09-01</td>\n",
       "      <td>2023-09-01</td>\n",
       "      <td>2020-04-30 00:00:00</td>\n",
       "      <td>E</td>\n",
       "      <td>14</td>\n",
       "      <td>SIS</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1418 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Queue ID               Project Name              Interconnecting Entity  \\\n",
       "0        0276  Homer Solar Energy Center      Homer Solar Energy Center, LLC   \n",
       "1        0386        Grand Isle Intertie       Vermont Green Line Devco, LLC   \n",
       "2        0393  Berrians East Replacement  NRG Berrians East Development, LLC   \n",
       "3        0396                Baron Winds                    Baron Winds, LLC   \n",
       "4       0396A    Wood Street Transformer       New York State Electric & Gas   \n",
       "...       ...                        ...                                 ...   \n",
       "1413      583                     Fulton       Erie Boulevard Hydropower, LP   \n",
       "1414     0696     Swinging Bridge Unit 3        Eagle Creek Hydro Power, LLC   \n",
       "1415     0701                   KCE NY 1                       KCE NY 1, LLC   \n",
       "1416     0731            Branscomb Solar                Branscomb Solar, LLC   \n",
       "1417     0781  Marcy South SSR Detection            New York Power Authority   \n",
       "\n",
       "          County State               Interconnection Location  \\\n",
       "0       Cortland    NY                Cortland - Fenner 115kV   \n",
       "1        Clinton    NY  Plattsburgh 230kV-New Haven, VT 345kV   \n",
       "2         Queens    NY                     Astoria East 138kV   \n",
       "3        Steuben    NY                 Hillside - Meyer 230kV   \n",
       "4         Putnam    NY                     Wood St. 345/115kV   \n",
       "...          ...   ...                                    ...   \n",
       "1413      Oswego    NY                         Fay St. 34.5kV   \n",
       "1414      Orange    NY                     Swing Bridge 69 kV   \n",
       "1415    Saratoga    NY      Luther - Forest Substation 34.5kV   \n",
       "1416  Washington    NY            Battenkill - Eastover 115kV   \n",
       "1417    Delaware    NY       Fraser - Annex 345 kV Substation   \n",
       "\n",
       "     Transmission Owner  Generation Type  Capacity (MW) Summer Capacity (MW)  \\\n",
       "0                 NM-NG            Solar           90.0                 90.0   \n",
       "1                  NYPA  DC Transmission          400.0                400.0   \n",
       "2                 ConEd        Dual Fuel           94.2                 94.2   \n",
       "3                 NYSEG             Wind          238.4                238.4   \n",
       "4                 NYSEG  AC Transmission            NaN                  NaN   \n",
       "...                 ...              ...            ...                  ...   \n",
       "1413              NM-NG            Hydro            1.3                  1.3   \n",
       "1414                O&R            Hydro            1.2                  1.2   \n",
       "1415              NYSEG   Energy Storage           20.0                 20.0   \n",
       "1416              NM-NG            Solar           20.0                 20.0   \n",
       "1417               NYPA  AC Transmission            NaN                  NaN   \n",
       "\n",
       "      ... Withdrawn Date Withdrawal Comment Actual Completion Date  \\\n",
       "0     ...            NaN                NaN                    NaN   \n",
       "1     ...            NaN                NaN                    NaN   \n",
       "2     ...            NaN                NaN                    NaN   \n",
       "3     ...            NaN                NaN                    NaN   \n",
       "4     ...            NaN                NaN                    NaN   \n",
       "...   ...            ...                ...                    ...   \n",
       "1413  ...            NaN                NaN                3/31/18   \n",
       "1414  ...            NaN                NaN    2020-04-30 00:00:00   \n",
       "1415  ...            NaN                NaN    2020-04-30 00:00:00   \n",
       "1416  ...            NaN                NaN    2022-03-31 00:00:00   \n",
       "1417  ...            NaN                NaN    2020-04-30 00:00:00   \n",
       "\n",
       "     Proposed  In-Service Proposed Initial-Sync          Last Update  Z     S  \\\n",
       "0              2023-08-01            2023-09-01  2022-09-30 00:00:00  C  10.0   \n",
       "1              2023-12-01                   NaT  2018-11-30 00:00:00  D   6.0   \n",
       "2              2024-05-01            2024-08-01  2022-06-30 00:00:00  J  11.0   \n",
       "3              2022-05-01            2022-06-01  2021-11-30 00:00:00  C  11.0   \n",
       "4              2022-12-01                   NaT  2021-04-30 00:00:00  G  12.0   \n",
       "...                   ...                   ...                  ... ..   ...   \n",
       "1413           2025-07-01            2025-11-01              3/31/18  C    14   \n",
       "1414           2024-11-01            2024-12-01  2020-04-30 00:00:00  G    14   \n",
       "1415           2022-10-01            2022-11-01  2020-04-30 00:00:00  F    14   \n",
       "1416           2024-11-01            2025-02-01  2022-03-31 00:00:00  F    14   \n",
       "1417           2023-09-01            2023-09-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, SIS                      NaT  \n",
       "2              FES, SRIS, FS      2019-07-09 00:00:00  \n",
       "3              FES, SRIS, FS      2019-07-09 00:00:00  \n",
       "4                        SIS                      NaT  \n",
       "...                      ...                      ...  \n",
       "1413                      FS      2017-07-12 00:00:00  \n",
       "1414                     NaN      2018-06-20 00:00:00  \n",
       "1415                     NaN      2018-06-20 00:00:00  \n",
       "1416            FES, SIS, FS      2020-04-29 00:00:00  \n",
       "1417                     SIS                      NaN  \n",
       "\n",
       "[1418 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": "d6d0e82e",
   "metadata": {},
   "source": [
    "## CAISO"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "09df0169",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Queue ID</th>\n",
       "      <th>Project Name</th>\n",
       "      <th>Interconnecting Entity</th>\n",
       "      <th>County</th>\n",
       "      <th>State</th>\n",
       "      <th>Interconnection Location</th>\n",
       "      <th>Transmission Owner</th>\n",
       "      <th>Generation Type</th>\n",
       "      <th>Capacity (MW)</th>\n",
       "      <th>Summer Capacity (MW)</th>\n",
       "      <th>...</th>\n",
       "      <th>Interconnection Request Receive Date</th>\n",
       "      <th>Interconnection Agreement Status</th>\n",
       "      <th>Study Process</th>\n",
       "      <th>Proposed On-line Date (as filed with IR)</th>\n",
       "      <th>System Impact Study or Phase I Cluster Study</th>\n",
       "      <th>Facilities Study (FAS) or Phase II Cluster Study</th>\n",
       "      <th>Optional Study (OS)</th>\n",
       "      <th>Full Capacity, Partial or Energy Only (FC/P/EO)</th>\n",
       "      <th>Off-Peak Deliverability and Economic Only</th>\n",
       "      <th>Feasibility Study or Supplemental Review</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>32</td>\n",
       "      <td>TULE WIND</td>\n",
       "      <td>None</td>\n",
       "      <td>SAN DIEGO</td>\n",
       "      <td>CA</td>\n",
       "      <td>Boulevard East Substation 138 kV</td>\n",
       "      <td>SDGE</td>\n",
       "      <td>Wind Turbine</td>\n",
       "      <td>193.8</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2004-05-12 00:00:00</td>\n",
       "      <td>Executed</td>\n",
       "      <td>Serial LGIP</td>\n",
       "      <td>2007-09-01 07:00:00</td>\n",
       "      <td>Complete</td>\n",
       "      <td>Complete</td>\n",
       "      <td>None</td>\n",
       "      <td>Partial Capacity</td>\n",
       "      <td>Off-Peak Deliverability</td>\n",
       "      <td>Waived</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>72</td>\n",
       "      <td>LAKE ELSINORE ADVANCED PUMPED STORAGE PROJECT</td>\n",
       "      <td>None</td>\n",
       "      <td>RIVERSIDE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Proposed Lee Lake Substation 500 kV</td>\n",
       "      <td>SDGE</td>\n",
       "      <td>Storage</td>\n",
       "      <td>500.0</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2005-04-26 00:00:00</td>\n",
       "      <td>Executed</td>\n",
       "      <td>Serial LGIP</td>\n",
       "      <td>2008-12-31 08:00:00</td>\n",
       "      <td>Complete</td>\n",
       "      <td>Re-Study</td>\n",
       "      <td>None</td>\n",
       "      <td>Full Capacity</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Waived</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>138</td>\n",
       "      <td>SANDSTORM WIND POWER</td>\n",
       "      <td>None</td>\n",
       "      <td>RIVERSIDE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Devers - San Bernardino 230 kV line</td>\n",
       "      <td>SCE</td>\n",
       "      <td>Wind Turbine + Storage</td>\n",
       "      <td>150.0</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2006-10-23 00:00:00</td>\n",
       "      <td>Executed</td>\n",
       "      <td>Serial LGIP</td>\n",
       "      <td>2008-12-31 08:00:00</td>\n",
       "      <td>Complete</td>\n",
       "      <td>Complete</td>\n",
       "      <td>None</td>\n",
       "      <td>Partial Capacity</td>\n",
       "      <td>Off-Peak Deliverability</td>\n",
       "      <td>Waived</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>146</td>\n",
       "      <td>DESERT SUNLIGHT PV I</td>\n",
       "      <td>None</td>\n",
       "      <td>RIVERSIDE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Red Bluff Substation 230kV</td>\n",
       "      <td>SCE</td>\n",
       "      <td>Photovoltaic + Storage</td>\n",
       "      <td>250.0</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2006-11-16 00:00:00</td>\n",
       "      <td>Executed</td>\n",
       "      <td>Serial LGIP</td>\n",
       "      <td>2008-12-01 08:00:00</td>\n",
       "      <td>Complete</td>\n",
       "      <td>Complete</td>\n",
       "      <td>None</td>\n",
       "      <td>Partial Capacity</td>\n",
       "      <td>Off-Peak Deliverability</td>\n",
       "      <td>Required</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>147</td>\n",
       "      <td>DESERT SUNLIGHT PV II</td>\n",
       "      <td>None</td>\n",
       "      <td>RIVERSIDE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Red Bluff Substation 230kV</td>\n",
       "      <td>SCE</td>\n",
       "      <td>Photovoltaic + Storage</td>\n",
       "      <td>300.0</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2006-11-16 00:00:00</td>\n",
       "      <td>Executed</td>\n",
       "      <td>Serial LGIP</td>\n",
       "      <td>2010-02-01 08:00:00</td>\n",
       "      <td>Complete</td>\n",
       "      <td>Complete</td>\n",
       "      <td>None</td>\n",
       "      <td>Partial Capacity</td>\n",
       "      <td>Off-Peak Deliverability</td>\n",
       "      <td>Required</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2269</th>\n",
       "      <td>2133</td>\n",
       "      <td>LIVE OAK STORAGE</td>\n",
       "      <td>None</td>\n",
       "      <td>SAN BERNARDINO</td>\n",
       "      <td>CA</td>\n",
       "      <td>San Bernadino 220 kV</td>\n",
       "      <td>SCE</td>\n",
       "      <td>Storage</td>\n",
       "      <td>350.0</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-04-09 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C14</td>\n",
       "      <td>2024-06-01 07:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Full Capacity</td>\n",
       "      <td>Off-Peak Deliverability</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2270</th>\n",
       "      <td>2183</td>\n",
       "      <td>HELIX STORAGE</td>\n",
       "      <td>None</td>\n",
       "      <td>SAN DIEGO</td>\n",
       "      <td>CA</td>\n",
       "      <td>Spring Valley Substation 69 kV</td>\n",
       "      <td>SDGE</td>\n",
       "      <td>Storage</td>\n",
       "      <td>80.0</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-04-09 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C14</td>\n",
       "      <td>2025-11-01 07:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Full Capacity</td>\n",
       "      <td>Off-Peak Deliverability</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2271</th>\n",
       "      <td>2190</td>\n",
       "      <td>HERMES ENERGY STORAGE</td>\n",
       "      <td>None</td>\n",
       "      <td>SAN DIEGO</td>\n",
       "      <td>CA</td>\n",
       "      <td>Border Substation 69 kV</td>\n",
       "      <td>SDGE</td>\n",
       "      <td>Storage</td>\n",
       "      <td>150.0</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-04-15 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C14</td>\n",
       "      <td>2024-06-01 07:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Full Capacity</td>\n",
       "      <td>Off-Peak Deliverability</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2272</th>\n",
       "      <td>2193</td>\n",
       "      <td>VENTANA ENERGY STORAGE</td>\n",
       "      <td>None</td>\n",
       "      <td>SAN BERNARDINO</td>\n",
       "      <td>CA</td>\n",
       "      <td>Lugo</td>\n",
       "      <td>SCE</td>\n",
       "      <td>Storage</td>\n",
       "      <td>250.0</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-11-19 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ISP</td>\n",
       "      <td>2024-06-01 07:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Full Capacity</td>\n",
       "      <td>Off-Peak Deliverability</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2273</th>\n",
       "      <td>2194</td>\n",
       "      <td>PRONGHORN ENERGY STORAGE</td>\n",
       "      <td>None</td>\n",
       "      <td>LOS ANGELES</td>\n",
       "      <td>CA</td>\n",
       "      <td>Antelope</td>\n",
       "      <td>SCE</td>\n",
       "      <td>Storage</td>\n",
       "      <td>120.0</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-05-07 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ISP</td>\n",
       "      <td>2026-06-01 07:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Full Capacity</td>\n",
       "      <td>Off-Peak Deliverability</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2274 rows × 36 columns</p>\n",
       "</div>"
      ],
      "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     2133                               LIVE OAK STORAGE   \n",
       "2270     2183                                  HELIX STORAGE   \n",
       "2271     2190                          HERMES 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 BERNARDINO    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                 San Bernadino 220 kV                SCE   \n",
       "2270       Spring Valley 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          350.0                 None  ...   \n",
       "2270                 Storage           80.0                 None  ...   \n",
       "2271                 Storage          150.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-09 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                      2024-06-01 07:00:00   \n",
       "2270           C14                      2025-11-01 07:00:00   \n",
       "2271           C14                      2024-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                   Off-Peak Deliverability   \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": "a6e83899",
   "metadata": {},
   "source": [
    "## SPP"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "d0e9ecff",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Queue ID</th>\n",
       "      <th>Project Name</th>\n",
       "      <th>Interconnecting Entity</th>\n",
       "      <th>County</th>\n",
       "      <th>State</th>\n",
       "      <th>Interconnection Location</th>\n",
       "      <th>Transmission Owner</th>\n",
       "      <th>Generation Type</th>\n",
       "      <th>Capacity (MW)</th>\n",
       "      <th>Summer Capacity (MW)</th>\n",
       "      <th>...</th>\n",
       "      <th>Withdrawn Date</th>\n",
       "      <th>Withdrawal Comment</th>\n",
       "      <th>Actual Completion Date</th>\n",
       "      <th>In-Service Date</th>\n",
       "      <th>Commercial Operation Date</th>\n",
       "      <th>Cessation Date</th>\n",
       "      <th>Current Cluster</th>\n",
       "      <th>Cluster Group</th>\n",
       "      <th>Replacement Generator Commercial Op Date</th>\n",
       "      <th>Service Type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>GEN-2001-014</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Sleeping Bear</td>\n",
       "      <td>OK</td>\n",
       "      <td>Ft Supply 138kV</td>\n",
       "      <td>WFEC</td>\n",
       "      <td>Wind</td>\n",
       "      <td>94.50</td>\n",
       "      <td>94.50</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>6/30/2007</td>\n",
       "      <td>4/15/2007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ICS-2008-001 Prior Queued</td>\n",
       "      <td>04 SOUTHEAST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>GEN-2001-018</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Neosho County</td>\n",
       "      <td>KS</td>\n",
       "      <td>Chanute NW Neosho Cnty By Tioga Sub</td>\n",
       "      <td>WERE</td>\n",
       "      <td>Thermal - Gas</td>\n",
       "      <td>47.00</td>\n",
       "      <td>47.00</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1/1/2002</td>\n",
       "      <td>1/1/2002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>GEN-2001-024</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Washington County</td>\n",
       "      <td>AR</td>\n",
       "      <td>SWEPCO Tontitown 161kV Substation</td>\n",
       "      <td>AEP</td>\n",
       "      <td>Thermal - CT</td>\n",
       "      <td>630.00</td>\n",
       "      <td>580.00</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>5/1/2007</td>\n",
       "      <td>7/1/2007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GEN-2001-026</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Meers</td>\n",
       "      <td>OK</td>\n",
       "      <td>Washita 138kV</td>\n",
       "      <td>WFEC</td>\n",
       "      <td>Wind</td>\n",
       "      <td>74.25</td>\n",
       "      <td>74.25</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>10/1/2003</td>\n",
       "      <td>10/1/2003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ICS-2008-001 Prior Queued</td>\n",
       "      <td>04 SOUTHEAST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>GEN-2001-029N</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Beatrice</td>\n",
       "      <td>NE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NPPD</td>\n",
       "      <td>Thermal - Gas</td>\n",
       "      <td>250.00</td>\n",
       "      <td>250.00</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1/1/2005</td>\n",
       "      <td>1/1/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>820</th>\n",
       "      <td>GEN-2022-SR4</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Minco 345 kV Substation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Battery/Storage</td>\n",
       "      <td>85.00</td>\n",
       "      <td>85.00</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Surplus</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>821</th>\n",
       "      <td>GEN-2022-SR5</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Seiling</td>\n",
       "      <td>OK</td>\n",
       "      <td>Tatonga 345 kV Substation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Battery/Storage</td>\n",
       "      <td>85.00</td>\n",
       "      <td>85.00</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/31/2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Surplus</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>822</th>\n",
       "      <td>GEN-2022-SR6</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Blackwell</td>\n",
       "      <td>OK</td>\n",
       "      <td>Nardin 69 kV Substation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Battery/Storage</td>\n",
       "      <td>50.00</td>\n",
       "      <td>50.00</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/31/2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Surplus</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>823</th>\n",
       "      <td>GEN-2022-SR7</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Campbell</td>\n",
       "      <td>NE</td>\n",
       "      <td>Macon 345 kV Substation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Battery/Storage</td>\n",
       "      <td>210.00</td>\n",
       "      <td>210.00</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/1/2018</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Surplus</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>GEN-2022-SR8</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Campbell</td>\n",
       "      <td>NE</td>\n",
       "      <td>Macon 345 kV Substation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Solar</td>\n",
       "      <td>210.00</td>\n",
       "      <td>210.00</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Surplus</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ER</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>825 rows × 24 columns</p>\n",
       "</div>"
      ],
      "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",
       "820   GEN-2022-SR4         None                   None                NaN   \n",
       "821   GEN-2022-SR5         None                   None            Seiling   \n",
       "822   GEN-2022-SR6         None                   None          Blackwell   \n",
       "823   GEN-2022-SR7         None                   None           Campbell   \n",
       "824   GEN-2022-SR8         None                   None           Campbell   \n",
       "\n",
       "    State             Interconnection Location Transmission Owner  \\\n",
       "0      OK                      Ft Supply 138kV               WFEC   \n",
       "1      KS  Chanute NW Neosho Cnty By Tioga Sub               WERE   \n",
       "2      AR    SWEPCO Tontitown 161kV Substation                AEP   \n",
       "3      OK                        Washita 138kV               WFEC   \n",
       "4      NE                                  NaN               NPPD   \n",
       "..    ...                                  ...                ...   \n",
       "820   NaN              Minco 345 kV Substation                NaN   \n",
       "821    OK            Tatonga 345 kV Substation                NaN   \n",
       "822    OK              Nardin 69 kV Substation                NaN   \n",
       "823    NE              Macon 345 kV Substation                NaN   \n",
       "824    NE              Macon 345 kV Substation                NaN   \n",
       "\n",
       "     Generation Type  Capacity (MW)  Summer Capacity (MW)  ...  \\\n",
       "0               Wind          94.50                 94.50  ...   \n",
       "1      Thermal - Gas          47.00                 47.00  ...   \n",
       "2       Thermal - CT         630.00                580.00  ...   \n",
       "3               Wind          74.25                 74.25  ...   \n",
       "4      Thermal - Gas         250.00                250.00  ...   \n",
       "..               ...            ...                   ...  ...   \n",
       "820  Battery/Storage          85.00                 85.00  ...   \n",
       "821  Battery/Storage          85.00                 85.00  ...   \n",
       "822  Battery/Storage          50.00                 50.00  ...   \n",
       "823  Battery/Storage         210.00                210.00  ...   \n",
       "824            Solar         210.00                210.00  ...   \n",
       "\n",
       "     Withdrawn Date Withdrawal Comment Actual Completion Date In-Service Date  \\\n",
       "0              None               None                   None       6/30/2007   \n",
       "1              None               None                   None        1/1/2002   \n",
       "2              None               None                   None        5/1/2007   \n",
       "3              None               None                   None       10/1/2003   \n",
       "4              None               None                   None        1/1/2005   \n",
       "..              ...                ...                    ...             ...   \n",
       "820            None               None                   None             NaN   \n",
       "821            None               None                   None             NaN   \n",
       "822            None               None                   None             NaN   \n",
       "823            None               None                   None             NaN   \n",
       "824            None               None                   None             NaN   \n",
       "\n",
       "    Commercial Operation Date Cessation Date            Current Cluster  \\\n",
       "0                   4/15/2007            NaN  ICS-2008-001 Prior Queued   \n",
       "1                    1/1/2002            NaN                        NaN   \n",
       "2                    7/1/2007            NaN                        NaN   \n",
       "3                   10/1/2003            NaN  ICS-2008-001 Prior Queued   \n",
       "4                    1/1/2005            NaN                        NaN   \n",
       "..                        ...            ...                        ...   \n",
       "820                       NaN            NaN                    Surplus   \n",
       "821                12/31/2022            NaN                    Surplus   \n",
       "822                12/31/2022            NaN                    Surplus   \n",
       "823                 12/1/2018            NaN                    Surplus   \n",
       "824                       NaN            NaN                    Surplus   \n",
       "\n",
       "    Cluster Group Replacement Generator Commercial Op Date Service Type  \n",
       "0    04 SOUTHEAST                                      NaN           ER  \n",
       "1             NaN                                      NaN           ER  \n",
       "2             NaN                                      NaN           ER  \n",
       "3    04 SOUTHEAST                                      NaN           ER  \n",
       "4             NaN                                      NaN           ER  \n",
       "..            ...                                      ...          ...  \n",
       "820           NaN                                      NaN           ER  \n",
       "821           NaN                                      NaN           ER  \n",
       "822           NaN                                      NaN           ER  \n",
       "823           NaN                                      NaN           ER  \n",
       "824           NaN                                      NaN           ER  \n",
       "\n",
       "[825 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": "ad233df8",
   "metadata": {},
   "source": [
    "## Ercot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6217496c",
   "metadata": {
    "tags": [
     "skip-execution"
    ]
   },
   "outputs": [],
   "source": [
    "ercot = gridstatus.Ercot()\n",
    "ercot.get_interconnection_queue()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f7e64128",
   "metadata": {},
   "source": [
    "## MISO"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "acde01a0",
   "metadata": {
    "tags": [
     "skip-execution"
    ]
   },
   "outputs": [],
   "source": [
    "miso = gridstatus.MISO()\n",
    "miso.get_interconnection_queue()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d363fa05",
   "metadata": {},
   "source": [
    "## ISONE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "019b8aec",
   "metadata": {
    "tags": [
     "skip-execution"
    ]
   },
   "outputs": [],
   "source": [
    "isone = gridstatus.ISONE()\n",
    "isone.get_interconnection_queue()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "37457508",
   "metadata": {},
   "source": [
    "## PJM"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f61b190e",
   "metadata": {
    "tags": [
     "skip-execution"
    ]
   },
   "outputs": [],
   "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.8.6"
  },
  "source_map": [
   5,
   17,
   21,
   24,
   27,
   30,
   33,
   37,
   42,
   45,
   50,
   53,
   58,
   61
  ]
 },
 "nbformat": 4,
 "nbformat_minor": 5
}