requests
1 row where category_id = 50958 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 33108 | 33108 | 675 SAW MILL BROOK PKWY | ward-8 | Blue Bike Docking Locations | 50958 | inactive | 2026-01-21 12:00 | 2026-01-21 | 42.291117 | -71.18631 |
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]);