requests
28 rows where category_id = 50990 sorted by rowid descending
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 30491 | 30491 | 289 PARK ST | ward-7 | Graffiti | 50990 | inactive | 2025-11-30 11:30 | 2025-12-01 | 42.34725 | -71.183844 |
| 29353 | 29353 | 29 THURSTON RD | ward-5 | Graffiti | 50990 | inactive | 2025-11-05 09:00 | 2025-11-05 | 42.315885 | -71.217311 |
| 27882 | 27882 | 325 LOWELL AVE | ward-2 | Graffiti | 50990 | active | 2025-10-07 11:15 | 42.346098 | -71.211281 | |
| 27125 | 27125 | 1483 CENTRE ST | ward-6 | Graffiti | 50990 | inactive | 2025-09-23 09:15 | 2025-09-23 | 42.324336 | -71.200431 |
| 24390 | 24390 | 1050 CHESTNUT ST | ward-5 | Graffiti | 50990 | inactive | 2025-07-30 12:00 | 2025-08-11 | 42.313329 | -71.224506 |
| 24115 | 24115 | 10 DOLPHIN RD | ward-7 | Graffiti | 50990 | inactive | 2025-07-25 10:30 | 2025-08-11 | 42.340374 | -71.178593 |
| 20874 | 20874 | 1199 CENTRE ST | ward-6 | Graffiti | 50990 | inactive | 2025-06-06 17:15 | 2025-06-10 | 42.331563 | -71.194797 |
| 20590 | 20590 | 96 DEXTER ROAD | ward-2 | Graffiti | 50990 | inactive | 2025-06-03 16:15 | 2025-06-05 | 42.341911 | -71.205364 |
| 20428 | 20428 | 1415 COMMONWEALTH AVE | ward-3 | Graffiti | 50990 | inactive | 2025-06-02 09:15 | 2025-06-02 | 42.337566 | -71.224416 |
| 18768 | 18768 | 1479 WASHINGTON STREET | ward-3 | Graffiti | 50990 | inactive | 2025-05-05 01:45 | 2025-05-05 | 42.346908 | -71.231876 |
| 18074 | 18074 | 77 LAKE AVE | ward-6 | Graffiti | 50990 | inactive | 2025-04-21 16:15 | 2025-04-29 | 42.32981 | -71.200768 |
| 14515 | 14515 | 508 WALNUT ST | ward-2 | Graffiti | 50990 | inactive | 2025-02-11 12:45 | 2025-02-12 | 42.343965 | -71.205575 |
| 14514 | 14514 | 472 WALNUT ST | ward-2 | Graffiti | 50990 | inactive | 2025-02-11 12:45 | 2025-02-12 | 42.345117 | -71.205453 |
| 14513 | 14513 | 442 WALNUT ST | ward-2 | Graffiti | 50990 | inactive | 2025-02-11 12:45 | 2025-02-12 | 42.346143 | -71.205849 |
| 14512 | 14512 | 288 WALNUT ST | ward-2 | Graffiti | 50990 | inactive | 2025-02-11 12:45 | 2025-02-12 | 42.351012 | -71.206461 |
| 13948 | 13948 | 222 LOWELL AVENUE | ward-2 | Graffiti | 50990 | inactive | 2025-01-30 18:15 | 2025-02-01 | 42.349856 | -71.210402 |
| 11920 | 11920 | 2–90 LAKE AVE | ward-6 | Graffiti | 50990 | inactive | 2024-12-20 08:30 | 2025-02-26 | 42.329612 | -71.200319 |
| 11805 | 11805 | 293 ALBEMARLE RD | ward-3 | Graffiti | 50990 | inactive | 2024-12-17 12:15 | 2024-12-19 | 42.356333 | -71.21567 |
| 11732 | 11732 | 02466 | ward-4 | Graffiti | 50990 | inactive | 2024-12-16 09:30 | 2024-12-16 | 42.35359 | -71.252802 |
| 10380 | 10380 | 200–224 ALBEMARLE RD | ward-2 | Graffiti | 50990 | inactive | 2024-11-20 13:15 | 2024-11-22 | 42.359618 | -71.216741 |
| 6560 | 6560 | 409 WINCHESTER STREET | ward-8 | Graffiti | 50990 | inactive | 2024-09-30 12:45 | 2024-10-03 | 42.30639 | -71.20581 |
| 6338 | 6338 | 10 HERRICK RD | ward-6 | Graffiti | 50990 | inactive | 2024-09-25 08:45 | 2024-09-25 | 42.329783 | -71.193868 |
| 5450 | 5450 | 31 HERRICK RD | ward-6 | Graffiti | 50990 | inactive | 2024-09-06 14:30 | 2024-09-10 | 42.328962 | -71.193661 |
| 5349 | 5349 | 90 A CHRISTINA STREET | ward-8 | Graffiti | 50990 | inactive | 2024-09-04 20:15 | 2024-09-09 | 42.306243 | -71.213022 |
| 2255 | 2255 | NEWTON CENTRE PLAYGROUND | ward-6 | Graffiti | 50990 | inactive | 2024-07-09 14:15 | 2024-07-10 | 42.332573 | -71.195801 |
| 2146 | 2146 | 2203 COMMONWEALTH AVE | ward-4 | Graffiti | 50990 | inactive | 2024-07-08 11:15 | 2024-07-10 | 42.350556 | -71.252678 |
| 1727 | 1727 | 99 SARGENT STREET | ward-7 | Graffiti | 50990 | inactive | 2024-06-29 19:45 | 2024-07-03 | 42.346201 | -71.184373 |
| 398 | 398 | 65 WEBSTER PARK | Graffiti | 50990 | active |
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]);