requests

7 rows where category_id = 53240 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▲ location ward category category_id active added removed latitude longitude
28523 28523 1382 BEACON STREET ward-5 School Zone Flashers Malfunction 53240 active 2025-10-21 09:15   42.330141 -71.220358
27985 27985 169 JACKSON ROAD ward-1 School Zone Flashers Malfunction 53240 inactive 2025-10-09 13:45 2025-10-21 42.358248 -71.195408
26762 26762 149 PLEASANT STREET ward-6 School Zone Flashers Malfunction 53240 active 2025-09-15 18:30   42.332124 -71.199608
26730 26730 1299 BEACON ST ward-5 School Zone Flashers Malfunction 53240 active 2025-09-15 13:00   42.330978 -71.216694
25383 25383 184 PINE ST ward-4 School Zone Flashers Malfunction 53240 active 2025-08-18 18:00   42.351624 -71.242124
20099 20099 555 COMMONWEALTH AVE ward-7 School Zone Flashers Malfunction 53240 inactive 2025-05-28 06:45 2025-05-28 42.33645 -71.18955
19849 19849 137 TEMPLE STREET ward-3 School Zone Flashers Malfunction 53240 active 2025-05-22 12:00   42.343116 -71.231097

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