requests
11 rows where category_id = 53223 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: ward, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 31628 | 31628 | 8 HALLRON RD | ward-4 | Pole Down | 53223 | inactive | 2025-12-22 09:00 | 2025-12-23 | 42.331824 | -71.257815 |
| 30767 | 30767 | 60 WELLS AVE | ward-8 | Pole Down | 53223 | inactive | 2025-12-04 10:15 | 2025-12-04 | 42.29451 | -71.200926 |
| 21251 | 21251 | 244 LEXINGTON ST | ward-4 | Pole Down | 53223 | inactive | 2025-06-12 16:45 | 2025-06-13 | 42.353523 | -71.244792 |
| 16114 | 16114 | 180 BRANDEIS RD | ward-8 | Pole Down | 53223 | inactive | 2025-03-10 12:00 | 2025-03-10 | 42.312618 | -71.185325 |
| 15838 | 15838 | 811 WATERTOWN ST | ward-3 | Pole Down | 53223 | inactive | 2025-03-06 14:45 | 2025-03-13 | 42.352578 | -71.218499 |
| 15636 | 15636 | 5 MORSELAND AVE | ward-2 | Pole Down | 53223 | inactive | 2025-03-01 16:45 | 2025-03-03 | 42.340194 | -71.197475 |
| 13849 | 13849 | 310 NEVADA STREET | ward-1 | Pole Down | 53223 | inactive | 2025-01-28 19:00 | 2025-01-29 | 42.359117 | -71.205445 |
| 13731 | 13731 | 15 NORWOOD AVENUE | ward-6 | Pole Down | 53223 | inactive | 2025-01-27 13:15 | 2025-01-28 | 42.328793 | -71.198106 |
| 12478 | 12478 | 933 CENTRE STREET | ward-2 | Pole Down | 53223 | inactive | 2025-01-02 08:15 | 2025-01-02 | 42.340413 | -71.192862 |
| 10525 | 10525 | 21 WILLIAMS ST | ward-5 | Pole Down | 53223 | inactive | 2024-11-23 14:00 | 2024-11-26 | 42.307499 | -71.219484 |
| 5997 | 5997 | 122–134 CHAPEL ST | Pole Down | 53223 | inactive | 2024-09-17 09:45 | 2024-09-17 |
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]);