_locations
7 rows where category_id = 50948
This data as json, CSV (advanced)
Suggested facets: ward, added, added (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 12462 | 12462 | 26 LOWELL AVE | 42.355944 | -71.207631 | 50948 | 2 | 2025-04-04 | 2025-04-07 | 0 |
| 15062 | 15062 | 28 JASSET ST | 42.363846 | -71.197767 | 50948 | 1 | 2025-06-05 | 2025-06-05 | 0 |
| 15104 | 15104 | 92 ALLISON ST | 42.363135 | -71.196714 | 50948 | 1 | 2025-06-05 | 2025-06-16 | 0 |
| 15261 | 15261 | 1697 BEACON STREET | 42.326604 | -71.232696 | 50948 | 5 | 2025-06-09 | 2025-06-11 | 0 |
| 16401 | 16401 | 41 CARLSON AVE | 42.29802 | -71.188052 | 50948 | 8 | 2025-07-01 | 2025-07-01 | 0 |
| 19293 | 19293 | 91 NEHOIDEN RD | 42.326208 | -71.237898 | 50948 | 5 | 2025-09-08 | 2025-09-08 | 0 |
| 21815 | 21815 | 1700 BEACON ST | 42.325803 | -71.233295 | 50948 | 5 | 2025-11-13 | 2025-11-13 | 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 );