_locations
121 rows where category_id = 51042
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 |
|---|---|---|---|---|---|---|---|---|---|
| 12415 | 12415 | 107 MADISON AVENUE | 42.350015 | -71.206646 | 51042 | 2 | 2025-04-03 | 2025-07-30 | 0 |
| 12416 | 12416 | 805 COMMONWEALTH AVENUE | 42.338183 | -71.199608 | 51042 | 2 | 2025-04-03 | 1 | |
| 13077 | 13077 | 1064 CENTRE ST | 42.335901 | -71.193132 | 51042 | 6 | 2025-04-23 | 2025-04-23 | 0 |
| 13273 | 13273 | 193 WINCHESTER ST | 42.31341 | -71.209377 | 51042 | 8 | 2025-04-28 | 2025-04-29 | 0 |
| 13274 | 13274 | 283 WINCHESTER ST | 42.310359 | -71.208428 | 51042 | 8 | 2025-04-28 | 2025-04-29 | 0 |
| 13666 | 13666 | 311 WATERTOWN ST | 42.361146 | -71.199198 | 51042 | 1 | 2025-05-07 | 2025-05-12 | 0 |
| 13673 | 13673 | 1720 COMMONWEALTH AVE | 42.340032 | -71.23761 | 51042 | 4 | 2025-05-07 | 2025-05-08 | 0 |
| 13674 | 13674 | 1736 COMMONWEALTH AVE | 42.340383 | -71.238096 | 51042 | 4 | 2025-05-07 | 2025-05-08 | 0 |
| 13675 | 13675 | 198 ARNOLD RD | 42.307038 | -71.19396 | 51042 | 8 | 2025-05-07 | 2025-05-08 | 0 |
| 13676 | 13676 | 535 BEACON ST | 42.332265 | -71.18186 | 51042 | 7 | 2025-05-07 | 2025-05-08 | 0 |
| 13677 | 13677 | 95 ARNOLD RD | 42.304437 | -71.190779 | 51042 | 8 | 2025-05-07 | 2025-05-08 | 0 |
| 13692 | 13692 | 140 BRANDEIS RD | 42.31368 | -71.18654 | 51042 | 8 | 2025-05-07 | 2025-05-14 | 0 |
| 13806 | 13806 | 191 DEDHAM ST | 42.313302 | -71.202429 | 51042 | 8 | 2025-05-09 | 2025-05-12 | 0 |
| 14143 | 14143 | 2134 COMMONWEALTH AVE | 42.347772 | -71.249103 | 51042 | 4 | 2025-05-19 | 2025-05-19 | 0 |
| 14270 | 14270 | 281 ALBEMARLE RD | 42.356736 | -71.216051 | 51042 | 3 | 2025-05-20 | 1 | |
| 14491 | 14491 | 46 WYOMING RD | 42.362019 | -71.21048 | 51042 | 2 | 2025-05-26 | 2025-05-28 | 0 |
| 14624 | 14624 | 901 WASHINGTON ST | 42.351345 | -71.209841 | 51042 | 2 | 2025-05-28 | 2025-05-29 | 0 |
| 14643 | 14643 | 90 CLARK ST | 42.321051 | -71.198361 | 51042 | 6 | 2025-05-29 | 1 | |
| 14689 | 14689 | 897 WASHINGTON ST | 42.35139 | -71.209652 | 51042 | 2 | 2025-05-29 | 1 | |
| 14808 | 14808 | 2 COURT STREET | 42.353353 | -71.2014 | 51042 | 2 | 2025-06-01 | 1 | |
| 15090 | 15090 | 40 CEDAR ST | 42.339447 | -71.198532 | 51042 | 2 | 2025-06-05 | 1 | |
| 15572 | 15572 | 10 ELIOT AVE | 42.352722 | -71.218157 | 51042 | 3 | 2025-06-16 | 1 | |
| 15749 | 15749 | 853 WASHINGTON STREET | 42.351481 | -71.209039 | 51042 | 2 | 2025-06-18 | 2025-09-16 | 0 |
| 15753 | 15753 | 1251 WASHINGTON STREET | 42.349467 | -71.224875 | 51042 | 3 | 2025-06-18 | 1 | |
| 15766 | 15766 | 1897 BEACON ST | 42.32871 | -71.24157 | 51042 | 5 | 2025-06-18 | 1 | |
| 15767 | 15767 | 82 EXETER ST | 42.338709 | -71.228408 | 51042 | 3 | 2025-06-18 | 1 | |
| 15771 | 15771 | 1886 BEACON ST | 42.328188 | -71.241291 | 51042 | 5 | 2025-06-18 | 2025-06-26 | 0 |
| 16008 | 16008 | 77 NEWTONVILLE AVE | 42.353181 | -71.189343 | 51042 | 1 | 2025-06-23 | 1 | |
| 16406 | 16406 | 515 AUBURN STREET | 42.344908 | -71.254415 | 51042 | 4 | 2025-07-01 | 1 | |
| 16413 | 16413 | 431 WASHINGTON ST | 42.356043 | -71.190423 | 51042 | 1 | 2025-07-01 | 1 | |
| 16535 | 16535 | 53 HOBART ROAD | 42.332156 | -71.181241 | 51042 | 7 | 2025-07-02 | 2025-07-14 | 0 |
| 16749 | 16749 | 924 WASHINGTON ST | 42.350877 | -71.211006 | 51042 | 2 | 2025-07-08 | 1 | |
| 16823 | 16823 | 71 NEWTONVILLE AVE | 42.353208 | -71.188893 | 51042 | 1 | 2025-07-09 | 1 | |
| 16899 | 16899 | 90 AUSTIN ST | 42.350175 | -71.211128 | 51042 | 2 | 2025-07-10 | 1 | |
| 16948 | 16948 | 935 WASHINGTON ST | 42.351255 | -71.211033 | 51042 | 2 | 2025-07-11 | 1 | |
| 17025 | 17025 | 218 ADAMS ST | 42.357861 | -71.199383 | 51042 | 1 | 2025-07-14 | 1 | |
| 17026 | 17026 | 11 HAGEN RD | 42.315948 | -71.194509 | 51042 | 8 | 2025-07-14 | 1 | |
| 17027 | 17027 | 36 THEODORE RD | 42.314832 | -71.193992 | 51042 | 8 | 2025-07-14 | 1 | |
| 17028 | 17028 | 41 EDDY ST | 42.351399 | -71.216798 | 51042 | 3 | 2025-07-14 | 1 | |
| 17408 | 17408 | 322 ADAMS ST | 42.355377 | -71.196026 | 51042 | 1 | 2025-07-19 | 2025-07-21 | 0 |
| 17638 | 17638 | 195 SUMNER ST | 42.331302 | -71.192417 | 51042 | 6 | 2025-07-24 | 2025-07-28 | 0 |
| 17851 | 17851 | 44 MANDALAY ROAD | 42.340134 | -71.18094 | 51042 | 7 | 2025-07-30 | 1 | |
| 18225 | 18225 | 342 BEACON ST | 42.332589 | -71.173238 | 51042 | 7 | 2025-08-07 | 1 | |
| 18226 | 18226 | 704 WALNUT ST | 42.337233 | -71.206641 | 51042 | 2 | 2025-08-07 | 1 | |
| 18388 | 18388 | 465 AUBURN STREET | 42.345574 | -71.252394 | 51042 | 4 | 2025-08-12 | 1 | |
| 18426 | 18426 | 58 RESERVOIR AVE | 42.331689 | -71.166195 | 51042 | 7 | 2025-08-13 | 2025-08-13 | 0 |
| 18528 | 18528 | 440 BEACON ST | 42.331815 | -71.177751 | 51042 | 7 | 2025-08-15 | 2025-08-15 | 0 |
| 18530 | 18530 | 455 BEACON ST | 42.33249 | -71.178102 | 51042 | 7 | 2025-08-15 | 2025-08-15 | 0 |
| 18537 | 18537 | 108 DERBY ST | 42.357582 | -71.228093 | 51042 | 3 | 2025-08-15 | 2025-08-15 | 0 |
| 18587 | 18587 | 209 HARTMAN ROAD | 42.304587 | -71.182824 | 51042 | 8 | 2025-08-18 | 1 | |
| 18660 | 18660 | 732 WALNUT ST | 42.336423 | -71.20679 | 51042 | 2 | 2025-08-20 | 2025-08-20 | 0 |
| 18667 | 18667 | 85 AUBURN ST | 42.344784 | -71.238393 | 51042 | 3 | 2025-08-20 | 1 | |
| 18968 | 18968 | 316 LOWELL AVENUE | 42.346256 | -71.211045 | 51042 | 2 | 2025-09-01 | 1 | |
| 19021 | 19021 | 409 CRAFTS ST | 42.360039 | -71.216343 | 51042 | 2 | 2025-09-02 | 1 | |
| 19068 | 19068 | 364 HOMER ST | 42.336558 | -71.209098 | 51042 | 2 | 2025-09-03 | 2025-09-05 | 0 |
| 19069 | 19069 | 412 HOMER ST | 42.337359 | -71.2112 | 51042 | 2 | 2025-09-03 | 2025-09-05 | 0 |
| 19070 | 19070 | 732 WALNUT ST | 42.336423 | -71.20679 | 51042 | 2 | 2025-09-03 | 2025-09-05 | 0 |
| 19073 | 19073 | 126 AUBURNDALE AVENUE | 42.352108 | -71.237481 | 51042 | 3 | 2025-09-03 | 1 | |
| 19074 | 19074 | 143 ROWE STREET | 42.347435 | -71.243318 | 51042 | 4 | 2025-09-03 | 1 | |
| 19081 | 19081 | 134 AUBURNDALE AVE | 42.351912 | -71.237615 | 51042 | 3 | 2025-09-03 | 1 | |
| 19317 | 19317 | 23 EDDY STREET | 42.351854 | -71.216989 | 51042 | 3 | 2025-09-09 | 1 | |
| 19325 | 19325 | 22 LYMAN ST | 42.331833 | -71.193056 | 51042 | 6 | 2025-09-09 | 2025-09-12 | 0 |
| 19328 | 19328 | 164 ADAMS ST | 42.359211 | -71.201052 | 51042 | 1 | 2025-09-09 | 2025-09-12 | 0 |
| 19344 | 19344 | 1126 CENTRE ST | 42.333777 | -71.193177 | 51042 | 6 | 2025-09-10 | 2025-09-12 | 0 |
| 19415 | 19415 | 62 WALNUT PARK | 42.356691 | -71.192421 | 51042 | 1 | 2025-09-11 | 2025-09-12 | 0 |
| 19711 | 19711 | 72 HEATHERLAND RD | 42.313374 | -71.208567 | 51042 | 8 | 2025-09-18 | 1 | |
| 19743 | 19743 | 1322 CENTRE ST | 42.32862 | -71.195643 | 51042 | 6 | 2025-09-19 | 2025-09-19 | 0 |
| 19782 | 19782 | 770 BEACON ST | 42.330249 | -71.19225 | 51042 | 6 | 2025-09-22 | 1 | |
| 19861 | 19861 | 330 R HOMER STREET | 42.335392 | -71.209565 | 51042 | 2 | 2025-09-24 | 1 | |
| 19862 | 19862 | 38 JEWETT ST | 42.359859 | -71.19032 | 51042 | 1 | 2025-09-24 | 2025-09-29 | 0 |
| 19914 | 19914 | 512 AUBURN ST | 42.344766 | -71.254229 | 51042 | 4 | 2025-09-24 | 1 | |
| 19932 | 19932 | 500 BEACON STREET | 42.332047 | -71.181053 | 51042 | 7 | 2025-09-25 | 1 | |
| 20117 | 20117 | 535 BEACON ST | 42.332265 | -71.18186 | 51042 | 7 | 2025-09-30 | 1 | |
| 20142 | 20142 | 278 AUSTIN ST | 42.348654 | -71.219619 | 51042 | 2 | 2025-10-01 | 2025-10-01 | 0 |
| 20144 | 20144 | 152 AUSTIN ST | 42.349662 | -71.213994 | 51042 | 2 | 2025-10-01 | 2025-10-01 | 0 |
| 20259 | 20259 | 133 ELLIOT ST | 42.31476 | -71.215475 | 51042 | 5 | 2025-10-03 | 1 | |
| 20260 | 20260 | 74 CIRCUIT AVE | 42.315849 | -71.215655 | 51042 | 5 | 2025-10-03 | 1 | |
| 20273 | 20273 | 100 LANGLEY RD | 42.329385 | -71.189946 | 51042 | 6 | 2025-10-03 | 1 | |
| 20274 | 20274 | 30 OLD COLONY RD | 42.336036 | -71.172783 | 51042 | 7 | 2025-10-03 | 1 | |
| 20275 | 20275 | 8 COMMONWEALTH AVE | 42.339501 | -71.166893 | 51042 | 7 | 2025-10-03 | 1 | |
| 20279 | 20279 | 1081 WASHINGTON ST | 42.350112 | -71.217563 | 51042 | 3 | 2025-10-03 | 2025-10-03 | 0 |
| 20280 | 20280 | 1180 WASHINGTON ST | 42.349005 | -71.221914 | 51042 | 3 | 2025-10-03 | 2025-10-03 | 0 |
| 20457 | 20457 | 953 CENTRE STREET | 42.339629 | -71.192788 | 51042 | 2 | 2025-10-09 | 1 | |
| 20994 | 20994 | 1164 CENTRE ST | 42.332517 | -71.1936 | 51042 | 6 | 2025-10-23 | 2025-11-14 | 0 |
| 21213 | 21213 | 293 ALBEMARLE RD | 42.356331 | -71.215673 | 51042 | 3 | 2025-10-30 | 1 | |
| 21223 | 21223 | 144 WALNUT STREET | 42.354867 | -71.208578 | 51042 | 2 | 2025-10-30 | 1 | |
| 21400 | 21400 | 80 WINCHESTER ST | 42.317163 | -71.208626 | 51042 | 5 | 2025-11-03 | 2025-11-04 | 0 |
| 21463 | 21463 | 270 COUNTRY CLUB RD | 42.302565 | -71.188452 | 51042 | 8 | 2025-11-04 | 2025-11-04 | 0 |
| 21702 | 21702 | 2 MECHANIC ST | 42.312681 | -71.217513 | 51042 | 5 | 2025-11-10 | 1 | |
| 21761 | 21761 | 1141 WALNUT ST | 42.322401 | -71.207204 | 51042 | 6 | 2025-11-12 | 1 | |
| 21762 | 21762 | 222 PEARL ST | 42.359517 | -71.195598 | 51042 | 1 | 2025-11-12 | 1 | |
| 21763 | 21763 | 420 FULLER ST | 42.339717 | -71.237232 | 51042 | 4 | 2025-11-12 | 1 | |
| 21792 | 21792 | 10 HIGHLAND AVE | 42.349257 | -71.207168 | 51042 | 2 | 2025-11-12 | 1 | |
| 22007 | 22007 | 48 RESERVOIR AVE | 42.331995 | -71.166042 | 51042 | 7 | 2025-11-18 | 1 | |
| 22093 | 22093 | 1097 CENTRE ST | 42.334677 | -71.193879 | 51042 | 6 | 2025-11-19 | 1 | |
| 22094 | 22094 | 1720 COMMONWEALTH AVE | 42.340032 | -71.23761 | 51042 | 4 | 2025-11-19 | 1 | |
| 22095 | 22095 | 293 FULLER ST | 42.33825 | -71.231841 | 51042 | 3 | 2025-11-19 | 2025-11-19 | 0 |
| 22100 | 22100 | 1250 WASHINGTON ST | 42.349185 | -71.224893 | 51042 | 3 | 2025-11-19 | 2025-11-19 | 0 |
| 22107 | 22107 | 256 AUSTIN ST | 42.348753 | -71.218481 | 51042 | 2 | 2025-11-20 | 1 | |
| 22110 | 22110 | 1736 COMMONWEALTH AVE | 42.340383 | -71.238096 | 51042 | 4 | 2025-11-20 | 2025-12-03 | 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 );