home / n311

locations

11 rows where category_id = 50948 sorted by added descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location, ward, added, removed, latitude, longitude, added (date), removed (date)

Link rowid location ward category category_id active added ▲ removed latitude longitude
26887 26887 90 MEADOWBROOK RD 8 Abandoned Bicycle 50948   2026-02-24 2026-02-24 42.307461 -71.191674
24044 24044 624 D ROADWAY 8 Abandoned Bicycle 50948   2026-01-15 2026-01-15 42.291753 -71.184196
23963 23963 633 SAW MILL BROOK PKWY 8 Abandoned Bicycle 50948   2026-01-13 2026-01-13 42.291891 -71.184771
23947 23947 624 D ROADWAY 8 Abandoned Bicycle 50948   2026-01-12 2026-01-13 42.291753 -71.184196
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

CSV options:

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
);
Powered by Datasette · Queries took 507.8ms