requests
13 rows where category_id = 51048 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 22660 | 22660 | 71 WOODWARD ST | ward-5 | Poison Ivy | 51048 | active | 2025-07-04 19:30 | 42.320889 | -71.214242 | |
| 22506 | 22506 | 246 DUDLEY RD | ward-8 | Poison Ivy | 51048 | inactive | 2025-07-02 09:00 | 2025-07-02 | 42.312636 | -71.179659 |
| 20915 | 20915 | 28 MANET RD | ward-7 | Poison Ivy | 51048 | inactive | 2025-06-08 17:30 | 2025-07-02 | 42.33816 | -71.174808 |
| 20381 | 20381 | 68 ALBERT RD | ward-4 | Poison Ivy | 51048 | inactive | 2025-05-31 21:45 | 2025-07-02 | 42.355206 | -71.240418 |
| 19984 | 19984 | 1148 CENTRE STREET | ward-6 | Poison Ivy | 51048 | inactive | 2025-05-24 19:30 | 2025-07-02 | 42.333068 | -71.193686 |
| 19804 | 19804 | 241 NAHANTON ST | ward-8 | Poison Ivy | 51048 | inactive | 2025-05-21 15:45 | 2025-07-02 | 42.299127 | -71.198384 |
| 19657 | 19657 | 57 WOODBINE ST | ward-4 | Poison Ivy | 51048 | inactive | 2025-05-20 07:00 | 2025-07-02 | 42.346665 | -71.253432 |
| 19160 | 19160 | 173 WABAN HILL RD N | ward-7 | Poison Ivy | 51048 | inactive | 2025-05-10 17:00 | 2025-07-02 | 42.339249 | -71.174966 |
| 4783 | 4783 | 14 DRIFTWOOD DR | ward-3 | Poison Ivy | 51048 | active | 2024-08-22 11:15 | 42.364337 | -71.223298 | |
| 3457 | 3457 | NEWTON CENTRE PLAYGROUND | ward-6 | Poison Ivy | 51048 | inactive | 2024-07-31 17:45 | 2024-08-01 | 42.332573 | -71.195801 |
| 1938 | 1938 | COLD SPRING PARK | ward-6 | Poison Ivy | 51048 | active | 2024-07-03 10:00 | 42.330992 | -71.212896 | |
| 1937 | 1937 | 1299 BEACON STREET | ward-6 | Poison Ivy | 51048 | active | 2024-07-03 10:00 | 42.330548 | -71.216544 | |
| 1238 | 1238 | 60 WOODBINE STREET | ward-4 | Poison Ivy | 51048 | active | 2024-06-23 | 42.346561 | -71.253645 |
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]);