crimelog
6 rows where outcome = "Under Investigation", title = "HIT AND RUN" and year = 2023 sorted by datetime descending
This data as json, CSV (advanced)
Suggested facets: building, datetime (date)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
16804 | 16804 | 23-03516 | HIT AND RUN | 2023 | 2023-11-30 12:02:00 | 246 FIFE AVE, MORGANTOWN, WV 26501 | Under Investigation | |
16802 | 16802 | 23-03492 | HIT AND RUN | 2023 | 2023-11-28 14:32:00 | WILLEY ST, MORGANTOWN, WV 26501 | Under Investigation | |
16323 | 16323 | 23-02958 | HIT AND RUN | 2023 | 2023-10-15 03:06:00 | SIGMA CHI FRATERNITY | 700 NORTH HIGH ST, MORGANTOWN, WV 26501 | Under Investigation |
16082 | 16082 | 23-02775 | HIT AND RUN | 2023 | 2023-09-26 11:31:00 | WVU SHORT TERM 2 (MOUNTAINLAIR) | 39.634049, -79.953009, MORGANTOWN, WV 26501 | Under Investigation |
14229 | 14229 | #23-01110 | HIT AND RUN | 2023 | 2023-04-14 15:13:00 | NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Under Investigation | |
13827 | 13827 | #23-00660 | HIT AND RUN | 2023 | 2023-02-22 13:19:00 | WVU Area 35 (Vandalia Garage) | 39.638093, -79.951677, MORGANTOWN | 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 );