_locations
8 rows where category_id = 51113
This data as json, CSV (advanced)
Suggested facets: ward, removed, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 8478 | 8478 | 278 MELROSE ST | 42.347038 | -71.248512 | 51113 | 4 | 2024-12-23 | 2025-12-16 | 0 |
| 8516 | 8516 | 63 MARGARET RD | 42.316208 | -71.215214 | 51113 | 5 | 2024-12-24 | 2025-08-12 | 0 |
| 10616 | 10616 | 658 COMMONWEALTH AVE | 42.335556 | -71.194436 | 51113 | 6 | 2025-02-17 | 2025-02-24 | 0 |
| 10928 | 10928 | 640 GROVE ST | 42.327378 | -71.258058 | 51113 | 4 | 2025-02-20 | 2025-03-28 | 0 |
| 11799 | 11799 | 475 PARKER ST | 42.311394 | -71.197043 | 51113 | 8 | 2025-03-15 | 2025-03-28 | 0 |
| 13283 | 13283 | 167 AUBURNDALE AVE | 42.35139 | -71.239023 | 51113 | 3 | 2025-04-28 | 2025-07-31 | 0 |
| 13335 | 13335 | 61 WASHBURN AVE | 42.351498 | -71.242781 | 51113 | 4 | 2025-04-29 | 2025-11-01 | 0 |
| 14844 | 14844 | 52 BERNARD ST | 42.304797 | -71.210295 | 51113 | 8 | 2025-06-02 | 2025-07-31 | 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 );