crimelog
111 rows where title = "ABCC VIOLATION" and year = 2019 sorted by datetime
This data as json, CSV (advanced)
outcome 3 ✖
Link | rowid | id | title | year | datetime ▼ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
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 |
206 | 206 | #19-05217 | ABCC VIOLATION | 2019 | 2019-12-06 01:41:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Clear by Citation |
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 |
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 |
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 |
166 | 166 | #19-05262 | ABCC VIOLATION | 2019 | 2019-12-08 00:26:00 | 160 BELMAR AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
82 | 82 | #19-05350 | ABCC VIOLATION | 2019 | 2019-12-13 03:00:00 | CAMPUS DR / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Arrest | |
67 | 67 | #19-05365 | ABCC VIOLATION | 2019 | 2019-12-14 00:16:00 | WVU MOUNTAINLAIR PARKING GARAGE | 109 PROSPECT ST, MORGANTOWN, WV | Clear by Arrest |
61 | 61 | #19-05371 | ABCC VIOLATION | 2019 | 2019-12-14 01:10:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
66 | 66 | #19-05366 | ABCC VIOLATION | 2019 | 2019-12-14 01:16:00 | 415 OAKLAND ST, MORGANTOWN, WV 26501 | Clear by Warning | |
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 |
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 );