requests
74 rows where category_id = 53463 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 31335 | 31335 | 119 ELM ST | ward-3 | Gate Covers | 53463 | active | 2025-12-17 11:45 | 42.348852 | -71.229335 | |
| 31287 | 31287 | 16 AVERY PATH | ward-8 | Gate Covers | 53463 | inactive | 2025-12-16 14:15 | 2025-12-17 | 42.291711 | -71.183313 |
| 30579 | 30579 | 25 IRVING ST | ward-7 | Gate Covers | 53463 | inactive | 2025-12-01 07:15 | 2025-12-09 | 42.337638 | -71.189316 |
| 30204 | 30204 | 44 BULLOUGH PARK | ward-2 | Gate Covers | 53463 | inactive | 2025-11-21 14:30 | 2025-12-08 | 42.340914 | -71.20409 |
| 30090 | 30090 | 1293 WASHINGTON ST | ward-3 | Gate Covers | 53463 | inactive | 2025-11-19 12:45 | 2025-12-05 | 42.349536 | -71.226518 |
| 29382 | 29382 | 8 CENTRAL AVE | ward-2 | Gate Covers | 53463 | inactive | 2025-11-05 11:45 | 2025-11-06 | 42.356187 | -71.205863 |
| 28891 | 28891 | 18 ROCKLAND ST | ward-1 | Gate Covers | 53463 | inactive | 2025-10-28 13:15 | 2025-11-06 | 42.359976 | -71.191391 |
| 28446 | 28446 | 560 PARKER ST | ward-8 | Gate Covers | 53463 | inactive | 2025-10-20 09:15 | 2025-10-20 | 42.308532 | -71.197812 |
| 28028 | 28028 | 36 GREEN ST | ward-1 | Gate Covers | 53463 | inactive | 2025-10-10 09:30 | 2025-10-29 | 42.358932 | -71.197016 |
| 27997 | 27997 | 560 PARKER ST | ward-8 | Gate Covers | 53463 | inactive | 2025-10-09 15:30 | 2025-10-16 | 42.308532 | -71.197812 |
| 27688 | 27688 | 6 BONTEMPO RD | ward-8 | Gate Covers | 53463 | inactive | 2025-10-02 15:30 | 2025-10-06 | 42.293133 | -71.184429 |
| 27660 | 27660 | 6 SPAULDING LN | ward-8 | Gate Covers | 53463 | active | 2025-10-02 10:15 | 42.302628 | -71.176284 | |
| 27437 | 27437 | 170 WALTHAM ST | ward-3 | Gate Covers | 53463 | active | 2025-09-29 09:45 | 42.361254 | -71.223156 | |
| 27409 | 27409 | 989 CENTRE ST | ward-2 | Gate Covers | 53463 | inactive | 2025-09-28 12:45 | 2025-10-02 | 42.338403 | -71.193317 |
| 27358 | 27358 | 6 BONTEMPO RD | ward-8 | Gate Covers | 53463 | inactive | 2025-09-26 13:45 | 2025-10-01 | 42.293133 | -71.184429 |
| 26852 | 26852 | 176 WALTHAM ST | ward-3 | Gate Covers | 53463 | inactive | 2025-09-17 08:45 | 2025-09-25 | 42.361038 | -71.2229 |
| 26748 | 26748 | 55 WETHERELL ST | ward-5 | Gate Covers | 53463 | inactive | 2025-09-15 15:30 | 2025-10-02 | 42.31161 | -71.217342 |
| 26746 | 26746 | 176 WALTHAM ST | ward-3 | Gate Covers | 53463 | inactive | 2025-09-15 15:15 | 2025-09-16 | 42.361038 | -71.2229 |
| 26356 | 26356 | 6 BONTEMPO RD | ward-8 | Gate Covers | 53463 | inactive | 2025-09-08 16:30 | 2025-09-11 | 42.293133 | -71.184429 |
| 25874 | 25874 | 209 TREMONT ST | ward-1 | Gate Covers | 53463 | inactive | 2025-08-29 08:15 | 2025-09-03 | 42.353181 | -71.176806 |
| 25678 | 25678 | 21 CARVER RD | ward-5 | Gate Covers | 53463 | inactive | 2025-08-25 14:00 | 2025-09-23 | 42.32358 | -71.217401 |
| 25642 | 25642 | 1004 CENTRE ST | ward-7 | Gate Covers | 53463 | inactive | 2025-08-24 09:30 | 2025-09-16 | 42.337908 | -71.192732 |
| 25414 | 25414 | 6 ROLAND ST | ward-8 | Gate Covers | 53463 | inactive | 2025-08-19 10:30 | 2025-09-11 | 42.307056 | -71.209494 |
| 24558 | 24558 | 16 CHAPIN ROAD | ward-6 | Gate Covers | 53463 | inactive | 2025-08-03 20:15 | 2025-11-19 | 42.333634 | -71.200551 |
| 24548 | 24548 | 1671 BEACON ST | ward-5 | Gate Covers | 53463 | inactive | 2025-08-03 07:15 | 2025-08-08 | 42.32619 | -71.231999 |
| 24196 | 24196 | 424 DEDHAM ST | ward-8 | Gate Covers | 53463 | inactive | 2025-07-28 09:30 | 2025-08-25 | 42.308343 | -71.197542 |
| 23946 | 23946 | 160 RANDLETT PARK | ward-3 | Gate Covers | 53463 | inactive | 2025-07-23 08:45 | 2025-09-13 | 42.355305 | -71.223458 |
| 23942 | 23942 | 386 QUINOBEQUIN ROAD | ward-5 | Gate Covers | 53463 | inactive | 2025-07-23 06:45 | 2025-07-24 | 42.322114 | -71.239691 |
| 21185 | 21185 | 209 UPLAND AVE | ward-8 | Gate Covers | 53463 | inactive | 2025-06-12 08:30 | 2025-06-16 | 42.311871 | -71.207559 |
| 20733 | 20733 | 889-891 BEACON STREET | ward-6 | Gate Covers | 53463 | inactive | 2025-06-05 08:45 | 2025-07-24 | 42.330411 | -71.198064 |
| 20422 | 20422 | 437 CHERRY ST | ward-3 | Gate Covers | 53463 | inactive | 2025-06-02 09:00 | 2025-06-09 | 42.349536 | -71.228637 |
| 20017 | 20017 | 209 UPLAND AVE | ward-8 | Gate Covers | 53463 | inactive | 2025-05-27 08:45 | 2025-05-30 | 42.311871 | -71.207559 |
| 19692 | 19692 | 436 DUDLEY RD | ward-8 | Gate Covers | 53463 | active | 2025-05-20 11:00 | 42.307704 | -71.179475 | |
| 18656 | 18656 | 10 OSSIPEE RD | ward-5 | Gate Covers | 53463 | inactive | 2025-05-01 13:45 | 2025-05-05 | 42.310449 | -71.219655 |
| 18592 | 18592 | 61 SHERBROOKE RD | ward-7 | Gate Covers | 53463 | inactive | 2025-04-30 12:30 | 2025-05-06 | 42.342147 | -71.185581 |
| 17808 | 17808 | 1552 CENTRE ST | ward-6 | Gate Covers | 53463 | inactive | 2025-04-14 22:00 | 2025-04-16 | 42.322149 | -71.20206 |
| 16481 | 16481 | 989 WATERTOWN ST | ward-3 | Gate Covers | 53463 | inactive | 2025-03-18 07:15 | 2025-04-29 | 42.34977 | -71.225739 |
| 16381 | 16381 | 173 AUBURNDALE AVE | ward-4 | Gate Covers | 53463 | inactive | 2025-03-14 17:00 | 2025-03-20 | 42.351183 | -71.239239 |
| 16070 | 16070 | 793 WASHINGTON STREET | ward-2 | Gate Covers | 53463 | inactive | 2025-03-10 07:45 | 2025-03-10 | 42.352068 | -71.206158 |
| 16003 | 16003 | 203 CHERRY ST | ward-3 | Gate Covers | 53463 | inactive | 2025-03-08 11:45 | 2025-03-20 | 42.357402 | -71.227755 |
| 15731 | 15731 | 86 DERBY STREET | ward-3 | Gate Covers | 53463 | inactive | 2025-03-04 14:30 | 2025-03-11 | 42.357277 | -71.227375 |
| 15657 | 15657 | 7 BORDER ST | ward-3 | Gate Covers | 53463 | inactive | 2025-03-03 09:30 | 2025-03-08 | 42.34923 | -71.229857 |
| 15595 | 15595 | 53 ROOSEVELT ROAD | ward-8 | Gate Covers | 53463 | inactive | 2025-02-28 11:00 | 2025-03-14 | 42.313863 | -71.193257 |
| 15480 | 15480 | 36 JASSET ST | ward-1 | Gate Covers | 53463 | inactive | 2025-02-26 11:30 | 2025-03-03 | 42.36354 | -71.197799 |
| 15342 | 15342 | 287 ELLIOT ST | ward-5 | Gate Covers | 53463 | inactive | 2025-02-24 14:00 | 2025-03-07 | 42.312728 | -71.221328 |
| 14681 | 14681 | 232 CHERRY STREET | ward-3 | Gate Covers | 53463 | inactive | 2025-02-14 14:15 | 2025-02-21 | 42.356326 | -71.227761 |
| 13959 | 13959 | 5 DERBY ST | ward-3 | Gate Covers | 53463 | inactive | 2025-01-31 08:45 | 2025-02-04 | 42.356394 | -71.2238 |
| 11458 | 11458 | 930 BEACON ST | ward-6 | Gate Covers | 53463 | inactive | 2024-12-10 16:30 | 2025-08-05 | 42.330329 | -71.199593 |
| 11371 | 11371 | 11 SHUTE PATH | ward-8 | Gate Covers | 53463 | inactive | 2024-12-10 12:00 | 2024-12-19 | 42.291074 | -71.184315 |
| 11124 | 11124 | 784 COMMONWEALTH AVE | ward-6 | Gate Covers | 53463 | inactive | 2024-12-06 11:00 | 2024-12-13 | 42.337646 | -71.198509 |
| 10288 | 10288 | 401 DUDLEY RD | ward-8 | Gate Covers | 53463 | inactive | 2024-11-18 15:30 | 2024-11-20 | 42.308113 | -71.18109 |
| 9693 | 9693 | 78 MOULTON ST | ward-4 | Gate Covers | 53463 | inactive | 2024-11-05 16:30 | 2024-11-06 | 42.328617 | -71.256647 |
| 9531 | 9531 | 1529 WASHINGTON ST | ward-3 | Gate Covers | 53463 | inactive | 2024-11-04 16:15 | 2024-11-14 | 42.345915 | -71.234067 |
| 9500 | 9500 | 545 PARKER ST | ward-8 | Gate Covers | 53463 | inactive | 2024-11-04 14:00 | 2024-11-19 | 42.309187 | -71.198048 |
| 8725 | 8725 | 47 STUART RD | ward-7 | Gate Covers | 53463 | inactive | 2024-10-29 14:30 | 2025-02-04 | 42.340496 | -71.185036 |
| 8563 | 8563 | 3 LAKE AVE | ward-6 | Gate Covers | 53463 | inactive | 2024-10-28 15:30 | 2024-11-19 | 42.330959 | -71.199038 |
| 7375 | 7375 | 329 LEXINGTON ST | ward-4 | Gate Covers | 53463 | active | 2024-10-17 15:00 | 42.3509 | -71.246797 | |
| 7219 | 7219 | 9 PROCTOR ST | ward-2 | Gate Covers | 53463 | inactive | 2024-10-16 13:30 | 2024-10-24 | 42.353425 | -71.211518 |
| 7023 | 7023 | NEWTON HIGHLANDS PLAYGROUND | ward-5 | Gate Covers | 53463 | inactive | 2024-10-11 15:30 | 2024-10-18 | 42.316342 | -71.207266 |
| 6863 | 6863 | 1516 WASHINGTON ST | ward-3 | Gate Covers | 53463 | inactive | 2024-10-08 16:30 | 2024-11-25 | 42.345635 | -71.233177 |
| 4966 | 4966 | 268 MELROSE ST | ward-4 | Gate Covers | 53463 | inactive | 2024-08-27 08:45 | 2024-08-27 | 42.347353 | -71.248644 |
| 4957 | 4957 | 32 SHORNECLIFFE RD | ward-7 | Gate Covers | 53463 | inactive | 2024-08-27 06:30 | 2024-08-27 | 42.349567 | -71.176703 |
| 4507 | 4507 | 193 OAK STREET | ward-5 | Gate Covers | 53463 | active | 2024-08-16 11:45 | 42.307596 | -71.216689 | |
| 4372 | 4372 | 362 WARD ST | ward-7 | Gate Covers | 53463 | inactive | 2024-08-14 16:00 | 2024-08-27 | 42.338629 | -71.187872 |
| 4250 | 4250 | 1550 CENTRE ST | ward-6 | Gate Covers | 53463 | inactive | 2024-08-13 06:15 | 2024-08-15 | 42.322128 | -71.202255 |
| 4199 | 4199 | 24 KODAYA RD | ward-5 | Gate Covers | 53463 | inactive | 2024-08-12 12:30 | 2024-08-27 | 42.321414 | -71.224891 |
| 4196 | 4196 | 8 CENTRAL AVE | ward-2 | Gate Covers | 53463 | inactive | 2024-08-12 12:00 | 2024-08-23 | 42.356191 | -71.205863 |
| 3538 | 3538 | 8 CENTRAL AVE | ward-2 | Gate Covers | 53463 | inactive | 2024-08-02 11:15 | 2024-08-02 | 42.356191 | -71.205863 |
| 3013 | 3013 | 8 CENTRAL AVE | ward-2 | Gate Covers | 53463 | inactive | 2024-07-23 11:30 | 2024-07-25 | 42.356191 | -71.205863 |
| 2293 | 2293 | 1574 CENTRE ST | ward-6 | Gate Covers | 53463 | inactive | 2024-07-10 06:45 | 2024-07-17 | 42.321652 | -71.202636 |
| 2028 | 2028 | 15 ALGONQUIN RD | ward-7 | Gate Covers | 53463 | inactive | 2024-07-05 14:45 | 2024-10-11 | 42.339779 | -71.169871 |
| 1149 | 1149 | 325 LOWELL AVE | ward-2 | Gate Covers | 53463 | active | 42.346095 | -71.211279 | ||
| 1148 | 1148 | 121 WARD ST | ward-7 | Gate Covers | 53463 | inactive | 2025-04-28 | 42.338027 | -71.1774 | |
| 1147 | 1147 | 103 TRUMAN RD | ward-8 | Gate Covers | 53463 | inactive | 2024-07-01 | 42.312836 | -71.199 |
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]);