_locations
6 rows where category_id = 57893
This data as json, CSV (advanced)
Suggested facets: ward, active, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 6693 | 6693 | 9 BONWOOD ST | 42.347376 | -71.201537 | 57893 | 2 | 2024-11-07 | 2025-04-01 | 0 |
| 8989 | 8989 | 77 PAUL ST | 42.326666 | -71.197314 | 57893 | 6 | 2025-01-07 | 2025-01-10 | 0 |
| 12072 | 12072 | 65 ELLIS STREET | 42.314752 | -71.225937 | 57893 | 5 | 2025-03-25 | 2025-03-31 | 0 |
| 13662 | 13662 | 1781 COMMONWEALTH AVENUE | 42.341784 | -71.239327 | 57893 | 4 | 2025-05-07 | 1 | |
| 15783 | 15783 | 301 ELLIOT ST | 42.312915 | -71.221487 | 57893 | 5 | 2025-06-19 | 2025-06-26 | 0 |
| 19549 | 19549 | 200 COMMONWEALTH AVE | 42.337008 | -71.174205 | 57893 | 7 | 2025-09-15 | 2025-11-03 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [_locations] ( [location] TEXT, [latitude] FLOAT, [longitude] FLOAT, [category_id] TEXT REFERENCES [categories]([id]), [ward] INTEGER, [added] TEXT, [removed] TEXT, [active] INTEGER );