crimelog
12 rows where title = "DUI" and year = 2022 sorted by datetime descending
This data as json, CSV (advanced)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
12066 | 12066 | #22-02296 | DUI | 2022 | 2022-09-19 14:46:00 | WVU ORGANIC FARM | ORCHARD ROAD BYP, MORGANTOWN, WV 26501 | Clear by Arrest |
12050 | 12050 | #22-02268 | DUI | 2022 | 2022-09-17 13:50:00 | BLUE LOT | STADIUM DR, MORGANTOWN, WV | Clear by Arrest |
11983 | 11983 | #22-02248 | DUI | 2022 | 2022-09-17 01:39:00 | PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Arrest | |
10981 | 10981 | #22-01094 | DUI | 2022 | 2022-04-23 02:29:00 | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Arrest | |
10836 | 10836 | #22-01046 | DUI | 2022 | 2022-04-17 03:00:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Arrest | |
10724 | 10724 | #22-00927 | DUI | 2022 | 2022-04-03 01:52:00 | MAIDEN LN, MORGANTOWN, WV 26501 | Clear by Arrest | |
10627 | 10627 | #22-00792 | DUI | 2022 | 2022-03-24 02:06:00 | WVU LAW SCHOOL | LAW CENTER DR, MORGANTOWN, WV 26501 | Clear by Arrest |
10112 | 10112 | #22-00290 | DUI | 2022 | 2022-01-30 01:58:00 | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Arrest | |
10030 | 10030 | #22-00194 | DUI | 2022 | 2022-01-20 23:18:00 | CHESTNUT ST, MORGANTOWN, WV 26501 | Clear by Arrest | |
9979 | 9979 | #22-00104 | DUI | 2022 | 2022-01-14 02:41:00 | SIGMA CHI FRATERNITY | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Arrest |
9928 | 9928 | #22-00070 | DUI | 2022 | 2022-01-12 01:38:00 | VAN VOORHIS RD, MORGANTOWN, WV 26501 | Clear by Arrest | |
9929 | 9929 | #22-00036 | DUI | 2022 | 2022-01-08 01:51:00 | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Arrest |
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 );