crimelog
7 rows where "datetime" is on date 2022-10-20 and year = 2022
This data as json, CSV (advanced)
Suggested facets: title, building, outcome, datetime (date)
Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
---|---|---|---|---|---|---|---|---|
12415 | 12415 | #22-02705 | TRAFFIC STOP, 1054 | 2022 | 2022-10-20 21:28:00 | BEECHURST AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
12416 | 12416 | #22-02704 | TRAFFIC STOP, 1054 | 2022 | 2022-10-20 13:27:00 | PATTESON DR, MORGANTOWN, WV 26501 | Clear by Warning | |
12417 | 12417 | #22-02703 | EQUIPMENT CHECK | 2022 | 2022-10-20 10:34:00 | ELMER PRINCE DR, MORGANTOWN, WV 26501 | Closed - Resolved | |
12418 | 12418 | #22-02702 | LARCENY FROM A VEHICLE | 2022 | 2022-10-20 10:11:00 | WVU VANDALIA HALL GOLD | FALLING RUN RD, MORGANTOWN, WV 26501 | Closed - Lack of leads |
12419 | 12419 | #SR22-02701 | BACK TICKET TOW | 2022 | 2022-10-20 08:33:00 | WVU Area 17 (Ming Hsieh Hall) | 39.636516, -79.953109 | Closed - Resolved |
12420 | 12420 | #22-02700 | FIRE ALARM | 2022 | 2022-10-20 06:32:00 | 355 OAKLAND ST, MORGANTOWN | Closed - Resolved | |
12421 | 12421 | #22-02699 | FIRE ALARM | 2022 | 2022-10-20 05:09:00 | WVU ALLEN HALL | OAKLAND ST, MORGANTOWN, WV | 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 );