locations

13 rows where category_id = 53463 sorted by added descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid location ward category category_id active added ▲ removed latitude longitude
28223 28223 48 DANIEL ST 6 Gate Covers 53463 active 2026-03-09   42.321879 -71.193155
28132 28132 90 OAK STREET 5 Gate Covers 53463 active 2026-03-06   42.309806 -71.220565
27861 27861 270 UPLAND ROAD 2 Gate Covers 53463   2026-03-05 2026-03-09 42.342624 -71.203042
26660 26660 337 CENTRAL ST 4 Gate Covers 53463   2026-02-21 2026-02-26 42.342471 -71.253756
26587 26587 1516 WASHINGTON ST 3 Gate Covers 53463   2026-02-19 2026-03-03 42.345639 -71.233178
26588 26588 1522 WASHINGTON ST 3 Gate Covers 53463   2026-02-19 2026-03-03 42.345342 -71.233614
26589 26589 170 WALTHAM ST 3 Gate Covers 53463 active 2026-02-19   42.361254 -71.223156
26590 26590 181 UPLAND RD 2 Gate Covers 53463   2026-02-19 2026-03-09 42.344316 -71.199995
26591 26591 193 OAK STREET 5 Gate Covers 53463 active 2026-02-19   42.307596 -71.216689
26592 26592 325 LOWELL AVE 2 Gate Covers 53463 active 2026-02-19   42.346095 -71.211279
26593 26593 329 LEXINGTON ST 4 Gate Covers 53463 active 2026-02-19   42.3509 -71.246797
26594 26594 436 DUDLEY RD 8 Gate Covers 53463 active 2026-02-19   42.307704 -71.179475
26595 26595 6 SPAULDING LN 8 Gate Covers 53463 active 2026-02-19   42.302628 -71.176284

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
);