crimelog
47 rows where outcome = "Clear by Citation", 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 |
|---|---|---|---|---|---|---|---|---|
| 15385 | 15385 | CRS23-01647 | ABCC VIOLATION | 2022 | 2022-08-15 00:22:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 15388 | 15388 | CRS23-01650 | ABCC VIOLATION | 2022 | 2022-08-15 00:16:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 15387 | 15387 | CRS23-01649 | ABCC VIOLATION | 2022 | 2022-08-15 00:11:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 11485 | 11485 | #22-01736 | ABCC VIOLATION | 2022 | 2022-08-13 22:39:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 11497 | 11497 | #22-01723 | ABCC VIOLATION | 2022 | 2022-08-13 00:25:00 | FIFE AVE, MORGANTOWN | Clear by Citation | |
| 11427 | 11427 | #22-01670 | ABCC VIOLATION | 2022 | 2022-08-06 00:04:00 | WVU UNIVERSITY PLACE NORTH | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Citation |
| 15386 | 15386 | CRS23-01648 | ABCC VIOLATION | 2022 | 2022-05-15 00:35:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 15378 | 15378 | CRS23-01640 | ABCC VIOLATION | 2022 | 2022-05-01 01:10:00 | PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 15379 | 15379 | CRS23-01641 | ABCC VIOLATION | 2022 | 2022-05-01 00:38:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 15380 | 15380 | CRS23-01642 | ABCC VIOLATION | 2022 | 2022-05-01 00:19:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 15377 | 15377 | CRS23-01639 | ABCC VIOLATION | 2022 | 2022-04-22 19:26:00 | PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 15375 | 15375 | CRS23-01637 | ABCC VIOLATION | 2022 | 2022-04-09 23:36:00 | PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 15376 | 15376 | CRS23-01638 | ABCC VIOLATION | 2022 | 2022-04-09 23:30:00 | PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 10725 | 10725 | #22-00926 | ABCC VIOLATION | 2022 | 2022-04-03 00:17:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 10616 | 10616 | #22-00805 | ABCC VIOLATION | 2022 | 2022-03-24 23:40:00 | HIGH STREET CANTEEN | N HIGH ST, MORGANTOWN, WV | Clear by Citation |
| 10587 | 10587 | #22-00783 | ABCC VIOLATION | 2022 | 2022-03-22 21:21:00 | HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 10232 | 10232 | #22-00397 | ABCC VIOLATION | 2022 | 2022-02-09 23:28:00 | PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 15374 | 15374 | CRS23-01636 | ABCC VIOLATION | 2022 | 2022-01-29 21:34:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 9993 | 9993 | #22-00144 | ABCC VIOLATION | 2022 | 2022-01-17 02:31:00 | WVU LIFE SCIENCES BUILDING | CAMPUS DR, MORGANTOWN, WV | Clear by Citation |
| 15394 | 15394 | CRS23-01657 | ABCC VIOLATION | 2022 | 2022-01-15 19:55:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 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 | |
| 9944 | 9944 | #22-00083 | ABCC VIOLATION | 2022 | 2022-01-13 01:25:00 | PROSPECT ST, MORGANTOWN, WV 26501 | 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 );