analysis_prep__synthesizing_comms.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "bc968d6a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import re\n",
    "from tqdm import tqdm\n",
    "\n",
    "tqdm.pandas()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "3fc4c0a5",
   "metadata": {},
   "outputs": [],
   "source": [
    "agenda_items_df = pd.read_csv(\"./agenda_items_071123b.csv\", index_col=0)\n",
    "item_speakers_df = pd.read_csv(\"./item_speakers_set_3.csv\", index_col=0)\n",
    "comms_content_df = pd.read_csv(\"./comms_content_3.csv\", index_col=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "bf1f41dd",
   "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>item_num</th>\n",
       "      <th>item_name</th>\n",
       "      <th>rec</th>\n",
       "      <th>financial_implications</th>\n",
       "      <th>contact</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>FY 2024 Tax Rate: Fund Fire Protection and Eme...</td>\n",
       "      <td>Adopt second reading of Ordinance No. 7,877-N....</td>\n",
       "      <td>See report</td>\n",
       "      <td>Henry Oyekanmi, Finance, (510) 981-7300, David...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   item_num                                          item_name  \\\n",
       "0         1  FY 2024 Tax Rate: Fund Fire Protection and Eme...   \n",
       "\n",
       "                                                 rec financial_implications  \\\n",
       "0  Adopt second reading of Ordinance No. 7,877-N....             See report   \n",
       "\n",
       "                                             contact  \n",
       "0  Henry Oyekanmi, Finance, (510) 981-7300, David...  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "agenda_items_df.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "6adcd403",
   "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>item_num</th>\n",
       "      <th>item_subject</th>\n",
       "      <th>comms_num</th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7</td>\n",
       "      <td>Contract: Insight Housing (formerly Berkeley F...</td>\n",
       "      <td>166</td>\n",
       "      <td>Steve Lipson</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   item_num                                       item_subject  comms_num  \\\n",
       "0         7  Contract: Insight Housing (formerly Berkeley F...        166   \n",
       "\n",
       "           name  \n",
       "0  Steve Lipson  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "item_speakers_df.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "31be6b15",
   "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>comms_num</th>\n",
       "      <th>comms_text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>166</td>\n",
       "      <td>. .\\nCeeen ee eee ee TT ccc ACCC CCT ata\\n\\nFr...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   comms_num                                         comms_text\n",
       "0        166  . .\\nCeeen ee eee ee TT ccc ACCC CCT ata\\n\\nFr..."
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "comms_content_df.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "7b3c2ea3",
   "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>comms_num</th>\n",
       "      <th>name</th>\n",
       "      <th>comms_text</th>\n",
       "      <th>item_num</th>\n",
       "      <th>item_subject</th>\n",
       "      <th>rec</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>166</td>\n",
       "      <td>Steve Lipson</td>\n",
       "      <td>. .\\nCeeen ee eee ee TT ccc ACCC CCT ata\\n\\nFr...</td>\n",
       "      <td>7</td>\n",
       "      <td>Contract: Insight Housing (formerly Berkeley F...</td>\n",
       "      <td>Adopt a Resolution authorizing the City Manage...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>167</td>\n",
       "      <td>Beatriz Leyva</td>\n",
       "      <td>| _ |\\nEee\\n\\nFrom: Beatriz Leyva-Cutler &lt;beat...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>168</td>\n",
       "      <td>Tsukuru Fors</td>\n",
       "      <td>| \\\\na nnn TT ee\\n\\nFrom: Tsukuru Fors &lt;forfut...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>169</td>\n",
       "      <td>Phoebe Thomas</td>\n",
       "      <td>. so\\nTTT EE\\n\\nFrom: ~ Phoebe Thomas Sorgen &lt;...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>170</td>\n",
       "      <td>David McGuire</td>\n",
       "      <td>mmm mia\\n\\nFrom: David McGuire &lt;sharkfilms@gma...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>172</td>\n",
       "      <td>Bindu Desai</td>\n",
       "      <td>From: Bindu Desai &lt;btdesai@icloud.com&gt;\\n\\nSent...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>173</td>\n",
       "      <td>Eva Frye</td>\n",
       "      <td>,\\n\\nFrom: ; Eva Frye &lt;eva@twohandsbrands.com&gt;...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>174</td>\n",
       "      <td>Yuka Saito</td>\n",
       "      <td>From: Yuka Saito &lt;sensory.awareness.japan@gmai...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>175</td>\n",
       "      <td>Laura Feldman</td>\n",
       "      <td>From: Laura Feldman &lt;feldman.le@gmail.com&gt;\\n\\n...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>176</td>\n",
       "      <td>Linda Roman</td>\n",
       "      <td>From: ~ Linda &lt;lroman@mindspring.com&gt;\\n\\nSent:...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>177</td>\n",
       "      <td>Liz Taylor</td>\n",
       "      <td>From: Liz Taylor &lt;liz@doermarine.com&gt;\\n\\n' Sen...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>178</td>\n",
       "      <td>Jacqueline Cabasso</td>\n",
       "      <td>From: Jacqueline Cabasso &lt;wslf@earthlink.net&gt;\\...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>179</td>\n",
       "      <td>Eri Tomita</td>\n",
       "      <td>|\\nen!\\n\\nFrom: Cross Pollinators &lt;cross.polli...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>180</td>\n",
       "      <td>Heiko Hasegawa</td>\n",
       "      <td>| | . |\\ni i\\n\\nFrom: | Hasegawa Reiko &lt;soundo...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>181</td>\n",
       "      <td>Desiree McGill</td>\n",
       "      <td>.\\n\\nFrom: Dezz &lt;earthtodezz@gmail.com&gt;\\n\\nSen...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>185</td>\n",
       "      <td>Derethia DuVal</td>\n",
       "      <td>From: Derethia DuVal &lt;derethia@outlook.com&gt;\\nS...</td>\n",
       "      <td>32</td>\n",
       "      <td>Referral Response: Affordable Housing Preferen...</td>\n",
       "      <td>Adopt a Resolution to create an Affordable Hou...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>186</td>\n",
       "      <td>Linda Currie</td>\n",
       "      <td>| |\\n|\\n\\nFrom: . Linda Currie &lt;info@transitio...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>187</td>\n",
       "      <td>Beth Lamont</td>\n",
       "      <td>From: Beth Lamont &lt;bethlamont1@gmail.com&gt;\\nSen...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>189</td>\n",
       "      <td>Kelly Hammargren</td>\n",
       "      <td>ee ieee\\n\\nFrom: kelly hammargren &lt;kellyhammar...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>190</td>\n",
       "      <td>Tom Kelly</td>\n",
       "      <td>. |\\nFrom: ) Tom Kelly &lt;tkelly@kyotousa.org&gt;\\n...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>191</td>\n",
       "      <td>Kathleen Giustino</td>\n",
       "      <td>.\\n\\nFrom: Kathleen Giustino &lt;kathleeng@a1suni...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>192</td>\n",
       "      <td>Erin Diehm</td>\n",
       "      <td>| |\\nSS i\\n\\nFrom: Erin Diehm &lt;erindiehm@hotma...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>193</td>\n",
       "      <td>Andra Mitchell</td>\n",
       "      <td>From: Andra Mitchell &lt;andra.mitchell.email@gma...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>194</td>\n",
       "      <td>Jack Kurzweil</td>\n",
       "      <td>eR, a a a i TTT TTT,\\n\\nFrom: Jack Kurzweil &lt;j...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>195</td>\n",
       "      <td>IsabelleGaston</td>\n",
       "      <td>From: Isabelle Gaston &lt;isabelle.gaston@gmail.c...</td>\n",
       "      <td>35</td>\n",
       "      <td>De-Prioritizing the enforcement of laws imposi...</td>\n",
       "      <td>Approve the Resolution presented and passed wi...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    comms_num                name  \\\n",
       "0         166        Steve Lipson   \n",
       "1         167       Beatriz Leyva   \n",
       "2         168        Tsukuru Fors   \n",
       "3         169       Phoebe Thomas   \n",
       "4         170       David McGuire   \n",
       "5         172         Bindu Desai   \n",
       "6         173            Eva Frye   \n",
       "7         174          Yuka Saito   \n",
       "8         175       Laura Feldman   \n",
       "9         176         Linda Roman   \n",
       "10        177          Liz Taylor   \n",
       "11        178  Jacqueline Cabasso   \n",
       "12        179          Eri Tomita   \n",
       "13        180      Heiko Hasegawa   \n",
       "14        181      Desiree McGill   \n",
       "15        185      Derethia DuVal   \n",
       "16        186        Linda Currie   \n",
       "17        187         Beth Lamont   \n",
       "18        189    Kelly Hammargren   \n",
       "19        190           Tom Kelly   \n",
       "20        191   Kathleen Giustino   \n",
       "21        192          Erin Diehm   \n",
       "22        193      Andra Mitchell   \n",
       "23        194       Jack Kurzweil   \n",
       "24        195     IsabelleGaston    \n",
       "\n",
       "                                           comms_text  item_num  \\\n",
       "0   . .\\nCeeen ee eee ee TT ccc ACCC CCT ata\\n\\nFr...         7   \n",
       "1   | _ |\\nEee\\n\\nFrom: Beatriz Leyva-Cutler <beat...        28   \n",
       "2   | \\\\na nnn TT ee\\n\\nFrom: Tsukuru Fors <forfut...        28   \n",
       "3   . so\\nTTT EE\\n\\nFrom: ~ Phoebe Thomas Sorgen <...        28   \n",
       "4   mmm mia\\n\\nFrom: David McGuire <sharkfilms@gma...        28   \n",
       "5   From: Bindu Desai <btdesai@icloud.com>\\n\\nSent...        28   \n",
       "6   ,\\n\\nFrom: ; Eva Frye <eva@twohandsbrands.com>...        28   \n",
       "7   From: Yuka Saito <sensory.awareness.japan@gmai...        28   \n",
       "8   From: Laura Feldman <feldman.le@gmail.com>\\n\\n...        28   \n",
       "9   From: ~ Linda <lroman@mindspring.com>\\n\\nSent:...        28   \n",
       "10  From: Liz Taylor <liz@doermarine.com>\\n\\n' Sen...        28   \n",
       "11  From: Jacqueline Cabasso <wslf@earthlink.net>\\...        28   \n",
       "12  |\\nen!\\n\\nFrom: Cross Pollinators <cross.polli...        28   \n",
       "13  | | . |\\ni i\\n\\nFrom: | Hasegawa Reiko <soundo...        28   \n",
       "14  .\\n\\nFrom: Dezz <earthtodezz@gmail.com>\\n\\nSen...        28   \n",
       "15  From: Derethia DuVal <derethia@outlook.com>\\nS...        32   \n",
       "16  | |\\n|\\n\\nFrom: . Linda Currie <info@transitio...        33   \n",
       "17  From: Beth Lamont <bethlamont1@gmail.com>\\nSen...        33   \n",
       "18  ee ieee\\n\\nFrom: kelly hammargren <kellyhammar...        33   \n",
       "19  . |\\nFrom: ) Tom Kelly <tkelly@kyotousa.org>\\n...        33   \n",
       "20  .\\n\\nFrom: Kathleen Giustino <kathleeng@a1suni...        33   \n",
       "21  | |\\nSS i\\n\\nFrom: Erin Diehm <erindiehm@hotma...        33   \n",
       "22  From: Andra Mitchell <andra.mitchell.email@gma...        33   \n",
       "23  eR, a a a i TTT TTT,\\n\\nFrom: Jack Kurzweil <j...        33   \n",
       "24  From: Isabelle Gaston <isabelle.gaston@gmail.c...        35   \n",
       "\n",
       "                                         item_subject  \\\n",
       "0   Contract: Insight Housing (formerly Berkeley F...   \n",
       "1   Relinquishment of Council Office Budget Funds ...   \n",
       "2   Relinquishment of Council Office Budget Funds ...   \n",
       "3   Relinquishment of Council Office Budget Funds ...   \n",
       "4   Relinquishment of Council Office Budget Funds ...   \n",
       "5   Relinquishment of Council Office Budget Funds ...   \n",
       "6   Relinquishment of Council Office Budget Funds ...   \n",
       "7   Relinquishment of Council Office Budget Funds ...   \n",
       "8   Relinquishment of Council Office Budget Funds ...   \n",
       "9   Relinquishment of Council Office Budget Funds ...   \n",
       "10  Relinquishment of Council Office Budget Funds ...   \n",
       "11  Relinquishment of Council Office Budget Funds ...   \n",
       "12  Relinquishment of Council Office Budget Funds ...   \n",
       "13  Relinquishment of Council Office Budget Funds ...   \n",
       "14  Relinquishment of Council Office Budget Funds ...   \n",
       "15  Referral Response: Affordable Housing Preferen...   \n",
       "16  Adoption — Civic Center Phase II — Design Concept   \n",
       "17  Adoption — Civic Center Phase II — Design Concept   \n",
       "18  Adoption — Civic Center Phase II — Design Concept   \n",
       "19  Adoption — Civic Center Phase II — Design Concept   \n",
       "20  Adoption — Civic Center Phase II — Design Concept   \n",
       "21  Adoption — Civic Center Phase II — Design Concept   \n",
       "22  Adoption — Civic Center Phase II — Design Concept   \n",
       "23  Adoption — Civic Center Phase II — Design Concept   \n",
       "24  De-Prioritizing the enforcement of laws imposi...   \n",
       "\n",
       "                                                  rec  \n",
       "0   Adopt a Resolution authorizing the City Manage...  \n",
       "1   Adopt a resolution approving an expenditure of...  \n",
       "2   Adopt a resolution approving an expenditure of...  \n",
       "3   Adopt a resolution approving an expenditure of...  \n",
       "4   Adopt a resolution approving an expenditure of...  \n",
       "5   Adopt a resolution approving an expenditure of...  \n",
       "6   Adopt a resolution approving an expenditure of...  \n",
       "7   Adopt a resolution approving an expenditure of...  \n",
       "8   Adopt a resolution approving an expenditure of...  \n",
       "9   Adopt a resolution approving an expenditure of...  \n",
       "10  Adopt a resolution approving an expenditure of...  \n",
       "11  Adopt a resolution approving an expenditure of...  \n",
       "12  Adopt a resolution approving an expenditure of...  \n",
       "13  Adopt a resolution approving an expenditure of...  \n",
       "14  Adopt a resolution approving an expenditure of...  \n",
       "15  Adopt a Resolution to create an Affordable Hou...  \n",
       "16  Adopt a Resolution approving Berkeley’s Civic ...  \n",
       "17  Adopt a Resolution approving Berkeley’s Civic ...  \n",
       "18  Adopt a Resolution approving Berkeley’s Civic ...  \n",
       "19  Adopt a Resolution approving Berkeley’s Civic ...  \n",
       "20  Adopt a Resolution approving Berkeley’s Civic ...  \n",
       "21  Adopt a Resolution approving Berkeley’s Civic ...  \n",
       "22  Adopt a Resolution approving Berkeley’s Civic ...  \n",
       "23  Adopt a Resolution approving Berkeley’s Civic ...  \n",
       "24  Approve the Resolution presented and passed wi...  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "item_comms_df = pd.merge(\n",
    "    left=item_speakers_df, right=agenda_items_df[[\"rec\", \"item_num\"]], on=\"item_num\", \n",
    "    left_index=False, right_index=False)\n",
    "item_comms_speaker_df = pd.merge(\n",
    "    left=item_comms_df, right=comms_content_df, on=\"comms_num\", left_index=False, right_index=False\n",
    ")[[\"comms_num\", \"name\", \"comms_text\", \"item_num\", \"item_subject\", \"rec\"]]\n",
    "item_comms_speaker_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "db3d283d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ 7, 28, 32, 33, 35])"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "item_comms_speaker_df[\"item_num\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "f18779c0",
   "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>comms_num</th>\n",
       "      <th>name</th>\n",
       "      <th>comms_text</th>\n",
       "      <th>item_num</th>\n",
       "      <th>item_subject</th>\n",
       "      <th>rec</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>166</td>\n",
       "      <td>Steve Lipson</td>\n",
       "      <td>. .\\nCeeen ee eee ee TT ccc ACCC CCT ata\\n\\nFr...</td>\n",
       "      <td>7</td>\n",
       "      <td>Contract: Insight Housing (formerly Berkeley F...</td>\n",
       "      <td>Adopt a Resolution authorizing the City Manage...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   comms_num          name                                         comms_text  \\\n",
       "0        166  Steve Lipson  . .\\nCeeen ee eee ee TT ccc ACCC CCT ata\\n\\nFr...   \n",
       "\n",
       "   item_num                                       item_subject  \\\n",
       "0         7  Contract: Insight Housing (formerly Berkeley F...   \n",
       "\n",
       "                                                 rec  \n",
       "0  Adopt a Resolution authorizing the City Manage...  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "item_comms_speaker_df[item_comms_speaker_df[\"item_num\"] == 7]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "c0564c3f",
   "metadata": {},
   "outputs": [],
   "source": [
    "#### TRYING TO BATCH\n",
    "#### THIS DID NOT YIELD GREAT RESULTS\n",
    "def batch_export_comms_text(item_comms_speaker_df):\n",
    "    for item_num in item_comms_speaker_df[\"item_num\"].unique():\n",
    "        with open(f\"./comms_texts/comms_item_{item_num}.txt\", \"w\") as f:\n",
    "            this_items_comms = item_comms_speaker_df[item_comms_speaker_df[\"item_num\"] == item_num]\n",
    "            for index, row in this_items_comms.iterrows():\n",
    "                f.write(f\"Comms #: {row['comms_num']}\\n\")\n",
    "                f.write(f\"Name: {row['name']}\\n\")\n",
    "                f.write(f\"Text:\")\n",
    "                f.write(re.sub(r'[^\\d\\s\\w]+', ' ', row['comms_text']))\n",
    "                f.write(\"\\n\")\n",
    "                f.write(f\"Recommendation: {row['rec']}\\n\")\n",
    "                f.write(\"--------*--------\\n\\n\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "4ca61962",
   "metadata": {},
   "outputs": [],
   "source": [
    "def write_prepped_comms_to_file(row, dest_fpath):\n",
    "    with open(dest_fpath, \"w\") as f:\n",
    "        f.write(f\"Comms #: {row['comms_num']}\\n\")\n",
    "        f.write(f\"Name: {row['name']}\\n\")\n",
    "        f.write(f\"Text:\")\n",
    "        f.write(re.sub(r'[^\\d\\s\\w]+', ' ', row['comms_text']))\n",
    "        f.write(\"\\n\")\n",
    "        f.write(f\"Recommendation: {row['rec']}\\n\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "ae443574",
   "metadata": {},
   "outputs": [],
   "source": [
    "from langchain.chat_models import ChatOpenAI\n",
    "from langchain.chains.summarize import load_summarize_chain\n",
    "from langchain import PromptTemplate\n",
    "from langchain.text_splitter import RecursiveCharacterTextSplitter\n",
    "from langchain.document_loaders import TextLoader\n",
    "\n",
    "comms_output_dirpath = \"./comms_texts\"\n",
    "\n",
    "llm = ChatOpenAI(openai_api_key=API_KEY,\n",
    "                 model_name=\"gpt-3.5-turbo\",\n",
    "                 temperature=0)\n",
    "\n",
    "# use this for testing, before moving to df\n",
    "# for idx, row in item_comms_speaker_df.iterrows():\n",
    "#     process_comms_email_from_row(row)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "f6fdd87b",
   "metadata": {},
   "outputs": [],
   "source": [
    "def summarize_comms_email(llm, fpath):\n",
    "    loader = TextLoader(fpath, encoding='utf-8')\n",
    "    documents = loader.load()\n",
    "\n",
    "    text_splitter = RecursiveCharacterTextSplitter(chunk_size=2500)\n",
    "    docs = text_splitter.split_documents(documents)\n",
    "    \n",
    "    prompt_template = \"\"\"\n",
    "    For this single email, provide a one-sentence summary and categorize their position (support, oppose, other) of the provided recommendations.\n",
    "    EMAIL INPUT =>\n",
    "    {text}\n",
    "    \n",
    "    OUTPUT FORMAT =>\n",
    "    Comms #:\n",
    "    Name:\n",
    "    Summary:\n",
    "    Position:\n",
    "    \"\"\"\n",
    "\n",
    "    PROMPT = PromptTemplate(template=prompt_template, input_variables=[\"text\"])\n",
    "    chain = load_summarize_chain(llm,\n",
    "                                 chain_type=\"map_reduce\",\n",
    "                                 return_intermediate_steps=True,\n",
    "                                 map_prompt=PROMPT,\n",
    "                                 combine_prompt=PROMPT)\n",
    "\n",
    "    result = chain({\"input_documents\": docs}, return_only_outputs=True)\n",
    "\n",
    "    return result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "acf654d3",
   "metadata": {},
   "outputs": [],
   "source": [
    "def process_comms_email_from_row(row):\n",
    "    dest_fpath = f\"{comms_output_dirpath}/comms_{row['comms_num']}.txt\"\n",
    "    write_prepped_comms_to_file(row, dest_fpath)\n",
    "    raw_result = summarize_comms_email(llm, dest_fpath)\n",
    "    return raw_result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 204,
   "id": "863f33b0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Comms #: 137\n",
      "Name: Michael Weber\n",
      "Summary: Michael Weber is requesting the City Council's support for the full flow restoration of Strawberry Creek in Civic Center Park as part of the Civic Center Plan.\n",
      "Position: Support\n"
     ]
    }
   ],
   "source": [
    "result = parse_text_from_file(llm=llm, fpath=\"./comms_texts/comms_137.txt\")\n",
    "\n",
    "# print(result[\"intermediate_steps\"])\n",
    "print(result[\"output_text\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "d48d90da",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|██████████████████| 25/25 [04:02<00:00,  9.70s/it]\n"
     ]
    }
   ],
   "source": [
    "item_comms_speaker_df[\"raw_summ\"] = item_comms_speaker_df.progress_apply(\n",
    "    lambda row: process_comms_email_from_row(row), axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "66d41993",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"Comms #: 181\\nName: Desiree McGill\\nSummary: Desiree expresses enthusiastic support for Councilmember Kate Harrison's resolution opposing the discharge of wastewater from the Fukushima Daiichi Nuclear Power Plant into the Pacific Ocean.\\nPosition: Support\\n\\nComms #: 1\\nName: N/A\\nSummary: The email recommends that the California Berkeley City Council opposes the proposed release of wastewater from the Fukushima Daiichi Nuclear Power Plant into the Pacific Ocean and suggests sending copies of the resolution to raise awareness and support at the federal level.\\nPosition: Support\\n\\nComms #: 123456\\nName: Desiree McGill\\nSummary: The email urges the California Berkeley City Council to adopt a resolution opposing the planned discharge of wastewater from the Fukushima Daiichi Nuclear Power Plant into the Pacific Ocean.\\nPosition: Support\""
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# looking at the output text!\n",
    "item_comms_speaker_df[\"raw_summ\"].iloc[14][\"output_text\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "325f9610",
   "metadata": {},
   "outputs": [],
   "source": [
    "item_comms_speaker_df[\"short_summ\"] = item_comms_speaker_df[\"raw_summ\"].apply(\n",
    "    lambda x: re.search(r\"\\nSummary:\\s*(.*)\\n\", x[\"output_text\"]).group(1)\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "9e0e9def",
   "metadata": {},
   "outputs": [],
   "source": [
    "item_comms_speaker_df[\"position\"] = item_comms_speaker_df[\"raw_summ\"].apply(\n",
    "    lambda x: re.search(r\"Position:\\s*(.*)\", x[\"output_text\"]).group(1)\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "4b31060d",
   "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>comms_num</th>\n",
       "      <th>name</th>\n",
       "      <th>comms_text</th>\n",
       "      <th>item_num</th>\n",
       "      <th>item_subject</th>\n",
       "      <th>rec</th>\n",
       "      <th>raw_summ</th>\n",
       "      <th>short_summ</th>\n",
       "      <th>position</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>166</td>\n",
       "      <td>Steve Lipson</td>\n",
       "      <td>. .\\nCeeen ee eee ee TT ccc ACCC CCT ata\\n\\nFr...</td>\n",
       "      <td>7</td>\n",
       "      <td>Contract: Insight Housing (formerly Berkeley F...</td>\n",
       "      <td>Adopt a Resolution authorizing the City Manage...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 166\n",
       "Name: St...</td>\n",
       "      <td>Steve Lipson questions the budget and efficien...</td>\n",
       "      <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>167</td>\n",
       "      <td>Beatriz Leyva</td>\n",
       "      <td>| _ |\\nEee\\n\\nFrom: Beatriz Leyva-Cutler &lt;beat...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 167\n",
       "Name: Be...</td>\n",
       "      <td>Beatriz Leyva and Santiago Casal are thanking ...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>168</td>\n",
       "      <td>Tsukuru Fors</td>\n",
       "      <td>| \\\\na nnn TT ee\\n\\nFrom: Tsukuru Fors &lt;forfut...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 168\n",
       "Name: Ts...</td>\n",
       "      <td>Tsukuru Fors supports the resolution opposing ...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>169</td>\n",
       "      <td>Phoebe Thomas</td>\n",
       "      <td>. so\\nTTT EE\\n\\nFrom: ~ Phoebe Thomas Sorgen &lt;...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 169\n",
       "Name: Ph...</td>\n",
       "      <td>Phoebe Thomas urges the Berkeley City Council ...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>170</td>\n",
       "      <td>David McGuire</td>\n",
       "      <td>mmm mia\\n\\nFrom: David McGuire &lt;sharkfilms@gma...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 170\n",
       "Name: Da...</td>\n",
       "      <td>David McGuire supports the resolution opposing...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>172</td>\n",
       "      <td>Bindu Desai</td>\n",
       "      <td>From: Bindu Desai &lt;btdesai@icloud.com&gt;\\n\\nSent...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 172\n",
       "Name: Bi...</td>\n",
       "      <td>Bindu Desai recommends adopting a resolution o...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>173</td>\n",
       "      <td>Eva Frye</td>\n",
       "      <td>,\\n\\nFrom: ; Eva Frye &lt;eva@twohandsbrands.com&gt;...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 173\n",
       "Name: Ev...</td>\n",
       "      <td>Eva Frye expresses strong support for councilm...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>174</td>\n",
       "      <td>Yuka Saito</td>\n",
       "      <td>From: Yuka Saito &lt;sensory.awareness.japan@gmai...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 174\n",
       "Name: Yu...</td>\n",
       "      <td>Yuka Saito opposes the release of contaminated...</td>\n",
       "      <td>Oppose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>175</td>\n",
       "      <td>Laura Feldman</td>\n",
       "      <td>From: Laura Feldman &lt;feldman.le@gmail.com&gt;\\n\\n...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 175\n",
       "Name: La...</td>\n",
       "      <td>Laura Feldman opposes TEPCO's plan to dump rad...</td>\n",
       "      <td>Oppose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>176</td>\n",
       "      <td>Linda Roman</td>\n",
       "      <td>From: ~ Linda &lt;lroman@mindspring.com&gt;\\n\\nSent:...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 176\n",
       "Name: Li...</td>\n",
       "      <td>Linda Roman urges the council to oppose Japan'...</td>\n",
       "      <td>Oppose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>177</td>\n",
       "      <td>Liz Taylor</td>\n",
       "      <td>From: Liz Taylor &lt;liz@doermarine.com&gt;\\n\\n' Sen...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 177\n",
       "Name: Li...</td>\n",
       "      <td>Liz Taylor supports the Resolution Opposing To...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>178</td>\n",
       "      <td>Jacqueline Cabasso</td>\n",
       "      <td>From: Jacqueline Cabasso &lt;wslf@earthlink.net&gt;\\...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 178\n",
       "Name: Ja...</td>\n",
       "      <td>Jacqueline Cabasso supports the Resolution Opp...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>179</td>\n",
       "      <td>Eri Tomita</td>\n",
       "      <td>|\\nen!\\n\\nFrom: Cross Pollinators &lt;cross.polli...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 179\n",
       "Name: Er...</td>\n",
       "      <td>Eri Tomita expresses opposition to the propose...</td>\n",
       "      <td>Oppose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>180</td>\n",
       "      <td>Heiko Hasegawa</td>\n",
       "      <td>| | . |\\ni i\\n\\nFrom: | Hasegawa Reiko &lt;soundo...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 180\n",
       "Name: He...</td>\n",
       "      <td>Heiko Hasegawa opposes the release of contamin...</td>\n",
       "      <td>Oppose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>181</td>\n",
       "      <td>Desiree McGill</td>\n",
       "      <td>.\\n\\nFrom: Dezz &lt;earthtodezz@gmail.com&gt;\\n\\nSen...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 181\n",
       "Name: De...</td>\n",
       "      <td>Desiree expresses enthusiastic support for Cou...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>185</td>\n",
       "      <td>Derethia DuVal</td>\n",
       "      <td>From: Derethia DuVal &lt;derethia@outlook.com&gt;\\nS...</td>\n",
       "      <td>32</td>\n",
       "      <td>Referral Response: Affordable Housing Preferen...</td>\n",
       "      <td>Adopt a Resolution to create an Affordable Hou...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 185\n",
       "Name: De...</td>\n",
       "      <td>Derethia DuVal supports the adoption of an Aff...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>186</td>\n",
       "      <td>Linda Currie</td>\n",
       "      <td>| |\\n|\\n\\nFrom: . Linda Currie &lt;info@transitio...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 186\n",
       "Name: Li...</td>\n",
       "      <td>Linda Currie is requesting support for the app...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>187</td>\n",
       "      <td>Beth Lamont</td>\n",
       "      <td>From: Beth Lamont &lt;bethlamont1@gmail.com&gt;\\nSen...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 187\n",
       "Name: Be...</td>\n",
       "      <td>Beth Lamont supports a full flow restoration o...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>189</td>\n",
       "      <td>Kelly Hammargren</td>\n",
       "      <td>ee ieee\\n\\nFrom: kelly hammargren &lt;kellyhammar...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 189\n",
       "Name: Ke...</td>\n",
       "      <td>Kelly Hammargren supports the alternative desi...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>190</td>\n",
       "      <td>Tom Kelly</td>\n",
       "      <td>. |\\nFrom: ) Tom Kelly &lt;tkelly@kyotousa.org&gt;\\n...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 190\n",
       "Name: To...</td>\n",
       "      <td>Tom Kelly supports the daylighting of Strawber...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>191</td>\n",
       "      <td>Kathleen Giustino</td>\n",
       "      <td>.\\n\\nFrom: Kathleen Giustino &lt;kathleeng@a1suni...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 191\n",
       "Name: Ka...</td>\n",
       "      <td>Kathleen Giustino supports the full flow resto...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>192</td>\n",
       "      <td>Erin Diehm</td>\n",
       "      <td>| |\\nSS i\\n\\nFrom: Erin Diehm &lt;erindiehm@hotma...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 192\n",
       "Name: Er...</td>\n",
       "      <td>Erin Diehm is providing 247 petition signature...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>193</td>\n",
       "      <td>Andra Mitchell</td>\n",
       "      <td>From: Andra Mitchell &lt;andra.mitchell.email@gma...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 193\n",
       "Name: An...</td>\n",
       "      <td>Andra Mitchell is requesting support for a ful...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>194</td>\n",
       "      <td>Jack Kurzweil</td>\n",
       "      <td>eR, a a a i TTT TTT,\\n\\nFrom: Jack Kurzweil &lt;j...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 194\n",
       "Name: Ja...</td>\n",
       "      <td>Jack Kurzweil expresses disappointment and dis...</td>\n",
       "      <td>Oppose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>195</td>\n",
       "      <td>IsabelleGaston</td>\n",
       "      <td>From: Isabelle Gaston &lt;isabelle.gaston@gmail.c...</td>\n",
       "      <td>35</td>\n",
       "      <td>De-Prioritizing the enforcement of laws imposi...</td>\n",
       "      <td>Approve the Resolution presented and passed wi...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 195\n",
       "Name: Is...</td>\n",
       "      <td>Isabelle Gaston opposes the recommendations re...</td>\n",
       "      <td>Oppose</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    comms_num                name  \\\n",
       "0         166        Steve Lipson   \n",
       "1         167       Beatriz Leyva   \n",
       "2         168        Tsukuru Fors   \n",
       "3         169       Phoebe Thomas   \n",
       "4         170       David McGuire   \n",
       "5         172         Bindu Desai   \n",
       "6         173            Eva Frye   \n",
       "7         174          Yuka Saito   \n",
       "8         175       Laura Feldman   \n",
       "9         176         Linda Roman   \n",
       "10        177          Liz Taylor   \n",
       "11        178  Jacqueline Cabasso   \n",
       "12        179          Eri Tomita   \n",
       "13        180      Heiko Hasegawa   \n",
       "14        181      Desiree McGill   \n",
       "15        185      Derethia DuVal   \n",
       "16        186        Linda Currie   \n",
       "17        187         Beth Lamont   \n",
       "18        189    Kelly Hammargren   \n",
       "19        190           Tom Kelly   \n",
       "20        191   Kathleen Giustino   \n",
       "21        192          Erin Diehm   \n",
       "22        193      Andra Mitchell   \n",
       "23        194       Jack Kurzweil   \n",
       "24        195     IsabelleGaston    \n",
       "\n",
       "                                           comms_text  item_num  \\\n",
       "0   . .\\nCeeen ee eee ee TT ccc ACCC CCT ata\\n\\nFr...         7   \n",
       "1   | _ |\\nEee\\n\\nFrom: Beatriz Leyva-Cutler <beat...        28   \n",
       "2   | \\\\na nnn TT ee\\n\\nFrom: Tsukuru Fors <forfut...        28   \n",
       "3   . so\\nTTT EE\\n\\nFrom: ~ Phoebe Thomas Sorgen <...        28   \n",
       "4   mmm mia\\n\\nFrom: David McGuire <sharkfilms@gma...        28   \n",
       "5   From: Bindu Desai <btdesai@icloud.com>\\n\\nSent...        28   \n",
       "6   ,\\n\\nFrom: ; Eva Frye <eva@twohandsbrands.com>...        28   \n",
       "7   From: Yuka Saito <sensory.awareness.japan@gmai...        28   \n",
       "8   From: Laura Feldman <feldman.le@gmail.com>\\n\\n...        28   \n",
       "9   From: ~ Linda <lroman@mindspring.com>\\n\\nSent:...        28   \n",
       "10  From: Liz Taylor <liz@doermarine.com>\\n\\n' Sen...        28   \n",
       "11  From: Jacqueline Cabasso <wslf@earthlink.net>\\...        28   \n",
       "12  |\\nen!\\n\\nFrom: Cross Pollinators <cross.polli...        28   \n",
       "13  | | . |\\ni i\\n\\nFrom: | Hasegawa Reiko <soundo...        28   \n",
       "14  .\\n\\nFrom: Dezz <earthtodezz@gmail.com>\\n\\nSen...        28   \n",
       "15  From: Derethia DuVal <derethia@outlook.com>\\nS...        32   \n",
       "16  | |\\n|\\n\\nFrom: . Linda Currie <info@transitio...        33   \n",
       "17  From: Beth Lamont <bethlamont1@gmail.com>\\nSen...        33   \n",
       "18  ee ieee\\n\\nFrom: kelly hammargren <kellyhammar...        33   \n",
       "19  . |\\nFrom: ) Tom Kelly <tkelly@kyotousa.org>\\n...        33   \n",
       "20  .\\n\\nFrom: Kathleen Giustino <kathleeng@a1suni...        33   \n",
       "21  | |\\nSS i\\n\\nFrom: Erin Diehm <erindiehm@hotma...        33   \n",
       "22  From: Andra Mitchell <andra.mitchell.email@gma...        33   \n",
       "23  eR, a a a i TTT TTT,\\n\\nFrom: Jack Kurzweil <j...        33   \n",
       "24  From: Isabelle Gaston <isabelle.gaston@gmail.c...        35   \n",
       "\n",
       "                                         item_subject  \\\n",
       "0   Contract: Insight Housing (formerly Berkeley F...   \n",
       "1   Relinquishment of Council Office Budget Funds ...   \n",
       "2   Relinquishment of Council Office Budget Funds ...   \n",
       "3   Relinquishment of Council Office Budget Funds ...   \n",
       "4   Relinquishment of Council Office Budget Funds ...   \n",
       "5   Relinquishment of Council Office Budget Funds ...   \n",
       "6   Relinquishment of Council Office Budget Funds ...   \n",
       "7   Relinquishment of Council Office Budget Funds ...   \n",
       "8   Relinquishment of Council Office Budget Funds ...   \n",
       "9   Relinquishment of Council Office Budget Funds ...   \n",
       "10  Relinquishment of Council Office Budget Funds ...   \n",
       "11  Relinquishment of Council Office Budget Funds ...   \n",
       "12  Relinquishment of Council Office Budget Funds ...   \n",
       "13  Relinquishment of Council Office Budget Funds ...   \n",
       "14  Relinquishment of Council Office Budget Funds ...   \n",
       "15  Referral Response: Affordable Housing Preferen...   \n",
       "16  Adoption — Civic Center Phase II — Design Concept   \n",
       "17  Adoption — Civic Center Phase II — Design Concept   \n",
       "18  Adoption — Civic Center Phase II — Design Concept   \n",
       "19  Adoption — Civic Center Phase II — Design Concept   \n",
       "20  Adoption — Civic Center Phase II — Design Concept   \n",
       "21  Adoption — Civic Center Phase II — Design Concept   \n",
       "22  Adoption — Civic Center Phase II — Design Concept   \n",
       "23  Adoption — Civic Center Phase II — Design Concept   \n",
       "24  De-Prioritizing the enforcement of laws imposi...   \n",
       "\n",
       "                                                  rec  \\\n",
       "0   Adopt a Resolution authorizing the City Manage...   \n",
       "1   Adopt a resolution approving an expenditure of...   \n",
       "2   Adopt a resolution approving an expenditure of...   \n",
       "3   Adopt a resolution approving an expenditure of...   \n",
       "4   Adopt a resolution approving an expenditure of...   \n",
       "5   Adopt a resolution approving an expenditure of...   \n",
       "6   Adopt a resolution approving an expenditure of...   \n",
       "7   Adopt a resolution approving an expenditure of...   \n",
       "8   Adopt a resolution approving an expenditure of...   \n",
       "9   Adopt a resolution approving an expenditure of...   \n",
       "10  Adopt a resolution approving an expenditure of...   \n",
       "11  Adopt a resolution approving an expenditure of...   \n",
       "12  Adopt a resolution approving an expenditure of...   \n",
       "13  Adopt a resolution approving an expenditure of...   \n",
       "14  Adopt a resolution approving an expenditure of...   \n",
       "15  Adopt a Resolution to create an Affordable Hou...   \n",
       "16  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "17  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "18  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "19  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "20  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "21  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "22  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "23  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "24  Approve the Resolution presented and passed wi...   \n",
       "\n",
       "                                             raw_summ  \\\n",
       "0   {'intermediate_steps': ['Comms #: 166\n",
       "Name: St...   \n",
       "1   {'intermediate_steps': ['Comms #: 167\n",
       "Name: Be...   \n",
       "2   {'intermediate_steps': ['Comms #: 168\n",
       "Name: Ts...   \n",
       "3   {'intermediate_steps': ['Comms #: 169\n",
       "Name: Ph...   \n",
       "4   {'intermediate_steps': ['Comms #: 170\n",
       "Name: Da...   \n",
       "5   {'intermediate_steps': ['Comms #: 172\n",
       "Name: Bi...   \n",
       "6   {'intermediate_steps': ['Comms #: 173\n",
       "Name: Ev...   \n",
       "7   {'intermediate_steps': ['Comms #: 174\n",
       "Name: Yu...   \n",
       "8   {'intermediate_steps': ['Comms #: 175\n",
       "Name: La...   \n",
       "9   {'intermediate_steps': ['Comms #: 176\n",
       "Name: Li...   \n",
       "10  {'intermediate_steps': ['Comms #: 177\n",
       "Name: Li...   \n",
       "11  {'intermediate_steps': ['Comms #: 178\n",
       "Name: Ja...   \n",
       "12  {'intermediate_steps': ['Comms #: 179\n",
       "Name: Er...   \n",
       "13  {'intermediate_steps': ['Comms #: 180\n",
       "Name: He...   \n",
       "14  {'intermediate_steps': ['Comms #: 181\n",
       "Name: De...   \n",
       "15  {'intermediate_steps': ['Comms #: 185\n",
       "Name: De...   \n",
       "16  {'intermediate_steps': ['Comms #: 186\n",
       "Name: Li...   \n",
       "17  {'intermediate_steps': ['Comms #: 187\n",
       "Name: Be...   \n",
       "18  {'intermediate_steps': ['Comms #: 189\n",
       "Name: Ke...   \n",
       "19  {'intermediate_steps': ['Comms #: 190\n",
       "Name: To...   \n",
       "20  {'intermediate_steps': ['Comms #: 191\n",
       "Name: Ka...   \n",
       "21  {'intermediate_steps': ['Comms #: 192\n",
       "Name: Er...   \n",
       "22  {'intermediate_steps': ['Comms #: 193\n",
       "Name: An...   \n",
       "23  {'intermediate_steps': ['Comms #: 194\n",
       "Name: Ja...   \n",
       "24  {'intermediate_steps': ['Comms #: 195\n",
       "Name: Is...   \n",
       "\n",
       "                                           short_summ position  \n",
       "0   Steve Lipson questions the budget and efficien...    Other  \n",
       "1   Beatriz Leyva and Santiago Casal are thanking ...  Support  \n",
       "2   Tsukuru Fors supports the resolution opposing ...  Support  \n",
       "3   Phoebe Thomas urges the Berkeley City Council ...  Support  \n",
       "4   David McGuire supports the resolution opposing...  Support  \n",
       "5   Bindu Desai recommends adopting a resolution o...  Support  \n",
       "6   Eva Frye expresses strong support for councilm...  Support  \n",
       "7   Yuka Saito opposes the release of contaminated...   Oppose  \n",
       "8   Laura Feldman opposes TEPCO's plan to dump rad...   Oppose  \n",
       "9   Linda Roman urges the council to oppose Japan'...   Oppose  \n",
       "10  Liz Taylor supports the Resolution Opposing To...  Support  \n",
       "11  Jacqueline Cabasso supports the Resolution Opp...  Support  \n",
       "12  Eri Tomita expresses opposition to the propose...   Oppose  \n",
       "13  Heiko Hasegawa opposes the release of contamin...   Oppose  \n",
       "14  Desiree expresses enthusiastic support for Cou...  Support  \n",
       "15  Derethia DuVal supports the adoption of an Aff...  Support  \n",
       "16  Linda Currie is requesting support for the app...  Support  \n",
       "17  Beth Lamont supports a full flow restoration o...  Support  \n",
       "18  Kelly Hammargren supports the alternative desi...  Support  \n",
       "19  Tom Kelly supports the daylighting of Strawber...  Support  \n",
       "20  Kathleen Giustino supports the full flow resto...  Support  \n",
       "21  Erin Diehm is providing 247 petition signature...  Support  \n",
       "22  Andra Mitchell is requesting support for a ful...  Support  \n",
       "23  Jack Kurzweil expresses disappointment and dis...   Oppose  \n",
       "24  Isabelle Gaston opposes the recommendations re...   Oppose  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "item_comms_speaker_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "3257d88a",
   "metadata": {},
   "outputs": [],
   "source": [
    "item_comms_speaker_df.to_csv(\"./synthed_comms_set_3.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "bf541ba9",
   "metadata": {},
   "outputs": [],
   "source": [
    "item_comms_speaker_df_3 = pd.read_csv(\"./synthed_comms_set_3.csv\", index_col=0)\n",
    "item_comms_speaker_df_2 = pd.read_csv(\"./synthed_comms_set_2.csv\", index_col=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "5c97c399",
   "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>comms_num</th>\n",
       "      <th>name</th>\n",
       "      <th>comms_text</th>\n",
       "      <th>item_num</th>\n",
       "      <th>item_subject</th>\n",
       "      <th>rec</th>\n",
       "      <th>raw_summ</th>\n",
       "      <th>short_summ</th>\n",
       "      <th>position</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>131</td>\n",
       "      <td>Seaver Wang</td>\n",
       "      <td>From: Seaver Wang &lt;seaver@thebreakthrough.org&gt;...</td>\n",
       "      <td>29</td>\n",
       "      <td>Resolution Opposing Tokyo Electric Power Compa...</td>\n",
       "      <td>Adopt a Resolution opposing Tokyo Electric Pow...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 131\\nName: S...</td>\n",
       "      <td>Seaver Wang opposes the proposed resolution by...</td>\n",
       "      <td>Oppose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>132</td>\n",
       "      <td>Diane Bohn</td>\n",
       "      <td>From: Diana &lt;nicca@igc.org&gt;\\nSent: Friday, Jul...</td>\n",
       "      <td>29</td>\n",
       "      <td>Resolution Opposing Tokyo Electric Power Compa...</td>\n",
       "      <td>Adopt a Resolution opposing Tokyo Electric Pow...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 132\\nName: D...</td>\n",
       "      <td>Diane Bohn is requesting support for Council m...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>133</td>\n",
       "      <td>Miya Sommers</td>\n",
       "      <td>— . .\\neee ERR ee EN a I CAC,\\n\\nFrom: Miya So...</td>\n",
       "      <td>29</td>\n",
       "      <td>Resolution Opposing Tokyo Electric Power Compa...</td>\n",
       "      <td>Adopt a Resolution opposing Tokyo Electric Pow...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 133\\nName: M...</td>\n",
       "      <td>Miya Sommers urges the Berkeley City Council t...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>135</td>\n",
       "      <td>Carole Marasovic</td>\n",
       "      <td>From: carole marasovic &lt;daphnesflight@yahoo.co...</td>\n",
       "      <td>32</td>\n",
       "      <td>Referral Response: Affordable Housing Preferen...</td>\n",
       "      <td>Adopt a Resolution to create an Affordable Hou...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 135\\nName: C...</td>\n",
       "      <td>Carole Marasovic requests the consideration of...</td>\n",
       "      <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>136</td>\n",
       "      <td>Chase Hommeyer</td>\n",
       "      <td>—\\na\\n\\nFrom:\\nSent:\\nTo:\\n\\nSubject:\\n\\nChase...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 136\\nName: C...</td>\n",
       "      <td>Chase Hommeyer supports the full restoration o...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>137</td>\n",
       "      <td>Michael Weber</td>\n",
       "      <td>etn tl\\n\\nFrom: Michael Weber &lt;michaeljohnwebe...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 137\\nName: M...</td>\n",
       "      <td>Michael Weber is requesting the City Council's...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>138</td>\n",
       "      <td>Miranda Ewell</td>\n",
       "      <td>From: Miranda Ewell &lt;mirandaewell@gmail.com&gt;\\n...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 138\\nName: M...</td>\n",
       "      <td>Miranda Ewell supports the full flow restorati...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>139</td>\n",
       "      <td>Ruth Morgan</td>\n",
       "      <td>From: : ~ Ruth Morgan &lt;morganruth397@gmail.com...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 139\\nName: R...</td>\n",
       "      <td>Ruth Morgan is requesting the support of the C...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>140</td>\n",
       "      <td>Summer Brenner</td>\n",
       "      <td>From: Summer Brenner &lt;summerbrenner@gmail.com&gt;...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 140\\nName: S...</td>\n",
       "      <td>Summer Brenner is requesting the council's sup...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>141</td>\n",
       "      <td>Drew Goetting</td>\n",
       "      <td>From: Berkeley Mayor's Office\\n\\nSent: Sunday,...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 141\\nName: D...</td>\n",
       "      <td>Drew Goetting provides a letter with considera...</td>\n",
       "      <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>142</td>\n",
       "      <td>Ann Harlow</td>\n",
       "      <td>From: Ann Harlow &lt;annharlow77@gmail.com&gt;\\nSent...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 142\\nName: A...</td>\n",
       "      <td>Ann Harlow, representing the Berkeley Historic...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>143</td>\n",
       "      <td>Stefen</td>\n",
       "      <td>From: stefen STEFEN &lt;stefen@stefenart.com&gt;\\nSe...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 143\\nName: S...</td>\n",
       "      <td>Stefen is requesting support for a full flow r...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>144</td>\n",
       "      <td>Sylvia Soriano</td>\n",
       "      <td>;\\n|\\n\\nFrom: Sylvia Soriano &lt;sylviana286@gmai...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 144\\nName: S...</td>\n",
       "      <td>Sylvia Soriano is requesting support for a ful...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>145</td>\n",
       "      <td>Mary Price</td>\n",
       "      <td>From: MaryRPrice &lt;maryrprice@gmail.com&gt;\\n\\nSen...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 145\\nName: M...</td>\n",
       "      <td>Mary Price is requesting support for a full fl...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>146</td>\n",
       "      <td>Irene Rice</td>\n",
       "      <td>t :\\nenna ee ee reece eee ee eee SS\\n\\nFrom: |...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 146\\nName: I...</td>\n",
       "      <td>Irene Rice is requesting support for a Full Fl...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>147</td>\n",
       "      <td>Fredrica Drotos</td>\n",
       "      <td>From: FD &lt;fadrot@gmail.com&gt; -\\n\\nSent: Saturda...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 147\\nName: F...</td>\n",
       "      <td>Fredrica Drotos supports the full flow restora...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>148</td>\n",
       "      <td>Dick and</td>\n",
       "      <td>From: Dick Eastman &lt;adzuma.otoko@protonmail.co...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 148\\nName: D...</td>\n",
       "      <td>Dick and Mariko Eastman support a full flow re...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>149</td>\n",
       "      <td>Carolyn Shoulders</td>\n",
       "      <td>From: Carolyn Shoulders &lt;cashou360@gmail.com&gt;\\...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 149\\nName: C...</td>\n",
       "      <td>Carolyn Shoulders, a Berkeley resident, is req...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>150</td>\n",
       "      <td>Tom Miller</td>\n",
       "      <td>From: ‘Tom Miller &lt;milltom@gmail.com&gt;\\n\\nSent:...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 150\\nName: T...</td>\n",
       "      <td>Tom Miller urges the Council to support the da...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>151</td>\n",
       "      <td>Sheila Himmel</td>\n",
       "      <td>.\\ni ii iF TTT\\n\\nFrom: sheila himmel &lt;sheila....</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 151\\nName: S...</td>\n",
       "      <td>Sheila Himmel is requesting support for a full...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>152</td>\n",
       "      <td>Bernard Marszalek</td>\n",
       "      <td>|\\na Ee mre!\\n\\nFrom: Bernard Marszalek &lt;ztang...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 152\\nName: B...</td>\n",
       "      <td>Bernard Marszalek is requesting support for th...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>153</td>\n",
       "      <td>Sally Nelson</td>\n",
       "      <td>| |\\nre\\n\\nFrom: Sally Nelson &lt;sallynels7@gmai...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 153\\nName: S...</td>\n",
       "      <td>Sally Nelson is requesting support for a full ...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>155</td>\n",
       "      <td>Margot Cunningham</td>\n",
       "      <td>| | | .\\nRe a a a I,\\n\\nFrom: Margot Cunningha...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 155\\nName: M...</td>\n",
       "      <td>Margot Cunningham is requesting the support of...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>157</td>\n",
       "      <td>Kathleen Giustino</td>\n",
       "      <td>| | |\\na eel\\n\\nFrom: Kathleen Giustino &lt;kathl...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 157\\nName: K...</td>\n",
       "      <td>Kathleen Giustino is requesting support for a ...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>159</td>\n",
       "      <td>Nancy Schimmel</td>\n",
       "      <td>From: . Nancy Schimmel &lt;nancy@sisterschoice.co...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 159\\nName: N...</td>\n",
       "      <td>Nancy Schimmel is requesting the full support ...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>160</td>\n",
       "      <td>Charles Enchill</td>\n",
       "      <td>. .\\ni\\n\\nFrom: Charles Enchill &lt;enchill.charl...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 160\\nName: C...</td>\n",
       "      <td>The Landmarks Preservation Commission supports...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>162</td>\n",
       "      <td>Camille MacDonald</td>\n",
       "      <td>i een nl\\n\\nFrom: Camille MacDonald &lt;camillema...</td>\n",
       "      <td>35</td>\n",
       "      <td>De-Prioritizing the enforcement of laws imposi...</td>\n",
       "      <td>Approve the Resolution presented and passed wi...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 162\\nName: C...</td>\n",
       "      <td>Camille MacDonald supports the recommendation ...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>163</td>\n",
       "      <td>Fran Haselsteiner</td>\n",
       "      <td>.\\ni\\n\\nFrom: Fran Haselsteiner &lt;franhaselstei...</td>\n",
       "      <td>35</td>\n",
       "      <td>De-Prioritizing the enforcement of laws imposi...</td>\n",
       "      <td>Approve the Resolution presented and passed wi...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 163\\nName: F...</td>\n",
       "      <td>Fran Haselsteiner opposes the proposal to lega...</td>\n",
       "      <td>Oppose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>164</td>\n",
       "      <td>Clifton Ross</td>\n",
       "      <td>eee RR rr er a A A TTA,\\n\\nFrom: Clifton Ross ...</td>\n",
       "      <td>35</td>\n",
       "      <td>De-Prioritizing the enforcement of laws imposi...</td>\n",
       "      <td>Approve the Resolution presented and passed wi...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 164\\nName: C...</td>\n",
       "      <td>Clifton Ross is requesting support for the dec...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>165</td>\n",
       "      <td>Karen Armstead</td>\n",
       "      <td>| )\\nTTT\\n\\nFrom: Karen Armstead &lt;prunedoggie@...</td>\n",
       "      <td>35</td>\n",
       "      <td>De-Prioritizing the enforcement of laws imposi...</td>\n",
       "      <td>Approve the Resolution presented and passed wi...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 165\\nName: K...</td>\n",
       "      <td>Karen Armstead is urging support for Item 35 o...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>166</td>\n",
       "      <td>Steve Lipson</td>\n",
       "      <td>. .\\nCeeen ee eee ee TT ccc ACCC CCT ata\\n\\nFr...</td>\n",
       "      <td>7</td>\n",
       "      <td>Contract: Insight Housing (formerly Berkeley F...</td>\n",
       "      <td>Adopt a Resolution authorizing the City Manage...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 166\\nName: S...</td>\n",
       "      <td>Steve Lipson questions the budget and efficien...</td>\n",
       "      <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>167</td>\n",
       "      <td>Beatriz Leyva</td>\n",
       "      <td>| _ |\\nEee\\n\\nFrom: Beatriz Leyva-Cutler &lt;beat...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 167\\nName: B...</td>\n",
       "      <td>Beatriz Leyva and Santiago Casal are thanking ...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>168</td>\n",
       "      <td>Tsukuru Fors</td>\n",
       "      <td>| \\\\na nnn TT ee\\n\\nFrom: Tsukuru Fors &lt;forfut...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 168\\nName: T...</td>\n",
       "      <td>Tsukuru Fors supports the resolution opposing ...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>169</td>\n",
       "      <td>Phoebe Thomas</td>\n",
       "      <td>. so\\nTTT EE\\n\\nFrom: ~ Phoebe Thomas Sorgen &lt;...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 169\\nName: P...</td>\n",
       "      <td>Phoebe Thomas urges the Berkeley City Council ...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>170</td>\n",
       "      <td>David McGuire</td>\n",
       "      <td>mmm mia\\n\\nFrom: David McGuire &lt;sharkfilms@gma...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 170\\nName: D...</td>\n",
       "      <td>David McGuire supports the resolution opposing...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>172</td>\n",
       "      <td>Bindu Desai</td>\n",
       "      <td>From: Bindu Desai &lt;btdesai@icloud.com&gt;\\n\\nSent...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 172\\nName: B...</td>\n",
       "      <td>Bindu Desai recommends adopting a resolution o...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>173</td>\n",
       "      <td>Eva Frye</td>\n",
       "      <td>,\\n\\nFrom: ; Eva Frye &lt;eva@twohandsbrands.com&gt;...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 173\\nName: E...</td>\n",
       "      <td>Eva Frye expresses strong support for councilm...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>174</td>\n",
       "      <td>Yuka Saito</td>\n",
       "      <td>From: Yuka Saito &lt;sensory.awareness.japan@gmai...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 174\\nName: Y...</td>\n",
       "      <td>Yuka Saito opposes the release of contaminated...</td>\n",
       "      <td>Oppose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>175</td>\n",
       "      <td>Laura Feldman</td>\n",
       "      <td>From: Laura Feldman &lt;feldman.le@gmail.com&gt;\\n\\n...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 175\\nName: L...</td>\n",
       "      <td>Laura Feldman opposes TEPCO's plan to dump rad...</td>\n",
       "      <td>Oppose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>176</td>\n",
       "      <td>Linda Roman</td>\n",
       "      <td>From: ~ Linda &lt;lroman@mindspring.com&gt;\\n\\nSent:...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 176\\nName: L...</td>\n",
       "      <td>Linda Roman urges the council to oppose Japan'...</td>\n",
       "      <td>Oppose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>177</td>\n",
       "      <td>Liz Taylor</td>\n",
       "      <td>From: Liz Taylor &lt;liz@doermarine.com&gt;\\n\\n' Sen...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 177\\nName: L...</td>\n",
       "      <td>Liz Taylor supports the Resolution Opposing To...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>178</td>\n",
       "      <td>Jacqueline Cabasso</td>\n",
       "      <td>From: Jacqueline Cabasso &lt;wslf@earthlink.net&gt;\\...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 178\\nName: J...</td>\n",
       "      <td>Jacqueline Cabasso supports the Resolution Opp...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>179</td>\n",
       "      <td>Eri Tomita</td>\n",
       "      <td>|\\nen!\\n\\nFrom: Cross Pollinators &lt;cross.polli...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 179\\nName: E...</td>\n",
       "      <td>Eri Tomita expresses opposition to the propose...</td>\n",
       "      <td>Oppose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>180</td>\n",
       "      <td>Heiko Hasegawa</td>\n",
       "      <td>| | . |\\ni i\\n\\nFrom: | Hasegawa Reiko &lt;soundo...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 180\\nName: H...</td>\n",
       "      <td>Heiko Hasegawa opposes the release of contamin...</td>\n",
       "      <td>Oppose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>181</td>\n",
       "      <td>Desiree McGill</td>\n",
       "      <td>.\\n\\nFrom: Dezz &lt;earthtodezz@gmail.com&gt;\\n\\nSen...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 181\\nName: D...</td>\n",
       "      <td>Desiree expresses enthusiastic support for Cou...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>185</td>\n",
       "      <td>Derethia DuVal</td>\n",
       "      <td>From: Derethia DuVal &lt;derethia@outlook.com&gt;\\nS...</td>\n",
       "      <td>32</td>\n",
       "      <td>Referral Response: Affordable Housing Preferen...</td>\n",
       "      <td>Adopt a Resolution to create an Affordable Hou...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 185\\nName: D...</td>\n",
       "      <td>Derethia DuVal supports the adoption of an Aff...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>186</td>\n",
       "      <td>Linda Currie</td>\n",
       "      <td>| |\\n|\\n\\nFrom: . Linda Currie &lt;info@transitio...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 186\\nName: L...</td>\n",
       "      <td>Linda Currie is requesting support for the app...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>187</td>\n",
       "      <td>Beth Lamont</td>\n",
       "      <td>From: Beth Lamont &lt;bethlamont1@gmail.com&gt;\\nSen...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 187\\nName: B...</td>\n",
       "      <td>Beth Lamont supports a full flow restoration o...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>189</td>\n",
       "      <td>Kelly Hammargren</td>\n",
       "      <td>ee ieee\\n\\nFrom: kelly hammargren &lt;kellyhammar...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 189\\nName: K...</td>\n",
       "      <td>Kelly Hammargren supports the alternative desi...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>190</td>\n",
       "      <td>Tom Kelly</td>\n",
       "      <td>. |\\nFrom: ) Tom Kelly &lt;tkelly@kyotousa.org&gt;\\n...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 190\\nName: T...</td>\n",
       "      <td>Tom Kelly supports the daylighting of Strawber...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>191</td>\n",
       "      <td>Kathleen Giustino</td>\n",
       "      <td>.\\n\\nFrom: Kathleen Giustino &lt;kathleeng@a1suni...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 191\\nName: K...</td>\n",
       "      <td>Kathleen Giustino supports the full flow resto...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>192</td>\n",
       "      <td>Erin Diehm</td>\n",
       "      <td>| |\\nSS i\\n\\nFrom: Erin Diehm &lt;erindiehm@hotma...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 192\\nName: E...</td>\n",
       "      <td>Erin Diehm is providing 247 petition signature...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>193</td>\n",
       "      <td>Andra Mitchell</td>\n",
       "      <td>From: Andra Mitchell &lt;andra.mitchell.email@gma...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 193\\nName: A...</td>\n",
       "      <td>Andra Mitchell is requesting support for a ful...</td>\n",
       "      <td>Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>194</td>\n",
       "      <td>Jack Kurzweil</td>\n",
       "      <td>eR, a a a i TTT TTT,\\n\\nFrom: Jack Kurzweil &lt;j...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 194\\nName: J...</td>\n",
       "      <td>Jack Kurzweil expresses disappointment and dis...</td>\n",
       "      <td>Oppose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>195</td>\n",
       "      <td>IsabelleGaston</td>\n",
       "      <td>From: Isabelle Gaston &lt;isabelle.gaston@gmail.c...</td>\n",
       "      <td>35</td>\n",
       "      <td>De-Prioritizing the enforcement of laws imposi...</td>\n",
       "      <td>Approve the Resolution presented and passed wi...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 195\\nName: I...</td>\n",
       "      <td>Isabelle Gaston opposes the recommendations re...</td>\n",
       "      <td>Oppose</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    comms_num                name  \\\n",
       "0         131         Seaver Wang   \n",
       "1         132          Diane Bohn   \n",
       "2         133        Miya Sommers   \n",
       "3         135    Carole Marasovic   \n",
       "4         136      Chase Hommeyer   \n",
       "5         137       Michael Weber   \n",
       "6         138       Miranda Ewell   \n",
       "7         139         Ruth Morgan   \n",
       "8         140      Summer Brenner   \n",
       "9         141       Drew Goetting   \n",
       "10        142          Ann Harlow   \n",
       "11        143              Stefen   \n",
       "12        144      Sylvia Soriano   \n",
       "13        145          Mary Price   \n",
       "14        146          Irene Rice   \n",
       "15        147     Fredrica Drotos   \n",
       "16        148            Dick and   \n",
       "17        149   Carolyn Shoulders   \n",
       "18        150          Tom Miller   \n",
       "19        151       Sheila Himmel   \n",
       "20        152   Bernard Marszalek   \n",
       "21        153        Sally Nelson   \n",
       "22        155   Margot Cunningham   \n",
       "23        157   Kathleen Giustino   \n",
       "24        159      Nancy Schimmel   \n",
       "25        160     Charles Enchill   \n",
       "26        162   Camille MacDonald   \n",
       "27        163   Fran Haselsteiner   \n",
       "28        164        Clifton Ross   \n",
       "29        165      Karen Armstead   \n",
       "30        166        Steve Lipson   \n",
       "31        167       Beatriz Leyva   \n",
       "32        168        Tsukuru Fors   \n",
       "33        169       Phoebe Thomas   \n",
       "34        170       David McGuire   \n",
       "35        172         Bindu Desai   \n",
       "36        173            Eva Frye   \n",
       "37        174          Yuka Saito   \n",
       "38        175       Laura Feldman   \n",
       "39        176         Linda Roman   \n",
       "40        177          Liz Taylor   \n",
       "41        178  Jacqueline Cabasso   \n",
       "42        179          Eri Tomita   \n",
       "43        180      Heiko Hasegawa   \n",
       "44        181      Desiree McGill   \n",
       "45        185      Derethia DuVal   \n",
       "46        186        Linda Currie   \n",
       "47        187         Beth Lamont   \n",
       "48        189    Kelly Hammargren   \n",
       "49        190           Tom Kelly   \n",
       "50        191   Kathleen Giustino   \n",
       "51        192          Erin Diehm   \n",
       "52        193      Andra Mitchell   \n",
       "53        194       Jack Kurzweil   \n",
       "54        195     IsabelleGaston    \n",
       "\n",
       "                                           comms_text  item_num  \\\n",
       "0   From: Seaver Wang <seaver@thebreakthrough.org>...        29   \n",
       "1   From: Diana <nicca@igc.org>\\nSent: Friday, Jul...        29   \n",
       "2   — . .\\neee ERR ee EN a I CAC,\\n\\nFrom: Miya So...        29   \n",
       "3   From: carole marasovic <daphnesflight@yahoo.co...        32   \n",
       "4   —\\na\\n\\nFrom:\\nSent:\\nTo:\\n\\nSubject:\\n\\nChase...        33   \n",
       "5   etn tl\\n\\nFrom: Michael Weber <michaeljohnwebe...        33   \n",
       "6   From: Miranda Ewell <mirandaewell@gmail.com>\\n...        33   \n",
       "7   From: : ~ Ruth Morgan <morganruth397@gmail.com...        33   \n",
       "8   From: Summer Brenner <summerbrenner@gmail.com>...        33   \n",
       "9   From: Berkeley Mayor's Office\\n\\nSent: Sunday,...        33   \n",
       "10  From: Ann Harlow <annharlow77@gmail.com>\\nSent...        33   \n",
       "11  From: stefen STEFEN <stefen@stefenart.com>\\nSe...        33   \n",
       "12  ;\\n|\\n\\nFrom: Sylvia Soriano <sylviana286@gmai...        33   \n",
       "13  From: MaryRPrice <maryrprice@gmail.com>\\n\\nSen...        33   \n",
       "14  t :\\nenna ee ee reece eee ee eee SS\\n\\nFrom: |...        33   \n",
       "15  From: FD <fadrot@gmail.com> -\\n\\nSent: Saturda...        33   \n",
       "16  From: Dick Eastman <adzuma.otoko@protonmail.co...        33   \n",
       "17  From: Carolyn Shoulders <cashou360@gmail.com>\\...        33   \n",
       "18  From: ‘Tom Miller <milltom@gmail.com>\\n\\nSent:...        33   \n",
       "19  .\\ni ii iF TTT\\n\\nFrom: sheila himmel <sheila....        33   \n",
       "20  |\\na Ee mre!\\n\\nFrom: Bernard Marszalek <ztang...        33   \n",
       "21  | |\\nre\\n\\nFrom: Sally Nelson <sallynels7@gmai...        33   \n",
       "22  | | | .\\nRe a a a I,\\n\\nFrom: Margot Cunningha...        33   \n",
       "23  | | |\\na eel\\n\\nFrom: Kathleen Giustino <kathl...        33   \n",
       "24  From: . Nancy Schimmel <nancy@sisterschoice.co...        33   \n",
       "25  . .\\ni\\n\\nFrom: Charles Enchill <enchill.charl...        33   \n",
       "26  i een nl\\n\\nFrom: Camille MacDonald <camillema...        35   \n",
       "27  .\\ni\\n\\nFrom: Fran Haselsteiner <franhaselstei...        35   \n",
       "28  eee RR rr er a A A TTA,\\n\\nFrom: Clifton Ross ...        35   \n",
       "29  | )\\nTTT\\n\\nFrom: Karen Armstead <prunedoggie@...        35   \n",
       "30  . .\\nCeeen ee eee ee TT ccc ACCC CCT ata\\n\\nFr...         7   \n",
       "31  | _ |\\nEee\\n\\nFrom: Beatriz Leyva-Cutler <beat...        28   \n",
       "32  | \\\\na nnn TT ee\\n\\nFrom: Tsukuru Fors <forfut...        28   \n",
       "33  . so\\nTTT EE\\n\\nFrom: ~ Phoebe Thomas Sorgen <...        28   \n",
       "34  mmm mia\\n\\nFrom: David McGuire <sharkfilms@gma...        28   \n",
       "35  From: Bindu Desai <btdesai@icloud.com>\\n\\nSent...        28   \n",
       "36  ,\\n\\nFrom: ; Eva Frye <eva@twohandsbrands.com>...        28   \n",
       "37  From: Yuka Saito <sensory.awareness.japan@gmai...        28   \n",
       "38  From: Laura Feldman <feldman.le@gmail.com>\\n\\n...        28   \n",
       "39  From: ~ Linda <lroman@mindspring.com>\\n\\nSent:...        28   \n",
       "40  From: Liz Taylor <liz@doermarine.com>\\n\\n' Sen...        28   \n",
       "41  From: Jacqueline Cabasso <wslf@earthlink.net>\\...        28   \n",
       "42  |\\nen!\\n\\nFrom: Cross Pollinators <cross.polli...        28   \n",
       "43  | | . |\\ni i\\n\\nFrom: | Hasegawa Reiko <soundo...        28   \n",
       "44  .\\n\\nFrom: Dezz <earthtodezz@gmail.com>\\n\\nSen...        28   \n",
       "45  From: Derethia DuVal <derethia@outlook.com>\\nS...        32   \n",
       "46  | |\\n|\\n\\nFrom: . Linda Currie <info@transitio...        33   \n",
       "47  From: Beth Lamont <bethlamont1@gmail.com>\\nSen...        33   \n",
       "48  ee ieee\\n\\nFrom: kelly hammargren <kellyhammar...        33   \n",
       "49  . |\\nFrom: ) Tom Kelly <tkelly@kyotousa.org>\\n...        33   \n",
       "50  .\\n\\nFrom: Kathleen Giustino <kathleeng@a1suni...        33   \n",
       "51  | |\\nSS i\\n\\nFrom: Erin Diehm <erindiehm@hotma...        33   \n",
       "52  From: Andra Mitchell <andra.mitchell.email@gma...        33   \n",
       "53  eR, a a a i TTT TTT,\\n\\nFrom: Jack Kurzweil <j...        33   \n",
       "54  From: Isabelle Gaston <isabelle.gaston@gmail.c...        35   \n",
       "\n",
       "                                         item_subject  \\\n",
       "0   Resolution Opposing Tokyo Electric Power Compa...   \n",
       "1   Resolution Opposing Tokyo Electric Power Compa...   \n",
       "2   Resolution Opposing Tokyo Electric Power Compa...   \n",
       "3   Referral Response: Affordable Housing Preferen...   \n",
       "4   Adoption — Civic Center Phase II — Design Concept   \n",
       "5   Adoption — Civic Center Phase II — Design Concept   \n",
       "6   Adoption — Civic Center Phase II — Design Concept   \n",
       "7   Adoption — Civic Center Phase II — Design Concept   \n",
       "8   Adoption — Civic Center Phase II — Design Conc...   \n",
       "9   Adoption — Civic Center Phase II — Design Conc...   \n",
       "10  Adoption — Civic Center Phase II — Design Conc...   \n",
       "11  Adoption — Civic Center Phase II — Design Conc...   \n",
       "12  Adoption — Civic Center Phase II — Design Conc...   \n",
       "13  Adoption — Civic Center Phase II — Design Conc...   \n",
       "14  Adoption — Civic Center Phase II — Design Conc...   \n",
       "15  Adoption — Civic Center Phase II — Design Conc...   \n",
       "16  Adoption — Civic Center Phase II — Design Conc...   \n",
       "17  Adoption — Civic Center Phase II — Design Conc...   \n",
       "18  Adoption — Civic Center Phase II — Design Conc...   \n",
       "19  Adoption — Civic Center Phase II — Design Conc...   \n",
       "20  Adoption — Civic Center Phase II — Design Conc...   \n",
       "21  Adoption — Civic Center Phase II — Design Conc...   \n",
       "22  Adoption — Civic Center Phase II — Design Conc...   \n",
       "23  Adoption — Civic Center Phase II — Design Conc...   \n",
       "24  Adoption — Civic Center Phase II — Design Conc...   \n",
       "25  Adoption — Civic Center Phase II — Design Conc...   \n",
       "26  De-Prioritizing the enforcement of laws imposi...   \n",
       "27  De-Prioritizing the enforcement of laws imposi...   \n",
       "28  De-Prioritizing the enforcement of laws imposi...   \n",
       "29  De-Prioritizing the enforcement of laws imposi...   \n",
       "30  Contract: Insight Housing (formerly Berkeley F...   \n",
       "31  Relinquishment of Council Office Budget Funds ...   \n",
       "32  Relinquishment of Council Office Budget Funds ...   \n",
       "33  Relinquishment of Council Office Budget Funds ...   \n",
       "34  Relinquishment of Council Office Budget Funds ...   \n",
       "35  Relinquishment of Council Office Budget Funds ...   \n",
       "36  Relinquishment of Council Office Budget Funds ...   \n",
       "37  Relinquishment of Council Office Budget Funds ...   \n",
       "38  Relinquishment of Council Office Budget Funds ...   \n",
       "39  Relinquishment of Council Office Budget Funds ...   \n",
       "40  Relinquishment of Council Office Budget Funds ...   \n",
       "41  Relinquishment of Council Office Budget Funds ...   \n",
       "42  Relinquishment of Council Office Budget Funds ...   \n",
       "43  Relinquishment of Council Office Budget Funds ...   \n",
       "44  Relinquishment of Council Office Budget Funds ...   \n",
       "45  Referral Response: Affordable Housing Preferen...   \n",
       "46  Adoption — Civic Center Phase II — Design Concept   \n",
       "47  Adoption — Civic Center Phase II — Design Concept   \n",
       "48  Adoption — Civic Center Phase II — Design Concept   \n",
       "49  Adoption — Civic Center Phase II — Design Concept   \n",
       "50  Adoption — Civic Center Phase II — Design Concept   \n",
       "51  Adoption — Civic Center Phase II — Design Concept   \n",
       "52  Adoption — Civic Center Phase II — Design Concept   \n",
       "53  Adoption — Civic Center Phase II — Design Concept   \n",
       "54  De-Prioritizing the enforcement of laws imposi...   \n",
       "\n",
       "                                                  rec  \\\n",
       "0   Adopt a Resolution opposing Tokyo Electric Pow...   \n",
       "1   Adopt a Resolution opposing Tokyo Electric Pow...   \n",
       "2   Adopt a Resolution opposing Tokyo Electric Pow...   \n",
       "3   Adopt a Resolution to create an Affordable Hou...   \n",
       "4   Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "5   Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "6   Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "7   Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "8   Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "9   Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "10  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "11  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "12  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "13  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "14  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "15  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "16  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "17  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "18  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "19  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "20  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "21  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "22  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "23  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "24  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "25  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "26  Approve the Resolution presented and passed wi...   \n",
       "27  Approve the Resolution presented and passed wi...   \n",
       "28  Approve the Resolution presented and passed wi...   \n",
       "29  Approve the Resolution presented and passed wi...   \n",
       "30  Adopt a Resolution authorizing the City Manage...   \n",
       "31  Adopt a resolution approving an expenditure of...   \n",
       "32  Adopt a resolution approving an expenditure of...   \n",
       "33  Adopt a resolution approving an expenditure of...   \n",
       "34  Adopt a resolution approving an expenditure of...   \n",
       "35  Adopt a resolution approving an expenditure of...   \n",
       "36  Adopt a resolution approving an expenditure of...   \n",
       "37  Adopt a resolution approving an expenditure of...   \n",
       "38  Adopt a resolution approving an expenditure of...   \n",
       "39  Adopt a resolution approving an expenditure of...   \n",
       "40  Adopt a resolution approving an expenditure of...   \n",
       "41  Adopt a resolution approving an expenditure of...   \n",
       "42  Adopt a resolution approving an expenditure of...   \n",
       "43  Adopt a resolution approving an expenditure of...   \n",
       "44  Adopt a resolution approving an expenditure of...   \n",
       "45  Adopt a Resolution to create an Affordable Hou...   \n",
       "46  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "47  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "48  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "49  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "50  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "51  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "52  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "53  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "54  Approve the Resolution presented and passed wi...   \n",
       "\n",
       "                                             raw_summ  \\\n",
       "0   {'intermediate_steps': [\"Comms #: 131\\nName: S...   \n",
       "1   {'intermediate_steps': [\"Comms #: 132\\nName: D...   \n",
       "2   {'intermediate_steps': ['Comms #: 133\\nName: M...   \n",
       "3   {'intermediate_steps': ['Comms #: 135\\nName: C...   \n",
       "4   {'intermediate_steps': ['Comms #: 136\\nName: C...   \n",
       "5   {'intermediate_steps': [\"Comms #: 137\\nName: M...   \n",
       "6   {'intermediate_steps': ['Comms #: 138\\nName: M...   \n",
       "7   {'intermediate_steps': ['Comms #: 139\\nName: R...   \n",
       "8   {'intermediate_steps': [\"Comms #: 140\\nName: S...   \n",
       "9   {'intermediate_steps': ['Comms #: 141\\nName: D...   \n",
       "10  {'intermediate_steps': ['Comms #: 142\\nName: A...   \n",
       "11  {'intermediate_steps': ['Comms #: 143\\nName: S...   \n",
       "12  {'intermediate_steps': ['Comms #: 144\\nName: S...   \n",
       "13  {'intermediate_steps': ['Comms #: 145\\nName: M...   \n",
       "14  {'intermediate_steps': ['Comms #: 146\\nName: I...   \n",
       "15  {'intermediate_steps': ['Comms #: 147\\nName: F...   \n",
       "16  {'intermediate_steps': ['Comms #: 148\\nName: D...   \n",
       "17  {'intermediate_steps': ['Comms #: 149\\nName: C...   \n",
       "18  {'intermediate_steps': ['Comms #: 150\\nName: T...   \n",
       "19  {'intermediate_steps': ['Comms #: 151\\nName: S...   \n",
       "20  {'intermediate_steps': ['Comms #: 152\\nName: B...   \n",
       "21  {'intermediate_steps': ['Comms #: 153\\nName: S...   \n",
       "22  {'intermediate_steps': ['Comms #: 155\\nName: M...   \n",
       "23  {'intermediate_steps': ['Comms #: 157\\nName: K...   \n",
       "24  {'intermediate_steps': ['Comms #: 159\\nName: N...   \n",
       "25  {'intermediate_steps': ['Comms #: 160\\nName: C...   \n",
       "26  {'intermediate_steps': ['Comms #: 162\\nName: C...   \n",
       "27  {'intermediate_steps': ['Comms #: 163\\nName: F...   \n",
       "28  {'intermediate_steps': ['Comms #: 164\\nName: C...   \n",
       "29  {'intermediate_steps': ['Comms #: 165\\nName: K...   \n",
       "30  {'intermediate_steps': ['Comms #: 166\\nName: S...   \n",
       "31  {'intermediate_steps': ['Comms #: 167\\nName: B...   \n",
       "32  {'intermediate_steps': [\"Comms #: 168\\nName: T...   \n",
       "33  {'intermediate_steps': ['Comms #: 169\\nName: P...   \n",
       "34  {'intermediate_steps': ['Comms #: 170\\nName: D...   \n",
       "35  {'intermediate_steps': [\"Comms #: 172\\nName: B...   \n",
       "36  {'intermediate_steps': [\"Comms #: 173\\nName: E...   \n",
       "37  {'intermediate_steps': ['Comms #: 174\\nName: Y...   \n",
       "38  {'intermediate_steps': [\"Comms #: 175\\nName: L...   \n",
       "39  {'intermediate_steps': [\"Comms #: 176\\nName: L...   \n",
       "40  {'intermediate_steps': [\"Comms #: 177\\nName: L...   \n",
       "41  {'intermediate_steps': [\"Comms #: 178\\nName: J...   \n",
       "42  {'intermediate_steps': ['Comms #: 179\\nName: E...   \n",
       "43  {'intermediate_steps': ['Comms #: 180\\nName: H...   \n",
       "44  {'intermediate_steps': [\"Comms #: 181\\nName: D...   \n",
       "45  {'intermediate_steps': ['Comms #: 185\\nName: D...   \n",
       "46  {'intermediate_steps': ['Comms #: 186\\nName: L...   \n",
       "47  {'intermediate_steps': ['Comms #: 187\\nName: B...   \n",
       "48  {'intermediate_steps': ['Comms #: 189\\nName: K...   \n",
       "49  {'intermediate_steps': ['Comms #: 190\\nName: T...   \n",
       "50  {'intermediate_steps': ['Comms #: 191\\nName: K...   \n",
       "51  {'intermediate_steps': ['Comms #: 192\\nName: E...   \n",
       "52  {'intermediate_steps': ['Comms #: 193\\nName: A...   \n",
       "53  {'intermediate_steps': ['Comms #: 194\\nName: J...   \n",
       "54  {'intermediate_steps': ['Comms #: 195\\nName: I...   \n",
       "\n",
       "                                           short_summ position  \n",
       "0   Seaver Wang opposes the proposed resolution by...   Oppose  \n",
       "1   Diane Bohn is requesting support for Council m...  Support  \n",
       "2   Miya Sommers urges the Berkeley City Council t...  Support  \n",
       "3   Carole Marasovic requests the consideration of...    Other  \n",
       "4   Chase Hommeyer supports the full restoration o...  Support  \n",
       "5   Michael Weber is requesting the City Council's...  Support  \n",
       "6   Miranda Ewell supports the full flow restorati...  Support  \n",
       "7   Ruth Morgan is requesting the support of the C...  Support  \n",
       "8   Summer Brenner is requesting the council's sup...  Support  \n",
       "9   Drew Goetting provides a letter with considera...    Other  \n",
       "10  Ann Harlow, representing the Berkeley Historic...  Support  \n",
       "11  Stefen is requesting support for a full flow r...  Support  \n",
       "12  Sylvia Soriano is requesting support for a ful...  Support  \n",
       "13  Mary Price is requesting support for a full fl...  Support  \n",
       "14  Irene Rice is requesting support for a Full Fl...  Support  \n",
       "15  Fredrica Drotos supports the full flow restora...  Support  \n",
       "16  Dick and Mariko Eastman support a full flow re...  Support  \n",
       "17  Carolyn Shoulders, a Berkeley resident, is req...  Support  \n",
       "18  Tom Miller urges the Council to support the da...  Support  \n",
       "19  Sheila Himmel is requesting support for a full...  Support  \n",
       "20  Bernard Marszalek is requesting support for th...  Support  \n",
       "21  Sally Nelson is requesting support for a full ...  Support  \n",
       "22  Margot Cunningham is requesting the support of...  Support  \n",
       "23  Kathleen Giustino is requesting support for a ...  Support  \n",
       "24  Nancy Schimmel is requesting the full support ...  Support  \n",
       "25  The Landmarks Preservation Commission supports...  Support  \n",
       "26  Camille MacDonald supports the recommendation ...  Support  \n",
       "27  Fran Haselsteiner opposes the proposal to lega...   Oppose  \n",
       "28  Clifton Ross is requesting support for the dec...  Support  \n",
       "29  Karen Armstead is urging support for Item 35 o...  Support  \n",
       "30  Steve Lipson questions the budget and efficien...    Other  \n",
       "31  Beatriz Leyva and Santiago Casal are thanking ...  Support  \n",
       "32  Tsukuru Fors supports the resolution opposing ...  Support  \n",
       "33  Phoebe Thomas urges the Berkeley City Council ...  Support  \n",
       "34  David McGuire supports the resolution opposing...  Support  \n",
       "35  Bindu Desai recommends adopting a resolution o...  Support  \n",
       "36  Eva Frye expresses strong support for councilm...  Support  \n",
       "37  Yuka Saito opposes the release of contaminated...   Oppose  \n",
       "38  Laura Feldman opposes TEPCO's plan to dump rad...   Oppose  \n",
       "39  Linda Roman urges the council to oppose Japan'...   Oppose  \n",
       "40  Liz Taylor supports the Resolution Opposing To...  Support  \n",
       "41  Jacqueline Cabasso supports the Resolution Opp...  Support  \n",
       "42  Eri Tomita expresses opposition to the propose...   Oppose  \n",
       "43  Heiko Hasegawa opposes the release of contamin...   Oppose  \n",
       "44  Desiree expresses enthusiastic support for Cou...  Support  \n",
       "45  Derethia DuVal supports the adoption of an Aff...  Support  \n",
       "46  Linda Currie is requesting support for the app...  Support  \n",
       "47  Beth Lamont supports a full flow restoration o...  Support  \n",
       "48  Kelly Hammargren supports the alternative desi...  Support  \n",
       "49  Tom Kelly supports the daylighting of Strawber...  Support  \n",
       "50  Kathleen Giustino supports the full flow resto...  Support  \n",
       "51  Erin Diehm is providing 247 petition signature...  Support  \n",
       "52  Andra Mitchell is requesting support for a ful...  Support  \n",
       "53  Jack Kurzweil expresses disappointment and dis...   Oppose  \n",
       "54  Isabelle Gaston opposes the recommendations re...   Oppose  "
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "item_comms_speaker_df = pd.concat([item_comms_speaker_df_2, item_comms_speaker_df_3], ignore_index=True).copy()\n",
    "item_comms_speaker_df\n",
    "#### TODO: hand-tag to check for accuracy!\n",
    "#### TODO: alternate bag-of-words approach!  and support/oppose approach!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "b535e534",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandas.core.groupby.generic.DataFrameGroupBy object at 0x13012f010>"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "item_comms_speaker_df.groupby(\"item_num\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "5e4a415a",
   "metadata": {},
   "outputs": [],
   "source": [
    "#### TODO: viz; bar w/ individual squares for each person"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "5c55b639",
   "metadata": {},
   "outputs": [],
   "source": [
    "# item_comms_speaker_df[\"support_bool\"] = item_comms_speaker_df[\"position\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "6aed234d",
   "metadata": {},
   "outputs": [],
   "source": [
    "item_comms_speaker_df.to_csv(\"./synthed_comms_sets_2_3.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "id": "e33acf24",
   "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>comms_num</th>\n",
       "      <th>name</th>\n",
       "      <th>comms_text</th>\n",
       "      <th>item_num</th>\n",
       "      <th>item_subject</th>\n",
       "      <th>rec</th>\n",
       "      <th>raw_summ</th>\n",
       "      <th>short_summ</th>\n",
       "      <th>position</th>\n",
       "      <th>support_bool</th>\n",
       "      <th>oppose_bool</th>\n",
       "      <th>other_bool</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>131</td>\n",
       "      <td>Seaver Wang</td>\n",
       "      <td>From: Seaver Wang &lt;seaver@thebreakthrough.org&gt;...</td>\n",
       "      <td>29</td>\n",
       "      <td>Resolution Opposing Tokyo Electric Power Compa...</td>\n",
       "      <td>Adopt a Resolution opposing Tokyo Electric Pow...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 131\\nName: S...</td>\n",
       "      <td>Seaver Wang opposes the proposed resolution by...</td>\n",
       "      <td>Oppose</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>132</td>\n",
       "      <td>Diane Bohn</td>\n",
       "      <td>From: Diana &lt;nicca@igc.org&gt;\\nSent: Friday, Jul...</td>\n",
       "      <td>29</td>\n",
       "      <td>Resolution Opposing Tokyo Electric Power Compa...</td>\n",
       "      <td>Adopt a Resolution opposing Tokyo Electric Pow...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 132\\nName: D...</td>\n",
       "      <td>Diane Bohn is requesting support for Council m...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   comms_num         name                                         comms_text  \\\n",
       "0        131  Seaver Wang  From: Seaver Wang <seaver@thebreakthrough.org>...   \n",
       "1        132   Diane Bohn  From: Diana <nicca@igc.org>\\nSent: Friday, Jul...   \n",
       "\n",
       "   item_num                                       item_subject  \\\n",
       "0        29  Resolution Opposing Tokyo Electric Power Compa...   \n",
       "1        29  Resolution Opposing Tokyo Electric Power Compa...   \n",
       "\n",
       "                                                 rec  \\\n",
       "0  Adopt a Resolution opposing Tokyo Electric Pow...   \n",
       "1  Adopt a Resolution opposing Tokyo Electric Pow...   \n",
       "\n",
       "                                            raw_summ  \\\n",
       "0  {'intermediate_steps': [\"Comms #: 131\\nName: S...   \n",
       "1  {'intermediate_steps': [\"Comms #: 132\\nName: D...   \n",
       "\n",
       "                                          short_summ position  support_bool  \\\n",
       "0  Seaver Wang opposes the proposed resolution by...   Oppose         False   \n",
       "1  Diane Bohn is requesting support for Council m...  Support          True   \n",
       "\n",
       "   oppose_bool  other_bool  \n",
       "0         True       False  \n",
       "1        False       False  "
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "item_comms_speaker_df = item_comms_speaker_df.assign(\n",
    "    support_bool = (item_comms_speaker_df[\"position\"] == \"Support\"),\n",
    "    oppose_bool = (item_comms_speaker_df[\"position\"] == \"Oppose\"),\n",
    "    other_bool = (item_comms_speaker_df[\"position\"] == \"Other\")\n",
    ")\n",
    "item_comms_speaker_df.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "id": "5383834b",
   "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>item_subject</th>\n",
       "      <th>support_bool</th>\n",
       "      <th>oppose_bool</th>\n",
       "      <th>other_bool</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>item_num</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Contract: Insight Housing (formerly Berkeley F...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Resolution Opposing Tokyo Electric Power Compa...</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Referral Response: Affordable Housing Preferen...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>De-Prioritizing the enforcement of laws imposi...</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               item_subject  support_bool  \\\n",
       "item_num                                                                    \n",
       "7         Contract: Insight Housing (formerly Berkeley F...             0   \n",
       "28        Relinquishment of Council Office Budget Funds ...             9   \n",
       "29        Resolution Opposing Tokyo Electric Power Compa...             2   \n",
       "32        Referral Response: Affordable Housing Preferen...             1   \n",
       "33        Adoption — Civic Center Phase II — Design Conc...            28   \n",
       "35        De-Prioritizing the enforcement of laws imposi...             3   \n",
       "\n",
       "          oppose_bool  other_bool  \n",
       "item_num                           \n",
       "7                   0           1  \n",
       "28                  5           0  \n",
       "29                  1           0  \n",
       "32                  0           1  \n",
       "33                  1           1  \n",
       "35                  2           0  "
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "item_comms_speaker_df.groupby(\"item_num\")[[\"item_subject\", \"support_bool\", \"oppose_bool\", \"other_bool\"]].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "id": "8693cc78",
   "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>comms_num</th>\n",
       "      <th>name</th>\n",
       "      <th>comms_text</th>\n",
       "      <th>item_num</th>\n",
       "      <th>item_subject</th>\n",
       "      <th>rec</th>\n",
       "      <th>raw_summ</th>\n",
       "      <th>short_summ</th>\n",
       "      <th>position</th>\n",
       "      <th>support_bool</th>\n",
       "      <th>oppose_bool</th>\n",
       "      <th>other_bool</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>131</td>\n",
       "      <td>Seaver Wang</td>\n",
       "      <td>From: Seaver Wang &lt;seaver@thebreakthrough.org&gt;...</td>\n",
       "      <td>29</td>\n",
       "      <td>Resolution Opposing Tokyo Electric Power Compa...</td>\n",
       "      <td>Adopt a Resolution opposing Tokyo Electric Pow...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 131\\nName: S...</td>\n",
       "      <td>Seaver Wang opposes the proposed resolution by...</td>\n",
       "      <td>Oppose</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>132</td>\n",
       "      <td>Diane Bohn</td>\n",
       "      <td>From: Diana &lt;nicca@igc.org&gt;\\nSent: Friday, Jul...</td>\n",
       "      <td>29</td>\n",
       "      <td>Resolution Opposing Tokyo Electric Power Compa...</td>\n",
       "      <td>Adopt a Resolution opposing Tokyo Electric Pow...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 132\\nName: D...</td>\n",
       "      <td>Diane Bohn is requesting support for Council m...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>133</td>\n",
       "      <td>Miya Sommers</td>\n",
       "      <td>— . .\\neee ERR ee EN a I CAC,\\n\\nFrom: Miya So...</td>\n",
       "      <td>29</td>\n",
       "      <td>Resolution Opposing Tokyo Electric Power Compa...</td>\n",
       "      <td>Adopt a Resolution opposing Tokyo Electric Pow...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 133\\nName: M...</td>\n",
       "      <td>Miya Sommers urges the Berkeley City Council t...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>135</td>\n",
       "      <td>Carole Marasovic</td>\n",
       "      <td>From: carole marasovic &lt;daphnesflight@yahoo.co...</td>\n",
       "      <td>32</td>\n",
       "      <td>Referral Response: Affordable Housing Preferen...</td>\n",
       "      <td>Adopt a Resolution to create an Affordable Hou...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 135\\nName: C...</td>\n",
       "      <td>Carole Marasovic requests the consideration of...</td>\n",
       "      <td>Other</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>136</td>\n",
       "      <td>Chase Hommeyer</td>\n",
       "      <td>—\\na\\n\\nFrom:\\nSent:\\nTo:\\n\\nSubject:\\n\\nChase...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 136\\nName: C...</td>\n",
       "      <td>Chase Hommeyer supports the full restoration o...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>137</td>\n",
       "      <td>Michael Weber</td>\n",
       "      <td>etn tl\\n\\nFrom: Michael Weber &lt;michaeljohnwebe...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 137\\nName: M...</td>\n",
       "      <td>Michael Weber is requesting the City Council's...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>138</td>\n",
       "      <td>Miranda Ewell</td>\n",
       "      <td>From: Miranda Ewell &lt;mirandaewell@gmail.com&gt;\\n...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 138\\nName: M...</td>\n",
       "      <td>Miranda Ewell supports the full flow restorati...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>139</td>\n",
       "      <td>Ruth Morgan</td>\n",
       "      <td>From: : ~ Ruth Morgan &lt;morganruth397@gmail.com...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 139\\nName: R...</td>\n",
       "      <td>Ruth Morgan is requesting the support of the C...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>140</td>\n",
       "      <td>Summer Brenner</td>\n",
       "      <td>From: Summer Brenner &lt;summerbrenner@gmail.com&gt;...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 140\\nName: S...</td>\n",
       "      <td>Summer Brenner is requesting the council's sup...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>141</td>\n",
       "      <td>Drew Goetting</td>\n",
       "      <td>From: Berkeley Mayor's Office\\n\\nSent: Sunday,...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 141\\nName: D...</td>\n",
       "      <td>Drew Goetting provides a letter with considera...</td>\n",
       "      <td>Other</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>142</td>\n",
       "      <td>Ann Harlow</td>\n",
       "      <td>From: Ann Harlow &lt;annharlow77@gmail.com&gt;\\nSent...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 142\\nName: A...</td>\n",
       "      <td>Ann Harlow, representing the Berkeley Historic...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>143</td>\n",
       "      <td>Stefen</td>\n",
       "      <td>From: stefen STEFEN &lt;stefen@stefenart.com&gt;\\nSe...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 143\\nName: S...</td>\n",
       "      <td>Stefen is requesting support for a full flow r...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>144</td>\n",
       "      <td>Sylvia Soriano</td>\n",
       "      <td>;\\n|\\n\\nFrom: Sylvia Soriano &lt;sylviana286@gmai...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 144\\nName: S...</td>\n",
       "      <td>Sylvia Soriano is requesting support for a ful...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>145</td>\n",
       "      <td>Mary Price</td>\n",
       "      <td>From: MaryRPrice &lt;maryrprice@gmail.com&gt;\\n\\nSen...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 145\\nName: M...</td>\n",
       "      <td>Mary Price is requesting support for a full fl...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>146</td>\n",
       "      <td>Irene Rice</td>\n",
       "      <td>t :\\nenna ee ee reece eee ee eee SS\\n\\nFrom: |...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 146\\nName: I...</td>\n",
       "      <td>Irene Rice is requesting support for a Full Fl...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>147</td>\n",
       "      <td>Fredrica Drotos</td>\n",
       "      <td>From: FD &lt;fadrot@gmail.com&gt; -\\n\\nSent: Saturda...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 147\\nName: F...</td>\n",
       "      <td>Fredrica Drotos supports the full flow restora...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>148</td>\n",
       "      <td>Dick and</td>\n",
       "      <td>From: Dick Eastman &lt;adzuma.otoko@protonmail.co...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 148\\nName: D...</td>\n",
       "      <td>Dick and Mariko Eastman support a full flow re...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>149</td>\n",
       "      <td>Carolyn Shoulders</td>\n",
       "      <td>From: Carolyn Shoulders &lt;cashou360@gmail.com&gt;\\...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 149\\nName: C...</td>\n",
       "      <td>Carolyn Shoulders, a Berkeley resident, is req...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>150</td>\n",
       "      <td>Tom Miller</td>\n",
       "      <td>From: ‘Tom Miller &lt;milltom@gmail.com&gt;\\n\\nSent:...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 150\\nName: T...</td>\n",
       "      <td>Tom Miller urges the Council to support the da...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>151</td>\n",
       "      <td>Sheila Himmel</td>\n",
       "      <td>.\\ni ii iF TTT\\n\\nFrom: sheila himmel &lt;sheila....</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 151\\nName: S...</td>\n",
       "      <td>Sheila Himmel is requesting support for a full...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>152</td>\n",
       "      <td>Bernard Marszalek</td>\n",
       "      <td>|\\na Ee mre!\\n\\nFrom: Bernard Marszalek &lt;ztang...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 152\\nName: B...</td>\n",
       "      <td>Bernard Marszalek is requesting support for th...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>153</td>\n",
       "      <td>Sally Nelson</td>\n",
       "      <td>| |\\nre\\n\\nFrom: Sally Nelson &lt;sallynels7@gmai...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 153\\nName: S...</td>\n",
       "      <td>Sally Nelson is requesting support for a full ...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>155</td>\n",
       "      <td>Margot Cunningham</td>\n",
       "      <td>| | | .\\nRe a a a I,\\n\\nFrom: Margot Cunningha...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 155\\nName: M...</td>\n",
       "      <td>Margot Cunningham is requesting the support of...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>157</td>\n",
       "      <td>Kathleen Giustino</td>\n",
       "      <td>| | |\\na eel\\n\\nFrom: Kathleen Giustino &lt;kathl...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 157\\nName: K...</td>\n",
       "      <td>Kathleen Giustino is requesting support for a ...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>159</td>\n",
       "      <td>Nancy Schimmel</td>\n",
       "      <td>From: . Nancy Schimmel &lt;nancy@sisterschoice.co...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 159\\nName: N...</td>\n",
       "      <td>Nancy Schimmel is requesting the full support ...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>160</td>\n",
       "      <td>Charles Enchill</td>\n",
       "      <td>. .\\ni\\n\\nFrom: Charles Enchill &lt;enchill.charl...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Conc...</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 160\\nName: C...</td>\n",
       "      <td>The Landmarks Preservation Commission supports...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>162</td>\n",
       "      <td>Camille MacDonald</td>\n",
       "      <td>i een nl\\n\\nFrom: Camille MacDonald &lt;camillema...</td>\n",
       "      <td>35</td>\n",
       "      <td>De-Prioritizing the enforcement of laws imposi...</td>\n",
       "      <td>Approve the Resolution presented and passed wi...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 162\\nName: C...</td>\n",
       "      <td>Camille MacDonald supports the recommendation ...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>163</td>\n",
       "      <td>Fran Haselsteiner</td>\n",
       "      <td>.\\ni\\n\\nFrom: Fran Haselsteiner &lt;franhaselstei...</td>\n",
       "      <td>35</td>\n",
       "      <td>De-Prioritizing the enforcement of laws imposi...</td>\n",
       "      <td>Approve the Resolution presented and passed wi...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 163\\nName: F...</td>\n",
       "      <td>Fran Haselsteiner opposes the proposal to lega...</td>\n",
       "      <td>Oppose</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>164</td>\n",
       "      <td>Clifton Ross</td>\n",
       "      <td>eee RR rr er a A A TTA,\\n\\nFrom: Clifton Ross ...</td>\n",
       "      <td>35</td>\n",
       "      <td>De-Prioritizing the enforcement of laws imposi...</td>\n",
       "      <td>Approve the Resolution presented and passed wi...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 164\\nName: C...</td>\n",
       "      <td>Clifton Ross is requesting support for the dec...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>165</td>\n",
       "      <td>Karen Armstead</td>\n",
       "      <td>| )\\nTTT\\n\\nFrom: Karen Armstead &lt;prunedoggie@...</td>\n",
       "      <td>35</td>\n",
       "      <td>De-Prioritizing the enforcement of laws imposi...</td>\n",
       "      <td>Approve the Resolution presented and passed wi...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 165\\nName: K...</td>\n",
       "      <td>Karen Armstead is urging support for Item 35 o...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>166</td>\n",
       "      <td>Steve Lipson</td>\n",
       "      <td>. .\\nCeeen ee eee ee TT ccc ACCC CCT ata\\n\\nFr...</td>\n",
       "      <td>7</td>\n",
       "      <td>Contract: Insight Housing (formerly Berkeley F...</td>\n",
       "      <td>Adopt a Resolution authorizing the City Manage...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 166\\nName: S...</td>\n",
       "      <td>Steve Lipson questions the budget and efficien...</td>\n",
       "      <td>Other</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>167</td>\n",
       "      <td>Beatriz Leyva</td>\n",
       "      <td>| _ |\\nEee\\n\\nFrom: Beatriz Leyva-Cutler &lt;beat...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 167\\nName: B...</td>\n",
       "      <td>Beatriz Leyva and Santiago Casal are thanking ...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>168</td>\n",
       "      <td>Tsukuru Fors</td>\n",
       "      <td>| \\\\na nnn TT ee\\n\\nFrom: Tsukuru Fors &lt;forfut...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 168\\nName: T...</td>\n",
       "      <td>Tsukuru Fors supports the resolution opposing ...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>169</td>\n",
       "      <td>Phoebe Thomas</td>\n",
       "      <td>. so\\nTTT EE\\n\\nFrom: ~ Phoebe Thomas Sorgen &lt;...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 169\\nName: P...</td>\n",
       "      <td>Phoebe Thomas urges the Berkeley City Council ...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>170</td>\n",
       "      <td>David McGuire</td>\n",
       "      <td>mmm mia\\n\\nFrom: David McGuire &lt;sharkfilms@gma...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 170\\nName: D...</td>\n",
       "      <td>David McGuire supports the resolution opposing...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>172</td>\n",
       "      <td>Bindu Desai</td>\n",
       "      <td>From: Bindu Desai &lt;btdesai@icloud.com&gt;\\n\\nSent...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 172\\nName: B...</td>\n",
       "      <td>Bindu Desai recommends adopting a resolution o...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>173</td>\n",
       "      <td>Eva Frye</td>\n",
       "      <td>,\\n\\nFrom: ; Eva Frye &lt;eva@twohandsbrands.com&gt;...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 173\\nName: E...</td>\n",
       "      <td>Eva Frye expresses strong support for councilm...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>174</td>\n",
       "      <td>Yuka Saito</td>\n",
       "      <td>From: Yuka Saito &lt;sensory.awareness.japan@gmai...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 174\\nName: Y...</td>\n",
       "      <td>Yuka Saito opposes the release of contaminated...</td>\n",
       "      <td>Oppose</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>175</td>\n",
       "      <td>Laura Feldman</td>\n",
       "      <td>From: Laura Feldman &lt;feldman.le@gmail.com&gt;\\n\\n...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 175\\nName: L...</td>\n",
       "      <td>Laura Feldman opposes TEPCO's plan to dump rad...</td>\n",
       "      <td>Oppose</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>176</td>\n",
       "      <td>Linda Roman</td>\n",
       "      <td>From: ~ Linda &lt;lroman@mindspring.com&gt;\\n\\nSent:...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 176\\nName: L...</td>\n",
       "      <td>Linda Roman urges the council to oppose Japan'...</td>\n",
       "      <td>Oppose</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>177</td>\n",
       "      <td>Liz Taylor</td>\n",
       "      <td>From: Liz Taylor &lt;liz@doermarine.com&gt;\\n\\n' Sen...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 177\\nName: L...</td>\n",
       "      <td>Liz Taylor supports the Resolution Opposing To...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>178</td>\n",
       "      <td>Jacqueline Cabasso</td>\n",
       "      <td>From: Jacqueline Cabasso &lt;wslf@earthlink.net&gt;\\...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 178\\nName: J...</td>\n",
       "      <td>Jacqueline Cabasso supports the Resolution Opp...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>179</td>\n",
       "      <td>Eri Tomita</td>\n",
       "      <td>|\\nen!\\n\\nFrom: Cross Pollinators &lt;cross.polli...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 179\\nName: E...</td>\n",
       "      <td>Eri Tomita expresses opposition to the propose...</td>\n",
       "      <td>Oppose</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>180</td>\n",
       "      <td>Heiko Hasegawa</td>\n",
       "      <td>| | . |\\ni i\\n\\nFrom: | Hasegawa Reiko &lt;soundo...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 180\\nName: H...</td>\n",
       "      <td>Heiko Hasegawa opposes the release of contamin...</td>\n",
       "      <td>Oppose</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>181</td>\n",
       "      <td>Desiree McGill</td>\n",
       "      <td>.\\n\\nFrom: Dezz &lt;earthtodezz@gmail.com&gt;\\n\\nSen...</td>\n",
       "      <td>28</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a resolution approving an expenditure of...</td>\n",
       "      <td>{'intermediate_steps': [\"Comms #: 181\\nName: D...</td>\n",
       "      <td>Desiree expresses enthusiastic support for Cou...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>185</td>\n",
       "      <td>Derethia DuVal</td>\n",
       "      <td>From: Derethia DuVal &lt;derethia@outlook.com&gt;\\nS...</td>\n",
       "      <td>32</td>\n",
       "      <td>Referral Response: Affordable Housing Preferen...</td>\n",
       "      <td>Adopt a Resolution to create an Affordable Hou...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 185\\nName: D...</td>\n",
       "      <td>Derethia DuVal supports the adoption of an Aff...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>186</td>\n",
       "      <td>Linda Currie</td>\n",
       "      <td>| |\\n|\\n\\nFrom: . Linda Currie &lt;info@transitio...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 186\\nName: L...</td>\n",
       "      <td>Linda Currie is requesting support for the app...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>187</td>\n",
       "      <td>Beth Lamont</td>\n",
       "      <td>From: Beth Lamont &lt;bethlamont1@gmail.com&gt;\\nSen...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 187\\nName: B...</td>\n",
       "      <td>Beth Lamont supports a full flow restoration o...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>189</td>\n",
       "      <td>Kelly Hammargren</td>\n",
       "      <td>ee ieee\\n\\nFrom: kelly hammargren &lt;kellyhammar...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 189\\nName: K...</td>\n",
       "      <td>Kelly Hammargren supports the alternative desi...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>190</td>\n",
       "      <td>Tom Kelly</td>\n",
       "      <td>. |\\nFrom: ) Tom Kelly &lt;tkelly@kyotousa.org&gt;\\n...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 190\\nName: T...</td>\n",
       "      <td>Tom Kelly supports the daylighting of Strawber...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>191</td>\n",
       "      <td>Kathleen Giustino</td>\n",
       "      <td>.\\n\\nFrom: Kathleen Giustino &lt;kathleeng@a1suni...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 191\\nName: K...</td>\n",
       "      <td>Kathleen Giustino supports the full flow resto...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>192</td>\n",
       "      <td>Erin Diehm</td>\n",
       "      <td>| |\\nSS i\\n\\nFrom: Erin Diehm &lt;erindiehm@hotma...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 192\\nName: E...</td>\n",
       "      <td>Erin Diehm is providing 247 petition signature...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>193</td>\n",
       "      <td>Andra Mitchell</td>\n",
       "      <td>From: Andra Mitchell &lt;andra.mitchell.email@gma...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 193\\nName: A...</td>\n",
       "      <td>Andra Mitchell is requesting support for a ful...</td>\n",
       "      <td>Support</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>194</td>\n",
       "      <td>Jack Kurzweil</td>\n",
       "      <td>eR, a a a i TTT TTT,\\n\\nFrom: Jack Kurzweil &lt;j...</td>\n",
       "      <td>33</td>\n",
       "      <td>Adoption — Civic Center Phase II — Design Concept</td>\n",
       "      <td>Adopt a Resolution approving Berkeley’s Civic ...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 194\\nName: J...</td>\n",
       "      <td>Jack Kurzweil expresses disappointment and dis...</td>\n",
       "      <td>Oppose</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>195</td>\n",
       "      <td>IsabelleGaston</td>\n",
       "      <td>From: Isabelle Gaston &lt;isabelle.gaston@gmail.c...</td>\n",
       "      <td>35</td>\n",
       "      <td>De-Prioritizing the enforcement of laws imposi...</td>\n",
       "      <td>Approve the Resolution presented and passed wi...</td>\n",
       "      <td>{'intermediate_steps': ['Comms #: 195\\nName: I...</td>\n",
       "      <td>Isabelle Gaston opposes the recommendations re...</td>\n",
       "      <td>Oppose</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    comms_num                name  \\\n",
       "0         131         Seaver Wang   \n",
       "1         132          Diane Bohn   \n",
       "2         133        Miya Sommers   \n",
       "3         135    Carole Marasovic   \n",
       "4         136      Chase Hommeyer   \n",
       "5         137       Michael Weber   \n",
       "6         138       Miranda Ewell   \n",
       "7         139         Ruth Morgan   \n",
       "8         140      Summer Brenner   \n",
       "9         141       Drew Goetting   \n",
       "10        142          Ann Harlow   \n",
       "11        143              Stefen   \n",
       "12        144      Sylvia Soriano   \n",
       "13        145          Mary Price   \n",
       "14        146          Irene Rice   \n",
       "15        147     Fredrica Drotos   \n",
       "16        148            Dick and   \n",
       "17        149   Carolyn Shoulders   \n",
       "18        150          Tom Miller   \n",
       "19        151       Sheila Himmel   \n",
       "20        152   Bernard Marszalek   \n",
       "21        153        Sally Nelson   \n",
       "22        155   Margot Cunningham   \n",
       "23        157   Kathleen Giustino   \n",
       "24        159      Nancy Schimmel   \n",
       "25        160     Charles Enchill   \n",
       "26        162   Camille MacDonald   \n",
       "27        163   Fran Haselsteiner   \n",
       "28        164        Clifton Ross   \n",
       "29        165      Karen Armstead   \n",
       "30        166        Steve Lipson   \n",
       "31        167       Beatriz Leyva   \n",
       "32        168        Tsukuru Fors   \n",
       "33        169       Phoebe Thomas   \n",
       "34        170       David McGuire   \n",
       "35        172         Bindu Desai   \n",
       "36        173            Eva Frye   \n",
       "37        174          Yuka Saito   \n",
       "38        175       Laura Feldman   \n",
       "39        176         Linda Roman   \n",
       "40        177          Liz Taylor   \n",
       "41        178  Jacqueline Cabasso   \n",
       "42        179          Eri Tomita   \n",
       "43        180      Heiko Hasegawa   \n",
       "44        181      Desiree McGill   \n",
       "45        185      Derethia DuVal   \n",
       "46        186        Linda Currie   \n",
       "47        187         Beth Lamont   \n",
       "48        189    Kelly Hammargren   \n",
       "49        190           Tom Kelly   \n",
       "50        191   Kathleen Giustino   \n",
       "51        192          Erin Diehm   \n",
       "52        193      Andra Mitchell   \n",
       "53        194       Jack Kurzweil   \n",
       "54        195     IsabelleGaston    \n",
       "\n",
       "                                           comms_text  item_num  \\\n",
       "0   From: Seaver Wang <seaver@thebreakthrough.org>...        29   \n",
       "1   From: Diana <nicca@igc.org>\\nSent: Friday, Jul...        29   \n",
       "2   — . .\\neee ERR ee EN a I CAC,\\n\\nFrom: Miya So...        29   \n",
       "3   From: carole marasovic <daphnesflight@yahoo.co...        32   \n",
       "4   —\\na\\n\\nFrom:\\nSent:\\nTo:\\n\\nSubject:\\n\\nChase...        33   \n",
       "5   etn tl\\n\\nFrom: Michael Weber <michaeljohnwebe...        33   \n",
       "6   From: Miranda Ewell <mirandaewell@gmail.com>\\n...        33   \n",
       "7   From: : ~ Ruth Morgan <morganruth397@gmail.com...        33   \n",
       "8   From: Summer Brenner <summerbrenner@gmail.com>...        33   \n",
       "9   From: Berkeley Mayor's Office\\n\\nSent: Sunday,...        33   \n",
       "10  From: Ann Harlow <annharlow77@gmail.com>\\nSent...        33   \n",
       "11  From: stefen STEFEN <stefen@stefenart.com>\\nSe...        33   \n",
       "12  ;\\n|\\n\\nFrom: Sylvia Soriano <sylviana286@gmai...        33   \n",
       "13  From: MaryRPrice <maryrprice@gmail.com>\\n\\nSen...        33   \n",
       "14  t :\\nenna ee ee reece eee ee eee SS\\n\\nFrom: |...        33   \n",
       "15  From: FD <fadrot@gmail.com> -\\n\\nSent: Saturda...        33   \n",
       "16  From: Dick Eastman <adzuma.otoko@protonmail.co...        33   \n",
       "17  From: Carolyn Shoulders <cashou360@gmail.com>\\...        33   \n",
       "18  From: ‘Tom Miller <milltom@gmail.com>\\n\\nSent:...        33   \n",
       "19  .\\ni ii iF TTT\\n\\nFrom: sheila himmel <sheila....        33   \n",
       "20  |\\na Ee mre!\\n\\nFrom: Bernard Marszalek <ztang...        33   \n",
       "21  | |\\nre\\n\\nFrom: Sally Nelson <sallynels7@gmai...        33   \n",
       "22  | | | .\\nRe a a a I,\\n\\nFrom: Margot Cunningha...        33   \n",
       "23  | | |\\na eel\\n\\nFrom: Kathleen Giustino <kathl...        33   \n",
       "24  From: . Nancy Schimmel <nancy@sisterschoice.co...        33   \n",
       "25  . .\\ni\\n\\nFrom: Charles Enchill <enchill.charl...        33   \n",
       "26  i een nl\\n\\nFrom: Camille MacDonald <camillema...        35   \n",
       "27  .\\ni\\n\\nFrom: Fran Haselsteiner <franhaselstei...        35   \n",
       "28  eee RR rr er a A A TTA,\\n\\nFrom: Clifton Ross ...        35   \n",
       "29  | )\\nTTT\\n\\nFrom: Karen Armstead <prunedoggie@...        35   \n",
       "30  . .\\nCeeen ee eee ee TT ccc ACCC CCT ata\\n\\nFr...         7   \n",
       "31  | _ |\\nEee\\n\\nFrom: Beatriz Leyva-Cutler <beat...        28   \n",
       "32  | \\\\na nnn TT ee\\n\\nFrom: Tsukuru Fors <forfut...        28   \n",
       "33  . so\\nTTT EE\\n\\nFrom: ~ Phoebe Thomas Sorgen <...        28   \n",
       "34  mmm mia\\n\\nFrom: David McGuire <sharkfilms@gma...        28   \n",
       "35  From: Bindu Desai <btdesai@icloud.com>\\n\\nSent...        28   \n",
       "36  ,\\n\\nFrom: ; Eva Frye <eva@twohandsbrands.com>...        28   \n",
       "37  From: Yuka Saito <sensory.awareness.japan@gmai...        28   \n",
       "38  From: Laura Feldman <feldman.le@gmail.com>\\n\\n...        28   \n",
       "39  From: ~ Linda <lroman@mindspring.com>\\n\\nSent:...        28   \n",
       "40  From: Liz Taylor <liz@doermarine.com>\\n\\n' Sen...        28   \n",
       "41  From: Jacqueline Cabasso <wslf@earthlink.net>\\...        28   \n",
       "42  |\\nen!\\n\\nFrom: Cross Pollinators <cross.polli...        28   \n",
       "43  | | . |\\ni i\\n\\nFrom: | Hasegawa Reiko <soundo...        28   \n",
       "44  .\\n\\nFrom: Dezz <earthtodezz@gmail.com>\\n\\nSen...        28   \n",
       "45  From: Derethia DuVal <derethia@outlook.com>\\nS...        32   \n",
       "46  | |\\n|\\n\\nFrom: . Linda Currie <info@transitio...        33   \n",
       "47  From: Beth Lamont <bethlamont1@gmail.com>\\nSen...        33   \n",
       "48  ee ieee\\n\\nFrom: kelly hammargren <kellyhammar...        33   \n",
       "49  . |\\nFrom: ) Tom Kelly <tkelly@kyotousa.org>\\n...        33   \n",
       "50  .\\n\\nFrom: Kathleen Giustino <kathleeng@a1suni...        33   \n",
       "51  | |\\nSS i\\n\\nFrom: Erin Diehm <erindiehm@hotma...        33   \n",
       "52  From: Andra Mitchell <andra.mitchell.email@gma...        33   \n",
       "53  eR, a a a i TTT TTT,\\n\\nFrom: Jack Kurzweil <j...        33   \n",
       "54  From: Isabelle Gaston <isabelle.gaston@gmail.c...        35   \n",
       "\n",
       "                                         item_subject  \\\n",
       "0   Resolution Opposing Tokyo Electric Power Compa...   \n",
       "1   Resolution Opposing Tokyo Electric Power Compa...   \n",
       "2   Resolution Opposing Tokyo Electric Power Compa...   \n",
       "3   Referral Response: Affordable Housing Preferen...   \n",
       "4   Adoption — Civic Center Phase II — Design Concept   \n",
       "5   Adoption — Civic Center Phase II — Design Concept   \n",
       "6   Adoption — Civic Center Phase II — Design Concept   \n",
       "7   Adoption — Civic Center Phase II — Design Concept   \n",
       "8   Adoption — Civic Center Phase II — Design Conc...   \n",
       "9   Adoption — Civic Center Phase II — Design Conc...   \n",
       "10  Adoption — Civic Center Phase II — Design Conc...   \n",
       "11  Adoption — Civic Center Phase II — Design Conc...   \n",
       "12  Adoption — Civic Center Phase II — Design Conc...   \n",
       "13  Adoption — Civic Center Phase II — Design Conc...   \n",
       "14  Adoption — Civic Center Phase II — Design Conc...   \n",
       "15  Adoption — Civic Center Phase II — Design Conc...   \n",
       "16  Adoption — Civic Center Phase II — Design Conc...   \n",
       "17  Adoption — Civic Center Phase II — Design Conc...   \n",
       "18  Adoption — Civic Center Phase II — Design Conc...   \n",
       "19  Adoption — Civic Center Phase II — Design Conc...   \n",
       "20  Adoption — Civic Center Phase II — Design Conc...   \n",
       "21  Adoption — Civic Center Phase II — Design Conc...   \n",
       "22  Adoption — Civic Center Phase II — Design Conc...   \n",
       "23  Adoption — Civic Center Phase II — Design Conc...   \n",
       "24  Adoption — Civic Center Phase II — Design Conc...   \n",
       "25  Adoption — Civic Center Phase II — Design Conc...   \n",
       "26  De-Prioritizing the enforcement of laws imposi...   \n",
       "27  De-Prioritizing the enforcement of laws imposi...   \n",
       "28  De-Prioritizing the enforcement of laws imposi...   \n",
       "29  De-Prioritizing the enforcement of laws imposi...   \n",
       "30  Contract: Insight Housing (formerly Berkeley F...   \n",
       "31  Relinquishment of Council Office Budget Funds ...   \n",
       "32  Relinquishment of Council Office Budget Funds ...   \n",
       "33  Relinquishment of Council Office Budget Funds ...   \n",
       "34  Relinquishment of Council Office Budget Funds ...   \n",
       "35  Relinquishment of Council Office Budget Funds ...   \n",
       "36  Relinquishment of Council Office Budget Funds ...   \n",
       "37  Relinquishment of Council Office Budget Funds ...   \n",
       "38  Relinquishment of Council Office Budget Funds ...   \n",
       "39  Relinquishment of Council Office Budget Funds ...   \n",
       "40  Relinquishment of Council Office Budget Funds ...   \n",
       "41  Relinquishment of Council Office Budget Funds ...   \n",
       "42  Relinquishment of Council Office Budget Funds ...   \n",
       "43  Relinquishment of Council Office Budget Funds ...   \n",
       "44  Relinquishment of Council Office Budget Funds ...   \n",
       "45  Referral Response: Affordable Housing Preferen...   \n",
       "46  Adoption — Civic Center Phase II — Design Concept   \n",
       "47  Adoption — Civic Center Phase II — Design Concept   \n",
       "48  Adoption — Civic Center Phase II — Design Concept   \n",
       "49  Adoption — Civic Center Phase II — Design Concept   \n",
       "50  Adoption — Civic Center Phase II — Design Concept   \n",
       "51  Adoption — Civic Center Phase II — Design Concept   \n",
       "52  Adoption — Civic Center Phase II — Design Concept   \n",
       "53  Adoption — Civic Center Phase II — Design Concept   \n",
       "54  De-Prioritizing the enforcement of laws imposi...   \n",
       "\n",
       "                                                  rec  \\\n",
       "0   Adopt a Resolution opposing Tokyo Electric Pow...   \n",
       "1   Adopt a Resolution opposing Tokyo Electric Pow...   \n",
       "2   Adopt a Resolution opposing Tokyo Electric Pow...   \n",
       "3   Adopt a Resolution to create an Affordable Hou...   \n",
       "4   Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "5   Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "6   Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "7   Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "8   Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "9   Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "10  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "11  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "12  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "13  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "14  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "15  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "16  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "17  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "18  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "19  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "20  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "21  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "22  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "23  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "24  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "25  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "26  Approve the Resolution presented and passed wi...   \n",
       "27  Approve the Resolution presented and passed wi...   \n",
       "28  Approve the Resolution presented and passed wi...   \n",
       "29  Approve the Resolution presented and passed wi...   \n",
       "30  Adopt a Resolution authorizing the City Manage...   \n",
       "31  Adopt a resolution approving an expenditure of...   \n",
       "32  Adopt a resolution approving an expenditure of...   \n",
       "33  Adopt a resolution approving an expenditure of...   \n",
       "34  Adopt a resolution approving an expenditure of...   \n",
       "35  Adopt a resolution approving an expenditure of...   \n",
       "36  Adopt a resolution approving an expenditure of...   \n",
       "37  Adopt a resolution approving an expenditure of...   \n",
       "38  Adopt a resolution approving an expenditure of...   \n",
       "39  Adopt a resolution approving an expenditure of...   \n",
       "40  Adopt a resolution approving an expenditure of...   \n",
       "41  Adopt a resolution approving an expenditure of...   \n",
       "42  Adopt a resolution approving an expenditure of...   \n",
       "43  Adopt a resolution approving an expenditure of...   \n",
       "44  Adopt a resolution approving an expenditure of...   \n",
       "45  Adopt a Resolution to create an Affordable Hou...   \n",
       "46  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "47  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "48  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "49  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "50  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "51  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "52  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "53  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "54  Approve the Resolution presented and passed wi...   \n",
       "\n",
       "                                             raw_summ  \\\n",
       "0   {'intermediate_steps': [\"Comms #: 131\\nName: S...   \n",
       "1   {'intermediate_steps': [\"Comms #: 132\\nName: D...   \n",
       "2   {'intermediate_steps': ['Comms #: 133\\nName: M...   \n",
       "3   {'intermediate_steps': ['Comms #: 135\\nName: C...   \n",
       "4   {'intermediate_steps': ['Comms #: 136\\nName: C...   \n",
       "5   {'intermediate_steps': [\"Comms #: 137\\nName: M...   \n",
       "6   {'intermediate_steps': ['Comms #: 138\\nName: M...   \n",
       "7   {'intermediate_steps': ['Comms #: 139\\nName: R...   \n",
       "8   {'intermediate_steps': [\"Comms #: 140\\nName: S...   \n",
       "9   {'intermediate_steps': ['Comms #: 141\\nName: D...   \n",
       "10  {'intermediate_steps': ['Comms #: 142\\nName: A...   \n",
       "11  {'intermediate_steps': ['Comms #: 143\\nName: S...   \n",
       "12  {'intermediate_steps': ['Comms #: 144\\nName: S...   \n",
       "13  {'intermediate_steps': ['Comms #: 145\\nName: M...   \n",
       "14  {'intermediate_steps': ['Comms #: 146\\nName: I...   \n",
       "15  {'intermediate_steps': ['Comms #: 147\\nName: F...   \n",
       "16  {'intermediate_steps': ['Comms #: 148\\nName: D...   \n",
       "17  {'intermediate_steps': ['Comms #: 149\\nName: C...   \n",
       "18  {'intermediate_steps': ['Comms #: 150\\nName: T...   \n",
       "19  {'intermediate_steps': ['Comms #: 151\\nName: S...   \n",
       "20  {'intermediate_steps': ['Comms #: 152\\nName: B...   \n",
       "21  {'intermediate_steps': ['Comms #: 153\\nName: S...   \n",
       "22  {'intermediate_steps': ['Comms #: 155\\nName: M...   \n",
       "23  {'intermediate_steps': ['Comms #: 157\\nName: K...   \n",
       "24  {'intermediate_steps': ['Comms #: 159\\nName: N...   \n",
       "25  {'intermediate_steps': ['Comms #: 160\\nName: C...   \n",
       "26  {'intermediate_steps': ['Comms #: 162\\nName: C...   \n",
       "27  {'intermediate_steps': ['Comms #: 163\\nName: F...   \n",
       "28  {'intermediate_steps': ['Comms #: 164\\nName: C...   \n",
       "29  {'intermediate_steps': ['Comms #: 165\\nName: K...   \n",
       "30  {'intermediate_steps': ['Comms #: 166\\nName: S...   \n",
       "31  {'intermediate_steps': ['Comms #: 167\\nName: B...   \n",
       "32  {'intermediate_steps': [\"Comms #: 168\\nName: T...   \n",
       "33  {'intermediate_steps': ['Comms #: 169\\nName: P...   \n",
       "34  {'intermediate_steps': ['Comms #: 170\\nName: D...   \n",
       "35  {'intermediate_steps': [\"Comms #: 172\\nName: B...   \n",
       "36  {'intermediate_steps': [\"Comms #: 173\\nName: E...   \n",
       "37  {'intermediate_steps': ['Comms #: 174\\nName: Y...   \n",
       "38  {'intermediate_steps': [\"Comms #: 175\\nName: L...   \n",
       "39  {'intermediate_steps': [\"Comms #: 176\\nName: L...   \n",
       "40  {'intermediate_steps': [\"Comms #: 177\\nName: L...   \n",
       "41  {'intermediate_steps': [\"Comms #: 178\\nName: J...   \n",
       "42  {'intermediate_steps': ['Comms #: 179\\nName: E...   \n",
       "43  {'intermediate_steps': ['Comms #: 180\\nName: H...   \n",
       "44  {'intermediate_steps': [\"Comms #: 181\\nName: D...   \n",
       "45  {'intermediate_steps': ['Comms #: 185\\nName: D...   \n",
       "46  {'intermediate_steps': ['Comms #: 186\\nName: L...   \n",
       "47  {'intermediate_steps': ['Comms #: 187\\nName: B...   \n",
       "48  {'intermediate_steps': ['Comms #: 189\\nName: K...   \n",
       "49  {'intermediate_steps': ['Comms #: 190\\nName: T...   \n",
       "50  {'intermediate_steps': ['Comms #: 191\\nName: K...   \n",
       "51  {'intermediate_steps': ['Comms #: 192\\nName: E...   \n",
       "52  {'intermediate_steps': ['Comms #: 193\\nName: A...   \n",
       "53  {'intermediate_steps': ['Comms #: 194\\nName: J...   \n",
       "54  {'intermediate_steps': ['Comms #: 195\\nName: I...   \n",
       "\n",
       "                                           short_summ position  support_bool  \\\n",
       "0   Seaver Wang opposes the proposed resolution by...   Oppose         False   \n",
       "1   Diane Bohn is requesting support for Council m...  Support          True   \n",
       "2   Miya Sommers urges the Berkeley City Council t...  Support          True   \n",
       "3   Carole Marasovic requests the consideration of...    Other         False   \n",
       "4   Chase Hommeyer supports the full restoration o...  Support          True   \n",
       "5   Michael Weber is requesting the City Council's...  Support          True   \n",
       "6   Miranda Ewell supports the full flow restorati...  Support          True   \n",
       "7   Ruth Morgan is requesting the support of the C...  Support          True   \n",
       "8   Summer Brenner is requesting the council's sup...  Support          True   \n",
       "9   Drew Goetting provides a letter with considera...    Other         False   \n",
       "10  Ann Harlow, representing the Berkeley Historic...  Support          True   \n",
       "11  Stefen is requesting support for a full flow r...  Support          True   \n",
       "12  Sylvia Soriano is requesting support for a ful...  Support          True   \n",
       "13  Mary Price is requesting support for a full fl...  Support          True   \n",
       "14  Irene Rice is requesting support for a Full Fl...  Support          True   \n",
       "15  Fredrica Drotos supports the full flow restora...  Support          True   \n",
       "16  Dick and Mariko Eastman support a full flow re...  Support          True   \n",
       "17  Carolyn Shoulders, a Berkeley resident, is req...  Support          True   \n",
       "18  Tom Miller urges the Council to support the da...  Support          True   \n",
       "19  Sheila Himmel is requesting support for a full...  Support          True   \n",
       "20  Bernard Marszalek is requesting support for th...  Support          True   \n",
       "21  Sally Nelson is requesting support for a full ...  Support          True   \n",
       "22  Margot Cunningham is requesting the support of...  Support          True   \n",
       "23  Kathleen Giustino is requesting support for a ...  Support          True   \n",
       "24  Nancy Schimmel is requesting the full support ...  Support          True   \n",
       "25  The Landmarks Preservation Commission supports...  Support          True   \n",
       "26  Camille MacDonald supports the recommendation ...  Support          True   \n",
       "27  Fran Haselsteiner opposes the proposal to lega...   Oppose         False   \n",
       "28  Clifton Ross is requesting support for the dec...  Support          True   \n",
       "29  Karen Armstead is urging support for Item 35 o...  Support          True   \n",
       "30  Steve Lipson questions the budget and efficien...    Other         False   \n",
       "31  Beatriz Leyva and Santiago Casal are thanking ...  Support          True   \n",
       "32  Tsukuru Fors supports the resolution opposing ...  Support          True   \n",
       "33  Phoebe Thomas urges the Berkeley City Council ...  Support          True   \n",
       "34  David McGuire supports the resolution opposing...  Support          True   \n",
       "35  Bindu Desai recommends adopting a resolution o...  Support          True   \n",
       "36  Eva Frye expresses strong support for councilm...  Support          True   \n",
       "37  Yuka Saito opposes the release of contaminated...   Oppose         False   \n",
       "38  Laura Feldman opposes TEPCO's plan to dump rad...   Oppose         False   \n",
       "39  Linda Roman urges the council to oppose Japan'...   Oppose         False   \n",
       "40  Liz Taylor supports the Resolution Opposing To...  Support          True   \n",
       "41  Jacqueline Cabasso supports the Resolution Opp...  Support          True   \n",
       "42  Eri Tomita expresses opposition to the propose...   Oppose         False   \n",
       "43  Heiko Hasegawa opposes the release of contamin...   Oppose         False   \n",
       "44  Desiree expresses enthusiastic support for Cou...  Support          True   \n",
       "45  Derethia DuVal supports the adoption of an Aff...  Support          True   \n",
       "46  Linda Currie is requesting support for the app...  Support          True   \n",
       "47  Beth Lamont supports a full flow restoration o...  Support          True   \n",
       "48  Kelly Hammargren supports the alternative desi...  Support          True   \n",
       "49  Tom Kelly supports the daylighting of Strawber...  Support          True   \n",
       "50  Kathleen Giustino supports the full flow resto...  Support          True   \n",
       "51  Erin Diehm is providing 247 petition signature...  Support          True   \n",
       "52  Andra Mitchell is requesting support for a ful...  Support          True   \n",
       "53  Jack Kurzweil expresses disappointment and dis...   Oppose         False   \n",
       "54  Isabelle Gaston opposes the recommendations re...   Oppose         False   \n",
       "\n",
       "    oppose_bool  other_bool  \n",
       "0          True       False  \n",
       "1         False       False  \n",
       "2         False       False  \n",
       "3         False        True  \n",
       "4         False       False  \n",
       "5         False       False  \n",
       "6         False       False  \n",
       "7         False       False  \n",
       "8         False       False  \n",
       "9         False        True  \n",
       "10        False       False  \n",
       "11        False       False  \n",
       "12        False       False  \n",
       "13        False       False  \n",
       "14        False       False  \n",
       "15        False       False  \n",
       "16        False       False  \n",
       "17        False       False  \n",
       "18        False       False  \n",
       "19        False       False  \n",
       "20        False       False  \n",
       "21        False       False  \n",
       "22        False       False  \n",
       "23        False       False  \n",
       "24        False       False  \n",
       "25        False       False  \n",
       "26        False       False  \n",
       "27         True       False  \n",
       "28        False       False  \n",
       "29        False       False  \n",
       "30        False        True  \n",
       "31        False       False  \n",
       "32        False       False  \n",
       "33        False       False  \n",
       "34        False       False  \n",
       "35        False       False  \n",
       "36        False       False  \n",
       "37         True       False  \n",
       "38         True       False  \n",
       "39         True       False  \n",
       "40        False       False  \n",
       "41        False       False  \n",
       "42         True       False  \n",
       "43         True       False  \n",
       "44        False       False  \n",
       "45        False       False  \n",
       "46        False       False  \n",
       "47        False       False  \n",
       "48        False       False  \n",
       "49        False       False  \n",
       "50        False       False  \n",
       "51        False       False  \n",
       "52        False       False  \n",
       "53         True       False  \n",
       "54         True       False  "
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "item_comms_speaker_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0e3a1664",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.10.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}