_locations
17 rows where category_id = 55455
This data as json, CSV (advanced)
Suggested facets: location, latitude, longitude, ward, removed, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 3521 | 3521 | 661 WATERTOWN STREET | 42.354915 | -71.212032 | 55455 | 2 | 2024-08-02 08:45 | 2024-08-13 | 0 |
| 6891 | 6891 | 244 CALIFORNIA ST | 42.364661 | -71.198265 | 55455 | 1 | 2024-10-09 07:15 | 2024-10-15 | 0 |
| 9423 | 9423 | 447 CENTRE STREET | 42.355196 | -71.186605 | 55455 | 1 | 2024-11-02 17:45 | 2024-11-04 | 0 |
| 9728 | 9728 | 24 HENSHAW TERRACE | 42.352275 | -71.226985 | 55455 | 3 | 2024-11-06 11:00 | 2024-11-06 | 0 |
| 9746 | 9746 | 100 CHESTNUT ST | 42.346607 | -71.223957 | 55455 | 3 | 2024-11-06 15:30 | 2024-11-07 | 0 |
| 10007 | 10007 | 54 NEWELL ROAD | 42.350613 | -71.243269 | 55455 | 4 | 2024-11-10 18:45 | 2024-11-11 | 0 |
| 13382 | 13382 | 52 CHANNING ROAD | 42.339737 | -71.197996 | 55455 | 2 | 2025-01-21 09:15 | 2025-01-21 | 0 |
| 13832 | 13832 | 191 MILL STREET | 42.341911 | -71.200799 | 55455 | 2 | 2025-01-28 16:00 | 2025-01-29 | 0 |
| 14341 | 14341 | 47 GRAFTON ST | 42.335661 | -71.194931 | 55455 | 6 | 2025-02-08 20:15 | 2025-02-10 | 0 |
| 14372 | 14372 | 8 CEDAR ST | 42.340572 | -71.198591 | 55455 | 2 | 2025-02-09 17:00 | 2025-02-10 | 0 |
| 14394 | 14394 | 47 GRAFTON ST | 42.335541 | -71.195162 | 55455 | 6 | 2025-02-10 09:30 | 2025-02-10 | 0 |
| 15537 | 15537 | 47 GRAFTON ST | 42.335541 | -71.195162 | 55455 | 6 | 2025-02-27 09:30 | 2025-02-27 | 0 |
| 16706 | 16706 | 470 WATERTOWN STREET | 42.358359 | -71.204511 | 55455 | 1 | 2025-03-24 09:30 | 2025-03-24 | 0 |
| 17058 | 17058 | 70 BOTSFORD ROAD | 42.304109 | -71.173238 | 55455 | 8 | 2025-03-29 23:00 | 2025-03-31 | 0 |
| 20703 | 20703 | 714 BEACON ST | 42.330681 | -71.189825 | 55455 | 6 | 2025-06-04 16:30 | 2025-06-05 | 0 |
| 22672 | 22672 | 140 BRANDEIS ROAD | 42.313721 | -71.188075 | 55455 | 8 | 2025-07-06 06:30 | 2025-07-07 | 0 |
| 26569 | 26569 | 448 NEWTONVILLE AVE | 42.350679 | -71.206182 | 55455 | 2 | 2025-09-12 06:15 | 2025-09-12 | 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 );