crimelog
5 rows where "datetime" is on date 2022-10-09 and year = 2022
This data as json, CSV (advanced)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 12250 | 12250 | #22-02536 | ASSIST EMS POLICE | 2022 | 2022-10-09 22:38:00 | WVU BROOKE TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 12251 | 12251 | #SR22-02535 | PROP ALARM | 2022 | 2022-10-09 14:04:00 | COLLEGE PARK | NEWTON AVE, MORGANTOWN, WV | Closed - Resolved |
| 12252 | 12252 | #22-02534 | ASSIST FIRE DEPT POLICE | 2022 | 2022-10-09 13:18:00 | CHI OMEGA SORORITY | NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 12253 | 12253 | #22-02533 | BATTERY | 2022 | 2022-10-09 02:03:00 | WAVERLY ST, MORGANTOWN | Cleared by Exception - Prosecution Declined | |
| 12254 | 12254 | #22-02532 | TRAFFIC STOP, 1054 | 2022 | 2022-10-09 01:57:00 | WVU MOUNTAINLAIR | UNIVERSITY AVE, MORGANTOWN, WV | Clear by Arrest |
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 );