requests
17 rows where category_id = 55455 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: location, ward, removed, latitude, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 26569 | 26569 | 448 NEWTONVILLE AVE | ward-2 | Vandalism | 55455 | inactive | 2025-09-12 06:15 | 2025-09-12 | 42.350679 | -71.206182 |
| 22672 | 22672 | 140 BRANDEIS ROAD | ward-8 | Vandalism | 55455 | inactive | 2025-07-06 06:30 | 2025-07-07 | 42.313721 | -71.188075 |
| 20703 | 20703 | 714 BEACON ST | ward-6 | Vandalism | 55455 | inactive | 2025-06-04 16:30 | 2025-06-05 | 42.330681 | -71.189825 |
| 17058 | 17058 | 70 BOTSFORD ROAD | ward-8 | Vandalism | 55455 | inactive | 2025-03-29 23:00 | 2025-03-31 | 42.304109 | -71.173238 |
| 16706 | 16706 | 470 WATERTOWN STREET | ward-1 | Vandalism | 55455 | inactive | 2025-03-24 09:30 | 2025-03-24 | 42.358359 | -71.204511 |
| 15537 | 15537 | 47 GRAFTON ST | ward-6 | Vandalism | 55455 | inactive | 2025-02-27 09:30 | 2025-02-27 | 42.335541 | -71.195162 |
| 14394 | 14394 | 47 GRAFTON ST | ward-6 | Vandalism | 55455 | inactive | 2025-02-10 09:30 | 2025-02-10 | 42.335541 | -71.195162 |
| 14372 | 14372 | 8 CEDAR ST | ward-2 | Vandalism | 55455 | inactive | 2025-02-09 17:00 | 2025-02-10 | 42.340572 | -71.198591 |
| 14341 | 14341 | 47 GRAFTON ST | ward-6 | Vandalism | 55455 | inactive | 2025-02-08 20:15 | 2025-02-10 | 42.335661 | -71.194931 |
| 13832 | 13832 | 191 MILL STREET | ward-2 | Vandalism | 55455 | inactive | 2025-01-28 16:00 | 2025-01-29 | 42.341911 | -71.200799 |
| 13382 | 13382 | 52 CHANNING ROAD | ward-2 | Vandalism | 55455 | inactive | 2025-01-21 09:15 | 2025-01-21 | 42.339737 | -71.197996 |
| 10007 | 10007 | 54 NEWELL ROAD | ward-4 | Vandalism | 55455 | inactive | 2024-11-10 18:45 | 2024-11-11 | 42.350613 | -71.243269 |
| 9746 | 9746 | 100 CHESTNUT ST | ward-3 | Vandalism | 55455 | inactive | 2024-11-06 15:30 | 2024-11-07 | 42.346607 | -71.223957 |
| 9728 | 9728 | 24 HENSHAW TERRACE | ward-3 | Vandalism | 55455 | inactive | 2024-11-06 11:00 | 2024-11-06 | 42.352275 | -71.226985 |
| 9423 | 9423 | 447 CENTRE STREET | ward-1 | Vandalism | 55455 | inactive | 2024-11-02 17:45 | 2024-11-04 | 42.355196 | -71.186605 |
| 6891 | 6891 | 244 CALIFORNIA ST | ward-1 | Vandalism | 55455 | inactive | 2024-10-09 07:15 | 2024-10-15 | 42.364661 | -71.198265 |
| 3521 | 3521 | 661 WATERTOWN STREET | ward-2 | Vandalism | 55455 | inactive | 2024-08-02 08:45 | 2024-08-13 | 42.354915 | -71.212032 |
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]);