requests
43 rows where category_id = 50970 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: ward, active, removed, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 31610 | 31610 | 499 CRAFTS ST | ward-3 | Damage - Private Property | 50970 | active | 2025-12-21 16:00 | 42.360633 | -71.220371 | |
| 31366 | 31366 | 436 WINCHESTER ST | ward-8 | Damage - Private Property | 50970 | active | 2025-12-17 16:30 | 42.305643 | -71.205269 | |
| 30960 | 30960 | 350 WOODWARD ST | ward-5 | Damage - Private Property | 50970 | inactive | 2025-12-09 18:30 | 2025-12-11 | 42.325389 | -71.225321 |
| 30434 | 30434 | 89 PLEASANT ST | ward-6 | Damage - Private Property | 50970 | active | 2025-11-26 10:00 | 42.331392 | -71.198406 | |
| 28721 | 28721 | 232 BROOKLINE ST | ward-8 | Damage - Private Property | 50970 | active | 2025-10-24 09:45 | 42.30261 | -71.176955 | |
| 26927 | 26927 | 38 FALMOUTH RD | ward-3 | Damage - Private Property | 50970 | inactive | 2025-09-18 12:00 | 2025-10-07 | 42.362406 | -71.2287 |
| 25833 | 25833 | 18 JOSEPH ROAD | ward-3 | Damage - Private Property | 50970 | inactive | 2025-08-28 10:00 | 2025-09-09 | 42.362589 | -71.215621 |
| 24540 | 24540 | 43 WINCHESTER RD | ward-1 | Damage - Private Property | 50970 | inactive | 2025-08-02 09:15 | 2025-08-05 | 42.349851 | -71.195909 |
| 24399 | 24399 | 76 CLINTON PL | ward-2 | Damage - Private Property | 50970 | inactive | 2025-07-30 14:00 | 2025-07-30 | 42.339582 | -71.193834 |
| 23835 | 23835 | 1234 CHESTNUT ST | ward-5 | Damage - Private Property | 50970 | inactive | 2025-07-21 14:45 | 2025-08-04 | 42.309783 | -71.220132 |
| 23070 | 23070 | 999 WASHINGTON ST | ward-2 | Damage - Private Property | 50970 | active | 2025-07-10 21:00 | 42.351066 | -71.213931 | |
| 22351 | 22351 | 47 MONTCLAIR RD | ward-5 | Damage - Private Property | 50970 | inactive | 2025-06-30 12:30 | 2025-07-01 | 42.329898 | -71.228934 |
| 22341 | 22341 | 6 WHEELER RD | ward-8 | Damage - Private Property | 50970 | active | 2025-06-30 10:30 | 42.312042 | -71.196237 | |
| 21154 | 21154 | 26 MERRILL RD | ward-7 | Damage - Private Property | 50970 | inactive | 2025-06-11 14:30 | 2025-07-30 | 42.337314 | -71.179191 |
| 20161 | 20161 | 76 CLINTON PL | ward-2 | Damage - Private Property | 50970 | inactive | 2025-05-28 15:30 | 2025-06-18 | 42.339582 | -71.193834 |
| 20012 | 20012 | 22 ELMWOOD STREET | ward-1 | Damage - Private Property | 50970 | inactive | 2025-05-26 22:00 | 2025-09-03 | 42.355795 | -71.183118 |
| 18875 | 18875 | 44 ROLLING LN | ward-8 | Damage - Private Property | 50970 | inactive | 2025-05-06 09:00 | 2025-05-13 | 42.30747 | -71.172009 |
| 18289 | 18289 | 44 ROLLING LN | ward-8 | Damage - Private Property | 50970 | inactive | 2025-04-24 17:00 | 2025-04-28 | 42.30747 | -71.172009 |
| 16392 | 16392 | 79 PEARL ST | ward-1 | Damage - Private Property | 50970 | inactive | 2025-03-15 17:45 | 2025-03-17 | 42.358545 | -71.188839 |
| 15356 | 15356 | 176 DEDHAM ST | ward-8 | Damage - Private Property | 50970 | inactive | 2025-02-24 16:15 | 2025-02-25 | 42.313788 | -71.201642 |
| 14818 | 14818 | 658 COMMONWEALTH AVE | ward-6 | Damage - Private Property | 50970 | inactive | 2025-02-17 16:30 | 2025-02-24 | 42.33555 | -71.194127 |
| 14618 | 14618 | 63 PAGE RD | ward-2 | Damage - Private Property | 50970 | active | 2025-02-13 16:45 | 42.354162 | -71.210763 | |
| 13844 | 13844 | 63 TANGLEWOOD RD | ward-8 | Damage - Private Property | 50970 | inactive | 2025-01-28 16:45 | 2025-01-31 | 42.317271 | -71.181824 |
| 13343 | 13343 | 46 TROY LN | ward-5 | Damage - Private Property | 50970 | inactive | 2025-01-20 09:45 | 2025-01-23 | 42.335307 | -71.219435 |
| 11366 | 11366 | 701 BOYLSTON ST | ward-6 | Damage - Private Property | 50970 | active | 2024-12-10 12:00 | 42.319378 | -71.199037 | |
| 10951 | 10951 | 371 AUSTIN ST | ward-2 | Damage - Private Property | 50970 | active | 2024-12-03 12:00 | 42.347765 | -71.22379 | |
| 10077 | 10077 | 2133 COMMONWEALTH AVE | ward-4 | Damage - Private Property | 50970 | inactive | 2024-11-13 07:30 | 2024-11-20 | 42.348267 | -71.249137 |
| 9909 | 9909 | 63 SOUTHGATE PARK | ward-3 | Damage - Private Property | 50970 | active | 2024-11-07 16:15 | 42.355131 | -71.226581 | |
| 9903 | 9903 | 522 COMMONWEALTH AVE | ward-6 | Damage - Private Property | 50970 | active | 2024-11-07 16:00 | 42.336113 | -71.187672 | |
| 9891 | 9891 | 131 MELROSE ST | ward-4 | Damage - Private Property | 50970 | active | 2024-11-07 15:30 | 42.351983 | -71.249308 | |
| 9883 | 9883 | 221 WALTHAM ST | ward-3 | Damage - Private Property | 50970 | active | 2024-11-07 15:15 | 42.35952 | -71.222695 | |
| 9872 | 9872 | 44 COLGATE RD | ward-4 | Damage - Private Property | 50970 | active | 2024-11-07 14:45 | 42.327873 | -71.257392 | |
| 8214 | 8214 | 8 BROADLAWN PARK | ward-8 | Damage - Private Property | 50970 | active | 2024-10-24 10:00 | 42.304235 | -71.166066 | |
| 7968 | 7968 | 134 SOUTH AVE | Damage - Private Property | 50970 | inactive | 2024-10-22 17:30 | 2024-10-23 | |||
| 7667 | 7667 | 73 BALDPATE HILL RD | ward-8 | Damage - Private Property | 50970 | active | 2024-10-18 16:15 | 42.306511 | -71.178633 | |
| 7618 | 7618 | 520 COMMONWEALTH AVE | ward-6 | Damage - Private Property | 50970 | active | 2024-10-18 15:00 | 42.336109 | -71.187598 | |
| 5889 | 5889 | 10 CENTRAL CLOSE | ward-4 | Damage - Private Property | 50970 | inactive | 2024-09-16 09:00 | 2024-10-09 | 42.345483 | -71.247966 |
| 5788 | 5788 | 765 DEDHAM ST | ward-8 | Damage - Private Property | 50970 | active | 2024-09-13 10:00 | 42.299231 | -71.187426 | |
| 3710 | 3710 | 184 UPLAND AVE | ward-8 | Damage - Private Property | 50970 | inactive | 2024-08-06 08:45 | 2025-08-11 | 42.312968 | -71.207588 |
| 1797 | 1797 | 17 GILBERT ST | ward-4 | Damage - Private Property | 50970 | inactive | 2024-07-01 15:30 | 2024-07-03 | 42.344409 | -71.236583 |
| 1584 | 1584 | 15 WOODLAWN DR | ward-7 | Damage - Private Property | 50970 | inactive | 2024-06-27 | 2024-07-19 | 42.341002 | -71.17602 |
| 1344 | 1344 | 540 PARKER STREET | ward-8 | Damage - Private Property | 50970 | inactive | 2024-06-24 | 2024-06-25 | 42.309182 | -71.197205 |
| 147 | 147 | 36 CRESTWOOD RD | ward-2 | Damage - Private Property | 50970 | inactive | 2024-06-17 | 42.341805 | -71.215159 |
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]);