requests
39 rows where category_id = 53467 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: ward, active, removed, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 31483 | 31483 | 24 CHAPIN RD | ward-6 | Water Sewer Bill Question | 53467 | inactive | 2025-12-19 12:15 | 2025-12-22 | 42.333876 | -71.200472 |
| 30977 | 30977 | 19 BERNARD ST | ward-8 | Water Sewer Bill Question | 53467 | inactive | 2025-12-10 10:00 | 2025-12-10 | 42.305562 | -71.211776 |
| 27626 | 27626 | 151 COUNTRY CLUB RD | ward-8 | Water Sewer Bill Question | 53467 | inactive | 2025-10-01 13:45 | 2025-11-03 | 42.304878 | -71.189906 |
| 27480 | 27480 | 36 NARDELL RD | ward-8 | Water Sewer Bill Question | 53467 | inactive | 2025-09-29 16:15 | 2025-09-30 | 42.309063 | -71.179641 |
| 27142 | 27142 | 31 STUART RD | ward-7 | Water Sewer Bill Question | 53467 | inactive | 2025-09-23 11:15 | 2025-09-24 | 42.340311 | -71.184326 |
| 26252 | 26252 | 43 BLAKE ST | ward-2 | Water Sewer Bill Question | 53467 | inactive | 2025-09-05 18:45 | 2025-09-08 | 42.346746 | -71.1986 |
| 25514 | 25514 | 17 TUDOR TER | ward-4 | Water Sewer Bill Question | 53467 | inactive | 2025-08-21 06:45 | 2025-08-22 | 42.349212 | -71.243042 |
| 25312 | 25312 | 14 LESLIE RD | ward-4 | Water Sewer Bill Question | 53467 | inactive | 2025-08-16 10:00 | 2025-08-18 | 42.339042 | -71.239428 |
| 23230 | 23230 | 80 CROSS HILL RD | ward-8 | Water Sewer Bill Question | 53467 | inactive | 2025-07-14 14:30 | 2025-07-16 | 42.305319 | -71.186904 |
| 20809 | 20809 | 29 PRAIRIE AVE | ward-4 | Water Sewer Bill Question | 53467 | inactive | 2025-06-06 07:00 | 2025-06-06 | 42.349617 | -71.23964 |
| 20516 | 20516 | 19 OHIO AVE | ward-5 | Water Sewer Bill Question | 53467 | inactive | 2025-06-03 06:30 | 2025-06-03 | 42.311691 | -71.221968 |
| 20512 | 20512 | 51 WALDORF RD | ward-5 | Water Sewer Bill Question | 53467 | inactive | 2025-06-02 19:30 | 2025-06-03 | 42.318909 | -71.219345 |
| 19512 | 19512 | 1385 WASHINGTON ST | ward-3 | Water Sewer Bill Question | 53467 | inactive | 2025-05-16 15:30 | 2025-05-19 | 42.348681 | -71.229776 |
| 17877 | 17877 | 49 GLENDALE RD | ward-7 | Water Sewer Bill Question | 53467 | active | 2025-04-15 19:30 | 42.339564 | -71.188785 | |
| 16531 | 16531 | 71 ANDREW ST | ward-8 | Water Sewer Bill Question | 53467 | inactive | 2025-03-18 22:00 | 2025-03-24 | 42.312969 | -71.205305 |
| 15482 | 15482 | 41 SOMERSET RD | ward-2 | Water Sewer Bill Question | 53467 | inactive | 2025-02-26 11:45 | 2025-02-27 | 42.344442 | -71.217635 |
| 15276 | 15276 | 87 LINCOLN ST | ward-6 | Water Sewer Bill Question | 53467 | inactive | 2025-02-23 10:30 | 2025-02-27 | 42.321456 | -71.209683 |
| 15261 | 15261 | 39 BELLEVUE ST | ward-1 | Water Sewer Bill Question | 53467 | inactive | 2025-02-21 18:45 | 2025-02-27 | 42.350679 | -71.188353 |
| 14525 | 14525 | 294 CABOT ST | ward-2 | Water Sewer Bill Question | 53467 | inactive | 2025-02-11 14:15 | 2025-02-13 | 42.347907 | -71.202222 |
| 13846 | 13846 | 71 ANDREW ST | ward-8 | Water Sewer Bill Question | 53467 | inactive | 2025-01-28 16:45 | 2025-01-30 | 42.312969 | -71.205305 |
| 13477 | 13477 | 15 CONCOLOR AVE | ward-2 | Water Sewer Bill Question | 53467 | inactive | 2025-01-22 08:30 | 2025-01-30 | 42.348519 | -71.190747 |
| 12230 | 12230 | 44 WOODBINE ST | ward-4 | Water Sewer Bill Question | 53467 | inactive | 2024-12-25 12:30 | 2025-01-30 | 42.346286 | -71.252936 |
| 10359 | 10359 | 30 NICKERSON RD | ward-8 | Water Sewer Bill Question | 53467 | inactive | 2024-11-20 09:30 | 2024-11-22 | 42.306676 | -71.175369 |
| 7963 | 7963 | 33 ELIOT MEMORIAL RD | ward-7 | Water Sewer Bill Question | 53467 | inactive | 2024-10-22 16:00 | 2024-10-22 | 42.344866 | -71.179904 |
| 7213 | 7213 | 495 WATERTOWN ST | ward-1 | Water Sewer Bill Question | 53467 | inactive | 2024-10-16 12:45 | 2024-10-22 | 42.358041 | -71.205489 |
| 6750 | 6750 | 64 LINCOLN RD | ward-1 | Water Sewer Bill Question | 53467 | inactive | 2024-10-04 15:30 | 2024-10-08 | 42.355229 | -71.200304 |
| 6578 | 6578 | 10 LAUREL ST | ward-6 | Water Sewer Bill Question | 53467 | inactive | 2024-09-30 17:15 | 2024-10-22 | 42.330242 | -71.20103 |
| 6224 | 6224 | 77 DORCAR RD | ward-8 | Water Sewer Bill Question | 53467 | inactive | 2024-09-23 17:45 | 2024-09-26 | 42.301212 | -71.175231 |
| 6223 | 6223 | 24 SAGAMORE RD | ward-5 | Water Sewer Bill Question | 53467 | inactive | 2024-09-23 17:45 | 2024-09-26 | 42.326222 | -71.216219 |
| 5904 | 5904 | 61 LANGDON ST | ward-1 | Water Sewer Bill Question | 53467 | inactive | 2024-09-16 11:00 | 2024-09-23 | 42.350237 | -71.193723 |
| 5641 | 5641 | 1334 WALNUT ST | ward-5 | Water Sewer Bill Question | 53467 | inactive | 2024-09-10 18:00 | 2024-09-23 | 42.316936 | -71.20231 |
| 4384 | 4384 | 1215 COMMONWEALTH AVE | ward-2 | Water Sewer Bill Question | 53467 | inactive | 2024-08-14 20:00 | 2024-09-23 | 42.337318 | -71.216558 |
| 3287 | 3287 | 85 HYDE AVE | ward-7 | Water Sewer Bill Question | 53467 | inactive | 2024-07-29 11:45 | 2024-09-23 | 42.347329 | -71.186363 |
| 2578 | 2578 | 172 CABOT STREET | ward-2 | Water Sewer Bill Question | 53467 | inactive | 2024-07-15 16:45 | 2024-09-23 | 42.347509 | -71.19669 |
| 2419 | 2419 | 1000 COMMONWEALTH AVE | ward-2 | Water Sewer Bill Question | 53467 | inactive | 2024-07-11 14:30 | 2024-07-11 | 42.337381 | -71.208615 |
| 1772 | 1772 | 29 WALTER ST | ward-6 | Water Sewer Bill Question | 53467 | inactive | 2024-07-01 10:00 | 2024-09-23 | 42.321386 | -71.192879 |
| 1414 | 1414 | 99 SHADY HILL RD | ward-5 | Water Sewer Bill Question | 53467 | inactive | 2024-06-25 | 2024-09-23 | 42.318408 | -71.204888 |
| 1152 | 1152 | 34 BROOKSIDE AVE | ward-2 | Water Sewer Bill Question | 53467 | inactive | 2024-09-23 | 42.353033 | -71.213445 | |
| 1151 | 1151 | 195 VARICK ROAD | ward-5 | Water Sewer Bill Question | 53467 | inactive | 2024-09-23 | 42.323774 | -71.245559 |
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]);