packet_parsing__agenda_scrape.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 87,
   "id": "21ccfaf7",
   "metadata": {},
   "outputs": [],
   "source": [
    "import re\n",
    "import requests\n",
    "from bs4 import BeautifulSoup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "e81cf054",
   "metadata": {},
   "outputs": [],
   "source": [
    "url = \"https://berkeleyca.gov/city-council-regular-meeting-eagenda-july-11-2023\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "f7a7803a",
   "metadata": {},
   "outputs": [],
   "source": [
    "resp = requests.get(url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "d2f72582",
   "metadata": {},
   "outputs": [],
   "source": [
    "soup = BeautifulSoup(resp.text, \"html\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "6404a7ba",
   "metadata": {},
   "outputs": [],
   "source": [
    "field_items = soup.select(\"div.field-items > div.field-item > div > p\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "id": "ec96db0a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[{'item_num': '1', 'item_name': 'FY 2024 Tax Rate: Fund Fire Protection and Emergency Response and Preparedness (Measure GG)', 'rec': 'Adopt second reading of Ordinance No. 7,877-N.S. setting the FY 2024 tax rate for funding Fire Protection and Emergency Response and Preparedness in the City of Berkeley at the rate of $0.06062 (6.062 cents) per square foot of improvements for dwelling units and setting the rate for all other property at $0.09173 (9.173 cents) per square foot of improvements.First Reading Vote: All Ayes.', 'financial_implications': 'See report', 'contact': 'Henry Oyekanmi, Finance, (510) 981-7300, David Sprague, Fire, (510) 981-3473'}, {'item_num': '2', 'item_name': 'FY 2024 Special Tax Rate: Fund the Provision of Library Services', 'rec': 'Adopt second reading of Ordinance No. 7,878-N.S. setting the FY 2024 tax rate for funding the provision of Library Services in the City of Berkeley at $0.2698 (26.98 cents) per square foot for dwelling units and $0.4080 (40.80 cents) per square foot for industrial, commercial, and institutional buildings.First Reading Vote: All Ayes.', 'financial_implications': 'See report', 'contact': 'Henry Oyekanmi, Finance, (510) 981-7300, Tess Mayer, Library, (510) 981-6100'}, {'item_num': '3', 'item_name': 'FY 2024 Annual Appropriations Ordinance', 'rec': 'Adopt second reading of Ordinance No. 7,879-N.S. adopting the FY 2024 Annual Appropriations Ordinance (AAO) in the amount of $728,631,293 (gross appropriations) and $621,229,929 (net appropriations).First Reading Vote: All Ayes.', 'financial_implications': 'See report', 'contact': 'Sharon Friedrichsen, Budget Manager, (510) 981-7000'}, {'item_num': '4', 'item_name': 'Adopting a temporary exemption from the collection of taxes under BMC Chapter 9.04.136(D): Tax Rate for Non-Medical and Medical Cannabis Businesses', 'rec': 'Adopt second reading of Ordinance No. 7,880-N.S. adopting a temporary exemption (per 9.04.136(D)) on the collection of the taxes for all non-medical and medical cannabis businesses, retroactive to January 2023 and ending July 2025; Waive any late penalties that may have accrued since January 2023; any and all tax payments already made to the City for Q1 2023 will apply as a credit against a future tax or fee payment to the City.First Reding Vote: All Ayes.', 'financial_implications': 'Loss of tax revenue', 'contact': 'Ben Bartlett, Councilmember, District 3, (510) 981-7130'}, {'item_num': '5', 'item_name': 'Encampment Resolution Funding Grant Award', 'rec': 'Adopt a Resolution authorizing the City Manager to receive a $4,931,058 Encampment Resolution Funding Round 2 grant award from the State of California, and to enter into contract and all necessary amendments with the State of California resulting from this funding.', 'financial_implications': 'See report', 'contact': \"Peter Radu, City Manager's Office, (510) 981-7000\"}, {'item_num': '6', 'item_name': 'Urgency Ordinance for Leasing the Real Property at 1619 University Avenue', 'rec': 'Adopt an Urgency Ordinance to enter into a lease for the real property located at 1619 University Avenue, Berkeley for a term of 60 months.', 'financial_implications': 'See report', 'contact': \"Peter Radu, City Manager's Office, (510) 981-7000\"}, {'item_num': '7', 'item_name': 'Contract: Insight Housing (formerly Berkeley Food and Housing Project) to operate interim housing at the Super 8', 'rec': 'Adopt a Resolution authorizing the City Manager to execute a contract and all necessary amendments with Berkeley Food and Housing Project to operate an interim housing program at the Super 8 Motel (1619 University Ave.) in an amount not to exceed $7,295,635 for the period of August 1, 2023 to July 31, 2028', 'financial_implications': 'See report', 'contact': \"Peter Radu, City Manager's Office, (510) 981-7000\"}, {'item_num': '8', 'item_name': 'Formal Bid Solicitations and Request for Proposals Scheduled for Possible Issuance After Council Approval on July 11, 2023', 'rec': 'Approve the request for proposals or invitation for bids (attached to staff report) that will be, or are planned to be, issued upon final approval by the requesting department or division.\\xa0 All contracts over the City Manager’s threshold will be returned to Council for final approval.', 'financial_implications': 'Various Funds - $482,500', 'contact': 'Henry Oyekanmi, Finance, (510) 981-7300'}, {'item_num': '9', 'item_name': 'Contract: Strategic Economics and Street Level Advisors for Affordable Housing Requirements Economic Feasibility Analysis', 'rec': 'Adopt a Resolution authorizing the City Manager or her designee to execute a contract and any amendments with Strategic Economics as a Contractor and Street Level Advisors as a subcontractor, to conduct an Economic Feasibility Analysis of the Affordable Housing Requirements for the Department of Health, Housing, and Community Services (HHCS) from July 15, 2023 to July 15, 2024 in an amount not to exceed $150,000.', 'financial_implications': 'See report', 'contact': 'Lisa Warhuus, Health, Housing, and Community Services, (510) 981-5400'}, {'item_num': '10', 'item_name': 'Contract No. 32300134 Amendment: Bonita House for Specialized Care Unit Provider', 'rec': 'Adopt a Resolution authorizing the City Manager or her designee to amend Contract No. 32300134 with Bonita House to add $68,000 of Mental Health Services Act (MHSA) funding for the Specialized Care Unit for a not-to-exceed total of $4,568,000.', 'financial_implications': 'See report', 'contact': 'Lisa Warhuus, Health, Housing, and Community Services, (510) 981-5400'}, {'item_num': '11', 'item_name': 'Contract No. 321001100 Amendment: JotForm, Inc. for a HIPAA Compliant Platform to Support Clinical Services', 'rec': 'Adopt a Resolution authorizing the City Manager or her designee to execute an amendment to Contract No. 32100110 and any subsequent amendments or extensions with the JotForm, Inc. by adding $53,424, bringing the contract total to an amount not to exceed $109,218 and extending the end date through May 12, 2026.', 'financial_implications': 'See report', 'contact': 'Lisa Warhuus, Health, Housing, and Community Services, (510) 981-5400'}, {'item_num': '12', 'item_name': 'California Department of Housing and Community Development (HCD) Prohousing Designation Program Application', 'rec': 'Adopt a Resolution authorizing the City of Berkeley’s application to and participation in the California Department of Housing and Community Development (HCD) Prohousing Designation Program.', 'financial_implications': 'See report', 'contact': 'Lisa Warhuus, Health, Housing, and Community Services, (510) 981-5400'}, {'item_num': '13', 'item_name': 'Contract No. 32000226 Amendment: MidAmerica Administrative & Retirement Solutions, Third Party Administrator for SRIP I Disability, and Health Reimbursement Accounts for Retiree Health Premium Assistance Plan Reimbursements, and Police Employees Retiree Income Plan', 'rec': 'Adopt a Resolution authorizing the City Manager to execute a contract amendment to Contract No. 32000226 with MidAmerica Administrative & Retirement Solutions for administration of the SRIP I Disability, Retiree Health Premium Assistance Plan (RHPAP) Health Reimbursement Account (HRA), and Police Employees Retiree Income Plans (PERIP) for the period covering January 1, 2021 through December 31, 2025, for a total cost not to exceed $233,736.', 'financial_implications': 'See report', 'contact': 'Aram Kouyoumdjian, Human Resources, (510) 981-6800'}, {'item_num': '14', 'item_name': 'Contract No. 32300158 Amendment: AppleOne Employment Services for Temporary Staffing Services', 'rec': 'Adopt a Resolution authorizing the City Manager to execute an amendment to Contract No. 32300158 with AppleOne Employment Services for temporary staffing services, to cover the period February 1, 2023 to June 30, 2025, for a total cost not to exceed $750,000.', 'financial_implications': 'Various Funds - $750,000', 'contact': 'Aram Kouyoumdjian, Human Resources, (510) 981-6800'}, {'item_num': '15', 'item_name': 'Revisions to the Unrepresented Employee Manual', 'rec': 'Adopt a Resolution authorizing the City Manager to execute changes to the Unrepresented Employee Manual that (1) effectuates merit raises for employees on salary ranges on their anniversary date in their current classification; (2) aligns vacation accrual, longevity pay rates, vacation sell-back policies, and a certification differential for the Fire Chief, the Police Chief, and their deputies with the corresponding provisions of the Memoranda of Understanding with the Berkeley Fire Fighters Association and the Berkeley Police Association; and (3) includes Accounting Office Specialists III among the classifications that qualify for the City Manager Department Differential.', 'financial_implications': 'See report', 'contact': 'Aram Kouyoumdjian, Human Resources, (510) 981-6800'}, {'item_num': '16', 'item_name': 'Supplemental Military Leave Compensation Policy', 'rec': 'Adopt a Resolution extending Resolution No. 63,646-N.S. to offer the City’s supplemental military leave compensation benefit retroactively from June 1, 2019 to June 30, 2025 to provide additional wages to supplement an employee’s military pay and allowances for a period not to exceed two (2) years that must be taken within 36 months of the leave request for employees called up to involuntary active military service. To receive the retroactive payment the employee must have been employed with the City of Berkeley at the time of active duty and remained employed with the City of Berkeley at the time of payment.', 'financial_implications': 'See report', 'contact': 'Aram Kouyoumdjian, Human Resources, (510) 981-6800'}, {'item_num': '17', 'item_name': 'Accepting grant funds from the Alameda County Transportation Commission for the Berkeley Pier Water Transportation / Ferry Project', 'rec': 'Adopt a Resolution accepting the Alameda County Transportation Commission grant allocation for the Berkeley Pier Water Transportation/ Ferry Project in the amount of $5,138,685, confirming the City’s commitment to the Alameda County Transportation Commission grant requirements, and authorizing the City Manager to execute the associated grant agreement and amendments.', 'financial_implications': 'Grant Revenue - $5,138,685', 'contact': 'Scott Ferris, Parks, Recreation and Waterfront, (510) 981-6700'}, {'item_num': '18', 'item_name': 'Contract No. 32000188 Amendment: GSI Environmental Inc. for On-Call Environmental Consulting Services', 'rec': 'Adopt a Resolution authorizing the City Manager to execute an amendment to Contract No. 32000188 with GSI Environmental Inc. for on-call environmental consulting services to increase the contract amount by $75,000 for a new not to exceed amount of $225,000 and extend the contract term from December 20, 2023 to June 30, 2025.', 'financial_implications': 'See report', 'contact': 'Scott Ferris, Parks, Recreation and Waterfront, (510) 981-6700'}, {'item_num': '19', 'item_name': 'Contract No. 32300022 Amendment: Public Safety Family Counseling Group Inc. for Additional Critical Incident Stress Management (CISM), Education and Counseling Services', 'rec': 'Adopt a Resolution authorizing the City Manager to execute an amendment to Contract No. 32300022 with Public Safety Family Counseling Group Inc. to provide additional CISM Peer Support Team support, education and counselling services, for a total amount not to exceed $150,000 for a total contract amount not to exceed $200,000, and extending the term through June 30, 2026.', 'financial_implications': 'See report', 'contact': 'Jennifer Louis, Police, (510) 981-5900'}, {'item_num': '20', 'item_name': 'Conduct a Study on the City’s History of Discriminatory Actions in Housing Policies/Programs', 'rec': 'Conduct a study that is comprehensive of the following actions: -Document the city of Berkeley’s past discriminatory actions in housing policies and programs that adversely impacted the Black community and its ability to remain and grow in the city, build inter-generational wealth, and fully realize the benefits of homeownership; -Inform future housing policy and program development and implementation to address these historic discriminatory practices; and -Provide data and information about historic discriminatory housing policies and programs in support of the city’s on-going reparations work. -Select community organization(s) as partners in the study to ensure a comprehensive community engagement process that documents lived experiences and local history so that lessons learned from those experiences can inform future housing policies and programs.', 'financial_implications': 'See report', 'contact': 'Mike Uberti, Commission Secretary, (510) 981-7400'}, {'item_num': '21', 'item_name': 'Berkeley Housing Authority Board of Commissioners Re-Appointments', 'rec': 'Adopt a Resolution re-appointing Alexandria Thomas-Rodriguez, Max Levine and Ali Kashani to the Berkeley Housing Authority Board of Commissioners.', 'financial_implications': 'None', 'contact': 'Jesse Arreguin, Mayor, (510) 981-7100'}, {'item_num': '22', 'item_name': 'Support Rooftop Solar and Battery Storage for Multifamily Housing and Schools', 'rec': 'Adopt a Resolution in support of viable Virtual Net Energy Metering (VNEM) and Net Energy Metering Aggregation (NEM-A) tariffs. Submit a copy of the Resolution to Governor Gavin Newsom, State Senator Nancy Skinner, Assemblymember Buffy Wicks, and members of the California Public Utilities Commission Board (CPUC).', 'financial_implications': 'Staff time', 'contact': 'Jesse Arreguin, Mayor, (510) 981-7100'}, {'item_num': '23', 'item_name': 'Relinquishment of Council Office Budget Funds for Chavez/Huerta Tribute Site', 'rec': 'Adopt a Resolution approving the expenditure of up to $5,000 from Mayor Arreguín, and any other Councilmembers, to the Kala Art Institute, the fiscal sponsor for the Chavez/Huerta Tribute Site, with funds relinquished from the City’s General Fund for the purpose of hiring of grounds keepers and providing the resources needed for the maintenance of the Chavez/Huerta Tribute Site, from the discretionary Council Office Budgets of Mayor Arreguín and any other Councilmembers who would like to contribute.', 'financial_implications': '$5,000 – Mayor’s Discretionary Fund', 'contact': 'Jesse Arreguin, Mayor, (510) 981-7100'}, {'item_num': '24', 'item_name': 'Excused Absence for Vice Mayor Ben Bartlett', 'rec': 'Excuse Vice Mayor Ben Bartlett from the June 6, 2023 Council meeting as a result of an illness of a close family member who needed immediate care.', 'financial_implications': 'None', 'contact': 'Jesse Arreguin, Mayor, (510) 981-7100'}, {'item_num': '25', 'item_name': 'Berkeley Humane: Bark (& Meow) Around the Block: Relinquishment of Council Office Budget Funds from General Funds and Grant of Such Funds', 'rec': 'Adopt a Resolution approving the expenditure of council office budget funds, including $500 from Councilmember Taplin, to support the Bark (& Meow) Around the Block adoption event hosted by Berkeley Humane, with funds relinquished to the City’s general fund.', 'financial_implications': '$500 – Councilmember’s Discretionary Fund', 'contact': 'Terry Taplin, Councilmember, District 2, (510) 981-7120'}, {'item_num': '26', 'item_name': 'Berkeley High School All Class Reunion: Relinquishment of Council Office Budget Funds from General Funds and Grant of Such Funds', 'rec': 'Adopt a Resolution approving the expenditure of council office budget funds, including $500 from Councilmember Taplin, to support the Berkeley High School All Class Reunion Committee (BHS ACRC) by way of its fiscal sponsor, the Berkeley Public Schools Fund, with funds relinquished to the City’s general fund.', 'financial_implications': '$500 – Councilmember’s Discretionary Fund', 'contact': 'Terry Taplin, Councilmember, District 2, (510) 981-7120'}, {'item_num': '27', 'item_name': 'Resolution for unionized employees of REI', 'rec': 'Adopt a Resolution of Support for the unionized employees of Recreational Equipment, Inc. (REI) in Berkeley, California that instructs REI to live up to its values, by ceasing to withhold the 2022 “Summit Pay”, and bargain in good faith.', 'financial_implications': 'None', 'contact': 'Ben Bartlett, Councilmember, District 3, (510) 981-7130'}, {'item_num': '28', 'item_name': 'Relinquishment of Council Office Budget Funds and Co-Sponsorship of the César Chávez Dolores Huerta Tribute Site Curriculum Project', 'rec': 'Adopt a resolution approving an expenditure of D13 funds and cosponsorship of the César Chávez/Dolores Huerta Tribute Site Curriculum Project, with $250 relinquished to the City’s general fund for this purpose each from Mayor Arreguín’s and Councilmember Harrison’s discretionary Council Office Budget Funds, and from any other Councilmembers who would like to contribute.', 'financial_implications': '$250 – Councilmembers’ Discretionary Fund', 'contact': 'Kate Harrison, Councilmember, District 4, (510) 981-7140'}, {'item_num': '29', 'item_name': 'Resolution Opposing Tokyo Electric Power Company and the Government of Japan’s Planned Discharge of Wastewater from Fukushima Daiichi Nuclear Power Plant into the Pacific Ocean', 'rec': 'Adopt a Resolution opposing Tokyo Electric Power Company (TEPCO) and the government of Japan’s plan to discharge wastewater from Fukushima Daiichi Nuclear Power Plant into the Pacific Ocean and send copies of this resolution to Secretary Blinken, Senator Dianne Feinstein, Senator Alex Padilla, and Representative Barbara Lee.', 'financial_implications': 'Staff time', 'contact': 'Kate Harrison, Councilmember, District 4, (510) 981-7140'}, {'item_num': '31', 'item_name': 'Staff Shortages: City Services Constrained by Staff Retention Challenges and Delayed Hiring', 'rec': 'We recommend City Council request that the City Manager report back by January 2024, and every six months thereafter, regarding the status of our audit recommendations until reported fully implemented. Some of our recommendations include: establish retention goals and conduct an analysis of staff needed for city operations and services; consider staff capacity around new legislation; take steps to improve employee satisfaction; identify opportunities for efficiency in the hiring process, and modernize its recruiting process; expand the telework policy to align with best practices; and regularly collect data on employee satisfaction and on diversity, equity, inclusion, and accessibility.', 'financial_implications': 'See report', 'contact': 'Jenny Wong, Auditor, (510) 981-6750'}, {'item_num': '32', 'item_name': 'Referral Response: Affordable Housing Preference Policy for Rental Housing Created Through the Below Market Rate and Housing Trust Fund Programs', 'rec': 'Adopt a Resolution to create an Affordable Housing Preference Policy applicable to new residential housing units created via the Below Market-Rate (BMR) and the Housing Trust Fund (HTF) programs consistent with Fair Housing law and government funder approvals, and direct the City Manager to adopt guidelines to administer the Housing Preference Policy.', 'financial_implications': 'See report.', 'contact': 'Lisa Warhuus, Health, Housing, and Community Services, (510) 981-5400'}, {'item_num': '33', 'item_name': 'Adoption - Civic Center Phase II - Design Concept', 'rec': 'Adopt a Resolution approving Berkeley’s Civic Center Design Concept Plan, and declaring Council’s intention to support the preferred design concept and necessary future studies and projects articulated in the plan.', 'financial_implications': 'See report.', 'contact': 'Liam Garland, Public Works, (510) 981-6300'}, {'item_num': '35', 'item_name': 'De-Prioritizing the enforcement of laws imposing criminal penalties for Entheogenic/Psychedelic plants and fungi for personal use', 'rec': 'Approve the Resolution presented and passed with a qualified positive recommendation at the June 12, 2023 meeting of the Health, Life Enrichment, Equity & Community Committee (Attachment 1), in lieu of the Resolutions provided in the originally referred item and by the Community Health Commission.Policy Committee Recommendation: to send the item to Council with a qualified positive recommendation to approve the Resolution in the form and as amended by the committee. There is no “mark-up” of the CHC resolution because what the Committee decided to pass is a full rewrite.', 'financial_implications': 'None', 'contact': 'Sophie Hahn, Councilmember, District 5, (510) 981-7150, Ben Bartlett, Councilmember, District 3, (510) 981-7130, Mark Humbert, Councilmember, District 8, (510) 981-7180'}]\n"
     ]
    }
   ],
   "source": [
    "agenda_items = []\n",
    "for item in field_items:\n",
    "    if item.select(\"strong > a\"):\n",
    "        try:\n",
    "            item_dict = {\n",
    "                \"item_num\": re.search(r\"([0-9]*).\", item.select_one(\"strong\").text).group(1),\n",
    "                \"item_name\": item.select_one(\"strong > a\").text\n",
    "            }\n",
    "            content = re.search(r\"Recommendation:\\s*(.*)Financial Implications:\\s*(.*)\\nContact:\\s*(.*)\", item.text)\n",
    "            item_dict[\"rec\"] = content.group(1)\n",
    "            item_dict[\"financial_implications\"] = content.group(2)\n",
    "            item_dict[\"contact\"] = content.group(3)\n",
    "            agenda_items.append(item_dict)\n",
    "        except:\n",
    "#             print(item)\n",
    "            pass\n",
    "print(agenda_items)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "id": "e4cbb568",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "id": "033f51a5",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(agenda_items)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "id": "b0267ae0",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"./agenda_items_071123b.csv\", index=\"item_num\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "id": "8ab1d1f5",
   "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",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>FY 2024 Special Tax Rate: Fund the Provision o...</td>\n",
       "      <td>Adopt second reading of Ordinance No. 7,878-N....</td>\n",
       "      <td>See report</td>\n",
       "      <td>Henry Oyekanmi, Finance, (510) 981-7300, Tess ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>FY 2024 Annual Appropriations Ordinance</td>\n",
       "      <td>Adopt second reading of Ordinance No. 7,879-N....</td>\n",
       "      <td>See report</td>\n",
       "      <td>Sharon Friedrichsen, Budget Manager, (510) 981...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Adopting a temporary exemption from the collec...</td>\n",
       "      <td>Adopt second reading of Ordinance No. 7,880-N....</td>\n",
       "      <td>Loss of tax revenue</td>\n",
       "      <td>Ben Bartlett, Councilmember, District 3, (510)...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Encampment Resolution Funding Grant Award</td>\n",
       "      <td>Adopt a Resolution authorizing the City Manage...</td>\n",
       "      <td>See report</td>\n",
       "      <td>Peter Radu, City Manager's Office, (510) 981-7000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Urgency Ordinance for Leasing the Real Propert...</td>\n",
       "      <td>Adopt an Urgency Ordinance to enter into a lea...</td>\n",
       "      <td>See report</td>\n",
       "      <td>Peter Radu, City Manager's Office, (510) 981-7000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\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>See report</td>\n",
       "      <td>Peter Radu, City Manager's Office, (510) 981-7000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>Formal Bid Solicitations and Request for Propo...</td>\n",
       "      <td>Approve the request for proposals or invitatio...</td>\n",
       "      <td>Various Funds - $482,500</td>\n",
       "      <td>Henry Oyekanmi, Finance, (510) 981-7300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>Contract: Strategic Economics and Street Level...</td>\n",
       "      <td>Adopt a Resolution authorizing the City Manage...</td>\n",
       "      <td>See report</td>\n",
       "      <td>Lisa Warhuus, Health, Housing, and Community S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>Contract No. 32300134 Amendment: Bonita House ...</td>\n",
       "      <td>Adopt a Resolution authorizing the City Manage...</td>\n",
       "      <td>See report</td>\n",
       "      <td>Lisa Warhuus, Health, Housing, and Community S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>Contract No. 321001100 Amendment: JotForm, Inc...</td>\n",
       "      <td>Adopt a Resolution authorizing the City Manage...</td>\n",
       "      <td>See report</td>\n",
       "      <td>Lisa Warhuus, Health, Housing, and Community S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>California Department of Housing and Community...</td>\n",
       "      <td>Adopt a Resolution authorizing the City of Ber...</td>\n",
       "      <td>See report</td>\n",
       "      <td>Lisa Warhuus, Health, Housing, and Community S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>Contract No. 32000226 Amendment: MidAmerica Ad...</td>\n",
       "      <td>Adopt a Resolution authorizing the City Manage...</td>\n",
       "      <td>See report</td>\n",
       "      <td>Aram Kouyoumdjian, Human Resources, (510) 981-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>Contract No. 32300158 Amendment: AppleOne Empl...</td>\n",
       "      <td>Adopt a Resolution authorizing the City Manage...</td>\n",
       "      <td>Various Funds - $750,000</td>\n",
       "      <td>Aram Kouyoumdjian, Human Resources, (510) 981-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>Revisions to the Unrepresented Employee Manual</td>\n",
       "      <td>Adopt a Resolution authorizing the City Manage...</td>\n",
       "      <td>See report</td>\n",
       "      <td>Aram Kouyoumdjian, Human Resources, (510) 981-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>Supplemental Military Leave Compensation Policy</td>\n",
       "      <td>Adopt a Resolution extending Resolution No. 63...</td>\n",
       "      <td>See report</td>\n",
       "      <td>Aram Kouyoumdjian, Human Resources, (510) 981-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>Accepting grant funds from the Alameda County ...</td>\n",
       "      <td>Adopt a Resolution accepting the Alameda Count...</td>\n",
       "      <td>Grant Revenue - $5,138,685</td>\n",
       "      <td>Scott Ferris, Parks, Recreation and Waterfront...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>Contract No. 32000188 Amendment: GSI Environme...</td>\n",
       "      <td>Adopt a Resolution authorizing the City Manage...</td>\n",
       "      <td>See report</td>\n",
       "      <td>Scott Ferris, Parks, Recreation and Waterfront...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>Contract No. 32300022 Amendment: Public Safety...</td>\n",
       "      <td>Adopt a Resolution authorizing the City Manage...</td>\n",
       "      <td>See report</td>\n",
       "      <td>Jennifer Louis, Police, (510) 981-5900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>Conduct a Study on the City’s History of Discr...</td>\n",
       "      <td>Conduct a study that is comprehensive of the f...</td>\n",
       "      <td>See report</td>\n",
       "      <td>Mike Uberti, Commission Secretary, (510) 981-7400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>Berkeley Housing Authority Board of Commission...</td>\n",
       "      <td>Adopt a Resolution re-appointing Alexandria Th...</td>\n",
       "      <td>None</td>\n",
       "      <td>Jesse Arreguin, Mayor, (510) 981-7100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>Support Rooftop Solar and Battery Storage for ...</td>\n",
       "      <td>Adopt a Resolution in support of viable Virtua...</td>\n",
       "      <td>Staff time</td>\n",
       "      <td>Jesse Arreguin, Mayor, (510) 981-7100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>Relinquishment of Council Office Budget Funds ...</td>\n",
       "      <td>Adopt a Resolution approving the expenditure o...</td>\n",
       "      <td>$5,000 – Mayor’s Discretionary Fund</td>\n",
       "      <td>Jesse Arreguin, Mayor, (510) 981-7100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>Excused Absence for Vice Mayor Ben Bartlett</td>\n",
       "      <td>Excuse Vice Mayor Ben Bartlett from the June 6...</td>\n",
       "      <td>None</td>\n",
       "      <td>Jesse Arreguin, Mayor, (510) 981-7100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>Berkeley Humane: Bark (&amp; Meow) Around the Bloc...</td>\n",
       "      <td>Adopt a Resolution approving the expenditure o...</td>\n",
       "      <td>$500 – Councilmember’s Discretionary Fund</td>\n",
       "      <td>Terry Taplin, Councilmember, District 2, (510)...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>Berkeley High School All Class Reunion: Relinq...</td>\n",
       "      <td>Adopt a Resolution approving the expenditure o...</td>\n",
       "      <td>$500 – Councilmember’s Discretionary Fund</td>\n",
       "      <td>Terry Taplin, Councilmember, District 2, (510)...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>Resolution for unionized employees of REI</td>\n",
       "      <td>Adopt a Resolution of Support for the unionize...</td>\n",
       "      <td>None</td>\n",
       "      <td>Ben Bartlett, Councilmember, District 3, (510)...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\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>$250 – Councilmembers’ Discretionary Fund</td>\n",
       "      <td>Kate Harrison, Councilmember, District 4, (510...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\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>Staff time</td>\n",
       "      <td>Kate Harrison, Councilmember, District 4, (510...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>31</td>\n",
       "      <td>Staff Shortages: City Services Constrained by ...</td>\n",
       "      <td>We recommend City Council request that the Cit...</td>\n",
       "      <td>See report</td>\n",
       "      <td>Jenny Wong, Auditor, (510) 981-6750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\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>See report.</td>\n",
       "      <td>Lisa Warhuus, Health, Housing, and Community S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\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>See report.</td>\n",
       "      <td>Liam Garland, Public Works, (510) 981-6300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\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>None</td>\n",
       "      <td>Sophie Hahn, Councilmember, District 5, (510) ...</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",
       "1         2  FY 2024 Special Tax Rate: Fund the Provision o...   \n",
       "2         3            FY 2024 Annual Appropriations Ordinance   \n",
       "3         4  Adopting a temporary exemption from the collec...   \n",
       "4         5          Encampment Resolution Funding Grant Award   \n",
       "5         6  Urgency Ordinance for Leasing the Real Propert...   \n",
       "6         7  Contract: Insight Housing (formerly Berkeley F...   \n",
       "7         8  Formal Bid Solicitations and Request for Propo...   \n",
       "8         9  Contract: Strategic Economics and Street Level...   \n",
       "9        10  Contract No. 32300134 Amendment: Bonita House ...   \n",
       "10       11  Contract No. 321001100 Amendment: JotForm, Inc...   \n",
       "11       12  California Department of Housing and Community...   \n",
       "12       13  Contract No. 32000226 Amendment: MidAmerica Ad...   \n",
       "13       14  Contract No. 32300158 Amendment: AppleOne Empl...   \n",
       "14       15     Revisions to the Unrepresented Employee Manual   \n",
       "15       16    Supplemental Military Leave Compensation Policy   \n",
       "16       17  Accepting grant funds from the Alameda County ...   \n",
       "17       18  Contract No. 32000188 Amendment: GSI Environme...   \n",
       "18       19  Contract No. 32300022 Amendment: Public Safety...   \n",
       "19       20  Conduct a Study on the City’s History of Discr...   \n",
       "20       21  Berkeley Housing Authority Board of Commission...   \n",
       "21       22  Support Rooftop Solar and Battery Storage for ...   \n",
       "22       23  Relinquishment of Council Office Budget Funds ...   \n",
       "23       24        Excused Absence for Vice Mayor Ben Bartlett   \n",
       "24       25  Berkeley Humane: Bark (& Meow) Around the Bloc...   \n",
       "25       26  Berkeley High School All Class Reunion: Relinq...   \n",
       "26       27          Resolution for unionized employees of REI   \n",
       "27       28  Relinquishment of Council Office Budget Funds ...   \n",
       "28       29  Resolution Opposing Tokyo Electric Power Compa...   \n",
       "29       31  Staff Shortages: City Services Constrained by ...   \n",
       "30       32  Referral Response: Affordable Housing Preferen...   \n",
       "31       33  Adoption - Civic Center Phase II - Design Concept   \n",
       "32       35  De-Prioritizing the enforcement of laws imposi...   \n",
       "\n",
       "                                                  rec  \\\n",
       "0   Adopt second reading of Ordinance No. 7,877-N....   \n",
       "1   Adopt second reading of Ordinance No. 7,878-N....   \n",
       "2   Adopt second reading of Ordinance No. 7,879-N....   \n",
       "3   Adopt second reading of Ordinance No. 7,880-N....   \n",
       "4   Adopt a Resolution authorizing the City Manage...   \n",
       "5   Adopt an Urgency Ordinance to enter into a lea...   \n",
       "6   Adopt a Resolution authorizing the City Manage...   \n",
       "7   Approve the request for proposals or invitatio...   \n",
       "8   Adopt a Resolution authorizing the City Manage...   \n",
       "9   Adopt a Resolution authorizing the City Manage...   \n",
       "10  Adopt a Resolution authorizing the City Manage...   \n",
       "11  Adopt a Resolution authorizing the City of Ber...   \n",
       "12  Adopt a Resolution authorizing the City Manage...   \n",
       "13  Adopt a Resolution authorizing the City Manage...   \n",
       "14  Adopt a Resolution authorizing the City Manage...   \n",
       "15  Adopt a Resolution extending Resolution No. 63...   \n",
       "16  Adopt a Resolution accepting the Alameda Count...   \n",
       "17  Adopt a Resolution authorizing the City Manage...   \n",
       "18  Adopt a Resolution authorizing the City Manage...   \n",
       "19  Conduct a study that is comprehensive of the f...   \n",
       "20  Adopt a Resolution re-appointing Alexandria Th...   \n",
       "21  Adopt a Resolution in support of viable Virtua...   \n",
       "22  Adopt a Resolution approving the expenditure o...   \n",
       "23  Excuse Vice Mayor Ben Bartlett from the June 6...   \n",
       "24  Adopt a Resolution approving the expenditure o...   \n",
       "25  Adopt a Resolution approving the expenditure o...   \n",
       "26  Adopt a Resolution of Support for the unionize...   \n",
       "27  Adopt a resolution approving an expenditure of...   \n",
       "28  Adopt a Resolution opposing Tokyo Electric Pow...   \n",
       "29  We recommend City Council request that the Cit...   \n",
       "30  Adopt a Resolution to create an Affordable Hou...   \n",
       "31  Adopt a Resolution approving Berkeley’s Civic ...   \n",
       "32  Approve the Resolution presented and passed wi...   \n",
       "\n",
       "                       financial_implications  \\\n",
       "0                                  See report   \n",
       "1                                  See report   \n",
       "2                                  See report   \n",
       "3                         Loss of tax revenue   \n",
       "4                                  See report   \n",
       "5                                  See report   \n",
       "6                                  See report   \n",
       "7                    Various Funds - $482,500   \n",
       "8                                  See report   \n",
       "9                                  See report   \n",
       "10                                 See report   \n",
       "11                                 See report   \n",
       "12                                 See report   \n",
       "13                   Various Funds - $750,000   \n",
       "14                                 See report   \n",
       "15                                 See report   \n",
       "16                 Grant Revenue - $5,138,685   \n",
       "17                                 See report   \n",
       "18                                 See report   \n",
       "19                                 See report   \n",
       "20                                       None   \n",
       "21                                 Staff time   \n",
       "22        $5,000 – Mayor’s Discretionary Fund   \n",
       "23                                       None   \n",
       "24  $500 – Councilmember’s Discretionary Fund   \n",
       "25  $500 – Councilmember’s Discretionary Fund   \n",
       "26                                       None   \n",
       "27  $250 – Councilmembers’ Discretionary Fund   \n",
       "28                                 Staff time   \n",
       "29                                 See report   \n",
       "30                                See report.   \n",
       "31                                See report.   \n",
       "32                                       None   \n",
       "\n",
       "                                              contact  \n",
       "0   Henry Oyekanmi, Finance, (510) 981-7300, David...  \n",
       "1   Henry Oyekanmi, Finance, (510) 981-7300, Tess ...  \n",
       "2   Sharon Friedrichsen, Budget Manager, (510) 981...  \n",
       "3   Ben Bartlett, Councilmember, District 3, (510)...  \n",
       "4   Peter Radu, City Manager's Office, (510) 981-7000  \n",
       "5   Peter Radu, City Manager's Office, (510) 981-7000  \n",
       "6   Peter Radu, City Manager's Office, (510) 981-7000  \n",
       "7             Henry Oyekanmi, Finance, (510) 981-7300  \n",
       "8   Lisa Warhuus, Health, Housing, and Community S...  \n",
       "9   Lisa Warhuus, Health, Housing, and Community S...  \n",
       "10  Lisa Warhuus, Health, Housing, and Community S...  \n",
       "11  Lisa Warhuus, Health, Housing, and Community S...  \n",
       "12  Aram Kouyoumdjian, Human Resources, (510) 981-...  \n",
       "13  Aram Kouyoumdjian, Human Resources, (510) 981-...  \n",
       "14  Aram Kouyoumdjian, Human Resources, (510) 981-...  \n",
       "15  Aram Kouyoumdjian, Human Resources, (510) 981-...  \n",
       "16  Scott Ferris, Parks, Recreation and Waterfront...  \n",
       "17  Scott Ferris, Parks, Recreation and Waterfront...  \n",
       "18             Jennifer Louis, Police, (510) 981-5900  \n",
       "19  Mike Uberti, Commission Secretary, (510) 981-7400  \n",
       "20              Jesse Arreguin, Mayor, (510) 981-7100  \n",
       "21              Jesse Arreguin, Mayor, (510) 981-7100  \n",
       "22              Jesse Arreguin, Mayor, (510) 981-7100  \n",
       "23              Jesse Arreguin, Mayor, (510) 981-7100  \n",
       "24  Terry Taplin, Councilmember, District 2, (510)...  \n",
       "25  Terry Taplin, Councilmember, District 2, (510)...  \n",
       "26  Ben Bartlett, Councilmember, District 3, (510)...  \n",
       "27  Kate Harrison, Councilmember, District 4, (510...  \n",
       "28  Kate Harrison, Councilmember, District 4, (510...  \n",
       "29                Jenny Wong, Auditor, (510) 981-6750  \n",
       "30  Lisa Warhuus, Health, Housing, and Community S...  \n",
       "31         Liam Garland, Public Works, (510) 981-6300  \n",
       "32  Sophie Hahn, Councilmember, District 5, (510) ...  "
      ]
     },
     "execution_count": 153,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8efa1262",
   "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
}