crimelog
10 rows where title = "LITTERING" sorted by datetime descending
This data as json, CSV (advanced)
outcome 5 ✖
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
12586 | 12586 | #22-02924 | LITTERING | 2022 | 2022-11-06 20:22:00 | 117 BELMAR AVE, MORGANTOWN | Closed - Resolved | |
11839 | 11839 | #22-02093 | LITTERING | 2022 | 2022-09-08 05:19:00 | BELMAR AVE, MORGANTOWN, WV 26501 | Under Investigation | |
9318 | 9318 | #21-03182 | LITTERING | 2021 | 2021-11-02 17:21:00 | WVU Area 46 (Green House, Annex & Percival) | 39.644042, -79.970400 | Closed - Resolved |
7003 | 7003 | #21-00780 | LITTERING | 2021 | 2021-03-17 14:55:00 | PANERA BREAD - WILLEY ST | 207 WILLEY ST, MORGANTOWN, WV 26501 | Clear by Citation |
5476 | 5476 | #20-03427 | LITTERING | 2020 | 2020-11-17 00:03:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Lack of leads |
4252 | 4252 | #20-02385 | LITTERING | 2020 | 2020-09-02 01:10:00 | WVU BOREMAN NORTH | 602 NORTH HIGH ST, MORGANTOWN, WV 26501 | Forward to Investigations |
3596 | 3596 | #20-02005 | LITTERING | 2020 | 2020-08-11 01:15:00 | SIGMA NU FRATERNITY | 617 NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Closed - Resolved |
1405 | 1405 | #19-03973 | LITTERING | 2019 | 2019-09-24 12:10:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation |
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 );