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