crimelog
58 rows where outcome = "Clear by Warning", title = "ABCC VIOLATION" and year = 2020 sorted by datetime descending
This data as json, CSV (advanced)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
2731 | 2731 | #20-01198 | ABCC VIOLATION | 2020 | 2020-03-06 23:53:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Clear by Warning |
2575 | 2575 | #20-01046 | ABCC VIOLATION | 2020 | 2020-02-29 02:52:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Clear by Warning |
2577 | 2577 | #20-01044 | ABCC VIOLATION | 2020 | 2020-02-29 01:57:00 | WVU STALNAKER HALL | 691 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
2578 | 2578 | #20-01043 | ABCC VIOLATION | 2020 | 2020-02-29 00:32:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Warning |
2395 | 2395 | #20-00898 | ABCC VIOLATION | 2020 | 2020-02-23 03:08:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Clear by Warning |
2399 | 2399 | #20-00894 | ABCC VIOLATION | 2020 | 2020-02-23 01:15:00 | WVU MOUNTAINLAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Warning |
2423 | 2423 | #20-00870 | ABCC VIOLATION | 2020 | 2020-02-22 02:15:00 | WVU LINCOLN HALL | 1014 RAWLEY AVE, MORGANTOWN, WV 26501 | Clear by Warning |
2425 | 2425 | #20-00868 | ABCC VIOLATION | 2020 | 2020-02-22 02:01:00 | WVU BROOKE TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Warning |
2451 | 2451 | #20-00841 | ABCC VIOLATION | 2020 | 2020-02-21 01:18:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Warning |
2284 | 2284 | #20-00739 | ABCC VIOLATION | 2020 | 2020-02-15 01:46:00 | WVU BENNETT TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Warning |
2287 | 2287 | #20-00736 | ABCC VIOLATION | 2020 | 2020-02-14 22:46:00 | WVU BOREMAN NORTH | 602 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
2297 | 2297 | #20-00723 | ABCC VIOLATION | 2020 | 2020-02-14 05:49:00 | WVU STALNAKER HALL | 691 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
2168 | 2168 | #20-00656 | ABCC VIOLATION | 2020 | 2020-02-09 03:24:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
2186 | 2186 | #20-00637 | ABCC VIOLATION | 2020 | 2020-02-08 02:25:00 | WVU HONORS HALL | 250 SECOND ST, MORGANTOWN, WV | Clear by Warning |
2188 | 2188 | #20-00635 | ABCC VIOLATION | 2020 | 2020-02-08 01:31:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Warning |
2189 | 2189 | #20-00634 | ABCC VIOLATION | 2020 | 2020-02-08 00:45:00 | WVU BOREMAN NORTH | 602 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
2190 | 2190 | #20-00633 | ABCC VIOLATION | 2020 | 2020-02-08 00:22:00 | WVU BRAXTON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Warning |
2051 | 2051 | #20-00553 | ABCC VIOLATION | 2020 | 2020-02-03 23:51:00 | KAPPA KAPPA GAMMA SORORITY | 265 PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Warning |
2054 | 2054 | #20-00550 | ABCC VIOLATION | 2020 | 2020-02-03 22:43:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Clear by Warning |
2006 | 2006 | #20-00490 | ABCC VIOLATION | 2020 | 2020-02-01 02:55:00 | WVU LYON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Warning |
2011 | 2011 | #20-00485 | ABCC VIOLATION | 2020 | 2020-02-01 00:30:00 | WVU BRAXTON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Warning |
2021 | 2021 | #20-00475 | ABCC VIOLATION | 2020 | 2020-01-31 22:12:00 | WVU MOUNTAINLAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Clear by Warning |
2036 | 2036 | #20-00458 | ABCC VIOLATION | 2020 | 2020-01-31 01:37:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Clear by Warning |
2039 | 2039 | #20-00455 | ABCC VIOLATION | 2020 | 2020-01-31 01:18:00 | PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Warning | |
1864 | 1864 | #20-00371 | ABCC VIOLATION | 2020 | 2020-01-26 04:36:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
1870 | 1870 | #20-00364 | ABCC VIOLATION | 2020 | 2020-01-25 23:49:00 | WVU BOREMAN NORTH | 602 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
1871 | 1871 | #20-00363 | ABCC VIOLATION | 2020 | 2020-01-25 23:46:00 | WVU BRAXTON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Warning |
1887 | 1887 | #20-00345 | ABCC VIOLATION | 2020 | 2020-01-25 01:03:00 | WVU MOUNTAINLAIR PARKING GARAGE | 109 PROSPECT ST, MORGANTOWN, WV | Clear by Warning |
1730 | 1730 | #20-00244 | ABCC VIOLATION | 2020 | 2020-01-19 02:05:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning |
1733 | 1733 | #20-00241 | ABCC VIOLATION | 2020 | 2020-01-19 01:00:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
1763 | 1763 | #20-00208 | ABCC VIOLATION | 2020 | 2020-01-18 02:01:00 | LAMBDA CHI ALPHA FRATERNITY | 216 BELMAR AVE, MORGANTOWN, WV 26501 | Clear by Warning |
1772 | 1772 | #20-00199 | ABCC VIOLATION | 2020 | 2020-01-17 23:25:00 | WVU BOREMAN NORTH | 602 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
1789 | 1789 | #20-00180 | ABCC VIOLATION | 2020 | 2020-01-17 02:17:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
1791 | 1791 | #20-00178 | ABCC VIOLATION | 2020 | 2020-01-17 01:38:00 | SIGMA NU FRATERNITY | 617 NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Clear by Warning |
1793 | 1793 | #20-00176 | ABCC VIOLATION | 2020 | 2020-01-17 01:34:00 | THETA CHI FRATERNITY | 692 NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [crimelog] ( [id] TEXT, [title] TEXT, [year] TEXT, [datetime] TEXT, [building] TEXT, [address] TEXT, [outcome] TEXT );