_locations
1 row where category_id = 51070
This data as json, CSV (advanced)
Suggested facets: added (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 19028 | 19028 | 426 HOMER ST | 42.337602 | -71.211681 | 51070 | 2 | 2025-09-02 | 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 );