crimelog
393 rows where outcome = "Under Investigation" sorted by building
This data as json, CSV (advanced)
title >30 ✖
- DESTRUCTION OF PROPERTY 46
- LARCENY 35
- PETIT LARCENY, STPL 21
- HARASSMENT 18
- BATTERY 16
- LARCENY FROM A VEHICLE 16
- TALK WITH OFFICER 12
- SEXUAL ASSAULT 11
- SUSPICIOUS EVENT 11
- HIT AND RUN 9
- DRUG INCIDENT 8
- FRAUD 8
- INFORMATION REPORT 8
- BURGLARY 5
- LOST PROPERTY 5
- VEHICLE ACCIDENT 5
- ASSAULT 4
- FIRE ALARM 4
- GRAND LARCENY 4
- STOLEN VEHICLE 4
- VANDALISM 4
- AUTO TAMPERING 3
- DOMESTIC DISPUTE 3
- FIGHT 3
- SHOPLIFTING 3
- THREATS 3
- ABCC VIOLATION 2
- BREAKING AND ENTERING 2
- FOUND PROPERTY 2
- SEXUAL ABUSE 2
- …
Link | rowid | id | title | year | datetime | building ▼ | address | outcome |
---|---|---|---|---|---|---|---|---|
13307 | 13307 | #23-00208 | PETIT LARCENY, STPL | 2023 | 2023-01-23 21:29:00 | DELTA CHI FRATERNITY | BELMAR AVE, MORGANTOWN, WV 26501 | Under Investigation |
1834 | 1834 | #20-00295 | HARASSMENT | 2020 | 2020-01-22 12:58:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Under Investigation |
4121 | 4121 | #20-02245 | DESTRUCTION OF PROPERTY | 2020 | 2020-08-24 22:07:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Under Investigation |
7101 | 7101 | #21-00828 | LARCENY | 2021 | 2021-03-19 16:10:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Under Investigation |
8192 | 8192 | #21-02000 | TALK WITH OFFICER | 2021 | 2021-07-27 10:21:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Under Investigation |
8854 | 8854 | #21-02681 | GRAND LARCENY | 2021 | 2021-09-24 17:00:00 | HEALTH SCIENCE CENTER | MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Under Investigation |
12730 | 12730 | #22-03020 | TALK WITH OFFICER | 2022 | 2022-11-15 10:16:00 | HEALTH SCIENCE CENTER | MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Under Investigation |
16115 | 16115 | 23-02796 | INFORMATION REPORT | 2023 | 2023-09-27 16:26:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Under Investigation |
1977 | 1977 | #20-00520 | SHOPLIFTING | 2020 | 2020-02-02 16:35:00 | HIGH STREET CANTEEN | 514 N HIGH ST, MORGANTOWN, WV | Under Investigation |
2818 | 2818 | #20-01274 | BATTERY | 2020 | 2020-03-12 01:31:00 | HIGH STREET CANTEEN | 514 N HIGH ST, MORGANTOWN, WV | Under Investigation |
10761 | 10761 | #22-00958 | FIGHT | 2022 | 2022-04-06 22:38:00 | HIGH STREET CANTEEN | N HIGH ST, MORGANTOWN, WV | Under Investigation |
2555 | 2555 | #20-01068 | DESTRUCTION OF PROPERTY | 2020 | 2020-03-01 04:20:00 | IHOP - OAKLAND HALL | 475 OAKLAND ST, MORGANTOWN, WV | Under Investigation |
2990 | 2990 | #20-01441 | LARCENY | 2020 | 2020-04-09 15:38:00 | KAPPA ALPHA FRATERNITY | 670 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
2983 | 2983 | #20-01446 | BREAKING AND ENTERING | 2020 | 2020-04-11 23:39:00 | LAMBDA CHI ALPHA FRATERNITY | 216 BELMAR AVE, MORGANTOWN, WV 26501 | Under Investigation |
7703 | 7703 | #21-01486 | DESTRUCTION OF PROPERTY | 2021 | 2021-05-08 02:11:00 | LAMBDA CHI ALPHA FRATERNITY | 670 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
8941 | 8941 | #21-02807 | AUTO TAMPERING | 2021 | 2021-10-02 16:58:00 | LAMBDA CHI ALPHA FRATERNITY | NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
10312 | 10312 | #22-00462 | DOMESTIC DISPUTE | 2022 | 2022-02-17 00:00:00 | LAMBDA CHI ALPHA FRATERNITY | NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
16333 | 16333 | 23-03031 | ABCC VIOLATION | 2023 | 2023-10-21 02:15:00 | LAMBDA CHI ALPHA FRATERNITY | 670 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
9532 | 9532 | #21-03414 | BATTERY | 2021 | 2021-11-20 13:46:00 | LIGHT BLUE LOT | WILLOWDALE RD, MORGANTOWN, WV | Under Investigation |
3014 | 3014 | #20-01473 | STOLEN VEHICLE | 2020 | 2020-04-20 16:58:00 | PHI SIGMA KAPPA FRATERNITY | 672 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
4124 | 4124 | #20-02234 | LARCENY FROM A VEHICLE | 2020 | 2020-08-21 20:00:00 | PHI SIGMA KAPPA FRATERNITY | 672 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
5336 | 5336 | #20-03201 | SUSPICIOUS EVENT | 2020 | 2020-10-30 01:00:00 | PHI SIGMA KAPPA FRATERNITY | 672 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
6529 | 6529 | #21-00224 | PETIT LARCENY, STPL | 2021 | 2021-01-29 14:35:00 | PHI SIGMA KAPPA FRATERNITY | 672 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
13631 | 13631 | #23-00513 | DESTRUCTION OF PROPERTY | 2023 | 2023-02-17 16:59:00 | PHI SIGMA KAPPA FRATERNITY | NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
13783 | 13783 | #23-00722 | FIRE ALARM | 2023 | 2023-03-05 02:15:00 | PHI SIGMA KAPPA FRATERNITY | NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
2567 | 2567 | #20-01056 | DESTRUCTION OF PROPERTY | 2020 | 2020-02-29 16:31:00 | PI KAPPA PHI Fraternity | 650 NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Under Investigation |
6707 | 6707 | #21-00420 | DESTRUCTION OF PROPERTY | 2021 | 2021-02-18 13:27:00 | PIERPONT APARTMENTS | 445 OAKLAND ST, MORGANTOWN, WV 26501 | Under Investigation |
18418 | 18418 | 24-01475 | SEXUAL ABUSE | 2023 | 2023-10-28 00:00:00 | PRYZM NIGHTCLUB | 335 HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
5123 | 5123 | #PS20-01069 | SEXUAL ASSAULT | 2020 | 2020-09-21 00:00:00 | PSC FRIEND HALL | 165 CAMPUS DR, KEYSER, WV 26726 | Under Investigation |
5160 | 5160 | #PS20-01017 | SPECIAL DETAIL POLICE | 2020 | 2020-09-17 10:00:00 | PSC UNIVERSITY POLICE | 171 FORT AVE, KEYSER, WV 26726 | Under Investigation |
16496 | 16496 | 23-03188 | SEXUAL ASSAULT | 2023 | 2023-10-29 22:22:00 | RUBY MEMORIAL HOSPITAL | 81 STADIUM DR, MORGANTOWN, WV 26501 | Under Investigation |
5502 | 5502 | #20-03414 | BATTERY | 2020 | 2020-11-15 11:43:00 | SIGMA ALPHA EPSILON FRATERNITY | 117 BELMAR AVE, MORGANTOWN, WV 26501 | Under Investigation |
11009 | 11009 | #22-01214 | DESTRUCTION OF PROPERTY | 2022 | 2022-05-06 01:57:00 | SIGMA ALPHA EPSILON FRATERNITY | NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
11840 | 11840 | #22-02092 | PETIT LARCENY, STPL | 2022 | 2022-09-08 05:01:00 | SIGMA ALPHA EPSILON FRATERNITY | NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
4729 | 4729 | #20-02900 | DESTRUCTION OF PROPERTY | 2020 | 2020-10-04 02:58:00 | SIGMA CHI FRATERNITY | 700 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
6588 | 6588 | #21-00345 | VANDALISM | 2021 | 2021-02-08 12:49:00 | SIGMA CHI FRATERNITY | 700 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
12414 | 12414 | #22-02608 | BURGLARY | 2022 | 2022-10-14 00:12:00 | SIGMA CHI FRATERNITY | NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
16323 | 16323 | 23-02958 | HIT AND RUN | 2023 | 2023-10-15 03:06:00 | SIGMA CHI FRATERNITY | 700 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
17649 | 17649 | 24-00696 | BATTERY | 2024 | 2024-03-03 15:30:00 | SIGMA CHI FRATERNITY | 700 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
11225 | 11225 | #22-01462 | SUSPICIOUS PERSON | 2022 | 2022-04-30 18:54:00 | SIGMA NU FRATERNITY | NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Under Investigation |
15887 | 15887 | 23-02597 | DESTRUCTION OF PROPERTY | 2023 | 2023-09-17 02:37:00 | SIGMA NU FRATERNITY | 617 NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Under Investigation |
7136 | 7136 | #21-00891 | BATTERY | 2021 | 2021-03-24 14:10:00 | SIGMA PHI EPSILON FRATERNITY | 216 Belmar Ave, MORGANTOWN, WV 26501 | Under Investigation |
10573 | 10573 | #22-00669 | LARCENY | 2022 | 2022-03-07 17:00:00 | STADIUM | ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Under Investigation |
3036 | 3036 | #20-01478 | DESTRUCTION OF PROPERTY | 2020 | 2020-04-23 16:19:00 | TAU KAPPA EPSILON FRATERNITY(OLD) | 692 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
17643 | 17643 | 24-00688 | HAZING | 2024 | 2024-03-03 00:27:00 | THETA CHI FRATERNITY | 225 BELMAR AVE, MORGANTOWN, WV 26501 | Under Investigation |
12533 | 12533 | #22-02790 | LARCENY | 2022 | 2022-10-28 10:15:00 | WVU APPLIED HUMAN SCIENCES BUILDING | BIRCH ST, MORGANTOWN, WV 26501 | Under Investigation |
12673 | 12673 | #22-02961 | LARCENY FROM A VEHICLE | 2022 | 2022-11-10 12:49:00 | WVU AREA 67 | 39.6511, -79.9605, MORGANTOWN | Under Investigation |
12808 | 12808 | #22-03098 | LARCENY FROM A VEHICLE | 2022 | 2022-11-27 09:05:00 | WVU AREA 67 | 39.6511, -79.9605 | Under Investigation |
12703 | 12703 | #22-02976 | TALK WITH OFFICER | 2022 | 2022-11-11 12:25:00 | WVU ARMSTRONG HALL | BEECHURST AVE, MORGANTOWN, WV | Under Investigation |
4541 | 4541 | #20-02662 | DRUG INCIDENT | 2020 | 2020-09-18 15:28:00 | WVU ARNOLD HALL | 650 PRICE ST, MORGANTOWN, WV 26501 | Under Investigation |
6941 | 6941 | #21-00667 | SEXUAL ASSAULT | 2021 | 2021-03-12 10:07:00 | WVU ARNOLD HALL | 650 PRICE ST, MORGANTOWN, WV 26501 | Under Investigation |
17934 | 17934 | 24-00976 | HARASSMENT | 2024 | 2024-03-26 07:37:00 | WVU ATHLETIC EQUIPMENT BUILDING | 3450 MONONGAHELA BLVD, MORGANTOWN, WV 26501 | Under Investigation |
11045 | 11045 | #22-01218 | DOMESTIC DISPUTE | 2022 | 2021-05-15 14:40:00 | WVU Area 1 (White Hall) | 39.632691, -79.955148 | Under Investigation |
12197 | 12197 | #22-02361 | SHOTS FIRED | 2022 | 2022-09-23 23:54:00 | WVU Area 1 (White Hall) | 39.632691, -79.955148 | Under Investigation |
15824 | 15824 | 23-02507 | AUTO TAMPERING | 2023 | 2023-09-13 16:58:00 | WVU Area 1 (White Hall) | 39.632691, -79.955148 | Under Investigation |
5317 | 5317 | #20-03246 | HIT AND RUN | 2020 | 2020-11-02 13:55:00 | WVU Area 14 (Gaskins House) | 39.635855, -79.951886, MORGANTOWN | Under Investigation |
11670 | 11670 | #22-01965 | LOST PROPERTY | 2022 | 2022-08-28 12:34:00 | WVU Area 200 (Law School) | 39.647579, -79.956816 | Under Investigation |
17123 | 17123 | 24-00125 | STOLEN VEHICLE | 2024 | 2024-01-15 13:59:00 | WVU Area 201 (Law School/Stadium) | 39.646126, -79.955498 | Under Investigation |
8919 | 8919 | #21-02751 | STOLEN VEHICLE | 2021 | 2021-09-30 05:37:00 | WVU Area 24A (Upper Chestnut Street) | 39.631878, -79.955537 | Under Investigation |
6477 | 6477 | #21-00217 | DESTRUCTION OF PROPERTY | 2021 | 2021-01-28 11:36:00 | WVU Area 26 (Bellmar) | 39.635786, -79.950319 | Under Investigation |
10615 | 10615 | #22-00785 | LARCENY FROM A VEHICLE | 2022 | 2022-03-23 12:33:00 | WVU Area 30H (College Park) | 39.636768, -79.946179, MORGANTOWN | Under Investigation |
8781 | 8781 | #21-02571 | DESTRUCTION OF PROPERTY | 2021 | 2021-09-17 11:10:00 | WVU Area 30U (College Park) | 39.637510,-79.943520 | Under Investigation |
15856 | 15856 | 23-02545 | LARCENY FROM A VEHICLE | 2023 | 2023-09-16 10:28:00 | WVU Area 30U (College Park) | 39.637510,-79.943520 | Under Investigation |
18042 | 18042 | 24-01093 | LARCENY FROM A VEHICLE | 2024 | 2024-04-10 03:35:00 | WVU Area 30U (College Park) | 39.637510,-79.943520 | Under Investigation |
15635 | 15635 | 23-02302 | STOLEN VEHICLE | 2023 | 2023-08-31 05:55:00 | WVU Area 31 (Arnold Hall) | 39.632257, -79.950949 | Under Investigation |
13827 | 13827 | #23-00660 | HIT AND RUN | 2023 | 2023-02-22 13:19:00 | WVU Area 35 (Vandalia Garage) | 39.638093, -79.951677, MORGANTOWN | Under Investigation |
8896 | 8896 | #21-02739 | HIT AND RUN | 2021 | 2021-09-29 12:50:00 | WVU Area 49 (Rec Center) | 39.649018, -79.971077, MORGANTOWN | Under Investigation |
11693 | 11693 | #22-01941 | DESTRUCTION OF PROPERTY | 2022 | 2022-08-27 13:06:00 | WVU Area 7 (Stansbury) | 39.635745, -79.957016 | Under Investigation |
18333 | 18333 | 24-01381 | DESTRUCTION OF PROPERTY | 2024 | 2024-05-02 09:40:00 | WVU Area 7 (Stansbury) | 39.635745, -79.957016 | Under Investigation |
11284 | 11284 | #22-01521 | PETIT LARCENY, STPL | 2022 | 2022-07-15 17:44:00 | WVU Area 84 (HSC) | 39.655764, -79.956151 | Under Investigation |
9723 | 9723 | #21-03629 | LARCENY FROM A VEHICLE | 2021 | 2021-12-12 19:59:00 | WVU Area 86 (Mountaineer Station) | 39.654310, -79.961126 | Under Investigation |
8057 | 8057 | #21-01860 | PETIT LARCENY, STPL | 2021 | 2021-06-27 18:38:00 | WVU BASKETBALL PRACTICE FACILITY | 49 GOLD RUSH DR, MORGANTOWN, WV 26501 | Under Investigation |
8345 | 8345 | #21-02179 | TALK WITH OFFICER | 2021 | 2021-08-17 18:25:00 | WVU BENNETT TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Under Investigation |
8470 | 8470 | #21-02306 | LARCENY | 2021 | 2021-08-23 21:00:00 | WVU BENNETT TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Under Investigation |
8646 | 8646 | #21-02516 | SEXUAL ASSAULT | 2021 | 2021-09-12 01:28:00 | WVU BENNETT TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Under Investigation |
9923 | 9923 | #22-00076 | LARCENY | 2022 | 2022-01-10 18:00:00 | WVU BENNETT TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Under Investigation |
11739 | 11739 | #22-01946 | SEXUAL ASSAULT | 2022 | 2022-08-27 21:51:00 | WVU BENNETT TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Under Investigation |
12599 | 12599 | #22-02909 | SEXUAL ASSAULT | 2022 | 2022-11-05 12:34:00 | WVU BENNETT TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Under Investigation |
15897 | 15897 | 23-02609 | LARCENY | 2023 | 2023-09-17 13:01:00 | WVU BENNETT TOWER | 1061 EVANSDALE DR, MORGANTOWN, WV 26501 | Under Investigation |
15986 | 15986 | 23-02679 | ASSAULT | 2023 | 2023-09-20 16:18:00 | WVU BENNETT TOWER | 1061 EVANSDALE DR, MORGANTOWN, WV 26501 | Under Investigation |
16636 | 16636 | 23-03346 | SUSPICIOUS EVENT | 2023 | 2023-11-11 20:22:00 | WVU BENNETT TOWER | 1061 EVANSDALE DR, MORGANTOWN, WV 26501 | Under Investigation |
14 | 14 | #19-05421 | SHOPLIFTING | 2019 | 2019-12-17 15:38:00 | WVU BOOKSTORE | 1501 UNIVERSITY AVE, MORGANTOWN, WV | Under Investigation |
4887 | 4887 | #20-02912 | DESTRUCTION OF PROPERTY | 2020 | 2020-10-05 12:02:00 | WVU BOREMAN NORTH | 602 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
10003 | 10003 | #22-00158 | INFORMATION REPORT | 2022 | 2022-01-18 17:08:00 | WVU BOREMAN NORTH | NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
11668 | 11668 | #22-01967 | PETIT LARCENY, STPL | 2022 | 2022-08-28 13:21:00 | WVU BOREMAN NORTH | NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
14234 | 14234 | #23-01105 | BATTERY | 2023 | 2023-04-14 03:10:00 | WVU BOREMAN NORTH | NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
14288 | 14288 | #23-01223 | HARASSMENT | 2023 | 2023-04-22 18:11:00 | WVU BOREMAN NORTH | NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
16096 | 16096 | 23-02786 | LOST PROPERTY | 2023 | 2023-09-27 00:50:00 | WVU BOREMAN NORTH | 602 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
10130 | 10130 | #22-00269 | FIGHT | 2022 | 2022-01-29 00:34:00 | WVU BOREMAN RFL GARAGE | NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Under Investigation |
10122 | 10122 | #22-00279 | LARCENY | 2022 | 2022-01-29 14:10:00 | WVU BOREMAN SOUTH | NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
10434 | 10434 | #22-00633 | DESTRUCTION OF PROPERTY | 2022 | 2022-03-06 13:02:00 | WVU BOREMAN SOUTH | NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
10874 | 10874 | #22-01042 | DESTRUCTION OF PROPERTY | 2022 | 2022-04-16 01:02:00 | WVU BOREMAN SOUTH | NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
13432 | 13432 | #23-00352 | DRUG INCIDENT | 2023 | 2023-02-05 02:13:00 | WVU BOREMAN SOUTH | NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
14246 | 14246 | #23-01181 | LARCENY | 2023 | 2023-04-19 23:35:00 | WVU BOREMAN SOUTH | NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
15707 | 15707 | 23-02373 | FRAUD | 2023 | 2023-09-06 17:51:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
15998 | 15998 | 23-02694 | LARCENY | 2023 | 2023-09-21 14:09:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
10164 | 10164 | #22-00316 | TALK WITH OFFICER | 2022 | 2022-02-02 12:50:00 | WVU BRAXTON TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Under Investigation |
17808 | 17808 | 24-00790 | JOYRIDING | 2024 | 2024-02-26 10:25:00 | WVU BRAXTON TOWER | 1047 EVANSDALE DR, MORGANTOWN, WV 26501 | Under Investigation |
2420 | 2420 | #20-00873 | DESTRUCTION OF PROPERTY | 2020 | 2020-02-22 01:29:00 | WVU BROOKE TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Under Investigation |
9358 | 9358 | #21-03207 | SEXUAL ASSAULT | 2021 | 2021-11-04 00:30:00 | WVU BROOKE TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Under Investigation |
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 );