crimelog
1,082 rows where title = "ASSIST EMS POLICE" sorted by outcome
This data as json, CSV (advanced)
Suggested facets: datetime (date)
outcome 14 ✖
- Closed - Resolved 953
- 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 ▼ |
---|---|---|---|---|---|---|---|---|
7185 | 7185 | #21-00965 | ASSIST EMS POLICE | 2021 | 2021-03-27 09:50:00 | IHOP - OAKLAND HALL | 475 OAKLAND ST, MORGANTOWN, WV | Active |
8977 | 8977 | #21-02602 | ASSIST EMS POLICE | 2021 | 2021-09-18 13:21:00 | WVU STADIUM | ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Active |
9689 | 9689 | #21-03568 | ASSIST EMS POLICE | 2021 | 2021-12-08 21:16:00 | WVU COLISEUM | JERRY WEST DR, MORGANTOWN, WV 26501 | Active |
12697 | 12697 | #22-02984 | ASSIST EMS POLICE | 2022 | 2022-11-12 11:06:00 | BLUE LOT | STADIUM DR, MORGANTOWN, WV | Active |
15349 | 15349 | 23-02179 | ASSIST EMS POLICE | 2023 | 2023-08-23 11:38:00 | WVU HODGES HALL | 127 HOUGH ST, MORGANTOWN, WV | Active |
15943 | 15943 | SR23-02443 | ASSIST EMS POLICE | 2023 | 2023-09-09 19:56:00 | WVU STADIUM | 3 ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Active |
16750 | 16750 | 23-03370 | ASSIST EMS POLICE | 2023 | 2023-11-14 11:17:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Active |
17868 | 17868 | 24-00911 | ASSIST EMS POLICE | 2024 | 2024-03-23 10:47:00 | CAPERTON INDOOR FACILITY | 2 ERRETT RODGERS DR, MORGANTOWN, WV | Active |
6641 | 6641 | #21-00378 | ASSIST EMS POLICE | 2021 | 2021-02-12 14:40:00 | WVU MOUNTAINLAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Arrest |
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 |
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 |
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 |
4240 | 4240 | #20-02373 | ASSIST EMS POLICE | 2020 | 2020-09-01 11:37:00 | WVU STUDENT HEALTH BUILDING | 390 BIRCH ST, MORGANTOWN, WV 26501 | Clear by Exception - Victim Refused to Cooperate |
8937 | 8937 | #21-02812 | ASSIST EMS POLICE | 2021 | 2021-10-02 18:24:00 | WVU LAW SCHOOL | LAW CENTER DR, MORGANTOWN, WV 26501 | Clear by Exception - Victim Refused to Cooperate |
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 |
1726 | 1726 | #20-00248 | ASSIST EMS POLICE | 2020 | 2020-01-19 03:03:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Clear by Warning |
2009 | 2009 | #20-00487 | ASSIST EMS POLICE | 2020 | 2020-02-01 01:49:00 | WVU LIFE SCIENCES BUILDING | 53 CAMPUS DR, MORGANTOWN, WV | Clear by Warning |
3151 | 3151 | #20-01594 | ASSIST EMS POLICE | 2020 | 2020-05-25 20:15:00 | NORTH HIGH ST / MAIDEN LN, MORGANTOWN, WV 26501 | Clear by Warning | |
3157 | 3157 | #20-01623 | ASSIST EMS POLICE | 2020 | 2020-05-31 02:58:00 | WVU MOUNTAINLAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Warning |
3299 | 3299 | #20-01756 | ASSIST EMS POLICE | 2020 | 2020-06-27 01:34:00 | WVU AREA 37 (FAYETTE ST/COOP) | 1400 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning |
3571 | 3571 | #20-01969 | ASSIST EMS POLICE | 2020 | 2020-08-08 00:41:00 | 60 NEWTON AVE, MORGANTOWN | Clear by Warning | |
4301 | 4301 | #20-02435 | ASSIST EMS POLICE | 2020 | 2020-09-05 03:02:00 | WVU BRAXTON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Warning |
4629 | 4629 | #20-02614 | ASSIST EMS POLICE | 2020 | 2020-09-16 23:14:00 | WVU BOREMAN NORTH | 602 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
4673 | 4673 | #20-02801 | ASSIST EMS POLICE | 2020 | 2020-09-25 20:53:00 | WVU STALNAKER HALL | 691 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
4731 | 4731 | #20-02896 | ASSIST EMS POLICE | 2020 | 2020-10-03 22:58:00 | WVU BENNETT TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Warning |
5326 | 5326 | #20-03275 | ASSIST EMS POLICE | 2020 | 2020-11-05 02:30:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning |
5360 | 5360 | #20-03299 | ASSIST EMS POLICE | 2020 | 2020-11-06 23:34:00 | WVU MOUNTAINLAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Warning |
6594 | 6594 | #21-00339 | ASSIST EMS POLICE | 2021 | 2021-02-08 03:03:00 | PHI SIGMA KAPPA FRATERNITY | 672 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
6738 | 6738 | #21-00533 | ASSIST EMS POLICE | 2021 | 2021-02-28 04:25:00 | NORTH SPRUCE ST / FIFE AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
7149 | 7149 | #21-00920 | ASSIST EMS POLICE | 2021 | 2021-03-25 22:03:00 | WVU MOUNTAIN LAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Warning |
7573 | 7573 | #21-01331 | ASSIST EMS POLICE | 2021 | 2021-04-25 01:00:00 | WVU VANDALIA HALL GOLD | 49 FALLING RUN RD, MORGANTOWN, WV 26501 | Clear by Warning |
7574 | 7574 | #21-01330 | ASSIST EMS POLICE | 2021 | 2021-04-25 00:27:00 | WVU MOUNTAINLAIR PARKING GARAGE | 109 PROSPECT ST, MORGANTOWN, WV | Clear by Warning |
8927 | 8927 | #21-02824 | ASSIST EMS POLICE | 2021 | 2021-10-03 10:09:00 | BLUE LOT | STADIUM DR, MORGANTOWN, WV | Clear by Warning |
9533 | 9533 | #21-03413 | ASSIST EMS POLICE | 2021 | 2021-11-20 12:28:00 | BLUE LOT | STADIUM DR, MORGANTOWN, WV | Clear by Warning |
9948 | 9948 | #22-00138 | ASSIST EMS POLICE | 2022 | 2022-01-16 23:27:00 | THETA CHI FRATERNITY | BELMAR AVE, MORGANTOWN, WV 26501 | Clear by Warning |
10240 | 10240 | #22-00409 | ASSIST EMS POLICE | 2022 | 2022-02-10 23:59:00 | WVU Area 24A (Upper Chestnut Street) | 39.631878, -79.955537, MORGANTOWN | Clear by Warning |
10474 | 10474 | #22-00639 | ASSIST EMS POLICE | 2022 | 2022-03-07 03:50:00 | WVU OAKLAND HALL-EAST | OAKLAND ST, MORGANTOWN, WV 26501 | Clear by Warning |
11011 | 11011 | #22-01212 | ASSIST EMS POLICE | 2022 | 2022-05-06 01:00:00 | WVU MOUNTAINLAIR | UNIVERSITY AVE, MORGANTOWN, WV | Clear by Warning |
11580 | 11580 | #22-01853 | ASSIST EMS POLICE | 2022 | 2022-08-20 21:19:00 | WVU BROOKE TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Warning |
12305 | 12305 | #22-02593 | ASSIST EMS POLICE | 2022 | 2022-10-13 19:53:00 | WVU STADIUM | ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Clear by Warning |
12360 | 12360 | #22-02611 | ASSIST EMS POLICE | 2022 | 2022-10-14 01:56:00 | COLLEGE PARK | NEWTON AVE, MORGANTOWN, WV | Clear by Warning |
13720 | 13720 | #23-00595 | ASSIST EMS POLICE | 2023 | 2023-02-24 04:07:00 | WVU DADISMAN HALL | NORTH HIGH ST, MORGANTOWN, WV | Clear by Warning |
14348 | 14348 | #23-01300 | ASSIST EMS POLICE | 2023 | 2023-04-30 05:20:00 | WVU HONORS HALL | SECOND ST, MORGANTOWN, WV | Clear by Warning |
15326 | 15326 | 23-02134 | ASSIST EMS POLICE | 2023 | 2023-08-20 02:11:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Clear by Warning |
17541 | 17541 | 24-00570 | ASSIST EMS POLICE | 2024 | 2024-02-23 03:16:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
17622 | 17622 | 24-00659 | ASSIST EMS POLICE | 2024 | 2024-03-01 22:09:00 | WVU OAKLAND HALL | 438 OAKLAND ST, MORGANTOWN, WV 26501 | Clear by Warning |
9780 | 9780 | #21-03666 | ASSIST EMS POLICE | 2021 | 2021-12-15 23:35:00 | WVU ARMSTRONG HALL | BEECHURST AVE, MORGANTOWN, WV | Closed - Lack of leads |
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 |
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 |
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 |
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 |
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 |
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 );