requests
15 rows where category_id = 53225 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: location, ward, latitude, longitude, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 31333 | 31333 | 119 ELM ST | ward-3 | Handholes | 53225 | inactive | 2025-12-17 10:45 | 2025-12-17 | 42.348852 | -71.229335 |
| 30864 | 30864 | 25 IRVING ST | ward-7 | Handholes | 53225 | inactive | 2025-12-08 09:15 | 2025-12-08 | 42.337638 | -71.189316 |
| 30477 | 30477 | 25 IRVING ST | ward-7 | Handholes | 53225 | inactive | 2025-11-28 15:00 | 2025-12-01 | 42.337638 | -71.189316 |
| 29383 | 29383 | 4 WISWALL STREET | ward-3 | Handholes | 53225 | inactive | 2025-11-05 11:45 | 2025-11-10 | 42.35093 | -71.217504 |
| 25835 | 25835 | 33 BIRCH HILL RD | ward-2 | Handholes | 53225 | inactive | 2025-08-28 10:00 | 2025-09-13 | 42.347628 | -71.21255 |
| 25731 | 25731 | 209 TREMONT ST | ward-1 | Handholes | 53225 | inactive | 2025-08-26 13:00 | 2025-08-29 | 42.353181 | -71.176806 |
| 24749 | 24749 | 15 TIMSON PATH | ward-8 | Handholes | 53225 | inactive | 2025-08-06 07:15 | 2025-10-13 | 42.290703 | -71.188898 |
| 24729 | 24729 | 150 PLEASANT STREET | ward-6 | Handholes | 53225 | inactive | 2025-08-05 18:45 | 2025-08-06 | 42.332251 | -71.199844 |
| 23938 | 23938 | 386 QUINOBEQUIN ROAD | ward-5 | Handholes | 53225 | inactive | 2025-07-22 20:30 | 2025-07-23 | 42.322114 | -71.239691 |
| 23154 | 23154 | 479 CALIFORNIA ST | ward-1 | Handholes | 53225 | inactive | 2025-07-13 13:45 | 2025-07-14 | 42.362793 | -71.207744 |
| 19255 | 19255 | 68 CHARLESBANK RD | ward-1 | Handholes | 53225 | inactive | 2025-05-12 20:30 | 2025-05-13 | 42.358464 | -71.179218 |
| 16308 | 16308 | 22 LOUISE ROAD | ward-8 | Handholes | 53225 | inactive | 2025-03-13 09:45 | 2025-03-19 | 42.31732 | -71.175362 |
| 16295 | 16295 | 27 TIMSON PATH | ward-8 | Handholes | 53225 | inactive | 2025-03-13 07:00 | 2025-03-13 | 42.290928 | -71.188956 |
| 6725 | 6725 | 5 SHELDON ROAD | ward-8 | Handholes | 53225 | inactive | 2024-10-04 11:00 | 2024-10-07 | 42.318893 | -71.193257 |
| 1957 | 1957 | 7 SHUMAKER PATH | ward-8 | Handholes | 53225 | inactive | 2024-07-03 14:00 | 2024-07-26 | 42.293772 | -71.188276 |
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]);