locations
8 rows where category_id = 51113 sorted by added descending
This data as json, CSV (advanced)
Suggested facets: ward, removed, added (date), removed (date)
| Link | rowid | location | ward | category | category_id | active | added ▲ | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 14844 | 14844 | 52 BERNARD ST | 8 | Snow - Property Damage | 51113 | 2025-06-02 | 2025-07-31 | 42.304797 | -71.210295 | |
| 13335 | 13335 | 61 WASHBURN AVE | 4 | Snow - Property Damage | 51113 | 2025-04-29 | 2025-11-01 | 42.351498 | -71.242781 | |
| 13283 | 13283 | 167 AUBURNDALE AVE | 3 | Snow - Property Damage | 51113 | 2025-04-28 | 2025-07-31 | 42.35139 | -71.239023 | |
| 11799 | 11799 | 475 PARKER ST | 8 | Snow - Property Damage | 51113 | 2025-03-15 | 2025-03-28 | 42.311394 | -71.197043 | |
| 10928 | 10928 | 640 GROVE ST | 4 | Snow - Property Damage | 51113 | 2025-02-20 | 2025-03-28 | 42.327378 | -71.258058 | |
| 10616 | 10616 | 658 COMMONWEALTH AVE | 6 | Snow - Property Damage | 51113 | 2025-02-17 | 2025-02-24 | 42.335556 | -71.194436 | |
| 8516 | 8516 | 63 MARGARET RD | 5 | Snow - Property Damage | 51113 | 2024-12-24 | 2025-08-12 | 42.316208 | -71.215214 | |
| 8478 | 8478 | 278 MELROSE ST | 4 | Snow - Property Damage | 51113 | 2024-12-23 | 2025-12-16 | 42.347038 | -71.248512 |
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 );