_locations
153 rows where category_id = 51172
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 |
|---|---|---|---|---|---|---|---|---|---|
| 1121 | 1121 | 231 JACKSON ROAD | 42.355121 | -71.195243 | 51172 | 1 | 2024-06-21 | 0 | |
| 1122 | 1122 | 612 CHESTNUT ST | 42.328938 | -71.225418 | 51172 | 5 | 2024-06-25 | 0 | |
| 1263 | 1263 | 496 COMMONWEALTH AVE | 42.336226 | -71.186293 | 51172 | 6 | 2024-06-24 | 2024-06-24 | 0 |
| 1281 | 1281 | 671 BEACON ST | 42.331375 | -71.188003 | 51172 | 7 | 2024-06-24 | 2024-06-25 | 0 |
| 1300 | 1300 | 230 GRANT AVENUE | 42.332225 | -71.188319 | 51172 | 7 | 2024-06-24 | 2024-06-25 | 0 |
| 2291 | 2291 | 92 PEARL STREET | 42.358328 | -71.189191 | 51172 | 1 | 2024-07-10 02:45 | 2024-07-11 | 0 |
| 2405 | 2405 | 374 HOMER ST | 42.336691 | -71.208945 | 51172 | 2 | 2024-07-11 13:30 | 2024-08-07 | 0 |
| 2572 | 2572 | 54 E ASH STREET | 42.347319 | -71.251193 | 51172 | 4 | 2024-07-15 14:45 | 2024-07-16 | 0 |
| 2758 | 2758 | 56 WEBSTER STREET | 42.350157 | -71.228748 | 51172 | 3 | 2024-07-17 18:15 | 2024-07-24 | 0 |
| 3058 | 3058 | 250 BROOKLINE STREET | 42.301287 | -71.178633 | 51172 | 8 | 2024-07-24 01:30 | 2024-07-26 | 0 |
| 3397 | 3397 | 549 WASHINGTON ST | 42.355144 | -71.195655 | 51172 | 1 | 2024-07-31 08:45 | 2024-07-31 | 0 |
| 3427 | 3427 | 12 WENHAM RD | 42.32782 | -71.208626 | 51172 | 6 | 2024-07-31 13:30 | 2024-08-07 | 0 |
| 3891 | 3891 | 65 HAMMOND ST | 42.33564 | -71.178725 | 51172 | 7 | 2024-08-08 10:15 | 2024-08-09 | 0 |
| 4530 | 4530 | 842 CHESTNUT ST | 42.320707 | -71.226269 | 51172 | 5 | 2024-08-16 15:30 | 2024-08-19 | 0 |
| 4743 | 4743 | 1324 WASHINGTON STREET | 42.349016 | -71.227568 | 51172 | 3 | 2024-08-21 15:30 | 2024-08-26 | 0 |
| 4871 | 4871 | 525 WALTHAM STREET | 42.349761 | -71.22643 | 51172 | 3 | 2024-08-23 22:45 | 2024-08-26 | 0 |
| 4928 | 4928 | 570 CENTRE ST | 42.351507 | -71.185822 | 51172 | 7 | 2024-08-26 14:45 | 2024-08-28 | 0 |
| 5035 | 5035 | 195 CRAFTS ST | 42.357044 | -71.20717 | 51172 | 1 | 2024-08-28 08:45 | 2024-08-29 | 0 |
| 5117 | 5117 | 714 BEACON ST | 42.330684 | -71.189826 | 51172 | 6 | 2024-08-29 12:00 | 2024-08-29 | 0 |
| 5347 | 5347 | 1R CHESTNUT STREET | 42.349349 | -71.225358 | 51172 | 3 | 2024-09-04 18:30 | 2024-09-06 | 0 |
| 5721 | 5721 | 90 WELLS AVE | 42.292659 | -71.198445 | 51172 | 8 | 2024-09-12 08:45 | 2024-09-13 | 0 |
| 6005 | 6005 | 1630 CENTRE ST | 42.320425 | -71.204715 | 51172 | 6 | 2024-09-17 10:45 | 2024-09-17 | 0 |
| 6462 | 6462 | 991 BOYLSTON STREET | 42.318798 | -71.212225 | 51172 | 5 | 2024-09-26 21:00 | 2024-09-27 | 0 |
| 6817 | 6817 | 1958 WASHINGTON ST | 42.333457 | -71.244964 | 51172 | 5 | 2024-10-08 08:45 | 2024-10-15 | 0 |
| 6940 | 6940 | 5 ELLIOT ST | 42.318601 | -71.2126 | 51172 | 5 | 2024-10-10 09:00 | 2024-10-10 | 0 |
| 6998 | 6998 | 1948 WASHINGTON STREET | 42.333631 | -71.244691 | 51172 | 4 | 2024-10-11 09:00 | 2024-10-15 | 0 |
| 7009 | 7009 | 2086 COMMONWEALTH AVE | 42.347649 | -71.247426 | 51172 | 4 | 2024-10-11 11:45 | 2024-10-17 | 0 |
| 7161 | 7161 | 1940 WASHINGTON ST | 42.333389 | -71.243459 | 51172 | 4 | 2024-10-15 14:30 | 2024-10-17 | 0 |
| 7702 | 7702 | 1948 WASHINGTON STREET | 42.333623 | -71.24483 | 51172 | 5 | 2024-10-19 19:45 | 2024-10-22 | 0 |
| 8797 | 8797 | 170 TEMPLE ST | 42.342094 | -71.231551 | 51172 | 3 | 2024-10-30 09:00 | 2024-11-01 | 0 |
| 9941 | 9941 | 300 WASHINGTON ST | 42.356588 | -71.18595 | 51172 | 1 | 2024-11-08 09:00 | 2024-11-08 | 0 |
| 9990 | 9990 | 165 MASSACHUSETTS 9 | 42.321329 | -71.17306 | 51172 | 7 | 2024-11-09 13:00 | 2024-11-12 | 0 |
| 10142 | 10142 | 5 ELLIOT STREET | 42.318715 | -71.212499 | 51172 | 5 | 2024-11-14 09:00 | 2024-11-14 | 0 |
| 10315 | 10315 | 1482 WASHINGTON STREET | 42.346526 | -71.232031 | 51172 | 3 | 2024-11-19 10:45 | 2024-11-26 | 0 |
| 10409 | 10409 | 554 WASHINGTON STREET | 42.354871 | -71.19566 | 51172 | 1 | 2024-11-20 23:45 | 2024-11-21 | 0 |
| 10424 | 10424 | 98 WINCHESTER ST | 42.316675 | -71.208514 | 51172 | 5 | 2024-11-21 09:15 | 2024-11-21 | 0 |
| 10615 | 10615 | 5 NORTH ST | 42.359807 | -71.215479 | 51172 | 2 | 2024-11-25 09:30 | 2024-11-27 | 0 |
| 10642 | 10642 | 79 JEWETT ST | 42.358462 | -71.191306 | 51172 | 1 | 2024-11-25 13:45 | 2024-11-26 | 0 |
| 10763 | 10763 | 690 WATERTOWN ST | 42.354127 | -71.213213 | 51172 | 2 | 2024-11-27 12:15 | 2024-12-04 | 0 |
| 11060 | 11060 | 231 HAMMOND POND PARKWAY | 42.320924 | -71.172486 | 51172 | 7 | 2024-12-04 21:15 | 2024-12-05 | 0 |
| 11310 | 11310 | 1 CHESTNUT ST | 42.349156 | -71.225629 | 51172 | 3 | 2024-12-09 16:45 | 2024-12-10 | 0 |
| 11486 | 11486 | 500 BEACON ST | 42.331899 | -71.180265 | 51172 | 7 | 2024-12-11 09:15 | 2024-12-11 | 0 |
| 11807 | 11807 | 2345 WASHINGTON ST | 42.325606 | -71.257528 | 51172 | 4 | 2024-12-17 12:15 | 2024-12-17 | 0 |
| 11812 | 11812 | 40 HARVARD ST | 42.351073 | -71.201409 | 51172 | 2 | 2024-12-17 13:45 | 2024-12-17 | 0 |
| 12261 | 12261 | 538 CALIFORNIA STREET | 42.361491 | -71.209498 | 51172 | 1 | 2024-12-26 14:45 | 2024-12-27 | 0 |
| 12886 | 12886 | 255 WASHINGTON STREET | 42.357372 | -71.184223 | 51172 | 1 | 2025-01-08 12:45 | 2025-01-09 | 0 |
| 13616 | 13616 | 449 COMMONWEALTH AVE | 42.337017 | -71.184704 | 51172 | 7 | 2025-01-23 17:00 | 2025-02-04 | 0 |
| 13843 | 13843 | 5 DEDHAM STREET | 42.316453 | -71.208595 | 51172 | 8 | 2025-01-28 16:30 | 2025-01-28 | 0 |
| 13918 | 13918 | 98 WINCHESTER ST | 42.316677 | -71.208513 | 51172 | 5 | 2025-01-30 11:15 | 2025-02-04 | 0 |
| 13993 | 13993 | 624 WASHINGTON ST | 42.353929 | -71.198988 | 51172 | 2 | 2025-01-31 15:15 | 2025-02-04 | 0 |
| 14344 | 14344 | 1001 BOYLSTON STREET | 42.319147 | -71.212655 | 51172 | 6 | 2025-02-08 21:00 | 2025-02-12 | 0 |
| 14448 | 14448 | 1670 CENTRE ST | 42.319611 | -71.206137 | 51172 | 6 | 2025-02-10 15:45 | 2025-02-12 | 0 |
| 14581 | 14581 | 1496 WASHINGTON STREET | 42.346038 | -71.232633 | 51172 | 3 | 2025-02-13 08:45 | 2025-02-20 | 0 |
| 14944 | 14944 | 475 BROOKLINE ST | 42.299046 | -71.186 | 51172 | 8 | 2025-02-18 11:15 | 2025-02-19 | 0 |
| 14966 | 14966 | 470 COMMONWEALTH AVE | 42.336261 | -71.185518 | 51172 | 7 | 2025-02-18 12:00 | 2025-02-21 | 0 |
| 15143 | 15143 | 54 GRANT AVENUE | 42.336899 | -71.185242 | 51172 | 7 | 2025-02-20 08:00 | 2025-02-21 | 0 |
| 15196 | 15196 | 401 WATERTOWN ST | 42.360273 | -71.202483 | 51172 | 1 | 2025-02-20 15:00 | 2025-02-20 | 0 |
| 15202 | 15202 | 1314 WASHINGTON ST | 42.349041 | -71.227071 | 51172 | 3 | 2025-02-20 16:00 | 2025-02-26 | 0 |
| 15237 | 15237 | 470 COMMONWEALTH AVE | 42.336261 | -71.185518 | 51172 | 7 | 2025-02-21 12:45 | 2025-03-04 | 0 |
| 15299 | 15299 | 823 WASHINGTON ST | 42.351876 | -71.206866 | 51172 | 2 | 2025-02-24 09:00 | 2025-02-24 | 0 |
| 15562 | 15562 | 94 QUINOBEQUIN ROAD | 42.325366 | -71.250248 | 51172 | 4 | 2025-02-27 14:00 | 2025-03-03 | 0 |
| 15570 | 15570 | 570 CENTRE ST | 42.351507 | -71.18582 | 51172 | 7 | 2025-02-27 15:45 | 2025-03-03 | 0 |
| 15678 | 15678 | 1946 WASHINGTON ST | 42.332922 | -71.242587 | 51172 | 4 | 2025-03-03 14:00 | 2025-03-04 | 0 |
| 15791 | 15791 | 20 HARVARD ST | 42.351885 | -71.201691 | 51172 | 2 | 2025-03-05 16:15 | 2025-03-11 | 0 |
| 15988 | 15988 | 366 AUBURNDALE AVE | 42.349698 | -71.247087 | 51172 | 4 | 2025-03-08 07:45 | 2025-03-11 | 0 |
| 16022 | 16022 | 833 WASHINGTON STREET | 42.35164 | -71.207258 | 51172 | 2 | 2025-03-08 20:45 | 1 | |
| 16085 | 16085 | 680 BEACON ST | 42.330879 | -71.188196 | 51172 | 6 | 2025-03-10 09:00 | 2025-03-10 | 0 |
| 16582 | 16582 | 303 WASHINGTON ST | 42.357213 | -71.186238 | 51172 | 1 | 2025-03-20 10:30 | 2025-03-21 | 0 |
| 16600 | 16600 | 283 BROOKLINE STREET | 42.301121 | -71.178526 | 51172 | 8 | 2025-03-20 13:30 | 2025-03-21 | 0 |
| 17136 | 17136 | 911 WASHINGTON ST | 42.351354 | -71.210196 | 51172 | 2 | 2025-04-01 09:45 | 2025-04-23 | 0 |
| 17157 | 17157 | 2077 WASHINGTON ST | 42.330321 | -71.248617 | 51172 | 4 | 2025-04-01 14:30 | 2025-04-11 | 0 |
| 17170 | 17170 | 321 COMMONWEALTH AVE | 42.336585 | -71.178786 | 51172 | 7 | 2025-04-01 16:30 | 2025-04-11 | 0 |
| 17171 | 17171 | 823 WASHINGTON ST | 42.351876 | -71.206866 | 51172 | 2 | 2025-04-01 16:30 | 2025-04-23 | 0 |
| 17187 | 17187 | 21 A LAKE AVENUE | 42.330439 | -71.198857 | 51172 | 6 | 2025-04-02 07:45 | 2025-04-02 | 0 |
| 17335 | 17335 | 1670 CENTRE STREET | 42.319544 | -71.206421 | 51172 | 6 | 2025-04-05 10:30 | 2025-04-07 | 0 |
| 17434 | 17434 | 865 BOYLSTON STREET | 42.319625 | -71.206602 | 51172 | 6 | 2025-04-07 16:30 | 2025-04-23 | 0 |
| 17665 | 17665 | 1750 COMMONWEALTH AVE | 42.340653 | -71.238623 | 51172 | 4 | 2025-04-10 15:15 | 2025-04-23 | 0 |
| 17932 | 17932 | 1280 WASHINGTON STREET | 42.34946 | -71.22602 | 51172 | 3 | 2025-04-16 15:15 | 2025-04-25 | 0 |
| 18088 | 18088 | 1 QUINOBEQUIN RD | 42.32684 | -71.252629 | 51172 | 4 | 2025-04-22 08:45 | 2025-04-23 | 0 |
| 18126 | 18126 | 261 CENTRE ST | 42.358679 | -71.18525 | 51172 | 1 | 2025-04-22 12:30 | 2025-04-23 | 0 |
| 18457 | 18457 | 268 WATERTOWN ST | 42.361245 | -71.197277 | 51172 | 1 | 2025-04-28 15:15 | 2025-04-29 | 0 |
| 18605 | 18605 | 287 WALNUT ST | 42.351066 | -71.20733 | 51172 | 2 | 2025-04-30 16:30 | 2025-07-15 | 0 |
| 18973 | 18973 | 658 WATERTOWN ST | 42.354594 | -71.211825 | 51172 | 2 | 2025-05-07 10:30 | 2025-05-13 | 0 |
| 19006 | 19006 | 1637 CENTRE ST | 42.320439 | -71.205381 | 51172 | 6 | 2025-05-07 15:45 | 2025-05-13 | 0 |
| 19374 | 19374 | 629 COMMONWEALTH AVE | 42.336414 | -71.192858 | 51172 | 7 | 2025-05-14 11:00 | 2025-07-29 | 0 |
| 19482 | 19482 | 583 WATERTOWN ST | 42.35616 | -71.208918 | 51172 | 2 | 2025-05-16 09:15 | 2025-05-19 | 0 |
| 19944 | 19944 | 394 WATERTOWN STREET | 42.360193 | -71.201907 | 51172 | 1 | 2025-05-23 14:00 | 2025-10-23 | 0 |
| 20433 | 20433 | 935 WASHINGTON ST | 42.351255 | -71.211033 | 51172 | 2 | 2025-06-02 09:30 | 2025-07-22 | 0 |
| 20711 | 20711 | 1293 WASHINGTON ST | 42.349536 | -71.226518 | 51172 | 3 | 2025-06-04 18:15 | 2025-07-22 | 0 |
| 21410 | 21410 | 829 WASHINGTON STREET | 42.351759 | -71.207119 | 51172 | 2 | 2025-06-16 15:15 | 1 | |
| 21414 | 21414 | 885 WASHINGTON STREET | 42.351632 | -71.209393 | 51172 | 2 | 2025-06-16 15:45 | 1 | |
| 21450 | 21450 | 621 WASHINGTON STREET | 42.354138 | -71.19905 | 51172 | 1 | 2025-06-17 07:00 | 2025-10-23 | 0 |
| 21617 | 21617 | 527 WALTHAM ST | 42.34968 | -71.226585 | 51172 | 3 | 2025-06-18 13:00 | 2025-06-26 | 0 |
| 21751 | 21751 | 305 COMMONWEALTH AVE | 42.336549 | -71.178246 | 51172 | 7 | 2025-06-20 12:45 | 2025-07-07 | 0 |
| 23262 | 23262 | 310 COMMONWEALTH AVENUE | 42.335923 | -71.178279 | 51172 | 7 | 2025-07-14 23:15 | 2025-07-29 | 0 |
| 23263 | 23263 | 9 WACHUSETT RD | 42.335847 | -71.17943 | 51172 | 7 | 2025-07-14 23:15 | 2025-07-29 | 0 |
| 23527 | 23527 | 259 WAVERLEY AVE | 42.347052 | -71.181257 | 51172 | 7 | 2025-07-16 15:00 | 2025-07-29 | 0 |
| 23535 | 23535 | 1321 WASHINGTON ST | 42.349464 | -71.227571 | 51172 | 3 | 2025-07-16 17:45 | 1 | |
| 23724 | 23724 | 226 LEXINGTON STREET | 42.353947 | -71.244691 | 51172 | 4 | 2025-07-20 09:30 | 2025-09-19 | 0 |
| 23742 | 23742 | 305 COMMONWEALTH AVE | 42.336549 | -71.178246 | 51172 | 7 | 2025-07-21 05:45 | 2025-07-29 | 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 );