Analysis of counts in four counties.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "r4YClOh81xIu"
   },
   "source": [
    "# Comparision of Pro Se cases by county"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "5LBBUqGyJQ8Q"
   },
   "source": [
    "### Set up environment"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 213
    },
    "colab_type": "code",
    "id": "bpG2zPdyJNtf",
    "outputId": "bc9f2919-8c18-4b9a-95eb-fa50eb13d21b"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: oscn==0.0.0.25 in /Users/owner/projects/cft/oscn (0.0.0.25)\n",
      "Requirement already satisfied: requests in /Users/owner/projects/python_envs/oscn/lib/python3.6/site-packages (from oscn==0.0.0.25) (2.19.1)\n",
      "Requirement already satisfied: beautifulsoup4 in /Users/owner/projects/python_envs/oscn/lib/python3.6/site-packages (from oscn==0.0.0.25) (4.6.0)\n",
      "Requirement already satisfied: urllib3<1.24,>=1.21.1 in /Users/owner/projects/python_envs/oscn/lib/python3.6/site-packages (from requests->oscn==0.0.0.25) (1.23)\n",
      "Requirement already satisfied: chardet<3.1.0,>=3.0.2 in /Users/owner/projects/python_envs/oscn/lib/python3.6/site-packages (from requests->oscn==0.0.0.25) (3.0.4)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in /Users/owner/projects/python_envs/oscn/lib/python3.6/site-packages (from requests->oscn==0.0.0.25) (2018.4.16)\n",
      "Requirement already satisfied: idna<2.8,>=2.5 in /Users/owner/projects/python_envs/oscn/lib/python3.6/site-packages (from requests->oscn==0.0.0.25) (2.7)\n"
     ]
    }
   ],
   "source": [
    "!pip install oscn==0.0.0.25\n",
    "\n",
    "import oscn"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "SpYkP0g316dT"
   },
   "source": [
    "### Set up the OSCN information needed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "ePxYAgknPIYw"
   },
   "outputs": [],
   "source": [
    "\n",
    "years = ['2017','2018']\n",
    "counties = ['mayes', 'love','rogers','delaware']\n",
    "types =['CM','CF']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Request the cases from OSCN and save as files\n",
    "This takes a couple hours"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 623
    },
    "colab_type": "code",
    "id": "901XB5X2PLMQ",
    "outputId": "0a055488-40dd-4cd3-ce7e-6fbc8f3925e6"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "data/CF.mayes.2018.oscn: 270\n"
     ]
    }
   ],
   "source": [
    "import pickle\n",
    "\n",
    "\n",
    "for county in counties:\n",
    "  for year in years:\n",
    "    for type in types:      \n",
    "      cases=oscn.request.CaseList(type=type, year=year,county=county)\n",
    "      all_cases = [c for c in cases]\n",
    "      file_name = f'data/{type}.{county}.{year}.oscn'\n",
    "      f = open(file_name, 'wb')\n",
    "      pickle.dump(all_cases, f)\n",
    "      f.close()\n",
    "      print(f'{file_name}: {len(all_cases)}')\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Retrieve the saved files"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 237
    },
    "colab_type": "code",
    "id": "qVsbnkB-1v6T",
    "outputId": "80d17652-1b74-4cc6-b8a6-6b611e3a1bfe"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "data/CM.mayes.2017.oscn added 632\n",
      "data/CF.mayes.2017.oscn added 425\n",
      "data/CM.mayes.2018.oscn added 371\n",
      "data/CF.mayes.2018.oscn added 270\n",
      "data/CM.love.2017.oscn added 767\n",
      "data/CF.love.2017.oscn added 305\n",
      "data/CM.love.2018.oscn added 565\n",
      "data/CF.love.2018.oscn added 204\n",
      "data/CM.rogers.2017.oscn added 1114\n",
      "data/CF.rogers.2017.oscn added 1060\n",
      "data/CM.rogers.2018.oscn added 884\n",
      "data/CF.rogers.2018.oscn added 555\n",
      "data/CM.delaware.2017.oscn added 936\n",
      "data/CF.delaware.2017.oscn added 439\n",
      "data/CM.delaware.2018.oscn added 713\n",
      "data/CF.delaware.2018.oscn added 337\n",
      "counted case: 9577 length saved 9577\n"
     ]
    }
   ],
   "source": [
    "import pickle\n",
    "\n",
    "\n",
    "saved_cases = []\n",
    "\n",
    "case_count =0 \n",
    "\n",
    "for county in counties:\n",
    "  for year in years:\n",
    "    for type in types:      \n",
    "      file_name = f'data/{type}.{county}.{year}.oscn'\n",
    "      new_cases = pickle.load(open(file_name, 'rb'))\n",
    "      new_case_count = len(new_cases)\n",
    "      case_count += new_case_count\n",
    "      print(f'{file_name} added {new_case_count}')\n",
    "      saved_cases += new_cases\n",
    "        \n",
    "print(f'counted case: {case_count} length saved {len(saved_cases)}')\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Create a pandas dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 35
    },
    "colab_type": "code",
    "id": "gbDCRWzhxVSh",
    "outputId": "a61c3a75-95c9-4c5f-d15f-94a051809a45"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CPU times: user 1min 10s, sys: 118 ms, total: 1min 10s\n",
      "Wall time: 1min 10s\n"
     ]
    }
   ],
   "source": [
    "import re\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "from datetime import datetime\n",
    "\n",
    "columns = ['Filed','County','Type','Judge','Case Number', 'Pro_Se','Source']\n",
    "\n",
    "# this function determines if a case is Pro Se or not\n",
    "pro_se_re = re.compile(r'(waive.*right.*attorney|represented.*pro se)', re.I | re.M)\n",
    "\n",
    "def is_pro_se(case):\n",
    "# First see if the Pro Se test is anywhere on the page to speed up processing\n",
    "    if pro_se_re.search(case.text):\n",
    "        if case.docket:\n",
    "            for minute in case.docket:\n",
    "                if pro_se_re.search(minute.description):\n",
    "                    return True\n",
    "    return False\n",
    "\n",
    "\n",
    "case_data = lambda c: [c.filed, c.county, c.type, oscn.parse.judge(c.text),  c.case_number, is_pro_se(c), c.source]\n",
    "%time all_cases = pd.DataFrame([case_data(c) for c in saved_cases], columns = columns)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Basic Reports"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>Filed</th>\n",
       "      <th>County</th>\n",
       "      <th>Type</th>\n",
       "      <th>Judge</th>\n",
       "      <th>Case Number</th>\n",
       "      <th>Pro_Se</th>\n",
       "      <th>Source</th>\n",
       "      <th>FiledDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-01-03</td>\n",
       "      <td>mayes</td>\n",
       "      <td>CM</td>\n",
       "      <td>UNASSIGNED</td>\n",
       "      <td>CM-2017-1</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.oscn.net/dockets/GetCaseInformatio...</td>\n",
       "      <td>2017-01-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-01-03</td>\n",
       "      <td>mayes</td>\n",
       "      <td>CM</td>\n",
       "      <td>UNASSIGNED</td>\n",
       "      <td>CM-2017-2</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.oscn.net/dockets/GetCaseInformatio...</td>\n",
       "      <td>2017-01-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-01-04</td>\n",
       "      <td>mayes</td>\n",
       "      <td>CM</td>\n",
       "      <td>UNASSIGNED</td>\n",
       "      <td>CM-2017-3</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.oscn.net/dockets/GetCaseInformatio...</td>\n",
       "      <td>2017-01-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-01-04</td>\n",
       "      <td>mayes</td>\n",
       "      <td>CM</td>\n",
       "      <td>UNASSIGNED</td>\n",
       "      <td>CM-2017-4</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.oscn.net/dockets/GetCaseInformatio...</td>\n",
       "      <td>2017-01-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-01-04</td>\n",
       "      <td>mayes</td>\n",
       "      <td>CM</td>\n",
       "      <td>UNASSIGNED</td>\n",
       "      <td>CM-2017-5</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.oscn.net/dockets/GetCaseInformatio...</td>\n",
       "      <td>2017-01-04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Filed County Type       Judge Case Number  Pro_Se  \\\n",
       "0 2017-01-03  mayes   CM  UNASSIGNED   CM-2017-1   False   \n",
       "1 2017-01-03  mayes   CM  UNASSIGNED   CM-2017-2   False   \n",
       "2 2017-01-04  mayes   CM  UNASSIGNED   CM-2017-3   False   \n",
       "3 2017-01-04  mayes   CM  UNASSIGNED   CM-2017-4   False   \n",
       "4 2017-01-04  mayes   CM  UNASSIGNED   CM-2017-5   False   \n",
       "\n",
       "                                              Source  FiledDate  \n",
       "0  https://www.oscn.net/dockets/GetCaseInformatio... 2017-01-03  \n",
       "1  https://www.oscn.net/dockets/GetCaseInformatio... 2017-01-03  \n",
       "2  https://www.oscn.net/dockets/GetCaseInformatio... 2017-01-04  \n",
       "3  https://www.oscn.net/dockets/GetCaseInformatio... 2017-01-04  \n",
       "4  https://www.oscn.net/dockets/GetCaseInformatio... 2017-01-04  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# convert the date from a string to a ptyhon DateTime type\n",
    "all_cases['FiledDate'] = pd.to_datetime(all_cases['Filed'])\n",
    "all_cases.head()\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Count of all cases by county and type in 2017 and 2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "County    Type\n",
       "delaware  CM      1574\n",
       "          CF       851\n",
       "love      CM      1332\n",
       "          CF       509\n",
       "mayes     CM      1003\n",
       "          CF       695\n",
       "rogers    CM      1998\n",
       "          CF      1615\n",
       "Name: Type, dtype: int64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_cases.groupby(['County'])['Type'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Count of Pro Se cases by county in 2018 and 2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "County    Pro_Se\n",
       "delaware  False     2117\n",
       "          True       308\n",
       "love      False     1841\n",
       "mayes     False     1698\n",
       "rogers    False     3596\n",
       "          True        17\n",
       "Name: Pro_Se, dtype: int64"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_cases.groupby(['County'])['Pro_Se'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Count of Pro Se cases by county, judge and type in 2018 and 2017\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "Z7AAKuj8EGcq"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "County    Judge                Type\n",
       "delaware  DENNEY, BARRY        CM       15\n",
       "          HANEY, ROBERT G      CM       10\n",
       "          LITTLEFIELD, ALICIA  CM      259\n",
       "                               CF       11\n",
       "          UNASSIGNED           CM       13\n",
       "rogers    CROSSON, TERRELL S   CM        2\n",
       "          STEIDLEY, J          CF       15\n",
       "Name: Type, dtype: int64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pro_se_cases = all_cases.query(\"Pro_Se == True\")\n",
    "pro_se_cases.groupby(['County','Judge'])['Type'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Graph of Pro Se case count by judge in 2018 and 2017"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x11d399c88>"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAFeCAYAAACLndSwAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAIABJREFUeJzt3XmYZGV99vHvzSIgIIuMBAEdIMi+6YgLmFfg1YDRABpZNIIJZjSBBFyDS8TEQDAiGhUxGBUwEcRXUUyIQkAleKkwA8gygzqyzsgyAhHcMMD9/nFOMTVNd/VWVafO0/fnuvrqs1R1/Yqh7zr9nGeRbSIiolxrNF1AREQMVoI+IqJwCfqIiMIl6CMiCpegj4goXII+IqJwCfqIiMIl6CMiCpegj4go3FpNFwCw2Wabef78+U2XERHRKosXL/6Z7XmTPW4kgn7+/PksWrSo6TIiIlpF0u1TeVyabiIiCpegj4goXII+IqJwCfqIiMIl6CMiCpegj4goXII+IqJwCfqIiMIl6CMiCjcSI2Nnav6J/zHU17vt1D8Y6utFRPRDrugjIgqXoI+IKFyCPiKicAn6iIjCJegjIgqXoI+IKFyCPiKicAn6iIjCJegjIgqXoI+IKNykQS9pa0nflLRE0k2Sjq+Pv0/SCknX1V8v63rOOyUtk/RDSb8/yDcQERG9TWWum0eAt9q+RtKGwGJJl9bnPmz7tO4HS9oZOALYBXg68F+SnmX70X4WHhERUzPpFb3tu2xfU28/BCwFtuzxlIOB820/bPtWYBmwdz+KjYiI6ZtWG72k+cBewPfrQ8dJul7SZyRtUh/bEriz62nL6f3BEBERAzTloJe0AfAl4ATbDwJnAtsBewJ3AR+azgtLWihpkaRFK1eunM5TIyJiGqYU9JLWpgr5f7P9ZQDb99h+1PZjwKdY1TyzAti66+lb1cdWY/ss2wtsL5g3b95s3kNERPQwlV43Aj4NLLV9etfxLboedihwY719EXCEpHUkbQNsD1zVv5IjImI6ptLrZh/gdcANkq6rj70LOFLSnoCB24A3Ati+SdIFwBKqHjvHpsdNRERzJg1621cCGufUxT2eczJw8izqioiIPsnI2IiIwiXoIyIKl6CPiChcgj4ionAJ+oiIwiXoIyIKl6CPiChcgj4ionAJ+oiIwiXoIyIKl6CPiChcgj4ionAJ+oiIwiXoIyIKl6CPiChcgj4ionAJ+oiIwiXoIyIKl6CPiChcgj4ionAJ+oiIwiXoIyIKl6CPiChcgj4ionAJ+oiIwiXoIyIKl6CPiChcgj4ionAJ+oiIwiXoIyIKN2nQS9pa0jclLZF0k6Tj6+ObSrpU0o/r75vUxyXpo5KWSbpe0rMH/SYiImJiU7mifwR4q+2dgecDx0raGTgRuMz29sBl9T7AQcD29ddC4My+Vx0REVM2adDbvsv2NfX2Q8BSYEvgYOCc+mHnAIfU2wcD57ryPWBjSVv0vfKIiJiSabXRS5oP7AV8H9jc9l31qbuBzevtLYE7u562vD429mctlLRI0qKVK1dOs+yIiJiqKQe9pA2ALwEn2H6w+5xtA57OC9s+y/YC2wvmzZs3nadGRMQ0TCnoJa1NFfL/ZvvL9eF7Ok0y9fd76+MrgK27nr5VfSwiIhowlV43Aj4NLLV9etepi4Cj6+2jga92HT+q7n3zfODnXU08ERExZGtN4TH7AK8DbpB0XX3sXcCpwAWSjgFuBw6rz10MvAxYBvwK+JO+VhwREdMyadDbvhLQBKcPGOfxBo6dZV0REdEnGRkbEVG4BH1EROES9BERhUvQR0QULkEfEVG4BH1EROES9BERhUvQR0QULkEfEVG4BH1EROES9BERhUvQR0QULkEfEVG4BH1EROES9BERhUvQR0QULkEfEVG4BH1EROES9BERhUvQR0QULkEfEVG4BH1EROES9BERhUvQR0QULkEfEVG4BH1EROES9BERhUvQR0QULkEfEVG4SYNe0mck3Svpxq5j75O0QtJ19dfLus69U9IyST+U9PuDKjwiIqZmKlf0ZwMHjnP8w7b3rL8uBpC0M3AEsEv9nE9IWrNfxUZExPRNGvS2rwDun+LPOxg43/bDtm8FlgF7z6K+iIiYpdm00R8n6fq6aWeT+tiWwJ1dj1leH4uIiIbMNOjPBLYD9gTuAj403R8gaaGkRZIWrVy5coZlRETEZGYU9Lbvsf2o7ceAT7GqeWYFsHXXQ7eqj433M86yvcD2gnnz5s2kjIiImIIZBb2kLbp2DwU6PXIuAo6QtI6kbYDtgatmV2JERMzGWpM9QNJ5wIuBzSQtB04CXixpT8DAbcAbAWzfJOkCYAnwCHCs7UcHU3pEREzFpEFv+8hxDn+6x+NPBk6eTVEREdE/GRkbEVG4BH1EROES9BERhUvQR0QULkEfEVG4BH1EROES9BERhUvQR0QULkEfEVG4BH1EROES9BERhUvQR0QULkEfEVG4BH1EROES9BERhUvQR0QULkEfEVG4BH1EROES9BERhUvQR0QULkEfEVG4BH1EROES9BERhUvQR0QULkEfEVG4BH1EROES9BERhUvQR0QULkEfEVG4SYNe0mck3Svpxq5jm0q6VNKP6++b1Mcl6aOSlkm6XtKzB1l8RERMbipX9GcDB445diJwme3tgcvqfYCDgO3rr4XAmf0pMyIiZmrSoLd9BXD/mMMHA+fU2+cAh3QdP9eV7wEbS9qiX8VGRMT0zbSNfnPbd9XbdwOb19tbAnd2PW55fSwiIhoy65uxtg14us+TtFDSIkmLVq5cOdsyIiJiAjMN+ns6TTL193vr4yuArbset1V97Alsn2V7ge0F8+bNm2EZERExmZkG/UXA0fX20cBXu44fVfe+eT7w864mnoiIaMBakz1A0nnAi4HNJC0HTgJOBS6QdAxwO3BY/fCLgZcBy4BfAX8ygJojImIaJg1620dOcOqAcR5r4NjZFhUREf2TkbEREYVL0EdEFC5BHxFRuAR9REThEvQREYVL0EdEFC5BHxFRuAR9REThEvQREYVL0EdEFC5BHxFRuAR9REThEvQREYVL0EdEFC5BHxFRuAR9REThEvQREYVL0EdEFC5BHxFRuAR9REThEvQREYVL0EdEFC5BHxFRuAR9REThEvQREYVL0EdEFC5BHxFRuAR9REThEvQREYVL0EdEFG6t2TxZ0m3AQ8CjwCO2F0jaFPgCMB+4DTjM9gOzKzMiImaqH1f0+9ne0/aCev9E4DLb2wOX1fsREdGQQTTdHAycU2+fAxwygNeIiIgpmm3QG7hE0mJJC+tjm9u+q96+G9h8vCdKWihpkaRFK1eunGUZERExkVm10QP72l4h6WnApZJu7j5p25I83hNtnwWcBbBgwYJxHxMREbM3qyt62yvq7/cCFwJ7A/dI2gKg/n7vbIuMiIiZm3HQS1pf0oadbeClwI3ARcDR9cOOBr462yIjImLmZtN0szlwoaTOz/m87a9Luhq4QNIxwO3AYbMvMyIiZmrGQW/7FmCPcY7fBxwwm6IiIqJ/MjI2IqJwCfqIiMIl6CMiCpegj4goXII+IqJwCfqIiMIl6CMiCpegj4goXII+IqJwCfqIiMIl6CMiCpegj4goXII+IqJwCfqIiMIl6CMiCpegj4goXII+IqJwCfqIiMIl6CMiCpegj4goXII+IqJwazVdQPTwvo2G/Ho/H+rL7XbObkN9vRuOvmGorxcxKnJFHxFRuFzRRwzI0h13Gtpr7XTz0qG9VrRPrugjIgqXK/qImLYz3nT5UF/v2E/uP9TXK02u6CMiCpegj4goXII+IqJwAwt6SQdK+qGkZZJOHNTrREREbwMJeklrAmcABwE7A0dK2nkQrxUREb0NqtfN3sAy27cASDofOBhYMqDXi4jomw8d/vKhvt5bv/DvA/35g2q62RK4s2t/eX0sIiKGTLb7/0OlPwIOtP2Gev91wPNsH9f1mIXAwnp3B+CHfS9kYpsBPxvi6w1b3l97lfzeIO+v355pe95kDxpU080KYOuu/a3qY4+zfRZw1oBevydJi2wvaOK1hyHvr71Kfm+Q99eUQTXdXA1sL2kbSU8CjgAuGtBrRUREDwO5orf9iKTjgG8AawKfsX3TIF4rIiJ6G9hcN7YvBi4e1M+fpUaajIYo76+9Sn5vkPfXiIHcjI2IiNGRKRAiIgqXoI+IKNycDXpJmzddw2xJuljS/KbrGBRJm/b4Wr/p+mLukvRMSRt17e8n6Z8kvaXuaThS5lTQS9pY0jGSLgOubbqePvgscImkd0tau+liBmAxsKj+PvbrZkl3Snptg/XFBOrfs7d37a+Q9KCkhyS9qcna+uQCYH0ASXsCXwTuAPYAPtFgXeMq/maspPWo5tl5DbAXsCFwCHCF7cearK0fJG0A/A1wIPA54PH3ZPv0puoaBknzgG/bbu2EeZJ2oBohvmN9aCnwKdvDHCned5Kuphodf1+9f63tvSStC3zD9v9ptsLZkXS97d3r7dOAx2y/Q9IawHWdc6Oi6Ct6SZ8HfgS8BPgYMB94wPa3Sgj52m+BXwLrUH2IdX8VzfZK4K+brmOmJL0A+BbwEFW3vE9R/Vt+U9LzGyytH9QJ+doXAWz/BlivmZL6Sl3b+wOXAYxqrpS+ZuzOwANUV0lLbT8qqZg/YSQdCJxONer42bZ/1XBJQ2f7a03XMAvvBY60/a2uY1+RdDlwEtU03221cfeO7VMA6ivezRqpqL8ul3QBcBewCXA5gKQtqC6+RspcaLrZETgSOJxqsqEdgF1t39NoYX0g6b+BN2XUcTtJ+pHtZ01w7oe2dxh2Tf0i6RPA/bbfM+b43wOb2W51O70kUWXKFsAFtlfUx/cCnmb7G03WN1bxQd9N0nOo2upfDSy3/cKGSxoISRsDx9o+uelaYmKSFtt+zgTnrrH97GHX1C91r6h/AZ4L/KA+vAfVzfU32P5FU7XNRXMq6DvqT+MX2b6i6VpmQ9LWwHuo5vr/CnAe8HfA64DzbB/fYHkDI2lpvXmG7Y83WswsSLoXOH+8U8BhtkvoArwtsEu9u8T2T5qsZ64quo1e0seAXp9krQ564Fzg28CXqXrdLAKuA3a3fXeThQ2S7Z0kPRVo+w3Lt/c4t2hoVQxQvcrcLU3XMdcVfUUv6ehe522fM6xaBkHSD2zv0bW/HHjGqN75ny5JZwJ/bfvBpmsZNklr2X6k6Tpi+iR9wfbhTdfRregreuALwIZ1N7zH1f2vH2qmpP6StAmrunrdB2xUN01h+/7GCuuPW4DFkk6y/fmmi+k3SVfa3rfe/pzt13Wdvgpocxv9XP6gekHTBYxVetB/FPg6VdNGt32BlwJ/PvSK+msjqlGi3X16r6m/G9h26BX1ke0P1mMhTpd0DHAmqw8IG/vv2jbd0zjsMuacaLdWf1CVpvSgf47thWMP2r6w7ubVarbnN13DoNleIek/gJOBV7Aq6M0TP8Dbple7advbVNv+QdWTpIk+xASM3HQkpQf9k3ucK3ZUsKRnAW+3/WdN1zIbknahuor/KbC37bsaLqnfNpZ0KNX/ixtLemV9XFR/rbXZPElvmehkAdNzfKjHuZuHVsUUlR7090ra2/ZV3QclPRdYOcFzWkPS7sBpwNOpuleeAXwceB69/0dsi/8HHG/7kqYLGZBvA3/Ytf2KrnNt7xG2JrABhV7Z295vonOSnjfMWqai9F43e1PNMnc2VVs2wALgKOAI299vqLS+kPR9qive71J1r3wXcA7w3npOkVaTtJPtpfX2OrYf7jr3fNvfa6666KXtA75mQ9Idtp/RdB3dig56eHze+b8Adq0P3QR83Pa9zVXVH5Kus71n1/4ttlt9A7Zbd1iMDY4SgkTSUT1O2/bnhlZMn3Vmq2y6jiZIutP21k3X0a30phvqOW1OarqOAVm3nluj8+fxw937tq+Z8JntoAm2x9tvo+dOcPwPqUY7tzbogQPGOzhHpucYuavnooNe0g2M/x9dVFdMIzVn9AzcRTV7ZcfdXfummj61zTzB9nj7rWP7Lzvb9diH11JNu/w9ql5Gbba+pFNZdf9otek5miysHyR9jYmz5alDLmdSRTfdSHpmr/O2bx9WLcMmaW3b/9t0HbPRNRdMZ6bAzrwwJc0FsxbweuBtVAH/D21fdARA0jepbjB37h8dSDU9x5tLmJ5DUs+FU2x/e1i1TEXRQd+LpO/Y3qfpOvqpvircn2qGzpe3PQjnwBQWxwLHUy1a8QHbtzVbUf/Mgek5njLR1BySnmH7jmHX1MtcDvqRu2EyU/VqRK+hWiJxU+BY4CLbDzRa2ABJOs3225quYzYkPQbcS9XVt/sXsfVNi5J+ALyYVfdSvtm93/bpOcZ0FLjM9gHjnRsVRbfRT6L1n3CSTqGaW/8OqnbPvwUWtf1Kd4oOo2ruaLNtmi5ggIqenoPV39emPc6NhKKDvmuk4RNOUca6lW+gWhP3TOBrth8uaanESYzcL9N0lXyPaA5Mz9GqjgJFBz2rjzQc69+HVsXgbEG18PmRwEfqG2DrlTJzoKSxV0qPn6KAoK8natvU9gfr/RVUi7qLagqLTzZZ32xI+mPb/1pv72P7O13njmvzgjG1p9VTPKhrm3p/XnNljW8ut9FvXsK6sR2S1gFeThX6LwIus/2aZquaHUm3Ul0djRfqbvvgMElXAwfavq/ev9b2XpLWBb5hu2fPjlE2Bwa79RybY/tvh1XLVJR+Rb+aerDGq6huXO5E1ce3CPX0AF8CviRpQ+DQhkuaNdslt2FDdaF1X9f+FwFs/0ZS25sWix7s1ivI6/VyR0rxQV//whxMFe57Uf1pfAjtnzQKeLw/7wO2r5d0GPB7wE+ATzRbWX/U/cwPAnasDy2hutptfdMUsHH3ju1TACStAWzWSEX906o27JmQtCVV8+n1tn8r6WnACVTjIkbqIrLoppt60YoXAZdQDba5HFhWypWipDOA3YF1qG7KbkC10Mo+wBq2X9tgebNW/yJdTjUC+FqqK8G9gN8B9rP90wbLmzVJnwDut/2eMcf/HtjM9puaqWz2JP0KWEb1b7ZdvU29v63tkbvqnQ5JJwDvpnpf61BdWH2Aah3nfxy1KbVLD/rrqOb6Phc43/bykib+krTE9s51m+4K4Gm2H60HTl1ve7eGS5wVSWcD19n+yJjjf0W1qEzPAVWjrv4T/1+o5rz5QX14D6qFwd9g+xdN1TZbpY9Kl7QE2Nf2/ZKeQXWhtY/txZM8tRFFN93Y3lPSjlQ3KP9L0s+ADQu6EfsbeLxN93bbj9b7ltTq6Q9qz7f9+rEHbX9UUuunCbD9S+BISduyainBJbZ/0mBZfTFekEvaDLjPZVxd/qYz6Mv2HZJ+OKohD4UHPYDtm6lmrzxJ0nOoQv9qScttv7DZ6matVV28ZuDXPc79amhVDMiY5ehW1N836hxv8+yj9WjtU4H7gfdTzcS5GbCGpKNsf73J+vpgK0kf7drfonvf9l81UNOEim66mUjdtPEi262+Idu2Ll7TJekWxh/9Kqp20O2GXFJf1eMeJmLbrZ19VNIiqoVwNgLOAg6y/b36L+zz2j5XfdvmYZqTQR/tIOmzvc7b/pNh1RLT070ojqSltnfqOlf0oiSjOKlZ8U030V6lB7mqtYvv7EzbW6849SrgduB9LZ/4q3uWyrFNcEVcXUp6AdUCMVfYvlfVGs4nUvX0G6kJE3NFHyOr657DuGyf3uv8qJN0DfB/654bv0fVBfgvgT2BnWz/UaMFzoKkR4FfsmpeqV+zapTzurbXbrC8WZP0QaqR6NcBvwt8g2ruqX8A/tkjtmbznLyil3QwcLdbvjj4HLBh0wUM2JpdV+2HA2fZ7oxuvq7BumbN9ppN1zBgfwDsVfd42wS4E9h1VNcUmJNBDzwP2K2e/Ougpovpt1I+yNp+M3kK1uyagO4AYGHXuSJ+NyXtx6quozfa/laD5fTTbzpX7bYfkPTjUQ15KOR/pumy/a6maxiwIj7IJF1g+7B6+wO2/7rr3CW2X9pcdX1xHvDtenzHr4H/BpD0u8DPmyxstupRzV+mGuvR6V/+6npKkkNtr5jwye2wraSLuva36d63/YcN1DSh4tvoJT2Vap6bzlwpS6m6d9038bPaoddyZiXo7p0xzgyIRfTcqPubbwFcUg+gQtKzgA1a3o/+QuCrts8ec/wo4FW2D26ksD5Ry9aMLfqKXtJOVHOlfINVc6U8F3iXpP3rwVRtdq2kd9s+f/KHtlKvq5DWX6FIejKw2PUi7pJ2AF4G3G77y40WN3s7237CDKq2z5X07iYK6rNrJ7rIqqdEGClrNF3AgL0fON72623/k+2P1POj/CVwcsO19cP+wOGSLq3/3C/NkyXtVY9oXq/efnZnv+ni+uDrwHx4vLnmu1RL7B0r6R8arKsfxs2WembOEm7UfquzIemyMee+MtxSJld00009/8QO0z3XNpIOAs4Grqar//KotRNO1yQjR7G937BqGQRJN3QmnpP0fqrVpo6V9CSqK/3WTkon6cNUs6me0NUktT7wYaobmSM1RcB0jWlWXK0ZcRSbFYtuuqHqxzuTc61R/7n/NqobeWew+kCVtnun7e81XcQAdV9l7Q98EKCe27zt/47voOpTfrukzgRnzwDOoZoaoe1aNd9+6UHfPdFXtyIm/ZJ0KtWiKm8uYJKo8XwCaPWSc5O4XtJpVBOa/S7VugmdldBarb7v8DZJf0P13gB+Yrv1k9HVWjWhYOlB/ykmHnTzL8MsZEAeoR600XQhA9L6Jecm8WfA8VTt9C/tCsGdgdOaKqqfbP8auKGzL+klwDtsv6S5qvqiO1vG5szIZUvRQd9rwE29QkzbPdgJeUmvtv3FzglJpxQwXmC1vsljtf0eRB2Cp45z6k6qVcJaS9L+wCepltT7CtXqS5+l+vAuoSPEfbY/3nQRU1X0zdheJN1he+S6QU1Hd9/ycfqZr7bfRpJ+TDV/yLhGra/ybEiaB7yaar2EpwMX2h5viuZWkHQt8GaqnkQHAf8KnNimcOylbb9fRV/RT6KEZgFNsD3efhv9oqQwH0vShsArqQb0PYtqJOk2trdqtLD+cNd0B1+RtKKUkG+juRz0Jfwp06o7/zNwa9MFDNi9wFXAe4Ar6yUgnzDIqKU2lvTKrv21uvcLGBC2u6TxBkyJ6kPuKcMuqJeim24kPcT4gSdgPdut/qAbZyrYzs28UqaCLXm+9s59oiOA9anmvfkCcKkLWLx+kkVjbPtPh1bMAIxiX/leig76aLeS52vvpmpx8COo2ue3p1rj+ELbP2q0sJhQ24K+6CkQ6jv/ne1txpx75ROfESNm3PnabXf3zW4927fYPqUeCbuAap3VixsuK3r74uQPGR1FX9HPgV4pnaap7huvprr38qQCmqZuBPa0/Yikm4GFrhd0l3Sj7V2brTCiHVodBFNQdK8U26sNBpO0AXAs8EbgwkaK6q9i52sHkHQrq99DUte+bW83/KqiRKUHfem9UoDHh8yfABwFfB54bgnz7ds+uZ4ZsDNfe+ffbA2qtvq2WzBmfw3gMKq5i64dfjmDJ2kB8FPbP226lrmk9Kab/wGuoLpSelG9Tb2/r+1NmqqtHyRtBryVqv36M8DHbLf+SneuqafufR3wdqrFpk+xvaTZqgZD0jnA7sCPbB/edD39NqrLeJYe9K1aBWa6JP0SWEk1tPyhsedtnz70omLKJK0N/CnVCNIrgVNtL2u2qv6QtKbtR3uc39D2E/6fbTtJpwC7ASO1jGfRQV86Se+jRxNUr7l+onmSllNNTPcR4I6x59s8qEjSdcCf2/5u07VE4UEv6QZ6B+HuQywnYjVdg4rG3pCFlg8qkvQ84GPAD6hmq3yg4ZL6qh7XMaFO77BRUXrQP7PXedu39zo/6iS9t8dp237/0IqJaZP0VlbvHmuqprgrbbd++gdJAt5EdXP5P1l99bO2rzD1tXEOm+r+w9a2R2q5xNJ73WxR+ApF462StT5wDPBUqjVzY3RtMM6xZwLvlvS+AhZ93xR4LtWH12IKWv3M9iu69yXtQzVn0d2MYI+w0q/ouwdMfdf2C5quaVDqmRCPpwr5C4AP2b632apiJiRtCvxXmwf0SXoTVS+iDwL/7EKDRtIBwN9QXc2fYvvShksaV+lX9N2DotZtrIoBqkPhLcBrqdbjfHZp7aFzTT23T9sH9O0LvKDUiw1JfwC8m2rg3ntsX9lwST2VHvRrSNqEaiBKZ/vxX6ACZj/8INV85mcBu9n+RcMlRR9I2g9o+4f11zshL2kf29/pnJB0XAFz038NWA7cB7xD0ju6T47a6melN93cRtUuON7Vkds+Haykx4CHqbroPWEo/ajNiR2rm6BX2KbAT4GjbN88/Kr6Yw7MM9WqMTpFX9Hbnt90DYNku+jZR+eAl4/ZN9VapOPdZG+b0ueZ+jaApHVZNZPqss4azqOm6KCQ9Mdd2/uMOXfc8Cvqr0zD3G62bx/zdUchIQ+FzzMlaS1J/0jVfHMOcC5wp6R/rEc8j5TSm25K//Ox6PcX7SXpV8Ayqqv37ept6v1tba/fVG39IOnDwIbAmztTOUh6CnAa8GvbxzdZ31hFN91Q+J+PlP/+or12arqAAXs58KzubqO2H5T058DNVF2dR0bpQV/0n4+U//6ipdo+6nwKPN7YANuPShq5373Sg35HSddT//lYb1Pvt7rHTW1bSRdRv596m3p/m4mfFjFYc2BRlSWSjrJ9bvfB+r7gyPWWKr2NvvS5blrVxSvmDklPHXOoe1GVa2y/avhV9Y+kLYEvU618trg+vABYDzjU9oqmahtP0UHfi6Tv2N5n8ke2g6R5ALZXNl1LREfpi6rUPd92qXeX2L6syXomMpeD/k7bWzddx2zUw+TfSzWJ0hpUfx4/QrXS1N81WVvMbSUvqgIg6cnA/9r+33p/B+BlwG22R2695rkc9HfYfkbTdcyGpLcABwELO9PaStoWOJNqCPqHm6wv5q6SF1UBkHQFcIztH9eL1V8F/BuwM3CV7Xc2WuAYRQd9j0FDAj5pe94w6+k3SdcCL7H9szHH51Etpr1XM5XFXCfpbCbu+dXqRVWgmr7C9m719vuBTW1NgGfrAAAECElEQVQfK+lJwOLOuVFReq+bV/Q49+9Dq2Jw1h4b8lC104/i6LyYO2y/fqJzkjYfYimD0v0htj/VdMzY/m09B9VIKT3ov9b2PxEn8dsZnosYKkkbA68CXkM1mOrpzVY0a9dLOg1YQTXXzSXw+PscOaU33RQ9DYCkRxl/lSkB69rOVX00RtJ6wMFU4b4X1ZQBhwBX2B65q97pqN/b8cAWwGds/6A+/kJgO9ufa7K+sRL0EdF3kj4PvIjqSvd84HKq2R2LHMhXN5XuCqwYxcVWSm+66YyMHaszX/vuwy4oYo7YmWrxlKXA0lGdGmCmJH2SqhvzTZI2Ar4LPApsKultts9rtsLVlX5FfxNV39ZxtX1kbMQok7QjcCRwOPAzYAdgV9v3NFpYH0i6yfYu9fYJwIttHyLpd4D/HLUeb6Vf0T+cMI9oRr1C1knASZKeQ9VWf7Wk5bZf2Gx1s9bd2eElwBcBbN89isv9lh70uRkZMQJsLwYWS3obVdt92/2PpJdT9brZBzgGqgVJqOa7GSmlB/0jTRcQMRdJ+hi9p8q+Yli1DMgbgY9S9bo5wfbd9fEDgP9orKoJlN5Gn143EQ2QdHTX7t9SNeE8zvY5w61obis96DvLmT3hFOl1EzEUkq4dtZuT/SDpIOBEVs1eeRPwAdsXN1fV+EpvurmV3tMgRMTgFXc1KenPqJpv3gEsqg8vAE6VtJXtsxorbhylX9EXeSUR0SYlNqFKWgLsa/v+McefClxpe6TWzC39iv47TRcQMRdJeohVV/JPlvRg5xRVs+lTmqmsbzQ25AFs35fulcN3az1n+7hsnz7MYiLmCtsbNl3DgD0oaY/OHDcdkvYAHmqopgmVHvQb9DhXbptVRAzaW4GLJH2W1deMPRr448aqmkDRbfS9SDrB9keariMi2qme7uAv6FozFjijq0/9yJjLQd/6pQQjYvRI2sf2SN0fLL3pppfRu2MSEa0gaU3gMGBLqknMbqqnRHgX1RQII9Xbby4H/dz8UyYi+uHTwNZUi4J/TNJPqdroT7T9lUYrG0fRQT+mi9dqpxjBiYciojUWALvbfkzSusDdVCtL3ddwXeMqOujnQBeviGjGbzvLIdr+jaRbRjXkYQ7fjI2ImKkx82gJ2K7eH8l5tIq+oo+IGJCRmuJgMgn6iIjpWxvYfGw3Skn7ULXXj5Q1mi4gIqKFPgI8OM7xB+tzIyVBHxExfZvbvmHswfrY/OGX01uCPiJi+jbucW7kum4n6CMipm9RvfjIaiS9gVWTnI2MdK+MiJgmSZsDFwK/ZfXZK58EHDpqE5sl6CMiZkjSfsCu9e5Nti9vsp6JJOgjIgqXNvqIiMIl6CMiCpegj4goXII+IqJwCfqIiML9fzhh0XTYX5aQAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "pro_se_cases['Judge'].value_counts().plot.bar()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Case count by type, county, and judge in 2018 and 2017"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "County    Judge                Type\n",
       "delaware  DENNEY, BARRY        CM        78\n",
       "                               CF        67\n",
       "          HANEY, ROBERT G      CF        86\n",
       "                               CM        44\n",
       "          LITTLEFIELD, ALICIA  CM       942\n",
       "                               CF       577\n",
       "          UNASSIGNED           CM       510\n",
       "                               CF       121\n",
       "love      COPPEDGE, WALLACE    CF       139\n",
       "                               CM        94\n",
       "          CORBIN,  LAURA J     CM         2\n",
       "          HICKS,  TODD         CM      1214\n",
       "                               CF       364\n",
       "          JOHNSON,  GREG       CM         2\n",
       "                               CF         1\n",
       "          ROBERTS,  CHARLES E  CF         1\n",
       "                               CM         1\n",
       "          UNASSIGNED           CM        19\n",
       "                               CF         4\n",
       "mayes     MCBRIDE,  TERRY H    CF         1\n",
       "          UNASSIGNED           CM      1003\n",
       "                               CF       694\n",
       "rogers    CONDREN, SHEILA A    CF         1\n",
       "          CROSSON, TERRELL S   CM      1979\n",
       "          MCBRIDE, TERRY H     CM         1\n",
       "          STEIDLEY, J          CF      1612\n",
       "          UNASSIGNED           CM        18\n",
       "                               CF         2\n",
       "Name: Type, dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_cases.groupby(['County','Judge'])['Type'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Pro Se Cases by county, judge, and type in 2018 and 2017"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "County    Judge                Type\n",
       "delaware  DENNEY, BARRY        CM       15\n",
       "          HANEY, ROBERT G      CM       10\n",
       "          LITTLEFIELD, ALICIA  CM      259\n",
       "                               CF       11\n",
       "          UNASSIGNED           CM       13\n",
       "rogers    CROSSON, TERRELL S   CM        2\n",
       "          STEIDLEY, J          CF       15\n",
       "Name: Type, dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pro_se_cases.groupby(['County','Judge'])['Type'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Percentage Pro Se by Year, County and Type"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "FiledDate  County    Type\n",
       "2017       delaware  CF       2.08\n",
       "                     CM      22.60\n",
       "           love      CF        NaN\n",
       "                     CM        NaN\n",
       "           mayes     CF        NaN\n",
       "                     CM        NaN\n",
       "           rogers    CF       1.32\n",
       "                     CM       0.18\n",
       "2018       delaware  CF       0.27\n",
       "                     CM      13.97\n",
       "           love      CF        NaN\n",
       "                     CM        NaN\n",
       "           mayes     CF        NaN\n",
       "                     CM        NaN\n",
       "           rogers    CF       0.18\n",
       "                     CM        NaN\n",
       "dtype: float64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "year = all_cases.FiledDate.dt.to_period(\"Y\")\n",
    "\n",
    "groups = [year,'County','Type']\n",
    "round(pro_se_cases.groupby(groups).size()/all_cases.groupby(groups).size()*100,2)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Percentage Pro Se by Year, Type, and Judge"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "FiledDate  Type  Judge              \n",
       "2017       CF    CONDREN, SHEILA A        NaN\n",
       "                 COPPEDGE, WALLACE        NaN\n",
       "                 DENNEY, BARRY            NaN\n",
       "                 HANEY, ROBERT G          NaN\n",
       "                 HICKS,  TODD             NaN\n",
       "                 JOHNSON,  GREG           NaN\n",
       "                 LITTLEFIELD, ALICIA     2.78\n",
       "                 MCBRIDE,  TERRY H        NaN\n",
       "                 ROBERTS,  CHARLES E      NaN\n",
       "                 STEIDLEY, J             1.32\n",
       "                 UNASSIGNED               NaN\n",
       "           CM    COPPEDGE, WALLACE        NaN\n",
       "                 CROSSON, TERRELL S      0.18\n",
       "                 DENNEY, BARRY          23.08\n",
       "                 HANEY, ROBERT G        26.92\n",
       "                 HICKS,  TODD             NaN\n",
       "                 JOHNSON,  GREG           NaN\n",
       "                 LITTLEFIELD, ALICIA    30.58\n",
       "                 ROBERTS,  CHARLES E      NaN\n",
       "                 UNASSIGNED              0.90\n",
       "2018       CF    COPPEDGE, WALLACE        NaN\n",
       "                 DENNEY, BARRY            NaN\n",
       "                 HANEY, ROBERT G          NaN\n",
       "                 HICKS,  TODD             NaN\n",
       "                 LITTLEFIELD, ALICIA     0.46\n",
       "                 STEIDLEY, J             0.18\n",
       "                 UNASSIGNED               NaN\n",
       "           CM    COPPEDGE, WALLACE        NaN\n",
       "                 CORBIN,  LAURA J         NaN\n",
       "                 CROSSON, TERRELL S       NaN\n",
       "                 DENNEY, BARRY          15.38\n",
       "                 HANEY, ROBERT G        16.67\n",
       "                 HICKS,  TODD             NaN\n",
       "                 JOHNSON,  GREG           NaN\n",
       "                 LITTLEFIELD, ALICIA    22.50\n",
       "                 MCBRIDE, TERRY H         NaN\n",
       "                 UNASSIGNED              0.77\n",
       "dtype: float64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "year = all_cases.FiledDate.dt.to_period(\"Y\")\n",
    "\n",
    "groups = [year,'Type','Judge']\n",
    "round(pro_se_cases.groupby(groups).size()/all_cases.groupby(groups).size()*100,2)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### History of Percentage CM Pro Se cases in Delaware County\n",
    "### (January 2017 - August 2018)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x11d243278>"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXQAAAEVCAYAAADwyx6sAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAIABJREFUeJzt3Xd4nNWV+PHvGfVRHTVbVrVkyw032QZLFIcWSgh2aLvsQsguWbLpIW3J7v42ybYUSNgQspuQBkkICcEQAyEGQhwMuICrJNtyb+qyZfU+c39/zIwRtspoNKN5Z3w+z6PH0jvv+86VPDq6c+6954oxBqWUUuHPFuoGKKWUCgwN6EopFSE0oCulVITQgK6UUhFCA7pSSkUIDehKKRUhNKArpVSE0ICulFIRQgO6UkpFiOjxThCReGAjEOc5/xljzFdF5HFgFdDuOfUjxphdY90rMzPTFBUVTarBSil1odm+ffspY0zWeOeNG9CBfuAqY0yXiMQAb4rIHz2PfckY84yvjSoqKmLbtm2+nq6UUgoQkeO+nDduQDfuYi9dni9jPB9aAEYppSzGpxy6iESJyC6gGXjVGLPV89B/iUiliDwsInGjXHufiGwTkW0tLS0BarZSSqlz+RTQjTFOY8wSIA+4WEQuAr4CzAVWAOnAP41y7WPGmOXGmOVZWeOmgJRSSvlpQrNcjDFtwAbgemNMg3HrB34OXByMBiqllPLNuAFdRLJEJM3zeQJwLVAjIjmeYwKsAaqD2VCllFJj82WWSw7whIhE4f4D8LQx5kUR+bOIZAEC7AL+MYjtVEopNQ5fZrlUAktHOH5VUFqkLMcYw6DTEBut69CUsjL9DVXjenrbSVZ+4zV6B5yhbopSagwa0NW43jh4itbuASpr20LdFKXUGDSgq3FV1bmrO2w/cSbELVFKjUUDuhpTe88gx0/3ALDjuPbQlbIyDehqTNX17t75jNR4dp44g7sShFLKijSgqzF50y1/u7KQ090DZ3vrSinr0YCuxlRV206eI4Gr52UDsEPz6EpZlgZ0NaaqunYW5aUyOzuZ5Lhoth/XgK6UVWlAV6Nq6xngRGsPF+WmEmUTlhSkseOEDowqZVUa0NWovPnzRblpACwtcLC/sYOu/qFQNkspNQoN6GpU3oB+UW4KAMsKHbgM7D6pvXSlrEgDuhpVVW07Bel20uyxACzJd/fUd2geXSlL0oCuRlVV187C3NSzX6cmxFA6LUlXjCplURrQ1YjOdA9Qe6aXhXmp7zleVuBg54k2XC5dYKSU1WhAVyPy5s+H99DBHdDbewc5cqo7FM1SSo1BA7oa0dkB0RnnBPRCB6B5dKWsSAO6GlFVbTuFGXZS7THvOV6cmUhqQoyuGFXKgjSgqxGdOyDqZbMJZQVpGtCVsiAN6Oo8p7v6qWvrHTGggzuPfqCpi/bewSlumVJqLBrQ1XnODojmjRLQPXn0XbrASClL0YCuzlN9doXoyAF9cX4aNkELdSllMRrQ1Xkqa9uZmZlISnzMiI8nxUUzZ3oKOzWPrpSlaEBX56muax+1d+61rDCNXSfacOoCI6UsQwO6eo9TXf3Ut/exaJyAXlbgoLN/iIPNnVPUstBxugwHmyL/+1ThTwO6eo+qcfLnXmUF3gVGkT8wunZ7Ldd/7w2aO/pC3RSlxjRuQBeReBF5W0R2i8geEfm65/hMEdkqIodE5LciEhv85qpgq6p9b8nc0RRm2MlIjL0gBkZ31bpTS1ruQFmdLz30fuAqY8xiYAlwvYisBL4FPGyMmQWcAe4NXjPVVKmqa6c4M5HkUQZEvUSEpQWOC2JgtKahA4CTrbpBtrK2cQO6cevyfBnj+TDAVcAznuNPAGuC0kI1papq20edf36ussI0jpzqprV7IMitCh2Xy7C/0Z0/P3mmN8StUWpsPuXQRSRKRHYBzcCrwGGgzRjj3YusFsgd5dr7RGSbiGxraWkJRJtVkDR39tHY0TfqCtFzLfPk0SO5l157ppfuAaf7c+2hK4vzKaAbY5zGmCVAHnAxMNfXJzDGPGaMWW6MWZ6VleVnM9VUqB6lZO5oFuWlEW2TiK7rsteTbkmOi+bkGQ3oytomNMvFGNMGbADKgTQRifY8lAfUBbhtaopV1XYgAgt8DOgJsVHMn5ES0QOjNY3un8kVpVmc0B66sjhfZrlkiUia5/ME4FpgH+7AfpvntHuAdcFqpJoaVXVtFGcmkhQXPf7JHmUFDnafbGfI6Qpiy0KnpqGTmRmJzJ6WRFNHP32DzlA3SalR+dJDzwE2iEgl8A7wqjHmReCfgM+LyCEgA/hp8JqppsJoJXPHsrQgjd5BJzWNkbnwpqaxg7k5yeQ77ADUtenAqLKucbtixphKYOkIx4/gzqerCNDc0UdTRz8L89ImdN0y7w5GJ86Muxgp3HT3D3G8tYdbyvLIT3cH9JOtPZRkJYW4ZUqNTFeKKmD0PUTHk5uWQHZyXERuSXegqRNjYF5OCgXegK5TF5WFaUBXgLvCoggsmDH2CtFziQjLCh3sOBF5JQD2NbjTSHOnJ5OdHEdstE2nLipL04CuAPeUxZKsJBInMCDqVVbg4ERrDy2d/UFoWejUNHaQFBdNniMBm03IS0vQqYvK0jSgKwAq69rHrbA4mrJCd9490uaj1zR0Mnd6MiICQF66nZOtmnJR1qUBXdHU0UdLZ7/fg5oLZqQSG2WLqDy6MYZ9nhkuXvkO7aEra9OArqj0VFhc5GMNl3PFx0SxIDclonro9e19dPYNMS/n3TGF/HQ7bT2DdPbp5tjKmjSgK6rq2rEJzJ/ggOhwZQUOKmvbGRiKjAVG++rdS/7nTh8W0B3eqYuadlHWpAFdUVXbxqzsJOyxEx8Q9VpW6KB/yHW29km4q2l0fx9zpg9LuaQnAGjaRVmWBvQLnDGGqrqOSS8KencHo8hIu+xr7KQg3f6eMgjv9tA1oCtr0oB+gWvs6ONUV7/fM1y8pqfGk5uWwPYIyaPXNHQwd1jvHCDNHkNSXDS1urhIWVRYBHSny3BUt/8KCu+Wc75uajGWpQVp7IyAHnrfoJOjp7qZm/PeMQURIc+RoD10ZVlhEdC//Ewld/xoc8RW9AulswOiOZMP6GUFDurb+2hoD+8e7IGmTlwG5uckn/dYfrpdc+jKssIioF87fxotnf28cehUqJsScarq2pmdnUxCbNSk73W2UNfx8C4DUHN2yf/5s37yHe7FRcaYqW6WUuMKi4B+1dxsHPYYntleG+qmRBRjzIT2EB3PvJwU4qJtYT8ffV9jBwkxUWcLcg2Xn55A76CT0xG8j6oKX2ER0GOjbaxeksure5to79FFHYHS0N7H6e6BCVdYHE1stI3FeWlhH9BrGjqZMz0Zm03Oe0xnuigrC4uADnBrWR4DQy5eqKwPdVMiRmUAB0S9lhamUV3XHrY7+xhjqGnsYN4I+XPg3broOtNFWVDYBPSLclOYMy2ZtTs07RIo1XXtRNmE+Tn+rxA9V1mBg0GnYU99e8Du2TMwxLZjrQG731iaOvo50zP4niX/w+U5PIuLtIeuLChsArqIcOuyXHaeaONwS1eomxMRKuvamZ2dRHzM5AdEvbwLjAK1cbTLZfjkkzu47YebqZ2C2SX7Gs9f8j9cYlw0GYmxU9IWpSYqbAI6wJoluUTZhLU6ODppxhiq/dhDdDxZyXEUpNsDNtPlBxsOsWF/CwCbDp8OyD3H4p3hMmf6yCkX0DK6yrrCKqBnp8SzqjSLZ3fU4XTptLHJqGvrpbV7wO8Ki2NZVuhg+4kzk57a98bBFr77pwOsXjKDzKQ4Nk3BtNWaxg5y0xJITYgZ9Rwto6usKqwCOrgHRxs7+th0WOekT0a1Zw/RYGzsXFaQRktn/6SWyNe19fKZp3YyOzuJb9yykIqSDDYdPh30+d/eTS3Gkp9up76tVzsVynLCLqBfPS+b1ASdkz5ZlbXtRNtk1MG/yVjqLdTl5/TF/iEnn3hyB4NOww/vWoY9NpqKkgyaO/s53BK8EhD9Q04Ot3SN+zPJd9gZdBoaO/qC1hal/BF2AT0+JooPLs5hfXUjHbrRgN+q6topnZYc0AFRr7nTk7HHRvldefE/X9zH7pNtPHT7IoqzkgCoKMkECOo7s0PNXQy5zHt2KRrJ2TK6OtNFWUzYBXSA25bl0z/k4qXKhlA3JSy5S+YGfkDUKzrKu8Bo4gOjz+2s5ZdbjnPfFcVcf1HO2eMFGXbyHAlsOhS8gdGxlvwPp4uLlFWFZUBfnJdKSVaipl38VHuml7aewYAuKDpXWWEaexs66BkY8vmamsYOvvJsFRfPTOfL18057/GKkgw2HzmNK0i565rGDuKibRRlnL/kf7gZaQmI6OIiZT1hGdBFhNuW5bPt+BmOaVndCavyDIgGq4cO7pkuTpc5uxp1PJ19g3z8VztIjo/h0TuXEh11/kuzoiST9t7BoO2KVNPYSem05BGfe7jYaBs5KfHUag9dWcy4AV1E8kVkg4jsFZE9IvJZz/GviUidiOzyfNwY/Oa+60NLc7EJunLUD1V17cREybi54slYmu/7wKgxhi/9rpITrT08eudSslPiRzyvoiQDCF4efV/D6Ev+z5WnZXSVBfnSQx8CvmCMmQ+sBD4pIvM9jz1sjFni+XgpaK0cwfTUeC6b7Z6THqy34JGqqtY9IBoXHfgBUS9HYizFWYk+DYz+5I2jrN/TyAPXz+WS4oxRz8tOiWdWdlJQFhi1dPZzqmtg3Py5l7eMrlJWMm5AN8Y0GGN2eD7vBPYBucFumC9uLculrq2XLUeCv4IwUngHRIOxoOhcZQUOdpxoG3Pu+NYjp/nm+hquXzCdj14+c9x7VpRk8PbRVgaGArvZiXdTaF/fteSnJ9DU2Uf/UHgWIVORaUI5dBEpApYCWz2HPiUilSLyMxFxjHLNfSKyTUS2tbS0TKqx57puwXSS46J5RtMuPjvZ2kt772BQFhSdq6zAQWv3AMdPj5yaaO7o41NP7aQw3c6Dty9C5PxyteeqKMmkZ8BJZW1gN9HwdYaLV77DjjFQpwOjykJ8DugikgSsBT5njOkA/g8oAZYADcB3RrrOGPOYMWa5MWZ5VlZWAJr8rviYKG5anMMfqxrp6vd9NsWFzDsguig3LejP5d3BaKRCXYNOF5/69U66+ob4v7uWkRw/+lL74VYWpyMS+Lou+xo7mJYSR3pirE/naxldZUU+BXQRicEdzJ80xjwLYIxpMsY4jTEu4MfAxcFr5uhuW5ZH76CTP1bpnHRfVNa1ERMllE5PCvpzzc5OIjkuesSB0W+vr+HtY61845aFYxbCOleaPZYFM1J4K8B1XfY1dE5o1awuLlJW5MssFwF+Cuwzxnx32PGcYad9CKgOfPPGV1bgYGamzkn3VXVdO3OnpwR1QNTLZhOWFJy/wOilqgZ+/MZRPlxeyJqlEx+OqSjJZOeJNnoHApO/HnS6ONTc6XO6BWBacjyxUTad6aIsxZce+qXA3cBV50xR/LaIVIlIJXAlcH8wGzoaEeHWsly2Hm3V3tI4vHuITkX+3KuswMH+xo6zKbHDLV18+ZlKluSn8S8fmOfXPStKMhhwugJWc/1ISzeDTuPzlEVw/7HKdSRQqzNdlIX4MsvlTWOMGGMWDZ+iaIy52xiz0HP8ZmNMyHIeHyrLQ3RO+rhOtPbQ0Tc0JTNcvMoKHbgM7D7ZRs/AEB//1XZiooT//dsyv98lrChKJ9omvBWg+eg142xqMZo8LaOrLCYsV4qeKzctgYqSDNbuqNU56WM4u4foFPbQl+SnIeIeGP3Ks1UcbO7ikTuXMiMtwe97JsZFsyQ/LWADo/saOomNslGclTih6/LT7fquUFlKRAR0cA+Onmzt5Z0p2nsyHFXXtRMbZaN0WvBWiJ4rNSGG2dlJ/PTNo6zbVc/nrynl8tmTn+1UMSuTqto22nsnX3FzX0MHs7KTiBlnyf+58h12zvQM0qlVP5VFRExAv27BdBJjo3RwdAyVte3MzUkmNnpq/9vLChy09w5y1dxsPnnlrIDcs6IkA5eBt49O/g94TWOHX2UQ3p3ponl0ZQ0RE9DtsdF8YFEOL1U1TKjCX7D1DTr53baTPP7W0ZC2w+UyVNcHr2TuWFYvyWVVaRYP37EEm238xUO+WFqQRnyMbdJ1XVq7B2jq6GfeBPPnMKyMrubRlUVEh7oBgXRrWR5Pb6tlfXUjt5TlhbQtDe29/GrLcZ56+ySt3QMAXHfRdHJS/c8dT8bx1h46+4ZCEtDLSzIoLxm9Ros/4qKjWFGUPun66BNd8j/c2cVFmkdXFhExPXRwz34oSLeHbLaLMYZ3jrXyySd3cNm3NvC/fznMskIH//WhiwDYeCCwpQ8m4mzJ3Cmc4RJs5SUZ7G/qpKWz3+97THTJ/3AOewyJsVGT2jtVqUCKqB66zSbcUpbL9147SF1bL7mTmEkxEX2DTp7fXc/jbx1jb0MHKfHR3HvZTO5eWUh+uh1jDN9/7RCvH2jhr1YUTEmbzlVV20Zs9NQOiAabe1u6/Ww5cpoPLp7h1z1qGjvITIojKzluwteKiM50UZYSUQEd3GmX//nTQZ7bUcunrpod1Oeqb3OnVX7zjjutUjotif/+0ELWLJ2BPfbdH62IcEVpJn+sbmTI6Rp3A4VgqKprZ15OyoRncljZRTNSSI6PZtPhU34HdPeSf///yOU57Jxo1U1WlDVEXEDPT7dzycx01u6o45NXzvKpgt9EuNMqZ3h801Fe3tOEMYZr5k3jI5cWUV6cMerzrSrN5ultteyubWNZYXpA2zQel8tQXdfBmqX+BT2rio6yccnMDL/now85XRxo6uTD5YV+tyE/PYG3Dp3CGBPw15pSExVxAR3cc9K/9EwlO06cCVjw7Bt08vyuen6+6Rj7GjpITYjho5fN5C5PWmU8l83KxCbw+v6WKQ/ox05309U/NCUVFqdaRUkGf9rXRO2ZHvIc4/8/DHfsdA/9Qy6/8udeBel2egednO4eIDNp4mkbpQIpct5/D3PDwhwSYgIzJ727f4jvv3aQ8m+8xpfXVuJyGb5xy0K2fOVqvnLjPJ+COUCqPYalBQ5eD8HAqHdAdCpruEyVS2dlAv6V053MDBevs1MXNY+uLCAiA3pSXDQ3LJzOi7sb6Bv0ryLfoNPFLzcfY9WDf+E7rx5gWaGDp/5hJes/dzl3XlxAQuzE65CsKs2isq6d013+z8rwx5Yjp0mMjWL2tOCXzJ1qpdOSyEiMZbM/Ab2hk2ibMCvb/5+L1kVXVhKRAR3gtrI8OvuHeHlP44Suc7kMz++u55rvvs7/W7eH4qxE1n68gp/cs4LyktFz5L64ojQLY+DNANfyHovTZXhlTxNXzZsWUQOiXiJCeUkGmw6fGnOru5Hsa+igJCtpUqWE8xxaF11ZR+T9hnusLM4gNy2BtTvqfL7mjYMt3PyDN/nMUztJiIni5x9ZwW/vW3l2553JWpibisMeM6Vpl23HWjndPcD1C6ZP2XNOtUtnZdLU0c/hlonNNqlp7JxUugXchcIyEmOp1dWiygIiclAU3HPSby3L5dENh2hs72N6avyo51bWtvGt9TW8deg0uWkJfPeOxaxekktUgJape0XZhMtnZ7HxwClcLhOwZfBjWb+nkdhoG++bE9jt/6ykwrMKdfPhUz6nT9p7B6lr6+Wu6f7PcPHKS7drPRdlCRHbQwe4pSwPl4Hndo7cSz96qptPPrmDmx99i30NnfzbTfP58xdXcUtZXsCDudeq0ixOdfWzt6EjKPcfzhjDy9WNXDE7i8S4iP3bTUG6ndy0hAkNjO5v9KwQnWQPHSBf66Iri4jogF6UmciKIgfPbD/5nvxqc0cf//JcFdd893U27G/mM1fN4vUvvY+/v2xm0Ldmu7zUPStjKtIuVXXt1Lf3cf1FkZtugXfz6JuPnPa5Hr53hsv8CewjOpr8dDv1bb04tRa/CrGIDujgXjl6uKWb3bXtdPQN8uDLNax68C/89p2T/O0lBbz+pSv5/Pvn+Lzr/GRlJ8czPydlSgL6+upGomzCNfOyg/5coXbprAzaegZ9fuezr6EDhz2GbD+W/J8r32Fn0Glo7Oib9L2UmozIfR/uceOiHL72wh6+uq6a4609tPUMcvPiGXzh/aUUZkxsh5pAWTUnix9vPEJn32DQ/pAYY1hf3Uh5cQZp9tigPIeVlBe73/lsPnzap/n2+xrcm0IHYnXnu3XRe6asfpBSI4n4HnpKfAw3XJTD7tp2FuWl8eKnL+ORO5eGLJiDO48+5DIB20JtJIeauzhyqpvrIjzd4jU9NZ7irESf9hl1uQz7AzDDxUsXFymriPgeOsDXbl7AvZfNtMxKybICB0lx0bx+oIXrgjSdcH11IyJw3fxpQbm/FV1aksnaHbUMOl1jzrk/0dpD76DTr00tRjIjLQERXVykQi/ie+jg3tfSKsEcIDbaRkVJBq/vb5nwYhhfrd/TSFmBg+yU0adrRpqKkgx6BpxU1raNeZ53QHReAAZEwf3/mZMST6320FWIXRAB3YquKM2irq2XI6cCX3r1ZGsPe+o7Inox0UhWFmcgAm+Ns4vR3oZObEJASyHkpdt16qIKOQ3oIbKq1L3Q5/X9gZ/t4i13EKx0jlU5EmOZn5My7j6jNQ0dzMxMJD4mcFNU8x26uEiFngb0EMlPt1OclRiU6YvrqxuZn5NCQcbEyslGgoqSDHYcbxuzKJt7yX9g0i1e+ekJNHX20T/kXzE4pQJBA3oIrSrNYsuR035XhBxJc0cf20+cifjFRKOpKMlkwOli27EzIz7e1T/EidYe5k0P7FZ8+Q47xkCdDoyqEBo3oItIvohsEJG9IrJHRD7rOZ4uIq+KyEHPv4GpYHUBWVWaRf+Qi61HWwN2z5f3NmEMF2xAXzEznWibjJp28S75D9SAqJeW0VVW4EsPfQj4gjFmPrAS+KSIzAceAF4zxswGXvN8rSbgkpkZxEbb2BjAtMvL1Y0UZyYyexI1vsNZUlw0i/PTRp3jv6/Bu6lF4FMuoHPRVWiNG9CNMQ3GmB2ezzuBfUAusBp4wnPaE8CaYDUyUiXERnHJzPSA5dHbegbYfOQ01100/YLe37KiJIPK2jY6+gbPe6ymsYPk+GhmjFF90x/TkuOJjbLpTBcVUhPKoYtIEbAU2ApMM8Y0eB5qBEZcwSIi94nINhHZ1tIy9duvWd2q0iwONXcFpJ72n/Y143QZbrhA0y1eFSWZuAy8feT8VFZNQyfzArTkfzibTch1JFCrM11UCPkc0EUkCVgLfM4Y854KSMa9OmbEFTLGmMeMMcuNMcuzsiK3Jre/vHXKNx6Y/C5G66sbmZEaz0ILLaIKhaUFacRF285LuxhjArKpxWjytIyuCjGfArqIxOAO5k8aY571HG4SkRzP4zlAc3CaGNlKspLITUvg9QOT+/F19w+x8WDLBZ9uAYiPiWJ5keO8gdHaM7109Q8FfEDUKz/drjl0FVK+zHIR4KfAPmPMd4c99Dxwj+fze4B1gW9e5BMRrijNZNOh0ww6XX7f5y/7WxgYcl1wq0NHU1GSSU1jJ6eGbch9dkA0wFMWvfIdds70DNLVPxSU+ys1Hl+Kc10K3A1Uicguz7F/Br4JPC0i9wLHgTuC08TIt6o0i6fePsnOE21cPDPdr3us39NIRmIsy4v8uz7SeLel23LkNDctmgG4FxSJQOm0IAX0YTNdAvkuYMjpYsuR1kn9wc9MimNh3oWdirsQjBvQjTFvAqO9h786sM25MFXMyiTKJrx+oNmvgN436OTP+5q4ecmMoG2dF24W5qaSFBfNW4eGB/QOCtPtQduOb3gZ3UAG9N+8c5J//X31pO/zyJ1LuXnxjAC0SFnVBVE+1+pS4mNYVuDg9QMtfOm6uRO+ftPhU3QPOC+42i1jiY6yccnMdDYPy6PXeDa1CJZgLS56bmcds7KTeOj2xX7f42vP7+Hf1lWzsjid7OQLpwLnhUYDukWsmpPFgy/vp6Wzn6wJbou2vrqR5LhoKkoyg9S68FQxK5PXapqpa+sl3R7L0dPdrF6SG7Tnc9hjSIyNCujA6MnWHrYfP8OXrpvDkvw0v+/z0O2LufGRN/jX56r50d3LLviB80iltVws4orZ7umLbx6a2Fz9IaeLV/c2cfW8bGKj9b9zOG8efdOhU+xv6sQYgjZlEdwD3Pnp9oCsKfB6fnc9AKuXTC5VMis7iS9cW8ore5vO3lNFHo0AFrFgRgoZibETLqf79rFWzvQMXrC1W8YyZ1oy6YmxbD58mhrPDJdA7VI0mrwAltE1xvD7nXWsKHKQ55h85cyPXl7M0oI0vvr8Hpo7dUPrSKQB3SJsNuGK0iw2HjyFy+X7LkYvVzcSH2PjilJdtHUum00oL8lg0+HT7GvoIDE2ijxHcDdxzk93Ly4KxE5Uexs6ONjcxc0BShNF2YQHb1tMz4CTf3muOmi7ZanQ0YBuIatKs2jtHqC6vt2n810uw8t7mlhVmoU9VodDRlJRkkFjRx+v7G1izvRkbEGeBZTvsNMz4KS1e2DS93p+Vz3RNuEDC3MC0DK3WdlJfPH9pby6t4l1uzT1Emk0oFvI5bMzEfF9F6PdtW00dvRpumUM3oHihva+gFdYHEmgZrq4XIbnd9ezqjSL9MTYQDTtrHsvK6bMm3rp0NRLJNGAbiEZSXFcNCOVjQd9C+jr9zQSbROumjtiXTQFFGXYz1ZWDNaS/+ECVUZ369FWGtr7uHmSg6EjibIJD92+mL5BJ//8XJWmXiKIBnSLWVWaxY4TbbT3nl/6dThjDC9XN1IxK5PUhJgpal34ERHKPb30QO9SNJKzi4smOdPl+d112GOjuHZ+cP5YF2cl8aXr5vCnfc08t7MuKM+hpp4GdItZNScLp8uw6dDY1Rf3N3Vy7HSP1m7xwZqlM5idnTQlPfTEuGjSE2Mn1UPvH3Lyh8oGrlswPahjI3936UyWFzr42vN7aNLUS0TQgG4xS/PTSI6PHnfTi/XVjYgQtB5cJLl8dhavfn5V0Jb8nyvfkTCpqYt/2d9CR9/QpOeejyfKJnz7tkX0D7n452c19RIJNKBbTHSUjctmZbLxQMuYv2DrqxtZUZg+4VWlKvjy0u2TSrlm9zUTAAAZFElEQVQ8v6uejMRYLpsV/JW/3tTLazXNrN2hqZdwpwHdgq4ozaK+vY9DzV0jPn7sVDc1jZ1cp7NbLCnfYae+rRfnBNYTeHX2DfKnfU3ctCiH6Kip+fX8u0tnsqLIwddf2ENju6ZewpkGdAvyLhIaLe3y8p5GAK5boOkWK8pPT2DQaWj0Iy+9vrqR/iEXq5cGr+bMubwLjgadLr7ybKWmXsKYBnQLyk1LYHZ20qgBff2eRhbmpgZkObgKvOFldCdq3a56CtLtLJ1EIS5/FGUm8uXr5rJhfwvPbK+d0udWgaMB3aJWlWax9WgrvQPO9xxvbO9j54k2XUxkYWcXF00woDd39LHp8ClWL5kRkmqIH6ko4uKidP79hb00tOtm1+FIA7pFrZqTxcCQiy1H37vR8St7vekWDehWNSMtHpGJrxZ9obIBlyGoJX7HYvPMehl0uXhgrc56CUca0C1qRVE68TG288oArK9uZFZ2ErOyk0LUMjWeuOgopqfEUzvBHvq6XXVclJsS0v/bosxEHrh+Lq8faOF32zT1Em40oFtUfEwUK4sz2Dgsj97aPcDWo626mCgM5E9w6uKRli4qa9tZvTg0vfPhPlxexCUz0/mPF/dS3xYZqZcLJYWkAd3CVpVmceRUNydOuwPDn/Y14XQZzZ+HgfwJ1kVft6seEfigBfb8tHlmvQy5DA9EwIKjDTXNlH/jz2w/3hrqpgSdBnQLW+Wdvugp1vVydSN5jgQWzAj+EnY1OfnpCTR19tE/5Bz3XGMM63bVUV6cwfRUa+z3WZBh54Eb5rLxQAu/fedkqJszKT976yjgexXTcKYB3cJmZiaS50hg44EWuvqHeOPgKa5fMF33gwwD+Q47xkCdDwOjlbXtHDvdE/Sl/hN198pCVhan859/2EddmKZeDjV38cZBd12kzUdOj3N2+NOAbmEiwqrSLDYdOsUrexoZcLo03RImJlIX/fe76oiNsnH9RYHbyCIQbDbh27cuxmUMD6yt9Gvla6j9astxYqNs3LYsj10n286bBhxpNKBb3KrSLLoHnHznlQNkJcdRVuAIdZOUD3ytiz7kdPHC7gaumpttyTLIBRl2vnLjPN44eIo7H9sy6TrvU6mrf4i122u5ceF0blqUw6DTsC3C8+ga0C2uYlYm0Tahrq2X98+fFvQt1FRgTEuOJzbKNu5Ml02HT3Oqq581S62VbhnurksKeOj2xexr6OD6/9nIb94+ERYDpc/trKOzf4gPVxSxoiidaJuw+XBkp13GDegi8jMRaRaR6mHHviYidSKyy/NxY3CbeeFKiotmeZG7V67plvBhswm5jgRqx5npsm5XPcnx0bxvTvYUtWziRITbluWx/v4rWJyfxgPPVnHvE9to7rRuIS9jDL/YdIyFuakszU8jMS6aRXmpbLrQAzrwOHD9CMcfNsYs8Xy8FNhmqeFuWZrHnGnJrCzOCHVT1ATkORLG7KH3DTp5eU8jN1w0nfiYqClsmX9y0xL41b2X8NUPzuetQ6e47uGNvFTVEOpmjWjLkVYONndxd3nh2UkE5SUZVNW109U/FOLWBc+4Ad0YsxGI7MSTxd2xIp+X77+CmCkqp6oCIz/dPmbO+U/7mujqH2JNiJb6+8NmE/7u0pn84TOXk59u5xNP7uBzv9lJe8/YWyZOtV9sPkaaPYabh83rLy/OxOkyvHM0csPZZCLEp0Sk0pOSGXWkTkTuE5FtIrKtpSXy54Eq5ZXvsHOmZ3DUHuG6XfVkJ8dxSRi+85qVncTaj1dw/zWlvFDZwHX/s5E3fNzcPNjq23p5ZW8Tf7Ui/z3vfJYVOoiJkoievuhvQP8/oARYAjQA3xntRGPMY8aY5caY5VlZWX4+nVLhZ6yZLm09A/xlfzM3L55BVJgOdMdE2fjsNbN57hMVJMVHc/dP3+bf1lXTMxDalMavt57AZQx3XVL4nuMJsVEsLXBE9MCoXwHdGNNkjHEaY1zAj4GLA9sspcLfWHXRX6pqZNBpWDOFG1kEy6K8NF789GXce9lMfrH5OB945E12nDgTkrb0Dzn5zTsnuHpu9tm1AMOVF2ewp76d9l5rpYgCxa+ALiLDV0B8CKge7VylLlRjLS5at6uOkqzEiCnjEB8Txf+7aT6//odLGBhycdv/beKhl/czMOSa0nb8saqRU10DfLi8aMTHy0sycBl4O0Lz6L5MW3wK2AzMEZFaEbkX+LaIVIlIJXAlcH+Q26lU2HHYY0iMjTqvh17f1svWo62sXpIbcWUcKkoyWf+5y7m1LI9HNxxizQ/eYn9j55Q9/xObj1GcmTjqBttLC9KIi7ZFbNrFl1kudxpjcowxMcaYPGPMT40xdxtjFhpjFhljbjbGWHPuklIhJCLkp9upPWfq4vO76wEsV7slUJLjY3jw9sU8dvcymjv7+OD33+SxjYeDvhipqradnSfauGtl4agL8OKio1hW6IjYgVGdB6dUEOWNUEb39zvrWFqQRmFGYohaNTXev2A6L3/uCq6cm8V/v1TDL7ccD+rz/WLzMeyxUdy6LG/M88qLM9jX0MGZ7oGgticUNKArFUT56e7FRd7e6f7GTmoaO1ltgbrnUyEjKY4f3rWMVaVZ/PdL+zjc0hWU5znTPcDzu+v50NLccWvilJe4p4luPRp5vXQN6EoFUb7DTs+Ak1ZPb3DdrjqibMJNF0hAB3fq6du3LSI+JorPP72bIWfgB0qf3naS/iHXqIOhwy3KSyMhJioi8+ga0JUKouEzXVwuw7pd9Vw2K5PMpLgQt2xqTUuJ5z/XXMTuk238YMPhgN7b6TL8cstxLpmZzpzpyeOeHxttY3lRZObRNaArFUTDFxftOHGGurZeS1dWDKabFs1g9ZIZfP/PB6msbQvYfTfUNFN7ppd7Kop8vqa8JIMDTV2c6uoPWDusQAO6UkF0dnHRmR5+v6uO+Bgb186/cKtm/vvNF5GZFMf9v91F32BgNpt4YvMxpqfEc+38aT5fU+4pt7AlwnrpGtCVCqLEuGjSE2M52tLNHyobuHb+dJLiokPdrJBJtcfw4O2LONzSzbfW10z6fkda3FvM/c0lBRMqXrcwN5WkuOiIy6NrQFcqyPIdCbxU1cCZnkHWROjc84m4fHYW95QX8vO3jvHWoVOTutcvtxwnJkr464vzJ3RddJSNFRGYR9eArlSQ5aXb6R5wkmaP4fLZWqAO4IEb5lGclcgXf7fb77oq3f1DPLOtlhsX5pCdHD/h68tLMjjS0k1Th3U36pgoDehKBZk3j/6BhTnERuuvHLgrHz58xxKaO/v5+vN7/LrH73d5tpgrLxz/5BGUF7vLA0RSHl1fXUoF2cxMd0CPhMqKgbQ4P41PXTmLZ3fW8ccJ7nzk3mLuOAtmpPi9cfr8GSmkxEdWHv3CHZ1RaorcvDiXrOQ4lhf6F3gi2aeumsWG/c3883NVLCt0kJ3iW+pk69FW9jd18u1bF/ld4CzKJlw8MyOi8ujaQ1cqyBJio7hq7rSIq6wYCDFRNr57xxJ6Bpz809pKnwt4/XLzcVITYvjgJFfclpdkcPx0D/VtY2/mHS40oCulQmpWdhIP3DCXDftb+M07J8c9v7G9j/V7GvmrFfkkxE5uc23vfPRISbtoQFdKhdw95UVcOiuD/3hxL8dPd4957q+3Hh9xizl/zJ2ejMMeEzFpFw3oSqmQs9mEB29bTJRN+MLTu3G6Rk69DAy5+PXbJ7lqTjYFGedvMefP814yM0N76EopFUgz0hL499UL2Hb8DD/aOHIBrz9WN3Cqq5+7/ZyqOJLykgzq2npH3Ps13GhAV0pZxpoludy4cDoPv3qAPfXt5z3+i83HKcqwc0UAF2h566NHQi9dA7pSyjJEhP9cs5A0eyyf/+1u+ofeLeBVXdfO9uNnuLu8aNQt5vwxOzuJzKTYiMija0BXSllKemIs37p1IfubOvnuKwfOHv/l5uMkxERx2zhbzE2UiHBJsTuPHux9T4NNA7pSynKumjuNOy8u4LE3jrD1yGnaegb4/a461viwxZw/yoszaOzo49jp8M6ja0BXSlnSv35gHgXpdr7wu9387K1jni3mAjcYOlyk5NE1oCulLCkxLprv3L6Y+rZeHnntIBcXpTMvJyUoz1WcmUh2clzY59E1oCulLGt5UTofW1UCwIcrgtM7B3cevbwk/PPoGtCVUpb2hWtLWfvxCj6wMCeoz1NenMGprn4Ot3QF9XmCSQO6UsrSoqNsLCt0BL24WSTk0ccN6CLyMxFpFpHqYcfSReRVETno+VfrgiqlwlpBup0ZqfFhnUf3pYf+OHD9OcceAF4zxswGXvN8rZRSYUtEWFmSwZYjrbhGqSVjdeMGdGPMRqD1nMOrgSc8nz8BrAlwu5RSasqVF2fQ2j3AgebOUDfFL/7m0KcZY7x7RjUC00Y7UUTuE5FtIrKtpaXFz6dTSqngC/c8+qQHRY17js+o70+MMY8ZY5YbY5ZnZemO50op68pz2MlPT7jgAnqTiOQAeP5tDlyTlFIqdMqLM9h6NDzz6P4G9OeBezyf3wOsC0xzlFIqtMpLMmjvHWRvQ0eomzJhvkxbfArYDMwRkVoRuRf4JnCtiBwErvF8rZRSYa+8OBOALWE4fTF6vBOMMXeO8tDVAW6LUkqF3PTUeGZmJrL58Gk+enlxqJszIbpSVCmlzrGyOIO3j7Yy5HSFuikTogFdKaXOUV6SQWf/EHvqwyuPrgFdKaXOsbI4HSDsygBoQFdKqXNkJ8czKzsp7Oaja0BXSqkRlBdn8M6xVgbDKI+uAV0ppUZQXpJBz4CTytr2UDfFZxrQlVJqBCuL3XVdwmk+ugZ0pZQaQXpiLHOnJ4dVHl0DulJKjWJlcQbbjrfSP+QMdVN8ogFdKaVGUV6SQd+gi10n2kLdFJ9oQFdKqVGsnJmBSPjMR9eArpRSo0i1xzA/JyVs8uga0JVSagzlxRnsPNFG36D18+ga0JVSagyXzs5kwOniq+v2WD6oa0BXSqkxrJqdxcdWFfPbbSe5+dE32d9o3Q2kNaArpdQYbDbhKzfM4xd/fzGt3QPc/OibPLn1OO7tlK1FA7pSSvngitIs/vjZK7h4Zjr/8lw1n3hyB+09g6Fu1ntoQFdKKR9lJcfxxN9dzFdumMure5u48ZE32H68NdTNOksDulJKTYDNJnxsVQnPfLyCKJtwx4+28OifD+J0hT4FowFdKaX8sCQ/jRc/cxkfWJjDQ68c4K6fbKWpoy+kbdKArpRSfkqJj+F7f72Eb9+2iF0n27jhe2/w55qmkLVHA7pSSk2CiHDH8nxe+PRlTEuJ5+8f38a/v7A3JAW9NKArpVQAzMpO4rlPVPCRiiJ+9tZRbvnfTRxp6ZrSNmhAV0qpAImPieJrNy/gxx9eTl1bLzd9/03Wbq+dsufXgK6UUgF27fxp/PGzl7MwN5Uv/G439/92F139Q0F/3kkFdBE5JiJVIrJLRLYFqlFKKRXuclIT+PU/rOT+a0pZt6uOLVNQsTE6APe40hhzKgD3UUqpiBJlEz57zWxWL5lBUWZi0J9PUy5KKRVkUxHMYfIB3QCviMh2EblvpBNE5D4R2SYi21paWib5dEoppUYz2YB+mTGmDLgB+KSIXHHuCcaYx4wxy40xy7Oysib5dEoppUYzqYBujKnz/NsMPAdcHIhGKaWUmji/A7qIJIpIsvdz4P1AdaAappRSamImM8tlGvCciHjv82tjzPqAtEoppdSE+R3QjTFHgMUBbItSSqlJ0GmLSikVIWQq98UTkRbguJ+XFwAnJvH0qUC7Xq/Xh+n1+voP7fWhbkOhMWb8aYLGmLD4AFomef1jer1eH8bX6+s/hNdbpQ3jfYRTyqVtkte/oNfr9WF8vb7+Q3u9VdowpilNuUyGiGwzxiwPdTuUCgV9/StfhFMP/bFQN0CpENLXvxpX2PTQlVJKjS2ceuhKKaXGoAE9wERkjYgYEZkb6rZMhoiMuRmiiPxFRCyV0xWRPBFZJyIHReSwiHxPRGLHOP9zImKfyjZGOn39h5blAvp4P8gwcCfwpudfn4lIVHCac2EQdw2KZ4HfG2NmA6VAEvBfY1z2OcBSAV1f/2oyLBfQw5mIJAGXAfcCf+059j4R2SgifxCR/SLyQxGxeR7rEpHviMhuoDx0LR+Zp+0vDvv6URH5SAibNJargD5jzM8BjDFO4H7g7z2F5B4SkWoRqRSRT4vIZ4AZwAYR2RDCdkcMff2HniUDuogkichrIrLDs2fpas/xIhHZJyI/FpE9IvKKiCSEur3DrAbWG2MOAKdFZJnn+MXAp4H5QAlwi+d4IrDVGLPYGPPmlLc2siwAtg8/YIzpwL268qNAEbDEGLMIeNIY8whQj3sLxSunuK1j0te/8pclAzrQB3zIuDfPuBL4juctNcBs4AfGmAW4F1vcGqI2juRO4Deez3/Du2873zbGHPH0Gp/C3YsBcAJrp7aJF6T3AT8yxgwBGGNaQ9uccenrX/klEJtEB4MA/+3ZAckF5OIu1wtw1Bizy/P5dtw9r5ATkXTcb/sXiogBonBv0fcHz7/Deb/u87zIrWqI9/7Rjw9VQ3ywF7ht+AERScFdA+VYKBo0Cfr6t4Zwev0D1u2h/y2QBSwzxiwBmnj3h9k/7Dwn1vmjdBvwS2NMoTGmyBiTDxwFLgcuFpGZntzhX+EeNAoHx4H5IhInImnA1aFu0BheA+wi8mE4O8j2HeBx4GXgYyIS7Xks3XNNJ5A89U0dl77+rSGcXv+AdQN6KtBsjBkUkSuBwlA3yAd34t6Gb7i1nuPvAI8C+3C/yM89z1I8ga/fGHMSeBr3TlRPAztD2rAxGPcKuQ8Bt4vIQeAA7tTFPwM/wZ1Lr/QMwP2N57LHgPUWHBTV138IhePr38tSK0U9P8gmYA7uQjZJwDZgJe6NqAFeNMZc5Dn/i0CSMeZrU99a34jI+4AvGmNuCnVbfCUii4EfG2N0j9gppK9/awjn179V3q55LQAOG2NOMfo0pou8nxhjHpqSVl1AROQfgc/gnqOtppa+/kMs3F//lumhD/9BGmNeCXV7lJpK+vpXgWCZgK6UUmpyrDooqpRSaoJCFtBFJF9ENojIXs+qt896jqeLyKueAkuviojDc3yuiGwWkX7PYJD3PnNEZNewjw4RCcv8l7qwBOp3wPPY/Z57VIvIUyJi+TnTKvBClnIRkRwgxxizQ0SScS+SWAN8BGg1xnxTRB4AHMaYfxKRbNzTt9YAZ0YaEPLMPa4DLjHG+LsZtVJTIlC/AyKSi3tu93xjTK+IPA28ZIx5fOq/KxVKIeuhG2MajDE7PJ934p6jmou7HsQTntOewP3ixRjTbIx5Bxgc47ZX454loMFcWV6AfweigQTP1Ec77jo16gJjiRy6iBQBS4GtwDRjTIPnoUbeXfLsi7/GXStCqbAymd8BY0wd8BDuxVMNQLvOlLkwhTygi7vk5lrc07U6hj/mWf3nU05I3BsZ3Az8LuCNVCqIJvs74MmxrwZm4i4JnCgidwWpucrCQhrQRSQG9wv5SWPMs57DTZ7cojfH2Ozj7W4AdhhjmgLfUqWCI0C/A9fgLtrVYowZxL3RR0Ww2qysK5SzXAT4KbDPGPPdYQ89D9zj+fweYJ2Pt7wTTbeoMBLA34ETwEoRsXvueTXufLy6wIRylstlwBtAFe4SoeAupLQVdyGcAtzVzu4wxrSKyHTcdS1SPOd34R7V7xCRRNwv6mJjTPvUfidK+SfAvwNfx13JcAh3EamPGmOGV2ZUFwBdKaqUUhEi5IOiSimlAkMDulJKRQgN6EopFSE0oCulVITQgK6UUhFCA7oKGyLiPKeyZpGILBeRRzyPf0REHp3gPY+JSOY5998jIrtF5AuejY3Hur5IRP5mrHOUmipW24JOqbH0GmOWnHPsGO652QG9v6ey4a9xz/n+6hjXFOHedPrXAWqDUn7THroKayLyPhF5cYTjWSKyVkTe8Xxc6jmeISKveHrhPwFkpPsaY5qB+4BPiVuRiLwhIjs8H96l9d8ELvf07O8XkSgRedDznJUi8rEgfetKnUcDugonCcPSLc+Nc+73gIeNMSuAW4GfeI5/FXjTGLMAeA73aswRGWOOAFFANu56KtcaY8pwr8h8xHPaA8AbxpglxpiHgXtxVztcAawA/kFEZvrzzSo1UZpyUeFkpJTLaK4B5rtLmwCQ4qlqeAVwC4Ax5g8icsbH+8UAj4rIEsAJlI5y3vuBRSJym+frVGA2cNTH51HKbxrQVaSyASuNMX3DDw4L8OMSkWLcwbsZd8++CVjsuXffaJcBnzbGvOxHm5WaFE25qEj1CvBp7xeenjXARtyDmIjIDYBjpItFJAv4IfCopyZ5KtBgjHEBd+NOxQB0AsnDLn0Z+LinLC4iUuopHqdU0GkPXUWqzwA/EJFK3K/zjcA/Al8HnhKRPcAm3FU6vRJEZBfu9MoQ8EvAW9b2f4G1IvJhYD3Q7TleCThFZDfwOO7cfRGww1PKtgXPFnJKBZtWW1RKqQihKRellIoQGtCVUipCaEBXSqkIoQFdKaUihAZ0pZSKEBrQlVIqQmhAV0qpCPH/ASLaCDoYr64wAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "month = all_cases.FiledDate.dt.to_period(\"M\")\n",
    "\n",
    "delaware_cases = all_cases.query(\"County == 'delaware'\").query(\"Type == 'CM'\")\n",
    "delaware_pro_se_cases = delaware_cases.query(\"Pro_Se == True\")\n",
    "groups = [month]\n",
    "by_month=round(delaware_pro_se_cases.groupby(groups).size()/delaware_cases.groupby(groups).size()*100,2)\n",
    "by_month.plot.line()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-3\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-4\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-10\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-19\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-23\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-24\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-26\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-27\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-44\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-45\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-58\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-60\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-61\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-64\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-65\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-68\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-72\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-73\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-74\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-75\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-80\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-83\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-93\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-94\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-115\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-116\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-117\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-118\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-120\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-121\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-123\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-126\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-129\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-132\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-141\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-145\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-156\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-158\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-170\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-172\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-185\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-187\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-191\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-193\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-194\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-196\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-201\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-203\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-215\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-219\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-220\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-224\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-229\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-245\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-251\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-252\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-253\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-259\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-264\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-270\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-272\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-274\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-278\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-282\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-289\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-290\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-293\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-305\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-310\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-313\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-318\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-319\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-320\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-323\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-329\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-332\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-335\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-351\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-352\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-354\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-355\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-363\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-370\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-380\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-382\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-386\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-389\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-390\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-399\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-407\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-413\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-420\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-440\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-445\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-456\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-460\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-464\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-465\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-467\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-476\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-480\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-481\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-483\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-484\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-487\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-490\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-492\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-499\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-503\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-508\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-509\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-510\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-516\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-519\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-522\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-526\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-529\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-532\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-546\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-548\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-550\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-551\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-552\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-553\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-557\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-565\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-567\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-569\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-571\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-574\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-578\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-583\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-593\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-597\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-599\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-609\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-617\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-619\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-625\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-632\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-633\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-635\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-640\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-652\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-660\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-674\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-675\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-676\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-677\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-680\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-681\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-682\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-683\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-689\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-691\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-696\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-701\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-709\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-711\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-715\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-726\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-728\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-732\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-737\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-748\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-749\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-755\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-756\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-760\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-768\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-771\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-775\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-779\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-781\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-785\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-789\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-803\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-804\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-805\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-806\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-811\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-819\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-820\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-822\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-823\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-824\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-825\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-829\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-830\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-831\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-835\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-839\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-846\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-849\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-853\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-855\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-871\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-872\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-878\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-879\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-892\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2017-903\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-9\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-10\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-11\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-12\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-14\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-15\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-16\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-19\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-23\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-32\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-38\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-41\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-44\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-59\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-61\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-83\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-84\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-94\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-98\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-99\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-107\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-112\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-117\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-121\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-126\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-136\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-137\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-140\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-141\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-149\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-173\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-174\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-184\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-187\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-189\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-190\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-199\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-214\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-215\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-219\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-220\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-226\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-228\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-239\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-245\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-252\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-262\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-273\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-277\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-278\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-279\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-283\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-308\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-314\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-317\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-320\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-325\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-328\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-336\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-338\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-358\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-361\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-366\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-384\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-412\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-423\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-425\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-427\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-440\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-448\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-453\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-461\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-463\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-469\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-470\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-477\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-482\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-485\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-497\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-501\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-504\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-511\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-512\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-514\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-532\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-541\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-565\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-576\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-579\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-580\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-582\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-594\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-640\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-663\n",
      "https://www.oscn.net/dockets/GetCaseInformation.aspx?db=delaware&number=CM-2018-669\n"
     ]
    }
   ],
   "source": [
    "for source in delaware_pro_se_cases['Source']:\n",
    "    print(source)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "colab": {
   "name": "delaware county pro se.ipynb",
   "provenance": [],
   "toc_visible": true,
   "version": "0.3.2"
  },
  "kernelspec": {
   "display_name": "Python 3",
   "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}