crimelog
4 rows where building = "SHEETZ #575 DOWNTOWN"
This data as json, CSV (advanced)
Suggested facets: title, year, outcome, datetime (date)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 1561 | 1561 | #20-00008 | ASSIST EMS POLICE | 2020 | 2020-01-03 03:50:00 | SHEETZ #575 DOWNTOWN | 1012 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 4698 | 4698 | #20-02827 | SUSPICIOUS PERSON | 2020 | 2020-09-27 21:07:00 | SHEETZ #575 DOWNTOWN | 1012 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Inactive |
| 7825 | 7825 | #21-01608 | WARRANT SERVICE | 2021 | 2021-05-28 09:59:00 | SHEETZ #575 DOWNTOWN | 1012 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Arrest |
| 16186 | 16186 | 23-02884 | WARRANT SERVICE | 2023 | 2023-10-05 23:15:00 | SHEETZ #575 DOWNTOWN | 1012 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Arrest |
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 );