crimelog
5 rows where outcome = "Active" and title = "BACK TICKET TOW" sorted by datetime descending
This data as json, CSV (advanced)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
12231 | 12231 | #22-02496 | BACK TICKET TOW | 2022 | 2022-10-05 08:44:00 | WVU Area 6 (Maiden Lane) | 39.635243, -79.953091, MORGANTOWN | Active |
12193 | 12193 | #22-02391 | BACK TICKET TOW | 2022 | 2022-09-27 08:39:00 | 39.635243, -79.953091, MORGANTOWN | Active | |
5419 | 5419 | #20-03369 | BACK TICKET TOW | 2020 | 2020-11-12 12:24:00 | WVU AREA 12 (Arnold) | 39.632448, -79.951216 | Active |
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 );