_locations
4 rows where category_id = 51034
This data as json, CSV (advanced)
Suggested facets: added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 3293 | 3293 | 33 MAPLE AVE | 42.353444 | -71.188974 | 51034 | 1 | 2024-07-29 12:30 | 2024-09-25 | 0 |
| 17010 | 17010 | 32 LANGLEY RD | 42.330879 | -71.193051 | 51034 | 6 | 2025-03-28 11:45 | 2025-03-31 | 0 |
| 17799 | 17799 | 91 WINSTON RD | 42.310494 | -71.185118 | 51034 | 8 | 2025-04-14 18:45 | 2025-04-15 | 0 |
| 22349 | 22349 | 55 BORDER ST | 42.348519 | -71.231904 | 51034 | 3 | 2025-06-30 11:45 | 2025-06-30 | 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 );