requests
23 rows where category_id = 50985 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: ward, removed, removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 30483 | 30483 | 205 LEXINGTON ST | ward-4 | Fence Repair | 50985 | inactive | 2025-11-29 11:45 | 2025-12-02 | 42.354585 | -71.244036 |
| 27717 | 27717 | 100 WALNUT ST | ward-2 | Fence Repair | 50985 | inactive | 2025-10-03 09:30 | 2025-10-06 | 42.357006 | -71.209409 |
| 27011 | 27011 | 115 BEETHOVEN AVE | ward-5 | Fence Repair | 50985 | inactive | 2025-09-20 17:45 | 2025-09-23 | 42.326775 | -71.219439 |
| 26531 | 26531 | 90 EAST SIDE PARKWAY | ward-2 | Fence Repair | 50985 | inactive | 2025-09-11 12:45 | 2025-09-16 | 42.351283 | -71.196561 |
| 25648 | 25648 | 177 CHERRY ST | ward-3 | Fence Repair | 50985 | inactive | 2025-08-24 20:45 | 2025-10-06 | 42.358167 | -71.227485 |
| 24662 | 24662 | 1200 BEACON ST | ward-6 | Fence Repair | 50985 | inactive | 2025-08-05 08:45 | 2025-08-19 | 42.330996 | -71.212896 |
| 23861 | 23861 | 30 BEETHOVEN AVE | ward-5 | Fence Repair | 50985 | inactive | 2025-07-22 08:00 | 2025-07-22 | 42.329682 | -71.217707 |
| 22419 | 22419 | 94 WEBSTER ST | ward-3 | Fence Repair | 50985 | inactive | 2025-07-01 11:15 | 2025-07-01 | 42.349536 | -71.230676 |
| 18164 | 18164 | 57 LOUISE ROAD | ward-8 | Fence Repair | 50985 | inactive | 2025-04-23 06:45 | 2025-05-08 | 42.316279 | -71.176946 |
| 18036 | 18036 | 50 PRINCESS ROAD | ward-3 | Fence Repair | 50985 | inactive | 2025-04-19 08:15 | 2025-04-29 | 42.354257 | -71.226495 |
| 17496 | 17496 | 232 BROOKLINE ST | ward-8 | Fence Repair | 50985 | inactive | 2025-04-08 12:15 | 2025-05-01 | 42.30261 | -71.176955 |
| 16675 | 16675 | 180 BRANDEIS RD | ward-8 | Fence Repair | 50985 | inactive | 2025-03-22 15:45 | 2025-04-15 | 42.312618 | -71.185325 |
| 16386 | 16386 | 110 TYLER TER | ward-6 | Fence Repair | 50985 | inactive | 2025-03-15 14:15 | 2025-03-18 | 42.331716 | -71.199068 |
| 16173 | 16173 | 687 WATERTOWN ST | ward-2 | Fence Repair | 50985 | inactive | 2025-03-11 09:00 | 2025-03-12 | 42.35463 | -71.21349 |
| 13771 | 13771 | 19 OTIS PARK | ward-2 | Fence Repair | 50985 | inactive | 2025-01-28 09:15 | 2025-04-21 | 42.347263 | -71.206915 |
| 12787 | 12787 | 611 CENTRE ST | ward-1 | Fence Repair | 50985 | inactive | 2025-01-07 14:00 | 2025-02-19 | 42.350076 | -71.18657 |
| 12243 | 12243 | 100 WALNUT STREET | ward-2 | Fence Repair | 50985 | inactive | 2024-12-26 10:00 | 2025-01-02 | 42.357071 | -71.209543 |
| 11746 | 11746 | 290 ALBEMARLE ROAD | ward-2 | Fence Repair | 50985 | inactive | 2024-12-16 13:45 | 2024-12-17 | 42.355002 | -71.214049 |
| 10621 | 10621 | 462 WALNUT STREET | ward-2 | Fence Repair | 50985 | inactive | 2024-11-25 10:30 | 2024-11-27 | 42.345479 | -71.205788 |
| 10282 | 10282 | 140 LION DR | ward-8 | Fence Repair | 50985 | inactive | 2024-11-18 14:30 | 2025-02-06 | 42.311658 | -71.186863 |
| 8681 | 8681 | 12 WENHAM RD | ward-6 | Fence Repair | 50985 | inactive | 2024-10-29 11:30 | 2024-10-30 | 42.32782 | -71.208626 |
| 7996 | 7996 | 1408 CENTRE ST | ward-6 | Fence Repair | 50985 | inactive | 2024-10-23 08:30 | 2024-11-05 | 42.326094 | -71.197965 |
| 5843 | 5843 | 457 WALNUT ST | ward-2 | Fence Repair | 50985 | inactive | 2024-09-15 17:00 | 2024-09-23 | 42.345286 | -71.207683 |
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]);