crimelog
8 rows where "datetime" is on date 2020-05-02
This data as json, CSV (advanced)
Suggested facets: title, building, outcome
Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
---|---|---|---|---|---|---|---|---|
3046 | 3046 | #20-01501 | PARTY/GATHERING | 2020 | 2020-05-02 22:59:00 | 310 SECOND ST UNIT A, MORGANTOWN, WV 26501 | Clear by Warning | |
3047 | 3047 | #20-01500 | ASSIST AGENCY | 2020 | 2020-05-02 21:10:00 | BEVERLY AVE, MORGANTOWN, WV 26501 | Closed - Resolved | |
3048 | 3048 | #20-01499 | PARTY/GATHERING | 2020 | 2020-05-02 20:10:00 | 565 PRICE ST UNIT 1, MORGANTOWN, WV 26501 | Clear by Warning | |
3049 | 3049 | #20-01498 | PARTY/GATHERING | 2020 | 2020-05-02 20:01:00 | KAPPA ALPHA FRATERNITY | 670 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
3050 | 3050 | #20-01497 | PARTY/GATHERING | 2020 | 2020-05-02 20:03:00 | SIGMA CHI FRATERNITY | 700 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
3051 | 3051 | #20-01496 | 56, SECH, SECURITY CHECK | 2020 | 2020-05-02 17:39:00 | 355 OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved | |
3052 | 3052 | #20-01495 | PARTY/GATHERING | 2020 | 2020-05-02 16:46:00 | 299 WILES ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3053 | 3053 | #20-01494 | FIRE ALARM | 2020 | 2020-05-02 12:38:00 | WVU UNIVERSITY PLACE TOWNHOMES NORTH | 256 GRANT AVE, 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 );