_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 |
|---|---|---|---|---|---|---|---|---|---|
| 3417 | 3417 | 22 CAROLINE PARK | 42.332715 | -71.225673 | 53220 | 5 | 2024-07-31 11:15 | 2024-08-02 | 0 |
| 3814 | 3814 | 36 ELINOR RD | 42.315033 | -71.200219 | 53220 | 6 | 2024-08-07 14:15 | 2024-08-12 | 0 |
| 14972 | 14972 | 73 AUBURN ST | 42.345171 | -71.2377 | 53220 | 3 | 2025-02-18 13:00 | 2025-02-18 | 0 |
| 15449 | 15449 | 212 TREMONT ST | 42.352857 | -71.17713 | 53220 | 1 | 2025-02-26 07:15 | 2025-02-27 | 0 |
| 16387 | 16387 | 142 RANDLETT PARK | 42.355116 | -71.222675 | 53220 | 3 | 2025-03-15 14:30 | 2025-03-17 | 0 |
| 16466 | 16466 | 80 UNION ST | 42.329412 | -71.192871 | 53220 | 6 | 2025-03-17 16:15 | 2025-03-18 | 0 |
| 25672 | 25672 | 10 WINCHESTER ST | 42.318873 | -71.207591 | 53220 | 5 | 2025-08-25 12:30 | 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 );