_locations
4 rows where category_id = 66937
This data as json, CSV (advanced)
Suggested facets: added, removed, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 22497 | 22497 | 1000 COMMONWEALTH AVE | 42.337377 | -71.208617 | 66937 | 2 | 2025-12-02 | 2025-12-02 | 0 |
| 22692 | 22692 | 1400 COMMONWEALTH AVE | 42.336477 | -71.22416 | 66937 | 3 | 2025-12-08 | 2025-12-09 | 0 |
| 22693 | 22693 | 389 WOODWARD ST | 42.326316 | -71.226653 | 66937 | 5 | 2025-12-08 | 2025-12-09 | 0 |
| 22893 | 22893 | 351 WAVERLEY AVE | 42.343992 | -71.182467 | 66937 | 7 | 2025-12-14 | 2025-12-16 | 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 );