requests
129 rows where category_id = 51173 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: ward, active, removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 31418 | 31418 | 9 OAK HILL ST | ward-8 | Traffic Signals | 51173 | active | 2025-12-18 15:00 | 42.300783 | -71.178899 | |
| 31282 | 31282 | 395 LEXINGTON STREET | ward-4 | Traffic Signals | 51173 | active | 2025-12-16 12:15 | 42.348627 | -71.247271 | |
| 31281 | 31281 | 369 LEXINGTON STREET | ward-4 | Traffic Signals | 51173 | active | 2025-12-16 12:15 | 42.34964 | -71.247655 | |
| 31280 | 31280 | 470 WAVERLEY AVENUE | ward-7 | Traffic Signals | 51173 | active | 2025-12-16 12:00 | 42.339952 | -71.182941 | |
| 31279 | 31279 | 1267 WASHINGTON STREET | ward-3 | Traffic Signals | 51173 | active | 2025-12-16 12:00 | 42.349362 | -71.225371 | |
| 31278 | 31278 | 1250 WASHINGTON STREET | ward-3 | Traffic Signals | 51173 | active | 2025-12-16 12:00 | 42.349188 | -71.224953 | |
| 31275 | 31275 | 829 WASHINGTON STREET | ward-2 | Traffic Signals | 51173 | active | 2025-12-16 11:45 | 42.35182 | -71.20718 | |
| 31274 | 31274 | 1974 A WASHINGTON STREET | ward-4 | Traffic Signals | 51173 | active | 2025-12-16 11:45 | 42.33282 | -71.246043 | |
| 31162 | 31162 | 2345 WASHINGTON ST | ward-4 | Traffic Signals | 51173 | active | 2025-12-13 15:30 | 42.325605 | -71.257527 | |
| 31150 | 31150 | 275 GROVE ST | ward-4 | Traffic Signals | 51173 | inactive | 2025-12-12 18:45 | 2025-12-15 | 42.338601 | -71.252321 |
| 30930 | 30930 | 1702 WASHINGTON ST | ward-4 | Traffic Signals | 51173 | active | 2025-12-09 13:15 | 42.340824 | -71.2386 | |
| 30921 | 30921 | 1395 COMMONWEALTH AVENUE | ward-3 | Traffic Signals | 51173 | inactive | 2025-12-09 10:30 | 2025-12-19 | 42.336998 | -71.22348 |
| 30877 | 30877 | 9 PARK ST | ward-1 | Traffic Signals | 51173 | active | 2025-12-08 11:45 | 42.356385 | -71.182616 | |
| 30824 | 30824 | 1300 CENTRE STREET | ward-6 | Traffic Signals | 51173 | active | 2025-12-05 14:00 | 42.329031 | -71.194952 | |
| 30646 | 30646 | 538 CALIFORNIA ST | ward-1 | Traffic Signals | 51173 | active | 2025-12-02 13:15 | 42.361281 | -71.209508 | |
| 30645 | 30645 | 390 WOODWARD ST | ward-5 | Traffic Signals | 51173 | active | 2025-12-02 13:15 | 42.325929 | -71.226662 | |
| 30456 | 30456 | 264 GROVE ST | ward-4 | Traffic Signals | 51173 | active | 2025-11-26 15:15 | 42.338367 | -71.251056 | |
| 30416 | 30416 | 264 GROVE STREET | ward-4 | Traffic Signals | 51173 | active | 2025-11-25 20:30 | 42.338294 | -71.251536 | |
| 30334 | 30334 | 85 WOODCLIFF RD | ward-5 | Traffic Signals | 51173 | active | 2025-11-24 19:15 | 42.319017 | -71.202276 | |
| 30128 | 30128 | 732 WALNUT ST | ward-2 | Traffic Signals | 51173 | active | 2025-11-19 20:00 | 42.336423 | -71.20679 | |
| 30076 | 30076 | 924 WASHINGTON ST | ward-2 | Traffic Signals | 51173 | active | 2025-11-19 10:00 | 42.350877 | -71.211006 | |
| 30052 | 30052 | 7 WADE STREET | ward-5 | Traffic Signals | 51173 | active | 2025-11-19 08:15 | 42.319211 | -71.207226 | |
| 30017 | 30017 | 98-100 WINCHESTER STREET | ward-5 | Traffic Signals | 51173 | active | 2025-11-18 14:45 | 42.316507 | -71.208824 | |
| 29752 | 29752 | 287 JACKSON ST | ward-6 | Traffic Signals | 51173 | active | 2025-11-13 09:45 | 42.319287 | -71.194059 | |
| 29656 | 29656 | 1347 WASHINGTON ST | ward-3 | Traffic Signals | 51173 | active | 2025-11-11 22:15 | 42.349113 | -71.228358 | |
| 29002 | 29002 | 732 WALNUT ST | ward-2 | Traffic Signals | 51173 | inactive | 2025-10-30 11:00 | 2025-11-06 | 42.336423 | -71.20679 |
| 28979 | 28979 | 12 CENTRE AVE | ward-1 | Traffic Signals | 51173 | inactive | 2025-10-29 17:45 | 2025-10-29 | 42.355557 | -71.187215 |
| 28952 | 28952 | 477 CENTRE ST | ward-1 | Traffic Signals | 51173 | inactive | 2025-10-29 11:45 | 2025-11-14 | 42.354423 | -71.186661 |
| 28935 | 28935 | 621 WASHINGTON STREET | ward-2 | Traffic Signals | 51173 | active | 2025-10-29 09:00 | 42.354122 | -71.199136 | |
| 28770 | 28770 | 12 DEDHAM STREET | ward-8 | Traffic Signals | 51173 | inactive | 2025-10-25 16:00 | 2025-11-14 | 42.316418 | -71.208342 |
| 28666 | 28666 | 704 BEACON ST | ward-6 | Traffic Signals | 51173 | active | 2025-10-22 19:15 | 42.330681 | -71.189366 | |
| 28572 | 28572 | 935 WASHINGTON ST | ward-2 | Traffic Signals | 51173 | active | 2025-10-22 01:45 | 42.351255 | -71.211033 | |
| 28524 | 28524 | 206 OAK ST | ward-5 | Traffic Signals | 51173 | active | 2025-10-21 09:30 | 42.307686 | -71.216429 | |
| 28498 | 28498 | 296 WASHINGTON ST | ward-1 | Traffic Signals | 51173 | inactive | 2025-10-20 15:45 | 2025-10-20 | 42.35661 | -71.185851 |
| 28351 | 28351 | 924 WASHINGTON ST | ward-2 | Traffic Signals | 51173 | inactive | 2025-10-16 13:15 | 2025-10-16 | 42.350877 | -71.211006 |
| 28311 | 28311 | 40 HARVARD ST | ward-2 | Traffic Signals | 51173 | active | 2025-10-16 09:45 | 42.351075 | -71.201408 | |
| 28160 | 28160 | 88 WOODCLIFF ROAD | ward-6 | Traffic Signals | 51173 | inactive | 2025-10-14 10:45 | 2025-10-14 | 42.319084 | -71.20199 |
| 27913 | 27913 | 144 ELLIOT STREET | ward-5 | Traffic Signals | 51173 | active | 2025-10-07 16:45 | 42.314578 | -71.215487 | |
| 27576 | 27576 | 54 HAMPSHIRE ST | ward-3 | Traffic Signals | 51173 | inactive | 2025-09-30 21:45 | 2025-10-02 | 42.341004 | -71.223174 |
| 27440 | 27440 | 14 NEEDHAM ST | ward-8 | Traffic Signals | 51173 | active | 2025-09-29 10:00 | 42.316101 | -71.209413 | |
| 27378 | 27378 | 99 CRAFTS ST | ward-1 | Traffic Signals | 51173 | inactive | 2025-09-26 17:00 | 2025-09-29 | 42.355917 | -71.202848 |
| 26923 | 26923 | 181 LEXINGTON ST | ward-4 | Traffic Signals | 51173 | active | 2025-09-18 10:45 | 42.355071 | -71.243204 | |
| 26777 | 26777 | 181 LEXINGTON ST | ward-4 | Traffic Signals | 51173 | inactive | 2025-09-16 08:00 | 2025-09-18 | 42.355071 | -71.243204 |
| 26683 | 26683 | 696 CHESTNUT STREET | ward-5 | Traffic Signals | 51173 | active | 2025-09-15 05:15 | 42.32606 | -71.226414 | |
| 26441 | 26441 | 389 WOODWARD STREET | ward-5 | Traffic Signals | 51173 | active | 2025-09-10 09:45 | 42.326252 | -71.226437 | |
| 26374 | 26374 | 244 NEEDHAM ST | ward-8 | Traffic Signals | 51173 | inactive | 2025-09-09 09:30 | 2025-09-12 | 42.309468 | -71.214386 |
| 26159 | 26159 | 2 LOWELL AVE | ward-2 | Traffic Signals | 51173 | inactive | 2025-09-04 15:15 | 2025-09-29 | 42.356493 | -71.206821 |
| 25994 | 25994 | 680 WALNUT ST | ward-2 | Traffic Signals | 51173 | inactive | 2025-09-02 10:30 | 2025-09-02 | 42.338106 | -71.20661 |
| 25993 | 25993 | 426 HOMER ST | ward-2 | Traffic Signals | 51173 | inactive | 2025-09-02 10:30 | 2025-09-02 | 42.337602 | -71.211681 |
| 25991 | 25991 | 732 WALNUT ST | ward-2 | Traffic Signals | 51173 | inactive | 2025-09-02 10:15 | 2025-09-02 | 42.336423 | -71.20679 |
| 25531 | 25531 | 1640 CENTRE ST | ward-6 | Traffic Signals | 51173 | inactive | 2025-08-21 11:00 | 2025-08-21 | 42.320286 | -71.205116 |
| 25510 | 25510 | 500 BEACON STREET | ward-7 | Traffic Signals | 51173 | active | 2025-08-20 21:00 | 42.331466 | -71.180693 | |
| 25499 | 25499 | 924 WASHINGTON ST | ward-2 | Traffic Signals | 51173 | inactive | 2025-08-20 15:15 | 2025-09-23 | 42.350877 | -71.211006 |
| 24861 | 24861 | 308 HOMER ST | ward-6 | Traffic Signals | 51173 | inactive | 2025-08-07 11:15 | 2025-08-15 | 42.335847 | -71.206758 |
| 24858 | 24858 | 245 WARD ST | ward-7 | Traffic Signals | 51173 | inactive | 2025-08-07 11:00 | 2025-08-15 | 42.339753 | -71.182652 |
| 24753 | 24753 | 358 NEWTONVILLE AVENUE | ward-2 | Traffic Signals | 51173 | inactive | 2025-08-06 08:30 | 2025-08-15 | 42.351125 | -71.201668 |
| 24627 | 24627 | 431 WASHINGTON ST | ward-1 | Traffic Signals | 51173 | active | 2025-08-04 16:15 | 42.356043 | -71.190423 | |
| 24543 | 24543 | 345 NEWTONVILLE AVENUE | ward-2 | Traffic Signals | 51173 | inactive | 2025-08-02 13:30 | 2025-08-18 | 42.351315 | -71.201411 |
| 24430 | 24430 | 220 HOBART RD | ward-7 | Traffic Signals | 51173 | active | 2025-07-31 08:45 | 42.33276 | -71.181333 | |
| 24354 | 24354 | 371 WASHINGTON ST | ward-1 | Traffic Signals | 51173 | inactive | 2025-07-30 09:15 | 2025-08-06 | 42.356664 | -71.188551 |
| 24353 | 24353 | 1667 CENTRE STREET | ward-6 | Traffic Signals | 51173 | active | 2025-07-30 09:00 | 42.319607 | -71.206507 | |
| 23874 | 23874 | 535 BEACON ST | ward-7 | Traffic Signals | 51173 | inactive | 2025-07-22 10:00 | 2025-07-29 | 42.332265 | -71.18186 |
| 23184 | 23184 | 833 WASHINGTON ST | ward-2 | Traffic Signals | 51173 | inactive | 2025-07-14 09:45 | 2025-07-22 | 42.351795 | -71.207204 |
| 22913 | 22913 | 624 COMMONWEALTH AVE | ward-6 | Traffic Signals | 51173 | active | 2025-07-09 09:15 | 42.335991 | -71.192822 | |
| 22867 | 22867 | 911 WASHINGTON ST | ward-2 | Traffic Signals | 51173 | inactive | 2025-07-08 16:00 | 2025-07-22 | 42.351354 | -71.210196 |
| 22219 | 22219 | 989 WATERTOWN ST | ward-3 | Traffic Signals | 51173 | inactive | 2025-06-26 16:00 | 2025-06-30 | 42.34977 | -71.225739 |
| 21354 | 21354 | 475 WASHINGTON STREET | ward-1 | Traffic Signals | 51173 | active | 2025-06-16 07:15 | 42.355275 | -71.192766 | |
| 20744 | 20744 | 25 PARK STREET | ward-1 | Traffic Signals | 51173 | inactive | 2025-06-05 09:45 | 2025-07-30 | 42.354939 | -71.182053 |
| 20719 | 20719 | 924 WASHINGTON ST | ward-2 | Traffic Signals | 51173 | inactive | 2025-06-04 20:45 | 2025-07-22 | 42.350877 | -71.211006 |
| 19945 | 19945 | 554 WASHINGTON STREET | ward-1 | Traffic Signals | 51173 | active | 2025-05-23 14:00 | 42.354928 | -71.195556 | |
| 19937 | 19937 | 1670 CENTRE ST | ward-6 | Traffic Signals | 51173 | inactive | 2025-05-23 13:15 | 2025-07-22 | 42.319611 | -71.206137 |
| 19387 | 19387 | 91 ALLERTON RD | ward-6 | Traffic Signals | 51173 | active | 2025-05-14 13:15 | 42.324435 | -71.199657 | |
| 19322 | 19322 | 833 WASHINGTON STREET | ward-2 | Traffic Signals | 51173 | active | 2025-05-13 15:15 | 42.351791 | -71.207247 | |
| 19116 | 19116 | 1670 CENTRE ST | ward-6 | Traffic Signals | 51173 | inactive | 2025-05-09 10:30 | 2025-05-13 | 42.319611 | -71.206137 |
| 18945 | 18945 | 924 WASHINGTON ST | ward-2 | Traffic Signals | 51173 | inactive | 2025-05-07 08:15 | 2025-05-12 | 42.350877 | -71.211006 |
| 18651 | 18651 | 427 CENTRE ST | ward-1 | Traffic Signals | 51173 | inactive | 2025-05-01 11:15 | 2025-07-15 | 42.355521 | -71.186508 |
| 18414 | 18414 | 924 WASHINGTON ST | ward-2 | Traffic Signals | 51173 | inactive | 2025-04-28 10:00 | 2025-04-29 | 42.350877 | -71.211006 |
| 18202 | 18202 | 1087 COMMONWEALTH AVE | ward-2 | Traffic Signals | 51173 | inactive | 2025-04-23 13:30 | 2025-04-24 | 42.338457 | -71.211357 |
| 17740 | 17740 | 50 CHAPIN RD | ward-6 | Traffic Signals | 51173 | inactive | 2025-04-13 13:00 | 2025-04-23 | 42.334353 | -71.19927 |
| 17572 | 17572 | 2122 COMMONWEALTH AVE | ward-4 | Traffic Signals | 51173 | inactive | 2025-04-09 09:00 | 2025-04-15 | 42.34779 | -71.248545 |
| 17331 | 17331 | 867 BOYLSTON STREET | ward-6 | Traffic Signals | 51173 | inactive | 2025-04-04 18:30 | 2025-04-07 | 42.319496 | -71.206732 |
| 17087 | 17087 | 10 WINCHESTER ST | ward-5 | Traffic Signals | 51173 | inactive | 2025-03-31 09:15 | 2025-04-01 | 42.318873 | -71.207591 |
| 17083 | 17083 | 535 BEACON ST | ward-7 | Traffic Signals | 51173 | inactive | 2025-03-31 08:45 | 2025-04-01 | 42.332265 | -71.18186 |
| 16981 | 16981 | 688 CHESTNUT STREET | ward-5 | Traffic Signals | 51173 | inactive | 2025-03-27 19:00 | 2025-04-02 | 42.326167 | -71.226227 |
| 16961 | 16961 | 160 WASHINGTON ST | ward-1 | Traffic Signals | 51173 | inactive | 2025-03-27 14:30 | 2025-03-27 | 42.355917 | -71.180811 |
| 16758 | 16758 | 359 LEXINGTON ST | ward-4 | Traffic Signals | 51173 | inactive | 2025-03-25 10:00 | 2025-03-26 | 42.350058 | -71.247245 |
| 16541 | 16541 | 49 LANGLEY ROAD | ward-6 | Traffic Signals | 51173 | inactive | 2025-03-19 10:15 | 2025-03-26 | 42.330423 | -71.192071 |
| 16372 | 16372 | 64 ASH ST | ward-4 | Traffic Signals | 51173 | inactive | 2025-03-14 15:00 | 2025-03-17 | 42.347232 | -71.25138 |
| 16206 | 16206 | 58 ASH ST | ward-4 | Traffic Signals | 51173 | inactive | 2025-03-11 13:30 | 2025-03-11 | 42.347079 | -71.251241 |
| 16161 | 16161 | 283 BROOKLINE STREET | ward-8 | Traffic Signals | 51173 | inactive | 2025-03-10 20:15 | 2025-03-17 | 42.301153 | -71.178505 |
| 16012 | 16012 | 261 WALNUT STREET | ward-2 | Traffic Signals | 51173 | active | 2025-03-08 14:00 | 42.351759 | -71.207419 | |
| 15989 | 15989 | 470 COMMONWEALTH AVENUE | ward-7 | Traffic Signals | 51173 | inactive | 2025-03-08 08:00 | 2025-03-10 | 42.336534 | -71.185446 |
| 15913 | 15913 | 1269 CENTRE ST | ward-6 | Traffic Signals | 51173 | inactive | 2025-03-07 12:15 | 2025-03-12 | 42.330186 | -71.195036 |
| 15573 | 15573 | 320 NEEDHAM ST | ward-8 | Traffic Signals | 51173 | inactive | 2025-02-27 17:00 | 2025-03-03 | 42.307182 | -71.215956 |
| 13692 | 13692 | 47 PARK ST | ward-1 | Traffic Signals | 51173 | inactive | 2025-01-26 12:00 | 2025-02-04 | 42.35495 | -71.182149 |
| 13677 | 13677 | 470 COMMONWEALTH AVENUE | ward-7 | Traffic Signals | 51173 | inactive | 2025-01-24 22:15 | 2025-02-04 | 42.336391 | -71.185575 |
| 13473 | 13473 | 410 LEXINGTON STREET | ward-4 | Traffic Signals | 51173 | inactive | 2025-01-22 08:00 | 2025-01-22 | 42.348234 | -71.247139 |
| 13170 | 13170 | 107 CENTRE AVENUE | ward-1 | Traffic Signals | 51173 | inactive | 2025-01-15 09:15 | 2025-01-15 | 42.355771 | -71.186787 |
| 12676 | 12676 | 935 WASHINGTON ST | ward-2 | Traffic Signals | 51173 | inactive | 2025-01-06 09:15 | 2025-01-13 | 42.351251 | -71.211056 |
| 12564 | 12564 | 2240 COMMONWEALTH AVE | ward-4 | Traffic Signals | 51173 | inactive | 2025-01-02 18:30 | 2025-01-16 | 42.346891 | -71.253748 |
| 12561 | 12561 | HAMMOND POND PKWY | ward-7 | Traffic Signals | 51173 | inactive | 2025-01-02 16:30 | 2025-01-03 | 42.332094 | -71.181194 |
| 12237 | 12237 | 529 CALIFORNIA STREET | ward-1 | Traffic Signals | 51173 | inactive | 2024-12-25 16:15 | 2024-12-27 | 42.361519 | -71.209506 |
| 11744 | 11744 | 107 MOUNT VERNON STREET | ward-2 | Traffic Signals | 51173 | inactive | 2024-12-16 12:45 | 2024-12-17 | 42.349746 | -71.214266 |
| 11482 | 11482 | 486 WALNUT STREET | ward-2 | Traffic Signals | 51173 | inactive | 2024-12-11 07:00 | 2024-12-24 | 42.344559 | -71.205659 |
| 10960 | 10960 | 791 WALNUT STREET | ward-2 | Traffic Signals | 51173 | inactive | 2024-12-03 14:15 | 2024-12-03 | 42.33425 | -71.209994 |
| 10632 | 10632 | 1121 WASHINGTON ST | ward-3 | Traffic Signals | 51173 | inactive | 2024-11-25 11:45 | 2024-11-26 | 42.349718 | -71.219353 |
| 10455 | 10455 | 1479 WASHINGTON STREET | ward-3 | Traffic Signals | 51173 | inactive | 2024-11-21 17:45 | 2024-11-22 | 42.347128 | -71.231967 |
| 10327 | 10327 | 159 WASHINGTON ST | ward-1 | Traffic Signals | 51173 | inactive | 2024-11-19 13:30 | 2024-11-20 | 42.356296 | -71.180445 |
| 10235 | 10235 | 2206 WASHINGTON STREET | ward-4 | Traffic Signals | 51173 | inactive | 2024-11-18 08:00 | 2024-11-18 | 42.327312 | -71.253183 |
| 9853 | 9853 | 27 WINCHESTER STREET | ward-5 | Traffic Signals | 51173 | inactive | 2024-11-07 13:45 | 2024-11-08 | 42.318885 | -71.207644 |
| 9757 | 9757 | 2094 COMMONWEALTH AVENUE | ward-4 | Traffic Signals | 51173 | inactive | 2024-11-06 19:15 | 2024-11-07 | 42.347947 | -71.247174 |
| 9418 | 9418 | 96 BEACON STREET | ward-7 | Traffic Signals | 51173 | inactive | 2024-11-02 08:45 | 2024-11-04 | 42.333887 | -71.162338 |
| 9036 | 9036 | 1887 COMMONWEALTH AVE | ward-4 | Traffic Signals | 51173 | inactive | 2024-10-31 09:00 | 2024-10-31 | 42.34453 | -71.240686 |
| 7985 | 7985 | 1750 COMMONWEALTH AVE | ward-4 | Traffic Signals | 51173 | inactive | 2024-10-23 07:15 | 2024-10-24 | 42.340656 | -71.23862 |
| 7529 | 7529 | 451 LEXINGTON ST | ward-4 | Traffic Signals | 51173 | inactive | 2024-10-18 11:15 | 2024-10-22 | 42.34683 | -71.247184 |
| 6883 | 6883 | 385 CALIFORNIA STREET | ward-1 | Traffic Signals | 51173 | inactive | 2024-10-09 06:15 | 2024-10-09 | 42.364781 | -71.204731 |
| 6736 | 6736 | 488 CENTRE ST | ward-1 | Traffic Signals | 51173 | inactive | 2024-10-04 12:15 | 2024-10-04 | 42.353941 | -71.186164 |
| 6568 | 6568 | BEACON ST | ward-7 | Traffic Signals | 51173 | inactive | 2024-09-30 13:45 | 2024-09-30 | 42.332852 | -71.172771 |
| 6535 | 6535 | 2088 COMMONWEALTH AVE | ward-4 | Traffic Signals | 51173 | inactive | 2024-09-29 16:15 | 2024-10-02 | 42.347896 | -71.247144 |
| 3771 | 3771 | 300 WASHINGTON ST | ward-1 | Traffic Signals | 51173 | inactive | 2024-08-07 07:00 | 2024-08-07 | 42.356588 | -71.18595 |
| 3303 | 3303 | 196 CALIFORNIA ST | ward-1 | Traffic Signals | 51173 | inactive | 2024-07-29 13:45 | 2024-07-30 | 42.364503 | -71.195996 |
| 2448 | 2448 | 1063 COMMONWEALTH AVENUE | ward-2 | Traffic Signals | 51173 | inactive | 2024-07-12 07:45 | 2024-07-12 | 42.338247 | -71.210423 |
| 2295 | 2295 | 1258–1268 WASHINGTON ST | ward-3 | Traffic Signals | 51173 | inactive | 2024-07-10 07:45 | 2024-07-11 | 42.349347 | -71.225498 |
| 2114 | 2114 | 848 BEACON ST | ward-6 | Traffic Signals | 51173 | inactive | 2024-07-08 07:45 | 2024-07-08 | 42.329867 | -71.195742 |
| 1762 | 1762 | 9 WADE STREET | ward-5 | Traffic Signals | 51173 | inactive | 2024-07-01 08:45 | 2024-07-01 | 42.31927 | -71.207279 |
| 1747 | 1747 | 86 DERBY STREET | ward-3 | Traffic Signals | 51173 | inactive | 2024-07-01 00:30 | 2024-07-03 | 42.357467 | -71.22746 |
| 1631 | 1631 | 808 BEACON ST | ward-6 | Traffic Signals | 51173 | inactive | 2024-06-27 14:45 | 2024-06-28 | 42.330033 | -71.193888 |
| 1613 | 1613 | 630 HAMMOND ST | Traffic Signals | 51173 | inactive | 2024-06-27 12:00 | 2024-06-27 | 42.322727 | -71.163219 | |
| 740 | 740 | 1–31 HAMMOND ST | ward-7 | Traffic Signals | 51173 | inactive | 2024-06-20 | 2024-06-20 | 42.336467 | -71.178578 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "requests" (
[location] TEXT,
[ward] TEXT,
[category] TEXT,
[category_id] TEXT REFERENCES [categories]([id]),
[active] TEXT,
[added] TEXT,
[removed] TEXT,
[latitude] FLOAT,
[longitude] FLOAT
);
CREATE INDEX [idx_requests_ward_category_category_id_active_added_removed]
ON [requests] ([ward], [category], [category_id], [active], [added], [removed]);