_locations

4 rows where category_id = 66937

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ location latitude longitude category_id ward added removed active
30640 30640 1000 COMMONWEALTH AVE 42.337377 -71.208617 66937 2   2025-12-02 0
30888 30888 1400 COMMONWEALTH AVE 42.336477 -71.22416 66937 3 2025-12-08 14:15 2025-12-09 0
30889 30889 389 WOODWARD ST 42.326316 -71.226653 66937 5 2025-12-08 14:15 2025-12-09 0
31169 31169 351 WAVERLEY AVE 42.343992 -71.182467 66937 7 2025-12-14 14:15 2025-12-16 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [_locations] (
   [location] TEXT,
   [latitude] FLOAT,
   [longitude] FLOAT,
   [category_id] TEXT REFERENCES [categories]([id]),
   [ward] INTEGER,
   [added] TEXT,
   [removed] TEXT,
   [active] INTEGER
);