Skip to content

Instantly share code, notes, and snippets.

@dev-area

dev-area/DateTime.ipynb

Created August 23, 2017 15:12
Show Gist options
  • Save dev-area/25cfcab942e6b02350e9204843cc96d2 to your computer and use it in GitHub Desktop.
Save dev-area/25cfcab942e6b02350e9204843cc96d2 to your computer and use it in GitHub Desktop.
Download ZIP
Date and Time examples
Display the source blob
Display the rendered blob
Raw
DateTime.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 8,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import pandas as pd\n",
"import datetime"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [],
"source": [
"df=pd.read_csv('./austin_crime.csv')"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"<class 'pandas.core.frame.DataFrame'>\n",
"RangeIndex: 159464 entries, 0 to 159463\n",
"Data columns (total 18 columns):\n",
"address 159464 non-null object\n",
"census_tract 84528 non-null object\n",
"clearance_date 81489 non-null object\n",
"clearance_status 81480 non-null object\n",
"council_district_code 84456 non-null float64\n",
"description 84884 non-null object\n",
"district 84871 non-null object\n",
"latitude 34500 non-null float64\n",
"location 34500 non-null object\n",
"location_description 78172 non-null object\n",
"longitude 34500 non-null float64\n",
"primary_type 79214 non-null object\n",
"timestamp 73544 non-null object\n",
"unique_key 73544 non-null float64\n",
"x_coordinate 72273 non-null float64\n",
"y_coordinate 72273 non-null float64\n",
"year 73544 non-null float64\n",
"zipcode 73201 non-null float64\n",
"dtypes: float64(8), object(10)\n",
"memory usage: 21.9+ MB\n"
]
}
],
"source": [
"df.info()"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>address</th>\n",
" <th>census_tract</th>\n",
" <th>clearance_date</th>\n",
" <th>clearance_status</th>\n",
" <th>council_district_code</th>\n",
" <th>description</th>\n",
" <th>district</th>\n",
" <th>latitude</th>\n",
" <th>location</th>\n",
" <th>location_description</th>\n",
" <th>longitude</th>\n",
" <th>primary_type</th>\n",
" <th>timestamp</th>\n",
" <th>unique_key</th>\n",
" <th>x_coordinate</th>\n",
" <th>y_coordinate</th>\n",
" <th>year</th>\n",
" <th>zipcode</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2620 RIO GRANDE ST Austin TX 78705</td>\n",
" <td>6.03</td>\n",
" <td>2015-12-14 00:00:00</td>\n",
" <td>Not cleared</td>\n",
" <td>9.0</td>\n",
" <td>THEFT</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2620 RIO GRANDE ST</td>\n",
" <td>NaN</td>\n",
" <td>Theft</td>\n",
" <td>2015-12-13 00:00:00</td>\n",
" <td>2.015505e+10</td>\n",
" <td>3113531.0</td>\n",
" <td>10079579.0</td>\n",
" <td>2015.0</td>\n",
" <td>78705.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>9500 S IH 35 SVRD SB Austin TX 78748</td>\n",
" <td>24.21</td>\n",
" <td>2015-09-14 00:00:00</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>5.0</td>\n",
" <td>THEFT BY SHOPLIFTING</td>\n",
" <td>F</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>9500 S IH 35 SVRD SB</td>\n",
" <td>NaN</td>\n",
" <td>Theft</td>\n",
" <td>2015-09-03 00:00:00</td>\n",
" <td>2.015246e+10</td>\n",
" <td>3099459.0</td>\n",
" <td>10032098.0</td>\n",
" <td>2015.0</td>\n",
" <td>78748.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>1000 E 41ST ST</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Austin TX 78751</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>(30.298356 -97.719647)</td>\n",
" <td>3.02</td>\n",
" <td>2014-07-29 00:00:00</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>9.0</td>\n",
" <td>THEFT BY SHOPLIFTING</td>\n",
" <td>B</td>\n",
" <td>30.298356</td>\n",
" <td>(30.298356-97.719647)</td>\n",
" <td>1000 E 41ST ST</td>\n",
" <td>-97.719647</td>\n",
" <td>Theft: Shoplifting</td>\n",
" <td>2014-04-04 00:00:00</td>\n",
" <td>2.014941e+09</td>\n",
" <td>3121345.0</td>\n",
" <td>10082705.0</td>\n",
" <td>2014.0</td>\n",
" <td>78751.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" address census_tract clearance_date \\\n",
"0 2620 RIO GRANDE ST Austin TX 78705 6.03 2015-12-14 00:00:00 \n",
"1 9500 S IH 35 SVRD SB Austin TX 78748 24.21 2015-09-14 00:00:00 \n",
"2 1000 E 41ST ST NaN NaN \n",
"3 Austin TX 78751 NaN NaN \n",
"4 (30.298356 -97.719647) 3.02 2014-07-29 00:00:00 \n",
"\n",
" clearance_status council_district_code description district \\\n",
"0 Not cleared 9.0 THEFT B \n",
"1 Cleared by Arrest 5.0 THEFT BY SHOPLIFTING F \n",
"2 NaN NaN NaN NaN \n",
"3 NaN NaN NaN NaN \n",
"4 Cleared by Arrest 9.0 THEFT BY SHOPLIFTING B \n",
"\n",
" latitude location location_description longitude \\\n",
"0 NaN NaN 2620 RIO GRANDE ST NaN \n",
"1 NaN NaN 9500 S IH 35 SVRD SB NaN \n",
"2 NaN NaN NaN NaN \n",
"3 NaN NaN NaN NaN \n",
"4 30.298356 (30.298356-97.719647) 1000 E 41ST ST -97.719647 \n",
"\n",
" primary_type timestamp unique_key x_coordinate \\\n",
"0 Theft 2015-12-13 00:00:00 2.015505e+10 3113531.0 \n",
"1 Theft 2015-09-03 00:00:00 2.015246e+10 3099459.0 \n",
"2 NaN NaN NaN NaN \n",
"3 NaN NaN NaN NaN \n",
"4 Theft: Shoplifting 2014-04-04 00:00:00 2.014941e+09 3121345.0 \n",
"\n",
" y_coordinate year zipcode \n",
"0 10079579.0 2015.0 78705.0 \n",
"1 10032098.0 2015.0 78748.0 \n",
"2 NaN NaN NaN \n",
"3 NaN NaN NaN \n",
"4 10082705.0 2014.0 78751.0 "
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.head()"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [],
"source": [
"df.dropna(inplace=True)\n",
"df['clearance_date']=(df['clearance_date']).astype('datetime64[ns]')\n"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>address</th>\n",
" <th>census_tract</th>\n",
" <th>clearance_date</th>\n",
" <th>clearance_status</th>\n",
" <th>council_district_code</th>\n",
" <th>description</th>\n",
" <th>district</th>\n",
" <th>latitude</th>\n",
" <th>location</th>\n",
" <th>location_description</th>\n",
" <th>longitude</th>\n",
" <th>primary_type</th>\n",
" <th>timestamp</th>\n",
" <th>unique_key</th>\n",
" <th>x_coordinate</th>\n",
" <th>y_coordinate</th>\n",
" <th>year</th>\n",
" <th>zipcode</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>(30.298356 -97.719647)</td>\n",
" <td>3.02</td>\n",
" <td>2014-07-29</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>9.0</td>\n",
" <td>THEFT BY SHOPLIFTING</td>\n",
" <td>B</td>\n",
" <td>30.298356</td>\n",
" <td>(30.298356-97.719647)</td>\n",
" <td>1000 E 41ST ST</td>\n",
" <td>-97.719647</td>\n",
" <td>Theft: Shoplifting</td>\n",
" <td>2014-04-04 00:00:00</td>\n",
" <td>2.014941e+09</td>\n",
" <td>3121345.0</td>\n",
" <td>10082705.0</td>\n",
" <td>2014.0</td>\n",
" <td>78751.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>(30.272154 -97.730002)</td>\n",
" <td>8.029999999999999</td>\n",
" <td>2014-05-08</td>\n",
" <td>Not cleared</td>\n",
" <td>1.0</td>\n",
" <td>AUTO THEFT</td>\n",
" <td>C</td>\n",
" <td>30.272154</td>\n",
" <td>(30.272154-97.730002)</td>\n",
" <td>1000 E 12TH ST</td>\n",
" <td>-97.730002</td>\n",
" <td>Auto Theft</td>\n",
" <td>2014-04-04 00:00:00</td>\n",
" <td>2.014941e+09</td>\n",
" <td>3118304.0</td>\n",
" <td>10072414.0</td>\n",
" <td>2014.0</td>\n",
" <td>78702.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>(30.201243 -97.709249)</td>\n",
" <td>24.31</td>\n",
" <td>2014-05-09</td>\n",
" <td>Not cleared</td>\n",
" <td>2.0</td>\n",
" <td>THEFT</td>\n",
" <td>H</td>\n",
" <td>30.201243</td>\n",
" <td>(30.201243-97.709249)</td>\n",
" <td>6800 BURLESON RD</td>\n",
" <td>-97.709249</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-05-08 00:00:00</td>\n",
" <td>2.014502e+10</td>\n",
" <td>3125886.0</td>\n",
" <td>10047276.0</td>\n",
" <td>2014.0</td>\n",
" <td>78744.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>(30.271198 -97.705609)</td>\n",
" <td>8.02</td>\n",
" <td>2014-12-19</td>\n",
" <td>Not cleared</td>\n",
" <td>1.0</td>\n",
" <td>AUTO THEFT</td>\n",
" <td>C</td>\n",
" <td>30.271198</td>\n",
" <td>(30.271198-97.705609)</td>\n",
" <td>3506 WEBBERVILLE RD</td>\n",
" <td>-97.705609</td>\n",
" <td>Auto Theft</td>\n",
" <td>2014-12-18 00:00:00</td>\n",
" <td>2.014352e+10</td>\n",
" <td>3125976.0</td>\n",
" <td>10072207.0</td>\n",
" <td>2014.0</td>\n",
" <td>78702.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>(30.356418 -97.731423)</td>\n",
" <td>18.170000000000002</td>\n",
" <td>2014-04-17</td>\n",
" <td>Not cleared</td>\n",
" <td>7.0</td>\n",
" <td>THEFT</td>\n",
" <td>B</td>\n",
" <td>30.356418</td>\n",
" <td>(30.356418-97.731423)</td>\n",
" <td>2438 W ANDERSON LN</td>\n",
" <td>-97.731423</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-04-16 00:00:00</td>\n",
" <td>2.014502e+10</td>\n",
" <td>3117183.0</td>\n",
" <td>10103211.0</td>\n",
" <td>2014.0</td>\n",
" <td>78757.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>(30.426691 -97.77719)</td>\n",
" <td>17.559999999999999</td>\n",
" <td>2014-10-07</td>\n",
" <td>Not cleared</td>\n",
" <td>10.0</td>\n",
" <td>THEFT</td>\n",
" <td>A</td>\n",
" <td>30.426691</td>\n",
" <td>(30.426691-97.77719)</td>\n",
" <td>11304 BLACKMOOR DR</td>\n",
" <td>-97.777190</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-10-01 00:00:00</td>\n",
" <td>2.014504e+10</td>\n",
" <td>3102055.0</td>\n",
" <td>10128145.0</td>\n",
" <td>2014.0</td>\n",
" <td>78759.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>(30.260544 -97.711225)</td>\n",
" <td>9.02</td>\n",
" <td>2014-12-01</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>3.0</td>\n",
" <td>THEFT</td>\n",
" <td>C</td>\n",
" <td>30.260544</td>\n",
" <td>(30.260544-97.711225)</td>\n",
" <td>2701 E 7TH ST</td>\n",
" <td>-97.711225</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-11-28 00:00:00</td>\n",
" <td>2.014332e+10</td>\n",
" <td>3124306.0</td>\n",
" <td>10067892.0</td>\n",
" <td>2014.0</td>\n",
" <td>78702.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>(30.20938 -97.805891)</td>\n",
" <td>17.13</td>\n",
" <td>2014-03-25</td>\n",
" <td>Not cleared</td>\n",
" <td>5.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>D</td>\n",
" <td>30.209380</td>\n",
" <td>(30.20938-97.805891)</td>\n",
" <td>2309 BERKELEY AVE</td>\n",
" <td>-97.805891</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-03-14 00:00:00</td>\n",
" <td>2.014501e+10</td>\n",
" <td>3094587.0</td>\n",
" <td>10048955.0</td>\n",
" <td>2014.0</td>\n",
" <td>78745.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>(30.190722 -97.752915)</td>\n",
" <td>24.12</td>\n",
" <td>2014-08-13</td>\n",
" <td>Cleared by Exception</td>\n",
" <td>2.0</td>\n",
" <td>THEFT</td>\n",
" <td>F</td>\n",
" <td>30.190722</td>\n",
" <td>(30.190722-97.752915)</td>\n",
" <td>2515 DOVEMEADOW DR</td>\n",
" <td>-97.752915</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-07-07 00:00:00</td>\n",
" <td>2.014188e+10</td>\n",
" <td>3111716.0</td>\n",
" <td>10042505.0</td>\n",
" <td>2014.0</td>\n",
" <td>78744.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>(30.322904 -97.710548)</td>\n",
" <td>15.03</td>\n",
" <td>2014-09-24</td>\n",
" <td>Not cleared</td>\n",
" <td>4.0</td>\n",
" <td>THEFT</td>\n",
" <td>I</td>\n",
" <td>30.322904</td>\n",
" <td>(30.322904-97.710548)</td>\n",
" <td>6000 MIDDLE FISKVILLE RD</td>\n",
" <td>-97.710548</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-09-22 00:00:00</td>\n",
" <td>2.014504e+10</td>\n",
" <td>3123931.0</td>\n",
" <td>10091029.0</td>\n",
" <td>2014.0</td>\n",
" <td>78752.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>(30.298396 -97.677709)</td>\n",
" <td>21.07</td>\n",
" <td>2014-07-17</td>\n",
" <td>Not cleared</td>\n",
" <td>1.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>I</td>\n",
" <td>30.298396</td>\n",
" <td>(30.298396-97.677709)</td>\n",
" <td>5407 PENDLETON LN</td>\n",
" <td>-97.677709</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-07-16 00:00:00</td>\n",
" <td>2.014503e+10</td>\n",
" <td>3134588.0</td>\n",
" <td>10082195.0</td>\n",
" <td>2014.0</td>\n",
" <td>78723.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td>(30.340296 -97.755204)</td>\n",
" <td>17.18</td>\n",
" <td>2014-06-02</td>\n",
" <td>Not cleared</td>\n",
" <td>10.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>B</td>\n",
" <td>30.340296</td>\n",
" <td>(30.340296-97.755204)</td>\n",
" <td>5929 BALCONES DR</td>\n",
" <td>-97.755204</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-05-13 00:00:00</td>\n",
" <td>2.014502e+10</td>\n",
" <td>3110257.0</td>\n",
" <td>10097698.0</td>\n",
" <td>2014.0</td>\n",
" <td>78731.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td>(30.499098 -97.77256)</td>\n",
" <td>205.1</td>\n",
" <td>2014-02-10</td>\n",
" <td>Cleared by Exception</td>\n",
" <td>6.0</td>\n",
" <td>THEFT</td>\n",
" <td>A</td>\n",
" <td>30.499098</td>\n",
" <td>(30.499098-97.77256)</td>\n",
" <td>15111 AVERY RANCH BLVD</td>\n",
" <td>-97.772560</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-01-13 00:00:00</td>\n",
" <td>2.014500e+10</td>\n",
" <td>3103012.0</td>\n",
" <td>10154463.0</td>\n",
" <td>2014.0</td>\n",
" <td>78717.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>77</th>\n",
" <td>(30.220698 -97.744858)</td>\n",
" <td>23.07</td>\n",
" <td>2014-03-27</td>\n",
" <td>Not cleared</td>\n",
" <td>3.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>H</td>\n",
" <td>30.220698</td>\n",
" <td>(30.220698-97.744858)</td>\n",
" <td>1718 WOODWARD ST</td>\n",
" <td>-97.744858</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-03-26 00:00:00</td>\n",
" <td>2.014501e+10</td>\n",
" <td>3114115.0</td>\n",
" <td>10053567.0</td>\n",
" <td>2014.0</td>\n",
" <td>78741.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>86</th>\n",
" <td>(30.224918 -97.70321)</td>\n",
" <td>23.12</td>\n",
" <td>2015-01-02</td>\n",
" <td>Not cleared</td>\n",
" <td>3.0</td>\n",
" <td>THEFT BY SHOPLIFTING</td>\n",
" <td>H</td>\n",
" <td>30.224918</td>\n",
" <td>(30.224918-97.70321)</td>\n",
" <td>6306 E RIVERSIDE DR</td>\n",
" <td>-97.703210</td>\n",
" <td>Theft: Shoplifting</td>\n",
" <td>2014-12-28 00:00:00</td>\n",
" <td>2.014362e+10</td>\n",
" <td>3127258.0</td>\n",
" <td>10055405.0</td>\n",
" <td>2014.0</td>\n",
" <td>78741.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>89</th>\n",
" <td>(30.32945 -97.690009)</td>\n",
" <td>18.11</td>\n",
" <td>2014-07-01</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>1.0</td>\n",
" <td>THEFT</td>\n",
" <td>I</td>\n",
" <td>30.329450</td>\n",
" <td>(30.32945-97.690009)</td>\n",
" <td>7517 CAMERON RD</td>\n",
" <td>-97.690009</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-06-28 00:00:00</td>\n",
" <td>2.014179e+10</td>\n",
" <td>3130685.0</td>\n",
" <td>10093333.0</td>\n",
" <td>2014.0</td>\n",
" <td>78752.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96</th>\n",
" <td>(30.434138 -97.782883)</td>\n",
" <td>17.82</td>\n",
" <td>2014-10-23</td>\n",
" <td>Not cleared</td>\n",
" <td>6.0</td>\n",
" <td>THEFT OF LICENSE PLATE</td>\n",
" <td>A</td>\n",
" <td>30.434138</td>\n",
" <td>(30.434138-97.782883)</td>\n",
" <td>11521 KEMPWOOD DR</td>\n",
" <td>-97.782883</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-10-19 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3100383.0</td>\n",
" <td>10130884.0</td>\n",
" <td>2014.0</td>\n",
" <td>78750.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>99</th>\n",
" <td>(30.212695 -97.745743)</td>\n",
" <td>24.11</td>\n",
" <td>2014-04-18</td>\n",
" <td>Not cleared</td>\n",
" <td>2.0</td>\n",
" <td>THEFT OF VEHICLE/OTHER</td>\n",
" <td>F</td>\n",
" <td>30.212695</td>\n",
" <td>(30.212695-97.745743)</td>\n",
" <td>2150 WOODWARD ST</td>\n",
" <td>-97.745743</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-03-28 00:00:00</td>\n",
" <td>2.014871e+09</td>\n",
" <td>3114393.0</td>\n",
" <td>10050515.0</td>\n",
" <td>2014.0</td>\n",
" <td>78744.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>106</th>\n",
" <td>(30.191043 -97.771802)</td>\n",
" <td>24.02</td>\n",
" <td>2014-12-24</td>\n",
" <td>Not cleared</td>\n",
" <td>2.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>F</td>\n",
" <td>30.191043</td>\n",
" <td>(30.191043-97.771802)</td>\n",
" <td>800 E WILLIAM CANNON DR</td>\n",
" <td>-97.771802</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-12-20 00:00:00</td>\n",
" <td>2.014506e+10</td>\n",
" <td>3105816.0</td>\n",
" <td>10042612.0</td>\n",
" <td>2014.0</td>\n",
" <td>78745.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>109</th>\n",
" <td>(30.238285 -97.754014)</td>\n",
" <td>13.08</td>\n",
" <td>2014-08-05</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>3.0</td>\n",
" <td>THEFT</td>\n",
" <td>D</td>\n",
" <td>30.238285</td>\n",
" <td>(30.238285-97.754014)</td>\n",
" <td>2400 S CONGRESS AVE</td>\n",
" <td>-97.754014</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-08-04 00:00:00</td>\n",
" <td>2.014216e+10</td>\n",
" <td>3110845.0</td>\n",
" <td>10059841.0</td>\n",
" <td>2014.0</td>\n",
" <td>78704.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>112</th>\n",
" <td>(30.214683 -97.769154)</td>\n",
" <td>24.03</td>\n",
" <td>2014-06-30</td>\n",
" <td>Not cleared</td>\n",
" <td>3.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>D</td>\n",
" <td>30.214683</td>\n",
" <td>(30.214683-97.769154)</td>\n",
" <td>4729 S CONGRESS AVE</td>\n",
" <td>-97.769154</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-06-03 00:00:00</td>\n",
" <td>2.014502e+10</td>\n",
" <td>3106445.0</td>\n",
" <td>10051054.0</td>\n",
" <td>2014.0</td>\n",
" <td>78745.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>123</th>\n",
" <td>(30.412351 -97.707908)</td>\n",
" <td>18.5</td>\n",
" <td>2014-04-16</td>\n",
" <td>Not cleared</td>\n",
" <td>7.0</td>\n",
" <td>THEFT</td>\n",
" <td>A</td>\n",
" <td>30.412351</td>\n",
" <td>(30.412351-97.707908)</td>\n",
" <td>12221 N MOPAC EXPY SVRD NB</td>\n",
" <td>-97.707908</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-04-15 00:00:00</td>\n",
" <td>2.014502e+10</td>\n",
" <td>3124636.0</td>\n",
" <td>10124176.0</td>\n",
" <td>2014.0</td>\n",
" <td>78758.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>126</th>\n",
" <td>(30.266739 -97.738086)</td>\n",
" <td>11</td>\n",
" <td>2014-02-27</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>9.0</td>\n",
" <td>AGG ASSAULT</td>\n",
" <td>G</td>\n",
" <td>30.266739</td>\n",
" <td>(30.266739-97.738086)</td>\n",
" <td>500 E 6TH ST</td>\n",
" <td>-97.738086</td>\n",
" <td>Aggravated Assault</td>\n",
" <td>2014-02-23 00:00:00</td>\n",
" <td>2.014540e+09</td>\n",
" <td>3115841.0</td>\n",
" <td>10070419.0</td>\n",
" <td>2014.0</td>\n",
" <td>78701.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>131</th>\n",
" <td>(30.216942 -97.754349)</td>\n",
" <td>24.03</td>\n",
" <td>2014-03-11</td>\n",
" <td>Not cleared</td>\n",
" <td>3.0</td>\n",
" <td>THEFT</td>\n",
" <td>D</td>\n",
" <td>30.216942</td>\n",
" <td>(30.216942-97.754349)</td>\n",
" <td>1001 E BEN WHITE BLVD SVRD EB</td>\n",
" <td>-97.754349</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-03-08 00:00:00</td>\n",
" <td>2.014671e+09</td>\n",
" <td>3111103.0</td>\n",
" <td>10052022.0</td>\n",
" <td>2014.0</td>\n",
" <td>78745.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>138</th>\n",
" <td>(30.362887 -97.717631)</td>\n",
" <td>18.18</td>\n",
" <td>2014-03-18</td>\n",
" <td>Not cleared</td>\n",
" <td>7.0</td>\n",
" <td>THEFT</td>\n",
" <td>I</td>\n",
" <td>30.362887</td>\n",
" <td>(30.362887-97.717631)</td>\n",
" <td>8630 RESEARCH BLVD SB</td>\n",
" <td>-97.717631</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-01-31 00:00:00</td>\n",
" <td>2.014500e+10</td>\n",
" <td>3121360.0</td>\n",
" <td>10105357.0</td>\n",
" <td>2014.0</td>\n",
" <td>78757.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>146</th>\n",
" <td>(30.372213 -97.730029)</td>\n",
" <td>18.170000000000002</td>\n",
" <td>2014-05-06</td>\n",
" <td>Not cleared</td>\n",
" <td>7.0</td>\n",
" <td>THEFT</td>\n",
" <td>B</td>\n",
" <td>30.372213</td>\n",
" <td>(30.372213-97.730029)</td>\n",
" <td>8800 MC CANN DR</td>\n",
" <td>-97.730029</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-05-02 00:00:00</td>\n",
" <td>2.014502e+10</td>\n",
" <td>3117467.0</td>\n",
" <td>10108775.0</td>\n",
" <td>2014.0</td>\n",
" <td>78757.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>150</th>\n",
" <td>(30.336574 -97.718265)</td>\n",
" <td>15.03</td>\n",
" <td>2014-12-30</td>\n",
" <td>Not cleared</td>\n",
" <td>4.0</td>\n",
" <td>THEFT BY SHOPLIFTING</td>\n",
" <td>I</td>\n",
" <td>30.336574</td>\n",
" <td>(30.336574-97.718265)</td>\n",
" <td>6929 AIRPORT BLVD</td>\n",
" <td>-97.718265</td>\n",
" <td>Theft: Shoplifting</td>\n",
" <td>2014-12-14 00:00:00</td>\n",
" <td>2.014348e+10</td>\n",
" <td>3121678.0</td>\n",
" <td>10096228.0</td>\n",
" <td>2014.0</td>\n",
" <td>78752.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>156</th>\n",
" <td>(30.367124 -97.684698)</td>\n",
" <td>18.23</td>\n",
" <td>2014-03-17</td>\n",
" <td>Not cleared</td>\n",
" <td>4.0</td>\n",
" <td>THEFT</td>\n",
" <td>E</td>\n",
" <td>30.367124</td>\n",
" <td>(30.367124-97.684698)</td>\n",
" <td>10205 BROWNIE DR</td>\n",
" <td>-97.684698</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-01-20 00:00:00</td>\n",
" <td>2.014202e+09</td>\n",
" <td>3131888.0</td>\n",
" <td>10107188.0</td>\n",
" <td>2014.0</td>\n",
" <td>78753.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159</th>\n",
" <td>(30.265106 -97.73654)</td>\n",
" <td>11</td>\n",
" <td>2014-12-11</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>9.0</td>\n",
" <td>THEFT</td>\n",
" <td>G</td>\n",
" <td>30.265106</td>\n",
" <td>(30.265106-97.73654)</td>\n",
" <td>415 SABINE ST</td>\n",
" <td>-97.736540</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-09-25 00:00:00</td>\n",
" <td>2.014268e+10</td>\n",
" <td>3116350.0</td>\n",
" <td>10069732.0</td>\n",
" <td>2014.0</td>\n",
" <td>78701.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>163</th>\n",
" <td>(30.40921 -97.744708)</td>\n",
" <td>17.54</td>\n",
" <td>2014-12-15</td>\n",
" <td>Not cleared</td>\n",
" <td>6.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>A</td>\n",
" <td>30.409210</td>\n",
" <td>(30.40921-97.744708)</td>\n",
" <td>11215 RESEARCH BLVD NB</td>\n",
" <td>-97.744708</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-12-14 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3112999.0</td>\n",
" <td>10122087.0</td>\n",
" <td>2014.0</td>\n",
" <td>78759.0</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",
" </tr>\n",
" <tr>\n",
" <th>159285</th>\n",
" <td>(30.35502 -97.673257)</td>\n",
" <td>18.34</td>\n",
" <td>2014-12-30</td>\n",
" <td>Not cleared</td>\n",
" <td>1.0</td>\n",
" <td>THEFT</td>\n",
" <td>E</td>\n",
" <td>30.355020</td>\n",
" <td>(30.35502-97.673257)</td>\n",
" <td>9701 DESSAU RD</td>\n",
" <td>-97.673257</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-29 00:00:00</td>\n",
" <td>2.014506e+10</td>\n",
" <td>3135717.0</td>\n",
" <td>10102799.0</td>\n",
" <td>2014.0</td>\n",
" <td>78754.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159291</th>\n",
" <td>(30.263215 -97.743895)</td>\n",
" <td>11</td>\n",
" <td>2014-12-14</td>\n",
" <td>Not cleared</td>\n",
" <td>9.0</td>\n",
" <td>THEFT</td>\n",
" <td>G</td>\n",
" <td>30.263215</td>\n",
" <td>(30.263215-97.743895)</td>\n",
" <td>111 E CESAR CHAVEZ ST</td>\n",
" <td>-97.743895</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-13 00:00:00</td>\n",
" <td>2.014347e+10</td>\n",
" <td>3113960.0</td>\n",
" <td>10068938.0</td>\n",
" <td>2014.0</td>\n",
" <td>78701.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159302</th>\n",
" <td>(30.342011 -97.769838)</td>\n",
" <td>17.18</td>\n",
" <td>2014-02-13</td>\n",
" <td>Not cleared</td>\n",
" <td>10.0</td>\n",
" <td>THEFT</td>\n",
" <td>B</td>\n",
" <td>30.342011</td>\n",
" <td>(30.342011-97.769838)</td>\n",
" <td>5715 MESA DR</td>\n",
" <td>-97.769838</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-02-02 00:00:00</td>\n",
" <td>2.014500e+10</td>\n",
" <td>3105425.0</td>\n",
" <td>10097522.0</td>\n",
" <td>2014.0</td>\n",
" <td>78731.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159314</th>\n",
" <td>(30.270141 -97.742042)</td>\n",
" <td>11</td>\n",
" <td>2014-08-13</td>\n",
" <td>Not cleared</td>\n",
" <td>9.0</td>\n",
" <td>THEFT</td>\n",
" <td>G</td>\n",
" <td>30.270141</td>\n",
" <td>(30.270141-97.742042)</td>\n",
" <td>823 CONGRESS AVE</td>\n",
" <td>-97.742042</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-08-10 00:00:00</td>\n",
" <td>2.014222e+10</td>\n",
" <td>3114720.0</td>\n",
" <td>10071679.0</td>\n",
" <td>2014.0</td>\n",
" <td>78701.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159319</th>\n",
" <td>(30.230214 -97.789729)</td>\n",
" <td>17.12</td>\n",
" <td>2014-03-17</td>\n",
" <td>Not cleared</td>\n",
" <td>5.0</td>\n",
" <td>THEFT</td>\n",
" <td>D</td>\n",
" <td>30.230214</td>\n",
" <td>(30.230214-97.789729)</td>\n",
" <td>2025 W BEN WHITE BLVD EB</td>\n",
" <td>-97.789729</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-02-25 00:00:00</td>\n",
" <td>2.014800e+10</td>\n",
" <td>3099711.0</td>\n",
" <td>10056294.0</td>\n",
" <td>2014.0</td>\n",
" <td>78745.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159323</th>\n",
" <td>(30.255443 -97.810066)</td>\n",
" <td>19.100000000000001</td>\n",
" <td>2014-05-22</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>8.0</td>\n",
" <td>THEFT BY SHOPLIFTING</td>\n",
" <td>D</td>\n",
" <td>30.255443</td>\n",
" <td>(30.255443-97.810066)</td>\n",
" <td>2901 S CAPITAL OF TEXAS HWY NB</td>\n",
" <td>-97.810066</td>\n",
" <td>Theft: Shoplifting</td>\n",
" <td>2014-05-16 00:00:00</td>\n",
" <td>2.014136e+10</td>\n",
" <td>3094135.0</td>\n",
" <td>10066586.0</td>\n",
" <td>2014.0</td>\n",
" <td>78746.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159330</th>\n",
" <td>(30.245613 -97.779565)</td>\n",
" <td>19.010000000000002</td>\n",
" <td>2014-05-08</td>\n",
" <td>Not cleared</td>\n",
" <td>5.0</td>\n",
" <td>THEFT</td>\n",
" <td>D</td>\n",
" <td>30.245613</td>\n",
" <td>(30.245613-97.779565)</td>\n",
" <td>2620 S LAMAR BLVD</td>\n",
" <td>-97.779565</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-04-25 00:00:00</td>\n",
" <td>2.014502e+10</td>\n",
" <td>3102814.0</td>\n",
" <td>10062425.0</td>\n",
" <td>2014.0</td>\n",
" <td>78704.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159333</th>\n",
" <td>(30.236722 -97.792161)</td>\n",
" <td>19.010000000000002</td>\n",
" <td>2014-06-06</td>\n",
" <td>Not cleared</td>\n",
" <td>5.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>D</td>\n",
" <td>30.236722</td>\n",
" <td>(30.236722-97.792161)</td>\n",
" <td>3940 S LAMAR BLVD SB</td>\n",
" <td>-97.792161</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-05-29 00:00:00</td>\n",
" <td>2.014149e+10</td>\n",
" <td>3098944.0</td>\n",
" <td>10059160.0</td>\n",
" <td>2014.0</td>\n",
" <td>78704.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159338</th>\n",
" <td>(30.352277 -97.675182)</td>\n",
" <td>18.329999999999998</td>\n",
" <td>2014-05-26</td>\n",
" <td>Not cleared</td>\n",
" <td>4.0</td>\n",
" <td>THEFT OF AUTO PARTS</td>\n",
" <td>E</td>\n",
" <td>30.352277</td>\n",
" <td>(30.352277-97.675182)</td>\n",
" <td>9500 DESSAU RD</td>\n",
" <td>-97.675182</td>\n",
" <td>Theft: Auto Parts</td>\n",
" <td>2014-05-22 00:00:00</td>\n",
" <td>2.014502e+10</td>\n",
" <td>3134899.0</td>\n",
" <td>10101953.0</td>\n",
" <td>2014.0</td>\n",
" <td>78753.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159346</th>\n",
" <td>(30.380427 -97.687226)</td>\n",
" <td>18.23</td>\n",
" <td>2014-08-14</td>\n",
" <td>Not cleared</td>\n",
" <td>4.0</td>\n",
" <td>THEFT</td>\n",
" <td>E</td>\n",
" <td>30.380427</td>\n",
" <td>(30.380427-97.687226)</td>\n",
" <td>11111 N LAMAR BLVD</td>\n",
" <td>-97.687226</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-07-08 00:00:00</td>\n",
" <td>2.014189e+10</td>\n",
" <td>3130996.0</td>\n",
" <td>10111967.0</td>\n",
" <td>2014.0</td>\n",
" <td>78753.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159349</th>\n",
" <td>(30.310071 -97.740307)</td>\n",
" <td>2.04</td>\n",
" <td>2014-03-20</td>\n",
" <td>Not cleared</td>\n",
" <td>10.0</td>\n",
" <td>THEFT</td>\n",
" <td>B</td>\n",
" <td>30.310071</td>\n",
" <td>(30.310071-97.740307)</td>\n",
" <td>1007 W 42ND ST</td>\n",
" <td>-97.740307</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-02-27 00:00:00</td>\n",
" <td>2.014501e+10</td>\n",
" <td>3114688.0</td>\n",
" <td>10086048.0</td>\n",
" <td>2014.0</td>\n",
" <td>78756.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159352</th>\n",
" <td>(30.267317 -97.73648)</td>\n",
" <td>11</td>\n",
" <td>2014-09-24</td>\n",
" <td>Not cleared</td>\n",
" <td>9.0</td>\n",
" <td>THEFT FROM PERSON</td>\n",
" <td>G</td>\n",
" <td>30.267317</td>\n",
" <td>(30.267317-97.73648)</td>\n",
" <td>611 E 7TH ST</td>\n",
" <td>-97.736480</td>\n",
" <td>Theft: Pocket Picking</td>\n",
" <td>2014-09-22 00:00:00</td>\n",
" <td>2.014504e+10</td>\n",
" <td>3116365.0</td>\n",
" <td>10070461.0</td>\n",
" <td>2014.0</td>\n",
" <td>78701.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159355</th>\n",
" <td>(30.198484 -97.754887)</td>\n",
" <td>24.11</td>\n",
" <td>2014-04-11</td>\n",
" <td>Not cleared</td>\n",
" <td>2.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>F</td>\n",
" <td>30.198484</td>\n",
" <td>(30.198484-97.754887)</td>\n",
" <td>2102 DEADWOOD DR</td>\n",
" <td>-97.754887</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-04-03 00:00:00</td>\n",
" <td>2.014501e+10</td>\n",
" <td>3111121.0</td>\n",
" <td>10045430.0</td>\n",
" <td>2014.0</td>\n",
" <td>78744.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159364</th>\n",
" <td>(30.352191 -97.702184)</td>\n",
" <td>18.059999999999999</td>\n",
" <td>2014-08-22</td>\n",
" <td>Not cleared</td>\n",
" <td>4.0</td>\n",
" <td>THEFT</td>\n",
" <td>E</td>\n",
" <td>30.352191</td>\n",
" <td>(30.352191-97.702184)</td>\n",
" <td>208 SAN JOSE ST</td>\n",
" <td>-97.702184</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-08-21 00:00:00</td>\n",
" <td>2.014233e+10</td>\n",
" <td>3126437.0</td>\n",
" <td>10101690.0</td>\n",
" <td>2014.0</td>\n",
" <td>78753.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159368</th>\n",
" <td>(30.318956 -97.703138)</td>\n",
" <td>21.05</td>\n",
" <td>2014-07-17</td>\n",
" <td>Not cleared</td>\n",
" <td>4.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>I</td>\n",
" <td>30.318956</td>\n",
" <td>(30.318956-97.703138)</td>\n",
" <td>1071 CLAYTON LN</td>\n",
" <td>-97.703138</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-07-17 00:00:00</td>\n",
" <td>2.014503e+10</td>\n",
" <td>3126310.0</td>\n",
" <td>10089393.0</td>\n",
" <td>2014.0</td>\n",
" <td>78723.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159374</th>\n",
" <td>(30.311037 -97.69757)</td>\n",
" <td>21.04</td>\n",
" <td>2014-02-10</td>\n",
" <td>Not cleared</td>\n",
" <td>4.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>I</td>\n",
" <td>30.311037</td>\n",
" <td>(30.311037-97.69757)</td>\n",
" <td>1503 RIDGEMONT DR</td>\n",
" <td>-97.697570</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-02-03 00:00:00</td>\n",
" <td>2.014501e+10</td>\n",
" <td>3128174.0</td>\n",
" <td>10086642.0</td>\n",
" <td>2014.0</td>\n",
" <td>78723.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159381</th>\n",
" <td>(30.226485 -97.726009)</td>\n",
" <td>23.13</td>\n",
" <td>2014-06-16</td>\n",
" <td>Not cleared</td>\n",
" <td>3.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>H</td>\n",
" <td>30.226485</td>\n",
" <td>(30.226485-97.726009)</td>\n",
" <td>2405 HUNTWICK DR</td>\n",
" <td>-97.726009</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-06-14 00:00:00</td>\n",
" <td>2.014165e+10</td>\n",
" <td>3119941.0</td>\n",
" <td>10055660.0</td>\n",
" <td>2014.0</td>\n",
" <td>78741.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159388</th>\n",
" <td>(30.302549 -97.704957)</td>\n",
" <td>3.06</td>\n",
" <td>2014-10-08</td>\n",
" <td>Not cleared</td>\n",
" <td>9.0</td>\n",
" <td>THEFT</td>\n",
" <td>B</td>\n",
" <td>30.302549</td>\n",
" <td>(30.302549-97.704957)</td>\n",
" <td>4900 MUELLER BLVD</td>\n",
" <td>-97.704957</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-09-13 00:00:00</td>\n",
" <td>2.014504e+10</td>\n",
" <td>3125563.0</td>\n",
" <td>10083887.0</td>\n",
" <td>2014.0</td>\n",
" <td>78723.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159400</th>\n",
" <td>(30.258532 -97.750565)</td>\n",
" <td>13.05</td>\n",
" <td>2014-04-03</td>\n",
" <td>Not cleared</td>\n",
" <td>9.0</td>\n",
" <td>THEFT</td>\n",
" <td>D</td>\n",
" <td>30.258532</td>\n",
" <td>(30.258532-97.750565)</td>\n",
" <td>601 BARTON SPRINGS RD</td>\n",
" <td>-97.750565</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-03-24 00:00:00</td>\n",
" <td>2.014501e+10</td>\n",
" <td>3111925.0</td>\n",
" <td>10067112.0</td>\n",
" <td>2014.0</td>\n",
" <td>78704.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159406</th>\n",
" <td>(30.417834 -97.846823)</td>\n",
" <td>17.14</td>\n",
" <td>2014-12-17</td>\n",
" <td>Not cleared</td>\n",
" <td>6.0</td>\n",
" <td>THEFT BY SHOPLIFTING</td>\n",
" <td>A</td>\n",
" <td>30.417834</td>\n",
" <td>(30.417834-97.846823)</td>\n",
" <td>8201 N FM 620 RD</td>\n",
" <td>-97.846823</td>\n",
" <td>Theft: Shoplifting</td>\n",
" <td>2014-05-31 00:00:00</td>\n",
" <td>2.014151e+10</td>\n",
" <td>3080616.0</td>\n",
" <td>10124342.0</td>\n",
" <td>2014.0</td>\n",
" <td>78726.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159410</th>\n",
" <td>(30.182709 -97.769248)</td>\n",
" <td>24.27</td>\n",
" <td>2014-10-07</td>\n",
" <td>Not cleared</td>\n",
" <td>2.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>F</td>\n",
" <td>30.182709</td>\n",
" <td>(30.182709-97.769248)</td>\n",
" <td>7100 BLUFF SPRINGS RD</td>\n",
" <td>-97.769248</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-10-05 00:00:00</td>\n",
" <td>2.014504e+10</td>\n",
" <td>3106107.0</td>\n",
" <td>10039972.0</td>\n",
" <td>2014.0</td>\n",
" <td>78744.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159418</th>\n",
" <td>(30.372228 -97.700074)</td>\n",
" <td>18.22</td>\n",
" <td>2014-11-07</td>\n",
" <td>Not cleared</td>\n",
" <td>4.0</td>\n",
" <td>AGG ASLT STRANGLE/SUFFOCATE</td>\n",
" <td>E</td>\n",
" <td>30.372228</td>\n",
" <td>(30.372228-97.700074)</td>\n",
" <td>9920 QUAIL BLVD</td>\n",
" <td>-97.700074</td>\n",
" <td>Aggravated Assault</td>\n",
" <td>2014-10-09 00:00:00</td>\n",
" <td>2.014282e+10</td>\n",
" <td>3126909.0</td>\n",
" <td>10109014.0</td>\n",
" <td>2014.0</td>\n",
" <td>78758.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159430</th>\n",
" <td>(30.265947 -97.767973)</td>\n",
" <td>19.11</td>\n",
" <td>2014-10-14</td>\n",
" <td>Not cleared</td>\n",
" <td>8.0</td>\n",
" <td>THEFT</td>\n",
" <td>D</td>\n",
" <td>30.265947</td>\n",
" <td>(30.265947-97.767973)</td>\n",
" <td>2100 BARTON SPRINGS RD</td>\n",
" <td>-97.767973</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-10-13 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3106394.0</td>\n",
" <td>10070460.0</td>\n",
" <td>2014.0</td>\n",
" <td>78746.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159439</th>\n",
" <td>(30.38253 -97.714384)</td>\n",
" <td>18.21</td>\n",
" <td>2014-10-20</td>\n",
" <td>Not cleared</td>\n",
" <td>4.0</td>\n",
" <td>THEFT</td>\n",
" <td>E</td>\n",
" <td>30.382530</td>\n",
" <td>(30.38253-97.714384)</td>\n",
" <td>10300 METRIC BLVD</td>\n",
" <td>-97.714384</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-09-03 00:00:00</td>\n",
" <td>2.014504e+10</td>\n",
" <td>3122006.0</td>\n",
" <td>10112742.0</td>\n",
" <td>2014.0</td>\n",
" <td>78758.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159444</th>\n",
" <td>(30.339922 -97.761682)</td>\n",
" <td>1.02</td>\n",
" <td>2014-03-03</td>\n",
" <td>Not cleared</td>\n",
" <td>10.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>B</td>\n",
" <td>30.339922</td>\n",
" <td>(30.339922-97.761682)</td>\n",
" <td>5508 CAPRICE DR</td>\n",
" <td>-97.761682</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-02-23 00:00:00</td>\n",
" <td>2.014501e+10</td>\n",
" <td>3107659.0</td>\n",
" <td>10096800.0</td>\n",
" <td>2014.0</td>\n",
" <td>78731.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159450</th>\n",
" <td>(30.312239 -97.662693)</td>\n",
" <td>22.01</td>\n",
" <td>2014-12-05</td>\n",
" <td>Not cleared</td>\n",
" <td>1.0</td>\n",
" <td>THEFT</td>\n",
" <td>C</td>\n",
" <td>30.312239</td>\n",
" <td>(30.312239-97.662693)</td>\n",
" <td>7112 ED BLUESTEIN BLVD NB</td>\n",
" <td>-97.662693</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-11-25 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3139137.0</td>\n",
" <td>10088360.0</td>\n",
" <td>2014.0</td>\n",
" <td>78724.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159453</th>\n",
" <td>(30.393536 -97.645133)</td>\n",
" <td>18.39</td>\n",
" <td>2014-03-27</td>\n",
" <td>Not cleared</td>\n",
" <td>7.0</td>\n",
" <td>THEFT</td>\n",
" <td>E</td>\n",
" <td>30.393536</td>\n",
" <td>(30.393536-97.645133)</td>\n",
" <td>12600 DESSAU RD</td>\n",
" <td>-97.645133</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-03-26 00:00:00</td>\n",
" <td>2.014851e+09</td>\n",
" <td>3144046.0</td>\n",
" <td>10117185.0</td>\n",
" <td>2014.0</td>\n",
" <td>78753.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159456</th>\n",
" <td>(30.405797 -97.74491)</td>\n",
" <td>17.54</td>\n",
" <td>2015-01-04</td>\n",
" <td>Not cleared</td>\n",
" <td>7.0</td>\n",
" <td>AGG ASLT ENHANC STRANGL/SUFFOC</td>\n",
" <td>A</td>\n",
" <td>30.405797</td>\n",
" <td>(30.405797-97.74491)</td>\n",
" <td>11111 RESEARCH BLVD SVRD NB</td>\n",
" <td>-97.744910</td>\n",
" <td>Aggravated Assault</td>\n",
" <td>2014-12-28 00:00:00</td>\n",
" <td>2.014362e+10</td>\n",
" <td>3112507.0</td>\n",
" <td>10120833.0</td>\n",
" <td>2014.0</td>\n",
" <td>78759.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159459</th>\n",
" <td>(30.207396 -97.728709)</td>\n",
" <td>24.31</td>\n",
" <td>2014-06-04</td>\n",
" <td>Not cleared</td>\n",
" <td>2.0</td>\n",
" <td>THEFT OF METAL</td>\n",
" <td>F</td>\n",
" <td>30.207396</td>\n",
" <td>(30.207396-97.728709)</td>\n",
" <td>4000 CAVEN RD</td>\n",
" <td>-97.728709</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-06-03 00:00:00</td>\n",
" <td>2.014502e+10</td>\n",
" <td>3119195.0</td>\n",
" <td>10048844.0</td>\n",
" <td>2014.0</td>\n",
" <td>78744.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159463</th>\n",
" <td>(30.226552 -97.741977)</td>\n",
" <td>23.07</td>\n",
" <td>2014-07-30</td>\n",
" <td>Not cleared</td>\n",
" <td>3.0</td>\n",
" <td>THEFT</td>\n",
" <td>H</td>\n",
" <td>30.226552</td>\n",
" <td>(30.226552-97.741977)</td>\n",
" <td>1712 TIMBER RIDGE DR</td>\n",
" <td>-97.741977</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-06-30 00:00:00</td>\n",
" <td>2.014503e+10</td>\n",
" <td>3114890.0</td>\n",
" <td>10055706.0</td>\n",
" <td>2014.0</td>\n",
" <td>78741.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>27459 rows × 18 columns</p>\n",
"</div>"
],
"text/plain": [
" address census_tract clearance_date \\\n",
"4 (30.298356 -97.719647) 3.02 2014-07-29 \n",
"9 (30.272154 -97.730002) 8.029999999999999 2014-05-08 \n",
"14 (30.201243 -97.709249) 24.31 2014-05-09 \n",
"17 (30.271198 -97.705609) 8.02 2014-12-19 \n",
"20 (30.356418 -97.731423) 18.170000000000002 2014-04-17 \n",
"26 (30.426691 -97.77719) 17.559999999999999 2014-10-07 \n",
"29 (30.260544 -97.711225) 9.02 2014-12-01 \n",
"32 (30.20938 -97.805891) 17.13 2014-03-25 \n",
"38 (30.190722 -97.752915) 24.12 2014-08-13 \n",
"42 (30.322904 -97.710548) 15.03 2014-09-24 \n",
"46 (30.298396 -97.677709) 21.07 2014-07-17 \n",
"56 (30.340296 -97.755204) 17.18 2014-06-02 \n",
"68 (30.499098 -97.77256) 205.1 2014-02-10 \n",
"77 (30.220698 -97.744858) 23.07 2014-03-27 \n",
"86 (30.224918 -97.70321) 23.12 2015-01-02 \n",
"89 (30.32945 -97.690009) 18.11 2014-07-01 \n",
"96 (30.434138 -97.782883) 17.82 2014-10-23 \n",
"99 (30.212695 -97.745743) 24.11 2014-04-18 \n",
"106 (30.191043 -97.771802) 24.02 2014-12-24 \n",
"109 (30.238285 -97.754014) 13.08 2014-08-05 \n",
"112 (30.214683 -97.769154) 24.03 2014-06-30 \n",
"123 (30.412351 -97.707908) 18.5 2014-04-16 \n",
"126 (30.266739 -97.738086) 11 2014-02-27 \n",
"131 (30.216942 -97.754349) 24.03 2014-03-11 \n",
"138 (30.362887 -97.717631) 18.18 2014-03-18 \n",
"146 (30.372213 -97.730029) 18.170000000000002 2014-05-06 \n",
"150 (30.336574 -97.718265) 15.03 2014-12-30 \n",
"156 (30.367124 -97.684698) 18.23 2014-03-17 \n",
"159 (30.265106 -97.73654) 11 2014-12-11 \n",
"163 (30.40921 -97.744708) 17.54 2014-12-15 \n",
"... ... ... ... \n",
"159285 (30.35502 -97.673257) 18.34 2014-12-30 \n",
"159291 (30.263215 -97.743895) 11 2014-12-14 \n",
"159302 (30.342011 -97.769838) 17.18 2014-02-13 \n",
"159314 (30.270141 -97.742042) 11 2014-08-13 \n",
"159319 (30.230214 -97.789729) 17.12 2014-03-17 \n",
"159323 (30.255443 -97.810066) 19.100000000000001 2014-05-22 \n",
"159330 (30.245613 -97.779565) 19.010000000000002 2014-05-08 \n",
"159333 (30.236722 -97.792161) 19.010000000000002 2014-06-06 \n",
"159338 (30.352277 -97.675182) 18.329999999999998 2014-05-26 \n",
"159346 (30.380427 -97.687226) 18.23 2014-08-14 \n",
"159349 (30.310071 -97.740307) 2.04 2014-03-20 \n",
"159352 (30.267317 -97.73648) 11 2014-09-24 \n",
"159355 (30.198484 -97.754887) 24.11 2014-04-11 \n",
"159364 (30.352191 -97.702184) 18.059999999999999 2014-08-22 \n",
"159368 (30.318956 -97.703138) 21.05 2014-07-17 \n",
"159374 (30.311037 -97.69757) 21.04 2014-02-10 \n",
"159381 (30.226485 -97.726009) 23.13 2014-06-16 \n",
"159388 (30.302549 -97.704957) 3.06 2014-10-08 \n",
"159400 (30.258532 -97.750565) 13.05 2014-04-03 \n",
"159406 (30.417834 -97.846823) 17.14 2014-12-17 \n",
"159410 (30.182709 -97.769248) 24.27 2014-10-07 \n",
"159418 (30.372228 -97.700074) 18.22 2014-11-07 \n",
"159430 (30.265947 -97.767973) 19.11 2014-10-14 \n",
"159439 (30.38253 -97.714384) 18.21 2014-10-20 \n",
"159444 (30.339922 -97.761682) 1.02 2014-03-03 \n",
"159450 (30.312239 -97.662693) 22.01 2014-12-05 \n",
"159453 (30.393536 -97.645133) 18.39 2014-03-27 \n",
"159456 (30.405797 -97.74491) 17.54 2015-01-04 \n",
"159459 (30.207396 -97.728709) 24.31 2014-06-04 \n",
"159463 (30.226552 -97.741977) 23.07 2014-07-30 \n",
"\n",
" clearance_status council_district_code \\\n",
"4 Cleared by Arrest 9.0 \n",
"9 Not cleared 1.0 \n",
"14 Not cleared 2.0 \n",
"17 Not cleared 1.0 \n",
"20 Not cleared 7.0 \n",
"26 Not cleared 10.0 \n",
"29 Cleared by Arrest 3.0 \n",
"32 Not cleared 5.0 \n",
"38 Cleared by Exception 2.0 \n",
"42 Not cleared 4.0 \n",
"46 Not cleared 1.0 \n",
"56 Not cleared 10.0 \n",
"68 Cleared by Exception 6.0 \n",
"77 Not cleared 3.0 \n",
"86 Not cleared 3.0 \n",
"89 Cleared by Arrest 1.0 \n",
"96 Not cleared 6.0 \n",
"99 Not cleared 2.0 \n",
"106 Not cleared 2.0 \n",
"109 Cleared by Arrest 3.0 \n",
"112 Not cleared 3.0 \n",
"123 Not cleared 7.0 \n",
"126 Cleared by Arrest 9.0 \n",
"131 Not cleared 3.0 \n",
"138 Not cleared 7.0 \n",
"146 Not cleared 7.0 \n",
"150 Not cleared 4.0 \n",
"156 Not cleared 4.0 \n",
"159 Cleared by Arrest 9.0 \n",
"163 Not cleared 6.0 \n",
"... ... ... \n",
"159285 Not cleared 1.0 \n",
"159291 Not cleared 9.0 \n",
"159302 Not cleared 10.0 \n",
"159314 Not cleared 9.0 \n",
"159319 Not cleared 5.0 \n",
"159323 Cleared by Arrest 8.0 \n",
"159330 Not cleared 5.0 \n",
"159333 Not cleared 5.0 \n",
"159338 Not cleared 4.0 \n",
"159346 Not cleared 4.0 \n",
"159349 Not cleared 10.0 \n",
"159352 Not cleared 9.0 \n",
"159355 Not cleared 2.0 \n",
"159364 Not cleared 4.0 \n",
"159368 Not cleared 4.0 \n",
"159374 Not cleared 4.0 \n",
"159381 Not cleared 3.0 \n",
"159388 Not cleared 9.0 \n",
"159400 Not cleared 9.0 \n",
"159406 Not cleared 6.0 \n",
"159410 Not cleared 2.0 \n",
"159418 Not cleared 4.0 \n",
"159430 Not cleared 8.0 \n",
"159439 Not cleared 4.0 \n",
"159444 Not cleared 10.0 \n",
"159450 Not cleared 1.0 \n",
"159453 Not cleared 7.0 \n",
"159456 Not cleared 7.0 \n",
"159459 Not cleared 2.0 \n",
"159463 Not cleared 3.0 \n",
"\n",
" description district latitude \\\n",
"4 THEFT BY SHOPLIFTING B 30.298356 \n",
"9 AUTO THEFT C 30.272154 \n",
"14 THEFT H 30.201243 \n",
"17 AUTO THEFT C 30.271198 \n",
"20 THEFT B 30.356418 \n",
"26 THEFT A 30.426691 \n",
"29 THEFT C 30.260544 \n",
"32 BURGLARY OF VEHICLE D 30.209380 \n",
"38 THEFT F 30.190722 \n",
"42 THEFT I 30.322904 \n",
"46 BURGLARY OF VEHICLE I 30.298396 \n",
"56 BURGLARY OF VEHICLE B 30.340296 \n",
"68 THEFT A 30.499098 \n",
"77 BURGLARY OF VEHICLE H 30.220698 \n",
"86 THEFT BY SHOPLIFTING H 30.224918 \n",
"89 THEFT I 30.329450 \n",
"96 THEFT OF LICENSE PLATE A 30.434138 \n",
"99 THEFT OF VEHICLE/OTHER F 30.212695 \n",
"106 BURGLARY OF VEHICLE F 30.191043 \n",
"109 THEFT D 30.238285 \n",
"112 BURGLARY OF VEHICLE D 30.214683 \n",
"123 THEFT A 30.412351 \n",
"126 AGG ASSAULT G 30.266739 \n",
"131 THEFT D 30.216942 \n",
"138 THEFT I 30.362887 \n",
"146 THEFT B 30.372213 \n",
"150 THEFT BY SHOPLIFTING I 30.336574 \n",
"156 THEFT E 30.367124 \n",
"159 THEFT G 30.265106 \n",
"163 BURGLARY OF VEHICLE A 30.409210 \n",
"... ... ... ... \n",
"159285 THEFT E 30.355020 \n",
"159291 THEFT G 30.263215 \n",
"159302 THEFT B 30.342011 \n",
"159314 THEFT G 30.270141 \n",
"159319 THEFT D 30.230214 \n",
"159323 THEFT BY SHOPLIFTING D 30.255443 \n",
"159330 THEFT D 30.245613 \n",
"159333 BURGLARY OF VEHICLE D 30.236722 \n",
"159338 THEFT OF AUTO PARTS E 30.352277 \n",
"159346 THEFT E 30.380427 \n",
"159349 THEFT B 30.310071 \n",
"159352 THEFT FROM PERSON G 30.267317 \n",
"159355 BURGLARY OF VEHICLE F 30.198484 \n",
"159364 THEFT E 30.352191 \n",
"159368 BURGLARY OF VEHICLE I 30.318956 \n",
"159374 BURGLARY OF VEHICLE I 30.311037 \n",
"159381 BURGLARY OF VEHICLE H 30.226485 \n",
"159388 THEFT B 30.302549 \n",
"159400 THEFT D 30.258532 \n",
"159406 THEFT BY SHOPLIFTING A 30.417834 \n",
"159410 BURGLARY OF VEHICLE F 30.182709 \n",
"159418 AGG ASLT STRANGLE/SUFFOCATE E 30.372228 \n",
"159430 THEFT D 30.265947 \n",
"159439 THEFT E 30.382530 \n",
"159444 BURGLARY OF VEHICLE B 30.339922 \n",
"159450 THEFT C 30.312239 \n",
"159453 THEFT E 30.393536 \n",
"159456 AGG ASLT ENHANC STRANGL/SUFFOC A 30.405797 \n",
"159459 THEFT OF METAL F 30.207396 \n",
"159463 THEFT H 30.226552 \n",
"\n",
" location location_description longitude \\\n",
"4 (30.298356-97.719647) 1000 E 41ST ST -97.719647 \n",
"9 (30.272154-97.730002) 1000 E 12TH ST -97.730002 \n",
"14 (30.201243-97.709249) 6800 BURLESON RD -97.709249 \n",
"17 (30.271198-97.705609) 3506 WEBBERVILLE RD -97.705609 \n",
"20 (30.356418-97.731423) 2438 W ANDERSON LN -97.731423 \n",
"26 (30.426691-97.77719) 11304 BLACKMOOR DR -97.777190 \n",
"29 (30.260544-97.711225) 2701 E 7TH ST -97.711225 \n",
"32 (30.20938-97.805891) 2309 BERKELEY AVE -97.805891 \n",
"38 (30.190722-97.752915) 2515 DOVEMEADOW DR -97.752915 \n",
"42 (30.322904-97.710548) 6000 MIDDLE FISKVILLE RD -97.710548 \n",
"46 (30.298396-97.677709) 5407 PENDLETON LN -97.677709 \n",
"56 (30.340296-97.755204) 5929 BALCONES DR -97.755204 \n",
"68 (30.499098-97.77256) 15111 AVERY RANCH BLVD -97.772560 \n",
"77 (30.220698-97.744858) 1718 WOODWARD ST -97.744858 \n",
"86 (30.224918-97.70321) 6306 E RIVERSIDE DR -97.703210 \n",
"89 (30.32945-97.690009) 7517 CAMERON RD -97.690009 \n",
"96 (30.434138-97.782883) 11521 KEMPWOOD DR -97.782883 \n",
"99 (30.212695-97.745743) 2150 WOODWARD ST -97.745743 \n",
"106 (30.191043-97.771802) 800 E WILLIAM CANNON DR -97.771802 \n",
"109 (30.238285-97.754014) 2400 S CONGRESS AVE -97.754014 \n",
"112 (30.214683-97.769154) 4729 S CONGRESS AVE -97.769154 \n",
"123 (30.412351-97.707908) 12221 N MOPAC EXPY SVRD NB -97.707908 \n",
"126 (30.266739-97.738086) 500 E 6TH ST -97.738086 \n",
"131 (30.216942-97.754349) 1001 E BEN WHITE BLVD SVRD EB -97.754349 \n",
"138 (30.362887-97.717631) 8630 RESEARCH BLVD SB -97.717631 \n",
"146 (30.372213-97.730029) 8800 MC CANN DR -97.730029 \n",
"150 (30.336574-97.718265) 6929 AIRPORT BLVD -97.718265 \n",
"156 (30.367124-97.684698) 10205 BROWNIE DR -97.684698 \n",
"159 (30.265106-97.73654) 415 SABINE ST -97.736540 \n",
"163 (30.40921-97.744708) 11215 RESEARCH BLVD NB -97.744708 \n",
"... ... ... ... \n",
"159285 (30.35502-97.673257) 9701 DESSAU RD -97.673257 \n",
"159291 (30.263215-97.743895) 111 E CESAR CHAVEZ ST -97.743895 \n",
"159302 (30.342011-97.769838) 5715 MESA DR -97.769838 \n",
"159314 (30.270141-97.742042) 823 CONGRESS AVE -97.742042 \n",
"159319 (30.230214-97.789729) 2025 W BEN WHITE BLVD EB -97.789729 \n",
"159323 (30.255443-97.810066) 2901 S CAPITAL OF TEXAS HWY NB -97.810066 \n",
"159330 (30.245613-97.779565) 2620 S LAMAR BLVD -97.779565 \n",
"159333 (30.236722-97.792161) 3940 S LAMAR BLVD SB -97.792161 \n",
"159338 (30.352277-97.675182) 9500 DESSAU RD -97.675182 \n",
"159346 (30.380427-97.687226) 11111 N LAMAR BLVD -97.687226 \n",
"159349 (30.310071-97.740307) 1007 W 42ND ST -97.740307 \n",
"159352 (30.267317-97.73648) 611 E 7TH ST -97.736480 \n",
"159355 (30.198484-97.754887) 2102 DEADWOOD DR -97.754887 \n",
"159364 (30.352191-97.702184) 208 SAN JOSE ST -97.702184 \n",
"159368 (30.318956-97.703138) 1071 CLAYTON LN -97.703138 \n",
"159374 (30.311037-97.69757) 1503 RIDGEMONT DR -97.697570 \n",
"159381 (30.226485-97.726009) 2405 HUNTWICK DR -97.726009 \n",
"159388 (30.302549-97.704957) 4900 MUELLER BLVD -97.704957 \n",
"159400 (30.258532-97.750565) 601 BARTON SPRINGS RD -97.750565 \n",
"159406 (30.417834-97.846823) 8201 N FM 620 RD -97.846823 \n",
"159410 (30.182709-97.769248) 7100 BLUFF SPRINGS RD -97.769248 \n",
"159418 (30.372228-97.700074) 9920 QUAIL BLVD -97.700074 \n",
"159430 (30.265947-97.767973) 2100 BARTON SPRINGS RD -97.767973 \n",
"159439 (30.38253-97.714384) 10300 METRIC BLVD -97.714384 \n",
"159444 (30.339922-97.761682) 5508 CAPRICE DR -97.761682 \n",
"159450 (30.312239-97.662693) 7112 ED BLUESTEIN BLVD NB -97.662693 \n",
"159453 (30.393536-97.645133) 12600 DESSAU RD -97.645133 \n",
"159456 (30.405797-97.74491) 11111 RESEARCH BLVD SVRD NB -97.744910 \n",
"159459 (30.207396-97.728709) 4000 CAVEN RD -97.728709 \n",
"159463 (30.226552-97.741977) 1712 TIMBER RIDGE DR -97.741977 \n",
"\n",
" primary_type timestamp unique_key \\\n",
"4 Theft: Shoplifting 2014-04-04 00:00:00 2.014941e+09 \n",
"9 Auto Theft 2014-04-04 00:00:00 2.014941e+09 \n",
"14 Theft: All Other Larceny 2014-05-08 00:00:00 2.014502e+10 \n",
"17 Auto Theft 2014-12-18 00:00:00 2.014352e+10 \n",
"20 Theft: All Other Larceny 2014-04-16 00:00:00 2.014502e+10 \n",
"26 Theft: All Other Larceny 2014-10-01 00:00:00 2.014504e+10 \n",
"29 Theft: All Other Larceny 2014-11-28 00:00:00 2.014332e+10 \n",
"32 Theft: BOV 2014-03-14 00:00:00 2.014501e+10 \n",
"38 Theft: All Other Larceny 2014-07-07 00:00:00 2.014188e+10 \n",
"42 Theft: All Other Larceny 2014-09-22 00:00:00 2.014504e+10 \n",
"46 Theft: BOV 2014-07-16 00:00:00 2.014503e+10 \n",
"56 Theft: BOV 2014-05-13 00:00:00 2.014502e+10 \n",
"68 Theft: All Other Larceny 2014-01-13 00:00:00 2.014500e+10 \n",
"77 Theft: BOV 2014-03-26 00:00:00 2.014501e+10 \n",
"86 Theft: Shoplifting 2014-12-28 00:00:00 2.014362e+10 \n",
"89 Theft: All Other Larceny 2014-06-28 00:00:00 2.014179e+10 \n",
"96 Theft: All Other Larceny 2014-10-19 00:00:00 2.014505e+10 \n",
"99 Theft: All Other Larceny 2014-03-28 00:00:00 2.014871e+09 \n",
"106 Theft: BOV 2014-12-20 00:00:00 2.014506e+10 \n",
"109 Theft: All Other Larceny 2014-08-04 00:00:00 2.014216e+10 \n",
"112 Theft: BOV 2014-06-03 00:00:00 2.014502e+10 \n",
"123 Theft: All Other Larceny 2014-04-15 00:00:00 2.014502e+10 \n",
"126 Aggravated Assault 2014-02-23 00:00:00 2.014540e+09 \n",
"131 Theft: All Other Larceny 2014-03-08 00:00:00 2.014671e+09 \n",
"138 Theft: All Other Larceny 2014-01-31 00:00:00 2.014500e+10 \n",
"146 Theft: All Other Larceny 2014-05-02 00:00:00 2.014502e+10 \n",
"150 Theft: Shoplifting 2014-12-14 00:00:00 2.014348e+10 \n",
"156 Theft: All Other Larceny 2014-01-20 00:00:00 2.014202e+09 \n",
"159 Theft: All Other Larceny 2014-09-25 00:00:00 2.014268e+10 \n",
"163 Theft: BOV 2014-12-14 00:00:00 2.014505e+10 \n",
"... ... ... ... \n",
"159285 Theft: All Other Larceny 2014-12-29 00:00:00 2.014506e+10 \n",
"159291 Theft: All Other Larceny 2014-12-13 00:00:00 2.014347e+10 \n",
"159302 Theft: All Other Larceny 2014-02-02 00:00:00 2.014500e+10 \n",
"159314 Theft: All Other Larceny 2014-08-10 00:00:00 2.014222e+10 \n",
"159319 Theft: All Other Larceny 2014-02-25 00:00:00 2.014800e+10 \n",
"159323 Theft: Shoplifting 2014-05-16 00:00:00 2.014136e+10 \n",
"159330 Theft: All Other Larceny 2014-04-25 00:00:00 2.014502e+10 \n",
"159333 Theft: BOV 2014-05-29 00:00:00 2.014149e+10 \n",
"159338 Theft: Auto Parts 2014-05-22 00:00:00 2.014502e+10 \n",
"159346 Theft: All Other Larceny 2014-07-08 00:00:00 2.014189e+10 \n",
"159349 Theft: All Other Larceny 2014-02-27 00:00:00 2.014501e+10 \n",
"159352 Theft: Pocket Picking 2014-09-22 00:00:00 2.014504e+10 \n",
"159355 Theft: BOV 2014-04-03 00:00:00 2.014501e+10 \n",
"159364 Theft: All Other Larceny 2014-08-21 00:00:00 2.014233e+10 \n",
"159368 Theft: BOV 2014-07-17 00:00:00 2.014503e+10 \n",
"159374 Theft: BOV 2014-02-03 00:00:00 2.014501e+10 \n",
"159381 Theft: BOV 2014-06-14 00:00:00 2.014165e+10 \n",
"159388 Theft: All Other Larceny 2014-09-13 00:00:00 2.014504e+10 \n",
"159400 Theft: All Other Larceny 2014-03-24 00:00:00 2.014501e+10 \n",
"159406 Theft: Shoplifting 2014-05-31 00:00:00 2.014151e+10 \n",
"159410 Theft: BOV 2014-10-05 00:00:00 2.014504e+10 \n",
"159418 Aggravated Assault 2014-10-09 00:00:00 2.014282e+10 \n",
"159430 Theft: All Other Larceny 2014-10-13 00:00:00 2.014505e+10 \n",
"159439 Theft: All Other Larceny 2014-09-03 00:00:00 2.014504e+10 \n",
"159444 Theft: BOV 2014-02-23 00:00:00 2.014501e+10 \n",
"159450 Theft: All Other Larceny 2014-11-25 00:00:00 2.014505e+10 \n",
"159453 Theft: All Other Larceny 2014-03-26 00:00:00 2.014851e+09 \n",
"159456 Aggravated Assault 2014-12-28 00:00:00 2.014362e+10 \n",
"159459 Theft: All Other Larceny 2014-06-03 00:00:00 2.014502e+10 \n",
"159463 Theft: All Other Larceny 2014-06-30 00:00:00 2.014503e+10 \n",
"\n",
" x_coordinate y_coordinate year zipcode \n",
"4 3121345.0 10082705.0 2014.0 78751.0 \n",
"9 3118304.0 10072414.0 2014.0 78702.0 \n",
"14 3125886.0 10047276.0 2014.0 78744.0 \n",
"17 3125976.0 10072207.0 2014.0 78702.0 \n",
"20 3117183.0 10103211.0 2014.0 78757.0 \n",
"26 3102055.0 10128145.0 2014.0 78759.0 \n",
"29 3124306.0 10067892.0 2014.0 78702.0 \n",
"32 3094587.0 10048955.0 2014.0 78745.0 \n",
"38 3111716.0 10042505.0 2014.0 78744.0 \n",
"42 3123931.0 10091029.0 2014.0 78752.0 \n",
"46 3134588.0 10082195.0 2014.0 78723.0 \n",
"56 3110257.0 10097698.0 2014.0 78731.0 \n",
"68 3103012.0 10154463.0 2014.0 78717.0 \n",
"77 3114115.0 10053567.0 2014.0 78741.0 \n",
"86 3127258.0 10055405.0 2014.0 78741.0 \n",
"89 3130685.0 10093333.0 2014.0 78752.0 \n",
"96 3100383.0 10130884.0 2014.0 78750.0 \n",
"99 3114393.0 10050515.0 2014.0 78744.0 \n",
"106 3105816.0 10042612.0 2014.0 78745.0 \n",
"109 3110845.0 10059841.0 2014.0 78704.0 \n",
"112 3106445.0 10051054.0 2014.0 78745.0 \n",
"123 3124636.0 10124176.0 2014.0 78758.0 \n",
"126 3115841.0 10070419.0 2014.0 78701.0 \n",
"131 3111103.0 10052022.0 2014.0 78745.0 \n",
"138 3121360.0 10105357.0 2014.0 78757.0 \n",
"146 3117467.0 10108775.0 2014.0 78757.0 \n",
"150 3121678.0 10096228.0 2014.0 78752.0 \n",
"156 3131888.0 10107188.0 2014.0 78753.0 \n",
"159 3116350.0 10069732.0 2014.0 78701.0 \n",
"163 3112999.0 10122087.0 2014.0 78759.0 \n",
"... ... ... ... ... \n",
"159285 3135717.0 10102799.0 2014.0 78754.0 \n",
"159291 3113960.0 10068938.0 2014.0 78701.0 \n",
"159302 3105425.0 10097522.0 2014.0 78731.0 \n",
"159314 3114720.0 10071679.0 2014.0 78701.0 \n",
"159319 3099711.0 10056294.0 2014.0 78745.0 \n",
"159323 3094135.0 10066586.0 2014.0 78746.0 \n",
"159330 3102814.0 10062425.0 2014.0 78704.0 \n",
"159333 3098944.0 10059160.0 2014.0 78704.0 \n",
"159338 3134899.0 10101953.0 2014.0 78753.0 \n",
"159346 3130996.0 10111967.0 2014.0 78753.0 \n",
"159349 3114688.0 10086048.0 2014.0 78756.0 \n",
"159352 3116365.0 10070461.0 2014.0 78701.0 \n",
"159355 3111121.0 10045430.0 2014.0 78744.0 \n",
"159364 3126437.0 10101690.0 2014.0 78753.0 \n",
"159368 3126310.0 10089393.0 2014.0 78723.0 \n",
"159374 3128174.0 10086642.0 2014.0 78723.0 \n",
"159381 3119941.0 10055660.0 2014.0 78741.0 \n",
"159388 3125563.0 10083887.0 2014.0 78723.0 \n",
"159400 3111925.0 10067112.0 2014.0 78704.0 \n",
"159406 3080616.0 10124342.0 2014.0 78726.0 \n",
"159410 3106107.0 10039972.0 2014.0 78744.0 \n",
"159418 3126909.0 10109014.0 2014.0 78758.0 \n",
"159430 3106394.0 10070460.0 2014.0 78746.0 \n",
"159439 3122006.0 10112742.0 2014.0 78758.0 \n",
"159444 3107659.0 10096800.0 2014.0 78731.0 \n",
"159450 3139137.0 10088360.0 2014.0 78724.0 \n",
"159453 3144046.0 10117185.0 2014.0 78753.0 \n",
"159456 3112507.0 10120833.0 2014.0 78759.0 \n",
"159459 3119195.0 10048844.0 2014.0 78744.0 \n",
"159463 3114890.0 10055706.0 2014.0 78741.0 \n",
"\n",
"[27459 rows x 18 columns]"
]
},
"execution_count": 19,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df"
]
},
{
"cell_type": "code",
"execution_count": 21,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>address</th>\n",
" <th>census_tract</th>\n",
" <th>clearance_date</th>\n",
" <th>clearance_status</th>\n",
" <th>council_district_code</th>\n",
" <th>description</th>\n",
" <th>district</th>\n",
" <th>latitude</th>\n",
" <th>location</th>\n",
" <th>location_description</th>\n",
" <th>longitude</th>\n",
" <th>primary_type</th>\n",
" <th>timestamp</th>\n",
" <th>unique_key</th>\n",
" <th>x_coordinate</th>\n",
" <th>y_coordinate</th>\n",
" <th>year</th>\n",
" <th>zipcode</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>(30.271198 -97.705609)</td>\n",
" <td>8.02</td>\n",
" <td>2014-12-19</td>\n",
" <td>Not cleared</td>\n",
" <td>1.0</td>\n",
" <td>AUTO THEFT</td>\n",
" <td>C</td>\n",
" <td>30.271198</td>\n",
" <td>(30.271198-97.705609)</td>\n",
" <td>3506 WEBBERVILLE RD</td>\n",
" <td>-97.705609</td>\n",
" <td>Auto Theft</td>\n",
" <td>2014-12-18 00:00:00</td>\n",
" <td>2.014352e+10</td>\n",
" <td>3125976.0</td>\n",
" <td>10072207.0</td>\n",
" <td>2014.0</td>\n",
" <td>78702.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>86</th>\n",
" <td>(30.224918 -97.70321)</td>\n",
" <td>23.12</td>\n",
" <td>2015-01-02</td>\n",
" <td>Not cleared</td>\n",
" <td>3.0</td>\n",
" <td>THEFT BY SHOPLIFTING</td>\n",
" <td>H</td>\n",
" <td>30.224918</td>\n",
" <td>(30.224918-97.70321)</td>\n",
" <td>6306 E RIVERSIDE DR</td>\n",
" <td>-97.703210</td>\n",
" <td>Theft: Shoplifting</td>\n",
" <td>2014-12-28 00:00:00</td>\n",
" <td>2.014362e+10</td>\n",
" <td>3127258.0</td>\n",
" <td>10055405.0</td>\n",
" <td>2014.0</td>\n",
" <td>78741.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>106</th>\n",
" <td>(30.191043 -97.771802)</td>\n",
" <td>24.02</td>\n",
" <td>2014-12-24</td>\n",
" <td>Not cleared</td>\n",
" <td>2.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>F</td>\n",
" <td>30.191043</td>\n",
" <td>(30.191043-97.771802)</td>\n",
" <td>800 E WILLIAM CANNON DR</td>\n",
" <td>-97.771802</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-12-20 00:00:00</td>\n",
" <td>2.014506e+10</td>\n",
" <td>3105816.0</td>\n",
" <td>10042612.0</td>\n",
" <td>2014.0</td>\n",
" <td>78745.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>150</th>\n",
" <td>(30.336574 -97.718265)</td>\n",
" <td>15.03</td>\n",
" <td>2014-12-30</td>\n",
" <td>Not cleared</td>\n",
" <td>4.0</td>\n",
" <td>THEFT BY SHOPLIFTING</td>\n",
" <td>I</td>\n",
" <td>30.336574</td>\n",
" <td>(30.336574-97.718265)</td>\n",
" <td>6929 AIRPORT BLVD</td>\n",
" <td>-97.718265</td>\n",
" <td>Theft: Shoplifting</td>\n",
" <td>2014-12-14 00:00:00</td>\n",
" <td>2.014348e+10</td>\n",
" <td>3121678.0</td>\n",
" <td>10096228.0</td>\n",
" <td>2014.0</td>\n",
" <td>78752.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>174</th>\n",
" <td>(30.230228 -97.706314)</td>\n",
" <td>23.18</td>\n",
" <td>2014-12-30</td>\n",
" <td>Not cleared</td>\n",
" <td>3.0</td>\n",
" <td>THEFT</td>\n",
" <td>H</td>\n",
" <td>30.230228</td>\n",
" <td>(30.230228-97.706314)</td>\n",
" <td>1600 GROVE BLVD</td>\n",
" <td>-97.706314</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-18 00:00:00</td>\n",
" <td>2.014800e+10</td>\n",
" <td>3125983.0</td>\n",
" <td>10057278.0</td>\n",
" <td>2014.0</td>\n",
" <td>78741.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>266</th>\n",
" <td>(30.278442 -97.672073)</td>\n",
" <td>21.1</td>\n",
" <td>2014-12-22</td>\n",
" <td>Cleared by Exception</td>\n",
" <td>1.0</td>\n",
" <td>THEFT</td>\n",
" <td>C</td>\n",
" <td>30.278442</td>\n",
" <td>(30.278442-97.672073)</td>\n",
" <td>5800 TECHNI CENTER DR</td>\n",
" <td>-97.672073</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-11-19 00:00:00</td>\n",
" <td>2.014323e+10</td>\n",
" <td>3136582.0</td>\n",
" <td>10075176.0</td>\n",
" <td>2014.0</td>\n",
" <td>78721.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>413</th>\n",
" <td>(30.363403 -97.69686)</td>\n",
" <td>18.190000000000001</td>\n",
" <td>2014-12-30</td>\n",
" <td>Not cleared</td>\n",
" <td>4.0</td>\n",
" <td>THEFT</td>\n",
" <td>E</td>\n",
" <td>30.363403</td>\n",
" <td>(30.363403-97.69686)</td>\n",
" <td>9414 N LAMAR BLVD</td>\n",
" <td>-97.696860</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-11-11 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3127650.0</td>\n",
" <td>10106327.0</td>\n",
" <td>2014.0</td>\n",
" <td>78758.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>681</th>\n",
" <td>(30.356322 -97.684957)</td>\n",
" <td>18.13</td>\n",
" <td>2014-12-22</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>4.0</td>\n",
" <td>AUTO THEFT</td>\n",
" <td>E</td>\n",
" <td>30.356322</td>\n",
" <td>(30.356322-97.684957)</td>\n",
" <td>933 E RUNDBERG LN</td>\n",
" <td>-97.684957</td>\n",
" <td>Auto Theft</td>\n",
" <td>2014-12-21 00:00:00</td>\n",
" <td>2.014355e+10</td>\n",
" <td>3131733.0</td>\n",
" <td>10103162.0</td>\n",
" <td>2014.0</td>\n",
" <td>78753.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>756</th>\n",
" <td>(30.291716 -97.737747)</td>\n",
" <td>6.01</td>\n",
" <td>2014-12-23</td>\n",
" <td>Not cleared</td>\n",
" <td>9.0</td>\n",
" <td>THEFT OF BICYCLE</td>\n",
" <td>B</td>\n",
" <td>30.291716</td>\n",
" <td>(30.291716-97.737747)</td>\n",
" <td>100 E 27TH ST</td>\n",
" <td>-97.737747</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-18 00:00:00</td>\n",
" <td>2.014352e+10</td>\n",
" <td>3115712.0</td>\n",
" <td>10079702.0</td>\n",
" <td>2014.0</td>\n",
" <td>78705.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>759</th>\n",
" <td>(30.190555 -97.766839)</td>\n",
" <td>24.19</td>\n",
" <td>2014-12-23</td>\n",
" <td>Not cleared</td>\n",
" <td>2.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>F</td>\n",
" <td>30.190555</td>\n",
" <td>(30.190555-97.766839)</td>\n",
" <td>6503 BLUFF SPRINGS RD</td>\n",
" <td>-97.766839</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-12-16 00:00:00</td>\n",
" <td>2.014506e+10</td>\n",
" <td>3107457.0</td>\n",
" <td>10042310.0</td>\n",
" <td>2014.0</td>\n",
" <td>78744.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>768</th>\n",
" <td>(30.307539 -97.710734)</td>\n",
" <td>3.06</td>\n",
" <td>2015-01-02</td>\n",
" <td>Not cleared</td>\n",
" <td>9.0</td>\n",
" <td>THEFT</td>\n",
" <td>B</td>\n",
" <td>30.307539</td>\n",
" <td>(30.307539-97.710734)</td>\n",
" <td>1200 BARBARA JORDAN BLVD</td>\n",
" <td>-97.710734</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-09 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3124571.0</td>\n",
" <td>10085297.0</td>\n",
" <td>2014.0</td>\n",
" <td>78723.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>872</th>\n",
" <td>(30.290015 -97.707435)</td>\n",
" <td>3.07</td>\n",
" <td>2015-01-19</td>\n",
" <td>Not cleared</td>\n",
" <td>9.0</td>\n",
" <td>THEFT</td>\n",
" <td>C</td>\n",
" <td>30.290015</td>\n",
" <td>(30.290015-97.707435)</td>\n",
" <td>3848 AIRPORT BLVD</td>\n",
" <td>-97.707435</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-09 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3125168.0</td>\n",
" <td>10078794.0</td>\n",
" <td>2014.0</td>\n",
" <td>78722.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>887</th>\n",
" <td>(30.259855 -97.758863)</td>\n",
" <td>13.03</td>\n",
" <td>2014-12-26</td>\n",
" <td>Not cleared</td>\n",
" <td>5.0</td>\n",
" <td>THEFT OF BICYCLE</td>\n",
" <td>D</td>\n",
" <td>30.259855</td>\n",
" <td>(30.259855-97.758863)</td>\n",
" <td>517 S LAMAR BLVD</td>\n",
" <td>-97.758863</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-23 00:00:00</td>\n",
" <td>2.014506e+10</td>\n",
" <td>3109538.0</td>\n",
" <td>10067577.0</td>\n",
" <td>2014.0</td>\n",
" <td>78704.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1041</th>\n",
" <td>(30.401689 -97.702175)</td>\n",
" <td>18.440000000000001</td>\n",
" <td>2015-01-14</td>\n",
" <td>Not cleared</td>\n",
" <td>7.0</td>\n",
" <td>AUTO THEFT</td>\n",
" <td>E</td>\n",
" <td>30.401689</td>\n",
" <td>(30.401689-97.702175)</td>\n",
" <td>12001 METRIC BLVD</td>\n",
" <td>-97.702175</td>\n",
" <td>Auto Theft</td>\n",
" <td>2014-12-13 00:00:00</td>\n",
" <td>2.014347e+10</td>\n",
" <td>3126112.0</td>\n",
" <td>10119741.0</td>\n",
" <td>2014.0</td>\n",
" <td>78758.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1082</th>\n",
" <td>(30.392622 -97.745915)</td>\n",
" <td>17.53</td>\n",
" <td>2015-02-04</td>\n",
" <td>Not cleared</td>\n",
" <td>7.0</td>\n",
" <td>THEFT</td>\n",
" <td>A</td>\n",
" <td>30.392622</td>\n",
" <td>(30.392622-97.745915)</td>\n",
" <td>10107 RESEARCH BLVD SVRD NB</td>\n",
" <td>-97.745915</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-11-18 00:00:00</td>\n",
" <td>2.014800e+10</td>\n",
" <td>3112264.0</td>\n",
" <td>10116438.0</td>\n",
" <td>2014.0</td>\n",
" <td>78759.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1177</th>\n",
" <td>(30.209401 -97.805934)</td>\n",
" <td>17.13</td>\n",
" <td>2015-06-02</td>\n",
" <td>Cleared by Exception</td>\n",
" <td>5.0</td>\n",
" <td>MISAPPLY FIDUCIARY PROP</td>\n",
" <td>D</td>\n",
" <td>30.209401</td>\n",
" <td>(30.209401-97.805934)</td>\n",
" <td>2205 BERKELEY AVE</td>\n",
" <td>-97.805934</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-11-17 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3094819.0</td>\n",
" <td>10048899.0</td>\n",
" <td>2014.0</td>\n",
" <td>78745.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1194</th>\n",
" <td>(30.400032 -97.652722)</td>\n",
" <td>18.39</td>\n",
" <td>2015-03-30</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>7.0</td>\n",
" <td>AGG ASSAULT FAM/DATE VIOLENCE</td>\n",
" <td>E</td>\n",
" <td>30.400032</td>\n",
" <td>(30.400032-97.652722)</td>\n",
" <td>12800 HARRISGLENN DR</td>\n",
" <td>-97.652722</td>\n",
" <td>Aggravated Assault</td>\n",
" <td>2014-09-24 00:00:00</td>\n",
" <td>2.014267e+10</td>\n",
" <td>3141537.0</td>\n",
" <td>10119603.0</td>\n",
" <td>2014.0</td>\n",
" <td>78753.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1220</th>\n",
" <td>(30.255443 -97.810066)</td>\n",
" <td>19.100000000000001</td>\n",
" <td>2015-01-22</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>8.0</td>\n",
" <td>THEFT</td>\n",
" <td>D</td>\n",
" <td>30.255443</td>\n",
" <td>(30.255443-97.810066)</td>\n",
" <td>2901 S CAPITAL OF TEXAS HWY NB</td>\n",
" <td>-97.810066</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-01-10 00:00:00</td>\n",
" <td>2.014101e+09</td>\n",
" <td>3094135.0</td>\n",
" <td>10066586.0</td>\n",
" <td>2014.0</td>\n",
" <td>78746.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1322</th>\n",
" <td>(30.28283 -97.775923)</td>\n",
" <td>16.02</td>\n",
" <td>2014-12-23</td>\n",
" <td>Not cleared</td>\n",
" <td>10.0</td>\n",
" <td>THEFT</td>\n",
" <td>B</td>\n",
" <td>30.282830</td>\n",
" <td>(30.28283-97.775923)</td>\n",
" <td>701 NEWMAN DR</td>\n",
" <td>-97.775923</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-20 00:00:00</td>\n",
" <td>2.014354e+10</td>\n",
" <td>3103774.0</td>\n",
" <td>10075849.0</td>\n",
" <td>2014.0</td>\n",
" <td>78703.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1489</th>\n",
" <td>(30.236639 -97.797956)</td>\n",
" <td>19.010000000000002</td>\n",
" <td>2015-01-25</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>5.0</td>\n",
" <td>THEFT</td>\n",
" <td>D</td>\n",
" <td>30.236639</td>\n",
" <td>(30.236639-97.797956)</td>\n",
" <td>4115 S CAPITAL OF TEXAS HWY NB</td>\n",
" <td>-97.797956</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-05-08 00:00:00</td>\n",
" <td>2.014128e+10</td>\n",
" <td>3097832.0</td>\n",
" <td>10059242.0</td>\n",
" <td>2014.0</td>\n",
" <td>78704.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1632</th>\n",
" <td>(30.467694 -97.809861)</td>\n",
" <td>203.18</td>\n",
" <td>2015-01-26</td>\n",
" <td>Not cleared</td>\n",
" <td>6.0</td>\n",
" <td>THEFT</td>\n",
" <td>A</td>\n",
" <td>30.467694</td>\n",
" <td>(30.467694-97.809861)</td>\n",
" <td>12617 RIDGELINE BLVD</td>\n",
" <td>-97.809861</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-18 00:00:00</td>\n",
" <td>2.014506e+10</td>\n",
" <td>3092290.0</td>\n",
" <td>10142671.0</td>\n",
" <td>2014.0</td>\n",
" <td>78613.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1741</th>\n",
" <td>(30.260829 -97.717161)</td>\n",
" <td>9.02</td>\n",
" <td>2015-01-14</td>\n",
" <td>Not cleared</td>\n",
" <td>3.0</td>\n",
" <td>THEFT</td>\n",
" <td>C</td>\n",
" <td>30.260829</td>\n",
" <td>(30.260829-97.717161)</td>\n",
" <td>2311 HIDALGO ST</td>\n",
" <td>-97.717161</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-11-22 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3122663.0</td>\n",
" <td>10068215.0</td>\n",
" <td>2014.0</td>\n",
" <td>78702.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1753</th>\n",
" <td>(30.357068 -97.733075)</td>\n",
" <td>15.01</td>\n",
" <td>2015-02-02</td>\n",
" <td>Not cleared</td>\n",
" <td>7.0</td>\n",
" <td>THEFT BY SHOPLIFTING</td>\n",
" <td>B</td>\n",
" <td>30.357068</td>\n",
" <td>(30.357068-97.733075)</td>\n",
" <td>2525 W ANDERSON LN</td>\n",
" <td>-97.733075</td>\n",
" <td>Theft: Shoplifting</td>\n",
" <td>2014-12-30 00:00:00</td>\n",
" <td>2.014364e+10</td>\n",
" <td>3116494.0</td>\n",
" <td>10102601.0</td>\n",
" <td>2014.0</td>\n",
" <td>78757.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1756</th>\n",
" <td>(30.223062 -97.670616)</td>\n",
" <td>23.1</td>\n",
" <td>2015-03-18</td>\n",
" <td>Not cleared</td>\n",
" <td>2.0</td>\n",
" <td>AUTO THEFT</td>\n",
" <td>H</td>\n",
" <td>30.223062</td>\n",
" <td>(30.223062-97.670616)</td>\n",
" <td>9321 EVENING SHADOWS DR</td>\n",
" <td>-97.670616</td>\n",
" <td>Auto Theft</td>\n",
" <td>2014-12-28 00:00:00</td>\n",
" <td>2.014362e+10</td>\n",
" <td>3137545.0</td>\n",
" <td>10054755.0</td>\n",
" <td>2014.0</td>\n",
" <td>78617.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1817</th>\n",
" <td>(30.338618 -97.692566)</td>\n",
" <td>18.13</td>\n",
" <td>2014-12-25</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>4.0</td>\n",
" <td>THEFT BY SHOPLIFTING</td>\n",
" <td>I</td>\n",
" <td>30.338618</td>\n",
" <td>(30.338618-97.692566)</td>\n",
" <td>1030 NORWOOD PARK BLVD</td>\n",
" <td>-97.692566</td>\n",
" <td>Theft: Shoplifting</td>\n",
" <td>2014-10-01 00:00:00</td>\n",
" <td>2.014274e+10</td>\n",
" <td>3129997.0</td>\n",
" <td>10096983.0</td>\n",
" <td>2014.0</td>\n",
" <td>78753.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1888</th>\n",
" <td>(30.498698 -97.775867)</td>\n",
" <td>205.09</td>\n",
" <td>2015-01-23</td>\n",
" <td>Cleared by Exception</td>\n",
" <td>6.0</td>\n",
" <td>AGG ASSAULT</td>\n",
" <td>A</td>\n",
" <td>30.498698</td>\n",
" <td>(30.498698-97.775867)</td>\n",
" <td>10600 W PARMER LN</td>\n",
" <td>-97.775867</td>\n",
" <td>Aggravated Assault</td>\n",
" <td>2014-12-16 00:00:00</td>\n",
" <td>2.014350e+10</td>\n",
" <td>3102230.0</td>\n",
" <td>10154430.0</td>\n",
" <td>2014.0</td>\n",
" <td>78717.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1922</th>\n",
" <td>(30.234032 -97.742436)</td>\n",
" <td>23.08</td>\n",
" <td>2015-01-22</td>\n",
" <td>Not cleared</td>\n",
" <td>9.0</td>\n",
" <td>THEFT</td>\n",
" <td>H</td>\n",
" <td>30.234032</td>\n",
" <td>(30.234032-97.742436)</td>\n",
" <td>1320 E OLTORF ST</td>\n",
" <td>-97.742436</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-10-10 00:00:00</td>\n",
" <td>2.014283e+10</td>\n",
" <td>3114800.0</td>\n",
" <td>10058474.0</td>\n",
" <td>2014.0</td>\n",
" <td>78704.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2191</th>\n",
" <td>(30.300002 -97.742349)</td>\n",
" <td>2.04</td>\n",
" <td>2015-01-19</td>\n",
" <td>Not cleared</td>\n",
" <td>9.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>B</td>\n",
" <td>30.300002</td>\n",
" <td>(30.300002-97.742349)</td>\n",
" <td>702 W 32ND ST</td>\n",
" <td>-97.742349</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-12-05 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3114177.0</td>\n",
" <td>10082461.0</td>\n",
" <td>2014.0</td>\n",
" <td>78705.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2205</th>\n",
" <td>(30.254462 -97.732058)</td>\n",
" <td>10</td>\n",
" <td>2015-02-26</td>\n",
" <td>Not cleared</td>\n",
" <td>3.0</td>\n",
" <td>AUTO THEFT</td>\n",
" <td>G</td>\n",
" <td>30.254462</td>\n",
" <td>(30.254462-97.732058)</td>\n",
" <td>1406 HASKELL ST</td>\n",
" <td>-97.732058</td>\n",
" <td>Auto Theft</td>\n",
" <td>2014-11-29 00:00:00</td>\n",
" <td>2.014333e+10</td>\n",
" <td>3117855.0</td>\n",
" <td>10065994.0</td>\n",
" <td>2014.0</td>\n",
" <td>78702.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2221</th>\n",
" <td>(30.152748 -97.828527)</td>\n",
" <td>17.72</td>\n",
" <td>2014-12-26</td>\n",
" <td>Not cleared</td>\n",
" <td>5.0</td>\n",
" <td>THEFT</td>\n",
" <td>F</td>\n",
" <td>30.152748</td>\n",
" <td>(30.152748-97.828527)</td>\n",
" <td>11308 ROBERT WOODING DR</td>\n",
" <td>-97.828527</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-24 00:00:00</td>\n",
" <td>2.014358e+10</td>\n",
" <td>3088135.0</td>\n",
" <td>10028195.0</td>\n",
" <td>2014.0</td>\n",
" <td>78748.0</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",
" </tr>\n",
" <tr>\n",
" <th>156917</th>\n",
" <td>(30.397116 -97.648791)</td>\n",
" <td>18.39</td>\n",
" <td>2015-02-05</td>\n",
" <td>Not cleared</td>\n",
" <td>7.0</td>\n",
" <td>AGG ASSAULT</td>\n",
" <td>E</td>\n",
" <td>30.397116</td>\n",
" <td>(30.397116-97.648791)</td>\n",
" <td>12712 BARTHOLDI ST</td>\n",
" <td>-97.648791</td>\n",
" <td>Aggravated Assault</td>\n",
" <td>2014-12-10 00:00:00</td>\n",
" <td>2.014344e+10</td>\n",
" <td>3142774.0</td>\n",
" <td>10118416.0</td>\n",
" <td>2014.0</td>\n",
" <td>78753.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>157096</th>\n",
" <td>(30.239018 -97.730225)</td>\n",
" <td>23.16</td>\n",
" <td>2015-02-11</td>\n",
" <td>Not cleared</td>\n",
" <td>3.0</td>\n",
" <td>THEFT</td>\n",
" <td>H</td>\n",
" <td>30.239018</td>\n",
" <td>(30.239018-97.730225)</td>\n",
" <td>1601 ROYAL CREST DR</td>\n",
" <td>-97.730225</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-10-29 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3118667.0</td>\n",
" <td>10060221.0</td>\n",
" <td>2014.0</td>\n",
" <td>78741.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>157104</th>\n",
" <td>(30.234873 -97.715023)</td>\n",
" <td>23.17</td>\n",
" <td>2015-01-02</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>3.0</td>\n",
" <td>AGG ASLT STRANGLE/SUFFOCATE</td>\n",
" <td>H</td>\n",
" <td>30.234873</td>\n",
" <td>(30.234873-97.715023)</td>\n",
" <td>1500 CROSSING PL</td>\n",
" <td>-97.715023</td>\n",
" <td>Aggravated Assault</td>\n",
" <td>2014-12-20 00:00:00</td>\n",
" <td>2.014354e+10</td>\n",
" <td>3123227.0</td>\n",
" <td>10058967.0</td>\n",
" <td>2014.0</td>\n",
" <td>78741.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>157224</th>\n",
" <td>(30.199333 -97.805965)</td>\n",
" <td>17.28</td>\n",
" <td>2014-12-26</td>\n",
" <td>Not cleared</td>\n",
" <td>5.0</td>\n",
" <td>THEFT</td>\n",
" <td>F</td>\n",
" <td>30.199333</td>\n",
" <td>(30.199333-97.805965)</td>\n",
" <td>1806 MATTHEWS LN</td>\n",
" <td>-97.805965</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-23 00:00:00</td>\n",
" <td>2.014506e+10</td>\n",
" <td>3094975.0</td>\n",
" <td>10045360.0</td>\n",
" <td>2014.0</td>\n",
" <td>78745.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>157346</th>\n",
" <td>(30.285687 -97.710335)</td>\n",
" <td>4.02</td>\n",
" <td>2015-01-12</td>\n",
" <td>Not cleared</td>\n",
" <td>9.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>C</td>\n",
" <td>30.285687</td>\n",
" <td>(30.285687-97.710335)</td>\n",
" <td>2900 MANOR RD</td>\n",
" <td>-97.710335</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-12-16 00:00:00</td>\n",
" <td>2.014506e+10</td>\n",
" <td>3124405.0</td>\n",
" <td>10077491.0</td>\n",
" <td>2014.0</td>\n",
" <td>78722.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>157369</th>\n",
" <td>(30.267162 -97.700936)</td>\n",
" <td>8.01</td>\n",
" <td>2015-01-12</td>\n",
" <td>Not cleared</td>\n",
" <td>3.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>C</td>\n",
" <td>30.267162</td>\n",
" <td>(30.267162-97.700936)</td>\n",
" <td>3206 THOMPSON ST</td>\n",
" <td>-97.700936</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-12-15 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3127558.0</td>\n",
" <td>10070798.0</td>\n",
" <td>2014.0</td>\n",
" <td>78702.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>157418</th>\n",
" <td>(30.279386 -97.689768)</td>\n",
" <td>21.09</td>\n",
" <td>2015-02-19</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>1.0</td>\n",
" <td>AGG ASSAULT</td>\n",
" <td>C</td>\n",
" <td>30.279386</td>\n",
" <td>(30.279386-97.689768)</td>\n",
" <td>1211 COMETA ST</td>\n",
" <td>-97.689768</td>\n",
" <td>Aggravated Assault</td>\n",
" <td>2014-10-01 00:00:00</td>\n",
" <td>2.014274e+10</td>\n",
" <td>3131034.0</td>\n",
" <td>10075286.0</td>\n",
" <td>2014.0</td>\n",
" <td>78721.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>157446</th>\n",
" <td>(30.270207 -97.74312)</td>\n",
" <td>11</td>\n",
" <td>2015-01-14</td>\n",
" <td>Not cleared</td>\n",
" <td>9.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>G</td>\n",
" <td>30.270207</td>\n",
" <td>(30.270207-97.74312)</td>\n",
" <td>121 W 8TH ST</td>\n",
" <td>-97.743120</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-12-01 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3114135.0</td>\n",
" <td>10071513.0</td>\n",
" <td>2014.0</td>\n",
" <td>78701.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>157548</th>\n",
" <td>(30.300889 -97.686737)</td>\n",
" <td>21.06</td>\n",
" <td>2015-01-13</td>\n",
" <td>Not cleared</td>\n",
" <td>1.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>I</td>\n",
" <td>30.300889</td>\n",
" <td>(30.300889-97.686737)</td>\n",
" <td>5304 CLOVERDALE LN</td>\n",
" <td>-97.686737</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-11-22 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3131722.0</td>\n",
" <td>10083162.0</td>\n",
" <td>2014.0</td>\n",
" <td>78723.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>157564</th>\n",
" <td>(30.282999 -97.746429)</td>\n",
" <td>6.04</td>\n",
" <td>2014-12-19</td>\n",
" <td>Not cleared</td>\n",
" <td>9.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>B</td>\n",
" <td>30.282999</td>\n",
" <td>(30.282999-97.746429)</td>\n",
" <td>706 W MARTIN LUTHER KING JR BLVD</td>\n",
" <td>-97.746429</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-11-15 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3113117.0</td>\n",
" <td>10076266.0</td>\n",
" <td>2014.0</td>\n",
" <td>78705.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>157731</th>\n",
" <td>(30.32945 -97.690009)</td>\n",
" <td>18.11</td>\n",
" <td>2014-12-29</td>\n",
" <td>Not cleared</td>\n",
" <td>1.0</td>\n",
" <td>ROBBERY BY ASSAULT</td>\n",
" <td>I</td>\n",
" <td>30.329450</td>\n",
" <td>(30.32945-97.690009)</td>\n",
" <td>7517 CAMERON RD</td>\n",
" <td>-97.690009</td>\n",
" <td>Robbery</td>\n",
" <td>2014-12-26 00:00:00</td>\n",
" <td>2.014360e+10</td>\n",
" <td>3130685.0</td>\n",
" <td>10093333.0</td>\n",
" <td>2014.0</td>\n",
" <td>78752.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>157869</th>\n",
" <td>(30.394899 -97.72685)</td>\n",
" <td>18.489999999999998</td>\n",
" <td>2015-04-17</td>\n",
" <td>Not cleared</td>\n",
" <td>7.0</td>\n",
" <td>THEFT</td>\n",
" <td>A</td>\n",
" <td>30.394899</td>\n",
" <td>(30.394899-97.72685)</td>\n",
" <td>3211 FEATHERGRASS CT</td>\n",
" <td>-97.726850</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-13 00:00:00</td>\n",
" <td>2.014506e+10</td>\n",
" <td>3118106.0</td>\n",
" <td>10116812.0</td>\n",
" <td>2014.0</td>\n",
" <td>78758.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>157924</th>\n",
" <td>(30.137904 -97.800345)</td>\n",
" <td>24.07</td>\n",
" <td>2014-12-21</td>\n",
" <td>Not cleared</td>\n",
" <td>5.0</td>\n",
" <td>THEFT OF LICENSE PLATE</td>\n",
" <td>F</td>\n",
" <td>30.137904</td>\n",
" <td>(30.137904-97.800345)</td>\n",
" <td>1901 ONION CREEK PKWY</td>\n",
" <td>-97.800345</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-18 00:00:00</td>\n",
" <td>2.014506e+10</td>\n",
" <td>3097241.0</td>\n",
" <td>10022889.0</td>\n",
" <td>2014.0</td>\n",
" <td>78748.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>158182</th>\n",
" <td>(30.238815 -97.741)</td>\n",
" <td>14.02</td>\n",
" <td>2015-01-01</td>\n",
" <td>Not cleared</td>\n",
" <td>9.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>H</td>\n",
" <td>30.238815</td>\n",
" <td>(30.238815-97.741)</td>\n",
" <td>1915 FAIRLAWN LN</td>\n",
" <td>-97.741000</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-12-09 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3115195.0</td>\n",
" <td>10060096.0</td>\n",
" <td>2014.0</td>\n",
" <td>78704.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>158242</th>\n",
" <td>(30.321478 -97.679146)</td>\n",
" <td>21.12</td>\n",
" <td>2015-02-23</td>\n",
" <td>Not cleared</td>\n",
" <td>1.0</td>\n",
" <td>THEFT</td>\n",
" <td>I</td>\n",
" <td>30.321478</td>\n",
" <td>(30.321478-97.679146)</td>\n",
" <td>7104 NORTHEAST DR</td>\n",
" <td>-97.679146</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-12 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3133900.0</td>\n",
" <td>10090625.0</td>\n",
" <td>2014.0</td>\n",
" <td>78723.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>158273</th>\n",
" <td>(30.338618 -97.692566)</td>\n",
" <td>18.13</td>\n",
" <td>2014-12-23</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>4.0</td>\n",
" <td>THEFT BY SHOPLIFTING</td>\n",
" <td>I</td>\n",
" <td>30.338618</td>\n",
" <td>(30.338618-97.692566)</td>\n",
" <td>1030 NORWOOD PARK BLVD</td>\n",
" <td>-97.692566</td>\n",
" <td>Theft: Shoplifting</td>\n",
" <td>2014-11-04 00:00:00</td>\n",
" <td>2.014308e+10</td>\n",
" <td>3129997.0</td>\n",
" <td>10096983.0</td>\n",
" <td>2014.0</td>\n",
" <td>78753.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>158296</th>\n",
" <td>(30.357262 -97.642666)</td>\n",
" <td>18.420000000000002</td>\n",
" <td>2015-01-09</td>\n",
" <td>Not cleared</td>\n",
" <td>1.0</td>\n",
" <td>AUTO THEFT</td>\n",
" <td>E</td>\n",
" <td>30.357262</td>\n",
" <td>(30.357262-97.642666)</td>\n",
" <td>11024 RELIANCE CREEK DR</td>\n",
" <td>-97.642666</td>\n",
" <td>Auto Theft</td>\n",
" <td>2014-12-04 00:00:00</td>\n",
" <td>2.014338e+10</td>\n",
" <td>3145132.0</td>\n",
" <td>10104015.0</td>\n",
" <td>2014.0</td>\n",
" <td>78754.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>158354</th>\n",
" <td>(30.32562 -97.694628)</td>\n",
" <td>18.12</td>\n",
" <td>2014-12-26</td>\n",
" <td>Not cleared</td>\n",
" <td>4.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>I</td>\n",
" <td>30.325620</td>\n",
" <td>(30.32562-97.694628)</td>\n",
" <td>1212 WESTHEIMER DR</td>\n",
" <td>-97.694628</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-12-20 00:00:00</td>\n",
" <td>2.014354e+10</td>\n",
" <td>3129079.0</td>\n",
" <td>10092100.0</td>\n",
" <td>2014.0</td>\n",
" <td>78752.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>158523</th>\n",
" <td>(30.260764 -97.801664)</td>\n",
" <td>19.100000000000001</td>\n",
" <td>2014-12-19</td>\n",
" <td>Not cleared</td>\n",
" <td>8.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>D</td>\n",
" <td>30.260764</td>\n",
" <td>(30.260764-97.801664)</td>\n",
" <td>1916 HOLLY HILL DR</td>\n",
" <td>-97.801664</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-12-02 00:00:00</td>\n",
" <td>2.014336e+10</td>\n",
" <td>3095757.0</td>\n",
" <td>10067577.0</td>\n",
" <td>2014.0</td>\n",
" <td>78746.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>158624</th>\n",
" <td>(30.326002 -97.717455)</td>\n",
" <td>15.03</td>\n",
" <td>2015-02-24</td>\n",
" <td>Not cleared</td>\n",
" <td>4.0</td>\n",
" <td>THEFT</td>\n",
" <td>I</td>\n",
" <td>30.326002</td>\n",
" <td>(30.326002-97.717455)</td>\n",
" <td>6016 DILLARD CIR</td>\n",
" <td>-97.717455</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-11-07 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3121779.0</td>\n",
" <td>10092034.0</td>\n",
" <td>2014.0</td>\n",
" <td>78752.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>158661</th>\n",
" <td>(30.368413 -97.70575)</td>\n",
" <td>18.190000000000001</td>\n",
" <td>2014-12-24</td>\n",
" <td>Not cleared</td>\n",
" <td>4.0</td>\n",
" <td>AUTO THEFT</td>\n",
" <td>E</td>\n",
" <td>30.368413</td>\n",
" <td>(30.368413-97.70575)</td>\n",
" <td>9433 PARKFIELD DR</td>\n",
" <td>-97.705750</td>\n",
" <td>Auto Theft</td>\n",
" <td>2014-12-22 00:00:00</td>\n",
" <td>2.014356e+10</td>\n",
" <td>3125277.0</td>\n",
" <td>10107519.0</td>\n",
" <td>2014.0</td>\n",
" <td>78758.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>158828</th>\n",
" <td>(30.38275 -97.658594)</td>\n",
" <td>18.350000000000001</td>\n",
" <td>2015-01-09</td>\n",
" <td>Not cleared</td>\n",
" <td>1.0</td>\n",
" <td>BURGLARY OF VEHICLE</td>\n",
" <td>E</td>\n",
" <td>30.382750</td>\n",
" <td>(30.38275-97.658594)</td>\n",
" <td>1406 DOMINIQUE DR</td>\n",
" <td>-97.658594</td>\n",
" <td>Theft: BOV</td>\n",
" <td>2014-12-31 00:00:00</td>\n",
" <td>2.014506e+10</td>\n",
" <td>3139927.0</td>\n",
" <td>10113123.0</td>\n",
" <td>2014.0</td>\n",
" <td>78753.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>158877</th>\n",
" <td>(30.321239 -97.729295)</td>\n",
" <td>3.05</td>\n",
" <td>2014-12-23</td>\n",
" <td>Not cleared</td>\n",
" <td>9.0</td>\n",
" <td>THEFT</td>\n",
" <td>I</td>\n",
" <td>30.321239</td>\n",
" <td>(30.321239-97.729295)</td>\n",
" <td>5301 N LAMAR BLVD</td>\n",
" <td>-97.729295</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-11 00:00:00</td>\n",
" <td>2.014345e+10</td>\n",
" <td>3118221.0</td>\n",
" <td>10090150.0</td>\n",
" <td>2014.0</td>\n",
" <td>78751.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>158882</th>\n",
" <td>(30.402642 -97.725361)</td>\n",
" <td>18.489999999999998</td>\n",
" <td>2015-01-15</td>\n",
" <td>Not cleared</td>\n",
" <td>7.0</td>\n",
" <td>THEFT BY SHOPLIFTING</td>\n",
" <td>A</td>\n",
" <td>30.402642</td>\n",
" <td>(30.402642-97.725361)</td>\n",
" <td>11600 CENTURY OAKS TER</td>\n",
" <td>-97.725361</td>\n",
" <td>Theft: Shoplifting</td>\n",
" <td>2014-11-08 00:00:00</td>\n",
" <td>2.014505e+10</td>\n",
" <td>3118703.0</td>\n",
" <td>10120061.0</td>\n",
" <td>2014.0</td>\n",
" <td>78758.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>158981</th>\n",
" <td>(30.19201 -97.775267)</td>\n",
" <td>24.02</td>\n",
" <td>2014-12-26</td>\n",
" <td>Not cleared</td>\n",
" <td>2.0</td>\n",
" <td>AGG ROBBERY/DEADLY WEAPON</td>\n",
" <td>F</td>\n",
" <td>30.192010</td>\n",
" <td>(30.19201-97.775267)</td>\n",
" <td>412 E WILLIAM CANNON DR</td>\n",
" <td>-97.775267</td>\n",
" <td>Robbery</td>\n",
" <td>2014-11-16 00:00:00</td>\n",
" <td>2.014320e+10</td>\n",
" <td>3104793.0</td>\n",
" <td>10043078.0</td>\n",
" <td>2014.0</td>\n",
" <td>78745.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159102</th>\n",
" <td>(30.234742 -97.713771)</td>\n",
" <td>23.18</td>\n",
" <td>2014-12-23</td>\n",
" <td>Not cleared</td>\n",
" <td>3.0</td>\n",
" <td>THEFT</td>\n",
" <td>H</td>\n",
" <td>30.234742</td>\n",
" <td>(30.234742-97.713771)</td>\n",
" <td>1500 FARO DR</td>\n",
" <td>-97.713771</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-15 00:00:00</td>\n",
" <td>2.014506e+10</td>\n",
" <td>3123698.0</td>\n",
" <td>10058703.0</td>\n",
" <td>2014.0</td>\n",
" <td>78741.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159132</th>\n",
" <td>(30.196836 -97.786991)</td>\n",
" <td>24.02</td>\n",
" <td>2014-12-21</td>\n",
" <td>Cleared by Arrest</td>\n",
" <td>2.0</td>\n",
" <td>THEFT BY SHOPLIFTING</td>\n",
" <td>F</td>\n",
" <td>30.196836</td>\n",
" <td>(30.196836-97.786991)</td>\n",
" <td>600 W WILLIAM CANNON DR</td>\n",
" <td>-97.786991</td>\n",
" <td>Theft: Shoplifting</td>\n",
" <td>2014-12-20 00:00:00</td>\n",
" <td>2.014354e+10</td>\n",
" <td>3101178.0</td>\n",
" <td>10044981.0</td>\n",
" <td>2014.0</td>\n",
" <td>78745.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159136</th>\n",
" <td>(30.423635 -97.702557)</td>\n",
" <td>18.48</td>\n",
" <td>2014-12-22</td>\n",
" <td>Not cleared</td>\n",
" <td>7.0</td>\n",
" <td>THEFT BY SHOPLIFTING</td>\n",
" <td>A</td>\n",
" <td>30.423635</td>\n",
" <td>(30.423635-97.702557)</td>\n",
" <td>12707 N MOPAC EXPY NB</td>\n",
" <td>-97.702557</td>\n",
" <td>Theft: Shoplifting</td>\n",
" <td>2014-12-15 00:00:00</td>\n",
" <td>2.014349e+10</td>\n",
" <td>3126500.0</td>\n",
" <td>10127412.0</td>\n",
" <td>2014.0</td>\n",
" <td>78727.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159285</th>\n",
" <td>(30.35502 -97.673257)</td>\n",
" <td>18.34</td>\n",
" <td>2014-12-30</td>\n",
" <td>Not cleared</td>\n",
" <td>1.0</td>\n",
" <td>THEFT</td>\n",
" <td>E</td>\n",
" <td>30.355020</td>\n",
" <td>(30.35502-97.673257)</td>\n",
" <td>9701 DESSAU RD</td>\n",
" <td>-97.673257</td>\n",
" <td>Theft: All Other Larceny</td>\n",
" <td>2014-12-29 00:00:00</td>\n",
" <td>2.014506e+10</td>\n",
" <td>3135717.0</td>\n",
" <td>10102799.0</td>\n",
" <td>2014.0</td>\n",
" <td>78754.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159456</th>\n",
" <td>(30.405797 -97.74491)</td>\n",
" <td>17.54</td>\n",
" <td>2015-01-04</td>\n",
" <td>Not cleared</td>\n",
" <td>7.0</td>\n",
" <td>AGG ASLT ENHANC STRANGL/SUFFOC</td>\n",
" <td>A</td>\n",
" <td>30.405797</td>\n",
" <td>(30.405797-97.74491)</td>\n",
" <td>11111 RESEARCH BLVD SVRD NB</td>\n",
" <td>-97.744910</td>\n",
" <td>Aggravated Assault</td>\n",
" <td>2014-12-28 00:00:00</td>\n",
" <td>2.014362e+10</td>\n",
" <td>3112507.0</td>\n",
" <td>10120833.0</td>\n",
" <td>2014.0</td>\n",
" <td>78759.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>2085 rows × 18 columns</p>\n",
"</div>"
],
"text/plain": [
" address census_tract clearance_date \\\n",
"17 (30.271198 -97.705609) 8.02 2014-12-19 \n",
"86 (30.224918 -97.70321) 23.12 2015-01-02 \n",
"106 (30.191043 -97.771802) 24.02 2014-12-24 \n",
"150 (30.336574 -97.718265) 15.03 2014-12-30 \n",
"174 (30.230228 -97.706314) 23.18 2014-12-30 \n",
"266 (30.278442 -97.672073) 21.1 2014-12-22 \n",
"413 (30.363403 -97.69686) 18.190000000000001 2014-12-30 \n",
"681 (30.356322 -97.684957) 18.13 2014-12-22 \n",
"756 (30.291716 -97.737747) 6.01 2014-12-23 \n",
"759 (30.190555 -97.766839) 24.19 2014-12-23 \n",
"768 (30.307539 -97.710734) 3.06 2015-01-02 \n",
"872 (30.290015 -97.707435) 3.07 2015-01-19 \n",
"887 (30.259855 -97.758863) 13.03 2014-12-26 \n",
"1041 (30.401689 -97.702175) 18.440000000000001 2015-01-14 \n",
"1082 (30.392622 -97.745915) 17.53 2015-02-04 \n",
"1177 (30.209401 -97.805934) 17.13 2015-06-02 \n",
"1194 (30.400032 -97.652722) 18.39 2015-03-30 \n",
"1220 (30.255443 -97.810066) 19.100000000000001 2015-01-22 \n",
"1322 (30.28283 -97.775923) 16.02 2014-12-23 \n",
"1489 (30.236639 -97.797956) 19.010000000000002 2015-01-25 \n",
"1632 (30.467694 -97.809861) 203.18 2015-01-26 \n",
"1741 (30.260829 -97.717161) 9.02 2015-01-14 \n",
"1753 (30.357068 -97.733075) 15.01 2015-02-02 \n",
"1756 (30.223062 -97.670616) 23.1 2015-03-18 \n",
"1817 (30.338618 -97.692566) 18.13 2014-12-25 \n",
"1888 (30.498698 -97.775867) 205.09 2015-01-23 \n",
"1922 (30.234032 -97.742436) 23.08 2015-01-22 \n",
"2191 (30.300002 -97.742349) 2.04 2015-01-19 \n",
"2205 (30.254462 -97.732058) 10 2015-02-26 \n",
"2221 (30.152748 -97.828527) 17.72 2014-12-26 \n",
"... ... ... ... \n",
"156917 (30.397116 -97.648791) 18.39 2015-02-05 \n",
"157096 (30.239018 -97.730225) 23.16 2015-02-11 \n",
"157104 (30.234873 -97.715023) 23.17 2015-01-02 \n",
"157224 (30.199333 -97.805965) 17.28 2014-12-26 \n",
"157346 (30.285687 -97.710335) 4.02 2015-01-12 \n",
"157369 (30.267162 -97.700936) 8.01 2015-01-12 \n",
"157418 (30.279386 -97.689768) 21.09 2015-02-19 \n",
"157446 (30.270207 -97.74312) 11 2015-01-14 \n",
"157548 (30.300889 -97.686737) 21.06 2015-01-13 \n",
"157564 (30.282999 -97.746429) 6.04 2014-12-19 \n",
"157731 (30.32945 -97.690009) 18.11 2014-12-29 \n",
"157869 (30.394899 -97.72685) 18.489999999999998 2015-04-17 \n",
"157924 (30.137904 -97.800345) 24.07 2014-12-21 \n",
"158182 (30.238815 -97.741) 14.02 2015-01-01 \n",
"158242 (30.321478 -97.679146) 21.12 2015-02-23 \n",
"158273 (30.338618 -97.692566) 18.13 2014-12-23 \n",
"158296 (30.357262 -97.642666) 18.420000000000002 2015-01-09 \n",
"158354 (30.32562 -97.694628) 18.12 2014-12-26 \n",
"158523 (30.260764 -97.801664) 19.100000000000001 2014-12-19 \n",
"158624 (30.326002 -97.717455) 15.03 2015-02-24 \n",
"158661 (30.368413 -97.70575) 18.190000000000001 2014-12-24 \n",
"158828 (30.38275 -97.658594) 18.350000000000001 2015-01-09 \n",
"158877 (30.321239 -97.729295) 3.05 2014-12-23 \n",
"158882 (30.402642 -97.725361) 18.489999999999998 2015-01-15 \n",
"158981 (30.19201 -97.775267) 24.02 2014-12-26 \n",
"159102 (30.234742 -97.713771) 23.18 2014-12-23 \n",
"159132 (30.196836 -97.786991) 24.02 2014-12-21 \n",
"159136 (30.423635 -97.702557) 18.48 2014-12-22 \n",
"159285 (30.35502 -97.673257) 18.34 2014-12-30 \n",
"159456 (30.405797 -97.74491) 17.54 2015-01-04 \n",
"\n",
" clearance_status council_district_code \\\n",
"17 Not cleared 1.0 \n",
"86 Not cleared 3.0 \n",
"106 Not cleared 2.0 \n",
"150 Not cleared 4.0 \n",
"174 Not cleared 3.0 \n",
"266 Cleared by Exception 1.0 \n",
"413 Not cleared 4.0 \n",
"681 Cleared by Arrest 4.0 \n",
"756 Not cleared 9.0 \n",
"759 Not cleared 2.0 \n",
"768 Not cleared 9.0 \n",
"872 Not cleared 9.0 \n",
"887 Not cleared 5.0 \n",
"1041 Not cleared 7.0 \n",
"1082 Not cleared 7.0 \n",
"1177 Cleared by Exception 5.0 \n",
"1194 Cleared by Arrest 7.0 \n",
"1220 Cleared by Arrest 8.0 \n",
"1322 Not cleared 10.0 \n",
"1489 Cleared by Arrest 5.0 \n",
"1632 Not cleared 6.0 \n",
"1741 Not cleared 3.0 \n",
"1753 Not cleared 7.0 \n",
"1756 Not cleared 2.0 \n",
"1817 Cleared by Arrest 4.0 \n",
"1888 Cleared by Exception 6.0 \n",
"1922 Not cleared 9.0 \n",
"2191 Not cleared 9.0 \n",
"2205 Not cleared 3.0 \n",
"2221 Not cleared 5.0 \n",
"... ... ... \n",
"156917 Not cleared 7.0 \n",
"157096 Not cleared 3.0 \n",
"157104 Cleared by Arrest 3.0 \n",
"157224 Not cleared 5.0 \n",
"157346 Not cleared 9.0 \n",
"157369 Not cleared 3.0 \n",
"157418 Cleared by Arrest 1.0 \n",
"157446 Not cleared 9.0 \n",
"157548 Not cleared 1.0 \n",
"157564 Not cleared 9.0 \n",
"157731 Not cleared 1.0 \n",
"157869 Not cleared 7.0 \n",
"157924 Not cleared 5.0 \n",
"158182 Not cleared 9.0 \n",
"158242 Not cleared 1.0 \n",
"158273 Cleared by Arrest 4.0 \n",
"158296 Not cleared 1.0 \n",
"158354 Not cleared 4.0 \n",
"158523 Not cleared 8.0 \n",
"158624 Not cleared 4.0 \n",
"158661 Not cleared 4.0 \n",
"158828 Not cleared 1.0 \n",
"158877 Not cleared 9.0 \n",
"158882 Not cleared 7.0 \n",
"158981 Not cleared 2.0 \n",
"159102 Not cleared 3.0 \n",
"159132 Cleared by Arrest 2.0 \n",
"159136 Not cleared 7.0 \n",
"159285 Not cleared 1.0 \n",
"159456 Not cleared 7.0 \n",
"\n",
" description district latitude \\\n",
"17 AUTO THEFT C 30.271198 \n",
"86 THEFT BY SHOPLIFTING H 30.224918 \n",
"106 BURGLARY OF VEHICLE F 30.191043 \n",
"150 THEFT BY SHOPLIFTING I 30.336574 \n",
"174 THEFT H 30.230228 \n",
"266 THEFT C 30.278442 \n",
"413 THEFT E 30.363403 \n",
"681 AUTO THEFT E 30.356322 \n",
"756 THEFT OF BICYCLE B 30.291716 \n",
"759 BURGLARY OF VEHICLE F 30.190555 \n",
"768 THEFT B 30.307539 \n",
"872 THEFT C 30.290015 \n",
"887 THEFT OF BICYCLE D 30.259855 \n",
"1041 AUTO THEFT E 30.401689 \n",
"1082 THEFT A 30.392622 \n",
"1177 MISAPPLY FIDUCIARY PROP D 30.209401 \n",
"1194 AGG ASSAULT FAM/DATE VIOLENCE E 30.400032 \n",
"1220 THEFT D 30.255443 \n",
"1322 THEFT B 30.282830 \n",
"1489 THEFT D 30.236639 \n",
"1632 THEFT A 30.467694 \n",
"1741 THEFT C 30.260829 \n",
"1753 THEFT BY SHOPLIFTING B 30.357068 \n",
"1756 AUTO THEFT H 30.223062 \n",
"1817 THEFT BY SHOPLIFTING I 30.338618 \n",
"1888 AGG ASSAULT A 30.498698 \n",
"1922 THEFT H 30.234032 \n",
"2191 BURGLARY OF VEHICLE B 30.300002 \n",
"2205 AUTO THEFT G 30.254462 \n",
"2221 THEFT F 30.152748 \n",
"... ... ... ... \n",
"156917 AGG ASSAULT E 30.397116 \n",
"157096 THEFT H 30.239018 \n",
"157104 AGG ASLT STRANGLE/SUFFOCATE H 30.234873 \n",
"157224 THEFT F 30.199333 \n",
"157346 BURGLARY OF VEHICLE C 30.285687 \n",
"157369 BURGLARY OF VEHICLE C 30.267162 \n",
"157418 AGG ASSAULT C 30.279386 \n",
"157446 BURGLARY OF VEHICLE G 30.270207 \n",
"157548 BURGLARY OF VEHICLE I 30.300889 \n",
"157564 BURGLARY OF VEHICLE B 30.282999 \n",
"157731 ROBBERY BY ASSAULT I 30.329450 \n",
"157869 THEFT A 30.394899 \n",
"157924 THEFT OF LICENSE PLATE F 30.137904 \n",
"158182 BURGLARY OF VEHICLE H 30.238815 \n",
"158242 THEFT I 30.321478 \n",
"158273 THEFT BY SHOPLIFTING I 30.338618 \n",
"158296 AUTO THEFT E 30.357262 \n",
"158354 BURGLARY OF VEHICLE I 30.325620 \n",
"158523 BURGLARY OF VEHICLE D 30.260764 \n",
"158624 THEFT I 30.326002 \n",
"158661 AUTO THEFT E 30.368413 \n",
"158828 BURGLARY OF VEHICLE E 30.382750 \n",
"158877 THEFT I 30.321239 \n",
"158882 THEFT BY SHOPLIFTING A 30.402642 \n",
"158981 AGG ROBBERY/DEADLY WEAPON F 30.192010 \n",
"159102 THEFT H 30.234742 \n",
"159132 THEFT BY SHOPLIFTING F 30.196836 \n",
"159136 THEFT BY SHOPLIFTING A 30.423635 \n",
"159285 THEFT E 30.355020 \n",
"159456 AGG ASLT ENHANC STRANGL/SUFFOC A 30.405797 \n",
"\n",
" location location_description longitude \\\n",
"17 (30.271198-97.705609) 3506 WEBBERVILLE RD -97.705609 \n",
"86 (30.224918-97.70321) 6306 E RIVERSIDE DR -97.703210 \n",
"106 (30.191043-97.771802) 800 E WILLIAM CANNON DR -97.771802 \n",
"150 (30.336574-97.718265) 6929 AIRPORT BLVD -97.718265 \n",
"174 (30.230228-97.706314) 1600 GROVE BLVD -97.706314 \n",
"266 (30.278442-97.672073) 5800 TECHNI CENTER DR -97.672073 \n",
"413 (30.363403-97.69686) 9414 N LAMAR BLVD -97.696860 \n",
"681 (30.356322-97.684957) 933 E RUNDBERG LN -97.684957 \n",
"756 (30.291716-97.737747) 100 E 27TH ST -97.737747 \n",
"759 (30.190555-97.766839) 6503 BLUFF SPRINGS RD -97.766839 \n",
"768 (30.307539-97.710734) 1200 BARBARA JORDAN BLVD -97.710734 \n",
"872 (30.290015-97.707435) 3848 AIRPORT BLVD -97.707435 \n",
"887 (30.259855-97.758863) 517 S LAMAR BLVD -97.758863 \n",
"1041 (30.401689-97.702175) 12001 METRIC BLVD -97.702175 \n",
"1082 (30.392622-97.745915) 10107 RESEARCH BLVD SVRD NB -97.745915 \n",
"1177 (30.209401-97.805934) 2205 BERKELEY AVE -97.805934 \n",
"1194 (30.400032-97.652722) 12800 HARRISGLENN DR -97.652722 \n",
"1220 (30.255443-97.810066) 2901 S CAPITAL OF TEXAS HWY NB -97.810066 \n",
"1322 (30.28283-97.775923) 701 NEWMAN DR -97.775923 \n",
"1489 (30.236639-97.797956) 4115 S CAPITAL OF TEXAS HWY NB -97.797956 \n",
"1632 (30.467694-97.809861) 12617 RIDGELINE BLVD -97.809861 \n",
"1741 (30.260829-97.717161) 2311 HIDALGO ST -97.717161 \n",
"1753 (30.357068-97.733075) 2525 W ANDERSON LN -97.733075 \n",
"1756 (30.223062-97.670616) 9321 EVENING SHADOWS DR -97.670616 \n",
"1817 (30.338618-97.692566) 1030 NORWOOD PARK BLVD -97.692566 \n",
"1888 (30.498698-97.775867) 10600 W PARMER LN -97.775867 \n",
"1922 (30.234032-97.742436) 1320 E OLTORF ST -97.742436 \n",
"2191 (30.300002-97.742349) 702 W 32ND ST -97.742349 \n",
"2205 (30.254462-97.732058) 1406 HASKELL ST -97.732058 \n",
"2221 (30.152748-97.828527) 11308 ROBERT WOODING DR -97.828527 \n",
"... ... ... ... \n",
"156917 (30.397116-97.648791) 12712 BARTHOLDI ST -97.648791 \n",
"157096 (30.239018-97.730225) 1601 ROYAL CREST DR -97.730225 \n",
"157104 (30.234873-97.715023) 1500 CROSSING PL -97.715023 \n",
"157224 (30.199333-97.805965) 1806 MATTHEWS LN -97.805965 \n",
"157346 (30.285687-97.710335) 2900 MANOR RD -97.710335 \n",
"157369 (30.267162-97.700936) 3206 THOMPSON ST -97.700936 \n",
"157418 (30.279386-97.689768) 1211 COMETA ST -97.689768 \n",
"157446 (30.270207-97.74312) 121 W 8TH ST -97.743120 \n",
"157548 (30.300889-97.686737) 5304 CLOVERDALE LN -97.686737 \n",
"157564 (30.282999-97.746429) 706 W MARTIN LUTHER KING JR BLVD -97.746429 \n",
"157731 (30.32945-97.690009) 7517 CAMERON RD -97.690009 \n",
"157869 (30.394899-97.72685) 3211 FEATHERGRASS CT -97.726850 \n",
"157924 (30.137904-97.800345) 1901 ONION CREEK PKWY -97.800345 \n",
"158182 (30.238815-97.741) 1915 FAIRLAWN LN -97.741000 \n",
"158242 (30.321478-97.679146) 7104 NORTHEAST DR -97.679146 \n",
"158273 (30.338618-97.692566) 1030 NORWOOD PARK BLVD -97.692566 \n",
"158296 (30.357262-97.642666) 11024 RELIANCE CREEK DR -97.642666 \n",
"158354 (30.32562-97.694628) 1212 WESTHEIMER DR -97.694628 \n",
"158523 (30.260764-97.801664) 1916 HOLLY HILL DR -97.801664 \n",
"158624 (30.326002-97.717455) 6016 DILLARD CIR -97.717455 \n",
"158661 (30.368413-97.70575) 9433 PARKFIELD DR -97.705750 \n",
"158828 (30.38275-97.658594) 1406 DOMINIQUE DR -97.658594 \n",
"158877 (30.321239-97.729295) 5301 N LAMAR BLVD -97.729295 \n",
"158882 (30.402642-97.725361) 11600 CENTURY OAKS TER -97.725361 \n",
"158981 (30.19201-97.775267) 412 E WILLIAM CANNON DR -97.775267 \n",
"159102 (30.234742-97.713771) 1500 FARO DR -97.713771 \n",
"159132 (30.196836-97.786991) 600 W WILLIAM CANNON DR -97.786991 \n",
"159136 (30.423635-97.702557) 12707 N MOPAC EXPY NB -97.702557 \n",
"159285 (30.35502-97.673257) 9701 DESSAU RD -97.673257 \n",
"159456 (30.405797-97.74491) 11111 RESEARCH BLVD SVRD NB -97.744910 \n",
"\n",
" primary_type timestamp unique_key \\\n",
"17 Auto Theft 2014-12-18 00:00:00 2.014352e+10 \n",
"86 Theft: Shoplifting 2014-12-28 00:00:00 2.014362e+10 \n",
"106 Theft: BOV 2014-12-20 00:00:00 2.014506e+10 \n",
"150 Theft: Shoplifting 2014-12-14 00:00:00 2.014348e+10 \n",
"174 Theft: All Other Larceny 2014-12-18 00:00:00 2.014800e+10 \n",
"266 Theft: All Other Larceny 2014-11-19 00:00:00 2.014323e+10 \n",
"413 Theft: All Other Larceny 2014-11-11 00:00:00 2.014505e+10 \n",
"681 Auto Theft 2014-12-21 00:00:00 2.014355e+10 \n",
"756 Theft: All Other Larceny 2014-12-18 00:00:00 2.014352e+10 \n",
"759 Theft: BOV 2014-12-16 00:00:00 2.014506e+10 \n",
"768 Theft: All Other Larceny 2014-12-09 00:00:00 2.014505e+10 \n",
"872 Theft: All Other Larceny 2014-12-09 00:00:00 2.014505e+10 \n",
"887 Theft: All Other Larceny 2014-12-23 00:00:00 2.014506e+10 \n",
"1041 Auto Theft 2014-12-13 00:00:00 2.014347e+10 \n",
"1082 Theft: All Other Larceny 2014-11-18 00:00:00 2.014800e+10 \n",
"1177 Theft: All Other Larceny 2014-11-17 00:00:00 2.014505e+10 \n",
"1194 Aggravated Assault 2014-09-24 00:00:00 2.014267e+10 \n",
"1220 Theft: All Other Larceny 2014-01-10 00:00:00 2.014101e+09 \n",
"1322 Theft: All Other Larceny 2014-12-20 00:00:00 2.014354e+10 \n",
"1489 Theft: All Other Larceny 2014-05-08 00:00:00 2.014128e+10 \n",
"1632 Theft: All Other Larceny 2014-12-18 00:00:00 2.014506e+10 \n",
"1741 Theft: All Other Larceny 2014-11-22 00:00:00 2.014505e+10 \n",
"1753 Theft: Shoplifting 2014-12-30 00:00:00 2.014364e+10 \n",
"1756 Auto Theft 2014-12-28 00:00:00 2.014362e+10 \n",
"1817 Theft: Shoplifting 2014-10-01 00:00:00 2.014274e+10 \n",
"1888 Aggravated Assault 2014-12-16 00:00:00 2.014350e+10 \n",
"1922 Theft: All Other Larceny 2014-10-10 00:00:00 2.014283e+10 \n",
"2191 Theft: BOV 2014-12-05 00:00:00 2.014505e+10 \n",
"2205 Auto Theft 2014-11-29 00:00:00 2.014333e+10 \n",
"2221 Theft: All Other Larceny 2014-12-24 00:00:00 2.014358e+10 \n",
"... ... ... ... \n",
"156917 Aggravated Assault 2014-12-10 00:00:00 2.014344e+10 \n",
"157096 Theft: All Other Larceny 2014-10-29 00:00:00 2.014505e+10 \n",
"157104 Aggravated Assault 2014-12-20 00:00:00 2.014354e+10 \n",
"157224 Theft: All Other Larceny 2014-12-23 00:00:00 2.014506e+10 \n",
"157346 Theft: BOV 2014-12-16 00:00:00 2.014506e+10 \n",
"157369 Theft: BOV 2014-12-15 00:00:00 2.014505e+10 \n",
"157418 Aggravated Assault 2014-10-01 00:00:00 2.014274e+10 \n",
"157446 Theft: BOV 2014-12-01 00:00:00 2.014505e+10 \n",
"157548 Theft: BOV 2014-11-22 00:00:00 2.014505e+10 \n",
"157564 Theft: BOV 2014-11-15 00:00:00 2.014505e+10 \n",
"157731 Robbery 2014-12-26 00:00:00 2.014360e+10 \n",
"157869 Theft: All Other Larceny 2014-12-13 00:00:00 2.014506e+10 \n",
"157924 Theft: All Other Larceny 2014-12-18 00:00:00 2.014506e+10 \n",
"158182 Theft: BOV 2014-12-09 00:00:00 2.014505e+10 \n",
"158242 Theft: All Other Larceny 2014-12-12 00:00:00 2.014505e+10 \n",
"158273 Theft: Shoplifting 2014-11-04 00:00:00 2.014308e+10 \n",
"158296 Auto Theft 2014-12-04 00:00:00 2.014338e+10 \n",
"158354 Theft: BOV 2014-12-20 00:00:00 2.014354e+10 \n",
"158523 Theft: BOV 2014-12-02 00:00:00 2.014336e+10 \n",
"158624 Theft: All Other Larceny 2014-11-07 00:00:00 2.014505e+10 \n",
"158661 Auto Theft 2014-12-22 00:00:00 2.014356e+10 \n",
"158828 Theft: BOV 2014-12-31 00:00:00 2.014506e+10 \n",
"158877 Theft: All Other Larceny 2014-12-11 00:00:00 2.014345e+10 \n",
"158882 Theft: Shoplifting 2014-11-08 00:00:00 2.014505e+10 \n",
"158981 Robbery 2014-11-16 00:00:00 2.014320e+10 \n",
"159102 Theft: All Other Larceny 2014-12-15 00:00:00 2.014506e+10 \n",
"159132 Theft: Shoplifting 2014-12-20 00:00:00 2.014354e+10 \n",
"159136 Theft: Shoplifting 2014-12-15 00:00:00 2.014349e+10 \n",
"159285 Theft: All Other Larceny 2014-12-29 00:00:00 2.014506e+10 \n",
"159456 Aggravated Assault 2014-12-28 00:00:00 2.014362e+10 \n",
"\n",
" x_coordinate y_coordinate year zipcode \n",
"17 3125976.0 10072207.0 2014.0 78702.0 \n",
"86 3127258.0 10055405.0 2014.0 78741.0 \n",
"106 3105816.0 10042612.0 2014.0 78745.0 \n",
"150 3121678.0 10096228.0 2014.0 78752.0 \n",
"174 3125983.0 10057278.0 2014.0 78741.0 \n",
"266 3136582.0 10075176.0 2014.0 78721.0 \n",
"413 3127650.0 10106327.0 2014.0 78758.0 \n",
"681 3131733.0 10103162.0 2014.0 78753.0 \n",
"756 3115712.0 10079702.0 2014.0 78705.0 \n",
"759 3107457.0 10042310.0 2014.0 78744.0 \n",
"768 3124571.0 10085297.0 2014.0 78723.0 \n",
"872 3125168.0 10078794.0 2014.0 78722.0 \n",
"887 3109538.0 10067577.0 2014.0 78704.0 \n",
"1041 3126112.0 10119741.0 2014.0 78758.0 \n",
"1082 3112264.0 10116438.0 2014.0 78759.0 \n",
"1177 3094819.0 10048899.0 2014.0 78745.0 \n",
"1194 3141537.0 10119603.0 2014.0 78753.0 \n",
"1220 3094135.0 10066586.0 2014.0 78746.0 \n",
"1322 3103774.0 10075849.0 2014.0 78703.0 \n",
"1489 3097832.0 10059242.0 2014.0 78704.0 \n",
"1632 3092290.0 10142671.0 2014.0 78613.0 \n",
"1741 3122663.0 10068215.0 2014.0 78702.0 \n",
"1753 3116494.0 10102601.0 2014.0 78757.0 \n",
"1756 3137545.0 10054755.0 2014.0 78617.0 \n",
"1817 3129997.0 10096983.0 2014.0 78753.0 \n",
"1888 3102230.0 10154430.0 2014.0 78717.0 \n",
"1922 3114800.0 10058474.0 2014.0 78704.0 \n",
"2191 3114177.0 10082461.0 2014.0 78705.0 \n",
"2205 3117855.0 10065994.0 2014.0 78702.0 \n",
"2221 3088135.0 10028195.0 2014.0 78748.0 \n",
"... ... ... ... ... \n",
"156917 3142774.0 10118416.0 2014.0 78753.0 \n",
"157096 3118667.0 10060221.0 2014.0 78741.0 \n",
"157104 3123227.0 10058967.0 2014.0 78741.0 \n",
"157224 3094975.0 10045360.0 2014.0 78745.0 \n",
"157346 3124405.0 10077491.0 2014.0 78722.0 \n",
"157369 3127558.0 10070798.0 2014.0 78702.0 \n",
"157418 3131034.0 10075286.0 2014.0 78721.0 \n",
"157446 3114135.0 10071513.0 2014.0 78701.0 \n",
"157548 3131722.0 10083162.0 2014.0 78723.0 \n",
"157564 3113117.0 10076266.0 2014.0 78705.0 \n",
"157731 3130685.0 10093333.0 2014.0 78752.0 \n",
"157869 3118106.0 10116812.0 2014.0 78758.0 \n",
"157924 3097241.0 10022889.0 2014.0 78748.0 \n",
"158182 3115195.0 10060096.0 2014.0 78704.0 \n",
"158242 3133900.0 10090625.0 2014.0 78723.0 \n",
"158273 3129997.0 10096983.0 2014.0 78753.0 \n",
"158296 3145132.0 10104015.0 2014.0 78754.0 \n",
"158354 3129079.0 10092100.0 2014.0 78752.0 \n",
"158523 3095757.0 10067577.0 2014.0 78746.0 \n",
"158624 3121779.0 10092034.0 2014.0 78752.0 \n",
"158661 3125277.0 10107519.0 2014.0 78758.0 \n",
"158828 3139927.0 10113123.0 2014.0 78753.0 \n",
"158877 3118221.0 10090150.0 2014.0 78751.0 \n",
"158882 3118703.0 10120061.0 2014.0 78758.0 \n",
"158981 3104793.0 10043078.0 2014.0 78745.0 \n",
"159102 3123698.0 10058703.0 2014.0 78741.0 \n",
"159132 3101178.0 10044981.0 2014.0 78745.0 \n",
"159136 3126500.0 10127412.0 2014.0 78727.0 \n",
"159285 3135717.0 10102799.0 2014.0 78754.0 \n",
"159456 3112507.0 10120833.0 2014.0 78759.0 \n",
"\n",
"[2085 rows x 18 columns]"
]
},
"execution_count": 21,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df[df['clearance_date']>datetime.date(2014,12,18)]"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 2",
"language": "python",
"name": "python2"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 2
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython2",
"version": "2.7.13"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment