crimelog
8 rows where "datetime" is on date 2019-12-21
This data as json, CSV (advanced)
Suggested facets: title, building, address, outcome
Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
---|---|---|---|---|---|---|---|---|
1487 | 1487 | #19-05453 | VEHICLE ACCIDENT | 2019 | 2019-12-21 12:14:00 | WVU COLISEUM | 11 JERRY WEST DR, MORGANTOWN, WV 26501 | Closed - Resolved |
1488 | 1488 | #19-05452 | INFORMATION REPORT | 2019 | 2019-12-21 10:51:00 | WVU VANDALIA HALL GOLD | 49 FALLING RUN RD, MORGANTOWN, WV 26501 | Closed - Resolved |
1489 | 1489 | #19-05451 | TRAFFIC STOP, 1054 | 2019 | 2019-12-21 04:01:00 | ELMER PRINCE DR / VAN VOORHIS RD, MORGANTOWN, WV 26501 | Clear by Warning | |
1490 | 1490 | #19-05450 | TRAFFIC STOP, 1054 | 2019 | 2019-12-21 02:30:00 | UNIVERSITY AVE / THIRD ST, MORGANTOWN, WV 26501 | Clear by Arrest | |
1491 | 1491 | #19-05449 | TRAFFIC STOP, 1054 | 2019 | 2019-12-21 02:01:00 | WILLEY ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
1492 | 1492 | #19-05448 | TRAFFIC STOP, 1054 | 2019 | 2019-12-21 01:51:00 | SPRUCE ST / FAYETTE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
1493 | 1493 | #19-05447 | TRAFFIC STOP, 1054 | 2019 | 2019-12-21 01:20:00 | FALLING RUN RD / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
1494 | 1494 | #19-05446 | TRAFFIC STOP, 1054 | 2019 | 2019-12-21 00:52:00 | WILLEY ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation |
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 );