crimelog
123 rows where outcome = "Clear by Warning", title = "ABCC VIOLATION" and year = 2022 sorted by datetime descending
This data as json, CSV (advanced)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
10272 | 10272 | #22-00410 | ABCC VIOLATION | 2022 | 2022-02-11 00:17:00 | WVU Area 1 (White Hall) | 39.632691, -79.955148 | Clear by Warning |
10183 | 10183 | #22-00357 | ABCC VIOLATION | 2022 | 2022-02-06 01:07:00 | WVU MOUNTAINLAIR | UNIVERSITY AVE, MORGANTOWN, WV | Clear by Warning |
10184 | 10184 | #22-00356 | ABCC VIOLATION | 2022 | 2022-02-05 21:56:00 | WVU HONORS HALL | SECOND ST, MORGANTOWN, WV | Clear by Warning |
10201 | 10201 | #22-00338 | ABCC VIOLATION | 2022 | 2022-02-04 01:28:00 | WVU SUMMIT HALL | GRANT AVE, MORGANTOWN, WV 26501 | Clear by Warning |
10113 | 10113 | #22-00289 | ABCC VIOLATION | 2022 | 2022-01-30 01:44:00 | WVU BENNETT TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Warning |
10115 | 10115 | #22-00287 | ABCC VIOLATION | 2022 | 2022-01-30 00:52:00 | WVU MOUNTAINLAIR | UNIVERSITY AVE, MORGANTOWN, WV | Clear by Warning |
10129 | 10129 | #22-00270 | ABCC VIOLATION | 2022 | 2022-01-29 01:02:00 | WVU SENECA HALL | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning |
10094 | 10094 | #22-00258 | ABCC VIOLATION | 2022 | 2022-01-27 23:44:00 | WVU STALNAKER HALL | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
10056 | 10056 | #22-00206 | ABCC VIOLATION | 2022 | 2022-01-22 01:34:00 | WVU MOUNTAINLAIR | UNIVERSITY AVE, MORGANTOWN, WV | Clear by Warning |
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 |
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 |
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 |
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 |
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 |
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 );