_locations
45 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 |
|---|---|---|---|---|---|---|---|---|---|
| 527 | 527 | 6 DEBORAH ROAD | 42.309128 | -71.183458 | 53216 | 8 | 2024-06-15 | 2024-08-05 | 0 |
| 1308 | 1308 | 23 ROTHERWOOD RD | 42.323304 | -71.19975 | 53216 | 6 | 2024-06-24 | 1 | |
| 2541 | 2541 | 643 WATERTOWN ST | 42.355168 | -71.211392 | 53216 | 2 | 2024-07-15 09:30 | 1 | |
| 4761 | 4761 | 147 ARNOLD RD | 42.305756 | -71.192404 | 53216 | 8 | 2024-08-22 08:00 | 2024-09-04 | 0 |
| 4902 | 4902 | 62 CLINTON PL | 42.339635 | -71.194457 | 53216 | 2 | 2024-08-26 12:45 | 1 | |
| 6440 | 6440 | 6 NORTH GATE PARK | 42.354889 | -71.224113 | 53216 | 3 | 2024-09-26 11:00 | 1 | |
| 6650 | 6650 | 16 WALKER STREET | 42.354 | -71.212044 | 53216 | 2 | 2024-10-02 13:45 | 2024-10-03 | 0 |
| 7216 | 7216 | 215 AUBURNDALE AVE | 42.35035 | -71.240765 | 53216 | 4 | 2024-10-16 13:30 | 2024-10-22 | 0 |
| 7530 | 7530 | 60 JUNE LN | 42.295466 | -71.18191 | 53216 | 8 | 2024-10-18 11:30 | 1 | |
| 8314 | 8314 | 24 STONELEIGH RD | 42.352116 | -71.223153 | 53216 | 3 | 2024-10-25 10:00 | 2024-11-13 | 0 |
| 8648 | 8648 | 41 ORCHARD AVE | 42.352666 | -71.222014 | 53216 | 3 | 2024-10-29 10:00 | 1 | |
| 8726 | 8726 | 36 ALGONQUIN RD | 42.340393 | -71.170222 | 53216 | 7 | 2024-10-29 14:45 | 1 | |
| 8805 | 8805 | 18 WASHINGTON PARK | 42.349097 | -71.202022 | 53216 | 2 | 2024-10-30 09:30 | 1 | |
| 8841 | 8841 | 117 LINWOOD AVE | 42.362525 | -71.204583 | 53216 | 1 | 2024-10-30 12:00 | 1 | |
| 8848 | 8848 | 144 WEBSTER ST | 42.349013 | -71.232797 | 53216 | 3 | 2024-10-30 12:15 | 1 | |
| 9299 | 9299 | 429 AUBURN ST | 42.346116 | -71.251203 | 53216 | 4 | 2024-11-01 11:15 | 1 | |
| 9316 | 9316 | 353 ELLIOT ST | 42.312958 | -71.224466 | 53216 | 5 | 2024-11-01 11:30 | 2024-11-01 | 0 |
| 9324 | 9324 | 190 SUMNER ST | 42.331632 | -71.191857 | 53216 | 6 | 2024-11-01 11:45 | 1 | |
| 9325 | 9325 | 30 WALKER ST | 42.353545 | -71.212183 | 53216 | 2 | 2024-11-01 11:45 | 1 | |
| 9326 | 9326 | 73 LAKEVIEW AVE | 42.338419 | -71.209864 | 53216 | 2 | 2024-11-01 11:45 | 1 | |
| 9575 | 9575 | 24 ROTHERWOOD RD | 42.323125 | -71.199356 | 53216 | 6 | 2024-11-05 11:15 | 1 | |
| 9629 | 9629 | 20 REDWOOD RD | 42.303996 | -71.182778 | 53216 | 8 | 2024-11-05 13:45 | 1 | |
| 9680 | 9680 | 259 WATERTOWN ST | 42.3618 | -71.197185 | 53216 | 1 | 2024-11-05 16:00 | 1 | |
| 11401 | 11401 | 1650 WASHINGTON ST | 42.341599 | -71.236838 | 53216 | 3 | 2024-12-10 14:30 | 2025-11-15 | 0 |
| 11517 | 11517 | 1321 CENTRE STREET | 42.328834 | -71.196597 | 53216 | 6 | 2024-12-11 16:00 | 2024-12-12 | 0 |
| 14608 | 14608 | 1075 COMMONWEALTH AVE | 53216 | 2025-02-13 14:30 | 2025-02-13 | 0 | |||
| 15281 | 15281 | 56 WOODCLIFF RD | 42.32007 | -71.201967 | 53216 | 6 | 2025-02-23 16:00 | 2025-02-24 | 0 |
| 15301 | 15301 | 56 WOODCLIFF RD | 42.32007 | -71.201967 | 53216 | 6 | 2025-02-24 09:15 | 1 | |
| 15852 | 15852 | 104 MANET RD | 42.335685 | -71.175996 | 53216 | 7 | 2025-03-06 21:15 | 2025-06-13 | 0 |
| 16028 | 16028 | 30 MILO ST | 42.360948 | -71.233731 | 53216 | 3 | 2025-03-09 12:15 | 1 | |
| 16323 | 16323 | 2271 COMMONWEALTH AVE | 42.347367 | -71.255417 | 53216 | 4 | 2025-03-13 14:45 | 2025-03-17 | 0 |
| 20729 | 20729 | 29 JASSET ST | 42.363729 | -71.198132 | 53216 | 1 | 2025-06-05 08:15 | 2025-09-22 | 0 |
| 21984 | 21984 | 544 WALNUT STREET | 42.342551 | -71.206229 | 53216 | 2 | 2025-06-24 07:00 | 2025-06-24 | 0 |
| 22009 | 22009 | 80 WABAN HILL ROAD | 42.33941 | -71.171311 | 53216 | 7 | 2025-06-24 11:15 | 1 | |
| 24114 | 24114 | 25 BREAMORE RD | 42.357051 | -71.178998 | 53216 | 1 | 2025-07-25 10:30 | 2025-09-22 | 0 |
| 25880 | 25880 | 1086 COMMONWEALTH AVENUE | 42.337993 | -71.211753 | 53216 | 2 | 2025-08-29 09:45 | 1 | |
| 26458 | 26458 | 81 ALBEMARLE ROAD | 42.362627 | -71.214887 | 53216 | 3 | 2025-09-10 14:15 | 1 | |
| 27010 | 27010 | 10 COLLINS RD | 42.325623 | -71.231418 | 53216 | 5 | 2025-09-20 17:00 | 2025-10-17 | 0 |
| 27048 | 27048 | 208 EVELYN RD | 42.33681 | -71.219871 | 53216 | 5 | 2025-09-22 12:15 | 2025-11-20 | 0 |
| 28080 | 28080 | 96 WABAN ST | 42.357897 | -71.193375 | 53216 | 1 | 2025-10-11 16:45 | 2025-10-14 | 0 |
| 29131 | 29131 | 96 WABAN STREET | 42.358038 | -71.193557 | 53216 | 1 | 2025-11-01 09:15 | 2025-11-03 | 0 |
| 29349 | 29349 | 393 FULLER ST | 42.339258 | -71.235779 | 53216 | 4 | 2025-11-05 08:00 | 2025-11-18 | 0 |
| 29654 | 29654 | 77 COTTON ST | 42.342777 | -71.186553 | 53216 | 7 | 2025-11-11 19:00 | 1 | |
| 29849 | 29849 | 199 DORSET RD | 42.330951 | -71.240522 | 53216 | 5 | 2025-11-15 16:30 | 2025-11-24 | 0 |
| 31022 | 31022 | 436 PARKER STREET | 42.312657 | -71.196226 | 53216 | 8 | 2025-12-11 07:45 | 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 );