crimelog
4 rows where outcome = "Closed - Resolved", title = "THREATS" and year = 2021
This data as json, CSV (advanced)
Suggested facets: building, datetime (date)
Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
---|---|---|---|---|---|---|---|---|
9504 | 9504 | #21-03368 | THREATS | 2021 | 2021-11-17 12:33:00 | WVU PHYSICAL ACTIVITY AND SPORTS MEDICINE | BIRCH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
9678 | 9678 | #21-03554 | THREATS | 2021 | 2021-12-07 19:47:00 | WVU UNIVERSITY PLACE TOWNHOMES SOUTH | GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
9681 | 9681 | #21-03549 | THREATS | 2021 | 2021-12-07 10:17:00 | RICHARD HARRISON WAY, MORGANTOWN, WV 26501 | Closed - Resolved | |
9683 | 9683 | #21-03547 | THREATS | 2021 | 2021-12-07 08:02:00 | NEWTON AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
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 );