_locations
526 rows where category_id = 51125
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 |
|---|---|---|---|---|---|---|---|---|---|
| 7074 | 7074 | 109 WARREN STREET | 42.329491 | -71.18682 | 51125 | 6 | 2024-11-19 | 2024-12-06 | 0 |
| 7847 | 7847 | 306 FRANKLIN ST | 42.351305 | -71.184875 | 51125 | 7 | 2024-12-10 | 2024-12-23 | 0 |
| 8349 | 8349 | 161 GROVE STREET | 42.341816 | -71.249745 | 51125 | 4 | 2024-12-21 | 2024-12-23 | 0 |
| 8360 | 8360 | 101–113 BOYLSTON ST | 42.319947 | -71.177047 | 51125 | 7 | 2024-12-21 | 2024-12-23 | 0 |
| 8365 | 8365 | 95 CHAPEL ST | 42.361899 | -71.200935 | 51125 | 1 | 2024-12-21 | 2024-12-23 | 0 |
| 8366 | 8366 | 451 WATERTOWN ST | 42.35927 | -71.204375 | 51125 | 1 | 2024-12-21 | 2024-12-23 | 0 |
| 8371 | 8371 | 36 WALSH RD | 42.29086 | -71.192335 | 51125 | 8 | 2024-12-22 | 2024-12-30 | 0 |
| 8372 | 8372 | 31 WALSH RD | 42.290988 | -71.191713 | 51125 | 8 | 2024-12-22 | 2024-12-30 | 0 |
| 8373 | 8373 | 23 WALSH RD | 42.290774 | -71.191628 | 51125 | 8 | 2024-12-22 | 2024-12-30 | 0 |
| 8374 | 8374 | 787 SAW MILL BROOK PKWY | 42.29011 | -71.191026 | 51125 | 8 | 2024-12-22 | 2024-12-30 | 0 |
| 8375 | 8375 | 10 VAN ROOSEN RD | 42.290218 | -71.19037 | 51125 | 8 | 2024-12-22 | 2024-12-30 | 0 |
| 8376 | 8376 | 3 VAN ROOSEN RD | 42.29026 | -71.189792 | 51125 | 8 | 2024-12-22 | 2024-12-30 | 0 |
| 8377 | 8377 | 21 VAN ROOSEN RD | 42.290759 | -71.19023 | 51125 | 8 | 2024-12-22 | 2024-12-30 | 0 |
| 8378 | 8378 | 27 VAN ROOSEN RD | 42.290941 | -71.190394 | 51125 | 8 | 2024-12-22 | 2024-12-30 | 0 |
| 8379 | 8379 | 32 VAN ROOSEN RD | 42.290864 | -71.191045 | 51125 | 8 | 2024-12-22 | 2024-12-30 | 0 |
| 8380 | 8380 | 239 WISWALL RD | 42.292055 | -71.191855 | 51125 | 8 | 2024-12-22 | 2024-12-30 | 0 |
| 8381 | 8381 | 144 HANCOCK STREET | 42.34169 | -71.250997 | 51125 | 4 | 2024-12-22 | 2024-12-30 | 0 |
| 8383 | 8383 | 134 HANSON RD | 42.295342 | -71.187842 | 51125 | 8 | 2024-12-22 | 2024-12-30 | 0 |
| 8384 | 8384 | 735 SAW MILL BROOK PKWY | 42.290375 | -71.188663 | 51125 | 8 | 2024-12-22 | 2024-12-30 | 0 |
| 8385 | 8385 | 101 MADISON AVE | 42.350149 | -71.206086 | 51125 | 2 | 2024-12-22 | 2024-12-30 | 0 |
| 8386 | 8386 | 95 MADISON AVE | 42.350034 | -71.205882 | 51125 | 2 | 2024-12-22 | 2024-12-30 | 0 |
| 8387 | 8387 | 308 WALNUT ST | 42.35038 | -71.206844 | 51125 | 2 | 2024-12-22 | 2024-12-30 | 0 |
| 8388 | 8388 | 198 WALNUT ST | 42.353383 | -71.207894 | 51125 | 2 | 2024-12-22 | 2024-12-30 | 0 |
| 8389 | 8389 | 174 WALNUT ST | 42.35405 | -71.208175 | 51125 | 2 | 2024-12-22 | 2024-12-27 | 0 |
| 8390 | 8390 | 168 WALNUT ST | 42.354215 | -71.208187 | 51125 | 2 | 2024-12-22 | 2024-12-30 | 0 |
| 8391 | 8391 | 160 WALNUT ST | 42.354503 | -71.208249 | 51125 | 2 | 2024-12-22 | 2024-12-30 | 0 |
| 8392 | 8392 | 154 WALNUT ST | 42.354782 | -71.208435 | 51125 | 2 | 2024-12-22 | 2024-12-27 | 0 |
| 8393 | 8393 | 130 WALNUT ST | 42.355226 | -71.208579 | 51125 | 2 | 2024-12-22 | 2024-12-27 | 0 |
| 8394 | 8394 | 46 LOWELL AVE | 42.355524 | -71.208332 | 51125 | 2 | 2024-12-22 | 2024-12-30 | 0 |
| 8395 | 8395 | 36 LOWELL AVE | 42.355644 | -71.208117 | 51125 | 2 | 2024-12-22 | 2024-12-30 | 0 |
| 8396 | 8396 | 20 LOWELL AVE | 42.356092 | -71.207533 | 51125 | 2 | 2024-12-22 | 2024-12-30 | 0 |
| 8397 | 8397 | 14 LOWELL AVE | 42.356216 | -71.207411 | 51125 | 2 | 2024-12-22 | 2024-12-30 | 0 |
| 8398 | 8398 | 6 LOWELL AVE | 42.356458 | -71.207094 | 51125 | 2 | 2024-12-22 | 2024-12-30 | 0 |
| 8399 | 8399 | LOWELL PARK | 42.356034 | -71.208103 | 51125 | 2 | 2024-12-22 | 2024-12-30 | 0 |
| 8400 | 8400 | 4 LOWELL AVE | 42.356533 | -71.206878 | 51125 | 2 | 2024-12-22 | 2024-12-30 | 0 |
| 8401 | 8401 | 179 CRAFTS ST | 42.356802 | -71.206463 | 51125 | 1 | 2024-12-22 | 2024-12-30 | 0 |
| 8402 | 8402 | 524 WATERTOWN ST | 42.357027 | -71.206186 | 51125 | 1 | 2024-12-22 | 2024-12-27 | 0 |
| 8403 | 8403 | 510 WATERTOWN ST | 42.35742 | -71.205803 | 51125 | 1 | 2024-12-22 | 2024-12-30 | 0 |
| 8404 | 8404 | 504 WATERTOWN ST | 42.357534 | -71.205592 | 51125 | 1 | 2024-12-22 | 2024-12-27 | 0 |
| 8405 | 8405 | 498 WATERTOWN ST | 42.357747 | -71.205443 | 51125 | 1 | 2024-12-22 | 2024-12-30 | 0 |
| 8406 | 8406 | 484 WATERTOWN ST | 42.358034 | -71.204827 | 51125 | 1 | 2024-12-22 | 2024-12-30 | 0 |
| 8407 | 8407 | 474 WATERTOWN ST | 42.358229 | -71.204519 | 51125 | 1 | 2024-12-22 | 2024-12-27 | 0 |
| 8408 | 8408 | 444 WATERTOWN ST | 42.359103 | -71.203355 | 51125 | 1 | 2024-12-22 | 2024-12-30 | 0 |
| 8409 | 8409 | 650–664 COMMONWEALTH AVE | 42.336017 | -71.193805 | 51125 | 2 | 2024-12-22 | 2024-12-30 | 0 |
| 8410 | 8410 | 978–992 COMMONWEALTH AVE | 42.338719 | -71.206588 | 51125 | 2 | 2024-12-22 | 2024-12-30 | 0 |
| 8411 | 8411 | 500 BEACON ST | 42.332149 | -71.180374 | 51125 | 7 | 2024-12-22 | 2024-12-30 | 0 |
| 8412 | 8412 | 1425 BEACON STREET | 42.329971 | -71.222128 | 51125 | 5 | 2024-12-22 | 2024-12-30 | 0 |
| 8414 | 8414 | 441 WATERTOWN ST | 42.359101 | -71.203794 | 51125 | 1 | 2024-12-23 | 2024-12-30 | 0 |
| 8415 | 8415 | 487 WATERTOWN ST | 42.358229 | -71.205209 | 51125 | 1 | 2024-12-23 | 2024-12-27 | 0 |
| 8416 | 8416 | 523 WATERTOWN ST | 42.357329 | -71.206481 | 51125 | 1 | 2024-12-23 | 2024-12-30 | 0 |
| 8417 | 8417 | 583 WATERTOWN ST | 42.356114 | -71.208918 | 51125 | 2 | 2024-12-23 | 2024-12-27 | 0 |
| 8418 | 8418 | 592 WATERTOWN ST | 42.355535 | -71.209183 | 51125 | 2 | 2024-12-23 | 2024-12-27 | 0 |
| 8419 | 8419 | 137 WALNUT ST | 42.354968 | -71.208885 | 51125 | 2 | 2024-12-23 | 2024-12-27 | 0 |
| 8420 | 8420 | 141 WALNUT ST | 42.354788 | -71.208799 | 51125 | 2 | 2024-12-23 | 2024-12-30 | 0 |
| 8421 | 8421 | 153 WALNUT ST | 42.354516 | -71.208641 | 51125 | 2 | 2024-12-23 | 2024-12-30 | 0 |
| 8422 | 8422 | 161 WALNUT ST | 42.354242 | -71.208595 | 51125 | 2 | 2024-12-23 | 2024-12-27 | 0 |
| 8423 | 8423 | 183 WALNUT ST | 42.353668 | -71.20837 | 51125 | 2 | 2024-12-23 | 2024-12-30 | 0 |
| 8424 | 8424 | 197 WALNUT ST | 42.353358 | -71.208297 | 51125 | 2 | 2024-12-23 | 2024-12-30 | 0 |
| 8425 | 8425 | 205 WALNUT ST | 42.353149 | -71.208217 | 51125 | 2 | 2024-12-23 | 2024-12-27 | 0 |
| 8426 | 8426 | 209 WALNUT ST | 42.352983 | -71.208139 | 51125 | 2 | 2024-12-23 | 2024-12-30 | 0 |
| 8427 | 8427 | 221 WALNUT ST | 42.352703 | -71.208011 | 51125 | 2 | 2024-12-23 | 2024-12-30 | 0 |
| 8428 | 8428 | 227 WALNUT ST | 42.35252 | -71.207889 | 51125 | 2 | 2024-12-23 | 2024-12-30 | 0 |
| 8431 | 8431 | 163 WINCHESTER ST | 42.314402 | -71.209434 | 51125 | 8 | 2024-12-23 | 2024-12-30 | 0 |
| 8432 | 8432 | 10 BROOKLINE PL | 51125 | 2024-12-23 | 2024-12-26 | 0 | |||
| 8454 | 8454 | 20 HARTFORD ST | 42.320894 | -71.207733 | 51125 | 6 | 2024-12-23 | 2024-12-30 | 0 |
| 8455 | 8455 | 326 HIGHLAND AVE | 42.346071 | -71.220815 | 51125 | 2 | 2024-12-23 | 2024-12-27 | 0 |
| 8456 | 8456 | 343 HIGHLAND AVE | 42.346334 | -71.221702 | 51125 | 2 | 2024-12-23 | 2024-12-27 | 0 |
| 8457 | 8457 | COMMONWEALTH AVENUE MEDIAN | 42.338232 | -71.20928 | 51125 | 2 | 2024-12-23 | 2024-12-26 | 0 |
| 8458 | 8458 | 3 PAYNE RD | 42.319409 | -71.198394 | 51125 | 6 | 2024-12-23 | 2024-12-30 | 0 |
| 8470 | 8470 | 35 ROSALIE RD | 42.303375 | -71.189682 | 51125 | 8 | 2024-12-23 | 2024-12-30 | 0 |
| 8471 | 8471 | 150 COUNTRY CLUB RD | 42.305197 | -71.189563 | 51125 | 8 | 2024-12-23 | 2024-12-30 | 0 |
| 8472 | 8472 | 156 COUNTRY CLUB RD | 42.304933 | -71.189164 | 51125 | 8 | 2024-12-23 | 2024-12-30 | 0 |
| 8473 | 8473 | 658 DEDHAM ST | 42.302707 | -71.19049 | 51125 | 8 | 2024-12-23 | 2024-12-30 | 0 |
| 8474 | 8474 | 91 ARNOLD RD | 42.30433 | -71.190578 | 51125 | 8 | 2024-12-23 | 2024-12-30 | 0 |
| 8475 | 8475 | 247 BROOKLINE ST | 42.301774 | -71.176808 | 51125 | 8 | 2024-12-23 | 2024-12-30 | 0 |
| 8479 | 8479 | 301 WAVERLEY AVE | 42.345641 | -71.181955 | 51125 | 7 | 2024-12-23 | 2025-02-24 | 0 |
| 8480 | 8480 | 69 LINCOLN ST | 42.321525 | -71.208813 | 51125 | 6 | 2024-12-23 | 2024-12-30 | 0 |
| 8485 | 8485 | 55 ALGONQUIN RD | 42.34113 | -71.170131 | 51125 | 7 | 2024-12-23 | 2024-12-30 | 0 |
| 8486 | 8486 | 62 ALGONQUIN RD | 42.341113 | -71.170594 | 51125 | 7 | 2024-12-23 | 2024-12-30 | 0 |
| 8487 | 8487 | 66 ALGONQUIN RD | 42.341229 | -71.170711 | 51125 | 7 | 2024-12-23 | 2024-12-30 | 0 |
| 8488 | 8488 | 156 OTIS ST | 42.34663 | -71.21404 | 51125 | 2 | 2024-12-23 | 2024-12-30 | 0 |
| 8489 | 8489 | 10 NORWOOD AVE | 42.328911 | -71.197724 | 51125 | 6 | 2024-12-23 | 2024-12-30 | 0 |
| 8490 | 8490 | 88 OTIS ST | 42.347159 | -71.210629 | 51125 | 2 | 2024-12-23 | 2024-12-30 | 0 |
| 8491 | 8491 | 60 OTIS ST | 42.347403 | -71.209289 | 51125 | 2 | 2024-12-23 | 2024-12-30 | 0 |
| 8492 | 8492 | 278 CABOT ST | 42.347993 | -71.201478 | 51125 | 2 | 2024-12-23 | 2024-12-27 | 0 |
| 8493 | 8493 | 270 CABOT ST | 42.348055 | -71.20086 | 51125 | 2 | 2024-12-23 | 1 | |
| 8497 | 8497 | 232 CABOT ST | 42.348125 | -71.199288 | 51125 | 2 | 2024-12-23 | 2025-02-24 | 0 |
| 8498 | 8498 | 63 CABOT ST | 42.347687 | -71.192118 | 51125 | 2 | 2024-12-23 | 2024-12-26 | 0 |
| 8499 | 8499 | 15 CABOT ST | 42.347345 | -71.1898 | 51125 | 2 | 2024-12-23 | 2024-12-27 | 0 |
| 8500 | 8500 | 336 CABOT ST | 42.347774 | -71.204137 | 51125 | 2 | 2024-12-23 | 2024-12-27 | 0 |
| 8501 | 8501 | 391 WALNUT ST | 42.347713 | -71.207254 | 51125 | 2 | 2024-12-23 | 2024-12-26 | 0 |
| 8502 | 8502 | 54 OTIS ST | 42.347434 | -71.209088 | 51125 | 2 | 2024-12-23 | 2024-12-30 | 0 |
| 8503 | 8503 | 584 CENTRE ST | 42.351063 | -71.185769 | 51125 | 7 | 2024-12-23 | 2025-02-24 | 0 |
| 8504 | 8504 | 526 CENTRE ST | 42.352967 | -71.186232 | 51125 | 1 | 2024-12-23 | 2024-12-27 | 0 |
| 8505 | 8505 | 78 CHARLESBANK RD | 42.358547 | -71.179655 | 51125 | 1 | 2024-12-23 | 2025-02-24 | 0 |
| 8506 | 8506 | 743 WASHINGTON ST | 42.352395 | -71.204013 | 51125 | 2 | 2024-12-23 | 2024-12-26 | 0 |
| 8507 | 8507 | 773 WASHINGTON ST | 42.352349 | -71.20477 | 51125 | 2 | 2024-12-23 | 2024-12-26 | 0 |
| 8517 | 8517 | 50–68 PINE ST | 42.353975 | -71.237851 | 51125 | 3 | 2024-12-24 | 2024-12-30 | 0 |
| 8518 | 8518 | 333–367 GROVE ST | 42.335158 | -71.252984 | 51125 | 4 | 2024-12-24 | 2024-12-30 | 0 |
| 8534 | 8534 | 161 GROVE STREET | 42.341877 | -71.25 | 51125 | 4 | 2024-12-24 | 2024-12-30 | 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 );