crimelog
6 rows where "datetime" is on date 2022-02-22 and year = 2022
This data as json, CSV (advanced)
Suggested facets: title, outcome, datetime (date)
Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
---|---|---|---|---|---|---|---|---|
10344 | 10344 | #22-00510 | FIRE ALARM | 2022 | 2022-02-22 20:47:00 | WVU UNIVERSITY PLACE TOWNHOMES NORTH | GRANT AVE, MORGANTOWN, WV 26501 | Report only |
10345 | 10345 | #22-00508 | ALARM CONDITION | 2022 | 2022-02-22 13:18:00 | WVU STUDENT HEALTH BUILDING | BIRCH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
10346 | 10346 | #22-00507 | UNSECURE BUILDING | 2022 | 2022-02-22 11:24:00 | WVU UNIVERSITY PARK APARTMENTS - WEST | OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Lack of leads |
10347 | 10347 | #22-00506 | TRAFFIC STOP, 1054 | 2022 | 2022-02-22 10:05:00 | HARDING AVE, MORGANTOWN | Clear by Warning | |
10348 | 10348 | #22-00505 | FIRE ALARM | 2022 | 2022-02-22 00:48:00 | HEALTH SCIENCE CENTER | MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
10414 | 10414 | #22-00509 | PETIT LARCENY, STPL | 2022 | 2022-02-22 17:06:00 | WVU MOUNTAINEER STATION | VAN VOORHIS RD, MORGANTOWN, WV | Under Investigation |
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 );