_locations
108 rows where category_id = 53469
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 |
|---|---|---|---|---|---|---|---|---|---|
| 1143 | 1143 | 26 HOMESTEAD ST | 42.32621 | -71.224055 | 53469 | 5 | 2024-07-01 | 0 | |
| 1144 | 1144 | 288 PRINCE STREET | 42.338548 | -71.220444 | 53469 | 3 | 2024-07-01 | 0 | |
| 1145 | 1145 | 71 FAIRLEE RD | 42.323654 | -71.223585 | 53469 | 5 | 2024-08-22 | 0 | |
| 1929 | 1929 | 22 BRACKETT RD | 42.343317 | -71.183663 | 53469 | 7 | 2024-07-03 09:00 | 2024-07-11 | 0 |
| 3640 | 3640 | 23 WEBSTER ST | 42.350598 | -71.22756 | 53469 | 3 | 2024-08-05 10:00 | 2024-08-12 | 0 |
| 3743 | 3743 | 5 TALBOT ST | 42.357069 | -71.226934 | 53469 | 3 | 2024-08-06 12:15 | 2025-08-05 | 0 |
| 4334 | 4334 | 124 JEWETT ST | 42.356903 | -71.19128 | 53469 | 1 | 2024-08-14 09:30 | 2024-08-19 | 0 |
| 4593 | 4593 | 5 HARWICH RD | 42.3042 | -71.171906 | 53469 | 8 | 2024-08-19 11:15 | 2024-08-22 | 0 |
| 5077 | 5077 | 109 RUSSELL RD | 42.361843 | -71.228035 | 53469 | 3 | 2024-08-28 15:30 | 2024-09-11 | 0 |
| 5799 | 5799 | 115 CYNTHIA RD | 42.306945 | -71.182257 | 53469 | 8 | 2024-09-13 11:30 | 2024-09-23 | 0 |
| 5800 | 5800 | 68 CYNTHIA RD | 42.308445 | -71.182753 | 53469 | 8 | 2024-09-13 11:30 | 2024-09-23 | 0 |
| 5897 | 5897 | 65 GRAY CLIFF RD | 42.332911 | -71.187121 | 53469 | 7 | 2024-09-16 10:15 | 2024-09-23 | 0 |
| 6939 | 6939 | 275 CENTRE ST | 42.358545 | -71.18527 | 53469 | 1 | 2024-10-10 08:30 | 2024-10-24 | 0 |
| 7028 | 7028 | 61 VERNDALE RD | 42.313706 | -71.206409 | 53469 | 8 | 2024-10-11 15:45 | 2024-11-19 | 0 |
| 8530 | 8530 | 430 QUINOBEQUIN RD | 42.322479 | -71.238077 | 53469 | 5 | 2024-10-28 14:30 | 2024-12-02 | 0 |
| 8757 | 8757 | 658 DEDHAM ST | 42.302707 | -71.19049 | 53469 | 8 | 2024-10-29 15:45 | 2024-11-01 | 0 |
| 9543 | 9543 | 33 ELIOT MEMORIAL RD | 42.344866 | -71.179904 | 53469 | 7 | 2024-11-05 09:15 | 2024-11-19 | 0 |
| 9997 | 9997 | 943 COMMONWEALTH AVE | 42.338974 | -71.205217 | 53469 | 2 | 2024-11-09 15:30 | 2024-11-26 | 0 |
| 10248 | 10248 | 15 NILES RD | 42.322306 | -71.21992 | 53469 | 5 | 2024-11-18 10:00 | 2024-12-13 | 0 |
| 10897 | 10897 | 61 VERNDALE RD | 42.313706 | -71.206409 | 53469 | 8 | 2024-12-02 12:15 | 2024-12-13 | 0 |
| 10903 | 10903 | 31 BEECHER PL | 42.321712 | -71.182896 | 53469 | 6 | 2024-12-02 14:30 | 2024-12-09 | 0 |
| 11183 | 11183 | 89 BEMIS ST | 42.363322 | -71.211387 | 53469 | 2 | 2024-12-07 12:30 | 2024-12-19 | 0 |
| 11798 | 11798 | 45 INDUSTRIAL PL | 42.309578 | -71.212327 | 53469 | 8 | 2024-12-17 10:45 | 2024-12-23 | 0 |
| 11856 | 11856 | 37 LAWMARISSA RD | 42.331154 | -71.227707 | 53469 | 5 | 2024-12-18 12:30 | 2025-01-23 | 0 |
| 11951 | 11951 | 57 DUDLEY RD | 42.317632 | -71.187204 | 53469 | 8 | 2024-12-20 15:15 | 2025-01-14 | 0 |
| 12099 | 12099 | 40 BUTTS ST | 42.307948 | -71.220052 | 53469 | 5 | 2024-12-23 10:00 | 2025-01-14 | 0 |
| 12394 | 12394 | 40 ALBEMARLE RD | 42.363617 | -71.213632 | 53469 | 2 | 2024-12-31 01:15 | 2025-01-11 | 0 |
| 12426 | 12426 | 1844 COMMONWEALTH AVE | 42.343083 | -71.24163 | 53469 | 4 | 2024-12-31 08:15 | 2025-01-18 | 0 |
| 13033 | 13033 | NEWTON HIGHLANDS PLAYGROUND | 42.316342 | -71.207266 | 53469 | 5 | 2025-01-13 06:30 | 2025-01-23 | 0 |
| 14131 | 14131 | 21 HARTFORD ST | 42.321006 | -71.208176 | 53469 | 6 | 2025-02-04 08:45 | 2025-02-19 | 0 |
| 14191 | 14191 | 6 FLORAL ST | 42.322362 | -71.20358 | 53469 | 6 | 2025-02-04 17:30 | 2025-02-13 | 0 |
| 14264 | 14264 | 24 CHAPEL ST | 42.364341 | -71.201822 | 53469 | 1 | 2025-02-06 16:15 | 2025-02-18 | 0 |
| 14297 | 14297 | 53 ANDREW ST | 42.313529 | -71.205551 | 53469 | 8 | 2025-02-07 12:45 | 2025-02-11 | 0 |
| 14412 | 14412 | 16 CHAPEL ST | 42.364584 | -71.20193 | 53469 | 1 | 2025-02-10 11:15 | 2025-02-18 | 0 |
| 14548 | 14548 | 942 BEACON ST | 42.330375 | -71.200184 | 53469 | 6 | 2025-02-12 08:00 | 2025-02-13 | 0 |
| 14946 | 14946 | 36 SELWYN RD | 42.315633 | -71.196984 | 53469 | 6 | 2025-02-18 11:15 | 2025-02-24 | 0 |
| 15134 | 15134 | 231 COUNTRY CLUB RD | 42.302527 | -71.189271 | 53469 | 8 | 2025-02-19 20:30 | 2025-02-24 | 0 |
| 15459 | 15459 | 309 WINCHESTER ST | 42.309045 | -71.209517 | 53469 | 8 | 2025-02-26 08:45 | 2025-03-03 | 0 |
| 15730 | 15730 | 27 DUNCKLEE ST | 42.325488 | -71.207982 | 53469 | 6 | 2025-03-04 14:15 | 2025-03-07 | 0 |
| 15877 | 15877 | 36 SELWYN RD | 42.315633 | -71.196984 | 53469 | 6 | 2025-03-07 09:45 | 2025-03-14 | 0 |
| 16091 | 16091 | 85 DUDLEY RD | 42.316713 | -71.186364 | 53469 | 8 | 2025-03-10 09:15 | 2025-03-14 | 0 |
| 16124 | 16124 | 155 WOODLAND ROAD | 42.34248 | -71.245705 | 53469 | 4 | 2025-03-10 12:45 | 2025-03-21 | 0 |
| 16361 | 16361 | 39 BEACONWOOD RD | 42.329817 | -71.210169 | 53469 | 6 | 2025-03-14 12:15 | 2025-03-18 | 0 |
| 16430 | 16430 | 74 CLINTON PL | 42.339582 | -71.193978 | 53469 | 2 | 2025-03-17 09:30 | 2025-03-26 | 0 |
| 16631 | 16631 | 195 WINDSOR RD | 42.332175 | -71.232012 | 53469 | 5 | 2025-03-20 22:00 | 2025-03-21 | 0 |
| 16874 | 16874 | 25 GOULD ROAD | 42.322955 | -71.233812 | 53469 | 5 | 2025-03-26 11:00 | 2025-03-28 | 0 |
| 17172 | 17172 | 1671 BEACON ST | 42.32619 | -71.231999 | 53469 | 5 | 2025-04-01 16:30 | 2025-04-02 | 0 |
| 17443 | 17443 | 85 DUDLEY RD | 42.316713 | -71.186364 | 53469 | 8 | 2025-04-08 07:45 | 2025-04-23 | 0 |
| 17630 | 17630 | 20 WOODCHESTER DR | 42.338862 | -71.178197 | 53469 | 7 | 2025-04-10 09:45 | 2025-04-18 | 0 |
| 17803 | 17803 | 42 ELIOT MEMORIAL RD | 42.344487 | -71.180483 | 53469 | 7 | 2025-04-14 19:45 | 2025-04-24 | 0 |
| 17824 | 17824 | 21 WHITE OAK RD | 42.328125 | -71.244716 | 53469 | 5 | 2025-04-15 09:15 | 2025-04-15 | 0 |
| 17832 | 17832 | 1199 WASHINGTON ST | 42.349383 | -71.222832 | 53469 | 3 | 2025-04-15 11:15 | 2025-05-14 | 0 |
| 17951 | 17951 | 139 HIGHLAND AVE | 42.348609 | -71.213301 | 53469 | 2 | 2025-04-17 09:00 | 2025-04-19 | 0 |
| 17992 | 17992 | 75 HIGHLAND ST | 42.346629 | -71.2265 | 53469 | 3 | 2025-04-17 17:00 | 2025-04-19 | 0 |
| 18095 | 18095 | 1355 BEACON ST | 42.330714 | -71.219263 | 53469 | 5 | 2025-04-22 09:00 | 2025-05-02 | 0 |
| 18665 | 18665 | 132 STANLEY RD | 42.320736 | -71.221347 | 53469 | 5 | 2025-05-01 15:45 | 2025-05-06 | 0 |
| 18677 | 18677 | 291 COUNTRY CLUB RD | 42.302871 | -71.187327 | 53469 | 8 | 2025-05-01 18:00 | 2025-05-02 | 0 |
| 19013 | 19013 | 11 MELVILLE AVE | 42.361956 | -71.207793 | 53469 | 1 | 2025-05-07 16:45 | 2025-05-20 | 0 |
| 19336 | 19336 | 88 WOODCLIFF RD | 42.318918 | -71.201822 | 53469 | 6 | 2025-05-13 19:45 | 2025-05-14 | 0 |
| 19391 | 19391 | 33 WASHINGTON PARK | 42.349506 | -71.202872 | 53469 | 2 | 2025-05-14 13:45 | 2025-05-14 | 0 |
| 19935 | 19935 | 527 COMMONWEALTH AVE | 42.336585 | -71.188308 | 53469 | 7 | 2025-05-23 13:00 | 1 | |
| 20044 | 20044 | 7 GREAT MEADOW RD | 42.31575 | -71.194019 | 53469 | 8 | 2025-05-27 11:45 | 2025-05-28 | 0 |
| 20082 | 20082 | 15 GREAT MEADOW RD | 42.315588 | -71.193843 | 53469 | 8 | 2025-05-27 18:00 | 2025-05-28 | 0 |
| 20102 | 20102 | 101 CARVER RD | 42.321384 | -71.219048 | 53469 | 5 | 2025-05-28 07:15 | 2025-05-30 | 0 |
| 20534 | 20534 | 2265 COMMONWEALTH AVE | 42.347277 | -71.255264 | 53469 | 4 | 2025-06-03 09:00 | 2025-06-09 | 0 |
| 20708 | 20708 | 42 MORRILL ST | 42.36174 | -71.221041 | 53469 | 3 | 2025-06-04 17:15 | 2025-08-05 | 0 |
| 20890 | 20890 | 572 SAW MILL BROOK PKWY | 42.293061 | -71.182485 | 53469 | 8 | 2025-06-07 12:15 | 2025-06-11 | 0 |
| 20997 | 20997 | 67 HANCOCK ST | 42.344028 | -71.25026 | 53469 | 4 | 2025-06-09 15:30 | 2025-06-18 | 0 |
| 21040 | 21040 | 7 HEREWARD RD | 42.323544 | -71.197479 | 53469 | 6 | 2025-06-10 10:00 | 2025-06-16 | 0 |
| 21763 | 21763 | 566 SAW MILL BROOK PKWY | 42.293223 | -71.182305 | 53469 | 8 | 2025-06-20 13:15 | 2025-06-24 | 0 |
| 21907 | 21907 | 21 WHITE OAK RD | 42.328125 | -71.244716 | 53469 | 5 | 2025-06-23 12:00 | 2025-06-25 | 0 |
| 22827 | 22827 | 16 CHAPEL ST | 42.364584 | -71.20193 | 53469 | 1 | 2025-07-08 11:30 | 2025-07-16 | 0 |
| 23092 | 23092 | 39 SKY VIEW CIR | 42.303834 | -71.185815 | 53469 | 8 | 2025-07-11 10:15 | 2025-07-30 | 0 |
| 23814 | 23814 | 71 FAIRLEE RD | 42.323652 | -71.223584 | 53469 | 5 | 2025-07-21 12:30 | 2025-08-05 | 0 |
| 24059 | 24059 | 15 GROVE HILL PARK | 42.340806 | -71.209481 | 53469 | 2 | 2025-07-24 12:45 | 2025-07-25 | 0 |
| 24060 | 24060 | 49 GROVE HILL PARK | 42.339627 | -71.209548 | 53469 | 2 | 2025-07-24 12:45 | 2025-08-05 | 0 |
| 24502 | 24502 | 18 SKY VIEW CIR | 42.304653 | -71.186252 | 53469 | 8 | 2025-08-01 11:30 | 2025-08-05 | 0 |
| 24767 | 24767 | 364 CALIFORNIA ST | 42.364971 | -71.203757 | 53469 | 1 | 2025-08-06 10:30 | 2025-08-12 | 0 |
| 24998 | 24998 | 49 GROVE HILL PARK | 42.339627 | -71.209548 | 53469 | 2 | 2025-08-11 15:30 | 2025-09-03 | 0 |
| 25360 | 25360 | 742 COMMONWEALTH AVE | 42.337053 | -71.197182 | 53469 | 6 | 2025-08-18 14:15 | 2025-08-25 | 0 |
| 25629 | 25629 | 35 WYKEHAM RD | 42.343137 | -71.225244 | 53469 | 3 | 2025-08-22 16:45 | 2025-09-03 | 0 |
| 25824 | 25824 | 42 MORRILL ST | 42.36174 | -71.221041 | 53469 | 3 | 2025-08-28 08:45 | 2025-09-17 | 0 |
| 25860 | 25860 | 36 MORRILL ST | 42.361569 | -71.22083 | 53469 | 3 | 2025-08-28 16:15 | 2025-09-17 | 0 |
| 26513 | 26513 | 13 ADAMS ST | 42.362793 | -71.20629 | 53469 | 1 | 2025-09-11 11:00 | 2025-09-16 | 0 |
| 26844 | 26844 | 65 ANNAWAN RD | 42.323895 | -71.233866 | 53469 | 5 | 2025-09-17 06:30 | 2025-09-17 | 0 |
| 26892 | 26892 | 1105 WALNUT ST | 42.323616 | -71.207375 | 53469 | 6 | 2025-09-17 15:45 | 2025-10-01 | 0 |
| 27481 | 27481 | 1429 CENTRE ST | 42.325839 | -71.198987 | 53469 | 6 | 2025-09-29 16:45 | 2025-10-01 | 0 |
| 28072 | 28072 | 849 BEACON ST | 42.330267 | -71.195877 | 53469 | 6 | 2025-10-11 08:30 | 2025-11-19 | 0 |
| 28409 | 28409 | 73 HARTMAN RD | 42.306813 | -71.188488 | 53469 | 8 | 2025-10-17 13:45 | 2025-10-21 | 0 |
| 28775 | 28775 | 29 EDEN AVE | 42.351138 | -71.224974 | 53469 | 3 | 2025-10-26 11:45 | 2025-11-04 | 0 |
| 28982 | 28982 | 344 LAKE AVENUE | 42.32262 | -71.206488 | 53469 | 6 | 2025-10-29 20:00 | 2025-10-30 | 0 |
| 29389 | 29389 | 817 WALNUT ST | 42.333147 | -71.207892 | 53469 | 6 | 2025-11-05 13:00 | 2025-11-10 | 0 |
| 29448 | 29448 | 791 WALNUT ST | 42.334749 | -71.208873 | 53469 | 2 | 2025-11-06 10:30 | 2025-11-10 | 0 |
| 29843 | 29843 | 466 WOODWARD STREET | 42.32681 | -71.230014 | 53469 | 5 | 2025-11-15 08:45 | 2025-11-17 | 0 |
| 29905 | 29905 | 139 WINCHESTER ST | 42.315219 | -71.209229 | 53469 | 8 | 2025-11-17 08:30 | 2025-11-17 | 0 |
| 30029 | 30029 | 120 OLDE FIELD RD | 42.314976 | -71.191301 | 53469 | 8 | 2025-11-18 17:15 | 2025-11-24 | 0 |
| 30067 | 30067 | 139 WINCHESTER ST | 42.315219 | -71.209229 | 53469 | 8 | 2025-11-19 09:00 | 2025-12-03 | 0 |
| 30283 | 30283 | 35 IRVING ST | 42.337287 | -71.189388 | 53469 | 7 | 2025-11-24 09:45 | 2025-11-24 | 0 |
| 30321 | 30321 | 32 CENTRAL TER | 42.345126 | -71.247411 | 53469 | 4 | 2025-11-24 15:15 | 2025-12-22 | 0 |
| 30484 | 30484 | 466 WOODWARD STREET | 42.326867 | -71.230025 | 53469 | 5 | 2025-11-29 13:45 | 2025-12-01 | 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 );