requests
41 rows where category_id = 53224 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: active, added, removed, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 26557 | 26557 | 95 LANGLEY RD | ward-6 | Double Pole | 53224 | inactive | 2025-09-11 15:45 | 2025-11-17 | 42.329295 | -71.190396 |
| 23828 | 23828 | 12 MECHANIC ST | ward-5 | Double Pole | 53224 | active | 2025-07-21 13:45 | 42.312384 | -71.217617 | |
| 22279 | 22279 | 28 ARDMORE RD | ward-3 | Double Pole | 53224 | active | 2025-06-27 17:15 | 42.344163 | -71.233403 | |
| 20191 | 20191 | 34 BONAD ROAD | ward-3 | Double Pole | 53224 | inactive | 2025-05-28 22:00 | 2025-08-16 | 42.339299 | -71.220308 |
| 20135 | 20135 | 34 BONAD RD | ward-3 | Double Pole | 53224 | inactive | 2025-05-28 11:30 | 2025-05-28 | 42.339447 | -71.220267 |
| 16368 | 16368 | 51 WALDORF RD | ward-5 | Double Pole | 53224 | active | 2025-03-14 14:15 | 42.318909 | -71.219345 | |
| 13237 | 13237 | 26 GREYLOCK RD | ward-2 | Double Pole | 53224 | inactive | 2025-01-16 11:45 | 2025-08-18 | 42.345689 | -71.214937 |
| 11507 | 11507 | 996 WALNUT ST | ward-6 | Double Pole | 53224 | inactive | 2024-12-11 14:45 | 2025-04-09 | 42.327103 | -71.205944 |
| 11506 | 11506 | 50 HIGHLAND AVE | ward-2 | Double Pole | 53224 | inactive | 2024-12-11 14:45 | 2025-02-07 | 42.348988 | -71.209123 |
| 11505 | 11505 | 430 WATERTOWN ST | ward-1 | Double Pole | 53224 | inactive | 2024-12-11 14:45 | 2025-02-07 | 42.35932 | -71.202965 |
| 11504 | 11504 | 411 WATERTOWN ST | ward-1 | Double Pole | 53224 | inactive | 2024-12-11 14:45 | 2025-02-07 | 42.359982 | -71.202638 |
| 11503 | 11503 | 281 PRINCE ST | ward-3 | Double Pole | 53224 | inactive | 2024-12-11 14:45 | 2025-02-18 | 42.337922 | -71.220766 |
| 11502 | 11502 | 15 BONAD RD | ward-3 | Double Pole | 53224 | inactive | 2024-12-11 14:45 | 2025-02-18 | 42.338784 | -71.22021 |
| 11501 | 11501 | 1007 WALNUT ST | ward-6 | Double Pole | 53224 | inactive | 2024-12-11 14:45 | 2025-04-09 | 42.32697 | -71.206495 |
| 11500 | 11500 | 72 CHARLESBANK RD | ward-1 | Double Pole | 53224 | inactive | 2024-12-11 14:30 | 2025-02-07 | 42.3585 | -71.179392 |
| 11499 | 11499 | 525 WALNUT ST | ward-2 | Double Pole | 53224 | inactive | 2024-12-11 14:30 | 2025-02-07 | 42.343277 | -71.206262 |
| 11498 | 11498 | 35 BEACONWOOD RD | ward-6 | Double Pole | 53224 | inactive | 2024-12-11 14:30 | 2025-02-07 | 42.329975 | -71.210047 |
| 7570 | 7570 | 122 ROUNDWOOD RD | ward-5 | Double Pole | 53224 | inactive | 2024-10-18 13:00 | 2025-03-27 | 42.316013 | -71.219261 |
| 6608 | 6608 | 244 DORSET ROAD | ward-5 | Double Pole | 53224 | inactive | 2024-10-01 11:30 | 2024-10-02 | 42.33026 | -71.241914 |
| 4000 | 4000 | 19 HIGH ST NEWTON HIGHLANDS MA 2461 | ward-5 | Double Pole | 53224 | inactive | 2024-08-09 07:45 | 2024-12-09 | 42.313575 | -71.222383 |
| 3993 | 3993 | 81 TYLER TER NEWTON CENTRE MA 2459 | ward-6 | Double Pole | 53224 | active | 2024-08-09 07:30 | 42.332288 | -71.198586 | |
| 3579 | 3579 | 81 TYLER TER | ward-6 | Double Pole | 53224 | inactive | 2024-08-03 08:45 | 2024-08-08 | 42.332288 | -71.198586 |
| 3574 | 3574 | 19 HIGH ST | ward-5 | Double Pole | 53224 | inactive | 2024-08-03 08:30 | 2024-08-08 | 42.313575 | -71.222383 |
| 880 | 880 | 82 BULLOUGH PARK | ward-2 | Double Pole | 53224 | inactive | 2024-12-09 | 42.339819 | -71.204869 | |
| 879 | 879 | 819 WATERTOWN ST | ward-3 | Double Pole | 53224 | inactive | 2024-12-09 | 42.352498 | -71.218839 | |
| 878 | 878 | 790 WATERTOWN ST | ward-3 | Double Pole | 53224 | inactive | 2024-12-09 | 42.352545 | -71.217234 | |
| 877 | 877 | 65 HILLSIDE AVE | ward-2 | Double Pole | 53224 | inactive | 2025-04-09 | 42.34702 | -71.2225 | |
| 876 | 876 | 550 BEACON ST | ward-7 | Double Pole | 53224 | inactive | 2024-07-01 | 42.331706 | -71.182383 | |
| 875 | 875 | 340 CHESTNUT ST | ward-3 | Double Pole | 53224 | inactive | 2025-04-09 | 42.338021 | -71.223031 | |
| 874 | 874 | 34 BONAD RD | ward-3 | Double Pole | 53224 | inactive | 2024-07-01 | 42.339451 | -71.220266 | |
| 873 | 873 | 329 WATERTOWN ST | ward-1 | Double Pole | 53224 | inactive | 2024-12-09 | 42.361025 | -71.199932 | |
| 872 | 872 | 322 ADAMS ST | ward-1 | Double Pole | 53224 | inactive | 2025-02-07 | 42.355375 | -71.196026 | |
| 871 | 871 | 320 CHESTNUT ST | ward-3 | Double Pole | 53224 | inactive | 2024-12-11 | 42.338529 | -71.223101 | |
| 870 | 870 | 240 VALENTINE ST | ward-2 | Double Pole | 53224 | inactive | 2024-12-11 | 42.338413 | -71.214008 | |
| 869 | 869 | 212 CHESTNUT ST | ward-3 | Double Pole | 53224 | inactive | 2025-03-14 | 42.342387 | -71.223143 | |
| 868 | 868 | 2 CLAREMONT ST | ward-1 | Double Pole | 53224 | inactive | 2025-04-09 | 42.351136 | -71.190376 | |
| 867 | 867 | 180 HIGHLAND ST | ward-3 | Double Pole | 53224 | inactive | 2024-08-13 | 42.344198 | -71.223634 | |
| 866 | 866 | 18 TEMPLE ST | ward-3 | Double Pole | 53224 | inactive | 2024-12-02 | 42.345312 | -71.226355 | |
| 865 | 865 | 15 LOCKWOOD RD | ward-3 | Double Pole | 53224 | inactive | 2024-08-13 | 42.344946 | -71.226027 | |
| 864 | 864 | 120 OTIS ST | ward-2 | Double Pole | 53224 | inactive | 2024-12-11 | 42.346919 | -71.212246 | |
| 863 | 863 | 106 OLIVER RD | ward-5 | Double Pole | 53224 | inactive | 2024-08-13 | 42.320893 | -71.222692 |
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]);