crimelog
1,553 rows where year = 2019 sorted by building descending
This data as json, CSV (advanced)
Suggested facets: outcome, datetime (date)
Link | rowid | id | title | year | datetime | building ▲ | address | outcome |
---|---|---|---|---|---|---|---|---|
741 | 741 | #19-04662 | TALK WITH OFFICER | 2019 | 2019-10-30 15:01:00 | WVU WOODBURN HALL | 1515 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Forward to Other Agency |
818 | 818 | #19-04582 | SUSPICIOUS EVENT | 2019 | 2019-10-26 02:33:00 | WVU WOODBURN HALL | 1515 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
1484 | 1484 | #19-05456 | DESTRUCTION OF PROPERTY | 2019 | 2019-12-22 08:00:00 | WVU WOODBURN HALL | 1515 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Inactive |
33 | 33 | #19-05401 | VANDALISM | 2019 | 2019-12-17 09:03:00 | WVU WOODBURN CIRCLE | 39.635817, -79.954791, MORGANTOWN, WV 26501 | Inactive |
644 | 644 | #19-04759 | LARCENY | 2019 | 2019-11-02 12:17:00 | WVU WOODBURN CIRCLE | 39.635817, -79.954791, MORGANTOWN, WV 26501 | Inactive |
696 | 696 | #19-04707 | SUSPICIOUS PERSON | 2019 | 2019-11-01 11:37:00 | WVU WISE LIBRARY | 1498 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Arrest |
803 | 803 | #19-04598 | PUBLIC INTOX | 2019 | 2019-10-27 03:30:00 | WVU WISE LIBRARY | 1498 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning |
840 | 840 | #19-04560 | TALK WITH OFFICER | 2019 | 2019-10-25 10:36:00 | WVU WISE LIBRARY | 1498 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
882 | 882 | #19-04516 | LARCENY | 2019 | 2019-10-22 12:00:00 | WVU WISE LIBRARY | 1498 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Inactive |
80 | 80 | #19-05352 | LOST PROPERTY | 2019 | 2019-12-13 14:08:00 | WVU WHITE HALL | 135 WILLEY ST, MORGANTOWN, WV 26501 | Closed - Resolved |
111 | 111 | #19-05320 | TALK WITH OFFICER | 2019 | 2019-12-10 20:45:00 | WVU WHITE HALL | 135 WILLEY ST, MORGANTOWN, WV 26501 | Inactive |
140 | 140 | #19-05289 | TALK WITH OFFICER | 2019 | 2019-12-09 16:52:00 | WVU WHITE HALL | 135 WILLEY ST, MORGANTOWN, WV 26501 | Closed - Resolved |
347 | 347 | #19-05068 | TALK WITH OFFICER | 2019 | 2019-11-20 21:45:00 | WVU WHITE HALL | 135 WILLEY ST, MORGANTOWN, WV 26501 | Inactive |
1053 | 1053 | #19-04336 | TALK WITH OFFICER | 2019 | 2019-10-14 11:12:00 | WVU WHITE HALL | 135 WILLEY ST, MORGANTOWN, WV 26501 | Closed - Resolved |
118 | 118 | #19-05313 | TALK WITH OFFICER | 2019 | 2019-12-10 21:37:00 | WVU WATERFRONT MARINA | 40 DONLEY ST, MORGANTOWN, WV 26501 | Inactive |
189 | 189 | #19-05238 | ELEVATOR RESCUE | 2019 | 2019-12-06 23:13:00 | WVU VANDALIA HALL GOLD | 49 FALLING RUN RD, MORGANTOWN, WV 26501 | Closed - Resolved |
1488 | 1488 | #19-05452 | INFORMATION REPORT | 2019 | 2019-12-21 10:51:00 | WVU VANDALIA HALL GOLD | 49 FALLING RUN RD, MORGANTOWN, WV 26501 | Closed - Resolved |
106 | 106 | #19-05325 | DRUG INCIDENT | 2019 | 2019-12-11 15:24:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Unfounded |
123 | 123 | #19-05307 | DRUG INCIDENT | 2019 | 2019-12-10 14:13:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Unfounded |
182 | 182 | #19-05245 | DRUG INCIDENT | 2019 | 2019-12-07 01:28:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Clear by Warning |
315 | 315 | #19-05101 | DRUG INCIDENT | 2019 | 2019-11-22 03:53:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Unfounded |
371 | 371 | #19-05043 | ASSIST EMS POLICE | 2019 | 2019-11-19 16:36:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Closed - Resolved |
441 | 441 | #19-04969 | DRUG INCIDENT | 2019 | 2019-11-14 22:02:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Unfounded |
453 | 453 | #19-04957 | DESTRUCTION OF PROPERTY | 2019 | 2019-11-14 13:46:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Closed - Unresolved |
465 | 465 | #19-04945 | DRUG INCIDENT | 2019 | 2019-11-13 16:57:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Unfounded |
484 | 484 | #19-04926 | DRUG INCIDENT | 2019 | 2019-11-12 22:40:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Unfounded |
490 | 490 | #19-04920 | DRUG INCIDENT | 2019 | 2019-11-12 16:21:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Unfounded |
494 | 494 | #19-04915 | ASSIST EMS POLICE | 2019 | 2019-11-11 21:02:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Closed - Resolved |
513 | 513 | #19-04896 | DRUG INCIDENT | 2019 | 2019-11-10 23:13:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Unfounded |
668 | 668 | #19-04735 | DRUG INCIDENT | 2019 | 2019-11-02 15:53:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Inactive |
687 | 687 | #19-04716 | DRUG INCIDENT | 2019 | 2019-11-01 21:12:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Closed - Unresolved |
701 | 701 | #19-04702 | DRUG INCIDENT | 2019 | 2019-11-01 03:59:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Unfounded |
738 | 738 | #19-04665 | DRUG INCIDENT | 2019 | 2019-10-30 21:56:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Unfounded |
758 | 758 | #19-04644 | DRUG INCIDENT | 2019 | 2019-10-29 18:54:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Clear by Warning |
832 | 832 | #19-04568 | DRUG INCIDENT | 2019 | 2019-10-25 18:55:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Unfounded |
846 | 846 | #19-04554 | LOUD MUSIC | 2019 | 2019-10-25 00:17:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Closed - Resolved |
850 | 850 | #19-04550 | DRUG INCIDENT | 2019 | 2019-10-24 22:21:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Unfounded |
897 | 897 | #19-04501 | AREA PATROL | 2019 | 2019-10-23 00:33:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Unfounded |
900 | 900 | #19-04498 | DRUG INCIDENT | 2019 | 2019-10-22 19:43:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Unfounded |
963 | 963 | #19-04431 | LOUD MUSIC | 2019 | 2019-10-18 23:50:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Closed - Resolved |
974 | 974 | #19-04420 | DRUG INCIDENT | 2019 | 2019-10-19 00:03:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Clear by Warning |
1482 | 1482 | #19-05458 | FIRE ALARM | 2019 | 2019-12-22 17:09:00 | WVU VANDALIA HALL BLUE | 51 FALLING RUN RD, MORGANTOWN, WV 26501 | Closed - Resolved |
34 | 34 | #19-05400 | FIRE ALARM | 2019 | 2019-12-17 06:37:00 | WVU UNIVERSITY PLACE TOWNHOMES NORTH | 256 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
37 | 37 | #19-05395 | FIRE ALARM | 2019 | 2019-12-16 12:07:00 | WVU UNIVERSITY PLACE TOWNHOMES NORTH | 256 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
331 | 331 | #19-05085 | FIRE ALARM | 2019 | 2019-11-21 17:49:00 | WVU UNIVERSITY PLACE TOWNHOMES NORTH | 256 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
1167 | 1167 | #19-04220 | DOMESTIC DISPUTE | 2019 | 2019-10-06 18:33:00 | WVU UNIVERSITY PLACE TOWNHOMES NORTH | 256 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
376 | 376 | #19-05038 | INFORMATION REPORT | 2019 | 2019-11-19 03:35:00 | WVU UNIVERSITY PLACE PARKING GARAGE | 2154 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
439 | 439 | #19-04971 | ASSIST AGENCY | 2019 | 2019-11-15 01:05:00 | WVU UNIVERSITY PLACE PARKING GARAGE | 2154 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
676 | 676 | #19-04727 | TRAFFIC STOP, 1054 | 2019 | 2019-11-02 02:13:00 | WVU UNIVERSITY PLACE PARKING GARAGE | 2154 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning |
762 | 762 | #19-04640 | AUTO TAMPERING | 2019 | 2019-10-26 02:20:00 | WVU UNIVERSITY PLACE PARKING GARAGE | 2154 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Charges Filed |
823 | 823 | #19-04577 | ELEVATOR RESCUE | 2019 | 2019-10-25 22:48:00 | WVU UNIVERSITY PLACE PARKING GARAGE | 2154 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Inactive |
1014 | 1014 | #19-04377 | FIRE ALARM | 2019 | 2019-10-16 17:21:00 | WVU UNIVERSITY PLACE PARKING GARAGE | 2154 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
1166 | 1166 | #19-04221 | DESTRUCTION OF PROPERTY | 2019 | 2019-10-06 20:46:00 | WVU UNIVERSITY PLACE PARKING GARAGE | 2154 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Inactive |
1401 | 1401 | #19-03977 | DESTRUCTION OF PROPERTY | 2019 | 2019-09-24 11:32:00 | WVU UNIVERSITY PLACE PARKING GARAGE | 2154 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Inactive |
296 | 296 | #19-05122 | ASSIST EMS POLICE | 2019 | 2019-11-24 03:42:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
320 | 320 | #19-05096 | ABCC VIOLATION | 2019 | 2019-11-22 01:34:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation |
444 | 444 | #19-04966 | INFORMATION REPORT | 2019 | 2019-11-14 20:44:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Report only |
530 | 530 | #19-04879 | DESTRUCTION OF PROPERTY | 2019 | 2019-11-09 21:20:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Inactive |
564 | 564 | #19-04841 | ABCC VIOLATION | 2019 | 2019-11-09 02:19:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning |
654 | 654 | #19-04749 | DRUG INCIDENT | 2019 | 2019-11-03 01:44:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning |
666 | 666 | #19-04737 | TALK WITH OFFICER | 2019 | 2019-11-02 19:52:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Inactive |
671 | 671 | #19-04732 | FIRE ALARM | 2019 | 2019-11-02 06:39:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Arrest |
689 | 689 | #19-04714 | DRUG INCIDENT | 2019 | 2019-11-01 19:46:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Unfounded |
726 | 726 | #19-04677 | TRESPASSING | 2019 | 2019-10-31 14:22:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Charges Filed |
756 | 756 | #19-04646 | LOUD NOISE | 2019 | 2019-10-29 21:51:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
899 | 899 | #19-04499 | LARCENY | 2019 | 2019-10-19 04:30:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Inactive |
975 | 975 | #19-04419 | LOUD NOISE | 2019 | 2019-10-18 22:47:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Unfounded |
1140 | 1140 | #19-04248 | DRUG INCIDENT | 2019 | 2019-10-08 19:36:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Unfounded |
1324 | 1324 | #19-04057 | SUICIDE THREAT | 2019 | 2019-09-29 14:11:00 | WVU UNIVERSITY PARK APARTMENTS - WEST | 442 OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
141 | 141 | #19-05288 | BACK TICKET TOW | 2019 | 2019-12-09 14:00:00 | WVU UNIVERSITY PARK APARTMENTS - NORTH | 475 OAKLAND ST, MORGANTOWN, WV 26501 | Vehicle- NOT Impounded |
961 | 961 | #19-04433 | FIRE ALARM | 2019 | 2019-10-19 08:08:00 | WVU UNIVERSITY PARK APARTMENTS - NORTH | 475 OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
1207 | 1207 | #19-04176 | DOMESTIC DISPUTE | 2019 | 2019-10-05 14:15:00 | WVU UNIVERSITY PARK APARTMENTS - NORTH | 475 OAKLAND ST, MORGANTOWN, WV 26501 | Clear by Arrest |
79 | 79 | #19-05353 | ASSIST EMS POLICE | 2019 | 2019-12-13 14:54:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
265 | 265 | #19-05155 | LARCENY | 2019 | 2019-11-21 10:25:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Inactive |
392 | 392 | #19-05020 | DESTRUCTION OF PROPERTY | 2019 | 2019-11-17 20:17:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
998 | 998 | #19-04394 | LARCENY | 2019 | 2019-10-17 11:59:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
462 | 462 | #19-04948 | ALARM CONDITION | 2019 | 2019-11-13 18:48:00 | WVU SUNCREST EXECUTIVE PLAZA 2 | 1075 VAN VOORHIS RD, MORGANTOWN, WV 26501 | Closed - Resolved |
1194 | 1194 | #19-04190 | BURGLAR ALARM | 2019 | 2019-10-05 17:25:00 | WVU SUNCREST EXECUTIVE PLAZA 2 | 1075 VAN VOORHIS RD, MORGANTOWN, WV 26501 | Closed - Resolved |
102 | 102 | #19-05329 | DRUG INCIDENT | 2019 | 2019-12-11 20:53:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
152 | 152 | #19-05277 | WELFARE CHECK | 2019 | 2019-12-09 06:09:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
201 | 201 | #19-05223 | DRUG INCIDENT | 2019 | 2019-12-06 11:37:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
212 | 212 | #19-05211 | ABCC VIOLATION | 2019 | 2019-12-05 22:10:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Warning |
213 | 213 | #19-05210 | DRUG INCIDENT | 2019 | 2019-12-05 21:28:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Warning |
406 | 406 | #19-05006 | ABCC VIOLATION | 2019 | 2019-11-17 00:40:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
423 | 423 | #19-04987 | SUSPICIOUS EVENT | 2019 | 2019-11-16 00:36:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
428 | 428 | #19-04982 | DRUG INCIDENT | 2019 | 2019-11-15 22:53:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
431 | 431 | #19-04979 | DRUG INCIDENT | 2019 | 2019-11-15 21:06:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
482 | 482 | #19-04928 | DRUG INCIDENT | 2019 | 2019-11-12 23:10:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Citation |
492 | 492 | #19-04918 | ASSIST EMS POLICE | 2019 | 2019-11-12 09:27:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
520 | 520 | #19-04889 | ABCC VIOLATION | 2019 | 2019-11-10 04:16:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Warning |
524 | 524 | #19-04885 | DRUG INCIDENT | 2019 | 2019-11-10 01:17:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
528 | 528 | #19-04881 | DRUG INCIDENT | 2019 | 2019-11-09 23:24:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
533 | 533 | #19-04876 | DRUG INCIDENT | 2019 | 2019-11-09 20:53:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
603 | 603 | #19-04800 | DRUG INCIDENT | 2019 | 2019-11-06 23:11:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
606 | 606 | #19-04797 | FIRE ALARM | 2019 | 2019-11-06 20:22:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
716 | 716 | #19-04687 | ASSIST EMS POLICE | 2019 | 2019-10-31 23:38:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Citation |
719 | 719 | #19-04684 | DRUG INCIDENT | 2019 | 2019-10-31 21:28:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
798 | 798 | #19-04603 | DRUG INCIDENT | 2019 | 2019-10-27 14:20:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Citation |
810 | 810 | #19-04591 | DRUG INCIDENT | 2019 | 2019-10-26 23:05:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
811 | 811 | #19-04590 | DRUG INCIDENT | 2019 | 2019-10-26 22:56:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [crimelog] ( [id] TEXT, [title] TEXT, [year] TEXT, [datetime] TEXT, [building] TEXT, [address] TEXT, [outcome] TEXT );