Crime Prediction - Clustering - Ipynb
Crime Prediction - Clustering - Ipynb
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import numpy as np\n",
"import timeit\n",
"import pandas as pd\n",
"from sklearn.preprocessing import StandardScaler\n",
"from sklearn.cluster import KMeans\n",
"import matplotlib.pyplot as plt\n",
"import matplotlib\n",
"from sklearn.decomposition import PCA\n",
"from sklearn.metrics import silhouette_samples, silhouette_score\n",
"import matplotlib.cm as cm\n",
"from sklearn.preprocessing import StandardScaler\n",
"from sklearn.model_selection import train_test_split\n",
"from sklearn.preprocessing import OneHotEncoder\n",
"from sklearn.ensemble import RandomForestClassifier\n",
"from sklearn.ensemble import GradientBoostingClassifier\n",
"from sklearn.metrics import confusion_matrix, classification_report,
accuracy_score"
]
},
{
"cell_type": "code",
"execution_count": 2,
"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>X</th>\n",
" <th>Y</th>\n",
" <th>Index_</th>\n",
" <th>event_unique_id</th>\n",
" <th>occurrencedate</th>\n",
" <th>reporteddate</th>\n",
" <th>premisetype</th>\n",
" <th>ucr_code</th>\n",
" <th>ucr_ext</th>\n",
" <th>offence</th>\n",
" <th>...</th>\n",
" <th>occurrencedayofweek</th>\n",
" <th>occurrencehour</th>\n",
" <th>MCI</th>\n",
" <th>Division</th>\n",
" <th>Hood_ID</th>\n",
" <th>Neighbourhood</th>\n",
" <th>Long</th>\n",
" <th>Lat</th>\n",
" <th>ObjectId</th>\n",
" <th>Total</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>-79.405228</td>\n",
" <td>43.656982</td>\n",
" <td>7801</td>\n",
" <td>GO-20152165447</td>\n",
" <td>2015-12-18T03:58:00.000Z</td>\n",
" <td>2015-12-18T03:59:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Friday</td>\n",
" <td>3</td>\n",
" <td>Assault</td>\n",
" <td>D14</td>\n",
" <td>79</td>\n",
" <td>University (79)</td>\n",
" <td>-79.405228</td>\n",
" <td>43.656982</td>\n",
" <td>7001</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>-79.307907</td>\n",
" <td>43.778732</td>\n",
" <td>7802</td>\n",
" <td>GO-20151417245</td>\n",
" <td>2015-08-15T21:45:00.000Z</td>\n",
" <td>2015-08-17T22:11:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Saturday</td>\n",
" <td>21</td>\n",
" <td>Assault</td>\n",
" <td>D42</td>\n",
" <td>118</td>\n",
" <td>Tam O'Shanter-Sullivan (118)</td>\n",
" <td>-79.307907</td>\n",
" <td>43.778732</td>\n",
" <td>7002</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>-79.225029</td>\n",
" <td>43.765942</td>\n",
" <td>7803</td>\n",
" <td>GO-20151421107</td>\n",
" <td>2015-08-16T16:00:00.000Z</td>\n",
" <td>2015-08-18T14:40:00.000Z</td>\n",
" <td>Apartment</td>\n",
" <td>2120</td>\n",
" <td>200</td>\n",
" <td>B&E</td>\n",
" <td>...</td>\n",
" <td>Sunday</td>\n",
" <td>16</td>\n",
" <td>Break and Enter</td>\n",
" <td>D43</td>\n",
" <td>137</td>\n",
" <td>Woburn (137)</td>\n",
" <td>-79.225029</td>\n",
" <td>43.765942</td>\n",
" <td>7003</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>-79.140823</td>\n",
" <td>43.778648</td>\n",
" <td>7804</td>\n",
" <td>GO-20152167714</td>\n",
" <td>2015-11-26T13:00:00.000Z</td>\n",
" <td>2015-12-18T13:38:00.000Z</td>\n",
" <td>Other</td>\n",
" <td>2120</td>\n",
" <td>200</td>\n",
" <td>B&E</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>13</td>\n",
" <td>Break and Enter</td>\n",
" <td>D43</td>\n",
" <td>133</td>\n",
" <td>Centennial Scarborough (133)</td>\n",
" <td>-79.140823</td>\n",
" <td>43.778648</td>\n",
" <td>7004</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>-79.288361</td>\n",
" <td>43.691235</td>\n",
" <td>7805</td>\n",
" <td>GO-20152169954</td>\n",
" <td>2015-12-18T19:50:00.000Z</td>\n",
" <td>2015-12-18T19:55:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Friday</td>\n",
" <td>19</td>\n",
" <td>Assault</td>\n",
" <td>D55</td>\n",
" <td>61</td>\n",
" <td>Taylor-Massey (61)</td>\n",
" <td>-79.288361</td>\n",
" <td>43.691235</td>\n",
" <td>7005</td>\n",
" <td>1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 30 columns</p>\n",
"</div>"
],
"text/plain": [
" X Y Index_ event_unique_id
occurrencedate \\\n",
"0 -79.405228 43.656982 7801 GO-20152165447 2015-12-18T03:58:00.000Z
\n",
"1 -79.307907 43.778732 7802 GO-20151417245 2015-08-15T21:45:00.000Z
\n",
"2 -79.225029 43.765942 7803 GO-20151421107 2015-08-16T16:00:00.000Z
\n",
"3 -79.140823 43.778648 7804 GO-20152167714 2015-11-26T13:00:00.000Z
\n",
"4 -79.288361 43.691235 7805 GO-20152169954 2015-12-18T19:50:00.000Z
\n",
"\n",
" reporteddate premisetype ucr_code ucr_ext
offence ... \\\n",
"0 2015-12-18T03:59:00.000Z Commercial 1430 100
Assault ... \n",
"1 2015-08-17T22:11:00.000Z Commercial 1430 100
Assault ... \n",
"2 2015-08-18T14:40:00.000Z Apartment 2120 200
B&E ... \n",
"3 2015-12-18T13:38:00.000Z Other 2120 200
B&E ... \n",
"4 2015-12-18T19:55:00.000Z Commercial 1430 100
Assault ... \n",
"\n",
" occurrencedayofweek occurrencehour MCI Division
Hood_ID \\\n",
"0 Friday 3 Assault D14
79 \n",
"1 Saturday 21 Assault D42
118 \n",
"2 Sunday 16 Break and Enter D43
137 \n",
"3 Thursday 13 Break and Enter D43
133 \n",
"4 Friday 19 Assault D55
61 \n",
"\n",
" Neighbourhood Long Lat ObjectId Total \
n",
"0 University (79) -79.405228 43.656982 7001 1 \
n",
"1 Tam O'Shanter-Sullivan (118) -79.307907 43.778732 7002 1 \
n",
"2 Woburn (137) -79.225029 43.765942 7003 1 \
n",
"3 Centennial Scarborough (133) -79.140823 43.778648 7004 1 \
n",
"4 Taylor-Massey (61) -79.288361 43.691235 7005 1 \
n",
"\n",
"[5 rows x 30 columns]"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df=pd.read_csv(\"C:/Users/KIIT/Downloads/MCI_2014_to_2019.csv\")\n",
"df['Total'] = 1\n",
"df.head()"
]
},
{
"cell_type": "code",
"execution_count": 3,
"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>X</th>\n",
" <th>Y</th>\n",
" <th>Index_</th>\n",
" <th>event_unique_id</th>\n",
" <th>occurrencedate</th>\n",
" <th>reporteddate</th>\n",
" <th>premisetype</th>\n",
" <th>ucr_code</th>\n",
" <th>ucr_ext</th>\n",
" <th>offence</th>\n",
" <th>...</th>\n",
" <th>occurrencedayofweek</th>\n",
" <th>occurrencehour</th>\n",
" <th>MCI</th>\n",
" <th>Division</th>\n",
" <th>Hood_ID</th>\n",
" <th>Neighbourhood</th>\n",
" <th>Long</th>\n",
" <th>Lat</th>\n",
" <th>ObjectId</th>\n",
" <th>Total</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>-79.405228</td>\n",
" <td>43.656982</td>\n",
" <td>7801</td>\n",
" <td>GO-20152165447</td>\n",
" <td>2015-12-18T03:58:00.000Z</td>\n",
" <td>2015-12-18T03:59:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Friday</td>\n",
" <td>3</td>\n",
" <td>Assault</td>\n",
" <td>D14</td>\n",
" <td>79</td>\n",
" <td>University (79)</td>\n",
" <td>-79.405228</td>\n",
" <td>43.656982</td>\n",
" <td>7001</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>-79.307907</td>\n",
" <td>43.778732</td>\n",
" <td>7802</td>\n",
" <td>GO-20151417245</td>\n",
" <td>2015-08-15T21:45:00.000Z</td>\n",
" <td>2015-08-17T22:11:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Saturday</td>\n",
" <td>21</td>\n",
" <td>Assault</td>\n",
" <td>D42</td>\n",
" <td>118</td>\n",
" <td>Tam O'Shanter-Sullivan (118)</td>\n",
" <td>-79.307907</td>\n",
" <td>43.778732</td>\n",
" <td>7002</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>-79.225029</td>\n",
" <td>43.765942</td>\n",
" <td>7803</td>\n",
" <td>GO-20151421107</td>\n",
" <td>2015-08-16T16:00:00.000Z</td>\n",
" <td>2015-08-18T14:40:00.000Z</td>\n",
" <td>Apartment</td>\n",
" <td>2120</td>\n",
" <td>200</td>\n",
" <td>B&E</td>\n",
" <td>...</td>\n",
" <td>Sunday</td>\n",
" <td>16</td>\n",
" <td>Break and Enter</td>\n",
" <td>D43</td>\n",
" <td>137</td>\n",
" <td>Woburn (137)</td>\n",
" <td>-79.225029</td>\n",
" <td>43.765942</td>\n",
" <td>7003</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>-79.140823</td>\n",
" <td>43.778648</td>\n",
" <td>7804</td>\n",
" <td>GO-20152167714</td>\n",
" <td>2015-11-26T13:00:00.000Z</td>\n",
" <td>2015-12-18T13:38:00.000Z</td>\n",
" <td>Other</td>\n",
" <td>2120</td>\n",
" <td>200</td>\n",
" <td>B&E</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>13</td>\n",
" <td>Break and Enter</td>\n",
" <td>D43</td>\n",
" <td>133</td>\n",
" <td>Centennial Scarborough (133)</td>\n",
" <td>-79.140823</td>\n",
" <td>43.778648</td>\n",
" <td>7004</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>-79.288361</td>\n",
" <td>43.691235</td>\n",
" <td>7805</td>\n",
" <td>GO-20152169954</td>\n",
" <td>2015-12-18T19:50:00.000Z</td>\n",
" <td>2015-12-18T19:55:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Friday</td>\n",
" <td>19</td>\n",
" <td>Assault</td>\n",
" <td>D55</td>\n",
" <td>61</td>\n",
" <td>Taylor-Massey (61)</td>\n",
" <td>-79.288361</td>\n",
" <td>43.691235</td>\n",
" <td>7005</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>-79.353310</td>\n",
" <td>43.688553</td>\n",
" <td>7806</td>\n",
" <td>GO-20152123146</td>\n",
" <td>2015-04-10T10:00:00.000Z</td>\n",
" <td>2015-12-11T14:27:00.000Z</td>\n",
" <td>Apartment</td>\n",
" <td>2120</td>\n",
" <td>200</td>\n",
" <td>B&E</td>\n",
" <td>...</td>\n",
" <td>Friday</td>\n",
" <td>10</td>\n",
" <td>Break and Enter</td>\n",
" <td>D54</td>\n",
" <td>57</td>\n",
" <td>Broadview North (57)</td>\n",
" <td>-79.353310</td>\n",
" <td>43.688553</td>\n",
" <td>7006</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>-79.380806</td>\n",
" <td>43.649895</td>\n",
" <td>7807</td>\n",
" <td>GO-20152143239</td>\n",
" <td>2015-12-14T21:00:00.000Z</td>\n",
" <td>2015-12-16T18:32:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>21</td>\n",
" <td>Assault</td>\n",
" <td>D52</td>\n",
" <td>76</td>\n",
" <td>Bay Street Corridor (76)</td>\n",
" <td>-79.380806</td>\n",
" <td>43.649895</td>\n",
" <td>7007</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>-79.380806</td>\n",
" <td>43.649895</td>\n",
" <td>7808</td>\n",
" <td>GO-20152143239</td>\n",
" <td>2015-12-14T21:00:00.000Z</td>\n",
" <td>2015-12-16T18:32:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>21</td>\n",
" <td>Assault</td>\n",
" <td>D52</td>\n",
" <td>76</td>\n",
" <td>Bay Street Corridor (76)</td>\n",
" <td>-79.380806</td>\n",
" <td>43.649895</td>\n",
" <td>7008</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>-79.380806</td>\n",
" <td>43.649895</td>\n",
" <td>7809</td>\n",
" <td>GO-20152143239</td>\n",
" <td>2015-12-14T21:00:00.000Z</td>\n",
" <td>2015-12-16T18:32:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>21</td>\n",
" <td>Assault</td>\n",
" <td>D52</td>\n",
" <td>76</td>\n",
" <td>Bay Street Corridor (76)</td>\n",
" <td>-79.380806</td>\n",
" <td>43.649895</td>\n",
" <td>7009</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>-79.386780</td>\n",
" <td>43.663361</td>\n",
" <td>7810</td>\n",
" <td>GO-20151970205</td>\n",
" <td>2015-11-17T01:20:00.000Z</td>\n",
" <td>2015-11-17T02:43:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>1610</td>\n",
" <td>160</td>\n",
" <td>Robbery - Taxi</td>\n",
" <td>...</td>\n",
" <td>Tuesday</td>\n",
" <td>1</td>\n",
" <td>Robbery</td>\n",
" <td>D52</td>\n",
" <td>76</td>\n",
" <td>Bay Street Corridor (76)</td>\n",
" <td>-79.386780</td>\n",
" <td>43.663361</td>\n",
" <td>7010</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>-79.611320</td>\n",
" <td>43.710689</td>\n",
" <td>7811</td>\n",
" <td>GO-20151976877</td>\n",
" <td>2015-11-18T05:35:00.000Z</td>\n",
" <td>2015-11-18T05:42:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>1480</td>\n",
" <td>100</td>\n",
" <td>Assault - Resist/ Prevent Seiz</td>\n",
" <td>...</td>\n",
" <td>Wednesday</td>\n",
" <td>5</td>\n",
" <td>Assault</td>\n",
" <td>D23</td>\n",
" <td>1</td>\n",
" <td>West Humber-Clairville (1)</td>\n",
" <td>-79.611320</td>\n",
" <td>43.710690</td>\n",
" <td>7011</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>-79.436020</td>\n",
" <td>43.698772</td>\n",
" <td>7812</td>\n",
" <td>GO-20152060024</td>\n",
" <td>2015-12-01T15:10:00.000Z</td>\n",
" <td>2015-12-01T15:20:00.000Z</td>\n",
" <td>Other</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Tuesday</td>\n",
" <td>15</td>\n",
" <td>Assault</td>\n",
" <td>D13</td>\n",
" <td>102</td>\n",
" <td>Forest Hill North (102)</td>\n",
" <td>-79.436020</td>\n",
" <td>43.698772</td>\n",
" <td>7012</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>-79.508636</td>\n",
" <td>43.720917</td>\n",
" <td>7813</td>\n",
" <td>GO-20152061875</td>\n",
" <td>2015-12-01T22:19:00.000Z</td>\n",
" <td>2015-12-01T22:19:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Tuesday</td>\n",
" <td>22</td>\n",
" <td>Assault</td>\n",
" <td>D31</td>\n",
" <td>26</td>\n",
" <td>Downsview-Roding-CFB (26)</td>\n",
" <td>-79.508636</td>\n",
" <td>43.720917</td>\n",
" <td>7013</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>-79.416420</td>\n",
" <td>43.735794</td>\n",
" <td>7814</td>\n",
" <td>GO-20152100410</td>\n",
" <td>2015-12-08T06:24:00.000Z</td>\n",
" <td>2015-12-08T06:24:00.000Z</td>\n",
" <td>House</td>\n",
" <td>2120</td>\n",
" <td>200</td>\n",
" <td>B&E</td>\n",
" <td>...</td>\n",
" <td>Tuesday</td>\n",
" <td>6</td>\n",
" <td>Break and Enter</td>\n",
" <td>D32</td>\n",
" <td>39</td>\n",
" <td>Bedford Park-Nortown (39)</td>\n",
" <td>-79.416420</td>\n",
" <td>43.735794</td>\n",
" <td>7014</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>-79.209801</td>\n",
" <td>43.814213</td>\n",
" <td>7815</td>\n",
" <td>GO-20152101269</td>\n",
" <td>2015-12-08T09:15:00.000Z</td>\n",
" <td>2015-12-08T09:27:00.000Z</td>\n",
" <td>Other</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Tuesday</td>\n",
" <td>9</td>\n",
" <td>Assault</td>\n",
" <td>D42</td>\n",
" <td>132</td>\n",
" <td>Malvern (132)</td>\n",
" <td>-79.209801</td>\n",
" <td>43.814213</td>\n",
" <td>7015</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>-79.359757</td>\n",
" <td>43.650761</td>\n",
" <td>7816</td>\n",
" <td>GO-20152122687</td>\n",
" <td>2015-12-11T13:15:00.000Z</td>\n",
" <td>2015-12-11T13:45:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Friday</td>\n",
" <td>13</td>\n",
" <td>Assault</td>\n",
" <td>D51</td>\n",
" <td>77</td>\n",
" <td>Waterfront Communities-The Island (77)</td>\n",
" <td>-79.359756</td>\n",
" <td>43.650761</td>\n",
" <td>7016</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>-79.237289</td>\n",
" <td>43.736679</td>\n",
" <td>7817</td>\n",
" <td>GO-20152156376</td>\n",
" <td>2015-12-16T16:50:00.000Z</td>\n",
" <td>2015-12-16T16:53:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Wednesday</td>\n",
" <td>16</td>\n",
" <td>Assault</td>\n",
" <td>D43</td>\n",
" <td>138</td>\n",
" <td>Eglinton East (138)</td>\n",
" <td>-79.237289</td>\n",
" <td>43.736679</td>\n",
" <td>7017</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>-79.565308</td>\n",
" <td>43.737240</td>\n",
" <td>7818</td>\n",
" <td>GO-20152156790</td>\n",
" <td>2015-12-16T17:00:00.000Z</td>\n",
" <td>2015-12-16T19:29:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Wednesday</td>\n",
" <td>17</td>\n",
" <td>Assault</td>\n",
" <td>D23</td>\n",
" <td>3</td>\n",
" <td>Thistletown-Beaumond Heights (3)</td>\n",
" <td>-79.565308</td>\n",
" <td>43.737240</td>\n",
" <td>7018</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>-79.240952</td>\n",
" <td>43.766937</td>\n",
" <td>7819</td>\n",
" <td>GO-20152157945</td>\n",
" <td>2015-12-16T10:00:00.000Z</td>\n",
" <td>2015-12-16T22:18:00.000Z</td>\n",
" <td>House</td>\n",
" <td>2120</td>\n",
" <td>200</td>\n",
" <td>B&E</td>\n",
" <td>...</td>\n",
" <td>Wednesday</td>\n",
" <td>10</td>\n",
" <td>Break and Enter</td>\n",
" <td>D43</td>\n",
" <td>137</td>\n",
" <td>Woburn (137)</td>\n",
" <td>-79.240952</td>\n",
" <td>43.766937</td>\n",
" <td>7019</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>-79.395432</td>\n",
" <td>43.671902</td>\n",
" <td>7820</td>\n",
" <td>GO-20152160331</td>\n",
" <td>2015-12-16T21:00:00.000Z</td>\n",
" <td>2015-12-17T10:26:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>2120</td>\n",
" <td>200</td>\n",
" <td>B&E</td>\n",
" <td>...</td>\n",
" <td>Wednesday</td>\n",
" <td>21</td>\n",
" <td>Break and Enter</td>\n",
" <td>D53</td>\n",
" <td>95</td>\n",
" <td>Annex (95)</td>\n",
" <td>-79.395432</td>\n",
" <td>43.671902</td>\n",
" <td>7020</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>-79.261574</td>\n",
" <td>43.811119</td>\n",
" <td>7821</td>\n",
" <td>GO-20152161385</td>\n",
" <td>2015-12-17T12:30:00.000Z</td>\n",
" <td>2015-12-17T13:17:00.000Z</td>\n",
" <td>House</td>\n",
" <td>2120</td>\n",
" <td>200</td>\n",
" <td>B&E</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>12</td>\n",
" <td>Break and Enter</td>\n",
" <td>D42</td>\n",
" <td>129</td>\n",
" <td>Agincourt North (129)</td>\n",
" <td>-79.261574</td>\n",
" <td>43.811119</td>\n",
" <td>7021</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>-79.216789</td>\n",
" <td>43.760220</td>\n",
" <td>7822</td>\n",
" <td>GO-20152163999</td>\n",
" <td>2015-12-17T20:56:00.000Z</td>\n",
" <td>2015-12-17T20:56:00.000Z</td>\n",
" <td>Apartment</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>20</td>\n",
" <td>Assault</td>\n",
" <td>D43</td>\n",
" <td>137</td>\n",
" <td>Woburn (137)</td>\n",
" <td>-79.216789</td>\n",
" <td>43.760220</td>\n",
" <td>7022</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>-79.299347</td>\n",
" <td>43.783596</td>\n",
" <td>7823</td>\n",
" <td>GO-20152163291</td>\n",
" <td>2015-12-17T11:40:00.000Z</td>\n",
" <td>2015-12-17T18:29:00.000Z</td>\n",
" <td>Other</td>\n",
" <td>1610</td>\n",
" <td>200</td>\n",
" <td>Robbery - Mugging</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>11</td>\n",
" <td>Robbery</td>\n",
" <td>D42</td>\n",
" <td>118</td>\n",
" <td>Tam O'Shanter-Sullivan (118)</td>\n",
" <td>-79.299347</td>\n",
" <td>43.783596</td>\n",
" <td>7023</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>-79.371635</td>\n",
" <td>43.768021</td>\n",
" <td>7824</td>\n",
" <td>GO-20152164454</td>\n",
" <td>2015-12-17T22:35:00.000Z</td>\n",
" <td>2015-12-17T22:35:00.000Z</td>\n",
" <td>Apartment</td>\n",
" <td>1450</td>\n",
" <td>100</td>\n",
" <td>Discharge Firearm - Recklessly</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>22</td>\n",
" <td>Assault</td>\n",
" <td>D33</td>\n",
" <td>52</td>\n",
" <td>Bayview Village (52)</td>\n",
" <td>-79.371635</td>\n",
" <td>43.768021</td>\n",
" <td>7024</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>-79.371635</td>\n",
" <td>43.768021</td>\n",
" <td>7825</td>\n",
" <td>GO-20152164454</td>\n",
" <td>2015-12-17T22:35:00.000Z</td>\n",
" <td>2015-12-17T22:35:00.000Z</td>\n",
" <td>Apartment</td>\n",
" <td>1457</td>\n",
" <td>100</td>\n",
" <td>Pointing A Firearm</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>22</td>\n",
" <td>Assault</td>\n",
" <td>D33</td>\n",
" <td>52</td>\n",
" <td>Bayview Village (52)</td>\n",
" <td>-79.371635</td>\n",
" <td>43.768021</td>\n",
" <td>7025</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>-79.371635</td>\n",
" <td>43.768021</td>\n",
" <td>7826</td>\n",
" <td>GO-20152164454</td>\n",
" <td>2015-12-17T22:35:00.000Z</td>\n",
" <td>2015-12-17T22:35:00.000Z</td>\n",
" <td>Apartment</td>\n",
" <td>1410</td>\n",
" <td>100</td>\n",
" <td>Aggravated Assault</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>22</td>\n",
" <td>Assault</td>\n",
" <td>D33</td>\n",
" <td>52</td>\n",
" <td>Bayview Village (52)</td>\n",
" <td>-79.371635</td>\n",
" <td>43.768021</td>\n",
" <td>7026</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>-79.399284</td>\n",
" <td>43.710915</td>\n",
" <td>7827</td>\n",
" <td>GO-20152171677</td>\n",
" <td>2015-12-19T02:15:00.000Z</td>\n",
" <td>2015-12-19T02:37:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>1420</td>\n",
" <td>100</td>\n",
" <td>Assault With Weapon</td>\n",
" <td>...</td>\n",
" <td>Saturday</td>\n",
" <td>2</td>\n",
" <td>Assault</td>\n",
" <td>D53</td>\n",
" <td>104</td>\n",
" <td>Mount Pleasant West (104)</td>\n",
" <td>-79.399284</td>\n",
" <td>43.710915</td>\n",
" <td>7027</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>-79.566063</td>\n",
" <td>43.760590</td>\n",
" <td>7828</td>\n",
" <td>GO-20152173351</td>\n",
" <td>2015-12-19T11:25:00.000Z</td>\n",
" <td>2015-12-19T11:32:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Saturday</td>\n",
" <td>11</td>\n",
" <td>Assault</td>\n",
" <td>D31</td>\n",
" <td>21</td>\n",
" <td>Humber Summit (21)</td>\n",
" <td>-79.566063</td>\n",
" <td>43.760590</td>\n",
" <td>7028</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>-79.444336</td>\n",
" <td>43.694447</td>\n",
" <td>7829</td>\n",
" <td>GO-20152171258</td>\n",
" <td>2015-12-19T00:44:00.000Z</td>\n",
" <td>2015-12-19T00:44:00.000Z</td>\n",
" <td>House</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Saturday</td>\n",
" <td>0</td>\n",
" <td>Assault</td>\n",
" <td>D13</td>\n",
" <td>107</td>\n",
" <td>Oakwood Village (107)</td>\n",
" <td>-79.444336</td>\n",
" <td>43.694447</td>\n",
" <td>7029</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>-79.278267</td>\n",
" <td>43.699040</td>\n",
" <td>7830</td>\n",
" <td>GO-20152211650</td>\n",
" <td>2015-12-26T15:00:00.000Z</td>\n",
" <td>2015-12-26T15:37:00.000Z</td>\n",
" <td>Other</td>\n",
" <td>1430</td>\n",
" <td>100</td>\n",
" <td>Assault</td>\n",
" <td>...</td>\n",
" <td>Saturday</td>\n",
" <td>15</td>\n",
" <td>Assault</td>\n",
" <td>D41</td>\n",
" <td>121</td>\n",
" <td>Oakridge (121)</td>\n",
" <td>-79.278267</td>\n",
" <td>43.699040</td>\n",
" <td>7030</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206405</th>\n",
" <td>-79.523819</td>\n",
" <td>43.645512</td>\n",
" <td>205871</td>\n",
" <td>GO-2019189499</td>\n",
" <td>2019-01-30T06:00:00.000Z</td>\n",
" <td>2019-01-30T17:31:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Wednesday</td>\n",
" <td>6</td>\n",
" <td>Auto Theft</td>\n",
" <td>D22</td>\n",
" <td>14</td>\n",
" <td>Islington-City Centre West (14)</td>\n",
" <td>-79.523819</td>\n",
" <td>43.645512</td>\n",
" <td>205971</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206406</th>\n",
" <td>-79.282257</td>\n",
" <td>43.802719</td>\n",
" <td>205872</td>\n",
" <td>GO-2019185627</td>\n",
" <td>2019-01-30T07:30:00.000Z</td>\n",
" <td>2019-01-30T08:35:00.000Z</td>\n",
" <td>House</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Wednesday</td>\n",
" <td>7</td>\n",
" <td>Auto Theft</td>\n",
" <td>D42</td>\n",
" <td>129</td>\n",
" <td>Agincourt North (129)</td>\n",
" <td>-79.282257</td>\n",
" <td>43.802719</td>\n",
" <td>205972</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206407</th>\n",
" <td>-79.397644</td>\n",
" <td>43.651878</td>\n",
" <td>205873</td>\n",
" <td>GO-2019268213</td>\n",
" <td>2019-02-11T18:21:00.000Z</td>\n",
" <td>2019-02-11T18:48:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>18</td>\n",
" <td>Auto Theft</td>\n",
" <td>D52</td>\n",
" <td>78</td>\n",
" <td>Kensington-Chinatown (78)</td>\n",
" <td>-79.397644</td>\n",
" <td>43.651878</td>\n",
" <td>205973</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206408</th>\n",
" <td>-79.587303</td>\n",
" <td>43.689518</td>\n",
" <td>205874</td>\n",
" <td>GO-2019276888</td>\n",
" <td>2019-02-11T22:30:00.000Z</td>\n",
" <td>2019-02-13T09:36:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>22</td>\n",
" <td>Auto Theft</td>\n",
" <td>D23</td>\n",
" <td>1</td>\n",
" <td>West Humber-Clairville (1)</td>\n",
" <td>-79.587303</td>\n",
" <td>43.689518</td>\n",
" <td>205974</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206409</th>\n",
" <td>-79.496696</td>\n",
" <td>43.751942</td>\n",
" <td>205875</td>\n",
" <td>GO-2019271066</td>\n",
" <td>2019-02-11T18:00:00.000Z</td>\n",
" <td>2019-02-12T09:12:00.000Z</td>\n",
" <td>House</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>18</td>\n",
" <td>Auto Theft</td>\n",
" <td>D31</td>\n",
" <td>27</td>\n",
" <td>York University Heights (27)</td>\n",
" <td>-79.496696</td>\n",
" <td>43.751942</td>\n",
" <td>205975</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206410</th>\n",
" <td>-79.383110</td>\n",
" <td>43.661373</td>\n",
" <td>205876</td>\n",
" <td>GO-2019283348</td>\n",
" <td>2019-02-11T23:00:00.000Z</td>\n",
" <td>2019-02-14T09:30:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>23</td>\n",
" <td>Auto Theft</td>\n",
" <td>D52</td>\n",
" <td>76</td>\n",
" <td>Bay Street Corridor (76)</td>\n",
" <td>-79.383110</td>\n",
" <td>43.661373</td>\n",
" <td>205976</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206411</th>\n",
" <td>-79.285736</td>\n",
" <td>43.723293</td>\n",
" <td>205877</td>\n",
" <td>GO-2019373647</td>\n",
" <td>2019-02-11T12:00:00.000Z</td>\n",
" <td>2019-02-28T10:28:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>12</td>\n",
" <td>Auto Theft</td>\n",
" <td>D41</td>\n",
" <td>120</td>\n",
" <td>Clairlea-Birchmount (120)</td>\n",
" <td>-79.285736</td>\n",
" <td>43.723293</td>\n",
" <td>205977</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206412</th>\n",
" <td>-79.603462</td>\n",
" <td>43.719158</td>\n",
" <td>205878</td>\n",
" <td>GO-2019274360</td>\n",
" <td>2019-02-11T22:00:00.000Z</td>\n",
" <td>2019-02-12T20:33:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>22</td>\n",
" <td>Auto Theft</td>\n",
" <td>D23</td>\n",
" <td>1</td>\n",
" <td>West Humber-Clairville (1)</td>\n",
" <td>-79.603462</td>\n",
" <td>43.719158</td>\n",
" <td>205978</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206413</th>\n",
" <td>-79.572487</td>\n",
" <td>43.717022</td>\n",
" <td>205879</td>\n",
" <td>GO-2019264057</td>\n",
" <td>2019-02-11T01:08:00.000Z</td>\n",
" <td>2019-02-11T07:20:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>1</td>\n",
" <td>Auto Theft</td>\n",
" <td>D23</td>\n",
" <td>1</td>\n",
" <td>West Humber-Clairville (1)</td>\n",
" <td>-79.572487</td>\n",
" <td>43.717022</td>\n",
" <td>205979</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206414</th>\n",
" <td>-79.534798</td>\n",
" <td>43.731228</td>\n",
" <td>205880</td>\n",
" <td>GO-2019270799</td>\n",
" <td>2019-02-11T20:00:00.000Z</td>\n",
" <td>2019-02-12T08:11:00.000Z</td>\n",
" <td>House</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>20</td>\n",
" <td>Auto Theft</td>\n",
" <td>D31</td>\n",
" <td>23</td>\n",
" <td>Pelmo Park-Humberlea (23)</td>\n",
" <td>-79.534798</td>\n",
" <td>43.731228</td>\n",
" <td>205980</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206415</th>\n",
" <td>-79.600998</td>\n",
" <td>43.734634</td>\n",
" <td>205881</td>\n",
" <td>GO-2019388262</td>\n",
" <td>2019-02-11T09:00:00.000Z</td>\n",
" <td>2019-03-02T13:37:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>9</td>\n",
" <td>Auto Theft</td>\n",
" <td>D23</td>\n",
" <td>1</td>\n",
" <td>West Humber-Clairville (1)</td>\n",
" <td>-79.600998</td>\n",
" <td>43.734634</td>\n",
" <td>205981</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206416</th>\n",
" <td>-79.504761</td>\n",
" <td>43.715744</td>\n",
" <td>205882</td>\n",
" <td>GO-2019266716</td>\n",
" <td>2019-02-11T13:40:00.000Z</td>\n",
" <td>2019-02-11T14:59:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>13</td>\n",
" <td>Auto Theft</td>\n",
" <td>D12</td>\n",
" <td>28</td>\n",
" <td>Rustic (28)</td>\n",
" <td>-79.504761</td>\n",
" <td>43.715744</td>\n",
" <td>205982</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206417</th>\n",
" <td>-79.597511</td>\n",
" <td>43.740971</td>\n",
" <td>205883</td>\n",
" <td>GO-2019264425</td>\n",
" <td>2019-02-11T08:15:00.000Z</td>\n",
" <td>2019-02-11T08:47:00.000Z</td>\n",
" <td>House</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>8</td>\n",
" <td>Auto Theft</td>\n",
" <td>D23</td>\n",
" <td>1</td>\n",
" <td>West Humber-Clairville (1)</td>\n",
" <td>-79.597511</td>\n",
" <td>43.740971</td>\n",
" <td>205983</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206418</th>\n",
" <td>-79.418137</td>\n",
" <td>43.790256</td>\n",
" <td>205884</td>\n",
" <td>GO-2019265391</td>\n",
" <td>2019-02-11T10:30:00.000Z</td>\n",
" <td>2019-02-11T11:20:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>10</td>\n",
" <td>Auto Theft</td>\n",
" <td>D32</td>\n",
" <td>50</td>\n",
" <td>Newtonbrook East (50)</td>\n",
" <td>-79.418137</td>\n",
" <td>43.790256</td>\n",
" <td>205984</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206419</th>\n",
" <td>-79.428543</td>\n",
" <td>43.794479</td>\n",
" <td>205885</td>\n",
" <td>GO-2019273094</td>\n",
" <td>2019-02-11T15:00:00.000Z</td>\n",
" <td>2019-02-12T15:50:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>15</td>\n",
" <td>Auto Theft</td>\n",
" <td>D32</td>\n",
" <td>36</td>\n",
" <td>Newtonbrook West (36)</td>\n",
" <td>-79.428543</td>\n",
" <td>43.794479</td>\n",
" <td>205985</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206420</th>\n",
" <td>-79.377144</td>\n",
" <td>43.656502</td>\n",
" <td>205886</td>\n",
" <td>GO-2019267805</td>\n",
" <td>2019-02-11T00:01:00.000Z</td>\n",
" <td>2019-02-11T18:04:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Monday</td>\n",
" <td>0</td>\n",
" <td>Auto Theft</td>\n",
" <td>D51</td>\n",
" <td>75</td>\n",
" <td>Church-Yonge Corridor (75)</td>\n",
" <td>-79.377144</td>\n",
" <td>43.656502</td>\n",
" <td>205986</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206421</th>\n",
" <td>-79.268341</td>\n",
" <td>43.814259</td>\n",
" <td>205887</td>\n",
" <td>GO-2019326856</td>\n",
" <td>2019-02-21T06:30:00.000Z</td>\n",
" <td>2019-02-21T06:54:00.000Z</td>\n",
" <td>House</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>6</td>\n",
" <td>Auto Theft</td>\n",
" <td>D42</td>\n",
" <td>129</td>\n",
" <td>Agincourt North (129)</td>\n",
" <td>-79.268341</td>\n",
" <td>43.814259</td>\n",
" <td>205987</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206422</th>\n",
" <td>-79.428535</td>\n",
" <td>43.789856</td>\n",
" <td>205888</td>\n",
" <td>GO-2019327062</td>\n",
" <td>2019-02-21T07:40:00.000Z</td>\n",
" <td>2019-02-21T07:44:00.000Z</td>\n",
" <td>House</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>7</td>\n",
" <td>Auto Theft</td>\n",
" <td>D32</td>\n",
" <td>36</td>\n",
" <td>Newtonbrook West (36)</td>\n",
" <td>-79.428535</td>\n",
" <td>43.789856</td>\n",
" <td>205988</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206423</th>\n",
" <td>-79.564438</td>\n",
" <td>43.670914</td>\n",
" <td>205889</td>\n",
" <td>GO-2019333586</td>\n",
" <td>2019-02-21T21:30:00.000Z</td>\n",
" <td>2019-02-22T06:00:00.000Z</td>\n",
" <td>House</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>21</td>\n",
" <td>Auto Theft</td>\n",
" <td>D22</td>\n",
" <td>11</td>\n",
" <td>Eringate-Centennial-West Deane (11)</td>\n",
" <td>-79.564438</td>\n",
" <td>43.670914</td>\n",
" <td>205989</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206424</th>\n",
" <td>-79.365318</td>\n",
" <td>43.745293</td>\n",
" <td>205890</td>\n",
" <td>GO-2019335865</td>\n",
" <td>2019-02-21T20:00:00.000Z</td>\n",
" <td>2019-02-22T13:04:00.000Z</td>\n",
" <td>House</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>20</td>\n",
" <td>Auto Theft</td>\n",
" <td>D33</td>\n",
" <td>42</td>\n",
" <td>Banbury-Don Mills (42)</td>\n",
" <td>-79.365318</td>\n",
" <td>43.745293</td>\n",
" <td>205990</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206425</th>\n",
" <td>-79.464493</td>\n",
" <td>43.668125</td>\n",
" <td>205891</td>\n",
" <td>GO-2019332516</td>\n",
" <td>2019-02-21T20:30:00.000Z</td>\n",
" <td>2019-02-21T22:42:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>20</td>\n",
" <td>Auto Theft</td>\n",
" <td>D11</td>\n",
" <td>90</td>\n",
" <td>Junction Area (90)</td>\n",
" <td>-79.464493</td>\n",
" <td>43.668125</td>\n",
" <td>205991</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206426</th>\n",
" <td>-79.614281</td>\n",
" <td>43.745495</td>\n",
" <td>205892</td>\n",
" <td>GO-2019399759</td>\n",
" <td>2019-02-21T12:44:00.000Z</td>\n",
" <td>2019-03-04T10:19:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>12</td>\n",
" <td>Auto Theft</td>\n",
" <td>D23</td>\n",
" <td>1</td>\n",
" <td>West Humber-Clairville (1)</td>\n",
" <td>-79.614281</td>\n",
" <td>43.745495</td>\n",
" <td>205992</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206427</th>\n",
" <td>-79.500000</td>\n",
" <td>43.761066</td>\n",
" <td>205893</td>\n",
" <td>GO-2019331091</td>\n",
" <td>2019-02-21T08:00:00.000Z</td>\n",
" <td>2019-02-21T17:59:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>8</td>\n",
" <td>Auto Theft</td>\n",
" <td>D31</td>\n",
" <td>27</td>\n",
" <td>York University Heights (27)</td>\n",
" <td>-79.500000</td>\n",
" <td>43.761066</td>\n",
" <td>205993</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206428</th>\n",
" <td>-79.593422</td>\n",
" <td>43.738930</td>\n",
" <td>205894</td>\n",
" <td>GO-2019333589</td>\n",
" <td>2019-02-21T23:45:00.000Z</td>\n",
" <td>2019-02-22T06:00:00.000Z</td>\n",
" <td>House</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>23</td>\n",
" <td>Auto Theft</td>\n",
" <td>D23</td>\n",
" <td>1</td>\n",
" <td>West Humber-Clairville (1)</td>\n",
" <td>-79.593422</td>\n",
" <td>43.738930</td>\n",
" <td>205994</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206429</th>\n",
" <td>-79.416000</td>\n",
" <td>43.781639</td>\n",
" <td>205895</td>\n",
" <td>GO-2019329984</td>\n",
" <td>2019-02-21T07:30:00.000Z</td>\n",
" <td>2019-02-21T15:19:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>7</td>\n",
" <td>Auto Theft</td>\n",
" <td>D32</td>\n",
" <td>36</td>\n",
" <td>Newtonbrook West (36)</td>\n",
" <td>-79.416000</td>\n",
" <td>43.781639</td>\n",
" <td>205995</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206430</th>\n",
" <td>-79.563538</td>\n",
" <td>43.682293</td>\n",
" <td>205896</td>\n",
" <td>GO-2019336030</td>\n",
" <td>2019-02-21T23:00:00.000Z</td>\n",
" <td>2019-02-22T13:27:00.000Z</td>\n",
" <td>Outside</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>23</td>\n",
" <td>Auto Theft</td>\n",
" <td>D23</td>\n",
" <td>7</td>\n",
" <td>Willowridge-Martingrove-Richview (7)</td>\n",
" <td>-79.563538</td>\n",
" <td>43.682293</td>\n",
" <td>205996</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206431</th>\n",
" <td>-79.348709</td>\n",
" <td>43.656227</td>\n",
" <td>205897</td>\n",
" <td>GO-2019336549</td>\n",
" <td>2019-02-21T00:01:00.000Z</td>\n",
" <td>2019-02-22T14:45:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>0</td>\n",
" <td>Auto Theft</td>\n",
" <td>D55</td>\n",
" <td>70</td>\n",
" <td>South Riverdale (70)</td>\n",
" <td>-79.348709</td>\n",
" <td>43.656227</td>\n",
" <td>205997</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206432</th>\n",
" <td>-79.598869</td>\n",
" <td>43.743992</td>\n",
" <td>205898</td>\n",
" <td>GO-2019187512</td>\n",
" <td>2019-01-30T12:30:00.000Z</td>\n",
" <td>2019-01-30T12:47:00.000Z</td>\n",
" <td>House</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Wednesday</td>\n",
" <td>12</td>\n",
" <td>Auto Theft</td>\n",
" <td>D23</td>\n",
" <td>1</td>\n",
" <td>West Humber-Clairville (1)</td>\n",
" <td>-79.598869</td>\n",
" <td>43.743992</td>\n",
" <td>205998</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206433</th>\n",
" <td>-79.348709</td>\n",
" <td>43.656227</td>\n",
" <td>205899</td>\n",
" <td>GO-2019336549</td>\n",
" <td>2019-02-21T00:01:00.000Z</td>\n",
" <td>2019-02-22T14:45:00.000Z</td>\n",
" <td>Commercial</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>0</td>\n",
" <td>Auto Theft</td>\n",
" <td>D55</td>\n",
" <td>70</td>\n",
" <td>South Riverdale (70)</td>\n",
" <td>-79.348709</td>\n",
" <td>43.656227</td>\n",
" <td>205999</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206434</th>\n",
" <td>-79.217125</td>\n",
" <td>43.814865</td>\n",
" <td>205900</td>\n",
" <td>GO-2019327189</td>\n",
" <td>2019-02-21T08:00:00.000Z</td>\n",
" <td>2019-02-21T08:09:00.000Z</td>\n",
" <td>House</td>\n",
" <td>2135</td>\n",
" <td>210</td>\n",
" <td>Theft Of Motor Vehicle</td>\n",
" <td>...</td>\n",
" <td>Thursday</td>\n",
" <td>8</td>\n",
" <td>Auto Theft</td>\n",
" <td>D42</td>\n",
" <td>132</td>\n",
" <td>Malvern (132)</td>\n",
" <td>-79.217125</td>\n",
" <td>43.814865</td>\n",
" <td>206000</td>\n",
" <td>1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>206376 rows × 30 columns</p>\n",
"</div>"
],
"text/plain": [
" X Y Index_ event_unique_id \\\n",
"0 -79.405228 43.656982 7801 GO-20152165447 \n",
"1 -79.307907 43.778732 7802 GO-20151417245 \n",
"2 -79.225029 43.765942 7803 GO-20151421107 \n",
"3 -79.140823 43.778648 7804 GO-20152167714 \n",
"4 -79.288361 43.691235 7805 GO-20152169954 \n",
"5 -79.353310 43.688553 7806 GO-20152123146 \n",
"6 -79.380806 43.649895 7807 GO-20152143239 \n",
"7 -79.380806 43.649895 7808 GO-20152143239 \n",
"8 -79.380806 43.649895 7809 GO-20152143239 \n",
"9 -79.386780 43.663361 7810 GO-20151970205 \n",
"10 -79.611320 43.710689 7811 GO-20151976877 \n",
"11 -79.436020 43.698772 7812 GO-20152060024 \n",
"12 -79.508636 43.720917 7813 GO-20152061875 \n",
"13 -79.416420 43.735794 7814 GO-20152100410 \n",
"14 -79.209801 43.814213 7815 GO-20152101269 \n",
"15 -79.359757 43.650761 7816 GO-20152122687 \n",
"16 -79.237289 43.736679 7817 GO-20152156376 \n",
"17 -79.565308 43.737240 7818 GO-20152156790 \n",
"18 -79.240952 43.766937 7819 GO-20152157945 \n",
"19 -79.395432 43.671902 7820 GO-20152160331 \n",
"20 -79.261574 43.811119 7821 GO-20152161385 \n",
"21 -79.216789 43.760220 7822 GO-20152163999 \n",
"22 -79.299347 43.783596 7823 GO-20152163291 \n",
"23 -79.371635 43.768021 7824 GO-20152164454 \n",
"24 -79.371635 43.768021 7825 GO-20152164454 \n",
"25 -79.371635 43.768021 7826 GO-20152164454 \n",
"26 -79.399284 43.710915 7827 GO-20152171677 \n",
"27 -79.566063 43.760590 7828 GO-20152173351 \n",
"28 -79.444336 43.694447 7829 GO-20152171258 \n",
"29 -79.278267 43.699040 7830 GO-20152211650 \n",
"... ... ... ... ... \n",
"206405 -79.523819 43.645512 205871 GO-2019189499 \n",
"206406 -79.282257 43.802719 205872 GO-2019185627 \n",
"206407 -79.397644 43.651878 205873 GO-2019268213 \n",
"206408 -79.587303 43.689518 205874 GO-2019276888 \n",
"206409 -79.496696 43.751942 205875 GO-2019271066 \n",
"206410 -79.383110 43.661373 205876 GO-2019283348 \n",
"206411 -79.285736 43.723293 205877 GO-2019373647 \n",
"206412 -79.603462 43.719158 205878 GO-2019274360 \n",
"206413 -79.572487 43.717022 205879 GO-2019264057 \n",
"206414 -79.534798 43.731228 205880 GO-2019270799 \n",
"206415 -79.600998 43.734634 205881 GO-2019388262 \n",
"206416 -79.504761 43.715744 205882 GO-2019266716 \n",
"206417 -79.597511 43.740971 205883 GO-2019264425 \n",
"206418 -79.418137 43.790256 205884 GO-2019265391 \n",
"206419 -79.428543 43.794479 205885 GO-2019273094 \n",
"206420 -79.377144 43.656502 205886 GO-2019267805 \n",
"206421 -79.268341 43.814259 205887 GO-2019326856 \n",
"206422 -79.428535 43.789856 205888 GO-2019327062 \n",
"206423 -79.564438 43.670914 205889 GO-2019333586 \n",
"206424 -79.365318 43.745293 205890 GO-2019335865 \n",
"206425 -79.464493 43.668125 205891 GO-2019332516 \n",
"206426 -79.614281 43.745495 205892 GO-2019399759 \n",
"206427 -79.500000 43.761066 205893 GO-2019331091 \n",
"206428 -79.593422 43.738930 205894 GO-2019333589 \n",
"206429 -79.416000 43.781639 205895 GO-2019329984 \n",
"206430 -79.563538 43.682293 205896 GO-2019336030 \n",
"206431 -79.348709 43.656227 205897 GO-2019336549 \n",
"206432 -79.598869 43.743992 205898 GO-2019187512 \n",
"206433 -79.348709 43.656227 205899 GO-2019336549 \n",
"206434 -79.217125 43.814865 205900 GO-2019327189 \n",
"\n",
" occurrencedate reporteddate premisetype \\\
n",
"0 2015-12-18T03:58:00.000Z 2015-12-18T03:59:00.000Z Commercial \
n",
"1 2015-08-15T21:45:00.000Z 2015-08-17T22:11:00.000Z Commercial \
n",
"2 2015-08-16T16:00:00.000Z 2015-08-18T14:40:00.000Z Apartment \
n",
"3 2015-11-26T13:00:00.000Z 2015-12-18T13:38:00.000Z Other \
n",
"4 2015-12-18T19:50:00.000Z 2015-12-18T19:55:00.000Z Commercial \
n",
"5 2015-04-10T10:00:00.000Z 2015-12-11T14:27:00.000Z Apartment \
n",
"6 2015-12-14T21:00:00.000Z 2015-12-16T18:32:00.000Z Outside \
n",
"7 2015-12-14T21:00:00.000Z 2015-12-16T18:32:00.000Z Outside \
n",
"8 2015-12-14T21:00:00.000Z 2015-12-16T18:32:00.000Z Outside \
n",
"9 2015-11-17T01:20:00.000Z 2015-11-17T02:43:00.000Z Outside \
n",
"10 2015-11-18T05:35:00.000Z 2015-11-18T05:42:00.000Z Commercial \
n",
"11 2015-12-01T15:10:00.000Z 2015-12-01T15:20:00.000Z Other \
n",
"12 2015-12-01T22:19:00.000Z 2015-12-01T22:19:00.000Z Commercial \
n",
"13 2015-12-08T06:24:00.000Z 2015-12-08T06:24:00.000Z House \
n",
"14 2015-12-08T09:15:00.000Z 2015-12-08T09:27:00.000Z Other \
n",
"15 2015-12-11T13:15:00.000Z 2015-12-11T13:45:00.000Z Outside \
n",
"16 2015-12-16T16:50:00.000Z 2015-12-16T16:53:00.000Z Outside \
n",
"17 2015-12-16T17:00:00.000Z 2015-12-16T19:29:00.000Z Outside \
n",
"18 2015-12-16T10:00:00.000Z 2015-12-16T22:18:00.000Z House \
n",
"19 2015-12-16T21:00:00.000Z 2015-12-17T10:26:00.000Z Commercial \
n",
"20 2015-12-17T12:30:00.000Z 2015-12-17T13:17:00.000Z House \
n",
"21 2015-12-17T20:56:00.000Z 2015-12-17T20:56:00.000Z Apartment \
n",
"22 2015-12-17T11:40:00.000Z 2015-12-17T18:29:00.000Z Other \
n",
"23 2015-12-17T22:35:00.000Z 2015-12-17T22:35:00.000Z Apartment \
n",
"24 2015-12-17T22:35:00.000Z 2015-12-17T22:35:00.000Z Apartment \
n",
"25 2015-12-17T22:35:00.000Z 2015-12-17T22:35:00.000Z Apartment \
n",
"26 2015-12-19T02:15:00.000Z 2015-12-19T02:37:00.000Z Commercial \
n",
"27 2015-12-19T11:25:00.000Z 2015-12-19T11:32:00.000Z Commercial \
n",
"28 2015-12-19T00:44:00.000Z 2015-12-19T00:44:00.000Z House \
n",
"29 2015-12-26T15:00:00.000Z 2015-12-26T15:37:00.000Z Other \
n",
"... ... ... ... \
n",
"206405 2019-01-30T06:00:00.000Z 2019-01-30T17:31:00.000Z Outside \
n",
"206406 2019-01-30T07:30:00.000Z 2019-01-30T08:35:00.000Z House \
n",
"206407 2019-02-11T18:21:00.000Z 2019-02-11T18:48:00.000Z Outside \
n",
"206408 2019-02-11T22:30:00.000Z 2019-02-13T09:36:00.000Z Outside \
n",
"206409 2019-02-11T18:00:00.000Z 2019-02-12T09:12:00.000Z House \
n",
"206410 2019-02-11T23:00:00.000Z 2019-02-14T09:30:00.000Z Outside \
n",
"206411 2019-02-11T12:00:00.000Z 2019-02-28T10:28:00.000Z Outside \
n",
"206412 2019-02-11T22:00:00.000Z 2019-02-12T20:33:00.000Z Outside \
n",
"206413 2019-02-11T01:08:00.000Z 2019-02-11T07:20:00.000Z Commercial \
n",
"206414 2019-02-11T20:00:00.000Z 2019-02-12T08:11:00.000Z House \
n",
"206415 2019-02-11T09:00:00.000Z 2019-03-02T13:37:00.000Z Commercial \
n",
"206416 2019-02-11T13:40:00.000Z 2019-02-11T14:59:00.000Z Outside \
n",
"206417 2019-02-11T08:15:00.000Z 2019-02-11T08:47:00.000Z House \
n",
"206418 2019-02-11T10:30:00.000Z 2019-02-11T11:20:00.000Z Outside \
n",
"206419 2019-02-11T15:00:00.000Z 2019-02-12T15:50:00.000Z Outside \
n",
"206420 2019-02-11T00:01:00.000Z 2019-02-11T18:04:00.000Z Commercial \
n",
"206421 2019-02-21T06:30:00.000Z 2019-02-21T06:54:00.000Z House \
n",
"206422 2019-02-21T07:40:00.000Z 2019-02-21T07:44:00.000Z House \
n",
"206423 2019-02-21T21:30:00.000Z 2019-02-22T06:00:00.000Z House \
n",
"206424 2019-02-21T20:00:00.000Z 2019-02-22T13:04:00.000Z House \
n",
"206425 2019-02-21T20:30:00.000Z 2019-02-21T22:42:00.000Z Outside \
n",
"206426 2019-02-21T12:44:00.000Z 2019-03-04T10:19:00.000Z Commercial \
n",
"206427 2019-02-21T08:00:00.000Z 2019-02-21T17:59:00.000Z Outside \
n",
"206428 2019-02-21T23:45:00.000Z 2019-02-22T06:00:00.000Z House \
n",
"206429 2019-02-21T07:30:00.000Z 2019-02-21T15:19:00.000Z Outside \
n",
"206430 2019-02-21T23:00:00.000Z 2019-02-22T13:27:00.000Z Outside \
n",
"206431 2019-02-21T00:01:00.000Z 2019-02-22T14:45:00.000Z Commercial \
n",
"206432 2019-01-30T12:30:00.000Z 2019-01-30T12:47:00.000Z House \
n",
"206433 2019-02-21T00:01:00.000Z 2019-02-22T14:45:00.000Z Commercial \
n",
"206434 2019-02-21T08:00:00.000Z 2019-02-21T08:09:00.000Z House \
n",
"\n",
" ucr_code ucr_ext offence ... \\\n",
"0 1430 100 Assault ... \n",
"1 1430 100 Assault ... \n",
"2 2120 200 B&E ... \n",
"3 2120 200 B&E ... \n",
"4 1430 100 Assault ... \n",
"5 2120 200 B&E ... \n",
"6 1430 100 Assault ... \n",
"7 1430 100 Assault ... \n",
"8 1430 100 Assault ... \n",
"9 1610 160 Robbery - Taxi ... \n",
"10 1480 100 Assault - Resist/ Prevent Seiz ... \n",
"11 1430 100 Assault ... \n",
"12 1430 100 Assault ... \n",
"13 2120 200 B&E ... \n",
"14 1430 100 Assault ... \n",
"15 1430 100 Assault ... \n",
"16 1430 100 Assault ... \n",
"17 1430 100 Assault ... \n",
"18 2120 200 B&E ... \n",
"19 2120 200 B&E ... \n",
"20 2120 200 B&E ... \n",
"21 1430 100 Assault ... \n",
"22 1610 200 Robbery - Mugging ... \n",
"23 1450 100 Discharge Firearm - Recklessly ... \n",
"24 1457 100 Pointing A Firearm ... \n",
"25 1410 100 Aggravated Assault ... \n",
"26 1420 100 Assault With Weapon ... \n",
"27 1430 100 Assault ... \n",
"28 1430 100 Assault ... \n",
"29 1430 100 Assault ... \n",
"... ... ... ... ... \n",
"206405 2135 210 Theft Of Motor Vehicle ... \n",
"206406 2135 210 Theft Of Motor Vehicle ... \n",
"206407 2135 210 Theft Of Motor Vehicle ... \n",
"206408 2135 210 Theft Of Motor Vehicle ... \n",
"206409 2135 210 Theft Of Motor Vehicle ... \n",
"206410 2135 210 Theft Of Motor Vehicle ... \n",
"206411 2135 210 Theft Of Motor Vehicle ... \n",
"206412 2135 210 Theft Of Motor Vehicle ... \n",
"206413 2135 210 Theft Of Motor Vehicle ... \n",
"206414 2135 210 Theft Of Motor Vehicle ... \n",
"206415 2135 210 Theft Of Motor Vehicle ... \n",
"206416 2135 210 Theft Of Motor Vehicle ... \n",
"206417 2135 210 Theft Of Motor Vehicle ... \n",
"206418 2135 210 Theft Of Motor Vehicle ... \n",
"206419 2135 210 Theft Of Motor Vehicle ... \n",
"206420 2135 210 Theft Of Motor Vehicle ... \n",
"206421 2135 210 Theft Of Motor Vehicle ... \n",
"206422 2135 210 Theft Of Motor Vehicle ... \n",
"206423 2135 210 Theft Of Motor Vehicle ... \n",
"206424 2135 210 Theft Of Motor Vehicle ... \n",
"206425 2135 210 Theft Of Motor Vehicle ... \n",
"206426 2135 210 Theft Of Motor Vehicle ... \n",
"206427 2135 210 Theft Of Motor Vehicle ... \n",
"206428 2135 210 Theft Of Motor Vehicle ... \n",
"206429 2135 210 Theft Of Motor Vehicle ... \n",
"206430 2135 210 Theft Of Motor Vehicle ... \n",
"206431 2135 210 Theft Of Motor Vehicle ... \n",
"206432 2135 210 Theft Of Motor Vehicle ... \n",
"206433 2135 210 Theft Of Motor Vehicle ... \n",
"206434 2135 210 Theft Of Motor Vehicle ... \n",
"\n",
" occurrencedayofweek occurrencehour MCI Division
Hood_ID \\\n",
"0 Friday 3 Assault D14
79 \n",
"1 Saturday 21 Assault D42
118 \n",
"2 Sunday 16 Break and Enter D43
137 \n",
"3 Thursday 13 Break and Enter D43
133 \n",
"4 Friday 19 Assault D55
61 \n",
"5 Friday 10 Break and Enter D54
57 \n",
"6 Monday 21 Assault D52
76 \n",
"7 Monday 21 Assault D52
76 \n",
"8 Monday 21 Assault D52
76 \n",
"9 Tuesday 1 Robbery D52
76 \n",
"10 Wednesday 5 Assault D23
1 \n",
"11 Tuesday 15 Assault D13
102 \n",
"12 Tuesday 22 Assault D31
26 \n",
"13 Tuesday 6 Break and Enter D32
39 \n",
"14 Tuesday 9 Assault D42
132 \n",
"15 Friday 13 Assault D51
77 \n",
"16 Wednesday 16 Assault D43
138 \n",
"17 Wednesday 17 Assault D23
3 \n",
"18 Wednesday 10 Break and Enter D43
137 \n",
"19 Wednesday 21 Break and Enter D53
95 \n",
"20 Thursday 12 Break and Enter D42
129 \n",
"21 Thursday 20 Assault D43
137 \n",
"22 Thursday 11 Robbery D42
118 \n",
"23 Thursday 22 Assault D33
52 \n",
"24 Thursday 22 Assault D33
52 \n",
"25 Thursday 22 Assault D33
52 \n",
"26 Saturday 2 Assault D53
104 \n",
"27 Saturday 11 Assault D31
21 \n",
"28 Saturday 0 Assault D13
107 \n",
"29 Saturday 15 Assault D41
121 \n",