crimelog
2 rows where outcome = "Active", title = "TALK WITH OFFICER" and year = 2020
This data as json, CSV (advanced)
Suggested facets: datetime (date)
Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
---|---|---|---|---|---|---|---|---|
3498 | 3498 | #20-01945 | TALK WITH OFFICER | 2020 | 2020-08-04 11:18:00 | IHOP - OAKLAND HALL | 475 OAKLAND ST, MORGANTOWN, WV | Active |
4686 | 4686 | #20-02833 | TALK WITH OFFICER | 2020 | 2020-09-28 10:42:00 | WVU SHORT TERM 2 (MOUNTAINLAIR) | 39.634049, -79.953009, 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 );