crimelog
111 rows where title = "ABCC VIOLATION" and year = 2019 sorted by outcome
This data as json, CSV (advanced)
outcome 3 ✖
Link | rowid | id | title | year | datetime | building | address | outcome ▼ |
---|---|---|---|---|---|---|---|---|
1068 | 1068 | #19-04321 | ABCC VIOLATION | 2019 | 2019-10-12 17:39:00 | LIGHT BLUE LOT | 0 WILLOWDALE RD, MORGANTOWN, WV | Closed - Resolved |
1197 | 1197 | #19-04187 | ABCC VIOLATION | 2019 | 2019-10-05 16:42:00 | STADIUM | 3 ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Closed - Resolved |
1202 | 1202 | #19-04181 | ABCC VIOLATION | 2019 | 2019-10-05 15:33:00 | WVU LYON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
1320 | 1320 | #19-04061 | ABCC VIOLATION | 2019 | 2019-09-29 22:26:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
683 | 683 | #19-04720 | ABCC VIOLATION | 2019 | 2019-11-02 00:09:00 | WVU BROOKE TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Unresolved |
945 | 945 | #19-04449 | ABCC VIOLATION | 2019 | 2019-10-20 02:56:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Inactive |
954 | 954 | #19-04440 | ABCC VIOLATION | 2019 | 2019-10-19 23:34:00 | WVU MOUNTAINLAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Inactive |
1069 | 1069 | #19-04320 | ABCC VIOLATION | 2019 | 2019-10-12 17:28:00 | GREEN LOT | VAN VOORHIS RD / CHRISTY ST, MORGANTOWN, WV 26501 | Inactive |
1220 | 1220 | #19-04163 | ABCC VIOLATION | 2019 | 2019-10-05 04:56:00 | SHEETZ #556 SUNNYSIDE | 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Inactive |
1235 | 1235 | #19-04148 | ABCC VIOLATION | 2019 | 2019-10-04 23:10:00 | WVU SENECA HALL | 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Inactive |
1248 | 1248 | #19-04134 | ABCC VIOLATION | 2019 | 2019-10-04 03:28:00 | INSOMNIA COOKIES | 2161 UNIVERSITY AVE, MORGANTOWN, WV | Inactive |
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 );