crimelog
10 rows where "datetime" is on date 2022-10-13, title = "ABCC VIOLATION" and year = 2022
This data as json, CSV (advanced)
Suggested facets: building, address, outcome, datetime (date)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 12296 | 12296 | #22-02623 | ABCC VIOLATION | 2022 | 2022-10-13 18:20:00 | WVU Area 65 (UPD) | 39.653176, -79.962206 | Clear by Warning |
| 12300 | 12300 | #22-02600 | ABCC VIOLATION | 2022 | 2022-10-13 21:05:00 | WVU HONORS HALL | SECOND ST, MORGANTOWN, WV | Closed - Resolved |
| 12303 | 12303 | #22-02595 | ABCC VIOLATION | 2022 | 2022-10-13 20:17:00 | UNITED BANK SUNCREST | ELMER PRINCE DR, MORGANTOWN, WV | Clear by Warning |
| 12304 | 12304 | #22-02594 | ABCC VIOLATION | 2022 | 2022-10-13 20:06:00 | BLUE LOT | STADIUM DR, MORGANTOWN, WV | Clear by Arrest |
| 12306 | 12306 | #22-02592 | ABCC VIOLATION | 2022 | 2022-10-13 19:51:00 | WVU OAKLAND HALL-EAST | OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 12307 | 12307 | #22-02591 | ABCC VIOLATION | 2022 | 2022-10-13 19:37:00 | BLUE LOT | STADIUM DR, MORGANTOWN, WV | Closed - Resolved |
| 12309 | 12309 | #22-02588 | ABCC VIOLATION | 2022 | 2022-10-13 18:43:00 | BLUE LOT | STADIUM DR, MORGANTOWN, WV | Closed - Resolved |
| 12366 | 12366 | #22-02599 | ABCC VIOLATION | 2022 | 2022-10-13 21:09:00 | HEALTH SCIENCE CENTER | MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 12368 | 12368 | #22-02586 | ABCC VIOLATION | 2022 | 2022-10-13 17:58:00 | WVU OAKLAND HALL-WEST | OAKLAND ST, MORGANTOWN, WV 26501 | Clear by Warning |
| 12385 | 12385 | #22-02598 | ABCC VIOLATION | 2022 | 2022-10-13 20:50:00 | LIGHT BLUE LOT | WILLOWDALE RD, MORGANTOWN, WV | 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 );