crimelog
9 rows where outcome = "Cleared by Exception - Prosecution Declined" and year = 2023
This data as json, CSV (advanced)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 13310 | 13310 | #23-00205 | PETIT LARCENY, STPL | 2023 | 2023-01-23 15:58:00 | HIGH STREET CANTEEN, MORGANTOWN | Cleared by Exception - Prosecution Declined | |
| 13541 | 13541 | #23-00436 | BURGLARY | 2023 | 2023-02-10 18:36:00 | WVU SUMMIT HALL | GRANT AVE, MORGANTOWN, WV 26501 | Cleared by Exception - Prosecution Declined |
| 14456 | 14456 | #23-01408 | SUSPICIOUS EVENT | 2023 | 2023-05-12 11:05:00 | MOUNTAIN LAIR | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Cleared by Exception - Prosecution Declined |
| 14864 | 14864 | 23-01507 | DESTRUCTION OF PROPERTY | 2023 | 2023-06-01 04:22:00 | WVU MOUNTAINEER STATION | 1112 VAN VOORHIS RD, MORGANTOWN, WV | Cleared by Exception - Prosecution Declined |
| 15255 | 15255 | 23-02045 | ABCC VIOLATION | 2023 | 2023-08-15 06:09:00 | WVU LIFE SCIENCES BUILDING | 53 CAMPUS DR, MORGANTOWN, WV | Cleared by Exception - Prosecution Declined |
| 15261 | 15261 | 23-02055 | ABCC VIOLATION | 2023 | 2023-08-15 19:10:00 | WVU PRT STATION-BEECHURST AVE | 96 BEECHURST AVE, MORGANTOWN, WV 26501 | Cleared by Exception - Prosecution Declined |
| 15871 | 15871 | 23-02569 | DOMESTIC DISPUTE | 2023 | 2023-09-16 19:18:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Cleared by Exception - Prosecution Declined |
| 15950 | 15950 | 23-02572 | BATTERY | 2023 | 2023-09-16 19:35:00 | BLUE LOT | 0 STADIUM DR, MORGANTOWN, WV | Cleared by Exception - Prosecution Declined |
| 16146 | 16146 | 23-02842 | LARCENY | 2023 | 2023-10-02 11:56:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | 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 );