crimelog

4 rows where outcome = "Report only", title = "SUSPICIOUS PERSON" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date)

Link rowid ▼ id title year datetime building address outcome
7238 7238 #21-00996 SUSPICIOUS PERSON 2021 2021-03-28 13:39:00 WVU MOUNTAINLAIR 1550 UNIVERSITY AVE, MORGANTOWN, WV Report only
7488 7488 #21-01261 SUSPICIOUS PERSON 2021 2021-04-17 14:57:00 ARBORETUM 2002 MONONGAHELA BLVD, MORGANTOWN, WV Report only
7696 7696 #21-01495 SUSPICIOUS PERSON 2021 2021-05-08 20:54:00 WVU MOUNTAINEER STATION 2 1130 VAN VOORHIS RD, MORGANTOWN, WV 26501 Report only
7730 7730 #21-01518 SUSPICIOUS PERSON 2021 2021-05-11 08:34:00 WVU POLICE DEPARTMENT 992 ELMER PRINCE DR, MORGANTOWN, WV Report only

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
);