crimelog
9 rows where "datetime" is on date 2021-06-19
This data as json, CSV (advanced)
Suggested facets: title, building, address, outcome
Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
---|---|---|---|---|---|---|---|---|
8009 | 8009 | #21-01812 | TRAFFIC STOP, 1054 | 2021 | 2021-06-19 21:01:00 | UNIVERSITY AVE / THIRD ST, MORGANTOWN, WV 26501 | Clear by Warning | |
8010 | 8010 | #21-01811 | TRAFFIC STOP, 1054 | 2021 | 2021-06-19 20:51:00 | HOUGH ST / BEECHURST AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
8011 | 8011 | #21-01810 | TRAFFIC STOP, 1054 | 2021 | 2021-06-19 18:57:00 | VAN VOORHIS RD / ELMER PRINCE DR, MORGANTOWN | Clear by Warning | |
8012 | 8012 | #21-01809 | ASSIST AGENCY | 2021 | 2021-06-19 12:36:00 | LITTLE GENERAL VAN VOORHIS | 1157 VAN VOORHIS RD, MORGANTOWN, WV | Forward to Other Agency |
8013 | 8013 | #21-01808 | TRAFFIC STOP, 1054 | 2021 | 2021-06-19 02:18:00 | SPRUCE ST / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
8014 | 8014 | #21-01807 | TRAFFIC STOP, 1054 | 2021 | 2021-06-19 01:38:00 | WILLEY ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
8015 | 8015 | #21-01806 | TRAFFIC STOP, 1054 | 2021 | 2021-06-19 01:20:00 | WILLEY ST / HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
8016 | 8016 | #21-01805 | TRAFFIC STOP, 1054 | 2021 | 2021-06-19 01:00:00 | WILLEY ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
8017 | 8017 | #21-01804 | TRAFFIC STOP, 1054 | 2021 | 2021-06-19 00:47:00 | SPRUCE ST / WILLEY ST, 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 );