crimelog
6 rows where outcome = "Closed - Lack of leads" and title = "INFORMATION REPORT" sorted by datetime descending
This data as json, CSV (advanced)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
11995 | 11995 | #22-02235 | INFORMATION REPORT | 2022 | 2022-09-09 02:09:00 | BELMAR AVE, MORGANTOWN, WV 26501 | Closed - Lack of leads | |
11182 | 11182 | #22-01405 | INFORMATION REPORT | 2022 | 2022-06-24 08:56:00 | COLLEGE PARK | NEWTON AVE, MORGANTOWN, WV | Closed - Lack of leads |
9823 | 9823 | #21-03704 | INFORMATION REPORT | 2021 | 2021-12-21 12:06:00 | WVU POLICE DEPARTMENT | ELMER PRINCE DR, MORGANTOWN, WV | Closed - Lack of leads |
9213 | 9213 | #21-03075 | INFORMATION REPORT | 2021 | 2021-10-26 08:15:00 | PI KAPP ALPHA FRATERNITY (PIKE) | BELMAR AVE, MORGANTOWN, WV 26501 | 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 );