_locations
10 rows where category_id = 50948
This data as json, CSV (advanced)
Suggested facets: location, latitude, longitude, ward, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 17297 | 17297 | 26 LOWELL AVE | 42.355944 | -71.207631 | 50948 | 2 | 2025-04-04 11:30 | 2025-04-07 | 0 |
| 20730 | 20730 | 28 JASSET ST | 42.363846 | -71.197767 | 50948 | 1 | 2025-06-05 08:15 | 2025-06-05 | 0 |
| 20778 | 20778 | 92 ALLISON ST | 42.363135 | -71.196714 | 50948 | 1 | 2025-06-05 13:45 | 2025-06-16 | 0 |
| 20980 | 20980 | 1697 BEACON STREET | 42.326604 | -71.232696 | 50948 | 5 | 2025-06-09 12:15 | 2025-06-11 | 0 |
| 22399 | 22399 | 41 CARLSON AVE | 42.29802 | -71.188052 | 50948 | 8 | 2025-07-01 08:00 | 2025-07-01 | 0 |
| 26348 | 26348 | 91 NEHOIDEN RD | 42.326208 | -71.237898 | 50948 | 5 | 2025-09-08 14:00 | 2025-09-08 | 0 |
| 32304 | 32304 | 69 CRAFTS ST | 42.355242 | -71.201736 | 50948 | 1 | 2026-01-07 09:45 | 2026-01-07 | 0 |
| 32573 | 32573 | 624 D ROADWAY | 42.291753 | -71.184196 | 50948 | 8 | 2026-01-12 16:45 | 2026-01-13 | 0 |
| 32713 | 32713 | 624 D ROADWAY | 42.291753 | -71.184196 | 50948 | 8 | 2026-01-15 08:15 | 2026-01-15 | 0 |
| 36044 | 36044 | 90 MEADOWBROOK RD | 42.307461 | -71.191674 | 50948 | 8 | 2026-02-24 14:30 | 2026-02-24 | 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 );