crimelog
7 rows where outcome = "Cleared by Exception - Prosecution Declined" and year = 2020
This data as json, CSV (advanced)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 1844 | 1844 | #20-00319 | LARCENY | 2020 | 2020-01-22 00:00:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Cleared by Exception - Prosecution Declined |
| 2459 | 2459 | #20-00801 | LARCENY | 2020 | 2020-02-18 14:27:00 | WVU PRT MAINTENANCE | 99 EIGHTH ST, MORGANTOWN, WV 26501 | Cleared by Exception - Prosecution Declined |
| 2740 | 2740 | #20-01189 | TRAFFIC STOP, 1054 | 2020 | 2020-03-06 14:45:00 | VAN VOORHIS RD, MORGANTOWN, WV 26501 | Cleared by Exception - Prosecution Declined | |
| 2751 | 2751 | #20-01177 | TRAFFIC STOP, 1054 | 2020 | 2020-03-06 11:10:00 | PATTESON DR, MORGANTOWN, WV 26501 | Cleared by Exception - Prosecution Declined | |
| 3729 | 3729 | #20-02130 | DESTRUCTION OF PROPERTY | 2020 | 2020-08-20 00:39:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Cleared by Exception - Prosecution Declined |
| 5090 | 5090 | #PS20-01120 | ASSAULT | 2020 | 2020-10-04 13:23:00 | PSC UNIVERSITY PLACE | 20 ARNOLD ST, KEYSER, WV 26726 | Cleared by Exception - Prosecution Declined |
| 6114 | 6114 | #PS20-01439 | DOMESTIC DISPUTE | 2020 | 2020-12-27 16:36:00 | Arnold St, Keyser, WV 26726 | Cleared by Exception - Prosecution Declined |
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 );