crimelog
6 rows where outcome = "Pending Arrest" and year = 2022
This data as json, CSV (advanced)
Suggested facets: title, datetime, building, datetime (date)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 10502 | 10502 | #22-00623 | FIRE ALARM | 2022 | 2022-03-06 02:06:00 | WVU DADISMAN HALL | NORTH HIGH ST, MORGANTOWN, WV | Pending Arrest |
| 10654 | 10654 | #22-00855 | FIRE ALARM | 2022 | 2022-03-06 02:06:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Pending Arrest | |
| 11513 | 11513 | #22-01759 | STOLEN VEHICLE | 2022 | 2022-08-15 03:36:00 | BELMAR AVE, MORGANTOWN | Pending Arrest | |
| 11933 | 11933 | #22-02182 | LARCENY | 2022 | 2022-09-11 05:30:00 | WVU PRT STATION-WALNUT ST | WALNUT ST, MORGANTOWN, WV 26501 | Pending Arrest |
| 12627 | 12627 | #22-02864 | LARCENY FROM A VEHICLE | 2022 | 2022-11-02 11:02:00 | WVU Area 39 (Summit) | 39.639206, -79.956773, MORGANTOWN | Pending Arrest |
| 12798 | 12798 | #22-02983 | LARCENY | 2022 | 2022-11-12 04:28:00 | WVU BROOKE TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Pending 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 );