crimelog
4 rows where outcome = "Unfounded" and title = "LOUD NOISE" sorted by datetime descending
This data as json, CSV (advanced)
Suggested facets: datetime (date)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
13447 | 13447 | #23-00337 | LOUD NOISE | 2023 | 2023-02-04 01:25:00 | FRAT ROW | N HIGH ST, MORGANTOWN, WV | Unfounded |
11808 | 11808 | #22-02057 | LOUD NOISE | 2022 | 2022-09-05 01:17:00 | FIFE AVE, MORGANTOWN | Unfounded | |
7241 | 7241 | #21-00964 | LOUD NOISE | 2021 | 2021-03-26 23:14:00 | PI KAPPA PHI FRATERNITY | 650 NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Unfounded |
975 | 975 | #19-04419 | LOUD NOISE | 2019 | 2019-10-18 22:47:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Unfounded |
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 );