crimelog
377 rows where outcome = "Closed - Resolved" and title = "WELFARE CHECK" sorted by datetime descending
This data as json, CSV (advanced)
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
1144 | 1144 | #19-04243 | WELFARE CHECK | 2019 | 2019-10-08 08:02:00 | PHI SIGMA KAPPA FRATERNITY | 672 NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
1150 | 1150 | #19-04237 | WELFARE CHECK | 2019 | 2019-10-08 02:58:00 | WVU SENECA HALL | 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
1216 | 1216 | #19-04167 | WELFARE CHECK | 2019 | 2019-10-05 09:40:00 | WVU SENECA HALL | 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
1217 | 1217 | #19-04166 | WELFARE CHECK | 2019 | 2019-10-05 06:05:00 | WVU SENECA HALL | 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
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 );