rep_info.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import datetime as dt\n",
    "import pandas as pd\n",
    "import requests\n",
    "import json\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>type</th>\n",
       "      <th>name</th>\n",
       "      <th>url</th>\n",
       "      <th>minority_url</th>\n",
       "      <th>thomas_id</th>\n",
       "      <th>house_committee_id</th>\n",
       "      <th>subcommittees</th>\n",
       "      <th>address</th>\n",
       "      <th>phone</th>\n",
       "      <th>rss_url</th>\n",
       "      <th>jurisdiction</th>\n",
       "      <th>youtube_id</th>\n",
       "      <th>jurisdiction_source</th>\n",
       "      <th>minority_rss_url</th>\n",
       "      <th>senate_committee_id</th>\n",
       "      <th>wikipedia</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Agriculture</td>\n",
       "      <td>https://agriculture.house.gov/</td>\n",
       "      <td>https://republicans-agriculture.house.gov</td>\n",
       "      <td>HSAG</td>\n",
       "      <td>AG</td>\n",
       "      <td>[{'name': 'Forestry', 'thomas_id': '15', 'addr...</td>\n",
       "      <td>1301 LHOB; Washington, DC 20515-6001</td>\n",
       "      <td>(202) 225-2171</td>\n",
       "      <td>https://agriculture.house.gov/Rss.aspx?GroupID=1</td>\n",
       "      <td>The House Committee on Agriculture has legisla...</td>\n",
       "      <td>UCOWh2WJxPywHIaccDWb8Mvg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Appropriations</td>\n",
       "      <td>https://appropriations.house.gov/</td>\n",
       "      <td>https://republicans-appropriations.house.gov/</td>\n",
       "      <td>HSAP</td>\n",
       "      <td>AP</td>\n",
       "      <td>[{'name': 'Agriculture, Rural Development, Foo...</td>\n",
       "      <td>H307 CAPITOL; Washington, DC 20515-6015</td>\n",
       "      <td>(202) 225-2771</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The House Committee on Appropriations is respo...</td>\n",
       "      <td>UCMaSlF09S0fpoRshS2t_7XA</td>\n",
       "      <td>https://appropriations.house.gov/about/</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Armed Services</td>\n",
       "      <td>https://armedservices.house.gov/</td>\n",
       "      <td>https://republicans-armedservices.house.gov/</td>\n",
       "      <td>HSAS</td>\n",
       "      <td>AS</td>\n",
       "      <td>[{'name': 'Tactical Air and Land Forces', 'tho...</td>\n",
       "      <td>2216 RHOB; Washington, DC 20515-6035</td>\n",
       "      <td>(202) 225-4151</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The House Committee on Armed Services has legi...</td>\n",
       "      <td>UCD506yORW2voSanqEgLOUIQ</td>\n",
       "      <td>https://armedservices.house.gov/about</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Financial Services</td>\n",
       "      <td>https://financialservices.house.gov/</td>\n",
       "      <td>https://republicans-financialservices.house.gov/</td>\n",
       "      <td>HSBA</td>\n",
       "      <td>BA</td>\n",
       "      <td>[{'name': 'Capital Markets', 'thomas_id': '16'...</td>\n",
       "      <td>2129 RHOB; Washington, DC 20515-6050</td>\n",
       "      <td>(202) 225-7502</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The House Financial Services Committee has jur...</td>\n",
       "      <td>UCiGw0gRK-daU7Xv4oDMr9Hg</td>\n",
       "      <td>https://financialservices.house.gov/about/</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on the Budget</td>\n",
       "      <td>https://budget.house.gov/</td>\n",
       "      <td>https://democrats-budget.house.gov/</td>\n",
       "      <td>HSBU</td>\n",
       "      <td>BU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>204 CHOB; Washington, DC 20515-6065</td>\n",
       "      <td>(202) 226-7270</td>\n",
       "      <td>https://budget.house.gov/news/rss.aspx</td>\n",
       "      <td>The House Committee on the Budget is responsib...</td>\n",
       "      <td>UCwzia2rpHJkowAXK-IF9E0w</td>\n",
       "      <td>https://budget.house.gov/about/</td>\n",
       "      <td>https://democrats-budget.house.gov/rss.xml</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    type                                   name  \\\n",
       "0  house         House Committee on Agriculture   \n",
       "1  house      House Committee on Appropriations   \n",
       "2  house      House Committee on Armed Services   \n",
       "3  house  House Committee on Financial Services   \n",
       "4  house          House Committee on the Budget   \n",
       "\n",
       "                                    url  \\\n",
       "0        https://agriculture.house.gov/   \n",
       "1     https://appropriations.house.gov/   \n",
       "2      https://armedservices.house.gov/   \n",
       "3  https://financialservices.house.gov/   \n",
       "4             https://budget.house.gov/   \n",
       "\n",
       "                                       minority_url thomas_id  \\\n",
       "0         https://republicans-agriculture.house.gov      HSAG   \n",
       "1     https://republicans-appropriations.house.gov/      HSAP   \n",
       "2      https://republicans-armedservices.house.gov/      HSAS   \n",
       "3  https://republicans-financialservices.house.gov/      HSBA   \n",
       "4               https://democrats-budget.house.gov/      HSBU   \n",
       "\n",
       "  house_committee_id                                      subcommittees  \\\n",
       "0                 AG  [{'name': 'Forestry', 'thomas_id': '15', 'addr...   \n",
       "1                 AP  [{'name': 'Agriculture, Rural Development, Foo...   \n",
       "2                 AS  [{'name': 'Tactical Air and Land Forces', 'tho...   \n",
       "3                 BA  [{'name': 'Capital Markets', 'thomas_id': '16'...   \n",
       "4                 BU                                                NaN   \n",
       "\n",
       "                                   address           phone  \\\n",
       "0     1301 LHOB; Washington, DC 20515-6001  (202) 225-2171   \n",
       "1  H307 CAPITOL; Washington, DC 20515-6015  (202) 225-2771   \n",
       "2     2216 RHOB; Washington, DC 20515-6035  (202) 225-4151   \n",
       "3     2129 RHOB; Washington, DC 20515-6050  (202) 225-7502   \n",
       "4      204 CHOB; Washington, DC 20515-6065  (202) 226-7270   \n",
       "\n",
       "                                            rss_url  \\\n",
       "0  https://agriculture.house.gov/Rss.aspx?GroupID=1   \n",
       "1                                               NaN   \n",
       "2                                               NaN   \n",
       "3                                               NaN   \n",
       "4            https://budget.house.gov/news/rss.aspx   \n",
       "\n",
       "                                        jurisdiction  \\\n",
       "0  The House Committee on Agriculture has legisla...   \n",
       "1  The House Committee on Appropriations is respo...   \n",
       "2  The House Committee on Armed Services has legi...   \n",
       "3  The House Financial Services Committee has jur...   \n",
       "4  The House Committee on the Budget is responsib...   \n",
       "\n",
       "                 youtube_id                         jurisdiction_source  \\\n",
       "0  UCOWh2WJxPywHIaccDWb8Mvg                                         NaN   \n",
       "1  UCMaSlF09S0fpoRshS2t_7XA     https://appropriations.house.gov/about/   \n",
       "2  UCD506yORW2voSanqEgLOUIQ       https://armedservices.house.gov/about   \n",
       "3  UCiGw0gRK-daU7Xv4oDMr9Hg  https://financialservices.house.gov/about/   \n",
       "4  UCwzia2rpHJkowAXK-IF9E0w             https://budget.house.gov/about/   \n",
       "\n",
       "                             minority_rss_url senate_committee_id wikipedia  \n",
       "0                                         NaN                 NaN       NaN  \n",
       "1                                         NaN                 NaN       NaN  \n",
       "2                                         NaN                 NaN       NaN  \n",
       "3                                         NaN                 NaN       NaN  \n",
       "4  https://democrats-budget.house.gov/rss.xml                 NaN       NaN  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# URL of the JSON file\n",
    "json_url = \" https://theunitedstates.io/congress-legislators/committees-current.json\"\n",
    "\n",
    "# Send a GET request to the URL and get the JSON data\n",
    "response = requests.get(json_url)\n",
    "data = response.json()\n",
    "\n",
    "curr_committee_df = pd.DataFrame(data)\n",
    "curr_committee_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Cleanup unecessary columns\n",
    "curr_committee_df.drop(['minority_url', 'rss_url', 'minority_rss_url', 'house_committee_id', 'subcommittees', 'jurisdiction_source', 'senate_committee_id', 'wikipedia', 'youtube_id'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>type</th>\n",
       "      <th>name</th>\n",
       "      <th>url</th>\n",
       "      <th>thomas_id</th>\n",
       "      <th>address</th>\n",
       "      <th>phone</th>\n",
       "      <th>jurisdiction</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Agriculture</td>\n",
       "      <td>https://agriculture.house.gov/</td>\n",
       "      <td>HSAG</td>\n",
       "      <td>1301 LHOB; Washington, DC 20515-6001</td>\n",
       "      <td>(202) 225-2171</td>\n",
       "      <td>The House Committee on Agriculture has legisla...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Appropriations</td>\n",
       "      <td>https://appropriations.house.gov/</td>\n",
       "      <td>HSAP</td>\n",
       "      <td>H307 CAPITOL; Washington, DC 20515-6015</td>\n",
       "      <td>(202) 225-2771</td>\n",
       "      <td>The House Committee on Appropriations is respo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Armed Services</td>\n",
       "      <td>https://armedservices.house.gov/</td>\n",
       "      <td>HSAS</td>\n",
       "      <td>2216 RHOB; Washington, DC 20515-6035</td>\n",
       "      <td>(202) 225-4151</td>\n",
       "      <td>The House Committee on Armed Services has legi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Financial Services</td>\n",
       "      <td>https://financialservices.house.gov/</td>\n",
       "      <td>HSBA</td>\n",
       "      <td>2129 RHOB; Washington, DC 20515-6050</td>\n",
       "      <td>(202) 225-7502</td>\n",
       "      <td>The House Financial Services Committee has jur...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on the Budget</td>\n",
       "      <td>https://budget.house.gov/</td>\n",
       "      <td>HSBU</td>\n",
       "      <td>204 CHOB; Washington, DC 20515-6065</td>\n",
       "      <td>(202) 226-7270</td>\n",
       "      <td>The House Committee on the Budget is responsib...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Education and the Workforce</td>\n",
       "      <td>https://edlabor.house.gov/</td>\n",
       "      <td>HSED</td>\n",
       "      <td>2176 RHOB; Washington, DC 20515-6100</td>\n",
       "      <td>(202) 225-4527</td>\n",
       "      <td>The committee has legislative jurisdiction ove...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Foreign Affairs</td>\n",
       "      <td>https://foreignaffairs.house.gov/</td>\n",
       "      <td>HSFA</td>\n",
       "      <td>2170 RHOB; Washington, DC 20515-6128</td>\n",
       "      <td>(202) 226-8467</td>\n",
       "      <td>The House Committee on Foreign Affairs conside...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Oversight and Accountability</td>\n",
       "      <td>https://oversight.house.gov/</td>\n",
       "      <td>HSGO</td>\n",
       "      <td>2157 RHOB; Washington, DC 20515-6143</td>\n",
       "      <td>(202) 225-5074</td>\n",
       "      <td>The committee oversees the federal government ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on House Administration</td>\n",
       "      <td>https://cha.house.gov/</td>\n",
       "      <td>HSHA</td>\n",
       "      <td>1309 LHOB; Washington, DC 20515-6157</td>\n",
       "      <td>(202) 225-8281</td>\n",
       "      <td>The Committee on House Administration has legi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Homeland Security</td>\n",
       "      <td>https://homeland.house.gov/</td>\n",
       "      <td>HSHM</td>\n",
       "      <td>176 FHOB; Washington, DC 20515-6480</td>\n",
       "      <td>(202) 226-8417</td>\n",
       "      <td>The House Committee on Homeland Security has j...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Energy and Commerce</td>\n",
       "      <td>https://energycommerce.house.gov/</td>\n",
       "      <td>HSIF</td>\n",
       "      <td>2125 RHOB; Washington, DC 20515-6115</td>\n",
       "      <td>(202) 225-3641</td>\n",
       "      <td>The House Committee on Energy and Commerce has...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Natural Resources</td>\n",
       "      <td>https://naturalresources.house.gov/</td>\n",
       "      <td>HSII</td>\n",
       "      <td>1324 LHOB; Washington, DC 20515-6201</td>\n",
       "      <td>(202) 225-2761</td>\n",
       "      <td>The House Committee on Natural Resources consi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>house</td>\n",
       "      <td>House Permanent Select Committee on Intelligence</td>\n",
       "      <td>https://intelligence.house.gov/</td>\n",
       "      <td>HLIG</td>\n",
       "      <td>HVC304 CAPITOL; Washington, DC 20515-6415</td>\n",
       "      <td>(202) 225-4121</td>\n",
       "      <td>The United States House Permanent Select Commi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on the Judiciary</td>\n",
       "      <td>https://judiciary.house.gov/</td>\n",
       "      <td>HSJU</td>\n",
       "      <td>2138 RHOB; Washington, DC 20515-6216</td>\n",
       "      <td>(202) 225-6906</td>\n",
       "      <td>The Committee on the Judiciary has jurisdictio...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Transportation and Infrastr...</td>\n",
       "      <td>https://transportation.house.gov/</td>\n",
       "      <td>HSPW</td>\n",
       "      <td>2165 RHOB; Washington, DC 20515-6256</td>\n",
       "      <td>(202) 225-9446</td>\n",
       "      <td>The Transportation and Infrastructure Committe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Rules</td>\n",
       "      <td>https://rules.house.gov/</td>\n",
       "      <td>HSRU</td>\n",
       "      <td>H312 CAPITOL; Washington, DC 20515-6269</td>\n",
       "      <td>(202) 225-9191</td>\n",
       "      <td>The House Committee on Rules is commonly known...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Small Business</td>\n",
       "      <td>https://smallbusiness.house.gov/</td>\n",
       "      <td>HSSM</td>\n",
       "      <td>2361 RHOB; Washington, DC 20515-6315</td>\n",
       "      <td>(202) 225-5821</td>\n",
       "      <td>The House Small Business Committee was establi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Ethics</td>\n",
       "      <td>https://ethics.house.gov/</td>\n",
       "      <td>HSSO</td>\n",
       "      <td>1015 LHOB; Washington, DC 20515-6328</td>\n",
       "      <td>(202) 225-7103</td>\n",
       "      <td>The House Committee on Ethics has the jurisdic...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Science, Space, and Technology</td>\n",
       "      <td>https://science.house.gov/</td>\n",
       "      <td>HSSY</td>\n",
       "      <td>2321 RHOB; Washington, DC 20515-6301</td>\n",
       "      <td>(202) 225-6371</td>\n",
       "      <td>The Committee on Science, Space, and Technolog...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Veterans' Affairs</td>\n",
       "      <td>https://veterans.house.gov/</td>\n",
       "      <td>HSVR</td>\n",
       "      <td>364 CHOB; Washington, DC 20515-6335</td>\n",
       "      <td>(202) 225-3527</td>\n",
       "      <td>The House Committee on Veterans' Affairs is th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Ways and Means</td>\n",
       "      <td>https://waysandmeans.house.gov/</td>\n",
       "      <td>HSWM</td>\n",
       "      <td>1139 LHOB; Washington, DC 20515-6348</td>\n",
       "      <td>(202) 225-3625</td>\n",
       "      <td>The Committee on Ways and Means is the chief t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>joint</td>\n",
       "      <td>Commission on Security and Cooperation in Europe</td>\n",
       "      <td>http://www.csce.gov/</td>\n",
       "      <td>JCSE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>joint</td>\n",
       "      <td>Joint Economic Committee</td>\n",
       "      <td>http://www.jec.senate.gov/</td>\n",
       "      <td>JSEC</td>\n",
       "      <td>SD-G01 DSOB; Washington, DC 20510-6432</td>\n",
       "      <td>(202) 224-5171</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>joint</td>\n",
       "      <td>Joint Committee on the Library</td>\n",
       "      <td>https://cha.house.gov/jointcommittees/joint-co...</td>\n",
       "      <td>JSLC</td>\n",
       "      <td>1309 LHOB; Washington, DC 20515-6157</td>\n",
       "      <td>(202) 225-8281</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>joint</td>\n",
       "      <td>Joint Committee on Printing</td>\n",
       "      <td>https://cha.house.gov/jointcommittees/joint-co...</td>\n",
       "      <td>JSPR</td>\n",
       "      <td>1309 LHOB; Washington, DC 20515-6446</td>\n",
       "      <td>(202) 225-8281</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>joint</td>\n",
       "      <td>Joint Committee on Taxation</td>\n",
       "      <td>https://www.jct.gov</td>\n",
       "      <td>JSTX</td>\n",
       "      <td>502 FHOB; Washington, DC 20515-6453</td>\n",
       "      <td>(202) 225-3621</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>senate</td>\n",
       "      <td>United States Senate Caucus on International N...</td>\n",
       "      <td>http://www.drugcaucus.senate.gov/</td>\n",
       "      <td>SCNC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Caucus on International Narcotics C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Select Committee on Ethics</td>\n",
       "      <td>http://www.ethics.senate.gov/</td>\n",
       "      <td>SLET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Select Committee on Ethics is autho...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on Indian Affairs</td>\n",
       "      <td>http://www.indian.senate.gov/</td>\n",
       "      <td>SLIA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on Indian Affairs has jur...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Select Committee on Intelligence</td>\n",
       "      <td>http://www.intelligence.senate.gov/</td>\n",
       "      <td>SLIN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on Intelligence was creat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Special Committee on Aging</td>\n",
       "      <td>http://www.aging.senate.gov/</td>\n",
       "      <td>SPAG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Special Committee on Aging conducts...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on Agriculture, Nutrition, an...</td>\n",
       "      <td>http://www.agriculture.senate.gov/</td>\n",
       "      <td>SSAF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on Agriculture has legisl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on Appropriations</td>\n",
       "      <td>http://www.appropriations.senate.gov/</td>\n",
       "      <td>SSAP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on Appropriations is resp...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on Armed Services</td>\n",
       "      <td>http://www.armed-services.senate.gov/</td>\n",
       "      <td>SSAS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on Armed Services has leg...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on Banking, Housing, and Urba...</td>\n",
       "      <td>http://banking.senate.gov/</td>\n",
       "      <td>SSBK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on Banking, Housing, and ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on the Budget</td>\n",
       "      <td>http://www.budget.senate.gov/</td>\n",
       "      <td>SSBU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on the Budget is responsi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on Commerce, Science, and Tra...</td>\n",
       "      <td>http://www.commerce.senate.gov/</td>\n",
       "      <td>SSCM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on Commerce, Science, and...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on Energy and Natural Resources</td>\n",
       "      <td>http://www.energy.senate.gov/</td>\n",
       "      <td>SSEG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on Energy and Natural Res...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on Environment and Public Works</td>\n",
       "      <td>http://www.epw.senate.gov/</td>\n",
       "      <td>SSEV</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on Environment and Public...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on Finance</td>\n",
       "      <td>http://www.finance.senate.gov/</td>\n",
       "      <td>SSFI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on Finance has legislativ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on Foreign Relations</td>\n",
       "      <td>http://www.foreign.senate.gov/</td>\n",
       "      <td>SSFR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on Foreign Relations was ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on Homeland Security and Gove...</td>\n",
       "      <td>http://www.hsgac.senate.gov/</td>\n",
       "      <td>SSGA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on Homeland Security and ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on Health, Education, Labor, ...</td>\n",
       "      <td>http://www.help.senate.gov/</td>\n",
       "      <td>SSHR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on Health, Education, Lab...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on the Judiciary</td>\n",
       "      <td>http://www.judiciary.senate.gov/</td>\n",
       "      <td>SSJU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on the Judiciary provides...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on Rules and Administration</td>\n",
       "      <td>http://www.rules.senate.gov/</td>\n",
       "      <td>SSRA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on Rules and Administrati...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on Small Business and Entrepr...</td>\n",
       "      <td>http://www.sbc.senate.gov/</td>\n",
       "      <td>SSSB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on Small Business and Ent...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>senate</td>\n",
       "      <td>Senate Committee on Veterans' Affairs</td>\n",
       "      <td>http://www.veterans.senate.gov/</td>\n",
       "      <td>SSVA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Senate Committee on Veterans' Affairs has ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>house</td>\n",
       "      <td>House Select Subcommittee on the Coronavirus P...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HSVC</td>\n",
       "      <td>2157 RHOB; Washington, DC 20515</td>\n",
       "      <td>(202) 225-5074</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>house</td>\n",
       "      <td>House Select Subcommittee on the Weaponization...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HSFD</td>\n",
       "      <td>2138 RHOB; Washington, DC 20515</td>\n",
       "      <td>(202) 225-6906</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>house</td>\n",
       "      <td>House Select Committee on the Strategic Compet...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HSZS</td>\n",
       "      <td>548 CHOB; Washington, DC 20515</td>\n",
       "      <td>(202) 226-9678</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      type                                               name  \\\n",
       "0    house                     House Committee on Agriculture   \n",
       "1    house                  House Committee on Appropriations   \n",
       "2    house                  House Committee on Armed Services   \n",
       "3    house              House Committee on Financial Services   \n",
       "4    house                      House Committee on the Budget   \n",
       "5    house     House Committee on Education and the Workforce   \n",
       "6    house                 House Committee on Foreign Affairs   \n",
       "7    house    House Committee on Oversight and Accountability   \n",
       "8    house            House Committee on House Administration   \n",
       "9    house               House Committee on Homeland Security   \n",
       "10   house             House Committee on Energy and Commerce   \n",
       "11   house               House Committee on Natural Resources   \n",
       "12   house   House Permanent Select Committee on Intelligence   \n",
       "13   house                   House Committee on the Judiciary   \n",
       "14   house  House Committee on Transportation and Infrastr...   \n",
       "15   house                           House Committee on Rules   \n",
       "16   house                  House Committee on Small Business   \n",
       "17   house                          House Committee on Ethics   \n",
       "18   house  House Committee on Science, Space, and Technology   \n",
       "19   house               House Committee on Veterans' Affairs   \n",
       "20   house                  House Committee on Ways and Means   \n",
       "21   joint   Commission on Security and Cooperation in Europe   \n",
       "22   joint                           Joint Economic Committee   \n",
       "23   joint                     Joint Committee on the Library   \n",
       "24   joint                        Joint Committee on Printing   \n",
       "25   joint                        Joint Committee on Taxation   \n",
       "26  senate  United States Senate Caucus on International N...   \n",
       "27  senate                  Senate Select Committee on Ethics   \n",
       "28  senate                 Senate Committee on Indian Affairs   \n",
       "29  senate            Senate Select Committee on Intelligence   \n",
       "30  senate                  Senate Special Committee on Aging   \n",
       "31  senate  Senate Committee on Agriculture, Nutrition, an...   \n",
       "32  senate                 Senate Committee on Appropriations   \n",
       "33  senate                 Senate Committee on Armed Services   \n",
       "34  senate  Senate Committee on Banking, Housing, and Urba...   \n",
       "35  senate                     Senate Committee on the Budget   \n",
       "36  senate  Senate Committee on Commerce, Science, and Tra...   \n",
       "37  senate   Senate Committee on Energy and Natural Resources   \n",
       "38  senate   Senate Committee on Environment and Public Works   \n",
       "39  senate                        Senate Committee on Finance   \n",
       "40  senate              Senate Committee on Foreign Relations   \n",
       "41  senate  Senate Committee on Homeland Security and Gove...   \n",
       "42  senate  Senate Committee on Health, Education, Labor, ...   \n",
       "43  senate                  Senate Committee on the Judiciary   \n",
       "44  senate       Senate Committee on Rules and Administration   \n",
       "45  senate  Senate Committee on Small Business and Entrepr...   \n",
       "46  senate              Senate Committee on Veterans' Affairs   \n",
       "47   house  House Select Subcommittee on the Coronavirus P...   \n",
       "48   house  House Select Subcommittee on the Weaponization...   \n",
       "49   house  House Select Committee on the Strategic Compet...   \n",
       "\n",
       "                                                  url thomas_id  \\\n",
       "0                      https://agriculture.house.gov/      HSAG   \n",
       "1                   https://appropriations.house.gov/      HSAP   \n",
       "2                    https://armedservices.house.gov/      HSAS   \n",
       "3                https://financialservices.house.gov/      HSBA   \n",
       "4                           https://budget.house.gov/      HSBU   \n",
       "5                          https://edlabor.house.gov/      HSED   \n",
       "6                   https://foreignaffairs.house.gov/      HSFA   \n",
       "7                        https://oversight.house.gov/      HSGO   \n",
       "8                              https://cha.house.gov/      HSHA   \n",
       "9                         https://homeland.house.gov/      HSHM   \n",
       "10                  https://energycommerce.house.gov/      HSIF   \n",
       "11                https://naturalresources.house.gov/      HSII   \n",
       "12                    https://intelligence.house.gov/      HLIG   \n",
       "13                       https://judiciary.house.gov/      HSJU   \n",
       "14                  https://transportation.house.gov/      HSPW   \n",
       "15                           https://rules.house.gov/      HSRU   \n",
       "16                   https://smallbusiness.house.gov/      HSSM   \n",
       "17                          https://ethics.house.gov/      HSSO   \n",
       "18                         https://science.house.gov/      HSSY   \n",
       "19                        https://veterans.house.gov/      HSVR   \n",
       "20                    https://waysandmeans.house.gov/      HSWM   \n",
       "21                               http://www.csce.gov/      JCSE   \n",
       "22                         http://www.jec.senate.gov/      JSEC   \n",
       "23  https://cha.house.gov/jointcommittees/joint-co...      JSLC   \n",
       "24  https://cha.house.gov/jointcommittees/joint-co...      JSPR   \n",
       "25                                https://www.jct.gov      JSTX   \n",
       "26                  http://www.drugcaucus.senate.gov/      SCNC   \n",
       "27                      http://www.ethics.senate.gov/      SLET   \n",
       "28                      http://www.indian.senate.gov/      SLIA   \n",
       "29                http://www.intelligence.senate.gov/      SLIN   \n",
       "30                       http://www.aging.senate.gov/      SPAG   \n",
       "31                 http://www.agriculture.senate.gov/      SSAF   \n",
       "32              http://www.appropriations.senate.gov/      SSAP   \n",
       "33              http://www.armed-services.senate.gov/      SSAS   \n",
       "34                         http://banking.senate.gov/      SSBK   \n",
       "35                      http://www.budget.senate.gov/      SSBU   \n",
       "36                    http://www.commerce.senate.gov/      SSCM   \n",
       "37                      http://www.energy.senate.gov/      SSEG   \n",
       "38                         http://www.epw.senate.gov/      SSEV   \n",
       "39                     http://www.finance.senate.gov/      SSFI   \n",
       "40                     http://www.foreign.senate.gov/      SSFR   \n",
       "41                       http://www.hsgac.senate.gov/      SSGA   \n",
       "42                        http://www.help.senate.gov/      SSHR   \n",
       "43                   http://www.judiciary.senate.gov/      SSJU   \n",
       "44                       http://www.rules.senate.gov/      SSRA   \n",
       "45                         http://www.sbc.senate.gov/      SSSB   \n",
       "46                    http://www.veterans.senate.gov/      SSVA   \n",
       "47                                                NaN      HSVC   \n",
       "48                                                NaN      HSFD   \n",
       "49                                                NaN      HSZS   \n",
       "\n",
       "                                      address           phone  \\\n",
       "0        1301 LHOB; Washington, DC 20515-6001  (202) 225-2171   \n",
       "1     H307 CAPITOL; Washington, DC 20515-6015  (202) 225-2771   \n",
       "2        2216 RHOB; Washington, DC 20515-6035  (202) 225-4151   \n",
       "3        2129 RHOB; Washington, DC 20515-6050  (202) 225-7502   \n",
       "4         204 CHOB; Washington, DC 20515-6065  (202) 226-7270   \n",
       "5        2176 RHOB; Washington, DC 20515-6100  (202) 225-4527   \n",
       "6        2170 RHOB; Washington, DC 20515-6128  (202) 226-8467   \n",
       "7        2157 RHOB; Washington, DC 20515-6143  (202) 225-5074   \n",
       "8        1309 LHOB; Washington, DC 20515-6157  (202) 225-8281   \n",
       "9         176 FHOB; Washington, DC 20515-6480  (202) 226-8417   \n",
       "10       2125 RHOB; Washington, DC 20515-6115  (202) 225-3641   \n",
       "11       1324 LHOB; Washington, DC 20515-6201  (202) 225-2761   \n",
       "12  HVC304 CAPITOL; Washington, DC 20515-6415  (202) 225-4121   \n",
       "13       2138 RHOB; Washington, DC 20515-6216  (202) 225-6906   \n",
       "14       2165 RHOB; Washington, DC 20515-6256  (202) 225-9446   \n",
       "15    H312 CAPITOL; Washington, DC 20515-6269  (202) 225-9191   \n",
       "16       2361 RHOB; Washington, DC 20515-6315  (202) 225-5821   \n",
       "17       1015 LHOB; Washington, DC 20515-6328  (202) 225-7103   \n",
       "18       2321 RHOB; Washington, DC 20515-6301  (202) 225-6371   \n",
       "19        364 CHOB; Washington, DC 20515-6335  (202) 225-3527   \n",
       "20       1139 LHOB; Washington, DC 20515-6348  (202) 225-3625   \n",
       "21                                        NaN             NaN   \n",
       "22     SD-G01 DSOB; Washington, DC 20510-6432  (202) 224-5171   \n",
       "23       1309 LHOB; Washington, DC 20515-6157  (202) 225-8281   \n",
       "24       1309 LHOB; Washington, DC 20515-6446  (202) 225-8281   \n",
       "25        502 FHOB; Washington, DC 20515-6453  (202) 225-3621   \n",
       "26                                        NaN             NaN   \n",
       "27                                        NaN             NaN   \n",
       "28                                        NaN             NaN   \n",
       "29                                        NaN             NaN   \n",
       "30                                        NaN             NaN   \n",
       "31                                        NaN             NaN   \n",
       "32                                        NaN             NaN   \n",
       "33                                        NaN             NaN   \n",
       "34                                        NaN             NaN   \n",
       "35                                        NaN             NaN   \n",
       "36                                        NaN             NaN   \n",
       "37                                        NaN             NaN   \n",
       "38                                        NaN             NaN   \n",
       "39                                        NaN             NaN   \n",
       "40                                        NaN             NaN   \n",
       "41                                        NaN             NaN   \n",
       "42                                        NaN             NaN   \n",
       "43                                        NaN             NaN   \n",
       "44                                        NaN             NaN   \n",
       "45                                        NaN             NaN   \n",
       "46                                        NaN             NaN   \n",
       "47            2157 RHOB; Washington, DC 20515  (202) 225-5074   \n",
       "48            2138 RHOB; Washington, DC 20515  (202) 225-6906   \n",
       "49             548 CHOB; Washington, DC 20515  (202) 226-9678   \n",
       "\n",
       "                                         jurisdiction  \n",
       "0   The House Committee on Agriculture has legisla...  \n",
       "1   The House Committee on Appropriations is respo...  \n",
       "2   The House Committee on Armed Services has legi...  \n",
       "3   The House Financial Services Committee has jur...  \n",
       "4   The House Committee on the Budget is responsib...  \n",
       "5   The committee has legislative jurisdiction ove...  \n",
       "6   The House Committee on Foreign Affairs conside...  \n",
       "7   The committee oversees the federal government ...  \n",
       "8   The Committee on House Administration has legi...  \n",
       "9   The House Committee on Homeland Security has j...  \n",
       "10  The House Committee on Energy and Commerce has...  \n",
       "11  The House Committee on Natural Resources consi...  \n",
       "12  The United States House Permanent Select Commi...  \n",
       "13  The Committee on the Judiciary has jurisdictio...  \n",
       "14  The Transportation and Infrastructure Committe...  \n",
       "15  The House Committee on Rules is commonly known...  \n",
       "16  The House Small Business Committee was establi...  \n",
       "17  The House Committee on Ethics has the jurisdic...  \n",
       "18  The Committee on Science, Space, and Technolog...  \n",
       "19  The House Committee on Veterans' Affairs is th...  \n",
       "20  The Committee on Ways and Means is the chief t...  \n",
       "21                                                NaN  \n",
       "22                                                NaN  \n",
       "23                                                NaN  \n",
       "24                                                NaN  \n",
       "25                                                NaN  \n",
       "26  The Senate Caucus on International Narcotics C...  \n",
       "27  The Senate Select Committee on Ethics is autho...  \n",
       "28  The Senate Committee on Indian Affairs has jur...  \n",
       "29  The Senate Committee on Intelligence was creat...  \n",
       "30  The Senate Special Committee on Aging conducts...  \n",
       "31  The Senate Committee on Agriculture has legisl...  \n",
       "32  The Senate Committee on Appropriations is resp...  \n",
       "33  The Senate Committee on Armed Services has leg...  \n",
       "34  The Senate Committee on Banking, Housing, and ...  \n",
       "35  The Senate Committee on the Budget is responsi...  \n",
       "36  The Senate Committee on Commerce, Science, and...  \n",
       "37  The Senate Committee on Energy and Natural Res...  \n",
       "38  The Senate Committee on Environment and Public...  \n",
       "39  The Senate Committee on Finance has legislativ...  \n",
       "40  The Senate Committee on Foreign Relations was ...  \n",
       "41  The Senate Committee on Homeland Security and ...  \n",
       "42  The Senate Committee on Health, Education, Lab...  \n",
       "43  The Senate Committee on the Judiciary provides...  \n",
       "44  The Senate Committee on Rules and Administrati...  \n",
       "45  The Senate Committee on Small Business and Ent...  \n",
       "46  The Senate Committee on Veterans' Affairs has ...  \n",
       "47                                                NaN  \n",
       "48                                                NaN  \n",
       "49                                                NaN  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "curr_committee_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>thomas_id</th>\n",
       "      <th>name</th>\n",
       "      <th>party</th>\n",
       "      <th>rank</th>\n",
       "      <th>title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>HSII</td>\n",
       "      <td>Bruce Westerman</td>\n",
       "      <td>majority</td>\n",
       "      <td>1</td>\n",
       "      <td>Chair</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>HSII</td>\n",
       "      <td>Raúl M. Grijalva</td>\n",
       "      <td>minority</td>\n",
       "      <td>1</td>\n",
       "      <td>Ranking Member</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>HSII</td>\n",
       "      <td>Doug Lamborn</td>\n",
       "      <td>majority</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>HSII</td>\n",
       "      <td>Grace F. Napolitano</td>\n",
       "      <td>minority</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>HSII</td>\n",
       "      <td>Robert J. Wittman</td>\n",
       "      <td>majority</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  thomas_id                 name     party  rank           title\n",
       "0      HSII      Bruce Westerman  majority     1           Chair\n",
       "1      HSII     Raúl M. Grijalva  minority     1  Ranking Member\n",
       "2      HSII         Doug Lamborn  majority     2             NaN\n",
       "3      HSII  Grace F. Napolitano  minority     2             NaN\n",
       "4      HSII    Robert J. Wittman  majority     3             NaN"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# URL of the JSON file\n",
    "json_url = \"https://theunitedstates.io/congress-legislators/committee-membership-current.json\"\n",
    "\n",
    "# Send a GET request to the URL and get the JSON data\n",
    "response = requests.get(json_url)\n",
    "data = response.json()\n",
    "\n",
    "\n",
    "# Create a list from the JSON data for each committee and then create a dataframe from the list\n",
    "for key in data.keys():\n",
    "    df = pd.DataFrame(data[key])\n",
    "\n",
    "\n",
    "# merge all the dataframes into one\n",
    "merged_df = pd.concat([pd.DataFrame(data[key]) for key in data.keys()], keys=data.keys())\n",
    "\n",
    "#reset index to thomas_id\n",
    "merged_df.reset_index(inplace=True)\n",
    "\n",
    "\n",
    "#remaname level_0 to thomas_id\n",
    "merged_df.rename(columns={'level_0':'thomas_id'}, inplace=True)\n",
    "#drop level_1\n",
    "merged_df.drop(['level_1', 'chamber', 'bioguide'], axis=1, inplace=True)\n",
    "\n",
    "merged_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>type</th>\n",
       "      <th>committee</th>\n",
       "      <th>url</th>\n",
       "      <th>thomas_id</th>\n",
       "      <th>address</th>\n",
       "      <th>phone</th>\n",
       "      <th>jurisdiction</th>\n",
       "      <th>member_name</th>\n",
       "      <th>party</th>\n",
       "      <th>rank</th>\n",
       "      <th>title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Agriculture</td>\n",
       "      <td>https://agriculture.house.gov/</td>\n",
       "      <td>HSAG</td>\n",
       "      <td>1301 LHOB; Washington, DC 20515-6001</td>\n",
       "      <td>(202) 225-2171</td>\n",
       "      <td>The House Committee on Agriculture has legisla...</td>\n",
       "      <td>Glenn Thompson</td>\n",
       "      <td>majority</td>\n",
       "      <td>1</td>\n",
       "      <td>Chair</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Agriculture</td>\n",
       "      <td>https://agriculture.house.gov/</td>\n",
       "      <td>HSAG</td>\n",
       "      <td>1301 LHOB; Washington, DC 20515-6001</td>\n",
       "      <td>(202) 225-2171</td>\n",
       "      <td>The House Committee on Agriculture has legisla...</td>\n",
       "      <td>David Scott</td>\n",
       "      <td>minority</td>\n",
       "      <td>1</td>\n",
       "      <td>Ranking Member</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Agriculture</td>\n",
       "      <td>https://agriculture.house.gov/</td>\n",
       "      <td>HSAG</td>\n",
       "      <td>1301 LHOB; Washington, DC 20515-6001</td>\n",
       "      <td>(202) 225-2171</td>\n",
       "      <td>The House Committee on Agriculture has legisla...</td>\n",
       "      <td>Frank D. Lucas</td>\n",
       "      <td>majority</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Agriculture</td>\n",
       "      <td>https://agriculture.house.gov/</td>\n",
       "      <td>HSAG</td>\n",
       "      <td>1301 LHOB; Washington, DC 20515-6001</td>\n",
       "      <td>(202) 225-2171</td>\n",
       "      <td>The House Committee on Agriculture has legisla...</td>\n",
       "      <td>Jim Costa</td>\n",
       "      <td>minority</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Agriculture</td>\n",
       "      <td>https://agriculture.house.gov/</td>\n",
       "      <td>HSAG</td>\n",
       "      <td>1301 LHOB; Washington, DC 20515-6001</td>\n",
       "      <td>(202) 225-2171</td>\n",
       "      <td>The House Committee on Agriculture has legisla...</td>\n",
       "      <td>Austin Scott</td>\n",
       "      <td>majority</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    type                       committee                             url  \\\n",
       "0  house  House Committee on Agriculture  https://agriculture.house.gov/   \n",
       "1  house  House Committee on Agriculture  https://agriculture.house.gov/   \n",
       "2  house  House Committee on Agriculture  https://agriculture.house.gov/   \n",
       "3  house  House Committee on Agriculture  https://agriculture.house.gov/   \n",
       "4  house  House Committee on Agriculture  https://agriculture.house.gov/   \n",
       "\n",
       "  thomas_id                               address           phone  \\\n",
       "0      HSAG  1301 LHOB; Washington, DC 20515-6001  (202) 225-2171   \n",
       "1      HSAG  1301 LHOB; Washington, DC 20515-6001  (202) 225-2171   \n",
       "2      HSAG  1301 LHOB; Washington, DC 20515-6001  (202) 225-2171   \n",
       "3      HSAG  1301 LHOB; Washington, DC 20515-6001  (202) 225-2171   \n",
       "4      HSAG  1301 LHOB; Washington, DC 20515-6001  (202) 225-2171   \n",
       "\n",
       "                                        jurisdiction     member_name  \\\n",
       "0  The House Committee on Agriculture has legisla...  Glenn Thompson   \n",
       "1  The House Committee on Agriculture has legisla...     David Scott   \n",
       "2  The House Committee on Agriculture has legisla...  Frank D. Lucas   \n",
       "3  The House Committee on Agriculture has legisla...       Jim Costa   \n",
       "4  The House Committee on Agriculture has legisla...    Austin Scott   \n",
       "\n",
       "      party  rank           title  \n",
       "0  majority     1           Chair  \n",
       "1  minority     1  Ranking Member  \n",
       "2  majority     2             NaN  \n",
       "3  minority     2             NaN  \n",
       "4  majority     3             NaN  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#merge the current committee dataframe with the merged_df dataframe\n",
    "merged_committee_df = pd.merge(curr_committee_df, merged_df, on=\"thomas_id\", how=\"outer\")\n",
    "merged_committee_df.rename(columns={'name_x':'committee'}, inplace=True)\n",
    "merged_committee_df.rename(columns={'name_y':'member_name'}, inplace=True)\n",
    "merged_committee_df.dropna(subset=['committee'], inplace=True)\n",
    "merged_committee_df.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>type</th>\n",
       "      <th>committee</th>\n",
       "      <th>url</th>\n",
       "      <th>thomas_id</th>\n",
       "      <th>address</th>\n",
       "      <th>phone</th>\n",
       "      <th>jurisdiction</th>\n",
       "      <th>member_name</th>\n",
       "      <th>party</th>\n",
       "      <th>rank</th>\n",
       "      <th>title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Agriculture</td>\n",
       "      <td>https://agriculture.house.gov/</td>\n",
       "      <td>HSAG</td>\n",
       "      <td>1301 LHOB; Washington, DC 20515-6001</td>\n",
       "      <td>(202) 225-2171</td>\n",
       "      <td>The House Committee on Agriculture has legisla...</td>\n",
       "      <td>Austin Scott</td>\n",
       "      <td>majority</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>house</td>\n",
       "      <td>House Committee on Armed Services</td>\n",
       "      <td>https://armedservices.house.gov/</td>\n",
       "      <td>HSAS</td>\n",
       "      <td>2216 RHOB; Washington, DC 20515-6035</td>\n",
       "      <td>(202) 225-4151</td>\n",
       "      <td>The House Committee on Armed Services has legi...</td>\n",
       "      <td>Austin Scott</td>\n",
       "      <td>majority</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>566</th>\n",
       "      <td>house</td>\n",
       "      <td>House Permanent Select Committee on Intelligence</td>\n",
       "      <td>https://intelligence.house.gov/</td>\n",
       "      <td>HLIG</td>\n",
       "      <td>HVC304 CAPITOL; Washington, DC 20515-6415</td>\n",
       "      <td>(202) 225-4121</td>\n",
       "      <td>The United States House Permanent Select Commi...</td>\n",
       "      <td>Austin Scott</td>\n",
       "      <td>majority</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      type                                         committee  \\\n",
       "4    house                    House Committee on Agriculture   \n",
       "125  house                 House Committee on Armed Services   \n",
       "566  house  House Permanent Select Committee on Intelligence   \n",
       "\n",
       "                                  url thomas_id  \\\n",
       "4      https://agriculture.house.gov/      HSAG   \n",
       "125  https://armedservices.house.gov/      HSAS   \n",
       "566   https://intelligence.house.gov/      HLIG   \n",
       "\n",
       "                                       address           phone  \\\n",
       "4         1301 LHOB; Washington, DC 20515-6001  (202) 225-2171   \n",
       "125       2216 RHOB; Washington, DC 20515-6035  (202) 225-4151   \n",
       "566  HVC304 CAPITOL; Washington, DC 20515-6415  (202) 225-4121   \n",
       "\n",
       "                                          jurisdiction   member_name  \\\n",
       "4    The House Committee on Agriculture has legisla...  Austin Scott   \n",
       "125  The House Committee on Armed Services has legi...  Austin Scott   \n",
       "566  The United States House Permanent Select Commi...  Austin Scott   \n",
       "\n",
       "        party  rank title  \n",
       "4    majority     3   NaN  \n",
       "125  majority     6   NaN  \n",
       "566  majority    10   NaN  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#lookup all instances of member_name and show associated thomas_id\n",
    "member_committees = merged_committee_df.loc[merged_committee_df['member_name'] == 'Austin Scott']\n",
    "member_committees.head()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Glenn Thompson', 'David Scott', 'Frank D. Lucas', 'Jim Costa',\n",
       "       'Austin Scott', 'James P. McGovern', 'Eric A. \"Rick\" Crawford',\n",
       "       'Alma S. Adams', 'Scott DesJarlais', 'Abigail Davis Spanberger',\n",
       "       'Doug LaMalfa', 'Jahana Hayes', 'David Rouzer', 'Shontel M. Brown',\n",
       "       'Trent Kelly', 'Sharice Davids', 'Don Bacon', 'Elissa Slotkin',\n",
       "       'Mike Bost', 'Yadira Caraveo', 'Dusty Johnson', 'Andrea Salinas',\n",
       "       'James R. Baird', 'Marie Gluesenkamp Perez', 'Tracey Mann',\n",
       "       'Donald G. Davis', 'Randy Feenstra', 'Jill N. Tokuda',\n",
       "       'Mary E. Miller', 'Nikki Budzinski', 'Barry Moore',\n",
       "       'Eric Sorensen', 'Kat Cammack', 'Gabe Vasquez', 'Brad Finstad',\n",
       "       'Jasmine Crockett', 'John W. Rose', 'Jonathan L. Jackson',\n",
       "       'Ronny Jackson', 'Greg Casar', 'Marcus J. Molinaro',\n",
       "       'Chellie Pingree', 'Monica De La Cruz', 'Salud O. Carbajal',\n",
       "       'Nicholas A. Langworthy', 'Angie Craig', 'John S. Duarte',\n",
       "       'Darren Soto', 'Zachary Nunn', 'Sanford D. Bishop, Jr.',\n",
       "       'Mark Alford', 'Derrick Van Orden', 'Lori Chavez-DeRemer',\n",
       "       'Max L. Miller', 'Kay Granger', 'Rosa L. DeLauro', 'Harold Rogers',\n",
       "       'Steny H. Hoyer', 'Robert B. Aderholt', 'Marcy Kaptur',\n",
       "       'Michael K. Simpson', 'John R. Carter', 'Barbara Lee',\n",
       "       'Ken Calvert', 'Betty McCollum', 'Tom Cole',\n",
       "       'C. A. Dutch Ruppersberger', 'Mario Diaz-Balart',\n",
       "       'Debbie Wasserman Schultz', 'Steve Womack', 'Henry Cuellar',\n",
       "       'Charles J. \"Chuck\" Fleischmann', 'David P. Joyce', 'Mike Quigley',\n",
       "       'Andy Harris', 'Derek Kilmer', 'Mark E. Amodei', 'Matt Cartwright',\n",
       "       'Chris Stewart', 'Grace Meng', 'David G. Valadao', 'Mark Pocan',\n",
       "       'Dan Newhouse', 'Pete Aguilar', 'John R. Moolenaar',\n",
       "       'Lois Frankel', 'John H. Rutherford', 'Bonnie Watson Coleman',\n",
       "       'Ben Cline', 'Norma J. Torres', 'Guy Reschenthaler', 'Ed Case',\n",
       "       'Mike Garcia', 'Adriano Espaillat', 'Ashley Hinson', 'Josh Harder',\n",
       "       'Tony Gonzales', 'Jennifer Wexton', 'Julia Letlow',\n",
       "       'David J. Trone', 'Michael Cloud', 'Lauren Underwood',\n",
       "       'Michael Guest', 'Susie Lee', 'Ryan K. Zinke', 'Joseph D. Morelle',\n",
       "       'Andrew S. Clyde', 'Jake LaTurner', 'Jerry L. Carl',\n",
       "       'Stephanie I. Bice', 'C. Scott Franklin', 'Jake Ellzey',\n",
       "       'Juan Ciscomani', 'Mike Rogers', 'Adam Smith', 'Joe Wilson',\n",
       "       'Joe Courtney', 'Michael R. Turner', 'John Garamendi',\n",
       "       'Doug Lamborn', 'Donald Norcross', 'Robert J. Wittman',\n",
       "       'Ruben Gallego', 'Seth Moulton', 'Sam Graves', 'Elise M. Stefanik',\n",
       "       'Ro Khanna', 'William R. Keating', 'Andy Kim', 'Mike Gallagher',\n",
       "       'Chrissy Houlahan', 'Matt Gaetz', 'Mikie Sherrill', 'Jim Banks',\n",
       "       'Veronica Escobar', 'Jack Bergman', 'Jared F. Golden',\n",
       "       'Michael Waltz', 'Sara Jacobs', 'Mike Johnson',\n",
       "       'Marilyn Strickland', 'Lisa C. McClain', 'Patrick Ryan',\n",
       "       'Jeff Jackson', 'Pat Fallon', 'Carlos A. Gimenez',\n",
       "       'Christopher R. Deluzio', 'Nancy Mace', 'Dale W. Strong',\n",
       "       'Jennifer L. McClellan', 'Morgan Luttrell', 'Terri A. Sewell',\n",
       "       'Jennifer Kiggans', 'Steven Horsford', 'Nick LaLota',\n",
       "       'Jimmy Panetta', 'James C. Moylan', 'Marc A. Veasey', 'Cory Mills',\n",
       "       'Richard McCormick', 'Patrick T. McHenry', 'Maxine Waters',\n",
       "       'Nydia M. Velázquez', 'Pete Sessions', 'Brad Sherman',\n",
       "       'Bill Posey', 'Gregory W. Meeks', 'Blaine Luetkemeyer',\n",
       "       'Bill Huizenga', 'Stephen F. Lynch', 'Ann Wagner', 'Al Green',\n",
       "       'Andy Barr', 'Emanuel Cleaver', 'Roger Williams', 'James A. Himes',\n",
       "       'J. French Hill', 'Bill Foster', 'Tom Emmer', 'Joyce Beatty',\n",
       "       'Barry Loudermilk', 'Juan Vargas', 'Alexander X. Mooney',\n",
       "       'Josh Gottheimer', 'Warren Davidson', 'Vicente Gonzalez',\n",
       "       'Sean Casten', 'Bryan Steil', 'Ayanna Pressley',\n",
       "       'William R. Timmons IV', 'Ralph Norman', 'Rashida Tlaib',\n",
       "       'Daniel Meuser', 'Ritchie Torres', 'Young Kim', 'Sylvia R. Garcia',\n",
       "       'Byron Donalds', 'Nikema Williams', 'Andrew R. Garbarino',\n",
       "       'Wiley Nickel', 'Scott Fitzgerald', 'Brittany Pettersen',\n",
       "       'Mike Flood', 'Michael Lawler', 'Andrew Ogles', 'Erin Houchin',\n",
       "       'Jodey C. Arrington', 'Brendan F. Boyle', 'Brian Higgins',\n",
       "       'Tom McClintock', 'Janice D. Schakowsky', 'Glenn Grothman',\n",
       "       'Earl Blumenauer', 'Lloyd Smucker', 'Daniel T. Kildee',\n",
       "       'Michael C. Burgess', 'Scott H. Peters', 'Earl L. \"Buddy\" Carter',\n",
       "       'Lloyd Doggett', 'Bob Good', 'A. Drew Ferguson IV',\n",
       "       'Sheila Jackson Lee', 'Chip Roy', 'Ilhan Omar', 'Blake D. Moore',\n",
       "       'Becca Balint', 'Ron Estes', 'Robert C. \"Bobby\" Scott',\n",
       "       'Michelle Fischbach', 'Rudy Yakym III', 'Josh Brecheen',\n",
       "       'Chuck Edwards', 'Virginia Foxx', 'Raúl M. Grijalva',\n",
       "       'Tim Walberg', 'Gregorio Kilili Camacho Sablan',\n",
       "       'Frederica S. Wilson', 'Suzanne Bonamici', 'Rick W. Allen',\n",
       "       'Mark Takano', 'James Comer', 'Mark DeSaulnier', 'Burgess Owens',\n",
       "       'Pramila Jayapal', 'Susan Wild', 'Lucy McBath', 'Michelle Steel',\n",
       "       'Haley M. Stevens', 'Teresa Leger Fernandez', 'Kevin Kiley',\n",
       "       'Kathy E. Manning', 'Aaron Bean', 'Frank J. Mrvan',\n",
       "       'Eric Burlison', 'Jamaal Bowman', 'Nathaniel Moran', 'John James',\n",
       "       'Brandon Williams', 'Michael T. McCaul', 'Christopher H. Smith',\n",
       "       'Gerald E. Connolly', 'Scott Perry', 'Darrell Issa',\n",
       "       'David N. Cicilline', 'Ami Bera', 'Brian J. Mast',\n",
       "       'Joaquin Castro', 'Ken Buck', 'Dina Titus', 'Tim Burchett',\n",
       "       'Ted Lieu', 'Mark E. Green', 'Dean Phillips', 'Colin Z. Allred',\n",
       "       'Maria Elvira Salazar', 'Aumua Amata Coleman Radewagen',\n",
       "       'Sheila Cherfilus-McCormick', 'Greg Stanton', 'Madeleine Dean',\n",
       "       'Jared Moskowitz', 'Thomas H. Kean, Jr.', 'Sydney Kamlager-Dove',\n",
       "       'Jason Crow', 'Bradley Scott Schneider', 'Keith Self',\n",
       "       'Jamie Raskin', 'Jim Jordan', 'Eleanor Holmes Norton',\n",
       "       'Paul A. Gosar', 'Raja Krishnamoorthi', 'Gary J. Palmer',\n",
       "       'Kweisi Mfume', 'Clay Higgins', 'Alexandria Ocasio-Cortez',\n",
       "       'Katie Porter', 'Andy Biggs', 'Cori Bush', 'Jimmy Gomez',\n",
       "       'Melanie A. Stansbury', 'Robert Garcia', 'Kelly Armstrong',\n",
       "       'Maxwell Frost', 'Summer L. Lee', 'Marjorie Taylor Greene',\n",
       "       'Daniel S. Goldman', 'Lauren Boebert', 'Russell Fry',\n",
       "       'Anna Paulina Luna', 'H. Morgan Griffith', 'Gregory F. Murphy',\n",
       "       'Mike Carey', 'Laurel M. Lee', 'Anthony D’Esposito',\n",
       "       'Bennie G. Thompson', 'Donald M. Payne, Jr.', 'Eric Swalwell',\n",
       "       'Dan Bishop', 'J. Luis Correa', 'Troy A. Carter', 'August Pfluger',\n",
       "       'Shri Thanedar', 'Seth Magaziner', 'Glenn Ivey', 'Mike Ezell',\n",
       "       'Delia C. Ramirez', 'Robert Menendez', 'Yvette D. Clarke',\n",
       "       'Elijah Crane', 'Cathy McMorris Rodgers', 'Frank Pallone, Jr.',\n",
       "       'Anna G. Eshoo', 'Robert E. Latta', 'Diana DeGette',\n",
       "       'Brett Guthrie', 'Doris O. Matsui', 'Gus M. Bilirakis',\n",
       "       'Kathy Castor', 'Bill Johnson', 'John P. Sarbanes',\n",
       "       'Larry Bucshon', 'Paul Tonko', 'Richard Hudson', 'Tony Cárdenas',\n",
       "       'Raul Ruiz', 'Jeff Duncan', 'Debbie Dingell', 'Neal P. Dunn',\n",
       "       'John R. Curtis', 'Ann M. Kuster', 'Debbie Lesko',\n",
       "       'Robin L. Kelly', 'Greg Pence', 'Nanette Diaz Barragán',\n",
       "       'Dan Crenshaw', 'Lisa Blunt Rochester', 'John Joyce',\n",
       "       'Randy K. Weber, Sr.', 'Kim Schrier', 'Lori Trahan',\n",
       "       'Troy Balderson', 'Lizzie Fletcher', 'Russ Fulcher',\n",
       "       'Diana Harshbarger', 'Mariannette Miller-Meeks', 'Jay Obernolte',\n",
       "       'Bruce Westerman', 'Grace F. Napolitano', 'Jared Huffman',\n",
       "       'Garret Graves', 'Joe Neguse', 'Mike Levin', 'Daniel Webster',\n",
       "       'Jenniffer González-Colón', 'Mary Sattler Peltola', 'Pete Stauber',\n",
       "       'Kevin Mullin', 'Thomas P. Tiffany', 'Val T. Hoyle',\n",
       "       'Matthew M. Rosendale, Sr.', 'Cliff Bentz', 'Wesley Hunt',\n",
       "       'Mike Collins', 'Harriet M. Hageman', 'Brad R. Wenstrup',\n",
       "       'André Carson', 'Darin LaHood', 'Stacey E. Plaskett',\n",
       "       'Brian K. Fitzpatrick', 'Jerrold Nadler', 'Zoe Lofgren',\n",
       "       'Steve Cohen', 'Henry C. \"Hank\" Johnson, Jr.', 'Adam B. Schiff',\n",
       "       'Thomas Massie', 'Victoria Spartz', 'Mary Gay Scanlon',\n",
       "       'Lance Gooden', 'Jefferson Van Drew', 'Deborah K. Ross',\n",
       "       'Troy E. Nehls', 'Rick Larsen', 'Brian Babin', 'Julia Brownley',\n",
       "       'Jesús G. \"Chuy\" García', 'Chris Pappas', 'Jake Auchincloss',\n",
       "       'Emilia Strong Sykes', 'Hillary J. Scholten', 'Valerie P. Foushee',\n",
       "       'Beth Van Duyne', 'Greg Landsman', 'Morgan McGarvey', 'Judy Chu',\n",
       "       'Claudia Tenney', 'Jason Smith', 'Richard E. Neal',\n",
       "       'Vern Buchanan', 'Adrian Smith', 'Mike Thompson', 'Mike Kelly',\n",
       "       'John B. Larson', 'David Schweikert', 'Bill Pascrell, Jr.',\n",
       "       'Danny K. Davis', 'Linda T. Sánchez', 'Suzan K. DelBene',\n",
       "       'Kevin Hern', 'Carol D. Miller', 'Gwen Moore', 'David Kustoff',\n",
       "       'Donald S. Beyer, Jr.', 'Dwight Evans', 'W. Gregory Steube',\n",
       "       'Nicole Malliotakis', 'Benjamin L. Cardin', 'Sheldon Whitehouse',\n",
       "       'Jeanne Shaheen', 'Richard Blumenthal', 'Tina Smith',\n",
       "       'Roger F. Wicker', 'John Boozman', 'Thom Tillis', 'Tim Scott',\n",
       "       'Martin Heinrich', 'Amy Klobuchar', 'Margaret Wood Hassan',\n",
       "       'Mark Kelly', 'Peter Welch', 'John Fetterman', 'Mike Lee',\n",
       "       'Tom Cotton', 'Eric Schmitt', 'J.D. Vance', 'Mark R. Warner',\n",
       "       'Jon Ossoff', 'Deb Fischer', 'Cindy Hyde-Smith', 'Jeff Merkley',\n",
       "       'Alex Padilla', 'Bill Hagerty', 'Ron Wyden', 'Debbie Stabenow',\n",
       "       'Maria Cantwell', 'Mike Crapo', 'Chuck Grassley', 'Ben Ray Luján',\n",
       "       'John Cornyn', 'James E. Risch', 'Christopher A. Coons',\n",
       "       'Brian Schatz', 'James Lankford', 'Jon Tester',\n",
       "       'Catherine Cortez Masto', 'Lisa Murkowski', 'John Hoeven',\n",
       "       'Steve Daines', 'Markwayne Mullin', 'Mike Rounds',\n",
       "       'Dianne Feinstein', 'Angus S. King, Jr.', 'Michael F. Bennet',\n",
       "       'Robert P. Casey, Jr.', 'Kirsten E. Gillibrand', 'Jack Reed',\n",
       "       'Charles E. Schumer', 'Marco Rubio', 'Susan M. Collins',\n",
       "       'Jerry Moran', 'Mitch McConnell', 'Elizabeth Warren',\n",
       "       'Raphael G. Warnock', 'Mike Braun', 'Rick Scott', 'Pete Ricketts',\n",
       "       'Sherrod Brown', 'Richard J. Durbin', 'Cory A. Booker',\n",
       "       'Joni Ernst', 'Roger Marshall', 'Tommy Tuberville', 'John Thune',\n",
       "       'Patty Murray', 'Tammy Baldwin', 'Christopher Murphy',\n",
       "       'Joe Manchin, III', 'Chris Van Hollen', 'Gary C. Peters',\n",
       "       'Lindsey Graham', 'Shelley Moore Capito', 'John Kennedy',\n",
       "       'Katie Boyd Britt', 'Mazie K. Hirono', 'Tim Kaine',\n",
       "       'Tammy Duckworth', 'Jacky Rosen', 'Dan Sullivan', 'Kevin Cramer',\n",
       "       'Ted Budd', 'Kyrsten Sinema', 'Cynthia M. Lummis',\n",
       "       'Bernard Sanders', 'Ron Johnson', 'Mitt Romney',\n",
       "       'Edward J. Markey', 'John W. Hickenlooper', 'Ted Cruz',\n",
       "       'Marsha Blackburn', 'Todd Young', 'John Barrasso', 'Bill Cassidy',\n",
       "       'Josh Hawley', 'Thomas R. Carper', 'Rand Paul'], dtype=object)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list_members = merged_committee_df['member_name'].unique()\n",
    "list_members"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "json_url = \"https://theunitedstates.io/congress-legislators/legislators-current.json\"\n",
    "\n",
    "# Send a GET request to the URL and get the JSON data\n",
    "response = requests.get(json_url)\n",
    "data = response.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "served_terms = {} # key, senator value start end?\n",
    "# {sheerod: {start:1905, end: 2002}}\n",
    "for cg in data: # data list\n",
    "    #  'name', 'bio', 'terms'\n",
    "    # print(cg[\"name\"][\"first\"])\n",
    "    # print(cg[\"name\"]['official_full'])\n",
    "    # print(cg[\"terms\"])\n",
    "    for term in cg[\"terms\"]:\n",
    "        if cg[\"name\"][\"official_full\"] not in served_terms:\n",
    "            served_terms[cg[\"name\"][\"official_full\"]] = {\"start\": term[\"start\"], \"end\": term[\"end\"]}\n",
    "        elif cg[\"name\"][\"official_full\"] in served_terms:\n",
    "            served_terms[cg[\"name\"][\"official_full\"]][\"end\"] = term['end']\n",
    "\n",
    "        # print(term)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Sherrod Brown': {'start': '1993-01-05', 'end': '2025-01-03'},\n",
       " 'Maria Cantwell': {'start': '1993-01-05', 'end': '2025-01-03'},\n",
       " 'Benjamin L. Cardin': {'start': '1987-01-06', 'end': '2025-01-03'},\n",
       " 'Thomas R. Carper': {'start': '1983-01-03', 'end': '2025-01-03'},\n",
       " 'Robert P. Casey, Jr.': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Dianne Feinstein': {'start': '1992-11-10', 'end': '2025-01-03'},\n",
       " 'Amy Klobuchar': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Robert Menendez': {'start': '1993-01-05', 'end': '2025-01-03'},\n",
       " 'Bernard Sanders': {'start': '1991-01-03', 'end': '2025-01-03'},\n",
       " 'Debbie Stabenow': {'start': '1997-01-07', 'end': '2025-01-03'},\n",
       " 'Jon Tester': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Sheldon Whitehouse': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'John Barrasso': {'start': '2007-06-25', 'end': '2025-01-03'},\n",
       " 'Roger F. Wicker': {'start': '1995-01-04', 'end': '2025-01-03'},\n",
       " 'Susan M. Collins': {'start': '1997-01-07', 'end': '2027-01-03'},\n",
       " 'John Cornyn': {'start': '2002-11-30', 'end': '2027-01-03'},\n",
       " 'Richard J. Durbin': {'start': '1983-01-03', 'end': '2027-01-03'},\n",
       " 'Lindsey Graham': {'start': '1995-01-04', 'end': '2027-01-03'},\n",
       " 'Mitch McConnell': {'start': '1985-01-03', 'end': '2027-01-03'},\n",
       " 'Jeff Merkley': {'start': '2009-01-06', 'end': '2027-01-03'},\n",
       " 'Jack Reed': {'start': '1991-01-03', 'end': '2027-01-03'},\n",
       " 'James E. Risch': {'start': '2009-01-06', 'end': '2027-01-03'},\n",
       " 'Jeanne Shaheen': {'start': '2009-01-06', 'end': '2027-01-03'},\n",
       " 'Mark R. Warner': {'start': '2009-01-06', 'end': '2027-01-03'},\n",
       " 'Kirsten E. Gillibrand': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Christopher A. Coons': {'start': '2010-11-15', 'end': '2027-01-03'},\n",
       " 'Joe Manchin, III': {'start': '2010-11-15', 'end': '2025-01-03'},\n",
       " 'Robert B. Aderholt': {'start': '1997-01-07', 'end': '2025-01-03'},\n",
       " 'Tammy Baldwin': {'start': '1999-01-06', 'end': '2025-01-03'},\n",
       " 'Michael F. Bennet': {'start': '2009-01-22', 'end': '2029-01-03'},\n",
       " 'Gus M. Bilirakis': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Sanford D. Bishop, Jr.': {'start': '1993-01-05', 'end': '2025-01-03'},\n",
       " 'Marsha Blackburn': {'start': '2003-01-07', 'end': '2025-01-03'},\n",
       " 'Earl Blumenauer': {'start': '1996-05-21', 'end': '2025-01-03'},\n",
       " 'Richard Blumenthal': {'start': '2011-01-05', 'end': '2029-01-03'},\n",
       " 'John Boozman': {'start': '2001-11-29', 'end': '2029-01-03'},\n",
       " 'Vern Buchanan': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Larry Bucshon': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Michael C. Burgess': {'start': '2003-01-07', 'end': '2025-01-03'},\n",
       " 'Ken Calvert': {'start': '1993-01-05', 'end': '2025-01-03'},\n",
       " 'Shelley Moore Capito': {'start': '2001-01-03', 'end': '2027-01-03'},\n",
       " 'André Carson': {'start': '2008-03-13', 'end': '2025-01-03'},\n",
       " 'John R. Carter': {'start': '2003-01-07', 'end': '2025-01-03'},\n",
       " 'Bill Cassidy': {'start': '2009-01-06', 'end': '2027-01-03'},\n",
       " 'Kathy Castor': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Judy Chu': {'start': '2009-07-16', 'end': '2025-01-03'},\n",
       " 'David N. Cicilline': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Yvette D. Clarke': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Emanuel Cleaver': {'start': '2005-01-04', 'end': '2025-01-03'},\n",
       " 'James E. Clyburn': {'start': '1993-01-05', 'end': '2025-01-03'},\n",
       " 'Steve Cohen': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Tom Cole': {'start': '2003-01-07', 'end': '2025-01-03'},\n",
       " 'Gerald E. Connolly': {'start': '2009-01-06', 'end': '2025-01-03'},\n",
       " 'Jim Costa': {'start': '2005-01-04', 'end': '2025-01-03'},\n",
       " 'Joe Courtney': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Mike Crapo': {'start': '1993-01-05', 'end': '2029-01-03'},\n",
       " 'Eric A. \"Rick\" Crawford': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Henry Cuellar': {'start': '2005-01-04', 'end': '2025-01-03'},\n",
       " 'Danny K. Davis': {'start': '1997-01-07', 'end': '2025-01-03'},\n",
       " 'Diana DeGette': {'start': '1997-01-07', 'end': '2025-01-03'},\n",
       " 'Rosa L. DeLauro': {'start': '1991-01-03', 'end': '2025-01-03'},\n",
       " 'Scott DesJarlais': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Mario Diaz-Balart': {'start': '2003-01-07', 'end': '2025-01-03'},\n",
       " 'Lloyd Doggett': {'start': '1995-01-04', 'end': '2025-01-03'},\n",
       " 'Jeff Duncan': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Anna G. Eshoo': {'start': '1993-01-05', 'end': '2025-01-03'},\n",
       " 'Charles J. \"Chuck\" Fleischmann': {'start': '2011-01-05',\n",
       "  'end': '2025-01-03'},\n",
       " 'Virginia Foxx': {'start': '2005-01-04', 'end': '2025-01-03'},\n",
       " 'John Garamendi': {'start': '2009-11-03', 'end': '2025-01-03'},\n",
       " 'Paul A. Gosar': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Kay Granger': {'start': '1997-01-07', 'end': '2025-01-03'},\n",
       " 'Chuck Grassley': {'start': '1975-01-14', 'end': '2029-01-03'},\n",
       " 'Sam Graves': {'start': '2001-01-03', 'end': '2025-01-03'},\n",
       " 'Al Green': {'start': '2005-01-04', 'end': '2025-01-03'},\n",
       " 'H. Morgan Griffith': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Raúl M. Grijalva': {'start': '2003-01-07', 'end': '2025-01-03'},\n",
       " 'Brett Guthrie': {'start': '2009-01-06', 'end': '2025-01-03'},\n",
       " 'Andy Harris': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Martin Heinrich': {'start': '2009-01-06', 'end': '2025-01-03'},\n",
       " 'Brian Higgins': {'start': '2005-01-04', 'end': '2025-01-03'},\n",
       " 'James A. Himes': {'start': '2009-01-06', 'end': '2025-01-03'},\n",
       " 'Mazie K. Hirono': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'John Hoeven': {'start': '2011-01-05', 'end': '2029-01-03'},\n",
       " 'Steny H. Hoyer': {'start': '1981-01-05', 'end': '2025-01-03'},\n",
       " 'Bill Huizenga': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Sheila Jackson Lee': {'start': '1995-01-04', 'end': '2025-01-03'},\n",
       " 'Bill Johnson': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Henry C. \"Hank\" Johnson, Jr.': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Ron Johnson': {'start': '2011-01-05', 'end': '2029-01-03'},\n",
       " 'Jim Jordan': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Marcy Kaptur': {'start': '1983-01-03', 'end': '2025-01-03'},\n",
       " 'William R. Keating': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Mike Kelly': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Doug Lamborn': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'James Lankford': {'start': '2011-01-05', 'end': '2029-01-03'},\n",
       " 'Rick Larsen': {'start': '2001-01-03', 'end': '2025-01-03'},\n",
       " 'John B. Larson': {'start': '1999-01-06', 'end': '2025-01-03'},\n",
       " 'Robert E. Latta': {'start': '2007-12-13', 'end': '2025-01-03'},\n",
       " 'Barbara Lee': {'start': '1998-04-07', 'end': '2025-01-03'},\n",
       " 'Mike Lee': {'start': '2011-01-05', 'end': '2029-01-03'},\n",
       " 'Zoe Lofgren': {'start': '1995-01-04', 'end': '2025-01-03'},\n",
       " 'Frank D. Lucas': {'start': '1993-05-10', 'end': '2025-01-03'},\n",
       " 'Blaine Luetkemeyer': {'start': '2009-01-06', 'end': '2025-01-03'},\n",
       " 'Ben Ray Luján': {'start': '2009-01-06', 'end': '2027-01-03'},\n",
       " 'Stephen F. Lynch': {'start': '2001-10-23', 'end': '2025-01-03'},\n",
       " 'Edward J. Markey': {'start': '1975-01-14', 'end': '2027-01-03'},\n",
       " 'Doris O. Matsui': {'start': '2005-03-10', 'end': '2025-01-03'},\n",
       " 'Kevin McCarthy': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Michael T. McCaul': {'start': '2005-01-04', 'end': '2025-01-03'},\n",
       " 'Tom McClintock': {'start': '2009-01-06', 'end': '2025-01-03'},\n",
       " 'Betty McCollum': {'start': '2001-01-03', 'end': '2025-01-03'},\n",
       " 'James P. McGovern': {'start': '1997-01-07', 'end': '2025-01-03'},\n",
       " 'Patrick T. McHenry': {'start': '2005-01-04', 'end': '2025-01-03'},\n",
       " 'Cathy McMorris Rodgers': {'start': '2005-01-04', 'end': '2025-01-03'},\n",
       " 'Gregory W. Meeks': {'start': '1997-01-07', 'end': '2025-01-03'},\n",
       " 'Gwen Moore': {'start': '2005-01-04', 'end': '2025-01-03'},\n",
       " 'Jerry Moran': {'start': '1997-01-07', 'end': '2029-01-03'},\n",
       " 'Lisa Murkowski': {'start': '2003-01-07', 'end': '2029-01-03'},\n",
       " 'Christopher Murphy': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Patty Murray': {'start': '1993-01-05', 'end': '2029-01-03'},\n",
       " 'Jerrold Nadler': {'start': '1992-11-03', 'end': '2025-01-03'},\n",
       " 'Grace F. Napolitano': {'start': '1999-01-06', 'end': '2025-01-03'},\n",
       " 'Richard E. Neal': {'start': '1989-01-03', 'end': '2025-01-03'},\n",
       " 'Eleanor Holmes Norton': {'start': '1991-01-03', 'end': '2025-01-03'},\n",
       " 'Frank Pallone, Jr.': {'start': '1987-01-06', 'end': '2025-01-03'},\n",
       " 'Bill Pascrell, Jr.': {'start': '1997-01-07', 'end': '2025-01-03'},\n",
       " 'Rand Paul': {'start': '2011-01-05', 'end': '2029-01-03'},\n",
       " 'Nancy Pelosi': {'start': '1987-01-06', 'end': '2025-01-03'},\n",
       " 'Gary C. Peters': {'start': '2009-01-06', 'end': '2027-01-03'},\n",
       " 'Chellie Pingree': {'start': '2009-01-06', 'end': '2025-01-03'},\n",
       " 'Bill Posey': {'start': '2009-01-06', 'end': '2025-01-03'},\n",
       " 'Mike Quigley': {'start': '2009-04-07', 'end': '2025-01-03'},\n",
       " 'Harold Rogers': {'start': '1981-01-05', 'end': '2025-01-03'},\n",
       " 'Mike Rogers': {'start': '2003-01-07', 'end': '2025-01-03'},\n",
       " 'Marco Rubio': {'start': '2011-01-05', 'end': '2029-01-03'},\n",
       " 'C. A. Dutch Ruppersberger': {'start': '2003-01-07', 'end': '2025-01-03'},\n",
       " 'Gregorio Kilili Camacho Sablan': {'start': '2009-01-06',\n",
       "  'end': '2025-01-03'},\n",
       " 'John P. Sarbanes': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Steve Scalise': {'start': '2008-05-07', 'end': '2025-01-03'},\n",
       " 'Janice D. Schakowsky': {'start': '1999-01-06', 'end': '2025-01-03'},\n",
       " 'Adam B. Schiff': {'start': '2001-01-03', 'end': '2025-01-03'},\n",
       " 'Charles E. Schumer': {'start': '1981-01-05', 'end': '2029-01-03'},\n",
       " 'David Schweikert': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Austin Scott': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'David Scott': {'start': '2003-01-07', 'end': '2025-01-03'},\n",
       " 'Robert C. \"Bobby\" Scott': {'start': '1993-01-05', 'end': '2025-01-03'},\n",
       " 'Tim Scott': {'start': '2011-01-05', 'end': '2029-01-03'},\n",
       " 'Terri A. Sewell': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Brad Sherman': {'start': '1997-01-07', 'end': '2025-01-03'},\n",
       " 'Michael K. Simpson': {'start': '1999-01-06', 'end': '2025-01-03'},\n",
       " 'Adam Smith': {'start': '1997-01-07', 'end': '2025-01-03'},\n",
       " 'Adrian Smith': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Christopher H. Smith': {'start': '1981-01-05', 'end': '2025-01-03'},\n",
       " 'Linda T. Sánchez': {'start': '2003-01-07', 'end': '2025-01-03'},\n",
       " 'Bennie G. Thompson': {'start': '1993-04-13', 'end': '2025-01-03'},\n",
       " 'Mike Thompson': {'start': '1999-01-06', 'end': '2025-01-03'},\n",
       " 'Glenn Thompson': {'start': '2009-01-06', 'end': '2025-01-03'},\n",
       " 'John Thune': {'start': '1997-01-07', 'end': '2029-01-03'},\n",
       " 'Paul Tonko': {'start': '2009-01-06', 'end': '2025-01-03'},\n",
       " 'Michael R. Turner': {'start': '2003-01-07', 'end': '2025-01-03'},\n",
       " 'Chris Van Hollen': {'start': '2003-01-07', 'end': '2029-01-03'},\n",
       " 'Nydia M. Velázquez': {'start': '1993-01-05', 'end': '2025-01-03'},\n",
       " 'Tim Walberg': {'start': '2007-01-04', 'end': '2025-01-03'},\n",
       " 'Debbie Wasserman Schultz': {'start': '2005-01-04', 'end': '2025-01-03'},\n",
       " 'Maxine Waters': {'start': '1991-01-03', 'end': '2025-01-03'},\n",
       " 'Daniel Webster': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Peter Welch': {'start': '2007-01-04', 'end': '2029-01-03'},\n",
       " 'Joe Wilson': {'start': '2001-12-18', 'end': '2025-01-03'},\n",
       " 'Frederica S. Wilson': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Robert J. Wittman': {'start': '2007-12-13', 'end': '2025-01-03'},\n",
       " 'Steve Womack': {'start': '2011-01-05', 'end': '2025-01-03'},\n",
       " 'Ron Wyden': {'start': '1981-01-05', 'end': '2029-01-03'},\n",
       " 'Todd Young': {'start': '2011-01-05', 'end': '2029-01-03'},\n",
       " 'Mark E. Amodei': {'start': '2011-09-13', 'end': '2025-01-03'},\n",
       " 'Suzanne Bonamici': {'start': '2012-02-07', 'end': '2025-01-03'},\n",
       " 'Suzan K. DelBene': {'start': '2012-11-13', 'end': '2025-01-03'},\n",
       " 'Thomas Massie': {'start': '2012-11-13', 'end': '2025-01-03'},\n",
       " 'Donald M. Payne, Jr.': {'start': '2012-11-15', 'end': '2025-01-03'},\n",
       " 'Brian Schatz': {'start': '2012-12-27', 'end': '2029-01-03'},\n",
       " 'Bill Foster': {'start': '2008-03-08', 'end': '2025-01-03'},\n",
       " 'Dina Titus': {'start': '2009-01-06', 'end': '2025-01-03'},\n",
       " 'Tom Cotton': {'start': '2013-01-03', 'end': '2027-01-03'},\n",
       " 'Kyrsten Sinema': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Doug LaMalfa': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Jared Huffman': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Ami Bera': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Eric Swalwell': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Julia Brownley': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Tony Cárdenas': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Raul Ruiz': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Mark Takano': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Juan Vargas': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Scott H. Peters': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Lois Frankel': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Tammy Duckworth': {'start': '2013-01-03', 'end': '2029-01-03'},\n",
       " 'Andy Barr': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Elizabeth Warren': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Angus S. King, Jr.': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Daniel T. Kildee': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Ann Wagner': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Steve Daines': {'start': '2013-01-03', 'end': '2027-01-03'},\n",
       " 'Richard Hudson': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Kevin Cramer': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Deb Fischer': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Ann M. Kuster': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Grace Meng': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Hakeem S. Jeffries': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Brad R. Wenstrup': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Joyce Beatty': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'David P. Joyce': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Markwayne Mullin': {'start': '2013-01-03', 'end': '2027-01-03'},\n",
       " 'Scott Perry': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Matt Cartwright': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Ted Cruz': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Randy K. Weber, Sr.': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Joaquin Castro': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Roger Williams': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Marc A. Veasey': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Chris Stewart': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Tim Kaine': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Derek Kilmer': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Mark Pocan': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Robin L. Kelly': {'start': '2013-04-09', 'end': '2025-01-03'},\n",
       " 'Jason Smith': {'start': '2013-06-04', 'end': '2025-01-03'},\n",
       " 'Cory A. Booker': {'start': '2013-10-31', 'end': '2027-01-03'},\n",
       " 'Katherine M. Clark': {'start': '2013-12-12', 'end': '2025-01-03'},\n",
       " 'Donald Norcross': {'start': '2014-11-12', 'end': '2025-01-03'},\n",
       " 'Alma S. Adams': {'start': '2014-11-12', 'end': '2025-01-03'},\n",
       " 'Gary J. Palmer': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'J. French Hill': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Bruce Westerman': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Ruben Gallego': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Mark DeSaulnier': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Pete Aguilar': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Ted Lieu': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Norma J. Torres': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Ken Buck': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Earl L. \"Buddy\" Carter': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Barry Loudermilk': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Rick W. Allen': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Mike Bost': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Garret Graves': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Seth Moulton': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'John R. Moolenaar': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Debbie Dingell': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Tom Emmer': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'David Rouzer': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Bonnie Watson Coleman': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Elise M. Stefanik': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Brendan F. Boyle': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Brian Babin': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Donald S. Beyer, Jr.': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Stacey E. Plaskett': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Dan Newhouse': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Glenn Grothman': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Alexander X. Mooney': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Aumua Amata Coleman Radewagen': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Dan Sullivan': {'start': '2015-01-06', 'end': '2027-01-03'},\n",
       " 'Joni Ernst': {'start': '2015-01-06', 'end': '2027-01-03'},\n",
       " 'Thom Tillis': {'start': '2015-01-06', 'end': '2027-01-03'},\n",
       " 'Mike Rounds': {'start': '2015-01-06', 'end': '2027-01-03'},\n",
       " 'Trent Kelly': {'start': '2015-06-09', 'end': '2025-01-03'},\n",
       " 'Darin LaHood': {'start': '2015-09-17', 'end': '2025-01-03'},\n",
       " 'Warren Davidson': {'start': '2016-06-09', 'end': '2025-01-03'},\n",
       " 'James Comer': {'start': '2016-11-14', 'end': '2025-01-03'},\n",
       " 'Dwight Evans': {'start': '2016-11-14', 'end': '2025-01-03'},\n",
       " 'John Kennedy': {'start': '2017-01-03', 'end': '2029-01-03'},\n",
       " 'Margaret Wood Hassan': {'start': '2017-01-03', 'end': '2029-01-03'},\n",
       " 'Catherine Cortez Masto': {'start': '2017-01-03', 'end': '2029-01-03'},\n",
       " 'Bradley Scott Schneider': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Andy Biggs': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Ro Khanna': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Jimmy Panetta': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Salud O. Carbajal': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Nanette Diaz Barragán': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'J. Luis Correa': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Lisa Blunt Rochester': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Matt Gaetz': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Neal P. Dunn': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'John H. Rutherford': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Darren Soto': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Brian J. Mast': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'A. Drew Ferguson IV': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Raja Krishnamoorthi': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Jim Banks': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Roger Marshall': {'start': '2017-01-03', 'end': '2027-01-03'},\n",
       " 'Clay Higgins': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Mike Johnson': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Jamie Raskin': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Jack Bergman': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Ted Budd': {'start': '2017-01-03', 'end': '2029-01-03'},\n",
       " 'Don Bacon': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Josh Gottheimer': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Jacky Rosen': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Adriano Espaillat': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Brian K. Fitzpatrick': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Lloyd Smucker': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Jenniffer González-Colón': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'David Kustoff': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Vicente Gonzalez': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Jodey C. Arrington': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Pramila Jayapal': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Mike Gallagher': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Ron Estes': {'start': '2017-04-25', 'end': '2025-01-03'},\n",
       " 'Ralph Norman': {'start': '2017-06-26', 'end': '2025-01-03'},\n",
       " 'Jimmy Gomez': {'start': '2017-07-11', 'end': '2025-01-03'},\n",
       " 'John R. Curtis': {'start': '2017-11-13', 'end': '2025-01-03'},\n",
       " 'Tina Smith': {'start': '2018-01-03', 'end': '2027-01-03'},\n",
       " 'Cindy Hyde-Smith': {'start': '2018-04-09', 'end': '2027-01-03'},\n",
       " 'Debbie Lesko': {'start': '2018-05-07', 'end': '2025-01-03'},\n",
       " 'Michael Cloud': {'start': '2018-07-10', 'end': '2025-01-03'},\n",
       " 'Troy Balderson': {'start': '2018-09-05', 'end': '2025-01-03'},\n",
       " 'Kevin Hern': {'start': '2018-11-13', 'end': '2025-01-03'},\n",
       " 'Joseph D. Morelle': {'start': '2018-11-13', 'end': '2025-01-03'},\n",
       " 'Mary Gay Scanlon': {'start': '2018-11-13', 'end': '2025-01-03'},\n",
       " 'Susan Wild': {'start': '2018-11-27', 'end': '2025-01-03'},\n",
       " 'Ed Case': {'start': '2003-01-07', 'end': '2025-01-03'},\n",
       " 'Steven Horsford': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Greg Stanton': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Josh Harder': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Katie Porter': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Mike Levin': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Joe Neguse': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Jason Crow': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Jahana Hayes': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Michael Waltz': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'W. Gregory Steube': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Lucy McBath': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Russ Fulcher': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Jesús G. \"Chuy\" García': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Sean Casten': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Lauren Underwood': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'James R. Baird': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Greg Pence': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Sharice Davids': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Lori Trahan': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Ayanna Pressley': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'David J. Trone': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Elissa Slotkin': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Haley M. Stevens': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Rashida Tlaib': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Angie Craig': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Dean Phillips': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Ilhan Omar': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Pete Stauber': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Michael Guest': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Kelly Armstrong': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Chris Pappas': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Jefferson Van Drew': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Andy Kim': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Mikie Sherrill': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Susie Lee': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Alexandria Ocasio-Cortez': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Madeleine Dean': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Chrissy Houlahan': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Daniel Meuser': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'John Joyce': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Guy Reschenthaler': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'William R. Timmons IV': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Dusty Johnson': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Tim Burchett': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'John W. Rose': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Mark E. Green': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Dan Crenshaw': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Lance Gooden': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Lizzie Fletcher': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Veronica Escobar': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Chip Roy': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Sylvia R. Garcia': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Colin Z. Allred': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Ben Cline': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Abigail Davis Spanberger': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Jennifer Wexton': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Kim Schrier': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Bryan Steil': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Carol D. Miller': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Rick Scott': {'start': '2019-01-08', 'end': '2025-01-03'},\n",
       " 'Mike Braun': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Josh Hawley': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Mitt Romney': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Jared F. Golden': {'start': '2019-01-03', 'end': '2025-01-03'},\n",
       " 'Dan Bishop': {'start': '2019-09-17', 'end': '2025-01-03'},\n",
       " 'Gregory F. Murphy': {'start': '2019-09-17', 'end': '2025-01-03'},\n",
       " 'Kweisi Mfume': {'start': '1987-01-06', 'end': '2025-01-03'},\n",
       " 'Thomas P. Tiffany': {'start': '2020-05-19', 'end': '2025-01-03'},\n",
       " 'Mike Garcia': {'start': '2020-05-19', 'end': '2025-01-03'},\n",
       " 'Mark Kelly': {'start': '2020-12-02', 'end': '2029-01-03'},\n",
       " 'Cynthia M. Lummis': {'start': '2009-01-06', 'end': '2027-01-03'},\n",
       " 'Darrell Issa': {'start': '2001-01-03', 'end': '2025-01-03'},\n",
       " 'Pete Sessions': {'start': '1997-01-07', 'end': '2025-01-03'},\n",
       " 'David G. Valadao': {'start': '2013-01-03', 'end': '2025-01-03'},\n",
       " 'Tommy Tuberville': {'start': '2021-01-03', 'end': '2027-01-03'},\n",
       " 'John W. Hickenlooper': {'start': '2021-01-03', 'end': '2027-01-03'},\n",
       " 'Bill Hagerty': {'start': '2021-01-03', 'end': '2027-01-03'},\n",
       " 'Jerry L. Carl': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Barry Moore': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Jay Obernolte': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Young Kim': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Michelle Steel': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Sara Jacobs': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Lauren Boebert': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Kat Cammack': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'C. Scott Franklin': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Byron Donalds': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Carlos A. Gimenez': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Maria Elvira Salazar': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Nikema Williams': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Andrew S. Clyde': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Marjorie Taylor Greene': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Ashley Hinson': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Mariannette Miller-Meeks': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Randy Feenstra': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Mary E. Miller': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Frank J. Mrvan': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Victoria Spartz': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Tracey Mann': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Jake LaTurner': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Jake Auchincloss': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Lisa C. McClain': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Michelle Fischbach': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Cori Bush': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Matthew M. Rosendale, Sr.': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Deborah K. Ross': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Kathy E. Manning': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Teresa Leger Fernandez': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Andrew R. Garbarino': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Nicole Malliotakis': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Ritchie Torres': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Jamaal Bowman': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Stephanie I. Bice': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Cliff Bentz': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Nancy Mace': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Diana Harshbarger': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Pat Fallon': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'August Pfluger': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Ronny Jackson': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Troy E. Nehls': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Tony Gonzales': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Beth Van Duyne': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Blake D. Moore': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Burgess Owens': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Bob Good': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Marilyn Strickland': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Scott Fitzgerald': {'start': '2021-01-03', 'end': '2025-01-03'},\n",
       " 'Alex Padilla': {'start': '2021-01-20', 'end': '2029-01-03'},\n",
       " 'Jon Ossoff': {'start': '2021-01-20', 'end': '2027-01-03'},\n",
       " 'Raphael G. Warnock': {'start': '2021-01-20', 'end': '2029-01-03'},\n",
       " 'Claudia Tenney': {'start': '2017-01-03', 'end': '2025-01-03'},\n",
       " 'Julia Letlow': {'start': '2021-04-14', 'end': '2025-01-03'},\n",
       " 'Troy A. Carter': {'start': '2021-05-11', 'end': '2025-01-03'},\n",
       " 'Melanie A. Stansbury': {'start': '2021-06-14', 'end': '2025-01-03'},\n",
       " 'Jake Ellzey': {'start': '2021-07-30', 'end': '2025-01-03'},\n",
       " 'Shontel M. Brown': {'start': '2021-11-04', 'end': '2025-01-03'},\n",
       " 'Mike Carey': {'start': '2021-11-04', 'end': '2025-01-03'},\n",
       " 'Sheila Cherfilus-McCormick': {'start': '2022-01-18', 'end': '2025-01-03'},\n",
       " 'Mike Flood': {'start': '2022-07-12', 'end': '2025-01-03'},\n",
       " 'Brad Finstad': {'start': '2022-08-12', 'end': '2025-01-03'},\n",
       " 'Mary Sattler Peltola': {'start': '2022-09-13', 'end': '2025-01-03'},\n",
       " 'Patrick Ryan': {'start': '2022-09-13', 'end': '2025-01-03'},\n",
       " 'Rudy Yakym III': {'start': '2022-11-14', 'end': '2025-01-03'},\n",
       " 'Ryan K. Zinke': {'start': '2015-01-06', 'end': '2025-01-03'},\n",
       " 'Katie Boyd Britt': {'start': '2023-01-03', 'end': '2029-01-03'},\n",
       " 'Eric Schmitt': {'start': '2023-01-03', 'end': '2029-01-03'},\n",
       " 'J.D. Vance': {'start': '2023-01-03', 'end': '2029-01-03'},\n",
       " 'John Fetterman': {'start': '2023-01-03', 'end': '2029-01-03'},\n",
       " 'Dale W. Strong': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Elijah Crane': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Juan Ciscomani': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Kevin Kiley': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'John S. Duarte': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Kevin Mullin': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Sydney Kamlager-Dove': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Robert Garcia': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Brittany Pettersen': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Yadira Caraveo': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Aaron Bean': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Cory Mills': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Maxwell Frost': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Anna Paulina Luna': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Laurel M. Lee': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Jared Moskowitz': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Richard McCormick': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Mike Collins': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'James C. Moylan': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Jill N. Tokuda': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Zachary Nunn': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Jonathan L. Jackson': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Delia C. Ramirez': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Nikki Budzinski': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Eric Sorensen': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Erin Houchin': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Morgan McGarvey': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Glenn Ivey': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Hillary J. Scholten': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'John James': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Shri Thanedar': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Mark Alford': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Eric Burlison': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Mike Ezell': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Donald G. Davis': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Valerie P. Foushee': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Chuck Edwards': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Wiley Nickel': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Jeff Jackson': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Thomas H. Kean, Jr.': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Gabe Vasquez': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Nick LaLota': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'George Santos': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Anthony D’Esposito': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Daniel S. Goldman': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Michael Lawler': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Marcus J. Molinaro': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Brandon Williams': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Nicholas A. Langworthy': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Greg Landsman': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Max L. Miller': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Emilia Strong Sykes': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Josh Brecheen': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Val T. Hoyle': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Lori Chavez-DeRemer': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Andrea Salinas': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Summer L. Lee': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Christopher R. Deluzio': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Seth Magaziner': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Russell Fry': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Andrew Ogles': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Nathaniel Moran': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Keith Self': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Morgan Luttrell': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Monica De La Cruz': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Jasmine Crockett': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Greg Casar': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Wesley Hunt': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Jennifer Kiggans': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Becca Balint': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Marie Gluesenkamp Perez': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Derrick Van Orden': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Harriet M. Hageman': {'start': '2023-01-03', 'end': '2025-01-03'},\n",
       " 'Pete Ricketts': {'start': '2023-01-23', 'end': '2024-11-05'},\n",
       " 'Jennifer L. McClellan': {'start': '2023-03-07', 'end': '2025-01-03'}}"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "served_terms"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "dev",
   "language": "python",
   "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.7.16"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}