requests
6 rows where category_id = 57893 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: ward, active, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 26703 | 26703 | 200 COMMONWEALTH AVE | ward-7 | Guardrail - Repairs | 57893 | inactive | 2025-09-15 09:30 | 2025-11-03 | 42.337008 | -71.174205 |
| 21654 | 21654 | 301 ELLIOT ST | ward-5 | Guardrail - Repairs | 57893 | inactive | 2025-06-19 06:45 | 2025-06-26 | 42.312915 | -71.221487 |
| 18947 | 18947 | 1781 COMMONWEALTH AVENUE | ward-4 | Guardrail - Repairs | 57893 | active | 2025-05-07 08:15 | 42.341784 | -71.239327 | |
| 16776 | 16776 | 65 ELLIS STREET | ward-5 | Guardrail - Repairs | 57893 | inactive | 2025-03-25 12:30 | 2025-03-29 | 42.314752 | -71.225937 |
| 12777 | 12777 | 77 PAUL ST | ward-6 | Guardrail - Repairs | 57893 | inactive | 2025-01-07 11:45 | 2025-01-10 | 42.326666 | -71.197314 |
| 9784 | 9784 | 9 BONWOOD ST | ward-2 | Guardrail - Repairs | 57893 | inactive | 2024-11-07 10:00 | 2025-04-01 | 42.347376 | -71.201537 |
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]);