home / n311

requests

137 rows where category_id = 51091 sorted by rowid descending

✎ View and edit SQL

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

CSV options:

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]);
Powered by Datasette · Queries took 1065.248ms