_locations
7 rows where category_id = 53220
This data as json, CSV (advanced)
Suggested facets: ward, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 2546 | 2546 | 22 CAROLINE PARK | 42.332715 | -71.225673 | 53220 | 5 | 2024-07-31 | 2024-08-02 | 0 |
| 2825 | 2825 | 36 ELINOR RD | 42.315033 | -71.200219 | 53220 | 6 | 2024-08-07 | 2024-08-12 | 0 |
| 10753 | 10753 | 73 AUBURN ST | 42.345171 | -71.2377 | 53220 | 3 | 2025-02-18 | 2025-02-18 | 0 |
| 11137 | 11137 | 212 TREMONT ST | 42.352857 | -71.17713 | 53220 | 1 | 2025-02-26 | 2025-02-27 | 0 |
| 11795 | 11795 | 142 RANDLETT PARK | 42.355116 | -71.222675 | 53220 | 3 | 2025-03-15 | 2025-03-17 | 0 |
| 11857 | 11857 | 80 UNION ST | 42.329412 | -71.192871 | 53220 | 6 | 2025-03-17 | 2025-03-18 | 0 |
| 18794 | 18794 | 10 WINCHESTER ST | 42.318873 | -71.207591 | 53220 | 5 | 2025-08-25 | 2025-08-27 | 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 );