_locations
55 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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 32199 | 32199 | 62 FELLSMERE RD | 42.340941 | -71.180069 | 51113 | 7 | 2026-01-05 08:45 | 1 | |
| 32331 | 32331 | 308 CYPRESS ST | 42.320502 | -71.188002 | 51113 | 6 | 2026-01-07 14:30 | 2026-01-15 | 0 |
| 32997 | 32997 | 28 COLLINS RD | 42.325362 | -71.231225 | 51113 | 5 | 2026-01-20 10:45 | 1 | |
| 33265 | 33265 | 503 WATERTOWN ST | 42.357807 | -71.205876 | 51113 | 1 | 2026-01-23 11:45 | 2026-02-18 | 0 |
| 33396 | 33396 | 44 KING ST | 42.350832 | -71.244347 | 51113 | 4 | 2026-01-26 15:15 | 1 | |
| 33430 | 33430 | 27 DURANT ST | 42.35157 | -71.179416 | 51113 | 1 | 2026-01-26 18:15 | 2026-02-13 | 0 |
| 33438 | 33438 | 9 PERRY RD | 42.350553 | -71.243982 | 51113 | 4 | 2026-01-26 19:00 | 1 | |
| 33495 | 33495 | 15 OTIS PARK | 42.347303 | -71.208041 | 51113 | 2 | 2026-01-27 09:45 | 2026-02-17 | 0 |
| 33598 | 33598 | 12 WABAN ST | 42.357456 | -71.189411 | 51113 | 1 | 2026-01-27 12:45 | 2026-02-05 | 0 |
| 33635 | 33635 | 24 HARTMAN RD | 42.307902 | -71.190288 | 51113 | 8 | 2026-01-27 16:45 | 2026-02-05 | 0 |
| 33671 | 33671 | 101 ALLEN AVENUE | 42.326802 | -71.220454 | 51113 | 5 | 2026-01-27 21:45 | 2026-02-18 | 0 |
| 33845 | 33845 | 49 CLIFTON RD | 42.302088 | -71.180145 | 51113 | 8 | 2026-01-28 15:00 | 2026-02-05 | 0 |
| 34355 | 34355 | 91 HIGH ST | 42.315399 | -71.223548 | 51113 | 5 | 2026-02-02 11:30 | 1 | |
| 34463 | 34463 | 1321 CENTRE ST | 42.328827 | -71.196219 | 51113 | 6 | 2026-02-02 15:45 | 2026-02-18 | 0 |
| 34788 | 34788 | 479 BOYLSTON STREET | 42.318977 | -71.188711 | 51113 | 6 | 2026-02-05 09:00 | 2026-02-05 | 0 |
| 34797 | 34797 | 49 CLIFTON RD | 42.302088 | -71.180145 | 51113 | 8 | 2026-02-05 09:45 | 1 | |
| 34940 | 34940 | 24 HARTMAN RD | 42.307902 | -71.190288 | 51113 | 8 | 2026-02-06 15:15 | 1 | |
| 34977 | 34977 | 36 MAPLE AVENUE | 42.353213 | -71.188632 | 51113 | 1 | 2026-02-07 15:15 | 2026-02-13 | 0 |
| 35025 | 35025 | 7 PERRY RD | 42.350598 | -71.24396 | 51113 | 4 | 2026-02-09 09:15 | 2026-03-04 | 0 |
| 35092 | 35092 | 100 DRUMLIN RD | 42.304671 | -71.18186 | 51113 | 8 | 2026-02-10 09:00 | 2026-03-04 | 0 |
| 35127 | 35127 | 389 WOODWARD ST | 42.326316 | -71.226653 | 51113 | 5 | 2026-02-10 16:45 | 1 | |
| 35164 | 35164 | 7 BEETHOVEN AVE | 42.330249 | -71.218967 | 51113 | 5 | 2026-02-11 08:30 | 2026-02-18 | 0 |
| 35200 | 35200 | 33 CRESTWOOD RD | 42.341238 | -71.215187 | 51113 | 2 | 2026-02-11 11:30 | 2026-02-17 | 0 |
| 35217 | 35217 | 33 ROSLYN RD | 42.330204 | -71.223332 | 51113 | 5 | 2026-02-11 15:00 | 2026-02-18 | 0 |
| 35372 | 35372 | 57 DANIEL ST | 42.322338 | -71.193411 | 51113 | 6 | 2026-02-12 17:15 | 1 | |
| 35411 | 35411 | 48 GRALYNN RD | 42.34104 | -71.181252 | 51113 | 7 | 2026-02-13 10:30 | 2026-02-18 | 0 |
| 35641 | 35641 | 385 LINWOOD AVE | 42.35553 | -71.211578 | 51113 | 2 | 2026-02-18 10:15 | 2026-03-04 | 0 |
| 35726 | 35726 | 141 JACKSON ST | 42.320475 | -71.188484 | 51113 | 6 | 2026-02-19 13:15 | 1 | |
| 35727 | 35727 | 177 CHERRY ST | 42.358167 | -71.227485 | 51113 | 3 | 2026-02-19 13:15 | 1 | |
| 35793 | 35793 | 462 WALNUT ST | 42.345441 | -71.205593 | 51113 | 2 | 2026-02-21 14:45 | 1 | |
| 35843 | 35843 | 36 SUNHILL LANE | 42.320036 | -71.195531 | 51113 | 6 | 2026-02-23 13:45 | 2026-03-04 | 0 |
| 35857 | 35857 | 74 MOSMAN ST | 42.363036 | -71.2193 | 51113 | 3 | 2026-02-23 17:15 | 1 | |
| 35969 | 35969 | 70 SPIERS RD | 42.288903 | -71.185779 | 51113 | 8 | 2026-02-24 11:30 | 1 | |
| 35991 | 35991 | 274 PARKER ST | 42.318 | -71.194334 | 51113 | 8 | 2026-02-24 12:00 | 1 | |
| 36055 | 36055 | 69 EVELYN RD | 42.332544 | -71.218823 | 51113 | 5 | 2026-02-24 14:45 | 1 | |
| 36096 | 36096 | 54 HOBART RD | 42.337377 | -71.181977 | 51113 | 7 | 2026-02-24 16:45 | 2026-03-04 | 0 |
| 36110 | 36110 | 367 HOMER ST | 42.337026 | -71.209328 | 51113 | 2 | 2026-02-24 18:15 | 2026-02-24 | 0 |
| 36181 | 36181 | 172 PEARL ST | 42.358941 | -71.193326 | 51113 | 1 | 2026-02-25 10:30 | 1 | |
| 36212 | 36212 | 393 COMMONWEALTH AVE | 42.336909 | -71.182112 | 51113 | 7 | 2026-02-25 13:15 | 1 | |
| 36533 | 36533 | 193 LAKE AVENUE | 42.326496 | -71.204084 | 51113 | 6 | 2026-02-27 02:45 | 1 | |
| 36963 | 36963 | 19 W BOULEVARD RD | 42.340743 | -71.18766 | 51113 | 7 | 2026-03-03 13:30 | 1 | |
| 37075 | 37075 | 385 LINWOOD AVE | 42.35553 | -71.211578 | 51113 | 2 | 2026-03-04 12:30 | 1 | |
| 37179 | 37179 | 20 LORNA RD | 42.341679 | -71.181887 | 51113 | 7 | 2026-03-05 12:15 | 1 | |
| 37201 | 37201 | 51 AVALON RD | 42.328962 | -71.222144 | 51113 | 5 | 2026-03-05 15:45 | 1 | |
| 37277 | 37277 | 47 PARKER AVE | 42.317721 | -71.197043 | 51113 | 6 | 2026-03-06 12:45 | 1 | |
| 37279 | 37279 | 33 CRESTWOOD RD | 42.341238 | -71.215187 | 51113 | 2 | 2026-03-06 13:00 | 1 | |
| 37672 | 37672 | 728 WALNUT ST | 42.336513 | -71.206763 | 51113 | 2 | 2026-03-10 10:45 | 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 );