crimelog
8 rows where outcome = "Clear by Citation" and title = "OPEN CONTAINER"
This data as json, CSV (advanced)
Suggested facets: year, datetime (date)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 9263 | 9263 | #21-03131 | OPEN CONTAINER | 2021 | 2021-10-30 22:44:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 11484 | 11484 | #22-01737 | OPEN CONTAINER | 2022 | 2022-08-13 23:21:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 15384 | 15384 | CRS23-01646 | OPEN CONTAINER | 2022 | 2022-08-15 00:09:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 15389 | 15389 | CRS23-01651 | OPEN CONTAINER | 2022 | 2022-08-15 01:29:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 15390 | 15390 | CRS23-01652 | OPEN CONTAINER | 2022 | 2022-08-13 00:04:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 15391 | 15391 | CRS23-01653 | OPEN CONTAINER | 2022 | 2022-08-14 23:43:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 15392 | 15392 | CRS23-01655 | OPEN CONTAINER | 2022 | 2022-08-14 23:44:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 15395 | 15395 | CRS23-01658 | OPEN CONTAINER | 2022 | 2022-08-15 00:19:00 | NORTH HIGH 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 );