home / n311

locations

28 rows where category_id = 50990 sorted by added descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid location ward category category_id active added ▲ removed latitude longitude
22375 22375 289 PARK ST 7 Graffiti 50990   2025-11-30 2025-12-01 42.34725 -71.183844
21499 21499 29 THURSTON RD 5 Graffiti 50990   2025-11-05 2025-11-05 42.315885 -71.217311
20377 20377 325 LOWELL AVE 2 Graffiti 50990 active 2025-10-07   42.346098 -71.211281
19822 19822 1483 CENTRE ST 6 Graffiti 50990   2025-09-23 2025-09-23 42.324336 -71.200431
17885 17885 1050 CHESTNUT ST 5 Graffiti 50990   2025-07-30 2025-08-11 42.313329 -71.224506
17682 17682 10 DOLPHIN RD 7 Graffiti 50990   2025-07-25 2025-08-11 42.340374 -71.178593
15177 15177 1199 CENTRE ST 6 Graffiti 50990   2025-06-06 2025-06-10 42.331563 -71.194797
14961 14961 96 DEXTER ROAD 2 Graffiti 50990   2025-06-03 2025-06-05 42.341911 -71.205364
14829 14829 1415 COMMONWEALTH AVE 3 Graffiti 50990   2025-06-02 2025-06-02 42.337566 -71.224416
13524 13524 1479 WASHINGTON STREET 3 Graffiti 50990   2025-05-05 2025-05-05 42.346908 -71.231876
13011 13011 77 LAKE AVE 6 Graffiti 50990   2025-04-21 2025-04-29 42.32981 -71.200768
10356 10356 288 WALNUT ST 2 Graffiti 50990   2025-02-11 2025-02-12 42.351012 -71.206461
10357 10357 442 WALNUT ST 2 Graffiti 50990   2025-02-11 2025-02-12 42.346143 -71.205849
10358 10358 472 WALNUT ST 2 Graffiti 50990   2025-02-11 2025-02-12 42.345117 -71.205453
10359 10359 508 WALNUT ST 2 Graffiti 50990   2025-02-11 2025-02-12 42.343965 -71.205575
9894 9894 222 LOWELL AVENUE 2 Graffiti 50990   2025-01-30 2025-02-01 42.349856 -71.210402
8292 8292 2–90 LAKE AVE 6 Graffiti 50990   2024-12-20 2025-02-26 42.329612 -71.200319
8214 8214 293 ALBEMARLE RD 3 Graffiti 50990   2024-12-17 2024-12-19 42.356333 -71.21567
8160 8160 02466 4 Graffiti 50990   2024-12-16 2024-12-16 42.35359 -71.252802
7110 7110 200–224 ALBEMARLE RD 2 Graffiti 50990   2024-11-20 2024-11-22 42.359618 -71.216741
4796 4796 409 WINCHESTER STREET 8 Graffiti 50990   2024-09-30 2024-10-03 42.30639 -71.20581
4651 4651 10 HERRICK RD 6 Graffiti 50990   2024-09-25 2024-09-25 42.329783 -71.193868
4003 4003 31 HERRICK RD 6 Graffiti 50990   2024-09-06 2024-09-10 42.328962 -71.193661
3926 3926 90 A CHRISTINA STREET 8 Graffiti 50990   2024-09-05 2024-09-09 42.306243 -71.213022
1700 1700 NEWTON CENTRE PLAYGROUND 6 Graffiti 50990   2024-07-09 2024-07-10 42.332573 -71.195801
1625 1625 2203 COMMONWEALTH AVE 4 Graffiti 50990   2024-07-08 2024-07-10 42.350556 -71.252678
1308 1308 99 SARGENT STREET 7 Graffiti 50990   2024-06-29 2024-07-03 42.346201 -71.184373
398 398 65 WEBSTER PARK   Graffiti 50990 active        

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