_locations
191 rows where category_id = 53239
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 |
|---|---|---|---|---|---|---|---|---|---|
| 1118 | 1118 | 180 EVELYN ROAD | 42.33647 | -71.218792 | 53239 | 5 | 2024-06-26 | 0 | |
| 1119 | 1119 | 306–368 ALBEMARLE RD | 53239 | 2024-06-25 | 0 | ||||
| 1120 | 1120 | 960 BEACON STREET | 42.330443 | -71.201239 | 53239 | 6 | 2024-06-24 | 0 | |
| 1362 | 1362 | 6 CHANNING STREET | 42.358229 | -71.187678 | 53239 | 1 | 2024-06-25 | 2024-06-26 | 0 |
| 1373 | 1373 | 40 CARLETON ST | 42.358864 | -71.187188 | 53239 | 1 | 2024-06-25 | 2024-06-26 | 0 |
| 1375 | 1375 | 100 PEARL ST | 42.358351 | -71.189789 | 53239 | 1 | 2024-06-25 | 2024-06-26 | 0 |
| 1711 | 1711 | 65 PEARL STREET | 42.358355 | -71.188021 | 53239 | 1 | 2024-06-28 18:00 | 2024-07-02 | 0 |
| 1970 | 1970 | 61 PEARL STREET | 42.358292 | -71.18785 | 53239 | 1 | 2024-07-03 17:45 | 2024-07-05 | 0 |
| 2358 | 2358 | 11 WILTSHIRE RD | 42.35628 | -71.196756 | 53239 | 1 | 2024-07-10 16:30 | 2024-07-11 | 0 |
| 2449 | 2449 | 2 PERRY ROAD | 42.350601 | -71.243704 | 53239 | 4 | 2024-07-12 08:30 | 2024-07-12 | 0 |
| 2658 | 2658 | 13 WILTSHIRE RD | 42.356328 | -71.196664 | 53239 | 1 | 2024-07-16 15:30 | 2024-07-16 | 0 |
| 2672 | 2672 | 13 WILTSHIRE RD | 42.356328 | -71.196664 | 53239 | 1 | 2024-07-16 17:15 | 2024-07-17 | 0 |
| 2757 | 2757 | 61 NEWELL ROAD | 42.350831 | -71.243543 | 53239 | 4 | 2024-07-17 18:15 | 2024-07-18 | 0 |
| 2930 | 2930 | 525 WINCHESTER ST | 42.302662 | -71.206596 | 53239 | 8 | 2024-07-22 10:00 | 2024-07-23 | 0 |
| 3144 | 3144 | 140 WINDERMERE RD | 42.340792 | -71.240816 | 53239 | 4 | 2024-07-25 13:45 | 2024-07-30 | 0 |
| 3690 | 3690 | 325 ALBEMARLE RD | 42.355548 | -71.214894 | 53239 | 3 | 2024-08-05 15:15 | 2024-08-07 | 0 |
| 3852 | 3852 | 324 CRAFTS ST | 42.358995 | -71.212725 | 53239 | 2 | 2024-08-08 09:00 | 2024-08-08 | 0 |
| 4242 | 4242 | 300 LAGRANGE STREET | 42.301269 | -71.169664 | 53239 | 8 | 2024-08-12 18:45 | 2024-08-14 | 0 |
| 4339 | 4339 | 1304 WALNUT ST | 42.317742 | -71.202865 | 53239 | 5 | 2024-08-14 10:00 | 2024-08-14 | 0 |
| 4341 | 4341 | CENTRE ST | 42.319562 | -71.206597 | 53239 | 6 | 2024-08-14 10:15 | 2024-08-14 | 0 |
| 4675 | 4675 | 343 CABOT ST | 42.348055 | -71.204583 | 53239 | 2 | 2024-08-20 15:30 | 2024-08-21 | 0 |
| 4808 | 4808 | 57 CHARLESBANK RD | 42.358737 | -71.178576 | 53239 | 1 | 2024-08-22 16:15 | 2024-08-26 | 0 |
| 4850 | 4850 | 790 WATERTOWN ST | 42.352545 | -71.217234 | 53239 | 3 | 2024-08-23 11:15 | 2024-08-26 | 0 |
| 4870 | 4870 | 1345 WASHINGTON STREET | 42.349047 | -71.228211 | 53239 | 3 | 2024-08-23 22:45 | 2024-08-26 | 0 |
| 5124 | 5124 | 95 HYDE ST | 42.323177 | -71.20421 | 53239 | 6 | 2024-08-29 13:45 | 2024-09-03 | 0 |
| 5172 | 5172 | 5 DEDHAM ST | 42.316258 | -71.208577 | 53239 | 8 | 2024-08-30 14:30 | 2024-08-30 | 0 |
| 5337 | 5337 | 55 FARLOW RD | 42.346951 | -71.177995 | 53239 | 7 | 2024-09-04 16:30 | 2024-09-12 | 0 |
| 5515 | 5515 | 1 CORNELL ST | 42.331571 | -71.260453 | 53239 | 4 | 2024-09-09 09:45 | 2024-09-16 | 0 |
| 5754 | 5754 | 131 WISWALL RD | 42.294999 | -71.188789 | 53239 | 8 | 2024-09-12 15:45 | 2024-09-23 | 0 |
| 5766 | 5766 | 200 JACKSON RD | 42.356356 | -71.194729 | 53239 | 1 | 2024-09-13 08:15 | 2024-09-13 | 0 |
| 5900 | 5900 | 133 PARK ST | 42.35234 | -71.182145 | 53239 | 1 | 2024-09-16 10:30 | 2024-12-02 | 0 |
| 5946 | 5946 | 406 DEDHAM STREET | 42.308484 | -71.198578 | 53239 | 8 | 2024-09-16 21:45 | 2024-09-23 | 0 |
| 6192 | 6192 | 116 CENTRAL ST | 42.345126 | -71.24621 | 53239 | 4 | 2024-09-23 17:45 | 2024-09-26 | 0 |
| 6193 | 6193 | 20 KENSINGTON STREET | 42.355723 | -71.216882 | 53239 | 3 | 2024-09-23 17:45 | 2024-10-03 | 0 |
| 6335 | 6335 | 3 CRAGMORE ROAD | 42.317687 | -71.222654 | 53239 | 5 | 2024-09-25 07:15 | 2024-09-25 | 0 |
| 6366 | 6366 | 15 FARLOW ROAD | 42.346795 | -71.179781 | 53239 | 7 | 2024-09-25 12:00 | 2024-09-25 | 0 |
| 6555 | 6555 | 223 RIVER ST | 42.355238 | -71.235161 | 53239 | 3 | 2024-09-30 11:15 | 2024-10-02 | 0 |
| 6646 | 6646 | 78 WOODBINE STREET | 42.346756 | -71.254679 | 53239 | 4 | 2024-10-02 12:30 | 2024-10-02 | 0 |
| 6688 | 6688 | 560 PARKER ST | 42.308533 | -71.197814 | 53239 | 8 | 2024-10-03 11:30 | 2024-10-08 | 0 |
| 6876 | 6876 | 51 WEST STREET | 42.359319 | -71.199641 | 53239 | 1 | 2024-10-08 20:45 | 2024-10-09 | 0 |
| 6929 | 6929 | 1389 WALNUT ST | 42.315045 | -71.202256 | 53239 | 5 | 2024-10-09 19:00 | 2024-10-10 | 0 |
| 7252 | 7252 | 560 PARKER ST | 42.308533 | -71.197814 | 53239 | 8 | 2024-10-17 09:45 | 2024-10-20 | 0 |
| 7782 | 7782 | 409 WINCHESTER ST | 42.30653 | -71.205974 | 53239 | 8 | 2024-10-21 11:00 | 2024-10-21 | 0 |
| 8216 | 8216 | 52 WEST ST | 42.359399 | -71.19944 | 53239 | 1 | 2024-10-24 10:00 | 2024-10-24 | 0 |
| 8628 | 8628 | 425 CENTRE STREET | 42.355906 | -71.186154 | 53239 | 1 | 2024-10-29 07:30 | 2024-10-29 | 0 |
| 9536 | 9536 | 8 WEBSTER STREET | 42.350642 | -71.226419 | 53239 | 3 | 2024-11-04 21:45 | 2024-11-05 | 0 |
| 9839 | 9839 | 191 ALLERTON RD | 42.323275 | -71.203807 | 53239 | 6 | 2024-11-07 13:00 | 2024-11-08 | 0 |
| 10132 | 10132 | 106 WAVERLEY AVE | 42.352118 | -71.179664 | 53239 | 1 | 2024-11-13 21:30 | 2024-11-14 | 0 |
| 10167 | 10167 | 31 BORDER STREET | 42.348833 | -71.230597 | 53239 | 3 | 2024-11-14 22:15 | 2024-11-15 | 0 |
| 10805 | 10805 | 6 KESSELER WAY | 42.307469 | -71.170812 | 53239 | 8 | 2024-11-30 09:15 | 2024-12-02 | 0 |
| 10810 | 10810 | 4 JANET RD | 42.340792 | -71.193713 | 53239 | 2 | 2024-11-30 13:00 | 2024-12-02 | 0 |
| 10811 | 10811 | 100 CHRISTINA ST | 42.306531 | -71.211882 | 53239 | 8 | 2024-11-30 21:30 | 2024-12-02 | 0 |
| 10886 | 10886 | 200 PARMENTER RD | 42.359506 | -71.231791 | 53239 | 3 | 2024-12-02 10:15 | 2024-12-02 | 0 |
| 10891 | 10891 | 44 MARSHALL STREET | 42.334281 | -71.190124 | 53239 | 6 | 2024-12-02 11:15 | 2024-12-04 | 0 |
| 11051 | 11051 | 213 DERBY ST | 42.359502 | -71.232368 | 53239 | 3 | 2024-12-04 16:30 | 2024-12-04 | 0 |
| 11164 | 11164 | 15 MECHANIC STREET | 42.312134 | -71.217762 | 53239 | 5 | 2024-12-06 15:30 | 2024-12-06 | 0 |
| 11167 | 11167 | 187 MELROSE STREET | 42.35011 | -71.249143 | 53239 | 4 | 2024-12-06 15:45 | 2024-12-10 | 0 |
| 11168 | 11168 | 58 LINDEN STREET | 42.310674 | -71.219188 | 53239 | 5 | 2024-12-06 15:45 | 2024-12-09 | 0 |
| 11509 | 11509 | 1136-1138 WALNUT STREET | 42.322544 | -71.206847 | 53239 | 6 | 2024-12-11 14:45 | 2024-12-12 | 0 |
| 11549 | 11549 | 1321 CENTRE STREET | 42.328834 | -71.196597 | 53239 | 6 | 2024-12-12 09:00 | 2024-12-16 | 0 |
| 11638 | 11638 | 100 WINCHESTER ST | 42.316594 | -71.208489 | 53239 | 5 | 2024-12-13 12:00 | 2024-12-13 | 0 |
| 11892 | 11892 | 78 WASHINGTON STREET | 42.354788 | -71.176906 | 53239 | 1 | 2024-12-19 09:15 | 2025-01-14 | 0 |
| 13013 | 13013 | 1 CHESTNUT ST | 42.349156 | -71.225629 | 53239 | 3 | 2025-01-10 16:15 | 2025-01-14 | 0 |
| 13146 | 13146 | 1966 BEACON STREET | 42.329047 | -71.244755 | 53239 | 5 | 2025-01-14 16:15 | 2025-01-14 | 0 |
| 13311 | 13311 | 100 HAMMOND ST | 42.335361 | -71.177189 | 53239 | 7 | 2025-01-17 16:45 | 2025-01-21 | 0 |
| 13323 | 13323 | 566 GROVE STREET | 42.329554 | -71.258059 | 53239 | 4 | 2025-01-18 16:30 | 2025-01-23 | 0 |
| 13756 | 13756 | 191 MILL STREET | 42.341792 | -71.200756 | 53239 | 2 | 2025-01-27 19:00 | 2025-01-28 | 0 |
| 13770 | 13770 | 56 WEBSTER STREET | 42.350221 | -71.228684 | 53239 | 3 | 2025-01-28 08:45 | 2025-01-28 | 0 |
| 13784 | 13784 | 300 HOMER STREET | 42.335899 | -71.206475 | 53239 | 6 | 2025-01-28 10:45 | 2025-01-28 | 0 |
| 14149 | 14149 | 690 WATERTOWN STREET | 42.354272 | -71.213277 | 53239 | 2 | 2025-02-04 10:15 | 2025-02-20 | 0 |
| 14231 | 14231 | 40 OLD ORCHARD ROAD | 42.331458 | -71.173687 | 53239 | 7 | 2025-02-05 18:45 | 2025-02-13 | 0 |
| 14542 | 14542 | 236 LINWOOD AVE | 42.359592 | -71.208445 | 53239 | 1 | 2025-02-11 19:00 | 2025-02-13 | 0 |
| 14710 | 14710 | 14 MANDALAY ROAD | 42.340828 | -71.182362 | 53239 | 7 | 2025-02-15 13:15 | 2025-02-18 | 0 |
| 15556 | 15556 | 51 BOYD STREET | 42.359775 | -71.187968 | 53239 | 1 | 2025-02-27 12:00 | 2025-03-03 | 0 |
| 15847 | 15847 | 1385 WALNUT ST | 42.31512 | -71.202308 | 53239 | 5 | 2025-03-06 17:45 | 2025-03-07 | 0 |
| 16122 | 16122 | 2322 WASHINGTON ST | 42.325452 | -71.256434 | 53239 | 4 | 2025-03-10 12:30 | 2025-03-10 | 0 |
| 16234 | 16234 | 237 MILL STREET | 42.342402 | -71.203213 | 53239 | 2 | 2025-03-11 18:30 | 2025-03-13 | 0 |
| 16385 | 16385 | 1915 BEACON ST | 42.32862 | -71.242245 | 53239 | 5 | 2025-03-15 13:45 | 2025-12-01 | 0 |
| 16629 | 16629 | 80 RESERVOIR AVENUE | 42.331149 | -71.166724 | 53239 | 7 | 2025-03-20 21:30 | 2025-03-25 | 0 |
| 16982 | 16982 | 1300 CENTRE ST | 42.329079 | -71.194734 | 53239 | 6 | 2025-03-27 19:15 | 2025-12-01 | 0 |
| 16984 | 16984 | 85 LANGLEY RD | 42.329511 | -71.190936 | 53239 | 6 | 2025-03-27 19:30 | 2025-04-02 | 0 |
| 17868 | 17868 | 152 FULLER ST | 42.335955 | -71.22609 | 53239 | 5 | 2025-04-15 16:30 | 2025-04-17 | 0 |
| 17921 | 17921 | 384 LINWOOD AVE | 42.355791 | -71.211299 | 53239 | 2 | 2025-04-16 12:30 | 2025-04-16 | 0 |
| 18476 | 18476 | 114 SARGENT ST | 42.346143 | -71.185352 | 53239 | 7 | 2025-04-28 17:15 | 2025-04-29 | 0 |
| 18496 | 18496 | 971 CENTRE ST | 42.339042 | -71.193213 | 53239 | 2 | 2025-04-29 07:15 | 2025-07-09 | 0 |
| 18590 | 18590 | 140 BRANDEIS RD | 42.31368 | -71.18654 | 53239 | 8 | 2025-04-30 11:00 | 2025-05-13 | 0 |
| 18692 | 18692 | 26-28 CARLETON STREET | 42.358736 | -71.186562 | 53239 | 1 | 2025-05-02 09:30 | 2025-05-05 | 0 |
| 18700 | 18700 | 55 HALCYON RD | 42.321672 | -71.196732 | 53239 | 6 | 2025-05-02 10:45 | 2025-05-05 | 0 |
| 18941 | 18941 | 963 CENTRE ST | 42.33933 | -71.193173 | 53239 | 2 | 2025-05-07 07:30 | 2025-05-12 | 0 |
| 19022 | 19022 | 52 DALBY STREET | 42.363302 | -71.200188 | 53239 | 1 | 2025-05-07 20:15 | 2025-05-12 | 0 |
| 19026 | 19026 | 291 WOODLAND ROAD | 42.340404 | -71.240507 | 53239 | 4 | 2025-05-08 07:45 | 2025-05-12 | 0 |
| 19093 | 19093 | 78 PINE GROVE AVENUE | 42.331807 | -71.260977 | 53239 | 4 | 2025-05-08 18:45 | 2025-05-12 | 0 |
| 19112 | 19112 | 191 DEDHAM ST | 42.313302 | -71.202429 | 53239 | 8 | 2025-05-09 09:30 | 2025-05-09 | 0 |
| 19247 | 19247 | 2 AUBURNDALE AVE | 42.352686 | -71.231882 | 53239 | 3 | 2025-05-12 17:45 | 2025-05-13 | 0 |
| 19448 | 19448 | 170 FULLER STREET | 42.336518 | -71.227063 | 53239 | 5 | 2025-05-15 14:15 | 2025-05-15 | 0 |
| 19524 | 19524 | 382 LINWOOD AVE | 42.355899 | -71.211389 | 53239 | 2 | 2025-05-16 22:30 | 2025-05-19 | 0 |
| 19732 | 19732 | 199 CHURCH ST | 42.354603 | -71.18766 | 53239 | 1 | 2025-05-20 16:30 | 2025-05-28 | 0 |
| 19757 | 19757 | 55-57 WETHERELL STREET | 42.311531 | -71.217332 | 53239 | 5 | 2025-05-21 09:15 | 2025-12-01 | 0 |
| 20045 | 20045 | 2 PERRY ROAD | 42.350615 | -71.243632 | 53239 | 4 | 2025-05-27 12:00 | 2025-05-29 | 0 |
| 20046 | 20046 | 77 NEWELL RD | 42.351075 | -71.243847 | 53239 | 4 | 2025-05-27 12:00 | 2025-05-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 );