Louisville Metro Animal Services.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Animal Control Data Set For 2005 -2017\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "scrolled": true
   },
   "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>AnimalID</th>\n",
       "      <th>AnimalType</th>\n",
       "      <th>IntakeDate</th>\n",
       "      <th>IntakeType</th>\n",
       "      <th>IntakeSubtype</th>\n",
       "      <th>PrimaryColor</th>\n",
       "      <th>PrimaryBreed</th>\n",
       "      <th>SecondaryBreed</th>\n",
       "      <th>Gender</th>\n",
       "      <th>SecondaryColor</th>\n",
       "      <th>...</th>\n",
       "      <th>IntakeInternalStatus</th>\n",
       "      <th>IntakeAsilomarStatus</th>\n",
       "      <th>ReproductiveStatusAtIntake</th>\n",
       "      <th>OutcomeDate</th>\n",
       "      <th>OutcomeType</th>\n",
       "      <th>OutcomeSubtype</th>\n",
       "      <th>OutcomeReason</th>\n",
       "      <th>OutcomeInternalStatus</th>\n",
       "      <th>OutcomeAsilomarStatus</th>\n",
       "      <th>ReproductiveStatusAtOutcome</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A366370</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2008-11-07 10:50:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>...</td>\n",
       "      <td>FEARFUL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2008-11-12 15:46:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>FERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNHEALTHY/UNTREATABLE</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A366531</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2008-11-10 10:20:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2008-11-19 20:10:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>CONTAG DIS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SICK</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A532367</td>\n",
       "      <td>BIRD</td>\n",
       "      <td>2014-07-23 23:21:00</td>\n",
       "      <td>CONFISCATE</td>\n",
       "      <td>CRUELTY</td>\n",
       "      <td>RED</td>\n",
       "      <td>CHICKEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MALE</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>...</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2014-11-05 15:49:00</td>\n",
       "      <td>TRANSFER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A532474</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>2014-07-24 18:29:00</td>\n",
       "      <td>ET REQUEST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>BAT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2014-07-24 23:59:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>MEDICAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A281756</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2006-09-11 18:10:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MALE</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2006-09-12 13:44:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>A451184</td>\n",
       "      <td>BIRD</td>\n",
       "      <td>2012-01-29 15:25:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>CHICKEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2012-02-22 23:59:00</td>\n",
       "      <td>TRANSFER</td>\n",
       "      <td>RESCUE GRP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>A256128</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2005-11-26 12:35:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>AMERICAN PIT BULL TERRIER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>MALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-12-08 23:59:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>MEDICAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>A314432</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2007-06-15 17:13:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BROWN TABBY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2007-06-15 18:07:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>A316619</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2007-06-29 20:10:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>LABRADOR RETRIEVER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>MALE</td>\n",
       "      <td>TAN</td>\n",
       "      <td>...</td>\n",
       "      <td>FEARFUL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2007-07-04 13:12:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>A317335</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2007-07-05 21:30:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2007-07-11 09:19:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>A317465</td>\n",
       "      <td>BIRD</td>\n",
       "      <td>2007-07-06 18:32:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>PIGEON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>INJURED</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2007-07-07 17:02:00</td>\n",
       "      <td>RELEASED</td>\n",
       "      <td>MEDICAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>A317486</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2007-07-06 22:21:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NURSING</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2007-07-12 19:01:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>A318485</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2007-07-14 13:29:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>DOMESTIC LONGHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2007-07-14 12:34:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>A318496</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2007-07-14 14:39:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK TIGER</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2007-07-19 17:25:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>A318533</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2007-07-14 21:41:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>DOMESTIC MEDIUMHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>SICK</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2007-07-15 03:44:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>MEDICAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>A319056</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2007-07-19 22:32:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>TRICOLOR</td>\n",
       "      <td>BEAGLE</td>\n",
       "      <td>MIX</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2007-08-07 12:13:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>A325393</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2007-09-01 14:37:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>NURSING</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2007-09-06 08:13:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>CONTAG DIS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>A258842</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2005-12-21 14:30:00</td>\n",
       "      <td>CONFISCATE</td>\n",
       "      <td>NEGLECT</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-12-29 11:05:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>BREED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>A258896</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2005-12-22 12:23:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BROWN BRINDLE</td>\n",
       "      <td>AMERICAN PIT BULL TERRIER</td>\n",
       "      <td>AMERICAN PIT BULL TERRIER</td>\n",
       "      <td>MALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-12-28 10:35:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>BREED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>A252704</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2005-10-15 10:48:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>TAN</td>\n",
       "      <td>AIREDALE TERRIER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-10-20 23:59:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>A252809</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2005-10-17 13:45:00</td>\n",
       "      <td>KHS</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>BLACK TIGER</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-10-22 23:59:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>A253104</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2005-10-19 22:25:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>INJURED</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-10-25 23:59:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>A254123</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2005-10-31 12:58:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-11-08 23:59:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>A503690</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2013-09-17 11:01:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2013-09-27 07:51:00</td>\n",
       "      <td>TNR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>A000120</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2005-03-15 12:00:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>BEAGLE</td>\n",
       "      <td>MIX</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-03-19 12:00:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>BREED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>A000604</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2005-03-21 12:42:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>CHINESE SHARPEI</td>\n",
       "      <td>MIX</td>\n",
       "      <td>MALE</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>...</td>\n",
       "      <td>FEARFUL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-03-26 09:00:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>BREED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>A000613</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2005-03-21 13:38:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>LABRADOR RETRIEVER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>FEARFUL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-03-26 10:00:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>SPACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>A276806</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2006-07-26 11:19:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>LABRADOR RETRIEVER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>MALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2006-08-03 12:30:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>A276968</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2006-07-27 14:32:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>ORANGE</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2006-08-05 18:30:00</td>\n",
       "      <td>MISSING</td>\n",
       "      <td>IN KENNEL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>A254608</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2005-11-07 11:14:00</td>\n",
       "      <td>KHS</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>DOMESTIC MEDIUMHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-11-12 08:30:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150812</th>\n",
       "      <td>A476498</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2012-09-19 16:53:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>JACK RUSS TER</td>\n",
       "      <td>CHIHUAHUA - SMOOTH COATED</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2012-10-23 17:00:00</td>\n",
       "      <td>TRANSFER</td>\n",
       "      <td>RESCUE GRP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150813</th>\n",
       "      <td>A564768</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2015-06-30 13:14:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>TAN</td>\n",
       "      <td>LHASA APSO</td>\n",
       "      <td>MIX</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2015-07-01 16:08:00</td>\n",
       "      <td>RTO</td>\n",
       "      <td>IN KENNEL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150814</th>\n",
       "      <td>A387290</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2009-06-24 09:02:00</td>\n",
       "      <td>OUTSURGERY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TAN</td>\n",
       "      <td>JACK RUSS TER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2009-06-24 15:46:00</td>\n",
       "      <td>RELEASED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150815</th>\n",
       "      <td>A478925</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2012-11-05 12:20:00</td>\n",
       "      <td>FOSTER</td>\n",
       "      <td>RETURN</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>BEAGLE</td>\n",
       "      <td>MIX</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2012-11-13 12:51:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>WEB PF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150816</th>\n",
       "      <td>A621065</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2017-07-03 13:08:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>TAN</td>\n",
       "      <td>CHIHUAHUA - SMOOTH COATED</td>\n",
       "      <td>FRENCH BULLDOG</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2017-07-13 15:51:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>FRIEND</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150817</th>\n",
       "      <td>A469834</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2012-07-11 11:51:00</td>\n",
       "      <td>FOSTER</td>\n",
       "      <td>RETURN</td>\n",
       "      <td>TAN</td>\n",
       "      <td>JACK RUSS TER</td>\n",
       "      <td>BEAGLE</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2012-07-12 17:49:00</td>\n",
       "      <td>FOSTER</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150818</th>\n",
       "      <td>A527800</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2014-05-29 17:54:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BROWN TABBY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2014-09-17 16:23:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>PS OUTER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150819</th>\n",
       "      <td>A583664</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2016-06-07 14:10:00</td>\n",
       "      <td>RETURN</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2016-08-07 14:40:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>INTERNET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150820</th>\n",
       "      <td>A434644</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2011-04-05 17:24:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BROWN TABBY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>ORANGE</td>\n",
       "      <td>...</td>\n",
       "      <td>SICK</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2011-06-30 14:35:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>PS HURST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150821</th>\n",
       "      <td>A473630</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2012-12-18 16:39:00</td>\n",
       "      <td>CONFISCATE</td>\n",
       "      <td>POTDANGER</td>\n",
       "      <td>TAN</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>AGGRESSIVE</td>\n",
       "      <td>UNHEALTHY/UNTREATABLE</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2013-01-26 14:16:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>BEHAV OBSV</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150822</th>\n",
       "      <td>A579169</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2016-01-27 07:54:00</td>\n",
       "      <td>FOSTER</td>\n",
       "      <td>RETURN</td>\n",
       "      <td>ORANGE TABBY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2016-01-30 13:29:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>WALK IN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150823</th>\n",
       "      <td>A402275</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2010-01-09 19:51:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>TAN</td>\n",
       "      <td>GERMAN SHEPHERD DOG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2010-01-25 15:06:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>FRIEND</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150824</th>\n",
       "      <td>A411362</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2010-05-11 11:48:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>SHIH TZU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2010-05-29 14:56:00</td>\n",
       "      <td>TRANSFER</td>\n",
       "      <td>RESCUE GRP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150825</th>\n",
       "      <td>A495208</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2013-06-26 17:05:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>FEIST</td>\n",
       "      <td>PARSON (JACK) RUSSELL TERRIER</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>...</td>\n",
       "      <td>FEARFUL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2013-07-03 15:08:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>WALK IN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150826</th>\n",
       "      <td>A617282</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2017-05-15 19:09:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>BORDER COLLIE</td>\n",
       "      <td>MIX</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2017-05-31 18:08:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>FRIEND</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150827</th>\n",
       "      <td>A466610</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2012-05-22 13:24:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>CALICO</td>\n",
       "      <td>DOMESTIC MEDIUMHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>FERAL</td>\n",
       "      <td>UNHEALTHY/UNTREATABLE</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2012-06-01 12:54:00</td>\n",
       "      <td>FOSTER</td>\n",
       "      <td>TOO YOUNG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150828</th>\n",
       "      <td>A608544</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2017-01-22 16:06:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>BOXER</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2017-03-15 23:59:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>PRV ADOPT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150829</th>\n",
       "      <td>A568829</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2015-10-08 14:25:00</td>\n",
       "      <td>FOSTER</td>\n",
       "      <td>RETURN</td>\n",
       "      <td>GRAY TABBY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2015-10-08 14:26:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>FOSTER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150830</th>\n",
       "      <td>A429494</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2011-01-06 18:34:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>DACHSHUND</td>\n",
       "      <td>WELSH CORGI - PEMBROKE</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>RED</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2011-01-30 10:48:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>PROMO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150831</th>\n",
       "      <td>A600994</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2016-09-23 12:22:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>WEST HIGHLAND WHITE TERRIER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2016-10-05 11:40:00</td>\n",
       "      <td>TRANSFER</td>\n",
       "      <td>RESCUE GRP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150832</th>\n",
       "      <td>A436502</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2011-05-03 21:26:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>LABRADOR RETRIEVER</td>\n",
       "      <td>BEAGLE</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2011-06-03 16:01:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>TV WHAS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150833</th>\n",
       "      <td>A499953</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2013-09-11 13:35:00</td>\n",
       "      <td>FOSTER</td>\n",
       "      <td>RETURN</td>\n",
       "      <td>TORTIE</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2013-10-09 16:12:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>PS OUTER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150834</th>\n",
       "      <td>A511345</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2013-11-19 18:57:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>DOMESTIC MEDIUMHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2014-01-09 13:58:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>INTERNET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150835</th>\n",
       "      <td>A489623</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2013-04-17 23:01:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>APRICOT</td>\n",
       "      <td>DANDIE DINMONT TERRIER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2013-05-08 16:19:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>INTERNET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150836</th>\n",
       "      <td>A493152</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2013-06-04 11:02:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>DACHSHUND - WIREHAIRED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>TAN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2013-06-16 12:55:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>WEB PF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150837</th>\n",
       "      <td>A591486</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2016-06-02 14:48:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>YELLOW BRINDLE</td>\n",
       "      <td>GREYHOUND</td>\n",
       "      <td>MIX</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2016-06-25 16:22:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>FRIEND</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150838</th>\n",
       "      <td>A523743</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2014-04-16 12:05:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>CREAM</td>\n",
       "      <td>CAIRN TERRIER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2014-04-23 15:11:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>INTERNET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150839</th>\n",
       "      <td>A369002</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2013-01-23 13:59:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>MINIATURE PINSCHER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2013-01-31 14:52:00</td>\n",
       "      <td>TRANSFER</td>\n",
       "      <td>KHS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150840</th>\n",
       "      <td>A439252</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2016-08-01 17:43:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK TABBY</td>\n",
       "      <td>DOMESTIC MEDIUMHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>EMACIATED</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2016-08-02 14:26:00</td>\n",
       "      <td>RTO</td>\n",
       "      <td>IN KENNEL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150841</th>\n",
       "      <td>A424601</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2013-07-19 13:02:00</td>\n",
       "      <td>ET REQUEST</td>\n",
       "      <td>SICK</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>...</td>\n",
       "      <td>INJURED</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2013-07-19 23:59:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>REQUESTED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>150842 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       AnimalID AnimalType           IntakeDate  IntakeType IntakeSubtype  \\\n",
       "0       A366370        CAT  2008-11-07 10:50:00       STRAY           OTC   \n",
       "1       A366531        CAT  2008-11-10 10:20:00       STRAY           OTC   \n",
       "2       A532367       BIRD  2014-07-23 23:21:00  CONFISCATE       CRUELTY   \n",
       "3       A532474      OTHER  2014-07-24 18:29:00  ET REQUEST           NaN   \n",
       "4       A281756        DOG  2006-09-11 18:10:00   OWNER SUR           OTC   \n",
       "5       A451184       BIRD  2012-01-29 15:25:00   OWNER SUR         FIELD   \n",
       "6       A256128        DOG  2005-11-26 12:35:00       STRAY         FIELD   \n",
       "7       A314432        CAT  2007-06-15 17:13:00   OWNER SUR           OTC   \n",
       "8       A316619        DOG  2007-06-29 20:10:00       STRAY         FIELD   \n",
       "9       A317335        CAT  2007-07-05 21:30:00       STRAY           OTC   \n",
       "10      A317465       BIRD  2007-07-06 18:32:00       STRAY         FIELD   \n",
       "11      A317486        CAT  2007-07-06 22:21:00       STRAY           OTC   \n",
       "12      A318485        CAT  2007-07-14 13:29:00   OWNER SUR           OTC   \n",
       "13      A318496        CAT  2007-07-14 14:39:00       STRAY         FIELD   \n",
       "14      A318533        CAT  2007-07-14 21:41:00       STRAY         FIELD   \n",
       "15      A319056        DOG  2007-07-19 22:32:00       STRAY           OTC   \n",
       "16      A325393        CAT  2007-09-01 14:37:00       STRAY           OTC   \n",
       "17      A258842        DOG  2005-12-21 14:30:00  CONFISCATE       NEGLECT   \n",
       "18      A258896        DOG  2005-12-22 12:23:00       STRAY           OTC   \n",
       "19      A252704        DOG  2005-10-15 10:48:00       STRAY           OTC   \n",
       "20      A252809        CAT  2005-10-17 13:45:00         KHS         STRAY   \n",
       "21      A253104        DOG  2005-10-19 22:25:00       STRAY         FIELD   \n",
       "22      A254123        CAT  2005-10-31 12:58:00       STRAY         FIELD   \n",
       "23      A503690        CAT  2013-09-17 11:01:00       STRAY           OTC   \n",
       "24      A000120        DOG  2005-03-15 12:00:00       STRAY           OTC   \n",
       "25      A000604        DOG  2005-03-21 12:42:00       STRAY         FIELD   \n",
       "26      A000613        DOG  2005-03-21 13:38:00       STRAY         FIELD   \n",
       "27      A276806        DOG  2006-07-26 11:19:00       STRAY         FIELD   \n",
       "28      A276968        CAT  2006-07-27 14:32:00   OWNER SUR           OTC   \n",
       "29      A254608        CAT  2005-11-07 11:14:00         KHS         STRAY   \n",
       "...         ...        ...                  ...         ...           ...   \n",
       "150812  A476498        DOG  2012-09-19 16:53:00   OWNER SUR           OTC   \n",
       "150813  A564768        DOG  2015-06-30 13:14:00       STRAY           OTC   \n",
       "150814  A387290        DOG  2009-06-24 09:02:00  OUTSURGERY           NaN   \n",
       "150815  A478925        DOG  2012-11-05 12:20:00      FOSTER        RETURN   \n",
       "150816  A621065        DOG  2017-07-03 13:08:00       STRAY           OTC   \n",
       "150817  A469834        DOG  2012-07-11 11:51:00      FOSTER        RETURN   \n",
       "150818  A527800        CAT  2014-05-29 17:54:00   OWNER SUR           OTC   \n",
       "150819  A583664        DOG  2016-06-07 14:10:00      RETURN      ADOPTION   \n",
       "150820  A434644        CAT  2011-04-05 17:24:00   OWNER SUR           OTC   \n",
       "150821  A473630        DOG  2012-12-18 16:39:00  CONFISCATE     POTDANGER   \n",
       "150822  A579169        CAT  2016-01-27 07:54:00      FOSTER        RETURN   \n",
       "150823  A402275        DOG  2010-01-09 19:51:00       STRAY         FIELD   \n",
       "150824  A411362        DOG  2010-05-11 11:48:00   OWNER SUR           OTC   \n",
       "150825  A495208        DOG  2013-06-26 17:05:00   OWNER SUR           OTC   \n",
       "150826  A617282        DOG  2017-05-15 19:09:00       STRAY         FIELD   \n",
       "150827  A466610        CAT  2012-05-22 13:24:00       STRAY         FIELD   \n",
       "150828  A608544        DOG  2017-01-22 16:06:00       STRAY         FIELD   \n",
       "150829  A568829        CAT  2015-10-08 14:25:00      FOSTER        RETURN   \n",
       "150830  A429494        DOG  2011-01-06 18:34:00   OWNER SUR           OTC   \n",
       "150831  A600994        DOG  2016-09-23 12:22:00       STRAY           OTC   \n",
       "150832  A436502        DOG  2011-05-03 21:26:00   OWNER SUR         FIELD   \n",
       "150833  A499953        CAT  2013-09-11 13:35:00      FOSTER        RETURN   \n",
       "150834  A511345        CAT  2013-11-19 18:57:00       STRAY         FIELD   \n",
       "150835  A489623        DOG  2013-04-17 23:01:00       STRAY         FIELD   \n",
       "150836  A493152        DOG  2013-06-04 11:02:00       STRAY         FIELD   \n",
       "150837  A591486        DOG  2016-06-02 14:48:00   OWNER SUR           OTC   \n",
       "150838  A523743        DOG  2014-04-16 12:05:00       STRAY           OTC   \n",
       "150839  A369002        DOG  2013-01-23 13:59:00       STRAY           OTC   \n",
       "150840  A439252        CAT  2016-08-01 17:43:00       STRAY         FIELD   \n",
       "150841  A424601        CAT  2013-07-19 13:02:00  ET REQUEST          SICK   \n",
       "\n",
       "          PrimaryColor                 PrimaryBreed  \\\n",
       "0                WHITE           DOMESTIC SHORTHAIR   \n",
       "1                BLACK           DOMESTIC SHORTHAIR   \n",
       "2                  RED                      CHICKEN   \n",
       "3                BROWN                          BAT   \n",
       "4                WHITE             PIT BULL TERRIER   \n",
       "5                BLACK                      CHICKEN   \n",
       "6                BROWN    AMERICAN PIT BULL TERRIER   \n",
       "7          BROWN TABBY           DOMESTIC SHORTHAIR   \n",
       "8                WHITE           LABRADOR RETRIEVER   \n",
       "9                 GRAY           DOMESTIC SHORTHAIR   \n",
       "10                GRAY                       PIGEON   \n",
       "11                GRAY           DOMESTIC SHORTHAIR   \n",
       "12               BLACK            DOMESTIC LONGHAIR   \n",
       "13         BLACK TIGER           DOMESTIC SHORTHAIR   \n",
       "14               BLACK          DOMESTIC MEDIUMHAIR   \n",
       "15            TRICOLOR                       BEAGLE   \n",
       "16                GRAY           DOMESTIC SHORTHAIR   \n",
       "17               WHITE             PIT BULL TERRIER   \n",
       "18       BROWN BRINDLE    AMERICAN PIT BULL TERRIER   \n",
       "19                 TAN             AIREDALE TERRIER   \n",
       "20         BLACK TIGER           DOMESTIC SHORTHAIR   \n",
       "21               BLACK             PIT BULL TERRIER   \n",
       "22               BLACK           DOMESTIC SHORTHAIR   \n",
       "23               BLACK           DOMESTIC SHORTHAIR   \n",
       "24               BLACK                       BEAGLE   \n",
       "25               BROWN              CHINESE SHARPEI   \n",
       "26               BLACK           LABRADOR RETRIEVER   \n",
       "27               BLACK           LABRADOR RETRIEVER   \n",
       "28              ORANGE           DOMESTIC SHORTHAIR   \n",
       "29                GRAY          DOMESTIC MEDIUMHAIR   \n",
       "...                ...                          ...   \n",
       "150812           BLACK                JACK RUSS TER   \n",
       "150813             TAN                   LHASA APSO   \n",
       "150814             TAN                JACK RUSS TER   \n",
       "150815           BLACK                       BEAGLE   \n",
       "150816             TAN    CHIHUAHUA - SMOOTH COATED   \n",
       "150817             TAN                JACK RUSS TER   \n",
       "150818     BROWN TABBY           DOMESTIC SHORTHAIR   \n",
       "150819           BROWN             PIT BULL TERRIER   \n",
       "150820     BROWN TABBY           DOMESTIC SHORTHAIR   \n",
       "150821             TAN             PIT BULL TERRIER   \n",
       "150822    ORANGE TABBY           DOMESTIC SHORTHAIR   \n",
       "150823             TAN          GERMAN SHEPHERD DOG   \n",
       "150824           BLACK                     SHIH TZU   \n",
       "150825           WHITE                        FEIST   \n",
       "150826           BLACK                BORDER COLLIE   \n",
       "150827          CALICO          DOMESTIC MEDIUMHAIR   \n",
       "150828           BROWN             PIT BULL TERRIER   \n",
       "150829      GRAY TABBY           DOMESTIC SHORTHAIR   \n",
       "150830           BROWN                    DACHSHUND   \n",
       "150831           WHITE  WEST HIGHLAND WHITE TERRIER   \n",
       "150832           BLACK           LABRADOR RETRIEVER   \n",
       "150833          TORTIE           DOMESTIC SHORTHAIR   \n",
       "150834           BLACK          DOMESTIC MEDIUMHAIR   \n",
       "150835         APRICOT       DANDIE DINMONT TERRIER   \n",
       "150836           BLACK       DACHSHUND - WIREHAIRED   \n",
       "150837  YELLOW BRINDLE                    GREYHOUND   \n",
       "150838           CREAM                CAIRN TERRIER   \n",
       "150839           BLACK           MINIATURE PINSCHER   \n",
       "150840     BLACK TABBY          DOMESTIC MEDIUMHAIR   \n",
       "150841            GRAY           DOMESTIC SHORTHAIR   \n",
       "\n",
       "                       SecondaryBreed         Gender SecondaryColor  ...  \\\n",
       "0                                 NaN  NEUTERED MALE          BROWN  ...   \n",
       "1                  DOMESTIC SHORTHAIR        UNKNOWN            NaN  ...   \n",
       "2                                 NaN           MALE          BLACK  ...   \n",
       "3                                 NaN        UNKNOWN            NaN  ...   \n",
       "4                                 NaN           MALE          BROWN  ...   \n",
       "5                                 NaN        UNKNOWN          WHITE  ...   \n",
       "6                                 MIX           MALE          WHITE  ...   \n",
       "7                                 NaN        UNKNOWN            NaN  ...   \n",
       "8                                 MIX           MALE            TAN  ...   \n",
       "9                                 NaN        UNKNOWN            NaN  ...   \n",
       "10                                NaN        UNKNOWN            NaN  ...   \n",
       "11                                NaN         FEMALE            NaN  ...   \n",
       "12                                NaN  SPAYED FEMALE          WHITE  ...   \n",
       "13                                NaN        UNKNOWN            NaN  ...   \n",
       "14                                NaN  NEUTERED MALE          WHITE  ...   \n",
       "15                                MIX  NEUTERED MALE            NaN  ...   \n",
       "16                                NaN         FEMALE          WHITE  ...   \n",
       "17                                NaN           MALE            NaN  ...   \n",
       "18          AMERICAN PIT BULL TERRIER           MALE          WHITE  ...   \n",
       "19                                MIX         FEMALE            NaN  ...   \n",
       "20                                NaN           MALE            NaN  ...   \n",
       "21                                NaN           MALE          WHITE  ...   \n",
       "22                                NaN           MALE            NaN  ...   \n",
       "23                                NaN           MALE          WHITE  ...   \n",
       "24                                MIX         FEMALE          WHITE  ...   \n",
       "25                                MIX           MALE          BROWN  ...   \n",
       "26                                MIX         FEMALE          WHITE  ...   \n",
       "27                                MIX           MALE            NaN  ...   \n",
       "28                                NaN           MALE            NaN  ...   \n",
       "29                                NaN           MALE          WHITE  ...   \n",
       "...                               ...            ...            ...  ...   \n",
       "150812      CHIHUAHUA - SMOOTH COATED  SPAYED FEMALE          WHITE  ...   \n",
       "150813                            MIX  NEUTERED MALE          BROWN  ...   \n",
       "150814                            MIX  SPAYED FEMALE            NaN  ...   \n",
       "150815                            MIX  SPAYED FEMALE          BROWN  ...   \n",
       "150816                 FRENCH BULLDOG  SPAYED FEMALE            NaN  ...   \n",
       "150817                         BEAGLE  NEUTERED MALE          WHITE  ...   \n",
       "150818                            NaN  NEUTERED MALE            NaN  ...   \n",
       "150819                            NaN  SPAYED FEMALE          WHITE  ...   \n",
       "150820                            NaN  SPAYED FEMALE         ORANGE  ...   \n",
       "150821                            NaN  SPAYED FEMALE            NaN  ...   \n",
       "150822                            NaN  NEUTERED MALE            NaN  ...   \n",
       "150823                            NaN  NEUTERED MALE          BLACK  ...   \n",
       "150824                            NaN  NEUTERED MALE           GRAY  ...   \n",
       "150825  PARSON (JACK) RUSSELL TERRIER  NEUTERED MALE          BLACK  ...   \n",
       "150826                            MIX  NEUTERED MALE          WHITE  ...   \n",
       "150827                            NaN  SPAYED FEMALE            NaN  ...   \n",
       "150828                          BOXER  NEUTERED MALE            NaN  ...   \n",
       "150829                            NaN  NEUTERED MALE          WHITE  ...   \n",
       "150830         WELSH CORGI - PEMBROKE  SPAYED FEMALE            RED  ...   \n",
       "150831                            NaN  NEUTERED MALE            NaN  ...   \n",
       "150832                         BEAGLE  SPAYED FEMALE          WHITE  ...   \n",
       "150833                            NaN  SPAYED FEMALE            NaN  ...   \n",
       "150834                            NaN  SPAYED FEMALE            NaN  ...   \n",
       "150835                            MIX  NEUTERED MALE            NaN  ...   \n",
       "150836                            NaN  SPAYED FEMALE            TAN  ...   \n",
       "150837                            MIX  NEUTERED MALE            NaN  ...   \n",
       "150838                            NaN  SPAYED FEMALE            NaN  ...   \n",
       "150839                            NaN  NEUTERED MALE          BROWN  ...   \n",
       "150840                            NaN  SPAYED FEMALE          WHITE  ...   \n",
       "150841                            NaN  SPAYED FEMALE          WHITE  ...   \n",
       "\n",
       "       IntakeInternalStatus   IntakeAsilomarStatus ReproductiveStatusAtIntake  \\\n",
       "0                   FEARFUL                HEALTHY                    ALTERED   \n",
       "1                    NORMAL                HEALTHY                    UNKNOWN   \n",
       "2                     OTHER                HEALTHY                    FERTILE   \n",
       "3                     OTHER                HEALTHY                    UNKNOWN   \n",
       "4                    NORMAL                HEALTHY                    FERTILE   \n",
       "5                    NORMAL                HEALTHY                    UNKNOWN   \n",
       "6                    NORMAL                HEALTHY                    FERTILE   \n",
       "7                    NORMAL                HEALTHY                    UNKNOWN   \n",
       "8                   FEARFUL                HEALTHY                    FERTILE   \n",
       "9                    NORMAL                HEALTHY                    UNKNOWN   \n",
       "10                  INJURED                HEALTHY                    UNKNOWN   \n",
       "11                  NURSING                HEALTHY                    FERTILE   \n",
       "12                   NORMAL                HEALTHY                    ALTERED   \n",
       "13                   NORMAL                HEALTHY                    UNKNOWN   \n",
       "14                     SICK                HEALTHY                    ALTERED   \n",
       "15                   NORMAL                HEALTHY                    ALTERED   \n",
       "16                  NURSING                HEALTHY                    FERTILE   \n",
       "17                   NORMAL                HEALTHY                    FERTILE   \n",
       "18                   NORMAL                HEALTHY                    FERTILE   \n",
       "19                   NORMAL                HEALTHY                    FERTILE   \n",
       "20                   NORMAL                HEALTHY                    FERTILE   \n",
       "21                  INJURED                HEALTHY                    FERTILE   \n",
       "22                   NORMAL                HEALTHY                    FERTILE   \n",
       "23                   NORMAL                HEALTHY                    FERTILE   \n",
       "24                   NORMAL                HEALTHY                    FERTILE   \n",
       "25                  FEARFUL                HEALTHY                    FERTILE   \n",
       "26                  FEARFUL                HEALTHY                    FERTILE   \n",
       "27                   NORMAL                HEALTHY                    FERTILE   \n",
       "28                   NORMAL                HEALTHY                    FERTILE   \n",
       "29                   NORMAL                HEALTHY                    FERTILE   \n",
       "...                     ...                    ...                        ...   \n",
       "150812               NORMAL                HEALTHY                    FERTILE   \n",
       "150813               NORMAL                HEALTHY                    FERTILE   \n",
       "150814               NORMAL                HEALTHY                    FERTILE   \n",
       "150815               NORMAL                HEALTHY                    FERTILE   \n",
       "150816               NORMAL                HEALTHY                    FERTILE   \n",
       "150817               NORMAL                HEALTHY                    FERTILE   \n",
       "150818               NORMAL                HEALTHY                    FERTILE   \n",
       "150819               NORMAL                HEALTHY                    ALTERED   \n",
       "150820                 SICK                HEALTHY                    FERTILE   \n",
       "150821           AGGRESSIVE  UNHEALTHY/UNTREATABLE                    ALTERED   \n",
       "150822               NORMAL                HEALTHY                    FERTILE   \n",
       "150823               NORMAL                HEALTHY                    FERTILE   \n",
       "150824               NORMAL                HEALTHY                    FERTILE   \n",
       "150825              FEARFUL                HEALTHY                    FERTILE   \n",
       "150826               NORMAL                HEALTHY                    FERTILE   \n",
       "150827                FERAL  UNHEALTHY/UNTREATABLE                    FERTILE   \n",
       "150828               NORMAL                HEALTHY                    FERTILE   \n",
       "150829               NORMAL                HEALTHY                    ALTERED   \n",
       "150830               NORMAL                HEALTHY                    FERTILE   \n",
       "150831               NORMAL                HEALTHY                    FERTILE   \n",
       "150832               NORMAL                HEALTHY                    FERTILE   \n",
       "150833               NORMAL                HEALTHY                    ALTERED   \n",
       "150834               NORMAL                HEALTHY                    FERTILE   \n",
       "150835               NORMAL                HEALTHY                    FERTILE   \n",
       "150836               NORMAL                HEALTHY                    FERTILE   \n",
       "150837               NORMAL                HEALTHY                    FERTILE   \n",
       "150838               NORMAL                HEALTHY                    FERTILE   \n",
       "150839               NORMAL                HEALTHY                    ALTERED   \n",
       "150840            EMACIATED                HEALTHY                    ALTERED   \n",
       "150841              INJURED                HEALTHY                    ALTERED   \n",
       "\n",
       "                OutcomeDate OutcomeType OutcomeSubtype OutcomeReason  \\\n",
       "0       2008-11-12 15:46:00        EUTH          FERAL           NaN   \n",
       "1       2008-11-19 20:10:00        EUTH     CONTAG DIS           NaN   \n",
       "2       2014-11-05 15:49:00    TRANSFER            NaN           NaN   \n",
       "3       2014-07-24 23:59:00        EUTH        MEDICAL           NaN   \n",
       "4       2006-09-12 13:44:00        EUTH     TIME/SPACE           NaN   \n",
       "5       2012-02-22 23:59:00    TRANSFER     RESCUE GRP           NaN   \n",
       "6       2005-12-08 23:59:00        EUTH        MEDICAL           NaN   \n",
       "7       2007-06-15 18:07:00        EUTH     TIME/SPACE           NaN   \n",
       "8       2007-07-04 13:12:00        EUTH     TIME/SPACE           NaN   \n",
       "9       2007-07-11 09:19:00        EUTH     TIME/SPACE           NaN   \n",
       "10      2007-07-07 17:02:00    RELEASED        MEDICAL           NaN   \n",
       "11      2007-07-12 19:01:00        EUTH     TIME/SPACE           NaN   \n",
       "12      2007-07-14 12:34:00        EUTH     TIME/SPACE           NaN   \n",
       "13      2007-07-19 17:25:00        EUTH     TIME/SPACE           NaN   \n",
       "14      2007-07-15 03:44:00        EUTH        MEDICAL           NaN   \n",
       "15      2007-08-07 12:13:00        EUTH     TIME/SPACE           NaN   \n",
       "16      2007-09-06 08:13:00        EUTH     CONTAG DIS           NaN   \n",
       "17      2005-12-29 11:05:00        EUTH          BREED           NaN   \n",
       "18      2005-12-28 10:35:00        EUTH          BREED           NaN   \n",
       "19      2005-10-20 23:59:00        EUTH     TIME/SPACE           NaN   \n",
       "20      2005-10-22 23:59:00        EUTH     TIME/SPACE           NaN   \n",
       "21      2005-10-25 23:59:00        EUTH     TIME/SPACE           NaN   \n",
       "22      2005-11-08 23:59:00        EUTH     TIME/SPACE           NaN   \n",
       "23      2013-09-27 07:51:00         TNR            NaN           NaN   \n",
       "24      2005-03-19 12:00:00        EUTH          BREED           NaN   \n",
       "25      2005-03-26 09:00:00        EUTH          BREED           NaN   \n",
       "26      2005-03-26 10:00:00        EUTH          SPACE           NaN   \n",
       "27      2006-08-03 12:30:00        EUTH     TIME/SPACE           NaN   \n",
       "28      2006-08-05 18:30:00     MISSING      IN KENNEL           NaN   \n",
       "29      2005-11-12 08:30:00        EUTH     TIME/SPACE           NaN   \n",
       "...                     ...         ...            ...           ...   \n",
       "150812  2012-10-23 17:00:00    TRANSFER     RESCUE GRP           NaN   \n",
       "150813  2015-07-01 16:08:00         RTO      IN KENNEL           NaN   \n",
       "150814  2009-06-24 15:46:00    RELEASED            NaN           NaN   \n",
       "150815  2012-11-13 12:51:00    ADOPTION         WEB PF           NaN   \n",
       "150816  2017-07-13 15:51:00    ADOPTION         FRIEND           NaN   \n",
       "150817  2012-07-12 17:49:00      FOSTER     TIME/SPACE           NaN   \n",
       "150818  2014-09-17 16:23:00    ADOPTION       PS OUTER           NaN   \n",
       "150819  2016-08-07 14:40:00    ADOPTION       INTERNET           NaN   \n",
       "150820  2011-06-30 14:35:00    ADOPTION       PS HURST           NaN   \n",
       "150821  2013-01-26 14:16:00        EUTH     BEHAV OBSV           NaN   \n",
       "150822  2016-01-30 13:29:00    ADOPTION        WALK IN           NaN   \n",
       "150823  2010-01-25 15:06:00    ADOPTION         FRIEND           NaN   \n",
       "150824  2010-05-29 14:56:00    TRANSFER     RESCUE GRP           NaN   \n",
       "150825  2013-07-03 15:08:00    ADOPTION        WALK IN           NaN   \n",
       "150826  2017-05-31 18:08:00    ADOPTION         FRIEND           NaN   \n",
       "150827  2012-06-01 12:54:00      FOSTER      TOO YOUNG           NaN   \n",
       "150828  2017-03-15 23:59:00    ADOPTION      PRV ADOPT           NaN   \n",
       "150829  2015-10-08 14:26:00    ADOPTION         FOSTER           NaN   \n",
       "150830  2011-01-30 10:48:00    ADOPTION          PROMO           NaN   \n",
       "150831  2016-10-05 11:40:00    TRANSFER     RESCUE GRP           NaN   \n",
       "150832  2011-06-03 16:01:00    ADOPTION        TV WHAS           NaN   \n",
       "150833  2013-10-09 16:12:00    ADOPTION       PS OUTER           NaN   \n",
       "150834  2014-01-09 13:58:00    ADOPTION       INTERNET           NaN   \n",
       "150835  2013-05-08 16:19:00    ADOPTION       INTERNET           NaN   \n",
       "150836  2013-06-16 12:55:00    ADOPTION         WEB PF           NaN   \n",
       "150837  2016-06-25 16:22:00    ADOPTION         FRIEND           NaN   \n",
       "150838  2014-04-23 15:11:00    ADOPTION       INTERNET           NaN   \n",
       "150839  2013-01-31 14:52:00    TRANSFER            KHS           NaN   \n",
       "150840  2016-08-02 14:26:00         RTO      IN KENNEL           NaN   \n",
       "150841  2013-07-19 23:59:00        EUTH      REQUESTED           NaN   \n",
       "\n",
       "       OutcomeInternalStatus  OutcomeAsilomarStatus  \\\n",
       "0                        NaN  UNHEALTHY/UNTREATABLE   \n",
       "1                       SICK                HEALTHY   \n",
       "2                        NaN                HEALTHY   \n",
       "3                      OTHER                HEALTHY   \n",
       "4                        NaN                HEALTHY   \n",
       "5                     NORMAL                HEALTHY   \n",
       "6                        NaN                HEALTHY   \n",
       "7                        NaN                HEALTHY   \n",
       "8                        NaN                HEALTHY   \n",
       "9                        NaN                HEALTHY   \n",
       "10                       NaN                HEALTHY   \n",
       "11                       NaN                HEALTHY   \n",
       "12                       NaN                HEALTHY   \n",
       "13                       NaN                HEALTHY   \n",
       "14                       NaN                HEALTHY   \n",
       "15                       NaN                HEALTHY   \n",
       "16                       NaN                HEALTHY   \n",
       "17                       NaN                HEALTHY   \n",
       "18                       NaN                HEALTHY   \n",
       "19                       NaN                HEALTHY   \n",
       "20                       NaN                HEALTHY   \n",
       "21                       NaN                HEALTHY   \n",
       "22                       NaN                HEALTHY   \n",
       "23                       NaN                HEALTHY   \n",
       "24                       NaN                HEALTHY   \n",
       "25                       NaN                HEALTHY   \n",
       "26                       NaN                HEALTHY   \n",
       "27                       NaN                HEALTHY   \n",
       "28                       NaN                HEALTHY   \n",
       "29                       NaN                HEALTHY   \n",
       "...                      ...                    ...   \n",
       "150812                   NaN                HEALTHY   \n",
       "150813                NORMAL                HEALTHY   \n",
       "150814                NORMAL                HEALTHY   \n",
       "150815                   NaN                HEALTHY   \n",
       "150816                NORMAL                HEALTHY   \n",
       "150817                   NaN                HEALTHY   \n",
       "150818                NORMAL                HEALTHY   \n",
       "150819                NORMAL                HEALTHY   \n",
       "150820                   NaN                HEALTHY   \n",
       "150821                   NaN                HEALTHY   \n",
       "150822                   NaN                HEALTHY   \n",
       "150823                NORMAL                HEALTHY   \n",
       "150824                   NaN                HEALTHY   \n",
       "150825                NORMAL                HEALTHY   \n",
       "150826                NORMAL                HEALTHY   \n",
       "150827                   NaN                HEALTHY   \n",
       "150828                NORMAL                HEALTHY   \n",
       "150829                NORMAL                HEALTHY   \n",
       "150830                   NaN                HEALTHY   \n",
       "150831                   NaN                HEALTHY   \n",
       "150832                   NaN                HEALTHY   \n",
       "150833                   NaN                HEALTHY   \n",
       "150834                   NaN                HEALTHY   \n",
       "150835                NORMAL                HEALTHY   \n",
       "150836                   NaN                HEALTHY   \n",
       "150837                NORMAL                HEALTHY   \n",
       "150838                NORMAL                HEALTHY   \n",
       "150839                   NaN                HEALTHY   \n",
       "150840                   NaN                HEALTHY   \n",
       "150841                   NaN                HEALTHY   \n",
       "\n",
       "       ReproductiveStatusAtOutcome  \n",
       "0                          ALTERED  \n",
       "1                          UNKNOWN  \n",
       "2                          FERTILE  \n",
       "3                          UNKNOWN  \n",
       "4                          FERTILE  \n",
       "5                          UNKNOWN  \n",
       "6                          FERTILE  \n",
       "7                          UNKNOWN  \n",
       "8                          FERTILE  \n",
       "9                          UNKNOWN  \n",
       "10                         UNKNOWN  \n",
       "11                         FERTILE  \n",
       "12                         ALTERED  \n",
       "13                         UNKNOWN  \n",
       "14                         ALTERED  \n",
       "15                         ALTERED  \n",
       "16                         FERTILE  \n",
       "17                         FERTILE  \n",
       "18                         FERTILE  \n",
       "19                         FERTILE  \n",
       "20                         FERTILE  \n",
       "21                         FERTILE  \n",
       "22                         FERTILE  \n",
       "23                         FERTILE  \n",
       "24                         FERTILE  \n",
       "25                         FERTILE  \n",
       "26                         FERTILE  \n",
       "27                         FERTILE  \n",
       "28                         FERTILE  \n",
       "29                         FERTILE  \n",
       "...                            ...  \n",
       "150812                     ALTERED  \n",
       "150813                     ALTERED  \n",
       "150814                     ALTERED  \n",
       "150815                     ALTERED  \n",
       "150816                     ALTERED  \n",
       "150817                     ALTERED  \n",
       "150818                     ALTERED  \n",
       "150819                     ALTERED  \n",
       "150820                     ALTERED  \n",
       "150821                     ALTERED  \n",
       "150822                     ALTERED  \n",
       "150823                     ALTERED  \n",
       "150824                     ALTERED  \n",
       "150825                     ALTERED  \n",
       "150826                     ALTERED  \n",
       "150827                     FERTILE  \n",
       "150828                     ALTERED  \n",
       "150829                     ALTERED  \n",
       "150830                     ALTERED  \n",
       "150831                     ALTERED  \n",
       "150832                     ALTERED  \n",
       "150833                     ALTERED  \n",
       "150834                     ALTERED  \n",
       "150835                     ALTERED  \n",
       "150836                     ALTERED  \n",
       "150837                     ALTERED  \n",
       "150838                     ALTERED  \n",
       "150839                     ALTERED  \n",
       "150840                     ALTERED  \n",
       "150841                     ALTERED  \n",
       "\n",
       "[150842 rows x 22 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Displays basic Amimal Control information\n",
    "import sys, csv, sqlite3\n",
    "import pandas as pd\n",
    "%matplotlib inline\n",
    "animalsSurrenderOrStray = pd.read_csv(r\"Animal_IO_Data_5 Lou_KY.csv\")\n",
    "\n",
    "con = sqlite3.connect(\"Animals.db\")\n",
    "animalsSurrenderOrStray.to_sql(\"animals\", con, if_exists = \"replace\")\n",
    "animalsSurrenderOrStray"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Displayes Intake Dates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>IntakeDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2008-11-07 10:50:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2008-11-10 10:20:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014-07-23 23:21:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014-07-24 18:29:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2006-09-11 18:10:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2012-01-29 15:25:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2005-11-26 12:35:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2007-06-15 17:13:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2007-06-29 20:10:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2007-07-05 21:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2007-07-06 18:32:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2007-07-06 22:21:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2007-07-14 13:29:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2007-07-14 14:39:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2007-07-14 21:41:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2007-07-19 22:32:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2007-09-01 14:37:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2005-12-21 14:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2005-12-22 12:23:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2005-10-15 10:48:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2005-10-17 13:45:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2005-10-19 22:25:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2005-10-31 12:58:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2013-09-17 11:01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2005-03-15 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2005-03-21 12:42:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2005-03-21 13:38:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2006-07-26 11:19:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2006-07-27 14:32:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2005-11-07 11:14:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150812</th>\n",
       "      <td>2012-09-19 16:53:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150813</th>\n",
       "      <td>2015-06-30 13:14:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150814</th>\n",
       "      <td>2009-06-24 09:02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150815</th>\n",
       "      <td>2012-11-05 12:20:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150816</th>\n",
       "      <td>2017-07-03 13:08:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150817</th>\n",
       "      <td>2012-07-11 11:51:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150818</th>\n",
       "      <td>2014-05-29 17:54:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150819</th>\n",
       "      <td>2016-06-07 14:10:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150820</th>\n",
       "      <td>2011-04-05 17:24:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150821</th>\n",
       "      <td>2012-12-18 16:39:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150822</th>\n",
       "      <td>2016-01-27 07:54:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150823</th>\n",
       "      <td>2010-01-09 19:51:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150824</th>\n",
       "      <td>2010-05-11 11:48:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150825</th>\n",
       "      <td>2013-06-26 17:05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150826</th>\n",
       "      <td>2017-05-15 19:09:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150827</th>\n",
       "      <td>2012-05-22 13:24:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150828</th>\n",
       "      <td>2017-01-22 16:06:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150829</th>\n",
       "      <td>2015-10-08 14:25:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150830</th>\n",
       "      <td>2011-01-06 18:34:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150831</th>\n",
       "      <td>2016-09-23 12:22:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150832</th>\n",
       "      <td>2011-05-03 21:26:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150833</th>\n",
       "      <td>2013-09-11 13:35:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150834</th>\n",
       "      <td>2013-11-19 18:57:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150835</th>\n",
       "      <td>2013-04-17 23:01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150836</th>\n",
       "      <td>2013-06-04 11:02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150837</th>\n",
       "      <td>2016-06-02 14:48:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150838</th>\n",
       "      <td>2014-04-16 12:05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150839</th>\n",
       "      <td>2013-01-23 13:59:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150840</th>\n",
       "      <td>2016-08-01 17:43:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150841</th>\n",
       "      <td>2013-07-19 13:02:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>150842 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 IntakeDate\n",
       "0       2008-11-07 10:50:00\n",
       "1       2008-11-10 10:20:00\n",
       "2       2014-07-23 23:21:00\n",
       "3       2014-07-24 18:29:00\n",
       "4       2006-09-11 18:10:00\n",
       "5       2012-01-29 15:25:00\n",
       "6       2005-11-26 12:35:00\n",
       "7       2007-06-15 17:13:00\n",
       "8       2007-06-29 20:10:00\n",
       "9       2007-07-05 21:30:00\n",
       "10      2007-07-06 18:32:00\n",
       "11      2007-07-06 22:21:00\n",
       "12      2007-07-14 13:29:00\n",
       "13      2007-07-14 14:39:00\n",
       "14      2007-07-14 21:41:00\n",
       "15      2007-07-19 22:32:00\n",
       "16      2007-09-01 14:37:00\n",
       "17      2005-12-21 14:30:00\n",
       "18      2005-12-22 12:23:00\n",
       "19      2005-10-15 10:48:00\n",
       "20      2005-10-17 13:45:00\n",
       "21      2005-10-19 22:25:00\n",
       "22      2005-10-31 12:58:00\n",
       "23      2013-09-17 11:01:00\n",
       "24      2005-03-15 12:00:00\n",
       "25      2005-03-21 12:42:00\n",
       "26      2005-03-21 13:38:00\n",
       "27      2006-07-26 11:19:00\n",
       "28      2006-07-27 14:32:00\n",
       "29      2005-11-07 11:14:00\n",
       "...                     ...\n",
       "150812  2012-09-19 16:53:00\n",
       "150813  2015-06-30 13:14:00\n",
       "150814  2009-06-24 09:02:00\n",
       "150815  2012-11-05 12:20:00\n",
       "150816  2017-07-03 13:08:00\n",
       "150817  2012-07-11 11:51:00\n",
       "150818  2014-05-29 17:54:00\n",
       "150819  2016-06-07 14:10:00\n",
       "150820  2011-04-05 17:24:00\n",
       "150821  2012-12-18 16:39:00\n",
       "150822  2016-01-27 07:54:00\n",
       "150823  2010-01-09 19:51:00\n",
       "150824  2010-05-11 11:48:00\n",
       "150825  2013-06-26 17:05:00\n",
       "150826  2017-05-15 19:09:00\n",
       "150827  2012-05-22 13:24:00\n",
       "150828  2017-01-22 16:06:00\n",
       "150829  2015-10-08 14:25:00\n",
       "150830  2011-01-06 18:34:00\n",
       "150831  2016-09-23 12:22:00\n",
       "150832  2011-05-03 21:26:00\n",
       "150833  2013-09-11 13:35:00\n",
       "150834  2013-11-19 18:57:00\n",
       "150835  2013-04-17 23:01:00\n",
       "150836  2013-06-04 11:02:00\n",
       "150837  2016-06-02 14:48:00\n",
       "150838  2014-04-16 12:05:00\n",
       "150839  2013-01-23 13:59:00\n",
       "150840  2016-08-01 17:43:00\n",
       "150841  2013-07-19 13:02:00\n",
       "\n",
       "[150842 rows x 1 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Displayes Intake dates\n",
    "import pandas, sqlite3\n",
    "db = sqlite3.connect('Animals.db')\n",
    "pandas.read_sql_query('select IntakeDate from animals', db)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "res = pandas.read_sql_query('select * from animals', db, chunksize=100_000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "def Q(sql):\n",
    "    res = pandas.read_sql_query(sql, db, chunksize=100_000)\n",
    "    return next(res)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>index</th>\n",
       "      <th>AnimalID</th>\n",
       "      <th>AnimalType</th>\n",
       "      <th>IntakeDate</th>\n",
       "      <th>IntakeType</th>\n",
       "      <th>IntakeSubtype</th>\n",
       "      <th>PrimaryColor</th>\n",
       "      <th>PrimaryBreed</th>\n",
       "      <th>SecondaryBreed</th>\n",
       "      <th>Gender</th>\n",
       "      <th>...</th>\n",
       "      <th>IntakeInternalStatus</th>\n",
       "      <th>IntakeAsilomarStatus</th>\n",
       "      <th>ReproductiveStatusAtIntake</th>\n",
       "      <th>OutcomeDate</th>\n",
       "      <th>OutcomeType</th>\n",
       "      <th>OutcomeSubtype</th>\n",
       "      <th>OutcomeReason</th>\n",
       "      <th>OutcomeInternalStatus</th>\n",
       "      <th>OutcomeAsilomarStatus</th>\n",
       "      <th>ReproductiveStatusAtOutcome</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>A366370</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2008-11-07 10:50:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>FEARFUL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2008-11-12 15:46:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>FERAL</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>UNHEALTHY/UNTREATABLE</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>A366531</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2008-11-10 10:20:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2008-11-19 20:10:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>CONTAG DIS</td>\n",
       "      <td>None</td>\n",
       "      <td>SICK</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>A532367</td>\n",
       "      <td>BIRD</td>\n",
       "      <td>2014-07-23 23:21:00</td>\n",
       "      <td>CONFISCATE</td>\n",
       "      <td>CRUELTY</td>\n",
       "      <td>RED</td>\n",
       "      <td>CHICKEN</td>\n",
       "      <td>None</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2014-11-05 15:49:00</td>\n",
       "      <td>TRANSFER</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>A532474</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>2014-07-24 18:29:00</td>\n",
       "      <td>ET REQUEST</td>\n",
       "      <td>None</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>BAT</td>\n",
       "      <td>None</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>...</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2014-07-24 23:59:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>MEDICAL</td>\n",
       "      <td>None</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>A281756</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2006-09-11 18:10:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>None</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2006-09-12 13:44:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>A451184</td>\n",
       "      <td>BIRD</td>\n",
       "      <td>2012-01-29 15:25:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>CHICKEN</td>\n",
       "      <td>None</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2012-02-22 23:59:00</td>\n",
       "      <td>TRANSFER</td>\n",
       "      <td>RESCUE GRP</td>\n",
       "      <td>None</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>A256128</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2005-11-26 12:35:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>AMERICAN PIT BULL TERRIER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-12-08 23:59:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>MEDICAL</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>A314432</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2007-06-15 17:13:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BROWN TABBY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2007-06-15 18:07:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>A316619</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2007-06-29 20:10:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>LABRADOR RETRIEVER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>FEARFUL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2007-07-04 13:12:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>A317335</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2007-07-05 21:30:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2007-07-11 09:19:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>A317465</td>\n",
       "      <td>BIRD</td>\n",
       "      <td>2007-07-06 18:32:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>PIGEON</td>\n",
       "      <td>None</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>...</td>\n",
       "      <td>INJURED</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2007-07-07 17:02:00</td>\n",
       "      <td>RELEASED</td>\n",
       "      <td>MEDICAL</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>A317486</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2007-07-06 22:21:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NURSING</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2007-07-12 19:01:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>A318485</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2007-07-14 13:29:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>DOMESTIC LONGHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2007-07-14 12:34:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>A318496</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2007-07-14 14:39:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK TIGER</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2007-07-19 17:25:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>A318533</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2007-07-14 21:41:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>DOMESTIC MEDIUMHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>SICK</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2007-07-15 03:44:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>MEDICAL</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>A319056</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2007-07-19 22:32:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>TRICOLOR</td>\n",
       "      <td>BEAGLE</td>\n",
       "      <td>MIX</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2007-08-07 12:13:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>A325393</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2007-09-01 14:37:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NURSING</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2007-09-06 08:13:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>CONTAG DIS</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>A258842</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2005-12-21 14:30:00</td>\n",
       "      <td>CONFISCATE</td>\n",
       "      <td>NEGLECT</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>None</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-12-29 11:05:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>BREED</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>A258896</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2005-12-22 12:23:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BROWN BRINDLE</td>\n",
       "      <td>AMERICAN PIT BULL TERRIER</td>\n",
       "      <td>AMERICAN PIT BULL TERRIER</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-12-28 10:35:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>BREED</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>A252704</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2005-10-15 10:48:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>TAN</td>\n",
       "      <td>AIREDALE TERRIER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-10-20 23:59:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>A252809</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2005-10-17 13:45:00</td>\n",
       "      <td>KHS</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>BLACK TIGER</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-10-22 23:59:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>A253104</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2005-10-19 22:25:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>None</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>INJURED</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-10-25 23:59:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>A254123</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2005-10-31 12:58:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-11-08 23:59:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>A503690</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2013-09-17 11:01:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2013-09-27 07:51:00</td>\n",
       "      <td>TNR</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>A000120</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2005-03-15 12:00:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>BEAGLE</td>\n",
       "      <td>MIX</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-03-19 12:00:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>BREED</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>A000604</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2005-03-21 12:42:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>CHINESE SHARPEI</td>\n",
       "      <td>MIX</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>FEARFUL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-03-26 09:00:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>BREED</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>A000613</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2005-03-21 13:38:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>LABRADOR RETRIEVER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>FEARFUL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-03-26 10:00:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>SPACE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>A276806</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2006-07-26 11:19:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>LABRADOR RETRIEVER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2006-08-03 12:30:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>A276968</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2006-07-27 14:32:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>ORANGE</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2006-08-05 18:30:00</td>\n",
       "      <td>MISSING</td>\n",
       "      <td>IN KENNEL</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>A254608</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2005-11-07 11:14:00</td>\n",
       "      <td>KHS</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>DOMESTIC MEDIUMHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2005-11-12 08:30:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>TIME/SPACE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99970</th>\n",
       "      <td>99970</td>\n",
       "      <td>A622344</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2017-08-22 14:46:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>None</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2017-08-22 16:05:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>REQUESTED</td>\n",
       "      <td>None</td>\n",
       "      <td>AGG PEOPLE</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99971</th>\n",
       "      <td>99971</td>\n",
       "      <td>A535310</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2014-09-06 12:10:00</td>\n",
       "      <td>RETURN</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>BEAGLE</td>\n",
       "      <td>None</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2014-09-21 13:08:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>EVENT</td>\n",
       "      <td>None</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99972</th>\n",
       "      <td>99972</td>\n",
       "      <td>A583571</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2016-02-20 13:18:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2016-02-25 09:07:00</td>\n",
       "      <td>TRANSFER</td>\n",
       "      <td>RESCUE GRP</td>\n",
       "      <td>None</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99973</th>\n",
       "      <td>99973</td>\n",
       "      <td>A615384</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2017-04-15 11:45:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>ORANGE TABBY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2017-04-24 14:15:00</td>\n",
       "      <td>TRANSFER</td>\n",
       "      <td>KHS</td>\n",
       "      <td>None</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99974</th>\n",
       "      <td>99974</td>\n",
       "      <td>A594912</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2016-07-16 12:59:00</td>\n",
       "      <td>DISPOSAL</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>None</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>DEAD</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2016-07-20 23:59:00</td>\n",
       "      <td>DISPOSAL</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>None</td>\n",
       "      <td>PARVO</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99975</th>\n",
       "      <td>99975</td>\n",
       "      <td>A564307</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2015-06-23 16:50:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>EUTH REQ</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>LABRADOR RETRIEVER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>AGED</td>\n",
       "      <td>TREATABLE/MANAGEABLE</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2015-06-23 20:12:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>REQUESTED</td>\n",
       "      <td>None</td>\n",
       "      <td>AGED</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99976</th>\n",
       "      <td>99976</td>\n",
       "      <td>A632360</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2017-12-13 21:51:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>None</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>DOMESTIC LONGHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2017-12-15 23:59:00</td>\n",
       "      <td>TNR</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99977</th>\n",
       "      <td>99977</td>\n",
       "      <td>A485868</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2013-02-11 14:09:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>TORTIE</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>FERAL</td>\n",
       "      <td>UNHEALTHY/UNTREATABLE</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2013-02-12 16:20:00</td>\n",
       "      <td>TNR</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99978</th>\n",
       "      <td>99978</td>\n",
       "      <td>A347995</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2008-04-23 10:04:00</td>\n",
       "      <td>OUTSURGERY</td>\n",
       "      <td>None</td>\n",
       "      <td>RED</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2008-04-23 23:59:00</td>\n",
       "      <td>RELEASED</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99979</th>\n",
       "      <td>99979</td>\n",
       "      <td>A381832</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2011-06-09 10:54:00</td>\n",
       "      <td>RETURN</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>CHINESE SHARPEI</td>\n",
       "      <td>MIX</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2011-06-25 12:53:00</td>\n",
       "      <td>TRANSFER</td>\n",
       "      <td>RESCUE GRP</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99980</th>\n",
       "      <td>99980</td>\n",
       "      <td>A615641</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2017-04-20 07:51:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>AMERICAN PIT BULL TERRIER</td>\n",
       "      <td>None</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2017-05-01 20:08:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>BEHAV OBSV</td>\n",
       "      <td>None</td>\n",
       "      <td>AGG ANIMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99981</th>\n",
       "      <td>99981</td>\n",
       "      <td>A455261</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2012-03-28 14:26:00</td>\n",
       "      <td>FOSTER</td>\n",
       "      <td>RETURN</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>GREAT DANE</td>\n",
       "      <td>WHIPPET</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2012-08-02 12:57:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>WALK IN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99982</th>\n",
       "      <td>99982</td>\n",
       "      <td>A552757</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2015-02-07 15:34:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2015-02-18 09:39:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>CONTAG DIS</td>\n",
       "      <td>None</td>\n",
       "      <td>PARVO</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99983</th>\n",
       "      <td>99983</td>\n",
       "      <td>A547971</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2014-12-15 11:33:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>ORANGE TABBY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NURSING</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2014-12-15 11:38:00</td>\n",
       "      <td>FOSTER</td>\n",
       "      <td>TOO YOUNG</td>\n",
       "      <td>None</td>\n",
       "      <td>NURSING</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99984</th>\n",
       "      <td>99984</td>\n",
       "      <td>A419425</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>2010-08-20 22:39:00</td>\n",
       "      <td>QUARANTINE</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>BAT</td>\n",
       "      <td>None</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>...</td>\n",
       "      <td>DEAD</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2010-08-20 23:21:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>BEHAV OBSV</td>\n",
       "      <td>None</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99985</th>\n",
       "      <td>99985</td>\n",
       "      <td>A615749</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2017-06-13 13:50:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>YELLOW</td>\n",
       "      <td>AUSTRALIAN SHEPHERD</td>\n",
       "      <td>MIX</td>\n",
       "      <td>SPAYED FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2017-06-22 23:59:00</td>\n",
       "      <td>ADOPTION</td>\n",
       "      <td>INTERNET</td>\n",
       "      <td>None</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99986</th>\n",
       "      <td>99986</td>\n",
       "      <td>A535820</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2014-08-30 11:26:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>APRICOT</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2014-09-02 15:37:00</td>\n",
       "      <td>TRANSFER</td>\n",
       "      <td>KHS</td>\n",
       "      <td>None</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99987</th>\n",
       "      <td>99987</td>\n",
       "      <td>A597829</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2017-04-23 10:12:00</td>\n",
       "      <td>FOSTER</td>\n",
       "      <td>RETURN</td>\n",
       "      <td>BUFF</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2017-04-24 07:11:00</td>\n",
       "      <td>FOSTER</td>\n",
       "      <td>MEDICAL</td>\n",
       "      <td>None</td>\n",
       "      <td>INJURED</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99988</th>\n",
       "      <td>99988</td>\n",
       "      <td>A601466</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2016-09-30 12:58:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>None</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2016-10-03 13:03:00</td>\n",
       "      <td>RTO</td>\n",
       "      <td>IN KENNEL</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99989</th>\n",
       "      <td>99989</td>\n",
       "      <td>A632355</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2017-12-13 21:42:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>None</td>\n",
       "      <td>ORANGE</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2017-12-15 23:59:00</td>\n",
       "      <td>TNR</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99990</th>\n",
       "      <td>99990</td>\n",
       "      <td>A428618</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2010-12-18 16:55:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>YELLOW</td>\n",
       "      <td>CHOW CHOW</td>\n",
       "      <td>LABRADOR RETRIEVER</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2010-12-30 16:22:00</td>\n",
       "      <td>TRANSFER</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99991</th>\n",
       "      <td>99991</td>\n",
       "      <td>A549225</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2014-12-31 14:34:00</td>\n",
       "      <td>OWNER SUR</td>\n",
       "      <td>OTC</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2015-01-07 15:21:00</td>\n",
       "      <td>TRANSFER</td>\n",
       "      <td>KHS</td>\n",
       "      <td>None</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99992</th>\n",
       "      <td>99992</td>\n",
       "      <td>A577317</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2015-11-30 09:48:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BROWN</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>PLOTT HOUND</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2015-12-05 13:44:00</td>\n",
       "      <td>RTO</td>\n",
       "      <td>IN KENNEL</td>\n",
       "      <td>None</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99993</th>\n",
       "      <td>99993</td>\n",
       "      <td>A618519</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2017-06-01 21:11:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>None</td>\n",
       "      <td>GRAY TABBY</td>\n",
       "      <td>DOMESTIC MEDIUMHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2017-06-02 23:59:00</td>\n",
       "      <td>RTF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99994</th>\n",
       "      <td>99994</td>\n",
       "      <td>A330440</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2008-04-21 23:36:00</td>\n",
       "      <td>CONFISCATE</td>\n",
       "      <td>POTDANGER</td>\n",
       "      <td>TRICOLOR</td>\n",
       "      <td>GERMAN SHEPHERD DOG</td>\n",
       "      <td>MIX</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2008-05-02 14:47:00</td>\n",
       "      <td>RTO</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99995</th>\n",
       "      <td>99995</td>\n",
       "      <td>A363634</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2009-04-13 22:41:00</td>\n",
       "      <td>CONFISCATE</td>\n",
       "      <td>UNPERMITED</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>None</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2009-04-30 14:46:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>BREED</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99996</th>\n",
       "      <td>99996</td>\n",
       "      <td>A566052</td>\n",
       "      <td>DOG</td>\n",
       "      <td>2015-07-17 15:12:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>PIT BULL TERRIER</td>\n",
       "      <td>MIX</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NURSING</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2015-07-19 23:59:00</td>\n",
       "      <td>TRANSFER</td>\n",
       "      <td>RESCUE GRP</td>\n",
       "      <td>None</td>\n",
       "      <td>NURSING</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99997</th>\n",
       "      <td>99997</td>\n",
       "      <td>A395477</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2009-10-09 20:13:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BROWN TABBY</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>2009-10-23 23:59:00</td>\n",
       "      <td>EUTH</td>\n",
       "      <td>CONTAG DIS</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99998</th>\n",
       "      <td>99998</td>\n",
       "      <td>A628304</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2017-10-27 13:16:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>OTC</td>\n",
       "      <td>BROWN TABBY</td>\n",
       "      <td>DOMESTIC LONGHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>NEUTERED MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "      <td>2017-10-27 17:15:00</td>\n",
       "      <td>RTF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>ALTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99999</th>\n",
       "      <td>99999</td>\n",
       "      <td>A544178</td>\n",
       "      <td>CAT</td>\n",
       "      <td>2014-10-29 08:17:00</td>\n",
       "      <td>STRAY</td>\n",
       "      <td>FIELD</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>DOMESTIC SHORTHAIR</td>\n",
       "      <td>None</td>\n",
       "      <td>MALE</td>\n",
       "      <td>...</td>\n",
       "      <td>FEARFUL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "      <td>2014-10-30 06:32:00</td>\n",
       "      <td>TNR</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NORMAL</td>\n",
       "      <td>HEALTHY</td>\n",
       "      <td>FERTILE</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100000 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       index AnimalID AnimalType           IntakeDate  IntakeType  \\\n",
       "0          0  A366370        CAT  2008-11-07 10:50:00       STRAY   \n",
       "1          1  A366531        CAT  2008-11-10 10:20:00       STRAY   \n",
       "2          2  A532367       BIRD  2014-07-23 23:21:00  CONFISCATE   \n",
       "3          3  A532474      OTHER  2014-07-24 18:29:00  ET REQUEST   \n",
       "4          4  A281756        DOG  2006-09-11 18:10:00   OWNER SUR   \n",
       "5          5  A451184       BIRD  2012-01-29 15:25:00   OWNER SUR   \n",
       "6          6  A256128        DOG  2005-11-26 12:35:00       STRAY   \n",
       "7          7  A314432        CAT  2007-06-15 17:13:00   OWNER SUR   \n",
       "8          8  A316619        DOG  2007-06-29 20:10:00       STRAY   \n",
       "9          9  A317335        CAT  2007-07-05 21:30:00       STRAY   \n",
       "10        10  A317465       BIRD  2007-07-06 18:32:00       STRAY   \n",
       "11        11  A317486        CAT  2007-07-06 22:21:00       STRAY   \n",
       "12        12  A318485        CAT  2007-07-14 13:29:00   OWNER SUR   \n",
       "13        13  A318496        CAT  2007-07-14 14:39:00       STRAY   \n",
       "14        14  A318533        CAT  2007-07-14 21:41:00       STRAY   \n",
       "15        15  A319056        DOG  2007-07-19 22:32:00       STRAY   \n",
       "16        16  A325393        CAT  2007-09-01 14:37:00       STRAY   \n",
       "17        17  A258842        DOG  2005-12-21 14:30:00  CONFISCATE   \n",
       "18        18  A258896        DOG  2005-12-22 12:23:00       STRAY   \n",
       "19        19  A252704        DOG  2005-10-15 10:48:00       STRAY   \n",
       "20        20  A252809        CAT  2005-10-17 13:45:00         KHS   \n",
       "21        21  A253104        DOG  2005-10-19 22:25:00       STRAY   \n",
       "22        22  A254123        CAT  2005-10-31 12:58:00       STRAY   \n",
       "23        23  A503690        CAT  2013-09-17 11:01:00       STRAY   \n",
       "24        24  A000120        DOG  2005-03-15 12:00:00       STRAY   \n",
       "25        25  A000604        DOG  2005-03-21 12:42:00       STRAY   \n",
       "26        26  A000613        DOG  2005-03-21 13:38:00       STRAY   \n",
       "27        27  A276806        DOG  2006-07-26 11:19:00       STRAY   \n",
       "28        28  A276968        CAT  2006-07-27 14:32:00   OWNER SUR   \n",
       "29        29  A254608        CAT  2005-11-07 11:14:00         KHS   \n",
       "...      ...      ...        ...                  ...         ...   \n",
       "99970  99970  A622344        DOG  2017-08-22 14:46:00   OWNER SUR   \n",
       "99971  99971  A535310        DOG  2014-09-06 12:10:00      RETURN   \n",
       "99972  99972  A583571        CAT  2016-02-20 13:18:00   OWNER SUR   \n",
       "99973  99973  A615384        CAT  2017-04-15 11:45:00       STRAY   \n",
       "99974  99974  A594912        DOG  2016-07-16 12:59:00    DISPOSAL   \n",
       "99975  99975  A564307        DOG  2015-06-23 16:50:00   OWNER SUR   \n",
       "99976  99976  A632360        CAT  2017-12-13 21:51:00       STRAY   \n",
       "99977  99977  A485868        CAT  2013-02-11 14:09:00       STRAY   \n",
       "99978  99978  A347995        DOG  2008-04-23 10:04:00  OUTSURGERY   \n",
       "99979  99979  A381832        DOG  2011-06-09 10:54:00      RETURN   \n",
       "99980  99980  A615641        DOG  2017-04-20 07:51:00       STRAY   \n",
       "99981  99981  A455261        DOG  2012-03-28 14:26:00      FOSTER   \n",
       "99982  99982  A552757        DOG  2015-02-07 15:34:00       STRAY   \n",
       "99983  99983  A547971        CAT  2014-12-15 11:33:00       STRAY   \n",
       "99984  99984  A419425      OTHER  2010-08-20 22:39:00  QUARANTINE   \n",
       "99985  99985  A615749        DOG  2017-06-13 13:50:00       STRAY   \n",
       "99986  99986  A535820        CAT  2014-08-30 11:26:00       STRAY   \n",
       "99987  99987  A597829        CAT  2017-04-23 10:12:00      FOSTER   \n",
       "99988  99988  A601466        DOG  2016-09-30 12:58:00       STRAY   \n",
       "99989  99989  A632355        CAT  2017-12-13 21:42:00       STRAY   \n",
       "99990  99990  A428618        DOG  2010-12-18 16:55:00       STRAY   \n",
       "99991  99991  A549225        DOG  2014-12-31 14:34:00   OWNER SUR   \n",
       "99992  99992  A577317        DOG  2015-11-30 09:48:00       STRAY   \n",
       "99993  99993  A618519        CAT  2017-06-01 21:11:00       STRAY   \n",
       "99994  99994  A330440        DOG  2008-04-21 23:36:00  CONFISCATE   \n",
       "99995  99995  A363634        DOG  2009-04-13 22:41:00  CONFISCATE   \n",
       "99996  99996  A566052        DOG  2015-07-17 15:12:00       STRAY   \n",
       "99997  99997  A395477        CAT  2009-10-09 20:13:00       STRAY   \n",
       "99998  99998  A628304        CAT  2017-10-27 13:16:00       STRAY   \n",
       "99999  99999  A544178        CAT  2014-10-29 08:17:00       STRAY   \n",
       "\n",
       "      IntakeSubtype   PrimaryColor               PrimaryBreed  \\\n",
       "0               OTC          WHITE         DOMESTIC SHORTHAIR   \n",
       "1               OTC          BLACK         DOMESTIC SHORTHAIR   \n",
       "2           CRUELTY            RED                    CHICKEN   \n",
       "3              None          BROWN                        BAT   \n",
       "4               OTC          WHITE           PIT BULL TERRIER   \n",
       "5             FIELD          BLACK                    CHICKEN   \n",
       "6             FIELD          BROWN  AMERICAN PIT BULL TERRIER   \n",
       "7               OTC    BROWN TABBY         DOMESTIC SHORTHAIR   \n",
       "8             FIELD          WHITE         LABRADOR RETRIEVER   \n",
       "9               OTC           GRAY         DOMESTIC SHORTHAIR   \n",
       "10            FIELD           GRAY                     PIGEON   \n",
       "11              OTC           GRAY         DOMESTIC SHORTHAIR   \n",
       "12              OTC          BLACK          DOMESTIC LONGHAIR   \n",
       "13            FIELD    BLACK TIGER         DOMESTIC SHORTHAIR   \n",
       "14            FIELD          BLACK        DOMESTIC MEDIUMHAIR   \n",
       "15              OTC       TRICOLOR                     BEAGLE   \n",
       "16              OTC           GRAY         DOMESTIC SHORTHAIR   \n",
       "17          NEGLECT          WHITE           PIT BULL TERRIER   \n",
       "18              OTC  BROWN BRINDLE  AMERICAN PIT BULL TERRIER   \n",
       "19              OTC            TAN           AIREDALE TERRIER   \n",
       "20            STRAY    BLACK TIGER         DOMESTIC SHORTHAIR   \n",
       "21            FIELD          BLACK           PIT BULL TERRIER   \n",
       "22            FIELD          BLACK         DOMESTIC SHORTHAIR   \n",
       "23              OTC          BLACK         DOMESTIC SHORTHAIR   \n",
       "24              OTC          BLACK                     BEAGLE   \n",
       "25            FIELD          BROWN            CHINESE SHARPEI   \n",
       "26            FIELD          BLACK         LABRADOR RETRIEVER   \n",
       "27            FIELD          BLACK         LABRADOR RETRIEVER   \n",
       "28              OTC         ORANGE         DOMESTIC SHORTHAIR   \n",
       "29            STRAY           GRAY        DOMESTIC MEDIUMHAIR   \n",
       "...             ...            ...                        ...   \n",
       "99970           OTC          BLACK           PIT BULL TERRIER   \n",
       "99971      ADOPTION          BROWN                     BEAGLE   \n",
       "99972           OTC           GRAY         DOMESTIC SHORTHAIR   \n",
       "99973           OTC   ORANGE TABBY         DOMESTIC SHORTHAIR   \n",
       "99974         STRAY          BLACK           PIT BULL TERRIER   \n",
       "99975      EUTH REQ          BLACK         LABRADOR RETRIEVER   \n",
       "99976          None          WHITE          DOMESTIC LONGHAIR   \n",
       "99977           OTC         TORTIE         DOMESTIC SHORTHAIR   \n",
       "99978          None            RED           PIT BULL TERRIER   \n",
       "99979      ADOPTION          BROWN            CHINESE SHARPEI   \n",
       "99980         FIELD          BLACK  AMERICAN PIT BULL TERRIER   \n",
       "99981        RETURN          BROWN                 GREAT DANE   \n",
       "99982         FIELD          BLACK           PIT BULL TERRIER   \n",
       "99983           OTC   ORANGE TABBY         DOMESTIC SHORTHAIR   \n",
       "99984         STRAY          BROWN                        BAT   \n",
       "99985           OTC         YELLOW        AUSTRALIAN SHEPHERD   \n",
       "99986           OTC        APRICOT         DOMESTIC SHORTHAIR   \n",
       "99987        RETURN           BUFF         DOMESTIC SHORTHAIR   \n",
       "99988           OTC           BLUE           PIT BULL TERRIER   \n",
       "99989          None         ORANGE         DOMESTIC SHORTHAIR   \n",
       "99990           OTC         YELLOW                  CHOW CHOW   \n",
       "99991           OTC          WHITE           PIT BULL TERRIER   \n",
       "99992         FIELD          BROWN           PIT BULL TERRIER   \n",
       "99993          None     GRAY TABBY        DOMESTIC MEDIUMHAIR   \n",
       "99994     POTDANGER       TRICOLOR        GERMAN SHEPHERD DOG   \n",
       "99995    UNPERMITED           GRAY           PIT BULL TERRIER   \n",
       "99996           OTC          BLACK           PIT BULL TERRIER   \n",
       "99997           OTC    BROWN TABBY         DOMESTIC SHORTHAIR   \n",
       "99998           OTC    BROWN TABBY          DOMESTIC LONGHAIR   \n",
       "99999         FIELD          BLACK         DOMESTIC SHORTHAIR   \n",
       "\n",
       "                  SecondaryBreed         Gender  ... IntakeInternalStatus  \\\n",
       "0                           None  NEUTERED MALE  ...              FEARFUL   \n",
       "1             DOMESTIC SHORTHAIR        UNKNOWN  ...               NORMAL   \n",
       "2                           None           MALE  ...                OTHER   \n",
       "3                           None        UNKNOWN  ...                OTHER   \n",
       "4                           None           MALE  ...               NORMAL   \n",
       "5                           None        UNKNOWN  ...               NORMAL   \n",
       "6                            MIX           MALE  ...               NORMAL   \n",
       "7                           None        UNKNOWN  ...               NORMAL   \n",
       "8                            MIX           MALE  ...              FEARFUL   \n",
       "9                           None        UNKNOWN  ...               NORMAL   \n",
       "10                          None        UNKNOWN  ...              INJURED   \n",
       "11                          None         FEMALE  ...              NURSING   \n",
       "12                          None  SPAYED FEMALE  ...               NORMAL   \n",
       "13                          None        UNKNOWN  ...               NORMAL   \n",
       "14                          None  NEUTERED MALE  ...                 SICK   \n",
       "15                           MIX  NEUTERED MALE  ...               NORMAL   \n",
       "16                          None         FEMALE  ...              NURSING   \n",
       "17                          None           MALE  ...               NORMAL   \n",
       "18     AMERICAN PIT BULL TERRIER           MALE  ...               NORMAL   \n",
       "19                           MIX         FEMALE  ...               NORMAL   \n",
       "20                          None           MALE  ...               NORMAL   \n",
       "21                          None           MALE  ...              INJURED   \n",
       "22                          None           MALE  ...               NORMAL   \n",
       "23                          None           MALE  ...               NORMAL   \n",
       "24                           MIX         FEMALE  ...               NORMAL   \n",
       "25                           MIX           MALE  ...              FEARFUL   \n",
       "26                           MIX         FEMALE  ...              FEARFUL   \n",
       "27                           MIX           MALE  ...               NORMAL   \n",
       "28                          None           MALE  ...               NORMAL   \n",
       "29                          None           MALE  ...               NORMAL   \n",
       "...                          ...            ...  ...                  ...   \n",
       "99970                       None           MALE  ...               NORMAL   \n",
       "99971                       None  SPAYED FEMALE  ...               NORMAL   \n",
       "99972                       None  NEUTERED MALE  ...               NORMAL   \n",
       "99973                       None  NEUTERED MALE  ...               NORMAL   \n",
       "99974                       None         FEMALE  ...                 DEAD   \n",
       "99975                        MIX         FEMALE  ...                 AGED   \n",
       "99976                       None         FEMALE  ...               NORMAL   \n",
       "99977                       None         FEMALE  ...                FERAL   \n",
       "99978                        MIX  SPAYED FEMALE  ...               NORMAL   \n",
       "99979                        MIX  SPAYED FEMALE  ...               NORMAL   \n",
       "99980                       None  SPAYED FEMALE  ...               NORMAL   \n",
       "99981                    WHIPPET  NEUTERED MALE  ...               NORMAL   \n",
       "99982                        MIX         FEMALE  ...                OTHER   \n",
       "99983                       None  NEUTERED MALE  ...              NURSING   \n",
       "99984                       None        UNKNOWN  ...                 DEAD   \n",
       "99985                        MIX  SPAYED FEMALE  ...               NORMAL   \n",
       "99986                       None         FEMALE  ...               NORMAL   \n",
       "99987                       None           MALE  ...                OTHER   \n",
       "99988                       None  NEUTERED MALE  ...                OTHER   \n",
       "99989                       None         FEMALE  ...               NORMAL   \n",
       "99990         LABRADOR RETRIEVER  NEUTERED MALE  ...               NORMAL   \n",
       "99991                        MIX           MALE  ...               NORMAL   \n",
       "99992                PLOTT HOUND  NEUTERED MALE  ...               NORMAL   \n",
       "99993                       None        UNKNOWN  ...               NORMAL   \n",
       "99994                        MIX  NEUTERED MALE  ...               NORMAL   \n",
       "99995                       None         FEMALE  ...               NORMAL   \n",
       "99996                        MIX         FEMALE  ...              NURSING   \n",
       "99997                       None        UNKNOWN  ...               NORMAL   \n",
       "99998                       None  NEUTERED MALE  ...               NORMAL   \n",
       "99999                       None           MALE  ...              FEARFUL   \n",
       "\n",
       "        IntakeAsilomarStatus ReproductiveStatusAtIntake          OutcomeDate  \\\n",
       "0                    HEALTHY                    ALTERED  2008-11-12 15:46:00   \n",
       "1                    HEALTHY                    UNKNOWN  2008-11-19 20:10:00   \n",
       "2                    HEALTHY                    FERTILE  2014-11-05 15:49:00   \n",
       "3                    HEALTHY                    UNKNOWN  2014-07-24 23:59:00   \n",
       "4                    HEALTHY                    FERTILE  2006-09-12 13:44:00   \n",
       "5                    HEALTHY                    UNKNOWN  2012-02-22 23:59:00   \n",
       "6                    HEALTHY                    FERTILE  2005-12-08 23:59:00   \n",
       "7                    HEALTHY                    UNKNOWN  2007-06-15 18:07:00   \n",
       "8                    HEALTHY                    FERTILE  2007-07-04 13:12:00   \n",
       "9                    HEALTHY                    UNKNOWN  2007-07-11 09:19:00   \n",
       "10                   HEALTHY                    UNKNOWN  2007-07-07 17:02:00   \n",
       "11                   HEALTHY                    FERTILE  2007-07-12 19:01:00   \n",
       "12                   HEALTHY                    ALTERED  2007-07-14 12:34:00   \n",
       "13                   HEALTHY                    UNKNOWN  2007-07-19 17:25:00   \n",
       "14                   HEALTHY                    ALTERED  2007-07-15 03:44:00   \n",
       "15                   HEALTHY                    ALTERED  2007-08-07 12:13:00   \n",
       "16                   HEALTHY                    FERTILE  2007-09-06 08:13:00   \n",
       "17                   HEALTHY                    FERTILE  2005-12-29 11:05:00   \n",
       "18                   HEALTHY                    FERTILE  2005-12-28 10:35:00   \n",
       "19                   HEALTHY                    FERTILE  2005-10-20 23:59:00   \n",
       "20                   HEALTHY                    FERTILE  2005-10-22 23:59:00   \n",
       "21                   HEALTHY                    FERTILE  2005-10-25 23:59:00   \n",
       "22                   HEALTHY                    FERTILE  2005-11-08 23:59:00   \n",
       "23                   HEALTHY                    FERTILE  2013-09-27 07:51:00   \n",
       "24                   HEALTHY                    FERTILE  2005-03-19 12:00:00   \n",
       "25                   HEALTHY                    FERTILE  2005-03-26 09:00:00   \n",
       "26                   HEALTHY                    FERTILE  2005-03-26 10:00:00   \n",
       "27                   HEALTHY                    FERTILE  2006-08-03 12:30:00   \n",
       "28                   HEALTHY                    FERTILE  2006-08-05 18:30:00   \n",
       "29                   HEALTHY                    FERTILE  2005-11-12 08:30:00   \n",
       "...                      ...                        ...                  ...   \n",
       "99970                HEALTHY                    FERTILE  2017-08-22 16:05:00   \n",
       "99971                HEALTHY                    ALTERED  2014-09-21 13:08:00   \n",
       "99972                HEALTHY                    ALTERED  2016-02-25 09:07:00   \n",
       "99973                HEALTHY                    ALTERED  2017-04-24 14:15:00   \n",
       "99974                HEALTHY                    FERTILE  2016-07-20 23:59:00   \n",
       "99975   TREATABLE/MANAGEABLE                    FERTILE  2015-06-23 20:12:00   \n",
       "99976                HEALTHY                    FERTILE  2017-12-15 23:59:00   \n",
       "99977  UNHEALTHY/UNTREATABLE                    FERTILE  2013-02-12 16:20:00   \n",
       "99978                HEALTHY                    ALTERED  2008-04-23 23:59:00   \n",
       "99979                HEALTHY                    ALTERED  2011-06-25 12:53:00   \n",
       "99980                HEALTHY                    ALTERED  2017-05-01 20:08:00   \n",
       "99981                HEALTHY                    ALTERED  2012-08-02 12:57:00   \n",
       "99982                HEALTHY                    FERTILE  2015-02-18 09:39:00   \n",
       "99983                HEALTHY                    ALTERED  2014-12-15 11:38:00   \n",
       "99984                HEALTHY                    UNKNOWN  2010-08-20 23:21:00   \n",
       "99985                HEALTHY                    ALTERED  2017-06-22 23:59:00   \n",
       "99986                HEALTHY                    FERTILE  2014-09-02 15:37:00   \n",
       "99987                HEALTHY                    FERTILE  2017-04-24 07:11:00   \n",
       "99988                HEALTHY                    ALTERED  2016-10-03 13:03:00   \n",
       "99989                HEALTHY                    FERTILE  2017-12-15 23:59:00   \n",
       "99990                HEALTHY                    ALTERED  2010-12-30 16:22:00   \n",
       "99991                HEALTHY                    FERTILE  2015-01-07 15:21:00   \n",
       "99992                HEALTHY                    ALTERED  2015-12-05 13:44:00   \n",
       "99993                HEALTHY                    UNKNOWN  2017-06-02 23:59:00   \n",
       "99994                HEALTHY                    ALTERED  2008-05-02 14:47:00   \n",
       "99995                HEALTHY                    FERTILE  2009-04-30 14:46:00   \n",
       "99996                HEALTHY                    FERTILE  2015-07-19 23:59:00   \n",
       "99997                HEALTHY                    UNKNOWN  2009-10-23 23:59:00   \n",
       "99998                HEALTHY                    ALTERED  2017-10-27 17:15:00   \n",
       "99999                HEALTHY                    FERTILE  2014-10-30 06:32:00   \n",
       "\n",
       "      OutcomeType OutcomeSubtype OutcomeReason OutcomeInternalStatus  \\\n",
       "0            EUTH          FERAL          None                  None   \n",
       "1            EUTH     CONTAG DIS          None                  SICK   \n",
       "2        TRANSFER           None          None                  None   \n",
       "3            EUTH        MEDICAL          None                 OTHER   \n",
       "4            EUTH     TIME/SPACE          None                  None   \n",
       "5        TRANSFER     RESCUE GRP          None                NORMAL   \n",
       "6            EUTH        MEDICAL          None                  None   \n",
       "7            EUTH     TIME/SPACE          None                  None   \n",
       "8            EUTH     TIME/SPACE          None                  None   \n",
       "9            EUTH     TIME/SPACE          None                  None   \n",
       "10       RELEASED        MEDICAL          None                  None   \n",
       "11           EUTH     TIME/SPACE          None                  None   \n",
       "12           EUTH     TIME/SPACE          None                  None   \n",
       "13           EUTH     TIME/SPACE          None                  None   \n",
       "14           EUTH        MEDICAL          None                  None   \n",
       "15           EUTH     TIME/SPACE          None                  None   \n",
       "16           EUTH     CONTAG DIS          None                  None   \n",
       "17           EUTH          BREED          None                  None   \n",
       "18           EUTH          BREED          None                  None   \n",
       "19           EUTH     TIME/SPACE          None                  None   \n",
       "20           EUTH     TIME/SPACE          None                  None   \n",
       "21           EUTH     TIME/SPACE          None                  None   \n",
       "22           EUTH     TIME/SPACE          None                  None   \n",
       "23            TNR           None          None                  None   \n",
       "24           EUTH          BREED          None                  None   \n",
       "25           EUTH          BREED          None                  None   \n",
       "26           EUTH          SPACE          None                  None   \n",
       "27           EUTH     TIME/SPACE          None                  None   \n",
       "28        MISSING      IN KENNEL          None                  None   \n",
       "29           EUTH     TIME/SPACE          None                  None   \n",
       "...           ...            ...           ...                   ...   \n",
       "99970        EUTH      REQUESTED          None            AGG PEOPLE   \n",
       "99971    ADOPTION          EVENT          None                NORMAL   \n",
       "99972    TRANSFER     RESCUE GRP          None                NORMAL   \n",
       "99973    TRANSFER            KHS          None                NORMAL   \n",
       "99974    DISPOSAL          STRAY          None                 PARVO   \n",
       "99975        EUTH      REQUESTED          None                  AGED   \n",
       "99976         TNR           None          None                  None   \n",
       "99977         TNR           None          None                  None   \n",
       "99978    RELEASED           None          None                  None   \n",
       "99979    TRANSFER     RESCUE GRP          None                  None   \n",
       "99980        EUTH     BEHAV OBSV          None            AGG ANIMAL   \n",
       "99981    ADOPTION        WALK IN          None                  None   \n",
       "99982        EUTH     CONTAG DIS          None                 PARVO   \n",
       "99983      FOSTER      TOO YOUNG          None               NURSING   \n",
       "99984        EUTH     BEHAV OBSV          None                NORMAL   \n",
       "99985    ADOPTION       INTERNET          None                NORMAL   \n",
       "99986    TRANSFER            KHS          None                NORMAL   \n",
       "99987      FOSTER        MEDICAL          None               INJURED   \n",
       "99988         RTO      IN KENNEL          None                  None   \n",
       "99989         TNR           None          None                  None   \n",
       "99990    TRANSFER           None          None                  None   \n",
       "99991    TRANSFER            KHS          None                NORMAL   \n",
       "99992         RTO      IN KENNEL          None                NORMAL   \n",
       "99993         RTF           None          None                NORMAL   \n",
       "99994         RTO           None          None                  None   \n",
       "99995        EUTH          BREED          None                  None   \n",
       "99996    TRANSFER     RESCUE GRP          None               NURSING   \n",
       "99997        EUTH     CONTAG DIS          None                  None   \n",
       "99998         RTF           None          None                NORMAL   \n",
       "99999         TNR           None          None                NORMAL   \n",
       "\n",
       "       OutcomeAsilomarStatus ReproductiveStatusAtOutcome  \n",
       "0      UNHEALTHY/UNTREATABLE                     ALTERED  \n",
       "1                    HEALTHY                     UNKNOWN  \n",
       "2                    HEALTHY                     FERTILE  \n",
       "3                    HEALTHY                     UNKNOWN  \n",
       "4                    HEALTHY                     FERTILE  \n",
       "5                    HEALTHY                     UNKNOWN  \n",
       "6                    HEALTHY                     FERTILE  \n",
       "7                    HEALTHY                     UNKNOWN  \n",
       "8                    HEALTHY                     FERTILE  \n",
       "9                    HEALTHY                     UNKNOWN  \n",
       "10                   HEALTHY                     UNKNOWN  \n",
       "11                   HEALTHY                     FERTILE  \n",
       "12                   HEALTHY                     ALTERED  \n",
       "13                   HEALTHY                     UNKNOWN  \n",
       "14                   HEALTHY                     ALTERED  \n",
       "15                   HEALTHY                     ALTERED  \n",
       "16                   HEALTHY                     FERTILE  \n",
       "17                   HEALTHY                     FERTILE  \n",
       "18                   HEALTHY                     FERTILE  \n",
       "19                   HEALTHY                     FERTILE  \n",
       "20                   HEALTHY                     FERTILE  \n",
       "21                   HEALTHY                     FERTILE  \n",
       "22                   HEALTHY                     FERTILE  \n",
       "23                   HEALTHY                     FERTILE  \n",
       "24                   HEALTHY                     FERTILE  \n",
       "25                   HEALTHY                     FERTILE  \n",
       "26                   HEALTHY                     FERTILE  \n",
       "27                   HEALTHY                     FERTILE  \n",
       "28                   HEALTHY                     FERTILE  \n",
       "29                   HEALTHY                     FERTILE  \n",
       "...                      ...                         ...  \n",
       "99970                HEALTHY                     FERTILE  \n",
       "99971                HEALTHY                     ALTERED  \n",
       "99972                HEALTHY                     ALTERED  \n",
       "99973                HEALTHY                     ALTERED  \n",
       "99974                HEALTHY                     FERTILE  \n",
       "99975                HEALTHY                     FERTILE  \n",
       "99976                HEALTHY                     FERTILE  \n",
       "99977                HEALTHY                     FERTILE  \n",
       "99978                HEALTHY                     ALTERED  \n",
       "99979                HEALTHY                     ALTERED  \n",
       "99980                HEALTHY                     ALTERED  \n",
       "99981                HEALTHY                     ALTERED  \n",
       "99982                HEALTHY                     FERTILE  \n",
       "99983                HEALTHY                     ALTERED  \n",
       "99984                HEALTHY                     UNKNOWN  \n",
       "99985                HEALTHY                     ALTERED  \n",
       "99986                HEALTHY                     FERTILE  \n",
       "99987                HEALTHY                     FERTILE  \n",
       "99988                HEALTHY                     ALTERED  \n",
       "99989                HEALTHY                     FERTILE  \n",
       "99990                HEALTHY                     ALTERED  \n",
       "99991                HEALTHY                     FERTILE  \n",
       "99992                HEALTHY                     ALTERED  \n",
       "99993                HEALTHY                     UNKNOWN  \n",
       "99994                HEALTHY                     ALTERED  \n",
       "99995                HEALTHY                     FERTILE  \n",
       "99996                HEALTHY                     FERTILE  \n",
       "99997                HEALTHY                     UNKNOWN  \n",
       "99998                HEALTHY                     ALTERED  \n",
       "99999                HEALTHY                     FERTILE  \n",
       "\n",
       "[100000 rows x 23 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Q('select * from animals')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## The Barchart Shows What breed was the most taken in by LMAS 2005-2017"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0xbb2f64e3c8>"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYcAAAGfCAYAAAC0mx6IAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAIABJREFUeJzsnXm4HFW1t99fwhAmZR4kQJBBRGYioCAKKIIToCIQlThGFLzECypOF1FBVBSUKyooF3ACPgFBBAERVBSQAEEJg0QIkMsUZrgys74/1u6cOt19unZ31ekzZL3P08+p2lV7167uOnvVXnsNMjOCIAiCoMiEke5AEARBMPoI4RAEQRC0EMIhCIIgaCGEQxAEQdBCCIcgCIKghRAOQRAEQQshHIIgCIIWQjgEQRAELYRwCIIgCFpYbKQ70Csrr7yyTZkyZaS7EQRBMGa49tprHzSzVXLOHbPCYcqUKcyaNWukuxEEQTBmkHRn7rmhVgqCIAhaCOEQBEEQtBDCIQiCIGhhzK45BEEQDMVzzz3H/Pnzefrpp0e6KyPCpEmTmDx5MosvvnjPbYRwCIJg3DF//nyWW245pkyZgqSR7k5fMTMeeugh5s+fz7rrrttzO6FWCoJg3PH000+z0korLXKCAUASK620UuVZUwiHIAjGJYuiYGhQx72HcAiCIAhaiDWHIAjGPVMO+22t7c07+q2l59x3333MnDmTa665hiWXXJIpU6Zw3HHHseGGG9bSh8svv5wllliC1772tbW018y4EQ5lP37OjxkEQVAHZsZee+3F9OnTOf300wGYPXs2999/f63CYdlllx024RBqpSAIgpq57LLLWHzxxTnggAMWlm2xxRbssMMOfPrTn2aTTTZh00035YwzzgB8oH/b29628NyDDjqIU045BfBQQYcffjhbbbUVm266Kbfccgvz5s3jhz/8IcceeyxbbLEFf/7zn2u/h3EzcwiCIBgt3HjjjWy99dYt5WeffTazZ8/mhhtu4MEHH+TVr341O+64Y2l7K6+8Mtdddx0nnHACxxxzDD/+8Y854IADWHbZZTn00EOH4xZi5hAEQdAvrrjiCvbbbz8mTpzIaqutxutf/3quueaa0nrvfOc7Adh6662ZN2/eMPfSCeEQBEFQM6961au49tprW8rNrO35iy22GC+++OLC/WYfhSWXXBKAiRMn8vzzz9fY06EJ4RAEQVAzO++8M8888wwnnXTSwrJrrrmGFVZYgTPOOIMXXniBBQsW8Kc//YltttmGddZZh5tuuolnnnmGxx57jEsvvbT0GssttxxPPPHEsN1DrDkEQTDu6be1oiTOOeccZs6cydFHH82kSZMWmrI++eSTbL755kjim9/8JquvvjoA73nPe9hss83YYIMN2HLLLUuv8fa3v513v/vdnHvuuRx//PG87nWvq/cehprmjHamTp1qxWQ/YcoaBEGDm2++mVe+8pUj3Y0Rpd13IOlaM5uaUz/USkEQBEELIRyCIAiCFkI4BEEwLhmrKvM6qOPeQzgEQTDumDRpEg899NAiKSAa+RwmTZpUqZ2wVgqCYNwxefJk5s+fz4IFC0a6KyNCIxNcFUI4BEEw7lh88cUrZUELQq0UBEEQtCFLOEiaJ+kfkmZLmpXKVpR0iaTb0t8VUrkkfU/SXEl/l7RVoZ3p6fzbJE0vlG+d2p+b6i66KZyCIAhGAd3MHHYysy0KDhSHAZea2QbApWkfYHdgg/SZAfwAXJgAhwPbAtsAhzcESjpnRqHebj3fURAEQVCZKmqlPYBT0/apwJ6F8tPMuQpYXtIawJuBS8zsYTN7BLgE2C0de4mZXWluWnBaoa0gCIJgBMgVDgZcLOlaSTNS2Wpmdi9A+rtqKl8TuLtQd34q61Q+v015EARBMELkWittb2b3SFoVuETSLR3ObbdeYD2UtzbsgmkGwNprr925x0EQBEHPZM0czOye9PcB4Bx8zeD+pBIi/X0gnT4fWKtQfTJwT0n55Dbl7fpxoplNNbOpq6yySk7XgyAIgh4oFQ6SlpG0XGMb2BW4ETgPaFgcTQfOTdvnAfsnq6XtgMeS2ukiYFdJK6SF6F2Bi9KxJyRtl6yU9i+0FQRBEIwAOWql1YBzknXpYsAvzOx3kq4BzpT0YeAuYO90/gXAW4C5wL+BDwKY2cOSvgo0cuJ9xcweTtsfB04BlgIuTJ8gCIJghCgVDmZ2O7B5m/KHgF3alBtw4BBtnQyc3KZ8FrBJRn+DIAiCPhAe0kEQBEELIRyCIAiCFkI4BEEQBC2EcAiCIAhaCOEQBEEQtBDCIQiCIGghhEMQBEHQQgiHIAiCoIUQDkEQBEELIRyCIAiCFkI4BEEQBC2EcAiCIAhaCOEQBEEQtBDCIQiCIGghhEMQBEHQQgiHIAiCoIUQDkEQBEELIRyCIAiCFkI4BEEQBC2EcAiCIAhaCOEQBEEQtBDCIQiCIGghhEMQBEHQQgiHIAiCoIUQDkEQBEELIRyCIAiCFkI4BEEQBC2EcAiCIAhaCOEQBEEQtJAtHCRNlHS9pPPT/rqSrpZ0m6QzJC2RypdM+3PT8SmFNj6Xym+V9OZC+W6pbK6kw+q7vSAIgqAXupk5HAzcXNj/BnCsmW0APAJ8OJV/GHjEzNYHjk3nIWljYF/gVcBuwAlJ4EwEvg/sDmwM7JfODYIgCEaILOEgaTLwVuDHaV/AzsCv0imnAnum7T3SPun4Lun8PYDTzewZM7sDmAtskz5zzex2M3sWOD2dGwRBEIwQuTOH44DPAC+m/ZWAR83s+bQ/H1gzba8J3A2Qjj+Wzl9Y3lRnqPIgCIJghCgVDpLeBjxgZtcWi9ucaiXHui1v15cZkmZJmrVgwYIOvQ6CIAiqkDNz2B54h6R5uMpnZ3wmsbykxdI5k4F70vZ8YC2AdPylwMPF8qY6Q5W3YGYnmtlUM5u6yiqrZHQ9CIIg6IVS4WBmnzOzyWY2BV9Q/oOZvRe4DHh3Om06cG7aPi/tk47/wcwsle+brJnWBTYA/gZcA2yQrJ+WSNc4r5a7C4IgCHpisfJThuSzwOmSvgZcD/wklf8E+KmkufiMYV8AM5sj6UzgJuB54EAzewFA0kHARcBE4GQzm1OhX0EQBEFFuhIOZnY5cHnavh23NGo+52lg7yHqHwkc2ab8AuCCbvoSBEEQDB/hIR0EQRC0EMIhCIIgaCGEQxAEQdBCCIcgCIKghRAOQRAEQQshHIIgCIIWQjgEQRAELYRwCIIgCFoI4RAEQRC0EMIhCIIgaCGEQxAEQdBCCIcgCIKghRAOQRAEQQshHIIgCIIWQjgEQRAELYRwCIIgCFoI4RAEQRC0EMIhCIIgaCGEQxAEQdBCCIcgCIKghRAOQRAEQQshHIIgCIIWQjgEQRAELYRwCIIgCFoI4RAEQRC0EMIhCIIgaCGEQxAEQdBCCIcgCIKghRAOQRAEQQulwkHSJEl/k3SDpDmSjkjl60q6WtJtks6QtEQqXzLtz03HpxTa+lwqv1XSmwvlu6WyuZIOq/82gyAIgm7ImTk8A+xsZpsDWwC7SdoO+AZwrJltADwCfDid/2HgETNbHzg2nYekjYF9gVcBuwEnSJooaSLwfWB3YGNgv3RuEARBMEKUCgdznky7i6ePATsDv0rlpwJ7pu090j7p+C6SlMpPN7NnzOwOYC6wTfrMNbPbzexZ4PR0bhAEQTBCZK05pDf82cADwCXAv4BHzez5dMp8YM20vSZwN0A6/hiwUrG8qc5Q5e36MUPSLEmzFixYkNP1IAiCoAeyhIOZvWBmWwCT8Tf9V7Y7Lf3VEMe6LW/XjxPNbKqZTV1llVXKOx4EQRD0RFfWSmb2KHA5sB2wvKTF0qHJwD1pez6wFkA6/lLg4WJ5U52hyoMgCIIRIsdaaRVJy6ftpYA3AjcDlwHvTqdNB85N2+elfdLxP5iZpfJ9kzXTusAGwN+Aa4ANkvXTEvii9Xl13FwQBEHQG4uVn8IawKnJqmgCcKaZnS/pJuB0SV8Drgd+ks7/CfBTSXPxGcO+AGY2R9KZwE3A88CBZvYCgKSDgIuAicDJZjantjsMgiAIuqZUOJjZ34Et25Tfjq8/NJc/Dew9RFtHAke2Kb8AuCCjv0EQBEEfCA/pIAiCoIUQDkEQBEELIRyCIAiCFkI4BEEQBC2EcAiCIAhaCOEQBEEQtBDCIQiCIGghhEMQBEHQQgiHIAiCoIUQDkEQBEELIRyCIAiCFkI4BEEQBC2EcAiCIAhaCOEQBEEQtBDCIQiCIGghhEMQBEHQQgiHIAiCoIUQDkEQBEELIRyCIAiCFkI4BEEQBC2EcAiCIAhaCOEQBEEQtBDCIQiCIGghhEMQBEHQQgiHIAiCoIUQDkEQBEELIRyCIAiCFkI4BEEQBC2UCgdJa0m6TNLNkuZIOjiVryjpEkm3pb8rpHJJ+p6kuZL+LmmrQlvT0/m3SZpeKN9a0j9Sne9J0nDcbBAEQZBHzszheeAQM3slsB1woKSNgcOAS81sA+DStA+wO7BB+swAfgAuTIDDgW2BbYDDGwIlnTOjUG+36rcWBEEQ9EqpcDCze83surT9BHAzsCawB3BqOu1UYM+0vQdwmjlXActLWgN4M3CJmT1sZo8AlwC7pWMvMbMrzcyA0wptBUEQBCNAV2sOkqYAWwJXA6uZ2b3gAgRYNZ22JnB3odr8VNapfH6b8iAIgmCEyBYOkpYFzgJmmtnjnU5tU2Y9lLfrwwxJsyTNWrBgQVmXgyAIgh7JEg6SFscFw8/N7OxUfH9SCZH+PpDK5wNrFapPBu4pKZ/cprwFMzvRzKaa2dRVVlklp+tBEARBD+RYKwn4CXCzmX2ncOg8oGFxNB04t1C+f7Ja2g54LKmdLgJ2lbRCWojeFbgoHXtC0nbpWvsX2gqCIAhGgMUyztkeeD/wD0mzU9nngaOBMyV9GLgL2DsduwB4CzAX+DfwQQAze1jSV4Fr0nlfMbOH0/bHgVOApYAL0ycIgiAYIUqFg5ldQft1AYBd2pxvwIFDtHUycHKb8lnAJmV9CYIgCPpDeEgHQRAELYRwCIIgCFoI4RAEQRC0EMIhCIIgaCGEQxAEQdBCCIcgCIKghRAOQRAEQQshHIIgCIIWQjgEQRAELYRwCIIgCFoI4RAEQRC0EMIhCIIgaCGEQxAEQdBCCIcgCIKghZx8DosMUw77bcfj845+a596EgRBMLLEzCEIgiBoIYRDEARB0EIIhyAIgqCFEA5BEARBCyEcgiAIghZCOARBEAQthHAIgiAIWgjhEARBELQQwiEIgiBoIYRDEARB0EIIhyAIgqCFEA5BEARBCyEcgiAIghZCOARBEAQtlAoHSSdLekDSjYWyFSVdIum29HeFVC5J35M0V9LfJW1VqDM9nX+bpOmF8q0l/SPV+Z4k1X2TQRAEQXfkzBxOAXZrKjsMuNTMNgAuTfsAuwMbpM8M4AfgwgQ4HNgW2AY4vCFQ0jkzCvWarxUEQRD0mVLhYGZ/Ah5uKt4DODVtnwrsWSg/zZyrgOUlrQG8GbjEzB42s0eAS4Dd0rGXmNmVZmbAaYW2giAIghGi1zWH1czsXoD0d9VUviZwd+G8+amsU/n8NuVtkTRD0ixJsxYsWNBj14MgCIIy6l6QbrdeYD2Ut8XMTjSzqWY2dZVVVumxi0EQBEEZveaQvl/SGmZ2b1INPZDK5wNrFc6bDNyTyt/QVH55Kp/c5vwxSVkOaog81EEQjA16nTmcBzQsjqYD5xbK909WS9sBjyW100XArpJWSAvRuwIXpWNPSNouWSntX2grCIIgGCFKZw6Sfom/9a8saT5udXQ0cKakDwN3AXun0y8A3gLMBf4NfBDAzB6W9FXgmnTeV8ysscj9cdwiaingwvQJgiAIRpBS4WBm+w1xaJc25xpw4BDtnAyc3KZ8FrBJWT+CIAiC/hEe0kEQBEELIRyCIAiCFkI4BEEQBC2EcAiCIAhaCOEQBEEQtBDCIQiCIGghhEMQBEHQQgiHIAiCoIUQDkEQBEELvQbeC4aJsuB9EbgvCIJ+EDOHIAiCoIWYOYxDYvYRBEFVQjgELUReiiAIQq0UBEEQtBDCIQiCIGghhEMQBEHQQgiHIAiCoIUQDkEQBEELIRyCIAiCFsKUNRgWwhw2CMY2MXMIgiAIWoiZQzBqCU/vIBg5QjgE45oQMEHQGyEcgqADdayd9KONEHJB3cSaQxAEQdBCCIcgCIKghVArBcEiQlXVVKjHFi1COARBMKaoQ8CEkCpn1AgHSbsB3wUmAj82s6NHuEtBEARtGS2zqOEUcqNizUHSROD7wO7AxsB+kjYe2V4FQRAsuowK4QBsA8w1s9vN7FngdGCPEe5TEATBIstoEQ5rAncX9uensiAIgmAEkJmNdB+QtDfwZjP7SNp/P7CNmX2y6bwZwIy0+wrg1g7Nrgw8WLFrVdsYDX0YLW2Mhj6MljZGQx9GSxujoQ+jpY1+9GEdM1slqyUzG/EP8BrgosL+54DPVWxzVg39qtTGaOjDaGljNPRhtLQxGvowWtoYDX0YLW2Mhj4UP6NFrXQNsIGkdSUtAewLnDfCfQqCIFhkGRWmrGb2vKSDgItwU9aTzWzOCHcrCIJgkWVUCAcAM7sAuKDGJk8cBW2Mhj6MljZGQx9GSxujoQ+jpY3R0IfR0sZo6MNCRsWCdBAEQTC6GC1rDkEQBMEoIoRDEARBF0haJMbNcXuTkpaX9IVR0I91KtZ/haST6urPSDES9yFpMUlvl/Tp9HmbpMrrbJLeJOmSOvqYca1zU9+3T5Z8vbTxmcL23k3Hjqrax5Gmn79H4jpJr+m1sqT3Fba3bzp2UJWO1TnujXnhIGktSSdKOl/SRyQtLenbwD+BVbtoZ6KklQv7S0iaIenmzPqvkfRuSaum/c0k/QK4IrP+ZpIulnSjpK9JWk3SWcClwE2Zbewh6cDC/tWSbk+fd+e0UZU67iPjGqUCV9LLgDnAIcDLcI/7TwNz0rGc6+ws6Z+SnpT0M0kbS5oFHA38oPc76GpAOwlYATgSuE/SXyV9S9JeklbLvNy+he3PNR3bLbONSv8jko6X9L3C57uSviRphy6uP2y/R5d8DPiupJMkrdBD/f8sbB/fdOxDOQ3UNe51pC6HiZH6AJcBXwbeDBwL/B34JbB6F23sCzwG3AP8EdgJD+FxDrBVRv1vATen614DHA7cDxwMTMrsw9XAB3DP74OB/03tZtVPbfwFWKuwPxtYCVgbuLSLds4sbH+j6djFw30fhbZeA7wbWDXtbwb8Arg7o+4pwMw25f8BnJp5/euBNwBLAnsCjwMHd3kPO+P/sE8CP8MDS84CrgXe2WVbE4GpwKHAXOCF3Ptot91uv0MbVf9Hprf5fAq4st3vNIy/x3GF7YObjp3SRTsCPg78C/hv4HuNT59+j8rjXuk16mpopD7ADU379wNLdtnGjcD6aXsr4Blgry7q39QY/PC3vKeADbrsw+ym/buBiV22cU3T/n8Xtq/qop3iw3vdUMeG6z5SvUoCF7ilw7FbM/vQfO//6uE+6hjQVgbegb8hXw5cBfwQmN7tfbS5p+sy26j0P9Kh3aW6GBDr+D0qfxfp3JWAk9Nv8UEKQq9Pv0flca/sM2r8HKqQpnZKu/cBS0taBsDMHs5o4lkzm5vOv07SHWZ2ThddeMrMnk71H5F0q5nd1kV9gEmStmTgPp4ENpOkRr8y2hg0xTWzov4yL55KqtrjMajnPgDeCmxpZk+n3/ceYLMuvtenOhz7d2Yby0t6Z2FfxX0zOzujDTOzy9P2ryUtMLPvZl4fSbfhb+xn4U6iXzOzJ3PrJzaX9Dj+myyVtkn7kzLbqPo/0hYzeyo9GjnU8XtoiO1sJB2Aqyi/BXzY0ujcBRtJ+nu6/nppu9Gfl3fRj6rjXkfGg3B4KT5FL/7QjQHIyPuyV5VU1AMuW9w3s++U1F9PUjHcx5Tivpm9I6MP9wHfGWLfcPVEGVdL+qiZDVr4lfQx4G8Z9RssnQb4Cfhg0hjshb/pdaKO+4DqAvelTQNJAwEvyWzjT8DbC/t/LOwbkDMYVR3QTga2A94FbApsIulK/G37hYzrY2YTc84roer/SAty44D34+qpHOr4PSakQXVCYbsxduR+T68DXmNmDzQfkLSCmT1SUv+VmdfpRB3jXkfCCQ6QdHin42Z2REn915fU/2Mv/eqWtBj+a3zK33hQtiapNMzs/sx2Lutw2Mwsd4DvGUmP4oNBgx2L+2UCV9IpdJjlmNkHK3Yxi5J+mJllLUCmtjYEXouvxbwOWGBmHZ+9VG/FTsdz3jJr+B95gtbv4Sl8gJ9pZveU9aEOJM0DXqT9rMHMrHRQlfRjSxGkm8rXAi40s0167NtEYF8z+3kv9etmzAsHSVt1Ot6FGqNKH15iZo8PcWxtM7sro412b7kLyZwyN9raGXhV2p1jZn/IrZvR9rZmdnWH47Xcx2gQuJKOM7OZafvgojpI0ilm9oHh7kPhei/HBcP26e/LgKvN7G0Zde/AB+aeB8TRwGj5PZLAXwzY38xeTGWvxMP/HGFmp5TUfwlwIG5Bdx5wCXAQbmgw28xKE51Jep+Z/Sxtb29mfykcO8jM/ruHWxt8jXEgHCq/5Uo608zek7a/YWafLRy72Mx2Lal/nZltlbYvNbNd2h0raeN/Su6jmzfMnXDhYMBNZtbpO+oKSXeZ2dodjtdyH1UFbh0DSdPvOuh37OJ3rdQPSefgaqXHgb/iFml/NbO6zILXNLP/zTjve52Om9l/lNT/OnDsEKqYQf9zHdqo4/dYB3jUzB5L+zvhhgLzgO+bZ6Isa0PAj/A1vn2BbYEzgAPMrDS5tKRzgUdwS61dUjtL4IYKs8vqpzYqfxdljPk1BzPbaahjkhbPbGaDwvabgOKDmrOQW3wja57CZy16dVJzKNOeXdKauN71aQb0ke+R9A3csqR0EMi5TKeDddxH4nLcKqZF4OKqs7KHf8fC9nSguAi8WWYfKi9e1tCP/wE+amZVk8AMxZW4qXMZ11a8zieAaZI+0WYAbf6fG4o6fo8zgb2AxyRtAfw/4OvAFsAJQIu6qJm0AD1D0nfx53QdYG8zuyqzDy83s03BVVR4cp61zeyJLu6j03fR63cziDEvHJpJUn0nYBq+WJUzIFWxzmk+p/n8nqZmkl6KL0JOwxewctKm/jfwg+ZpraT98Qe/jrzcXd1Pj/cB1QVuHQNJHYuXlfphZudJWlXSERRmg8AJuWtIXfSvUz9ObVtZmsTgReKhuB1ffP65pN2BQxsGB7l9oJ7fY6nC+sb78PQA35aHxMh9az+eATXdxvj63jRJ06B8FgU819gwsxfkll/dCAYYhjGnmXEjHCRtiw9Ae+GDyYG4uVkOVaxzYMCSQwy26hBdmJBKWgq3Z5+Gvxkvh095/9SpXoGNzWyv5kIzO01duNRL+g3tHzDh9t1l9aveB1R/+OsYSJotQorrV7n/gJX6IQ+v8Avcqe+0VHcr3DLtvUVdc490PZCkhdNdgf1wJ6w/42/gHa9jZjem/9NvArMkTTOzv5fUK1LH71EURDuTPMbN7EXlm9TOGmI7l4ZpcaM/DfNieVcsx5quFnPYToyHNYcjgfcAd+EOU+fgqfLW7aKNy+ls2TKk6irVr2TJkdr4Oa6CuBg4HfgDMLfL+5hrZuu3KZ8A/LPdsSHa6XkxuI77SO3Mx01ghXvSNkwlhVu3rFVSfx4VrVLqoGo/JF0FfNzMrm8q3wL4kZltm9GHxptuyyHcaSvLtFfSjrjAfytuGr09riIp9RtpoxffHXfk+x7wPjPbMqONdczszpy+dmjju8AawL34C8yGZvacpDWA35jZ1B7bXQFfy+jLgKqSEDJVvycYHzOHGcCteGyV882dprr6gczsDRX78Fsz6+UNosgm+CLVzbh37wvd3gfwG3lwu5lm9n8AcqeYY+kikVJFS6A67gM8ptBybbYBfpxR//U1DCSVLeHMbEqH9nNUbC9pFgyp3dmSlmtXoQ2dns2s5zYJ67vw/7NPm9kTSR2S61A4SDia2YWSpuJ+HLlrQOdQvtZUxkxgH1xA7GBmDRXP6kDW7FrSf+EhZm6RtCRwIb5m8XyaDf2+pH6zmtToUrDUMfiXMR6Ew+oMTHGPS9ZLS0lazMyez2lA1c0vT5K0LD5zOb0XSxIz21zSRvib2e8lPQAsJ2l1M7svs5nP4Itrd0pqPDxrA6cCn8/ti6Q9gMlm9v20fzUD6rHPmNmvhvk+Os62lBdZtY6B5NsdjnXj0DcUOYvBUhvHqjTAZAXOHGq9ILVzTE4buIf2nvjA+kKyuOlG6B/cpl8LgLdL2i6zjToWWl9hZqcDpIG90Zfru+jHPsBX0/Z0BtTHG+L/ax2FA64aazYtXk7SbOAjZjavrANq7zcC3ammOl9jrKuViqTFsbfhgmIHPNjctIx6lc0vJb0CN2vbB3iWAUHRk4RPb1XT8MBz883stV3UXQpYH39Q5nbxdteo/xfcGefutD8bN7lbBvifJsuhsrZ6uo+07nFQ8/cnaRfgu1biaCTp+hxVxUgi6e4M9dgM4KO4DXzRsfEb+GLqjyr2oaNpctO5DWOP/YC34J7mHwYusJKQHs1qpR77+gCuqmxLxkJwXeawC58tecThixu/Q5X7TC+pM8wsO1LucDIeZg4LSdYPvwJ+labcHWcEhXqVvWXN7FbgCOAISZvjguIPku4zs+07127b3ix80e4QBptDdkTSSvhgvFEqulnSL83soS4uv0RDMCSuSPUfSmqqbHq9D3wQuEzST/AFzFWA4/A37ekZ9ddUB9v8nIFkKCS9CZ9BvanXNhrdKD3B7ERJ9+BvqgsdG/EYS7+peH3o4m08qT3+gD/XiwO748/5CXhwwFqu04GnqG5SW4cJ6DOSNsGD3e2EC+4GS/faMTM7W9IXe60PIGl54EAzO7JKOzAOhIMGx3up0s5EYAVL9uTyxCofAD5lZtmxUNLi76q4Ce0ywILMekMtGjYoXQeQe2n+AQ/Qdj3+sL8a+Lyknc3slpy+UCGAXx33ka75c0nn44LhZmBxPKfBSZm62coDidzT/Ie4N/KvgaMYsBjK+ucrWQxePqcNMzsfOD/n3CEM24fOAAAgAElEQVT6MFT4jIZFXtckXf15wHlpplrGuhocf6y5vZz4Yw91UpFlUocJ6Ez8JXQV3LHvDgBJb8H/73oiqaazVIXyUB1fYuDZ/AX+ArF/2q7MmBcODF6o/Bjuudgg68eWtG+q93/yKJhfBn6Kh4p+b2Ybr8On23vi4Y1PxwXLYzn1GbwweAQeorpbvop7WZ7Z1Ld34YPZuzLbqRLAr477aLAxsE265lRc4C5GwU68A3UMJN/GDR6uxN+SrwK+ZF1EVaXiYnCZsM2cAbXTcTco9QhO/fhHp35Qvqi8gM5rODlk9bWEyWlGqcI2aT/LB8fc2W2jNuUXkGH4McQL7Qq49VRu2IvT8Bets/CETVfhM8pNu1nb69jPcbbm0JOeWdKNeGC6uclC5Upc554VkljS3bglx+m4FUMl56QK93Grmb2i22Ntzq0rgF/Pen+55+hW+BT5yqTOOgLXdc80s4tL6l9lZrkLjEO10ayT/peZrVelzR76UFShtQjbGgRgbj8appMCfov/DsV+dFxbq2PNoQ6avs8Wcr7PNoO74V7OVzRmESX1m1+YDHgI+JOZ/aOsfmrjBjPbvLB/P+5l/UxO/RzGw8yhSK+Srmqs+h2G+ufoxmqqQK/38X89Hht8cY9/81oNDuD3W+s+gF+VN485wMcshaU2N809VNKpuI67o3BoJxgkrYfP7vYtW9BOVM4foKEdChttdFSnFAcrSTN7FQZJTfpeBntZ/yJ3MCk+35Ke6cHQYl6X5w8LNQnTdibEU4AvSPpywxqqA0uaWbb14FBomPM5jLeZQ09vJxpwuGrwn8V9K4lVL+kKM9shbf/UzN5fpU813sfCQ2Q4jpW0vQyuMptmZm/NrFPL22LSxVoSEN3WXQO3IJuGqz6+Dpyd84ZWkxVbbdFlKzwXG+PrA39hwMN4K9yJbQ8zm9Nle6NiFtALndY9IHvtY6i2VwR+X/bd1GS5NY9hdvIc8zOHJl3o+hrsRm5mluNg0+xk1bxfRtGC51VNx7IW/DRgt1x0p2/UN8uzW+7U7xzHseY+LYGrD6bhes2z8AXaTnWK9tdL93gfjbY+ARyGf79KbX/DzE7IqPtRfJYwGQ+29hHgXMvwVm9QhxUbnpRnyOiyNbSfw/G4l/UlTdd/I67j7hgBIJ1bHMyKIWaAPIfAqkhaGnguLYY3zMffAtyZM4tLvAZPXftLPN95LUHqwN/WpawYHBOb3vpb2sm41pQuu9c1Y37moGF2I5e0TNkbq/oQPrefJFPNRtycy/BwxMf344Es9OGLeN6Cg8zs9lT2cjyq6dVm9rWS+s/ia0eHJHNaJN3e7RtVVSs2VQzn3ixsGUhxmi1sJd1iZi0LqOnYzZn3MRoSQP0JT8t5m6T1cUOFn+OGC38zs89ltDERjwK7Hz6T/C3wy25nT0O0vTPwxbLvQtIzwP8yDG/9SWAeamYf7bWNBmN+5oCbNnbMt5CDPJTBGsDfzezZtCg7Ex8IXlZSfXlJe+FmaEU9tfBgYTnXr5ytq0YuwoOp7WADZnrdWOgsJH2vjQBz93Sx/vJ+YHMbiNyJmd0u6T3ADUBH4YD/ZnsD35GHCj8TN4ftpu+VrdgYPAB0HV3WzLqZwQ7FBElLNq8vyJ1Gc8eAz5vZlb12QPUk5VrBBlLFTscH9U8mgX0tKYheyXVeAH4H/E7uIb0fcLmkr5jZ8Rl9GMpya0U8z/n+GU3c1KuhRqEPmwHHMGDKejy+Frct1a3CgPEhHLKjng6FpJl4XJW5wJJpIPwObi62dUYTf8TN0BrbxRDGuZFIH8Rz6TYGz+LAUUtO2C7YGndu+r2k23ErrKxIppI+ByxuZl9JRVcCj+ED86m4zj+LomAolD0l6cWMug/icYB+ILcJ3wd4QNLNwDmZC4JfBLa2Hq3YGl0ZYrvdfguSXg2sbGYXNpW/HRe2Ob4cpwFnyTOEzUv1p+BB736aUR/g+1QLR1IcsLbGzXgbz3huKJLi97Uz8C2A9DJX+kw0SELhrbhgmIJ/D9mZFvEoDM39eqiXNbEKnIQ/31fiKt/rcP+G97b7v+kJMxvTHzxO/DuH+mS2cROwYtpeG7en3q7P9/Fd/I34BDw/sEb6u0392h7XS9+LBxibUXL+dcAyhf3r09+JuKlf7nUvBXZpU74zcFmF+3kFcHjmudc17d/Sw/Xm4wYOhxS2G/t3Z9S/HJjSpnx94A9d9OMg3Nz6wfS5E/hkF/Wvr/GZ6qkt4Gf42/KncO/kpVP58sANmW2cis8yvgZs0mM/Vuz0yaj/gSHKJ+FJg3L6MLtp/25gYl2/kZmNizWHh4BzGVp/l2NR0rxOcKN1kSS8jd1zcyc6WjsV2hHwBvyNZhvcXPMHlmE7XWjjFbjj1sLwGbjq7dbcNoZodwKuq92n03fa5rv8gKXkQ5KuNbOcmRiSXoX/rlcw4MT1arqwsEmqwQPpMUlOVSu21EalcO6S/mEpa1ibY4Ns3XNQiuRqXSaXkfQoHWbB1oWVTwWrq6XwAH5r4HGlbkjlrwXWM7PSWVCaYTTe8IuDXzdrOHcwYDyyBq5OWjgLsi7WDNQmN4aZvTuj3i2pTuO6P8cNR5Q6UdlAYDyole7MEQAlFD0lwRP2LNy3ci/UOvTCmEvqyyRdj6t1vgrchk8hS5H0Gnx6/CPgRPxB2TK1+U7LTGOoNsnLzROpXyRpg5Lqy0pa3JJFSUEwLIkHasvCzObI49dMwwd34YPTxyxj2qx6kuRUtWID+J41RVTtkk6hKbLiXKWXl8fM7CdFoSDpk/jb5nEZzdTh4VwJM3sKOLqxL4/vtAkeXPKvmW1khacoaWNhbhL17rDaLjfGupYfJPM+Br+4FPfriBg8LmYOlaNvqgavyQ5tl1o7Nc7D03jug6+jnA2cYYMD4JW1cSFu6nl5U/nrgcPMbPfMdnq2vpJ0FB5G/aDGg57u7b+B+yzDoqRD2yvjut0cXX3lJDl1II8kugD4K+5n8Fcz+2cX9X+Ie89+sXjf8rSha5jZjIw2bgS2MrNnm8qXBK6xDHPvqlZ3GhwGZF+aoqtmvIA1vovj04vDS3F9+wu4OudQM/tlj33r2oenULcXP6Ziboxf20BujK4SYg03laXoKOD97QolTZSUZVFiZqcO9cGna6VIWlPS1GQ5gTzv71H4m38OD+D5GP6Kv6HdDrxa0jtVkm+iwHrNggEWOlp1s6BdJXLll/B7uUvStZKuw71j70/H8jogbSfpcklnS9oyDXA3AvdLyglpPGSSHDLf/iWdWdj+RtOxjh7aheutiqeu/Qtumnu2pPslnSvpMxlNHIL/dnMlnZU+c/G1k9ygk9YsGFLhM2RYTCXmZZ43FLNw9eC1ePrea5s+ObyuoE78IJ7dcFN8gTvnu1yIpCUk7Zl+43uBN1Liw1MjZ+FxnPbB81ksQ5fRBIrPjqS9m44dVUcna1u8GKkPrqr4HP5muiv+sH8SX3A7N7ONKwrbP206dl1G/Zn42+GV+ILsdPxt71j87S6nD6cA/zPE5+TMNq7tcKz0Ptqd21wvtx1cHbJp+izVw+86K/2ee+OZ5bZL5RuRsaCJr7Ws0KZ8RTIXlovXafM99Lqoul56PucCT3VR7+W4Fdzb8dSc3VzzH8BqbcpXA/7Ry30U2ngTcEmVNrq4VvH3+C2Fhd3c3yP192Tcz+Bn6fuc12U//rPwmd+0/5+ZbQhX/ZyU+vIEnu542cz6lf9Hyz7jYc3hp/jgcSXuBftpYAl80XJ2ZhtVPZxn4BmmHpZ7vc4FdrRMHT+AmX0g99wOrKX2OQyyI04mek5ennSpzbxayXHUzHJNexezFFwv2aBflerforxE8McCF0tqlyTn2Mw+dHqby434+1p8xvAaYC18RngV8L5Cv8o74o6At+ee38S3gN/Kc2oUv4tv4tY/pUjaCV/L6il8uSrGmEo8Kult+GC6PZ5oCHlmwJyw4VCPD0/VdSjMR/Fec2NAtdl9FuNBOLzckjWHPJLng3h0wm6sMaoOAk9bclIzs7sk/bMbwQBtLZ66ivSY+HSHY93kuM7OX5HZBwM2x0NZZPlL4HFjGjzVpr2OWGuSnIa1UjdJcpaWh4mYwOCQESJ/MLoCH5C/g+uXu8rKVwdmdpqkBcBX8AVcwwMbHm5N/hMd+A7VwpfnpiPtxMdwn4TV8VhhjdDUu+AziRx69uFpYF2EYMlsr9vcGFBPXoqOjIcF6crhKtJDcgg+CHyLgcxOAr5pJWGa1Zq+cNCCm+UttrUzeVwRN2/7spVHeixrfx2rEEqkm8Xgpno74A6GKwBH5g7Mkl7ATQ4bA3ExbMQkM+vK27kX1DlkBGaWE5NodXzm8FrcPHkxXFhcCVyZZgSjnjb/Z30PX143yaJtPzzPyWzcOfLEPly3Y24MyzMQGPb/j/EgHIpfEgx8Ud3YLXeKvomVBGAbZmunrEiPhfNfg6uQ/mRmD8jd7A/DF/OyorLKE60fDTyMv3n/FJ/qTgD2N7PfZbSxC74AbcBR1hT0bbiR9E3gdjP7YVP5p4DVzeyzGW1s1+0MMKPNpYEP4etU65pZx7dWSccxYOX0v3X2pRvSC1QxHeYxxX0rCXxX04DYnPioMbu+zMyuKKvfod2GD8++Zf/rdaAa4sGpYC4+XIx54VAHch+Abtznm+sfZTXEZ+/Qfpa5rqRv4a79s3EP2vOBT+D64R9Zplu9pFnA5/G4UCcCu5vZVZI2wuPZDNkXSW/FZwqP4SqcHH+C2pF0E+4B+2JT+QQ8flapk2NV883Uxkvx9YbG7GFLfE3qr8BfzOxXJfUPKtSFgkks7hWcHTaiCiUvUGYlvkaqmCwotdHuJWxFfCH3DMvw11A9MZ5GnDqezdJrjBfhkBbMGrrlOdbGpLND3ao23MP2Qykz0mM69ybcnv1peUjge4DNbCBYWe41Z5vZFml7UNTOMkEl90Cdj4cCaXm4MhceKyNpjpk1GxeUHms6rw4fmgW4fv6v6fM3c2euXtpaA1+IfS0ey2vVnJnxaKPu/5ekp/9r5gvUZQx4N0PTM5r5f9YxuJ6ZnVZSv+FhvbCosG856ro6ns0yxvyCtDzq59nA0wwkMnlPemD26tNUvHJ89iGm3d1EegQ3jXw6XfMReWrQrgRDospicKkevk/8W9IGzfcv9/DOHZzXVYfkMJmC7idmdljm9doiN8/aFBcK2+MhqueSHzQPVQw9nupsghscFBf4j7HM1JbDhXkwxtzTP4vHtLoXFs5G3oX7cXw5s41XtykTbha7Jm7F1YmpTfsT8NnPoUCLb84QrNLGiGUhlhmypxNjXjjg/g0/sBSmoUGS7ifgXsdlNEw3m8lNGLQRA4KpGSPPAa2OSI/rNQ1mU4r7Xby1by5P0tMu8dCkThUtZTaTh4NeH7+Pf+WqtGrkv4ALJX2NASerqbhPzMzMNuoIGbErvubTE5IuwX15ZuMzkKPM7OYu26gcelzSHvg6w9fx70S45c/Zkg41s3NL6g9LsqBkxvp+fLaaww9xh7eG2fXXcb+TLXAVamlcIzP7ZOH6wr/Dz+K/T6lZr5k9lOpOSH3/NP77vtXMbsq8j4nAstRkttqOMa9WSm/Hr+j2WNN5c2jSgRYp04fWpH6onM9BNaak7JX0z3oUvuh6J/5WNBl35vvCcC+iNfWl8abbWF+4kS7edGtac7gBD6bY06xS0o9wM+B/44NPw8rpwS76cCOwp1UIPZ7uYw9LIb8L5VNwZ9OOAQBLLL8sU51TTHzU4Ck8TP5MM7sno42FwQolfR9YYGZfTvsL1akZ7SyGz7wOwTPKfd0yg1vK/Ro+hEeXvSLV/VdO3UIbw77mMB5mDm2tPZJUzrVffraKmWdNNCKPVpl9jIaUlN/CnYLWteRrIukl+FvnMXhUzb5gZjfi3uq9Mq+GblSaVZrZx2Dhd7gdrlo6UNIqwI1mlnN/z5rZ3NTedfI4Pt3kpADP0TGvTf/mpcGuI5Zh9pvRRh0BLidKWsw86dQuuO9Gg6zxUNKB+HN8KbBbD2PHHXjeluPwGEubS1ooXDONY4ZtxtBgPAiH30g6CX9z+D8AeaySY4ELMtuoalEzpCNQ4UHsiNUTdOtyUkIWNaWkxL1a+5Gu9G3AhlaYkprZ45I+DtxCH4VDVcwsN6ZVJypn/Uo8g88enkrbk/FIADms2qSfXra4n6mffk7S2mZ2V7EwWSGVPt/ypEV3W3JcS2rfd+Gzyy/nzIw7tN1NasxfAn+U9CD+Xf45tbE+bmGXw/F4/LAd8PFnYVfIU0P/ngHH0OYZl5GXeGiX8lOqMR6Ew2dwveGdkhoSfG08qUeWeamZHVSxDx/BYyMh6admVgwG+DcyB+U0Vd2dgVwMNwEX5QiXRhOF7a5TUtaEFQVDofAFSWNbh9kble5Z0rH4bGFDfLHyr/j6wXQzezSzmTpCjx+OexUfxeD8Gofh+vYyfsRgXf/RdKnrVw2pMc3sSEmX4nkYLi48qxNSf3Ko9CJnNYTKqSJMcxnzwiHpsA+V9CV8AVR4fPd+himoGpsJSS8DLsMjRF6f6r0Nz4G8U44+lT641Gdwk6T9m835JL0PnzmMCyS9LPM3WaPipe7AIwNfb57/uGushnAPZvbrZIJ5CD6ICg/B8R5LSXdKmFgY0PYBTjSzs/D0pbkx0GpJjWltHButizDqQ6mR5B7X0/AEU0PSycootV/Z0qgOxrxwUPtw1utrINBbz85tqf1tzezqktMqB2jDF3F/YE2OPJL+A58Z5eiWG+oDMViVIGrItZ3JgbgFy4cY/Ia5FJ66tS+o1Zt2EJYR0qSEq/AZahn3lZ8yNGb2vWR2ur88O17DhPQX5iG3S5F0ppm9J21/wwre4ZIuNrNdM/tyA/lm1c1U1vUDSxasEm+VB1U8rFehWQfy/CDTcFPUO8hTCVVeO5G0kZndkraXLD4Lqsmzf8wLB9y2uLhdjN2Tq7/rxP+jfBBYXtJe+NR0+YLAEu5lnMN27aabaXDITfFZVBc0qw5+nNlGJcz9SraVO+81MrhdaGaX9uP6BYqBBo/A1SJ1kqumm1DFB0bSxnhQtr8wsLD9BuALkt6RafpYzN73JgargbJeGlQ9qmoduv5JTSawTwKbJXPSvnk3S9oQj5+2Hx6a/wzc8jNr0b2OmRw+Y2qoq69ksOr6BGpYXxzzpqxF6jApbdPm3VYSk0gVYzOlNobs+3Dc10gg6S4z65fVVPG6w/FcZN2LpGfwENND5TgvC4F+KXC0NcWmkvRG3DQ4J/hfz5n9Cuc1zKSFv3h8pOlGSs2k5TG7Grr+hvHIhngOg9KBvQ5z2DqQRwH4M/DhhhWYpNvLfstC/XZh9ReSM6stPtPNz3ddz/t4mDkUGQ5JlxMeuo5gXS8dQkUmMnMv1/HQDTP9WhRvpqfnooNqSsDymc1UtVZas1kwAJjZ71P/cqgcerw4+Et6MkcYtGmjqq5/tHjfvwufOVwm6Xd4BOZunu0DcJ+bM/EICL38Xwz7+uJ4Ew490WHKLGClzDaqhif4E4NVZM3HciimWxwOVUpVxto0tVMOjG7yY1RhQrNOGWh4oOf+/97LQPL5donpu2Ws/Y61knxEztFA7ulPAatJ+gEe9rsshewaeIbDfXAz4DOAs8zskS66MTm9DKqwTdrvJrHXkIx5tVLTwL4jTQNphi60smexCuEJ8JzRX2YgPMFX+6ULberTiKiiOlhiCFeDdPQEr7EfRW/apRkc796sYsA6SceY2aEZ532gsYgqadl07eyQKJK+iDu/HWTJCU3ulfw9YJaZfaXrzveABnvwX0aT13c/TCtHM+n72RvYpxv1ljw23H54itHPmllWvCwNY5qAhdcYB8JhWENGSDrDzPYpOaeO8ATHmdnMtH2wFTJsSTqlW9voXF1y3ah90qKF1LQYl9OPYY133836iaRP4P4Ay+AD6hPAN8zshMz6B+H+PEun+k/iYUBy1UpIWgm3qmn40NyMWzxlDeoaiCTa09rJcCNphS7fvKtcq3Kom9TOVrhgeBM+6/92poFBWbvrDGVu21U7Y104NCN35d8E+F8ze6CG9koHgTaLfLeY2Uad6nRqo9dFw059WtQY7vvPMVRI530Bj6R6kKWsb5JejnvVX21mX+vimssBWHcpcJH0Sjxf8UUM+NBsiQ9KOzdMIkc7kn5sZh9pU74WbhFXmqOjpn5UEpSSjsB9mG7G1yt+Z/mOrsV2Kif26tj+WBcOkn4IHG9mc+SJVa4EXsA9hA81s19WbD9HOMxnsB73P4v7luHUUmJ9kGtR0lCltEsdWFmVMpaoQ63W4Q1ReKKdyRlt3Apsbk1OWvKQ8jeY2YYl9Ss7TEn6FXCmmZ3ZVP4uYJqZvSujjXWAR83ssbS/E65vnwd838yeLWujKpJOwddZ9reU5CgJvguAI6wpMvNoJVk73c5A6PjGIJwbfgPVlNirE+NhQfp1ZnZA2v4g8E8z21Oeu/dC3L66Ixo6O5SAnFysdYQnaNjDT6DVNj4rgKDVE5hsvFBHvPtOwRCzB8N2/6jmOQhysrgVf9OP4Wtb3bKpmbWEpzCzs+ThMHI4E9gLeEzu+PX/cOfMLXC7+pY3+mHgg/j9n5HW+bbFF3MPMLPf9uH6HVF+jKc64qi9FdjSKib26sR4EA7Ff9I34Q8tZnaf8hOAdIrLUjrlrkmP/lIGR+8sLmJnTe+SBcsB+JvE34GTe5mujhMqx7u3eoIhzpe0izU5AcqdBO/N6MPCZ0vSnj0+a50WwHMXx5eygXAh78OfrW/Lox/nhr+ohLmaY4ak7+JBJtcB9m5nIjucqGKMpzrWA6gvsdeQjAfh8Kikt+GORtsDHwaQB7HLteEecftpM5tSQzOnAs/hDjpvwT2U+xoFNb2tP2ZmP2kq/yQeX6c0z29N3FvVkqfNjNKAB83s7i6a+Q/gXElXMDicyPbkJaJqvn4vNEdlbdBNWJWikN0ZT5qEmb3YxUtYJQp+J8Kz4V0HTJM0LfWlX348tcR4qkhdib2GZDysOWyIm/WtDhxXMBt8M7CrmR2S0Uaz85kBDwKzu13865UOqi3vUJ4H6T/MbNO0vRier7ivi9LJcmurZh20pCWBa3L0qTX1o441h3YeuSviobL3M7OsN+Y0o5vGQDiROcDPux1Iel1kr8OCLL2tr4HPdt6Bh2V/Tp7X+jdm1pz6snb6Yb6Z2Y9BSYEk3Q1MsT7GeBpuK00YB8KhDtQ+/MWKwGa4i/wf+tCHF/FBY0GjqHDYLC9TVmUrp6oUBVQ3x4ahHyua2cNp4XRhwDoz6xSCIbftqcB3zGzHCm1MxM2df15yXjG3+Pp47mjoYvGypP1lLMPvQj492AcXEGdays0u97Ze1cwuqtKPHJKQXc7MFjSVrwo83q+3dkm34Caojf/Rn+PCv+cYT5K26qXecBLCoQPJQuNMM9s249xKHtKSPoW75T+Gm7edY2ZPdtnfFxjQIRctlvpmrZQGszea2f1N5asBv++jcFgTD7r4NANrOVvh38lejcGtQvu5FmQvwSPVrgmciyd6OZCUN9jMOqqW0jM4JLn66/R9rAH83cyeTQPqTOADZvaynDZGGkkn4mafZzeVvxfYwcw+3qd+XM7QKr6sF7k2bXb1Itf00tCuE9Vn6GYWnw4f4LqMc/bFB/V78Hy2O+EJz8/BVSzdXG9dPEnR1biFyBYj/R102f/98dASr8ctbZbDvWn/hieo6Vc/zsEHvnb9O7di26sB12aeey6eCOpj6fe8JD0jWb8rPlvYvk3564D1MtuYic9Ir8T149PxaKLHAmuM9DPTxfd+U4djc0a6fxXv7fouz1+n06eWPo30lzKaP8Ar8GTuZefdCKyftrfC0zjuVeG6rwK+ituQv6eLejsXttdtOvbOPn5vu6cB8KH0+SOwe59/u1t7OdZ03vH4elbx8zPcRv3tmW38o7A9EXgEV43k3sf5uIlic/lUXNef08ZNwIppe23cwm+7fv4eNf2mN/dybBj68ZnC9t5Nx47qsc09R/r7bf6MebVSHdYxah94b0V8Gv4+M7uypH4dHtIvx2cgewB346ql860LPapq9rIey0iaa2brtymfgPvCtBxrc27zAqjhwu4ay/S+r/o7SLrRhvD8zV3DadOHIdsczUj6I/BpM/tbU/mr8dATPa8BddmPEf8/0+DYYYMOUZMKeTyYsn6I9oktTsQD3+WYTh7TtN8YBG6zPM/POhK4z8V9E84FHsff8D6hgYx2OW1oiO12+8OChj8DWy6/kXQSMNMGcgcsg6tSLshpwOqxftlc0uNpW3jI7MfJ/yee1OFYlqk2g6N2gj+vC/dzfpNkudVJzz7sCe/xdZozk6d0IwLxVFxVuG8frt9gxP/PrODwWodlXjvGg3CwdgO4mT2jTANsa2P2JWll3Gcghzo8pL/CwD/fsl3WbTDsMd4z6Fco6zI+g3vw3impsWi7Nu4L8vmcBiRtkM59BA+HchKu6/8X8BEzu6asDTPL8m7vwDWSPmpmJzX17cMMDtHeiU837efWK9IuAu12+PdcOYZZDmb2N0nb4Av6H0jFc4Btc2dydXVliO12+/1gWK45HtRKla1j5BmqjgYexnX9PwVWxkNZ7G9mv6u948OApEfxkOXCB7FG+HLh1hwr9KEPR5lZ1uDbD+QxjNbHv4O5ZvbvkirFulcAp+HJlj6FL+z+Bv9uv2YZVmxVSc/xOfg6QfFteQl8XaurfAzqIWx4mzZeD3wJWBLXsV/Ya1t1IA+8t6+ZfatP12tYBbaLYTbJzDqG3JG0syXzeEnrmtkdhWPvtC7z3g+XKms8CIf9cS/UQxgIObE18E08IFipakDSLPwN8aW4Omp3M7tK0kbAL3OmbJJ2x71GN2YgCfw3zCxLhVEH/XCMyejDqFnbSOaaB1Lwc8Cfidz1goXOTs1rGM2OUMNN8tdorBPMsS59byR9HH8+l0lFT9JF2PDUxptxoSTzhjEAABtfSURBVPA0cKTV4DPSK2lmvzfub7Ambvpdml9jNFDHmoUGO+4eQ9PMrlsB044xr1Yys9MkLcDVMo1/nhuBw7t4o1nMUvYmSV+xFKvFzG7J0UxJ+ihuqvgZBtQqU4GjJU02sxOzb6gC/Rj8M5iowUEDB2F9SgojaXs8pMEp+Nt/w8/hb5Lea2Z/yWimGBjv8Q7Hhp00EPc0GMsTBr0WeIM1hQ1PzoKlYcMlXYOH2vgWbhI7yKvf+uDAJQ9ZvhfucLYhPqN6uWVExx3mfi2NvxTOs+TnVFZliO12+0NRzBr5x6Z9w318KjHmZw51UFWSS7oJV9s83FS+EnCF5aUJrUxfHGPK+/AMHudqRJPCSLoK+LiZXd9UvgUe0jjHsfHfuKGAgPUY7J38cjNbZqi6owlVDBuezr2cgWerOVKtWQ+OX90i6SncX+aL+P+VSbq9X89UoR/vwM2aH059+T5wPzAFz+bWUVsxGqydchjzM4earGMaFiVFaxLSfidrkYXdaPdGbGYPZa6J12KSi8d3B+/3b/Hge/3mpuGwnOiBlzQLBgAzm53eQHPoi1DvB+1Moi0/bDhm9oahjskTbPWDz+NWST8AfiHpjD5dt5mvArviaujLcD+U25Ma81Lc6KETL5cHyVNhm7SfFQlY0ttxb/c70/5/4REW7gQOLq5j9MqYFw7UYB1Tg0XJ45I2N7MbioWSNsdTQuZQ2STXCqEUJD1j9YQGHqtIbVJHyhP4TMhpYBx9f5XChrcjWQLuhKt43o57jQ8rZnYscKyk9XAh8WvgZZI+i685/HO4+5B4sXEtSXc0VHXm2dhyQuQXQ6Y0m9E37w/Fkbi1GPKo1O/D11+2BH4IvDmznSEZD8LhFaPAOuYQ4Dx5AL9iWObp+I+WQ2WT3FHCd5sL0hrEo9ZfHeaxwMWSDmWwocI30rFFidrChkvaFhcIe+GOoo04UX3DzP6FD45HStoUHxQvxFV//aCYmOvFpjW20hePTmuDaTaUs3ZoBcu7dwI/MbNrgWvlOcsrMx6Ew25k2q0PF2Z2Rfqn+QRuf90Iy7xdN6aGklYbwiQ3t35x5rGUPGLmQsHSj0VDYG1JG6XF/CWB3wGbA89LmmZmv+9DHzCzEyXdg6sAXpWK5+AmqL/pRx9GC+YpdDdhcNjwPwEfa6duaoekI4H3AHfh2RW/AszKsQasC3X2Cn4mrTN9oXmGNAxUTszVgddknqdklvxvYBc82VCDHFV4+QXG+oK0pBvwwG4jah1T6M8q6boLys5tqleHSW4na5Z+LRrOATZJi4Uz8Le6N+LWJaea2TbD3Ye6kHSKmX1gpPsxHCRT0IdyZ3PJIvBWXL15vnl6yr4vBg+FPCryJniejDEXGqSBMnLWp/M+hL8UPw48YGa7pfItgWOsBo/18TBz2IjBUryIAaUPr6SLzWzXXjuQ1D6H41PsCanoBeB4y8xGVodJro2CjHbAs4UB583A6eZJUG6WJyDqCxocLqKFTEOFviQmGm7UwclTUq6T5+r4Iux+wHHpRWQpSYvZKEhFm56xG5KByrCiiom5OtTPzVmPmZ0s6SJgVaC41nkfA97jlRgPM4c6Mn5VakOei+EtwIyGlUCyI/8BHn++LzpueQCyuxuqrDQbaVgwfLkfs6g0tf8Ibtp3K7B14TvpOiBhhX48iwvXM/FQ6oNeHjJnYs1JXQbRJzVdZVSDk2dTe5Nwy7j9gB2AS81sWs3dHrVUnaGX1M96yZP0YzP7SJvytYAL65g9hXDwNm6nfewYoNzbUNL1wJusyQEmqZguzulfHSa5kq7DQ4k8LGlHPLLrJ4EtgFea2bvL2qhKeks9BXeYOs7MvprK3wK838z2G+4+pOuthHvQ7gM8D5wBnNVsvVTSxhO4pdhQPhvDrqarAw329L7ZCn43NbwYLYeHg+/b2kPgKk9c87O/mb2Yyl6Jm7B/xVK65CqMB7VSHdYxL8XfhIZSTZV5Gy7eLBjA1x26sAGvI2DdxMLsYB/gRDM7CzhLUla+46qYe5e3zA7Mw4j0LZSImT2Em/T9UJ4FbT9gjqTPmtlPM5uZO1YEQAlFX4anmo7lrjm09cPBVRhVTcHHFHXM0NPLyzQG/lduBn7Rxez+g8CPgDMk7Qtsi78AHWBmv+3mfobERkFSiSof4L+AjdL2krhTysN4pMg3ZrZRmu2t1/q5bdNjkpCmNm7EQ4EA3ALsWDzWp9/juML2wU3HThmB52MrPOTDbOAnwMZd1O0qO9do/QAv4AuXT+CzqMcL+89ltnEjsESb8iVxZ6wRv88+fp/XMZA8aUdcbfkufD3nVxn1X4n7l5wCHIwHdDw1tbNRl335LvBn3Iqs1gRO42HmsA/+o4D7FYCrNDbEv/Ac08mqfgTFmP3N7eaaldVhkvtL4I+SHsTfEP8MIGl9PI1pPygmXJnO4Jld3xZ4JR2BzwZvxtVrn7PuF04/U3vHRgCr7uSZmhkXfjh1UHWG/lX8xenMYqGkd+H+G+8qa6CghhYe1+k6YJqkaVBP3pTxIBzqsI7JdVRrS03/fJUD1pnZkZIuxTPYXVz4Xibgaw/9oFNQsX7yJTyd5+bpc1QawxpJdnIE1Xckdcq2NS6smXKp6oczjphYsNLaBZhROJYz5mxqbdb/zOwsSUdl9mHWENu1MR6EwzPJwed+3J2/uLC8dGYbV6VBoDGYNQaEnlPuybOO7QlMM7O3ZlSpbJILC3X+zWX9CisAg71HJzQJvH7qprNi1JTwtvJTFhm+BfxWUjs/nNyQD+OFqjP0Trk0svJsWAcDAEnr5LRRxngQDjOBX+GqpGNtwGzyLUBL4LV2WCHlXhUkLYGbtE7D1URn4YuiOYyWgHVVGU7v0WysKS5SWgDcEbjLPMxAVhuS9sSTBf3DzC6qv6djA6snNP64oIYZenNa4QbCx7EsJL0Gz2XxJ/O4TpsBh+HJqNbKbWfI9gfua9El2W0fgA8CfwdO7kY/LelNuDXMm/EF8TNwB7gpXbQxLHlgF1UknQ8cZmY3SloDF1Kz8Pg7J1pGlFtJJ+DhJv6Kqw9+Y8k0Nwh6RdLhnY6b2REZbXwLn9nOxset8/HwPUfhIemzwqJ0vMZYFw6SjjOzmWn7YDP7buHYKZYR/kAe7Oo5fHq4O3CnmR3cRR9eTHU/UJi5dBVaQNIHrMk2uQeT3BGnqvdojf2YY2avStufx61A9k92+X/JWS+QdCOeB+EFeUKXP5vZ1sPb89FJHX44QX3Ic8hsZR7GZAXc0mkzM7utrmuMB7VSHdYxG1vKNS3pJ3hCkW7YGg8h/PvkUHc63evXKwesk3QHg/+BVdg3M+tH1MpZeIC7RmypQUlhgH75DTxX2N4FOAnAzJ5QZg4D3NjhhVTv34ugVU6RYVn0XFRR9bTCTzVmB2b2iKRb6xQMMD6EQx3WMQsHEjN7vtsxwDypzPXAZ+XpKfcDlpB0IR5nPidNaB0muVOb9ifgkTQPJXP9pQYOwU3xnsKF5Dlm9mSfrl3kbnmipPm4r8PvgEb2s1zHxI0k/T1tC1gv7S9y1kr9WABdVFA9aYXX0+AkQVMK+5jZOyr3cwxpLNqigaisE4A/MDhC62VmtnlGGy8wYCUgYCk8FG4Va6UJwJuAfczsQxnnL1xzkHQWvtD1o7TfVerAdO3343H2Z+MOdjd1ew9VkLQuLiT3wD1HjzKzvnhpp+uvii+eroFHtW3kCN8Jj/dUamFTNug1L3qPdzotgJpZ5QXQRQXVkFZY0us7Hbca8smPh5lDZeuYmvwUmtt8UdI83Ds1h8omuSlUx4eATwFXAHuYJ0bpO2Z2h6RzcUH7fnwG1DfhYGYP4EYGzeWX4UYDOW0sUoN/J5oWQD+bFvwbC6ClLz/BICqnFW4M/smYZn18rPtXHQvRDca8cOjGImi4SG9QxwAvw1MXHo8n39gW+HZmM5VNcoE78PAIx+Hu9JvLU5UC5QEE60AejXZffMZwN65aOrLOhzYYEd4KbDmcC6CLEJXTCicH34ZgvhPXnEyWZ6P8gpk916l+1jXGgVppxK1jJF2Nh+e+Evdv+AzwC+BL/RwU5ZEah/pBLUe9VUMfXsTNgc/F4/cM6o+ZfWe4+xDUj6Rri5ZaKkR6DbpD0g7Az4G2aYXN7IqMNo4FlgM+ZWZPpLKX4C+pT3VjbTnkNcaBcHiRDtYx1p/sZ4P+USTdDUxpWLpktlHZJLek/ZbQB8OBpC/T2eSx1IY7GH1IehRPLdpgx+J+HQugixKSVsfVco20rXPwtbGstMKSbgM2bDZzl2fEu8XMNqjaxzGvVmJ0WMdM0uB8zU8CmzVMHzNnL7UHrJP0Uvy7mYZHglyzl3a6wcy+PNzX6JUeFvYvo/NMrHIqxjHEHk37uerSoA1mdp88jlKv6wXWzv8p+eTU8sY/5oWDeZa1YwvWMZdK6rd1zL1AUV1yX2E/17a/loB1yVTzHbhA2Aqfeu7J4Le+YaUGG+7hotvvtV0CqO1wteED1bszprjezNpFHkb/v737D5arvOs4/v6QNhB+tBKbgkOhBSpibRGEgRb6g0YozEBsiVBIxAqtYsfUqaQO6IhFUMcZUplq9Q8HqkKkNiiEiURSMIWxdCgh/KhAiW0Mta2O0mTQdiiVNnz843s2d+/u3XvP3nt29+zZ72uG6Z5zdp99QsM+5znP9/l+pTlrHqcpbesFlxNrg/NZL/iKosTrrR1tX0qk61+wsR8cWkYZHeNqajcvOGGdpNuIGci9wJ8Rob07bT9QQf9KqSiGe1D6KoLithxMRejg7xL1Cz7sCcsnBDxA3GwgaWvHrOmu1rVUyjripu2YGdYLPkHUeJjLGuBOSR9k+rrFEuCCKjrZhDWHmaJj7h52dEwRE/+C7d2KUplvJ36Y7yr5+a8TFbt6laScMxVHsedDwK3ABtvf7DeNx0JVEcNdJ5LOIQaF7xNRV6XCYJumYx/OtDxgncdpdlWsF0j6R2KAOJq2dQvbW6vqZxNmDjuZHh1zFPBrrXjhYUTHSPo4sU5gSZ8FziLutM6TdGZroXk2VYTk2v5pRdH41UQqj+eAQyQdXnahqwILjuGuC0mPEKHF64hItGnRccOIhKsR93g903GaXRXrBX8NfI7InnBDFaGrnZowOFzP1F/Og0fUh0uIBd8DiWeIhzty8byCko+2qgrJtb2DKJ36cUmnEAPFNknfsn16mTYWaMEx3DXyAhFccCGxsD+qPFF10EozLaannO4rzXQCKlgvsH27pM3Ef+vbJa2nrVZ4FTfFYz841CQ65vuOEoovSfo329+DfXmaukor9lB5wjrb24m/OB9jejTUIH0M2FQsrnXFcA+pDz1JOhK4xPa6ud5r+8xZ2imbn6kpbiKek3e+Brh5+N0Za1WtF/yAuIHZn/j/o2xCyVLGfnCAWkTH/IiklcQP+quK1xTHry7ZxoJDciX96RxvWXC+lbnYflDSaUQM92VMxXC/dYiPtqaR9BrgIiKa7Qhg4zzbEZHaZDWwApiYEpm5P6U6tv8DOE3ScqbWC+7pZ71A0rlEROQmInX396ruZxMWpHtGxwA3DyM6prhL7sn25X20Ne+EdcUs5SngdiK9wbSH/J4ls+YgSFpWfO+353rvAL77EOIubDURubaRSIL4unm0dVrRzgXAUuLOb5Pt56vrcb3NdePhrOdQmqYXF3sS+LT7KC5WtPEFImru6QF0Mb6jAYNDraNj5rMzWdJPEesYvwhcZfv2kp/7UeIO+WIix9IG4I5h/ogVd9fXEj+g+xED1F6iMt71Q+zHi0RdjmuIvwfuN3JL0h8SKc+/QdQN3ghst11FfeqxUrcbj3Gm7uJiXy8TtDJsTRgcnuk1AMx2bcB9mrYz2facO5OrDsmVdAQxA1kLXG17/Xzamcf3XknU0b7CU8kDjyFyT20pNi0Oqx+XAAcRea42APf1OTh8G/hXIpHh3Y6kc0MNDa6LOtx4NIWkJz1VXOwVwLZ+du4PSxMGh4eJH6KZomNusn3qkPrRc2ey7TkXilRhwroi8mkVUU/iUeCPPaR6DpIeB862vbvj/DKiRsVQ4+GLgWkVMVD8ODGr2Wj7qyU+uwh4T/H55USq77OAI/t9DNAko7rxaIrONC79pnUZliYMDgvOcFhBH9p3Jn+WqZ3JpR8/qIKEdZKuI3LuP1P0Y8uwf8QkPWX7zf1eGwZJbyEG7/e7z5KpxXPi84kfxbcDW22vrr6X9TbKG4+m0ACKiw3C2A8OsPAMhxV8/8h3Jhf9eBnYRUQ8wdRgM7SylrPdBdX1DqlfxWL3ykl6zl6HG480XI0YHFpGHB3T2pl8MZGU7XjgLf0MUAsNyVUNylp23BVNuwQcYHso+wMkfZfuXb27iUdDV9veU6KNtcD/2v50x/lfBxbZ/mSFXa61Otx4pOEa+8GhLtExHX06hZh6XwSU2pk8yJDc4tn5JbZvm28bTaBIZngZcLrti0q8/ykihvyljvP7A49M0g9iHW480nA1YXCoRXRMj77tB3y0TB+qCMlVZHZcQ2z02gTcB3yESD39hO3OnPwTqezjrfaokn6uTRJJZwCrba8ZdV9StfYbdQcq8AFgVWtgALC9i0jV8IGR9Sr68TJwZcm390xY18dXrgd+gthY88vEAvmFwHtzYAhF2ovSmQEkde2CnuncJJF0oqQbFJmE/4CK6gekemlC+oxXdoZNQqw71CT/TdlUpFUkrDumLX76ZuIZ+1EucsZPkrYUJu0OJdaE/r5kM+uAzUVuqlbiw5OBG4i8+xND0nFEOPAqYA+xz0GuppZJqqEmDA6zJbYrm/RukMo+t6siYd2+tL2O9L/PTuLAUFjRcWziR+1PbJcq+mP71mIj3PVAKwT3KeBaT16xnx3Ejt4VtnfCvke6qaGasOYw8uiYGSJj2vuwxHapQXihIbnjEj+dxo+kC4iZw+nAFiKc9eZJTCUyKcZ+cGiiUYbkNkUVieIkfYrZNyZOXLI5SQcRO/9bu8ZvIXac3zvSjqXKNeGxUiPMFJJbzARKh+RKWm7788Xro9sX6SWttH3nALpeV4+2vb6O+Hfbr+1zv2Wy2H6ByEhwm6SlRLj2bxHBD6lBcuZQE1WE5LaHaI5L/pZh0ABqHEt6fcb2pyZrQihrU1QRkqser2c6niTzvgOS9DZJF0p6bXF8gqTPAAPP2ZXSKOXgUB89Q3KBsovqWQS+QpLWAX9JpF/fLOlaYmPhw0SG15QaK9cc6qOKkNxjJG0iZgmt1xTHExVV0hFBdqCk77QuUT5y6zzgpKKOw6FEkZsTbH+t+h6nVC+55lATVYTkSnrXbNdtD7yGdJNIetT2yW3HT9g+cZR9SmlYcnBIE6MtDHO17fNKvP9/gH9uO/XO9mPbP1d5J1OqiRwcGkTSe4HX2f7z4vhhYFlx+SrbZdNGNIakxUQU2GrgXOAO4E7b/1DiszkTSxMr1xya5SpiF2vL/kQKjoOISnkTMzhIOpvYqHUOUcNhPXCq7cv7aOZx29+Z6YKkoxbey5TqK6OVmmWx7W+2HT9oe4/tbxADxCT5HHAskQb90mKmMGct7w4PtF5I2tpx7a6FdS+lesuZQ7Mc2n5g+yNth8uYLCcTs6h/krSLyAW0qM822veGLJ3lWkqNkzOHZnm4qCg3jaRfBbaNoD8jY/tx21fbPhb4PeAkYLGkeyRdUbaZHq9nOk6pUXJBukGKXbx3Af/H9PoD+wPvs/3fo+pbHRSV+c4mSqbOufYg6VvAjcQs4criNcXxb9g+clB9TWnUcnBoIEnLibTfAE+3kvFNEkmdeaQM7O5Yk5mrjVmT9dm+bj59S2kc5OCQGknS/TOcXgosJmYOX57hekqpkINDmiiSTgFutP3OEu9dcE2IlMZVRiuliWJ7u6SDS779w0RZ0NuJvEoZoZQmRg4OaaJIOozykUY/RhSzuRj4IbABuMP28wPqXkq1kY+VUiP1KPG5lKiB/NEy6TM62juC2HG9Frja9vpKOppSTeXMITVVZ4lPA3uAtbaf66ehIvJpFREGew/TS5Cm1Eg5c0ipB0nXAecDzxA7rLfY/uFoe5XScOTgkBpJ0pPMvLbQKvZzQok2XgZ2AS8Wp1rtlW4jpXGVj5VSU51f/K+AzUTa7n5NVPW8lNrlzCE1nqTHbHfumF5Ie2cQBYPWVNVmSnWTM4eUSpB0IlEw6P3As8Cdo+1RSoOVg0NqpI7cSksknUTbJjbbj3V/qquN44i036uISKcNxGz73RV3N6XaycdKqZF65FZqse3lJdp4GfgC8CHbO4tzu2wfU1E3U6qtnDmkRqro7v7niZnD/ZK2EOGsmUIjTYScOaRGkrRytuu2S68ZSDoIeB/xeGk5cAuw0fa9C+pkSjWWg0NqJEl/Nctl2/7gPNtdSpFvqcyjqZTGVQ4OKaWUuuSaQ2okSWtnu277xtmupzTp9ht1B1IakEPa/vnNjuNDRtivlMZCPlZKjSfpcdsnjbofKY2TnDmkSZB3QCn1KQeHlFJKXfKxUmqkjpTdbwR2ti6R6bZTmlMODqmRJL1+tuu2/31YfUlpHGUoa2qqVwKH2f5i+0lJ7wD+czRdSml85JpDaqpPAt+d4fyLxbWU0ixycEhN9Qbb/9J50vZ24A3D705K4yUHh9RUB8xybcnQepHSmMrBITXVI5J+pfOkpA8Bj46gPymNlYxWSo0k6TBgI/ASU4PBKcBi4ALb/zWqvqU0DnJwSI0m6d3Am4vDp21/fpT9SWlc5OCQUkqpS645pJRS6pKDQ0oppS45OKTUg6S9kp6Q9GVJj0k6fUDfc6akuwfRdkrzlekzUurtRdsnAkg6B/gj4F3tb5C0yPbeUXQupUHKmUNK5bwKeB723enfL+kzwJPFuUslbStmGn8haVFx/j2SHipmHn8n6eDi/LmSdkh6EFg5oj9TSj3l4JBSb0uKH/sdwM3A77ddOxX4HdtvkvSTwMXAGcVMYy/wC5JeA1wDnGX7Z4DtwFpJBwA3ASuAdwCHD++PlFI5+Vgppd7aHyu9DbhVUmvPxDbbzxavfxY4mdiVDZGe4zngrcCbgC8W5xcDDwHHA8/a/lrR9t8AVwzlT5RSSTk4pFSC7YeKmcCy4tQLbZcF3GL7t9s/I2kFcJ/tVR3nTyRLl6aay8dKKZUg6XhgEbBnhstbgQslvbZ479Ki2NCXgDMkvbE4f6Ck44AdwNGSji0+v2qGNlMaqZw5pNTbEklPFK8F/JLtvcUjon1sf0XSNcC9kvYDfgCssf0lSZcBfytp/+Lt19j+qqQrgM2SdgMPMpXiI6VayPQZKaWUuuRjpZRSSl1ycEgppdQlB4eUUkpdcnBIKaXUJQeHlFJKXXJwSCml1CUHh5RSSl1ycEgppdTl/wG7KC9bScvxLwAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Counts and makes a very basic bar graph to showing what breeds where most taken in by \n",
    "#Louisville metro animal services from 2005-2017\n",
    "\n",
    "res = Q(\"\"\"\n",
    "SELECT\n",
    "   (PrimaryBreed) as Breed, \n",
    "   count(*) as Count\n",
    "   from animals\n",
    "   group by PrimaryBreed\n",
    "   ORDER BY Count desc limit 20\n",
    "\n",
    "\"\"\")\n",
    "res.plot.bar(x = \"Breed\")"
   ]
  }
 ],
 "metadata": {
  "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}