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