requests
137 rows where category_id = 51091 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: ward, active, removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 31603 | 31603 | 799 COMMONWEALTH AVE | ward-2 | Sign damaged or knocked down | 51091 | inactive | 2025-12-21 10:30 | 2025-12-22 | 42.338322 | -71.199014 |
| 31415 | 31415 | 13 GLENMORE TER | ward-6 | Sign damaged or knocked down | 51091 | inactive | 2025-12-18 14:30 | 2025-12-19 | 42.319584 | -71.211672 |
| 31317 | 31317 | 5 DERBY ST | ward-3 | Sign damaged or knocked down | 51091 | inactive | 2025-12-17 05:15 | 2025-12-17 | 42.356394 | -71.2238 |
| 31205 | 31205 | 6 RIDGE AVE | ward-6 | Sign damaged or knocked down | 51091 | inactive | 2025-12-15 12:00 | 2025-12-16 | 42.324939 | -71.193573 |
| 31195 | 31195 | 321 WALTHAM ST | ward-3 | Sign damaged or knocked down | 51091 | inactive | 2025-12-15 10:15 | 2025-12-16 | 42.356133 | -71.223777 |
| 31087 | 31087 | 447 CENTRE STREET | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-12-11 23:45 | 2025-12-12 | 42.3552 | -71.186616 |
| 30740 | 30740 | 108 NEWTONVILLE AVE | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-12-04 07:15 | 2025-12-04 | 42.35337 | -71.190837 |
| 30693 | 30693 | 215 SUMNER ST | ward-6 | Sign damaged or knocked down | 51091 | inactive | 2025-12-03 10:30 | 2025-12-04 | 42.330969 | -71.192637 |
| 30461 | 30461 | 45 OLD COLONY RD | ward-7 | Sign damaged or knocked down | 51091 | inactive | 2025-11-27 08:15 | 2025-12-01 | 42.335613 | -71.173476 |
| 30453 | 30453 | 270 CABOT ST | ward-2 | Sign damaged or knocked down | 51091 | inactive | 2025-11-26 13:15 | 2025-12-01 | 42.348051 | -71.200859 |
| 30240 | 30240 | 462 WALNUT ST | ward-2 | Sign damaged or knocked down | 51091 | inactive | 2025-11-23 15:45 | 2025-11-24 | 42.345441 | -71.205593 |
| 30097 | 30097 | 185 FAIRWAY DR | ward-3 | Sign damaged or knocked down | 51091 | inactive | 2025-11-19 14:30 | 2025-11-20 | 42.356187 | -71.223125 |
| 29640 | 29640 | 93 MONADNOCK ROAD | ward-7 | Sign damaged or knocked down | 51091 | inactive | 2025-11-11 10:15 | 2025-11-12 | 42.334043 | -71.178279 |
| 29607 | 29607 | 1223 CHESTNUT ST | ward-5 | Sign damaged or knocked down | 51091 | active | 2025-11-10 11:00 | 42.309288 | -71.220821 | |
| 29530 | 29530 | 130 WHEELER RD | ward-8 | Sign damaged or knocked down | 51091 | inactive | 2025-11-07 15:15 | 2025-11-12 | 42.310017 | -71.191787 |
| 29474 | 29474 | 44 B JEFFERSON STREET | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-11-06 15:00 | 2025-11-17 | 42.358815 | -71.182989 |
| 29318 | 29318 | 44 B JEFFERSON STREET | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-11-04 13:30 | 2025-11-06 | 42.358815 | -71.182989 |
| 29145 | 29145 | 59 CRAFTS ST | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-11-01 13:15 | 2025-11-03 | 42.35508 | -71.201318 |
| 29099 | 29099 | 112 GIBBS ST | ward-6 | Sign damaged or knocked down | 51091 | inactive | 2025-10-31 13:45 | 2025-11-04 | 42.332931 | -71.189636 |
| 29014 | 29014 | 47 WILLISTON RD | ward-4 | Sign damaged or knocked down | 51091 | inactive | 2025-10-30 13:00 | 2025-10-31 | 42.341094 | -71.252789 |
| 28810 | 28810 | 61 WALLACE ST | ward-8 | Sign damaged or knocked down | 51091 | inactive | 2025-10-27 11:00 | 2025-10-28 | 42.30477 | -71.208108 |
| 28809 | 28809 | 24 NORMAN ROAD | ward-6 | Sign damaged or knocked down | 51091 | inactive | 2025-10-27 11:00 | 2025-10-28 | 42.325089 | -71.204569 |
| 28674 | 28674 | 61 WASHBURN AVENUE | ward-4 | Sign damaged or knocked down | 51091 | inactive | 2025-10-23 08:45 | 2025-10-24 | 42.351367 | -71.242696 |
| 28614 | 28614 | 5 STAFFORD RD | ward-6 | Sign damaged or knocked down | 51091 | inactive | 2025-10-22 10:15 | 2025-10-22 | 42.33411 | -71.20152 |
| 28485 | 28485 | 1725 WASHINGTON ST | ward-4 | Sign damaged or knocked down | 51091 | inactive | 2025-10-20 14:15 | 2025-10-22 | 42.34032 | -71.23968 |
| 28088 | 28088 | 37 FARMINGTON ROAD | ward-3 | Sign damaged or knocked down | 51091 | inactive | 2025-10-12 09:00 | 2025-10-14 | 42.361159 | -71.228556 |
| 28010 | 28010 | 10 CAMBRIA ROAD | ward-3 | Sign damaged or knocked down | 51091 | inactive | 2025-10-09 22:45 | 2025-10-14 | 42.362557 | -71.229413 |
| 28006 | 28006 | 226 KENT RD | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2025-10-09 18:15 | 2025-10-14 | 42.330753 | -71.230838 |
| 27986 | 27986 | 2370 COMMONWEALTH AVE | ward-4 | Sign damaged or knocked down | 51091 | inactive | 2025-10-09 13:45 | 2025-10-09 | 42.344604 | -71.258027 |
| 27978 | 27978 | 11 RICE ST | ward-6 | Sign damaged or knocked down | 51091 | inactive | 2025-10-09 11:30 | 2025-10-09 | 42.335937 | -71.191935 |
| 27959 | 27959 | 8 JEFFERSON STREET | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-10-08 17:30 | 2025-10-09 | 42.359751 | -71.182153 |
| 27518 | 27518 | 12 GREEN ST | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-09-30 10:15 | 2025-10-01 | 42.359346 | -71.195994 |
| 27380 | 27380 | 425 CENTRE ST | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-09-26 17:15 | 2025-09-29 | 42.35553 | -71.186504 |
| 26974 | 26974 | 9 WILLIAM ST | ward-4 | Sign damaged or knocked down | 51091 | inactive | 2025-09-19 11:00 | 2025-09-23 | 42.356484 | -71.23644 |
| 26592 | 26592 | 256 WATERTOWN ST | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-09-12 09:30 | 2025-09-15 | 42.36138 | -71.196696 |
| 26470 | 26470 | 229 RIVER ST | ward-4 | Sign damaged or knocked down | 51091 | inactive | 2025-09-10 16:30 | 2025-09-11 | 42.35535 | -71.235396 |
| 26150 | 26150 | 213 TREMONT ST | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-09-04 13:45 | 2025-09-09 | 42.35328 | -71.176928 |
| 26146 | 26146 | 2 LOWELL AVE | ward-2 | Sign damaged or knocked down | 51091 | inactive | 2025-09-04 13:15 | 2025-09-04 | 42.356493 | -71.206821 |
| 26041 | 26041 | 112 HARDING STREET | ward-3 | Sign damaged or knocked down | 51091 | inactive | 2025-09-03 07:45 | 2025-09-03 | 42.363665 | -71.223363 |
| 25587 | 25587 | 286 WATERTOWN ST | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-08-21 17:00 | 2025-08-26 | 42.361074 | -71.198087 |
| 25373 | 25373 | 270 CABOT ST | ward-2 | Sign damaged or knocked down | 51091 | inactive | 2025-08-18 16:30 | 2025-08-20 | 42.348051 | -71.200859 |
| 25052 | 25052 | 51 MIGNON ROAD | ward-3 | Sign damaged or knocked down | 51091 | inactive | 2025-08-12 11:30 | 2025-08-13 | 42.340451 | -71.232009 |
| 23988 | 23988 | 314 HAMMOND ST | ward-7 | Sign damaged or knocked down | 51091 | inactive | 2025-07-23 14:15 | 2025-07-31 | 42.33123 | -71.169791 |
| 23982 | 23982 | 372 WATERTOWN ST | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-07-23 13:30 | 2025-07-24 | 42.360435 | -71.201187 |
| 23788 | 23788 | 79 JEWETT ST | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-07-21 10:45 | 2025-07-23 | 42.358464 | -71.191305 |
| 23726 | 23726 | 537 CALIFORNIA ST | ward-2 | Sign damaged or knocked down | 51091 | inactive | 2025-07-20 10:30 | 2025-07-21 | 42.361542 | -71.209832 |
| 23106 | 23106 | 35 WALNUT ST | ward-2 | Sign damaged or knocked down | 51091 | inactive | 2025-07-11 12:30 | 2025-07-14 | 42.358104 | -71.211564 |
| 22585 | 22585 | 93 NONANTUM ST | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-07-02 18:00 | 2025-07-21 | 42.35013 | -71.178975 |
| 22289 | 22289 | 157 MELROSE ST | ward-4 | Sign damaged or knocked down | 51091 | inactive | 2025-06-29 09:15 | 2025-06-30 | 42.351093 | -71.249508 |
| 22001 | 22001 | 271 LAKE AVE | ward-6 | Sign damaged or knocked down | 51091 | inactive | 2025-06-24 10:15 | 2025-06-24 | 42.324372 | -71.20422 |
| 21327 | 21327 | 140 BRANDEIS RD | ward-8 | Sign damaged or knocked down | 51091 | inactive | 2025-06-14 20:00 | 2025-06-17 | 42.31368 | -71.18654 |
| 21265 | 21265 | 475 WASHINGTON STREET | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-06-13 07:30 | 2025-06-16 | 42.355275 | -71.192766 |
| 21239 | 21239 | 91 HERRICK RD | ward-6 | Sign damaged or knocked down | 51091 | inactive | 2025-06-12 16:00 | 2025-06-16 | 42.327351 | -71.192799 |
| 20854 | 20854 | 50 DOLPHIN ROAD | ward-7 | Sign damaged or knocked down | 51091 | inactive | 2025-06-06 14:30 | 2025-06-11 | 42.33964 | -71.180108 |
| 20686 | 20686 | 3 BORDER ST | ward-3 | Sign damaged or knocked down | 51091 | inactive | 2025-06-04 14:45 | 2025-06-09 | 42.349302 | -71.229663 |
| 20379 | 20379 | 61 WASHBURN AVE | ward-4 | Sign damaged or knocked down | 51091 | inactive | 2025-05-31 20:15 | 2025-06-03 | 42.351498 | -71.242781 |
| 20247 | 20247 | 87 RESERVOIR AVE | ward-7 | Sign damaged or knocked down | 51091 | inactive | 2025-05-29 15:00 | 2025-06-02 | 42.33087 | -71.167257 |
| 20179 | 20179 | 6 LEXINGTON STREET | ward-4 | Sign damaged or knocked down | 51091 | inactive | 2025-05-28 17:45 | 2025-05-29 | 42.359798 | -71.239391 |
| 20177 | 20177 | 18 SAINT JAMES STREET | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-05-28 17:15 | 2025-05-29 | 42.358086 | -71.18049 |
| 20142 | 20142 | 22 MARLBORO ST | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-05-28 12:30 | 2025-05-29 | 42.351597 | -71.17614 |
| 19886 | 19886 | 321 WALTHAM ST | ward-3 | Sign damaged or knocked down | 51091 | inactive | 2025-05-23 08:00 | 2025-05-23 | 42.356133 | -71.223777 |
| 19885 | 19885 | 309 WALTHAM ST | ward-3 | Sign damaged or knocked down | 51091 | inactive | 2025-05-23 08:00 | 2025-05-23 | 42.356619 | -71.223746 |
| 19714 | 19714 | 15 BROADWAY | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-05-20 14:15 | 2025-05-22 | 42.357942 | -71.206497 |
| 19604 | 19604 | 257 WATERTOWN ST | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-05-19 11:15 | 2025-05-19 | 42.36165 | -71.19711 |
| 19567 | 19567 | 114 HILLSIDE AVENUE | ward-2 | Sign damaged or knocked down | 51091 | inactive | 2025-05-19 08:30 | 2025-05-29 | 42.345416 | -71.221238 |
| 19555 | 19555 | 263 WATERTOWN ST | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-05-19 04:15 | 2025-05-21 | 42.361524 | -71.197394 |
| 19522 | 19522 | 5 EVELYN ROAD | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2025-05-16 20:30 | 2025-05-21 | 42.330601 | -71.21891 |
| 19220 | 19220 | 50 WINCHESTER STREET | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2025-05-12 13:00 | 2025-05-13 | 42.318322 | -71.208706 |
| 19219 | 19219 | 1101 BEACON ST | ward-6 | Sign damaged or knocked down | 51091 | inactive | 2025-05-12 13:00 | 2025-05-15 | 42.331149 | -71.207694 |
| 18980 | 18980 | 7 OSSIPEE RD | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2025-05-07 11:30 | 2025-05-12 | 42.310665 | -71.219673 |
| 18896 | 18896 | 105 REDWOOD RD | ward-8 | Sign damaged or knocked down | 51091 | inactive | 2025-05-06 11:15 | 2025-05-15 | 42.301332 | -71.182517 |
| 18869 | 18869 | 5 DERBY ST | ward-3 | Sign damaged or knocked down | 51091 | inactive | 2025-05-06 07:45 | 2025-05-07 | 42.356394 | -71.2238 |
| 18821 | 18821 | 1480 CENTRE ST | ward-6 | Sign damaged or knocked down | 51091 | inactive | 2025-05-05 14:00 | 2025-05-07 | 42.324138 | -71.199923 |
| 18771 | 18771 | 1103 COMMONWEALTH AVENUE | ward-2 | Sign damaged or knocked down | 51091 | inactive | 2025-05-05 02:00 | 2025-05-05 | 42.338083 | -71.212118 |
| 18688 | 18688 | 1299 BEACON STREET | ward-5 | Sign damaged or knocked down | 51091 | active | 2025-05-02 08:30 | 42.330863 | -71.21641 | |
| 18305 | 18305 | 259 CENTRE ST | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-04-25 07:00 | 2025-04-25 | 42.358968 | -71.185347 |
| 18123 | 18123 | 73 OAK STREET | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2025-04-22 12:00 | 2025-04-25 | 42.310214 | -71.220819 |
| 18093 | 18093 | 1964 WASHINGTON ST | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2025-04-22 09:00 | 2025-04-23 | 42.333323 | -71.245153 |
| 17314 | 17314 | 181 WARREN ST | ward-6 | Sign damaged or knocked down | 51091 | inactive | 2025-04-04 14:45 | 2025-04-07 | 42.329754 | -71.190198 |
| 17186 | 17186 | 8 SAINT JAMES STREET | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-04-02 01:45 | 2025-04-02 | 42.358387 | -71.180254 |
| 15987 | 15987 | 832 DEDHAM STREET | ward-8 | Sign damaged or knocked down | 51091 | inactive | 2025-03-08 06:00 | 2025-03-11 | 42.298359 | -71.184845 |
| 15858 | 15858 | 268 WASHINGTON STREET | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-03-07 01:30 | 2025-03-10 | 42.357214 | -71.185253 |
| 15694 | 15694 | 2054 BEACON ST | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2025-03-03 18:00 | 2025-03-05 | 42.329736 | -71.248239 |
| 15664 | 15664 | 67 COOK STREET | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-03-03 10:15 | 2025-03-03 | 42.359085 | -71.19707 |
| 14685 | 14685 | 2061 WASHINGTON STREET | ward-4 | Sign damaged or knocked down | 51091 | inactive | 2025-02-14 14:45 | 2025-02-26 | 42.330546 | -71.248189 |
| 14333 | 14333 | 7 PLAYSTEAD RD | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-02-08 15:15 | 2025-02-08 | 42.352236 | -71.174399 |
| 13941 | 13941 | 6 CLIFTON RD | ward-8 | Sign damaged or knocked down | 51091 | inactive | 2025-01-30 15:30 | 2025-02-03 | 42.302727 | -71.178575 |
| 13902 | 13902 | 335 WALNUT ST | ward-2 | Sign damaged or knocked down | 51091 | inactive | 2025-01-30 06:00 | 2025-02-03 | 42.349644 | -71.206912 |
| 13828 | 13828 | 16 RICKER RD | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-01-28 15:15 | 2025-01-31 | 42.351405 | -71.175275 |
| 13778 | 13778 | 109 OAK STREET | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2025-01-28 10:00 | 2025-01-31 | 42.308476 | -71.221061 |
| 13086 | 13086 | 61 WAVERLEY AVENUE | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-01-13 13:45 | 2025-01-14 | 42.35361 | -71.179645 |
| 13031 | 13031 | 91-93 CHARLESBANK ROAD | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-01-12 22:00 | 2025-01-13 | 42.358807 | -71.180221 |
| 13012 | 13012 | 160 FRANKLIN STREET | ward-7 | Sign damaged or knocked down | 51091 | inactive | 2025-01-10 16:15 | 2025-01-11 | 42.349 | -71.179052 |
| 12797 | 12797 | 25 RIVER AVENUE | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2025-01-07 17:00 | 2025-01-08 | 42.312316 | -71.225395 |
| 12796 | 12796 | 2101 MASSACHUSETTS 16 | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2025-01-07 17:00 | 2025-01-08 | 42.329503 | -71.249535 |
| 12641 | 12641 | 1304 BOYLSTON STREET | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2025-01-06 01:00 | 2025-01-08 | 42.316735 | -71.226323 |
| 12638 | 12638 | 321 HAMMOND POND PARKWAY | ward-7 | Sign damaged or knocked down | 51091 | inactive | 2025-01-05 23:00 | 2025-01-06 | 42.322182 | -71.172652 |
| 12494 | 12494 | 23 SEMINARY AVE | ward-4 | Sign damaged or knocked down | 51091 | inactive | 2025-01-02 09:30 | 2025-01-02 | 42.343171 | -71.248441 |
| 12472 | 12472 | 3 CHARLESBANK ROAD | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2025-01-01 16:00 | 2025-01-02 | 42.358276 | -71.174868 |
| 12320 | 12320 | 130 COTTON ST | ward-7 | Sign damaged or knocked down | 51091 | inactive | 2024-12-27 15:45 | 2024-12-30 | 42.340931 | -71.188011 |
| 11917 | 11917 | 107 BRANDEIS RD | ward-8 | Sign damaged or knocked down | 51091 | inactive | 2024-12-20 06:30 | 2024-12-20 | 42.314404 | -71.190346 |
| 11594 | 11594 | 341 LAKE AVE | ward-6 | Sign damaged or knocked down | 51091 | inactive | 2024-12-12 13:30 | 2024-12-16 | 42.322882 | -71.206569 |
| 10957 | 10957 | 16 PARK STREET | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2024-12-03 13:15 | 2024-12-10 | 42.356151 | -71.182378 |
| 10708 | 10708 | 49 PEARL ST | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2024-11-26 09:45 | 2024-11-26 | 42.358327 | -71.187256 |
| 10509 | 10509 | 108 MADISON AVE | ward-2 | Sign damaged or knocked down | 51091 | inactive | 2024-11-22 14:15 | 2024-11-27 | 42.349856 | -71.206566 |
| 10407 | 10407 | 197 CALIFORNIA ST | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2024-11-20 20:00 | 2024-11-22 | 42.364997 | -71.196275 |
| 10345 | 10345 | 255 WASHINGTON STREET | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2024-11-20 00:30 | 2024-11-20 | 42.35746 | -71.18403 |
| 10224 | 10224 | 97 HAWTHORN STREET | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2024-11-16 22:00 | 2024-11-18 | 42.356817 | -71.200381 |
| 8779 | 8779 | 2-98 ELM ST | ward-3 | Sign damaged or knocked down | 51091 | inactive | 2024-10-29 23:15 | 2024-11-01 | 42.349694 | -71.230752 |
| 8289 | 8289 | 1345 WASHINGTON ST | Sign damaged or knocked down | 51091 | inactive | 2024-10-24 14:30 | 2024-10-28 | |||
| 7741 | 7741 | 10 BOLTON RD | ward-2 | Sign damaged or knocked down | 51091 | inactive | 2024-10-21 08:45 | 2024-10-22 | 42.344958 | -71.211422 |
| 6718 | 6718 | 78 HULL ST | ward-2 | Sign damaged or knocked down | 51091 | inactive | 2024-10-04 08:45 | 2024-10-08 | 42.343627 | -71.209557 |
| 6186 | 6186 | 51 OAK ST | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2024-09-23 17:45 | 2024-09-25 | 42.310896 | -71.221061 |
| 6024 | 6024 | 122–134 CHAPEL ST | Sign damaged or knocked down | 51091 | inactive | 2024-09-17 13:15 | 2024-09-23 | |||
| 5512 | 5512 | 922 CHESTNUT ST | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2024-09-09 09:30 | 2024-09-09 | 42.317602 | -71.225667 |
| 5045 | 5045 | 42 BERWICK RD | ward-6 | Sign damaged or knocked down | 51091 | inactive | 2024-08-28 09:45 | 2024-08-28 | 42.327469 | -71.205095 |
| 4214 | 4214 | 282 WATERTOWN ST | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2024-08-12 13:30 | 2024-08-13 | 42.361115 | -71.197948 |
| 3352 | 3352 | 59 SAINT JAMES CIR | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2024-07-30 09:45 | 2024-07-31 | 42.356713 | -71.181204 |
| 2815 | 2815 | 23 NAHANTON STREET | ward-8 | Sign damaged or knocked down | 51091 | inactive | 2024-07-18 15:00 | 2024-07-22 | 42.300232 | -71.188794 |
| 2751 | 2751 | 27 NEEDHAM STREET | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2024-07-17 17:00 | 2024-07-23 | 42.316402 | -71.209994 |
| 2737 | 2737 | 44 RIVER ST | ward-3 | Sign damaged or knocked down | 51091 | inactive | 2024-07-17 15:15 | 2024-07-18 | 42.352007 | -71.228202 |
| 2662 | 2662 | 843847 CENTRE STREET | ward-2 | Sign damaged or knocked down | 51091 | inactive | 2024-07-16 15:45 | 2024-07-17 | 42.342846 | -71.191733 |
| 2583 | 2583 | 274 PARKER STREET | ward-8 | Sign damaged or knocked down | 51091 | inactive | 2024-07-16 00:00 | 2024-07-17 | 42.318044 | -71.194587 |
| 2582 | 2582 | 27 WINCHESTER STREET | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2024-07-16 00:00 | 2024-07-16 | 42.318774 | -71.207762 |
| 2289 | 2289 | 363 WASHINGTON STREET | ward-1 | Sign damaged or knocked down | 51091 | inactive | 2024-07-10 02:45 | 2024-07-10 | 42.356528 | -71.188397 |
| 2288 | 2288 | 31 NAHANTON STREET | ward-8 | Sign damaged or knocked down | 51091 | inactive | 2024-07-10 02:00 | 2024-07-11 | 42.300109 | -71.189641 |
| 2286 | 2286 | 244 NEEDHAM STREET | ward-8 | Sign damaged or knocked down | 51091 | inactive | 2024-07-09 23:15 | 2024-07-10 | 42.309393 | -71.214554 |
| 2285 | 2285 | 215 NEEDHAM STREET | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2024-07-09 23:15 | 2024-07-10 | 42.310833 | -71.214361 |
| 2284 | 2284 | 212 NEEDHAM STREET | ward-8 | Sign damaged or knocked down | 51091 | inactive | 2024-07-09 23:15 | 2024-07-10 | 42.3105 | -71.214049 |
| 2211 | 2211 | 304 WALNUT ST | ward-2 | Sign damaged or knocked down | 51091 | inactive | 2024-07-09 08:45 | 2024-07-10 | 42.350457 | -71.206788 |
| 2201 | 2201 | 41 MIDDLESEX RD | ward-7 | Sign damaged or knocked down | 51091 | inactive | 2024-07-08 19:00 | 2024-07-10 | 42.326044 | -71.163277 |
| 2079 | 2079 | 821 BEACON STREET | ward-6 | Sign damaged or knocked down | 51091 | inactive | 2024-07-08 00:45 | 2024-07-09 | 42.330121 | -71.194952 |
| 1835 | 1835 | 9 MANHATTAN TER | ward-3 | Sign damaged or knocked down | 51091 | inactive | 2024-07-02 09:45 | 2024-07-03 | 42.355559 | -71.229521 |
| 1783 | 1783 | 7 LUCILLE PLACE | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2024-07-01 12:45 | 2024-07-03 | 42.317227 | -71.223169 |
| 1620 | 1620 | 1–13 ARDMORE RD | ward-3 | Sign damaged or knocked down | 51091 | inactive | 2024-06-27 13:15 | 2024-07-01 | 42.344861 | -71.232734 |
| 1273 | 1273 | 1781 COMMONWEALTH AVENUE | ward-4 | Sign damaged or knocked down | 51091 | inactive | 2024-06-24 | 2024-06-24 | 42.341894 | -71.238975 |
| 1112 | 1112 | 7 BEETHOVEN AVENUE | ward-5 | Sign damaged or knocked down | 51091 | inactive | 2024-06-24 | 42.330506 | -71.218749 |
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]);