_locations
138 rows where category_id = 51043
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 |
|---|---|---|---|---|---|---|---|---|---|
| 1111 | 1111 | 465–499 WARD ST | 42.338116 | -71.193027 | 51043 | 2 | 2024-06-21 | 0 | |
| 1256 | 1256 | 69 MIDDLESEX RD | 42.326475 | -71.162274 | 51043 | 7 | 2024-06-24 | 2024-06-25 | 0 |
| 2508 | 2508 | 200–224 ALBEMARLE RD | 42.359698 | -71.216708 | 51043 | 2 | 2024-07-12 17:30 | 2024-07-15 | 0 |
| 2524 | 2524 | NEVADA ST | 42.361558 | -71.20955 | 51043 | 1 | 2024-07-13 22:30 | 2024-07-16 | 0 |
| 2525 | 2525 | 842 CHESTNUT ST | 42.320707 | -71.226269 | 51043 | 5 | 2024-07-14 11:15 | 2024-07-15 | 0 |
| 4520 | 4520 | WOODLAND ROAD | 42.345977 | -71.246394 | 51043 | 4 | 2024-08-16 13:45 | 2024-08-19 | 0 |
| 4873 | 4873 | 1887 COMMONWEALTH AVE | 42.344513 | -71.240683 | 51043 | 4 | 2024-08-24 07:30 | 2024-08-26 | 0 |
| 4979 | 4979 | 1004 CENTRE STREET | 42.338088 | -71.192656 | 51043 | 7 | 2024-08-27 09:30 | 2024-08-28 | 0 |
| 6825 | 6825 | 99 JACKSON RD | 42.359659 | -71.194856 | 51043 | 1 | 2024-10-08 09:00 | 2024-10-08 | 0 |
| 6903 | 6903 | 1483 CENTRE ST | 42.324347 | -71.200211 | 51043 | 6 | 2024-10-09 10:30 | 2024-10-10 | 0 |
| 8201 | 8201 | 1320 CENTRE ST | 42.32855 | -71.195458 | 51043 | 6 | 2024-10-23 17:30 | 2024-10-28 | 0 |
| 8705 | 8705 | 2 LOWELL AVE | 42.356496 | -71.206822 | 51043 | 2 | 2024-10-29 13:45 | 2024-10-30 | 0 |
| 9018 | 9018 | 78 LANGLEY RD | 42.330119 | -71.191305 | 51043 | 6 | 2024-10-30 16:45 | 2024-10-31 | 0 |
| 9838 | 9838 | 711 BEACON ST | 42.331071 | -71.189887 | 51043 | 6 | 2024-11-07 13:00 | 2024-11-08 | 0 |
| 10276 | 10276 | 1065 WALNUT ST | 42.32498 | -71.207048 | 51043 | 6 | 2024-11-18 13:45 | 2024-11-19 | 0 |
| 10296 | 10296 | 1320 CENTRE STREET | 42.328539 | -71.19536 | 51043 | 6 | 2024-11-18 18:30 | 2024-11-19 | 0 |
| 10470 | 10470 | 91 ALLERTON RD | 42.324431 | -71.199659 | 51043 | 6 | 2024-11-22 09:30 | 2024-11-26 | 0 |
| 10515 | 10515 | 1471 CENTRE ST | 42.324649 | -71.200218 | 51043 | 6 | 2024-11-22 15:00 | 2024-11-26 | 0 |
| 10728 | 10728 | 69 TAMWORTH RD | 42.320506 | -71.226463 | 51043 | 5 | 2024-11-26 18:30 | 2024-11-27 | 0 |
| 10953 | 10953 | 603 COMMONWEALTH AVE | 42.336478 | -71.191789 | 51043 | 7 | 2024-12-03 12:15 | 2024-12-04 | 0 |
| 11042 | 11042 | 1314 CENTRE ST | 42.3287 | -71.195366 | 51043 | 6 | 2024-12-04 13:30 | 2024-12-06 | 0 |
| 12602 | 12602 | 125 LINCOLN ST | 42.32117 | -71.211611 | 51043 | 6 | 2025-01-03 13:15 | 2025-01-03 | 0 |
| 12969 | 12969 | 1404 CENTRE STREET | 42.326366 | -71.19802 | 51043 | 6 | 2025-01-10 09:00 | 2025-01-13 | 0 |
| 13048 | 13048 | 90 LINCOLN ST | 42.320988 | -71.209663 | 51043 | 6 | 2025-01-13 09:15 | 2025-01-13 | 0 |
| 13206 | 13206 | 414 WATERTOWN STREET | 42.35982 | -71.202328 | 51043 | 1 | 2025-01-15 18:15 | 2025-01-17 | 0 |
| 13248 | 13248 | 1574 CENTRE ST | 42.321817 | -71.202764 | 51043 | 6 | 2025-01-16 14:00 | 2025-01-22 | 0 |
| 13270 | 13270 | 447 CENTRE STREET | 42.355081 | -71.186326 | 51043 | 1 | 2025-01-16 23:45 | 2025-01-23 | 0 |
| 13755 | 13755 | 92 WALNUT STREET | 42.32355 | -71.253027 | 51043 | 2025-01-27 19:00 | 2025-01-30 | 0 | |
| 14399 | 14399 | 547 WASHINGTON STREET | 42.354994 | -71.195231 | 51043 | 1 | 2025-02-10 09:45 | 2025-02-18 | 0 |
| 14598 | 14598 | 1482 WASHINGTON ST | 42.346404 | -71.23203 | 51043 | 3 | 2025-02-13 12:15 | 2025-02-20 | 0 |
| 14757 | 14757 | 68 LOS ANGELES ST | 42.364377 | -71.195603 | 51043 | 1 | 2025-02-16 18:30 | 2025-02-18 | 0 |
| 15313 | 15313 | 823 WASHINGTON ST | 42.351876 | -71.206866 | 51043 | 2 | 2025-02-24 10:00 | 1 | |
| 15414 | 15414 | 405 CRAFTS ST | 42.359839 | -71.215739 | 51043 | 2 | 2025-02-25 12:45 | 2025-02-26 | 0 |
| 15477 | 15477 | 535 BEACON ST | 42.332265 | -71.18186 | 51043 | 7 | 2025-02-26 10:15 | 2025-02-26 | 0 |
| 15522 | 15522 | 570 CENTRE ST | 42.351507 | -71.18582 | 51043 | 7 | 2025-02-26 20:30 | 2025-03-04 | 0 |
| 15713 | 15713 | 1404 CENTRE ST | 42.326226 | -71.19779 | 51043 | 6 | 2025-03-04 11:30 | 2025-03-04 | 0 |
| 15787 | 15787 | 711 BEACON ST | 42.331068 | -71.189888 | 51043 | 6 | 2025-03-05 14:00 | 2025-03-17 | 0 |
| 15849 | 15849 | 188 WALTHAM ST | 42.360723 | -71.222738 | 51043 | 3 | 2025-03-06 20:30 | 2025-03-11 | 0 |
| 16176 | 16176 | 257 WALTHAM ST | 42.358239 | -71.22312 | 51043 | 3 | 2025-03-11 09:00 | 2025-04-02 | 0 |
| 16233 | 16233 | 413 CHERRY ST | 42.350319 | -71.229051 | 51043 | 3 | 2025-03-11 17:00 | 2025-03-14 | 0 |
| 16571 | 16571 | 268 WATERTOWN ST | 42.361245 | -71.197277 | 51043 | 1 | 2025-03-20 09:00 | 2025-03-26 | 0 |
| 16753 | 16753 | 5 EVELYN ROAD | 42.330621 | -71.218757 | 51043 | 5 | 2025-03-25 09:30 | 2025-03-27 | 0 |
| 16811 | 16811 | 56 WEBSTER STREET | 42.350181 | -71.22878 | 51043 | 3 | 2025-03-25 18:00 | 2025-04-02 | 0 |
| 17112 | 17112 | 711 BEACON ST | 42.331068 | -71.189888 | 51043 | 6 | 2025-03-31 15:30 | 2025-04-01 | 0 |
| 17165 | 17165 | 92 LANGLEY ROAD | 42.329649 | -71.190553 | 51043 | 6 | 2025-04-01 15:15 | 2025-04-02 | 0 |
| 17168 | 17168 | 21 LAKE AVE | 42.330222 | -71.199261 | 51043 | 6 | 2025-04-01 16:15 | 2025-04-02 | 0 |
| 17257 | 17257 | 5 EVELYN ROAD | 42.330621 | -71.218757 | 51043 | 5 | 2025-04-03 14:30 | 2025-04-16 | 0 |
| 17387 | 17387 | 711 BEACON ST | 42.331068 | -71.189888 | 51043 | 6 | 2025-04-07 14:15 | 2025-04-16 | 0 |
| 17597 | 17597 | 21 LAKE AVE | 42.330222 | -71.199261 | 51043 | 6 | 2025-04-09 16:15 | 2025-04-15 | 0 |
| 17710 | 17710 | 2122 COMMONWEALTH AVE | 42.34779 | -71.248545 | 51043 | 4 | 2025-04-11 13:15 | 2025-04-15 | 0 |
| 17721 | 17721 | 796 BEACON ST | 42.330123 | -71.193497 | 51043 | 6 | 2025-04-11 16:15 | 2025-04-15 | 0 |
| 17831 | 17831 | 629 COMMONWEALTH AVE | 42.336414 | -71.192858 | 51043 | 7 | 2025-04-15 11:15 | 2025-04-23 | 0 |
| 17857 | 17857 | 19 CRESCENT AVENUE | 42.330491 | -71.198804 | 51043 | 6 | 2025-04-15 14:45 | 2025-04-15 | 0 |
| 17940 | 17940 | 988 WASHINGTON STREET | 42.350712 | -71.213835 | 51043 | 2 | 2025-04-16 19:15 | 2025-04-17 | 0 |
| 18345 | 18345 | 659 WATERTOWN ST | 42.3549 | -71.211978 | 51043 | 2 | 2025-04-25 12:30 | 2025-05-14 | 0 |
| 18684 | 18684 | 92 LANGLEY ROAD | 42.329598 | -71.190465 | 51043 | 6 | 2025-05-02 07:45 | 2025-05-05 | 0 |
| 18789 | 18789 | 275 CENTRE ST | 42.358545 | -71.185271 | 51043 | 1 | 2025-05-05 09:45 | 2025-05-12 | 0 |
| 18813 | 18813 | 287 HOMER STREET | 42.336026 | -71.205788 | 51043 | 2 | 2025-05-05 11:30 | 2025-05-12 | 0 |
| 19253 | 19253 | 15 CYPRESS ST | 42.328656 | -71.194991 | 51043 | 6 | 2025-05-12 19:45 | 2025-10-03 | 0 |
| 19481 | 19481 | 35 CYPRESS ST | 42.328152 | -71.194653 | 51043 | 6 | 2025-05-16 09:15 | 2025-07-29 | 0 |
| 19572 | 19572 | 552 COMMONWEALTH AVE | 42.336036 | -71.189658 | 51043 | 6 | 2025-05-19 09:00 | 2025-05-28 | 0 |
| 20002 | 20002 | 543 COMMONWEALTH AVE | 42.336531 | -71.188952 | 51043 | 7 | 2025-05-26 14:15 | 1 | |
| 20036 | 20036 | 1073 CENTRE STREET | 42.335622 | -71.193589 | 51043 | 6 | 2025-05-27 10:45 | 1 | |
| 20073 | 20073 | 555 COMMONWEALTH AVE | 42.33645 | -71.18955 | 51043 | 7 | 2025-05-27 16:30 | 2025-05-28 | 0 |
| 20201 | 20201 | 1310 CENTRE ST | 42.328935 | -71.195229 | 51043 | 6 | 2025-05-29 08:30 | 1 | |
| 20812 | 20812 | 1750 COMMONWEALTH AVE | 42.340653 | -71.238623 | 51043 | 4 | 2025-06-06 08:45 | 1 | |
| 20813 | 20813 | 64 BORDER STREET | 42.348006 | -71.232094 | 51043 | 3 | 2025-06-06 08:45 | 2025-10-03 | 0 |
| 21264 | 21264 | 244 LEXINGTON ST | 42.353523 | -71.244792 | 51043 | 4 | 2025-06-13 07:00 | 1 | |
| 21330 | 21330 | 1518 BEACON STREET | 42.32892 | -71.226012 | 51043 | 5 | 2025-06-15 11:30 | 1 | |
| 21523 | 21523 | 1298 CENTRE ST | 42.329106 | -71.194649 | 51043 | 6 | 2025-06-17 15:30 | 2025-06-25 | 0 |
| 21535 | 21535 | 1300 CENTRE STREET | 42.329076 | -71.19478 | 51043 | 6 | 2025-06-17 19:30 | 2025-06-25 | 0 |
| 21688 | 21688 | 84 DERBY ST | 42.357258 | -71.227292 | 51043 | 3 | 2025-06-20 07:45 | 2025-06-29 | 0 |
| 22657 | 22657 | 251 WARD STREET | 42.339595 | -71.182979 | 51043 | 7 | 2025-07-04 14:15 | 2025-07-07 | 0 |
| 22782 | 22782 | 59 LAKEWOOD RD | 42.326559 | -71.205989 | 51043 | 6 | 2025-07-07 18:30 | 2025-07-29 | 0 |
| 22991 | 22991 | 73 PARKER ST | 42.324849 | -71.194181 | 51043 | 6 | 2025-07-09 16:15 | 2025-10-03 | 0 |
| 23247 | 23247 | 85 PARKER ST | 42.324381 | -71.194077 | 51043 | 6 | 2025-07-14 17:15 | 2025-10-03 | 0 |
| 23491 | 23491 | 1296 CENTRE ST | 42.32916 | -71.194698 | 51043 | 6 | 2025-07-16 11:00 | 2025-10-03 | 0 |
| 23556 | 23556 | 310 COMMONWEALTH AVE | 42.335901 | -71.178192 | 51043 | 7 | 2025-07-17 09:15 | 2025-07-29 | 0 |
| 23842 | 23842 | 226 LEXINGTON ST | 42.353919 | -71.244365 | 51043 | 4 | 2025-07-21 16:00 | 2025-09-19 | 0 |
| 23851 | 23851 | 1667 CENTRE ST | 42.31989 | -71.206484 | 51043 | 6 | 2025-07-21 17:45 | 1 | |
| 24169 | 24169 | 1240 BOYLSTON ST | 42.317091 | -71.223543 | 51043 | 5 | 2025-07-26 19:15 | 2025-07-29 | 0 |
| 24307 | 24307 | 1296-1298 CENTRE STREET | 42.329003 | -71.194673 | 51043 | 6 | 2025-07-29 12:45 | 2025-08-18 | 0 |
| 24379 | 24379 | 195 CRAFTS STREET | 42.356897 | -71.207054 | 51043 | 1 | 2025-07-30 11:15 | 2025-08-13 | 0 |
| 24731 | 24731 | 886 WALNUT ST | 42.33114 | -71.206992 | 51043 | 6 | 2025-08-05 22:30 | 2025-09-16 | 0 |
| 25037 | 25037 | 1082 BEACON ST | 42.330654 | -71.206646 | 51043 | 6 | 2025-08-12 08:45 | 2025-08-18 | 0 |
| 25147 | 25147 | 2 LOWELL AVE | 42.356493 | -71.206821 | 51043 | 2 | 2025-08-13 12:15 | 1 | |
| 25430 | 25430 | 87 DERBY ST | 42.357582 | -71.227125 | 51043 | 3 | 2025-08-19 13:00 | 2025-10-06 | 0 |
| 25507 | 25507 | 893 WALNUT ST | 42.330645 | -71.207123 | 51043 | 6 | 2025-08-20 19:00 | 2025-09-16 | 0 |
| 25610 | 25610 | 1099 BEACON ST | 42.331131 | -71.207555 | 51043 | 6 | 2025-08-22 12:00 | 2025-08-25 | 0 |
| 25809 | 25809 | 59 LAKEWOOD ROAD | 42.326493 | -71.206217 | 51043 | 6 | 2025-08-27 16:15 | 1 | |
| 25856 | 25856 | 1008 BEACON STREET | 42.330593 | -71.203299 | 51043 | 6 | 2025-08-28 15:00 | 1 | |
| 25882 | 25882 | 595 WATERTOWN ST | 42.356007 | -71.209598 | 51043 | 2 | 2025-08-29 10:00 | 2025-08-29 | 0 |
| 26086 | 26086 | 1025 WALNUT STREET | 42.326477 | -71.206646 | 51043 | 6 | 2025-09-03 20:15 | 1 | |
| 26308 | 26308 | 109 LOWELL AVENUE | 42.353583 | -71.209589 | 51043 | 2 | 2025-09-08 08:00 | 1 | |
| 26377 | 26377 | 296 WASHINGTON ST | 42.35661 | -71.185851 | 51043 | 1 | 2025-09-09 09:45 | 2025-09-17 | 0 |
| 26397 | 26397 | 420 WAVERLEY AVE | 42.341724 | -71.182593 | 51043 | 7 | 2025-09-09 13:45 | 1 | |
| 26440 | 26440 | 26 PAGE RD | 42.353415 | -71.20935 | 51043 | 2 | 2025-09-10 09:45 | 1 | |
| 26568 | 26568 | 294 CENTRE ST | 42.358122 | -71.18456 | 51043 | 1 | 2025-09-12 05:45 | 1 | |
| 26576 | 26576 | 26 PAGE ROAD | 42.353535 | -71.209393 | 51043 | 2 | 2025-09-12 08:45 | 1 | |
| 26621 | 26621 | 2 LOWELL AVENUE | 42.356623 | -71.206845 | 51043 | 2 | 2025-09-12 13:00 | 1 |
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 );