crimelog

3 rows where outcome = "Active", title = "HIT AND RUN" and year = 2020

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date)

Link rowid ▼ id title year datetime building address outcome
1693 1693 #20-00166 HIT AND RUN 2020 2020-01-15 11:54:00 WVU Area 52 (Chestnut Ridge RB) 39.656849, -79.955134 Active
1857 1857 #20-00291 HIT AND RUN 2020 2020-01-17 11:12:00 MORRILL WAY / FINE ARTS DR, MORGANTOWN, WV 26501 Active
3446 3446 #20-01912 HIT AND RUN 2020 2020-07-26 19:20:00 WVU Area 21 (CBCR) 39.631961, -79.951950, Morgantown Active

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