crimelog
5 rows where outcome = "Under Investigation", title = "LARCENY FROM A VEHICLE" and year = 2023 sorted by datetime descending
This data as json, CSV (advanced)
Suggested facets: building, address, datetime (date)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
16801 | 16801 | 23-03490 | LARCENY FROM A VEHICLE | 2023 | 2023-11-28 11:05:00 | WVU UNIVERSITY PLACE PARKING GARAGE | 2154 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Under Investigation |
16198 | 16198 | 23-02895 | LARCENY FROM A VEHICLE | 2023 | 2023-10-07 14:40:00 | ARBORETUM | 2002 MONONGAHELA BLVD, MORGANTOWN, WV | Under Investigation |
15898 | 15898 | 23-02610 | LARCENY FROM A VEHICLE | 2023 | 2023-09-17 14:48:00 | WVU UNIVERSITY PLACE PARKING GARAGE | 2154 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Under Investigation |
15856 | 15856 | 23-02545 | LARCENY FROM A VEHICLE | 2023 | 2023-09-16 10:28:00 | WVU Area 30U (College Park) | 39.637510,-79.943520 | Under Investigation |
14266 | 14266 | #23-01186 | LARCENY FROM A VEHICLE | 2023 | 2023-04-19 14:00:00 | WVU UNIVERSITY PLACE PARKING GARAGE | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Under Investigation |
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 );