home / n311

requests

15 rows where category_id = 51108 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ward, added, removed, added (date), removed (date)

Link rowid ▲ location ward category category_id active added removed latitude longitude
36617 36617 81 ALBEMARLE RD ward-3 Snow - MBTA Stop Issues 51108 inactive 2026-02-27 14:00 2026-02-27 42.362784 -71.214917
36190 36190 325 BOYLSTON ST ward-6 Snow - MBTA Stop Issues 51108 inactive 2026-02-25 11:45 2026-02-25 42.319503 -71.181752
35168 35168 7 OAK ST ward-5 Snow - MBTA Stop Issues 51108 inactive 2026-02-11 08:45 2026-02-11 42.312447 -71.221325
35068 35068 145 WASHINGTON ST ward-1 Snow - MBTA Stop Issues 51108 inactive 2026-02-09 15:45 2026-02-10 42.356115 -71.179799
34849 34849 104 NEEDHAM ST ward-8 Snow - MBTA Stop Issues 51108 inactive 2026-02-05 14:30 2026-02-06 42.313788 -71.211263
34832 34832 104 NEEDHAM STREET ward-8 Snow - MBTA Stop Issues 51108 inactive 2026-02-05 13:30 2026-02-05 42.313871 -71.211437
34734 34734 1299 CENTRE ST ward-6 Snow - MBTA Stop Issues 51108 inactive 2026-02-04 13:30 2026-02-04 42.329583 -71.19536
34705 34705 73 LEXINGTON ST ward-4 Snow - MBTA Stop Issues 51108 inactive 2026-02-04 10:00 2026-02-09 42.357663 -71.239937
34704 34704 344 RIVER ST ward-4 Snow - MBTA Stop Issues 51108 inactive 2026-02-04 10:00 2026-02-09 42.357618 -71.239541
34677 34677 925 CENTRE ST ward-2 Snow - MBTA Stop Issues 51108 inactive 2026-02-03 22:30 2026-02-04 42.340626 -71.192975
34273 34273 4 JUDITH ROAD ward-6 Snow - MBTA Stop Issues 51108 inactive 2026-01-31 16:00 2026-02-02 42.335677 -71.207097
33904 33904 50 STATION AVENUE ward-6 Snow - MBTA Stop Issues 51108 inactive 2026-01-29 08:30 2026-01-29 42.322361 -71.205554
33676 33676 135 AUBURN ST ward-4 Snow - MBTA Stop Issues 51108 inactive 2026-01-28 08:15 2026-01-29 42.344784 -71.240625
33675 33675 1 NEWTON PL ward-1 Snow - MBTA Stop Issues 51108 inactive 2026-01-28 08:00 2026-01-28 42.357762 -71.185122
13040 13040 AUBURNDALE ward-4 Snow - MBTA Stop Issues 51108 inactive 2025-01-13 08:30 2025-01-13 42.346388 -71.24684

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);
Powered by Datasette · Queries took 1358.688ms