crimelog
8 rows where title = "ELEVATOR RESCUE" and year = 2020
This data as json, CSV (advanced)
Suggested facets: building, address, datetime (date)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 1664 | 1664 | #20-00132 | ELEVATOR RESCUE | 2020 | 2020-01-14 18:00:00 | WVU UNIVERSITY PLACE PARKING GARAGE | 2154 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 2734 | 2734 | #20-01195 | ELEVATOR RESCUE | 2020 | 2020-03-06 21:00:00 | WVU OAKLAND HALL-WEST | 438 OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 2799 | 2799 | #20-01298 | ELEVATOR RESCUE | 2020 | 2020-03-12 23:38:00 | WVU BRAXTON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 3705 | 3705 | #20-02103 | ELEVATOR RESCUE | 2020 | 2020-08-18 22:09:00 | WVU SENECA HALL | 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 3759 | 3759 | #20-02209 | ELEVATOR RESCUE | 2020 | 2020-08-22 23:13:00 | WVU OAKLAND HALL-WEST | 438 OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 4280 | 4280 | #20-02456 | ELEVATOR RESCUE | 2020 | 2020-09-06 04:00:00 | WVU UNIVERSITY PLACE PARKING GARAGE | 2154 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 4693 | 4693 | #20-02848 | ELEVATOR RESCUE | 2020 | 2020-09-29 19:46:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 5479 | 5479 | #20-03445 | ELEVATOR RESCUE | 2020 | 2020-11-18 22:56:00 | WVU BROOKE TOWER | 356 EVANSDALE 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 );