data_imported.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "collision_data  = pd.read_csv('datasets/pd_collisions_datasd.csv')\n",
    "collision_dict = pd.read_csv('datasets/pd_collisions_dictionary_datasd.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>Field</th>\n",
       "      <th>Description</th>\n",
       "      <th>Values</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>activityNumber</td>\n",
       "      <td>Collision report number</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>activityDate</td>\n",
       "      <td>Date/time of collision</td>\n",
       "      <td>Date / time in 24 hour format</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>beat</td>\n",
       "      <td>San Diego Police beat</td>\n",
       "      <td>see code list</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>StreetNo</td>\n",
       "      <td>Street number of collision location, abstracte...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>StreetDir</td>\n",
       "      <td>Direction of street in location</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>StreetName</td>\n",
       "      <td>Name of street</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>StreetType</td>\n",
       "      <td>Street type</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CrossStDir</td>\n",
       "      <td>Direction of cross street, if collision at int...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>CrossStName</td>\n",
       "      <td>Street name, if collision at intersection</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>CrossStType</td>\n",
       "      <td>Street type, if collision at intersection</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>violationSection</td>\n",
       "      <td>Violation section for primary collision factor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>violationType</td>\n",
       "      <td>Violation type for primary collision factor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>chargeDescription</td>\n",
       "      <td>Violation section description for primary coll...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>numberInjured</td>\n",
       "      <td>Number of people injured in collision</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>numberKilled</td>\n",
       "      <td>Number of people killed in collision</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>hitRunLevel</td>\n",
       "      <td>Level of violation, if collision was a hit &amp; run</td>\n",
       "      <td>Felony or Misdemeanor (Null if not a hit &amp; run)</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Field                                        Description  \\\n",
       "0      activityNumber                            Collision report number   \n",
       "1        activityDate                             Date/time of collision   \n",
       "2                beat                              San Diego Police beat   \n",
       "3            StreetNo  Street number of collision location, abstracte...   \n",
       "4           StreetDir                    Direction of street in location   \n",
       "5          StreetName                                     Name of street   \n",
       "6          StreetType                                        Street type   \n",
       "7          CrossStDir  Direction of cross street, if collision at int...   \n",
       "8         CrossStName          Street name, if collision at intersection   \n",
       "9         CrossStType          Street type, if collision at intersection   \n",
       "10   violationSection     Violation section for primary collision factor   \n",
       "11      violationType        Violation type for primary collision factor   \n",
       "12  chargeDescription  Violation section description for primary coll...   \n",
       "13      numberInjured              Number of people injured in collision   \n",
       "14       numberKilled               Number of people killed in collision   \n",
       "15        hitRunLevel   Level of violation, if collision was a hit & run   \n",
       "16                NaN                                                NaN   \n",
       "17                NaN                                                NaN   \n",
       "\n",
       "                                             Values  Unnamed: 3  \n",
       "0                                               NaN         NaN  \n",
       "1                     Date / time in 24 hour format         NaN  \n",
       "2                                     see code list         NaN  \n",
       "3                                               NaN         NaN  \n",
       "4                                               NaN         NaN  \n",
       "5                                               NaN         NaN  \n",
       "6                                               NaN         NaN  \n",
       "7                                               NaN         NaN  \n",
       "8                                               NaN         NaN  \n",
       "9                                               NaN         NaN  \n",
       "10                                              NaN         NaN  \n",
       "11                                              NaN         NaN  \n",
       "12                                              NaN         NaN  \n",
       "13                                              NaN         NaN  \n",
       "14                                              NaN         NaN  \n",
       "15  Felony or Misdemeanor (Null if not a hit & run)         NaN  \n",
       "16                                              NaN         NaN  \n",
       "17                                              NaN         NaN  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "collision_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>report_id</th>\n",
       "      <th>date_time</th>\n",
       "      <th>police_beat</th>\n",
       "      <th>street_no</th>\n",
       "      <th>street_dir</th>\n",
       "      <th>street_name</th>\n",
       "      <th>street_type</th>\n",
       "      <th>cross_st_dir</th>\n",
       "      <th>cross_st_name</th>\n",
       "      <th>cross_st_type</th>\n",
       "      <th>violation_section</th>\n",
       "      <th>violation_type</th>\n",
       "      <th>charge_desc</th>\n",
       "      <th>injured</th>\n",
       "      <th>killed</th>\n",
       "      <th>hit_run_lvl</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>170166</td>\n",
       "      <td>2017-01-01 00:01:00</td>\n",
       "      <td>124</td>\n",
       "      <td>8300</td>\n",
       "      <td></td>\n",
       "      <td>CAM DEL ORO</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>MISC-HAZ</td>\n",
       "      <td>VC</td>\n",
       "      <td>MISCELLANEOUS HAZARDOUS VIOLATIONS OF THE VEHI...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>170218</td>\n",
       "      <td>2017-01-01 00:01:00</td>\n",
       "      <td>325</td>\n",
       "      <td>8100</td>\n",
       "      <td></td>\n",
       "      <td>ROYAL GORGE</td>\n",
       "      <td>DRIVE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNING MOVEMENTS AND REQUIRED SIGNALS</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>170101</td>\n",
       "      <td>2017-01-01 00:01:00</td>\n",
       "      <td>322</td>\n",
       "      <td>6400</td>\n",
       "      <td></td>\n",
       "      <td>CRAWFORD</td>\n",
       "      <td>STREET</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>MISC-HAZ</td>\n",
       "      <td>VC</td>\n",
       "      <td>MISCELLANEOUS HAZARDOUS VIOLATIONS OF THE VEHI...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>170082</td>\n",
       "      <td>2017-01-01 00:01:00</td>\n",
       "      <td>935</td>\n",
       "      <td>5500</td>\n",
       "      <td></td>\n",
       "      <td>VALERIO</td>\n",
       "      <td>TRAIL</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>MISC-HAZ</td>\n",
       "      <td>VC</td>\n",
       "      <td>MISCELLANEOUS HAZARDOUS VIOLATIONS OF THE VEHI...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>170097</td>\n",
       "      <td>2017-01-01 01:00:00</td>\n",
       "      <td>521</td>\n",
       "      <td>1000</td>\n",
       "      <td></td>\n",
       "      <td>11TH</td>\n",
       "      <td>AVENUE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNING MOVEMENTS AND REQUIRED SIGNALS</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>170220</td>\n",
       "      <td>2017-01-01 01:00:00</td>\n",
       "      <td>524</td>\n",
       "      <td>1000</td>\n",
       "      <td></td>\n",
       "      <td>A</td>\n",
       "      <td>STREET</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>MISC-HAZ</td>\n",
       "      <td>VC</td>\n",
       "      <td>MISCELLANEOUS HAZARDOUS VIOLATIONS OF THE VEHI...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>170153</td>\n",
       "      <td>2017-01-01 01:18:00</td>\n",
       "      <td>437</td>\n",
       "      <td>2600</td>\n",
       "      <td></td>\n",
       "      <td>RAMFOS</td>\n",
       "      <td>PLACE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNING MOVEMENTS AND REQUIRED SIGNALS</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>170035</td>\n",
       "      <td>2017-01-01 01:53:00</td>\n",
       "      <td>935</td>\n",
       "      <td>3900</td>\n",
       "      <td></td>\n",
       "      <td>DE LA VALLE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNING MOVEMENTS AND REQUIRED SIGNALS</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>170044</td>\n",
       "      <td>2017-01-01 01:58:00</td>\n",
       "      <td>115</td>\n",
       "      <td>9100</td>\n",
       "      <td></td>\n",
       "      <td>SYDNEY</td>\n",
       "      <td>COURT</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNING MOVEMENTS AND REQUIRED SIGNALS</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>170042</td>\n",
       "      <td>2017-01-01 02:00:00</td>\n",
       "      <td>122</td>\n",
       "      <td>1600</td>\n",
       "      <td></td>\n",
       "      <td>HORNBLEND</td>\n",
       "      <td>STREET</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNING MOVEMENTS AND REQUIRED SIGNALS</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>170041</td>\n",
       "      <td>2017-01-01 02:00:00</td>\n",
       "      <td>122</td>\n",
       "      <td>900</td>\n",
       "      <td></td>\n",
       "      <td>EMERALD</td>\n",
       "      <td>STREET</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22350</td>\n",
       "      <td>VC</td>\n",
       "      <td>VIOLATION OF BASIC SPEED LAW SPEED UNSAFE FOR ...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>170139</td>\n",
       "      <td>2017-01-01 02:03:00</td>\n",
       "      <td>434</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>IMPERIAL</td>\n",
       "      <td>AVENUE</td>\n",
       "      <td></td>\n",
       "      <td>VIEWCREST DR</td>\n",
       "      <td>DRIVE</td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNING MOVEMENTS AND REQUIRED SIGNALS</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>170090</td>\n",
       "      <td>2017-01-01 04:10:00</td>\n",
       "      <td>813</td>\n",
       "      <td>2900</td>\n",
       "      <td></td>\n",
       "      <td>LAUREL</td>\n",
       "      <td>STREET</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNING MOVEMENTS AND REQUIRED SIGNALS</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>170073</td>\n",
       "      <td>2017-01-01 04:43:00</td>\n",
       "      <td>242</td>\n",
       "      <td>10000</td>\n",
       "      <td></td>\n",
       "      <td>BLACK MTN</td>\n",
       "      <td>ROAD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNING MOVEMENTS AND REQUIRED SIGNALS</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>170217</td>\n",
       "      <td>2017-01-01 05:26:00</td>\n",
       "      <td>823</td>\n",
       "      <td>5800</td>\n",
       "      <td></td>\n",
       "      <td>UNIVERSITY</td>\n",
       "      <td>AVENUE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNING MOVEMENTS AND REQUIRED SIGNALS</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>170074</td>\n",
       "      <td>2017-01-01 06:56:00</td>\n",
       "      <td>243</td>\n",
       "      <td>6900</td>\n",
       "      <td></td>\n",
       "      <td>MIRAMAR</td>\n",
       "      <td>ROAD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22350</td>\n",
       "      <td>VC</td>\n",
       "      <td>VIOLATION OF BASIC SPEED LAW SPEED UNSAFE FOR ...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>170118</td>\n",
       "      <td>2017-01-01 11:25:00</td>\n",
       "      <td>123</td>\n",
       "      <td>2500</td>\n",
       "      <td></td>\n",
       "      <td>INGRAHAM</td>\n",
       "      <td>STREET</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22350</td>\n",
       "      <td>VC</td>\n",
       "      <td>VIOLATION OF BASIC SPEED LAW SPEED UNSAFE FOR ...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>170067</td>\n",
       "      <td>2017-01-01 11:37:00</td>\n",
       "      <td>123</td>\n",
       "      <td>2400</td>\n",
       "      <td>W</td>\n",
       "      <td>MISSION BAY</td>\n",
       "      <td>DRIVE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22350</td>\n",
       "      <td>VC</td>\n",
       "      <td>VIOLATION OF BASIC SPEED LAW SPEED UNSAFE FOR ...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>170316</td>\n",
       "      <td>2017-01-01 12:30:00</td>\n",
       "      <td>813</td>\n",
       "      <td>2800</td>\n",
       "      <td></td>\n",
       "      <td>EL CAJON</td>\n",
       "      <td>BOULEVARD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>MISC-HAZ</td>\n",
       "      <td>VC</td>\n",
       "      <td>MISCELLANEOUS HAZARDOUS VIOLATIONS OF THE VEHI...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>170045</td>\n",
       "      <td>2017-01-01 13:00:00</td>\n",
       "      <td>111</td>\n",
       "      <td>3200</td>\n",
       "      <td></td>\n",
       "      <td>ASHFORD</td>\n",
       "      <td>STREET</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>MISC-HAZ</td>\n",
       "      <td>VC</td>\n",
       "      <td>MISCELLANEOUS HAZARDOUS VIOLATIONS OF THE VEHI...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>170068</td>\n",
       "      <td>2017-01-01 13:03:00</td>\n",
       "      <td>122</td>\n",
       "      <td>1100</td>\n",
       "      <td></td>\n",
       "      <td>GARNET</td>\n",
       "      <td>AVENUE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22517</td>\n",
       "      <td>VC</td>\n",
       "      <td>OPENING AND CLOSING DOORS</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>170251</td>\n",
       "      <td>2017-01-01 13:16:00</td>\n",
       "      <td>832</td>\n",
       "      <td>4300</td>\n",
       "      <td></td>\n",
       "      <td>EL CAJON</td>\n",
       "      <td>BOULEVARD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22450(A)</td>\n",
       "      <td>VC</td>\n",
       "      <td>STOP REQUIREMENTS STATE STOP LINE</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>170096</td>\n",
       "      <td>2017-01-01 15:30:00</td>\n",
       "      <td>512</td>\n",
       "      <td>2800</td>\n",
       "      <td></td>\n",
       "      <td>IMPERIAL</td>\n",
       "      <td>AVENUE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22350</td>\n",
       "      <td>VC</td>\n",
       "      <td>VIOLATION OF BASIC SPEED LAW SPEED UNSAFE FOR ...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>FELONY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>170078</td>\n",
       "      <td>2017-01-01 15:30:00</td>\n",
       "      <td>315</td>\n",
       "      <td>5100</td>\n",
       "      <td></td>\n",
       "      <td>MISSION CENTER</td>\n",
       "      <td>ROAD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>21461A</td>\n",
       "      <td>VC</td>\n",
       "      <td>FAIL TO OBEY TRAFFIC CONTROL DEVICE</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>170051</td>\n",
       "      <td>2017-01-01 16:40:00</td>\n",
       "      <td>321</td>\n",
       "      <td>10400</td>\n",
       "      <td></td>\n",
       "      <td>SAN DIEGO MISSION</td>\n",
       "      <td>ROAD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>21703</td>\n",
       "      <td>VC</td>\n",
       "      <td>FOLLOWING TOO CLOSELY</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>170257</td>\n",
       "      <td>2017-01-01 18:07:00</td>\n",
       "      <td>611</td>\n",
       "      <td>3700</td>\n",
       "      <td></td>\n",
       "      <td>SPORTS ARENA</td>\n",
       "      <td>BOULEVARD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNING MOVEMENTS AND REQUIRED SIGNALS</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>170278</td>\n",
       "      <td>2017-01-01 19:30:00</td>\n",
       "      <td>627</td>\n",
       "      <td>100</td>\n",
       "      <td></td>\n",
       "      <td>WASHINGTON</td>\n",
       "      <td>STREET</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNING MOVEMENTS AND REQUIRED SIGNALS</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>170146</td>\n",
       "      <td>2017-01-01 19:45:00</td>\n",
       "      <td>822</td>\n",
       "      <td>5800</td>\n",
       "      <td></td>\n",
       "      <td>EL CAJON</td>\n",
       "      <td>BOULEVARD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>21801A</td>\n",
       "      <td>VC</td>\n",
       "      <td>LEFT TURN YIELD UNTIL SAFE OR U-TURN</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>170127</td>\n",
       "      <td>2017-01-01 20:36:00</td>\n",
       "      <td>524</td>\n",
       "      <td>700</td>\n",
       "      <td></td>\n",
       "      <td>08TH</td>\n",
       "      <td>AVENUE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>21950B</td>\n",
       "      <td>VC</td>\n",
       "      <td>PEDESTRIAN NOT TO SUDDENLY ENTER PATH ETC</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>170122</td>\n",
       "      <td>2017-01-01 22:15:00</td>\n",
       "      <td>841</td>\n",
       "      <td>3400</td>\n",
       "      <td></td>\n",
       "      <td>COLLEGE</td>\n",
       "      <td>AVENUE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>21804</td>\n",
       "      <td>VC</td>\n",
       "      <td>ENTERING HWY FROM PRIVATE ROAD OR DRIVEWAY</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22678</th>\n",
       "      <td>19200840</td>\n",
       "      <td>2019-04-10 18:56:14</td>\n",
       "      <td>524</td>\n",
       "      <td>1100</td>\n",
       "      <td></td>\n",
       "      <td>PACIFIC</td>\n",
       "      <td>HIGHWAY</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22517</td>\n",
       "      <td>VC</td>\n",
       "      <td>UNSAFE OPENING OF VEH DOOR (I)</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22679</th>\n",
       "      <td>19011931</td>\n",
       "      <td>2019-04-10 21:26:09</td>\n",
       "      <td>524</td>\n",
       "      <td>1200</td>\n",
       "      <td></td>\n",
       "      <td>01ST</td>\n",
       "      <td>AVENUE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22350</td>\n",
       "      <td>VC</td>\n",
       "      <td>UNSAFE SPEED (BASIC SPEED LAW) (I)</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22680</th>\n",
       "      <td>19200841</td>\n",
       "      <td>2019-04-10 22:30:23</td>\n",
       "      <td>934</td>\n",
       "      <td>3400</td>\n",
       "      <td></td>\n",
       "      <td>DEL MAR HEIGHTS</td>\n",
       "      <td>ROAD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNS:UNSAFE TURN AND/OR NO TURN SIGNAL (I)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22681</th>\n",
       "      <td>19200843</td>\n",
       "      <td>2019-04-11 09:31:51</td>\n",
       "      <td>529</td>\n",
       "      <td>500</td>\n",
       "      <td></td>\n",
       "      <td>JUNIPER</td>\n",
       "      <td>STREET</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>21235(G)</td>\n",
       "      <td>VC</td>\n",
       "      <td>OPERATE MOTOR SCOOTER UPON SIDEWALK (I)</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22682</th>\n",
       "      <td>19200845</td>\n",
       "      <td>2019-04-11 11:56:00</td>\n",
       "      <td>313</td>\n",
       "      <td>3700</td>\n",
       "      <td></td>\n",
       "      <td>RUFFIN</td>\n",
       "      <td>ROAD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>21801A</td>\n",
       "      <td>VC</td>\n",
       "      <td>RIGHT-OF-WAY:MAKING LEFT OR U-TURN (I)</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22683</th>\n",
       "      <td>19200849</td>\n",
       "      <td>2019-04-11 16:11:00</td>\n",
       "      <td>311</td>\n",
       "      <td>3500</td>\n",
       "      <td></td>\n",
       "      <td>RUFFIN</td>\n",
       "      <td>ROAD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNS:UNSAFE TURN AND/OR NO TURN SIGNAL (I)</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22684</th>\n",
       "      <td>19200854</td>\n",
       "      <td>2019-04-11 16:18:10</td>\n",
       "      <td>512</td>\n",
       "      <td>2100</td>\n",
       "      <td></td>\n",
       "      <td>OCEAN VIEW</td>\n",
       "      <td>BOULEVARD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>12500(A)</td>\n",
       "      <td>VC</td>\n",
       "      <td>DRVG WITHOUT VALID DRVR'S LIC (M)</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22685</th>\n",
       "      <td>19200852</td>\n",
       "      <td>2019-04-11 17:00:00</td>\n",
       "      <td>313</td>\n",
       "      <td>4400</td>\n",
       "      <td></td>\n",
       "      <td>CONVOY</td>\n",
       "      <td>STREET</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNS:UNSAFE TURN AND/OR NO TURN SIGNAL (I)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22686</th>\n",
       "      <td>19200850</td>\n",
       "      <td>2019-04-11 18:36:49</td>\n",
       "      <td>518</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>31ST</td>\n",
       "      <td>STREET</td>\n",
       "      <td></td>\n",
       "      <td>JUNIPER</td>\n",
       "      <td>STREET</td>\n",
       "      <td>21801A</td>\n",
       "      <td>VC</td>\n",
       "      <td>RIGHT-OF-WAY:MAKING LEFT OR U-TURN (I)</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22687</th>\n",
       "      <td>19200851</td>\n",
       "      <td>2019-04-11 19:12:30</td>\n",
       "      <td>242</td>\n",
       "      <td>10700</td>\n",
       "      <td></td>\n",
       "      <td>CAM RUIZ</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22350</td>\n",
       "      <td>VC</td>\n",
       "      <td>UNSAFE SPEED (BASIC SPEED LAW) (I)</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22688</th>\n",
       "      <td>19200855</td>\n",
       "      <td>2019-04-11 21:08:00</td>\n",
       "      <td>838</td>\n",
       "      <td>3600</td>\n",
       "      <td></td>\n",
       "      <td>UNIVERSITY</td>\n",
       "      <td>AVENUE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>21804</td>\n",
       "      <td>VC</td>\n",
       "      <td>RIGHT-OF-WAY:ENTERING HWY (I)</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22689</th>\n",
       "      <td>19200860</td>\n",
       "      <td>2019-04-12 07:59:00</td>\n",
       "      <td>315</td>\n",
       "      <td>5300</td>\n",
       "      <td></td>\n",
       "      <td>SCHEIDLER</td>\n",
       "      <td>WAY</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22350</td>\n",
       "      <td>VC</td>\n",
       "      <td>UNSAFE SPEED (BASIC SPEED LAW) (I)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22690</th>\n",
       "      <td>19200861</td>\n",
       "      <td>2019-04-12 10:27:00</td>\n",
       "      <td>115</td>\n",
       "      <td>9800</td>\n",
       "      <td></td>\n",
       "      <td>GENESEE</td>\n",
       "      <td>AVENUE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>21453A</td>\n",
       "      <td>VC</td>\n",
       "      <td>SIGNAL LIGHTS:CIRCULAR RED (I)</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22691</th>\n",
       "      <td>19200867</td>\n",
       "      <td>2019-04-12 10:57:00</td>\n",
       "      <td>541</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>FT W OF ECL 200 TONY GWYNN</td>\n",
       "      <td>DRIVE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNS:UNSAFE TURN AND/OR NO TURN SIGNAL (I)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22692</th>\n",
       "      <td>19200865</td>\n",
       "      <td>2019-04-12 14:00:00</td>\n",
       "      <td>313</td>\n",
       "      <td>3800</td>\n",
       "      <td></td>\n",
       "      <td>KEARNY MESA</td>\n",
       "      <td>ROAD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNS:UNSAFE TURN AND/OR NO TURN SIGNAL (I)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22693</th>\n",
       "      <td>19200866</td>\n",
       "      <td>2019-04-12 14:09:50</td>\n",
       "      <td>243</td>\n",
       "      <td>7400</td>\n",
       "      <td></td>\n",
       "      <td>MIRAMAR</td>\n",
       "      <td>ROAD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>21804</td>\n",
       "      <td>VC</td>\n",
       "      <td>RIGHT-OF-WAY:ENTERING HWY (I)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22694</th>\n",
       "      <td>19200882</td>\n",
       "      <td>2019-04-12 18:10:17</td>\n",
       "      <td>524</td>\n",
       "      <td>600</td>\n",
       "      <td></td>\n",
       "      <td>07TH</td>\n",
       "      <td>AVENUE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>MISC-HAZ</td>\n",
       "      <td>VC</td>\n",
       "      <td>MISCELLANEOUS HAZARDOUS VIOLATIONS OF THE VEHI...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22695</th>\n",
       "      <td>19200869</td>\n",
       "      <td>2019-04-12 18:25:00</td>\n",
       "      <td>524</td>\n",
       "      <td>1100</td>\n",
       "      <td></td>\n",
       "      <td>08TH</td>\n",
       "      <td>AVENUE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>21950A</td>\n",
       "      <td>VC</td>\n",
       "      <td>RIGHT-OF-WAY:DRVR YIELD TO PEDESTRIAN IN CROSS...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22696</th>\n",
       "      <td>19200871</td>\n",
       "      <td>2019-04-13 01:20:00</td>\n",
       "      <td>523</td>\n",
       "      <td>400</td>\n",
       "      <td></td>\n",
       "      <td>F</td>\n",
       "      <td>STREET</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>MISC-HAZ</td>\n",
       "      <td>VC</td>\n",
       "      <td>MISCELLANEOUS HAZARDOUS VIOLATIONS OF THE VEHI...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22697</th>\n",
       "      <td>19200876</td>\n",
       "      <td>2019-04-13 13:30:41</td>\n",
       "      <td>512</td>\n",
       "      <td>2800</td>\n",
       "      <td></td>\n",
       "      <td>NATIONAL</td>\n",
       "      <td>AVENUE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNS:UNSAFE TURN AND/OR NO TURN SIGNAL (I)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22698</th>\n",
       "      <td>19012270</td>\n",
       "      <td>2019-04-13 15:28:23</td>\n",
       "      <td>242</td>\n",
       "      <td>10800</td>\n",
       "      <td></td>\n",
       "      <td>VIA SAN BLAS</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>23152A</td>\n",
       "      <td>VC</td>\n",
       "      <td>DUI ALCOHOL (M)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22699</th>\n",
       "      <td>19200877</td>\n",
       "      <td>2019-04-13 15:35:00</td>\n",
       "      <td>315</td>\n",
       "      <td>2400</td>\n",
       "      <td></td>\n",
       "      <td>CAM DEL RIO SOUTH</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22350</td>\n",
       "      <td>VC</td>\n",
       "      <td>UNSAFE SPEED (BASIC SPEED LAW) (I)</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22700</th>\n",
       "      <td>19012292</td>\n",
       "      <td>2019-04-13 19:02:00</td>\n",
       "      <td>512</td>\n",
       "      <td>2100</td>\n",
       "      <td></td>\n",
       "      <td>KEARNY</td>\n",
       "      <td>AVENUE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22350</td>\n",
       "      <td>VC</td>\n",
       "      <td>UNSAFE SPEED (BASIC SPEED LAW) (I)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22701</th>\n",
       "      <td>19200878</td>\n",
       "      <td>2019-04-14 01:20:00</td>\n",
       "      <td>111</td>\n",
       "      <td>4100</td>\n",
       "      <td></td>\n",
       "      <td>ASHFORD</td>\n",
       "      <td>STREET</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>21460A</td>\n",
       "      <td>VC</td>\n",
       "      <td>LANE USAGE:VEH CROSS DOUBLE SOLID LINE (I)</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22702</th>\n",
       "      <td>19200879</td>\n",
       "      <td>2019-04-14 02:15:00</td>\n",
       "      <td>516</td>\n",
       "      <td>3200</td>\n",
       "      <td></td>\n",
       "      <td>J</td>\n",
       "      <td>STREET</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNS:UNSAFE TURN AND/OR NO TURN SIGNAL (I)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22703</th>\n",
       "      <td>19200884</td>\n",
       "      <td>2019-04-14 10:51:00</td>\n",
       "      <td>235</td>\n",
       "      <td>15500</td>\n",
       "      <td></td>\n",
       "      <td>SAN PASQUAL VALLEY</td>\n",
       "      <td>ROAD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22350</td>\n",
       "      <td>VC</td>\n",
       "      <td>UNSAFE SPEED (BASIC SPEED LAW) (I)</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22704</th>\n",
       "      <td>19200885</td>\n",
       "      <td>2019-04-14 10:53:18</td>\n",
       "      <td>315</td>\n",
       "      <td>9100</td>\n",
       "      <td></td>\n",
       "      <td>FRIARS</td>\n",
       "      <td>ROAD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22350</td>\n",
       "      <td>VC</td>\n",
       "      <td>UNSAFE SPEED (BASIC SPEED LAW) (I)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>MISDEMEANOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22705</th>\n",
       "      <td>19200891</td>\n",
       "      <td>2019-04-14 16:08:00</td>\n",
       "      <td>243</td>\n",
       "      <td>7000</td>\n",
       "      <td></td>\n",
       "      <td>MIRAMAR</td>\n",
       "      <td>ROAD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>21453A</td>\n",
       "      <td>VC</td>\n",
       "      <td>SIGNAL LIGHTS:CIRCULAR RED (I)</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22706</th>\n",
       "      <td>19200894</td>\n",
       "      <td>2019-04-14 18:03:00</td>\n",
       "      <td>116</td>\n",
       "      <td>1500</td>\n",
       "      <td></td>\n",
       "      <td>MORENA</td>\n",
       "      <td>BOULEVARD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>23152(F)</td>\n",
       "      <td>VC</td>\n",
       "      <td>DUI ALCOHOL/DRUG (M)</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22707</th>\n",
       "      <td>19200893</td>\n",
       "      <td>2019-04-14 19:41:00</td>\n",
       "      <td>521</td>\n",
       "      <td>800</td>\n",
       "      <td></td>\n",
       "      <td>10TH</td>\n",
       "      <td>AVENUE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22107</td>\n",
       "      <td>VC</td>\n",
       "      <td>TURNS:UNSAFE TURN AND/OR NO TURN SIGNAL (I)</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>22708 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      report_id            date_time  police_beat  street_no street_dir  \\\n",
       "0        170166  2017-01-01 00:01:00          124       8300              \n",
       "1        170218  2017-01-01 00:01:00          325       8100              \n",
       "2        170101  2017-01-01 00:01:00          322       6400              \n",
       "3        170082  2017-01-01 00:01:00          935       5500              \n",
       "4        170097  2017-01-01 01:00:00          521       1000              \n",
       "5        170220  2017-01-01 01:00:00          524       1000              \n",
       "6        170153  2017-01-01 01:18:00          437       2600              \n",
       "7        170035  2017-01-01 01:53:00          935       3900              \n",
       "8        170044  2017-01-01 01:58:00          115       9100              \n",
       "9        170042  2017-01-01 02:00:00          122       1600              \n",
       "10       170041  2017-01-01 02:00:00          122        900              \n",
       "11       170139  2017-01-01 02:03:00          434          0              \n",
       "12       170090  2017-01-01 04:10:00          813       2900              \n",
       "13       170073  2017-01-01 04:43:00          242      10000              \n",
       "14       170217  2017-01-01 05:26:00          823       5800              \n",
       "15       170074  2017-01-01 06:56:00          243       6900              \n",
       "16       170118  2017-01-01 11:25:00          123       2500              \n",
       "17       170067  2017-01-01 11:37:00          123       2400          W   \n",
       "18       170316  2017-01-01 12:30:00          813       2800              \n",
       "19       170045  2017-01-01 13:00:00          111       3200              \n",
       "20       170068  2017-01-01 13:03:00          122       1100              \n",
       "21       170251  2017-01-01 13:16:00          832       4300              \n",
       "22       170096  2017-01-01 15:30:00          512       2800              \n",
       "23       170078  2017-01-01 15:30:00          315       5100              \n",
       "24       170051  2017-01-01 16:40:00          321      10400              \n",
       "25       170257  2017-01-01 18:07:00          611       3700              \n",
       "26       170278  2017-01-01 19:30:00          627        100              \n",
       "27       170146  2017-01-01 19:45:00          822       5800              \n",
       "28       170127  2017-01-01 20:36:00          524        700              \n",
       "29       170122  2017-01-01 22:15:00          841       3400              \n",
       "...         ...                  ...          ...        ...        ...   \n",
       "22678  19200840  2019-04-10 18:56:14          524       1100              \n",
       "22679  19011931  2019-04-10 21:26:09          524       1200              \n",
       "22680  19200841  2019-04-10 22:30:23          934       3400              \n",
       "22681  19200843  2019-04-11 09:31:51          529        500              \n",
       "22682  19200845  2019-04-11 11:56:00          313       3700              \n",
       "22683  19200849  2019-04-11 16:11:00          311       3500              \n",
       "22684  19200854  2019-04-11 16:18:10          512       2100              \n",
       "22685  19200852  2019-04-11 17:00:00          313       4400              \n",
       "22686  19200850  2019-04-11 18:36:49          518          0              \n",
       "22687  19200851  2019-04-11 19:12:30          242      10700              \n",
       "22688  19200855  2019-04-11 21:08:00          838       3600              \n",
       "22689  19200860  2019-04-12 07:59:00          315       5300              \n",
       "22690  19200861  2019-04-12 10:27:00          115       9800              \n",
       "22691  19200867  2019-04-12 10:57:00          541          0              \n",
       "22692  19200865  2019-04-12 14:00:00          313       3800              \n",
       "22693  19200866  2019-04-12 14:09:50          243       7400              \n",
       "22694  19200882  2019-04-12 18:10:17          524        600              \n",
       "22695  19200869  2019-04-12 18:25:00          524       1100              \n",
       "22696  19200871  2019-04-13 01:20:00          523        400              \n",
       "22697  19200876  2019-04-13 13:30:41          512       2800              \n",
       "22698  19012270  2019-04-13 15:28:23          242      10800              \n",
       "22699  19200877  2019-04-13 15:35:00          315       2400              \n",
       "22700  19012292  2019-04-13 19:02:00          512       2100              \n",
       "22701  19200878  2019-04-14 01:20:00          111       4100              \n",
       "22702  19200879  2019-04-14 02:15:00          516       3200              \n",
       "22703  19200884  2019-04-14 10:51:00          235      15500              \n",
       "22704  19200885  2019-04-14 10:53:18          315       9100              \n",
       "22705  19200891  2019-04-14 16:08:00          243       7000              \n",
       "22706  19200894  2019-04-14 18:03:00          116       1500              \n",
       "22707  19200893  2019-04-14 19:41:00          521        800              \n",
       "\n",
       "                      street_name street_type cross_st_dir  cross_st_name  \\\n",
       "0                     CAM DEL ORO                                           \n",
       "1                     ROYAL GORGE       DRIVE                               \n",
       "2                        CRAWFORD      STREET                               \n",
       "3                         VALERIO       TRAIL                               \n",
       "4                            11TH      AVENUE                               \n",
       "5                               A      STREET                               \n",
       "6                          RAMFOS       PLACE                               \n",
       "7                     DE LA VALLE                                           \n",
       "8                          SYDNEY       COURT                               \n",
       "9                       HORNBLEND      STREET                               \n",
       "10                        EMERALD      STREET                               \n",
       "11                       IMPERIAL      AVENUE                VIEWCREST DR   \n",
       "12                         LAUREL      STREET                               \n",
       "13                      BLACK MTN        ROAD                               \n",
       "14                     UNIVERSITY      AVENUE                               \n",
       "15                        MIRAMAR        ROAD                               \n",
       "16                       INGRAHAM      STREET                               \n",
       "17                    MISSION BAY       DRIVE                               \n",
       "18                       EL CAJON   BOULEVARD                               \n",
       "19                        ASHFORD      STREET                               \n",
       "20                         GARNET      AVENUE                               \n",
       "21                       EL CAJON   BOULEVARD                               \n",
       "22                       IMPERIAL      AVENUE                               \n",
       "23                 MISSION CENTER        ROAD                               \n",
       "24              SAN DIEGO MISSION        ROAD                               \n",
       "25                   SPORTS ARENA   BOULEVARD                               \n",
       "26                     WASHINGTON      STREET                               \n",
       "27                       EL CAJON   BOULEVARD                               \n",
       "28                           08TH      AVENUE                               \n",
       "29                        COLLEGE      AVENUE                               \n",
       "...                           ...         ...          ...            ...   \n",
       "22678                     PACIFIC     HIGHWAY                               \n",
       "22679                        01ST      AVENUE                               \n",
       "22680             DEL MAR HEIGHTS        ROAD                               \n",
       "22681                     JUNIPER      STREET                               \n",
       "22682                      RUFFIN        ROAD                               \n",
       "22683                      RUFFIN        ROAD                               \n",
       "22684                  OCEAN VIEW   BOULEVARD                               \n",
       "22685                      CONVOY      STREET                               \n",
       "22686                        31ST      STREET                     JUNIPER   \n",
       "22687                    CAM RUIZ                                           \n",
       "22688                  UNIVERSITY      AVENUE                               \n",
       "22689                   SCHEIDLER         WAY                               \n",
       "22690                     GENESEE      AVENUE                               \n",
       "22691  FT W OF ECL 200 TONY GWYNN       DRIVE                               \n",
       "22692                 KEARNY MESA        ROAD                               \n",
       "22693                     MIRAMAR        ROAD                               \n",
       "22694                        07TH      AVENUE                               \n",
       "22695                        08TH      AVENUE                               \n",
       "22696                           F      STREET                               \n",
       "22697                    NATIONAL      AVENUE                               \n",
       "22698                VIA SAN BLAS                                           \n",
       "22699           CAM DEL RIO SOUTH                                           \n",
       "22700                      KEARNY      AVENUE                               \n",
       "22701                     ASHFORD      STREET                               \n",
       "22702                           J      STREET                               \n",
       "22703          SAN PASQUAL VALLEY        ROAD                               \n",
       "22704                      FRIARS        ROAD                               \n",
       "22705                     MIRAMAR        ROAD                               \n",
       "22706                      MORENA   BOULEVARD                               \n",
       "22707                        10TH      AVENUE                               \n",
       "\n",
       "      cross_st_type violation_section violation_type  \\\n",
       "0                            MISC-HAZ             VC   \n",
       "1                               22107             VC   \n",
       "2                            MISC-HAZ             VC   \n",
       "3                            MISC-HAZ             VC   \n",
       "4                               22107             VC   \n",
       "5                            MISC-HAZ             VC   \n",
       "6                               22107             VC   \n",
       "7                               22107             VC   \n",
       "8                               22107             VC   \n",
       "9                               22107             VC   \n",
       "10                              22350             VC   \n",
       "11            DRIVE             22107             VC   \n",
       "12                              22107             VC   \n",
       "13                              22107             VC   \n",
       "14                              22107             VC   \n",
       "15                              22350             VC   \n",
       "16                              22350             VC   \n",
       "17                              22350             VC   \n",
       "18                           MISC-HAZ             VC   \n",
       "19                           MISC-HAZ             VC   \n",
       "20                              22517             VC   \n",
       "21                           22450(A)             VC   \n",
       "22                              22350             VC   \n",
       "23                             21461A             VC   \n",
       "24                              21703             VC   \n",
       "25                              22107             VC   \n",
       "26                              22107             VC   \n",
       "27                             21801A             VC   \n",
       "28                             21950B             VC   \n",
       "29                              21804             VC   \n",
       "...             ...               ...            ...   \n",
       "22678                           22517             VC   \n",
       "22679                           22350             VC   \n",
       "22680                           22107             VC   \n",
       "22681                        21235(G)             VC   \n",
       "22682                          21801A             VC   \n",
       "22683                           22107             VC   \n",
       "22684                        12500(A)             VC   \n",
       "22685                           22107             VC   \n",
       "22686        STREET            21801A             VC   \n",
       "22687                           22350             VC   \n",
       "22688                           21804             VC   \n",
       "22689                           22350             VC   \n",
       "22690                          21453A             VC   \n",
       "22691                           22107             VC   \n",
       "22692                           22107             VC   \n",
       "22693                           21804             VC   \n",
       "22694                        MISC-HAZ             VC   \n",
       "22695                          21950A             VC   \n",
       "22696                        MISC-HAZ             VC   \n",
       "22697                           22107             VC   \n",
       "22698                          23152A             VC   \n",
       "22699                           22350             VC   \n",
       "22700                           22350             VC   \n",
       "22701                          21460A             VC   \n",
       "22702                           22107             VC   \n",
       "22703                           22350             VC   \n",
       "22704                           22350             VC   \n",
       "22705                          21453A             VC   \n",
       "22706                        23152(F)             VC   \n",
       "22707                           22107             VC   \n",
       "\n",
       "                                             charge_desc  injured  killed  \\\n",
       "0      MISCELLANEOUS HAZARDOUS VIOLATIONS OF THE VEHI...        0       0   \n",
       "1                 TURNING MOVEMENTS AND REQUIRED SIGNALS        0       0   \n",
       "2      MISCELLANEOUS HAZARDOUS VIOLATIONS OF THE VEHI...        0       0   \n",
       "3      MISCELLANEOUS HAZARDOUS VIOLATIONS OF THE VEHI...        0       0   \n",
       "4                 TURNING MOVEMENTS AND REQUIRED SIGNALS        0       0   \n",
       "5      MISCELLANEOUS HAZARDOUS VIOLATIONS OF THE VEHI...        0       0   \n",
       "6                 TURNING MOVEMENTS AND REQUIRED SIGNALS        0       0   \n",
       "7                 TURNING MOVEMENTS AND REQUIRED SIGNALS        0       0   \n",
       "8                 TURNING MOVEMENTS AND REQUIRED SIGNALS        0       0   \n",
       "9                 TURNING MOVEMENTS AND REQUIRED SIGNALS        0       0   \n",
       "10     VIOLATION OF BASIC SPEED LAW SPEED UNSAFE FOR ...        0       0   \n",
       "11                TURNING MOVEMENTS AND REQUIRED SIGNALS        0       0   \n",
       "12                TURNING MOVEMENTS AND REQUIRED SIGNALS        0       0   \n",
       "13                TURNING MOVEMENTS AND REQUIRED SIGNALS        0       0   \n",
       "14                TURNING MOVEMENTS AND REQUIRED SIGNALS        0       0   \n",
       "15     VIOLATION OF BASIC SPEED LAW SPEED UNSAFE FOR ...        1       0   \n",
       "16     VIOLATION OF BASIC SPEED LAW SPEED UNSAFE FOR ...        1       0   \n",
       "17     VIOLATION OF BASIC SPEED LAW SPEED UNSAFE FOR ...        1       0   \n",
       "18     MISCELLANEOUS HAZARDOUS VIOLATIONS OF THE VEHI...        0       0   \n",
       "19     MISCELLANEOUS HAZARDOUS VIOLATIONS OF THE VEHI...        0       0   \n",
       "20                             OPENING AND CLOSING DOORS        1       0   \n",
       "21                     STOP REQUIREMENTS STATE STOP LINE        1       0   \n",
       "22     VIOLATION OF BASIC SPEED LAW SPEED UNSAFE FOR ...        0       0   \n",
       "23                   FAIL TO OBEY TRAFFIC CONTROL DEVICE        1       0   \n",
       "24                                 FOLLOWING TOO CLOSELY        0       0   \n",
       "25                TURNING MOVEMENTS AND REQUIRED SIGNALS        4       0   \n",
       "26                TURNING MOVEMENTS AND REQUIRED SIGNALS        0       0   \n",
       "27                  LEFT TURN YIELD UNTIL SAFE OR U-TURN        2       0   \n",
       "28             PEDESTRIAN NOT TO SUDDENLY ENTER PATH ETC        1       0   \n",
       "29            ENTERING HWY FROM PRIVATE ROAD OR DRIVEWAY        3       0   \n",
       "...                                                  ...      ...     ...   \n",
       "22678                     UNSAFE OPENING OF VEH DOOR (I)        1       0   \n",
       "22679                 UNSAFE SPEED (BASIC SPEED LAW) (I)        1       0   \n",
       "22680        TURNS:UNSAFE TURN AND/OR NO TURN SIGNAL (I)        0       0   \n",
       "22681            OPERATE MOTOR SCOOTER UPON SIDEWALK (I)        1       0   \n",
       "22682             RIGHT-OF-WAY:MAKING LEFT OR U-TURN (I)        2       0   \n",
       "22683        TURNS:UNSAFE TURN AND/OR NO TURN SIGNAL (I)        1       0   \n",
       "22684                  DRVG WITHOUT VALID DRVR'S LIC (M)        2       0   \n",
       "22685        TURNS:UNSAFE TURN AND/OR NO TURN SIGNAL (I)        0       0   \n",
       "22686             RIGHT-OF-WAY:MAKING LEFT OR U-TURN (I)        1       0   \n",
       "22687                 UNSAFE SPEED (BASIC SPEED LAW) (I)        1       0   \n",
       "22688                      RIGHT-OF-WAY:ENTERING HWY (I)        1       0   \n",
       "22689                 UNSAFE SPEED (BASIC SPEED LAW) (I)        0       0   \n",
       "22690                     SIGNAL LIGHTS:CIRCULAR RED (I)        1       0   \n",
       "22691        TURNS:UNSAFE TURN AND/OR NO TURN SIGNAL (I)        0       0   \n",
       "22692        TURNS:UNSAFE TURN AND/OR NO TURN SIGNAL (I)        0       0   \n",
       "22693                      RIGHT-OF-WAY:ENTERING HWY (I)        0       0   \n",
       "22694  MISCELLANEOUS HAZARDOUS VIOLATIONS OF THE VEHI...        0       0   \n",
       "22695  RIGHT-OF-WAY:DRVR YIELD TO PEDESTRIAN IN CROSS...        1       0   \n",
       "22696  MISCELLANEOUS HAZARDOUS VIOLATIONS OF THE VEHI...        0       0   \n",
       "22697        TURNS:UNSAFE TURN AND/OR NO TURN SIGNAL (I)        0       0   \n",
       "22698                                    DUI ALCOHOL (M)        0       0   \n",
       "22699                 UNSAFE SPEED (BASIC SPEED LAW) (I)        1       0   \n",
       "22700                 UNSAFE SPEED (BASIC SPEED LAW) (I)        0       0   \n",
       "22701         LANE USAGE:VEH CROSS DOUBLE SOLID LINE (I)        1       0   \n",
       "22702        TURNS:UNSAFE TURN AND/OR NO TURN SIGNAL (I)        0       0   \n",
       "22703                 UNSAFE SPEED (BASIC SPEED LAW) (I)        1       0   \n",
       "22704                 UNSAFE SPEED (BASIC SPEED LAW) (I)        0       0   \n",
       "22705                     SIGNAL LIGHTS:CIRCULAR RED (I)        1       0   \n",
       "22706                               DUI ALCOHOL/DRUG (M)        1       0   \n",
       "22707        TURNS:UNSAFE TURN AND/OR NO TURN SIGNAL (I)        1       0   \n",
       "\n",
       "       hit_run_lvl  \n",
       "0      MISDEMEANOR  \n",
       "1      MISDEMEANOR  \n",
       "2      MISDEMEANOR  \n",
       "3      MISDEMEANOR  \n",
       "4      MISDEMEANOR  \n",
       "5      MISDEMEANOR  \n",
       "6              NaN  \n",
       "7      MISDEMEANOR  \n",
       "8      MISDEMEANOR  \n",
       "9      MISDEMEANOR  \n",
       "10     MISDEMEANOR  \n",
       "11             NaN  \n",
       "12     MISDEMEANOR  \n",
       "13             NaN  \n",
       "14     MISDEMEANOR  \n",
       "15             NaN  \n",
       "16             NaN  \n",
       "17             NaN  \n",
       "18     MISDEMEANOR  \n",
       "19     MISDEMEANOR  \n",
       "20             NaN  \n",
       "21             NaN  \n",
       "22          FELONY  \n",
       "23             NaN  \n",
       "24     MISDEMEANOR  \n",
       "25             NaN  \n",
       "26             NaN  \n",
       "27             NaN  \n",
       "28             NaN  \n",
       "29             NaN  \n",
       "...            ...  \n",
       "22678          NaN  \n",
       "22679          NaN  \n",
       "22680  MISDEMEANOR  \n",
       "22681          NaN  \n",
       "22682          NaN  \n",
       "22683          NaN  \n",
       "22684          NaN  \n",
       "22685  MISDEMEANOR  \n",
       "22686          NaN  \n",
       "22687  MISDEMEANOR  \n",
       "22688  MISDEMEANOR  \n",
       "22689          NaN  \n",
       "22690          NaN  \n",
       "22691  MISDEMEANOR  \n",
       "22692          NaN  \n",
       "22693          NaN  \n",
       "22694  MISDEMEANOR  \n",
       "22695          NaN  \n",
       "22696  MISDEMEANOR  \n",
       "22697  MISDEMEANOR  \n",
       "22698          NaN  \n",
       "22699          NaN  \n",
       "22700          NaN  \n",
       "22701          NaN  \n",
       "22702          NaN  \n",
       "22703          NaN  \n",
       "22704  MISDEMEANOR  \n",
       "22705          NaN  \n",
       "22706          NaN  \n",
       "22707          NaN  \n",
       "\n",
       "[22708 rows x 16 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "collision_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "traffic_data = pd.read_csv('datasets/traffic_counts_datasd.csv')\n",
    "traffic_dict = pd.read_csv('datasets/traffic_counts_dictionary_datasd.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>Field</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>street_name</td>\n",
       "      <td>The vehicles were counted on this street</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>limits</td>\n",
       "      <td>The vehicles were counted between these cross ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>northbound_count</td>\n",
       "      <td>The 24 hour count of northbound vehicles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>southbound_count</td>\n",
       "      <td>The 24 hour count of southbound vehicles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>eastbound_count</td>\n",
       "      <td>The 24 hour count of eastbound vehicles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>westbound_count</td>\n",
       "      <td>The 24 hour count of westbound vehicles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>total_count</td>\n",
       "      <td>The 24 hour total of all directions of vehicle...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>count_date</td>\n",
       "      <td>The vehicles were counted on this date</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Field                                        Description\n",
       "0       street_name           The vehicles were counted on this street\n",
       "1            limits  The vehicles were counted between these cross ...\n",
       "2  northbound_count           The 24 hour count of northbound vehicles\n",
       "3  southbound_count           The 24 hour count of southbound vehicles\n",
       "4   eastbound_count            The 24 hour count of eastbound vehicles\n",
       "5   westbound_count            The 24 hour count of westbound vehicles\n",
       "6       total_count  The 24 hour total of all directions of vehicle...\n",
       "7        count_date             The vehicles were counted on this date"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "traffic_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>street_name</th>\n",
       "      <th>limits</th>\n",
       "      <th>all_count</th>\n",
       "      <th>northbound_count</th>\n",
       "      <th>southbound_count</th>\n",
       "      <th>eastbound_count</th>\n",
       "      <th>westbound_count</th>\n",
       "      <th>total_count</th>\n",
       "      <th>file_no</th>\n",
       "      <th>count_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>01AV018207</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>A ST - ASH ST</td>\n",
       "      <td></td>\n",
       "      <td>18010</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18010</td>\n",
       "      <td>0182-07</td>\n",
       "      <td>2007-03-13 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>01AV015210</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>A ST - ASH ST</td>\n",
       "      <td></td>\n",
       "      <td>20060</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20060</td>\n",
       "      <td>0152-10</td>\n",
       "      <td>2010-03-18 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>01AV018213</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>A ST - ASH ST</td>\n",
       "      <td></td>\n",
       "      <td>19597</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19597</td>\n",
       "      <td>0182-13</td>\n",
       "      <td>2013-03-12 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>01AV088812</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>ASH ST - BEECH ST</td>\n",
       "      <td></td>\n",
       "      <td>2298</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2298</td>\n",
       "      <td>0888-12</td>\n",
       "      <td>2012-12-11 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>01AV068711</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>B ST - A ST</td>\n",
       "      <td></td>\n",
       "      <td>15625</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15625</td>\n",
       "      <td>0687-11</td>\n",
       "      <td>2011-09-01 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>01AV000714</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>B ST - A ST</td>\n",
       "      <td></td>\n",
       "      <td>13569</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13569</td>\n",
       "      <td>0007-14</td>\n",
       "      <td>2014-02-11 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>01AV048412</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>B ST - C ST</td>\n",
       "      <td></td>\n",
       "      <td>13389</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13389</td>\n",
       "      <td>0484-12</td>\n",
       "      <td>2012-05-31 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>01AV048115</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>B ST - C ST</td>\n",
       "      <td></td>\n",
       "      <td>13995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13995</td>\n",
       "      <td>0481-15</td>\n",
       "      <td>2015-06-17 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>01AV019406</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>BEECH ST - CEDAR ST</td>\n",
       "      <td></td>\n",
       "      <td>27450</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27450</td>\n",
       "      <td>0194-06</td>\n",
       "      <td>2006-03-23 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>01AV017909</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>BEECH ST - CEDAR ST</td>\n",
       "      <td></td>\n",
       "      <td>22345</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22345</td>\n",
       "      <td>0179-09</td>\n",
       "      <td>2009-03-31 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>01AV018912</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>BEECH ST - CEDAR ST</td>\n",
       "      <td></td>\n",
       "      <td>18742</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18742</td>\n",
       "      <td>0189-12</td>\n",
       "      <td>2012-03-08 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>01AV022415</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>BEECH ST - CEDAR ST</td>\n",
       "      <td></td>\n",
       "      <td>24463</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24463</td>\n",
       "      <td>0224-15</td>\n",
       "      <td>2015-04-30 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>01AV005516</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>BEECH ST - CEDAR ST</td>\n",
       "      <td></td>\n",
       "      <td>25715</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25715</td>\n",
       "      <td>0055-16</td>\n",
       "      <td>2016-03-30 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>01AV058207</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>E ST - BROADWAY</td>\n",
       "      <td></td>\n",
       "      <td>10410</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10410</td>\n",
       "      <td>0582-07</td>\n",
       "      <td>2008-01-08 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>01AV000611</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>E ST - BROADWAY</td>\n",
       "      <td></td>\n",
       "      <td>12905</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12905</td>\n",
       "      <td>0006-11</td>\n",
       "      <td>2011-02-08 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>01AV000814</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>E ST - BROADWAY</td>\n",
       "      <td></td>\n",
       "      <td>11278</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11278</td>\n",
       "      <td>0008-14</td>\n",
       "      <td>2014-02-11 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>01AV016105</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>ELM ST - FIR ST</td>\n",
       "      <td></td>\n",
       "      <td>3920</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3920</td>\n",
       "      <td>0161-05</td>\n",
       "      <td>2006-03-30 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>01AV018909</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>ELM ST - FIR ST</td>\n",
       "      <td></td>\n",
       "      <td>3285</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3285</td>\n",
       "      <td>0189-09</td>\n",
       "      <td>2009-03-31 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>01AV019012</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>ELM ST - FIR ST</td>\n",
       "      <td></td>\n",
       "      <td>3414</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3414</td>\n",
       "      <td>0190-12</td>\n",
       "      <td>2012-03-08 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>01AV114314</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>ELM ST - FIR ST</td>\n",
       "      <td></td>\n",
       "      <td>3419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3419</td>\n",
       "      <td>1143-14</td>\n",
       "      <td>2014-08-05 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>01AV022515</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>ELM ST - FIR ST</td>\n",
       "      <td></td>\n",
       "      <td>3477</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3477</td>\n",
       "      <td>0225-15</td>\n",
       "      <td>2015-04-30 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>01AV006516</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>ELM ST - FIR ST</td>\n",
       "      <td></td>\n",
       "      <td>3474</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3474</td>\n",
       "      <td>0065-16</td>\n",
       "      <td>2016-03-01 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>01AV048312</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>F ST - E ST</td>\n",
       "      <td></td>\n",
       "      <td>11148</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11148</td>\n",
       "      <td>0483-12</td>\n",
       "      <td>2012-05-10 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>01AV041815</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>F ST - E ST</td>\n",
       "      <td></td>\n",
       "      <td>11421</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11421</td>\n",
       "      <td>0418-15</td>\n",
       "      <td>2015-06-09 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>01AV048212</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>F ST - G ST</td>\n",
       "      <td></td>\n",
       "      <td>10003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10003</td>\n",
       "      <td>0482-12</td>\n",
       "      <td>2012-05-10 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>01AV041915</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>F ST - G ST</td>\n",
       "      <td></td>\n",
       "      <td>10774</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10774</td>\n",
       "      <td>0419-15</td>\n",
       "      <td>2015-06-10 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>01AV068611</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>GRAPE ST - HAWTHORN ST</td>\n",
       "      <td></td>\n",
       "      <td>3210</td>\n",
       "      <td>610.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3820</td>\n",
       "      <td>0686-11</td>\n",
       "      <td>2011-08-30 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>01AV000914</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>GRAPE ST - HAWTHORN ST</td>\n",
       "      <td></td>\n",
       "      <td>3566</td>\n",
       "      <td>502.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4068</td>\n",
       "      <td>0009-14</td>\n",
       "      <td>2014-02-11 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>01AV114214</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>GRAPE ST - HAWTHORN ST</td>\n",
       "      <td></td>\n",
       "      <td>3038</td>\n",
       "      <td>514.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3552</td>\n",
       "      <td>1142-14</td>\n",
       "      <td>2014-08-05 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>01AV110615</td>\n",
       "      <td>01 AV</td>\n",
       "      <td>ISLAND AV - E HARBOR DR</td>\n",
       "      <td></td>\n",
       "      <td>3355</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3355</td>\n",
       "      <td>1106-15</td>\n",
       "      <td>2015-12-22 00:00:00</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11629</th>\n",
       "      <td>WORLDTRADEDR009807</td>\n",
       "      <td>WORLD TRADE DR</td>\n",
       "      <td>CONFERENCE WY - CAMINO NORTE</td>\n",
       "      <td></td>\n",
       "      <td>4560</td>\n",
       "      <td>3210.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7770</td>\n",
       "      <td>0098-07</td>\n",
       "      <td>2007-02-22 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11630</th>\n",
       "      <td>WORLDTRADEDR007410</td>\n",
       "      <td>WORLD TRADE DR</td>\n",
       "      <td>CONFERENCE WY - CAMINO NORTE</td>\n",
       "      <td></td>\n",
       "      <td>5955</td>\n",
       "      <td>3525.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9480</td>\n",
       "      <td>0074-10</td>\n",
       "      <td>2010-02-23 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11631</th>\n",
       "      <td>WORLDTRADEDR017213</td>\n",
       "      <td>WORLD TRADE DR</td>\n",
       "      <td>CONFERENCE WY - CAMINO NORTE</td>\n",
       "      <td></td>\n",
       "      <td>4521</td>\n",
       "      <td>3655.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8176</td>\n",
       "      <td>0172-13</td>\n",
       "      <td>2013-02-26 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11632</th>\n",
       "      <td>WORLDTRADEDR004217</td>\n",
       "      <td>WORLD TRADE DR</td>\n",
       "      <td>CONFERENCE WY - CAMINO NORTE</td>\n",
       "      <td></td>\n",
       "      <td>3883</td>\n",
       "      <td>3417.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7300</td>\n",
       "      <td>0042-17</td>\n",
       "      <td>2017-02-15 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11633</th>\n",
       "      <td>WORLDTRADEDR022817</td>\n",
       "      <td>WORLD TRADE DR</td>\n",
       "      <td>HIGHLAND RH RD - CAM DEL NORTE</td>\n",
       "      <td></td>\n",
       "      <td>5060</td>\n",
       "      <td>5154.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10214</td>\n",
       "      <td>0228-17</td>\n",
       "      <td>2017-04-25 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11634</th>\n",
       "      <td>WORLDTRADEDR009707</td>\n",
       "      <td>WORLD TRADE DR</td>\n",
       "      <td>HIGHLAND RH RD - CONFERENCE WY</td>\n",
       "      <td></td>\n",
       "      <td>4910</td>\n",
       "      <td>3350.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8260</td>\n",
       "      <td>0097-07</td>\n",
       "      <td>2007-02-22 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11635</th>\n",
       "      <td>WORLDTRADEDR007310</td>\n",
       "      <td>WORLD TRADE DR</td>\n",
       "      <td>HIGHLAND RH RD - CONFERENCE WY</td>\n",
       "      <td></td>\n",
       "      <td>4725</td>\n",
       "      <td>4420.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9145</td>\n",
       "      <td>0073-10</td>\n",
       "      <td>2010-02-23 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11636</th>\n",
       "      <td>WORLDTRADEDR017313</td>\n",
       "      <td>WORLD TRADE DR</td>\n",
       "      <td>HIGHLAND RH RD - CONFERENCE WY</td>\n",
       "      <td></td>\n",
       "      <td>4056</td>\n",
       "      <td>4167.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8223</td>\n",
       "      <td>0173-13</td>\n",
       "      <td>2013-02-21 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11637</th>\n",
       "      <td>WORLDTRADEDR004117</td>\n",
       "      <td>WORLD TRADE DR</td>\n",
       "      <td>HIGHLAND RH RD - CONFERENCE WY</td>\n",
       "      <td></td>\n",
       "      <td>5285</td>\n",
       "      <td>4252.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9537</td>\n",
       "      <td>0041-17</td>\n",
       "      <td>2017-02-15 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11638</th>\n",
       "      <td>WORLDTRADEDR009907</td>\n",
       "      <td>WORLD TRADE DR</td>\n",
       "      <td>STONEY PEAK DR - HIGHLAND RH RD</td>\n",
       "      <td></td>\n",
       "      <td>2270</td>\n",
       "      <td>2610.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4880</td>\n",
       "      <td>0099-07</td>\n",
       "      <td>2007-02-22 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11639</th>\n",
       "      <td>WORLDTRADEDR007510</td>\n",
       "      <td>WORLD TRADE DR</td>\n",
       "      <td>STONEY PEAK DR - HIGHLAND RH RD</td>\n",
       "      <td></td>\n",
       "      <td>2235</td>\n",
       "      <td>3570.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5805</td>\n",
       "      <td>0075-10</td>\n",
       "      <td>2010-03-02 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11640</th>\n",
       "      <td>WORLDTRADEDR017413</td>\n",
       "      <td>WORLD TRADE DR</td>\n",
       "      <td>STONEY PEAK DR - HIGHLAND RH RD</td>\n",
       "      <td></td>\n",
       "      <td>1902</td>\n",
       "      <td>3277.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5179</td>\n",
       "      <td>0174-13</td>\n",
       "      <td>2013-02-26 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11641</th>\n",
       "      <td>WORLDTRADEDR004317</td>\n",
       "      <td>WORLD TRADE DR</td>\n",
       "      <td>STONEY PEAK DR - HIGHLAND RH RD</td>\n",
       "      <td></td>\n",
       "      <td>4142</td>\n",
       "      <td>3748.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7890</td>\n",
       "      <td>0043-17</td>\n",
       "      <td>2017-02-28 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11642</th>\n",
       "      <td>WORSCHDR029012</td>\n",
       "      <td>WORSCH DR</td>\n",
       "      <td>DEL MAR TRAILS RD - WORSCH WY</td>\n",
       "      <td></td>\n",
       "      <td>726</td>\n",
       "      <td>683.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1409</td>\n",
       "      <td>0290-12</td>\n",
       "      <td>2012-03-27 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11643</th>\n",
       "      <td>WORSCHDR030915</td>\n",
       "      <td>WORSCH DR</td>\n",
       "      <td>DEL MAR TRAILS RD - WORSCH WY</td>\n",
       "      <td></td>\n",
       "      <td>854</td>\n",
       "      <td>842.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1696</td>\n",
       "      <td>0309-15</td>\n",
       "      <td>2015-05-21 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11644</th>\n",
       "      <td>WORSCHDR023617</td>\n",
       "      <td>WORSCH DR</td>\n",
       "      <td>WORSCH WY - PORTILLA  PL</td>\n",
       "      <td></td>\n",
       "      <td>551</td>\n",
       "      <td>880.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1431</td>\n",
       "      <td>0236-17</td>\n",
       "      <td>2017-04-27 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11645</th>\n",
       "      <td>WYNDHAVENDR025017</td>\n",
       "      <td>WYNDHAVEN DR</td>\n",
       "      <td>QUARTER MILE DR - HALF MILE  DR</td>\n",
       "      <td></td>\n",
       "      <td>231</td>\n",
       "      <td>312.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>543</td>\n",
       "      <td>0250-17</td>\n",
       "      <td>2017-05-25 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11646</th>\n",
       "      <td>YERBASANTADR057810</td>\n",
       "      <td>YERBA SANTA DR</td>\n",
       "      <td>MESQUITE RD - MONTEZUMA RD</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1210.0</td>\n",
       "      <td>1080.0</td>\n",
       "      <td>2290</td>\n",
       "      <td>0578-10</td>\n",
       "      <td>2010-06-24 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11647</th>\n",
       "      <td>YSABELCRKRD057910</td>\n",
       "      <td>YSABEL CRK RD</td>\n",
       "      <td>BANDY CYN RD - SD 078</td>\n",
       "      <td></td>\n",
       "      <td>310</td>\n",
       "      <td>295.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>605</td>\n",
       "      <td>0579-10</td>\n",
       "      <td>2010-06-22 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11648</th>\n",
       "      <td>ZIONAV058010</td>\n",
       "      <td>ZION AV</td>\n",
       "      <td>ARCHWOOD AV - CRAWFORD ST</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6075.0</td>\n",
       "      <td>4815.0</td>\n",
       "      <td>10890</td>\n",
       "      <td>0580-10</td>\n",
       "      <td>2010-06-24 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11649</th>\n",
       "      <td>ZIONAV029607</td>\n",
       "      <td>ZION AV</td>\n",
       "      <td>CLARA LEE AV - ESTRELLA AV</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6160.0</td>\n",
       "      <td>6780.0</td>\n",
       "      <td>12940</td>\n",
       "      <td>0296-07</td>\n",
       "      <td>2007-05-29 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11650</th>\n",
       "      <td>ZIONAV031910</td>\n",
       "      <td>ZION AV</td>\n",
       "      <td>CLARA LEE AV - ESTRELLA AV</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5975.0</td>\n",
       "      <td>5410.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>0319-10</td>\n",
       "      <td>2010-05-26 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11651</th>\n",
       "      <td>ZIONAV041613</td>\n",
       "      <td>ZION AV</td>\n",
       "      <td>CLARA LEE AV - ESTRELLA AV</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6114.0</td>\n",
       "      <td>5618.0</td>\n",
       "      <td>11732</td>\n",
       "      <td>0416-13</td>\n",
       "      <td>2013-04-25 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11652</th>\n",
       "      <td>ZIONAV085311</td>\n",
       "      <td>ZION AV</td>\n",
       "      <td>MISSION GORGE RD - ARCHWOOD AV</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6050.0</td>\n",
       "      <td>5510.0</td>\n",
       "      <td>11560</td>\n",
       "      <td>0853-11</td>\n",
       "      <td>2011-08-11 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11653</th>\n",
       "      <td>ZIONAV112514</td>\n",
       "      <td>ZION AV</td>\n",
       "      <td>MISSION GORGE RD - ARCHWOOD AV</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7320.0</td>\n",
       "      <td>5377.0</td>\n",
       "      <td>12697</td>\n",
       "      <td>1125-14</td>\n",
       "      <td>2014-12-10 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11654</th>\n",
       "      <td>ZOOPL009205</td>\n",
       "      <td>ZOO PL</td>\n",
       "      <td>PARK BL - FLORIDA DR</td>\n",
       "      <td></td>\n",
       "      <td>2620</td>\n",
       "      <td>3680.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6300</td>\n",
       "      <td>0092-05</td>\n",
       "      <td>2005-04-07 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11655</th>\n",
       "      <td>ZOOPL013708</td>\n",
       "      <td>ZOO PL</td>\n",
       "      <td>PARK BL - FLORIDA DR</td>\n",
       "      <td></td>\n",
       "      <td>4790</td>\n",
       "      <td>4640.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9430</td>\n",
       "      <td>0137-08</td>\n",
       "      <td>2008-03-20 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11656</th>\n",
       "      <td>ZOOPL033011</td>\n",
       "      <td>ZOO PL</td>\n",
       "      <td>PARK BL - FLORIDA DR</td>\n",
       "      <td></td>\n",
       "      <td>2425</td>\n",
       "      <td>3170.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5595</td>\n",
       "      <td>0330-11</td>\n",
       "      <td>2014-05-24 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11657</th>\n",
       "      <td>ZOOPL112614</td>\n",
       "      <td>ZOO PL</td>\n",
       "      <td>PARK BL - FLORIDA DR</td>\n",
       "      <td></td>\n",
       "      <td>1935</td>\n",
       "      <td>2490.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4425</td>\n",
       "      <td>1126-14</td>\n",
       "      <td>2014-12-16 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11658</th>\n",
       "      <td>ZOOPL022018</td>\n",
       "      <td>ZOO PL</td>\n",
       "      <td>PARK BL - FLORIDA DR</td>\n",
       "      <td></td>\n",
       "      <td>3110</td>\n",
       "      <td>3164.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6274</td>\n",
       "      <td>0220-18</td>\n",
       "      <td>2018-04-17 00:00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11659 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       id     street_name                           limits  \\\n",
       "0              01AV018207           01 AV                    A ST - ASH ST   \n",
       "1              01AV015210           01 AV                    A ST - ASH ST   \n",
       "2              01AV018213           01 AV                    A ST - ASH ST   \n",
       "3              01AV088812           01 AV                ASH ST - BEECH ST   \n",
       "4              01AV068711           01 AV                      B ST - A ST   \n",
       "5              01AV000714           01 AV                      B ST - A ST   \n",
       "6              01AV048412           01 AV                      B ST - C ST   \n",
       "7              01AV048115           01 AV                      B ST - C ST   \n",
       "8              01AV019406           01 AV              BEECH ST - CEDAR ST   \n",
       "9              01AV017909           01 AV              BEECH ST - CEDAR ST   \n",
       "10             01AV018912           01 AV              BEECH ST - CEDAR ST   \n",
       "11             01AV022415           01 AV              BEECH ST - CEDAR ST   \n",
       "12             01AV005516           01 AV              BEECH ST - CEDAR ST   \n",
       "13             01AV058207           01 AV                 E ST - BROADWAY    \n",
       "14             01AV000611           01 AV                 E ST - BROADWAY    \n",
       "15             01AV000814           01 AV                 E ST - BROADWAY    \n",
       "16             01AV016105           01 AV                  ELM ST - FIR ST   \n",
       "17             01AV018909           01 AV                  ELM ST - FIR ST   \n",
       "18             01AV019012           01 AV                  ELM ST - FIR ST   \n",
       "19             01AV114314           01 AV                  ELM ST - FIR ST   \n",
       "20             01AV022515           01 AV                  ELM ST - FIR ST   \n",
       "21             01AV006516           01 AV                  ELM ST - FIR ST   \n",
       "22             01AV048312           01 AV                      F ST - E ST   \n",
       "23             01AV041815           01 AV                      F ST - E ST   \n",
       "24             01AV048212           01 AV                      F ST - G ST   \n",
       "25             01AV041915           01 AV                      F ST - G ST   \n",
       "26             01AV068611           01 AV           GRAPE ST - HAWTHORN ST   \n",
       "27             01AV000914           01 AV           GRAPE ST - HAWTHORN ST   \n",
       "28             01AV114214           01 AV           GRAPE ST - HAWTHORN ST   \n",
       "29             01AV110615           01 AV          ISLAND AV - E HARBOR DR   \n",
       "...                   ...             ...                              ...   \n",
       "11629  WORLDTRADEDR009807  WORLD TRADE DR    CONFERENCE WY - CAMINO NORTE    \n",
       "11630  WORLDTRADEDR007410  WORLD TRADE DR    CONFERENCE WY - CAMINO NORTE    \n",
       "11631  WORLDTRADEDR017213  WORLD TRADE DR    CONFERENCE WY - CAMINO NORTE    \n",
       "11632  WORLDTRADEDR004217  WORLD TRADE DR    CONFERENCE WY - CAMINO NORTE    \n",
       "11633  WORLDTRADEDR022817  WORLD TRADE DR  HIGHLAND RH RD - CAM DEL NORTE    \n",
       "11634  WORLDTRADEDR009707  WORLD TRADE DR   HIGHLAND RH RD - CONFERENCE WY   \n",
       "11635  WORLDTRADEDR007310  WORLD TRADE DR   HIGHLAND RH RD - CONFERENCE WY   \n",
       "11636  WORLDTRADEDR017313  WORLD TRADE DR   HIGHLAND RH RD - CONFERENCE WY   \n",
       "11637  WORLDTRADEDR004117  WORLD TRADE DR   HIGHLAND RH RD - CONFERENCE WY   \n",
       "11638  WORLDTRADEDR009907  WORLD TRADE DR  STONEY PEAK DR - HIGHLAND RH RD   \n",
       "11639  WORLDTRADEDR007510  WORLD TRADE DR  STONEY PEAK DR - HIGHLAND RH RD   \n",
       "11640  WORLDTRADEDR017413  WORLD TRADE DR  STONEY PEAK DR - HIGHLAND RH RD   \n",
       "11641  WORLDTRADEDR004317  WORLD TRADE DR  STONEY PEAK DR - HIGHLAND RH RD   \n",
       "11642      WORSCHDR029012       WORSCH DR    DEL MAR TRAILS RD - WORSCH WY   \n",
       "11643      WORSCHDR030915       WORSCH DR    DEL MAR TRAILS RD - WORSCH WY   \n",
       "11644      WORSCHDR023617       WORSCH DR         WORSCH WY - PORTILLA  PL   \n",
       "11645   WYNDHAVENDR025017    WYNDHAVEN DR  QUARTER MILE DR - HALF MILE  DR   \n",
       "11646  YERBASANTADR057810  YERBA SANTA DR       MESQUITE RD - MONTEZUMA RD   \n",
       "11647   YSABELCRKRD057910   YSABEL CRK RD           BANDY CYN RD - SD 078    \n",
       "11648        ZIONAV058010         ZION AV        ARCHWOOD AV - CRAWFORD ST   \n",
       "11649        ZIONAV029607         ZION AV       CLARA LEE AV - ESTRELLA AV   \n",
       "11650        ZIONAV031910         ZION AV       CLARA LEE AV - ESTRELLA AV   \n",
       "11651        ZIONAV041613         ZION AV       CLARA LEE AV - ESTRELLA AV   \n",
       "11652        ZIONAV085311         ZION AV   MISSION GORGE RD - ARCHWOOD AV   \n",
       "11653        ZIONAV112514         ZION AV   MISSION GORGE RD - ARCHWOOD AV   \n",
       "11654         ZOOPL009205          ZOO PL             PARK BL - FLORIDA DR   \n",
       "11655         ZOOPL013708          ZOO PL             PARK BL - FLORIDA DR   \n",
       "11656         ZOOPL033011          ZOO PL             PARK BL - FLORIDA DR   \n",
       "11657         ZOOPL112614          ZOO PL             PARK BL - FLORIDA DR   \n",
       "11658         ZOOPL022018          ZOO PL             PARK BL - FLORIDA DR   \n",
       "\n",
       "      all_count northbound_count  southbound_count  eastbound_count  \\\n",
       "0                          18010               NaN              NaN   \n",
       "1                          20060               NaN              NaN   \n",
       "2                          19597               NaN              NaN   \n",
       "3                           2298               NaN              NaN   \n",
       "4                          15625               NaN              NaN   \n",
       "5                          13569               NaN              NaN   \n",
       "6                          13389               NaN              NaN   \n",
       "7                          13995               NaN              NaN   \n",
       "8                          27450               NaN              NaN   \n",
       "9                          22345               NaN              NaN   \n",
       "10                         18742               NaN              NaN   \n",
       "11                         24463               NaN              NaN   \n",
       "12                         25715               NaN              NaN   \n",
       "13                         10410               NaN              NaN   \n",
       "14                         12905               NaN              NaN   \n",
       "15                         11278               NaN              NaN   \n",
       "16                          3920               NaN              NaN   \n",
       "17                          3285               NaN              NaN   \n",
       "18                          3414               NaN              NaN   \n",
       "19                          3419               NaN              NaN   \n",
       "20                          3477               NaN              NaN   \n",
       "21                          3474               NaN              NaN   \n",
       "22                         11148               NaN              NaN   \n",
       "23                         11421               NaN              NaN   \n",
       "24                         10003               NaN              NaN   \n",
       "25                         10774               NaN              NaN   \n",
       "26                          3210             610.0              NaN   \n",
       "27                          3566             502.0              NaN   \n",
       "28                          3038             514.0              NaN   \n",
       "29                          3355               NaN              NaN   \n",
       "...         ...              ...               ...              ...   \n",
       "11629                       4560            3210.0              NaN   \n",
       "11630                       5955            3525.0              NaN   \n",
       "11631                       4521            3655.0              NaN   \n",
       "11632                       3883            3417.0              NaN   \n",
       "11633                       5060            5154.0              NaN   \n",
       "11634                       4910            3350.0              NaN   \n",
       "11635                       4725            4420.0              NaN   \n",
       "11636                       4056            4167.0              NaN   \n",
       "11637                       5285            4252.0              NaN   \n",
       "11638                       2270            2610.0              NaN   \n",
       "11639                       2235            3570.0              NaN   \n",
       "11640                       1902            3277.0              NaN   \n",
       "11641                       4142            3748.0              NaN   \n",
       "11642                        726             683.0              NaN   \n",
       "11643                        854             842.0              NaN   \n",
       "11644                        551             880.0              NaN   \n",
       "11645                        231             312.0              NaN   \n",
       "11646                        NaN               NaN           1210.0   \n",
       "11647                        310             295.0              NaN   \n",
       "11648                        NaN               NaN           6075.0   \n",
       "11649                        NaN               NaN           6160.0   \n",
       "11650                        NaN               NaN           5975.0   \n",
       "11651                        NaN               NaN           6114.0   \n",
       "11652                        NaN               NaN           6050.0   \n",
       "11653                        NaN               NaN           7320.0   \n",
       "11654                       2620            3680.0              NaN   \n",
       "11655                       4790            4640.0              NaN   \n",
       "11656                       2425            3170.0              NaN   \n",
       "11657                       1935            2490.0              NaN   \n",
       "11658                       3110            3164.0              NaN   \n",
       "\n",
       "       westbound_count  total_count  file_no           count_date  \n",
       "0                  NaN        18010  0182-07  2007-03-13 00:00:00  \n",
       "1                  NaN        20060  0152-10  2010-03-18 00:00:00  \n",
       "2                  NaN        19597  0182-13  2013-03-12 00:00:00  \n",
       "3                  NaN         2298  0888-12  2012-12-11 00:00:00  \n",
       "4                  NaN        15625  0687-11  2011-09-01 00:00:00  \n",
       "5                  NaN        13569  0007-14  2014-02-11 00:00:00  \n",
       "6                  NaN        13389  0484-12  2012-05-31 00:00:00  \n",
       "7                  NaN        13995  0481-15  2015-06-17 00:00:00  \n",
       "8                  NaN        27450  0194-06  2006-03-23 00:00:00  \n",
       "9                  NaN        22345  0179-09  2009-03-31 00:00:00  \n",
       "10                 NaN        18742  0189-12  2012-03-08 00:00:00  \n",
       "11                 NaN        24463  0224-15  2015-04-30 00:00:00  \n",
       "12                 NaN        25715  0055-16  2016-03-30 00:00:00  \n",
       "13                 NaN        10410  0582-07  2008-01-08 00:00:00  \n",
       "14                 NaN        12905  0006-11  2011-02-08 00:00:00  \n",
       "15                 NaN        11278  0008-14  2014-02-11 00:00:00  \n",
       "16                 NaN         3920  0161-05  2006-03-30 00:00:00  \n",
       "17                 NaN         3285  0189-09  2009-03-31 00:00:00  \n",
       "18                 NaN         3414  0190-12  2012-03-08 00:00:00  \n",
       "19                 NaN         3419  1143-14  2014-08-05 00:00:00  \n",
       "20                 NaN         3477  0225-15  2015-04-30 00:00:00  \n",
       "21                 NaN         3474  0065-16  2016-03-01 00:00:00  \n",
       "22                 NaN        11148  0483-12  2012-05-10 00:00:00  \n",
       "23                 NaN        11421  0418-15  2015-06-09 00:00:00  \n",
       "24                 NaN        10003  0482-12  2012-05-10 00:00:00  \n",
       "25                 NaN        10774  0419-15  2015-06-10 00:00:00  \n",
       "26                 NaN         3820  0686-11  2011-08-30 00:00:00  \n",
       "27                 NaN         4068  0009-14  2014-02-11 00:00:00  \n",
       "28                 NaN         3552  1142-14  2014-08-05 00:00:00  \n",
       "29                 NaN         3355  1106-15  2015-12-22 00:00:00  \n",
       "...                ...          ...      ...                  ...  \n",
       "11629              NaN         7770  0098-07  2007-02-22 00:00:00  \n",
       "11630              NaN         9480  0074-10  2010-02-23 00:00:00  \n",
       "11631              NaN         8176  0172-13  2013-02-26 00:00:00  \n",
       "11632              NaN         7300  0042-17  2017-02-15 00:00:00  \n",
       "11633              NaN        10214  0228-17  2017-04-25 00:00:00  \n",
       "11634              NaN         8260  0097-07  2007-02-22 00:00:00  \n",
       "11635              NaN         9145  0073-10  2010-02-23 00:00:00  \n",
       "11636              NaN         8223  0173-13  2013-02-21 00:00:00  \n",
       "11637              NaN         9537  0041-17  2017-02-15 00:00:00  \n",
       "11638              NaN         4880  0099-07  2007-02-22 00:00:00  \n",
       "11639              NaN         5805  0075-10  2010-03-02 00:00:00  \n",
       "11640              NaN         5179  0174-13  2013-02-26 00:00:00  \n",
       "11641              NaN         7890  0043-17  2017-02-28 00:00:00  \n",
       "11642              NaN         1409  0290-12  2012-03-27 00:00:00  \n",
       "11643              NaN         1696  0309-15  2015-05-21 00:00:00  \n",
       "11644              NaN         1431  0236-17  2017-04-27 00:00:00  \n",
       "11645              NaN          543  0250-17  2017-05-25 00:00:00  \n",
       "11646           1080.0         2290  0578-10  2010-06-24 00:00:00  \n",
       "11647              NaN          605  0579-10  2010-06-22 00:00:00  \n",
       "11648           4815.0        10890  0580-10  2010-06-24 00:00:00  \n",
       "11649           6780.0        12940  0296-07  2007-05-29 00:00:00  \n",
       "11650           5410.0        11385  0319-10  2010-05-26 00:00:00  \n",
       "11651           5618.0        11732  0416-13  2013-04-25 00:00:00  \n",
       "11652           5510.0        11560  0853-11  2011-08-11 00:00:00  \n",
       "11653           5377.0        12697  1125-14  2014-12-10 00:00:00  \n",
       "11654              NaN         6300  0092-05  2005-04-07 00:00:00  \n",
       "11655              NaN         9430  0137-08  2008-03-20 00:00:00  \n",
       "11656              NaN         5595  0330-11  2014-05-24 00:00:00  \n",
       "11657              NaN         4425  1126-14  2014-12-16 00:00:00  \n",
       "11658              NaN         6274  0220-18  2018-04-17 00:00:00  \n",
       "\n",
       "[11659 rows x 11 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "traffic_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}