crimelog
11 rows where "datetime" is on date 2023-09-16 and title = "ABCC VIOLATION"
This data as json, CSV (advanced)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 15852 | 15852 | 23-02539 | ABCC VIOLATION | 2023 | 2023-09-16 01:16:00 | WVU MOUNTAINLAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Warning |
| 15857 | 15857 | 23-02548 | ABCC VIOLATION | 2023 | 2023-09-16 12:06:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Clear by Warning |
| 15859 | 15859 | 23-02553 | ABCC VIOLATION | 2023 | 2023-09-16 15:50:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Clear by Citation |
| 15861 | 15861 | 23-02555 | ABCC VIOLATION | 2023 | 2023-09-16 16:59:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Closed - Resolved |
| 15862 | 15862 | 23-02557 | ABCC VIOLATION | 2023 | 2023-09-16 17:20:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Clear by Warning |
| 15863 | 15863 | 23-02558 | ABCC VIOLATION | 2023 | 2023-09-16 17:18:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Clear by Warning |
| 15867 | 15867 | 23-02562 | ABCC VIOLATION | 2023 | 2023-09-16 17:49:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Clear by Warning |
| 15870 | 15870 | 23-02565 | ABCC VIOLATION | 2023 | 2023-09-16 18:32:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Clear by Warning |
| 15875 | 15875 | 23-02574 | ABCC VIOLATION | 2023 | 2023-09-16 19:57:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Clear by Warning |
| 15919 | 15919 | 23-02546 | ABCC VIOLATION | 2023 | 2023-09-16 11:38:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Clear by Arrest |
| 16059 | 16059 | 23-02567 | ABCC VIOLATION | 2023 | 2023-09-16 19:02:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | 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 );