crimelog
13 rows where outcome = "Active" and title = "INFORMATION REPORT" sorted by datetime descending
This data as json, CSV (advanced)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
11537 | 11537 | #22-01781 | INFORMATION REPORT | 2022 | 2022-08-16 13:02:00 | WVU CHILD CARE CENTER | LAUREL ST, MORGANTOWN, WV | Active |
10996 | 10996 | #22-01206 | INFORMATION REPORT | 2022 | 2022-05-05 12:30:00 | WVU POLICE DEPARTMENT | ELMER PRINCE DR, MORGANTOWN, WV | Active |
10337 | 10337 | #22-00396 | INFORMATION REPORT | 2022 | 2022-02-09 20:17:00 | Elmer Prince Dr, MORGANTOWN, WV 26501 | Active | |
8560 | 8560 | #21-02395 | INFORMATION REPORT | 2021 | 2021-09-02 16:22:00 | WVU POLICE DEPARTMENT | 992 ELMER PRINCE DR, MORGANTOWN, WV | Active |
7471 | 7471 | #21-01112 | INFORMATION REPORT | 2021 | 2021-04-07 15:30:00 | WVU POLICE DEPARTMENT | 992 ELMER PRINCE DR, MORGANTOWN, WV | Active |
5993 | 5993 | #20-03520 | INFORMATION REPORT | 2020 | 2020-12-01 14:08:00 | EVANSDALE DR, MORGANTOWN, WV 26501 | Active | |
3363 | 3363 | #20-01814 | INFORMATION REPORT | 2020 | 2020-07-08 14:34:00 | COLLEGE PARK | 60 NEWTON AVE, MORGANTOWN, WV | Active |
3042 | 3042 | #20-01479 | INFORMATION REPORT | 2020 | 2020-04-24 12:04:00 | WVU POLICE DEPARTMENT | 992 ELMER PRINCE DR, MORGANTOWN, WV | Active |
1970 | 1970 | #20-00254 | INFORMATION REPORT | 2020 | 2020-01-19 14:58:00 | WVU LYON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Active |
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 );