crimelog
7 rows where outcome = "Under Investigation" and title = "FIGHT" 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 |
---|---|---|---|---|---|---|---|---|
17871 | 17871 | 24-00914 | FIGHT | 2024 | 2024-03-24 01:10:00 | HIGH ST, MORGANTOWN, WV 26501 | Under Investigation | |
12029 | 12029 | #22-02122 | FIGHT | 2022 | 2022-09-10 01:12:00 | DELTA CHI FRATERNITY | BELMAR AVE, MORGANTOWN, WV 26501 | Under Investigation |
11368 | 11368 | #22-01601 | FIGHT | 2022 | 2022-07-26 15:00:00 | COLLEGE PARK | NEWTON AVE, MORGANTOWN, WV | Under Investigation |
10761 | 10761 | #22-00958 | FIGHT | 2022 | 2022-04-06 22:38:00 | HIGH STREET CANTEEN | N HIGH ST, MORGANTOWN, WV | Under Investigation |
10130 | 10130 | #22-00269 | FIGHT | 2022 | 2022-01-29 00:34:00 | WVU BOREMAN RFL GARAGE | NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Under Investigation |
8752 | 8752 | #21-02610 | FIGHT | 2021 | 2021-09-18 15:25:00 | WVU STADIUM | 3 ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Under Investigation |
6433 | 6433 | #21-00150 | FIGHT | 2021 | 2021-01-23 00:19:00 | BELMAR AVE, MORGANTOWN, WV 26501 | Under Investigation |
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 );