crimelog
3 rows where outcome = "Closed - Unresolved" and title = "BURGLARY"
This data as json, CSV (advanced)
Suggested facets: year, datetime (date)
Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
---|---|---|---|---|---|---|---|---|
1367 | 1367 | #19-04011 | BURGLARY | 2019 | 2019-09-26 18:30:00 | 117 BELMAR AVE, MORGANTOWN, WV 26501 | Closed - Unresolved | |
1505 | 1505 | #19-05396 | BURGLARY | 2019 | 2019-12-06 02:40:00 | 780 NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Closed - Unresolved | |
1685 | 1685 | #20-00143 | BURGLARY | 2020 | 2020-01-15 15:23:00 | 801 PRICE ST, MORGANTOWN, WV 26501 | Closed - Unresolved |
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 );