crimelog
7 rows where outcome = "Closed - Resolved", title = "ABCC VIOLATION" and year = 2020 sorted by id
This data as json, CSV (advanced)
Suggested facets: building, address, datetime (date)
Link | rowid | id ▼ | title | year | datetime | building | address | outcome |
---|---|---|---|---|---|---|---|---|
2012 | 2012 | #20-00484 | ABCC VIOLATION | 2020 | 2020-01-31 23:58:00 | WVU BROOKE TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
2706 | 2706 | #20-01226 | ABCC VIOLATION | 2020 | 2020-03-07 23:05:00 | WVU BROOKE TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
2975 | 2975 | #20-01420 | ABCC VIOLATION | 2020 | 2020-03-07 18:02:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
3061 | 3061 | #20-01513 | ABCC VIOLATION | 2020 | 2020-05-05 22:08:00 | SIGMA ALPHA EPSILON FRATERNITY | 117 BELMAR AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
4311 | 4311 | #20-02425 | ABCC VIOLATION | 2020 | 2020-09-04 23:12:00 | WVU MOUNTAINLAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Closed - Resolved |
5249 | 5249 | #20-03182 | ABCC VIOLATION | 2020 | 2020-10-29 00:03:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
5459 | 5459 | #20-03378 | ABCC VIOLATION | 2020 | 2020-11-13 01:06:00 | WVU SUMMIT HALL | 211 GRANT 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 );