requests
7 rows where category_id = 53220 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 25672 | 25672 | 10 WINCHESTER ST | ward-5 | Wire Arcing | 53220 | inactive | 2025-08-25 12:30 | 2025-08-27 | 42.318873 | -71.207591 |
| 16466 | 16466 | 80 UNION ST | ward-6 | Wire Arcing | 53220 | inactive | 2025-03-17 16:15 | 2025-03-18 | 42.329412 | -71.192871 |
| 16387 | 16387 | 142 RANDLETT PARK | ward-3 | Wire Arcing | 53220 | inactive | 2025-03-15 14:30 | 2025-03-17 | 42.355116 | -71.222675 |
| 15449 | 15449 | 212 TREMONT ST | ward-1 | Wire Arcing | 53220 | inactive | 2025-02-26 07:15 | 2025-02-27 | 42.352857 | -71.17713 |
| 14972 | 14972 | 73 AUBURN ST | ward-3 | Wire Arcing | 53220 | inactive | 2025-02-18 13:00 | 2025-02-18 | 42.345171 | -71.2377 |
| 3814 | 3814 | 36 ELINOR RD | ward-6 | Wire Arcing | 53220 | inactive | 2024-08-07 14:15 | 2024-08-12 | 42.315033 | -71.200219 |
| 3417 | 3417 | 22 CAROLINE PARK | ward-5 | Wire Arcing | 53220 | inactive | 2024-07-31 11:15 | 2024-08-02 | 42.332715 | -71.225673 |
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]);