crimelog
10 rows where outcome = "Active" and title = "FIRE ALARM" sorted by datetime descending
This data as json, CSV (advanced)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
12317 | 12317 | #SR22-02578 | FIRE ALARM | 2022 | 2022-10-13 09:45:00 | WVU BOREMAN NORTH | NORTH HIGH ST, MORGANTOWN, WV 26501 | Active |
8314 | 8314 | #21-02113 | FIRE ALARM | 2021 | 2021-08-14 12:41:00 | WVU REC CENTER | 2001 REC CENTER DR, MORGANTOWN, WV 26501 | Active |
6620 | 6620 | #21-00370 | FIRE ALARM | 2021 | 2021-02-11 10:30:00 | WVU MINERAL RESOURCES BUILDING | 401 EVANSDALE DR, MORGANTOWN, WV | Active |
3371 | 3371 | #20-01845 | FIRE ALARM | 2020 | 2020-07-12 20:03:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Active |
3211 | 3211 | #20-01660 | FIRE ALARM | 2020 | 2020-06-10 15:33:00 | WVU BOOK DEPOSITORY | 1111 POULTRY FARM RD, MORGANTOWN | Active |
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 );