requests

3 rows where category_id = 53468 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▲ location ward category category_id active added removed latitude longitude
1443 1443 130 FESSENDEN STREET ward-2 Dirty Water 53468 inactive 2024-06-26 2024-07-01 42.363619 -71.212097
1142 1142 40 HOMER STREET ward-6 Dirty Water 53468 inactive   2024-07-01 42.334599 -71.19529
1141 1141 118 LOUISE ROAD ward-8 Dirty Water 53468 inactive   2024-07-01 42.315137 -71.178566

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