crimelog
7 rows where building = "ALPHA SIGMA PHI FRATERNITY" and outcome = "Clear by Warning"
This data as json, CSV (advanced)
Suggested facets: datetime (date)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 185 | 185 | #19-05242 | ABCC VIOLATION | 2019 | 2019-12-06 23:52:00 | ALPHA SIGMA PHI FRATERNITY | 200 BELMAR AVE, MORGANTOWN, WV 26501 | Clear by Warning |
| 680 | 680 | #19-04723 | ABCC VIOLATION | 2019 | 2019-11-02 01:05:00 | ALPHA SIGMA PHI FRATERNITY | 200 BELMAR AVE, MORGANTOWN, WV 26501 | Clear by Warning |
| 3337 | 3337 | #20-01798 | PARTY/GATHERING | 2020 | 2020-07-05 01:15:00 | ALPHA SIGMA PHI FRATERNITY | 200 BELMAR AVE, MORGANTOWN, WV 26501 | Clear by Warning |
| 7332 | 7332 | #21-01102 | IMPROPER USE OF A ROOF | 2021 | 2021-04-06 17:34:00 | ALPHA SIGMA PHI FRATERNITY | 200 BELMAR AVE, MORGANTOWN, WV 26501 | Clear by Warning |
| 9708 | 9708 | #21-03570 | ABCC VIOLATION | 2021 | 2021-12-09 02:29:00 | ALPHA SIGMA PHI FRATERNITY | BELMAR AVE, MORGANTOWN, WV 26501 | Clear by Warning |
| 10521 | 10521 | #22-00674 | ABCC VIOLATION | 2022 | 2022-03-10 01:02:00 | ALPHA SIGMA PHI FRATERNITY | BELMAR AVE, MORGANTOWN, WV 26501 | Clear by Warning |
| 17734 | 17734 | 24-00769 | ABCC VIOLATION | 2024 | 2024-03-07 01:00:00 | ALPHA SIGMA PHI FRATERNITY | 200 BELMAR AVE, MORGANTOWN, WV 26501 | Clear by Warning |
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 );