crimelog
6 rows where outcome = "Clear by Citation" and title = "HIT AND RUN" sorted by datetime descending
This data as json, CSV (advanced)
Suggested facets: datetime (date)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
13640 | 13640 | #23-00498 | HIT AND RUN | 2023 | 2023-02-15 01:55:00 | WVU UNIVERSITY PLACE PARKING GARAGE | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation |
8962 | 8962 | #21-02782 | HIT AND RUN | 2021 | 2021-10-01 19:07:00 | WVU MOUNTAINLAIR | UNIVERSITY AVE, MORGANTOWN, WV | Clear by Citation |
5325 | 5325 | #20-03276 | HIT AND RUN | 2020 | 2020-11-05 09:53:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Citation |
3123 | 3123 | #20-01565 | HIT AND RUN | 2020 | 2020-05-19 22:42:00 | PRICE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
554 | 554 | #19-04852 | HIT AND RUN | 2019 | 2019-11-09 09:32:00 | WVU Area 201 (Law School/Stadium) | 39.646126, -79.955498, MORGANTOWN, WV | Clear by Citation |
1360 | 1360 | #19-04019 | HIT AND RUN | 2019 | 2019-09-27 11:59:00 | WVU SHORT TERM 10 (B&E LOOP) | 39.637487, -79.953285, MORGANTOWN, WV 26501 | Clear by Citation |
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 );