_locations
8 rows where category_id = 51095
This data as json, CSV (advanced)
Suggested facets: ward, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 4759 | 4759 | 65-67 BRIDGE STREET | 42.362843 | -71.203106 | 51095 | 1 | 2024-08-21 21:15 | 2024-08-22 | 0 |
| 12642 | 12642 | 1479 WASHINGTON STREET | 42.346962 | -71.2318 | 51095 | 3 | 2025-01-06 01:00 | 2025-01-06 | 0 |
| 17056 | 17056 | 1025 WALNUT ST | 42.326343 | -71.206646 | 51095 | 6 | 2025-03-29 19:00 | 2025-03-31 | 0 |
| 22669 | 22669 | 16 ALBEMARLE RD | 42.364206 | -71.213369 | 51095 | 2 | 2025-07-05 21:00 | 2025-07-09 | 0 |
| 22671 | 22671 | 131 COUNTRY CLUB RD | 42.305238 | -71.190392 | 51095 | 8 | 2025-07-06 00:15 | 2025-07-08 | 0 |
| 25617 | 25617 | 100 LOS ANGELES ST | 42.363396 | -71.196435 | 51095 | 1 | 2025-08-22 14:30 | 2025-08-26 | 0 |
| 26797 | 26797 | 22 LINCOLN ST | 42.321456 | -71.206997 | 51095 | 6 | 2025-09-16 10:30 | 2025-09-17 | 0 |
| 28094 | 28094 | 211 PLYMOUTH RD | 42.322932 | -71.215389 | 51095 | 5 | 2025-10-12 17:30 | 2025-10-14 | 0 |
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 );