crimelog
10 rows where outcome = "Report only" and title = "SUSPICIOUS PERSON"
This data as json, CSV (advanced)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 7238 | 7238 | #21-00996 | SUSPICIOUS PERSON | 2021 | 2021-03-28 13:39:00 | WVU MOUNTAINLAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Report only |
| 7488 | 7488 | #21-01261 | SUSPICIOUS PERSON | 2021 | 2021-04-17 14:57:00 | ARBORETUM | 2002 MONONGAHELA BLVD, MORGANTOWN, WV | Report only |
| 7696 | 7696 | #21-01495 | SUSPICIOUS PERSON | 2021 | 2021-05-08 20:54:00 | WVU MOUNTAINEER STATION 2 | 1130 VAN VOORHIS RD, MORGANTOWN, WV 26501 | Report only |
| 7730 | 7730 | #21-01518 | SUSPICIOUS PERSON | 2021 | 2021-05-11 08:34:00 | WVU POLICE DEPARTMENT | 992 ELMER PRINCE DR, MORGANTOWN, WV | Report only |
| 10141 | 10141 | #22-00246 | SUSPICIOUS PERSON | 2022 | 2022-01-27 04:56:00 | RESEARCH WAY, MORGANTOWN, WV 26501 | Report only | |
| 10243 | 10243 | #22-00403 | SUSPICIOUS PERSON | 2022 | 2022-02-10 13:58:00 | WVU BROOKE TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Report only |
| 13097 | 13097 | #22-03365 | SUSPICIOUS PERSON | 2022 | 2022-12-22 14:18:00 | PRICE ST, MORGANTOWN, WV 26501 | Report only | |
| 13111 | 13111 | #22-03425 | SUSPICIOUS PERSON | 2022 | 2022-12-31 20:36:00 | PRICE ST, MORGANTOWN, WV 26501 | Report only | |
| 13112 | 13112 | #22-03424 | SUSPICIOUS PERSON | 2022 | 2022-12-31 20:09:00 | WILES ST, MORGANTOWN, WV 26501 | Report only | |
| 15279 | 15279 | 23-02075 | SUSPICIOUS PERSON | 2023 | 2023-08-16 16:22:00 | WVU MOUNTAINLAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Report only |
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 );