requests
57 rows where category_id = 53462 sorted by rowid 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 30802 | 30802 | 45 WETHERELL ST | ward-5 | Flooding | 53462 | active | 2025-12-05 08:30 | 42.311844 | -71.217234 | |
| 28745 | 28745 | 12 RICHARDSON RD | ward-5 | Flooding | 53462 | active | 2025-10-24 14:45 | 42.317604 | -71.224745 | |
| 28640 | 28640 | 5 VOSS TER | ward-8 | Flooding | 53462 | active | 2025-10-22 13:15 | 42.310413 | -71.194707 | |
| 28580 | 28580 | 20 PARK PL | ward-2 | Flooding | 53462 | active | 2025-10-22 08:45 | 42.348501 | -71.204625 | |
| 28502 | 28502 | 71 WISWALL RD | ward-8 | Flooding | 53462 | active | 2025-10-20 16:30 | 42.296445 | -71.1869 | |
| 28477 | 28477 | 547 WASHINGTON ST | ward-1 | Flooding | 53462 | active | 2025-10-20 13:00 | 42.355125 | -71.195589 | |
| 28473 | 28473 | 77 FLORENCE ST | ward-8 | Flooding | 53462 | active | 2025-10-20 12:45 | 42.317577 | -71.179443 | |
| 28468 | 28468 | 44 HEREWARD RD | ward-6 | Flooding | 53462 | active | 2025-10-20 11:30 | 42.325038 | -71.197268 | |
| 28466 | 28466 | 1 CROFTDALE RD | ward-7 | Flooding | 53462 | active | 2025-10-20 11:15 | 42.334389 | -71.184326 | |
| 28464 | 28464 | 785 CENTRE ST | ward-2 | Flooding | 53462 | active | 2025-10-20 11:00 | 42.345387 | -71.191868 | |
| 28158 | 28158 | 45 BISHOPSGATE RD | ward-7 | Flooding | 53462 | active | 2025-10-14 10:30 | 42.334515 | -71.183475 | |
| 28117 | 28117 | 125 FALMOUTH RD | ward-3 | Flooding | 53462 | active | 2025-10-13 16:30 | 42.360849 | -71.231004 | |
| 28084 | 28084 | 181 A PEARL STREET | ward-1 | Flooding | 53462 | active | 2025-10-11 20:45 | 42.359196 | -71.193718 | |
| 28078 | 28078 | 39 NORWOOD AVE | ward-6 | Flooding | 53462 | active | 2025-10-11 15:15 | 42.328314 | -71.19873 | |
| 27932 | 27932 | 855 CENTRE STREET | ward-2 | Flooding | 53462 | inactive | 2025-10-08 10:00 | 2025-10-10 | 42.342751 | -71.191969 |
| 27929 | 27929 | 1720 COMMONWEALTH AVE | ward-4 | Flooding | 53462 | active | 2025-10-08 09:30 | 42.340032 | -71.23761 | |
| 27312 | 27312 | 24 BRENTWOOD AVE | ward-6 | Flooding | 53462 | active | 2025-09-25 23:45 | 42.332184 | -71.205453 | |
| 26274 | 26274 | 58 CIRCUIT AVE | ward-5 | Flooding | 53462 | inactive | 2025-09-07 10:45 | 2025-09-13 | 42.316407 | -71.215718 |
| 26240 | 26240 | 180 WINCHESTER ST | ward-8 | Flooding | 53462 | inactive | 2025-09-05 16:00 | 2025-10-07 | 42.313869 | -71.208837 |
| 25644 | 25644 | 98 BRANDEIS RD | ward-8 | Flooding | 53462 | inactive | 2025-08-24 14:15 | 2025-08-25 | 42.314562 | -71.190981 |
| 23117 | 23117 | 35 DARTMOUTH STREET | ward-3 | Flooding | 53462 | active | 2025-07-11 14:45 | 42.338199 | -71.226012 | |
| 20767 | 20767 | 9 BRANDEIS RD | ward-8 | Flooding | 53462 | inactive | 2025-06-05 12:45 | 2025-07-16 | 42.312384 | -71.193537 |
| 20395 | 20395 | 28 WINSTON ROAD | ward-8 | Flooding | 53462 | inactive | 2025-06-01 15:30 | 2025-07-08 | 42.311664 | -71.18901 |
| 19647 | 19647 | 8 BURTON AVE | ward-1 | Flooding | 53462 | inactive | 2025-05-19 18:00 | 2025-05-27 | 42.357492 | -71.201642 |
| 18916 | 18916 | 15 WILTON RD | ward-2 | Flooding | 53462 | inactive | 2025-05-06 15:00 | 2025-07-09 | 42.353658 | -71.205359 |
| 17401 | 17401 | 4 GEORGE ST | ward-7 | Flooding | 53462 | inactive | 2025-04-07 15:15 | 2025-04-08 | 42.347538 | -71.186288 |
| 17325 | 17325 | 89-93 OAK STREET | ward-5 | Flooding | 53462 | inactive | 2025-04-04 16:15 | 2025-04-08 | 42.309436 | -71.220551 |
| 17248 | 17248 | 17 ROSSMERE ST | ward-2 | Flooding | 53462 | inactive | 2025-04-03 13:00 | 2025-04-08 | 42.355026 | -71.209836 |
| 17126 | 17126 | 59 SOUTH GATE PARK | ward-3 | Flooding | 53462 | inactive | 2025-04-01 01:30 | 2025-06-02 | 42.354915 | -71.226645 |
| 16749 | 16749 | 25 GOULD ROAD | ward-5 | Flooding | 53462 | inactive | 2025-03-25 08:45 | 2025-03-28 | 42.322796 | -71.233941 |
| 16644 | 16644 | 18 DUNSTAN ST | ward-3 | Flooding | 53462 | inactive | 2025-03-21 11:00 | 2025-03-21 | 42.350247 | -71.222112 |
| 16514 | 16514 | 235 CYPRESS ST | ward-6 | Flooding | 53462 | inactive | 2025-03-18 14:00 | 2025-03-18 | 42.322653 | -71.189226 |
| 16513 | 16513 | 193 PLEASANT ST | ward-6 | Flooding | 53462 | inactive | 2025-03-18 14:00 | 2025-03-18 | 42.333561 | -71.201255 |
| 16442 | 16442 | 15 MAPLE AVE | ward-1 | Flooding | 53462 | inactive | 2025-03-17 11:45 | 2025-03-17 | 42.353937 | -71.188718 |
| 16424 | 16424 | 69 LAKEVIEW AVENUE | ward-2 | Flooding | 53462 | inactive | 2025-03-17 08:45 | 2025-06-02 | 42.338056 | -71.209221 |
| 16079 | 16079 | 18 INDIANA TER | ward-5 | Flooding | 53462 | inactive | 2025-03-10 08:45 | 2025-03-12 | 42.30999 | -71.221505 |
| 15997 | 15997 | 17 INDIANA TER | ward-5 | Flooding | 53462 | inactive | 2025-03-08 10:30 | 2025-03-12 | 42.310314 | -71.221581 |
| 15844 | 15844 | 41 WESTCHESTER RD | ward-2 | Flooding | 53462 | inactive | 2025-03-06 16:15 | 2025-03-12 | 42.346612 | -71.196937 |
| 14734 | 14734 | 14 WEBSTER ST | ward-3 | Flooding | 53462 | inactive | 2025-02-16 12:00 | 2025-04-16 | 42.3504 | -71.227008 |
| 14614 | 14614 | 11 BLUEBERRY CIR | ward-4 | Flooding | 53462 | inactive | 2025-02-13 15:45 | 2025-02-21 | 42.330465 | -71.256956 |
| 13159 | 13159 | 9 OAK AVE | ward-3 | Flooding | 53462 | inactive | 2025-01-15 08:30 | 2025-01-16 | 42.352338 | -71.232882 |
| 12009 | 12009 | 99 GATE HOUSE RD | ward-7 | Flooding | 53462 | inactive | 2024-12-21 17:45 | 2025-02-25 | 42.330922 | -71.165792 |
| 11421 | 11421 | 62 CLINTON PL | ward-2 | Flooding | 53462 | active | 2024-12-10 14:30 | 42.339635 | -71.194457 | |
| 10780 | 10780 | 19 DALBY ST | ward-1 | Flooding | 53462 | inactive | 2024-11-28 16:15 | 2025-04-08 | 42.364297 | -71.200683 |
| 10779 | 10779 | 1100 BOYLSTON ST | ward-5 | Flooding | 53462 | inactive | 2024-11-28 13:30 | 2024-12-06 | 42.31799 | -71.217264 |
| 10471 | 10471 | 41 WESTCHESTER RD | ward-2 | Flooding | 53462 | inactive | 2024-11-22 09:30 | 2024-11-26 | 42.346612 | -71.196937 |
| 7351 | 7351 | 8 FREDANA RD | ward-5 | Flooding | 53462 | active | 2024-10-17 14:30 | 42.331448 | -71.227518 | |
| 7287 | 7287 | 67 LINDBERGH AVE | ward-3 | Flooding | 53462 | inactive | 2024-10-17 12:15 | 2024-11-06 | 42.353799 | -71.225942 |
| 5461 | 5461 | NAHANTON PARK | ward-8 | Flooding | 53462 | inactive | 2024-09-06 16:30 | 2024-09-11 | 42.298349 | -71.208303 |
| 5050 | 5050 | 467 NAHANTON STREET | ward-8 | Flooding | 53462 | inactive | 2024-08-28 11:00 | 2024-08-29 | 42.297344 | -71.207086 |
| 4667 | 4667 | 194 OAK STREET | ward-5 | Flooding | 53462 | inactive | 2024-08-20 14:45 | 2024-08-21 | 42.307581 | -71.216539 |
| 4253 | 4253 | 42 TRUMAN RD | ward-8 | Flooding | 53462 | inactive | 2024-08-13 06:30 | 2024-08-13 | 42.314543 | -71.197122 |
| 4142 | 4142 | 30 PINE CREST ROAD | ward-6 | Flooding | 53462 | inactive | 2024-08-12 07:15 | 2024-08-19 | 42.328888 | -71.205198 |
| 4135 | 4135 | 394 NAHANTON STREET | ward-8 | Flooding | 53462 | inactive | 2024-08-11 12:15 | 2024-08-21 | 42.297317 | -71.207294 |
| 2204 | 2204 | 120 OLDE FIELD RD | ward-8 | Flooding | 53462 | inactive | 2024-07-08 23:30 | 2024-09-23 | 42.314973 | -71.191299 |
| 1553 | 1553 | 51 SEVLAND RD | ward-8 | Flooding | 53462 | inactive | 2024-06-26 | 2024-07-11 | 42.307052 | -71.184791 |
| 1146 | 1146 | 250 LAGRANGE STREET | ward-8 | Flooding | 53462 | inactive | 2024-06-24 | 42.302687 | -71.167762 |
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]);