locations
22 rows where category_id = 51139 sorted by added descending
This data as json, CSV (advanced)
Suggested facets: location, ward, added, removed, latitude, longitude, added (date), removed (date)
| Link | rowid | location | ward | category | category_id | active | added ▲ | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 12239 | 12239 | 20 WINDERMERE RD | 4 | Street Light - Gas lamp out | 51139 | 2025-03-28 | 2025-04-02 | 42.343785 | -71.238537 | |
| 11858 | 11858 | 20 WINDERMERE RD | 4 | Street Light - Gas lamp out | 51139 | 2025-03-17 | 2025-03-19 | 42.343785 | -71.238537 | |
| 11860 | 11860 | 77 LAKE AVE | 6 | Street Light - Gas lamp out | 51139 | 2025-03-17 | 2025-03-20 | 42.329808 | -71.200769 | |
| 11652 | 11652 | 11 KENWOOD AVE | 6 | Street Light - Gas lamp out | 51139 | 2025-03-11 | 2025-03-27 | 42.337278 | -71.202249 | |
| 11012 | 11012 | 30 BIRCH HILL RD | 2 | Street Light - Gas lamp out | 51139 | 2025-02-24 | 2025-02-24 | 42.347673 | -71.211906 | |
| 11014 | 11014 | 65 SHORNECLIFFE RD | 7 | Street Light - Gas lamp out | 51139 | 2025-02-24 | 2025-02-24 | 42.349644 | -71.1783 | |
| 9676 | 9676 | 22 BERWICK ROAD | 6 | Street Light - Gas lamp out | 51139 | 2025-01-24 | 2025-01-28 | 42.327303 | -71.204279 | |
| 8800 | 8800 | 19 PRESCOTT ST | 2 | Street Light - Gas lamp out | 51139 | 2025-01-02 | 2025-01-03 | 42.355448 | -71.207447 | |
| 8109 | 8109 | 53 GRAY CLIFF ROAD | 7 | Street Light - Gas lamp out | 51139 | 2024-12-15 | 2025-03-20 | 42.33279 | -71.18639 | |
| 8098 | 8098 | 70 WINDERMERE RD | 4 | Street Light - Gas lamp out | 51139 | 2024-12-13 | 2025-03-20 | 42.342257 | -71.239505 | |
| 7994 | 7994 | 42 BRAEBURN ROAD | 4 | Street Light - Gas lamp out | 51139 | 2024-12-11 | 2024-12-13 | 42.343037 | -71.240292 | |
| 7128 | 7128 | 140 BRANDEIS RD | 8 | Street Light - Gas lamp out | 51139 | 2024-11-21 | 2024-11-21 | 42.313681 | -71.18654 | |
| 5147 | 5147 | 24 WARREN ST | 7 | Street Light - Gas lamp out | 51139 | 2024-10-12 | 2024-10-29 | 42.327769 | -71.183473 | |
| 4737 | 4737 | 32 WALNUT PL | 2 | Street Light - Gas lamp out | 51139 | 2024-09-27 | 2024-11-27 | 42.348593 | -71.208191 | |
| 4139 | 4139 | 79 KENWOOD AVENUE | 6 | Street Light - Gas lamp out | 51139 | 2024-09-10 | 2024-09-12 | 42.335475 | -71.202092 | |
| 3609 | 3609 | 11 KENWOOD AVE | 6 | Street Light - Gas lamp out | 51139 | 2024-08-26 | 2024-08-28 | 42.337275 | -71.202251 | |
| 3138 | 3138 | 43 KENWOOD AVE | 6 | Street Light - Gas lamp out | 51139 | 2024-08-13 | 2024-08-15 | 42.33632 | -71.202495 | |
| 2031 | 2031 | 9 THE LEDGES RD | 7 | Street Light - Gas lamp out | 51139 | 2024-07-17 | 2024-07-17 | 42.332156 | -71.184101 | |
| 850 | 850 | 53 VISTA AVE | 4 | Street Light - Gas lamp out | 51139 | 2024-06-21 | 2024-07-17 | 42.340251 | -71.245588 | |
| 518 | 518 | 35 BRAE BURN RD | 4 | Street Light - Gas lamp out | 51139 | 2024-06-15 | 2024-06-18 | 42.343314 | -71.240267 | |
| 413 | 413 | 33 WINDERMERE ROAD | 4 | Street Light - Gas lamp out | 51139 | 2024-06-24 | 42.34329 | -71.238726 | ||
| 414 | 414 | 530 LOWELL AVE | 2 | Street Light - Gas lamp out | 51139 | 2024-06-17 | 42.339051 | -71.211418 |
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 );