crimelog

7 rows where outcome = "Inactive", title = "ABCC VIOLATION" and year = 2020

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: building, datetime (date)

Link rowid ▼ id title year datetime building address outcome
1890 1890 #20-00342 ABCC VIOLATION 2020 2020-01-24 22:14:00 WVU BOREMAN SOUTH 600 NORTH HIGH ST, MORGANTOWN, WV 26501 Inactive
2055 2055 #20-00549 ABCC VIOLATION 2020 2020-02-03 22:42:00 WVU BOREMAN NORTH 602 NORTH HIGH ST, MORGANTOWN, WV 26501 Inactive
2074 2074 #20-00525 ABCC VIOLATION 2020 2020-02-02 22:31:00 WVU BRAXTON TOWER 356 EVANSDALE DR, MORGANTOWN, WV 26501 Inactive
2400 2400 #20-00893 ABCC VIOLATION 2020 2020-02-23 00:49:00 WVU BOREMAN SOUTH 600 NORTH HIGH ST, MORGANTOWN, WV 26501 Inactive
3658 3658 #20-02063 ABCC VIOLATION 2020 2020-08-17 00:05:00   228 BELMAR AVE, MORGANTOWN, WV 26501 Inactive
4833 4833 #20-02976 ABCC VIOLATION 2020 2020-10-10 03:24:00 WVU SUMMIT HALL 211 GRANT AVE, MORGANTOWN, WV 26501 Inactive
5340 5340 #20-03329 ABCC VIOLATION 2020 2020-11-08 03:37:00 WVU DADISMAN HALL 693 NORTH HIGH ST, MORGANTOWN, WV Inactive

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [crimelog] (
   [id] TEXT,
   [title] TEXT,
   [year] TEXT,
   [datetime] TEXT,
   [building] TEXT,
   [address] TEXT,
   [outcome] TEXT
);