requests
4 rows where category_id = 51034 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 22349 | 22349 | 55 BORDER ST | ward-3 | Parking - Parking Meter Missing | 51034 | inactive | 2025-06-30 11:45 | 2025-06-30 | 42.348519 | -71.231904 |
| 17799 | 17799 | 91 WINSTON RD | ward-8 | Parking - Parking Meter Missing | 51034 | inactive | 2025-04-14 18:45 | 2025-04-15 | 42.310494 | -71.185118 |
| 17010 | 17010 | 32 LANGLEY RD | ward-6 | Parking - Parking Meter Missing | 51034 | inactive | 2025-03-28 11:45 | 2025-03-31 | 42.330879 | -71.193051 |
| 3293 | 3293 | 33 MAPLE AVE | ward-1 | Parking - Parking Meter Missing | 51034 | inactive | 2024-07-29 12:30 | 2024-09-25 | 42.353444 | -71.188974 |
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]);