crimelog
7 rows where outcome = "Clear by Arrest", title = "ABCC VIOLATION" and year = 2019
This data as json, CSV (advanced)
Suggested facets: building, datetime (date)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 67 | 67 | #19-05365 | ABCC VIOLATION | 2019 | 2019-12-14 00:16:00 | WVU MOUNTAINLAIR PARKING GARAGE | 109 PROSPECT ST, MORGANTOWN, WV | Clear by Arrest |
| 82 | 82 | #19-05350 | ABCC VIOLATION | 2019 | 2019-12-13 03:00:00 | CAMPUS DR / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Arrest | |
| 531 | 531 | #19-04878 | ABCC VIOLATION | 2019 | 2019-11-09 21:14:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Arrest |
| 711 | 711 | #19-04692 | ABCC VIOLATION | 2019 | 2019-11-01 00:40:00 | NORTH HIGH ST / PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Arrest | |
| 820 | 820 | #19-04580 | ABCC VIOLATION | 2019 | 2019-10-26 02:08:00 | WVU MOUNTAINLAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Arrest |
| 1222 | 1222 | #19-04161 | ABCC VIOLATION | 2019 | 2019-10-05 04:11:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Arrest |
| 1459 | 1459 | #19-03919 | ABCC VIOLATION | 2019 | 2019-09-20 22:48:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Arrest |
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 );