requests

6 rows where category_id = 51122 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▲ location ward category category_id active added removed latitude longitude
13503 13503 687 WATERTOWN ST ward-2 Snow - School Issues 51122 inactive 2025-01-22 11:30 2025-01-23 42.35463 -71.21349
13483 13483 149 PLEASANT ST ward-6 Snow - School Issues 51122 inactive 2025-01-22 09:30 2025-01-22 42.332508 -71.199644
13178 13178 170 TEMPLE STREET ward-3 Snow - School Issues 51122 inactive 2025-01-15 10:00 2025-01-16 42.342097 -71.231183
13057 13057 2 ELM ROAD ward-2 Snow - School Issues 51122 inactive 2025-01-13 10:00 2025-01-14 42.345988 -71.208326
13051 13051 99 HANCOCK STREET ward-4 Snow - School Issues 51122 inactive 2025-01-13 09:30 2025-01-14 42.343044 -71.250769
13038 13038 113 GROVE STREET ward-4 Snow - School Issues 51122 inactive 2025-01-13 08:30 2025-01-13 42.342538 -71.249121

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "requests" (
   [location] TEXT,
   [ward] TEXT,
   [category] TEXT,
   [category_id] TEXT REFERENCES [categories]([id]),
   [active] TEXT,
   [added] TEXT,
   [removed] TEXT,
   [latitude] FLOAT,
   [longitude] FLOAT
);
CREATE INDEX [idx_requests_ward_category_category_id_active_added_removed]
    ON [requests] ([ward], [category], [category_id], [active], [added], [removed]);