requests
143 rows where category_id = 53459 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 31315 | 31315 | 39 DEVON RD | ward-6 | Sign Knocked Down | 53459 | inactive | 2025-12-16 21:30 | 2025-12-17 | 42.335316 | -71.189091 |
| 31260 | 31260 | 5 EVELYN RD | ward-5 | Sign Knocked Down | 53459 | inactive | 2025-12-16 08:45 | 2025-12-16 | 42.330816 | -71.218706 |
| 30729 | 30729 | 1146 CHESTNUT ST | ward-5 | Sign Knocked Down | 53459 | inactive | 2025-12-03 17:15 | 2025-12-04 | 42.309972 | -71.223539 |
| 30408 | 30408 | 36 INDIANA TER | ward-5 | Sign Knocked Down | 53459 | inactive | 2025-11-25 15:45 | 2025-11-28 | 42.309891 | -71.22236 |
| 30288 | 30288 | 186 LANGLEY RD | ward-7 | Sign Knocked Down | 53459 | inactive | 2025-11-24 10:15 | 2025-11-24 | 42.326955 | -71.187773 |
| 29866 | 29866 | 5 GLEN RD | ward-7 | Sign Knocked Down | 53459 | inactive | 2025-11-16 16:30 | 2025-11-17 | 42.327576 | -71.187953 |
| 29855 | 29855 | 126 GLEN AVENUE | ward-7 | Sign Knocked Down | 53459 | inactive | 2025-11-16 09:45 | 2025-11-17 | 42.327651 | -71.188107 |
| 29370 | 29370 | 186 LANGLEY RD | ward-7 | Sign Knocked Down | 53459 | inactive | 2025-11-05 10:45 | 2025-11-06 | 42.326955 | -71.187773 |
| 29114 | 29114 | 360 UPLAND AVE | ward-8 | Sign Knocked Down | 53459 | inactive | 2025-10-31 16:15 | 2025-11-02 | 42.307452 | -71.203464 |
| 28936 | 28936 | 251 MILL ST | ward-2 | Sign Knocked Down | 53459 | inactive | 2025-10-29 09:00 | 2025-10-29 | 42.342588 | -71.203433 |
| 28773 | 28773 | 324 CENTRE ST | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-10-26 08:45 | 2025-10-28 | 42.357411 | -71.184042 |
| 28648 | 28648 | 51 MIDDLESEX RD | ward-7 | Sign Knocked Down | 53459 | inactive | 2025-10-22 14:15 | 2025-10-24 | 42.326235 | -71.162937 |
| 28337 | 28337 | 287 JACKSON STREET | ward-6 | Sign Knocked Down | 53459 | inactive | 2025-10-16 10:30 | 2025-10-16 | 42.319137 | -71.19426 |
| 28191 | 28191 | 5 BRAE BURN RD | ward-4 | Sign Knocked Down | 53459 | inactive | 2025-10-14 12:15 | 2025-10-16 | 42.344181 | -71.239509 |
| 27803 | 27803 | 326 FULLER ST | ward-5 | Sign Knocked Down | 53459 | inactive | 2025-10-06 09:00 | 2025-10-06 | 42.338088 | -71.233281 |
| 27673 | 27673 | 627 CHESTNUT ST | ward-5 | Sign Knocked Down | 53459 | inactive | 2025-10-02 11:15 | 2025-10-02 | 42.328359 | -71.226437 |
| 27363 | 27363 | 2 MOODY ST | ward-6 | Sign Knocked Down | 53459 | inactive | 2025-09-26 14:30 | 2025-09-29 | 42.319701 | -71.179205 |
| 26922 | 26922 | 181 LEXINGTON ST | ward-4 | Sign Knocked Down | 53459 | inactive | 2025-09-18 10:30 | 2025-09-18 | 42.355071 | -71.243204 |
| 26818 | 26818 | 38 ORIENT AVE | ward-6 | Sign Knocked Down | 53459 | inactive | 2025-09-16 13:45 | 2025-09-23 | 42.335982 | -71.201007 |
| 26702 | 26702 | 43 WALNUT ST | ward-2 | Sign Knocked Down | 53459 | inactive | 2025-09-15 09:30 | 2025-09-17 | 42.357834 | -71.211245 |
| 26701 | 26701 | 181 LEXINGTON ST | ward-4 | Sign Knocked Down | 53459 | inactive | 2025-09-15 09:30 | 2025-09-16 | 42.355071 | -71.243204 |
| 26512 | 26512 | 14 SAINT JAMES ST | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-09-11 11:00 | 2025-09-15 | 42.358194 | -71.180397 |
| 26309 | 26309 | 687 WATERTOWN ST | ward-2 | Sign Knocked Down | 53459 | inactive | 2025-09-08 08:15 | 2025-09-09 | 42.35463 | -71.21349 |
| 25370 | 25370 | 439 WASHINGTON ST | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-08-18 15:30 | 2025-08-20 | 42.355935 | -71.190873 |
| 24997 | 24997 | 1236 CHESTNUT STREET | ward-5 | Sign Knocked Down | 53459 | inactive | 2025-08-11 14:45 | 2025-08-11 | 42.309563 | -71.220401 |
| 24987 | 24987 | 35 MIGNON ROAD | ward-3 | Sign Knocked Down | 53459 | inactive | 2025-08-11 13:45 | 2025-08-12 | 42.340436 | -71.231795 |
| 24598 | 24598 | 66 FAIRWAY DR | ward-3 | Sign Knocked Down | 53459 | inactive | 2025-08-04 11:00 | 2025-08-05 | 42.354846 | -71.218112 |
| 24188 | 24188 | 559 PARKER ST | ward-8 | Sign Knocked Down | 53459 | inactive | 2025-07-28 09:15 | 2025-07-31 | 42.308703 | -71.198298 |
| 24187 | 24187 | 39 WOODWARD ST | ward-6 | Sign Knocked Down | 53459 | inactive | 2025-07-28 09:15 | 2025-07-29 | 42.319998 | -71.213171 |
| 24158 | 24158 | 192 PINE RIDGE RD | ward-5 | Sign Knocked Down | 53459 | inactive | 2025-07-26 07:00 | 2025-07-29 | 42.326694 | -71.228588 |
| 23132 | 23132 | 115 HUNNEWELL AVENUE | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-07-11 19:15 | 2025-07-14 | 42.356405 | -71.176987 |
| 22828 | 22828 | 6 BLACKSTONE TER | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-07-08 11:45 | 2025-07-08 | 42.350094 | -71.179358 |
| 22610 | 22610 | 2039 COMMONWEALTH AVE | ward-4 | Sign Knocked Down | 53459 | inactive | 2025-07-03 10:30 | 2025-07-08 | 42.347727 | -71.244842 |
| 22039 | 22039 | 31 CLYDE ST | ward-2 | Sign Knocked Down | 53459 | inactive | 2025-06-24 16:45 | 2025-06-25 | 42.346872 | -71.204049 |
| 21929 | 21929 | 85 HOMER ST | ward-6 | Sign Knocked Down | 53459 | inactive | 2025-06-23 15:45 | 2025-06-24 | 42.335874 | -71.196822 |
| 21429 | 21429 | 6 HYDE AVE | ward-7 | Sign Knocked Down | 53459 | inactive | 2025-06-16 20:45 | 2025-06-17 | 42.349725 | -71.186454 |
| 21357 | 21357 | 9 CEDAR STREET | ward-2 | Sign Knocked Down | 53459 | inactive | 2025-06-16 08:45 | 2025-06-16 | 42.340729 | -71.198782 |
| 21113 | 21113 | 3 CEDAR ST | ward-2 | Sign Knocked Down | 53459 | inactive | 2025-06-11 09:00 | 2025-06-17 | 42.340716 | -71.199077 |
| 20397 | 20397 | 169 ALBEMARLE RD | ward-3 | Sign Knocked Down | 53459 | inactive | 2025-06-01 16:15 | 2025-06-03 | 42.360336 | -71.217095 |
| 19640 | 19640 | 255 PARKER ST | ward-6 | Sign Knocked Down | 53459 | inactive | 2025-05-19 15:30 | 2025-05-20 | 42.318594 | -71.19468 |
| 19537 | 19537 | 287 JACKSON ST | ward-6 | Sign Knocked Down | 53459 | inactive | 2025-05-17 17:00 | 2025-05-19 | 42.319287 | -71.194059 |
| 19526 | 19526 | 287 JACKSON STREET | ward-6 | Sign Knocked Down | 53459 | inactive | 2025-05-17 00:15 | 2025-05-20 | 42.319163 | -71.194029 |
| 19199 | 19199 | 34 SIMPSON ST | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-05-12 10:00 | 2025-05-13 | 42.356943 | -71.174003 |
| 19158 | 19158 | 257 NEWTONVILLE AVE | ward-2 | Sign Knocked Down | 53459 | inactive | 2025-05-10 12:15 | 2025-05-12 | 42.352812 | -71.197425 |
| 19134 | 19134 | 55 INDIAN RIDGE RD | ward-8 | Sign Knocked Down | 53459 | inactive | 2025-05-09 14:00 | 2025-05-12 | 42.296184 | -71.183039 |
| 19018 | 19018 | 120 EDINBORO STREET | ward-2 | Sign Knocked Down | 53459 | inactive | 2025-05-07 18:45 | 2025-05-12 | 42.355398 | -71.212622 |
| 18880 | 18880 | 9 WADE STREET | ward-5 | Sign Knocked Down | 53459 | inactive | 2025-05-06 09:30 | 2025-05-08 | 42.319068 | -71.207226 |
| 18102 | 18102 | 377 LOWELL AVE | ward-2 | Sign Knocked Down | 53459 | inactive | 2025-04-22 09:45 | 2025-04-23 | 42.344414 | -71.211429 |
| 18087 | 18087 | 65 OAK ST | ward-5 | Sign Knocked Down | 53459 | inactive | 2025-04-22 08:45 | 2025-04-25 | 42.310449 | -71.220919 |
| 18054 | 18054 | 285 ELLIOT ST | ward-5 | Sign Knocked Down | 53459 | inactive | 2025-04-20 15:45 | 2025-04-23 | 42.312867 | -71.221252 |
| 17962 | 17962 | 560 PARKER ST | ward-8 | Sign Knocked Down | 53459 | inactive | 2025-04-17 11:30 | 2025-04-25 | 42.308532 | -71.197812 |
| 17827 | 17827 | 8 VARICK RD | ward-5 | Sign Knocked Down | 53459 | inactive | 2025-04-15 10:00 | 2025-04-23 | 42.328953 | -71.245233 |
| 17768 | 17768 | 2 BRYON RD | ward-8 | Sign Knocked Down | 53459 | inactive | 2025-04-14 12:30 | 2025-04-14 | 42.302691 | -71.167352 |
| 17571 | 17571 | 96 MONADNOCK RD | ward-7 | Sign Knocked Down | 53459 | inactive | 2025-04-09 09:00 | 2025-04-09 | 42.334335 | -71.177684 |
| 17454 | 17454 | 475 WASHINGTON ST | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-04-08 09:15 | 2025-04-09 | 42.35562 | -71.192408 |
| 17199 | 17199 | 321 WALTHAM ST | ward-3 | Sign Knocked Down | 53459 | inactive | 2025-04-02 09:15 | 2025-04-02 | 42.356133 | -71.223777 |
| 16789 | 16789 | 40 NEEDHAM ST | ward-8 | Sign Knocked Down | 53459 | inactive | 2025-03-25 14:45 | 2025-03-26 | 42.315759 | -71.209782 |
| 16503 | 16503 | 28 AUSTIN ST | ward-2 | Sign Knocked Down | 53459 | inactive | 2025-03-18 12:00 | 2025-03-18 | 42.350346 | -71.208243 |
| 16398 | 16398 | 79 WHEELER RD | ward-8 | Sign Knocked Down | 53459 | inactive | 2025-03-15 18:00 | 2025-03-17 | 42.310125 | -71.193915 |
| 16338 | 16338 | 40 NEEDHAM STREET | ward-8 | Sign Knocked Down | 53459 | inactive | 2025-03-13 21:45 | 2025-03-24 | 42.315821 | -71.210026 |
| 16337 | 16337 | 281 NEEDHAM STREET | ward-5 | Sign Knocked Down | 53459 | inactive | 2025-03-13 21:45 | 2025-03-17 | 42.308581 | -71.215433 |
| 16336 | 16336 | 256 PARKER STREET | ward-8 | Sign Knocked Down | 53459 | inactive | 2025-03-13 21:45 | 2025-03-17 | 42.318675 | -71.194351 |
| 16121 | 16121 | 214 CONCORD ST | ward-4 | Sign Knocked Down | 53459 | inactive | 2025-03-10 12:30 | 2025-03-11 | 42.327252 | -71.259197 |
| 16112 | 16112 | 6 SPAULDING LN | ward-8 | Sign Knocked Down | 53459 | inactive | 2025-03-10 11:30 | 2025-03-11 | 42.302628 | -71.176284 |
| 15952 | 15952 | 153 WESTCHESTER ROAD | ward-2 | Sign Knocked Down | 53459 | inactive | 2025-03-07 16:00 | 2025-03-11 | 42.344813 | -71.194158 |
| 15857 | 15857 | 88 SAINT JAMES STREET | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-03-07 01:15 | 2025-03-10 | 42.35872 | -71.180232 |
| 15856 | 15856 | 3 CHARLESBANK ROAD | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-03-07 01:15 | 2025-03-10 | 42.35834 | -71.174868 |
| 15855 | 15855 | 221 JACKSON STREET | ward-8 | Sign Knocked Down | 53459 | inactive | 2025-03-07 01:15 | 2025-03-10 | 42.318798 | -71.194308 |
| 15854 | 15854 | 213 CALIFORNIA STREET | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-03-07 01:15 | 2025-03-10 | 42.364904 | -71.196518 |
| 15818 | 15818 | 904 CENTRE ST | ward-7 | Sign Knocked Down | 53459 | inactive | 2025-03-06 10:00 | 2025-03-10 | 42.341256 | -71.192075 |
| 15699 | 15699 | 40 WOODCHESTER DR | ward-7 | Sign Knocked Down | 53459 | inactive | 2025-03-04 09:00 | 2025-03-05 | 42.339402 | -71.177927 |
| 15565 | 15565 | 78 PLAINFIELD ST | ward-5 | Sign Knocked Down | 53459 | inactive | 2025-02-27 14:30 | 2025-03-03 | 42.326622 | -71.222652 |
| 15458 | 15458 | 15 WALSINGHAM ST | ward-4 | Sign Knocked Down | 53459 | inactive | 2025-02-26 08:45 | 2025-02-26 | 42.330942 | -71.248613 |
| 14940 | 14940 | 47 TERRACE AVE | ward-6 | Sign Knocked Down | 53459 | inactive | 2025-02-18 11:00 | 2025-02-24 | 42.324228 | -71.210822 |
| 14920 | 14920 | 9 ELDREDGE ST | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-02-18 10:15 | 2025-02-21 | 42.355503 | -71.18343 |
| 14696 | 14696 | 130 WHEELER RD | ward-8 | Sign Knocked Down | 53459 | inactive | 2025-02-14 17:15 | 2025-02-26 | 42.310017 | -71.191786 |
| 14672 | 14672 | 124 MCCARTHY RD | ward-8 | Sign Knocked Down | 53459 | inactive | 2025-02-14 13:00 | 2025-02-20 | 42.295788 | -71.186832 |
| 14375 | 14375 | 80 HANCOCK ST | ward-4 | Sign Knocked Down | 53459 | inactive | 2025-02-09 17:15 | 2025-02-12 | 42.34366 | -71.250125 |
| 14343 | 14343 | 2 CHARLES ST | ward-4 | Sign Knocked Down | 53459 | inactive | 2025-02-08 20:45 | 2025-02-12 | 42.344613 | -71.255088 |
| 14323 | 14323 | 2–98 HUNNEWELL CIR | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-02-08 08:00 | 2025-02-08 | 42.355716 | -71.179139 |
| 14307 | 14307 | 248 HOMER STREET | ward-6 | Sign Knocked Down | 53459 | inactive | 2025-02-07 14:45 | 2025-02-12 | 42.335297 | -71.204308 |
| 14157 | 14157 | 2105 COMMONWEALTH AVE | ward-4 | Sign Knocked Down | 53459 | inactive | 2025-02-04 11:00 | 2025-02-05 | 42.348243 | -71.247306 |
| 14116 | 14116 | 14 SAINT JAMES TERRACE | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-02-04 07:45 | 2025-02-05 | 42.35939 | -71.179952 |
| 13912 | 13912 | 255 NEWTONVILLE AVE | ward-2 | Sign Knocked Down | 53459 | inactive | 2025-01-30 10:30 | 2025-01-31 | 42.352839 | -71.197322 |
| 13835 | 13835 | 191 MILL STREET | ward-2 | Sign Knocked Down | 53459 | inactive | 2025-01-28 16:00 | 2025-02-05 | 42.341815 | -71.200735 |
| 13814 | 13814 | 268 PRINCE ST | ward-3 | Sign Knocked Down | 53459 | inactive | 2025-01-28 13:15 | 2025-01-31 | 42.338637 | -71.220938 |
| 13468 | 13468 | 2282 COMMONWEALTH AVE | ward-4 | Sign Knocked Down | 53459 | inactive | 2025-01-22 07:30 | 2025-01-23 | 42.346494 | -71.255277 |
| 13397 | 13397 | 45 OLD COLONY RD | ward-7 | Sign Knocked Down | 53459 | inactive | 2025-01-21 09:45 | 2025-01-23 | 42.335586 | -71.173508 |
| 13366 | 13366 | 10 NONANTUM STREET | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-01-20 22:30 | 2025-01-21 | 42.35018 | -71.175443 |
| 13364 | 13364 | 237 FRANKLIN ST | ward-7 | Sign Knocked Down | 53459 | inactive | 2025-01-20 21:30 | 2025-01-21 | 42.350009 | -71.181761 |
| 13312 | 13312 | 25 GREEN ST | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-01-17 17:00 | 2025-01-21 | 42.359346 | -71.196858 |
| 13303 | 13303 | 36 GREEN ST | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-01-17 14:00 | 2025-01-21 | 42.358932 | -71.197016 |
| 13096 | 13096 | 2–78 GRANT AVE | ward-7 | Sign Knocked Down | 53459 | inactive | 2025-01-13 17:15 | 2025-01-14 | 42.33933 | -71.183816 |
| 13080 | 13080 | 84 FAIRMONT AVE | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-01-13 13:00 | 2025-01-23 | 42.350039 | -71.191302 |
| 13065 | 13065 | 85 CHARLESBANK RD | ward-1 | Sign Knocked Down | 53459 | inactive | 2025-01-13 10:15 | 2025-01-13 | 42.358825 | -71.179978 |
| 13045 | 13045 | 6 AGAWAM RD | ward-5 | Sign Knocked Down | 53459 | inactive | 2025-01-13 09:00 | 2025-01-13 | 42.32938 | -71.246498 |
| 13039 | 13039 | 5 HAGEN RD | ward-8 | Sign Knocked Down | 53459 | inactive | 2025-01-13 08:30 | 2025-01-13 | 42.315991 | -71.1948 |
| 13021 | 13021 | 6 HAGEN RD | ward-8 | Sign Knocked Down | 53459 | inactive | 2025-01-11 11:30 | 2025-01-13 | 42.316346 | -71.194703 |
| 13018 | 13018 | 2004 BEACON ST | ward-5 | Sign Knocked Down | 53459 | inactive | 2025-01-11 07:30 | 2025-01-14 | 42.329646 | -71.246552 |
| 13014 | 13014 | 6 AGAWAM ROAD | ward-5 | Sign Knocked Down | 53459 | inactive | 2025-01-10 16:30 | 2025-01-14 | 42.3293 | -71.246644 |
| 12883 | 12883 | 5 GRAYSON LN | ward-4 | Sign Knocked Down | 53459 | inactive | 2025-01-08 12:00 | 2025-01-17 | 42.327974 | -71.262866 |
| 12383 | 12383 | 1 WABAN ST | ward-1 | Sign Knocked Down | 53459 | inactive | 2024-12-30 15:45 | 2025-01-02 | 42.357761 | -71.189094 |
| 12362 | 12362 | 21 THORNTON ST | ward-1 | Sign Knocked Down | 53459 | inactive | 2024-12-30 12:30 | 2025-01-02 | 42.357578 | -71.189123 |
| 12186 | 12186 | 75 SUMMIT ST | ward-1 | Sign Knocked Down | 53459 | inactive | 2024-12-24 09:00 | 2024-12-26 | 42.352326 | -71.192338 |
| 12185 | 12185 | 151 VALENTINE ST | ward-2 | Sign Knocked Down | 53459 | inactive | 2024-12-24 09:00 | 2024-12-26 | 42.339924 | -71.21738 |
| 11960 | 11960 | 53 BRANDEIS RD | ward-8 | Sign Knocked Down | 53459 | inactive | 2024-12-20 16:15 | 2024-12-23 | 42.313442 | -71.192357 |
| 11955 | 11955 | 67 ROOSEVELT RD | ward-8 | Sign Knocked Down | 53459 | inactive | 2024-12-20 16:00 | 2024-12-24 | 42.313657 | -71.192815 |
| 11925 | 11925 | 240 CALIFORNIA ST | ward-1 | Sign Knocked Down | 53459 | inactive | 2024-12-20 09:00 | 2024-12-24 | 42.364647 | -71.198072 |
| 11661 | 11661 | 78 PLAINFIELD STREET | ward-5 | Sign Knocked Down | 53459 | inactive | 2024-12-13 16:45 | 2024-12-27 | 42.326461 | -71.222375 |
| 11569 | 11569 | 405 LANGLEY RD | ward-6 | Sign Knocked Down | 53459 | inactive | 2024-12-12 10:00 | 2024-12-16 | 42.320109 | -71.183748 |
| 11560 | 11560 | 21 WINCHESTER RD | ward-1 | Sign Knocked Down | 53459 | inactive | 2024-12-12 09:45 | 2024-12-17 | 42.349674 | -71.194974 |
| 10812 | 10812 | AUBURN ST | ward-4 | Sign Knocked Down | 53459 | inactive | 2024-12-01 06:45 | 2024-12-03 | 42.346313 | -71.248655 |
| 10768 | 10768 | 187 CHERRY ST | ward-3 | Sign Knocked Down | 53459 | inactive | 2024-11-27 14:30 | 2024-12-04 | 42.357882 | -71.227599 |
| 10726 | 10726 | 187 CHERRY ST | ward-3 | Sign Knocked Down | 53459 | inactive | 2024-11-26 16:45 | 2024-11-27 | 42.357882 | -71.227599 |
| 10644 | 10644 | 6 BRENTWOOD AVE | ward-6 | Sign Knocked Down | 53459 | inactive | 2024-11-25 14:30 | 2024-11-26 | 42.331925 | -71.204959 |
| 10445 | 10445 | 227 WALNUT ST | ward-2 | Sign Knocked Down | 53459 | inactive | 2024-11-21 13:00 | 2024-11-22 | 42.352556 | -71.207956 |
| 10287 | 10287 | 56 HANSON RD | ward-8 | Sign Knocked Down | 53459 | inactive | 2024-11-18 15:30 | 2024-11-21 | 42.292916 | -71.186513 |
| 10254 | 10254 | 121 CEDRIC ROAD | ward-6 | Sign Knocked Down | 53459 | inactive | 2024-11-18 11:15 | 2024-11-21 | 42.322518 | -71.196095 |
| 10194 | 10194 | 72 HIGH STREET | ward-5 | Sign Knocked Down | 53459 | inactive | 2024-11-15 14:15 | 2024-11-19 | 42.31478 | -71.223754 |
| 10134 | 10134 | 90 WASHBURN AVENUE | ward-4 | Sign Knocked Down | 53459 | inactive | 2024-11-14 08:30 | 2024-11-19 | 42.351426 | -71.243833 |
| 8938 | 8938 | 16 PHILLIPS ST | ward-4 | Sign Knocked Down | 53459 | inactive | 2024-10-30 13:45 | 2024-11-01 | 42.346302 | -71.255875 |
| 8591 | 8591 | 31 AUBURN ST | ward-3 | Sign Knocked Down | 53459 | inactive | 2024-10-28 17:30 | 2024-10-30 | 42.345019 | -71.23607 |
| 6427 | 6427 | 40 FULLER ST | ward-5 | Sign Knocked Down | 53459 | inactive | 2024-09-26 09:15 | 2024-09-30 | 42.336045 | -71.221059 |
| 6190 | 6190 | 49 CRAFTS ST | ward-1 | Sign Knocked Down | 53459 | inactive | 2024-09-23 17:45 | 2024-09-25 | 42.354969 | -71.200986 |
| 6189 | 6189 | 166–176 LION DR | ward-8 | Sign Knocked Down | 53459 | inactive | 2024-09-23 17:45 | 2024-09-25 | 42.312769 | -71.184288 |
| 6188 | 6188 | 162 DEDHAM STREET | ward-8 | Sign Knocked Down | 53459 | inactive | 2024-09-23 17:45 | 2024-09-25 | 42.314276 | -71.202291 |
| 6187 | 6187 | 1119 WALNUT STREET | ward-6 | Sign Knocked Down | 53459 | inactive | 2024-09-23 17:45 | 2024-10-01 | 42.323098 | -71.207698 |
| 5909 | 5909 | 34 ROWE ST | ward-4 | Sign Knocked Down | 53459 | inactive | 2024-09-16 12:15 | 2024-09-16 | 42.349034 | -71.240613 |
| 5894 | 5894 | 1298 COMMONWEALTH AVENUE | ward-3 | Sign Knocked Down | 53459 | inactive | 2024-09-16 10:00 | 2024-09-17 | 42.337099 | -71.220109 |
| 5753 | 5753 | 136 HYDE ST | ward-6 | Sign Knocked Down | 53459 | inactive | 2024-09-12 15:45 | 2024-09-16 | 42.322122 | -71.202875 |
| 5611 | 5611 | 11 OWAISA RD | ward-5 | Sign Knocked Down | 53459 | inactive | 2024-09-10 12:15 | 2024-09-11 | 42.327051 | -71.238975 |
| 5529 | 5529 | 200–224 ALBEMARLE RD | ward-2 | Sign Knocked Down | 53459 | inactive | 2024-09-09 14:15 | 2024-09-11 | 42.359394 | -71.216811 |
| 4927 | 4927 | 76 CHESTNUT ST | ward-2 | Sign Knocked Down | 53459 | inactive | 2024-08-26 14:45 | 2024-08-26 | 42.34755 | -71.224571 |
| 4400 | 4400 | 49 JANET RD | ward-2 | Sign Knocked Down | 53459 | inactive | 2024-08-15 10:00 | 2024-08-20 | 42.340308 | -71.195153 |
| 4198 | 4198 | 942 WATERTOWN ST | ward-3 | Sign Knocked Down | 53459 | inactive | 2024-08-12 12:15 | 2024-08-13 | 42.350228 | -71.223666 |
| 3458 | 3458 | 35 WABAN STREET | ward-1 | Sign Knocked Down | 53459 | inactive | 2024-07-31 18:00 | 2024-08-06 | 42.357347 | -71.190527 |
| 3217 | 3217 | 254 ALBEMARLE ROAD | ward-3 | Sign Knocked Down | 53459 | inactive | 2024-07-28 15:45 | 2024-07-30 | 42.356833 | -71.216002 |
| 3168 | 3168 | 73 CARVER RD | ward-5 | Sign Knocked Down | 53459 | inactive | 2024-07-26 09:00 | 2024-07-30 | 42.321935 | -71.218201 |
| 2873 | 2873 | 574 AUBURN ST | ward-4 | Sign Knocked Down | 53459 | inactive | 2024-07-19 15:00 | 2024-07-22 | 42.343874 | -71.257261 |
| 1614 | 1614 | 1686 BEACON ST | ward-5 | Sign Knocked Down | 53459 | inactive | 2024-06-27 12:30 | 2024-07-01 | 42.325696 | -71.232694 |
| 1576 | 1576 | 268 LEXINGTON ST | ward-4 | Sign Knocked Down | 53459 | inactive | 2024-06-27 | 2024-07-11 | 42.352744 | -71.245199 |
| 1473 | 1473 | 1220 CHESTNUT STREET | ward-5 | Sign Knocked Down | 53459 | inactive | 2024-06-26 | 2024-06-26 | 42.309635 | -71.220723 |
| 1467 | 1467 | 99 MOULTON ST | ward-4 | Sign Knocked Down | 53459 | inactive | 2024-06-26 | 2024-06-26 | 42.329325 | -71.256105 |
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]);