requests
41 rows where category_id = 51137 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: ward, active, removed, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 31618 | 31618 | 10 WASHINGTON PARK | ward-2 | Street light - Knocked Down | 51137 | active | 2025-12-21 22:30 | 42.34914 | -71.201691 | |
| 31529 | 31529 | 18 WASHINGTON PARK | ward-2 | Street light - Knocked Down | 51137 | active | 2025-12-19 13:45 | 42.349095 | -71.202024 | |
| 31097 | 31097 | 34 OTIS ST | ward-2 | Street light - Knocked Down | 51137 | inactive | 2025-12-12 08:00 | 2025-12-18 | 42.34761 | -71.208162 |
| 31079 | 31079 | 34 OTIS STREET | ward-2 | Street light - Knocked Down | 51137 | inactive | 2025-12-11 17:15 | 2025-12-12 | 42.347493 | -71.207998 |
| 30911 | 30911 | 153 HARVARD STREET | ward-2 | Street light - Knocked Down | 51137 | active | 2025-12-09 07:30 | 42.347097 | -71.200853 | |
| 30776 | 30776 | 60 WELLS AVE | ward-8 | Street light - Knocked Down | 51137 | active | 2025-12-04 13:00 | 42.29451 | -71.200926 | |
| 30455 | 30455 | 15 ELIZABETH CIR | ward-3 | Street light - Knocked Down | 51137 | inactive | 2025-11-26 14:45 | 2025-12-18 | 42.33771 | -71.22852 |
| 30446 | 30446 | 39 BYFIELD RD | ward-5 | Street light - Knocked Down | 51137 | active | 2025-11-26 12:00 | 42.332733 | -71.22303 | |
| 30304 | 30304 | 28 SARGENT ST | ward-7 | Street light - Knocked Down | 51137 | inactive | 2025-11-24 12:45 | 2025-12-10 | 42.34662 | -71.182463 |
| 29627 | 29627 | 54 JEROME AVE | ward-3 | Street light - Knocked Down | 51137 | inactive | 2025-11-10 15:00 | 2025-12-18 | 42.359715 | -71.22933 |
| 28588 | 28588 | 144 ELLIOT ST | ward-5 | Street light - Knocked Down | 51137 | inactive | 2025-10-22 10:00 | 2025-10-27 | 42.314283 | -71.215263 |
| 28481 | 28481 | 128 WESTLAND AVE | ward-3 | Street light - Knocked Down | 51137 | active | 2025-10-20 13:45 | 42.354936 | -71.22906 | |
| 28269 | 28269 | 1 BACON ST | ward-1 | Street light - Knocked Down | 51137 | active | 2025-10-15 14:45 | 42.358068 | -71.186643 | |
| 27445 | 27445 | 503 BOYLSTON ST | ward-6 | Street light - Knocked Down | 51137 | inactive | 2025-09-29 10:45 | 2025-09-30 | 42.319116 | -71.189825 |
| 27126 | 27126 | 20 AUSTIN ST | ward-2 | Street light - Knocked Down | 51137 | active | 2025-09-23 09:30 | 42.350373 | -71.207604 | |
| 27018 | 27018 | 361 FANEUIL STREET | Street light - Knocked Down | 51137 | inactive | 2025-09-21 20:15 | 2025-09-22 | 42.35214 | -71.165619 | |
| 26719 | 26719 | 20 SWALLOW DR | ward-4 | Street light - Knocked Down | 51137 | inactive | 2025-09-15 11:30 | 2025-10-03 | 42.328791 | -71.260146 |
| 26613 | 26613 | 12 KINGSBURY RD | ward-7 | Street light - Knocked Down | 51137 | inactive | 2025-09-12 12:15 | 2025-09-23 | 42.329907 | -71.168634 |
| 24946 | 24946 | 145 WARREN ST | ward-6 | Street light - Knocked Down | 51137 | inactive | 2025-08-10 08:30 | 2025-08-13 | 42.329691 | -71.188511 |
| 24521 | 24521 | 32 HARVARD STREET | ward-2 | Street light - Knocked Down | 51137 | inactive | 2025-08-01 15:00 | 2025-08-18 | 42.351315 | -71.201582 |
| 21758 | 21758 | 38 BALCARRES RD | ward-2 | Street light - Knocked Down | 51137 | inactive | 2025-06-20 13:00 | 2025-06-25 | 42.344325 | -71.218062 |
| 18360 | 18360 | 16 BROOKDALE RD | ward-2 | Street light - Knocked Down | 51137 | inactive | 2025-04-25 15:45 | 2025-04-29 | 42.361794 | -71.214575 |
| 18098 | 18098 | 221 OTIS ST | ward-2 | Street light - Knocked Down | 51137 | inactive | 2025-04-22 09:15 | 2025-07-09 | 42.346449 | -71.216934 |
| 16504 | 16504 | 230 GRANT AVENUE | ward-7 | Street light - Knocked Down | 51137 | inactive | 2025-03-18 12:00 | 2025-11-06 | 42.332088 | -71.188319 |
| 16090 | 16090 | 2084 WASHINGTON ST | ward-5 | Street light - Knocked Down | 51137 | inactive | 2025-03-10 09:15 | 2025-03-27 | 42.329709 | -71.248563 |
| 15744 | 15744 | 18 AUSTIN ST | ward-2 | Street light - Knocked Down | 51137 | inactive | 2025-03-04 16:30 | 2025-03-07 | 42.350418 | -71.207573 |
| 15665 | 15665 | 265 CENTRE ST | ward-1 | Street light - Knocked Down | 51137 | active | 2025-03-03 10:15 | 42.358453 | -71.185023 | |
| 13052 | 13052 | 1820 WASHINGTON ST | ward-4 | Street light - Knocked Down | 51137 | inactive | 2025-01-13 09:30 | 2025-01-13 | 42.337111 | -71.240928 |
| 12515 | 12515 | 40 LYME RD | ward-3 | Street light - Knocked Down | 51137 | inactive | 2025-01-02 11:15 | 2025-01-03 | 42.358933 | -71.223254 |
| 12453 | 12453 | 239 RIVER ST | ward-4 | Street light - Knocked Down | 51137 | inactive | 2024-12-31 12:00 | 2025-01-02 | 42.355623 | -71.235713 |
| 11972 | 11972 | 108 JACKSON RD | ward-1 | Street light - Knocked Down | 51137 | inactive | 2024-12-20 16:45 | 2024-12-27 | 42.359271 | -71.194659 |
| 11729 | 11729 | 56 CHAPEL ST | ward-1 | Street light - Knocked Down | 51137 | inactive | 2024-12-16 09:00 | 2025-06-30 | 42.363382 | -71.20119 |
| 11637 | 11637 | 228 HIGHLAND AVE | ward-2 | Street light - Knocked Down | 51137 | active | 2024-12-13 11:45 | 42.347081 | -71.216616 | |
| 11423 | 11423 | 12 CHANNING ST | ward-1 | Street light - Knocked Down | 51137 | inactive | 2024-12-10 14:45 | 2025-02-14 | 42.357839 | -71.187716 |
| 10513 | 10513 | 244 DORSET RD | ward-5 | Street light - Knocked Down | 51137 | inactive | 2024-11-22 14:45 | 2024-11-25 | 42.330392 | -71.241883 |
| 10078 | 10078 | 54 PARK ST | ward-1 | Street light - Knocked Down | 51137 | inactive | 2024-11-13 07:30 | 2024-11-27 | 42.355156 | -71.182035 |
| 9928 | 9928 | 963 WATERTOWN STREET | ward-3 | Street light - Knocked Down | 51137 | inactive | 2024-11-08 07:15 | 2024-11-19 | 42.350094 | -71.224725 |
| 8422 | 8422 | 26 ROWENA ROAD | ward-6 | Street light - Knocked Down | 51137 | inactive | 2024-10-26 10:45 | 2024-10-29 | 42.322967 | -71.197441 |
| 8211 | 8211 | 934 WATERTOWN ST | ward-3 | Street light - Knocked Down | 51137 | inactive | 2024-10-24 08:45 | 2024-10-24 | 42.350302 | -71.223413 |
| 4577 | 4577 | 1479 WASHINGTON ST | ward-3 | Street light - Knocked Down | 51137 | inactive | 2024-08-19 09:30 | 2024-08-19 | 42.346753 | -71.232241 |
| 3279 | 3279 | 26 WASHINGTON PARK | ward-2 | Street light - Knocked Down | 51137 | inactive | 2024-07-29 10:30 | 2024-07-30 | 42.349054 | -71.202379 |
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]);