home / wvu

crimelog

21 rows where "datetime" is on date 2021-03-13, outcome = "Clear by Citation" and title = "ABCC VIOLATION"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: address, datetime (date)

Link rowid ▼ id title year datetime building address outcome
6909 6909 #21-00717 ABCC VIOLATION 2021 2021-03-13 23:46:00   GRANT AVE, MORGANTOWN, WV 26501 Clear by Citation
6911 6911 #21-00711 ABCC VIOLATION 2021 2021-03-13 21:07:00   PROSPECT ST, MORGANTOWN, WV 26501 Clear by Citation
6912 6912 #21-00710 ABCC VIOLATION 2021 2021-03-13 21:01:00   NORTH SPRUCE ST, MORGANTOWN, WV 26501 Clear by Citation
6914 6914 #21-00704 ABCC VIOLATION 2021 2021-03-13 19:54:00   NORTH HIGH ST, MORGANTOWN, WV 26501 Clear by Citation
6918 6918 #21-00700 ABCC VIOLATION 2021 2021-03-13 18:58:00   FIFE AVE / NORTH HIGH ST, MORGANTOWN, WV 26501 Clear by Citation
6919 6919 #21-00699 ABCC VIOLATION 2021 2021-03-13 18:35:00   BELMAR AVE, MORGANTOWN Clear by Citation
6920 6920 #21-00696 ABCC VIOLATION 2021 2021-03-13 18:16:00   NORTH HIGH ST, MORGANTOWN, WV 26501 Clear by Citation
6924 6924 #21-00691 ABCC VIOLATION 2021 2021-03-13 16:40:00   WAVERLY ST, MORGANTOWN, WV 26501 Clear by Citation
6928 6928 #21-00685 ABCC VIOLATION 2021 2021-03-13 02:04:00   HOUSTON DR / GRANT AVE, MORGANTOWN, WV 26501 Clear by Citation
6932 6932 #21-00681 ABCC VIOLATION 2021 2021-03-13 00:33:00   FIFE AVE / NORTH SPRUCE ST, MORGANTOWN, WV 26501 Clear by Citation
6934 6934 #21-00678 ABCC VIOLATION 2021 2021-03-13 00:08:00   NORTH HIGH ST / FIFE AVE, MORGANTOWN, WV 26501 Clear by Citation
6966 6966 #21-00715 ABCC VIOLATION 2021 2021-03-13 21:45:00   BEVERLY AVE, MORGANTOWN, WV 26501 Clear by Citation
6967 6967 #21-00714 ABCC VIOLATION 2021 2021-03-13 21:39:00   NORTH HIGH ST, MORGANTOWN, WV 26501 Clear by Citation
6968 6968 #21-00713 ABCC VIOLATION 2021 2021-03-13 21:09:00   PRICE ST, MORGANTOWN, WV 26501 Clear by Citation
6969 6969 #21-00708 ABCC VIOLATION 2021 2021-03-13 20:51:00   NORTH HIGH ST, MORGANTOWN, WV 26501 Clear by Citation
6971 6971 #21-00706 ABCC VIOLATION 2021 2021-03-13 20:37:00   BELMAR AVE / PRICE ST, MORGANTOWN, WV 26501 Clear by Citation
6972 6972 #21-00698 ABCC VIOLATION 2021 2021-03-13 18:47:00   NORTH HIGH ST, MORGANTOWN, WV 26501 Clear by Citation
6973 6973 #21-00697 ABCC VIOLATION 2021 2021-03-13 18:51:00   NORTH HIGH ST/Fife St, MORGANTOWN, WV 26501 Clear by Citation
6974 6974 #21-00695 ABCC VIOLATION 2021 2021-03-13 17:54:00   NORTH HIGH ST, MORGANTOWN, WV 26501 Clear by Citation
6975 6975 #21-00687 ABCC VIOLATION 2021 2021-03-13 02:20:00   SPRUCE ST, MORGANTOWN, WV 26501 Clear by Citation
6976 6976 #21-00679 ABCC VIOLATION 2021 2021-03-13 00:17:00   FIFE AVE / NORTH HIGH ST, MORGANTOWN, WV 26501 Clear by Citation

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