crimelog
6 rows where outcome = "Closed - Lack of leads" and title = "VEHICLE ACCIDENT" sorted by datetime descending
This data as json, CSV (advanced)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
12560 | 12560 | #22-02811 | VEHICLE ACCIDENT | 2022 | 2022-10-29 09:57:00 | WVU MOUNTAINLAIR | UNIVERSITY AVE, MORGANTOWN, WV | Closed - Lack of leads |
11922 | 11922 | #22-02053 | VEHICLE ACCIDENT | 2022 | 2022-09-04 15:20:00 | WVU AREA 93P (HSC) | 39.654294, -79.959226, Morgantown, WV 26506 | Closed - Lack of leads |
11272 | 11272 | #22-01534 | VEHICLE ACCIDENT | 2022 | 2022-07-17 21:41:00 | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Lack of leads | |
10400 | 10400 | #22-00539 | VEHICLE ACCIDENT | 2022 | 2022-02-25 17:26:00 | WVU MOUNTAINLAIR PARKING GARAGE | PROSPECT ST, MORGANTOWN, WV | Closed - Lack of leads |
10162 | 10162 | #22-00318 | VEHICLE ACCIDENT | 2022 | 2022-02-02 18:08:00 | WVU Area 81 (HSC) | 39.655616, -79.961320, morgantown | Closed - Lack of leads |
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 );