home / n311

locations

42 rows where category_id = 50970 sorted by added descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid location ward category category_id active added ▲ removed latitude longitude
23229 23229 499 CRAFTS ST 3 Damage - Private Property 50970 active 2025-12-21   42.360633 -71.220371
23040 23040 436 WINCHESTER ST 8 Damage - Private Property 50970 active 2025-12-17   42.305643 -71.205269
22738 22738 350 WOODWARD ST 5 Damage - Private Property 50970   2025-12-09 2025-12-11 42.325389 -71.225321
22337 22337 89 PLEASANT ST 6 Damage - Private Property 50970 active 2025-11-26   42.331392 -71.198406
21007 21007 232 BROOKLINE ST 8 Damage - Private Property 50970 active 2025-10-24   42.30261 -71.176955
19699 19699 38 FALMOUTH RD 3 Damage - Private Property 50970   2025-09-18 2025-10-07 42.362406 -71.2287
18906 18906 18 JOSEPH ROAD 3 Damage - Private Property 50970   2025-08-28 2025-09-09 42.362589 -71.215621
17989 17989 43 WINCHESTER RD 1 Damage - Private Property 50970   2025-08-02 2025-08-05 42.349851 -71.195909
17488 17488 1234 CHESTNUT ST 5 Damage - Private Property 50970   2025-07-21 2025-08-04 42.309783 -71.220132
16905 16905 999 WASHINGTON ST 2 Damage - Private Property 50970 active 2025-07-11   42.351066 -71.213931
16360 16360 6 WHEELER RD 8 Damage - Private Property 50970 active 2025-06-30   42.312042 -71.196237
16366 16366 47 MONTCLAIR RD 5 Damage - Private Property 50970   2025-06-30 2025-07-01 42.329898 -71.228934
15401 15401 26 MERRILL RD 7 Damage - Private Property 50970   2025-06-11 2025-07-30 42.337314 -71.179191
14619 14619 76 CLINTON PL 2 Damage - Private Property 50970   2025-05-28 2025-06-18 42.339582 -71.193834
14505 14505 22 ELMWOOD STREET 1 Damage - Private Property 50970   2025-05-27 2025-09-03 42.355795 -71.183118
13609 13609 44 ROLLING LN 8 Damage - Private Property 50970   2025-05-06 2025-05-13 42.30747 -71.172009
13166 13166 44 ROLLING LN 8 Damage - Private Property 50970   2025-04-24 2025-04-28 42.30747 -71.172009
11804 11804 79 PEARL ST 1 Damage - Private Property 50970   2025-03-15 2025-03-17 42.358545 -71.188839
11063 11063 176 DEDHAM ST 8 Damage - Private Property 50970   2025-02-24 2025-02-25 42.313788 -71.201642
10611 10611 658 COMMONWEALTH AVE 6 Damage - Private Property 50970   2025-02-17 2025-02-24 42.33555 -71.194127
10433 10433 63 PAGE RD 2 Damage - Private Property 50970 active 2025-02-13   42.354162 -71.210763
9817 9817 63 TANGLEWOOD RD 8 Damage - Private Property 50970   2025-01-28 2025-01-31 42.317271 -71.181824
9412 9412 46 TROY LN 5 Damage - Private Property 50970   2025-01-20 2025-01-23 42.335307 -71.219435
7891 7891 701 BOYLSTON ST 6 Damage - Private Property 50970 active 2024-12-10   42.319378 -71.199037
7573 7573 371 AUSTIN ST 2 Damage - Private Property 50970 active 2024-12-03   42.347765 -71.22379
6893 6893 2133 COMMONWEALTH AVE 4 Damage - Private Property 50970   2024-11-13 2024-11-20 42.348267 -71.249137
6734 6734 44 COLGATE RD 4 Damage - Private Property 50970 active 2024-11-07   42.327873 -71.257392
6743 6743 221 WALTHAM ST 3 Damage - Private Property 50970 active 2024-11-07   42.35952 -71.222695
6752 6752 131 MELROSE ST 4 Damage - Private Property 50970 active 2024-11-07   42.351983 -71.249308
6766 6766 522 COMMONWEALTH AVE 6 Damage - Private Property 50970 active 2024-11-07   42.336113 -71.187672
6774 6774 63 SOUTHGATE PARK 3 Damage - Private Property 50970 active 2024-11-07   42.355131 -71.226581
5789 5789 8 BROADLAWN PARK 8 Damage - Private Property 50970 active 2024-10-24   42.304235 -71.166066
5694 5694 134 SOUTH AVE   Damage - Private Property 50970   2024-10-22 2024-10-23    
5475 5475 520 COMMONWEALTH AVE 6 Damage - Private Property 50970 active 2024-10-18   42.336109 -71.187598
5496 5496 73 BALDPATE HILL RD 8 Damage - Private Property 50970 active 2024-10-18   42.306511 -71.178633
4323 4323 10 CENTRAL CLOSE 4 Damage - Private Property 50970   2024-09-16 2024-10-09 42.345483 -71.247966
4248 4248 765 DEDHAM ST 8 Damage - Private Property 50970 active 2024-09-13   42.299231 -71.187426
2759 2759 184 UPLAND AVE 8 Damage - Private Property 50970   2024-08-06 2025-08-11 42.312968 -71.207588
1352 1352 17 GILBERT ST 4 Damage - Private Property 50970   2024-07-01 2024-07-03 42.344409 -71.236583
1189 1189 15 WOODLAWN DR 7 Damage - Private Property 50970   2024-06-27 2024-07-19 42.341002 -71.17602
1004 1004 540 PARKER STREET 8 Damage - Private Property 50970   2024-06-24 2024-06-25 42.309182 -71.197205
147 147 36 CRESTWOOD RD 2 Damage - Private Property 50970     2024-06-17 42.341805 -71.215159

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "locations" (
   [location] TEXT,
   [ward] INTEGER,
   [category] TEXT,
   [category_id] TEXT REFERENCES [categories]([id]),
   [active] TEXT,
   [added] TEXT,
   [removed] TEXT,
   [latitude] FLOAT,
   [longitude] FLOAT
);
Powered by Datasette · Queries took 1140.098ms