crimelog
4 rows where "datetime" is on date 2023-07-03 and outcome = "Closed - Resolved"
This data as json, CSV (advanced)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 14778 | 14778 | #23-01726 | ASSIST POLICE POLICE | 2023 | 2023-07-03 13:19:00 | QDOBA MEXICAN GRILL | PATTESON DR, MORGANTOWN, WV | Closed - Resolved |
| 14779 | 14779 | #23-01725 | ALARM CONDITION | 2023 | 2023-07-03 12:06:00 | HEALTH SCIENCE CENTER | MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 15003 | 15003 | 23-01725 | ALARM CONDITION | 2023 | 2023-07-03 12:06:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 15004 | 15004 | 23-01726 | ASSIST POLICE POLICE | 2023 | 2023-07-03 13:19:00 | QDOBA MEXICAN GRILL | 386 PATTESON DR, MORGANTOWN, WV | Closed - Resolved |
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 );