_locations
43 rows where category_id = 50970
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 |
|---|---|---|---|---|---|---|---|---|---|
| 147 | 147 | 36 CRESTWOOD RD | 42.341805 | -71.215159 | 50970 | 2 | 2024-06-17 | 0 | |
| 1344 | 1344 | 540 PARKER STREET | 42.309182 | -71.197205 | 50970 | 8 | 2024-06-24 | 2024-06-25 | 0 |
| 1584 | 1584 | 15 WOODLAWN DR | 42.341002 | -71.17602 | 50970 | 7 | 2024-06-27 | 2024-07-19 | 0 |
| 1797 | 1797 | 17 GILBERT ST | 42.344409 | -71.236583 | 50970 | 4 | 2024-07-01 15:30 | 2024-07-03 | 0 |
| 3710 | 3710 | 184 UPLAND AVE | 42.312968 | -71.207588 | 50970 | 8 | 2024-08-06 08:45 | 2025-08-11 | 0 |
| 5788 | 5788 | 765 DEDHAM ST | 42.299231 | -71.187426 | 50970 | 8 | 2024-09-13 10:00 | 1 | |
| 5889 | 5889 | 10 CENTRAL CLOSE | 42.345483 | -71.247966 | 50970 | 4 | 2024-09-16 09:00 | 2024-10-09 | 0 |
| 7618 | 7618 | 520 COMMONWEALTH AVE | 42.336109 | -71.187598 | 50970 | 6 | 2024-10-18 15:00 | 1 | |
| 7667 | 7667 | 73 BALDPATE HILL RD | 42.306511 | -71.178633 | 50970 | 8 | 2024-10-18 16:15 | 1 | |
| 7968 | 7968 | 134 SOUTH AVE | 50970 | 2024-10-22 17:30 | 2024-10-23 | 0 | |||
| 8214 | 8214 | 8 BROADLAWN PARK | 42.304235 | -71.166066 | 50970 | 8 | 2024-10-24 10:00 | 1 | |
| 9872 | 9872 | 44 COLGATE RD | 42.327873 | -71.257392 | 50970 | 4 | 2024-11-07 14:45 | 1 | |
| 9883 | 9883 | 221 WALTHAM ST | 42.35952 | -71.222695 | 50970 | 3 | 2024-11-07 15:15 | 1 | |
| 9891 | 9891 | 131 MELROSE ST | 42.351983 | -71.249308 | 50970 | 4 | 2024-11-07 15:30 | 1 | |
| 9903 | 9903 | 522 COMMONWEALTH AVE | 42.336113 | -71.187672 | 50970 | 6 | 2024-11-07 16:00 | 1 | |
| 9909 | 9909 | 63 SOUTHGATE PARK | 42.355131 | -71.226581 | 50970 | 3 | 2024-11-07 16:15 | 1 | |
| 10077 | 10077 | 2133 COMMONWEALTH AVE | 42.348267 | -71.249137 | 50970 | 4 | 2024-11-13 07:30 | 2024-11-20 | 0 |
| 10951 | 10951 | 371 AUSTIN ST | 42.347765 | -71.22379 | 50970 | 2 | 2024-12-03 12:00 | 1 | |
| 11366 | 11366 | 701 BOYLSTON ST | 42.319378 | -71.199037 | 50970 | 6 | 2024-12-10 12:00 | 1 | |
| 13343 | 13343 | 46 TROY LN | 42.335307 | -71.219435 | 50970 | 5 | 2025-01-20 09:45 | 2025-01-23 | 0 |
| 13844 | 13844 | 63 TANGLEWOOD RD | 42.317271 | -71.181824 | 50970 | 8 | 2025-01-28 16:45 | 2025-01-31 | 0 |
| 14618 | 14618 | 63 PAGE RD | 42.354162 | -71.210763 | 50970 | 2 | 2025-02-13 16:45 | 1 | |
| 14818 | 14818 | 658 COMMONWEALTH AVE | 42.33555 | -71.194127 | 50970 | 6 | 2025-02-17 16:30 | 2025-02-24 | 0 |
| 15356 | 15356 | 176 DEDHAM ST | 42.313788 | -71.201642 | 50970 | 8 | 2025-02-24 16:15 | 2025-02-25 | 0 |
| 16392 | 16392 | 79 PEARL ST | 42.358545 | -71.188839 | 50970 | 1 | 2025-03-15 17:45 | 2025-03-17 | 0 |
| 18289 | 18289 | 44 ROLLING LN | 42.30747 | -71.172009 | 50970 | 8 | 2025-04-24 17:00 | 2025-04-28 | 0 |
| 18875 | 18875 | 44 ROLLING LN | 42.30747 | -71.172009 | 50970 | 8 | 2025-05-06 09:00 | 2025-05-13 | 0 |
| 20012 | 20012 | 22 ELMWOOD STREET | 42.355795 | -71.183118 | 50970 | 1 | 2025-05-26 22:00 | 2025-09-03 | 0 |
| 20161 | 20161 | 76 CLINTON PL | 42.339582 | -71.193834 | 50970 | 2 | 2025-05-28 15:30 | 2025-06-18 | 0 |
| 21154 | 21154 | 26 MERRILL RD | 42.337314 | -71.179191 | 50970 | 7 | 2025-06-11 14:30 | 2025-07-30 | 0 |
| 22341 | 22341 | 6 WHEELER RD | 42.312042 | -71.196237 | 50970 | 8 | 2025-06-30 10:30 | 1 | |
| 22351 | 22351 | 47 MONTCLAIR RD | 42.329898 | -71.228934 | 50970 | 5 | 2025-06-30 12:30 | 2025-07-01 | 0 |
| 23070 | 23070 | 999 WASHINGTON ST | 42.351066 | -71.213931 | 50970 | 2 | 2025-07-10 21:00 | 1 | |
| 23835 | 23835 | 1234 CHESTNUT ST | 42.309783 | -71.220132 | 50970 | 5 | 2025-07-21 14:45 | 2025-08-04 | 0 |
| 24399 | 24399 | 76 CLINTON PL | 42.339582 | -71.193834 | 50970 | 2 | 2025-07-30 14:00 | 2025-07-30 | 0 |
| 24540 | 24540 | 43 WINCHESTER RD | 42.349851 | -71.195909 | 50970 | 1 | 2025-08-02 09:15 | 2025-08-05 | 0 |
| 25833 | 25833 | 18 JOSEPH ROAD | 42.362589 | -71.215621 | 50970 | 3 | 2025-08-28 10:00 | 2025-09-09 | 0 |
| 26927 | 26927 | 38 FALMOUTH RD | 42.362406 | -71.2287 | 50970 | 3 | 2025-09-18 12:00 | 2025-10-07 | 0 |
| 28721 | 28721 | 232 BROOKLINE ST | 42.30261 | -71.176955 | 50970 | 8 | 2025-10-24 09:45 | 1 | |
| 30434 | 30434 | 89 PLEASANT ST | 42.331392 | -71.198406 | 50970 | 6 | 2025-11-26 10:00 | 1 | |
| 30960 | 30960 | 350 WOODWARD ST | 42.325389 | -71.225321 | 50970 | 5 | 2025-12-09 18:30 | 2025-12-11 | 0 |
| 31366 | 31366 | 436 WINCHESTER ST | 42.305643 | -71.205269 | 50970 | 8 | 2025-12-17 16:30 | 1 | |
| 31610 | 31610 | 499 CRAFTS ST | 42.360633 | -71.220371 | 50970 | 3 | 2025-12-21 16:00 | 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 );