home / n311

locations

4 rows where category_id = 66937 sorted by added descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid location ward category category_id active added ▲ removed latitude longitude
22893 22893 351 WAVERLEY AVE 7 Remove Advertisement 66937   2025-12-14 2025-12-16 42.343992 -71.182467
22692 22692 1400 COMMONWEALTH AVE 3 Remove Advertisement 66937   2025-12-08 2025-12-09 42.336477 -71.22416
22693 22693 389 WOODWARD ST 5 Remove Advertisement 66937   2025-12-08 2025-12-09 42.326316 -71.226653
22497 22497 1000 COMMONWEALTH AVE 2 Remove Advertisement 66937   2025-12-02 2025-12-02 42.337377 -71.208617

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 153.665ms