crimelog
15 rows where outcome = "Closed - Unresolved" and title = "BACK TICKET TOW" sorted by datetime descending
This data as json, CSV (advanced)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
12744 | 12744 | #SR22-03034 | BACK TICKET TOW | 2022 | 2022-11-16 08:40:00 | WVU SHORT TERM 2 (MOUNTAINLAIR) | 39.634049, -79.953009, MORGANTOWN, WV 26501 | Closed - Unresolved |
12714 | 12714 | #SR22-03012 | BACK TICKET TOW | 2022 | 2022-11-14 14:02:00 | WVU SHORT TERM 5 (SUNNYSIDE) | 39.638035, -79.955530, MORGANTOWN, WV 26501 | Closed - Unresolved |
12629 | 12629 | #SR22-02860 | BACK TICKET TOW | 2022 | 2022-11-02 08:06:00 | WVU Area 50 (Allen/ Perc) | 39.646836, -79.966397, Morgantown | Closed - Unresolved |
12467 | 12467 | #22-02749 | BACK TICKET TOW | 2022 | 2022-10-25 12:38:00 | COLLEGE PARK | NEWTON AVE, MORGANTOWN, WV | Closed - Unresolved |
12400 | 12400 | #SR22-02671 | BACK TICKET TOW | 2022 | 2022-10-18 08:25:00 | WVU MOUNTAINLAIR PARKING GARAGE | PROSPECT ST, MORGANTOWN, WV | 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 );