crimelog
3,152 rows where title = "TRAFFIC STOP, 1054" sorted by address
This data as json, CSV (advanced)
Suggested facets: datetime (date)
outcome 14 ✖
- Clear by Warning 1,565
- Clear by Citation 1,473
- Clear by Arrest 47
- Closed - Resolved 43
- Vehicle- Impounded 7
- Active 4
- Pending Arrest 4
- Cleared by Exception - Prosecution Declined 2
- Inactive 2
- 990 ELMER PRINCE DR, MORGANTOWN, WV 1
- Closed - Charges Filed 1
- Forward to Other Agency 1
- NORTH SPRUCE ST, MORGANTOWN 1
- UNIVERSITY AVE, MORGANTOWN, WV 26501 1
Link | rowid | id | title | year | datetime | building | address ▼ | outcome |
---|---|---|---|---|---|---|---|---|
13286 | 13286 | #23-00190 | TRAFFIC STOP, 1054 | 2023 | 2023-01-21 20:58:00 | , MORGANTOWN, WV 26501 | Clear by Citation | |
13288 | 13288 | #23-00188 | TRAFFIC STOP, 1054 | 2023 | 2023-01-21 19:45:00 | , MORGANTOWN, WV 26501 | Clear by Warning | |
14772 | 14772 | #23-01719 | TRAFFIC STOP, 1054 | 2023 | 2023-07-01 20:05:00 | , MORGANTOWN, WV 26501 | Clear by Citation | |
2745 | 2745 | #20-01183 | TRAFFIC STOP, 1054 | 2020 | 2020-03-06 13:38:00 | WVU ERICKSON ALUMNI CENTER | 1 ALUMNI DR, MORGANTOWN, WV | Clear by Citation |
15709 | 15709 | 23-02376 | TRAFFIC STOP, 1054 | 2023 | 2023-09-07 05:23:00 | WVU ERICKSON ALUMNI CENTER | 1 ALUMNI DR, MORGANTOWN, WV | Closed - Resolved |
3178 | 3178 | #20-01634 | TRAFFIC STOP, 1054 | 2020 | 2020-06-02 20:55:00 | 1 LAW CENTER DR / UNIVERSITY AVE, MORGANTOWN | Clear by Warning | |
8369 | 8369 | #21-02190 | TRAFFIC STOP, 1054 | 2021 | 2021-08-18 20:13:00 | 1 LAW CENTER DR / UNIVERSITY AVE, MORGANTOWN, WV 26506 | Clear by Citation | |
1769 | 1769 | #20-00202 | TRAFFIC STOP, 1054 | 2020 | 2020-01-18 00:38:00 | WVU LAW SCHOOL | 1 LAW CENTER DR, MORGANTOWN, WV 26501 | Clear by Warning |
6452 | 6452 | #21-00211 | TRAFFIC STOP, 1054 | 2021 | 2021-01-27 17:43:00 | WVU LAW SCHOOL | 1 LAW CENTER DR, MORGANTOWN, WV 26501 | Clear by Arrest |
15341 | 15341 | 23-02165 | TRAFFIC STOP, 1054 | 2023 | 2023-08-21 20:14:00 | WVU LAW SCHOOL | 1 LAW CENTER DR, MORGANTOWN, WV 26501 | Clear by Warning |
18083 | 18083 | 24-01129 | TRAFFIC STOP, 1054 | 2024 | 2024-04-15 06:33:00 | 1 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Clear by Citation | |
11235 | 11235 | #22-01472 | TRAFFIC STOP, 1054 | 2022 | 2022-07-10 03:32:00 | 100-2175529 | UNIVERSITY AVE, MORGANTOWN, WV 26501 | |
12592 | 12592 | #22-02918 | TRAFFIC STOP, 1054 | 2022 | 2022-11-06 02:02:00 | 1012 UNIVERSITY AVE, MORGANTOWN | Clear by Warning | |
1582 | 1582 | #20-00009 | TRAFFIC STOP, 1054 | 2020 | 2020-01-03 10:44:00 | WVU COLISEUM | 11 JERRY WEST DR, MORGANTOWN, WV 26501 | Clear by Warning |
2652 | 2652 | #20-01140 | TRAFFIC STOP, 1054 | 2020 | 2020-03-04 16:46:00 | WVU EVANSDALE LIBRARY | 111 RESEARCH WAY, MORGANTOWN, WV | Clear by Citation |
13953 | 13953 | #23-00875 | TRAFFIC STOP, 1054 | 2023 | 2023-03-23 20:42:00 | 1201 EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Warning | |
3121 | 3121 | #20-01567 | TRAFFIC STOP, 1054 | 2020 | 2020-05-20 18:44:00 | NORTH RIDGE TOWN HOMES #A | 1238 VAN VOORHIS RD UNIT 1, MORGANTOWN, WV 26501 | Clear by Citation |
18286 | 18286 | 24-01336 | TRAFFIC STOP, 1054 | 2024 | 2024-04-29 09:46:00 | WVU NATIONAL RESEARCH CENTER FOR COAL & ENERGY | 1272 EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation |
18283 | 18283 | 24-01333 | TRAFFIC STOP, 1054 | 2024 | 2024-04-29 09:19:00 | WVU MINERAL RESOURCES BUILDING | 1374 EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Citation |
4806 | 4806 | #20-02950 | TRAFFIC STOP, 1054 | 2020 | 2020-10-08 20:06:00 | WVU MOUNTAINLAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Citation |
6743 | 6743 | #21-00528 | TRAFFIC STOP, 1054 | 2021 | 2021-02-28 00:11:00 | WVU MOUNTAINLAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Citation |
8274 | 8274 | #21-02097 | TRAFFIC STOP, 1054 | 2021 | 2021-08-12 18:09:00 | WVU MOUNTAIN LAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Warning |
6713 | 6713 | #21-00478 | TRAFFIC STOP, 1054 | 2021 | 2021-02-24 19:59:00 | WVU MING HSIEH HALL | 1600 UNIVERSITY AVE, MORGANTOWN | Clear by Citation |
14285 | 14285 | #23-01226 | TRAFFIC STOP, 1054 | 2023 | 2023-04-22 22:38:00 | 1601 UNIVERSITY AVE, MORGANTOWN | Clear by Warning | |
2515 | 2515 | #20-00971 | TRAFFIC STOP, 1054 | 2020 | 2020-02-26 09:17:00 | J&S PAWN AND GUNS | 1704 MILEGROUND RD UNIT C, MORGANTOWN, WV 26501 | Clear by Citation |
17995 | 17995 | 24-01044 | TRAFFIC STOP, 1054 | 2024 | 2024-04-08 20:49:00 | 2001 KITTIE BLAKEMORE DR / FINE ARTS DR, MORGANTOWN | Clear by Warning | |
17996 | 17996 | 24-01045 | TRAFFIC STOP, 1054 | 2024 | 2024-04-08 21:07:00 | 2001 KITTIE BLAKEMORE DR / FINE ARTS DR, MORGANTOWN, WV 26501 | Clear by Citation | |
17691 | 17691 | 24-00749 | TRAFFIC STOP, 1054 | 2024 | 2024-03-05 20:10:00 | 2001 KITTIE BLAKEMORE DR / MORRILL WAY, MORGANTOWN, WV 26501 | Clear by Citation | |
2071 | 2071 | #20-00531 | TRAFFIC STOP, 1054 | 2020 | 2020-02-03 10:21:00 | WVU REC CENTER | 2001 REC CENTER DR, MORGANTOWN, WV 26501 | Clear by Citation |
2687 | 2687 | #20-01111 | TRAFFIC STOP, 1054 | 2020 | 2020-03-03 11:03:00 | WVU STUDENT RECREATION CENTER | 2001 REC CENTER DR, MORGANTOWN, WV 26501 | Clear by Citation |
14893 | 14893 | 23-01544 | TRAFFIC STOP, 1054 | 2023 | 2023-06-05 22:00:00 | WVU STUDENT RECREATION CENTER | 2001 REC CENTER DR, MORGANTOWN, WV 26501 | Clear by Citation |
18103 | 18103 | 24-01154 | TRAFFIC STOP, 1054 | 2024 | 2024-04-15 11:16:00 | WVU REC CENTER | 2001 REC CENTER DR, MORGANTOWN, WV 26501 | Clear by Citation |
18288 | 18288 | 24-01338 | TRAFFIC STOP, 1054 | 2024 | 2024-04-29 10:17:00 | WVU REC CENTER | 2001 REC CENTER DR, MORGANTOWN, WV 26501 | Clear by Citation |
17597 | 17597 | 24-00608 | TRAFFIC STOP, 1054 | 2024 | 2024-02-26 11:40:00 | 201ST MEMORIAL HWY | Clear by Warning | |
8171 | 8171 | #21-01992 | TRAFFIC STOP, 1054 | 2021 | 2021-07-25 20:20:00 | 201ST MEMORIAL HWY / MILEGROUND RD, MORGANTOWN, WV 26501 | Clear by Citation | |
1644 | 1644 | #20-00051 | TRAFFIC STOP, 1054 | 2020 | 2020-01-08 20:00:00 | 201ST MEMORIAL HWY / WILLOWDALE RD, MORGANTOWN, WV 26501 | Clear by Warning | |
5282 | 5282 | #20-03208 | TRAFFIC STOP, 1054 | 2020 | 2020-10-30 23:06:00 | 201ST MEMORIAL HWY, MORGANTOWN, WV 26501 | Clear by Warning | |
7682 | 7682 | #21-01453 | TRAFFIC STOP, 1054 | 2021 | 2021-05-04 23:29:00 | 201ST MEMORIAL HWY, MORGANTOWN, WV 26501 | Clear by Warning | |
7856 | 7856 | #21-01515 | TRAFFIC STOP, 1054 | 2021 | 2021-05-10 22:28:00 | 201st Memorial Highway / RESEARCH PARK RD, MORGANTOWN | Clear by Citation | |
2880 | 2880 | #20-01300 | TRAFFIC STOP, 1054 | 2020 | 2020-03-13 01:22:00 | 2154 UNIVERSITY AVE / CAMPUS DR, MORGANTOWN | Clear by Warning | |
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 |
3632 | 3632 | #20-02051 | TRAFFIC STOP, 1054 | 2020 | 2020-08-15 02:52:00 | 29 BEECHURST AVE / CAMPUS DR, MORGANTOWN, WV 26501 | Clear by Citation | |
17961 | 17961 | 24-01012 | TRAFFIC STOP, 1054 | 2024 | 2024-04-06 10:40:00 | WVU KNAPP HALL | 29 BEECHURST AVE, MORGANTOWN, WV | Clear by Warning |
10209 | 10209 | #22-00372 | TRAFFIC STOP, 1054 | 2022 | 2022-02-07 15:41:00 | 2908 UNIVERSITY AVE, MORGANTOWN | Clear by Warning | |
7836 | 7836 | #21-01630 | TRAFFIC STOP, 1054 | 2021 | 2021-05-31 18:42:00 | DANIELS MENS STORE | 2908 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Citation |
7946 | 7946 | #21-01748 | TRAFFIC STOP, 1054 | 2021 | 2021-06-14 17:46:00 | DANIELS MENS STORE | 2908 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Citation |
7026 | 7026 | #21-00815 | TRAFFIC STOP, 1054 | 2021 | 2021-03-18 16:06:00 | 2932 UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN | Clear by Citation | |
10563 | 10563 | #22-00717 | TRAFFIC STOP, 1054 | 2022 | 2022-03-16 11:47:00 | 2932 UNIVERSITY AVE, MORGANTOWN | Clear by Citation | |
4587 | 4587 | #20-02709 | TRAFFIC STOP, 1054 | 2020 | 2020-09-20 12:53:00 | MCDONALDS EVANSDALE | 2932 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Citation |
4588 | 4588 | #20-02708 | TRAFFIC STOP, 1054 | 2020 | 2020-09-20 12:39:00 | MCDONALDS EVANSDALE | 2932 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Citation |
7835 | 7835 | #21-01631 | TRAFFIC STOP, 1054 | 2021 | 2021-05-31 18:54:00 | MCDONALDS EVANSDALE | 2932 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Citation |
7575 | 7575 | #21-01360 | TRAFFIC STOP, 1054 | 2021 | 2021-04-27 19:55:00 | LITTLE CAESARS EVANSDALE | 2942 UNIVERSITY AVE, MORGANTOWN, WV | Vehicle- Impounded |
6295 | 6295 | #BC20-00537 | TRAFFIC STOP, 1054 | 2020 | 2020-11-14 00:30:00 | 2nd Avenue and Neville, Beckley, WV 25801 | Closed - Resolved | |
6297 | 6297 | #BC20-00504 | TRAFFIC STOP, 1054 | 2020 | 2020-11-11 02:15:00 | 2nd Street and Thornhill Courts, Beckley, WV 25801 | Closed - Resolved | |
15634 | 15634 | 23-02172 | TRAFFIC STOP, 1054 | 2023 | 2023-08-22 11:28:00 | WVU STADIUM | 3 ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Active |
2299 | 2299 | #20-00721 | TRAFFIC STOP, 1054 | 2020 | 2020-02-14 02:41:00 | 300 BEECHURST AVE / HOUGH ST, MORGANTOWN, WV | Clear by Arrest | |
1496 | 1496 | #19-05443 | TRAFFIC STOP, 1054 | 2019 | 2019-12-20 08:48:00 | PRETE BUILDING | 3040 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Citation |
1402 | 1402 | #19-03976 | TRAFFIC STOP, 1054 | 2019 | 2019-09-24 14:03:00 | CHICK FILA PATTESON DR | 334 PATTESON DR, MORGANTOWN, WV | Clear by Warning |
2338 | 2338 | #20-00784 | TRAFFIC STOP, 1054 | 2020 | 2020-02-17 14:08:00 | BURGER KING PATTESON DR | 340 PATTESON DR, MORGANTOWN, WV | Clear by Citation |
7213 | 7213 | #21-00934 | TRAFFIC STOP, 1054 | 2021 | 2021-03-26 17:09:00 | BURGER KING PATTESON DR | 340 PATTESON DR, MORGANTOWN, WV | Clear by Citation |
7920 | 7920 | #21-01672 | TRAFFIC STOP, 1054 | 2021 | 2021-06-05 08:48:00 | BURGER KING PATTESON DR | 340 PATTESON DR, MORGANTOWN, WV | Clear by Warning |
2698 | 2698 | #20-01235 | TRAFFIC STOP, 1054 | 2020 | 2020-03-08 14:22:00 | KROGER PATTESON | 350 PATTESON DR, MORGANTOWN, WV | Clear by Citation |
2447 | 2447 | #20-00845 | TRAFFIC STOP, 1054 | 2020 | 2020-02-21 09:36:00 | WVU PERCIVAL HALL | 355 OAKLAND ST, MORGANTOWN, WV | Clear by Citation |
4446 | 4446 | #20-02610 | TRAFFIC STOP, 1054 | 2020 | 2020-09-16 19:22:00 | 356 EVANSDALE DR / UNIVERSITY AVE, MORGANTOWN | Clear by Citation | |
5141 | 5141 | #PS20-01046 | TRAFFIC STOP, 1054 | 2020 | 2020-09-22 10:30:00 | PSC C-5 PARKING AREA | 39.439633, -78.983946 | Clear by Warning |
15165 | 15165 | 23-01935 | TRAFFIC STOP, 1054 | 2023 | 2023-08-09 22:58:00 | WVU Area 1 (White Hall) | 39.632691, -79.955148 | Clear by Citation |
8669 | 8669 | #21-02489 | TRAFFIC STOP, 1054 | 2021 | 2021-09-10 22:32:00 | WVU Area 25 (Mountainlair loading dock) | 39.634256, -79.954015 | Clear by Warning |
13528 | 13528 | #23-00449 | TRAFFIC STOP, 1054 | 2023 | 2023-02-12 02:29:00 | WVU Area 17 (Ming Hsieh Hall) | 39.636516, -79.953109, MORGANTOWN | Clear by Citation |
50 | 50 | #19-05382 | TRAFFIC STOP, 1054 | 2019 | 2019-12-15 02:04:00 | WVU Area 10 | 39.636747, -79.956624 | Clear by Warning |
866 | 866 | #19-04533 | TRAFFIC STOP, 1054 | 2019 | 2019-10-24 08:19:00 | WVU Area 10 | 39.636747, -79.956624, MORGANTOWN | Clear by Warning |
7354 | 7354 | #21-01127 | TRAFFIC STOP, 1054 | 2021 | 2021-04-08 17:40:00 | WVU Area 10 | 39.636747, -79.956624, MORGANTOWN, WV 26501 | Clear by Citation |
1344 | 1344 | #19-04037 | TRAFFIC STOP, 1054 | 2019 | 2019-09-28 02:24:00 | WVU Area 8 | 39.636918, -79.957013 | Clear by Warning |
2602 | 2602 | #20-00974 | TRAFFIC STOP, 1054 | 2020 | 2020-02-26 13:14:00 | WVU Area 8 | 39.636918, -79.957013, MORGANTOWN, WV 26505 | Clear by Warning |
2561 | 2561 | #20-01062 | TRAFFIC STOP, 1054 | 2020 | 2020-02-29 23:17:00 | WVU Area 5 (loop) | 39.637152, -79.953937, MORGANTOWN | Clear by Warning |
681 | 681 | #19-04722 | TRAFFIC STOP, 1054 | 2019 | 2019-11-02 00:33:00 | WVU SHORT TERM 10 (B&E LOOP) | 39.637487, -79.953285, MORGANTOWN, WV 26501 | Clear by Warning |
3138 | 3138 | #20-01579 | TRAFFIC STOP, 1054 | 2020 | 2020-05-23 02:28:00 | WVU SHORT TERM 10 (B&E LOOP) | 39.637487, -79.953285, MORGANTOWN, WV 26501 | Clear by Citation |
8504 | 8504 | #21-02342 | TRAFFIC STOP, 1054 | 2021 | 2021-08-29 00:53:00 | WVU SHORT TERM 10 (B&E LOOP) | 39.637487, -79.953285, MORGANTOWN, WV 26501 | Clear by Warning |
8719 | 8719 | #21-02566 | TRAFFIC STOP, 1054 | 2021 | 2021-09-16 22:47:00 | WVU SHORT TERM 10 (B&E LOOP) | 39.637487, -79.953285, MORGANTOWN, WV 26501 | Clear by Warning |
12457 | 12457 | #22-02726 | TRAFFIC STOP, 1054 | 2022 | 2022-10-24 00:10:00 | WVU SHORT TERM 10 (B&E LOOP) | 39.637487, -79.953285, MORGANTOWN, WV 26501 | Clear by Warning |
15769 | 15769 | 23-02407 | TRAFFIC STOP, 1054 | 2023 | 2023-09-09 00:23:00 | WVU SHORT TERM 10 (B&E LOOP) | 39.637487, -79.953285, MORGANTOWN, WV 26501 | Clear by Citation |
15888 | 15888 | 23-02598 | TRAFFIC STOP, 1054 | 2023 | 2023-09-17 03:28:00 | WVU SHORT TERM 10 (B&E LOOP) | 39.637487, -79.953285, MORGANTOWN, WV 26501 | Clear by Citation |
13212 | 13212 | #23-00125 | TRAFFIC STOP, 1054 | 2023 | 2023-01-14 23:38:00 | WVU Area 30U (College Park) | 39.637510, -79.943520 | Clear by Warning |
8008 | 8008 | #21-01813 | TRAFFIC STOP, 1054 | 2021 | 2021-06-20 00:20:00 | WVU SHORT TERM 5 (SUNNYSIDE) | 39.638035, -79.955530, MORGANTOWN, WV 26501 | Clear by Warning |
2844 | 2844 | #20-01336 | TRAFFIC STOP, 1054 | 2020 | 2020-03-15 10:21:00 | WVU Area 46 (Green House, Annex & Percival) | 39.644042, -79.970400 | Clear by Warning |
838 | 838 | #19-04562 | TRAFFIC STOP, 1054 | 2019 | 2019-10-25 13:32:00 | WVU Area 40 NRCCE | 39.644635, -79.972324 | Clear by Warning |
10151 | 10151 | #22-00306 | TRAFFIC STOP, 1054 | 2022 | 2022-02-01 13:25:00 | WVU Area 40 NRCCE | 39.644635, -79.972324 | Clear by Citation |
17251 | 17251 | 24-00273 | TRAFFIC STOP, 1054 | 2024 | 2024-01-30 12:41:00 | WVU Area 40 NRCCE | 39.644635, -79.972324 | Clear by Warning |
17253 | 17253 | 24-00275 | TRAFFIC STOP, 1054 | 2024 | 2024-01-30 14:25:00 | WVU Area 40 NRCCE | 39.644635, -79.972324 | Closed - Resolved |
2445 | 2445 | #20-00848 | TRAFFIC STOP, 1054 | 2020 | 2020-02-21 12:06:00 | WVU SHORT TERM 6 (WATER TOWER) | 39.644914,-79.967471, MORGANTOWN, WV 26501 | Closed - Resolved |
17252 | 17252 | 24-00274 | TRAFFIC STOP, 1054 | 2024 | 2024-01-30 14:05:00 | WVU Area 41 (Engineering Sciences) | 39.645620, -79.974047 | Clear by Warning |
763 | 763 | #19-04639 | TRAFFIC STOP, 1054 | 2019 | 2019-10-29 13:59:00 | WVU SHORT TERM 4 (REC CENTER) | 39.647516,-79.971475, MORGANTOWN, WV 26501 | Clear by Warning |
17943 | 17943 | 24-00985 | TRAFFIC STOP, 1054 | 2024 | 2024-04-03 11:50:00 | WVU Area 48 (ERC) | 39.648510, -79.965258, MORGANTOWN | Closed - Resolved |
18290 | 18290 | 24-01341 | TRAFFIC STOP, 1054 | 2024 | 2024-04-29 11:16:00 | WVU Area 70 (CAC Back) | 39.648731, -79.975422 | Clear by Citation |
18104 | 18104 | 24-01155 | TRAFFIC STOP, 1054 | 2024 | 2024-04-15 11:28:00 | WVU Area 51 (Erickson/Art Museum) | 39.648856, -79.973702, MORGANTOWN | Clear by Citation |
16781 | 16781 | 23-03489 | TRAFFIC STOP, 1054 | 2023 | 2023-11-28 10:01:00 | WVU SHORT TERM 1( PATTESON DRIVE) | 39.649685,-79.972572, MORGANTOWN, WV 26501 | Clear by Warning |
12065 | 12065 | #22-02323 | TRAFFIC STOP, 1054 | 2022 | 2022-09-21 00:07:00 | WVU Area 77 (CPASS) | 39.649775, -79.969667 | Clear by Warning |
1592 | 1592 | #20-00056 | TRAFFIC STOP, 1054 | 2020 | 2020-01-09 13:27:00 | WVU AREA 93P (HSC) | 39.654294, -79.959226 | Clear by Warning |
2224 | 2224 | #20-00682 | TRAFFIC STOP, 1054 | 2020 | 2020-02-11 08:07:00 | WVU AREA 93P (HSC) | 39.654294, -79.959226, MORGANTOWN | Clear by Warning |
2304 | 2304 | #20-00709 | TRAFFIC STOP, 1054 | 2020 | 2020-02-13 07:43:00 | WVU AREA 93P (HSC) | 39.654294, -79.959226, MORGANTOWN | Clear by Warning |
114 | 114 | #19-05317 | TRAFFIC STOP, 1054 | 2019 | 2019-12-11 05:41:00 | WVU Area 81 (HSC) | 39.655616, -79.961320 | 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 );