_locations
47 rows where category_id = 53216
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 |
|---|---|---|---|---|---|---|---|---|---|
| 528 | 528 | 6 DEBORAH ROAD | 42.309128 | -71.183458 | 53216 | 8 | 2024-06-16 | 2024-08-05 | 0 |
| 984 | 984 | 23 ROTHERWOOD RD | 42.323304 | -71.19975 | 53216 | 6 | 2024-06-24 | 1 | |
| 1910 | 1910 | 643 WATERTOWN ST | 42.355168 | -71.211392 | 53216 | 2 | 2024-07-15 | 1 | |
| 3498 | 3498 | 147 ARNOLD RD | 42.305756 | -71.192404 | 53216 | 8 | 2024-08-22 | 2024-09-04 | 0 |
| 3605 | 3605 | 62 CLINTON PL | 42.339635 | -71.194457 | 53216 | 2 | 2024-08-26 | 1 | |
| 4711 | 4711 | 6 NORTH GATE PARK | 42.354889 | -71.224113 | 53216 | 3 | 2024-09-26 | 1 | |
| 4857 | 4857 | 16 WALKER STREET | 42.354 | -71.212044 | 53216 | 2 | 2024-10-02 | 2024-10-03 | 0 |
| 5291 | 5291 | 215 AUBURNDALE AVE | 42.35035 | -71.240765 | 53216 | 4 | 2024-10-16 | 2024-10-22 | 0 |
| 5438 | 5438 | 60 JUNE LN | 42.295466 | -71.18191 | 53216 | 8 | 2024-10-18 | 1 | |
| 5834 | 5834 | 24 STONELEIGH RD | 42.352116 | -71.223153 | 53216 | 3 | 2024-10-25 | 2024-11-13 | 0 |
| 6032 | 6032 | 41 ORCHARD AVE | 42.352666 | -71.222014 | 53216 | 3 | 2024-10-29 | 1 | |
| 6075 | 6075 | 36 ALGONQUIN RD | 42.340393 | -71.170222 | 53216 | 7 | 2024-10-29 | 1 | |
| 6130 | 6130 | 18 WASHINGTON PARK | 42.349097 | -71.202022 | 53216 | 2 | 2024-10-30 | 1 | |
| 6161 | 6161 | 117 LINWOOD AVE | 42.362525 | -71.204583 | 53216 | 1 | 2024-10-30 | 1 | |
| 6165 | 6165 | 144 WEBSTER ST | 42.349013 | -71.232797 | 53216 | 3 | 2024-10-30 | 1 | |
| 6360 | 6360 | 429 AUBURN ST | 42.346116 | -71.251203 | 53216 | 4 | 2024-11-01 | 1 | |
| 6368 | 6368 | 30 WALKER ST | 42.353545 | -71.212183 | 53216 | 2 | 2024-11-01 | 1 | |
| 6369 | 6369 | 353 ELLIOT ST | 42.312958 | -71.224466 | 53216 | 5 | 2024-11-01 | 2024-11-01 | 0 |
| 6379 | 6379 | 190 SUMNER ST | 42.331632 | -71.191857 | 53216 | 6 | 2024-11-01 | 1 | |
| 6380 | 6380 | 73 LAKEVIEW AVE | 42.338419 | -71.209864 | 53216 | 2 | 2024-11-01 | 1 | |
| 6556 | 6556 | 24 ROTHERWOOD RD | 42.323125 | -71.199356 | 53216 | 6 | 2024-11-05 | 1 | |
| 6591 | 6591 | 20 REDWOOD RD | 42.303996 | -71.182778 | 53216 | 8 | 2024-11-05 | 1 | |
| 6618 | 6618 | 259 WATERTOWN ST | 42.3618 | -71.197185 | 53216 | 1 | 2024-11-05 | 1 | |
| 7909 | 7909 | 1650 WASHINGTON ST | 42.341599 | -71.236838 | 53216 | 3 | 2024-12-10 | 2025-11-15 | 0 |
| 7987 | 7987 | 1321 CENTRE STREET | 42.328834 | -71.196597 | 53216 | 6 | 2024-12-11 | 2024-12-12 | 0 |
| 10375 | 10375 | 123 MAIN ST | 42.358977 | -71.193325 | 53216 | 1 | 2025-02-11 | 2025-02-11 | 0 |
| 10376 | 10376 | 170 PEARL ST | 42.358977 | -71.193325 | 53216 | 1 | 2025-02-11 | 2025-02-11 | 0 |
| 10426 | 10426 | 1075 COMMONWEALTH AVE | 53216 | 2025-02-13 | 2025-02-13 | 0 | |||
| 11007 | 11007 | 56 WOODCLIFF RD | 42.32007 | -71.201967 | 53216 | 6 | 2025-02-23 | 2025-02-24 | 0 |
| 11021 | 11021 | 56 WOODCLIFF RD | 42.32007 | -71.201967 | 53216 | 6 | 2025-02-24 | 1 | |
| 11411 | 11411 | 104 MANET RD | 42.335685 | -71.175996 | 53216 | 7 | 2025-03-07 | 2025-06-13 | 0 |
| 11544 | 11544 | 30 MILO ST | 42.360948 | -71.233731 | 53216 | 3 | 2025-03-09 | 1 | |
| 11754 | 11754 | 2271 COMMONWEALTH AVE | 42.347367 | -71.255417 | 53216 | 4 | 2025-03-13 | 2025-03-17 | 0 |
| 15063 | 15063 | 29 JASSET ST | 42.363729 | -71.198132 | 53216 | 1 | 2025-06-05 | 2025-09-22 | 0 |
| 16065 | 16065 | 544 WALNUT STREET | 42.342551 | -71.206229 | 53216 | 2 | 2025-06-24 | 2025-06-24 | 0 |
| 16084 | 16084 | 80 WABAN HILL ROAD | 42.33941 | -71.171311 | 53216 | 7 | 2025-06-24 | 1 | |
| 17681 | 17681 | 25 BREAMORE RD | 42.357051 | -71.178998 | 53216 | 1 | 2025-07-25 | 2025-09-22 | 0 |
| 18934 | 18934 | 1086 COMMONWEALTH AVENUE | 42.337993 | -71.211753 | 53216 | 2 | 2025-08-29 | 1 | |
| 19366 | 19366 | 81 ALBEMARLE ROAD | 42.362627 | -71.214887 | 53216 | 3 | 2025-09-10 | 1 | |
| 19757 | 19757 | 10 COLLINS RD | 42.325623 | -71.231418 | 53216 | 5 | 2025-09-20 | 2025-10-17 | 0 |
| 19780 | 19780 | 208 EVELYN RD | 42.33681 | -71.219871 | 53216 | 5 | 2025-09-22 | 2025-11-20 | 0 |
| 20518 | 20518 | 96 WABAN ST | 42.357897 | -71.193375 | 53216 | 1 | 2025-10-11 | 2025-10-14 | 0 |
| 21322 | 21322 | 96 WABAN STREET | 42.358038 | -71.193557 | 53216 | 1 | 2025-11-01 | 2025-11-03 | 0 |
| 21494 | 21494 | 393 FULLER ST | 42.339258 | -71.235779 | 53216 | 4 | 2025-11-05 | 2025-11-18 | 0 |
| 21728 | 21728 | 77 COTTON ST | 42.342777 | -71.186553 | 53216 | 7 | 2025-11-12 | 1 | |
| 21882 | 21882 | 199 DORSET RD | 42.330951 | -71.240522 | 53216 | 5 | 2025-11-15 | 2025-11-24 | 0 |
| 22780 | 22780 | 436 PARKER STREET | 42.312657 | -71.196226 | 53216 | 8 | 2025-12-11 | 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 );