crimelog
9 rows where outcome = "Closed - Resolved", title = "LOUD PARTY" and year = 2021 sorted by datetime descending
This data as json, CSV (advanced)
Suggested facets: building, address, datetime (date)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
9167 | 9167 | #21-03052 | LOUD PARTY | 2021 | 2021-10-24 00:28:00 | NORTH HIGH ST, MORGANTOWN | Closed - Resolved | |
8921 | 8921 | #21-02749 | LOUD PARTY | 2021 | 2021-09-30 00:49:00 | ALPHA OMNIA FRATERNITY (PIKE) | BELMAR AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
8746 | 8746 | #21-02619 | LOUD PARTY | 2021 | 2021-09-18 11:34:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Closed - Resolved |
8747 | 8747 | #21-02618 | LOUD PARTY | 2021 | 2021-09-18 11:15:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Closed - Resolved |
8748 | 8748 | #21-02617 | LOUD PARTY | 2021 | 2021-09-18 11:08:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Closed - Resolved |
8749 | 8749 | #21-02616 | LOUD PARTY | 2021 | 2021-09-18 10:51:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Closed - Resolved |
8516 | 8516 | #21-02328 | LOUD PARTY | 2021 | 2021-08-27 23:56:00 | SIGMA CHI FRATERNITY | 700 NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
8405 | 8405 | #21-02242 | LOUD PARTY | 2021 | 2021-08-22 00:25:00 | DELTA CHI FRATERNITY | 117 BELMAR AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
8358 | 8358 | #21-02165 | LOUD PARTY | 2021 | 2021-08-17 01:14:00 | DELTA CHI FRATERNITY | 117 BELMAR AVE, 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 );