crimelog
5 rows where "datetime" is on date 2021-03-07 and title = "ABCC VIOLATION"
This data as json, CSV (advanced)
Suggested facets: address, datetime (date)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 6827 | 6827 | #21-00597 | ABCC VIOLATION | 2021 | 2021-03-07 01:54:00 | PROSPECT ST / NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 6828 | 6828 | #21-00596 | ABCC VIOLATION | 2021 | 2021-03-07 00:52:00 | 49 NEWTON AVE unit 407, MORGANTOWN, WV 26501 | Clear by Citation | |
| 6831 | 6831 | #21-00593 | ABCC VIOLATION | 2021 | 2021-03-07 00:34:00 | FIFE AVE / PRICE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 6832 | 6832 | #21-00592 | ABCC VIOLATION | 2021 | 2021-03-07 00:28:00 | FIFE AVE / PRICE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 6833 | 6833 | #21-00591 | ABCC VIOLATION | 2021 | 2021-03-07 00:24:00 | FIFE AVE / PRICE ST, MORGANTOWN, WV 26501 | Clear by Citation |
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 );