requests
6 rows where category_id = 50948 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 26348 | 26348 | 91 NEHOIDEN RD | ward-5 | Abandoned Bicycle | 50948 | inactive | 2025-09-08 14:00 | 2025-09-08 | 42.326208 | -71.237898 |
| 22399 | 22399 | 41 CARLSON AVE | ward-8 | Abandoned Bicycle | 50948 | inactive | 2025-07-01 08:00 | 2025-07-01 | 42.29802 | -71.188052 |
| 20980 | 20980 | 1697 BEACON STREET | ward-5 | Abandoned Bicycle | 50948 | inactive | 2025-06-09 12:15 | 2025-06-11 | 42.326604 | -71.232696 |
| 20778 | 20778 | 92 ALLISON ST | ward-1 | Abandoned Bicycle | 50948 | inactive | 2025-06-05 13:45 | 2025-06-16 | 42.363135 | -71.196714 |
| 20730 | 20730 | 28 JASSET ST | ward-1 | Abandoned Bicycle | 50948 | inactive | 2025-06-05 08:15 | 2025-06-05 | 42.363846 | -71.197767 |
| 17297 | 17297 | 26 LOWELL AVE | ward-2 | Abandoned Bicycle | 50948 | inactive | 2025-04-04 11:30 | 2025-04-07 | 42.355944 | -71.207631 |
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]);