_locations
143 rows where category_id = 53459
This data as json, CSV (advanced)
Suggested facets: ward, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 1467 | 1467 | 99 MOULTON ST | 42.329325 | -71.256105 | 53459 | 4 | 2024-06-26 | 2024-06-26 | 0 |
| 1473 | 1473 | 1220 CHESTNUT STREET | 42.309635 | -71.220723 | 53459 | 5 | 2024-06-26 | 2024-06-26 | 0 |
| 1576 | 1576 | 268 LEXINGTON ST | 42.352744 | -71.245199 | 53459 | 4 | 2024-06-27 | 2024-07-11 | 0 |
| 1614 | 1614 | 1686 BEACON ST | 42.325696 | -71.232694 | 53459 | 5 | 2024-06-27 12:30 | 2024-07-01 | 0 |
| 2873 | 2873 | 574 AUBURN ST | 42.343874 | -71.257261 | 53459 | 4 | 2024-07-19 15:00 | 2024-07-22 | 0 |
| 3168 | 3168 | 73 CARVER RD | 42.321935 | -71.218201 | 53459 | 5 | 2024-07-26 09:00 | 2024-07-30 | 0 |
| 3217 | 3217 | 254 ALBEMARLE ROAD | 42.356833 | -71.216002 | 53459 | 3 | 2024-07-28 15:45 | 2024-07-30 | 0 |
| 3458 | 3458 | 35 WABAN STREET | 42.357347 | -71.190527 | 53459 | 1 | 2024-07-31 18:00 | 2024-08-06 | 0 |
| 4198 | 4198 | 942 WATERTOWN ST | 42.350228 | -71.223666 | 53459 | 3 | 2024-08-12 12:15 | 2024-08-13 | 0 |
| 4400 | 4400 | 49 JANET RD | 42.340308 | -71.195153 | 53459 | 2 | 2024-08-15 10:00 | 2024-08-20 | 0 |
| 4927 | 4927 | 76 CHESTNUT ST | 42.34755 | -71.224571 | 53459 | 2 | 2024-08-26 14:45 | 2024-08-26 | 0 |
| 5529 | 5529 | 200–224 ALBEMARLE RD | 42.359394 | -71.216811 | 53459 | 2 | 2024-09-09 14:15 | 2024-09-11 | 0 |
| 5611 | 5611 | 11 OWAISA RD | 42.327051 | -71.238975 | 53459 | 5 | 2024-09-10 12:15 | 2024-09-11 | 0 |
| 5753 | 5753 | 136 HYDE ST | 42.322122 | -71.202875 | 53459 | 6 | 2024-09-12 15:45 | 2024-09-16 | 0 |
| 5894 | 5894 | 1298 COMMONWEALTH AVENUE | 42.337099 | -71.220109 | 53459 | 3 | 2024-09-16 10:00 | 2024-09-17 | 0 |
| 5909 | 5909 | 34 ROWE ST | 42.349034 | -71.240613 | 53459 | 4 | 2024-09-16 12:15 | 2024-09-16 | 0 |
| 6187 | 6187 | 1119 WALNUT STREET | 42.323098 | -71.207698 | 53459 | 6 | 2024-09-23 17:45 | 2024-10-01 | 0 |
| 6188 | 6188 | 162 DEDHAM STREET | 42.314276 | -71.202291 | 53459 | 8 | 2024-09-23 17:45 | 2024-09-25 | 0 |
| 6189 | 6189 | 166–176 LION DR | 42.312769 | -71.184288 | 53459 | 8 | 2024-09-23 17:45 | 2024-09-25 | 0 |
| 6190 | 6190 | 49 CRAFTS ST | 42.354969 | -71.200986 | 53459 | 1 | 2024-09-23 17:45 | 2024-09-25 | 0 |
| 6427 | 6427 | 40 FULLER ST | 42.336045 | -71.221059 | 53459 | 5 | 2024-09-26 09:15 | 2024-09-30 | 0 |
| 8591 | 8591 | 31 AUBURN ST | 42.345019 | -71.23607 | 53459 | 3 | 2024-10-28 17:30 | 2024-10-30 | 0 |
| 8938 | 8938 | 16 PHILLIPS ST | 42.346302 | -71.255875 | 53459 | 4 | 2024-10-30 13:45 | 2024-11-01 | 0 |
| 10134 | 10134 | 90 WASHBURN AVENUE | 42.351426 | -71.243833 | 53459 | 4 | 2024-11-14 08:30 | 2024-11-19 | 0 |
| 10194 | 10194 | 72 HIGH STREET | 42.31478 | -71.223754 | 53459 | 5 | 2024-11-15 14:15 | 2024-11-19 | 0 |
| 10254 | 10254 | 121 CEDRIC ROAD | 42.322518 | -71.196095 | 53459 | 6 | 2024-11-18 11:15 | 2024-11-21 | 0 |
| 10287 | 10287 | 56 HANSON RD | 42.292916 | -71.186513 | 53459 | 8 | 2024-11-18 15:30 | 2024-11-21 | 0 |
| 10445 | 10445 | 227 WALNUT ST | 42.352556 | -71.207956 | 53459 | 2 | 2024-11-21 13:00 | 2024-11-22 | 0 |
| 10644 | 10644 | 6 BRENTWOOD AVE | 42.331925 | -71.204959 | 53459 | 6 | 2024-11-25 14:30 | 2024-11-26 | 0 |
| 10726 | 10726 | 187 CHERRY ST | 42.357882 | -71.227599 | 53459 | 3 | 2024-11-26 16:45 | 2024-11-27 | 0 |
| 10768 | 10768 | 187 CHERRY ST | 42.357882 | -71.227599 | 53459 | 3 | 2024-11-27 14:30 | 2024-12-04 | 0 |
| 10812 | 10812 | AUBURN ST | 42.346313 | -71.248655 | 53459 | 4 | 2024-12-01 06:45 | 2024-12-03 | 0 |
| 11560 | 11560 | 21 WINCHESTER RD | 42.349674 | -71.194974 | 53459 | 1 | 2024-12-12 09:45 | 2024-12-17 | 0 |
| 11569 | 11569 | 405 LANGLEY RD | 42.320109 | -71.183748 | 53459 | 6 | 2024-12-12 10:00 | 2024-12-16 | 0 |
| 11661 | 11661 | 78 PLAINFIELD STREET | 42.326461 | -71.222375 | 53459 | 5 | 2024-12-13 16:45 | 2024-12-27 | 0 |
| 11925 | 11925 | 240 CALIFORNIA ST | 42.364647 | -71.198072 | 53459 | 1 | 2024-12-20 09:00 | 2024-12-24 | 0 |
| 11955 | 11955 | 67 ROOSEVELT RD | 42.313657 | -71.192815 | 53459 | 8 | 2024-12-20 16:00 | 2024-12-24 | 0 |
| 11960 | 11960 | 53 BRANDEIS RD | 42.313442 | -71.192357 | 53459 | 8 | 2024-12-20 16:15 | 2024-12-23 | 0 |
| 12185 | 12185 | 151 VALENTINE ST | 42.339924 | -71.21738 | 53459 | 2 | 2024-12-24 09:00 | 2024-12-26 | 0 |
| 12186 | 12186 | 75 SUMMIT ST | 42.352326 | -71.192338 | 53459 | 1 | 2024-12-24 09:00 | 2024-12-26 | 0 |
| 12362 | 12362 | 21 THORNTON ST | 42.357578 | -71.189123 | 53459 | 1 | 2024-12-30 12:30 | 2025-01-02 | 0 |
| 12383 | 12383 | 1 WABAN ST | 42.357761 | -71.189094 | 53459 | 1 | 2024-12-30 15:45 | 2025-01-02 | 0 |
| 12883 | 12883 | 5 GRAYSON LN | 42.327974 | -71.262866 | 53459 | 4 | 2025-01-08 12:00 | 2025-01-17 | 0 |
| 13014 | 13014 | 6 AGAWAM ROAD | 42.3293 | -71.246644 | 53459 | 5 | 2025-01-10 16:30 | 2025-01-14 | 0 |
| 13018 | 13018 | 2004 BEACON ST | 42.329646 | -71.246552 | 53459 | 5 | 2025-01-11 07:30 | 2025-01-14 | 0 |
| 13021 | 13021 | 6 HAGEN RD | 42.316346 | -71.194703 | 53459 | 8 | 2025-01-11 11:30 | 2025-01-13 | 0 |
| 13039 | 13039 | 5 HAGEN RD | 42.315991 | -71.1948 | 53459 | 8 | 2025-01-13 08:30 | 2025-01-13 | 0 |
| 13045 | 13045 | 6 AGAWAM RD | 42.32938 | -71.246498 | 53459 | 5 | 2025-01-13 09:00 | 2025-01-13 | 0 |
| 13065 | 13065 | 85 CHARLESBANK RD | 42.358825 | -71.179978 | 53459 | 1 | 2025-01-13 10:15 | 2025-01-13 | 0 |
| 13080 | 13080 | 84 FAIRMONT AVE | 42.350039 | -71.191302 | 53459 | 1 | 2025-01-13 13:00 | 2025-01-23 | 0 |
| 13096 | 13096 | 2–78 GRANT AVE | 42.33933 | -71.183816 | 53459 | 7 | 2025-01-13 17:15 | 2025-01-14 | 0 |
| 13303 | 13303 | 36 GREEN ST | 42.358932 | -71.197016 | 53459 | 1 | 2025-01-17 14:00 | 2025-01-21 | 0 |
| 13312 | 13312 | 25 GREEN ST | 42.359346 | -71.196858 | 53459 | 1 | 2025-01-17 17:00 | 2025-01-21 | 0 |
| 13364 | 13364 | 237 FRANKLIN ST | 42.350009 | -71.181761 | 53459 | 7 | 2025-01-20 21:30 | 2025-01-21 | 0 |
| 13366 | 13366 | 10 NONANTUM STREET | 42.35018 | -71.175443 | 53459 | 1 | 2025-01-20 22:30 | 2025-01-21 | 0 |
| 13397 | 13397 | 45 OLD COLONY RD | 42.335586 | -71.173508 | 53459 | 7 | 2025-01-21 09:45 | 2025-01-23 | 0 |
| 13468 | 13468 | 2282 COMMONWEALTH AVE | 42.346494 | -71.255277 | 53459 | 4 | 2025-01-22 07:30 | 2025-01-23 | 0 |
| 13814 | 13814 | 268 PRINCE ST | 42.338637 | -71.220938 | 53459 | 3 | 2025-01-28 13:15 | 2025-01-31 | 0 |
| 13835 | 13835 | 191 MILL STREET | 42.341815 | -71.200735 | 53459 | 2 | 2025-01-28 16:00 | 2025-02-05 | 0 |
| 13912 | 13912 | 255 NEWTONVILLE AVE | 42.352839 | -71.197322 | 53459 | 2 | 2025-01-30 10:30 | 2025-01-31 | 0 |
| 14116 | 14116 | 14 SAINT JAMES TERRACE | 42.35939 | -71.179952 | 53459 | 1 | 2025-02-04 07:45 | 2025-02-05 | 0 |
| 14157 | 14157 | 2105 COMMONWEALTH AVE | 42.348243 | -71.247306 | 53459 | 4 | 2025-02-04 11:00 | 2025-02-05 | 0 |
| 14307 | 14307 | 248 HOMER STREET | 42.335297 | -71.204308 | 53459 | 6 | 2025-02-07 14:45 | 2025-02-12 | 0 |
| 14323 | 14323 | 2–98 HUNNEWELL CIR | 42.355716 | -71.179139 | 53459 | 1 | 2025-02-08 08:00 | 2025-02-08 | 0 |
| 14343 | 14343 | 2 CHARLES ST | 42.344613 | -71.255088 | 53459 | 4 | 2025-02-08 20:45 | 2025-02-12 | 0 |
| 14375 | 14375 | 80 HANCOCK ST | 42.34366 | -71.250125 | 53459 | 4 | 2025-02-09 17:15 | 2025-02-12 | 0 |
| 14672 | 14672 | 124 MCCARTHY RD | 42.295788 | -71.186832 | 53459 | 8 | 2025-02-14 13:00 | 2025-02-20 | 0 |
| 14696 | 14696 | 130 WHEELER RD | 42.310017 | -71.191786 | 53459 | 8 | 2025-02-14 17:15 | 2025-02-26 | 0 |
| 14920 | 14920 | 9 ELDREDGE ST | 42.355503 | -71.18343 | 53459 | 1 | 2025-02-18 10:15 | 2025-02-21 | 0 |
| 14940 | 14940 | 47 TERRACE AVE | 42.324228 | -71.210822 | 53459 | 6 | 2025-02-18 11:00 | 2025-02-24 | 0 |
| 15458 | 15458 | 15 WALSINGHAM ST | 42.330942 | -71.248613 | 53459 | 4 | 2025-02-26 08:45 | 2025-02-26 | 0 |
| 15565 | 15565 | 78 PLAINFIELD ST | 42.326622 | -71.222652 | 53459 | 5 | 2025-02-27 14:30 | 2025-03-03 | 0 |
| 15699 | 15699 | 40 WOODCHESTER DR | 42.339402 | -71.177927 | 53459 | 7 | 2025-03-04 09:00 | 2025-03-05 | 0 |
| 15818 | 15818 | 904 CENTRE ST | 42.341256 | -71.192075 | 53459 | 7 | 2025-03-06 10:00 | 2025-03-10 | 0 |
| 15854 | 15854 | 213 CALIFORNIA STREET | 42.364904 | -71.196518 | 53459 | 1 | 2025-03-07 01:15 | 2025-03-10 | 0 |
| 15855 | 15855 | 221 JACKSON STREET | 42.318798 | -71.194308 | 53459 | 8 | 2025-03-07 01:15 | 2025-03-10 | 0 |
| 15856 | 15856 | 3 CHARLESBANK ROAD | 42.35834 | -71.174868 | 53459 | 1 | 2025-03-07 01:15 | 2025-03-10 | 0 |
| 15857 | 15857 | 88 SAINT JAMES STREET | 42.35872 | -71.180232 | 53459 | 1 | 2025-03-07 01:15 | 2025-03-10 | 0 |
| 15952 | 15952 | 153 WESTCHESTER ROAD | 42.344813 | -71.194158 | 53459 | 2 | 2025-03-07 16:00 | 2025-03-11 | 0 |
| 16112 | 16112 | 6 SPAULDING LN | 42.302628 | -71.176284 | 53459 | 8 | 2025-03-10 11:30 | 2025-03-11 | 0 |
| 16121 | 16121 | 214 CONCORD ST | 42.327252 | -71.259197 | 53459 | 4 | 2025-03-10 12:30 | 2025-03-11 | 0 |
| 16336 | 16336 | 256 PARKER STREET | 42.318675 | -71.194351 | 53459 | 8 | 2025-03-13 21:45 | 2025-03-17 | 0 |
| 16337 | 16337 | 281 NEEDHAM STREET | 42.308581 | -71.215433 | 53459 | 5 | 2025-03-13 21:45 | 2025-03-17 | 0 |
| 16338 | 16338 | 40 NEEDHAM STREET | 42.315821 | -71.210026 | 53459 | 8 | 2025-03-13 21:45 | 2025-03-24 | 0 |
| 16398 | 16398 | 79 WHEELER RD | 42.310125 | -71.193915 | 53459 | 8 | 2025-03-15 18:00 | 2025-03-17 | 0 |
| 16503 | 16503 | 28 AUSTIN ST | 42.350346 | -71.208243 | 53459 | 2 | 2025-03-18 12:00 | 2025-03-18 | 0 |
| 16789 | 16789 | 40 NEEDHAM ST | 42.315759 | -71.209782 | 53459 | 8 | 2025-03-25 14:45 | 2025-03-26 | 0 |
| 17199 | 17199 | 321 WALTHAM ST | 42.356133 | -71.223777 | 53459 | 3 | 2025-04-02 09:15 | 2025-04-02 | 0 |
| 17454 | 17454 | 475 WASHINGTON ST | 42.35562 | -71.192408 | 53459 | 1 | 2025-04-08 09:15 | 2025-04-09 | 0 |
| 17571 | 17571 | 96 MONADNOCK RD | 42.334335 | -71.177684 | 53459 | 7 | 2025-04-09 09:00 | 2025-04-09 | 0 |
| 17768 | 17768 | 2 BRYON RD | 42.302691 | -71.167352 | 53459 | 8 | 2025-04-14 12:30 | 2025-04-14 | 0 |
| 17827 | 17827 | 8 VARICK RD | 42.328953 | -71.245233 | 53459 | 5 | 2025-04-15 10:00 | 2025-04-23 | 0 |
| 17962 | 17962 | 560 PARKER ST | 42.308532 | -71.197812 | 53459 | 8 | 2025-04-17 11:30 | 2025-04-25 | 0 |
| 18054 | 18054 | 285 ELLIOT ST | 42.312867 | -71.221252 | 53459 | 5 | 2025-04-20 15:45 | 2025-04-23 | 0 |
| 18087 | 18087 | 65 OAK ST | 42.310449 | -71.220919 | 53459 | 5 | 2025-04-22 08:45 | 2025-04-25 | 0 |
| 18102 | 18102 | 377 LOWELL AVE | 42.344414 | -71.211429 | 53459 | 2 | 2025-04-22 09:45 | 2025-04-23 | 0 |
| 18880 | 18880 | 9 WADE STREET | 42.319068 | -71.207226 | 53459 | 5 | 2025-05-06 09:30 | 2025-05-08 | 0 |
| 19018 | 19018 | 120 EDINBORO STREET | 42.355398 | -71.212622 | 53459 | 2 | 2025-05-07 18:45 | 2025-05-12 | 0 |
| 19134 | 19134 | 55 INDIAN RIDGE RD | 42.296184 | -71.183039 | 53459 | 8 | 2025-05-09 14:00 | 2025-05-12 | 0 |
| 19158 | 19158 | 257 NEWTONVILLE AVE | 42.352812 | -71.197425 | 53459 | 2 | 2025-05-10 12:15 | 2025-05-12 | 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 );