Washington-Post-Collection.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "da277a50",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "61c471fb",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('/Users/nms-workshop/Downloads/Washington_Post_Opioid_Collection.csv', sep='|')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "d7ac35fe",
   "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>id</th>\n",
       "      <th>tid</th>\n",
       "      <th>bates</th>\n",
       "      <th>type</th>\n",
       "      <th>description</th>\n",
       "      <th>title</th>\n",
       "      <th>author</th>\n",
       "      <th>mentioned</th>\n",
       "      <th>attending</th>\n",
       "      <th>copied</th>\n",
       "      <th>...</th>\n",
       "      <th>datereceived</th>\n",
       "      <th>datesent</th>\n",
       "      <th>filename</th>\n",
       "      <th>filepath</th>\n",
       "      <th>messageid</th>\n",
       "      <th>subject</th>\n",
       "      <th>timereceived</th>\n",
       "      <th>timesent</th>\n",
       "      <th>redaction</th>\n",
       "      <th>ocr_text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>mgyc0230</td>\n",
       "      <td>gck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email, Presentation</td>\n",
       "      <td></td>\n",
       "      <td>Mallinckrodt Controlled Substance Suspicious O...</td>\n",
       "      <td>Harper, Karen, Mallinckrodt/Covidien Pharmaceu...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>kgyc0230</td>\n",
       "      <td>eck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document</td>\n",
       "      <td></td>\n",
       "      <td>Videotaped deposition of Jennifer R Norris in ...</td>\n",
       "      <td>US District Court for Northern District of Ohio</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP Doc #: 1957-11 Filed: ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ygyc0230</td>\n",
       "      <td>ick70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document</td>\n",
       "      <td></td>\n",
       "      <td>Expert Report of Ronald W Buzzeo, R.Ph. in Nat...</td>\n",
       "      <td>Buzzeo, Ronald</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-35  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>lgyc0230</td>\n",
       "      <td>fck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document</td>\n",
       "      <td></td>\n",
       "      <td>Videotaped deposition of Nathan J Hartle in Na...</td>\n",
       "      <td>US District Court for Northern District of Ohio</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-12  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>pgyc0230</td>\n",
       "      <td>jck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>Suspicious Order Monitoring Program No. C/S Co...</td>\n",
       "      <td>Davis, Howard</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-41  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>rgyc0230</td>\n",
       "      <td>lck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>Suspicious Order Monitoring Training Notes fro...</td>\n",
       "      <td>Harper, Karen, Mallinckrodt/Covidien Pharmaceu...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-43  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>qgyc0230</td>\n",
       "      <td>kck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>Re: Suspicious Order Monitoring Program; Exhib...</td>\n",
       "      <td>Harper, Karen, Mallinckrodt/Covidien Pharmaceu...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-42  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>zgyc0230</td>\n",
       "      <td>ock70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: SOM; Exhibit 48</td>\n",
       "      <td>Harper, Karen, Mallinckrodt/Covidien Pharmaceu...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-48  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>tgyc0230</td>\n",
       "      <td>nck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document, Image</td>\n",
       "      <td></td>\n",
       "      <td>Retail Generic Incentive Plan Earnings by Sale...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-45  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>fhyc0230</td>\n",
       "      <td>pck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: CVS Caremark Transitioning Generic Pharma;...</td>\n",
       "      <td>Borelli, Victor, Covidien</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-50 Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>ngyc0230</td>\n",
       "      <td>hck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document</td>\n",
       "      <td></td>\n",
       "      <td>Videotaped deposition of Karen Harper in Natio...</td>\n",
       "      <td>US District Court for Northern District of Ohio</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-34 Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>ghyc0230</td>\n",
       "      <td>qck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>Fw: Old Bridge acc# 3448; Exhibit 52</td>\n",
       "      <td>Adams, John G</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-52  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>hhyc0230</td>\n",
       "      <td>rck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: Oxy 15 mg &amp; 30 mg at Sunrise; Exhibit 53</td>\n",
       "      <td>Stewart, Cathy, Covidien</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-53  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>sgyc0230</td>\n",
       "      <td>mck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document</td>\n",
       "      <td></td>\n",
       "      <td>Videotaped deposition of William Ratliff in Na...</td>\n",
       "      <td>US District Court for Northern District of Ohio</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-44 Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>xhyc0230</td>\n",
       "      <td>sck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: Peculiar order report; Exhibit 54</td>\n",
       "      <td>Borelli, Victor, Covidien</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-54 Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>jhyc0230</td>\n",
       "      <td>tck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: HD Smith; Exhibit 55</td>\n",
       "      <td>Myers, Penny, Covidien Mallinckrodt</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-55  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>khyc0230</td>\n",
       "      <td>uck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: Oxy 30; Exhibit 58</td>\n",
       "      <td>Borelli, Victor, Covidien</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-58  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>yhyc0230</td>\n",
       "      <td>yck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>Oxy Sales by retailer; Exhibit 63</td>\n",
       "      <td>Collier, Ginger, Covidien</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-63  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>mhyc0230</td>\n",
       "      <td>wck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: Things; Exhibit 60</td>\n",
       "      <td>Borelli, Victor, Covidien</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-60 Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>lhyc0230</td>\n",
       "      <td>vck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>FW: Sunrise Wholesale; Exhibit 59</td>\n",
       "      <td>Stewart, Cathy, Covidien</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-59  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>phyc0230</td>\n",
       "      <td>zck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>FW: pharmacies noted in Coviedien letter; Exhi...</td>\n",
       "      <td>Corona, Wayne, Masters Pharmaceuticals</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-65  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>nhyc0230</td>\n",
       "      <td>xck70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document</td>\n",
       "      <td></td>\n",
       "      <td>Videotaped deposition of Victor Borelli in Nat...</td>\n",
       "      <td>US District Court for Northern District of Ohio</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-61  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>shyc0230</td>\n",
       "      <td>cdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: Item Exceeds Average; Exhibit 78</td>\n",
       "      <td>Seid, Stephen</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-78  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>thyc0230</td>\n",
       "      <td>ddk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: Item Exceeds Average; Exhibit 79</td>\n",
       "      <td>Seid, Stephen</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-79  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>rhyc0230</td>\n",
       "      <td>bdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: Methadone; Exhibit 70</td>\n",
       "      <td>Burd, Jeff, Mallinckrodt</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-70 Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>qhyc0230</td>\n",
       "      <td>adk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>FW: Notes to File, Howard Davis; Exhibit 69</td>\n",
       "      <td>Harper, Karen, Mallinckrodt/Covidien Pharmaceu...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-69  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>zhyc0230</td>\n",
       "      <td>edk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: Item Exceeds Average; Exhibit 80</td>\n",
       "      <td>Seid, Stephen</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-80 Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>gxyc0230</td>\n",
       "      <td>gdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: Item on order exceeds average exception; E...</td>\n",
       "      <td>Seid, Stephen</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-82  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>hxyc0230</td>\n",
       "      <td>hdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: Item on order exceeds average exception; E...</td>\n",
       "      <td>Seid, Stephen</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-83  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>fxyc0230</td>\n",
       "      <td>fdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: Item on order exceeds average exception; E...</td>\n",
       "      <td>Seid, Stephen</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP Doc #: 1957-81 Filed: ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>xxyc0230</td>\n",
       "      <td>idk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>FW: Item on order exceeds average exception; E...</td>\n",
       "      <td>Seid, Stephen</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1957-84 Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>jxyc0230</td>\n",
       "      <td>jdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: 2 suspicious/excessive for 08DEC2016; Exhi...</td>\n",
       "      <td>Corum, Belinda, JOM Pharmaceutical Services, Inc</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP Doc #: 1960-100 Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>kxyc0230</td>\n",
       "      <td>kdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: McKesson Agrees to Pay Record $150 Million...</td>\n",
       "      <td>Dempsey, Michele, Janssen Pharmaceuticals</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP Doc #: 1960-102 Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>mxyc0230</td>\n",
       "      <td>mdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document, Email</td>\n",
       "      <td></td>\n",
       "      <td>Initial Findings and Recommendations on Cardin...</td>\n",
       "      <td>Buzzeo, Ronald, Cegedim Dendrite</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1964-7  Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>lxyc0230</td>\n",
       "      <td>ldk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>FW: Possible Suspect Pharmacy; Exhibit 217</td>\n",
       "      <td>Mone, Michael, Cardinal Health</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1964-5  Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>nxyc0230</td>\n",
       "      <td>ndk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document</td>\n",
       "      <td></td>\n",
       "      <td>Investigation Report of the Special Demand Com...</td>\n",
       "      <td>Special Demand Committee</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1964-8  Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>yxyc0230</td>\n",
       "      <td>odk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>RE: The situation at CAH remains \"chaotic\" and...</td>\n",
       "      <td>Sopher, Scott, Deloitte Consulting</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1964-12  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>pxyc0230</td>\n",
       "      <td>pdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document</td>\n",
       "      <td></td>\n",
       "      <td>Oral testimony of Todd Cameron; Exhibit 229</td>\n",
       "      <td>The State of Montana Office of the Attorney Ge...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1964-17  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>qxyc0230</td>\n",
       "      <td>qdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>Our Friends at DEA; Exhibit 232</td>\n",
       "      <td>Crowley, Jack, Purdue Pharma</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP Doc #: 2350-25 Filed: ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>txyc0230</td>\n",
       "      <td>tdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document</td>\n",
       "      <td></td>\n",
       "      <td>Summary of the DEA-HDMA Meeting 4/15/2008 - Th...</td>\n",
       "      <td>HDMA, Healthcare Distribution Management Assoc...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1965-78  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>sxyc0230</td>\n",
       "      <td>sdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document</td>\n",
       "      <td></td>\n",
       "      <td>Appendix B: Order to Show Cause and Immediate ...</td>\n",
       "      <td>Leonhart, Michele, Drug Enforcement Administra...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1965-17  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>zxyc0230</td>\n",
       "      <td>udk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document</td>\n",
       "      <td></td>\n",
       "      <td>HDMA Best Practices for controlled Substances ...</td>\n",
       "      <td>HDMA, Healthcare Distribution Management Assoc...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1965-79  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>rxyc0230</td>\n",
       "      <td>rdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>FW: HDMA DEA Strategy Meeting - Availability R...</td>\n",
       "      <td>Ducca, Anita, Healthcare Distribution Manageme...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 2350-26  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>fjyc0230</td>\n",
       "      <td>vdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document</td>\n",
       "      <td></td>\n",
       "      <td>Chronology of HDMA Involvementn in DEA Control...</td>\n",
       "      <td>HDMA, Healthcare Distribution Management Assoc...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1965-80 Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>gjyc0230</td>\n",
       "      <td>wdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>Chronology of HDMA DEA Involvementn updated 10...</td>\n",
       "      <td>Ducca, Anita, Healthcare Distribution Manageme...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1965-81  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>hjyc0230</td>\n",
       "      <td>xdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Presentation</td>\n",
       "      <td></td>\n",
       "      <td>Industry Compliance Guidelines: Reporting Susp...</td>\n",
       "      <td>Ducca, Anita, Healthcare Distribution Manageme...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1965-83  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>xjyc0230</td>\n",
       "      <td>ydk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Presentation</td>\n",
       "      <td></td>\n",
       "      <td>DEA Suspicious Orders: Recommended Industry Co...</td>\n",
       "      <td>HDMA, Healthcare Distribution Management Assoc...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1965-84 Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>kjyc0230</td>\n",
       "      <td>aek70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document, Email</td>\n",
       "      <td></td>\n",
       "      <td>Rewrite; Exhibit 408</td>\n",
       "      <td>Wilson, Bill, Wilson Security Services, Inc</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1965-90 Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>ljyc0230</td>\n",
       "      <td>bek70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>DEA Strategy Task Force Meeting Update; Exhibi...</td>\n",
       "      <td>Twitty, Tom, HD Smith</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 2357-74 Filed:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>jjyc0230</td>\n",
       "      <td>zdk70j00</td>\n",
       "      <td></td>\n",
       "      <td>Presentation</td>\n",
       "      <td></td>\n",
       "      <td>HDMA DEA Suspicious Orders \"Best Practices\"; E...</td>\n",
       "      <td>HDMA, Healthcare Distribution Management Assoc...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1965-85  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>mjyc0230</td>\n",
       "      <td>cek70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document, Email, Image</td>\n",
       "      <td></td>\n",
       "      <td>Suspicious Orders Project; Exhibit 410</td>\n",
       "      <td>Ducca, Anita, Healthcare Distribution Manageme...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP Doc #: 1965-92 Filed: ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>njyc0230</td>\n",
       "      <td>dek70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>Fwd: Draft Ensuring Patient Access and Effecti...</td>\n",
       "      <td>Ducca, Anita, Healthcare Distribution Manageme...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 2357-76  Filed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>yjyc0230</td>\n",
       "      <td>eek70j00</td>\n",
       "      <td></td>\n",
       "      <td>Email</td>\n",
       "      <td></td>\n",
       "      <td>Fwd: S. 483 Ensuring Patient Access and Effect...</td>\n",
       "      <td>Bennett, Pamela, Purdue Pharma</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP Doc #: 2357-99 Filed: ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>pjyc0230</td>\n",
       "      <td>fek70j00</td>\n",
       "      <td></td>\n",
       "      <td>HTML, Presentation</td>\n",
       "      <td></td>\n",
       "      <td>Crisis Playbook: An Interactive Guide to Crisi...</td>\n",
       "      <td>HDMA, Healthcare Distribution Management Assoc...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 2357-105  File...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>qjyc0230</td>\n",
       "      <td>gek70j00</td>\n",
       "      <td></td>\n",
       "      <td>Document, Presentation</td>\n",
       "      <td></td>\n",
       "      <td>Distributor Briefing with Actavis Elizabeth, L...</td>\n",
       "      <td>Boockholdt, Barbara, Office of Diversion Control</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Case: l:17-md-02804-DAP  Doc #: 1967-72  Filed...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>55 rows × 71 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          id       tid bates                    type description  \\\n",
       "0   mgyc0230  gck70j00           Email, Presentation               \n",
       "1   kgyc0230  eck70j00                      Document               \n",
       "2   ygyc0230  ick70j00                      Document               \n",
       "3   lgyc0230  fck70j00                      Document               \n",
       "4   pgyc0230  jck70j00                         Email               \n",
       "5   rgyc0230  lck70j00                         Email               \n",
       "6   qgyc0230  kck70j00                         Email               \n",
       "7   zgyc0230  ock70j00                         Email               \n",
       "8   tgyc0230  nck70j00               Document, Image               \n",
       "9   fhyc0230  pck70j00                         Email               \n",
       "10  ngyc0230  hck70j00                      Document               \n",
       "11  ghyc0230  qck70j00                         Email               \n",
       "12  hhyc0230  rck70j00                         Email               \n",
       "13  sgyc0230  mck70j00                      Document               \n",
       "14  xhyc0230  sck70j00                         Email               \n",
       "15  jhyc0230  tck70j00                         Email               \n",
       "16  khyc0230  uck70j00                         Email               \n",
       "17  yhyc0230  yck70j00                         Email               \n",
       "18  mhyc0230  wck70j00                         Email               \n",
       "19  lhyc0230  vck70j00                         Email               \n",
       "20  phyc0230  zck70j00                         Email               \n",
       "21  nhyc0230  xck70j00                      Document               \n",
       "22  shyc0230  cdk70j00                         Email               \n",
       "23  thyc0230  ddk70j00                         Email               \n",
       "24  rhyc0230  bdk70j00                         Email               \n",
       "25  qhyc0230  adk70j00                         Email               \n",
       "26  zhyc0230  edk70j00                         Email               \n",
       "27  gxyc0230  gdk70j00                         Email               \n",
       "28  hxyc0230  hdk70j00                         Email               \n",
       "29  fxyc0230  fdk70j00                         Email               \n",
       "30  xxyc0230  idk70j00                         Email               \n",
       "31  jxyc0230  jdk70j00                         Email               \n",
       "32  kxyc0230  kdk70j00                         Email               \n",
       "33  mxyc0230  mdk70j00               Document, Email               \n",
       "34  lxyc0230  ldk70j00                         Email               \n",
       "35  nxyc0230  ndk70j00                      Document               \n",
       "36  yxyc0230  odk70j00                         Email               \n",
       "37  pxyc0230  pdk70j00                      Document               \n",
       "38  qxyc0230  qdk70j00                         Email               \n",
       "39  txyc0230  tdk70j00                      Document               \n",
       "40  sxyc0230  sdk70j00                      Document               \n",
       "41  zxyc0230  udk70j00                      Document               \n",
       "42  rxyc0230  rdk70j00                         Email               \n",
       "43  fjyc0230  vdk70j00                      Document               \n",
       "44  gjyc0230  wdk70j00                         Email               \n",
       "45  hjyc0230  xdk70j00                  Presentation               \n",
       "46  xjyc0230  ydk70j00                  Presentation               \n",
       "47  kjyc0230  aek70j00               Document, Email               \n",
       "48  ljyc0230  bek70j00                         Email               \n",
       "49  jjyc0230  zdk70j00                  Presentation               \n",
       "50  mjyc0230  cek70j00        Document, Email, Image               \n",
       "51  njyc0230  dek70j00                         Email               \n",
       "52  yjyc0230  eek70j00                         Email               \n",
       "53  pjyc0230  fek70j00            HTML, Presentation               \n",
       "54  qjyc0230  gek70j00        Document, Presentation               \n",
       "\n",
       "                                                title  \\\n",
       "0   Mallinckrodt Controlled Substance Suspicious O...   \n",
       "1   Videotaped deposition of Jennifer R Norris in ...   \n",
       "2   Expert Report of Ronald W Buzzeo, R.Ph. in Nat...   \n",
       "3   Videotaped deposition of Nathan J Hartle in Na...   \n",
       "4   Suspicious Order Monitoring Program No. C/S Co...   \n",
       "5   Suspicious Order Monitoring Training Notes fro...   \n",
       "6   Re: Suspicious Order Monitoring Program; Exhib...   \n",
       "7                                 RE: SOM; Exhibit 48   \n",
       "8   Retail Generic Incentive Plan Earnings by Sale...   \n",
       "9   RE: CVS Caremark Transitioning Generic Pharma;...   \n",
       "10  Videotaped deposition of Karen Harper in Natio...   \n",
       "11               Fw: Old Bridge acc# 3448; Exhibit 52   \n",
       "12       RE: Oxy 15 mg & 30 mg at Sunrise; Exhibit 53   \n",
       "13  Videotaped deposition of William Ratliff in Na...   \n",
       "14              RE: Peculiar order report; Exhibit 54   \n",
       "15                           RE: HD Smith; Exhibit 55   \n",
       "16                             RE: Oxy 30; Exhibit 58   \n",
       "17                  Oxy Sales by retailer; Exhibit 63   \n",
       "18                             RE: Things; Exhibit 60   \n",
       "19                  FW: Sunrise Wholesale; Exhibit 59   \n",
       "20  FW: pharmacies noted in Coviedien letter; Exhi...   \n",
       "21  Videotaped deposition of Victor Borelli in Nat...   \n",
       "22               RE: Item Exceeds Average; Exhibit 78   \n",
       "23               RE: Item Exceeds Average; Exhibit 79   \n",
       "24                          RE: Methadone; Exhibit 70   \n",
       "25        FW: Notes to File, Howard Davis; Exhibit 69   \n",
       "26               RE: Item Exceeds Average; Exhibit 80   \n",
       "27  RE: Item on order exceeds average exception; E...   \n",
       "28  RE: Item on order exceeds average exception; E...   \n",
       "29  RE: Item on order exceeds average exception; E...   \n",
       "30  FW: Item on order exceeds average exception; E...   \n",
       "31  RE: 2 suspicious/excessive for 08DEC2016; Exhi...   \n",
       "32  RE: McKesson Agrees to Pay Record $150 Million...   \n",
       "33  Initial Findings and Recommendations on Cardin...   \n",
       "34         FW: Possible Suspect Pharmacy; Exhibit 217   \n",
       "35  Investigation Report of the Special Demand Com...   \n",
       "36  RE: The situation at CAH remains \"chaotic\" and...   \n",
       "37        Oral testimony of Todd Cameron; Exhibit 229   \n",
       "38                    Our Friends at DEA; Exhibit 232   \n",
       "39  Summary of the DEA-HDMA Meeting 4/15/2008 - Th...   \n",
       "40  Appendix B: Order to Show Cause and Immediate ...   \n",
       "41  HDMA Best Practices for controlled Substances ...   \n",
       "42  FW: HDMA DEA Strategy Meeting - Availability R...   \n",
       "43  Chronology of HDMA Involvementn in DEA Control...   \n",
       "44  Chronology of HDMA DEA Involvementn updated 10...   \n",
       "45  Industry Compliance Guidelines: Reporting Susp...   \n",
       "46  DEA Suspicious Orders: Recommended Industry Co...   \n",
       "47                               Rewrite; Exhibit 408   \n",
       "48  DEA Strategy Task Force Meeting Update; Exhibi...   \n",
       "49  HDMA DEA Suspicious Orders \"Best Practices\"; E...   \n",
       "50             Suspicious Orders Project; Exhibit 410   \n",
       "51  Fwd: Draft Ensuring Patient Access and Effecti...   \n",
       "52  Fwd: S. 483 Ensuring Patient Access and Effect...   \n",
       "53  Crisis Playbook: An Interactive Guide to Crisi...   \n",
       "54  Distributor Briefing with Actavis Elizabeth, L...   \n",
       "\n",
       "                                               author mentioned attending  \\\n",
       "0   Harper, Karen, Mallinckrodt/Covidien Pharmaceu...                       \n",
       "1     US District Court for Northern District of Ohio                       \n",
       "2                                      Buzzeo, Ronald                       \n",
       "3     US District Court for Northern District of Ohio                       \n",
       "4                                       Davis, Howard                       \n",
       "5   Harper, Karen, Mallinckrodt/Covidien Pharmaceu...                       \n",
       "6   Harper, Karen, Mallinckrodt/Covidien Pharmaceu...                       \n",
       "7   Harper, Karen, Mallinckrodt/Covidien Pharmaceu...                       \n",
       "8                                                                           \n",
       "9                           Borelli, Victor, Covidien                       \n",
       "10    US District Court for Northern District of Ohio                       \n",
       "11                                      Adams, John G                       \n",
       "12                           Stewart, Cathy, Covidien                       \n",
       "13    US District Court for Northern District of Ohio                       \n",
       "14                          Borelli, Victor, Covidien                       \n",
       "15                Myers, Penny, Covidien Mallinckrodt                       \n",
       "16                          Borelli, Victor, Covidien                       \n",
       "17                          Collier, Ginger, Covidien                       \n",
       "18                          Borelli, Victor, Covidien                       \n",
       "19                           Stewart, Cathy, Covidien                       \n",
       "20             Corona, Wayne, Masters Pharmaceuticals                       \n",
       "21    US District Court for Northern District of Ohio                       \n",
       "22                                      Seid, Stephen                       \n",
       "23                                      Seid, Stephen                       \n",
       "24                           Burd, Jeff, Mallinckrodt                       \n",
       "25  Harper, Karen, Mallinckrodt/Covidien Pharmaceu...                       \n",
       "26                                      Seid, Stephen                       \n",
       "27                                      Seid, Stephen                       \n",
       "28                                      Seid, Stephen                       \n",
       "29                                      Seid, Stephen                       \n",
       "30                                      Seid, Stephen                       \n",
       "31   Corum, Belinda, JOM Pharmaceutical Services, Inc                       \n",
       "32          Dempsey, Michele, Janssen Pharmaceuticals                       \n",
       "33                   Buzzeo, Ronald, Cegedim Dendrite                       \n",
       "34                     Mone, Michael, Cardinal Health                       \n",
       "35                           Special Demand Committee                       \n",
       "36                 Sopher, Scott, Deloitte Consulting                       \n",
       "37  The State of Montana Office of the Attorney Ge...                       \n",
       "38                       Crowley, Jack, Purdue Pharma                       \n",
       "39  HDMA, Healthcare Distribution Management Assoc...                       \n",
       "40  Leonhart, Michele, Drug Enforcement Administra...                       \n",
       "41  HDMA, Healthcare Distribution Management Assoc...                       \n",
       "42  Ducca, Anita, Healthcare Distribution Manageme...                       \n",
       "43  HDMA, Healthcare Distribution Management Assoc...                       \n",
       "44  Ducca, Anita, Healthcare Distribution Manageme...                       \n",
       "45  Ducca, Anita, Healthcare Distribution Manageme...                       \n",
       "46  HDMA, Healthcare Distribution Management Assoc...                       \n",
       "47        Wilson, Bill, Wilson Security Services, Inc                       \n",
       "48                              Twitty, Tom, HD Smith                       \n",
       "49  HDMA, Healthcare Distribution Management Assoc...                       \n",
       "50  Ducca, Anita, Healthcare Distribution Manageme...                       \n",
       "51  Ducca, Anita, Healthcare Distribution Manageme...                       \n",
       "52                     Bennett, Pamela, Purdue Pharma                       \n",
       "53  HDMA, Healthcare Distribution Management Assoc...                       \n",
       "54   Boockholdt, Barbara, Office of Diversion Control                       \n",
       "\n",
       "   copied  ... datereceived datesent filename  filepath messageid subject  \\\n",
       "0          ...                                                              \n",
       "1          ...                                                              \n",
       "2          ...                                                              \n",
       "3          ...                                                              \n",
       "4          ...                                                              \n",
       "5          ...                                                              \n",
       "6          ...                                                              \n",
       "7          ...                                                              \n",
       "8          ...                                                              \n",
       "9          ...                                                              \n",
       "10         ...                                                              \n",
       "11         ...                                                              \n",
       "12         ...                                                              \n",
       "13         ...                                                              \n",
       "14         ...                                                              \n",
       "15         ...                                                              \n",
       "16         ...                                                              \n",
       "17         ...                                                              \n",
       "18         ...                                                              \n",
       "19         ...                                                              \n",
       "20         ...                                                              \n",
       "21         ...                                                              \n",
       "22         ...                                                              \n",
       "23         ...                                                              \n",
       "24         ...                                                              \n",
       "25         ...                                                              \n",
       "26         ...                                                              \n",
       "27         ...                                                              \n",
       "28         ...                                                              \n",
       "29         ...                                                              \n",
       "30         ...                                                              \n",
       "31         ...                                                              \n",
       "32         ...                                                              \n",
       "33         ...                                                              \n",
       "34         ...                                                              \n",
       "35         ...                                                              \n",
       "36         ...                                                              \n",
       "37         ...                                                              \n",
       "38         ...                                                              \n",
       "39         ...                                                              \n",
       "40         ...                                                              \n",
       "41         ...                                                              \n",
       "42         ...                                                              \n",
       "43         ...                                                              \n",
       "44         ...                                                              \n",
       "45         ...                                                              \n",
       "46         ...                                                              \n",
       "47         ...                                                              \n",
       "48         ...                                                              \n",
       "49         ...                                                              \n",
       "50         ...                                                              \n",
       "51         ...                                                              \n",
       "52         ...                                                              \n",
       "53         ...                                                              \n",
       "54         ...                                                              \n",
       "\n",
       "   timereceived timesent redaction  \\\n",
       "0                                    \n",
       "1                                    \n",
       "2                                    \n",
       "3                                    \n",
       "4                                    \n",
       "5                                    \n",
       "6                                    \n",
       "7                                    \n",
       "8                                    \n",
       "9                                    \n",
       "10                                   \n",
       "11                                   \n",
       "12                                   \n",
       "13                                   \n",
       "14                                   \n",
       "15                                   \n",
       "16                                   \n",
       "17                                   \n",
       "18                                   \n",
       "19                                   \n",
       "20                                   \n",
       "21                                   \n",
       "22                                   \n",
       "23                                   \n",
       "24                                   \n",
       "25                                   \n",
       "26                                   \n",
       "27                                   \n",
       "28                                   \n",
       "29                                   \n",
       "30                                   \n",
       "31                                   \n",
       "32                                   \n",
       "33                                   \n",
       "34                                   \n",
       "35                                   \n",
       "36                                   \n",
       "37                                   \n",
       "38                                   \n",
       "39                                   \n",
       "40                                   \n",
       "41                                   \n",
       "42                                   \n",
       "43                                   \n",
       "44                                   \n",
       "45                                   \n",
       "46                                   \n",
       "47                                   \n",
       "48                                   \n",
       "49                                   \n",
       "50                                   \n",
       "51                                   \n",
       "52                                   \n",
       "53                                   \n",
       "54                                   \n",
       "\n",
       "                                             ocr_text  \n",
       "0   Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed...  \n",
       "1   Case: l:17-md-02804-DAP Doc #: 1957-11 Filed: ...  \n",
       "2   Case: l:17-md-02804-DAP  Doc #: 1957-35  Filed...  \n",
       "3   Case: l:17-md-02804-DAP  Doc #: 1957-12  Filed...  \n",
       "4   Case: l:17-md-02804-DAP  Doc #: 1957-41  Filed...  \n",
       "5   Case: l:17-md-02804-DAP  Doc #: 1957-43  Filed...  \n",
       "6   Case: l:17-md-02804-DAP  Doc #: 1957-42  Filed...  \n",
       "7   Case: l:17-md-02804-DAP  Doc #: 1957-48  Filed...  \n",
       "8   Case: l:17-md-02804-DAP  Doc #: 1957-45  Filed...  \n",
       "9   Case: l:17-md-02804-DAP  Doc #: 1957-50 Filed:...  \n",
       "10  Case: l:17-md-02804-DAP  Doc #: 1957-34 Filed:...  \n",
       "11  Case: l:17-md-02804-DAP  Doc #: 1957-52  Filed...  \n",
       "12  Case: l:17-md-02804-DAP  Doc #: 1957-53  Filed...  \n",
       "13  Case: l:17-md-02804-DAP  Doc #: 1957-44 Filed:...  \n",
       "14  Case: l:17-md-02804-DAP  Doc #: 1957-54 Filed:...  \n",
       "15  Case: l:17-md-02804-DAP  Doc #: 1957-55  Filed...  \n",
       "16  Case: l:17-md-02804-DAP  Doc #: 1957-58  Filed...  \n",
       "17  Case: l:17-md-02804-DAP  Doc #: 1957-63  Filed...  \n",
       "18  Case: l:17-md-02804-DAP  Doc #: 1957-60 Filed:...  \n",
       "19  Case: l:17-md-02804-DAP  Doc #: 1957-59  Filed...  \n",
       "20  Case: l:17-md-02804-DAP  Doc #: 1957-65  Filed...  \n",
       "21  Case: l:17-md-02804-DAP  Doc #: 1957-61  Filed...  \n",
       "22  Case: l:17-md-02804-DAP  Doc #: 1957-78  Filed...  \n",
       "23  Case: l:17-md-02804-DAP  Doc #: 1957-79  Filed...  \n",
       "24  Case: l:17-md-02804-DAP  Doc #: 1957-70 Filed:...  \n",
       "25  Case: l:17-md-02804-DAP  Doc #: 1957-69  Filed...  \n",
       "26  Case: l:17-md-02804-DAP  Doc #: 1957-80 Filed:...  \n",
       "27  Case: l:17-md-02804-DAP  Doc #: 1957-82  Filed...  \n",
       "28  Case: l:17-md-02804-DAP  Doc #: 1957-83  Filed...  \n",
       "29  Case: l:17-md-02804-DAP Doc #: 1957-81 Filed: ...  \n",
       "30  Case: l:17-md-02804-DAP  Doc #: 1957-84 Filed:...  \n",
       "31  Case: l:17-md-02804-DAP Doc #: 1960-100 Filed:...  \n",
       "32  Case: l:17-md-02804-DAP Doc #: 1960-102 Filed:...  \n",
       "33  Case: l:17-md-02804-DAP  Doc #: 1964-7  Filed:...  \n",
       "34  Case: l:17-md-02804-DAP  Doc #: 1964-5  Filed:...  \n",
       "35  Case: l:17-md-02804-DAP  Doc #: 1964-8  Filed:...  \n",
       "36  Case: l:17-md-02804-DAP  Doc #: 1964-12  Filed...  \n",
       "37  Case: l:17-md-02804-DAP  Doc #: 1964-17  Filed...  \n",
       "38  Case: l:17-md-02804-DAP Doc #: 2350-25 Filed: ...  \n",
       "39  Case: l:17-md-02804-DAP  Doc #: 1965-78  Filed...  \n",
       "40  Case: l:17-md-02804-DAP  Doc #: 1965-17  Filed...  \n",
       "41  Case: l:17-md-02804-DAP  Doc #: 1965-79  Filed...  \n",
       "42  Case: l:17-md-02804-DAP  Doc #: 2350-26  Filed...  \n",
       "43  Case: l:17-md-02804-DAP  Doc #: 1965-80 Filed:...  \n",
       "44  Case: l:17-md-02804-DAP  Doc #: 1965-81  Filed...  \n",
       "45  Case: l:17-md-02804-DAP  Doc #: 1965-83  Filed...  \n",
       "46  Case: l:17-md-02804-DAP  Doc #: 1965-84 Filed:...  \n",
       "47  Case: l:17-md-02804-DAP  Doc #: 1965-90 Filed:...  \n",
       "48  Case: l:17-md-02804-DAP  Doc #: 2357-74 Filed:...  \n",
       "49  Case: l:17-md-02804-DAP  Doc #: 1965-85  Filed...  \n",
       "50  Case: l:17-md-02804-DAP Doc #: 1965-92 Filed: ...  \n",
       "51  Case: l:17-md-02804-DAP  Doc #: 2357-76  Filed...  \n",
       "52  Case: l:17-md-02804-DAP Doc #: 2357-99 Filed: ...  \n",
       "53  Case: l:17-md-02804-DAP  Doc #: 2357-105  File...  \n",
       "54  Case: l:17-md-02804-DAP  Doc #: 1967-72  Filed...  \n",
       "\n",
       "[55 rows x 71 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "fa9424dc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['id', 'tid', 'bates', 'type', 'description', 'title', 'author',\n",
       "       'mentioned', 'attending', 'copied', 'recipient', 'redacted',\n",
       "       'collection_name', 'pages', 'exhibit_number', 'document_date',\n",
       "       'date_added_ucsf', 'date_modified_ucsf', 'date_added_industry',\n",
       "       'date_modified_industry', 'date_produced', 'date_shipped',\n",
       "       'deposition_date', 'date_privilege_logged', 'case', 'industry', 'drug',\n",
       "       'adverse_ruling', 'area', 'bates_alternate', 'box', 'brand', 'country',\n",
       "       'language', 'court', 'format', 'express_waiver', 'file', 'genre',\n",
       "       'keywords', 'bates_master', 'other_number', 'request_number',\n",
       "       'minnesota_request_number', 'privilege_code', 'topic', 'witness',\n",
       "       'cited', 'availability', 'grant_number', 'source', 'folder', 'series',\n",
       "       'chemical', 'food', 'rights', 'attachment', 'attachmentnum',\n",
       "       'conversation', 'conversationid', 'custodian', 'datereceived',\n",
       "       'datesent', 'filename', 'filepath', 'messageid', 'subject',\n",
       "       'timereceived', 'timesent', 'redaction', 'ocr_text'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "ae3d1b65",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19  1 of 26.  PagelD #: 127749    EXHIBIT 33     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19 2 of 26.  PagelD #: 127750    From:    To:    Sent:    Subject:    Attachments:    Harper, Karen    Sarrtowski, Michael J    4/12/2011 7:27:22 PM    Suspicious Order Monitoring Presentation for EC    Training for Executive Committee 04_20l1.ppt    Karen Harper    Mallinckrodt/Covidien Pharmaceuticals    Senior Manager, Controlled Substance Compliance    Global Logistics Group    office phone (314) 654-1868    cellular (314) 401-1573    This irtfbrm ebon maybe oonfrienbal and/or privileged. Use of this inform ation by anyone omer than the Intended recipient is prohibited If you receive mis in error, please inform the sender and remove any record of mis message.    EXHIBIT^  3    DATE: cc8mpb(l|>R0RefiflesT7T^;    Confidential    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-Mi 000024199 MNK-T10000283074     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19 3 of 26.  PagelD #: 127751    Mallinckrodt Controlled Substance Suspicious Order Monitoring Program    Presentation for Executive Committee April 25, 2011    yrrreao*oe%dfi    ~^-\\\\>^1Xm  .r^e�.^�\\'-    m----    f^rf^sA^.^,^^ itSX � fife    . ^^^>^fe|l^       lit    �**n�-.^,�;*�^:!\\':;:::|\\',V \\'\\\\^J,.n<<v\\'lf.\"\\'-3>-!\\\\-\\'<^7i!    ,Jj!i ^^^ ;�; \\'MS^S        g^^WSSS^i        � -c^tm        ^rj^i^V.v �tf.\\'-Y,,;\"\".i-.ll^\\'i\\'VWwt/i � J \\'�>,-..\\' .� -        y&s�a    \"w*,��iw^.\\'\"\\'li:. V�;. \\'-Km,...hmO\\',-.\".. .�7*;.y,--,: \\'l-\\'TttTl    Confidential    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024200 MNK-T1 0000283075     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19 4 of 26.  PagelD #: 127752    Suspicious Order Monitoring Presentation Agenda    Suspicious Order Monitoring Team Composition    Regulatory Background    By the Numbers    Oxycodone Market Analysis    Florida Distribution Trends    DEA Past Communication and Distributor Initiative    Previous Suspicious Order Monitoring Program    Recent Industry Enforcement Action and DEA Guidance    Suspicious Order Monitoring Enhancements    OxyContin Express Video    Florida Pain Clinic Raids    Suspicious Order Monitoring Next Steps    DEA and Distributor Feedback    Confidential    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024201 MNK-T1 0000283076     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19 5 of 26.  PagelD #: 127753    Mallinckrodt Suspicious Order Monitoring (SOM) Team Composition    Leadership Team Meets once per month    Controlled Substance Compliance    Security    Legal    Steering Committee Meets once per quarter    Controlled Substance Compliance    Security    Legal    Commercial    Customer Service    Finance    Medical Affairs/REMs    Subcommittees    As needed    WiilililH^?  /��?    Mm�wfh4�m    w\\':m Ld&mHl-\\':-M    ^:30-:    i:WY.\";,\\'\\'..A.    UllllllilhMi* i n ,J�*ritnu!\\'w    \\' .�\\'a*;.: \\'    rf-i!-\\'\\'-\\'\\'    :-e    (.          �:-.   \\'  � WWW    AO\\'.V        3   I    Confidential    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024202 MNK-T1 0000283077     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19 6 of 26.  PagelD #: 127754    . o523iime/v    DEA Policy on Suspicious Orders    21 CFR 1301.74        �Requires registrants to design and operate a suspicious order identification system    �Requires that registrants report suspicious orders to DEA when discovered via monitoring process    �Registrant is reminded that their responsibility does not end merely with the filing of a suspicious order report    �DEA does not approve or otherwise endorse any specific program for reporting suspicious orders    � Registrant must conduct an independent analysis of suspicious orders prior to completing a sale to determine whether the controlled substances are likely to be diverted    Confidential    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024203 MNK-T1 0000283078     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19 7 of 26.  PagelD #: 127755    By the Numbers    �sa^^  There are currently 1,363,883 DEA registrants    V*f<    �ill    &    795 Distributor registrants    gS^I   528 Manufacturing registrants    %^u^�*Z\\\\i?-    \\'DEA must rely on the States and individual registrants to monitor\"    J3   COVIDIEN    Covidien has 1,300+ controlled substance customer account\\'s    1,100+ Generics & Specialty Brands 200+ Active Pharmaceutical Ingredients    5   I    Confidential    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024204 MNK-T1  0000283079     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19 8 of 26.  PagelD #: 127756    Oxycodone Market Analysis 04/12/11    Product Description   Oxy/APAP   Tablets   Oxy/APAP   Caps (5/500)   Oxy   Tablets    MAL Share FY10Q4   40%   33%   52%    MAL Share FY11Q1   39%   31%   56%    Actavts      1%   25%    Amneal   5%          Caraco         2%    Endo   15%          Halsey      1%       KVK-Tech         3%    Qualitest   5%   12%   12%    Roxane   3%   16%       Teva      38%       Watson   31%   1%       Mylan   2%          CorePharma         2%    TOTAL   100.0%   100.0%   100.0%    6  I    Confidential .    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024205 MNK-T1 0000283080     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19 9 of 26.  PagelD #: 127757    Florida Distribution of Oxycodone    98 of the top 100 doctors dispensing Oxycodone nationally are in Florida    By far, more oxycodone is dispensed in the state of Florida than in the remaining states combined    data per Florida Governor\\'s Press Office 03/28/11    7  I    Confidential    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024206 MNK-T1 0000283081     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19  10 of 26.  PagelD #: 127758    DEA reiterates responsibilities in light of the growing Rx drug abuse problem    U.S. D�F�fiTfn6/IT OF JUSTICE ORUS EIIFUHCEWEIIT ADinmiSTHIlTWII    www.dea.gov    Washington, DC. 2D537    MALLINCKRODT INC    3600 NORTH SECOND STREET    ST LOUIS MO.   63147-0000    l,ll��ll�,,ll.l..ll.,.lll,..ll,.,ll,.,ll...l,l�t    December 27,2007    In reference to registration # PM0037451    Dear Registrant-.    This letter Is being sent to even/ entity in Ihe United Slates registered wilh the Drug Enforcement Administration (DEA) to manufacture or distribute controlled substances. The purpose of this lelter Is to reiterate the responsibilities of controlled substance manufacturers and distributors to inform DEA of suspicious orders In accordance wilh 21 CFR 1301.74(b).    In addilion to, and not in lieu of, the general requirement under 21 USC 823, that manufacturers and distributors maintain effective controls against diversion. DEA regulations require all manufacturers and distributors to report suspicious orders of controlled substances. Tills 21 CFR 1301.74(b), specifically requires that s registrant \"design and operate a system to disclose to the registrant suspicious orders of controlled substances.\" The regulation clearly indicates that It Is tha sole responsibility of the registrant to design and operate such a system. Accordingly, DEA does not approve or otherwise endorse any specific system for reporting suspicious orders. Past communications with DEA. whether implicit or explicit, that could be construed as approval of a particular system for reporting suspicious orders, should no longer be taken to mean that DEA approves a specific system.    The regulation also requires that the registrant Inform the local DEA Division Office of suspicious orders when discovered by the registrant. Filing a monlhly report ol completed transactions (e.g.. \"excessive purchase report\" or \"high unit purchases\\') does nol meet the regulatory requirement lo report suspicious orders, Registrants are reminded that their responsibility doss not end merely with the filing of a suspicious order report Registrants must conduct an independent analysis of suspicious orders prior to completing a sala to determine whether Ihe controlled substances are likely to be diverted from legitimate channels. Reporting an order as suspicious will not absolve tha registrant of responsibility if the registrant knew, or should have known, that the controlled substances were being diverted.    The regulation specifically slates that suspicious orders include orders of an unusual size, orders deviating substantially from a normal pattern, and orders of an unusual frequency. These criteria are disjunctive and are nol all Inclusive. For example, if an order deviates subslanlially from a normal pallorn, the size of the order does not matter and tha order should be reported as suspicious. Likewise, a registrant need not welt for a \"normal pattern\" to develop over time before determining whether a particular order Is suspicious. The size of an order alone, whether or nol It deviates from a normal pattern, Is enough to trigger the registrant\\'s responsibility to report the order ss suspicious, The determination of whether an order is suspicious depends not only on the ordering patterns of the particular customer, but also on the patterns of the registrant\\'s customer base and the patterns throughout tha relevant segment of the regulated industry.    Failure to maintain effective controls against diversion is inconsistent with the public interest and may result in the revocation of the registrant\\'s DEA license    DEA can immediately    suspend or revoke    registration for violations of    the Controlled Substances    Act and regulations.    Confidential    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024207 MNK-T1 0000283082     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19  11 of 26.  PagelD #: 127759    DEA Distributor Initiative, 2008    DEA suspends licenses of distributors for not maintaining effective controls against diversion of controlled substances    Amerisource Bergen    Orlando, FL Distribution Licenses suspended for four months    Cardinal    DEA license suspended at three distribution centers for ten    months    Cardinal pays $34 million due to enforcement actions    McKesson    McKesson Corporation Agrees to Pay More than $13 million to settle claims that it failed to report suspicious sales of prescription medications    9   I    Confidential    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024208 MNK-T1 0000283083     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19  12 of 26.  PagelD #: 127760    Masters Pharmaceutical    Masters is a Mallinckrodt Distributor customer    Masters sold more than 4 million doses of hydrocodone, phentermine and alprazolam to internet pharmacies between 2005-2008 without reporting the sales to the DEA    Although Masters reported suspicious orders during the 2005 and 2008 period in question, the DEA believed that some orders placed by 10 pharmacies should have been reported as suspicious    ^A\\'lUJiiiw/njiffW^^    mm:^<    !J.v:..-,Z\\'�    $$    l:.:l    >�**\\'    ,v\\'-^    fl\\'iiTx        fW     \"-�\\'\",\\'.\\'\"4    Ii:;.;.�*:;..   W\\'-\\'WWX    M    Fined $500,000    10    � Confidential    .    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024209 MNK-T1 0000283084     Case: l:17-md-02804-DAP Doc #: 1957-33 Filed: 07/23/19 13 of 26. PagelD #: 127761    fc    CVS Fines    Mb    z^3tWs3^.    tr^zM\\\\V.W- Ml�\\\\X>;,&&!&\\'    Mw\\'- �\\'�\\'< � \\' �\\'�\\'\\' \\'i i>:.i \\'/A    . �:!i-:&�  ��    .�.       --\\'i   \\'*     U-\\'   .\\'.V    ,\\' [.I TTf�5MS2L    �� � �\\'   i�*\\'-;>ll*< ^SiS-V\\'1!    fc\\'V,\"     :�:� ���� \\'�\\'��\\'�� �� �u..\\'U3u;jiuJ!!.!,n   \\'   ji\\'i    �4iiJ.i7.\\',.    CVS Caremark\\'s Latest Leqal Headaches? A Record $77.6 Million Settlement with DEA Published October 15, 2010    The already extensive list of government entities scrutinizing CVS Caremark\\'s behavior just got longer. DEA joins the alphabet soup with a record $77.6 million settlement, which includes a $75 million fine (the largest ever under the Controlled Substances Act) and the forfeiture of $2.6 million in profits from illegal sales. Meanwhile, a California court upheld a $42,000 fine against Caremark for acting in \"bad faith\" in a whistleblower lawsuit.    In a statement, the U.S. Drug Enforcement Administration said the company, \"admitted that it unlawfully sold pseudoephedrine [PSE] to criminals who made methamphetamine. As part of the agreement with federal prosecutors, CVS has agreed to pay $75 million in civil penalties and to forfeit the $2.6 million in profits the company earned as a result of the illegal conduct.\"    11    Confidential    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024210 MNK-T1 0000283085     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19  14 of 26.  PagelD #: 127762    Existing SOM Program (pre 06/10)    � Customer completes checklist prior to establishing new account and once annually thereafter    � Credit performs Dun & Bradstreet and other information checks (Associated Pharmacies)    � CDIG and CSRs follow existing procedure on verification of customer DEA registration, quota, DEA 222 Form    � Peculiar Order report flags direct orders of unusual size, frequency, incremental increases, purchase of a new molecule or business from a new customer    � Any Peculiar Order issues that are not resolved by internal investigation are referred to the Controlled Substance Compliance Group Security Director and DEA Compliance Manager for further investigation    � Security Director and DEA Compliance Manager consult with Commercial Group Business Manager regarding ship or no ship decision based on findings of their investigation    � Security Director and DEA Compliance Manager report orders that have been elevated from Peculiar to Suspicious to DEA    Confidential �    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024211 MNK-T1 0000283086     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19  15 of 26.  PagelD #: 127763    Industry Events 06/16/10    Harvard Drug (Mallinckrodt Distributor customer) Livonia, Michigan    Controlled Substance License Suspended for Livonia location Approval to resume shipping CIII-CV negotiated within one week CI I restriction shipments at Livonia still in force    Sunrise Distributors (Mallinckrodt Distributor customer) Sunrise, Florida    License Suspended pending further investigation License voluntarily surrendered    13   I    Confidential    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024212 MNK-T1 0000283087     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19  16 of 26.  PagelD #: 127764    DEA St. Louis Conversation 07/20/10    Mallinckrodt was named as supplier of Harvard Drug Distributor at a DEA training session in Washington DC    Pain Clinic undercover operations reveal a \"cattle call\" scenario    Mallinckrodt is viewed as the kingpin within the drug cartel    DEA is implementing a \"new direction\" initiative aimed at manufacturers of Oxycodone    DEA expectation has evolved to require that manufacturers know their customers\\' customers    14   I    Confidential .    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024213 MNK-T1 0000283088     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19  17 of 26.  PagelD #: 127765    SOM Program Enhancements Achieved    Monthly review of Chargeback Reports    Data analysis reveals    % of Oxycodone purchased per Distributor % of Distributor Oxycodone sold to Florida Pharmacies that purchase from multiple Distributors    Distributor Audit Program Implemented    Met with DEA Albany and DEA St. Louis to discuss Chargeback Report observations    Conducted on-site SOM Audit of Keysource, Masters, Cedardale 12/10 and 01/11    Informed Distributors of audit findings 02/11    All communication to Distributors has been pre-reviewed by Commercial    Checking law enforcement newsletters and DEA webpage for match with pharmacy indirect customers    15   |    Confidential    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024214 MNK-T1 0000283089     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19  18 of 26.  PagelD #: 127766    �mm^t-    .\\'�\\' ��\\':r:3\\'<-\\':\\'   \\'    ,Y::*\\'4af#^^    . *��\\'�\\';\\', ff-\\'v\\'-.-\\'S �   \\'\\' \\' \\'\\'� .\\'��\\'-\\'� f            . ->.-u�4a^_ .-�.    ....\\'i\\'xL/H-:- / VJnv.-\\'-\" \\'   f-T\\' I   fu.\\'-Vf    ��,.V|{:yy. c*mfe? fKl^jftiV^Wa^^TMt    �   ^Ml?   ...    .....,,-...........  -    : W^m    ��:-,>WvJ ^k  Pv&v.\\'.                 .-vri^Jeyii,(i� ��\\'� --�.J.4i^ts,��.k   ���    ;\\\\> \"    >�*<�    \\'I\\'M-    U\\'    4: V~7fT\\': �-*r\\\\ �    ^��\\'�^^(I\\'l\\'l\\'llii;1:\\':\\':\\'\\'/!!!    �\"   \\'-\\'mmWn    ,\\'r. 1 I I I I l\\\\ I,    \\'lllfjl\\'        /;;|^;/!::^;:^,:    fill!    .,.., ..� ii � Hi nan.....<\"ii\"    :� � �\\'.\\', i r!-).ff\\'X� �:-.Y.\\\\N.Tr,\\'l; ,V.� ,\"\\'-v?-\\'^�-..t\"� � i!^i.mj)_Mwu�mi>.\\' \\'i\"    i w    16    Confidential .    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024215 MNK-T1 0000283090     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19  19 of 26.  PagelD #: 127767    lit^.4�*.   ^T.       it** \"�\"t Trl\\' Eiff        ((                  �!,   L\\'\\'.    ,\\',AJ�il\\'�\"IU\\',*t\"    WVrtl*\"\"\"        \\'. �{��.!.i.l.\\'.i,l,l,(\\'�    �;^;\\';v;Yk,^Vfll\\'l\"\\'v\\'\\'ll,,i,-.: ;,;�:,\\'i iini.iMiliiii\"*-VrV -.Vf    B\\'-\\'-iY.:!\\',-,\\'^\".\":\\' Z< j\\';Vl1iiiiiiiilHM!,llilill^:,.!.^11)!!--i;f: Y;4;,        � l^v,iv,|iii:iV,\\',;:\\'-|.,i:\\'rrk\\',!:^;,!;Ti;l:li.^\\'    l^^^^vl-]    \"....v �..\\'iHiliti111 ^    ; ��:�: \\'J\\'^yr:\\'.r:V|V\\'i\\'mYi\\'iY    /:,.s\\'Vi\\'\\'4IK4\\'/V<-fi-.4\\'F \\' \\'\\'�WtkC\\'CiiK^\\'t\\'i    \\'^^uw\\'kW\\'pryfif\\'ji    viz XV      � �\\'\\'    \\\\i;iiMl ��. ,-,M\\'!:\"�\"�!    Y.fi    /�;i^^^^;vf/4ii:A\\';-:v:\\'>;\\'-/wf>.pztfe^MfiiM!;; ��\"�.\\'fc:,;. Ai&Whif.Mtiil    � �:* .�; .ri..^w.v\\'i-^\"\":\\'\"r ���\"�. ./\\'-ft f; \\'^\\'\\' ,-\\\\    , /    ; ,-Y: ah:-* ?�.�*\\'\\'/\"� ?*�;�&�. i.\\'.\\'.>;��:��,�.\\'I;,\\'i|. V \" I i\\'1\\'    �T�    .\\',\\'./ ZY,rv;!Ti\\'V:^\\'ifiY,i:^!\\'\\'/;v^!!!>z;.v,vVvSf\\';\\'\\' � v. riMl|./.^orio^.^j::Y/,f ��,     �;�. v.;iJ^   . ,,-,��;,;r ;v .ji:,u,�:,;^^.;v �^�\\'�.^�,7,\\'����..-� ;.^-    V \\'\\',\\'�I �.!.\\':�:� �\".:,�\\':\\'. 11. .*<�,\"� 11 - Vf �,�:,!�. \\'   �\\'.\\'�\\'��.\" I u\\'^ ,ii.,-,. :;a.\\'i^!J.!J.i(,l^^-i-_--.;_iiu^.\\'iiJi\\'-ui.\\'.�.�i\\'4iw\\',.,.;i,i:.-..:       �� -�:>   �\\'�-\\'   �-��   �---   --�    -Mr,; :Y . ;,..�;   - \"� � r..\\'-\\'.; \\'iV, \\'\";..,;,\\',,, -\\'f: r1!1 Ij\\'yf-i � mw I\\'wtn.i. i\\' �\\' \"  �> \\':i.h ii.^j.t\\'l.VM\\'J-fW \\'\" \\'\" \"- *.-\" ^�\"\"\\'�\\'\"\"---\" \\'    \\'\\'\\'�\\'\\'\"�\\'\\'\\'\\'\\'�\\'   \\'\"\"� i\\';\\'i\\'\\':\\'.\"     \\' \\'\\'� \\'�}\":�\"�\\'\\'�\\':,�\\'�, r^�mV->fn, j,Y*ywW�\\'\\' u..\\'Z\\':t;,;l\\'\"4 ^\\\\~;1\\'\\'\\'\\'\\'� ^f >,y--\\'W\\'.i\\'-�l\\'.\\',\\'-\\'\\'uV. r1^\\'�\\'�v\"\\'\\'\\'\\'-\\'\\'1 \\'   --- - \\'\\' 11\\'u\\'^X\\'�*4iu�reta�^^aaaaaBarea*atxitaMaxiiiBMtiittttitiiitiatx*pat-^*^..\\'-    ..-           ..�-.�-.w-------.    �yjiik.\\'Ui\\'\\'\"    f\\'|    -^��Yfl    �;�;�.!; w�.-,>;zilW,ilulT\\'^\\'    � i .p �xtuW\\'V\\'Y;:\\':^i4,.;ilU>-:\\'.\\'.:\\'-;\\'::\\' ��! �-��� \\'\\'\" j,�. - A\\'.-\\'   � *u*oiu�>Vt.�.v\\'- � ----;\\' �-\\'���    -   f     \\'.\\' \\\\   \\'    M..    -\\'�i\\'l.....i .-�\\'\\'_\\' I\\'    ..i-1-    17  I    Confidential    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024216 MNK-T1 0000283091     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19 20 of 26.  PagelD #: 127768    18   I    Confidential    .    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    I    MAL-MI 000024217 MNK-T1 0000283092     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19 21 of 26.  PagelD #: 127769    DEA Florida Pain Clinic Raids    Florida Sun Sentinel    3:54 p.m. EST. February 23. 2011    Drug investigators raided an untold number of pain clinics from Miami to West Palm Beach on Wednesday,    arresting doctors and clinic owners in the biggest single strike at Florida\\'s pain pill industry. Hundreds of officers from federal, state and local agencies fanned out in an orchestrated sweep that shut down    some of the busiest and best known pain clinics in Broward, Palm Beach and Miami-Dade counties, said    officials who spoke on the condition of anonymity. In Delrav Beach, police arrested Dr. Zvi Harry Perper, the son of Broward Medical Examiner Dr. Joshua Perper, at    Delray Pain Management, 201 N. Swinton Ave. Zvi Perper is listed as the owner of the clinic, which is run by    manager Kenneth Murry, who opened it in early 2009. In Oakland Park, a half dozen medical personnel in scrubs were handcuffed and arrested at a high-volume clinic    called Commercial Medical Group, 291 E. Commercial Blvd. Arrests also were made at by agents raiding 45th Street Medical in Lake Worth, which is owned by Dr. Robert    Elessar, federal officials said. Agents raided many more locations, seizing records as part of ongoing    investigations. \"We\\'re so happy all this is happening,\" said Julie DePasquale, a clerk at German Bread Haus two doors from the    Oakland Park clinic. She said it is popularwith out-of-state pill seekers. \"I\\'ll feel safer coming to work at 7    o\\'clock in the morning. The druggies are out there like the night of the living dead, waiting for that place to    open. It\\'s scary.\" The raids were led by agents from the U.S. Drug Enforcement Administration, the Broward Sheriffs Office, the    Palm Beach County Sheriffs Office and police departments from the state and cities. Florida Department of    Health inspectors were on hand to initiate disciplinary actions against clinic doctors and owners.    Confidential    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024218 MNK-T1 0000283093     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19 22 of 26.  PagelD #: 127770    SOM Distributor Audit Next Steps    Work with Finance to synchronize In/Out Distributor Chargeback Audits    Revise Customer Checklists (sent by Customer Data Integrity/CDIG to all accounts)    Work with CDIG on policy matters    Will continue to communicate with Commercial Group    20   |    Confidential �    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024219 MNK-T1 0000283094     Case: l:17-md-02804-DAP Doc #: 1957-33 Filed: 07/23/19 23 of 26. PagelD #: 127771    Feedback Received    Distributors                                                                                                                             |it;    Positive feedback and full audit cooperation from Keysource, Masters, Cedardale       \\'*TJ&& H.D. Smith, Amerisource Bergen, McKesson, Quest, and others volunteering for audits    DEA St. Louis    Agency looks to Mallinckrodt as the leader in industry to be the leader in SOM Review of Company record keeping systems to incorporate into SOM is a great benefit    DEA Albany    Appreciated the visit by Mallinckrodt to explain SOM initiatives    DEA Washington DC    Granted 3,900 kg AA Oxycodone Quota for Hobart 12/13/10 (3,900 kg AA requested 10/14/10) Will be training Manufacturing Registrants on DEA SOM expectations    DEA Industry Consultant    Mallinckrodt has taken a brave and bold step within industry to upgrade SOM program    21    Confidential    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024220 MNK-T1 0000283095     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19  24 of 26.  PagelD #: 127772    Pharmacy 54 Empty Mallinckrodt Oxycodone Pill Bottles - eBay (item 280580022565 en... Page I of 6    ebVX    Figly breaslcencer StH.ejy.wo.>    Ustafm category: Cralts > HuluPurpose Croft Supplies > Ditpay S Storage    (^eSay Buyer Protection Lea    Pharmacy 54 Empty Mallinckrodt Oxycodone Pill Bottles    blask.fl (267 >V) F^^prp^j    llemcontllllon: Used IYv A::Y\\'ft/fliiz:;.J\\'/i            Timelefl: 3d05h(Oct31.201017X15:17PDT)    \"\".\\'.ys-LLci -1\\'It\\'-\\'.        Bidhistoiy; 0bids    j,;:-;.-.r.\\'Y,Hri\\'.^v;           SlariingbW:  US$0.99    ,,Mfffr--:WX    i �x4 eBay Buyer Protection    // \\'\\'0,0,s I\"** Pu\\'fiase pm:e plus original shipping,    lean mote    Pharmacy 5ri Empty Mallinckrodt Oxycodone Pitt Boltlux - uBny (Hum 280580022565 cn�.   Page 3 of 6    W\"\\'M    J\\'-jV/i\\'i\\'il\\'i.i&Y-\\'. .:;� ;.;,\\'.Y,�\\'�\\'.�\"j!|iiihii..)i\\' \".���. u\\'.\\',-y�\\'..-i.:iv..\\'�\"i/i  .  :,r        f,\\'i<x<:-  �   J\\'    i-,:-:-4    iW!w\\'MWviw\\\\ \" x^lzlftliliniY\\'    V&W \\'\"\"\"�    , \\'��\\'.- \\'��\\'<� . �\" �- �,��\\'\"\\'.: C\\'.Y, �,^;;;^\\'Lv\\'<:i,Y\\'^<Y\\';>iZ\\'Y\\'> \\'(\\'\\'^\"-M    - -\\' :     \\'    \\'�    :.\\'�� y.:�...-.� .,/   .\\'-.\\'-vx-    ,;\\'\\'(\\',.,,\\'..*>iylt.�>�.*�.�_\\' ��:;�:�>.\" If     \\'  \";.\\'V\" �\"\\' \"�\\' �\\'\"!.� .\\' v.\"\\':\":-: .\"!�:2\\'v\\\\\".P\\':r.,,.;: < , �.\\'�K\\\\j.#\\';:\\':\"\\'T\\' J-\\'****    .\\'       * ,,,. ,, �                   \\'.,        \\'      � \\'  V.........          � U,   .        J\\'       *.*;    {v.!\".:\\':   . ;\\'- \\'\\'�>:\" \\'�.��\\'-� � \"�\\'\\'? �^V\\'i T **<�?\\'  *<&�$*<}�/ W,m    ^      \\'  �                           1.. ^au.PJk.\\'CL^.^. .\\'-_.\\'- . **?>\\'  *.\\'VI-.(- It     /SWJtL1 .                           .  .-aT**!.     _   ti.AAtii\\'.A, > \\'.I riSui. .5    ^iMyft\\'\\'aSJrZ\\'.^�^U\\'J6U.y/Ui-4 , \\\\fiAto..\\'i\\'. �   y\\'g**\\'1-   T-.l-o^LJ-.^.    ijiua.P    You are bidding on 54 cleaned used empty pill bottles with 54 child safety caps/lids.    Dimensions:    2 and 6/16\" tall with cap, 2 and 3/16\" tall w/o cap. 1 and 7/16\" diameter, 13/16\" mouth.    hllp//cnJ.cbay.com/w5/cBaylSAPI.dll?Viewiicm&item-2a0S80022SfiSeixi=D4v3eSX0l...    10/28/2010    22   |    Confidential .     CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024221 MNK-T1 0000283096     Case: l:17-md-02804-DAP Doc #: 1957-33 Filed: 07/23/19 25 of 26.  PagelD #: 127773    Fentanyl Transmucosal Product Tampering    23   |    joun.is                                    ncwuiMitn    part {�# m\"�*\" .\"��Jr \\'\\'\\'<�� vm� <rjM.tr- uri n tHtaar. >. wrhar    U    cqiMMfcot to flOO ITICC| \\'titiji.ylUnti    rrVainratj Me� ba keJiii *mi*.u|    (V\"J\" /  tHrMl*iLlrtt<*J�v>,ubJ.* y    lta<>�i��<(\\'jiirii>�.|WiBA    ^^:^1*?tt    q t^Usi^mtbmtf Stntni^inlM^^    MM        A,CV�lMMSMhl�^�aOia�HtodSM^tW>WM�M    It  tt�n   Protet   W   tt(                       X <S,-    -^..._.j.    ..\\'.    -~�.    2123    .Afi * .\\'/.    FiY:;i;;;\\';i:\\'vz;:YY;>Y?-zY4ttL^:Ge;ZYY\\'/3    v1\\'\\',\\'-1!\\'!;�!.\\'�\\' y\":\\'v,-/*\\'i:Y,jv.y.\\'.\\'i.\\'\\'1 {YYij/S\\'Y\\'\"\\'\\'\\'\\'\\'\\'\\'^\\'-\\'it    III! !ir)Y.H\\').;V;\\\\: �>\\':��\\'�<�\\':W\\'WK.}< TMVW^PwWWWMkwWxwW^l    UwvWM^WxwzrwWy\\'- xww-zwwv.wWwwwwiVWXpx^M\\\\ jjj;jf|jJ!!P\\'^    ,................,..., 5j^::/^    l:-\\'.:\\'.,ulY,a;t/ii\\'ifci.;i.i.\\'--\\'\\';^ilY:jYj:\\'.4Yi/>i,\\'iu:\\',Y, i:i.\\'r\\'.U6.\\'iJf,\\'i;i:\\'*.\\'\\'\\'iY:,\"i.i.L!....\\'r:ilirpa.\\':8\\',.c.V/\\'i:2..ji\\'..<    i.Vi.\\'.i:-!-, \\'/.\\'v;    iv,;\\'.:.-.-;,Vc\":.;� �\\'�\"   \\'\".......    .^v\\'c;-Y\\':\\'/;:\"v.\\'\\'\\'\"    rfoTMi/Tjt^P\\'L^f JM|f\"\\'JW.�?Tin^^    r,. vrm;    Confidential    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024222 MNK-T1 0000283097     Case: l:17-md-02804-DAP  Doc #: 1957-33  Filed:  07/23/19 26 of 26.  PagelD #: 127774    z^^^/^^^^^: J \"\\'\"\\' 1    i?s^&:$^                   -J    Mpa^Z\\' V%^\\'3(� J?&*^$^^    . >-,   >:=^SA\\'*^-f!^:^*\\'%. (4\\\\ \\' j>x____.    �<v**\\'~f.   \\'.\"J  �\\'.\\'\"�   r*\"\"\"^! >�:...�/\\'.:,�.\\'!  .%4.   J    1^SpiL.V\\'\\'r ���\"�\\'i\\'^ilai^si^i.-^Yj.-.F I    24   I    Comments, Feedback, Questions    Thank you for your time    Confidential i    CONFIDENTIAL�SUBJECT TO PROTECTIVE ORDER    MAL-MI 000024223 MNK-T1 0000283098 '"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['ocr_text'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "347cb115",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'mgyc0230'"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['id'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "95c1e3f6",
   "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.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}