requests
72 rows where category_id = 51171 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: ward, active
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 31665 | 31665 | 195 CRAFTS ST | ward-1 | Traffic Signal Light Out | 51171 | active | 2025-12-22 15:30 | 42.357042 | -71.207172 | |
| 31277 | 31277 | 2345 WASHINGTON STREET | ward-4 | Traffic Signal Light Out | 51171 | active | 2025-12-16 12:00 | 42.325509 | -71.257566 | |
| 31002 | 31002 | 105 ELM STREET | ward-3 | Traffic Signal Light Out | 51171 | active | 2025-12-10 16:30 | 42.348638 | -71.229105 | |
| 30962 | 30962 | 470 COMMONWEALTH AVENUE | ward-6 | Traffic Signal Light Out | 51171 | active | 2025-12-09 21:15 | 42.336343 | -71.185843 | |
| 30846 | 30846 | 310 NEEDHAM STREET | ward-8 | Traffic Signal Light Out | 51171 | active | 2025-12-06 13:30 | 42.307469 | -71.216152 | |
| 30638 | 30638 | 27 CHRISTINA ST | ward-8 | Traffic Signal Light Out | 51171 | active | 2025-12-02 10:45 | 42.30702 | -71.214899 | |
| 30030 | 30030 | 405 CRAFTS ST | ward-2 | Traffic Signal Light Out | 51171 | active | 2025-11-18 18:45 | 42.360021 | -71.216042 | |
| 29126 | 29126 | 331 WATERTOWN STREET | ward-1 | Traffic Signal Light Out | 51171 | active | 2025-11-01 01:15 | 42.361019 | -71.200038 | |
| 28997 | 28997 | 62 RIVER STREET | ward-3 | Traffic Signal Light Out | 51171 | active | 2025-10-30 09:00 | 42.352203 | -71.228791 | |
| 28882 | 28882 | 70 RIVER ST | ward-3 | Traffic Signal Light Out | 51171 | active | 2025-10-28 11:15 | 42.352119 | -71.229317 | |
| 28678 | 28678 | 527 WALTHAM ST | ward-3 | Traffic Signal Light Out | 51171 | inactive | 2025-10-23 09:45 | 2025-11-14 | 42.34968 | -71.226585 |
| 28440 | 28440 | 331 WATERTOWN ST | ward-1 | Traffic Signal Light Out | 51171 | active | 2025-10-19 23:45 | 42.361002 | -71.200013 | |
| 28270 | 28270 | 40 HARVARD ST | ward-2 | Traffic Signal Light Out | 51171 | active | 2025-10-15 14:45 | 42.351075 | -71.201408 | |
| 28122 | 28122 | 257 TREMONT ST | ward-1 | Traffic Signal Light Out | 51171 | active | 2025-10-14 07:30 | 42.354108 | -71.17857 | |
| 27783 | 27783 | 261 PARKER ST | ward-6 | Traffic Signal Light Out | 51171 | inactive | 2025-10-05 11:45 | 2025-10-22 | 42.318387 | -71.194766 |
| 27742 | 27742 | 474 CENTRE STREET | ward-1 | Traffic Signal Light Out | 51171 | active | 2025-10-03 14:45 | 42.354471 | -71.186095 | |
| 27587 | 27587 | 1087 BEACON ST | ward-6 | Traffic Signal Light Out | 51171 | active | 2025-10-01 08:45 | 42.331032 | -71.206785 | |
| 27436 | 27436 | 425 CENTRE ST | ward-1 | Traffic Signal Light Out | 51171 | active | 2025-09-29 09:45 | 42.35553 | -71.186504 | |
| 27383 | 27383 | 728 WALNUT ST | ward-2 | Traffic Signal Light Out | 51171 | active | 2025-09-26 21:30 | 42.336513 | -71.206763 | |
| 26256 | 26256 | 550 WASHINGTON ST | ward-1 | Traffic Signal Light Out | 51171 | active | 2025-09-06 07:30 | 42.354774 | -71.195139 | |
| 25754 | 25754 | 356 NEWTONVILLE AVE | ward-2 | Traffic Signal Light Out | 51171 | inactive | 2025-08-26 18:15 | 2025-08-28 | 42.350913 | -71.201831 |
| 25424 | 25424 | 390 WOODWARD ST | ward-5 | Traffic Signal Light Out | 51171 | inactive | 2025-08-19 12:00 | 2025-08-20 | 42.325929 | -71.226662 |
| 25366 | 25366 | 1753 COMMONWEALTH AVE | ward-3 | Traffic Signal Light Out | 51171 | inactive | 2025-08-18 15:15 | 2025-08-28 | 42.341202 | -71.238173 |
| 24595 | 24595 | 255 WASHINGTON ST | ward-1 | Traffic Signal Light Out | 51171 | active | 2025-08-04 10:45 | 42.357771 | -71.183844 | |
| 24529 | 24529 | 465 CENTRE ST | ward-1 | Traffic Signal Light Out | 51171 | active | 2025-08-01 17:15 | 42.354747 | -71.186675 | |
| 24508 | 24508 | 32 HARVARD ST | ward-2 | Traffic Signal Light Out | 51171 | inactive | 2025-08-01 12:45 | 2025-08-02 | 42.351408 | -71.201547 |
| 23891 | 23891 | 275 WAVERLEY AVE | ward-7 | Traffic Signal Light Out | 51171 | inactive | 2025-07-22 12:30 | 2025-07-29 | 42.346449 | -71.181428 |
| 23855 | 23855 | 1572 COMMONWEALTH AVENUE | ward-3 | Traffic Signal Light Out | 51171 | active | 2025-07-21 23:30 | 42.339115 | -71.231022 | |
| 23748 | 23748 | 537 CALIFORNIA ST | ward-2 | Traffic Signal Light Out | 51171 | inactive | 2025-07-21 07:30 | 2025-07-23 | 42.361542 | -71.209832 |
| 23675 | 23675 | 4 JUDITH ROAD | ward-2 | Traffic Signal Light Out | 51171 | active | 2025-07-18 13:00 | 42.335519 | -71.207505 | |
| 23227 | 23227 | 282 WAVERLEY AVENUE | ward-7 | Traffic Signal Light Out | 51171 | inactive | 2025-07-14 14:30 | 2025-07-29 | 42.346716 | -71.180854 |
| 22878 | 22878 | 978 CENTRE STREET | ward-7 | Traffic Signal Light Out | 51171 | inactive | 2025-07-08 22:15 | 2025-07-29 | 42.33609 | -71.1933 |
| 22590 | 22590 | 235 CALIFORNIA ST | ward-1 | Traffic Signal Light Out | 51171 | inactive | 2025-07-02 22:15 | 2025-07-26 | 42.365016 | -71.197866 |
| 22363 | 22363 | 1664 CENTRE ST | ward-6 | Traffic Signal Light Out | 51171 | inactive | 2025-06-30 15:15 | 2025-07-15 | 42.319737 | -71.205908 |
| 22218 | 22218 | 1279 WASHINGTON ST | ward-3 | Traffic Signal Light Out | 51171 | inactive | 2025-06-26 16:00 | 2025-06-30 | 42.34959 | -71.225564 |
| 21114 | 21114 | 1888 COMMONWEALTH AVE | ward-4 | Traffic Signal Light Out | 51171 | inactive | 2025-06-11 09:15 | 2025-06-11 | 42.344676 | -71.241399 |
| 19685 | 19685 | 255 WASHINGTON STREET | ward-1 | Traffic Signal Light Out | 51171 | active | 2025-05-20 10:30 | 42.357515 | -71.18418 | |
| 19500 | 19500 | 640 COMMONWEALTH AVE | ward-6 | Traffic Signal Light Out | 51171 | inactive | 2025-05-16 13:45 | 2025-05-16 | 42.335802 | -71.193353 |
| 18769 | 18769 | 437 WASHINGTON STREET | ward-1 | Traffic Signal Light Out | 51171 | inactive | 2025-05-05 01:45 | 2025-07-15 | 42.35603 | -71.190533 |
| 17939 | 17939 | 18 GATEWAY CTR | ward-1 | Traffic Signal Light Out | 51171 | inactive | 2025-04-16 19:00 | 2025-04-17 | 42.356826 | -71.186 |
| 17715 | 17715 | 529 CRAFTS ST | ward-3 | Traffic Signal Light Out | 51171 | inactive | 2025-04-11 15:00 | 2025-04-23 | 42.360543 | -71.221788 |
| 17674 | 17674 | 1702 WASHINGTON ST | ward-4 | Traffic Signal Light Out | 51171 | inactive | 2025-04-10 17:45 | 2025-04-15 | 42.340824 | -71.2386 |
| 17317 | 17317 | 2078 COMMONWEALTH AVE | ward-4 | Traffic Signal Light Out | 51171 | inactive | 2025-04-04 15:30 | 2025-04-23 | 42.347574 | -71.24666 |
| 16425 | 16425 | 216 PEARL STREET | ward-1 | Traffic Signal Light Out | 51171 | inactive | 2025-03-17 09:00 | 2025-03-17 | 42.359624 | -71.195488 |
| 16358 | 16358 | 94 GROVE ST | ward-4 | Traffic Signal Light Out | 51171 | inactive | 2025-03-14 11:15 | 2025-03-17 | 42.343308 | -71.248226 |
| 16196 | 16196 | 14-16 BRIDGE STREET | ward-1 | Traffic Signal Light Out | 51171 | inactive | 2025-03-11 12:15 | 2025-03-14 | 42.364951 | -71.204072 |
| 16101 | 16101 | 1007 BEACON ST | ward-6 | Traffic Signal Light Out | 51171 | inactive | 2025-03-10 10:30 | 2025-03-10 | 42.330807 | -71.203239 |
| 15354 | 15354 | 2221 WASHINGTON ST | ward-4 | Traffic Signal Light Out | 51171 | inactive | 2025-02-24 15:45 | 2025-02-26 | 42.327306 | -71.253963 |
| 13757 | 13757 | 68 CHESTNUT STREET | ward-3 | Traffic Signal Light Out | 51171 | inactive | 2025-01-27 19:00 | 2025-01-28 | 42.34785 | -71.225004 |
| 13465 | 13465 | 410 LEXINGTON STREET | ward-4 | Traffic Signal Light Out | 51171 | inactive | 2025-01-21 20:00 | 2025-02-05 | 42.348224 | -71.247176 |
| 13305 | 13305 | 334 WATERTOWN ST | ward-1 | Traffic Signal Light Out | 51171 | inactive | 2025-01-17 14:30 | 2025-01-23 | 42.360768 | -71.199941 |
| 11975 | 11975 | 108 JACKSON ROAD | ward-1 | Traffic Signal Light Out | 51171 | inactive | 2024-12-20 17:30 | 2024-12-27 | 42.359378 | -71.194748 |
| 10139 | 10139 | 1697 BEACON ST | ward-5 | Traffic Signal Light Out | 51171 | inactive | 2024-11-14 08:45 | 2024-11-18 | 42.326457 | -71.232711 |
| 9607 | 9607 | 207 NAHANTON ST | ward-8 | Traffic Signal Light Out | 51171 | inactive | 2024-11-05 12:00 | 2024-11-12 | 42.300804 | -71.196786 |
| 9429 | 9429 | 2345 WASHINGTON STREET | ward-4 | Traffic Signal Light Out | 51171 | inactive | 2024-11-03 14:45 | 2024-11-07 | 42.325505 | -71.257634 |
| 8663 | 8663 | 255 WASHINGTON ST | ward-1 | Traffic Signal Light Out | 51171 | inactive | 2024-10-29 10:15 | 2024-11-04 | 42.357767 | -71.183842 |
| 7676 | 7676 | 465 CENTRE ST | ward-1 | Traffic Signal Light Out | 51171 | inactive | 2024-10-18 16:15 | 2024-10-21 | 42.354744 | -71.186674 |
| 6523 | 6523 | WATERTOWN ST @ ADAMS ST | ward-1 | Traffic Signal Light Out | 51171 | inactive | 2024-09-28 17:15 | 2024-10-01 | 42.359952 | -71.202364 |
| 5565 | 5565 | 821 BEACON STREET | ward-6 | Traffic Signal Light Out | 51171 | inactive | 2024-09-10 08:00 | 2024-09-11 | 42.330157 | -71.194888 |
| 5516 | 5516 | 1940 WASHINGTON ST | ward-4 | Traffic Signal Light Out | 51171 | inactive | 2024-09-09 09:45 | 2024-09-09 | 42.333389 | -71.243459 |
| 5171 | 5171 | 2077 WASHINGTON ST | ward-4 | Traffic Signal Light Out | 51171 | inactive | 2024-08-30 14:00 | 2024-09-03 | 42.33031 | -71.248644 |
| 4246 | 4246 | 1195 BOYLSTON STREET | Traffic Signal Light Out | 51171 | inactive | 2024-08-12 20:15 | 2024-08-13 | 42.32376 | -71.164251 | |
| 3745 | 3745 | 287-289 AUBURN STREET | ward-4 | Traffic Signal Light Out | 51171 | inactive | 2024-08-06 12:45 | 2024-08-07 | 42.346676 | -71.24689 |
| 3119 | 3119 | 421 WAVERLEY AVENUE | ward-7 | Traffic Signal Light Out | 51171 | inactive | 2024-07-25 08:45 | 2024-08-01 | 42.341498 | -71.182871 |
| 2805 | 2805 | WASHINGTON ST | ward-3 | Traffic Signal Light Out | 51171 | inactive | 2024-07-18 13:15 | 2024-07-26 | 42.347953 | -71.232147 |
| 2461 | 2461 | 87 HOBART RD | ward-7 | Traffic Signal Light Out | 51171 | inactive | 2024-07-12 10:00 | 2024-07-12 | 42.336236 | -71.182698 |
| 2459 | 2459 | 629 COMMONWEALTH AVE | ward-7 | Traffic Signal Light Out | 51171 | inactive | 2024-07-12 09:45 | 2024-07-12 | 42.336412 | -71.192857 |
| 1980 | 1980 | COMMONWEALTH AVENUE MEDIAN | ward-2 | Traffic Signal Light Out | 51171 | inactive | 2024-07-04 14:15 | 2024-07-08 | 42.338232 | -71.20928 |
| 746 | 746 | 333 NAHANTON ST | ward-8 | Traffic Signal Light Out | 51171 | inactive | 2024-06-20 | 2024-06-20 | 42.299379 | -71.204223 |
| 585 | 585 | 431 WASHINGTON ST | ward-1 | Traffic Signal Light Out | 51171 | inactive | 2024-06-17 | 2024-06-17 | 42.355952 | -71.190472 |
| 504 | 504 | BEACON ST | Traffic Signal Light Out | 51171 | inactive | 2024-06-14 | 2024-06-17 | |||
| 412 | 412 | 2077 MASSACHUSETTS 16 | ward-4 | Traffic Signal Light Out | 51171 | inactive | 2024-06-17 | 42.330252 | -71.24836 |
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]);