_locations
72 rows where category_id = 51171
This data as json, CSV (advanced)
Suggested facets: ward, added (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 412 | 412 | 2077 MASSACHUSETTS 16 | 42.330252 | -71.24836 | 51171 | 4 | 2024-06-17 | 0 | |
| 504 | 504 | BEACON ST | 51171 | 2024-06-14 | 2024-06-17 | 0 | |||
| 585 | 585 | 431 WASHINGTON ST | 42.355952 | -71.190472 | 51171 | 1 | 2024-06-17 | 2024-06-17 | 0 |
| 746 | 746 | 333 NAHANTON ST | 42.299379 | -71.204223 | 51171 | 8 | 2024-06-20 | 2024-06-20 | 0 |
| 1980 | 1980 | COMMONWEALTH AVENUE MEDIAN | 42.338232 | -71.20928 | 51171 | 2 | 2024-07-04 14:15 | 2024-07-08 | 0 |
| 2459 | 2459 | 629 COMMONWEALTH AVE | 42.336412 | -71.192857 | 51171 | 7 | 2024-07-12 09:45 | 2024-07-12 | 0 |
| 2461 | 2461 | 87 HOBART RD | 42.336236 | -71.182698 | 51171 | 7 | 2024-07-12 10:00 | 2024-07-12 | 0 |
| 2805 | 2805 | WASHINGTON ST | 42.347953 | -71.232147 | 51171 | 3 | 2024-07-18 13:15 | 2024-07-26 | 0 |
| 3119 | 3119 | 421 WAVERLEY AVENUE | 42.341498 | -71.182871 | 51171 | 7 | 2024-07-25 08:45 | 2024-08-01 | 0 |
| 3745 | 3745 | 287-289 AUBURN STREET | 42.346676 | -71.24689 | 51171 | 4 | 2024-08-06 12:45 | 2024-08-07 | 0 |
| 4246 | 4246 | 1195 BOYLSTON STREET | 42.32376 | -71.164251 | 51171 | 2024-08-12 20:15 | 2024-08-13 | 0 | |
| 5171 | 5171 | 2077 WASHINGTON ST | 42.33031 | -71.248644 | 51171 | 4 | 2024-08-30 14:00 | 2024-09-03 | 0 |
| 5516 | 5516 | 1940 WASHINGTON ST | 42.333389 | -71.243459 | 51171 | 4 | 2024-09-09 09:45 | 2024-09-09 | 0 |
| 5565 | 5565 | 821 BEACON STREET | 42.330157 | -71.194888 | 51171 | 6 | 2024-09-10 08:00 | 2024-09-11 | 0 |
| 6523 | 6523 | WATERTOWN ST @ ADAMS ST | 42.359952 | -71.202364 | 51171 | 1 | 2024-09-28 17:15 | 2024-10-01 | 0 |
| 7676 | 7676 | 465 CENTRE ST | 42.354744 | -71.186674 | 51171 | 1 | 2024-10-18 16:15 | 2024-10-21 | 0 |
| 8663 | 8663 | 255 WASHINGTON ST | 42.357767 | -71.183842 | 51171 | 1 | 2024-10-29 10:15 | 2024-11-04 | 0 |
| 9429 | 9429 | 2345 WASHINGTON STREET | 42.325505 | -71.257634 | 51171 | 4 | 2024-11-03 14:45 | 2024-11-07 | 0 |
| 9607 | 9607 | 207 NAHANTON ST | 42.300804 | -71.196786 | 51171 | 8 | 2024-11-05 12:00 | 2024-11-12 | 0 |
| 10139 | 10139 | 1697 BEACON ST | 42.326457 | -71.232711 | 51171 | 5 | 2024-11-14 08:45 | 2024-11-18 | 0 |
| 11975 | 11975 | 108 JACKSON ROAD | 42.359378 | -71.194748 | 51171 | 1 | 2024-12-20 17:30 | 2024-12-27 | 0 |
| 13305 | 13305 | 334 WATERTOWN ST | 42.360768 | -71.199941 | 51171 | 1 | 2025-01-17 14:30 | 2025-01-23 | 0 |
| 13465 | 13465 | 410 LEXINGTON STREET | 42.348224 | -71.247176 | 51171 | 4 | 2025-01-21 20:00 | 2025-02-05 | 0 |
| 13757 | 13757 | 68 CHESTNUT STREET | 42.34785 | -71.225004 | 51171 | 3 | 2025-01-27 19:00 | 2025-01-28 | 0 |
| 15354 | 15354 | 2221 WASHINGTON ST | 42.327306 | -71.253963 | 51171 | 4 | 2025-02-24 15:45 | 2025-02-26 | 0 |
| 16101 | 16101 | 1007 BEACON ST | 42.330807 | -71.203239 | 51171 | 6 | 2025-03-10 10:30 | 2025-03-10 | 0 |
| 16196 | 16196 | 14-16 BRIDGE STREET | 42.364951 | -71.204072 | 51171 | 1 | 2025-03-11 12:15 | 2025-03-14 | 0 |
| 16358 | 16358 | 94 GROVE ST | 42.343308 | -71.248226 | 51171 | 4 | 2025-03-14 11:15 | 2025-03-17 | 0 |
| 16425 | 16425 | 216 PEARL STREET | 42.359624 | -71.195488 | 51171 | 1 | 2025-03-17 09:00 | 2025-03-17 | 0 |
| 17317 | 17317 | 2078 COMMONWEALTH AVE | 42.347574 | -71.24666 | 51171 | 4 | 2025-04-04 15:30 | 2025-04-23 | 0 |
| 17674 | 17674 | 1702 WASHINGTON ST | 42.340824 | -71.2386 | 51171 | 4 | 2025-04-10 17:45 | 2025-04-15 | 0 |
| 17715 | 17715 | 529 CRAFTS ST | 42.360543 | -71.221788 | 51171 | 3 | 2025-04-11 15:00 | 2025-04-23 | 0 |
| 17939 | 17939 | 18 GATEWAY CTR | 42.356826 | -71.186 | 51171 | 1 | 2025-04-16 19:00 | 2025-04-17 | 0 |
| 18769 | 18769 | 437 WASHINGTON STREET | 42.35603 | -71.190533 | 51171 | 1 | 2025-05-05 01:45 | 2025-07-15 | 0 |
| 19500 | 19500 | 640 COMMONWEALTH AVE | 42.335802 | -71.193353 | 51171 | 6 | 2025-05-16 13:45 | 2025-05-16 | 0 |
| 19685 | 19685 | 255 WASHINGTON STREET | 42.357515 | -71.18418 | 51171 | 1 | 2025-05-20 10:30 | 1 | |
| 21114 | 21114 | 1888 COMMONWEALTH AVE | 42.344676 | -71.241399 | 51171 | 4 | 2025-06-11 09:15 | 2025-06-11 | 0 |
| 22218 | 22218 | 1279 WASHINGTON ST | 42.34959 | -71.225564 | 51171 | 3 | 2025-06-26 16:00 | 2025-06-30 | 0 |
| 22363 | 22363 | 1664 CENTRE ST | 42.319737 | -71.205908 | 51171 | 6 | 2025-06-30 15:15 | 2025-07-15 | 0 |
| 22590 | 22590 | 235 CALIFORNIA ST | 42.365016 | -71.197866 | 51171 | 1 | 2025-07-02 22:15 | 2025-07-26 | 0 |
| 22878 | 22878 | 978 CENTRE STREET | 42.33609 | -71.1933 | 51171 | 7 | 2025-07-08 22:15 | 2025-07-29 | 0 |
| 23227 | 23227 | 282 WAVERLEY AVENUE | 42.346716 | -71.180854 | 51171 | 7 | 2025-07-14 14:30 | 2025-07-29 | 0 |
| 23675 | 23675 | 4 JUDITH ROAD | 42.335519 | -71.207505 | 51171 | 2 | 2025-07-18 13:00 | 1 | |
| 23748 | 23748 | 537 CALIFORNIA ST | 42.361542 | -71.209832 | 51171 | 2 | 2025-07-21 07:30 | 2025-07-23 | 0 |
| 23855 | 23855 | 1572 COMMONWEALTH AVENUE | 42.339115 | -71.231022 | 51171 | 3 | 2025-07-21 23:30 | 1 | |
| 23891 | 23891 | 275 WAVERLEY AVE | 42.346449 | -71.181428 | 51171 | 7 | 2025-07-22 12:30 | 2025-07-29 | 0 |
| 24508 | 24508 | 32 HARVARD ST | 42.351408 | -71.201547 | 51171 | 2 | 2025-08-01 12:45 | 2025-08-02 | 0 |
| 24529 | 24529 | 465 CENTRE ST | 42.354747 | -71.186675 | 51171 | 1 | 2025-08-01 17:15 | 1 | |
| 24595 | 24595 | 255 WASHINGTON ST | 42.357771 | -71.183844 | 51171 | 1 | 2025-08-04 10:45 | 1 | |
| 25366 | 25366 | 1753 COMMONWEALTH AVE | 42.341202 | -71.238173 | 51171 | 3 | 2025-08-18 15:15 | 2025-08-28 | 0 |
| 25424 | 25424 | 390 WOODWARD ST | 42.325929 | -71.226662 | 51171 | 5 | 2025-08-19 12:00 | 2025-08-20 | 0 |
| 25754 | 25754 | 356 NEWTONVILLE AVE | 42.350913 | -71.201831 | 51171 | 2 | 2025-08-26 18:15 | 2025-08-28 | 0 |
| 26256 | 26256 | 550 WASHINGTON ST | 42.354774 | -71.195139 | 51171 | 1 | 2025-09-06 07:30 | 1 | |
| 27383 | 27383 | 728 WALNUT ST | 42.336513 | -71.206763 | 51171 | 2 | 2025-09-26 21:30 | 1 | |
| 27436 | 27436 | 425 CENTRE ST | 42.35553 | -71.186504 | 51171 | 1 | 2025-09-29 09:45 | 1 | |
| 27587 | 27587 | 1087 BEACON ST | 42.331032 | -71.206785 | 51171 | 6 | 2025-10-01 08:45 | 1 | |
| 27742 | 27742 | 474 CENTRE STREET | 42.354471 | -71.186095 | 51171 | 1 | 2025-10-03 14:45 | 1 | |
| 27783 | 27783 | 261 PARKER ST | 42.318387 | -71.194766 | 51171 | 6 | 2025-10-05 11:45 | 2025-10-22 | 0 |
| 28122 | 28122 | 257 TREMONT ST | 42.354108 | -71.17857 | 51171 | 1 | 2025-10-14 07:30 | 1 | |
| 28270 | 28270 | 40 HARVARD ST | 42.351075 | -71.201408 | 51171 | 2 | 2025-10-15 14:45 | 1 | |
| 28440 | 28440 | 331 WATERTOWN ST | 42.361002 | -71.200013 | 51171 | 1 | 2025-10-19 23:45 | 1 | |
| 28678 | 28678 | 527 WALTHAM ST | 42.34968 | -71.226585 | 51171 | 3 | 2025-10-23 09:45 | 2025-11-14 | 0 |
| 28882 | 28882 | 70 RIVER ST | 42.352119 | -71.229317 | 51171 | 3 | 2025-10-28 11:15 | 1 | |
| 28997 | 28997 | 62 RIVER STREET | 42.352203 | -71.228791 | 51171 | 3 | 2025-10-30 09:00 | 1 | |
| 29126 | 29126 | 331 WATERTOWN STREET | 42.361019 | -71.200038 | 51171 | 1 | 2025-11-01 01:15 | 1 | |
| 30030 | 30030 | 405 CRAFTS ST | 42.360021 | -71.216042 | 51171 | 2 | 2025-11-18 18:45 | 1 | |
| 30638 | 30638 | 27 CHRISTINA ST | 42.30702 | -71.214899 | 51171 | 8 | 2025-12-02 10:45 | 1 | |
| 30846 | 30846 | 310 NEEDHAM STREET | 42.307469 | -71.216152 | 51171 | 8 | 2025-12-06 13:30 | 1 | |
| 30962 | 30962 | 470 COMMONWEALTH AVENUE | 42.336343 | -71.185843 | 51171 | 6 | 2025-12-09 21:15 | 1 | |
| 31002 | 31002 | 105 ELM STREET | 42.348638 | -71.229105 | 51171 | 3 | 2025-12-10 16:30 | 1 | |
| 31277 | 31277 | 2345 WASHINGTON STREET | 42.325509 | -71.257566 | 51171 | 4 | 2025-12-16 12:00 | 1 | |
| 31665 | 31665 | 195 CRAFTS ST | 42.357042 | -71.207172 | 51171 | 1 | 2025-12-22 15:30 | 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 );