crimelog
2,238 rows where outcome = "Clear by Citation" sorted by datetime
This data as json, CSV (advanced)
Suggested facets: datetime (date)
title >30 ✖
- TRAFFIC STOP, 1054 1,473
- ABCC VIOLATION 436
- DRUG INCIDENT 178
- Clery – Other Police Agency 36
- VEHICLE ACCIDENT 23
- PUBLIC INTOX 11
- TRESPASSING 9
- OPEN CONTAINER 8
- PARKING COMPLAINT 8
- SHOPLIFTING 7
- UNDERAGE POSSESSION 7
- HIT AND RUN 6
- BATTERY 4
- ASSIST EMS POLICE 3
- PARTY/GATHERING 3
- DESTRUCTION OF PROPERTY 2
- DISORDERLY CONDUCT 2
- LITTERING 2
- LOUD NOISE 2
- POSSESSION OF A CONTROLLED SUBSTANCE 2
- RECKLESS DRIVING 2
- ASSIST PERSON POLICE 1
- DISTURBANCE 1
- DOMESTIC DISPUTE 1
- DRUG OVERDOSE 1
- FIGHT 1
- FIRE ALARM 1
- LOUD PARTY 1
- MOTORIST ASSIST, S20 1
- PARKING ENFORCEMENT 1
- …
Link | rowid | id | title | year | datetime ▼ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
1474 | 1474 | #19-03903 | ABCC VIOLATION | 2019 | 2019-09-20 01:57:00 | NORTH HIGH ST / FIFE AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1468 | 1468 | #19-03909 | TRAFFIC STOP, 1054 | 2019 | 2019-09-20 14:37:00 | UNIVERSITY AVE / OAKLAND ST, MORGANTOWN, WV 26501 | Clear by Citation | |
1466 | 1466 | #19-03911 | TRAFFIC STOP, 1054 | 2019 | 2019-09-20 16:45:00 | EIGHTH ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1464 | 1464 | #19-03913 | TRAFFIC STOP, 1054 | 2019 | 2019-09-20 18:14:00 | PROSPECT ST / NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
1460 | 1460 | #19-03918 | ABCC VIOLATION | 2019 | 2019-09-20 21:51:00 | BELMAR AVE / WAVERLY ST, MORGANTOWN, WV 26501 | Clear by Citation | |
1458 | 1458 | #19-03920 | ABCC VIOLATION | 2019 | 2019-09-20 23:03:00 | NORTH SPRUCE ST / PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Citation | |
1457 | 1457 | #19-03921 | ABCC VIOLATION | 2019 | 2019-09-20 23:18:00 | NORTH SPRUCE ST / FIFE AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1455 | 1455 | #19-03923 | ABCC VIOLATION | 2019 | 2019-09-20 23:40:00 | NORTH SPRUCE ST / WILES ST, MORGANTOWN, WV 26501 | Clear by Citation | |
1452 | 1452 | #19-03926 | ABCC VIOLATION | 2019 | 2019-09-21 00:40:00 | NORTH SPRUCE ST / WILES ST, MORGANTOWN WV,26501 | Clear by Citation | |
1450 | 1450 | #19-03928 | ABCC VIOLATION | 2019 | 2019-09-21 00:57:00 | ALPHA SIGMA PHI FRATERNITY | 200 BELMAR AVE, MORGANTOWN, WV 26501 | Clear by Citation |
1449 | 1449 | #19-03929 | ABCC VIOLATION | 2019 | 2019-09-21 01:00:00 | WVU OAKLAND HALL-WEST | 438 OAKLAND ST, MORGANTOWN, WV 26501 | Clear by Citation |
1444 | 1444 | #19-03934 | ABCC VIOLATION | 2019 | 2019-09-21 02:16:00 | COLLEGE PARK | 60 NEWTON AVE, MORGANTOWN, WV | Clear by Citation |
1439 | 1439 | #19-03939 | ABCC VIOLATION | 2019 | 2019-09-21 23:56:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Clear by Citation |
1438 | 1438 | #19-03940 | ABCC VIOLATION | 2019 | 2019-09-22 00:05:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Clear by Citation |
1435 | 1435 | #19-03943 | ABCC VIOLATION | 2019 | 2019-09-22 01:45:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Citation |
1433 | 1433 | #19-03945 | ABCC VIOLATION | 2019 | 2019-09-22 02:29:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Citation |
1432 | 1432 | #19-03946 | TRAFFIC STOP, 1054 | 2019 | 2019-09-22 02:56:00 | THIRD ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1425 | 1425 | #19-03953 | TRAFFIC STOP, 1054 | 2019 | 2019-09-22 17:39:00 | EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1423 | 1423 | #19-03955 | TRAFFIC STOP, 1054 | 2019 | 2019-09-22 22:40:00 | OAKLAND ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1419 | 1419 | #19-03959 | TRAFFIC STOP, 1054 | 2019 | 2019-09-23 12:55:00 | MORRILL WAY / FINE ARTS DR, MORGANTOWN, WV 26505 | Clear by Citation | |
1405 | 1405 | #19-03973 | LITTERING | 2019 | 2019-09-24 12:10:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation |
1398 | 1398 | #19-03980 | TRAFFIC STOP, 1054 | 2019 | 2019-09-24 22:09:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1391 | 1391 | #19-03987 | TRAFFIC STOP, 1054 | 2019 | 2019-09-25 09:01:00 | MORRILL WAY / FINE ARTS DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1390 | 1390 | #19-03988 | TRAFFIC STOP, 1054 | 2019 | 2019-09-25 10:08:00 | MORRILL WAY / FINE ARTS DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1384 | 1384 | #19-03994 | DRUG INCIDENT | 2019 | 2019-09-25 23:03:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Citation |
1371 | 1371 | #19-04007 | TRAFFIC STOP, 1054 | 2019 | 2019-09-26 13:20:00 | MONONGAHELA BLVD / PATTESON DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1360 | 1360 | #19-04019 | HIT AND RUN | 2019 | 2019-09-27 11:59:00 | WVU SHORT TERM 10 (B&E LOOP) | 39.637487, -79.953285, MORGANTOWN, WV 26501 | Clear by Citation |
1353 | 1353 | #19-04027 | VEHICLE ACCIDENT | 2019 | 2019-09-27 19:06:00 | RAWLEY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1348 | 1348 | #19-04033 | ABCC VIOLATION | 2019 | 2019-09-27 23:09:00 | NORTH HIGH ST / fife ave, MORGANTOWN, WV 26501 | Clear by Citation | |
1339 | 1339 | #19-04042 | TRAFFIC STOP, 1054 | 2019 | 2019-09-28 19:28:00 | WILLEY ST / CHESTNUT ST, MORGANTOWN, WV 26501 | Clear by Citation | |
1338 | 1338 | #19-04043 | ABCC VIOLATION | 2019 | 2019-09-28 22:39:00 | NORTH HIGH ST / FIFE AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1335 | 1335 | #19-04046 | ABCC VIOLATION | 2019 | 2019-09-28 23:52:00 | NORTH SPRUCE ST / WILES ST, MORGANTOWN, WV 26501 | Clear by Citation | |
1334 | 1334 | #19-04047 | ABCC VIOLATION | 2019 | 2019-09-29 00:02:00 | FIFE AVE / NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
1332 | 1332 | #19-04049 | ABCC VIOLATION | 2019 | 2019-09-29 01:35:00 | PROSPECT ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1330 | 1330 | #19-04051 | ABCC VIOLATION | 2019 | 2019-09-29 02:00:00 | NORTH SPRUCE ST / PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Citation | |
1327 | 1327 | #19-04054 | TRAFFIC STOP, 1054 | 2019 | 2019-09-29 03:28:00 | UNIVERSITY AVE / HOUGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
1296 | 1296 | #19-04085 | TRAFFIC STOP, 1054 | 2019 | 2019-10-01 12:08:00 | MORRILL WAY / FINE ARTS DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1290 | 1290 | #19-04092 | TRAFFIC STOP, 1054 | 2019 | 2019-10-02 00:50:00 | UNIVERSITY AVE / OAKLAND ST, MORGANTOWN, WV 26501 | Clear by Citation | |
1281 | 1281 | #19-04101 | DRUG INCIDENT | 2019 | 2019-10-02 20:56:00 | WVU BROOKE TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation |
1270 | 1270 | #19-04112 | TRAFFIC STOP, 1054 | 2019 | 2019-10-03 10:38:00 | PATTESON DR / MONONGAHELA BLVD, MORGANTOWN, WV 26501 | Clear by Citation | |
1264 | 1264 | #19-04118 | TRAFFIC STOP, 1054 | 2019 | 2019-10-03 14:17:00 | FINE ARTS DR / MORRILL WAY, MORGANTOWN, WV 26501 | Clear by Citation | |
1259 | 1259 | #19-04123 | TRAFFIC STOP, 1054 | 2019 | 2019-10-03 17:58:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN | Clear by Citation | |
1250 | 1250 | #19-04132 | ABCC VIOLATION | 2019 | 2019-10-04 01:31:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Clear by Citation |
1230 | 1230 | #19-04153 | SHOPLIFTING | 2019 | 2019-10-05 01:31:00 | SHEETZ #556 SUNNYSIDE | 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation |
1212 | 1212 | #19-04171 | ABCC VIOLATION | 2019 | 2019-10-05 13:43:00 | WVU STADIUM | 3 ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Clear by Citation |
1209 | 1209 | #19-04174 | ABCC VIOLATION | 2019 | 2019-10-05 14:11:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Clear by Citation |
1205 | 1205 | #19-04178 | ABCC VIOLATION | 2019 | 2019-10-05 15:05:00 | STADIUM | 3 ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Clear by Citation |
1191 | 1191 | #19-04194 | ABCC VIOLATION | 2019 | 2019-10-05 18:01:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation |
1184 | 1184 | #19-04203 | DRUG INCIDENT | 2019 | 2019-10-05 21:23:00 | WVU BENNETT TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation |
1143 | 1143 | #19-04245 | VEHICLE ACCIDENT | 2019 | 2019-10-08 14:53:00 | WVU Area 10 | 39.636747, -79.956624 | Clear by Citation |
1139 | 1139 | #19-04249 | DRUG INCIDENT | 2019 | 2019-10-08 21:26:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Clear by Citation |
1125 | 1125 | #19-04263 | TRAFFIC STOP, 1054 | 2019 | 2019-10-09 12:25:00 | CAMPUS DR / BEECHURST AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1121 | 1121 | #19-04267 | TRAFFIC STOP, 1054 | 2019 | 2019-10-09 16:40:00 | EVANSDALE DR / FINE ARTS DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1120 | 1120 | #19-04268 | TRAFFIC STOP, 1054 | 2019 | 2019-10-09 16:59:00 | EVANSDALE DR / FINE ARTS DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1117 | 1117 | #19-04271 | TRAFFIC STOP, 1054 | 2019 | 2019-10-09 17:18:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1116 | 1116 | #19-04272 | TRAFFIC STOP, 1054 | 2019 | 2019-10-09 17:24:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1115 | 1115 | #19-04273 | TRAFFIC STOP, 1054 | 2019 | 2019-10-09 17:42:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1113 | 1113 | #19-04275 | TRAFFIC STOP, 1054 | 2019 | 2019-10-09 17:54:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1112 | 1112 | #19-04276 | TRAFFIC STOP, 1054 | 2019 | 2019-10-09 18:04:00 | EVANSDALE DR / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1111 | 1111 | #19-04277 | TRAFFIC STOP, 1054 | 2019 | 2019-10-09 18:13:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1110 | 1110 | #19-04278 | TRAFFIC STOP, 1054 | 2019 | 2019-10-09 18:37:00 | UNIVERSITY AVE / EVANSDALE DR | Clear by Citation | |
1109 | 1109 | #19-04279 | TRAFFIC STOP, 1054 | 2019 | 2019-10-09 18:48:00 | EVANSDALE DR / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1108 | 1108 | #19-04280 | TRAFFIC STOP, 1054 | 2019 | 2019-10-09 18:56:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1107 | 1107 | #19-04281 | TRAFFIC STOP, 1054 | 2019 | 2019-10-09 19:58:00 | EVANSDALE DR / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1106 | 1106 | #19-04282 | ABCC VIOLATION | 2019 | 2019-10-10 00:25:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Citation |
1093 | 1093 | #19-04295 | TRAFFIC STOP, 1054 | 2019 | 2019-10-10 17:12:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1092 | 1092 | #19-04296 | TRAFFIC STOP, 1054 | 2019 | 2019-10-10 18:01:00 | EVANSDALE DR / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1091 | 1091 | #19-04297 | TRAFFIC STOP, 1054 | 2019 | 2019-10-10 18:18:00 | EVANSDALE DR / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1090 | 1090 | #19-04298 | TRAFFIC STOP, 1054 | 2019 | 2019-10-10 18:27:00 | EVANSDALE DR / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1089 | 1089 | #19-04299 | TRAFFIC STOP, 1054 | 2019 | 2019-10-10 18:40:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1088 | 1088 | #19-04300 | TRAFFIC STOP, 1054 | 2019 | 2019-10-10 18:48:00 | UNIVERSITY AVE / EVANSDALE DR | Clear by Citation | |
1077 | 1077 | #19-04311 | ABCC VIOLATION | 2019 | 2019-10-12 01:34:00 | WVU BRAXTON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation |
1058 | 1058 | #19-04331 | TRAFFIC STOP, 1054 | 2019 | 2019-10-13 12:39:00 | UNIVERSITY AVE / COLLEGE AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1052 | 1052 | #19-04337 | TRAFFIC STOP, 1054 | 2019 | 2019-10-14 13:06:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1050 | 1050 | #19-04339 | TRAFFIC STOP, 1054 | 2019 | 2019-10-14 13:52:00 | UNIVERSITY AVE / RIVERVIEW DR, MORGANTOWN | Clear by Citation | |
1049 | 1049 | #19-04340 | TRAFFIC STOP, 1054 | 2019 | 2019-10-14 14:13:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1048 | 1048 | #19-04341 | TRAFFIC STOP, 1054 | 2019 | 2019-10-14 14:27:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1046 | 1046 | #19-04343 | TRAFFIC STOP, 1054 | 2019 | 2019-10-14 14:38:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1045 | 1045 | #19-04344 | TRAFFIC STOP, 1054 | 2019 | 2019-10-14 14:49:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1043 | 1043 | #19-04346 | TRAFFIC STOP, 1054 | 2019 | 2019-10-14 15:12:00 | EVANSDALE DR / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1042 | 1042 | #19-04347 | TRAFFIC STOP, 1054 | 2019 | 2019-10-14 15:41:00 | EVANSDALE DR / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1040 | 1040 | #19-04349 | TRAFFIC STOP, 1054 | 2019 | 2019-10-14 16:09:00 | EVANSDALE DR / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
1039 | 1039 | #19-04350 | TRAFFIC STOP, 1054 | 2019 | 2019-10-14 16:35:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
1037 | 1037 | #19-04352 | TRAFFIC STOP, 1054 | 2019 | 2019-10-14 16:45:00 | PAR MAR STORE | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation |
1036 | 1036 | #19-04354 | TRAFFIC STOP, 1054 | 2019 | 2019-10-14 17:00:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation | |
994 | 994 | #19-04399 | ABCC VIOLATION | 2019 | 2019-10-18 01:20:00 | NORTH HIGH ST / PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Citation | |
979 | 979 | #19-04415 | ABCC VIOLATION | 2019 | 2019-10-18 22:37:00 | WVU SENECA HALL | 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation |
929 | 929 | #19-04467 | SHOPLIFTING | 2019 | 2019-10-19 01:45:00 | HIGH STREET CANTEEN | 514 N HIGH ST, MORGANTOWN, WV | Clear by Citation |
967 | 967 | #19-04427 | ABCC VIOLATION | 2019 | 2019-10-19 02:32:00 | NORTH HIGH ST / FIFE AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
966 | 966 | #19-04428 | TRAFFIC STOP, 1054 | 2019 | 2019-10-19 03:17:00 | PROSPECT ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
955 | 955 | #19-04439 | ABCC VIOLATION | 2019 | 2019-10-19 22:42:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Clear by Citation |
952 | 952 | #19-04442 | ABCC VIOLATION | 2019 | 2019-10-20 00:22:00 | UNIVERSITY AVE / FIRST ST, MORGANTOWN, WV 26501 | Clear by Citation | |
950 | 950 | #19-04444 | ABCC VIOLATION | 2019 | 2019-10-20 01:01:00 | PROSPECT ST / NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
947 | 947 | #19-04447 | DRUG INCIDENT | 2019 | 2019-10-20 02:24:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Citation |
946 | 946 | #19-04448 | TRAFFIC STOP, 1054 | 2019 | 2019-10-20 02:32:00 | WILLEY ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
944 | 944 | #19-04450 | TRAFFIC STOP, 1054 | 2019 | 2019-10-20 03:09:00 | PROSPECT ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
922 | 922 | #19-04476 | TRAFFIC STOP, 1054 | 2019 | 2019-10-22 11:37:00 | EVANSDALE DR / FINE ARTS DR, MORGANTOWN, WV 26501 | Clear by Citation | |
921 | 921 | #19-04477 | TRAFFIC STOP, 1054 | 2019 | 2019-10-22 11:54:00 | EVANSDALE DR / FINE ARTS DR, MORGANTOWN, WV 26501 | Clear by Citation | |
919 | 919 | #19-04479 | TRAFFIC STOP, 1054 | 2019 | 2019-10-22 12:03:00 | EVANSDALE DR / FINE ARTS DR, MORGANTOWN, WV 26501 | Clear by Citation | |
918 | 918 | #19-04480 | TRAFFIC STOP, 1054 | 2019 | 2019-10-22 12:15:00 | EVANSDALE DR / FINE ARTS DR, MORGANTOWN, WV 26501 | Clear by Citation |
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 );