home / n311

requests

168 rows where category_id = 53461 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ward, active, added (date), removed (date)

Link rowid ▲ location ward category category_id active added removed latitude longitude
31171 31171 40 SUMMIT ST ward-1 Catch Basin Repair 53461 active 2025-12-14 18:00   42.353064 -71.191319
31042 31042 93 BRANDEIS ROAD ward-8 Catch Basin Repair 53461 active 2025-12-11 11:15   42.314292 -71.191111
30292 30292 50 ALDEN PL ward-3 Catch Basin Repair 53461 active 2025-11-24 10:45   42.354144 -71.230671
29398 29398 23 ORCHARD STREET ward-1 Catch Basin Repair 53461 inactive 2025-11-05 14:30 2025-12-09 42.358173 -71.182056
29192 29192 20 ELIZABETH CIR ward-3 Catch Basin Repair 53461 active 2025-11-03 08:45   42.338124 -71.22848
28639 28639 194 DEDHAM ST ward-8 Catch Basin Repair 53461 active 2025-10-22 13:15   42.313401 -71.2017
28583 28583 119 CLARK ST ward-6 Catch Basin Repair 53461 active 2025-10-22 09:00   42.320124 -71.197781
28500 28500 582 BEACON ST ward-7 Catch Basin Repair 53461 active 2025-10-20 16:15   42.331518 -71.183867
28421 28421 129 HAGEN ROAD ward-8 Catch Basin Repair 53461 inactive 2025-10-17 16:30 2025-10-27 42.317259 -71.189756
27947 27947 45 ELMORE ST ward-2 Catch Basin Repair 53461 active 2025-10-08 13:15   42.339033 -71.19518
27582 27582 38 HAWTHORN ST ward-1 Catch Basin Repair 53461 active 2025-10-01 08:00   42.358464 -71.20197
27552 27552 1737 COMMONWEALTH AVENUE ward-3 Catch Basin Repair 53461 active 2025-09-30 14:45   42.341102 -71.237546
27092 27092 48 BILLINGS PARK ward-7 Catch Basin Repair 53461 inactive 2025-09-22 17:30 2025-10-09 42.352452 -71.183592
27028 27028 57 WETHERELL ST ward-5 Catch Basin Repair 53461 inactive 2025-09-22 09:00 2025-11-03 42.311628 -71.21741
26471 26471 449 LOWELL AVENUE ward-2 Catch Basin Repair 53461 inactive 2025-09-10 16:30 2025-09-25 42.341927 -71.212575
26263 26263 5 GRAYDALE CIR ward-4 Catch Basin Repair 53461 inactive 2025-09-06 16:00 2025-09-16 42.344361 -71.249459
26116 26116 7 SEVLAND RD ward-8 Catch Basin Repair 53461 inactive 2025-09-04 09:15 2025-10-25 42.308361 -71.185788
26023 26023 3 RANGELEY RD ward-3 Catch Basin Repair 53461 active 2025-09-02 15:30   42.358113 -71.225132
25817 25817 30 STEIN CIRCLE ward-8 Catch Basin Repair 53461 inactive 2025-08-27 22:00 2025-11-25 42.290841 -71.188355
25794 25794 33 BIRCH HILL RD ward-2 Catch Basin Repair 53461 inactive 2025-08-27 14:00 2025-08-28 42.347628 -71.21255
25735 25735 742 COMMONWEALTH AVE ward-6 Catch Basin Repair 53461 inactive 2025-08-26 14:45 2025-10-30 42.337053 -71.197182
25694 25694 115 WABAN PARK ward-1 Catch Basin Repair 53461 active 2025-08-25 20:30   42.358509 -71.193897
25633 25633 66 ELMORE ST ward-2 Catch Basin Repair 53461 active 2025-08-22 22:45   42.338727 -71.196152
25627 25627 36 REGENT ST ward-3 Catch Basin Repair 53461 inactive 2025-08-22 16:00 2025-09-09 42.344073 -71.220803
25618 25618 1000 COMMONWEALTH AVE ward-2 Catch Basin Repair 53461 inactive 2025-08-22 14:30 2025-10-30 42.337377 -71.208617
25036 25036 106 RIVER ST ward-3 Catch Basin Repair 53461 inactive 2025-08-12 08:30 2025-08-21 42.352452 -71.230527
24980 24980 63 BONAD RD ward-3 Catch Basin Repair 53461 inactive 2025-08-11 12:30 2025-08-18 42.339753 -71.21885
24916 24916 8 EASTHAM RD ward-8 Catch Basin Repair 53461 inactive 2025-08-08 10:30 2025-08-19 42.300711 -71.174597
24680 24680 26 DORCAR RD ward-8 Catch Basin Repair 53461 inactive 2025-08-05 10:15 2025-08-06 42.302565 -71.173755
24402 24402 11 FLORENCE ST ward-8 Catch Basin Repair 53461 inactive 2025-07-30 14:15 2025-07-30 42.318756 -71.181288
24340 24340 2014 WASHINGTON STREET ward-5 Catch Basin Repair 53461 active 2025-07-29 23:15   42.331902 -71.245442
24053 24053 100 WALNUT ST ward-2 Catch Basin Repair 53461 active 2025-07-24 11:45   42.357006 -71.209409
23962 23962 262 KENRICK ST ward-7 Catch Basin Repair 53461 active 2025-07-23 09:45   42.346413 -71.174309
23961 23961 128 BALDPATE HILL RD ward-8 Catch Basin Repair 53461 active 2025-07-23 09:45   42.30513 -71.179475
23937 23937 11 TENNYSON RD ward-3 Catch Basin Repair 53461 inactive 2025-07-22 19:45 2025-07-23 42.3441 -71.232363
23754 23754 15 AVALON RD ward-5 Catch Basin Repair 53461 active 2025-07-21 08:45   42.329097 -71.220344
23732 23732 66 LINDEN STREET ward-5 Catch Basin Repair 53461 inactive 2025-07-20 20:15 2025-08-06 42.310547 -71.219178
23498 23498 36 GLEN AVE ward-7 Catch Basin Repair 53461 inactive 2025-07-16 12:00 2025-10-11 42.330204 -71.185919
23039 23039 30 STEIN CIR ward-8 Catch Basin Repair 53461 inactive 2025-07-10 12:30 2025-07-14 42.290694 -71.188344
22797 22797 10 BOLTON RD ward-2 Catch Basin Repair 53461 active 2025-07-08 08:15   42.344955 -71.21142
22441 22441 808 COMMONWEALTH AVE ward-6 Catch Basin Repair 53461 inactive 2025-07-01 15:30 2025-07-10 42.337647 -71.199536
22286 22286 53 HAWTHORN ST ward-1 Catch Basin Repair 53461 inactive 2025-06-28 14:30 2025-07-01 42.357825 -71.201691
22130 22130 128 DANEHILL RD ward-8 Catch Basin Repair 53461 active 2025-06-25 11:45   42.311187 -71.204756
21926 21926 38 HAWTHORN ST ward-1 Catch Basin Repair 53461 inactive 2025-06-23 15:15 2025-06-26 42.358464 -71.20197
21804 21804 32 WASHINGTON PARK ward-2 Catch Basin Repair 53461 active 2025-06-21 20:15   42.349041 -71.202735
21415 21415 680 WALNUT ST ward-2 Catch Basin Repair 53461 inactive 2025-06-16 16:00 2025-10-25 42.338106 -71.20661
21344 21344 65 HARWICH RD ward-8 Catch Basin Repair 53461 inactive 2025-06-16 06:45 2025-11-10 42.305328 -71.172612
21146 21146 100 ANDREW ST ward-8 Catch Basin Repair 53461 inactive 2025-06-11 13:15 2025-06-23 42.313293 -71.204513
21141 21141 25 MAGUE AVE ward-3 Catch Basin Repair 53461 active 2025-06-11 11:45   42.354765 -71.233011
21031 21031 94 MOFFAT RD ward-5 Catch Basin Repair 53461 inactive 2025-06-10 08:45 2025-06-24 42.332202 -71.228678
21000 21000 275 DUDLEY RD ward-8 Catch Basin Repair 53461 active 2025-06-09 15:45   42.312321 -71.181882
20732 20732 1064 CENTRE ST ward-6 Catch Basin Repair 53461 active 2025-06-05 08:45   42.335901 -71.193132
20721 20721 315 OTIS ST ward-2 Catch Basin Repair 53461 inactive 2025-06-04 21:00 2025-06-25 42.345441 -71.220866
20009 20009 89 ELM ST ward-3 Catch Basin Repair 53461 inactive 2025-05-26 20:30 2025-08-19 42.349662 -71.229983
19398 19398 8 EMERALD ST ward-1 Catch Basin Repair 53461 inactive 2025-05-14 15:30 2025-09-11 42.35652 -71.200611
19327 19327 1192 BEACON ST ward-6 Catch Basin Repair 53461 inactive 2025-05-13 15:30 2025-05-28 42.330879 -71.211767
19266 19266 76 SHERIDAN ST ward-3 Catch Basin Repair 53461 inactive 2025-05-13 07:45 2025-05-14 42.356826 -71.233839
19264 19264 8 LINCOLN ST ward-6 Catch Basin Repair 53461 inactive 2025-05-13 07:30 2025-05-13 42.321555 -71.206565
19172 19172 72 HOMER ST ward-6 Catch Basin Repair 53461 inactive 2025-05-11 17:45 2025-05-14 42.335253 -71.196426
19150 19150 54 CARLETON ST ward-1 Catch Basin Repair 53461 active 2025-05-09 18:45   42.358644 -71.187408
18989 18989 53 JASSET ST ward-1 Catch Basin Repair 53461 inactive 2025-05-07 13:00 2025-05-13 42.362901 -71.198271
18913 18913 73 HARDING ST ward-3 Catch Basin Repair 53461 inactive 2025-05-06 14:15 2025-06-02 42.362721 -71.222306
18827 18827 50 WALNUT PL ward-5 Catch Basin Repair 53461 active 2025-05-05 14:45   42.318495 -71.204391
18824 18824 1272 BEACON ST ward-6 Catch Basin Repair 53461 inactive 2025-05-05 14:30 2025-05-28 42.330762 -71.215344
18818 18818 99 SARGENT ST ward-7 Catch Basin Repair 53461 inactive 2025-05-05 13:00 2025-06-02 42.346404 -71.184542
18796 18796 23 ELINOR RD ward-8 Catch Basin Repair 53461 active 2025-05-05 10:00   42.314715 -71.20076
18738 18738 129 RACHEL RD ward-8 Catch Basin Repair 53461 inactive 2025-05-02 19:45 2025-05-28 42.306687 -71.20553
18582 18582 330 HOMER STREET ward-2 Catch Basin Repair 53461 inactive 2025-04-30 10:00 2025-04-30 42.336462 -71.208942
18569 18569 1272 BEACON STREET ward-6 Catch Basin Repair 53461 inactive 2025-04-30 07:45 2025-04-30 42.330823 -71.215401
18221 18221 10 PILLION CT ward-2 Catch Basin Repair 53461 inactive 2025-04-23 19:15 2025-04-25 42.352137 -71.197893
18173 18173 40 ALGONQUIN RD ward-7 Catch Basin Repair 53461 inactive 2025-04-23 09:00 2025-04-25 42.340545 -71.17029
18075 18075 21 JOSEPH ROAD ward-3 Catch Basin Repair 53461 inactive 2025-04-21 16:30 2025-04-30 42.362815 -71.215874
18015 18015 66 BROOKLINE STREET ward-8 Catch Basin Repair 53461 inactive 2025-04-18 10:30 2025-04-30 42.306968 -71.17266
17843 17843 80 FARINA RD ward-8 Catch Basin Repair 53461 inactive 2025-04-15 12:30 2025-04-16 42.309 -71.180699
17732 17732 9 HIGGINS ST ward-4 Catch Basin Repair 53461 inactive 2025-04-11 20:15 2025-04-30 42.348519 -71.249922
17661 17661 935 COMMONWEALTH AVE ward-2 Catch Basin Repair 53461 inactive 2025-04-10 14:30 2025-10-18 42.338871 -71.204904
17604 17604 76 SHERIDAN ST ward-3 Catch Basin Repair 53461 inactive 2025-04-09 19:30 2025-04-16 42.356826 -71.233839
17580 17580 54 LOVETT RD ward-8 Catch Basin Repair 53461 inactive 2025-04-09 10:45 2025-04-09 42.302331 -71.184389
17547 17547 15 BLACKSTONE TER ward-1 Catch Basin Repair 53461 inactive 2025-04-08 16:30 2025-04-09 42.350517 -71.179164
17447 17447 127 BELLEVUE ST ward-1 Catch Basin Repair 53461 inactive 2025-04-08 09:00 2025-04-11 42.352218 -71.191854
17408 17408 101 CENTRAL ST ward-4 Catch Basin Repair 53461 inactive 2025-04-07 15:30 2025-04-08 42.345113 -71.245321
17339 17339 17 EDDY ST ward-3 Catch Basin Repair 53461 inactive 2025-04-05 18:30 2025-04-16 42.352011 -71.217419
17265 17265 79 WALNUT ST ward-2 Catch Basin Repair 53461 inactive 2025-04-03 16:30 2025-04-18 42.356772 -71.210214
17217 17217 895 COMMONWEALTH AVE ward-2 Catch Basin Repair 53461 inactive 2025-04-02 14:30 2025-04-03 42.338403 -71.203113
17161 17161 32-34 GILBERT STREET ward-4 Catch Basin Repair 53461 inactive 2025-04-01 14:45 2025-04-01 42.343734 -71.236773
17014 17014 197 CYPRESS ST ward-6 Catch Basin Repair 53461 inactive 2025-03-28 12:30 2025-04-03 42.323634 -71.19032
16986 16986 11 MANDALAY ROAD ward-7 Catch Basin Repair 53461 inactive 2025-03-27 20:15 2025-03-28 42.340767 -71.182212
16782 16782 8 EMERALD ST ward-1 Catch Basin Repair 53461 inactive 2025-03-25 13:45 2025-03-26 42.35652 -71.200611
16777 16777 195 CYPRESS ST ward-6 Catch Basin Repair 53461 inactive 2025-03-25 12:30 2025-03-28 42.323688 -71.190374
16745 16745 216 WOODCLIFF RD ward-6 Catch Basin Repair 53461 inactive 2025-03-25 08:30 2025-03-26 42.315048 -71.200953
16696 16696 6 COTTONWOOD ROAD ward-8 Catch Basin Repair 53461 inactive 2025-03-24 07:00 2025-03-24 42.305128 -71.184089
16693 16693 259 WAVERLEY AVENUE ward-7 Catch Basin Repair 53461 inactive 2025-03-23 20:00 2025-03-24 42.34695 -71.180806
16681 16681 5 GRAYDALE CIR ward-4 Catch Basin Repair 53461 inactive 2025-03-22 17:00 2025-03-26 42.344361 -71.249459
16634 16634 5 DONNA RD ward-8 Catch Basin Repair 53461 inactive 2025-03-21 06:45 2025-03-21 42.308352 -71.179979
16633 16633 15 CLARK STREET ward-6 Catch Basin Repair 53461 inactive 2025-03-21 06:45 2025-03-22 42.322193 -71.201153
16624 16624 308 HOMER STREET ward-6 Catch Basin Repair 53461 inactive 2025-03-20 19:00 2025-03-21 42.335931 -71.206732
16575 16575 1616 CENTRE ST ward-6 Catch Basin Repair 53461 inactive 2025-03-20 09:45 2025-03-21 42.32079 -71.204202
16563 16563 4 BOYLSTON RD ward-6 Catch Basin Repair 53461 inactive 2025-03-19 18:30 2025-03-21 42.320754 -71.204207
16540 16540 22 FAXON ST ward-1 Catch Basin Repair 53461 inactive 2025-03-19 10:00 2025-03-24 42.364206 -71.199324
16485 16485 53 WASHBURN AVE ward-4 Catch Basin Repair 53461 inactive 2025-03-18 08:45 2025-03-21 42.351399 -71.24243
16419 16419 113 HANCOCK ST ward-4 Catch Basin Repair 53461 inactive 2025-03-16 17:30 2025-03-17 42.342606 -71.251349
16380 16380 126 ALGONQUIN RD ward-7 Catch Basin Repair 53461 inactive 2025-03-14 16:00 2025-03-24 42.341715 -71.173085
16363 16363 14 LARKSPUR RD ward-5 Catch Basin Repair 53461 inactive 2025-03-14 12:45 2025-03-17 42.322131 -71.232201
16334 16334 249 WOODCLIFF RD ward-8 Catch Basin Repair 53461 inactive 2025-03-13 20:15 2025-03-21 42.313734 -71.200971
16160 16160 111 PAULSON ROAD ward-5 Catch Basin Repair 53461 inactive 2025-03-10 20:00 2025-03-12 42.333171 -71.219607
16123 16123 99 PAULSON RD ward-5 Catch Basin Repair 53461 inactive 2025-03-10 12:30 2025-03-12 42.333093 -71.219984
16058 16058 14 LARKSPUR RD ward-5 Catch Basin Repair 53461 inactive 2025-03-09 17:45 2025-03-12 42.322131 -71.232201
16008 16008 26 PARK PL ward-2 Catch Basin Repair 53461 inactive 2025-03-08 13:30 2025-03-12 42.348339 -71.204612
16002 16002 90 HIGHLAND AVE ward-2 Catch Basin Repair 53461 inactive 2025-03-08 11:45 2025-03-12 42.348771 -71.210925
15960 15960 387 LOWELL AVE ward-2 Catch Basin Repair 53461 inactive 2025-03-07 16:30 2025-03-12 42.344091 -71.211537
15867 15867 19 PARK PL ward-2 Catch Basin Repair 53461 inactive 2025-03-07 08:30 2025-03-28 42.34851 -71.204936
15634 15634 113 HANCOCK ST ward-4 Catch Basin Repair 53461 inactive 2025-03-01 12:30 2025-03-12 42.342606 -71.251349
15599 15599 40 ALDEN PL ward-3 Catch Basin Repair 53461 inactive 2025-02-28 11:30 2025-03-12 42.35418 -71.231157
15170 15170 81 FARINA RD ward-8 Catch Basin Repair 53461 inactive 2025-02-20 12:00 2025-02-21 42.309396 -71.180879
14827 14827 19 ROWE ST ward-4 Catch Basin Repair 53461 inactive 2025-02-17 18:00 2025-02-21 42.349518 -71.240949
14755 14755 108 LOVETT RD ward-8 Catch Basin Repair 53461 inactive 2025-02-16 17:45 2025-02-21 42.304257 -71.184299
14628 14628 266 GREENWOOD ST ward-8 Catch Basin Repair 53461 inactive 2025-02-13 22:00 2025-05-14 42.304716 -71.190113
14246 14246 29 TOWER ROAD ward-5 Catch Basin Repair 53461 inactive 2025-02-06 09:30 2025-02-06 42.311087 -71.215369
14245 14245 114 THURSTON RD ward-5 Catch Basin Repair 53461 inactive 2025-02-06 09:30 2025-02-21 42.314733 -71.220888
14230 14230 30 CHASKE AVE ward-4 Catch Basin Repair 53461 inactive 2025-02-05 17:00 2025-02-21 42.350814 -71.250597
13858 13858 30 WHITE AVE ward-6 Catch Basin Repair 53461 inactive 2025-01-28 23:30 2025-02-21 42.321403 -71.189796
13594 13594 47 BOUND BROOK RD ward-8 Catch Basin Repair 53461 inactive 2025-01-23 13:00 2025-02-06 42.312177 -71.2044
13244 13244 76 WEBSTER PARK ward-3 Catch Basin Repair 53461 inactive 2025-01-16 12:45 2025-02-06 42.350312 -71.234455
12392 12392 1137 WASHINGTON STREET ward-3 Catch Basin Repair 53461 inactive 2024-12-30 21:45 2025-01-07 42.349999 -71.219929
11449 11449 1720 COMMONWEALTH AVE ward-4 Catch Basin Repair 53461 inactive 2024-12-10 16:15 2025-04-01 42.340036 -71.23761
11295 11295 59 LOWELL AVE ward-2 Catch Basin Repair 53461 inactive 2024-12-09 13:00 2025-04-08 42.355169 -71.209276
9851 9851 167 NEHOIDEN RD ward-5 Catch Basin Repair 53461 inactive 2024-11-07 13:30 2024-11-13 42.32749 -71.240763
9846 9846 28 MIGNON RD ward-3 Catch Basin Repair 53461 inactive 2024-11-07 13:15 2024-11-13 42.34014 -71.231073
7385 7385 81 CLARK ST ward-6 Catch Basin Repair 53461 inactive 2024-10-17 15:15 2024-11-06 42.320917 -71.198976
7384 7384 60 HARTMAN RD ward-8 Catch Basin Repair 53461 inactive 2024-10-17 15:15 2024-11-13 42.30736 -71.188667
6359 6359 46 SCHOFIELD DR ward-2 Catch Basin Repair 53461 inactive 2024-09-25 11:00 2024-10-22 42.361393 -71.213016
6219 6219 55 WOODBINE STREET ward-4 Catch Basin Repair 53461 inactive 2024-09-23 17:45 2024-10-22 42.346698 -71.253503
6218 6218 11 MORTON ST ward-2 Catch Basin Repair 53461 inactive 2024-09-23 17:45 2024-10-22 42.341387 -71.200904
5885 5885 23 CHERRY PL ward-3 Catch Basin Repair 53461 inactive 2024-09-16 08:45 2024-09-30 42.356419 -71.229045
5225 5225 16 ALBA CIR ward-7 Catch Basin Repair 53461 inactive 2024-09-03 08:45 2024-09-10 42.348467 -71.183782
5093 5093 28 EMERSON ST ward-1 Catch Basin Repair 53461 inactive 2024-08-29 06:30 2024-09-30 42.358776 -71.188165
4882 4882 485 NAHANTON STREET ward-8 Catch Basin Repair 53461 inactive 2024-08-24 18:45 2024-08-26 42.297439 -71.20729
4780 4780 35 MELBOURNE AVE ward-1 Catch Basin Repair 53461 inactive 2024-08-22 11:00 2024-09-13 42.363169 -71.204446
4738 4738 52 ALGONQUIN RD ward-7 Catch Basin Repair 53461 inactive 2024-08-21 14:15 2024-09-10 42.340894 -71.17039
4698 4698 450 DEDHAM STREET ward-8 Catch Basin Repair 53461 inactive 2024-08-21 06:45 2024-08-28 42.307815 -71.196881
4617 4617 237 FRANKLIN ST ward-7 Catch Basin Repair 53461 inactive 2024-08-19 15:45 2024-09-23 42.350009 -71.181763
4545 4545 1784 BEACON ST ward-5 Catch Basin Repair 53461 inactive 2024-08-17 09:45 2024-08-21 42.32668 -71.23715
4494 4494 31 SALISBURY RD ward-2 Catch Basin Repair 53461 inactive 2024-08-16 10:00 2024-09-25 42.348708 -71.196024
4466 4466 55 WOODBINE STREET ward-4 Catch Basin Repair 53461 inactive 2024-08-16 06:45 2024-08-21 42.346691 -71.253507
4386 4386 516 GROVE ST ward-4 Catch Basin Repair 53461 inactive 2024-08-15 07:15 2024-08-22 42.331228 -71.257204
3760 3760 51 OAK AVE ward-3 Catch Basin Repair 53461 inactive 2024-08-06 15:45 2024-08-07 42.350982 -71.232282
3533 3533 37 FREDERICK ST ward-2 Catch Basin Repair 53461 inactive 2024-08-02 09:45 2024-09-10 42.346988 -71.202441
3497 3497 92 MANET RD ward-7 Catch Basin Repair 53461 inactive 2024-08-01 13:45 2024-08-06 42.33605 -71.175815
3465 3465 62 DEBORAH RD ward-8 Catch Basin Repair 53461 inactive 2024-08-01 08:15 2024-08-06 42.308111 -71.183833
3451 3451 34 BROADLAWN PARK ward-8 Catch Basin Repair 53461 inactive 2024-07-31 15:45 2024-09-12 42.303754 -71.165013
3354 3354 342 WATERTOWN ST ward-1 Catch Basin Repair 53461 inactive 2024-07-30 10:15 2024-07-30 42.36069 -71.200173
2659 2659 24 GOULD RD ward-5 Catch Basin Repair 53461 inactive 2024-07-16 15:30 2024-07-22 42.32292 -71.233484
2584 2584 500 DEDHAM STREET ward-8 Catch Basin Repair 53461 inactive 2024-07-16 00:00 2024-09-25 42.306588 -71.195188
2522 2522 76 OAKDALE RD ward-6 Catch Basin Repair 53461 inactive 2024-07-13 21:45 2024-07-17 42.318096 -71.198177
2406 2406 32 COMMONWEALTH PARK ward-2 Catch Basin Repair 53461 inactive 2024-07-11 13:30 2024-07-17 42.338808 -71.202951
2032 2032 25 WARE RD ward-4 Catch Basin Repair 53461 inactive 2024-07-05 15:00 2024-10-01 42.349453 -71.250331
2031 2031 2150 COMMONWEALTH AVE ward-4 Catch Basin Repair 53461 inactive 2024-07-05 15:00 2024-09-23 42.347869 -71.249811
1971 1971 67 LEWIS STREET ward-1 Catch Basin Repair 53461 inactive 2024-07-03 19:15 2024-07-22 42.351283 -71.194673
658 658 72 WILLISTON RD ward-4 Catch Basin Repair 53461 inactive 2024-06-18 2024-06-20 42.340163 -71.252241
545 545 164 HARVARD STREET ward-2 Catch Basin Repair 53461 inactive 2024-06-17 2024-06-20 42.346861 -71.200587
544 544 100 BERKSHIRE RD ward-2 Catch Basin Repair 53461 inactive 2024-06-17 2024-06-18 42.340301 -71.204303
519 519 6 BEMIS RD ward-1 Catch Basin Repair 53461 inactive 2024-06-15 2024-06-18 42.363538 -71.208209
50 50 88 CHAPEL ST ward-1 Catch Basin Repair 53461 inactive   2024-06-18 42.3623 -71.200671
49 49 56 ROOSEVELT RD ward-8 Catch Basin Repair 53461 inactive   2024-06-18 42.314048 -71.193106
48 48 55 FARLOW RD ward-7 Catch Basin Repair 53461 inactive   2024-06-20 42.346951 -71.177995
47 47 36 WAMESIT RD ward-5 Catch Basin Repair 53461 inactive   2024-06-18 42.327734 -71.237434
46 46 11 LEWIS STREET ward-1 Catch Basin Repair 53461 inactive   2024-06-20 42.352334 -71.196594
45 45 100 BERKSHIRE ROAD ward-2 Catch Basin Repair 53461 inactive   2024-06-20 42.340356 -71.204587

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 1793.961ms