home / n311

requests

29 rows where category_id = 50994 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location, active, removed, latitude, longitude, added (date), removed (date)

Link rowid ▲ location ward category category_id active added removed latitude longitude
28634 28634 239 WINCHESTER ST ward-8 Gravel Request 50994 inactive 2025-10-22 12:15 2025-10-22 42.311808 -71.209067
28555 28555 10 MAPLEWOOD AVENUE ward-6 Gravel Request 50994 active 2025-10-21 16:00   42.32021 -71.189373
27859 27859 165 NESHOBE RD ward-5 Gravel Request 50994 inactive 2025-10-07 09:00 2025-10-27 42.326199 -71.244423
27814 27814 2 HIGHLAND TER ward-2 Gravel Request 50994 inactive 2025-10-06 11:45 2025-10-16 42.349428 -71.209202
27628 27628 6 THORNTON PL ward-1 Gravel Request 50994 inactive 2025-10-01 14:30 2025-10-09 42.357249 -71.18834
26363 26363 15 BURRAGE ROAD ward-7 Gravel Request 50994 inactive 2025-09-08 21:00 2025-10-01 42.339948 -71.190231
24952 24952 89 PARK AVE ward-7 Gravel Request 50994 inactive 2025-08-10 19:00 2025-08-12 42.343317 -71.18573
23943 23943 22 PARKWAY RD ward-1 Gravel Request 50994 inactive 2025-07-23 08:00 2025-08-05 42.363378 -71.207753
23794 23794 92 MORRILL ST ward-3 Gravel Request 50994 active 2025-07-21 11:15   42.363225 -71.222004
20498 20498 118 WALNUT HILL ROAD ward-6 Gravel Request 50994 inactive 2025-06-02 15:30 2025-06-04 42.31664 -71.19993
19729 19729 42 PROSPECT PARK ward-2 Gravel Request 50994 inactive 2025-05-20 16:00 2025-05-23 42.343119 -71.207987
18131 18131 10 HIGH ST ward-8 Gravel Request 50994 inactive 2025-04-22 14:00 2025-04-28 42.313005 -71.209859
17105 17105 18 PRISCILLA RD ward-7 Gravel Request 50994 inactive 2025-03-31 13:15 2025-04-02 42.33618 -71.173625
16951 16951 10 PARKER RD ward-8 Gravel Request 50994 inactive 2025-03-27 11:00 2025-04-22 42.314004 -71.196345
15608 15608 2 MORGAN PL ward-1 Gravel Request 50994 inactive 2025-02-28 14:15 2025-04-28 42.360487 -71.197579
15038 15038 215 AUBURN STREET ward-4 Gravel Request 50994 inactive 2025-02-18 18:15 2025-02-24 42.345875 -71.244197
12352 12352 2 MORGAN PL ward-1 Gravel Request 50994 inactive 2024-12-30 10:15 2025-01-08 42.360487 -71.197579
10402 10402 42 PROSPECT PARK ward-2 Gravel Request 50994 inactive 2024-11-20 16:30 2025-02-10 42.34312 -71.207988
8625 8625 542 CHESTNUT STREET ward-5 Gravel Request 50994 inactive 2024-10-29 07:30 2024-10-30 42.330794 -71.224448
7511 7511 50 CONCORD ST ward-4 Gravel Request 50994 active 2024-10-18 11:00   42.329708 -71.265716
7157 7157 2 MORGAN PL ward-1 Gravel Request 50994 inactive 2024-10-15 13:30 2024-10-23 42.360487 -71.197579
6600 6600 10 PARKER RD ward-8 Gravel Request 50994 inactive 2024-10-01 10:15 2024-10-08 42.314008 -71.196347
5673 5673 239 WINCHESTER STREET ward-8 Gravel Request 50994 inactive 2024-09-11 11:30 2024-09-26 42.311619 -71.2091
4736 4736 10 WINTHROP AVE ward-1 Gravel Request 50994 inactive 2024-08-21 14:15 2024-08-28 42.353691 -71.190239
4713 4713 5 SWAN AVE ward-3 Gravel Request 50994 inactive 2024-08-21 09:30 2024-08-29 42.362238 -71.22142
3428 3428 22 PARKWAY RD ward-1 Gravel Request 50994 inactive 2024-07-31 14:00 2024-08-06 42.363376 -71.207755
3153 3153 26 HIGH STREET ward-8 Gravel Request 50994 inactive 2024-07-25 15:45 2024-08-07 42.312881 -71.210222
2808 2808 12 GORDON TER ward-1 Gravel Request 50994 inactive 2024-07-18 13:45 2024-07-30 42.358607 -71.186979
1621 1621 2 MORGAN PL ward-1 Gravel Request 50994 inactive 2024-06-27 13:30 2024-07-23 42.360487 -71.197579

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);
Powered by Datasette · Queries took 1938.954ms