home / wvu

crimelog

13 rows where "datetime" is on date 2023-03-04 and title = "ABCC VIOLATION"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: building, address, outcome, datetime (date)

Link rowid ▼ id title year datetime building address outcome
13785 13785 #23-00720 ABCC VIOLATION 2023 2023-03-04 17:49:00 WVU MOUNTAINLAIR UNIVERSITY AVE, MORGANTOWN, WV Clear by Warning
13786 13786 #23-00718 ABCC VIOLATION 2023 2023-03-04 20:31:00 WVU OAKLAND HALL-WEST OAKLAND ST, MORGANTOWN, WV 26501 Clear by Warning
13787 13787 #23-00717 ABCC VIOLATION 2023 2023-03-04 20:29:00 THETA CHI FRATERNITY BELMAR AVE, MORGANTOWN, WV 26501 Clear by Warning
13790 13790 #23-00714 ABCC VIOLATION 2023 2023-03-04 18:41:00 WVU MOUNTAINLAIR UNIVERSITY AVE, MORGANTOWN, WV Clear by Warning
13791 13791 #23-00713 ABCC VIOLATION 2023 2023-03-04 18:47:00 WVU BOREMAN NORTH NORTH HIGH ST, MORGANTOWN, WV 26501 Clear by Warning
13792 13792 #23-00712 ABCC VIOLATION 2023 2023-03-04 18:44:00   NORTH HIGH ST, MORGANTOWN, WV 26501 Clear by Warning
13795 13795 #23-00709 ABCC VIOLATION 2023 2023-03-04 18:12:00   NORTH HIGH ST, MORGANTOWN, WV 26501 Clear by Arrest
13799 13799 #23-00705 ABCC VIOLATION 2023 2023-03-04 17:56:00   NORTH HIGH ST, MORGANTOWN, WV 26501 Clear by Citation
13801 13801 #23-00703 ABCC VIOLATION 2023 2023-03-04 17:08:00 ALPHA SIGMA PHI FRATERNITY BELMAR AVE, MORGANTOWN, WV 26501 Closed - Resolved
13805 13805 #23-00698 ABCC VIOLATION 2023 2023-03-04 16:07:00 WVU COLISEUM JERRY WEST DR, MORGANTOWN, WV 26501 Clear by Warning
13810 13810 #23-00693 ABCC VIOLATION 2023 2023-03-04 04:15:00 WVU OAKLAND HALL-WEST OAKLAND ST, MORGANTOWN, WV 26501 Clear by Warning
13812 13812 #23-00691 ABCC VIOLATION 2023 2023-03-04 03:17:00 WVU MOUNTAINLAIR UNIVERSITY AVE, MORGANTOWN, WV Clear by Arrest
13857 13857 #23-00700 ABCC VIOLATION 2023 2023-03-04 15:51:00   BELMAR AVE, MORGANTOWN Closed - Resolved

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 184.908ms