_locations
13 rows where category_id = 53463
This data as json, CSV (advanced)
Suggested facets: ward, added, removed, active, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 26587 | 26587 | 1516 WASHINGTON ST | 42.345639 | -71.233178 | 53463 | 3 | 2026-02-19 | 2026-03-03 | 0 |
| 26588 | 26588 | 1522 WASHINGTON ST | 42.345342 | -71.233614 | 53463 | 3 | 2026-02-19 | 2026-03-03 | 0 |
| 26589 | 26589 | 170 WALTHAM ST | 42.361254 | -71.223156 | 53463 | 3 | 2026-02-19 | 1 | |
| 26590 | 26590 | 181 UPLAND RD | 42.344316 | -71.199995 | 53463 | 2 | 2026-02-19 | 2026-03-09 | 0 |
| 26591 | 26591 | 193 OAK STREET | 42.307596 | -71.216689 | 53463 | 5 | 2026-02-19 | 1 | |
| 26592 | 26592 | 325 LOWELL AVE | 42.346095 | -71.211279 | 53463 | 2 | 2026-02-19 | 1 | |
| 26593 | 26593 | 329 LEXINGTON ST | 42.3509 | -71.246797 | 53463 | 4 | 2026-02-19 | 1 | |
| 26594 | 26594 | 436 DUDLEY RD | 42.307704 | -71.179475 | 53463 | 8 | 2026-02-19 | 1 | |
| 26595 | 26595 | 6 SPAULDING LN | 42.302628 | -71.176284 | 53463 | 8 | 2026-02-19 | 1 | |
| 26660 | 26660 | 337 CENTRAL ST | 42.342471 | -71.253756 | 53463 | 4 | 2026-02-21 | 2026-02-26 | 0 |
| 27861 | 27861 | 270 UPLAND ROAD | 42.342624 | -71.203042 | 53463 | 2 | 2026-03-05 | 2026-03-09 | 0 |
| 28132 | 28132 | 90 OAK STREET | 42.309806 | -71.220565 | 53463 | 5 | 2026-03-06 | 1 | |
| 28223 | 28223 | 48 DANIEL ST | 42.321879 | -71.193155 | 53463 | 6 | 2026-03-09 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [_locations] ( [location] TEXT, [latitude] FLOAT, [longitude] FLOAT, [category_id] TEXT REFERENCES [categories]([id]), [ward] INTEGER, [added] TEXT, [removed] TEXT, [active] INTEGER );