Spreadsheet: 478616d1472916765-large-spreadsheet-has-3-4-rows-of-data-need-to-combine-some-of-the-data-into-one-row-ef966_reformatting_data_david-new-a
Sheet: Table 1

Case # | Start Date | End Date | Rpt. Date | Offense | Weapon | Territory | Location |  | Helper |  | match_row | Que Number | Start Date | Start Time | Offense |  | Location
Off. Seq. | Start Time | End Time | Rpt. Time |  | Status | Badge
 | Start Day | End Day | Rpt. Day |  | Disposition | Officer
120 -1 Incidents, 10ffenses
13-033179 | 2013-03-28 00:00:00 | 2013-03-28 00:00:00 | 2013-03-28 00:00:00 | - PROPERTY FOUND |  | 120 | 2427 GRESHAM RD
PRIMARY | 14:15:00 | 14:30:00 | 14:15:00 |  | FURTHER INVESTIGATION | 1445
 | THU. | THU. | THU. |  |  | AM PREZIOSI
220 -7 Incidents, 9 Offenses
13-024604 | 2013-03-01 00:00:00 | 2013-03-06 00:00:00 | 2013-03-06 00:00:00 | - PROPERTY DAMAGE |  | 220 | 1942 SHAWN WAYNE CIR
PRIMARY | 00:00:00 | 15:00:00 | 15:00:00 |  | FURTHER INVESTIGATION | 6555
 | FR!. | WED. | FR!. |  |  | AN RENFROE
14-063790 | 2014-06-26 00:00:00 | 2014-06-26 00:00:00 | 2014-06-26 00:00:00 | - FAMILY OFFENSE FREE TEXT | HANDS/FISTS/ETC | 220 | 1930 FLAT SHOALS RD,
[NAME] | 21:30:00 | 22:00:00 | 22:04:00 |  | FURTHER INVESTIGATION | 2233 | APT, P-3
 | THU. | THU. | THU. |  |  | RM WEEKLEY
14-105262 | 2014-10-18 00:00:00 | 2014-10-18 00:00:00 | 2014-10-18 00:00:00 | - FAMILY OFFENSE FREE TEXT | HANDS/FISTS/ETC | 220 | 1776 FAYETTEVILLE
[NAME] | 08:15:00 | 08:20:00 | 08:30:00 |  |  | 3158 | COURT
 | SAT. | SAT. | SAT. |  |  | GRIMES J A
14-063790 | 2014-06-26 00:00:00 | 2014-06-26 00:00:00 | 2014-06-26 00:00:00 | 16-5-23 (1313) - SIMPLE | HANDS/FISTS/ETC | 220 | 1930 FLAT SHOALS RD,
PRIMARY | 21:30:00 | 22:00:00 | 22:04:00 | BATIERY 16-5-23 | FURTHER INVESTIGATION | 2233 | APT. P-3
 | THU. | THU. | THU. |  |  | RM WEEKLEY
14-105262 | 2014-10-18 00:00:00 | 2014-10-18 00:00:00 | 2014-10-18 00:00:00 | 16-5-23.1 (1313) - SIMPLE | HANDS/FISTS/ETC | 220 | 1776 FAYETTEVILLE
PRIMARY | 08:15:00 | 08:20:00 | 08:30:00 | BATTERY |  | 3158 | COURT
 | SAT. | SAT. | SAT. |  |  | GRIMES J A
15-078132 | 2015/0B/09 | 2015-08-09 00:00:00 | 2015-08-09 00:00:00 | 16-8-14 (m) (2303) - | HANDS/FISTS/ETC | 220 | 2427 GRESHAM RD
PRIMARY | 13:15:00 | 13:50:00 | 13:40:00 | SHOPLIFTING |  | 3301
 | SUN. | SUN. | SUN. |  |  | FLEMMING C J
14-018750 | 2014-02-25 00:00:00 | 2014-02-25 00:00:00 | 2014-02-25 00:00:00 | 16-8-14 (M) (2303) - |  | 220 | 2427 GRESHAM RD
PRIMARY | 15:30:00 | 16:30:00 | 15:50:00 | SHOPLIFTING 16-8-14 | FURTHER INVESTIGATION | 2415
 | TUE. | TUE. | TUE. |  |  | MB HARRIS
13-057977 | 2013-05-21 00:00:00 | 2013-05-21 00:00:00 | 2013-05-29 00:00:00 | 16-B-3 (2399) - THEFT BY |  | 220 | 2170 LILAC LN
PRIMARY | 19:30:00 | 20:00:00 | 13:59:00 | DECEPTION 16-8-3 | FURTHER INVESTIGATION | 6555
 | TUE. | TUE. | TUE. |  | EXCEPTIONALLY CLEARED | AN RENFROE
