crimelog
7 rows where title = "BREAKING AND ENTERING" and year = 2019 sorted by datetime descending
This data as json, CSV (advanced)
Suggested facets: datetime, building, address, datetime (date)
outcome 3 ✖
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
254 | 254 | #19-05166 | BREAKING AND ENTERING | 2019 | 2019-12-03 08:41:00 | WVU MINERAL RESOURCES BUILDING | 401 EVANSDALE DR, MORGANTOWN, WV | Closed - Unresolved |
281 | 281 | #19-05139 | BREAKING AND ENTERING | 2019 | 2019-11-22 12:00:00 | WVU AGRICULTURAL SCIENCES BLDG | 101 RESEARCH WAY, MORGANTOWN, WV | Inactive |
251 | 251 | #19-05169 | BREAKING AND ENTERING | 2019 | 2019-11-22 00:00:00 | WVU ENGINEERING SCIENCES BLDG | 395 EVANSDALE DR, MORGANTOWN, WV | Inactive |
259 | 259 | #19-05161 | BREAKING AND ENTERING | 2019 | 2019-11-22 00:00:00 | WVU AGRICULTURAL SCIENCES BLDG | 101 RESEARCH WAY, MORGANTOWN, WV | Inactive |
503 | 503 | #19-04906 | BREAKING AND ENTERING | 2019 | 2019-11-10 19:30:00 | WVU ORGANIC FARM | 0 ORCHARD ROAD BYP, MORGANTOWN, WV 26501 | Inactive |
670 | 670 | #19-04733 | BREAKING AND ENTERING | 2019 | 2019-11-02 10:37:00 | WVU MOUNTAINLAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Arrest |
129 | 129 | #19-05300 | BREAKING AND ENTERING | 2019 | 2019-11-02 00:00:00 | WVU ALLEN HALL | 355 OAKLAND ST, MORGANTOWN, WV | 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 );