crimelog
5 rows where "datetime" is on date 2022-01-24 and outcome = "Closed - Resolved"
This data as json, CSV (advanced)
Suggested facets: title, datetime (date)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 10069 | 10069 | #22-00225 | TRESPASSING | 2022 | 2022-01-24 19:09:00 | WVU ARNOLD HALL | PRICE ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 10070 | 10070 | #22-00224 | DESTRUCTION OF PROPERTY | 2022 | 2022-01-24 22:27:00 | WVU WOODBURN CIRCLE | 39.635817, -79.954791, MORGANTOWN, WV 26501 | Closed - Resolved |
| 10071 | 10071 | #22-00223 | ASSIST EMS POLICE | 2022 | 2022-01-24 21:30:00 | WVU LYON TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 10073 | 10073 | #22-00220 | ALARM CONDITION | 2022 | 2022-01-24 13:12:00 | HEALTH SCIENCE CENTER | MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 10075 | 10075 | #22-00218 | ASSIST EMS POLICE | 2022 | 2022-01-24 10:07:00 | WVU EVANSDALE LIBRARY | RESEARCH WAY, 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 );