locations

6 rows where category_id = 51122 sorted by added descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid location ward category category_id active added ▲ removed latitude longitude
9528 9528 149 PLEASANT ST 6 Snow - School Issues 51122   2025-01-22 2025-01-22 42.332508 -71.199644
9544 9544 687 WATERTOWN ST 2 Snow - School Issues 51122   2025-01-22 2025-01-23 42.35463 -71.21349
9289 9289 170 TEMPLE STREET 3 Snow - School Issues 51122   2025-01-15 2025-01-16 42.342097 -71.231183
9200 9200 113 GROVE STREET 4 Snow - School Issues 51122   2025-01-13 2025-01-13 42.342538 -71.249121
9205 9205 99 HANCOCK STREET 4 Snow - School Issues 51122   2025-01-13 2025-01-14 42.343044 -71.250769
9210 9210 2 ELM ROAD 2 Snow - School Issues 51122   2025-01-13 2025-01-14 42.345988 -71.208326

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
);