crimelog
16 rows where "datetime" is on date 2021-03-17, outcome = "Clear by Citation" and title = "ABCC VIOLATION"
This data as json, CSV (advanced)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 7000 | 7000 | #21-00789 | ABCC VIOLATION | 2021 | 2021-03-17 17:55:00 | FIFE AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
| 7001 | 7001 | #21-00784 | ABCC VIOLATION | 2021 | 2021-03-17 17:01:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 7034 | 7034 | #21-00804 | ABCC VIOLATION | 2021 | 2021-03-17 21:28:00 | PRICE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 7035 | 7035 | #21-00802 | ABCC VIOLATION | 2021 | 2021-03-17 20:34:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 7036 | 7036 | #21-00801 | ABCC VIOLATION | 2021 | 2021-03-17 20:25:00 | FIFE AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
| 7037 | 7037 | #21-00799 | ABCC VIOLATION | 2021 | 2021-03-17 20:00:00 | GRANT AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
| 7039 | 7039 | #21-00795 | ABCC VIOLATION | 2021 | 2021-03-17 19:32:00 | PRICE ST / FIFE AVE, MORGANTOWN, WV 26501 | Clear by Citation | |
| 7040 | 7040 | #21-00792 | ABCC VIOLATION | 2021 | 2021-03-17 18:44:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 7042 | 7042 | #21-00790 | ABCC VIOLATION | 2021 | 2021-03-17 18:08:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 7043 | 7043 | #21-00788 | ABCC VIOLATION | 2021 | 2021-03-17 17:40:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 7044 | 7044 | #21-00787 | ABCC VIOLATION | 2021 | 2021-03-17 17:38:00 | NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 7045 | 7045 | #21-00786 | ABCC VIOLATION | 2021 | 2021-03-17 17:34:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 7046 | 7046 | #21-00785 | ABCC VIOLATION | 2021 | 2021-03-17 17:13:00 | PROSPECT ST / NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 7047 | 7047 | #21-00783 | ABCC VIOLATION | 2021 | 2021-03-17 16:53:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 7048 | 7048 | #21-00782 | ABCC VIOLATION | 2021 | 2021-03-17 16:50:00 | NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Citation | |
| 7091 | 7091 | #21-00800 | ABCC VIOLATION | 2021 | 2021-03-17 20:02:00 | GRANT AVE / HOUSTON DR, 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 );