_locations
6 rows where category_id = 51122
This data as json, CSV (advanced)
Suggested facets: ward, removed, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 13038 | 13038 | 113 GROVE STREET | 42.342538 | -71.249121 | 51122 | 4 | 2025-01-13 08:30 | 2025-01-13 | 0 |
| 13051 | 13051 | 99 HANCOCK STREET | 42.343044 | -71.250769 | 51122 | 4 | 2025-01-13 09:30 | 2025-01-14 | 0 |
| 13057 | 13057 | 2 ELM ROAD | 42.345988 | -71.208326 | 51122 | 2 | 2025-01-13 10:00 | 2025-01-14 | 0 |
| 13178 | 13178 | 170 TEMPLE STREET | 42.342097 | -71.231183 | 51122 | 3 | 2025-01-15 10:00 | 2025-01-16 | 0 |
| 13483 | 13483 | 149 PLEASANT ST | 42.332508 | -71.199644 | 51122 | 6 | 2025-01-22 09:30 | 2025-01-22 | 0 |
| 13503 | 13503 | 687 WATERTOWN ST | 42.35463 | -71.21349 | 51122 | 2 | 2025-01-22 11:30 | 2025-01-23 | 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 );