_locations
413 rows where category_id = 51140
This data as json, CSV (advanced)
Suggested facets: active, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 415 | 415 | 185 VALENTINE ST | 42.339408 | -71.215989 | 51140 | 2 | 2024-06-17 | 0 | |
| 416 | 416 | 29 CHARLOTTE ROAD | 42.33377 | -71.203562 | 51140 | 6 | 2024-06-17 | 0 | |
| 417 | 417 | 575 WATERTOWN STREET | 42.356072 | -71.208468 | 51140 | 2 | 2024-08-15 | 0 | |
| 418 | 418 | 650 COMMONWEALTH AVE | 42.33563 | -71.193749 | 51140 | 6 | 2024-06-17 | 0 | |
| 419 | 419 | 75 HIGHLAND ST | 42.346631 | -71.226499 | 51140 | 3 | 2025-05-21 | 0 | |
| 851 | 851 | 42 OAK HILL ST | 42.299733 | -71.178896 | 51140 | 8 | 2024-06-21 | 2024-07-11 | 0 |
| 929 | 929 | 25 BOYLSTON STREET | 42.322828 | -71.166773 | 51140 | 2024-06-23 | 1 | ||
| 930 | 930 | 504 BOYLSTON STREET | 42.318774 | -71.190296 | 51140 | 6 | 2024-06-23 | 2024-06-24 | 0 |
| 931 | 931 | 528 MASSACHUSETTS 9 | 42.318897 | -71.191074 | 51140 | 6 | 2024-06-23 | 1 | |
| 1015 | 1015 | 1081 CENTRE ST | 42.335289 | -71.193637 | 51140 | 6 | 2024-06-25 | 2024-07-08 | 0 |
| 1107 | 1107 | 35 WESTVIEW TER | 42.344484 | -71.231295 | 51140 | 3 | 2024-06-26 | 2024-07-08 | 0 |
| 1180 | 1180 | 16 CHINIAN PATH | 42.291417 | -71.189162 | 51140 | 8 | 2024-06-27 | 2024-08-15 | 0 |
| 1229 | 1229 | 72 AUSTIN ST | 51140 | 2024-06-27 | 2024-07-11 | 0 | |||
| 1333 | 1333 | 171 WISWALL RD | 42.293887 | -71.189928 | 51140 | 8 | 2024-07-01 | 2024-07-11 | 0 |
| 1346 | 1346 | 139 ROWE ST | 42.34769 | -71.243327 | 51140 | 4 | 2024-07-01 | 2024-07-08 | 0 |
| 1358 | 1358 | 23 DAVIS ST | 42.3486 | -71.226507 | 51140 | 3 | 2024-07-01 | 2024-07-08 | 0 |
| 1519 | 1519 | 32 HARVARD ST | 42.35129 | -71.201423 | 51140 | 2 | 2024-07-05 | 2024-07-11 | 0 |
| 1569 | 1569 | 70 AUSTIN ST | 42.350186 | -71.210273 | 51140 | 2 | 2024-07-08 | 2024-07-08 | 0 |
| 1846 | 1846 | 355 WALNUT ST | 42.348825 | -71.207028 | 51140 | 2 | 2024-07-12 | 2024-08-01 | 0 |
| 1899 | 1899 | 171 WISWALL RD | 42.293887 | -71.189928 | 51140 | 8 | 2024-07-15 | 2024-08-15 | 0 |
| 2017 | 2017 | 1118 COMMONWEALTH AVE | 42.337691 | -71.212846 | 51140 | 2 | 2024-07-17 | 2024-08-01 | 0 |
| 2134 | 2134 | 1091–1135 COMMONWEALTH AVE | 42.338016 | -71.213081 | 51140 | 2 | 2024-07-18 | 2024-08-01 | 0 |
| 2135 | 2135 | 1125 COMMONWEALTH AVE | 42.338068 | -71.213041 | 51140 | 2 | 2024-07-18 | 2024-08-01 | 0 |
| 2247 | 2247 | 735 CENTRE ST | 42.346681 | -71.189681 | 51140 | 2 | 2024-07-23 | 2024-08-07 | 0 |
| 2370 | 2370 | 18 KELLER PATH | 42.290777 | -71.184641 | 51140 | 8 | 2024-07-26 | 2024-08-15 | 0 |
| 2620 | 2620 | 4 APPLEGARTH ST | 42.339625 | -71.195796 | 51140 | 2 | 2024-08-01 | 2024-08-12 | 0 |
| 2641 | 2641 | 2014 WASHINGTON ST | 42.331436 | -71.24684 | 51140 | 5 | 2024-08-02 | 1 | |
| 2835 | 2835 | 73 ELM RD | 42.346317 | -71.209827 | 51140 | 2 | 2024-08-07 | 2024-08-15 | 0 |
| 2967 | 2967 | 65 BERNARD ST | 42.304368 | -71.210398 | 51140 | 8 | 2024-08-09 | 2024-08-22 | 0 |
| 3321 | 3321 | 6 AGAWAM RD | 42.329656 | -71.246636 | 51140 | 5 | 2024-08-16 | 2024-08-19 | 0 |
| 3375 | 3375 | 2019 BEACON ST | 42.329901 | -71.24669 | 51140 | 5 | 2024-08-19 | 2024-08-22 | 0 |
| 3491 | 3491 | 69 MECHANIC STREET | 42.310849 | -71.218062 | 51140 | 5 | 2024-08-21 | 2024-08-27 | 0 |
| 3492 | 3492 | 87 OSSIPEE ROAD | 42.310753 | -71.218577 | 51140 | 5 | 2024-08-21 | 2024-08-27 | 0 |
| 3563 | 3563 | 30 COLBERT RD E | 42.339284 | -71.219539 | 51140 | 3 | 2024-08-23 | 2024-08-28 | 0 |
| 3591 | 3591 | 32 KAPPIUS PATH | 42.290136 | -71.185012 | 51140 | 8 | 2024-08-24 | 2024-08-28 | 0 |
| 3768 | 3768 | 2 CLARK STREET | 42.32328 | -71.200713 | 51140 | 6 | 2024-08-30 | 1 | |
| 3805 | 3805 | 32 HARVARD ST | 42.351352 | -71.201434 | 51140 | 2 | 2024-09-01 | 2024-09-17 | 0 |
| 3858 | 3858 | 1932 WASHINGTON ST | 42.333957 | -71.244526 | 51140 | 4 | 2024-09-03 | 2024-09-17 | 0 |
| 3865 | 3865 | 2 CLARK ST | 42.323245 | -71.200397 | 51140 | 6 | 2024-09-03 | 2024-09-03 | 0 |
| 4090 | 4090 | 15 HOBART RD | 42.338564 | -71.181839 | 51140 | 7 | 2024-09-10 | 2024-09-17 | 0 |
| 4203 | 4203 | 678 DEDHAM STREET | 42.30189 | -71.189803 | 51140 | 8 | 2024-09-12 | 2024-09-17 | 0 |
| 4204 | 4204 | 150 WELLS AVENUE | 42.292722 | -71.196503 | 51140 | 8 | 2024-09-12 | 2024-09-12 | 0 |
| 4205 | 4205 | 160 WELLS AVENUE | 42.293719 | -71.197453 | 51140 | 8 | 2024-09-12 | 2024-09-12 | 0 |
| 4206 | 4206 | 1 WELLS AVENUE | 42.295312 | -71.20287 | 51140 | 8 | 2024-09-12 | 2024-09-12 | 0 |
| 4207 | 4207 | 200 WELLS AVENUE | 42.295288 | -71.200263 | 51140 | 8 | 2024-09-12 | 2024-09-17 | 0 |
| 4422 | 4422 | 241 CHURCH ST | 42.354889 | -71.189198 | 51140 | 1 | 2024-09-17 | 2024-09-23 | 0 |
| 4552 | 4552 | 201–243 ALBEMARLE RD | 42.359348 | -71.217216 | 51140 | 3 | 2024-09-23 | 2024-09-25 | 0 |
| 4556 | 4556 | 970 COMMONWEALTH AVE | 42.338568 | -71.20655 | 51140 | 2 | 2024-09-24 | 1 | |
| 4614 | 4614 | 1940 WASHINGTON ST | 42.333389 | -71.243459 | 51140 | 4 | 2024-09-24 | 2024-09-25 | 0 |
| 4663 | 4663 | 1831 WASHINGTON ST | 42.337022 | -71.24171 | 51140 | 4 | 2024-09-25 | 2024-10-28 | 0 |
| 4727 | 4727 | 52 MILO ST | 42.360244 | -71.233963 | 51140 | 3 | 2024-09-27 | 2024-10-09 | 0 |
| 4775 | 4775 | 54 BEMIS ST | 42.362088 | -71.211595 | 51140 | 2 | 2024-09-29 | 2025-05-21 | 0 |
| 4876 | 4876 | 370 B CHERRY STREET | 42.351846 | -71.229413 | 51140 | 3 | 2024-10-03 | 2024-10-09 | 0 |
| 4884 | 4884 | 6 CHANNING ST | 42.358089 | -71.187798 | 51140 | 1 | 2024-10-03 | 2025-05-22 | 0 |
| 4894 | 4894 | 484 WATERTOWN ST | 42.358007 | -71.204757 | 51140 | 1 | 2024-10-03 | 2025-05-22 | 0 |
| 4895 | 4895 | 1362 WASHINGTON ST | 42.348419 | -71.228521 | 51140 | 3 | 2024-10-03 | 2024-10-28 | 0 |
| 4896 | 4896 | 216 LOWELL AVE | 42.349959 | -71.21062 | 51140 | 2 | 2024-10-03 | 2025-10-03 | 0 |
| 4911 | 4911 | 159 FLORENCE ST | 42.317628 | -71.175322 | 51140 | 8 | 2024-10-04 | 2024-10-17 | 0 |
| 4917 | 4917 | 5 HUNTER STREET | 42.347983 | -71.226931 | 51140 | 3 | 2024-10-04 | 2025-06-04 | 0 |
| 4918 | 4918 | 51 HIGHLAND STREET | 42.34748 | -71.226692 | 51140 | 3 | 2024-10-04 | 1 | |
| 4919 | 4919 | 59 HIGHLAND STREET | 42.347325 | -71.226647 | 51140 | 3 | 2024-10-04 | 1 | |
| 4922 | 4922 | 24 IRELAND RD | 42.339731 | -71.186768 | 51140 | 7 | 2024-10-04 | 2024-10-09 | 0 |
| 4945 | 4945 | 53 DOROTHY RD | 42.297248 | -71.187274 | 51140 | 8 | 2024-10-07 | 2024-10-11 | 0 |
| 4952 | 4952 | 2 WHITNEY ROAD | 42.344147 | -71.199909 | 51140 | 2 | 2024-10-07 | 2024-10-28 | 0 |
| 4975 | 4975 | 201–299 AUSTIN ST | 51140 | 2024-10-08 | 2025-05-22 | 0 | |||
| 5055 | 5055 | 45 OLD COLONY RD | 42.335681 | -71.173492 | 51140 | 7 | 2024-10-09 | 2024-10-17 | 0 |
| 5076 | 5076 | 106 SHORNECLIFFE RD | 42.348483 | -71.179241 | 51140 | 7 | 2024-10-10 | 2024-11-20 | 0 |
| 5078 | 5078 | 370 B CHERRY STREET | 42.351846 | -71.229413 | 51140 | 3 | 2024-10-10 | 2024-10-15 | 0 |
| 5110 | 5110 | 31 HERRICK RD | 42.329004 | -71.193522 | 51140 | 6 | 2024-10-11 | 2024-10-29 | 0 |
| 5150 | 5150 | 175 BRANDEIS ROAD | 42.313054 | -71.18476 | 51140 | 8 | 2024-10-13 | 2024-12-03 | 0 |
| 5288 | 5288 | 22 HARRINGTON STREET | 42.351722 | -71.215215 | 51140 | 3 | 2024-10-16 | 2025-09-02 | 0 |
| 5514 | 5514 | 170 OAKLEIGH RD | 42.357001 | -71.177727 | 51140 | 1 | 2024-10-21 | 2024-11-13 | 0 |
| 5517 | 5517 | 944 WATERTOWN ST | 42.350185 | -71.223746 | 51140 | 3 | 2024-10-21 | 2024-10-28 | 0 |
| 5599 | 5599 | 56 TAFT AVENUE | 42.362284 | -71.224011 | 51140 | 3 | 2024-10-22 | 2024-10-28 | 0 |
| 5700 | 5700 | 206 WALTHAM ST | 42.359831 | -71.221359 | 51140 | 3 | 2024-10-23 | 2024-10-28 | 0 |
| 5780 | 5780 | 49 LEXINGTON STREET | 42.357912 | -71.239716 | 51140 | 4 | 2024-10-24 | 2024-10-28 | 0 |
| 5831 | 5831 | 1087 COMMONWEALTH AVE | 42.338454 | -71.211359 | 51140 | 2 | 2024-10-25 | 2024-10-28 | 0 |
| 5847 | 5847 | 69 PICKWICK ROAD | 42.33583 | -71.230948 | 51140 | 5 | 2024-10-25 | 2024-10-28 | 0 |
| 5863 | 5863 | 300 HAMMOND POND PKWY | 42.325314 | -71.177399 | 51140 | 7 | 2024-10-25 | 2024-10-28 | 0 |
| 5985 | 5985 | 288 CENTRE STREET | 42.358431 | -71.184808 | 51140 | 1 | 2024-10-29 | 1 | |
| 5986 | 5986 | 330 WASHINGTON ST | 42.35621 | -71.18682 | 51140 | 1 | 2024-10-29 | 1 | |
| 5987 | 5987 | 278 CHURCH STREET | 42.355239 | -71.190039 | 51140 | 1 | 2024-10-29 | 2024-10-30 | 0 |
| 5988 | 5988 | 475A WASHINGTON STREET | 42.355326 | -71.193032 | 51140 | 1 | 2024-10-29 | 2024-11-01 | 0 |
| 5989 | 5989 | 513 WASHINGTON STREET | 42.355067 | -71.193685 | 51140 | 1 | 2024-10-29 | 1 | |
| 5990 | 5990 | 527 WASHINGTON STREET | 42.355168 | -71.194512 | 51140 | 1 | 2024-10-29 | 1 | |
| 5991 | 5991 | 681 WASHINGTON STREET | 42.353087 | -71.20159 | 51140 | 2 | 2024-10-29 | 2024-11-13 | 0 |
| 5992 | 5992 | 787 WASHINGTON STREET | 42.352052 | -71.205672 | 51140 | 2 | 2024-10-29 | 1 | |
| 6077 | 6077 | 65 KENILWORTH ST | 42.34347 | -71.17917 | 51140 | 7 | 2024-10-29 | 2024-10-30 | 0 |
| 6102 | 6102 | 240 GREENWOOD ST | 42.305423 | -71.189369 | 51140 | 8 | 2024-10-29 | 2024-10-30 | 0 |
| 6283 | 6283 | 155–163 GRANT AVE | 42.334809 | -71.187453 | 51140 | 6 | 2024-10-30 | 2024-11-13 | 0 |
| 6286 | 6286 | 879–899 COMMONWEALTH AVE | 42.338202 | -71.203268 | 51140 | 2 | 2024-10-31 | 2024-11-01 | 0 |
| 6287 | 6287 | 895 COMMONWEALTH AVE | 42.338402 | -71.203324 | 51140 | 2 | 2024-10-31 | 2024-11-01 | 0 |
| 6448 | 6448 | 704 WALNUT ST | 42.337237 | -71.206642 | 51140 | 2 | 2024-11-03 | 2024-11-04 | 0 |
| 6459 | 6459 | 95 NEVADA ST | 42.363202 | -71.213711 | 51140 | 2 | 2024-11-04 | 2024-11-06 | 0 |
| 6543 | 6543 | 6 ANTHONY RD | 42.363732 | -71.214367 | 51140 | 3 | 2024-11-05 | 2024-11-06 | 0 |
| 6547 | 6547 | 582 BEACON ST | 42.33152 | -71.183867 | 51140 | 7 | 2024-11-05 | 2024-11-13 | 0 |
| 6633 | 6633 | 457 CENTRE ST | 42.354959 | -71.186512 | 51140 | 1 | 2024-11-05 | 1 | |
| 6673 | 6673 | 187 WOODCLIFF RD | 42.315961 | -71.20121 | 51140 | 5 | 2024-11-07 | 2024-11-13 | 0 |
| 6820 | 6820 | 277 WALTHAM STREET | 42.357379 | -71.223227 | 51140 | 3 | 2024-11-08 | 2024-11-20 | 0 |
| 6840 | 6840 | 2360 COMMONWEALTH AVE | 51140 | 2024-11-11 | 2024-11-20 | 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 );