crimelog
4 rows where outcome = "Active" and title = "BATTERY" sorted by datetime descending
This data as json, CSV (advanced)
Suggested facets: building, datetime (date)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
15979 | 15979 | 23-02581 | BATTERY | 2023 | 2023-09-16 21:20:00 | 992 ELMER PRINCE DR, MORGANTOWN | Active | |
7032 | 7032 | #21-00808 | BATTERY | 2021 | 2021-03-18 00:07:00 | SIGMA PHI ELPSILON FRATERNITY | 216 BELMAR AVE, MORGANTOWN, WV 26501 | Active |
3331 | 3331 | #20-01807 | BATTERY | 2020 | 2020-07-05 23:50:00 | SPRUCE ST, MORGANTOWN, WV 26501 | Active | |
504 | 504 | #19-04905 | BATTERY | 2019 | 2019-11-10 00:00:00 | WVU LYON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Active |
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 );