Spreadsheet: 583041d1532191794-large-data-base-that-needs-some-cells-filled-in-see-attachment-how-to-separate-crimes-that-have-one-crime-category-but-many-incidents
Sheet: original

Highest UCR Code | UCR Code Description | Case Number | Incident From Date | Incident From Time | Address String |  | Highest UCR Code | UCR Code Description | Case Number | Incident From Date | Incident From Time | Address String
230F | THEFT FROM A MOTOR VEHICLE | PD180105005905 | 2018-01-02 00:00:00 | 2018-07-01 09:00:00 | UNK DADE COUNTY |  | 230F | THEFT FROM MOTOR VEHICLE | PD180105005905 | 2018-01-02 00:00:00 | 2018-07-01 09:00:00 | UNK DADE COUNTY
 |  | PD180216062846 | 2018-02-10 00:00:00 | 2018-07-01 09:00:00 | UNK MIAMI DADE COUNTY |  | 230F | THEFT FROM MOTOR VEHICLE | PD180216062846 | 2018-02-10 00:00:00 | 2018-07-01 09:00:00 | UNK MIAMI DADE COUNTY
 |  | PD180531200178 | 2018-05-31 00:00:00 | 2018-07-01 14:00:00 | UNK MIAMI-DADE COUNTY |  | 230F | THEFT FROM MOTOR VEHICLE | PD180531200178 | 2018-05-31 00:00:00 | 2018-07-01 14:00:00 | UNK MIAMI-DADE COUNTY
 |  | PD180621227813 | 2018-06-09 00:00:00 | 2018-07-01 09:14:59.999000 | 7405 NORTHWEST 36TH AVENUE |  | 230F | THEFT FROM MOTOR VEHICLE | PD180621227813 | 2018-06-09 00:00:00 | 2018-07-01 09:14:59.999000 | 7405 NORTHWEST 36TH AVENUE
