crimelog
6 rows where outcome = "Inactive" and title = "PUBLIC INTOX" sorted by datetime descending
This data as json, CSV (advanced)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
4253 | 4253 | #20-02384 | PUBLIC INTOX | 2020 | 2020-09-02 01:39:00 | WVU KNAPP HALL | 29 BEECHURST AVE, MORGANTOWN, WV | Inactive |
3261 | 3261 | #20-01720 | PUBLIC INTOX | 2020 | 2020-06-21 01:38:00 | WVU Area 1 (White Hall) | 39.632691, -79.955148 | Inactive |
1886 | 1886 | #20-00346 | PUBLIC INTOX | 2020 | 2020-01-25 02:44:00 | WVU OAKLAND HALL-WEST | 438 OAKLAND ST, MORGANTOWN, WV 26501 | Inactive |
549 | 549 | #19-04858 | PUBLIC INTOX | 2019 | 2019-11-09 12:14:00 | WVU STADIUM | 3 ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Inactive |
712 | 712 | #19-04691 | PUBLIC INTOX | 2019 | 2019-11-01 00:42:00 | WVU SENECA HALL | 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Inactive |
948 | 948 | #19-04446 | PUBLIC INTOX | 2019 | 2019-10-20 02:20:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | 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 );