crimelog
5 rows where title = "SHOTS HEARD" sorted by datetime descending
This data as json, CSV (advanced)
Suggested facets: datetime (date)
outcome 3 ✖
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
17071 | 17071 | 24-00087 | SHOTS HEARD | 2024 | 2024-01-12 11:43:00 | EVANSDALE AREA | 1 EVANSDALE AREA, MORGANTOWN, WV 26501 | Closed - Resolved |
11335 | 11335 | #22-01574 | SHOTS HEARD | 2022 | 2022-07-23 02:24:00 | WVU KNAPP HALL | BEECHURST AVE, MORGANTOWN, WV | Inactive |
10102 | 10102 | #22-00250 | SHOTS HEARD | 2022 | 2022-01-27 10:08:00 | WVU GASKINS HOUSE | NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
3430 | 3430 | #20-01887 | SHOTS HEARD | 2020 | 2020-07-22 13:57:00 | COLLEGE PARK | 60 NEWTON AVE, MORGANTOWN, WV | Closed - Resolved |
2763 | 2763 | #20-01165 | SHOTS HEARD | 2020 | 2020-03-06 01:23:00 | WVU LINCOLN HALL | 1014 RAWLEY 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 );