crimelog
3 rows where title = "TRAINING POLICE" sorted by datetime descending
This data as json, CSV (advanced)
Suggested facets: building, datetime (date)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
5555 | 5555 | #BC20-00440 | TRAINING POLICE | 2020 | 2020-11-09 08:50:00 | Firearm Range, Beckley, WV 25801 | Closed - Resolved | |
5600 | 5600 | #BC20-00395 | TRAINING POLICE | 2020 | 2020-11-05 12:59:00 | TECH UNIVERSITY POLICE | 313 S KANAWHA ST, BECKLEY, WV 25802 | Closed - Resolved |
5664 | 5664 | #BC20-00331 | TRAINING POLICE | 2020 | 2020-11-02 07:15:00 | Health Department Harper Road, Beckley, WV 25801 | 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 );