locations
123 rows where category_id = 51173 sorted by added descending
This data as json, CSV (advanced)
Suggested facets: ward, active, added (date), removed (date)
| Link | rowid | location | ward | category | category_id | active | added ▲ | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 23079 | 23079 | 9 OAK HILL ST | 8 | Traffic Signals | 51173 | active | 2025-12-18 | 42.300783 | -71.178899 | |
| 22969 | 22969 | 1974 A WASHINGTON STREET | 4 | Traffic Signals | 51173 | active | 2025-12-16 | 42.33282 | -71.246043 | |
| 22970 | 22970 | 829 WASHINGTON STREET | 2 | Traffic Signals | 51173 | active | 2025-12-16 | 42.35182 | -71.20718 | |
| 22971 | 22971 | 1250 WASHINGTON STREET | 3 | Traffic Signals | 51173 | active | 2025-12-16 | 42.349188 | -71.224953 | |
| 22972 | 22972 | 1267 WASHINGTON STREET | 3 | Traffic Signals | 51173 | active | 2025-12-16 | 42.349362 | -71.225371 | |
| 22973 | 22973 | 369 LEXINGTON STREET | 4 | Traffic Signals | 51173 | active | 2025-12-16 | 42.34964 | -71.247655 | |
| 22974 | 22974 | 395 LEXINGTON STREET | 4 | Traffic Signals | 51173 | active | 2025-12-16 | 42.348627 | -71.247271 | |
| 22975 | 22975 | 470 WAVERLEY AVENUE | 7 | Traffic Signals | 51173 | active | 2025-12-16 | 42.339952 | -71.182941 | |
| 22889 | 22889 | 2345 WASHINGTON ST | 4 | Traffic Signals | 51173 | active | 2025-12-13 | 42.325605 | -71.257527 | |
| 22878 | 22878 | 275 GROVE ST | 4 | Traffic Signals | 51173 | 2025-12-12 | 2025-12-15 | 42.338601 | -71.252321 | |
| 22709 | 22709 | 1395 COMMONWEALTH AVENUE | 3 | Traffic Signals | 51173 | 2025-12-09 | 2025-12-19 | 42.336998 | -71.22348 | |
| 22715 | 22715 | 1702 WASHINGTON ST | 4 | Traffic Signals | 51173 | active | 2025-12-09 | 42.340824 | -71.2386 | |
| 22683 | 22683 | 9 PARK ST | 1 | Traffic Signals | 51173 | active | 2025-12-08 | 42.356385 | -71.182616 | |
| 22644 | 22644 | 1300 CENTRE STREET | 6 | Traffic Signals | 51173 | active | 2025-12-05 | 42.329031 | -71.194952 | |
| 22500 | 22500 | 390 WOODWARD ST | 5 | Traffic Signals | 51173 | active | 2025-12-02 | 42.325929 | -71.226662 | |
| 22501 | 22501 | 538 CALIFORNIA ST | 1 | Traffic Signals | 51173 | active | 2025-12-02 | 42.361281 | -71.209508 | |
| 22322 | 22322 | 264 GROVE STREET | 4 | Traffic Signals | 51173 | active | 2025-11-26 | 42.338294 | -71.251536 | |
| 22351 | 22351 | 264 GROVE ST | 4 | Traffic Signals | 51173 | active | 2025-11-26 | 42.338367 | -71.251056 | |
| 22262 | 22262 | 85 WOODCLIFF RD | 5 | Traffic Signals | 51173 | active | 2025-11-25 | 42.319017 | -71.202276 | |
| 22109 | 22109 | 732 WALNUT ST | 2 | Traffic Signals | 51173 | active | 2025-11-20 | 42.336423 | -71.20679 | |
| 22051 | 22051 | 7 WADE STREET | 5 | Traffic Signals | 51173 | active | 2025-11-19 | 42.319211 | -71.207226 | |
| 22068 | 22068 | 924 WASHINGTON ST | 2 | Traffic Signals | 51173 | active | 2025-11-19 | 42.350877 | -71.211006 | |
| 22014 | 22014 | 98-100 WINCHESTER STREET | 5 | Traffic Signals | 51173 | active | 2025-11-18 | 42.316507 | -71.208824 | |
| 21809 | 21809 | 287 JACKSON ST | 6 | Traffic Signals | 51173 | active | 2025-11-13 | 42.319287 | -71.194059 | |
| 21730 | 21730 | 1347 WASHINGTON ST | 3 | Traffic Signals | 51173 | active | 2025-11-12 | 42.349113 | -71.228358 | |
| 21212 | 21212 | 732 WALNUT ST | 2 | Traffic Signals | 51173 | 2025-10-30 | 2025-11-06 | 42.336423 | -71.20679 | |
| 21167 | 21167 | 621 WASHINGTON STREET | 2 | Traffic Signals | 51173 | active | 2025-10-29 | 42.354122 | -71.199136 | |
| 21177 | 21177 | 477 CENTRE ST | 1 | Traffic Signals | 51173 | 2025-10-29 | 2025-11-14 | 42.354423 | -71.186661 | |
| 21189 | 21189 | 12 CENTRE AVE | 1 | Traffic Signals | 51173 | 2025-10-29 | 2025-10-29 | 42.355557 | -71.187215 | |
| 21038 | 21038 | 12 DEDHAM STREET | 8 | Traffic Signals | 51173 | 2025-10-25 | 2025-11-14 | 42.316418 | -71.208342 | |
| 20891 | 20891 | 935 WASHINGTON ST | 2 | Traffic Signals | 51173 | active | 2025-10-22 | 42.351255 | -71.211033 | |
| 20965 | 20965 | 704 BEACON ST | 6 | Traffic Signals | 51173 | active | 2025-10-22 | 42.330681 | -71.189366 | |
| 20856 | 20856 | 206 OAK ST | 5 | Traffic Signals | 51173 | active | 2025-10-21 | 42.307686 | -71.216429 | |
| 20833 | 20833 | 296 WASHINGTON ST | 1 | Traffic Signals | 51173 | 2025-10-20 | 2025-10-20 | 42.35661 | -71.185851 | |
| 20702 | 20702 | 40 HARVARD ST | 2 | Traffic Signals | 51173 | active | 2025-10-16 | 42.351075 | -71.201408 | |
| 20731 | 20731 | 924 WASHINGTON ST | 2 | Traffic Signals | 51173 | 2025-10-16 | 2025-10-17 | 42.350877 | -71.211006 | |
| 20580 | 20580 | 88 WOODCLIFF ROAD | 6 | Traffic Signals | 51173 | 2025-10-14 | 2025-10-14 | 42.319084 | -71.20199 | |
| 20400 | 20400 | 144 ELLIOT STREET | 5 | Traffic Signals | 51173 | active | 2025-10-07 | 42.314578 | -71.215487 | |
| 20145 | 20145 | 54 HAMPSHIRE ST | 3 | Traffic Signals | 51173 | 2025-10-01 | 2025-10-02 | 42.341004 | -71.223174 | |
| 20049 | 20049 | 14 NEEDHAM ST | 8 | Traffic Signals | 51173 | active | 2025-09-29 | 42.316101 | -71.209413 | |
| 20012 | 20012 | 99 CRAFTS ST | 1 | Traffic Signals | 51173 | 2025-09-26 | 2025-09-29 | 42.355917 | -71.202848 | |
| 19694 | 19694 | 181 LEXINGTON ST | 4 | Traffic Signals | 51173 | active | 2025-09-18 | 42.355071 | -71.243204 | |
| 19593 | 19593 | 181 LEXINGTON ST | 4 | Traffic Signals | 51173 | 2025-09-16 | 2025-09-18 | 42.355071 | -71.243204 | |
| 19533 | 19533 | 696 CHESTNUT STREET | 5 | Traffic Signals | 51173 | active | 2025-09-15 | 42.32606 | -71.226414 | |
| 19354 | 19354 | 389 WOODWARD STREET | 5 | Traffic Signals | 51173 | active | 2025-09-10 | 42.326252 | -71.226437 | |
| 19310 | 19310 | 244 NEEDHAM ST | 8 | Traffic Signals | 51173 | 2025-09-09 | 2025-09-12 | 42.309468 | -71.214386 | |
| 19145 | 19145 | 2 LOWELL AVE | 2 | Traffic Signals | 51173 | 2025-09-04 | 2025-09-29 | 42.356493 | -71.206821 | |
| 18679 | 18679 | 500 BEACON STREET | 7 | Traffic Signals | 51173 | active | 2025-08-21 | 42.331466 | -71.180693 | |
| 18671 | 18671 | 924 WASHINGTON ST | 2 | Traffic Signals | 51173 | 2025-08-20 | 2025-09-23 | 42.350877 | -71.211006 | |
| 18223 | 18223 | 245 WARD ST | 7 | Traffic Signals | 51173 | 2025-08-07 | 2025-08-15 | 42.339753 | -71.182652 | |
| 18224 | 18224 | 308 HOMER ST | 6 | Traffic Signals | 51173 | 2025-08-07 | 2025-08-15 | 42.335847 | -71.206758 | |
| 18145 | 18145 | 358 NEWTONVILLE AVENUE | 2 | Traffic Signals | 51173 | 2025-08-06 | 2025-08-15 | 42.351125 | -71.201668 | |
| 18051 | 18051 | 431 WASHINGTON ST | 1 | Traffic Signals | 51173 | active | 2025-08-04 | 42.356043 | -71.190423 | |
| 17991 | 17991 | 345 NEWTONVILLE AVENUE | 2 | Traffic Signals | 51173 | 2025-08-02 | 2025-08-18 | 42.351315 | -71.201411 | |
| 17914 | 17914 | 220 HOBART RD | 7 | Traffic Signals | 51173 | active | 2025-07-31 | 42.33276 | -71.181333 | |
| 17855 | 17855 | 1667 CENTRE STREET | 6 | Traffic Signals | 51173 | active | 2025-07-30 | 42.319607 | -71.206507 | |
| 17859 | 17859 | 371 WASHINGTON ST | 1 | Traffic Signals | 51173 | 2025-07-30 | 2025-08-06 | 42.356664 | -71.188551 | |
| 17513 | 17513 | 535 BEACON ST | 7 | Traffic Signals | 51173 | 2025-07-22 | 2025-07-30 | 42.332265 | -71.18186 | |
| 16984 | 16984 | 833 WASHINGTON ST | 2 | Traffic Signals | 51173 | 2025-07-14 | 2025-07-22 | 42.351795 | -71.207204 | |
| 16774 | 16774 | 624 COMMONWEALTH AVE | 6 | Traffic Signals | 51173 | active | 2025-07-09 | 42.335991 | -71.192822 | |
| 16745 | 16745 | 911 WASHINGTON ST | 2 | Traffic Signals | 51173 | 2025-07-08 | 2025-07-22 | 42.351354 | -71.210196 | |
| 16264 | 16264 | 989 WATERTOWN ST | 3 | Traffic Signals | 51173 | 2025-06-26 | 2025-06-30 | 42.34977 | -71.225739 | |
| 15554 | 15554 | 475 WASHINGTON STREET | 1 | Traffic Signals | 51173 | active | 2025-06-16 | 42.355275 | -71.192766 | |
| 15053 | 15053 | 924 WASHINGTON ST | 2 | Traffic Signals | 51173 | 2025-06-05 | 2025-07-22 | 42.350877 | -71.211006 | |
| 15077 | 15077 | 25 PARK STREET | 1 | Traffic Signals | 51173 | 2025-06-05 | 2025-07-30 | 42.354939 | -71.182053 | |
| 14445 | 14445 | 1670 CENTRE ST | 6 | Traffic Signals | 51173 | 2025-05-23 | 2025-07-22 | 42.319611 | -71.206137 | |
| 14447 | 14447 | 554 WASHINGTON STREET | 1 | Traffic Signals | 51173 | active | 2025-05-23 | 42.354928 | -71.195556 | |
| 13998 | 13998 | 91 ALLERTON RD | 6 | Traffic Signals | 51173 | active | 2025-05-14 | 42.324435 | -71.199657 | |
| 13948 | 13948 | 833 WASHINGTON STREET | 2 | Traffic Signals | 51173 | active | 2025-05-13 | 42.351791 | -71.207247 | |
| 13790 | 13790 | 1670 CENTRE ST | 6 | Traffic Signals | 51173 | 2025-05-09 | 2025-05-13 | 42.319611 | -71.206137 | |
| 13659 | 13659 | 924 WASHINGTON ST | 2 | Traffic Signals | 51173 | 2025-05-07 | 2025-05-12 | 42.350877 | -71.211006 | |
| 13439 | 13439 | 427 CENTRE ST | 1 | Traffic Signals | 51173 | 2025-05-01 | 2025-07-15 | 42.355521 | -71.186508 | |
| 13264 | 13264 | 924 WASHINGTON ST | 2 | Traffic Signals | 51173 | 2025-04-28 | 2025-04-29 | 42.350877 | -71.211006 | |
| 13100 | 13100 | 1087 COMMONWEALTH AVE | 2 | Traffic Signals | 51173 | 2025-04-23 | 2025-04-24 | 42.338457 | -71.211357 | |
| 12764 | 12764 | 50 CHAPIN RD | 6 | Traffic Signals | 51173 | 2025-04-13 | 2025-04-23 | 42.334353 | -71.19927 | |
| 12644 | 12644 | 2122 COMMONWEALTH AVE | 4 | Traffic Signals | 51173 | 2025-04-09 | 2025-04-15 | 42.34779 | -71.248545 | |
| 12490 | 12490 | 867 BOYLSTON STREET | 6 | Traffic Signals | 51173 | 2025-04-04 | 2025-04-07 | 42.319496 | -71.206732 | |
| 12292 | 12292 | 10 WINCHESTER ST | 5 | Traffic Signals | 51173 | 2025-03-31 | 2025-04-01 | 42.318873 | -71.207591 | |
| 12293 | 12293 | 535 BEACON ST | 7 | Traffic Signals | 51173 | 2025-03-31 | 2025-04-01 | 42.332265 | -71.18186 | |
| 12231 | 12231 | 688 CHESTNUT STREET | 5 | Traffic Signals | 51173 | 2025-03-27 | 2025-04-02 | 42.326167 | -71.226227 | |
| 12056 | 12056 | 359 LEXINGTON ST | 4 | Traffic Signals | 51173 | 2025-03-25 | 2025-03-26 | 42.350058 | -71.247245 | |
| 11904 | 11904 | 49 LANGLEY ROAD | 6 | Traffic Signals | 51173 | 2025-03-19 | 2025-03-26 | 42.330423 | -71.192071 | |
| 11786 | 11786 | 64 ASH ST | 4 | Traffic Signals | 51173 | 2025-03-14 | 2025-03-17 | 42.347232 | -71.25138 | |
| 11645 | 11645 | 283 BROOKLINE STREET | 8 | Traffic Signals | 51173 | 2025-03-11 | 2025-03-17 | 42.301153 | -71.178505 | |
| 11675 | 11675 | 58 ASH ST | 4 | Traffic Signals | 51173 | 2025-03-11 | 2025-03-11 | 42.347079 | -71.251241 | |
| 11512 | 11512 | 470 COMMONWEALTH AVENUE | 7 | Traffic Signals | 51173 | 2025-03-08 | 2025-03-10 | 42.336534 | -71.185446 | |
| 11530 | 11530 | 261 WALNUT STREET | 2 | Traffic Signals | 51173 | active | 2025-03-08 | 42.351759 | -71.207419 | |
| 11450 | 11450 | 1269 CENTRE ST | 6 | Traffic Signals | 51173 | 2025-03-07 | 2025-03-12 | 42.330186 | -71.195036 | |
| 11328 | 11328 | 426 HOMER ST | 2 | Traffic Signals | 51173 | 2025-03-04 | 2025-03-04 | 42.337602 | -71.211681 | |
| 11227 | 11227 | 320 NEEDHAM ST | 8 | Traffic Signals | 51173 | 2025-02-27 | 2025-03-03 | 42.307182 | -71.215956 | |
| 9708 | 9708 | 47 PARK ST | 1 | Traffic Signals | 51173 | 2025-01-26 | 2025-02-04 | 42.35495 | -71.182149 | |
| 9694 | 9694 | 470 COMMONWEALTH AVENUE | 7 | Traffic Signals | 51173 | 2025-01-25 | 2025-02-04 | 42.336391 | -71.185575 | |
| 9519 | 9519 | 410 LEXINGTON STREET | 4 | Traffic Signals | 51173 | 2025-01-22 | 2025-01-22 | 42.348234 | -71.247139 | |
| 9278 | 9278 | 107 CENTRE AVENUE | 1 | Traffic Signals | 51173 | 2025-01-15 | 2025-01-15 | 42.355771 | -71.186787 | |
| 8905 | 8905 | 935 WASHINGTON ST | 2 | Traffic Signals | 51173 | 2025-01-06 | 2025-01-13 | 42.351251 | -71.211056 | |
| 8813 | 8813 | HAMMOND POND PKWY | 7 | Traffic Signals | 51173 | 2025-01-02 | 2025-01-03 | 42.332094 | -71.181194 | |
| 8817 | 8817 | 2240 COMMONWEALTH AVE | 4 | Traffic Signals | 51173 | 2025-01-02 | 2025-01-16 | 42.346891 | -71.253748 | |
| 8572 | 8572 | 529 CALIFORNIA STREET | 1 | Traffic Signals | 51173 | 2024-12-25 | 2024-12-27 | 42.361519 | -71.209506 | |
| 8167 | 8167 | 107 MOUNT VERNON STREET | 2 | Traffic Signals | 51173 | 2024-12-16 | 2024-12-17 | 42.349746 | -71.214266 | |
| 7970 | 7970 | 486 WALNUT STREET | 2 | Traffic Signals | 51173 | 2024-12-11 | 2024-12-24 | 42.344559 | -71.205659 | |
| 7578 | 7578 | 791 WALNUT STREET | 2 | Traffic Signals | 51173 | 2024-12-03 | 2024-12-03 | 42.33425 | -71.209994 | |
| 7302 | 7302 | 1121 WASHINGTON ST | 3 | Traffic Signals | 51173 | 2024-11-25 | 2024-11-26 | 42.349718 | -71.219353 | |
| 7163 | 7163 | 1479 WASHINGTON STREET | 3 | Traffic Signals | 51173 | 2024-11-21 | 2024-11-22 | 42.347128 | -71.231967 | |
| 7075 | 7075 | 159 WASHINGTON ST | 1 | Traffic Signals | 51173 | 2024-11-19 | 2024-11-20 | 42.356296 | -71.180445 | |
| 7021 | 7021 | 2206 WASHINGTON STREET | 4 | Traffic Signals | 51173 | 2024-11-18 | 2024-11-18 | 42.327312 | -71.253183 | |
| 6668 | 6668 | 2094 COMMONWEALTH AVENUE | 4 | Traffic Signals | 51173 | 2024-11-07 | 2024-11-07 | 42.347947 | -71.247174 | |
| 6721 | 6721 | 27 WINCHESTER STREET | 5 | Traffic Signals | 51173 | 2024-11-07 | 2024-11-08 | 42.318885 | -71.207644 | |
| 6443 | 6443 | 96 BEACON STREET | 7 | Traffic Signals | 51173 | 2024-11-02 | 2024-11-04 | 42.333887 | -71.162338 | |
| 6293 | 6293 | 1887 COMMONWEALTH AVE | 4 | Traffic Signals | 51173 | 2024-10-31 | 2024-10-31 | 42.34453 | -71.240686 | |
| 5701 | 5701 | 1750 COMMONWEALTH AVE | 4 | Traffic Signals | 51173 | 2024-10-23 | 2024-10-24 | 42.340656 | -71.23862 | |
| 5427 | 5427 | 451 LEXINGTON ST | 4 | Traffic Signals | 51173 | 2024-10-18 | 2024-10-22 | 42.34683 | -71.247184 | |
| 5035 | 5035 | 385 CALIFORNIA STREET | 1 | Traffic Signals | 51173 | 2024-10-09 | 2024-10-09 | 42.364781 | -71.204731 | |
| 4914 | 4914 | 488 CENTRE ST | 1 | Traffic Signals | 51173 | 2024-10-04 | 2024-10-04 | 42.353941 | -71.186164 | |
| 4781 | 4781 | 2088 COMMONWEALTH AVE | 4 | Traffic Signals | 51173 | 2024-09-29 | 2024-10-02 | 42.347896 | -71.247144 | |
| 2797 | 2797 | 300 WASHINGTON ST | 1 | Traffic Signals | 51173 | 2024-08-07 | 2024-08-07 | 42.356588 | -71.18595 | |
| 2469 | 2469 | 196 CALIFORNIA ST | 1 | Traffic Signals | 51173 | 2024-07-29 | 2024-07-30 | 42.364503 | -71.195996 | |
| 1838 | 1838 | 1063 COMMONWEALTH AVENUE | 2 | Traffic Signals | 51173 | 2024-07-12 | 2024-07-12 | 42.338247 | -71.210423 | |
| 1728 | 1728 | 1258–1268 WASHINGTON ST | 3 | Traffic Signals | 51173 | 2024-07-10 | 2024-07-11 | 42.349347 | -71.225498 | |
| 1602 | 1602 | 848 BEACON ST | 6 | Traffic Signals | 51173 | 2024-07-08 | 2024-07-08 | 42.329867 | -71.195742 | |
| 1321 | 1321 | 86 DERBY STREET | 3 | Traffic Signals | 51173 | 2024-07-01 | 2024-07-03 | 42.357467 | -71.22746 | |
| 1216 | 1216 | 630 HAMMOND ST | Traffic Signals | 51173 | 2024-06-27 | 2024-06-27 | 42.322727 | -71.163219 | ||
| 1225 | 1225 | 808 BEACON ST | 6 | Traffic Signals | 51173 | 2024-06-27 | 2024-06-28 | 42.330033 | -71.193888 | |
| 741 | 741 | 1–31 HAMMOND ST | 7 | Traffic Signals | 51173 | 2024-06-20 | 2024-06-20 | 42.336467 | -71.178578 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "locations" ( [location] TEXT, [ward] INTEGER, [category] TEXT, [category_id] TEXT REFERENCES [categories]([id]), [active] TEXT, [added] TEXT, [removed] TEXT, [latitude] FLOAT, [longitude] FLOAT );