locations

1 row where category_id = 51108 sorted by added descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid location ward category category_id active added ▲ removed latitude longitude
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
);