crimelog
3 rows where building = "PSC STAYMAN FIELD"
This data as json, CSV (advanced)
Suggested facets: title, datetime (date)
Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
---|---|---|---|---|---|---|---|---|
4041 | 4041 | #PS20-00679 | TRESPASSING | 2020 | 2020-06-24 20:50:00 | PSC STAYMAN FIELD | 39.438876, -78.986920 | Closed - Resolved |
5105 | 5105 | #PS20-01098 | K9 DETAIL | 2020 | 2020-10-01 00:00:00 | PSC STAYMAN FIELD | 39.438876, -78.986920 | Closed - Resolved |
5197 | 5197 | #PS20-00961 | K9 DETAIL | 2020 | 2020-09-06 00:00:00 | PSC STAYMAN FIELD | 39.438876, -78.986920 | 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 );