crimelog
221 rows where title = "ABCC VIOLATION" and year = 2022 sorted by datetime descending
This data as json, CSV (advanced)
outcome 3 ✖
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
10058 | 10058 | #22-00204 | ABCC VIOLATION | 2022 | 2022-01-21 23:25:00 | WVU MOUNTAINLAIR | UNIVERSITY AVE, MORGANTOWN, WV | Clear by Warning |
10059 | 10059 | #22-00203 | ABCC VIOLATION | 2022 | 2022-01-21 23:09:00 | WVU DADISMAN HALL | NORTH HIGH ST, MORGANTOWN, WV | Clear by Warning |
10060 | 10060 | #22-00202 | ABCC VIOLATION | 2022 | 2022-01-21 21:45:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning | |
10066 | 10066 | #22-00196 | ABCC VIOLATION | 2022 | 2022-01-21 01:46:00 | WVU BROOKE TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Warning |
10039 | 10039 | #22-00183 | ABCC VIOLATION | 2022 | 2022-01-20 01:22:00 | WVU STALNAKER HALL | NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
10040 | 10040 | #22-00182 | ABCC VIOLATION | 2022 | 2022-01-20 01:22:00 | NORTH HIGH ST, MORGANTOWN, WV 26505 | Clear by Warning | |
9991 | 9991 | #22-00146 | ABCC VIOLATION | 2022 | 2022-01-17 04:12:00 | WVU OAKLAND HALL-EAST | OAKLAND ST, MORGANTOWN, WV 26501 | Clear by Warning |
9993 | 9993 | #22-00144 | ABCC VIOLATION | 2022 | 2022-01-17 02:31:00 | WVU LIFE SCIENCES BUILDING | CAMPUS DR, MORGANTOWN, WV | Clear by Citation |
9992 | 9992 | #22-00145 | ABCC VIOLATION | 2022 | 2022-01-17 00:38:00 | WVU DADISMAN HALL | NORTH HIGH ST, MORGANTOWN, WV | Clear by Warning |
9954 | 9954 | #22-00130 | ABCC VIOLATION | 2022 | 2022-01-16 02:15:00 | WVU OAKLAND HALL | OAKLAND ST, MORGANTOWN, WV 26501 | Clear by Warning |
15394 | 15394 | CRS23-01657 | ABCC VIOLATION | 2022 | 2022-01-15 19:55:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
9965 | 9965 | #22-00118 | ABCC VIOLATION | 2022 | 2022-01-15 01:09:00 | WVU BROOKE TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Warning |
9964 | 9964 | #22-00119 | ABCC VIOLATION | 2022 | 2022-01-15 01:05:00 | NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Clear by Warning | |
9966 | 9966 | #22-00117 | ABCC VIOLATION | 2022 | 2022-01-15 00:57:00 | WVU BROOKE TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Warning |
15373 | 15373 | CRS23-01635 | ABCC VIOLATION | 2022 | 2022-01-15 00:12:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
9969 | 9969 | #22-00114 | ABCC VIOLATION | 2022 | 2022-01-14 23:24:00 | WVU DADISMAN HALL | NORTH HIGH ST, MORGANTOWN, WV | Clear by Citation |
9972 | 9972 | #22-00111 | ABCC VIOLATION | 2022 | 2022-01-14 22:20:00 | PROSPECT ST, MORGANTOWN | Clear by Citation | |
9984 | 9984 | #22-00099 | ABCC VIOLATION | 2022 | 2022-01-14 00:15:00 | WVU BOREMAN SOUTH | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
9944 | 9944 | #22-00083 | ABCC VIOLATION | 2022 | 2022-01-13 01:25:00 | PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Citation | |
9895 | 9895 | #22-00045 | ABCC VIOLATION | 2022 | 2022-01-09 01:49:00 | WVU BRAXTON TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Warning |
9855 | 9855 | #22-00005 | ABCC VIOLATION | 2022 | 2022-01-01 03:52:00 | WVU Area 1 (White Hall) | 39.632691, -79.955148 | 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 );