requests
4 rows where category_id = 66937 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: added, removed, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 31169 | 31169 | 351 WAVERLEY AVE | ward-7 | Remove Advertisement | 66937 | inactive | 2025-12-14 14:15 | 2025-12-16 | 42.343992 | -71.182467 |
| 30889 | 30889 | 389 WOODWARD ST | ward-5 | Remove Advertisement | 66937 | inactive | 2025-12-08 14:15 | 2025-12-09 | 42.326316 | -71.226653 |
| 30888 | 30888 | 1400 COMMONWEALTH AVE | ward-3 | Remove Advertisement | 66937 | inactive | 2025-12-08 14:15 | 2025-12-09 | 42.336477 | -71.22416 |
| 30640 | 30640 | 1000 COMMONWEALTH AVE | ward-2 | Remove Advertisement | 66937 | inactive | 2025-12-02 | 42.337377 | -71.208617 |
Advanced export
JSON shape: default, array, newline-delimited
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]);