_locations
76 rows where category_id = 51041
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 |
|---|---|---|---|---|---|---|---|---|---|
| 12417 | 12417 | 1408 WALNUT ST | 42.314455 | -71.201841 | 51041 | 8 | 2025-04-03 | 2025-05-19 | 0 |
| 12418 | 12418 | 20 HARVARD ST | 42.351885 | -71.201691 | 51041 | 2 | 2025-04-03 | 1 | |
| 12419 | 12419 | 23 NEWTONVILLE AVENUE | 42.352198 | -71.187187 | 51041 | 1 | 2025-04-03 | 1 | |
| 12420 | 12420 | 299 WATERTOWN ST | 42.361179 | -71.198638 | 51041 | 1 | 2025-04-03 | 2025-05-13 | 0 |
| 12421 | 12421 | 381 DUDLEY RD | 42.308631 | -71.181774 | 51041 | 8 | 2025-04-03 | 1 | |
| 12422 | 12422 | 51 MIDDLESEX ROAD | 42.326376 | -71.162917 | 51041 | 7 | 2025-04-03 | 2025-05-15 | 0 |
| 12423 | 12423 | 549 COMMONWEALTH AVE | 42.336519 | -71.18913 | 51041 | 7 | 2025-04-03 | 2025-08-10 | 0 |
| 12424 | 12424 | 557 SAW MILL BROOK PARKWAY | 42.293566 | -71.182335 | 51041 | 8 | 2025-04-03 | 2025-08-13 | 0 |
| 12425 | 12425 | 78 LAKEWOOD RD | 42.326403 | -71.206934 | 51041 | 6 | 2025-04-03 | 1 | |
| 12426 | 12426 | 78 WINCHESTER STREET | 42.317104 | -71.207738 | 51041 | 5 | 2025-04-03 | 2025-09-22 | 0 |
| 12427 | 12427 | 90 OAK HILL STREET | 42.297867 | -71.180093 | 51041 | 8 | 2025-04-03 | 2025-05-29 | 0 |
| 12895 | 12895 | 60 MIDDLESEX RD | 42.326757 | -71.162681 | 51041 | 7 | 2025-04-16 | 2025-04-16 | 0 |
| 13082 | 13082 | 1269 CENTRE ST | 42.330186 | -71.195036 | 51041 | 6 | 2025-04-23 | 2025-04-23 | 0 |
| 13340 | 13340 | 291 WALNUT ST | 42.350922 | -71.20728 | 51041 | 2 | 2025-04-29 | 2025-09-04 | 0 |
| 13474 | 13474 | 342 BEACON ST | 42.332589 | -71.173238 | 51041 | 7 | 2025-05-02 | 2025-05-05 | 0 |
| 13805 | 13805 | 416 LANGLEY RD | 42.319881 | -71.183232 | 51041 | 6 | 2025-05-09 | 2025-05-12 | 0 |
| 14083 | 14083 | 91 OAK HILL ST | 42.298146 | -71.18024 | 51041 | 8 | 2025-05-16 | 2025-05-16 | 0 |
| 14254 | 14254 | 258 HAMMOND ST | 42.332337 | -71.171627 | 51041 | 7 | 2025-05-20 | 2025-05-20 | 0 |
| 14482 | 14482 | 1075 CENTRE STREET | 42.335479 | -71.193493 | 51041 | 6 | 2025-05-25 | 2025-07-16 | 0 |
| 14562 | 14562 | 173 JACKSON RD | 42.357087 | -71.195657 | 51041 | 1 | 2025-05-28 | 2025-05-28 | 0 |
| 14564 | 14564 | 893 WALNUT ST | 42.330645 | -71.207123 | 51041 | 6 | 2025-05-28 | 2025-05-28 | 0 |
| 14565 | 14565 | 94 WINCHESTER ST | 42.316785 | -71.208648 | 51041 | 5 | 2025-05-28 | 2025-05-28 | 0 |
| 14813 | 14813 | 970 BEACON ST | 42.33042 | -71.201511 | 51041 | 6 | 2025-06-02 | 1 | |
| 14898 | 14898 | 232 BROOKLINE ST | 42.30261 | -71.176955 | 51041 | 8 | 2025-06-03 | 1 | |
| 14902 | 14902 | 198 GREENWOOD ST | 42.306561 | -71.187944 | 51041 | 8 | 2025-06-03 | 1 | |
| 14907 | 14907 | 53 VERNON ST | 42.35445 | -71.181734 | 51041 | 1 | 2025-06-03 | 2025-06-04 | 0 |
| 14973 | 14973 | 543 HAMMOND ST | 42.32493 | -71.165498 | 51041 | 7 | 2025-06-04 | 1 | |
| 15170 | 15170 | 69 DAY ST | 42.338223 | -71.238141 | 51041 | 4 | 2025-06-06 | 1 | |
| 15173 | 15173 | 1766 WASHINGTON ST | 42.338781 | -71.239919 | 51041 | 4 | 2025-06-06 | 1 | |
| 15223 | 15223 | 41 ADAMS ST | 42.362127 | -71.205399 | 51041 | 1 | 2025-06-09 | 1 | |
| 15292 | 15292 | 288 LEXINGTON ST | 42.352119 | -71.245557 | 51041 | 4 | 2025-06-10 | 1 | |
| 15339 | 15339 | 1615 BEACON ST | 42.327261 | -71.230235 | 51041 | 5 | 2025-06-11 | 1 | |
| 15340 | 15340 | 47 WOODWARD ST | 42.320232 | -71.213427 | 51041 | 6 | 2025-06-11 | 1 | |
| 15345 | 15345 | 237 ADAMS ST | 42.35724 | -71.19891 | 51041 | 1 | 2025-06-11 | 1 | |
| 15505 | 15505 | 287 CENTRE ST | 42.35814 | -71.185023 | 51041 | 1 | 2025-06-13 | 1 | |
| 15506 | 15506 | 457 WALNUT ST | 42.345126 | -71.207613 | 51041 | 2 | 2025-06-13 | 2025-06-18 | 0 |
| 15565 | 15565 | 44 CAPITAL ST | 42.360453 | -71.195234 | 51041 | 1 | 2025-06-16 | 1 | |
| 15715 | 15715 | 137 LAKE AVE | 42.328278 | -71.203167 | 51041 | 6 | 2025-06-18 | 1 | |
| 15716 | 15716 | 3 MORELAND AVE | 42.3288 | -71.202722 | 51041 | 6 | 2025-06-18 | 1 | |
| 15717 | 15717 | 50 LAKE AVE | 42.329556 | -71.199297 | 51041 | 6 | 2025-06-18 | 1 | |
| 15718 | 15718 | 57 LAKE AVE | 42.329916 | -71.199855 | 51041 | 6 | 2025-06-18 | 1 | |
| 15719 | 15719 | 770 BEACON ST | 42.330249 | -71.19225 | 51041 | 6 | 2025-06-18 | 1 | |
| 15720 | 15720 | 90 LAKE AVE | 42.329313 | -71.201012 | 51041 | 6 | 2025-06-18 | 1 | |
| 15799 | 15799 | 138 LAKE AVE | 42.328152 | -71.20251 | 51041 | 6 | 2025-06-19 | 1 | |
| 15802 | 15802 | 255 WASHINGTON ST | 42.357771 | -71.183844 | 51041 | 1 | 2025-06-19 | 1 | |
| 15972 | 15972 | 61 WASHBURN AVE | 42.351498 | -71.242781 | 51041 | 4 | 2025-06-23 | 1 | |
| 16026 | 16026 | 191 MILL STREET | 42.341704 | -71.200907 | 51041 | 2 | 2025-06-23 | 1 | |
| 16028 | 16028 | 431 WASHINGTON ST | 42.356043 | -71.190423 | 51041 | 1 | 2025-06-23 | 2025-07-01 | 0 |
| 16363 | 16363 | 761 WALNUT STREET | 42.335328 | -71.20905 | 51041 | 2 | 2025-06-30 | 1 | |
| 16478 | 16478 | 119 ADAMS ST | 42.360273 | -71.202893 | 51041 | 1 | 2025-07-02 | 1 | |
| 16699 | 16699 | 70 RIVER ST | 42.352119 | -71.229317 | 51041 | 3 | 2025-07-08 | 1 | |
| 16717 | 16717 | 457 WALNUT ST | 42.345126 | -71.207613 | 51041 | 2 | 2025-07-08 | 2025-09-16 | 0 |
| 16752 | 16752 | 1085 CENTRE ST | 42.335127 | -71.193632 | 51041 | 6 | 2025-07-09 | 1 | |
| 16753 | 16753 | 650 COMMONWEALTH AVE | 42.335631 | -71.193749 | 51041 | 6 | 2025-07-09 | 1 | |
| 16844 | 16844 | 1243 WALNUT STREET | 42.319512 | -71.204436 | 51041 | 6 | 2025-07-09 | 1 | |
| 16917 | 16917 | 233 COMMONWEALTH AVE | 42.337539 | -71.175704 | 51041 | 7 | 2025-07-11 | 1 | |
| 17409 | 17409 | 233 JACKSON RD | 42.35526 | -71.195459 | 51041 | 1 | 2025-07-19 | 1 | |
| 17456 | 17456 | 171 PEARL ST | 42.359256 | -71.193245 | 51041 | 1 | 2025-07-21 | 1 | |
| 17632 | 17632 | 5 HAMMOND ST | 42.337845 | -71.178696 | 51041 | 7 | 2025-07-24 | 1 | |
| 17720 | 17720 | 53 HOBART ROAD | 42.332188 | -71.181257 | 51041 | 7 | 2025-07-26 | 1 | |
| 18315 | 18315 | 108 FULLER STREET | 42.335475 | -71.223737 | 51041 | 5 | 2025-08-11 | 1 | |
| 18551 | 18551 | 887 CHESTNUT ST | 42.318846 | -71.226356 | 51041 | 5 | 2025-08-16 | 1 | |
| 18621 | 18621 | 200 HAMMOND ST | 42.333543 | -71.173202 | 51041 | 7 | 2025-08-19 | 1 | |
| 18622 | 18622 | 325 BEACON ST | 42.333273 | -71.171924 | 51041 | 7 | 2025-08-19 | 1 | |
| 18926 | 18926 | 191 COLLEGE ROAD | 42.337168 | -71.172143 | 51041 | 7 | 2025-08-28 | 1 | |
| 19071 | 19071 | 330 HOMER ST | 42.336045 | -71.207843 | 51041 | 2 | 2025-09-03 | 1 | |
| 19075 | 19075 | 680 WALNUT ST | 42.338106 | -71.20661 | 51041 | 2 | 2025-09-03 | 2025-09-05 | 0 |
| 20997 | 20997 | 1299 CENTRE ST | 42.329583 | -71.19536 | 51041 | 6 | 2025-10-23 | 1 | |
| 21296 | 21296 | 418 LANGLEY ROAD | 42.319909 | -71.182786 | 51041 | 6 | 2025-10-31 | 1 | |
| 21504 | 21504 | 2 WELLS AVE | 42.295185 | -71.20184 | 51041 | 8 | 2025-11-05 | 1 | |
| 21764 | 21764 | 566 GROVE ST | 42.329655 | -71.257959 | 51041 | 4 | 2025-11-12 | 1 | |
| 21798 | 21798 | 1063 COMMONWEALTH AVE | 42.338304 | -71.21043 | 51041 | 2 | 2025-11-12 | 1 | |
| 22142 | 22142 | 305 CENTRE ST | 42.357888 | -71.184929 | 51041 | 1 | 2025-11-20 | 1 | |
| 22242 | 22242 | 154 WASHINGTON STREET | 42.355993 | -71.180307 | 51041 | 1 | 2025-11-24 | 1 | |
| 23261 | 23261 | 28 DAY ST | 42.339411 | -71.237696 | 51041 | 4 | 2025-12-22 | 2025-12-22 | 0 |
| 23325 | 23325 | 76 CRESCENT ST | 42.346431 | -71.237709 | 51041 | 3 | 2025-12-23 | 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 );