_locations
173 rows where category_id = 51042
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 |
|---|---|---|---|---|---|---|---|---|---|
| 1110 | 1110 | 348 DEDHAM STREET | 42.309317 | -71.201186 | 51042 | 8 | 2024-07-02 | 0 | |
| 1290 | 1290 | 324 AUBURNDALE AVENUE | 42.350247 | -71.245454 | 51042 | 4 | 2024-06-24 | 2024-06-24 | 0 |
| 1652 | 1652 | 676 WATERTOWN STREET | 42.354431 | -71.212301 | 51042 | 2 | 2024-06-27 18:45 | 2024-06-28 | 0 |
| 1782 | 1782 | 18 UPHAM ST | 42.354387 | -71.229691 | 51042 | 3 | 2024-07-01 12:45 | 2024-08-12 | 0 |
| 1794 | 1794 | 307 AUBURNDALE AVENUE | 42.350274 | -71.244582 | 51042 | 4 | 2024-07-01 14:45 | 2024-07-01 | 0 |
| 2617 | 2617 | 65 WALNUT STREET | 42.357087 | -71.210423 | 51042 | 2 | 2024-07-16 09:30 | 2024-07-18 | 0 |
| 3055 | 3055 | 1330 CENTRE ST | 42.328345 | -71.195938 | 51042 | 6 | 2024-07-23 20:30 | 2024-07-24 | 0 |
| 3364 | 3364 | 1–11 BROOKSIDE AVE | 42.354032 | -71.213623 | 51042 | 3 | 2024-07-30 12:15 | 2024-07-30 | 0 |
| 3365 | 3365 | 244–268 ALBEMARLE RD | 42.358199 | -71.216608 | 51042 | 3 | 2024-07-30 12:15 | 2024-07-30 | 0 |
| 3382 | 3382 | 339 RIVER ST | 42.357739 | -71.23936 | 51042 | 4 | 2024-07-30 15:45 | 2024-08-01 | 0 |
| 3383 | 3383 | 49 LEXINGTON ST | 42.357832 | -71.239608 | 51042 | 4 | 2024-07-30 15:45 | 2024-08-01 | 0 |
| 4203 | 4203 | 55 EXETER ST | 42.339211 | -71.228176 | 51042 | 3 | 2024-08-12 12:45 | 2024-08-20 | 0 |
| 4205 | 4205 | 1445 COMMONWEALTH AVE | 42.337969 | -71.225457 | 51042 | 3 | 2024-08-12 13:00 | 2024-08-20 | 0 |
| 4300 | 4300 | 386 WARD ST | 42.338411 | -71.188894 | 51042 | 7 | 2024-08-13 15:15 | 2024-08-20 | 0 |
| 4557 | 4557 | 200–224 ALBEMARLE RD | 42.359698 | -71.216727 | 51042 | 2 | 2024-08-18 18:45 | 2024-08-20 | 0 |
| 4629 | 4629 | 1005 DEDHAM STREET | 42.294566 | -71.178821 | 51042 | 8 | 2024-08-19 21:45 | 2024-08-22 | 0 |
| 4630 | 4630 | 410 WINCHESTER STREET | 42.306155 | -71.205708 | 51042 | 8 | 2024-08-19 21:45 | 2024-08-21 | 0 |
| 4770 | 4770 | 50 WINCHESTER STREET | 42.318227 | -71.208535 | 51042 | 5 | 2024-08-22 09:15 | 2024-09-23 | 0 |
| 5210 | 5210 | 73 HARVARD STREET | 42.349975 | -71.201212 | 51042 | 2 | 2024-09-02 21:15 | 2024-09-17 | 0 |
| 5644 | 5644 | 27 THEODORE RD | 42.31463 | -71.19459 | 51042 | 8 | 2024-09-10 19:15 | 2024-09-17 | 0 |
| 5711 | 5711 | 2370 COMMONWEALTH AVE | 42.344526 | -71.258518 | 51042 | 4 | 2024-09-11 20:45 | 2024-09-17 | 0 |
| 6185 | 6185 | MANET RD | 42.337404 | -71.175216 | 51042 | 7 | 2024-09-23 17:45 | 2024-10-22 | 0 |
| 6262 | 6262 | 1–29 UPHAM ST | 42.354321 | -71.228737 | 51042 | 3 | 2024-09-24 08:45 | 2024-09-24 | 0 |
| 6599 | 6599 | 39 WOODWARD STREET | 42.319813 | -71.213352 | 51042 | 6 | 2024-10-01 10:00 | 2024-10-01 | 0 |
| 6813 | 6813 | 1537 WASHINGTON ST | 42.345224 | -71.234295 | 51042 | 3 | 2024-10-08 08:30 | 2024-10-08 | 0 |
| 6931 | 6931 | 1299 CENTRE ST | 42.329585 | -71.195362 | 51042 | 6 | 2024-10-09 19:15 | 2024-10-22 | 0 |
| 7035 | 7035 | 33 THEODORE RD | 42.314686 | -71.194292 | 51042 | 8 | 2024-10-11 18:00 | 2024-11-04 | 0 |
| 7205 | 7205 | 220 HOBART RD | 42.332392 | -71.181311 | 51042 | 7 | 2024-10-16 10:00 | 2024-10-16 | 0 |
| 7783 | 7783 | 111 DALBY ST | 42.361286 | -71.199466 | 51042 | 1 | 2024-10-21 11:15 | 2024-10-21 | 0 |
| 7840 | 7840 | COMMONWEALTH AVENUE MEDIAN | 42.338232 | -71.20928 | 51042 | 2 | 2024-10-21 19:45 | 2024-10-24 | 0 |
| 9457 | 9457 | 27 THEODORE RD | 42.31463 | -71.19459 | 51042 | 8 | 2024-11-04 12:00 | 2024-11-06 | 0 |
| 10252 | 10252 | 121 RIVER ST | 42.352948 | -71.231777 | 51042 | 3 | 2024-11-18 11:00 | 2024-11-21 | 0 |
| 10349 | 10349 | AUSTIN ST | 42.350219 | -71.211139 | 51042 | 2 | 2024-11-20 07:45 | 2024-11-21 | 0 |
| 11090 | 11090 | 125 MEADOWBROOK RD | 42.309253 | -71.189848 | 51042 | 8 | 2024-12-05 17:00 | 2024-12-18 | 0 |
| 11302 | 11302 | 224 VALENTINE ST | 42.338491 | -71.214468 | 51042 | 2 | 2024-12-09 14:45 | 2024-12-17 | 0 |
| 11762 | 11762 | 171 LOWELL AVE | 42.35143 | -71.210707 | 51042 | 2 | 2024-12-16 18:00 | 2024-12-17 | 0 |
| 11879 | 11879 | 743 WASHINGTON ST | 42.352417 | -71.203872 | 51042 | 2 | 2024-12-18 16:30 | 2025-01-09 | 0 |
| 11891 | 11891 | 541 LOWELL AVE | 42.33868 | -71.211792 | 51042 | 2 | 2024-12-19 09:15 | 2025-01-03 | 0 |
| 12315 | 12315 | 825 WATERTOWN ST | 42.352289 | -71.219035 | 51042 | 3 | 2024-12-27 15:00 | 2025-01-03 | 0 |
| 12606 | 12606 | 81 OAK ST | 42.309961 | -71.220661 | 51042 | 5 | 2025-01-03 14:30 | 2025-01-03 | 0 |
| 13357 | 13357 | 107 MADISON AVENUE | 42.350015 | -71.206646 | 51042 | 2 | 2025-01-20 15:30 | 2025-07-30 | 0 |
| 13973 | 13973 | 367 ALBEMARLE RD | 42.354148 | -71.214026 | 51042 | 3 | 2025-01-31 11:00 | 2025-01-31 | 0 |
| 13977 | 13977 | 354 ALBEMARLE RD | 42.356161 | -71.214569 | 51042 | 2 | 2025-01-31 11:15 | 2025-01-31 | 0 |
| 14287 | 14287 | 442 WALNUT ST | 42.345983 | -71.205984 | 51042 | 2 | 2025-02-07 09:15 | 2025-02-12 | 0 |
| 14306 | 14306 | 1057 WALNUT ST | 42.32517 | -71.206825 | 51042 | 6 | 2025-02-07 14:45 | 2025-02-12 | 0 |
| 14611 | 14611 | 21 NEWTONVILLE AVENUE | 42.352154 | -71.187246 | 51042 | 1 | 2025-02-13 15:15 | 2025-02-13 | 0 |
| 15028 | 15028 | 6 MECHANIC ST | 42.312598 | -71.217634 | 51042 | 5 | 2025-02-18 16:30 | 2025-02-19 | 0 |
| 15528 | 15528 | 805 COMMONWEALTH AVENUE | 42.338183 | -71.199608 | 51042 | 2 | 2025-02-27 07:15 | 1 | |
| 16365 | 16365 | 342 BEACON ST | 42.332589 | -71.173238 | 51042 | 7 | 2025-03-14 13:15 | 2025-03-14 | 0 |
| 16371 | 16371 | 1087 COMMONWEALTH AVE | 42.338457 | -71.211357 | 51042 | 2 | 2025-03-14 15:00 | 2025-03-17 | 0 |
| 16374 | 16374 | 95 COLUMBIA AVE | 42.313797 | -71.209679 | 51042 | 8 | 2025-03-14 15:15 | 2025-03-17 | 0 |
| 16649 | 16649 | 85 AUBURN ST | 42.344784 | -71.238393 | 51042 | 3 | 2025-03-21 11:45 | 2025-03-21 | 0 |
| 18175 | 18175 | 1064 CENTRE ST | 42.335901 | -71.193132 | 51042 | 6 | 2025-04-23 09:30 | 2025-04-23 | 0 |
| 18424 | 18424 | 193 WINCHESTER ST | 42.31341 | -71.209377 | 51042 | 8 | 2025-04-28 10:45 | 2025-04-29 | 0 |
| 18428 | 18428 | 283 WINCHESTER ST | 42.310359 | -71.208428 | 51042 | 8 | 2025-04-28 11:00 | 2025-04-29 | 0 |
| 18949 | 18949 | 198 ARNOLD RD | 42.307038 | -71.19396 | 51042 | 8 | 2025-05-07 08:45 | 2025-05-08 | 0 |
| 18950 | 18950 | 311 WATERTOWN ST | 42.361146 | -71.199198 | 51042 | 1 | 2025-05-07 08:45 | 2025-05-12 | 0 |
| 18951 | 18951 | 535 BEACON ST | 42.332265 | -71.18186 | 51042 | 7 | 2025-05-07 08:45 | 2025-05-08 | 0 |
| 18952 | 18952 | 95 ARNOLD RD | 42.304437 | -71.190779 | 51042 | 8 | 2025-05-07 08:45 | 2025-05-08 | 0 |
| 18958 | 18958 | 1736 COMMONWEALTH AVE | 42.340383 | -71.238096 | 51042 | 4 | 2025-05-07 09:00 | 2025-05-08 | 0 |
| 18961 | 18961 | 1720 COMMONWEALTH AVE | 42.340032 | -71.23761 | 51042 | 4 | 2025-05-07 09:15 | 2025-05-08 | 0 |
| 18976 | 18976 | 140 BRANDEIS RD | 42.31368 | -71.18654 | 51042 | 8 | 2025-05-07 11:15 | 2025-05-14 | 0 |
| 19135 | 19135 | 191 DEDHAM ST | 42.313302 | -71.202429 | 51042 | 8 | 2025-05-09 14:00 | 2025-05-12 | 0 |
| 19573 | 19573 | 2134 COMMONWEALTH AVE | 42.347772 | -71.249103 | 51042 | 4 | 2025-05-19 09:00 | 2025-05-19 | 0 |
| 19737 | 19737 | 281 ALBEMARLE RD | 42.356736 | -71.216051 | 51042 | 3 | 2025-05-20 18:30 | 1 | |
| 19995 | 19995 | 46 WYOMING RD | 42.362019 | -71.21048 | 51042 | 2 | 2025-05-26 08:45 | 2025-05-28 | 0 |
| 20169 | 20169 | 901 WASHINGTON ST | 42.351345 | -71.209841 | 51042 | 2 | 2025-05-28 16:15 | 2025-05-29 | 0 |
| 20192 | 20192 | 90 CLARK ST | 42.321051 | -71.198361 | 51042 | 6 | 2025-05-28 22:45 | 1 | |
| 20258 | 20258 | 897 WASHINGTON ST | 42.35139 | -71.209652 | 51042 | 2 | 2025-05-29 17:30 | 1 | |
| 20400 | 20400 | 2 COURT STREET | 42.353353 | -71.2014 | 51042 | 2 | 2025-06-01 17:45 | 1 | |
| 20762 | 20762 | 40 CEDAR ST | 42.339447 | -71.198532 | 51042 | 2 | 2025-06-05 11:45 | 1 | |
| 21387 | 21387 | 10 ELIOT AVE | 42.352722 | -71.218157 | 51042 | 3 | 2025-06-16 11:30 | 1 | |
| 21610 | 21610 | 853 WASHINGTON STREET | 42.351481 | -71.209039 | 51042 | 2 | 2025-06-18 11:45 | 2025-09-16 | 0 |
| 21615 | 21615 | 1251 WASHINGTON STREET | 42.349467 | -71.224875 | 51042 | 3 | 2025-06-18 12:45 | 1 | |
| 21634 | 21634 | 1886 BEACON ST | 42.328188 | -71.241291 | 51042 | 5 | 2025-06-18 14:45 | 2025-06-26 | 0 |
| 21635 | 21635 | 1897 BEACON ST | 42.32871 | -71.24157 | 51042 | 5 | 2025-06-18 14:45 | 1 | |
| 21636 | 21636 | 82 EXETER ST | 42.338709 | -71.228408 | 51042 | 3 | 2025-06-18 14:45 | 1 | |
| 21923 | 21923 | 77 NEWTONVILLE AVE | 42.353181 | -71.189343 | 51042 | 1 | 2025-06-23 15:00 | 1 | |
| 22400 | 22400 | 515 AUBURN STREET | 42.344908 | -71.254415 | 51042 | 4 | 2025-07-01 08:15 | 1 | |
| 22413 | 22413 | 431 WASHINGTON ST | 42.356043 | -71.190423 | 51042 | 1 | 2025-07-01 10:00 | 1 | |
| 22554 | 22554 | 53 HOBART ROAD | 42.332156 | -71.181241 | 51042 | 7 | 2025-07-02 13:00 | 2025-07-14 | 0 |
| 22876 | 22876 | 924 WASHINGTON ST | 42.350877 | -71.211006 | 51042 | 2 | 2025-07-08 19:45 | 1 | |
| 22968 | 22968 | 71 NEWTONVILLE AVE | 42.353208 | -71.188893 | 51042 | 1 | 2025-07-09 14:45 | 1 | |
| 23064 | 23064 | 90 AUSTIN ST | 42.350175 | -71.211128 | 51042 | 2 | 2025-07-10 17:45 | 1 | |
| 23133 | 23133 | 935 WASHINGTON ST | 42.351255 | -71.211033 | 51042 | 2 | 2025-07-11 19:15 | 1 | |
| 23248 | 23248 | 218 ADAMS ST | 42.357861 | -71.199383 | 51042 | 1 | 2025-07-14 17:15 | 1 | |
| 23249 | 23249 | 38 LINCOLN RD | 42.355791 | -71.199351 | 51042 | 1 | 2025-07-14 17:15 | 2025-07-14 | 0 |
| 23251 | 23251 | 11 HAGEN RD | 42.315948 | -71.194509 | 51042 | 8 | 2025-07-14 18:15 | 1 | |
| 23252 | 23252 | 36 THEODORE RD | 42.314832 | -71.193992 | 51042 | 8 | 2025-07-14 18:15 | 1 | |
| 23253 | 23253 | 41 EDDY ST | 42.351399 | -71.216798 | 51042 | 3 | 2025-07-14 18:15 | 1 | |
| 23717 | 23717 | 322 ADAMS ST | 42.355377 | -71.196026 | 51042 | 1 | 2025-07-19 13:00 | 2025-07-21 | 0 |
| 24044 | 24044 | 195 SUMNER ST | 42.331302 | -71.192417 | 51042 | 6 | 2025-07-24 10:30 | 2025-07-28 | 0 |
| 24347 | 24347 | 44 MANDALAY ROAD | 42.340134 | -71.18094 | 51042 | 7 | 2025-07-30 08:15 | 1 | |
| 24862 | 24862 | 342 BEACON ST | 42.332589 | -71.173238 | 51042 | 7 | 2025-08-07 11:30 | 1 | |
| 24863 | 24863 | 704 WALNUT ST | 42.337233 | -71.206641 | 51042 | 2 | 2025-08-07 11:30 | 1 | |
| 25087 | 25087 | 465 AUBURN STREET | 42.345574 | -71.252394 | 51042 | 4 | 2025-08-12 18:00 | 1 | |
| 25138 | 25138 | 58 RESERVOIR AVE | 42.331689 | -71.166195 | 51042 | 7 | 2025-08-13 11:45 | 2025-08-13 | 0 |
| 25274 | 25274 | 440 BEACON ST | 42.331815 | -71.177751 | 51042 | 7 | 2025-08-15 08:45 | 2025-08-15 | 0 |
| 25275 | 25275 | 455 BEACON ST | 42.33249 | -71.178102 | 51042 | 7 | 2025-08-15 08:45 | 2025-08-15 | 0 |
| 25292 | 25292 | 108 DERBY ST | 42.357582 | -71.228093 | 51042 | 3 | 2025-08-15 13:15 | 2025-08-15 | 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 );