crimelog
5 rows where outcome = "Vehicle- NOT Impounded" and title = "PARKING COMPLAINT" sorted by datetime descending
This data as json, CSV (advanced)
Suggested facets: building, datetime (date)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
9221 | 9221 | #21-03061 | PARKING COMPLAINT | 2021 | 2021-10-25 08:51:00 | WVU UNIVERSITY PARK APARTMENTS - NORTH | OAKLAND ST, MORGANTOWN, WV 26501 | Vehicle- NOT Impounded |
2279 | 2279 | #20-00744 | PARKING COMPLAINT | 2020 | 2020-02-15 10:41:00 | WVU SHORT TERM 4 (REC CENTER) | 39.647516,-79.971475, MORGANTOWN, WV 26501 | Vehicle- NOT Impounded |
2155 | 2155 | #20-00672 | PARKING COMPLAINT | 2020 | 2020-02-10 08:21:00 | COLLEGE PARK | 60 NEWTON AVE, MORGANTOWN, WV | Vehicle- NOT Impounded |
1688 | 1688 | #20-00139 | PARKING COMPLAINT | 2020 | 2020-01-15 09:18:00 | WVU UNIVERSITY PARK APARTMENTS - NORTH | 475 OAKLAND ST, MORGANTOWN, WV 26501 | Vehicle- NOT Impounded |
311 | 311 | #19-05105 | PARKING COMPLAINT | 2019 | 2019-11-22 10:18:00 | MAIDEN LN, MORGANTOWN, WV 26501 | Vehicle- NOT Impounded |
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 );