home / n311

locations

13 rows where category_id = 51048 sorted by added descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ward, active, added, removed, added (date), removed (date)

Link rowid location ward category category_id active added ▲ removed latitude longitude
16609 16609 71 WOODWARD ST 5 Poison Ivy 51048 active 2025-07-04   42.320889 -71.214242
16496 16496 246 DUDLEY RD 8 Poison Ivy 51048   2025-07-02 2025-07-02 42.312636 -71.179659
15212 15212 28 MANET RD 7 Poison Ivy 51048   2025-06-08 2025-07-02 42.33816 -71.174808
14793 14793 68 ALBERT RD 4 Poison Ivy 51048   2025-06-01 2025-07-02 42.355206 -71.240418
14481 14481 1148 CENTRE STREET 6 Poison Ivy 51048   2025-05-24 2025-07-02 42.333068 -71.193686
14334 14334 241 NAHANTON ST 8 Poison Ivy 51048   2025-05-21 2025-07-02 42.299127 -71.198384
14210 14210 57 WOODBINE ST 4 Poison Ivy 51048   2025-05-20 2025-07-02 42.346665 -71.253432
13827 13827 173 WABAN HILL RD N 7 Poison Ivy 51048   2025-05-10 2025-07-02 42.339249 -71.174966
3514 3514 14 DRIFTWOOD DR 3 Poison Ivy 51048 active 2024-08-22   42.364337 -71.223298
2575 2575 NEWTON CENTRE PLAYGROUND 6 Poison Ivy 51048   2024-07-31 2024-08-01 42.332573 -71.195801
1454 1454 1299 BEACON STREET 6 Poison Ivy 51048 active 2024-07-03   42.330548 -71.216544
1455 1455 COLD SPRING PARK 6 Poison Ivy 51048 active 2024-07-03   42.330992 -71.212896
937 937 60 WOODBINE STREET 4 Poison Ivy 51048 active 2024-06-23   42.346561 -71.253645

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 456.494ms