requests
46 rows where category_id = 51147 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: ward, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 31127 | 31127 | 5 MORSELAND AVE | ward-2 | Street Sign - Missing | 51147 | inactive | 2025-12-12 13:00 | 2025-12-16 | 42.340194 | -71.197475 |
| 30744 | 30744 | 216 WOODCLIFF RD | ward-6 | Street Sign - Missing | 51147 | inactive | 2025-12-04 08:45 | 2025-12-04 | 42.315048 | -71.200953 |
| 30465 | 30465 | 23 OTIS ST | ward-2 | Street Sign - Missing | 51147 | inactive | 2025-11-28 10:00 | 2025-12-01 | 42.348087 | -71.20787 |
| 29618 | 29618 | 2345 COMMONWEALTH AVE | ward-4 | Street Sign - Missing | 51147 | inactive | 2025-11-10 12:00 | 2025-11-12 | 42.346017 | -71.258238 |
| 29381 | 29381 | 20 WADE ST | ward-5 | Street Sign - Missing | 51147 | inactive | 2025-11-05 11:45 | 2025-11-10 | 42.318864 | -71.206317 |
| 29250 | 29250 | 1300 WALNUT ST | ward-5 | Street Sign - Missing | 51147 | inactive | 2025-11-03 15:15 | 2025-11-04 | 42.318099 | -71.202893 |
| 29240 | 29240 | 1300 WALNUT ST | ward-5 | Street Sign - Missing | 51147 | inactive | 2025-11-03 13:15 | 2025-11-03 | 42.318099 | -71.202893 |
| 28744 | 28744 | 3 EXMOOR ROAD | ward-7 | Street Sign - Missing | 51147 | inactive | 2025-10-24 14:45 | 2025-10-31 | 42.340277 | -71.185146 |
| 28704 | 28704 | 1295 CENTRE ST | ward-6 | Street Sign - Missing | 51147 | inactive | 2025-10-23 20:00 | 2025-10-24 | 42.329637 | -71.195346 |
| 28420 | 28420 | 124 HAGEN ROAD | ward-8 | Street Sign - Missing | 51147 | inactive | 2025-10-17 16:30 | 2025-10-21 | 42.317267 | -71.190088 |
| 28294 | 28294 | 2360 COMMONWEALTH AVENUE | ward-4 | Street Sign - Missing | 51147 | inactive | 2025-10-15 19:45 | 2025-10-16 | 42.34532 | -71.258231 |
| 28052 | 28052 | 77 HEATHERLAND RD | ward-8 | Street Sign - Missing | 51147 | inactive | 2025-10-10 13:45 | 2025-10-14 | 42.313725 | -71.208819 |
| 27588 | 27588 | 131 HARVARD ST | ward-2 | Street Sign - Missing | 51147 | inactive | 2025-10-01 08:45 | 2025-10-01 | 42.348006 | -71.201228 |
| 27336 | 27336 | 28 KINGMAN RD | ward-6 | Street Sign - Missing | 51147 | inactive | 2025-09-26 10:45 | 2025-09-29 | 42.3279 | -71.207474 |
| 25841 | 25841 | 15 MORSELAND AVE | ward-2 | Street Sign - Missing | 51147 | inactive | 2025-08-28 10:45 | 2025-09-03 | 42.33996 | -71.197506 |
| 25483 | 25483 | 12 GREEN ST | ward-1 | Street Sign - Missing | 51147 | inactive | 2025-08-20 12:30 | 2025-08-21 | 42.359346 | -71.195994 |
| 25479 | 25479 | 40 BRISTOL RD | ward-3 | Street Sign - Missing | 51147 | inactive | 2025-08-20 12:15 | 2025-08-25 | 42.337242 | -71.222018 |
| 25478 | 25478 | 1395 COMMONWEALTH AVE | ward-3 | Street Sign - Missing | 51147 | inactive | 2025-08-20 12:15 | 2025-08-25 | 42.337332 | -71.224038 |
| 25474 | 25474 | 56 ACACIA AVE | ward-7 | Street Sign - Missing | 51147 | inactive | 2025-08-20 12:00 | 2025-08-21 | 42.331761 | -71.167568 |
| 23834 | 23834 | 320 DUDLEY ROAD | ward-8 | Street Sign - Missing | 51147 | inactive | 2025-07-21 14:30 | 2025-07-23 | 42.310642 | -71.181412 |
| 20839 | 20839 | 474 WOODWARD STREET | ward-5 | Street Sign - Missing | 51147 | inactive | 2025-06-06 11:45 | 2025-06-09 | 42.32651 | -71.230364 |
| 20609 | 20609 | 48 RUTHVEN ROAD | ward-7 | Street Sign - Missing | 51147 | inactive | 2025-06-04 00:00 | 2025-06-04 | 42.348089 | -71.183005 |
| 19594 | 19594 | 37 COMMONWEALTH AVE | ward-7 | Street Sign - Missing | 51147 | inactive | 2025-05-19 10:30 | 2025-05-19 | 42.339924 | -71.16831 |
| 18683 | 18683 | 119 B CHARLESBANK ROAD | ward-1 | Street Sign - Missing | 51147 | inactive | 2025-05-01 22:45 | 2025-05-09 | 42.35897 | -71.18153 |
| 18458 | 18458 | 195 SUMNER ST | ward-6 | Street Sign - Missing | 51147 | inactive | 2025-04-28 15:15 | 2025-04-29 | 42.331302 | -71.192417 |
| 17688 | 17688 | 1000 COMMONWEALTH AVE | ward-2 | Street Sign - Missing | 51147 | inactive | 2025-04-11 10:00 | 2025-04-16 | 42.337377 | -71.208617 |
| 15676 | 15676 | 33 ASPEN AVE | ward-4 | Street Sign - Missing | 51147 | inactive | 2025-03-03 13:00 | 2025-03-06 | 42.339447 | -71.247002 |
| 15286 | 15286 | 416 GROVE ST | ward-4 | Street Sign - Missing | 51147 | inactive | 2025-02-23 18:00 | 2025-02-27 | 42.333867 | -71.2535 |
| 12982 | 12982 | 3 POND AVE | ward-1 | Street Sign - Missing | 51147 | inactive | 2025-01-10 10:45 | 2025-01-17 | 42.360294 | -71.191921 |
| 12643 | 12643 | 320 NEEDHAM STREET | ward-8 | Street Sign - Missing | 51147 | inactive | 2025-01-06 01:00 | 2025-01-06 | 42.306969 | -71.216565 |
| 10357 | 10357 | 183 WINCHESTER STREET | ward-8 | Street Sign - Missing | 51147 | inactive | 2024-11-20 09:15 | 2024-11-20 | 42.313594 | -71.209243 |
| 10257 | 10257 | COLUMBIA AVE | ward-8 | Street Sign - Missing | 51147 | inactive | 2024-11-18 11:15 | 2024-11-26 | 42.313956 | -71.210941 |
| 10256 | 10256 | 71 HEATHERLAND RD | ward-8 | Street Sign - Missing | 51147 | inactive | 2024-11-18 11:15 | 2024-11-21 | 42.313662 | -71.208626 |
| 10255 | 10255 | 104 COLUMBIA AVE | ward-8 | Street Sign - Missing | 51147 | inactive | 2024-11-18 11:15 | 2024-12-02 | 42.313583 | -71.210076 |
| 10105 | 10105 | 105 CARLTON RD | ward-5 | Street Sign - Missing | 51147 | inactive | 2024-11-13 11:30 | 2024-11-20 | 42.324904 | -71.241886 |
| 9745 | 9745 | 187 WOODCLIFF RD | ward-5 | Street Sign - Missing | 51147 | inactive | 2024-11-06 15:15 | 2024-11-07 | 42.315961 | -71.20121 |
| 9721 | 9721 | 137 WAVERLEY AVE | ward-1 | Street Sign - Missing | 51147 | inactive | 2024-11-06 08:45 | 2024-11-06 | 42.351062 | -71.180191 |
| 9048 | 9048 | 10 JOHN ST | ward-6 | Street Sign - Missing | 51147 | inactive | 2024-10-31 09:30 | 2024-11-08 | 42.319673 | -71.182079 |
| 5584 | 5584 | 56 BARNSTABLE RD | ward-3 | Street Sign - Missing | 51147 | inactive | 2024-09-10 09:45 | 2024-09-23 | 42.339766 | -71.221838 |
| 4542 | 4542 | 100 NEEDHAM STREET | ward-8 | Street Sign - Missing | 51147 | inactive | 2024-08-17 09:15 | 2024-08-20 | 42.314046 | -71.21134 |
| 4440 | 4440 | 86 PAGE ROAD | ward-2 | Street Sign - Missing | 51147 | inactive | 2024-08-15 17:00 | 2024-08-20 | 42.354407 | -71.211947 |
| 3185 | 3185 | 28 WADE ST | ward-5 | Street Sign - Missing | 51147 | inactive | 2024-07-26 12:45 | 2024-08-06 | 42.318685 | -71.206088 |
| 3174 | 3174 | 1330 CENTRE STREET | ward-6 | Street Sign - Missing | 51147 | inactive | 2024-07-26 10:30 | 2024-07-30 | 42.328476 | -71.196046 |
| 2801 | 2801 | 11 ELM ST | ward-3 | Street Sign - Missing | 51147 | inactive | 2024-07-18 12:30 | 2024-07-18 | 42.352085 | -71.231104 |
| 2294 | 2294 | 963 WATERTOWN STREET | ward-3 | Street Sign - Missing | 51147 | inactive | 2024-07-10 07:45 | 2024-07-16 | 42.35011 | -71.2248 |
| 1825 | 1825 | 1224 BOYLSTON ST | ward-5 | Street Sign - Missing | 51147 | inactive | 2024-07-02 08:45 | 2024-07-02 | 42.317209 | -71.222856 |
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]);