home / wvu

crimelog

3 rows where outcome = " "

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, building

Link rowid ▼ id title year datetime building address outcome
3554 3554 #PS20-00610 ANIMAL COMPLAINT   2020-05-29 18:47:00 PSC INDOOR RIDING AREA 640 CHESTNUT ST, KEYSER, WV 26726
13715 13715 #23-00600 ADMIN DETAIL POLICE 2023 2023-02-24 11:10:00   Electronic Device Destruction and Disposal
13833 13833 #23-00740 ADMIN DETAIL POLICE 2023 2023-03-06 16:12:00   Record Destruction

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
);
Powered by Datasette · Queries took 4960.011ms