crimelog
1,083 rows where title = "ASSIST EMS POLICE" sorted by title
This data as json, CSV (advanced)
Suggested facets: datetime (date)
outcome 14 ✖
- Closed - Resolved 954
- Inactive 34
- Clear by Warning 32
- Report only 27
- Unfounded 17
- Active 8
- Clear by Citation 3
- Clear by Exception - Victim Refused to Cooperate 2
- Clear by Arrest 1
- Closed - Lack of leads 1
- Closed - Unresolved 1
- Forward to Other Agency 1
- Referral for disposition through applicable University Administrative Process 1
- Under Investigation 1
Link | rowid | id | title ▼ | year | datetime | building | address | outcome |
---|---|---|---|---|---|---|---|---|
13 | 13 | #19-05422 | ASSIST EMS POLICE | 2019 | 2019-12-18 14:43:00 | WVU ARMSTRONG HALL | 94 BEECHURST AVE, MORGANTOWN, WV | Closed - Resolved |
38 | 38 | #19-05394 | ASSIST EMS POLICE | 2019 | 2019-12-16 10:11:00 | 80 NEWTON AVE, MORGANTOWN, WV 26501 | Closed - Resolved | |
39 | 39 | #19-05393 | ASSIST EMS POLICE | 2019 | 2019-12-16 09:28:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
44 | 44 | #19-05388 | ASSIST EMS POLICE | 2019 | 2019-12-15 07:22:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Closed - Resolved |
64 | 64 | #19-05368 | ASSIST EMS POLICE | 2019 | 2019-12-14 02:54:00 | WVU BUSINESS AND ECONOMICS BUILDING | 1601 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
76 | 76 | #19-05356 | ASSIST EMS POLICE | 2019 | 2019-12-13 17:21:00 | WVU MOUNTAINEER STATION | 1112 VAN VOORHIS RD, MORGANTOWN, WV | Closed - Resolved |
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 |
83 | 83 | #19-05349 | ASSIST EMS POLICE | 2019 | 2019-12-13 02:50:00 | BELMAR AVE / PRICE ST, MORGANTOWN, WV 26501 | Unfounded | |
89 | 89 | #19-05343 | ASSIST EMS POLICE | 2019 | 2019-12-12 18:29:00 | WVU LINCOLN HALL | 1014 RAWLEY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
124 | 124 | #19-05306 | ASSIST EMS POLICE | 2019 | 2019-12-10 14:03:00 | WVU DENTAL CARE | 451 SUNCREST TOWN CENTRE DR, MORGANTOWN, WV | Closed - Resolved |
125 | 125 | #19-05305 | ASSIST EMS POLICE | 2019 | 2019-12-10 14:12:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
128 | 128 | #19-05301 | ASSIST EMS POLICE | 2019 | 2019-12-10 11:44:00 | WVU LIFE SCIENCES BUILDING | 53 CAMPUS DR, MORGANTOWN, WV | Closed - Resolved |
149 | 149 | #19-05280 | ASSIST EMS POLICE | 2019 | 2019-12-09 08:50:00 | WVU LINCOLN HALL | 1014 RAWLEY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
150 | 150 | #19-05279 | ASSIST EMS POLICE | 2019 | 2019-12-06 08:39:00 | WVU COLISEUM | 11 JERRY WEST DR, MORGANTOWN, WV 26501 | Closed - Resolved |
158 | 158 | #19-05271 | ASSIST EMS POLICE | 2019 | 2019-12-08 20:25:00 | WVU HONORS HALL | 250 SECOND ST, MORGANTOWN, WV | Closed - Resolved |
192 | 192 | #19-05235 | ASSIST EMS POLICE | 2019 | 2019-12-06 22:35:00 | WVU COLISEUM | 11 JERRY WEST DR, MORGANTOWN, WV 26501 | Closed - Resolved |
194 | 194 | #19-05233 | ASSIST EMS POLICE | 2019 | 2019-12-06 22:02:00 | WVU COLISEUM | 11 JERRY WEST DR, MORGANTOWN, WV 26501 | Closed - Resolved |
197 | 197 | #19-05230 | ASSIST EMS POLICE | 2019 | 2019-12-06 21:05:00 | WVU COLISEUM | 11 JERRY WEST DR, MORGANTOWN, WV 26501 | Closed - Resolved |
198 | 198 | #19-05229 | ASSIST EMS POLICE | 2019 | 2019-12-06 19:00:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Closed - Resolved |
209 | 209 | #19-05214 | ASSIST EMS POLICE | 2019 | 2019-12-05 23:25:00 | WVU BRAXTON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
216 | 216 | #19-05206 | ASSIST EMS POLICE | 2019 | 2019-12-05 18:41:00 | WVU STUDENT HEALTH BUILDING | 390 BIRCH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
219 | 219 | #19-05203 | ASSIST EMS POLICE | 2019 | 2019-12-05 16:47:00 | WVU SENECA HALL | 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
234 | 234 | #19-05188 | ASSIST EMS POLICE | 2019 | 2019-12-04 16:40:00 | WVU BUSINESS AND ECONOMICS BUILDING | 1601 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
237 | 237 | #19-05185 | ASSIST EMS POLICE | 2019 | 2019-12-04 15:08:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
252 | 252 | #19-05168 | ASSIST EMS POLICE | 2019 | 2019-12-03 11:21:00 | WVU PRT STATION-BEECHURST AVE | 96 BEECHURST AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
262 | 262 | #19-05158 | ASSIST EMS POLICE | 2019 | 2019-12-02 12:46:00 | WVU MOUNTAIN LAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Closed - Resolved |
270 | 270 | #19-05150 | ASSIST EMS POLICE | 2019 | 2019-12-01 21:43:00 | WVU BROOKE TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
283 | 283 | #19-05137 | ASSIST EMS POLICE | 2019 | 2019-11-27 14:16:00 | WVU STUDENT HEALTH BUILDING | 390 BIRCH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
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 |
300 | 300 | #19-05118 | ASSIST EMS POLICE | 2019 | 2019-11-23 13:38:00 | WVU STADIUM | 3 ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Closed - Resolved |
304 | 304 | #19-05114 | ASSIST EMS POLICE | 2019 | 2019-11-23 12:07:00 | BROWN LOT | 0 LAW CENTER DR, MORGANTOWN, WV | Closed - Resolved |
309 | 309 | #19-05108 | ASSIST EMS POLICE | 2019 | 2019-11-22 22:59:00 | WVU COLISEUM | 11 JERRY WEST DR, MORGANTOWN, WV 26501 | Closed - Resolved |
312 | 312 | #19-05104 | ASSIST EMS POLICE | 2019 | 2019-11-22 11:24:00 | WVU STUDENT HEALTH BUILDING | 390 BIRCH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
346 | 346 | #19-05069 | ASSIST EMS POLICE | 2019 | 2019-11-20 22:27:00 | WVU BROOKE TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
351 | 351 | #19-05064 | ASSIST EMS POLICE | 2019 | 2019-11-20 19:08:00 | WVU STUDENT HEALTH BUILDING | 390 BIRCH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
361 | 361 | #19-05053 | ASSIST EMS POLICE | 2019 | 2019-11-20 09:01:00 | WVU STUDENT HEALTH BUILDING | 390 BIRCH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
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 |
422 | 422 | #19-04988 | ASSIST EMS POLICE | 2019 | 2019-11-16 01:07:00 | SHEETZ #556 SUNNYSIDE | 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
451 | 451 | #19-04959 | ASSIST EMS POLICE | 2019 | 2019-11-14 18:23:00 | WVU CLARK HALL | 100 PROSPECT ST, MORGANTOWN, WV | Closed - Resolved |
459 | 459 | #19-04951 | ASSIST EMS POLICE | 2019 | 2019-11-14 01:58:00 | WVU Area 10 | 39.636747, -79.956624, WV | Forward to Other Agency |
468 | 468 | #19-04942 | ASSIST EMS POLICE | 2019 | 2019-11-13 15:11:00 | WVU PHYSICAL ACTIVITY AND SPORTS MEDICINE | 375 BIRCH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
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 |
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 |
501 | 501 | #19-04908 | ASSIST EMS POLICE | 2019 | 2019-11-11 16:27:00 | WVU STEWART HALL | 1500 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
523 | 523 | #19-04886 | ASSIST EMS POLICE | 2019 | 2019-11-10 01:47:00 | 316 FIFE AVE, MORGANTOWN, WV 26501 | Closed - Resolved | |
529 | 529 | #19-04880 | ASSIST EMS POLICE | 2019 | 2019-11-09 22:23:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
534 | 534 | #19-04875 | ASSIST EMS POLICE | 2019 | 2019-11-09 19:48:00 | WVU BOREMAN NORTH | 602 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation |
537 | 537 | #19-04872 | ASSIST EMS POLICE | 2019 | 2019-11-09 15:16:00 | PHYSICIANS OFFICE CENTER | 61 STADIUM DR, MORGANTOWN, WV 26501 | Closed - Resolved |
540 | 540 | #19-04869 | ASSIST EMS POLICE | 2019 | 2019-11-09 14:09:00 | WVU STADIUM | 3 ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Closed - Resolved |
542 | 542 | #19-04866 | ASSIST EMS POLICE | 2019 | 2019-11-09 12:50:00 | WVU CHESTNUT RIDGE RESEARCH BUILDING | 886 CHESTNUT RIDGE RD, MORGANTOWN, WV 26501 | Closed - Resolved |
543 | 543 | #19-04865 | ASSIST EMS POLICE | 2019 | 2019-11-09 13:06:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Closed - Resolved |
550 | 550 | #19-04857 | ASSIST EMS POLICE | 2019 | 2019-11-09 11:21:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Closed - Resolved |
553 | 553 | #19-04853 | ASSIST EMS POLICE | 2019 | 2019-11-09 09:50:00 | WVU POLICE DEPARTMENT | 992 ELMER PRINCE DR, MORGANTOWN, WV | Inactive |
562 | 562 | #19-04843 | ASSIST EMS POLICE | 2019 | 2019-11-09 03:15:00 | WVU OAKLAND HALL-WEST | 438 OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
589 | 589 | #19-04815 | ASSIST EMS POLICE | 2019 | 2019-11-07 15:10:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
611 | 611 | #19-04792 | ASSIST EMS POLICE | 2019 | 2019-11-06 16:59:00 | WVU BRAXTON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
616 | 616 | #19-04787 | ASSIST EMS POLICE | 2019 | 2019-11-06 13:12:00 | CARRUTH CENTER | 700 COLLEGE AVE, MORGANTOWN, WV | Closed - Resolved |
619 | 619 | #19-04784 | ASSIST EMS POLICE | 2019 | 2019-11-06 10:32:00 | WVU EISLAND HALL | 128 HOUGH ST, MORGANTOWN, WV | Closed - Resolved |
641 | 641 | #19-04762 | ASSIST EMS POLICE | 2019 | 2019-11-04 15:18:00 | WVU HEALTH AND EDUCATION BUILDING | 375 BIRCH ST, MORGANTOWN, WV | Closed - Resolved |
667 | 667 | #19-04736 | ASSIST EMS POLICE | 2019 | 2019-11-02 17:48:00 | WVU MOUNTAINLAIR PARKING GARAGE | 109 PROSPECT ST, MORGANTOWN, WV | Closed - Resolved |
703 | 703 | #19-04700 | ASSIST EMS POLICE | 2019 | 2019-11-01 03:25:00 | WVU STALNAKER HALL | 691 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation |
707 | 707 | #19-04696 | ASSIST EMS POLICE | 2019 | 2019-11-01 01:33:00 | WVU BENNETT TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
714 | 714 | #19-04689 | ASSIST EMS POLICE | 2019 | 2019-10-31 23:58:00 | PHI DELTA THETA FRATERNITY | 225 BELMAR AVE, MORGANTOWN, WV 26501 | Inactive |
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 |
724 | 724 | #19-04679 | ASSIST EMS POLICE | 2019 | 2019-10-31 16:23:00 | WVU OAKLAND HALL-WEST | 438 OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
752 | 752 | #19-04650 | ASSIST EMS POLICE | 2019 | 2019-10-30 04:04:00 | WVU PRT STATION-BEECHURST AVE | 96 BEECHURST AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
760 | 760 | #19-04642 | ASSIST EMS POLICE | 2019 | 2019-10-29 18:17:00 | WVU BROOKS HALL | 98 BEECHURST AVE, MORGANTOWN, WV | Closed - Resolved |
787 | 787 | #19-04614 | ASSIST EMS POLICE | 2019 | 2019-10-28 12:14:00 | WVU EVANSDALE CROSSING | 62 MORRILL WAY, MORGANTOWN, WV | Inactive |
793 | 793 | #19-04608 | ASSIST EMS POLICE | 2019 | 2019-10-27 18:16:00 | WVU LINCOLN HALL | 1014 RAWLEY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
817 | 817 | #19-04583 | ASSIST EMS POLICE | 2019 | 2019-10-26 02:54:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Closed - Resolved |
842 | 842 | #19-04558 | ASSIST EMS POLICE | 2019 | 2019-10-25 09:08:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
867 | 867 | #19-04532 | ASSIST EMS POLICE | 2019 | 2019-10-23 23:35:00 | WVU BROOKE TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
924 | 924 | #19-04474 | ASSIST EMS POLICE | 2019 | 2019-10-22 08:43:00 | WVU ONE WATERFRONT PLACE | 1 WATERFRONT PL, MORGANTOWN, WV | Closed - Resolved |
981 | 981 | #19-04413 | ASSIST EMS POLICE | 2019 | 2019-10-18 19:49:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
985 | 985 | #19-04409 | ASSIST EMS POLICE | 2019 | 2019-10-18 17:01:00 | 309 BELMAR AVE, MORGANTOWN, WV 26501 | Closed - Resolved | |
1010 | 1010 | #19-04381 | ASSIST EMS POLICE | 2019 | 2019-10-16 21:01:00 | WVU STUDENT RECREATION CENTER | 2001 REC CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
1029 | 1029 | #19-04361 | ASSIST EMS POLICE | 2019 | 2019-10-15 09:59:00 | WVU SHORT TERM 4 (REC CENTER) | 39.647516,-79.971475, MORGANTOWN, WV 26501 | Closed - Resolved |
1031 | 1031 | #19-04359 | ASSIST EMS POLICE | 2019 | 2019-10-11 20:30:00 | WVU COLISEUM | 11 JERRY WEST DR, MORGANTOWN, WV 26501 | Closed - Resolved |
1035 | 1035 | #19-04355 | ASSIST EMS POLICE | 2019 | 2019-10-14 18:42:00 | LIGHT BLUE LOT | 0 WILLOWDALE RD, MORGANTOWN, WV | Closed - Resolved |
1055 | 1055 | #19-04334 | ASSIST EMS POLICE | 2019 | 2019-10-14 09:06:00 | WVU LINCOLN HALL | 1014 RAWLEY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
1070 | 1070 | #19-04318 | ASSIST EMS POLICE | 2019 | 2019-10-12 15:53:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Closed - Resolved |
1087 | 1087 | #19-04301 | ASSIST EMS POLICE | 2019 | 2019-10-10 18:48:00 | WVU MOUNTAINEER STATION | 1112 VAN VOORHIS RD, MORGANTOWN, WV | Closed - Resolved |
1124 | 1124 | #19-04264 | ASSIST EMS POLICE | 2019 | 2019-10-09 12:39:00 | ASHEBROOKE LIQUOR OUTLET | 300 BEECHURST AVE, MORGANTOWN, WV | Closed - Resolved |
1145 | 1145 | #19-04242 | ASSIST EMS POLICE | 2019 | 2019-10-08 13:53:00 | WVU MING HSIEH HALL | 1600 UNIVERSITY AVE, MORGANTOWN | Closed - Resolved |
1151 | 1151 | #19-04236 | ASSIST EMS POLICE | 2019 | 2019-10-08 01:01:00 | WVU STALNAKER HALL | 691 NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
1164 | 1164 | #19-04223 | ASSIST EMS POLICE | 2019 | 2019-10-07 09:01:00 | WVU ARMSTRONG HALL | 94 BEECHURST AVE, MORGANTOWN, WV | Closed - Resolved |
1176 | 1176 | #19-04211 | ASSIST EMS POLICE | 2019 | 2019-10-06 02:06:00 | WVU Area 6 (Maiden Lane) | 39.635243, -79.953091 | Closed - Resolved |
1177 | 1177 | #19-04210 | ASSIST EMS POLICE | 2019 | 2019-10-06 01:48:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved | |
1183 | 1183 | #19-04204 | ASSIST EMS POLICE | 2019 | 2019-10-05 21:36:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Inactive |
1190 | 1190 | #19-04195 | ASSIST EMS POLICE | 2019 | 2019-10-05 18:25:00 | STADIUM | 3 ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Closed - Resolved |
1213 | 1213 | #19-04170 | ASSIST EMS POLICE | 2019 | 2019-10-05 12:55:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Closed - Resolved |
1227 | 1227 | #19-04156 | ASSIST EMS POLICE | 2019 | 2019-10-05 03:04:00 | WVU MOUNTAINLAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Unfounded |
1253 | 1253 | #19-04129 | ASSIST EMS POLICE | 2019 | 2019-10-03 23:56:00 | WVU BOREMAN NORTH | 602 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
1256 | 1256 | #19-04126 | ASSIST EMS POLICE | 2019 | 2019-10-03 23:07:00 | SIGMA NU FRATERNITY | 617 NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Closed - Resolved |
1263 | 1263 | #19-04119 | ASSIST EMS POLICE | 2019 | 2019-10-03 14:12:00 | WVU ENGINEERING SCIENCES BLDG | 395 EVANSDALE DR, MORGANTOWN, WV | Closed - Resolved |
1314 | 1314 | #19-04067 | ASSIST EMS POLICE | 2019 | 2019-09-30 10:29:00 | WVU AGRICULTURAL SCIENCES BLDG | 101 RESEARCH WAY, MORGANTOWN, WV | Closed - Resolved |
1325 | 1325 | #19-04056 | ASSIST EMS POLICE | 2019 | 2019-09-29 15:01:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Closed - Resolved |
1326 | 1326 | #19-04055 | ASSIST EMS POLICE | 2019 | 2019-09-29 14:59:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Closed - Resolved |
1340 | 1340 | #19-04041 | ASSIST EMS POLICE | 2019 | 2019-09-28 15:13:00 | 284 WILES ST, MORGANTOWN, WV 26501 | Closed - Resolved | |
1341 | 1341 | #19-04040 | ASSIST EMS POLICE | 2019 | 2019-09-28 05:39:00 | COLLEGE PARK | 60 NEWTON AVE, MORGANTOWN, WV | Inactive |
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 );