Total Number of Case for 230F : |  | 4 |  |  |  |  | 230G | THEFT FROM ALL OTHERS | PD180110013002 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | UNK UNKNOWN
230G | THEFT FROM ALL OTHERS | PD180110013002 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | UNK UNKNOWN |  | 230G | THEFT FROM ALL OTHERS | PD180203044830 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | UNKNOW DADE COUNTY
 |  | PD180203044830 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180104004778 | 2018-01-04 00:00:00 | 2018-07-01 08:00:00 | NO VALID ADDRESS AVAILABLE
 |  | PD180104004778 | 2018-01-04 00:00:00 | 2018-07-01 08:00:00 | NO VALID ADDRESS AVAILABLE |  | 230G | THEFT FROM ALL OTHERS | PD180105005784 | 2018-01-05 00:00:00 | 2018-07-01 12:16:00 | W PALM DR & SW 187TH AVE
 |  | PD180105005784 | 2018-01-05 00:00:00 | 2018-07-01 12:16:00 | W PALM DR & SW 187TH AVE |  | 230G | THEFT FROM ALL OTHERS | PD180112014736 | 2018-01-11 00:00:00 | 2018-07-01 06:00:00 | UNKNOW DADE COUNTY
 |  | PD180112014736 | 2018-01-11 00:00:00 | 2018-07-01 06:00:00 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180320105475 | 2018-01-15 00:00:00 | 2018-07-01 00:00:00 | UNKNOWN MIAMI DADE COUNTY
 |  | PD180320105475 | 2018-01-15 00:00:00 | 2018-07-01 00:00:00 | UNKNOWN MIAMI DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180117022428 | 2018-01-17 00:00:00 | 2018-07-01 15:00:00 | UNKNOW DADE COUNTY
 |  | PD180117022428 | 2018-01-17 00:00:00 | 2018-07-01 15:00:00 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180123029804 | 2018-01-20 00:00:00 | 2018-07-01 23:29:59.999000 | UNK UNK
 |  | PD180123029804 | 2018-01-20 00:00:00 | 2018-07-01 23:29:59.999000 | UNK UNK |  | 230G | THEFT FROM ALL OTHERS | PD180123029523 | 2018-01-22 00:00:00 | 2018-07-01 08:29:59.999000 | NW UNKNOWN & NW UNKNOWN
 |  | PD180123029523 | 2018-01-22 00:00:00 | 2018-07-01 08:29:59.999000 | NW UNKNOWN & NW UNKNOWN |  | 230G | THEFT FROM ALL OTHERS | PD180124031347 | 2018-01-23 00:00:00 | 2018-07-01 17:00:00 | UNK UNKNOWN
 |  | PD180124031347 | 2018-01-23 00:00:00 | 2018-07-01 17:00:00 | UNK UNKNOWN |  | 230G | THEFT FROM ALL OTHERS | PD180125032622 | 2018-01-24 00:00:00 | 2018-07-01 08:00:00 | UNK UNK
 |  | PD180125032622 | 2018-01-24 00:00:00 | 2018-07-01 08:00:00 | UNK UNK |  | 230G | THEFT FROM ALL OTHERS | PD180430159619 | 2018-02-01 00:00:00 | 2018-07-01 08:00:00 | UNK UNKNOWN
 |  | PD180430159619 | 2018-02-01 00:00:00 | 2018-07-01 08:00:00 | UNK UNKNOWN |  | 230G | THEFT FROM ALL OTHERS | PD180204046466 | 2018-02-02 00:00:00 | 2018-07-01 09:30:00 | UNKNOW DADE COUNTY
 |  | PD180204046466 | 2018-02-02 00:00:00 | 2018-07-01 09:30:00 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180209052660 | 2018-02-03 00:00:00 | 2018-07-01 18:30:00 | NW UNKNOWN & NW UNKNOWN
 |  | PD180209052660 | 2018-02-03 00:00:00 | 2018-07-01 18:30:00 | NW UNKNOWN & NW UNKNOWN |  | 230G | THEFT FROM ALL OTHERS | PD180209053147 | 2018-02-05 00:00:00 | 2018-07-01 19:40:00 | UNK DADE COUNTY
 |  | PD180209053147 | 2018-02-05 00:00:00 | 2018-07-01 19:40:00 | UNK DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180210054242 | 2018-02-09 00:00:00 | 2018-07-01 09:59:59.999000 | UNK UNK
 |  | PD180210054242 | 2018-02-09 00:00:00 | 2018-07-01 09:59:59.999000 | UNK UNK |  | 230G | THEFT FROM ALL OTHERS | PD180218065227 | 2018-02-15 00:00:00 | 2018-07-01 00:00:00 | UNKNOWN MIAMI DADE COUNTY
 |  | PD180218065227 | 2018-02-15 00:00:00 | 2018-07-01 00:00:00 | UNKNOWN MIAMI DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180226075681 | 2018-02-17 00:00:00 | 2018-07-01 12:00:00 | UNK UNK
 |  | PD180226075681 | 2018-02-17 00:00:00 | 2018-07-01 12:00:00 | UNK UNK |  | 230G | THEFT FROM ALL OTHERS | PD180220067536 | 2018-02-19 00:00:00 | 2018-07-01 15:59:59.999000 | UNKNOW DADE COUNTY
 |  | PD180220067536 | 2018-02-19 00:00:00 | 2018-07-01 15:59:59.999000 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180223071963 | 2018-02-20 00:00:00 | 2018-07-01 21:59:59.999000 | UNKNOW DADE COUNTY
 |  | PD180223071963 | 2018-02-20 00:00:00 | 2018-07-01 21:59:59.999000 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180301079841 | 2018-02-22 00:00:00 | 2018-07-01 12:00:00 | UNK UNK
 |  | PD180301079841 | 2018-02-22 00:00:00 | 2018-07-01 12:00:00 | UNK UNK |  | 230G | THEFT FROM ALL OTHERS | PD180224072831 | 2018-02-23 00:00:00 | 2018-07-01 07:24:59.999000 | UNK UNK
 |  | PD180224072831 | 2018-02-23 00:00:00 | 2018-07-01 07:24:59.999000 | UNK UNK |  | 230G | THEFT FROM ALL OTHERS | PD180228078811 | 2018-02-27 00:00:00 | 2018-07-01 15:00:00 | UNKNOW DADE COUNTY
 |  | PD180228078811 | 2018-02-27 00:00:00 | 2018-07-01 15:00:00 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180302081660 | 2018-03-02 00:00:00 | 2018-07-01 15:46:59.999000 | UNKNOW DADE COUNTY
 |  | PD180302081660 | 2018-03-02 00:00:00 | 2018-07-01 15:46:59.999000 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180304083979 | 2018-03-03 00:00:00 | 2018-07-01 11:00:00 | NO VALID ADDRESS AVAILABLE
 |  | PD180304083979 | 2018-03-03 00:00:00 | 2018-07-01 11:00:00 | NO VALID ADDRESS AVAILABLE |  | 230G | THEFT FROM ALL OTHERS | PD180317101339 | 2018-03-08 00:00:00 | 2018-07-01 08:00:00 | UNK UNK
 |  | PD180317101339 | 2018-03-08 00:00:00 | 2018-07-01 08:00:00 | UNK UNK |  | 230G | THEFT FROM ALL OTHERS | PD180313096121 | 2018-03-13 00:00:00 | 2018-07-01 09:59:59.999000 | UNKNOW DADE COUNTY
 |  | PD180313096121 | 2018-03-13 00:00:00 | 2018-07-01 09:59:59.999000 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180327114368 | 2018-03-25 00:00:00 | 2018-07-01 09:59:59.999000 | UNKNOW DADE COUNTY
 |  | PD180327114368 | 2018-03-25 00:00:00 | 2018-07-01 09:59:59.999000 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180329117254 | 2018-03-28 00:00:00 | 2018-07-01 18:00:00 | UNKNOW DADE COUNTY
 |  | PD180329117254 | 2018-03-28 00:00:00 | 2018-07-01 18:00:00 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180406127968 | 2018-03-29 00:00:00 | 2018-07-01 08:00:00 | UNKNOW DADE COUNTY
 |  | PD180406127968 | 2018-03-29 00:00:00 | 2018-07-01 08:00:00 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180424151782 | 2018-04-22 00:00:00 | 2018-07-01 00:00:00 | NO VALID ADDRESS AVAILABLE
 |  | PD180424151782 | 2018-04-22 00:00:00 | 2018-07-01 00:00:00 | NO VALID ADDRESS AVAILABLE |  | 230G | THEFT FROM ALL OTHERS | PD180430159328 | 2018-04-23 00:00:00 | 2018-07-01 00:00:00 | UNK DADE COUNTY
 |  | PD180430159328 | 2018-04-23 00:00:00 | 2018-07-01 00:00:00 | UNK DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180426154511 | 2018-04-23 00:00:00 | 2018-07-01 14:00:00 | UNKNOWN MIAMI-DADE COUNTY
 |  | PD180426154511 | 2018-04-23 00:00:00 | 2018-07-01 14:00:00 | UNKNOWN MIAMI-DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180429158876 | 2018-04-25 00:00:00 | 2018-07-01 08:00:00 | UNK UNKNOWN
 |  | PD180429158876 | 2018-04-25 00:00:00 | 2018-07-01 08:00:00 | UNK UNKNOWN |  | 230G | THEFT FROM ALL OTHERS | PD180501160904 | 2018-04-27 00:00:00 | 2018-07-01 08:00:00 | UNK UNK
 |  | PD180501160904 | 2018-04-27 00:00:00 | 2018-07-01 08:00:00 | UNK UNK |  | 230G | THEFT FROM ALL OTHERS | PD180428157474 | 2018-04-27 00:00:00 | 2018-07-01 12:00:00 | UNKNOWN DADE COUNTY
 |  | PD180428157474 | 2018-04-27 00:00:00 | 2018-07-01 12:00:00 | UNKNOWN DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180501161203 | 2018-04-29 00:00:00 | 2018-07-01 08:00:00 | UNKNOW DADE COUNTY
 |  | PD180501161203 | 2018-04-29 00:00:00 | 2018-07-01 08:00:00 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180517182113 | 2018-05-01 00:00:00 | 2018-07-01 08:00:00 | UNKNOW DADE COUNTY
 |  | PD180517182113 | 2018-05-01 00:00:00 | 2018-07-01 08:00:00 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180502162815 | 2018-05-01 00:00:00 | 2018-07-01 15:00:00 | UNKNOW DADE COUNTY
 |  | PD180502162815 | 2018-05-01 00:00:00 | 2018-07-01 15:00:00 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180502162379 | 2018-05-02 00:00:00 | 2018-07-01 14:29:00 | BRIDGE END & WINDMILL GATE RD
 |  | PD180502162379 | 2018-05-02 00:00:00 | 2018-07-01 14:29:00 | BRIDGE END & WINDMILL GATE RD |  | 230G | THEFT FROM ALL OTHERS | PD180517181978 | 2018-05-15 00:00:00 | 2018-07-01 23:00:00 | UNKNOW DADE COUNTY
 |  | PD180517181978 | 2018-05-15 00:00:00 | 2018-07-01 23:00:00 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180518182934 | 2018-05-16 00:00:00 | 2018-07-01 23:29:59.999000 | UNKNOWN DADE COUNTY
 |  | PD180518182934 | 2018-05-16 00:00:00 | 2018-07-01 23:29:59.999000 | UNKNOWN DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180524190885 | 2018-05-17 00:00:00 | 2018-07-01 09:59:59.999000 | UK UK
 |  | PD180524190885 | 2018-05-17 00:00:00 | 2018-07-01 09:59:59.999000 | UK UK |  | 230G | THEFT FROM ALL OTHERS | PD180523189431 | 2018-05-23 00:00:00 | 2018-07-01 12:44:00 | UNK UNKNOWN
 |  | PD180523189431 | 2018-05-23 00:00:00 | 2018-07-01 12:44:00 | UNK UNKNOWN |  | 230G | THEFT FROM ALL OTHERS | PD180528195740 | 2018-05-27 00:00:00 | 2018-07-01 09:00:00 | UNKNOW DADE COUNTY
 |  | PD180528195740 | 2018-05-27 00:00:00 | 2018-07-01 09:00:00 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180604205213 | 2018-06-02 00:00:00 | 2018-07-01 18:00:00 | UNKNOW DADE COUNTY
 |  | PD180604205213 | 2018-06-02 00:00:00 | 2018-07-01 18:00:00 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180606207890 | 2018-06-06 00:00:00 | 2018-07-01 10:30:00 | 7167 SW 103CT CIR
 |  | PD180606207890 | 2018-06-06 00:00:00 | 2018-07-01 10:30:00 | 7167 SW 103CT CIR |  | 230G | THEFT FROM ALL OTHERS | PD180618224033 | 2018-06-13 00:00:00 | 2018-07-01 08:00:00 | UNKNOW DADE COUNTY
 |  | PD180618224033 | 2018-06-13 00:00:00 | 2018-07-01 08:00:00 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180622229414 | 2018-06-20 00:00:00 | 2018-07-01 08:00:00 | UNKNOW DADE COUNTY
 |  | PD180622229414 | 2018-06-20 00:00:00 | 2018-07-01 08:00:00 | UNKNOW DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180625233247 | 2018-06-24 00:00:00 | 2018-07-01 12:59:59.999000 | UNKNOWN MIAMI-DADE COUNTY
 |  | PD180625233247 | 2018-06-24 00:00:00 | 2018-07-01 12:59:59.999000 | UNKNOWN MIAMI-DADE COUNTY |  | 230G | THEFT FROM ALL OTHERS | PD180629237986 | 2018-06-29 00:00:00 | 2018-07-01 08:45:00 | 3690 N 56 AVE
 |  | PD180629237986 | 2018-06-29 00:00:00 | 2018-07-01 08:45:00 | 3690 N 56 AVE