Printed August 4, 2016 |  |  |  |  |  |  | Page 1 of 482
230 - 10 Incidents, 12 Offenses
14-033196 | 2014-04-07 00:00:00 | 2014-04-07 00:00:00 | 2014-04-07 00:00:00 | - FRAUDULENT ACTIVITY |  | 230 | 2047 2ND AVE
PRIMARY | 16:09:00 | 16:09:00 | 16:09:00 |  | FURTHER INVESTIGATION | 2893
 | MON. | MON. | MON. |  |  | TD CAPALDI
15-034692 | 2015-04-12 00:00:00 | 2015-04-12 00:00:00 | 2015-04-12 00:00:00 | - FAMILY OFFENSE FREE TEXT | HANDS/FISTS/ETC | 230 | 1805 VICKI LANE
[NAME] | 23:39:00 | 23:45:00 | 23:39:00 |  |  | 3308
 | SUN. | SUN. | SUN. |  |  | RASKIN YC
14-063220 | 2014-06-25 00:00:00 | 2014-06-25 00:00:00 | 2014-06-25 00:00:00 | 16-10-24 (4802) - |  | 230 | 2427 GRESHAM RD
[NAME] | 13:00:00 | 13:15:00 | 13:17:00 | OBSTRUCTING OFFICER | FURTHER INVESTIGATION | 2427
 | WED. | WED. | WED. | 16-10-24 | CLEARED BY ARREST | DC REESE
 |  |  |  |  |  | #2427
13-023013 | 2013-03-01 00:00:00 | 2013-03-01 00:00:00 | 2013-03-01 00:00:00 | 16-45.2 - ENGAGING IN |  | 230 | 1504 BOULDERCREST RD
PRIMARY | 21:30:00 | 21:30:00 | 21:30:00 | DRUG-RELATED ACTIVITY | FURTHER INVESTIGATION | 2646
 | FR!. | FR!. | FR!. |  |  | R JACKSON
15-034692 | 2015-04-12 00:00:00 | 2015-04-12 00:00:00 | 2015-04-12 00:00:00 | 16-5-23 (1313) - SIMPLE | HANDS/FISTS/ETC | 230 | 1805 VICKI LANE
PRIMARY | 23:39:00 | 23:45:00 | 23:39:00 | ASSAULT/SIMPLE BATTERY |  | 3308
 | SUN. | SUN. | SUN. |  |  | RASKIN YC
15-057416 | 2015-06-14 00:00:00 | 2015-06-15 00:00:00 | 2015-06-15 00:00:00 | 16-5-23 (1313) - SIMPLE | HANDS/FISTS/ETC | 230 | 2051 FLAT SHOALS RD,
PRIMARY | 23:50:00 | 00:00:00 | 06:16:00 | ASSAULT/SIMPLE BATTERY |  | 3124 | APT. G-l
 | SUN. | MON. | SUN. |  |  | ELLIS D
16-018095 | 2015-06-10 00:00:00 | 2015-10-01 00:00:00 | 2016-02-23 00:00:00 | 16-5-45 (7399) - FAMILY |  | 230 | 1923 DONNA PL
PRIMARY | 12:00:00 | 12:00:00 | 17:02:00 | OFFENSE FREE TEXT |  | 6553
 | WED. | THU. | WED. |  |  | HINES J
15-037227 | 2015-04-17 00:00:00 | 2015-04-20 00:00:00 | 2015-04-20 00:00:00 | 16-7-21 (2902) - DAMAGE TO |  | 230 | 2105 VINEYARD WALK,
PRIMARY | 13:30:00 | 01:14:00 | 01:14:00 | PROPERTY - PRIVATE |  | 3308 | APT. I
 | FR!. | MON. | FR!. |  |  | RASKIN YC
15-070228 | 2015-07-19 00:00:00 | 2015-07-19 00:00:00 | 2015-07-20 00:00:00 | 16-8-14 (f) (2303) - |  | 230 | 2427 GRESHAM ROAD
PRIMARY | 13:55:00 | 14:33:00 | 01:42:00 | SHOPLIFTING |  | 3292
 | SUN. | SUN. | SUN. |  |  | ADAMS CC
14-063220 | 2014-06-25 00:00:00 | 2014-06-25 00:00:00 | 2014-06-25 00:00:00 | 16-8-14 (M) (2303) - |  | 230 | 2427 GRESHAM RD
PRIMARY | 13:00:00 | 13:15:00 | 13:17:00 | SHOPLIFTING 16-8-14 | FURTHER INVESTIGATION | 2427
 | WED. | WED. | WED. |  | CLEARED BY ARREST | DC REESE
 |  |  |  |  |  | #2427
Printed August 4, 2016 |  |  |  |  |  |  | Page 2 of 482