crimelog
5 rows where outcome = "Inactive", title = "LOST PROPERTY" and year = 2020
This data as json, CSV (advanced)
Suggested facets: datetime (date)
Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
---|---|---|---|---|---|---|---|---|
1560 | 1560 | #20-00012 | LOST PROPERTY | 2020 | 2020-01-03 18:16:00 | WVU WHITE HALL | 135 WILLEY ST, MORGANTOWN, WV 26501 | Inactive |
1667 | 1667 | #20-00129 | LOST PROPERTY | 2020 | 2020-01-14 00:01:00 | WVU ALLEN HALL | 355 OAKLAND ST, MORGANTOWN, WV | Inactive |
1999 | 1999 | #20-00497 | LOST PROPERTY | 2020 | 2020-02-01 15:08:00 | WVU COLISEUM | 11 JERRY WEST DR, MORGANTOWN, WV 26501 | Inactive |
2446 | 2446 | #20-00847 | LOST PROPERTY | 2020 | 2020-02-20 00:00:00 | 345 HIGH ST, MORGANTOWN, WV 26501 | Inactive | |
4353 | 4353 | #20-02467 | LOST PROPERTY | 2020 | 2020-09-07 01:53:00 | WVU ELIZABETH MOORE HALL | 1507 UNIVERSITY AVE, MORGANTOWN, WV | Inactive |
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 );