crimelog
10 rows where outcome = "Closed - Resolved", title = "INFORMATION REPORT" and year = 2021 sorted by datetime descending
This data as json, CSV (advanced)
Suggested facets: building, datetime (date)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
9777 | 9777 | #21-03643 | INFORMATION REPORT | 2021 | 2021-12-14 04:42:00 | WVU CLARK HALL | PROSPECT ST, MORGANTOWN, WV | Closed - Resolved |
9722 | 9722 | #21-03630 | INFORMATION REPORT | 2021 | 2021-12-12 23:24:00 | WVU OAKLAND HALL-WEST | OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
9377 | 9377 | #21-03243 | INFORMATION REPORT | 2021 | 2021-11-06 20:32:00 | WVU PRT STATION - HSC | MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
9126 | 9126 | #21-02952 | INFORMATION REPORT | 2021 | 2021-10-15 12:37:00 | elmer prince dr, MORGANTOWN, WV 26501 | Closed - Resolved | |
9025 | 9025 | #21-02856 | INFORMATION REPORT | 2021 | 2021-10-06 00:27:00 | WVU MOUNTAINLAIR | UNIVERSITY AVE, MORGANTOWN, WV | Closed - Resolved |
8979 | 8979 | #21-02587 | INFORMATION REPORT | 2021 | 2021-09-18 08:39:00 | BLUE LOT | STADIUM DR, MORGANTOWN, WV | Closed - Resolved |
8726 | 8726 | #21-02559 | INFORMATION REPORT | 2021 | 2021-09-16 10:14:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
8549 | 8549 | #21-02385 | INFORMATION REPORT | 2021 | 2021-09-01 17:02:00 | WVU Area 44 (Evansdale Library) | 39.644803, -79.971079 | Closed - Resolved |
7913 | 7913 | #21-01707 | INFORMATION REPORT | 2021 | 2021-06-09 12:34:00 | 253 Richard Harrison Way, GRANVILLE, WV 26534 | Closed - Resolved | |
6443 | 6443 | #21-00139 | INFORMATION REPORT | 2021 | 2021-01-22 13:00:00 | 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 );