locations
6 rows where category_id = 57893 sorted by added descending
This data as json, CSV (advanced)
Suggested facets: ward, active, added (date), removed (date)
| Link | rowid | location | ward | category | category_id | active | added ▲ | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 19549 | 19549 | 200 COMMONWEALTH AVE | 7 | Guardrail - Repairs | 57893 | 2025-09-15 | 2025-11-03 | 42.337008 | -71.174205 | |
| 15783 | 15783 | 301 ELLIOT ST | 5 | Guardrail - Repairs | 57893 | 2025-06-19 | 2025-06-26 | 42.312915 | -71.221487 | |
| 13662 | 13662 | 1781 COMMONWEALTH AVENUE | 4 | Guardrail - Repairs | 57893 | active | 2025-05-07 | 42.341784 | -71.239327 | |
| 12072 | 12072 | 65 ELLIS STREET | 5 | Guardrail - Repairs | 57893 | 2025-03-25 | 2025-03-31 | 42.314752 | -71.225937 | |
| 8989 | 8989 | 77 PAUL ST | 6 | Guardrail - Repairs | 57893 | 2025-01-07 | 2025-01-10 | 42.326666 | -71.197314 | |
| 6693 | 6693 | 9 BONWOOD ST | 2 | Guardrail - Repairs | 57893 | 2024-11-07 | 2025-04-01 | 42.347376 | -71.201537 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "locations" ( [location] TEXT, [ward] INTEGER, [category] TEXT, [category_id] TEXT REFERENCES [categories]([id]), [active] TEXT, [added] TEXT, [removed] TEXT, [latitude] FLOAT, [longitude] FLOAT );