crimelog
3 rows where outcome = "Closed - Unresolved" and title = "AUTO TAMPERING" sorted by datetime descending
This data as json, CSV (advanced)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
12567 | 12567 | #22-02862 | AUTO TAMPERING | 2022 | 2022-11-02 09:10:00 | WVU Area 39 (Summit) | 39.639206, -79.956773 | Closed - Unresolved |
6735 | 6735 | #21-00536 | AUTO TAMPERING | 2021 | 2021-02-28 21:21:00 | WVU Area 44 (Evansdale Library) | 39.644803, -79.971079 | Closed - Unresolved |
1949 | 1949 | #20-00435 | AUTO TAMPERING | 2020 | 2020-01-28 18:00:00 | 284 WILES ST, MORGANTOWN, WV 26501 | Closed - Unresolved |
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 );