requests
8 rows where category_id = 51113 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: ward, removed, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 20436 | 20436 | 52 BERNARD ST | ward-8 | Snow - Property Damage | 51113 | inactive | 2025-06-02 09:45 | 2025-07-31 | 42.304797 | -71.210295 |
| 18504 | 18504 | 61 WASHBURN AVE | ward-4 | Snow - Property Damage | 51113 | inactive | 2025-04-29 08:45 | 2025-11-01 | 42.351498 | -71.242781 |
| 18441 | 18441 | 167 AUBURNDALE AVE | ward-3 | Snow - Property Damage | 51113 | inactive | 2025-04-28 12:15 | 2025-07-31 | 42.35139 | -71.239023 |
| 16390 | 16390 | 475 PARKER ST | ward-8 | Snow - Property Damage | 51113 | inactive | 2025-03-15 17:00 | 2025-03-28 | 42.311394 | -71.197043 |
| 15174 | 15174 | 640 GROVE ST | ward-4 | Snow - Property Damage | 51113 | inactive | 2025-02-20 13:45 | 2025-03-28 | 42.327378 | -71.258058 |
| 14821 | 14821 | 658 COMMONWEALTH AVE | ward-6 | Snow - Property Damage | 51113 | inactive | 2025-02-17 17:00 | 2025-02-24 | 42.335556 | -71.194436 |
| 12172 | 12172 | 63 MARGARET RD | ward-5 | Snow - Property Damage | 51113 | inactive | 2024-12-23 20:15 | 2025-08-12 | 42.316208 | -71.215214 |
| 12125 | 12125 | 278 MELROSE ST | ward-4 | Snow - Property Damage | 51113 | inactive | 2024-12-23 12:00 | 2025-12-16 | 42.347038 | -71.248512 |
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]);