crimelog
9 rows where outcome = "Clear by Citation" and title = "TRESPASSING"
This data as json, CSV (advanced)
Suggested facets: year, datetime (date)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 416 | 416 | #19-04995 | TRESPASSING | 2019 | 2019-11-16 07:40:00 | IHOP - OAKLAND HALL | 475 OAKLAND ST, MORGANTOWN, WV | Clear by Citation |
| 1701 | 1701 | #20-00157 | TRESPASSING | 2020 | 2020-01-16 05:35:00 | WVU ONE WATERFRONT PLACE | 1 WATERFRONT PL, MORGANTOWN, WV | Clear by Citation |
| 3718 | 3718 | #20-02141 | TRESPASSING | 2020 | 2020-08-20 13:32:00 | WVU FACILITIES MANAGEMENT BUILDING | 975 RAWLEY LN, MORGANTOWN, WV | Clear by Citation |
| 6530 | 6530 | #21-00223 | TRESPASSING | 2021 | 2021-01-29 11:22:00 | WVU BOOKSTORE | 1501 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Citation |
| 6669 | 6669 | #21-00465 | TRESPASSING | 2021 | 2021-02-23 08:05:00 | WVU MARINA TOWERS | 48 DONLEY ST, MORGANTOWN, WV 26501 | Clear by Citation |
| 9658 | 9658 | #21-03493 | TRESPASSING | 2021 | 2021-12-03 03:08:00 | HEALTH SCIENCE CENTER | MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Clear by Citation |
| 12138 | 12138 | #22-02409 | TRESPASSING | 2022 | 2022-09-28 13:04:00 | WVU WHITE HALL | WILLEY ST, MORGANTOWN, WV 26501 | Clear by Citation |
| 16686 | 16686 | 23-03398 | TRESPASSING | 2023 | 2023-11-16 13:23:00 | WVU LIFE SCIENCES BUILDING | 53 CAMPUS DR, MORGANTOWN, WV | Clear by Citation |
| 16807 | 16807 | 23-03520 | TRESPASSING | 2023 | 2023-11-30 22:02:00 | COLLEGE PARK | 60 NEWTON AVE, MORGANTOWN, WV | Clear by Citation |
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 );