_locations
1 row where category_id = 51108
This data as json, CSV (advanced)
Suggested facets: added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 9199 | 9199 | AUBURNDALE | 42.346388 | -71.24684 | 51108 | 4 | 2025-01-13 | 2025-01-13 | 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 );