crimelog
35 rows where outcome = "Closed - Resolved", title = "ABCC VIOLATION" and year = 2022 sorted by datetime descending
This data as json, CSV (advanced)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
11644 | 11644 | #22-01919 | ABCC VIOLATION | 2022 | 2022-08-25 23:49:00 | WVU WHITE HALL | WILLEY ST, MORGANTOWN, WV 26501 | Closed - Resolved |
11528 | 11528 | #22-01791 | ABCC VIOLATION | 2022 | 2022-08-16 19:20:00 | WVU REC CENTER | rec center dr, MORGANTOWN, WV 26501 | Closed - Resolved |
11529 | 11529 | #22-01790 | ABCC VIOLATION | 2022 | 2022-08-16 19:19:00 | WVU REC CENTER | REC CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
11530 | 11530 | #22-01789 | ABCC VIOLATION | 2022 | 2022-08-16 19:01:00 | WVU REC CENTER | REC CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
11541 | 11541 | #22-01776 | ABCC VIOLATION | 2022 | 2022-08-16 03:52:00 | WVU Area 30U (College Park) | 39.637510, -79.943520 | Closed - Resolved |
11482 | 11482 | #22-01739 | ABCC VIOLATION | 2022 | 2022-08-14 00:24:00 | WVU MOUNTAINLAIR | UNIVERSITY AVE, MORGANTOWN, WV | Closed - Resolved |
11158 | 11158 | #22-01387 | ABCC VIOLATION | 2022 | 2022-06-18 02:17:00 | WVU MOUNTAINLAIR PARKING GARAGE | PROSPECT ST, MORGANTOWN, WV | Closed - Resolved |
10984 | 10984 | #22-01091 | ABCC VIOLATION | 2022 | 2022-04-22 23:29:00 | COLLEGE PARK | NEWTON AVE, MORGANTOWN, WV | Closed - Resolved |
10460 | 10460 | #22-00605 | ABCC VIOLATION | 2022 | 2022-03-05 00:15:00 | WVU UNIVERSITY PLACE NORTH | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
10367 | 10367 | #22-00519 | ABCC VIOLATION | 2022 | 2022-02-24 03:33:00 | WVU OAKLAND HALL-WEST | OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
10255 | 10255 | #22-00428 | ABCC VIOLATION | 2022 | 2022-02-13 05:55:00 | WVU SUMMIT HALL | GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
10095 | 10095 | #22-00257 | ABCC VIOLATION | 2022 | 2022-01-27 21:26:00 | WVU SENECA HALL | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
10039 | 10039 | #22-00183 | ABCC VIOLATION | 2022 | 2022-01-20 01:22:00 | WVU STALNAKER HALL | NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
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 );