crimelog
111 rows where title = "ABCC VIOLATION" and year = 2019 sorted by address
This data as json, CSV (advanced)
outcome 3 ✖
Link | rowid | id | title | year | datetime | building | address ▼ | outcome |
---|---|---|---|---|---|---|---|---|
1458 | 1458 | #19-03920 | ABCC VIOLATION | 2019 | 2019-09-20 23:03:00 | NORTH SPRUCE ST / PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Citation | |
1452 | 1452 | #19-03926 | ABCC VIOLATION | 2019 | 2019-09-21 00:40:00 | NORTH SPRUCE ST / WILES ST, MORGANTOWN WV,26501 | Clear by Citation | |
1335 | 1335 | #19-04046 | ABCC VIOLATION | 2019 | 2019-09-28 23:52:00 | NORTH SPRUCE ST / WILES ST, MORGANTOWN, WV 26501 | Clear by Citation | |
1455 | 1455 | #19-03923 | ABCC VIOLATION | 2019 | 2019-09-20 23:40:00 | NORTH SPRUCE ST / WILES ST, MORGANTOWN, WV 26501 | Clear by Citation | |
679 | 679 | #19-04724 | ABCC VIOLATION | 2019 | 2019-11-02 01:45:00 | PROSPECT ST / NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
950 | 950 | #19-04444 | ABCC VIOLATION | 2019 | 2019-10-20 01:01:00 | PROSPECT ST / NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
1332 | 1332 | #19-04049 | ABCC VIOLATION | 2019 | 2019-09-29 01:35:00 | PROSPECT ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
425 | 425 | #19-04985 | ABCC VIOLATION | 2019 | 2019-11-16 00:52:00 | PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Citation | |
952 | 952 | #19-04442 | ABCC VIOLATION | 2019 | 2019-10-20 00:22:00 | UNIVERSITY AVE / FIRST ST, MORGANTOWN, WV 26501 | Clear by Citation | |
1069 | 1069 | #19-04320 | ABCC VIOLATION | 2019 | 2019-10-12 17:28:00 | GREEN LOT | VAN VOORHIS RD / CHRISTY ST, MORGANTOWN, WV 26501 | Inactive |
1199 | 1199 | #19-04184 | ABCC VIOLATION | 2019 | 2019-10-05 16:06:00 | GREEN LOT | VAN VOORHIS RD / CHRISTY ST, MORGANTOWN, WV 26501 | Clear by Warning |
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 );