_locations
54 rows where category_id = 51113
This data as json, CSV (advanced)
Suggested facets: ward, removed, active, 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 |
| 23673 | 23673 | 62 FELLSMERE RD | 42.340941 | -71.180069 | 51113 | 7 | 2026-01-05 | 1 | |
| 23764 | 23764 | 308 CYPRESS ST | 42.320502 | -71.188002 | 51113 | 6 | 2026-01-07 | 2026-01-15 | 0 |
| 24263 | 24263 | 28 COLLINS RD | 42.325362 | -71.231225 | 51113 | 5 | 2026-01-20 | 1 | |
| 24471 | 24471 | 503 WATERTOWN ST | 42.357807 | -71.205876 | 51113 | 1 | 2026-01-23 | 2026-02-18 | 0 |
| 24587 | 24587 | 44 KING ST | 42.350832 | -71.244347 | 51113 | 4 | 2026-01-26 | 1 | |
| 24625 | 24625 | 27 DURANT ST | 42.35157 | -71.179416 | 51113 | 1 | 2026-01-26 | 2026-02-13 | 0 |
| 24626 | 24626 | 9 PERRY RD | 42.350553 | -71.243982 | 51113 | 4 | 2026-01-26 | 1 | |
| 24705 | 24705 | 15 OTIS PARK | 42.347303 | -71.208041 | 51113 | 2 | 2026-01-27 | 2026-02-17 | 0 |
| 24783 | 24783 | 12 WABAN ST | 42.357456 | -71.189411 | 51113 | 1 | 2026-01-27 | 2026-02-05 | 0 |
| 24828 | 24828 | 24 HARTMAN RD | 42.307902 | -71.190288 | 51113 | 8 | 2026-01-27 | 2026-02-05 | 0 |
| 24844 | 24844 | 101 ALLEN AVENUE | 42.326802 | -71.220454 | 51113 | 5 | 2026-01-28 | 2026-02-18 | 0 |
| 25015 | 25015 | 49 CLIFTON RD | 42.302088 | -71.180145 | 51113 | 8 | 2026-01-28 | 2026-02-05 | 0 |
| 25493 | 25493 | 91 HIGH ST | 42.315399 | -71.223548 | 51113 | 5 | 2026-02-02 | 1 | |
| 25561 | 25561 | 1321 CENTRE ST | 42.328827 | -71.196219 | 51113 | 6 | 2026-02-02 | 2026-02-18 | 0 |
| 25845 | 25845 | 479 BOYLSTON STREET | 42.318977 | -71.188711 | 51113 | 6 | 2026-02-05 | 2026-02-05 | 0 |
| 25857 | 25857 | 49 CLIFTON RD | 42.302088 | -71.180145 | 51113 | 8 | 2026-02-05 | 1 | |
| 25976 | 25976 | 24 HARTMAN RD | 42.307902 | -71.190288 | 51113 | 8 | 2026-02-06 | 1 | |
| 26004 | 26004 | 36 MAPLE AVENUE | 42.353213 | -71.188632 | 51113 | 1 | 2026-02-07 | 2026-02-13 | 0 |
| 26045 | 26045 | 7 PERRY RD | 42.350598 | -71.24396 | 51113 | 4 | 2026-02-09 | 2026-03-04 | 0 |
| 26093 | 26093 | 100 DRUMLIN RD | 42.304671 | -71.18186 | 51113 | 8 | 2026-02-10 | 2026-03-04 | 0 |
| 26133 | 26133 | 389 WOODWARD ST | 42.326316 | -71.226653 | 51113 | 5 | 2026-02-10 | 1 | |
| 26152 | 26152 | 7 BEETHOVEN AVE | 42.330249 | -71.218967 | 51113 | 5 | 2026-02-11 | 2026-02-18 | 0 |
| 26181 | 26181 | 33 CRESTWOOD RD | 42.341238 | -71.215187 | 51113 | 2 | 2026-02-11 | 2026-02-17 | 0 |
| 26195 | 26195 | 33 ROSLYN RD | 42.330204 | -71.223332 | 51113 | 5 | 2026-02-11 | 2026-02-18 | 0 |
| 26314 | 26314 | 57 DANIEL ST | 42.322338 | -71.193411 | 51113 | 6 | 2026-02-12 | 1 | |
| 26347 | 26347 | 48 GRALYNN RD | 42.34104 | -71.181252 | 51113 | 7 | 2026-02-13 | 2026-02-18 | 0 |
| 26531 | 26531 | 385 LINWOOD AVE | 42.35553 | -71.211578 | 51113 | 2 | 2026-02-18 | 2026-03-04 | 0 |
| 26608 | 26608 | 141 JACKSON ST | 42.320475 | -71.188484 | 51113 | 6 | 2026-02-19 | 1 | |
| 26609 | 26609 | 177 CHERRY ST | 42.358167 | -71.227485 | 51113 | 3 | 2026-02-19 | 1 | |
| 26661 | 26661 | 462 WALNUT ST | 42.345441 | -71.205593 | 51113 | 2 | 2026-02-21 | 1 | |
| 26701 | 26701 | 36 SUNHILL LANE | 42.320036 | -71.195531 | 51113 | 6 | 2026-02-23 | 2026-03-04 | 0 |
| 26709 | 26709 | 74 MOSMAN ST | 42.363036 | -71.2193 | 51113 | 3 | 2026-02-23 | 1 | |
| 26838 | 26838 | 70 SPIERS RD | 42.288903 | -71.185779 | 51113 | 8 | 2026-02-24 | 1 | |
| 26849 | 26849 | 274 PARKER ST | 42.318 | -71.194334 | 51113 | 8 | 2026-02-24 | 1 | |
| 26916 | 26916 | 69 EVELYN RD | 42.332544 | -71.218823 | 51113 | 5 | 2026-02-24 | 1 | |
| 26940 | 26940 | 54 HOBART RD | 42.337377 | -71.181977 | 51113 | 7 | 2026-02-24 | 2026-03-04 | 0 |
| 27011 | 27011 | 172 PEARL ST | 42.358941 | -71.193326 | 51113 | 1 | 2026-02-25 | 1 | |
| 27040 | 27040 | 393 COMMONWEALTH AVE | 42.336909 | -71.182112 | 51113 | 7 | 2026-02-25 | 1 | |
| 27329 | 27329 | 193 LAKE AVENUE | 42.326496 | -71.204084 | 51113 | 6 | 2026-02-27 | 1 | |
| 27693 | 27693 | 19 W BOULEVARD RD | 42.340743 | -71.18766 | 51113 | 7 | 2026-03-03 | 1 | |
| 27790 | 27790 | 385 LINWOOD AVE | 42.35553 | -71.211578 | 51113 | 2 | 2026-03-04 | 1 | |
| 27866 | 27866 | 20 LORNA RD | 42.341679 | -71.181887 | 51113 | 7 | 2026-03-05 | 1 | |
| 27878 | 27878 | 51 AVALON RD | 42.328962 | -71.222144 | 51113 | 5 | 2026-03-05 | 1 | |
| 27948 | 27948 | 33 CRESTWOOD RD | 42.341238 | -71.215187 | 51113 | 2 | 2026-03-06 | 1 | |
| 27949 | 27949 | 47 PARKER AVE | 42.317721 | -71.197043 | 51113 | 6 | 2026-03-06 | 1 | |
| 28271 | 28271 | 728 WALNUT ST | 42.336513 | -71.206763 | 51113 | 2 | 2026-03-10 | 1 |
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 );