_locations
46 rows where category_id = 51147
This data as json, CSV (advanced)
Suggested facets: ward, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 1825 | 1825 | 1224 BOYLSTON ST | 42.317209 | -71.222856 | 51147 | 5 | 2024-07-02 08:45 | 2024-07-02 | 0 |
| 2294 | 2294 | 963 WATERTOWN STREET | 42.35011 | -71.2248 | 51147 | 3 | 2024-07-10 07:45 | 2024-07-16 | 0 |
| 2801 | 2801 | 11 ELM ST | 42.352085 | -71.231104 | 51147 | 3 | 2024-07-18 12:30 | 2024-07-18 | 0 |
| 3174 | 3174 | 1330 CENTRE STREET | 42.328476 | -71.196046 | 51147 | 6 | 2024-07-26 10:30 | 2024-07-30 | 0 |
| 3185 | 3185 | 28 WADE ST | 42.318685 | -71.206088 | 51147 | 5 | 2024-07-26 12:45 | 2024-08-06 | 0 |
| 4440 | 4440 | 86 PAGE ROAD | 42.354407 | -71.211947 | 51147 | 2 | 2024-08-15 17:00 | 2024-08-20 | 0 |
| 4542 | 4542 | 100 NEEDHAM STREET | 42.314046 | -71.21134 | 51147 | 8 | 2024-08-17 09:15 | 2024-08-20 | 0 |
| 5584 | 5584 | 56 BARNSTABLE RD | 42.339766 | -71.221838 | 51147 | 3 | 2024-09-10 09:45 | 2024-09-23 | 0 |
| 9048 | 9048 | 10 JOHN ST | 42.319673 | -71.182079 | 51147 | 6 | 2024-10-31 09:30 | 2024-11-08 | 0 |
| 9721 | 9721 | 137 WAVERLEY AVE | 42.351062 | -71.180191 | 51147 | 1 | 2024-11-06 08:45 | 2024-11-06 | 0 |
| 9745 | 9745 | 187 WOODCLIFF RD | 42.315961 | -71.20121 | 51147 | 5 | 2024-11-06 15:15 | 2024-11-07 | 0 |
| 10105 | 10105 | 105 CARLTON RD | 42.324904 | -71.241886 | 51147 | 5 | 2024-11-13 11:30 | 2024-11-20 | 0 |
| 10255 | 10255 | 104 COLUMBIA AVE | 42.313583 | -71.210076 | 51147 | 8 | 2024-11-18 11:15 | 2024-12-02 | 0 |
| 10256 | 10256 | 71 HEATHERLAND RD | 42.313662 | -71.208626 | 51147 | 8 | 2024-11-18 11:15 | 2024-11-21 | 0 |
| 10257 | 10257 | COLUMBIA AVE | 42.313956 | -71.210941 | 51147 | 8 | 2024-11-18 11:15 | 2024-11-26 | 0 |
| 10357 | 10357 | 183 WINCHESTER STREET | 42.313594 | -71.209243 | 51147 | 8 | 2024-11-20 09:15 | 2024-11-20 | 0 |
| 12643 | 12643 | 320 NEEDHAM STREET | 42.306969 | -71.216565 | 51147 | 8 | 2025-01-06 01:00 | 2025-01-06 | 0 |
| 12982 | 12982 | 3 POND AVE | 42.360294 | -71.191921 | 51147 | 1 | 2025-01-10 10:45 | 2025-01-17 | 0 |
| 15286 | 15286 | 416 GROVE ST | 42.333867 | -71.2535 | 51147 | 4 | 2025-02-23 18:00 | 2025-02-27 | 0 |
| 15676 | 15676 | 33 ASPEN AVE | 42.339447 | -71.247002 | 51147 | 4 | 2025-03-03 13:00 | 2025-03-06 | 0 |
| 17688 | 17688 | 1000 COMMONWEALTH AVE | 42.337377 | -71.208617 | 51147 | 2 | 2025-04-11 10:00 | 2025-04-16 | 0 |
| 18458 | 18458 | 195 SUMNER ST | 42.331302 | -71.192417 | 51147 | 6 | 2025-04-28 15:15 | 2025-04-29 | 0 |
| 18683 | 18683 | 119 B CHARLESBANK ROAD | 42.35897 | -71.18153 | 51147 | 1 | 2025-05-01 22:45 | 2025-05-09 | 0 |
| 19594 | 19594 | 37 COMMONWEALTH AVE | 42.339924 | -71.16831 | 51147 | 7 | 2025-05-19 10:30 | 2025-05-19 | 0 |
| 20609 | 20609 | 48 RUTHVEN ROAD | 42.348089 | -71.183005 | 51147 | 7 | 2025-06-04 00:00 | 2025-06-04 | 0 |
| 20839 | 20839 | 474 WOODWARD STREET | 42.32651 | -71.230364 | 51147 | 5 | 2025-06-06 11:45 | 2025-06-09 | 0 |
| 23834 | 23834 | 320 DUDLEY ROAD | 42.310642 | -71.181412 | 51147 | 8 | 2025-07-21 14:30 | 2025-07-23 | 0 |
| 25474 | 25474 | 56 ACACIA AVE | 42.331761 | -71.167568 | 51147 | 7 | 2025-08-20 12:00 | 2025-08-21 | 0 |
| 25478 | 25478 | 1395 COMMONWEALTH AVE | 42.337332 | -71.224038 | 51147 | 3 | 2025-08-20 12:15 | 2025-08-25 | 0 |
| 25479 | 25479 | 40 BRISTOL RD | 42.337242 | -71.222018 | 51147 | 3 | 2025-08-20 12:15 | 2025-08-25 | 0 |
| 25483 | 25483 | 12 GREEN ST | 42.359346 | -71.195994 | 51147 | 1 | 2025-08-20 12:30 | 2025-08-21 | 0 |
| 25841 | 25841 | 15 MORSELAND AVE | 42.33996 | -71.197506 | 51147 | 2 | 2025-08-28 10:45 | 2025-09-03 | 0 |
| 27336 | 27336 | 28 KINGMAN RD | 42.3279 | -71.207474 | 51147 | 6 | 2025-09-26 10:45 | 2025-09-29 | 0 |
| 27588 | 27588 | 131 HARVARD ST | 42.348006 | -71.201228 | 51147 | 2 | 2025-10-01 08:45 | 2025-10-01 | 0 |
| 28052 | 28052 | 77 HEATHERLAND RD | 42.313725 | -71.208819 | 51147 | 8 | 2025-10-10 13:45 | 2025-10-14 | 0 |
| 28294 | 28294 | 2360 COMMONWEALTH AVENUE | 42.34532 | -71.258231 | 51147 | 4 | 2025-10-15 19:45 | 2025-10-16 | 0 |
| 28420 | 28420 | 124 HAGEN ROAD | 42.317267 | -71.190088 | 51147 | 8 | 2025-10-17 16:30 | 2025-10-21 | 0 |
| 28704 | 28704 | 1295 CENTRE ST | 42.329637 | -71.195346 | 51147 | 6 | 2025-10-23 20:00 | 2025-10-24 | 0 |
| 28744 | 28744 | 3 EXMOOR ROAD | 42.340277 | -71.185146 | 51147 | 7 | 2025-10-24 14:45 | 2025-10-31 | 0 |
| 29240 | 29240 | 1300 WALNUT ST | 42.318099 | -71.202893 | 51147 | 5 | 2025-11-03 13:15 | 2025-11-03 | 0 |
| 29250 | 29250 | 1300 WALNUT ST | 42.318099 | -71.202893 | 51147 | 5 | 2025-11-03 15:15 | 2025-11-04 | 0 |
| 29381 | 29381 | 20 WADE ST | 42.318864 | -71.206317 | 51147 | 5 | 2025-11-05 11:45 | 2025-11-10 | 0 |
| 29618 | 29618 | 2345 COMMONWEALTH AVE | 42.346017 | -71.258238 | 51147 | 4 | 2025-11-10 12:00 | 2025-11-12 | 0 |
| 30465 | 30465 | 23 OTIS ST | 42.348087 | -71.20787 | 51147 | 2 | 2025-11-28 10:00 | 2025-12-01 | 0 |
| 30744 | 30744 | 216 WOODCLIFF RD | 42.315048 | -71.200953 | 51147 | 6 | 2025-12-04 08:45 | 2025-12-04 | 0 |
| 31127 | 31127 | 5 MORSELAND AVE | 42.340194 | -71.197475 | 51147 | 2 | 2025-12-12 13:00 | 2025-12-16 | 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 );