crimelog
6 rows where outcome = "NORTH HIGH ST, MORGANTOWN, WV 26501" and title = "OPEN CONTAINER" sorted by datetime descending
This data as json, CSV (advanced)
Suggested facets: datetime (date)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
14710 | 14710 | #CRS23-01651 | OPEN CONTAINER | 2023 | 2022-08-15 01:29:00 | MPD case # M2022-036259 | NORTH HIGH ST, MORGANTOWN, WV 26501 | |
14703 | 14703 | #CRS23-01658 | OPEN CONTAINER | 2023 | 2022-08-15 00:19:00 | MPD citation # 54486 | NORTH HIGH ST, MORGANTOWN, WV 26501 | |
14715 | 14715 | #CRS23-01646 | OPEN CONTAINER | 2023 | 2022-08-15 00:09:00 | MPD Case # M2022-003311 | NORTH HIGH ST, MORGANTOWN, WV 26501 | |
14706 | 14706 | #CRS23-01655 | OPEN CONTAINER | 2023 | 2022-08-14 23:44:00 | MPD citation # 54485 | NORTH HIGH ST, MORGANTOWN, WV 26501 | |
14708 | 14708 | #CRS23-01653 | OPEN CONTAINER | 2023 | 2022-08-14 23:43:00 | MPD citation # 54291 | NORTH HIGH ST, MORGANTOWN, WV 26501 | |
14709 | 14709 | #CRS23-01652 | OPEN CONTAINER | 2023 | 2022-08-13 00:04:00 | MPD citation # 54290 | NORTH HIGH ST, MORGANTOWN, WV 26501 |
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 );