requests
35 rows where category_id = 51094 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 30609 | 30609 | 20 HARTFORD ST | ward-6 | Sign Relocation Request | 51094 | inactive | 2025-12-01 13:30 | 2025-12-02 | 42.320898 | -71.207735 |
| 29461 | 29461 | 382 WATERTOWN ST | ward-1 | Sign Relocation Request | 51094 | inactive | 2025-11-06 13:15 | 2025-11-12 | 42.360363 | -71.20157 |
| 29217 | 29217 | 70 AUBURN ST | ward-4 | Sign Relocation Request | 51094 | inactive | 2025-11-03 10:30 | 2025-11-04 | 42.344523 | -71.237534 |
| 28811 | 28811 | 1724 BEACON STREET | ward-5 | Sign Relocation Request | 51094 | inactive | 2025-10-27 11:00 | 2025-10-28 | 42.326382 | -71.234327 |
| 28625 | 28625 | 247 WATERTOWN ST | ward-1 | Sign Relocation Request | 51094 | inactive | 2025-10-22 11:00 | 2025-10-22 | 42.361902 | -71.196435 |
| 28144 | 28144 | 814 WATERTOWN ST | ward-3 | Sign Relocation Request | 51094 | inactive | 2025-10-14 09:45 | 2025-10-14 | 42.352173 | -71.218368 |
| 27918 | 27918 | 228 BELLEVUE ST | ward-1 | Sign Relocation Request | 51094 | inactive | 2025-10-08 00:15 | 2025-10-09 | 42.352848 | -71.195607 |
| 27869 | 27869 | 428 WARD ST | ward-7 | Sign Relocation Request | 51094 | inactive | 2025-10-07 09:45 | 2025-10-08 | 42.338016 | -71.190774 |
| 26982 | 26982 | 1371 CENTRE ST | ward-6 | Sign Relocation Request | 51094 | inactive | 2025-09-19 13:15 | 2025-09-22 | 42.327531 | -71.197232 |
| 26981 | 26981 | 1310 CENTRE ST | ward-6 | Sign Relocation Request | 51094 | inactive | 2025-09-19 13:15 | 2025-09-22 | 42.328935 | -71.195229 |
| 26871 | 26871 | 50 WOODLAND RD | ward-4 | Sign Relocation Request | 51094 | inactive | 2025-09-17 11:00 | 2025-09-22 | 42.34419 | -71.250746 |
| 24975 | 24975 | 159 WASHINGTON STREET | ward-1 | Sign Relocation Request | 51094 | inactive | 2025-08-11 10:30 | 2025-08-12 | 42.356101 | -71.180398 |
| 23805 | 23805 | 1274 WASHINGTON ST | ward-3 | Sign Relocation Request | 51094 | inactive | 2025-07-21 12:00 | 2025-07-21 | 42.349275 | -71.225829 |
| 22603 | 22603 | 130 RIVER ST | ward-3 | Sign Relocation Request | 51094 | inactive | 2025-07-03 09:15 | 2025-07-04 | 42.352902 | -71.232224 |
| 18872 | 18872 | 825 CENTRE ST | ward-2 | Sign Relocation Request | 51094 | inactive | 2025-05-06 08:45 | 2025-05-13 | 42.343587 | -71.191436 |
| 16828 | 16828 | 51 GLEN AVE | ward-6 | Sign Relocation Request | 51094 | inactive | 2025-03-26 06:00 | 2025-04-25 | 42.329907 | -71.186522 |
| 16669 | 16669 | 16 NOBLE STREET | ward-3 | Sign Relocation Request | 51094 | inactive | 2025-03-21 17:15 | 2025-03-24 | 42.361256 | -71.232992 |
| 16566 | 16566 | 15 SHORT ST | ward-5 | Sign Relocation Request | 51094 | inactive | 2025-03-20 00:30 | 2025-03-20 | 42.329124 | -71.226648 |
| 16458 | 16458 | 132 WINDERMERE ROAD | ward-4 | Sign Relocation Request | 51094 | inactive | 2025-03-17 14:45 | 2025-03-17 | 42.34126 | -71.240743 |
| 13067 | 13067 | 140 VINE ST | ward-8 | Sign Relocation Request | 51094 | inactive | 2025-01-13 10:45 | 2025-01-14 | 42.302766 | -71.169713 |
| 11816 | 11816 | 211 WEBSTER ST | ward-3 | Sign Relocation Request | 51094 | inactive | 2024-12-17 14:30 | 2024-12-18 | 42.348791 | -71.23582 |
| 11099 | 11099 | 22 HYDE ST | ward-6 | Sign Relocation Request | 51094 | inactive | 2024-12-06 08:45 | 2024-12-06 | 42.325596 | -71.205527 |
| 10343 | 10343 | 231 JACKSON ROAD | ward-1 | Sign Relocation Request | 51094 | inactive | 2024-11-20 00:15 | 2024-12-02 | 42.355137 | -71.195252 |
| 10342 | 10342 | 143 ROWE STREET | ward-4 | Sign Relocation Request | 51094 | inactive | 2024-11-20 00:15 | 2024-11-26 | 42.347438 | -71.243318 |
| 10259 | 10259 | 95 COLUMBIA AVE | ward-8 | Sign Relocation Request | 51094 | inactive | 2024-11-18 11:30 | 2024-11-20 | 42.313671 | -71.209802 |
| 9965 | 9965 | 112 HYDE STREET | ward-6 | Sign Relocation Request | 51094 | inactive | 2024-11-08 14:15 | 2024-11-12 | 42.322971 | -71.203793 |
| 6893 | 6893 | 122 AUBURN ST | ward-4 | Sign Relocation Request | 51094 | inactive | 2024-10-09 07:15 | 2024-10-09 | 42.344528 | -71.240223 |
| 6765 | 6765 | 455 NAHANTON STREET | ward-8 | Sign Relocation Request | 51094 | inactive | 2024-10-06 11:45 | 2024-10-07 | 42.297693 | -71.207505 |
| 5560 | 5560 | 251 MILL STREET | ward-2 | Sign Relocation Request | 51094 | inactive | 2024-09-10 05:30 | 2024-09-11 | 42.342295 | -71.203437 |
| 4366 | 4366 | 10 DUNSTAN ST | ward-3 | Sign Relocation Request | 51094 | inactive | 2024-08-14 15:30 | 2024-08-14 | 42.350454 | -71.222327 |
| 3215 | 3215 | 154 WOODCHESTER DR | ward-7 | Sign Relocation Request | 51094 | inactive | 2024-07-28 11:30 | 2024-07-30 | 42.341869 | -71.174313 |
| 2657 | 2657 | 13 WILTSHIRE RD | ward-1 | Sign Relocation Request | 51094 | inactive | 2024-07-16 15:30 | 2024-07-18 | 42.356328 | -71.196664 |
| 2287 | 2287 | 693 CENTRE STREET | ward-2 | Sign Relocation Request | 51094 | inactive | 2024-07-09 23:30 | 2024-07-10 | 42.34764 | -71.188697 |
| 1326 | 1326 | 540 CENTRE STREET | ward-1 | Sign Relocation Request | 51094 | inactive | 2024-06-24 | 2024-06-27 | 42.352552 | -71.185961 |
| 1113 | 1113 | 8 FREDANA ROAD | ward-5 | Sign Relocation Request | 51094 | inactive | 2024-06-26 | 42.33141 | -71.227267 |
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]);