_locations
118 rows where category_id = 53464
This data as json, CSV (advanced)
Suggested facets: ward, active, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 93 | 93 | 1707 WASHINGTON ST | 42.340834 | -71.239182 | 53464 | 4 | 2024-06-20 | 0 | |
| 94 | 94 | 242 LAKE AVE | 42.32508 | -71.202985 | 53464 | 6 | 2024-06-20 | 0 | |
| 95 | 95 | 259 LEXINGTON ST | 42.353118 | -71.245508 | 53464 | 4 | 2024-06-20 | 0 | |
| 96 | 96 | 31 BOTSFORD RD | 42.305108 | -71.174392 | 53464 | 8 | 2024-06-18 | 0 | |
| 579 | 579 | 54 PETTEE ST | 42.313309 | -71.221444 | 53464 | 5 | 2024-06-17 | 2024-06-18 | 0 |
| 834 | 834 | 285 ALBEMARLE RD | 42.356351 | -71.216537 | 53464 | 3 | 2024-06-21 | 2024-10-01 | 0 |
| 1106 | 1106 | 54 PETTEE ST | 42.313309 | -71.221444 | 53464 | 5 | 2024-06-26 | 2024-07-02 | 0 |
| 1796 | 1796 | 15 NORWOOD AVE | 42.328977 | -71.198183 | 53464 | 6 | 2024-07-11 | 2024-07-24 | 0 |
| 2278 | 2278 | 54 PETTEE ST | 42.313309 | -71.221444 | 53464 | 5 | 2024-07-23 | 2024-10-02 | 0 |
| 2332 | 2332 | 1515 WASHINGTON ST | 42.346008 | -71.23354 | 53464 | 3 | 2024-07-24 | 2024-08-28 | 0 |
| 2532 | 2532 | 30 SALISBURY RD | 42.34863 | -71.195598 | 53464 | 2 | 2024-07-31 | 2024-09-11 | 0 |
| 2664 | 2664 | 90 LAKE AVE | 42.329316 | -71.201011 | 53464 | 6 | 2024-08-03 | 2024-08-06 | 0 |
| 2673 | 2673 | 223 ELLIOT ST | 42.312699 | -71.218315 | 53464 | 5 | 2024-08-04 | 2024-08-28 | 0 |
| 2803 | 2803 | 1025 WALNUT ST | 42.326343 | -71.206644 | 53464 | 6 | 2024-08-07 | 2024-08-28 | 0 |
| 3099 | 3099 | 275 CENTRE ST | 42.358545 | -71.18527 | 53464 | 1 | 2024-08-12 | 2024-08-21 | 0 |
| 3155 | 3155 | 15 ROBERTS AVE | 42.3524 | -71.211877 | 53464 | 2 | 2024-08-13 | 2024-08-21 | 0 |
| 3793 | 3793 | 289 WEBSTER ST | 42.348966 | -71.239483 | 53464 | 4 | 2024-08-30 | 2024-09-10 | 0 |
| 3869 | 3869 | 190 LANGLEY RD | 42.326804 | -71.187749 | 53464 | 7 | 2024-09-03 | 2024-09-10 | 0 |
| 3871 | 3871 | 217 CRAFTS STREET | 42.357293 | -71.208191 | 53464 | 1 | 2024-09-03 | 2024-09-10 | 0 |
| 3907 | 3907 | 460 CALIFORNIA ST | 42.362998 | -71.206687 | 53464 | 1 | 2024-09-04 | 2024-09-10 | 0 |
| 4020 | 4020 | 26 ALBA CIR | 42.348715 | -71.183977 | 53464 | 7 | 2024-09-07 | 2024-09-10 | 0 |
| 4036 | 4036 | 16 ALBA CIR | 42.34847 | -71.183838 | 53464 | 7 | 2024-09-09 | 2024-09-11 | 0 |
| 4225 | 4225 | 28 LENOX ST | 42.344543 | -71.218987 | 53464 | 2 | 2024-09-12 | 2024-09-25 | 0 |
| 4460 | 4460 | 479 NAHANTON STREET | 42.297325 | -71.207219 | 53464 | 8 | 2024-09-23 | 2024-10-02 | 0 |
| 4461 | 4461 | 572 DEDHAM ST | 42.304694 | -71.192766 | 53464 | 8 | 2024-09-23 | 2024-11-06 | 0 |
| 4881 | 4881 | 10 MYRTLE ST | 42.344464 | -71.234105 | 53464 | 3 | 2024-10-03 | 2024-10-22 | 0 |
| 5109 | 5109 | 658 DEDHAM ST | 42.302707 | -71.19049 | 53464 | 8 | 2024-10-11 | 2024-11-04 | 0 |
| 5513 | 5513 | DUCHESNE HALL | 42.343306 | -71.190756 | 53464 | 2 | 2024-10-20 | 2024-10-24 | 0 |
| 5760 | 5760 | 563 SAW MILL BROOK PKWY | 42.293634 | -71.182721 | 53464 | 8 | 2024-10-23 | 2024-10-28 | 0 |
| 6671 | 6671 | 391 DEDHAM ST | 42.30873 | -71.199222 | 53464 | 8 | 2024-11-07 | 2025-02-25 | 0 |
| 7817 | 7817 | 63 BONAD RD | 42.339752 | -71.218852 | 53464 | 3 | 2024-12-09 | 2025-01-16 | 0 |
| 7835 | 7835 | 64 BONAD RD | 42.340078 | -71.219135 | 53464 | 3 | 2024-12-09 | 2024-12-20 | 0 |
| 7946 | 7946 | 76 HIGHLAND AVE | 42.348867 | -71.210181 | 53464 | 2 | 2024-12-10 | 2025-04-01 | 0 |
| 8434 | 8434 | 24 PEMBROKE ST | 42.352156 | -71.177053 | 53464 | 1 | 2024-12-23 | 2025-04-08 | 0 |
| 8658 | 8658 | 364 AUBURNDALE AVE | 42.349656 | -71.246948 | 53464 | 4 | 2024-12-30 | 2025-01-07 | 0 |
| 8690 | 8690 | 57 OAK AVE | 42.350749 | -71.232188 | 53464 | 3 | 2024-12-31 | 2025-02-21 | 0 |
| 8824 | 8824 | 1216 CHESTNUT ST | 42.309486 | -71.220694 | 53464 | 5 | 2025-01-03 | 2025-01-13 | 0 |
| 8914 | 8914 | 104 VINE ST | 42.303215 | -71.171518 | 53464 | 8 | 2025-01-06 | 2025-01-13 | 0 |
| 8927 | 8927 | 427 CENTRE ST | 42.355522 | -71.186506 | 53464 | 1 | 2025-01-06 | 2025-05-13 | 0 |
| 8985 | 8985 | 18 ELIOT AVE | 42.352918 | -71.218478 | 53464 | 3 | 2025-01-07 | 2025-01-07 | 0 |
| 9659 | 9659 | 87 COLLINS RD | 42.323508 | -71.231598 | 53464 | 5 | 2025-01-24 | 2025-02-06 | 0 |
| 9701 | 9701 | 82 COLLINS RD | 42.323775 | -71.231322 | 53464 | 5 | 2025-01-25 | 2025-02-06 | 0 |
| 9726 | 9726 | 11 FENWICK RD | 42.322788 | -71.230982 | 53464 | 5 | 2025-01-27 | 2025-01-29 | 0 |
| 9734 | 9734 | 8 CAVANAUGH PATH | 42.292917 | -71.182418 | 53464 | 8 | 2025-01-27 | 2025-02-06 | 0 |
| 9761 | 9761 | 2 SAINT MARYS STREET | 42.331553 | -71.262286 | 53464 | 4 | 2025-01-28 | 2025-02-06 | 0 |
| 9764 | 9764 | 245 GROVE ST | 42.339078 | -71.251311 | 53464 | 4 | 2025-01-28 | 2025-01-29 | 0 |
| 9807 | 9807 | 39 CLEARWATER ROAD | 42.332854 | -71.259862 | 53464 | 4 | 2025-01-28 | 2025-02-06 | 0 |
| 9948 | 9948 | 525 WALTHAM STREET | 42.349708 | -71.226378 | 53464 | 3 | 2025-02-03 | 2025-03-03 | 0 |
| 9953 | 9953 | 157 SPIERS RD | 42.290811 | -71.182976 | 53464 | 8 | 2025-02-03 | 2025-02-06 | 0 |
| 10027 | 10027 | 26 COMMONWEALTH PARK | 42.338997 | -71.202906 | 53464 | 2 | 2025-02-04 | 2025-02-05 | 0 |
| 10225 | 10225 | 48 CHERRY PL | 42.356106 | -71.230064 | 53464 | 3 | 2025-02-09 | 2025-02-21 | 0 |
| 10291 | 10291 | 36 TROWBRIDGE AVE | 42.345162 | -71.204112 | 53464 | 2 | 2025-02-10 | 2025-02-21 | 0 |
| 10328 | 10328 | 77 MANDALAY ROAD | 42.33942 | -71.179996 | 53464 | 7 | 2025-02-11 | 2025-02-21 | 0 |
| 10351 | 10351 | 15 FARLOW RD | 42.346782 | -71.180132 | 53464 | 7 | 2025-02-11 | 2025-02-21 | 0 |
| 10419 | 10419 | 39 NARDELL RD | 42.308811 | -71.179272 | 53464 | 8 | 2025-02-13 | 2025-02-21 | 0 |
| 10447 | 10447 | 48 DERBY ST | 42.356664 | -71.225672 | 53464 | 3 | 2025-02-14 | 2025-02-21 | 0 |
| 10590 | 10590 | 45 CHERRY PL | 42.356493 | -71.22997 | 53464 | 3 | 2025-02-17 | 2025-02-21 | 0 |
| 10655 | 10655 | 8 SILVER BIRCH RD | 42.320124 | -71.221334 | 53464 | 5 | 2025-02-18 | 2025-02-21 | 0 |
| 10680 | 10680 | 51 HATFIELD RD | 42.359571 | -71.224349 | 53464 | 3 | 2025-02-18 | 2025-02-21 | 0 |
| 10958 | 10958 | 1112 CENTRE ST | 42.334218 | -71.19311 | 53464 | 6 | 2025-02-21 | 2025-02-21 | 0 |
| 11028 | 11028 | 66 CRAGMORE RD | 42.319174 | -71.221728 | 53464 | 5 | 2025-02-24 | 2025-03-31 | 0 |
| 11228 | 11228 | 67 RANDLETT PARK | 42.354576 | -71.219246 | 53464 | 3 | 2025-02-27 | 2025-04-11 | 0 |
| 11312 | 11312 | 41 NEEDHAM STREET | 42.315587 | -71.210293 | 53464 | 5 | 2025-03-04 | 2025-03-07 | 0 |
| 11368 | 11368 | 67 CHURCH ST | 42.352137 | -71.182494 | 53464 | 1 | 2025-03-05 | 2025-03-28 | 0 |
| 11372 | 11372 | 521 WALTHAM ST | 42.349752 | -71.226581 | 53464 | 3 | 2025-03-05 | 2025-04-30 | 0 |
| 11953 | 11953 | 37 WILDE RD | 42.327549 | -71.243586 | 53464 | 5 | 2025-03-20 | 2025-03-28 | 0 |
| 12258 | 12258 | 49 SHERIDAN STREET | 42.357772 | -71.233545 | 53464 | 4 | 2025-03-28 | 2025-04-01 | 0 |
| 12365 | 12365 | 1225 CHESTNUT ST | 42.309261 | -71.220362 | 53464 | 5 | 2025-04-01 | 2025-04-16 | 0 |
| 12521 | 12521 | 84 FORDHAM RD | 42.359931 | -71.225613 | 53464 | 3 | 2025-04-07 | 2025-05-08 | 0 |
| 12636 | 12636 | 425 CHESTNUT ST | 42.335028 | -71.224097 | 53464 | 5 | 2025-04-09 | 1 | |
| 12724 | 12724 | 349 DEDHAM ST | 42.308937 | -71.200904 | 53464 | 8 | 2025-04-11 | 1 | |
| 12920 | 12920 | 6 BONTEMPO RD | 42.293133 | -71.184429 | 53464 | 8 | 2025-04-17 | 1 | |
| 12937 | 12937 | 432 CHESTNUT ST | 42.334686 | -71.223809 | 53464 | 5 | 2025-04-17 | 1 | |
| 13053 | 13053 | 16 SCOTNEY RD | 42.303267 | -71.174682 | 53464 | 8 | 2025-04-22 | 2025-05-01 | 0 |
| 13117 | 13117 | 500 DEDHAM STREET | 42.306802 | -71.195317 | 53464 | 8 | 2025-04-24 | 2025-04-30 | 0 |
| 13161 | 13161 | 12 CUSHING ST | 42.323445 | -71.20193 | 53464 | 6 | 2025-04-24 | 1 | |
| 13715 | 13715 | 79 FAXON ST | 42.362262 | -71.19887 | 53464 | 1 | 2025-05-07 | 1 | |
| 13986 | 13986 | 64 CRAFTS ST | 42.3549 | -71.201903 | 53464 | 2 | 2025-05-14 | 2025-05-20 | 0 |
| 14712 | 14712 | 101 AVALON RD | 42.328674 | -71.224268 | 53464 | 5 | 2025-05-30 | 2025-05-30 | 0 |
| 14715 | 14715 | 63 AVALON RD | 42.328935 | -71.222567 | 53464 | 5 | 2025-05-30 | 1 | |
| 14788 | 14788 | 50 HYDE STREET | 42.324827 | -71.205016 | 53464 | 6 | 2025-05-31 | 2025-06-04 | 0 |
| 15149 | 15149 | 418 WOODWARD ST | 42.325992 | -71.228039 | 53464 | 5 | 2025-06-06 | 2025-11-10 | 0 |
| 15279 | 15279 | 54 MILL ST | 42.340626 | -71.195144 | 53464 | 2 | 2025-06-09 | 2025-06-26 | 0 |
| 15312 | 15312 | 35 PLACID RD | 42.312123 | -71.198663 | 53464 | 8 | 2025-06-10 | 2025-06-23 | 0 |
| 15854 | 15854 | 104 VINE ST | 42.303204 | -71.171496 | 53464 | 8 | 2025-06-20 | 2025-07-07 | 0 |
| 16684 | 16684 | 20 JUDITH ROAD | 42.335011 | -71.206475 | 53464 | 6 | 2025-07-07 | 2025-07-14 | 0 |
| 16705 | 16705 | 158 ADAMS ST | 42.359364 | -71.201232 | 53464 | 1 | 2025-07-08 | 1 | |
| 16958 | 16958 | 490 AUBURN ST | 42.344964 | -71.253185 | 53464 | 4 | 2025-07-12 | 1 | |
| 17690 | 17690 | 24 BREAMORE RD | 42.356979 | -71.178611 | 53464 | 1 | 2025-07-25 | 2025-07-29 | 0 |
| 17691 | 17691 | 25 BREAMORE RD | 42.357051 | -71.178998 | 53464 | 1 | 2025-07-25 | 2025-08-05 | 0 |
| 17771 | 17771 | 887 CHESTNUT ST | 42.318846 | -71.226356 | 53464 | 5 | 2025-07-28 | 2025-08-06 | 0 |
| 17790 | 17790 | 10 SCOTNEY RD | 42.303609 | -71.174601 | 53464 | 8 | 2025-07-29 | 2025-08-18 | 0 |
| 18014 | 18014 | 231 SPIERS RD | 42.292782 | -71.180874 | 53464 | 8 | 2025-08-04 | 1 | |
| 18154 | 18154 | 55 DRUMLIN RD | 42.306165 | -71.181482 | 53464 | 8 | 2025-08-06 | 2025-09-11 | 0 |
| 18419 | 18419 | 315 WOODWARD STREET | 42.3247 | -71.223963 | 53464 | 5 | 2025-08-13 | 2025-09-23 | 0 |
| 18446 | 18446 | 522 AUBURN STREET | 42.344781 | -71.254883 | 53464 | 4 | 2025-08-13 | 1 | |
| 18569 | 18569 | 63 BONAD RD | 42.339753 | -71.21885 | 53464 | 3 | 2025-08-18 | 1 | |
| 18895 | 18895 | 33 BIRCH HILL RD | 42.347628 | -71.21255 | 53464 | 2 | 2025-08-28 | 2025-08-28 | 0 |
| 18969 | 18969 | 374 HAMMOND STREET | 42.330284 | -71.1674 | 53464 | 7 | 2025-09-01 | 2025-09-16 | 0 |
| 19062 | 19062 | 100 PRINCE ST | 42.341859 | -71.2256 | 53464 | 3 | 2025-09-03 | 2025-09-23 | 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 );