crimelog
4 rows where "datetime" is on date 2020-03-01 and outcome = "Clear by Arrest" sorted by datetime descending
This data as json, CSV (advanced)
Suggested facets: building
title 4 ✖
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
2616 | 2616 | #20-01081 | DRUG INCIDENT | 2020 | 2020-03-01 20:24:00 | WVU UNIVERSITY PARK APARTMENTS - WEST | 442 OAKLAND ST, MORGANTOWN, WV 26501 | Clear by Arrest |
2673 | 2673 | #20-01080 | DOMESTIC DISPUTE | 2020 | 2020-03-01 17:44:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Clear by Arrest |
2548 | 2548 | #20-01077 | TRAFFIC STOP, 1054 | 2020 | 2020-03-01 16:36:00 | ELMER PRINCE DR / MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Clear by Arrest | |
2556 | 2556 | #20-01067 | DUI | 2020 | 2020-03-01 03:10:00 | UNIVERSITY AVE / NORTH ST, MORGANTOWN, WV 26505 | 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 );