crimelog
152 rows where outcome = "Closed - Resolved" and title = "BURGLAR ALARM" sorted by datetime descending
This data as json, CSV (advanced)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
915 | 915 | #19-04483 | BURGLAR ALARM | 2019 | 2019-10-22 12:33:00 | WVU REC CENTER | 2001 REC CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
1098 | 1098 | #19-04290 | BURGLAR ALARM | 2019 | 2019-10-10 11:27:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
1194 | 1194 | #19-04190 | BURGLAR ALARM | 2019 | 2019-10-05 17:25:00 | WVU SUNCREST EXECUTIVE PLAZA 2 | 1075 VAN VOORHIS RD, MORGANTOWN, WV 26501 | Closed - Resolved |
1232 | 1232 | #19-04151 | BURGLAR ALARM | 2019 | 2019-10-05 00:28:00 | KAY CASTO & CHANEY | 1085 VAN VOORHIS RD UNIT 100, MORGANTOWN, WV 26501 | Closed - Resolved |
1269 | 1269 | #19-04113 | BURGLAR ALARM | 2019 | 2019-10-03 11:26:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, 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 );