_locations
14 rows where category_id = 51108
This data as json, CSV (advanced)
Suggested facets: ward, added, removed, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 9199 | 9199 | AUBURNDALE | 42.346388 | -71.24684 | 51108 | 4 | 2025-01-13 | 2025-01-13 | 0 |
| 24849 | 24849 | 1 NEWTON PL | 42.357762 | -71.185122 | 51108 | 1 | 2026-01-28 | 2026-01-28 | 0 |
| 24869 | 24869 | 135 AUBURN ST | 42.344784 | -71.240625 | 51108 | 4 | 2026-01-28 | 2026-01-29 | 0 |
| 25063 | 25063 | 50 STATION AVENUE | 42.322361 | -71.205554 | 51108 | 6 | 2026-01-29 | 2026-01-29 | 0 |
| 25393 | 25393 | 4 JUDITH ROAD | 42.335677 | -71.207097 | 51108 | 6 | 2026-01-31 | 2026-02-02 | 0 |
| 25748 | 25748 | 925 CENTRE ST | 42.340626 | -71.192975 | 51108 | 2 | 2026-02-04 | 2026-02-04 | 0 |
| 25781 | 25781 | 344 RIVER ST | 42.357618 | -71.239541 | 51108 | 4 | 2026-02-04 | 2026-02-09 | 0 |
| 25782 | 25782 | 73 LEXINGTON ST | 42.357663 | -71.239937 | 51108 | 4 | 2026-02-04 | 2026-02-09 | 0 |
| 25798 | 25798 | 1299 CENTRE ST | 42.329583 | -71.19536 | 51108 | 6 | 2026-02-04 | 2026-02-04 | 0 |
| 25880 | 25880 | 104 NEEDHAM STREET | 42.313871 | -71.211437 | 51108 | 8 | 2026-02-05 | 2026-02-05 | 0 |
| 25895 | 25895 | 104 NEEDHAM ST | 42.313788 | -71.211263 | 51108 | 8 | 2026-02-05 | 2026-02-06 | 0 |
| 26074 | 26074 | 145 WASHINGTON ST | 42.356115 | -71.179799 | 51108 | 1 | 2026-02-09 | 2026-02-10 | 0 |
| 26151 | 26151 | 7 OAK ST | 42.312447 | -71.221325 | 51108 | 5 | 2026-02-11 | 2026-02-11 | 0 |
| 27025 | 27025 | 325 BOYLSTON ST | 42.319503 | -71.181752 | 51108 | 6 | 2026-02-25 | 2026-02-25 | 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 );