requests
8 rows where category_id = 51095 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: ward, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 28094 | 28094 | 211 PLYMOUTH RD | ward-5 | Sign Vandalized | 51095 | inactive | 2025-10-12 17:30 | 2025-10-14 | 42.322932 | -71.215389 |
| 26797 | 26797 | 22 LINCOLN ST | ward-6 | Sign Vandalized | 51095 | inactive | 2025-09-16 10:30 | 2025-09-17 | 42.321456 | -71.206997 |
| 25617 | 25617 | 100 LOS ANGELES ST | ward-1 | Sign Vandalized | 51095 | inactive | 2025-08-22 14:30 | 2025-08-26 | 42.363396 | -71.196435 |
| 22671 | 22671 | 131 COUNTRY CLUB RD | ward-8 | Sign Vandalized | 51095 | inactive | 2025-07-06 00:15 | 2025-07-08 | 42.305238 | -71.190392 |
| 22669 | 22669 | 16 ALBEMARLE RD | ward-2 | Sign Vandalized | 51095 | inactive | 2025-07-05 21:00 | 2025-07-09 | 42.364206 | -71.213369 |
| 17056 | 17056 | 1025 WALNUT ST | ward-6 | Sign Vandalized | 51095 | inactive | 2025-03-29 19:00 | 2025-03-31 | 42.326343 | -71.206646 |
| 12642 | 12642 | 1479 WASHINGTON STREET | ward-3 | Sign Vandalized | 51095 | inactive | 2025-01-06 01:00 | 2025-01-06 | 42.346962 | -71.2318 |
| 4759 | 4759 | 65-67 BRIDGE STREET | ward-1 | Sign Vandalized | 51095 | inactive | 2024-08-21 21:15 | 2024-08-22 | 42.362843 | -71.203106 |
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]);