crimelog
21 rows where "datetime" is on date 2021-03-13, outcome = "Clear by Citation" and title = "ABCC VIOLATION"
This data as json, CSV (advanced)
Suggested facets: address, datetime (date)
Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
---|---|---|---|---|---|---|---|---|
6909 | 6909 | #21-00717 | ABCC VIOLATION | 2021 | 2021-03-13 23:46:00 | GRANT AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
6911 | 6911 | #21-00711 | ABCC VIOLATION | 2021 | 2021-03-13 21:07:00 | PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Citation | |
6912 | 6912 | #21-00710 | ABCC VIOLATION | 2021 | 2021-03-13 21:01:00 | NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
6914 | 6914 | #21-00704 | ABCC VIOLATION | 2021 | 2021-03-13 19:54:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
6918 | 6918 | #21-00700 | ABCC VIOLATION | 2021 | 2021-03-13 18:58:00 | FIFE AVE / NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
6919 | 6919 | #21-00699 | ABCC VIOLATION | 2021 | 2021-03-13 18:35:00 | BELMAR AVE, MORGANTOWN | Clear by Citation | |
6920 | 6920 | #21-00696 | ABCC VIOLATION | 2021 | 2021-03-13 18:16:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
6924 | 6924 | #21-00691 | ABCC VIOLATION | 2021 | 2021-03-13 16:40:00 | WAVERLY ST, MORGANTOWN, WV 26501 | Clear by Citation | |
6928 | 6928 | #21-00685 | ABCC VIOLATION | 2021 | 2021-03-13 02:04:00 | HOUSTON DR / GRANT AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
6932 | 6932 | #21-00681 | ABCC VIOLATION | 2021 | 2021-03-13 00:33:00 | FIFE AVE / NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
6934 | 6934 | #21-00678 | ABCC VIOLATION | 2021 | 2021-03-13 00:08:00 | NORTH HIGH ST / FIFE AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
6966 | 6966 | #21-00715 | ABCC VIOLATION | 2021 | 2021-03-13 21:45:00 | BEVERLY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
6967 | 6967 | #21-00714 | ABCC VIOLATION | 2021 | 2021-03-13 21:39:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
6968 | 6968 | #21-00713 | ABCC VIOLATION | 2021 | 2021-03-13 21:09:00 | PRICE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
6969 | 6969 | #21-00708 | ABCC VIOLATION | 2021 | 2021-03-13 20:51:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
6971 | 6971 | #21-00706 | ABCC VIOLATION | 2021 | 2021-03-13 20:37:00 | BELMAR AVE / PRICE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
6972 | 6972 | #21-00698 | ABCC VIOLATION | 2021 | 2021-03-13 18:47:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
6973 | 6973 | #21-00697 | ABCC VIOLATION | 2021 | 2021-03-13 18:51:00 | NORTH HIGH ST/Fife St, MORGANTOWN, WV 26501 | Clear by Citation | |
6974 | 6974 | #21-00695 | ABCC VIOLATION | 2021 | 2021-03-13 17:54:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
6975 | 6975 | #21-00687 | ABCC VIOLATION | 2021 | 2021-03-13 02:20:00 | SPRUCE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
6976 | 6976 | #21-00679 | ABCC VIOLATION | 2021 | 2021-03-13 00:17:00 | FIFE AVE / 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 );