_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 |
|---|---|---|---|---|---|---|---|---|---|
| 12125 | 12125 | 278 MELROSE ST | 42.347038 | -71.248512 | 51113 | 4 | 2024-12-23 12:00 | 2025-12-16 | 0 |
| 12172 | 12172 | 63 MARGARET RD | 42.316208 | -71.215214 | 51113 | 5 | 2024-12-23 20:15 | 2025-08-12 | 0 |
| 14821 | 14821 | 658 COMMONWEALTH AVE | 42.335556 | -71.194436 | 51113 | 6 | 2025-02-17 17:00 | 2025-02-24 | 0 |
| 15174 | 15174 | 640 GROVE ST | 42.327378 | -71.258058 | 51113 | 4 | 2025-02-20 13:45 | 2025-03-28 | 0 |
| 16390 | 16390 | 475 PARKER ST | 42.311394 | -71.197043 | 51113 | 8 | 2025-03-15 17:00 | 2025-03-28 | 0 |
| 18441 | 18441 | 167 AUBURNDALE AVE | 42.35139 | -71.239023 | 51113 | 3 | 2025-04-28 12:15 | 2025-07-31 | 0 |
| 18504 | 18504 | 61 WASHBURN AVE | 42.351498 | -71.242781 | 51113 | 4 | 2025-04-29 08:45 | 2025-11-01 | 0 |
| 20436 | 20436 | 52 BERNARD ST | 42.304797 | -71.210295 | 51113 | 8 | 2025-06-02 09:45 | 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 );