requests
52 rows where category_id = 53470 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: ward, active, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 31539 | 31539 | 154 ALLERTON RD | ward-6 | Low Pressure | 53470 | active | 2025-12-19 14:00 | 42.323634 | -71.202168 | |
| 31397 | 31397 | 11 WAYNE RD | ward-8 | Low Pressure | 53470 | active | 2025-12-18 10:30 | 42.302673 | -71.171991 | |
| 31264 | 31264 | 77 CLOVERDALE RD | ward-6 | Low Pressure | 53470 | inactive | 2025-12-16 10:00 | 2025-12-17 | 42.319665 | -71.20053 |
| 30380 | 30380 | 75 BEECHER PL | ward-6 | Low Pressure | 53470 | inactive | 2025-11-25 09:45 | 2025-11-28 | 42.322509 | -71.181252 |
| 30374 | 30374 | 81 BEECHER PLACE | ward-6 | Low Pressure | 53470 | inactive | 2025-11-25 09:15 | 2025-11-28 | 42.322417 | -71.181002 |
| 30091 | 30091 | 39 BEECHER PL | ward-6 | Low Pressure | 53470 | inactive | 2025-11-19 12:45 | 2025-11-19 | 42.321852 | -71.182539 |
| 30073 | 30073 | 83 BEECHER PL | ward-6 | Low Pressure | 53470 | inactive | 2025-11-19 09:15 | 2025-11-19 | 42.322374 | -71.180928 |
| 30069 | 30069 | 368 LANGLEY RD | ward-6 | Low Pressure | 53470 | inactive | 2025-11-19 09:00 | 2025-11-19 | 42.321501 | -71.18375 |
| 30066 | 30066 | 75 BEECHER PL | ward-6 | Low Pressure | 53470 | inactive | 2025-11-19 08:45 | 2025-11-19 | 42.322509 | -71.181252 |
| 29364 | 29364 | 21 COOLIDGE RD | ward-7 | Low Pressure | 53470 | inactive | 2025-11-05 10:15 | 2025-11-05 | 42.339339 | -71.187012 |
| 28677 | 28677 | 19 PHILLIPS LN | ward-2 | Low Pressure | 53470 | inactive | 2025-10-23 09:00 | 2025-10-25 | 42.34716 | -71.204157 |
| 26737 | 26737 | 21 WHITTLESEY RD | ward-8 | Low Pressure | 53470 | inactive | 2025-09-15 14:00 | 2025-09-16 | 42.310503 | -71.196566 |
| 26251 | 26251 | 23 BLAKE ST | ward-2 | Low Pressure | 53470 | inactive | 2025-09-05 18:45 | 2025-09-06 | 42.347331 | -71.198802 |
| 25449 | 25449 | 36 SKY VIEW CIR | ward-8 | Low Pressure | 53470 | inactive | 2025-08-20 03:30 | 2025-08-25 | 42.304239 | -71.185545 |
| 24847 | 24847 | 18 SKY VIEW CIR | ward-8 | Low Pressure | 53470 | inactive | 2025-08-07 09:00 | 2025-08-25 | 42.304653 | -71.186252 |
| 24554 | 24554 | 42 GREENOUGH ST | ward-4 | Low Pressure | 53470 | inactive | 2025-08-03 13:45 | 2025-08-05 | 42.343956 | -71.237934 |
| 24094 | 24094 | 46 ALDERWOOD RD | ward-7 | Low Pressure | 53470 | inactive | 2025-07-25 07:15 | 2025-08-05 | 42.340518 | -71.190518 |
| 24090 | 24090 | 41 ALDERWOOD RD | ward-7 | Low Pressure | 53470 | inactive | 2025-07-24 19:30 | 2025-08-05 | 42.340203 | -71.190698 |
| 24081 | 24081 | 205 CYPRESS ST | ward-6 | Low Pressure | 53470 | inactive | 2025-07-24 16:15 | 2025-07-29 | 42.3234 | -71.19009 |
| 24062 | 24062 | 47 PRESCOTT ST | ward-2 | Low Pressure | 53470 | inactive | 2025-07-24 12:45 | 2025-07-26 | 42.35526 | -71.206142 |
| 23713 | 23713 | 31 FAYETTE ST | ward-1 | Low Pressure | 53470 | inactive | 2025-07-18 20:15 | 2025-07-23 | 42.359796 | -71.192223 |
| 23568 | 23568 | 404 LANGLEY RD | ward-6 | Low Pressure | 53470 | inactive | 2025-07-17 10:15 | 2025-07-23 | 42.320304 | -71.183093 |
| 23540 | 23540 | 34 BEECHER TERRACE | ward-6 | Low Pressure | 53470 | inactive | 2025-07-16 23:45 | 2025-07-23 | 42.320956 | -71.181273 |
| 23490 | 23490 | 102 BOYD ST | ward-1 | Low Pressure | 53470 | inactive | 2025-07-16 10:45 | 2025-07-23 | 42.360228 | -71.190077 |
| 23312 | 23312 | 209 COMMONWEALTH AVE | ward-7 | Low Pressure | 53470 | inactive | 2025-07-15 11:15 | 2025-07-16 | 42.33771 | -71.174376 |
| 22624 | 22624 | 71 HEATHERLAND RD | ward-8 | Low Pressure | 53470 | inactive | 2025-07-03 11:30 | 2025-07-07 | 42.313707 | -71.208437 |
| 22622 | 22622 | 107 UPLAND AVE | ward-8 | Low Pressure | 53470 | inactive | 2025-07-03 11:15 | 2025-07-07 | 42.315399 | -71.20832 |
| 22335 | 22335 | 25 BALLARD ST | ward-7 | Low Pressure | 53470 | inactive | 2025-06-30 09:45 | 2025-07-21 | 42.339366 | -71.191539 |
| 22227 | 22227 | 24 SHERIDAN ST | ward-3 | Low Pressure | 53470 | inactive | 2025-06-26 22:15 | 2025-06-30 | 42.358563 | -71.232804 |
| 21999 | 21999 | 300 LAKE AVENUE | ward-6 | Low Pressure | 53470 | inactive | 2025-06-24 09:45 | 2025-06-24 | 42.323589 | -71.205016 |
| 21990 | 21990 | 23A CHARLESBANK ROAD | ward-1 | Low Pressure | 53470 | inactive | 2025-06-24 08:15 | 2025-06-27 | 42.358419 | -71.1774 |
| 21520 | 21520 | 56 SOLON ST | ward-5 | Low Pressure | 53470 | inactive | 2025-06-17 14:45 | 2025-06-23 | 42.316389 | -71.201628 |
| 21267 | 21267 | 15 METACOMET ROAD | ward-5 | Low Pressure | 53470 | inactive | 2025-06-13 07:45 | 2025-06-17 | 42.329272 | -71.239135 |
| 20341 | 20341 | 60 PARKER TER | ward-8 | Low Pressure | 53470 | inactive | 2025-05-30 15:30 | 2025-06-02 | 42.312186 | -71.1936 |
| 20304 | 20304 | 50 KILBURN RD | ward-3 | Low Pressure | 53470 | inactive | 2025-05-30 11:00 | 2025-07-01 | 42.354081 | -71.227229 |
| 19356 | 19356 | 12 GLASTONBURY OVAL | ward-5 | Low Pressure | 53470 | inactive | 2025-05-14 08:15 | 2025-05-20 | 42.329745 | -71.220582 |
| 19268 | 19268 | 295 CYPRESS ST | ward-6 | Low Pressure | 53470 | inactive | 2025-05-13 08:15 | 2025-05-13 | 42.320889 | -71.188457 |
| 17316 | 17316 | 58 MORTON STREET | ward-2 | Low Pressure | 53470 | inactive | 2025-04-04 15:00 | 2025-04-18 | 42.340261 | -71.200703 |
| 16683 | 16683 | 63 ROSALIE RD | ward-8 | Low Pressure | 53470 | inactive | 2025-03-22 21:30 | 2025-03-26 | 42.30414 | -71.189109 |
| 15098 | 15098 | 350 QUINOBEQUIN RD | ward-5 | Low Pressure | 53470 | inactive | 2025-02-19 13:00 | 2025-02-24 | 42.321762 | -71.24153 |
| 13195 | 13195 | 50 OAK AVENUE | ward-3 | Low Pressure | 53470 | inactive | 2025-01-15 15:15 | 2025-01-15 | 42.351107 | -71.231765 |
| 12624 | 12624 | 15 WOODBINE TER | ward-4 | Low Pressure | 53470 | inactive | 2025-01-05 11:00 | 2025-01-06 | 42.346102 | -71.25421 |
| 11857 | 11857 | 21-23 PEABODY STREET | ward-1 | Low Pressure | 53470 | inactive | 2024-12-18 12:30 | 2024-12-19 | 42.357372 | -71.187174 |
| 11721 | 11721 | 18 HAWTHORNE AVE | ward-4 | Low Pressure | 53470 | inactive | 2024-12-16 08:15 | 2024-12-17 | 42.341422 | -71.244965 |
| 9449 | 9449 | 137 WITHINGTON ROAD | ward-2 | Low Pressure | 53470 | inactive | 2024-11-04 11:00 | 2024-11-13 | 42.345598 | -71.199104 |
| 7083 | 7083 | 15 EVERGREEN AVE | ward-4 | Low Pressure | 53470 | inactive | 2024-10-14 13:15 | 2024-10-16 | 42.344147 | -71.258416 |
| 4700 | 4700 | 194 OAK STREET | ward-5 | Low Pressure | 53470 | inactive | 2024-08-21 07:45 | 2024-11-01 | 42.307581 | -71.216539 |
| 4553 | 4553 | 15 DAVIS STREET | ward-3 | Low Pressure | 53470 | inactive | 2024-08-18 12:30 | 2024-08-19 | 42.348207 | -71.225529 |
| 4290 | 4290 | 15 ROBERTS AVE | ward-2 | Low Pressure | 53470 | inactive | 2024-08-13 13:00 | 2024-08-13 | 42.3524 | -71.211877 |
| 3755 | 3755 | 5 ELLIOT STREET | ward-5 | Low Pressure | 53470 | inactive | 2024-08-06 14:15 | 2024-08-12 | 42.318604 | -71.212558 |
| 2893 | 2893 | 12 ROTHERWOOD RD | ward-6 | Low Pressure | 53470 | inactive | 2024-07-20 15:30 | 2024-07-23 | 42.323488 | -71.199178 |
| 2518 | 2518 | 205 CYPRESS ST | ward-6 | Low Pressure | 53470 | inactive | 2024-07-13 12:00 | 2024-07-23 | 42.323396 | -71.190091 |
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]);