crimelog

27 rows where outcome = "Clear by Warning", title = "ABCC VIOLATION" and year = 2019

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: building

Link rowid ▼ id title year datetime building address outcome
54 54 #19-05378 ABCC VIOLATION 2019 2019-12-15 00:05:00 WVU LYON TOWER 356 EVANSDALE DR, MORGANTOWN, WV 26501 Clear by Warning
66 66 #19-05366 ABCC VIOLATION 2019 2019-12-14 01:16:00 415 OAKLAND ST, MORGANTOWN, WV 26501 Clear by Warning
166 166 #19-05262 ABCC VIOLATION 2019 2019-12-08 00:26:00 160 BELMAR AVE, MORGANTOWN, WV 26501 Clear by Warning
183 183 #19-05244 ABCC VIOLATION 2019 2019-12-07 00:52:00 WVU SENECA HALL 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 Clear by Warning
185 185 #19-05242 ABCC VIOLATION 2019 2019-12-06 23:52:00 ALPHA SIGMA PHI FRATERNITY 200 BELMAR AVE, MORGANTOWN, WV 26501 Clear by Warning
195 195 #19-05232 ABCC VIOLATION 2019 2019-12-06 22:02:00 WVU COLISEUM 11 JERRY WEST DR, MORGANTOWN, WV 26501 Clear by Warning
211 211 #19-05212 ABCC VIOLATION 2019 2019-12-05 23:08:00 PHI KAPPA PSI FRATERNITY 780 PRICE ST, MORGANTOWN, WV 26501 Clear by Warning
212 212 #19-05211 ABCC VIOLATION 2019 2019-12-05 22:10:00 WVU SUMMIT HALL 211 GRANT AVE, MORGANTOWN, WV 26501 Clear by Warning
327 327 #19-05089 ABCC VIOLATION 2019 2019-11-21 23:44:00 WVU BENNETT TOWER 356 EVANSDALE DR, MORGANTOWN, WV 26501 Clear by Warning
520 520 #19-04889 ABCC VIOLATION 2019 2019-11-10 04:16:00 WVU SUMMIT HALL 211 GRANT AVE, MORGANTOWN, WV 26501 Clear by Warning
526 526 #19-04883 ABCC VIOLATION 2019 2019-11-10 00:23:00 WVU OAKLAND HALL-EAST 438 OAKLAND ST, MORGANTOWN, WV 26501 Clear by Warning
564 564 #19-04841 ABCC VIOLATION 2019 2019-11-09 02:19:00 WVU UNIVERSITY PLACE NORTH 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 Clear by Warning
565 565 #19-04840 ABCC VIOLATION 2019 2019-11-09 01:16:00 WVU BENNETT TOWER 356 EVANSDALE DR, MORGANTOWN, WV 26501 Clear by Warning
566 566 #19-04839 ABCC VIOLATION 2019 2019-11-09 00:46:00 WVU BENNETT TOWER 356 EVANSDALE DR, MORGANTOWN, WV 26501 Clear by Warning
680 680 #19-04723 ABCC VIOLATION 2019 2019-11-02 01:05:00 ALPHA SIGMA PHI FRATERNITY 200 BELMAR AVE, MORGANTOWN, WV 26501 Clear by Warning
709 709 #19-04694 ABCC VIOLATION 2019 2019-11-01 01:35:00 WVU BROOKE TOWER 356 EVANSDALE DR, MORGANTOWN, WV 26501 Clear by Warning
826 826 #19-04574 ABCC VIOLATION 2019 2019-10-25 21:35:00 WVU HONORS HALL 250 SECOND ST, MORGANTOWN, WV Clear by Warning
964 964 #19-04430 ABCC VIOLATION 2019 2019-10-19 03:43:00 WVU OAKLAND HALL-EAST 438 OAKLAND ST, MORGANTOWN, WV 26501 Clear by Warning
970 970 #19-04424 ABCC VIOLATION 2019 2019-10-19 00:56:00 WVU BRAXTON TOWER 356 EVANSDALE DR, MORGANTOWN, WV 26501 Clear by Warning
972 972 #19-04422 ABCC VIOLATION 2019 2019-10-19 00:54:00 WVU DADISMAN HALL 693 NORTH HIGH ST, MORGANTOWN, WV Clear by Warning
976 976 #19-04418 ABCC VIOLATION 2019 2019-10-18 23:36:00 WVU MOUNTAINLAIR 1550 UNIVERSITY AVE, MORGANTOWN, WV Clear by Warning
993 993 #19-04400 ABCC VIOLATION 2019 2019-10-18 01:27:00 WVU SENECA HALL 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 Clear by Warning
1199 1199 #19-04184 ABCC VIOLATION 2019 2019-10-05 16:06:00 GREEN LOT VAN VOORHIS RD / CHRISTY ST, MORGANTOWN, WV 26501 Clear by Warning
1204 1204 #19-04179 ABCC VIOLATION 2019 2019-10-05 15:16:00 STADIUM 3 ERRETT RODGERS DR, MORGANTOWN, WV 26501 Clear by Warning
1224 1224 #19-04159 ABCC VIOLATION 2019 2019-10-05 02:47:00 WVU SUMMIT HALL 211 GRANT AVE, MORGANTOWN, WV 26501 Clear by Warning
1228 1228 #19-04155 ABCC VIOLATION 2019 2019-10-05 02:01:00 WVU BOREMAN NORTH 602 NORTH HIGH ST, MORGANTOWN, WV 26501 Clear by Warning
1257 1257 #19-04125 ABCC VIOLATION 2019 2019-10-03 22:34:00 SIGMA PHI EPSILON FRATERNITY 709 NORTH HIGH ST, MORGANTOWN, WV 26501 Clear by Warning

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [crimelog] (
   [id] TEXT,
   [title] TEXT,
   [year] TEXT,
   [datetime] TEXT,
   [building] TEXT,
   [address] TEXT,
   [outcome] TEXT
);