crimelog
9 rows where "datetime" is on date 2020-06-06
This data as json, CSV (advanced)
Suggested facets: title, building, outcome
Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
---|---|---|---|---|---|---|---|---|
3192 | 3192 | #20-01647 | TRAFFIC STOP, 1054 | 2020 | 2020-06-06 04:21:00 | UNIVERSITY AVE / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3193 | 3193 | #20-01646 | DUI | 2020 | 2020-06-06 03:09:00 | BEECHURST AVE, MORGANTOWN, WV 26501 | Clear by Arrest | |
3194 | 3194 | #20-01645 | BATTERY | 2020 | 2020-06-06 01:47:00 | WVU LIFE SCIENCES BUILDING | 53 CAMPUS DR, MORGANTOWN, WV | Under Investigation |
3195 | 3195 | #20-01644 | TRAFFIC STOP, 1054 | 2020 | 2020-06-06 00:32:00 | SPRUCE ST / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Citation | |
4076 | 4076 | #PS20-00643 | AREA PATROL | 2020 | 2020-06-06 19:00:00 | Potomac State College, Keyser, WV 26726 | Closed - Resolved | |
4079 | 4079 | #PS20-00640 | K9 DETAIL | 2020 | 2020-06-06 23:30:00 | PSC UNIVERSITY POLICE | 171 FORT AVE, KEYSER, WV 26726 | Closed - Resolved |
4080 | 4080 | #PS20-00639 | TRAFFIC STOP, 1054 | 2020 | 2020-06-06 19:28:00 | PSC State Street, Keyser, WV 26726 | Clear by Warning | |
4081 | 4081 | #PS20-00638 | ASSIST POLICE POLICE | 2020 | 2020-06-06 01:09:00 | Saint Cloud Street, Keyser, WV 26726 | Closed - Resolved | |
4082 | 4082 | #PS20-00637 | AREA PATROL | 2020 | 2020-06-06 09:00:00 | PSC, KEYSER, WV 26726 | 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 );