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