crimelog
9 rows where "datetime" is on date 2020-02-22, outcome = "Clear by Citation" and title = "ABCC VIOLATION"
This data as json, CSV (advanced)
Suggested facets: datetime (date)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 2403 | 2403 | #20-00890 | ABCC VIOLATION | 2020 | 2020-02-22 22:47:00 | FIFE AVE / NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 2404 | 2404 | #20-00889 | ABCC VIOLATION | 2020 | 2020-02-22 22:24:00 | PRICE ST / BELMAR AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
| 2406 | 2406 | #20-00887 | ABCC VIOLATION | 2020 | 2020-02-22 22:01:00 | NORTH HIGH ST / PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 2407 | 2407 | #20-00886 | ABCC VIOLATION | 2020 | 2020-02-22 21:53:00 | PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 2408 | 2408 | #20-00885 | ABCC VIOLATION | 2020 | 2020-02-22 21:36:00 | PRICE ST / GLENDON AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
| 2409 | 2409 | #20-00884 | ABCC VIOLATION | 2020 | 2020-02-22 21:34:00 | PRICE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 2410 | 2410 | #20-00883 | ABCC VIOLATION | 2020 | 2020-02-22 21:24:00 | BELMAR AVE / WAVERLY ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 2411 | 2411 | #20-00882 | ABCC VIOLATION | 2020 | 2020-02-22 21:00:00 | NORTH SPRUCE ST / PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 2415 | 2415 | #20-00878 | ABCC VIOLATION | 2020 | 2020-02-22 18:25:00 | FIFE AVE, MORGANTOWN, WV 26501 | Clear by Citation |
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 );