_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 |
|---|---|---|---|---|---|---|---|---|---|
| 9784 | 9784 | 9 BONWOOD ST | 42.347376 | -71.201537 | 57893 | 2 | 2024-11-07 10:00 | 2025-04-01 | 0 |
| 12777 | 12777 | 77 PAUL ST | 42.326666 | -71.197314 | 57893 | 6 | 2025-01-07 11:45 | 2025-01-10 | 0 |
| 16776 | 16776 | 65 ELLIS STREET | 42.314752 | -71.225937 | 57893 | 5 | 2025-03-25 12:30 | 2025-03-29 | 0 |
| 18947 | 18947 | 1781 COMMONWEALTH AVENUE | 42.341784 | -71.239327 | 57893 | 4 | 2025-05-07 08:15 | 1 | |
| 21654 | 21654 | 301 ELLIOT ST | 42.312915 | -71.221487 | 57893 | 5 | 2025-06-19 06:45 | 2025-06-26 | 0 |
| 26703 | 26703 | 200 COMMONWEALTH AVE | 42.337008 | -71.174205 | 57893 | 7 | 2025-09-15 09:30 | 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 );