crimelog
6 rows where "datetime" is on date 2022-06-29 and year = 2022
This data as json, CSV (advanced)
Suggested facets: outcome, datetime (date)
Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
---|---|---|---|---|---|---|---|---|
11192 | 11192 | #22-01428 | GRAND LARCENY | 2022 | 2022-06-29 17:06:00 | WVU AREA 68 | 39.6517, -79.9604, morgantown | Closed - Lack of leads |
11193 | 11193 | #22-01427 | PETIT LARCENY, STPL | 2022 | 2022-06-29 16:07:00 | WVU VANDALIA HALL BLUE | FALLING RUN RD, MORGANTOWN, WV 26501 | Closed - Resolved |
11194 | 11194 | #22-01426 | ALARM CONDITION | 2022 | 2022-06-29 15:29:00 | WVU STEWART HALL | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
11195 | 11195 | #22-01425 | ASSIST EMS POLICE | 2022 | 2022-06-29 11:56:00 | WVU OAKLAND HALL | OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
11196 | 11196 | #22-01424 | PANIC ALARM | 2022 | 2022-06-29 09:16:00 | HEALTH SCIENCE CENTER | MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
11212 | 11212 | #22-01439 | SUSPICIOUS VEHICLE | 2022 | 2022-06-29 08:34:00 | WVU Area 50 (Allen/ Perc) | 39.646836, -79.966397, MORGANTOWN | 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 );