crimelog
2 rows where outcome = "Active" and title = "PETIT LARCENY, STPL" sorted by datetime descending
This data as json, CSV (advanced)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
12169 | 12169 | #22-02445 | PETIT LARCENY, STPL | 2022 | 2022-10-01 00:12:00 | WVU DADISMAN HALL | NORTH HIGH ST, MORGANTOWN, WV | Active |
3220 | 3220 | #BC20-00061 | PETIT LARCENY, STPL | 2020 | 2020-06-04 19:16:00 | 390 SOUTH KANAWHA STREET, BECKLEY, WV 25801 | Active |
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 );