home / n311

_locations

6 rows where category_id = 50948

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ward, added (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

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [_locations] (
   [location] TEXT,
   [latitude] FLOAT,
   [longitude] FLOAT,
   [category_id] TEXT REFERENCES [categories]([id]),
   [ward] INTEGER,
   [added] TEXT,
   [removed] TEXT,
   [active] INTEGER
);
Powered by Datasette · Queries took 630.771ms