crimelog
7 rows where title = "PUBLIC INTOX" and year = 2024 sorted by datetime descending
This data as json, CSV (advanced)
Suggested facets: building, datetime (date)
outcome 4 ✖
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
18269 | 18269 | 24-01321 | PUBLIC INTOX | 2024 | 2024-04-28 01:17:00 | WVU SENECA HALL | 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
18180 | 18180 | 24-01229 | PUBLIC INTOX | 2024 | 2024-04-20 03:02:00 | WVU WHITE HALL | 135 WILLEY ST, MORGANTOWN, WV 26501 | Closed - Resolved |
18057 | 18057 | 24-01119 | PUBLIC INTOX | 2024 | 2024-04-14 01:14:00 | WVU STALNAKER HALL | 691 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
17921 | 17921 | 24-00967 | PUBLIC INTOX | 2024 | 2024-03-31 15:26:00 | WVU MOUNTAINLAIR PARKING GARAGE | 109 PROSPECT ST, MORGANTOWN, WV | Clear by Arrest |
17645 | 17645 | 24-00690 | PUBLIC INTOX | 2024 | 2024-03-03 03:05:00 | NORTH HIGH ST, MORGANTOWN | Clear by Warning | |
17629 | 17629 | 24-00667 | PUBLIC INTOX | 2024 | 2024-03-02 15:40:00 | PROSPECT ST / SPRUCE ST, MORGANTOWN, WV 26501 | Closed - Resolved | |
17626 | 17626 | 24-00664 | PUBLIC INTOX | 2024 | 2024-03-02 02:03:00 | WVU MOUNTAINLAIR | 1550 UNIVERSITY 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 );