_locations
231 rows where category_id = 51184
This data as json, CSV (advanced)
Suggested facets: ward, active, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 13467 | 13467 | 457 WALNUT ST | 42.345128 | -71.207614 | 51184 | 2 | 2025-05-02 | 1 | |
| 13468 | 13468 | 147 LAKE AVE | 42.328032 | -71.20324 | 51184 | 6 | 2025-05-02 | 1 | |
| 13469 | 13469 | 86 GODDARD ST | 42.304743 | -71.208864 | 51184 | 8 | 2025-05-02 | 2025-10-16 | 0 |
| 13470 | 13470 | 246 DUDLEY RD | 42.312636 | -71.179659 | 51184 | 8 | 2025-05-02 | 2025-05-08 | 0 |
| 13526 | 13526 | 74 ELLIOT ST | 42.316362 | -71.213049 | 51184 | 5 | 2025-05-05 | 2025-05-05 | 0 |
| 13529 | 13529 | 47 MORTON ST | 42.34059 | -71.200944 | 51184 | 2 | 2025-05-05 | 2025-10-28 | 0 |
| 13749 | 13749 | 25 HUNNEWELL AVE | 42.355494 | -71.173098 | 51184 | 1 | 2025-05-08 | 2025-12-11 | 0 |
| 13914 | 13914 | 270 MOUNT VERNON ST | 42.34743 | -71.221185 | 51184 | 2 | 2025-05-13 | 2025-05-14 | 0 |
| 13932 | 13932 | 43 PRINCE ST | 42.343524 | -71.226698 | 51184 | 3 | 2025-05-13 | 2025-12-19 | 0 |
| 13934 | 13934 | 49 FAIRFAX ST | 42.342462 | -71.228318 | 51184 | 3 | 2025-05-13 | 2025-12-19 | 0 |
| 13937 | 13937 | 51 MIGNON RD | 42.340599 | -71.232152 | 51184 | 3 | 2025-05-13 | 1 | |
| 13963 | 13963 | 267 MOUNT VERNON ST | 42.347565 | -71.220767 | 51184 | 2 | 2025-05-14 | 2025-12-19 | 0 |
| 13969 | 13969 | 38 CHESTERFIELD RD | 42.339852 | -71.235342 | 51184 | 3 | 2025-05-14 | 1 | |
| 13970 | 13970 | 1742 COMMONWEALTH AVE | 42.340563 | -71.238447 | 51184 | 4 | 2025-05-14 | 1 | |
| 13973 | 13973 | 33 TENNYSON RD | 42.343335 | -71.232062 | 51184 | 3 | 2025-05-14 | 1 | |
| 14020 | 14020 | 16 KINGSWOOD RD | 42.351894 | -71.255223 | 51184 | 4 | 2025-05-15 | 1 | |
| 14032 | 14032 | 76 FREEMAN ST | 42.351237 | -71.247155 | 51184 | 4 | 2025-05-15 | 1 | |
| 14033 | 14033 | 148 LEXINGTON ST | 42.355431 | -71.241449 | 51184 | 4 | 2025-05-15 | 1 | |
| 14034 | 14034 | 138 LEXINGTON ST | 42.355683 | -71.241062 | 51184 | 4 | 2025-05-15 | 1 | |
| 14041 | 14041 | 211 AUBURNDALE AVE | 42.350382 | -71.240517 | 51184 | 4 | 2025-05-15 | 2025-07-17 | 0 |
| 14042 | 14042 | 41 MURRAY RD | 42.350076 | -71.238438 | 51184 | 4 | 2025-05-15 | 1 | |
| 14049 | 14049 | 43 DEARBORN ST | 42.356304 | -71.232647 | 51184 | 3 | 2025-05-15 | 1 | |
| 14050 | 14050 | 79 CLEVELAND ST | 42.357015 | -71.231436 | 51184 | 3 | 2025-05-15 | 1 | |
| 14134 | 14134 | 65 HAMMOND ST | 42.335721 | -71.178705 | 51184 | 7 | 2025-05-19 | 1 | |
| 14136 | 14136 | 53 MARSHALL ST | 42.334497 | -71.190477 | 51184 | 6 | 2025-05-19 | 1 | |
| 14137 | 14137 | 111 FLORAL ST | 42.320097 | -71.207438 | 51184 | 6 | 2025-05-19 | 2025-12-09 | 0 |
| 14138 | 14138 | 130 BERKELEY ST | 42.341445 | -71.229596 | 51184 | 3 | 2025-05-19 | 1 | |
| 14141 | 14141 | 2027 COMMONWEALTH AVE | 42.347601 | -71.244315 | 51184 | 4 | 2025-05-19 | 1 | |
| 14150 | 14150 | 117 RUSSELL RD | 42.362073 | -71.22789 | 51184 | 3 | 2025-05-19 | 1 | |
| 14151 | 14151 | 101 FALMOUTH RD | 42.360678 | -71.230158 | 51184 | 3 | 2025-05-19 | 1 | |
| 14158 | 14158 | 26 LAUREL AVE | 42.361137 | -71.235293 | 51184 | 3 | 2025-05-19 | 1 | |
| 14159 | 14159 | 257 WALTHAM ST | 42.358239 | -71.22312 | 51184 | 3 | 2025-05-19 | 1 | |
| 14163 | 14163 | 239 WALTHAM ST | 42.358887 | -71.22285 | 51184 | 3 | 2025-05-19 | 1 | |
| 14164 | 14164 | 75 CHERRY ST | 42.361587 | -71.226968 | 51184 | 3 | 2025-05-19 | 1 | |
| 14168 | 14168 | 47 CHERRY ST | 42.362604 | -71.226927 | 51184 | 3 | 2025-05-19 | 1 | |
| 14169 | 14169 | 203 WALTHAM ST | 42.36003 | -71.222751 | 51184 | 3 | 2025-05-19 | 1 | |
| 14172 | 14172 | 15 LYME RD | 42.359796 | -71.223318 | 51184 | 3 | 2025-05-19 | 1 | |
| 14173 | 14173 | 3 RANGELEY RD | 42.358113 | -71.225132 | 51184 | 3 | 2025-05-19 | 1 | |
| 14174 | 14174 | 21 PLEASANT ST | 42.358311 | -71.223957 | 51184 | 3 | 2025-05-19 | 1 | |
| 14178 | 14178 | 26 CHASE AVE | 42.363693 | -71.223093 | 51184 | 3 | 2025-05-19 | 1 | |
| 14179 | 14179 | 88 HARDING ST | 42.363018 | -71.223053 | 51184 | 3 | 2025-05-19 | 1 | |
| 14184 | 14184 | 86 MORRILL ST | 42.363045 | -71.221892 | 51184 | 3 | 2025-05-19 | 1 | |
| 14188 | 14188 | 480 CRAFTS ST | 42.360201 | -71.219579 | 51184 | 3 | 2025-05-19 | 1 | |
| 14213 | 14213 | 46 MOSMAN ST | 42.362046 | -71.219088 | 51184 | 3 | 2025-05-20 | 1 | |
| 14214 | 14214 | 153 ALBEMARLE RD | 42.360831 | -71.216816 | 51184 | 3 | 2025-05-20 | 1 | |
| 14216 | 14216 | 48 BROOKDALE RD | 42.360777 | -71.215155 | 51184 | 2 | 2025-05-20 | 1 | |
| 14222 | 14222 | 51 WILDWOOD AVE | 42.354576 | -71.215488 | 51184 | 3 | 2025-05-20 | 1 | |
| 14236 | 14236 | 5 LINDBERGH AVE | 42.352191 | -71.225694 | 51184 | 3 | 2025-05-20 | 2025-09-18 | 0 |
| 14242 | 14242 | 774 WATERTOWN ST | 42.352767 | -71.21664 | 51184 | 3 | 2025-05-20 | 1 | |
| 14245 | 14245 | 464 CRAFTS ST | 42.360165 | -71.219003 | 51184 | 3 | 2025-05-20 | 1 | |
| 14248 | 14248 | 125 LOWELL AVE | 42.352956 | -71.210115 | 51184 | 2 | 2025-05-20 | 1 | |
| 14249 | 14249 | 12 MELBOURNE AVE | 42.364026 | -71.204936 | 51184 | 1 | 2025-05-20 | 1 | |
| 14309 | 14309 | 63 PIERREPONT RD | 42.332283 | -71.257055 | 51184 | 4 | 2025-05-21 | 1 | |
| 14311 | 14311 | 4 TRAVIS DR | 42.340617 | -71.175578 | 51184 | 7 | 2025-05-21 | 2025-12-16 | 0 |
| 14312 | 14312 | 27 RESERVOIR DR | 42.339285 | -71.176113 | 51184 | 7 | 2025-05-21 | 2025-12-16 | 0 |
| 14313 | 14313 | 209 COMMONWEALTH AVE | 42.33771 | -71.174376 | 51184 | 7 | 2025-05-21 | 1 | |
| 14314 | 14314 | 717 CENTRE ST | 42.347286 | -71.189267 | 51184 | 2 | 2025-05-21 | 1 | |
| 14318 | 14318 | 195 MILL ST | 42.341931 | -71.201034 | 51184 | 2 | 2025-05-21 | 2025-07-17 | 0 |
| 14323 | 14323 | 16 ROYCE RD | 42.339825 | -71.201822 | 51184 | 2 | 2025-05-21 | 2025-06-10 | 0 |
| 14324 | 14324 | 42 HAMLIN RD | 42.339555 | -71.200737 | 51184 | 2 | 2025-05-21 | 2025-06-11 | 0 |
| 14325 | 14325 | 63 NATHAN RD | 42.337044 | -71.193542 | 51184 | 2 | 2025-05-21 | 2025-07-17 | 0 |
| 14326 | 14326 | 33 BLAKE ST | 42.347061 | -71.198721 | 51184 | 2 | 2025-05-21 | 1 | |
| 14327 | 14327 | 46 BLAKE ST | 42.346728 | -71.198046 | 51184 | 2 | 2025-05-21 | 1 | |
| 14418 | 14418 | 170 FULLER ST | 42.336288 | -71.226864 | 51184 | 5 | 2025-05-23 | 2025-10-30 | 0 |
| 14419 | 14419 | 91 MARY ELLEN RD | 42.33672 | -71.217788 | 51184 | 5 | 2025-05-23 | 2025-06-13 | 0 |
| 14528 | 14528 | 148 DARTMOUTH ST | 42.335199 | -71.228538 | 51184 | 5 | 2025-05-27 | 2025-10-30 | 0 |
| 14529 | 14529 | 29 PICKWICK RD | 42.336801 | -71.231954 | 51184 | 5 | 2025-05-27 | 2025-10-31 | 0 |
| 14531 | 14531 | 1575 COMMONWEALTH AVE | 42.339654 | -71.231211 | 51184 | 3 | 2025-05-27 | 1 | |
| 14534 | 14534 | 1282 BEACON ST | 42.330672 | -71.215992 | 51184 | 6 | 2025-05-27 | 1 | |
| 14572 | 14572 | 394 HOMER ST | 42.337044 | -71.210462 | 51184 | 2 | 2025-05-28 | 1 | |
| 14574 | 14574 | 32 MASON RD | 42.336567 | -71.198091 | 51184 | 6 | 2025-05-28 | 2025-12-10 | 0 |
| 14578 | 14578 | 54 BOTHFELD RD | 42.337494 | -71.205323 | 51184 | 2 | 2025-05-28 | 2025-12-10 | 0 |
| 14579 | 14579 | 55 ELLISON RD | 42.336837 | -71.206038 | 51184 | 2 | 2025-05-28 | 2025-12-10 | 0 |
| 14580 | 14580 | 330 HOMER ST | 42.336045 | -71.207843 | 51184 | 2 | 2025-05-28 | 1 | |
| 14586 | 14586 | 774 WALNUT ST | 42.334713 | -71.207231 | 51184 | 6 | 2025-05-28 | 1 | |
| 14587 | 14587 | 37 CHARLOTTE RD | 42.333993 | -71.203307 | 51184 | 6 | 2025-05-28 | 1 | |
| 14588 | 14588 | 42 STAFFORD RD | 42.334281 | -71.19977 | 51184 | 6 | 2025-05-28 | 1 | |
| 14599 | 14599 | 155 GRANT AVE | 42.334614 | -71.187971 | 51184 | 6 | 2025-05-28 | 1 | |
| 14600 | 14600 | 565 COMMONWEALTH AVE | 42.336468 | -71.189978 | 51184 | 7 | 2025-05-28 | 2025-06-10 | 0 |
| 14601 | 14601 | 45 OLD COLONY RD | 42.335613 | -71.173476 | 51184 | 7 | 2025-05-28 | 1 | |
| 14602 | 14602 | 25 PRISCILLA RD | 42.336288 | -71.174097 | 51184 | 7 | 2025-05-28 | 1 | |
| 14646 | 14646 | 900 BEACON ST | 42.330303 | -71.19855 | 51184 | 6 | 2025-05-29 | 1 | |
| 14647 | 14647 | 888 BEACON ST | 42.330177 | -71.19774 | 51184 | 6 | 2025-05-29 | 1 | |
| 14672 | 14672 | 25 LOUISE RD | 42.317136 | -71.175785 | 51184 | 8 | 2025-05-29 | 2025-11-04 | 0 |
| 14713 | 14713 | 797 BEACON ST | 42.330411 | -71.193479 | 51184 | 6 | 2025-05-30 | 1 | |
| 14716 | 14716 | 784 BEACON ST | 42.330186 | -71.192939 | 51184 | 6 | 2025-05-30 | 1 | |
| 14735 | 14735 | 9 WALTER ST | 42.320898 | -71.192133 | 51184 | 6 | 2025-05-30 | 2025-11-04 | 0 |
| 14736 | 14736 | 32 GLENWOOD AVE | 42.323238 | -71.192822 | 51184 | 6 | 2025-05-30 | 2025-11-04 | 0 |
| 14737 | 14737 | 271 CYPRESS ST | 42.321735 | -71.188398 | 51184 | 6 | 2025-05-30 | 1 | |
| 14738 | 14738 | 575 BOYLSTON ST | 42.31926 | -71.193209 | 51184 | 6 | 2025-05-30 | 1 | |
| 14831 | 14831 | 102 ALLERTON RD | 42.324372 | -71.200251 | 51184 | 6 | 2025-06-02 | 1 | |
| 14832 | 14832 | 22 ROWENA RD | 42.322878 | -71.196984 | 51184 | 6 | 2025-06-02 | 2025-12-09 | 0 |
| 14833 | 14833 | 72 CLOVERDALE RD | 42.319836 | -71.200076 | 51184 | 6 | 2025-06-02 | 2025-07-17 | 0 |
| 14838 | 14838 | 114 ATHELSTANE RD | 42.321519 | -71.199144 | 51184 | 6 | 2025-06-02 | 2025-12-09 | 0 |
| 14839 | 14839 | 167 PARKER ST | 42.321618 | -71.194352 | 51184 | 6 | 2025-06-02 | 2025-07-15 | 0 |
| 14851 | 14851 | 95 WOOD END RD | 42.322869 | -71.212766 | 51184 | 6 | 2025-06-02 | 2025-12-09 | 0 |
| 14852 | 14852 | 28 COCHITUATE RD | 42.323598 | -71.213594 | 51184 | 6 | 2025-06-02 | 2025-10-10 | 0 |
| 14855 | 14855 | 75 LINCOLN ST | 42.321456 | -71.209184 | 51184 | 6 | 2025-06-02 | 1 | |
| 14875 | 14875 | 81 WINSLOW RD | 42.328035 | -71.21745 | 51184 | 5 | 2025-06-02 | 2025-10-10 | 0 |
| 14876 | 14876 | 20 SAGAMORE RD | 42.326127 | -71.215974 | 51184 | 5 | 2025-06-02 | 2025-10-10 | 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 );