requests
77 rows where category_id = 53222 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: ward, active, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 31585 | 31585 | 10 CLIFF RD | ward-5 | Pole Leaning | 53222 | inactive | 2025-12-20 12:15 | 2025-12-22 | 42.311637 | -71.219948 |
| 31512 | 31512 | 120 STANLEY RD | ward-5 | Pole Leaning | 53222 | inactive | 2025-12-19 13:15 | 2025-12-23 | 42.32097 | -71.221797 |
| 31170 | 31170 | 66 CONCORD STREET | ward-4 | Pole Leaning | 53222 | inactive | 2025-12-14 17:45 | 2025-12-15 | 42.329205 | -71.265848 |
| 30387 | 30387 | 101 PLEASANT ST | ward-6 | Pole Leaning | 53222 | inactive | 2025-11-25 11:15 | 2025-11-26 | 42.33132 | -71.198861 |
| 29113 | 29113 | 29 NEWTONVILLE AVE | ward-1 | Pole Leaning | 53222 | inactive | 2025-10-31 16:15 | 2025-11-01 | 42.352398 | -71.187273 |
| 29094 | 29094 | 40 NEWTONVILLE AVE | ward-1 | Pole Leaning | 53222 | inactive | 2025-10-31 12:30 | 2025-11-10 | 42.352155 | -71.187719 |
| 28423 | 28423 | 1684 COMMONWEALTH AVE | ward-4 | Pole Leaning | 53222 | inactive | 2025-10-17 16:45 | 2025-10-20 | 42.33951 | -71.236467 |
| 28087 | 28087 | 71 SHARPE RD | ward-8 | Pole Leaning | 53222 | active | 2025-10-12 07:30 | 42.308136 | -71.195472 | |
| 27300 | 27300 | 38 CRAFTS ST | ward-2 | Pole Leaning | 53222 | active | 2025-09-25 14:30 | 42.354612 | -71.200823 | |
| 27250 | 27250 | 111 WENDELL ROAD | ward-8 | Pole Leaning | 53222 | inactive | 2025-09-24 21:00 | 2025-11-10 | 42.310565 | -71.201771 |
| 27025 | 27025 | 95 LANGLEY ROAD | ward-6 | Pole Leaning | 53222 | inactive | 2025-09-22 08:45 | 2025-09-24 | 42.329253 | -71.190274 |
| 25876 | 25876 | 255 WASHINGTON ST | ward-1 | Pole Leaning | 53222 | inactive | 2025-08-29 09:00 | 2025-09-02 | 42.357771 | -71.183844 |
| 24606 | 24606 | 54 GRANT ST | ward-3 | Pole Leaning | 53222 | inactive | 2025-08-04 12:15 | 2025-09-25 | 42.358473 | -71.232584 |
| 24342 | 24342 | 4 MECHANIC ST | ward-5 | Pole Leaning | 53222 | inactive | 2025-07-30 06:45 | 2025-08-08 | 42.312636 | -71.217518 |
| 24175 | 24175 | 36 JUDITH RD | ward-6 | Pole Leaning | 53222 | inactive | 2025-07-27 18:15 | 2025-07-30 | 42.334434 | -71.206344 |
| 23522 | 23522 | 11 ELIOT AVE | ward-3 | Pole Leaning | 53222 | inactive | 2025-07-16 14:00 | 2025-11-17 | 42.352983 | -71.218049 |
| 23519 | 23519 | 420 FULLER ST | ward-4 | Pole Leaning | 53222 | inactive | 2025-07-16 13:45 | 2025-09-04 | 42.339717 | -71.237232 |
| 22699 | 22699 | 34 SUMNER ST | ward-7 | Pole Leaning | 53222 | inactive | 2025-07-07 07:15 | 2025-11-17 | 42.337017 | -71.191175 |
| 22300 | 22300 | 34 SUMNER ST | ward-7 | Pole Leaning | 53222 | inactive | 2025-06-29 23:15 | 2025-06-30 | 42.337017 | -71.191175 |
| 20573 | 20573 | 744 QUINOBEQUIN RD | ward-5 | Pole Leaning | 53222 | inactive | 2025-06-03 14:00 | 2025-06-04 | 42.31746 | -71.226518 |
| 20048 | 20048 | 77 PEMBROKE ST | ward-1 | Pole Leaning | 53222 | inactive | 2025-05-27 12:30 | 2025-05-28 | 42.350679 | -71.178705 |
| 19805 | 19805 | 14 CLOVERDALE ROAD | ward-6 | Pole Leaning | 53222 | inactive | 2025-05-21 15:45 | 2025-08-06 | 42.321054 | -71.1995 |
| 18868 | 18868 | 75 COMMONWEALTH PARK W | ward-2 | Pole Leaning | 53222 | inactive | 2025-05-06 07:15 | 2025-05-19 | 42.33933 | -71.204292 |
| 18403 | 18403 | 7 COMMONWEALTH PARK | ward-2 | Pole Leaning | 53222 | active | 2025-04-28 09:00 | 42.339645 | -71.203284 | |
| 18315 | 18315 | 10 MIDLAND AVENUE | ward-1 | Pole Leaning | 53222 | inactive | 2025-04-25 09:30 | 2025-04-28 | 42.365501 | -71.19477 |
| 17963 | 17963 | 2300 WASHINGTON ST | ward-4 | Pole Leaning | 53222 | inactive | 2025-04-17 11:45 | 2025-04-18 | 42.325488 | -71.254931 |
| 17762 | 17762 | 588 WALNUT ST | ward-2 | Pole Leaning | 53222 | active | 2025-04-14 10:45 | 42.341148 | -71.206479 | |
| 17506 | 17506 | 1974 WASHINGTON ST | ward-5 | Pole Leaning | 53222 | inactive | 2025-04-08 14:15 | 2025-04-28 | 42.333012 | -71.245391 |
| 17445 | 17445 | 88 LEWIS ST | ward-1 | Pole Leaning | 53222 | inactive | 2025-04-08 09:00 | 2025-04-16 | 42.351453 | -71.193789 |
| 16452 | 16452 | 10 OSSIPEE RD | ward-5 | Pole Leaning | 53222 | inactive | 2025-03-17 13:45 | 2025-08-06 | 42.310449 | -71.219655 |
| 16253 | 16253 | 592 SAW MILL BROOK PKWY | ward-8 | Pole Leaning | 53222 | inactive | 2025-03-12 10:00 | 2025-03-18 | 42.29253 | -71.183052 |
| 16115 | 16115 | 10 STONEWOOD DR | ward-8 | Pole Leaning | 53222 | inactive | 2025-03-10 12:00 | 2025-03-10 | 42.313851 | -71.182544 |
| 16065 | 16065 | 277 HOMER ST | ward-2 | Pole Leaning | 53222 | inactive | 2025-03-10 07:00 | 2025-03-13 | 42.335874 | -71.205345 |
| 16005 | 16005 | 27 PEABODY ST | ward-1 | Pole Leaning | 53222 | inactive | 2025-03-08 13:00 | 2025-03-10 | 42.357222 | -71.187071 |
| 15921 | 15921 | 282 HOMER ST | ward-6 | Pole Leaning | 53222 | inactive | 2025-03-07 13:30 | 2025-03-10 | 42.335577 | -71.205674 |
| 15918 | 15918 | 22 LOUISE ROAD | ward-8 | Pole Leaning | 53222 | inactive | 2025-03-07 13:15 | 2025-03-13 | 42.31732 | -71.175362 |
| 13742 | 13742 | 109 OAK STREET | ward-5 | Pole Leaning | 53222 | inactive | 2025-01-27 15:45 | 2025-01-28 | 42.308476 | -71.221061 |
| 13587 | 13587 | 73 LEXINGTON ST | ward-4 | Pole Leaning | 53222 | active | 2025-01-23 11:30 | 42.357663 | -71.239937 | |
| 13207 | 13207 | 85 CRESCENT ST | ward-4 | Pole Leaning | 53222 | inactive | 2025-01-16 07:30 | 2025-06-23 | 42.34626 | -71.238234 |
| 12549 | 12549 | 238 NEVADA ST | ward-1 | Pole Leaning | 53222 | inactive | 2025-01-02 14:45 | 2025-01-03 | 42.360861 | -71.207996 |
| 12539 | 12539 | 16 MANEMET RD | ward-6 | Pole Leaning | 53222 | inactive | 2025-01-02 14:15 | 2025-01-03 | 42.337468 | -71.203201 |
| 12495 | 12495 | 40 LYME RD | ward-3 | Pole Leaning | 53222 | inactive | 2025-01-02 09:45 | 2025-01-02 | 42.358933 | -71.223254 |
| 12308 | 12308 | 390 DEDHAM ST | ward-8 | Pole Leaning | 53222 | inactive | 2024-12-27 12:15 | 2025-05-09 | 42.308926 | -71.199002 |
| 11093 | 11093 | 15 CLARK STREET | ward-6 | Pole Leaning | 53222 | inactive | 2024-12-05 18:00 | 2024-12-11 | 42.322653 | -71.201014 |
| 10641 | 10641 | 119 OAK HILL ST | ward-8 | Pole Leaning | 53222 | inactive | 2024-11-25 13:45 | 2024-12-02 | 42.297358 | -71.180605 |
| 10510 | 10510 | 32 CLOVELLY RD | ward-7 | Pole Leaning | 53222 | inactive | 2024-11-22 14:30 | 2024-12-02 | 42.329856 | -71.1761 |
| 10497 | 10497 | 39 SUMMIT ST | ward-1 | Pole Leaning | 53222 | inactive | 2024-11-22 12:15 | 2024-12-19 | 42.35331 | -71.191588 |
| 10160 | 10160 | 106 PLEASANT ST | ward-6 | Pole Leaning | 53222 | inactive | 2024-11-14 16:00 | 2024-11-26 | 42.331103 | -71.199488 |
| 9966 | 9966 | 2 CLARK ST | ward-6 | Pole Leaning | 53222 | inactive | 2024-11-08 14:45 | 2024-11-12 | 42.323245 | -71.200397 |
| 9812 | 9812 | 112 WALTHAM ST | ward-3 | Pole Leaning | 53222 | active | 2024-11-07 11:15 | 42.362695 | -71.22484 | |
| 7772 | 7772 | 29 FAIRMONT AVE | ward-1 | Pole Leaning | 53222 | inactive | 2024-10-21 10:00 | 2024-10-28 | 42.349674 | -71.18874 |
| 7716 | 7716 | 42 SUMMIT ST | ward-1 | Pole Leaning | 53222 | inactive | 2024-10-21 06:45 | 2024-10-28 | 42.353058 | -71.191448 |
| 6612 | 6612 | 82 LOWELL AVE | ward-2 | Pole Leaning | 53222 | inactive | 2024-10-01 14:00 | 2024-10-16 | 42.354202 | -71.209114 |
| 6558 | 6558 | 441 WATERTOWN ST | ward-1 | Pole Leaning | 53222 | inactive | 2024-09-30 12:15 | 2024-09-30 | 42.359325 | -71.20373 |
| 5842 | 5842 | 21 CLARK STREET | ward-6 | Pole Leaning | 53222 | inactive | 2024-09-15 17:00 | 2024-09-30 | 42.322602 | -71.200708 |
| 5827 | 5827 | 80 TOLMAN ST | ward-3 | Pole Leaning | 53222 | inactive | 2024-09-14 07:45 | 2024-11-07 | 42.360804 | -71.234714 |
| 4153 | 4153 | 256 DORSET RD | ward-5 | Pole Leaning | 53222 | inactive | 2024-08-12 08:45 | 2024-08-16 | 42.329915 | -71.242008 |
| 4037 | 4037 | 117 HOMER STREET | ward-6 | Pole Leaning | 53222 | inactive | 2024-08-09 13:45 | 2024-08-12 | 42.335581 | -71.197967 |
| 3998 | 3998 | 9 PROSPECT ST WEST NEWTON MA 2465 | ward-3 | Pole Leaning | 53222 | inactive | 2024-08-09 07:30 | 2024-08-21 | 42.34659 | -71.23486 |
| 3997 | 3997 | 81 OXFORD RD NEWTON CENTRE MA 2459 | ward-6 | Pole Leaning | 53222 | active | 2024-08-09 07:30 | 42.324393 | -71.195273 | |
| 3996 | 3996 | 50 LEE RD NEWTON MA 2467 | ward-7 | Pole Leaning | 53222 | active | 2024-08-09 07:30 | 42.331897 | -71.169316 | |
| 3995 | 3995 | 5 WYKEHAM RD WEST NEWTON MA 2465 | ward-3 | Pole Leaning | 53222 | inactive | 2024-08-09 07:30 | 2025-09-25 | 42.343102 | -71.223758 |
| 3994 | 3994 | 1359 CENTRE ST NEWTON CENTRE MA 2459 | ward-6 | Pole Leaning | 53222 | inactive | 2024-08-09 07:30 | 2024-10-03 | 42.327715 | -71.196998 |
| 3989 | 3989 | 43 ALBEMARLE RD | ward-3 | Pole Leaning | 53222 | inactive | 2024-08-08 19:30 | 2024-08-10 | 42.363681 | -71.214242 |
| 3950 | 3950 | 134 WENDELL RD | ward-8 | Pole Leaning | 53222 | inactive | 2024-08-08 13:15 | 2025-11-10 | 42.309822 | -71.201652 |
| 3772 | 3772 | 12 PROSPECT ST | ward-3 | Pole Leaning | 53222 | inactive | 2024-08-07 07:30 | 2024-08-08 | 42.346763 | -71.234615 |
| 3667 | 3667 | 9 PROSPECT ST | ward-3 | Pole Leaning | 53222 | inactive | 2024-08-05 12:30 | 2024-08-08 | 42.34659 | -71.23486 |
| 3582 | 3582 | 81 OXFORD RD | ward-6 | Pole Leaning | 53222 | inactive | 2024-08-03 08:45 | 2024-08-08 | 42.324393 | -71.195273 |
| 3581 | 3581 | 47 STONE AVE | ward-7 | Pole Leaning | 53222 | inactive | 2024-08-03 08:45 | 2024-08-08 | 42.331897 | -71.169316 |
| 3578 | 3578 | 5 WYKEHAM RD | ward-3 | Pole Leaning | 53222 | inactive | 2024-08-03 08:30 | 2024-08-08 | 42.343102 | -71.223758 |
| 3577 | 3577 | 1359 CENTRE ST | ward-6 | Pole Leaning | 53222 | inactive | 2024-08-03 08:30 | 2024-08-08 | 42.327715 | -71.196998 |
| 2962 | 2962 | 20 SHADY HILL RD | ward-5 | Pole Leaning | 53222 | inactive | 2024-07-22 15:15 | 2024-11-05 | 42.315972 | -71.20328 |
| 2512 | 2512 | 400 HOMER STREET | ward-2 | Pole Leaning | 53222 | inactive | 2024-07-13 01:45 | 2024-11-22 | 42.337289 | -71.210756 |
| 2371 | 2371 | 536 WALNUT ST | ward-2 | Pole Leaning | 53222 | active | 2024-07-11 07:15 | 42.342836 | -71.205721 | |
| 2366 | 2366 | 542 WALNUT STREET | ward-2 | Pole Leaning | 53222 | inactive | 2024-07-10 19:45 | 2024-07-11 | 42.342561 | -71.205788 |
| 894 | 894 | 65 ASHMONT AVE | ward-1 | Pole Leaning | 53222 | inactive | 2024-11-25 | 42.356132 | -71.20308 | |
| 893 | 893 | 39 SUMMIT ST | ward-1 | Pole Leaning | 53222 | inactive | 2024-10-28 | 42.35331 | -71.191588 |
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]);