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