_locations
1,345 rows where category_id = 51014
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 |
|---|---|---|---|---|---|---|---|---|---|
| 445 | 445 | 65 GRAY CLIFF RD | 42.332911 | -71.187121 | 51014 | 7 | 2024-06-14 | 2024-06-17 | 0 |
| 465 | 465 | 76 CLINTON PL | 42.339581 | -71.193836 | 51014 | 2 | 2024-06-14 | 2024-06-17 | 0 |
| 500 | 500 | 35 ELLISON RD | 42.337367 | -71.206035 | 51014 | 2 | 2024-06-14 | 2024-06-18 | 0 |
| 581 | 581 | 21 MINOT PL | 42.357645 | -71.212678 | 51014 | 2 | 2024-06-17 | 2024-06-21 | 0 |
| 645 | 645 | 35 ELLISON RD | 42.337367 | -71.206035 | 51014 | 2 | 2024-06-18 | 2024-06-18 | 0 |
| 682 | 682 | 16 SULLIVAN AVE | 42.313271 | -71.223697 | 51014 | 5 | 2024-06-18 | 2024-06-20 | 0 |
| 685 | 685 | 20 BUFF CIR | 42.30825 | -71.201054 | 51014 | 8 | 2024-06-18 | 2024-06-20 | 0 |
| 737 | 737 | 20 F ROADWAY | 42.290547 | -71.185347 | 51014 | 8 | 2024-06-19 | 2024-06-21 | 0 |
| 754 | 754 | 566 BEACON ST | 42.331557 | -71.183168 | 51014 | 7 | 2024-06-20 | 2024-06-21 | 0 |
| 781 | 781 | 678 CENTRE ST | 42.348246 | -71.187783 | 51014 | 7 | 2024-06-20 | 2024-06-24 | 0 |
| 784 | 784 | 169 PARK ST | 42.351215 | -71.182254 | 51014 | 7 | 2024-06-20 | 2024-06-21 | 0 |
| 789 | 789 | 20 MAPLE AVE | 42.353802 | -71.18838 | 51014 | 1 | 2024-06-20 | 2024-06-24 | 0 |
| 790 | 790 | 4 HUNNEWELL AVE | 42.354691 | -71.173018 | 51014 | 1 | 2024-06-20 | 2024-06-24 | 0 |
| 793 | 793 | 18 MAPLE AVE | 42.353869 | -71.188366 | 51014 | 1 | 2024-06-20 | 2024-06-24 | 0 |
| 798 | 798 | 136 JEWETT ST | 42.356529 | -71.191398 | 51014 | 1 | 2024-06-20 | 2024-06-25 | 0 |
| 799 | 799 | 4 JANET RD | 42.340609 | -71.19347 | 51014 | 2 | 2024-06-20 | 2024-06-24 | 0 |
| 800 | 800 | 925 CENTRE ST | 42.34063 | -71.192976 | 51014 | 2 | 2024-06-20 | 2024-06-21 | 0 |
| 804 | 804 | 90 BEACON ST | 42.33364 | -71.161786 | 51014 | 7 | 2024-06-20 | 2024-06-21 | 0 |
| 807 | 807 | 9 HOWARD ST | 42.35309 | -71.194191 | 51014 | 1 | 2024-06-20 | 2024-06-24 | 0 |
| 842 | 842 | 1146 CHESTNUT ST | 42.309974 | -71.22354 | 51014 | 5 | 2024-06-21 | 2024-06-24 | 0 |
| 1161 | 1161 | 83 BEMIS ST | 42.36311 | -71.211613 | 51014 | 2 | 2024-06-21 | 2024-06-21 | 0 |
| 1170 | 1170 | 15 WOODSIDE RD | 42.343581 | -71.204481 | 51014 | 2 | 2024-06-21 | 2024-06-24 | 0 |
| 1172 | 1172 | 247 WATERTOWN ST | 42.361857 | -71.196384 | 51014 | 1 | 2024-06-21 | 2024-06-26 | 0 |
| 1175 | 1175 | 37 OLDE FIELD RD | 42.317568 | -71.191984 | 51014 | 8 | 2024-06-21 | 2024-06-24 | 0 |
| 1178 | 1178 | 35 ANTHONY CIR | 42.363616 | -71.215613 | 51014 | 3 | 2024-06-21 | 2024-06-26 | 0 |
| 1180 | 1180 | STEARNS PL | 42.361547 | -71.197357 | 51014 | 1 | 2024-06-21 | 2024-06-25 | 0 |
| 1200 | 1200 | 67 RANDLETT PARK | 42.354578 | -71.219246 | 51014 | 3 | 2024-06-22 | 2024-06-26 | 0 |
| 1206 | 1206 | 67 COMMONWEALTH PARK W | 42.339343 | -71.20407 | 51014 | 2 | 2024-06-22 | 2024-06-27 | 0 |
| 1222 | 1222 | 108 ADAMS ST | 42.360607 | -71.20297 | 51014 | 1 | 2024-06-23 | 2024-06-25 | 0 |
| 1243 | 1243 | 249 WATERTOWN ST | 42.361743 | -71.196781 | 51014 | 1 | 2024-06-23 | 2024-06-26 | 0 |
| 1255 | 1255 | 20 RICKER TER | 42.351173 | -71.174636 | 51014 | 1 | 2024-06-24 | 2024-06-25 | 0 |
| 1267 | 1267 | 1035 CENTRE ST | 42.336817 | -71.193503 | 51014 | 2 | 2024-06-24 | 2024-06-25 | 0 |
| 1268 | 1268 | 115 LOWELL AVE | 42.353365 | -71.209942 | 51014 | 2 | 2024-06-24 | 2024-06-25 | 0 |
| 1269 | 1269 | 18 DUNSTAN ST | 42.350246 | -71.222113 | 51014 | 3 | 2024-06-24 | 2024-06-25 | 0 |
| 1278 | 1278 | 52 BERKSHIRE RD | 42.340957 | -71.202491 | 51014 | 2 | 2024-06-24 | 2024-06-25 | 0 |
| 1298 | 1298 | 35 WALNUT ST | 42.358103 | -71.211562 | 51014 | 2 | 2024-06-24 | 2024-06-27 | 0 |
| 1343 | 1343 | 490 AUBURN ST | 42.344966 | -71.253185 | 51014 | 4 | 2024-06-24 | 2024-06-26 | 0 |
| 1349 | 1349 | 257 WATERTOWN ST | 42.361441 | -71.197258 | 51014 | 1 | 2024-06-24 | 2024-06-26 | 0 |
| 1353 | 1353 | 70 SMITH AVE | 42.356932 | -71.233025 | 51014 | 3 | 2024-06-25 | 2024-06-27 | 0 |
| 1381 | 1381 | 259 CHERRY ST | 42.355499 | -71.22851 | 51014 | 3 | 2024-06-25 | 2024-06-27 | 0 |
| 1391 | 1391 | 115 LOWELL AVE | 42.353365 | -71.209942 | 51014 | 2 | 2024-06-25 | 2024-06-26 | 0 |
| 1507 | 1507 | 59 SELWYN RD | 42.315115 | -71.198234 | 51014 | 8 | 2024-06-26 | 2024-06-28 | 0 |
| 1579 | 1579 | 233 WISWALL RD | 42.292232 | -71.191678 | 51014 | 8 | 2024-06-27 | 2024-06-28 | 0 |
| 1639 | 1639 | 25 LEWIS ST | 42.351954 | -71.196182 | 51014 | 1 | 2024-06-27 15:45 | 2024-06-28 | 0 |
| 1640 | 1640 | 27 WINCHESTER RD | 42.34977 | -71.195202 | 51014 | 1 | 2024-06-27 15:45 | 2024-06-28 | 0 |
| 1647 | 1647 | 17 MAPLE ST | 42.345058 | -71.243979 | 51014 | 4 | 2024-06-27 16:45 | 2024-06-28 | 0 |
| 1649 | 1649 | 15 WOODLAWN DR | 42.34099 | -71.176082 | 51014 | 7 | 2024-06-27 17:00 | 2024-06-28 | 0 |
| 1651 | 1651 | 471 DEDHAM ST | 42.306767 | -71.196398 | 51014 | 8 | 2024-06-27 18:00 | 2024-07-01 | 0 |
| 1662 | 1662 | 9 COOK ST | 42.360644 | -71.198971 | 51014 | 1 | 2024-06-28 09:15 | 2024-07-01 | 0 |
| 1665 | 1665 | 29 HOWARD ST | 42.352484 | -71.193847 | 51014 | 1 | 2024-06-28 09:30 | 2024-07-01 | 0 |
| 1667 | 1667 | 117 ELIOT AVE | 42.35444 | -71.222539 | 51014 | 3 | 2024-06-28 09:45 | 2024-07-01 | 0 |
| 1682 | 1682 | 13 MOUNT IDA TER | 42.351287 | -71.188204 | 51014 | 1 | 2024-06-28 11:30 | 2024-07-01 | 0 |
| 1704 | 1704 | 179 SPIERS RD | 42.291413 | -71.182326 | 51014 | 8 | 2024-06-28 15:30 | 2024-07-02 | 0 |
| 1705 | 1705 | 65 BROADWAY | 42.3592 | -71.208209 | 51014 | 1 | 2024-06-28 15:30 | 2024-07-01 | 0 |
| 1706 | 1706 | 109 DALBY ST | 42.361379 | -71.199618 | 51014 | 1 | 2024-06-28 16:00 | 2024-07-02 | 0 |
| 1713 | 1713 | 14 WYOMING ROAD | 42.363153 | -71.210015 | 51014 | 1 | 2024-06-28 18:30 | 2024-07-01 | 0 |
| 1716 | 1716 | 362 LINWOOD AVE | 42.356524 | -71.21155 | 51014 | 2 | 2024-06-28 19:15 | 2024-07-01 | 0 |
| 1721 | 1721 | 25 THAXTER RD | 42.362938 | -71.209647 | 51014 | 1 | 2024-06-29 08:45 | 2024-07-01 | 0 |
| 1724 | 1724 | 56 WILDWOOD AVE | 42.3546 | -71.215121 | 51014 | 3 | 2024-06-29 10:30 | 2024-07-01 | 0 |
| 1732 | 1732 | 18 FESSENDEN ST | 42.360419 | -71.214803 | 51014 | 2 | 2024-06-30 11:15 | 2024-07-01 | 0 |
| 1761 | 1761 | 41 THAXTER RD | 42.362405 | -71.20985 | 51014 | 1 | 2024-07-01 08:45 | 2024-07-01 | 0 |
| 1769 | 1769 | 17 ROSSMERE ST | 42.355025 | -71.209837 | 51014 | 2 | 2024-07-01 09:30 | 2024-07-01 | 0 |
| 1802 | 1802 | 18 FESSENDEN ST | 42.360349 | -71.214835 | 51014 | 2 | 2024-07-01 16:00 | 2024-07-02 | 0 |
| 1803 | 1803 | 64 DALBY ST | 42.362907 | -71.199893 | 51014 | 1 | 2024-07-01 16:00 | 2024-07-03 | 0 |
| 1829 | 1829 | 79 PRINCE ST | 42.342421 | -71.226266 | 51014 | 3 | 2024-07-02 09:15 | 2024-07-02 | 0 |
| 1856 | 1856 | 6 ANGIER CIR | 42.340351 | -71.238941 | 51014 | 4 | 2024-07-02 12:45 | 2024-07-03 | 0 |
| 1867 | 1867 | 18 WEBSTER ST | 42.35023 | -71.227121 | 51014 | 3 | 2024-07-02 14:15 | 2024-07-03 | 0 |
| 1878 | 1878 | 9 WADE ST | 42.318941 | -71.206888 | 51014 | 5 | 2024-07-02 15:45 | 2024-07-03 | 0 |
| 1947 | 1947 | 73 W PINE ST | 42.352697 | -71.250117 | 51014 | 4 | 2024-07-03 11:45 | 2024-07-08 | 0 |
| 1954 | 1954 | 16 SULLIVAN AVE | 42.313271 | -71.223697 | 51014 | 5 | 2024-07-03 13:30 | 2024-07-05 | 0 |
| 1958 | 1958 | 33 ALEXANDER RD | 42.316066 | -71.199386 | 51014 | 6 | 2024-07-03 14:00 | 2024-07-05 | 0 |
| 1966 | 1966 | 22 WALTER ST | 42.320938 | -71.192891 | 51014 | 6 | 2024-07-03 16:30 | 2024-07-05 | 0 |
| 1999 | 1999 | 164 WARD STREET | 42.338342 | -71.179417 | 51014 | 7 | 2024-07-05 09:00 | 2024-07-05 | 0 |
| 2172 | 2172 | 10 PILLION CT | 42.352141 | -71.197894 | 51014 | 2 | 2024-07-08 15:00 | 2024-07-09 | 0 |
| 2173 | 2173 | 11 PILLION CT | 42.351953 | -71.198042 | 51014 | 2 | 2024-07-08 15:00 | 2024-07-08 | 0 |
| 2198 | 2198 | 84 RIVER STREET | 42.352207 | -71.230068 | 51014 | 3 | 2024-07-08 17:15 | 2024-07-08 | 0 |
| 2229 | 2229 | 216 VALENTINE ST | 42.338925 | -71.214708 | 51014 | 2 | 2024-07-09 10:00 | 2024-07-09 | 0 |
| 2240 | 2240 | 50 WALNUT PL | 42.318494 | -71.204393 | 51014 | 5 | 2024-07-09 11:00 | 2024-07-10 | 0 |
| 2252 | 2252 | 62 BROADWAY | 42.358781 | -71.208509 | 51014 | 1 | 2024-07-09 14:00 | 2024-07-10 | 0 |
| 2280 | 2280 | 140 DUDLEY RD | 42.315794 | -71.18351 | 51014 | 8 | 2024-07-09 19:00 | 2024-07-11 | 0 |
| 2305 | 2305 | 28 OLDE FIELD RD | 42.317983 | -71.191561 | 51014 | 8 | 2024-07-10 09:15 | 2024-07-11 | 0 |
| 2345 | 2345 | 73 ROUNDWOOD RD | 42.316949 | -71.217552 | 51014 | 5 | 2024-07-10 15:00 | 2024-07-11 | 0 |
| 2355 | 2355 | 60 AMHERST RD | 42.320417 | -71.225794 | 51014 | 5 | 2024-07-10 16:30 | 2024-07-11 | 0 |
| 2373 | 2373 | 69 OLDE FIELD RD | 42.316493 | -71.191711 | 51014 | 8 | 2024-07-11 08:45 | 2024-07-11 | 0 |
| 2420 | 2420 | 742 CENTRE ST | 42.346297 | -71.188616 | 51014 | 7 | 2024-07-11 14:45 | 2024-07-15 | 0 |
| 2468 | 2468 | 50 WILDWOOD AVE | 42.354797 | -71.215247 | 51014 | 3 | 2024-07-12 10:30 | 2024-07-15 | 0 |
| 2473 | 2473 | 8 ROCKLAND ST | 42.359845 | -71.190985 | 51014 | 1 | 2024-07-12 11:00 | 2024-07-16 | 0 |
| 2481 | 2481 | 31 FOX HILL RD | 42.308856 | -71.192592 | 51014 | 8 | 2024-07-12 11:45 | 2024-07-16 | 0 |
| 2500 | 2500 | 108 CHAPEL ST | 42.361691 | -71.200316 | 51014 | 1 | 2024-07-12 16:15 | 2024-07-16 | 0 |
| 2501 | 2501 | 11 WISWALL ST | 42.350894 | -71.2181 | 51014 | 3 | 2024-07-12 16:15 | 2024-07-16 | 0 |
| 2507 | 2507 | 27 WABAN STREET | 42.35759 | -71.190322 | 51014 | 1 | 2024-07-12 17:30 | 2024-07-16 | 0 |
| 2559 | 2559 | 17 WISWALL ST | 42.350815 | -71.218333 | 51014 | 3 | 2024-07-15 12:15 | 2024-07-22 | 0 |
| 2566 | 2566 | 651 WATERTOWN ST | 42.355106 | -71.21182 | 51014 | 2 | 2024-07-15 13:00 | 2024-07-18 | 0 |
| 2628 | 2628 | 90 BERKELEY ST | 42.340955 | -71.227654 | 51014 | 3 | 2024-07-16 10:45 | 2024-07-22 | 0 |
| 2660 | 2660 | 33 COLLINS RD | 42.325 | -71.231326 | 51014 | 5 | 2024-07-16 15:45 | 2024-07-18 | 0 |
| 2661 | 2661 | 356 WOODWARD ST | 42.325528 | -71.225501 | 51014 | 5 | 2024-07-16 15:45 | 2024-07-18 | 0 |
| 2669 | 2669 | 12 NANTUCKET RD | 42.322538 | -71.214277 | 51014 | 5 | 2024-07-16 17:15 | 2024-07-18 | 0 |
| 2670 | 2670 | 141 WOOD END RD | 42.322045 | -71.214679 | 51014 | 5 | 2024-07-16 17:15 | 2024-07-18 | 0 |
| 2674 | 2674 | 1 BOWDOIN ST | 42.323882 | -71.211551 | 51014 | 6 | 2024-07-16 17:45 | 2024-07-18 | 0 |
| 2682 | 2682 | 4 RIDGEWAY TER | 42.319621 | -71.219353 | 51014 | 5 | 2024-07-17 06:00 | 2024-07-18 | 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 );