home / n311

locations

14 rows where category_id = 51108 sorted by added 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
27025 27025 325 BOYLSTON ST 6 Snow - MBTA Stop Issues 51108   2026-02-25 2026-02-25 42.319503 -71.181752
26151 26151 7 OAK ST 5 Snow - MBTA Stop Issues 51108   2026-02-11 2026-02-11 42.312447 -71.221325
26074 26074 145 WASHINGTON ST 1 Snow - MBTA Stop Issues 51108   2026-02-09 2026-02-10 42.356115 -71.179799
25880 25880 104 NEEDHAM STREET 8 Snow - MBTA Stop Issues 51108   2026-02-05 2026-02-05 42.313871 -71.211437
25895 25895 104 NEEDHAM ST 8 Snow - MBTA Stop Issues 51108   2026-02-05 2026-02-06 42.313788 -71.211263
25748 25748 925 CENTRE ST 2 Snow - MBTA Stop Issues 51108   2026-02-04 2026-02-04 42.340626 -71.192975
25781 25781 344 RIVER ST 4 Snow - MBTA Stop Issues 51108   2026-02-04 2026-02-09 42.357618 -71.239541
25782 25782 73 LEXINGTON ST 4 Snow - MBTA Stop Issues 51108   2026-02-04 2026-02-09 42.357663 -71.239937
25798 25798 1299 CENTRE ST 6 Snow - MBTA Stop Issues 51108   2026-02-04 2026-02-04 42.329583 -71.19536
25393 25393 4 JUDITH ROAD 6 Snow - MBTA Stop Issues 51108   2026-01-31 2026-02-02 42.335677 -71.207097
25063 25063 50 STATION AVENUE 6 Snow - MBTA Stop Issues 51108   2026-01-29 2026-01-29 42.322361 -71.205554
24849 24849 1 NEWTON PL 1 Snow - MBTA Stop Issues 51108   2026-01-28 2026-01-28 42.357762 -71.185122
24869 24869 135 AUBURN ST 4 Snow - MBTA Stop Issues 51108   2026-01-28 2026-01-29 42.344784 -71.240625
9199 9199 AUBURNDALE 4 Snow - MBTA Stop Issues 51108   2025-01-13 2025-01-13 42.346388 -71.24684

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "locations" (
   [location] TEXT,
   [ward] INTEGER,
   [category] TEXT,
   [category_id] TEXT REFERENCES [categories]([id]),
   [active] TEXT,
   [added] TEXT,
   [removed] TEXT,
   [latitude] FLOAT,
   [longitude] FLOAT
);
Powered by Datasette · Queries took 509.502ms