requests
22 rows where category_id = 51139 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: location, ward, added, removed, latitude, longitude, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 16989 | 16989 | 20 WINDERMERE RD | ward-4 | Street Light - Gas lamp out | 51139 | inactive | 2025-03-27 21:15 | 2025-04-02 | 42.343785 | -71.238537 |
| 16475 | 16475 | 77 LAKE AVE | ward-6 | Street Light - Gas lamp out | 51139 | inactive | 2025-03-17 18:45 | 2025-03-20 | 42.329808 | -71.200769 |
| 16472 | 16472 | 20 WINDERMERE RD | ward-4 | Street Light - Gas lamp out | 51139 | inactive | 2025-03-17 16:30 | 2025-03-19 | 42.343785 | -71.238537 |
| 16168 | 16168 | 11 KENWOOD AVE | ward-6 | Street Light - Gas lamp out | 51139 | inactive | 2025-03-11 07:15 | 2025-03-27 | 42.337278 | -71.202249 |
| 15288 | 15288 | 65 SHORNECLIFFE RD | ward-7 | Street Light - Gas lamp out | 51139 | inactive | 2025-02-23 21:45 | 2025-02-24 | 42.349644 | -71.1783 |
| 15287 | 15287 | 30 BIRCH HILL RD | ward-2 | Street Light - Gas lamp out | 51139 | inactive | 2025-02-23 20:30 | 2025-02-24 | 42.347673 | -71.211906 |
| 13658 | 13658 | 22 BERWICK ROAD | ward-6 | Street Light - Gas lamp out | 51139 | inactive | 2025-01-24 12:30 | 2025-01-28 | 42.327303 | -71.204279 |
| 12542 | 12542 | 19 PRESCOTT ST | ward-2 | Street Light - Gas lamp out | 51139 | inactive | 2025-01-02 14:15 | 2025-01-03 | 42.355448 | -71.207447 |
| 11675 | 11675 | 53 GRAY CLIFF ROAD | ward-7 | Street Light - Gas lamp out | 51139 | inactive | 2024-12-15 07:15 | 2025-03-20 | 42.33279 | -71.18639 |
| 11663 | 11663 | 70 WINDERMERE RD | ward-4 | Street Light - Gas lamp out | 51139 | inactive | 2024-12-13 18:30 | 2025-03-20 | 42.342257 | -71.239505 |
| 11519 | 11519 | 42 BRAEBURN ROAD | ward-4 | Street Light - Gas lamp out | 51139 | inactive | 2024-12-11 16:00 | 2024-12-13 | 42.343037 | -71.240292 |
| 10408 | 10408 | 140 BRANDEIS RD | ward-8 | Street Light - Gas lamp out | 51139 | inactive | 2024-11-20 21:30 | 2024-11-21 | 42.313681 | -71.18654 |
| 7045 | 7045 | 24 WARREN ST | ward-7 | Street Light - Gas lamp out | 51139 | inactive | 2024-10-12 19:30 | 2024-10-29 | 42.327769 | -71.183473 |
| 6478 | 6478 | 32 WALNUT PL | ward-2 | Street Light - Gas lamp out | 51139 | inactive | 2024-09-27 10:45 | 2024-11-27 | 42.348593 | -71.208191 |
| 5626 | 5626 | 79 KENWOOD AVENUE | ward-6 | Street Light - Gas lamp out | 51139 | inactive | 2024-09-10 14:30 | 2024-09-12 | 42.335475 | -71.202092 |
| 4901 | 4901 | 11 KENWOOD AVE | ward-6 | Street Light - Gas lamp out | 51139 | inactive | 2024-08-26 12:30 | 2024-08-28 | 42.337275 | -71.202251 |
| 4261 | 4261 | 43 KENWOOD AVE | ward-6 | Street Light - Gas lamp out | 51139 | inactive | 2024-08-13 09:15 | 2024-08-15 | 42.33632 | -71.202495 |
| 2696 | 2696 | 9 THE LEDGES RD | ward-7 | Street Light - Gas lamp out | 51139 | inactive | 2024-07-17 09:00 | 2024-07-17 | 42.332156 | -71.184101 |
| 852 | 852 | 53 VISTA AVE | ward-4 | Street Light - Gas lamp out | 51139 | inactive | 2024-06-21 | 2024-07-17 | 42.340251 | -71.245588 |
| 517 | 517 | 35 BRAE BURN RD | ward-4 | Street Light - Gas lamp out | 51139 | inactive | 2024-06-15 | 2024-06-18 | 42.343314 | -71.240267 |
| 414 | 414 | 530 LOWELL AVE | ward-2 | Street Light - Gas lamp out | 51139 | inactive | 2024-06-17 | 42.339051 | -71.211418 | |
| 413 | 413 | 33 WINDERMERE ROAD | ward-4 | Street Light - Gas lamp out | 51139 | inactive | 2024-06-24 | 42.34329 | -71.238726 |
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]);