requests
22 rows where category_id = 51031 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: ward, removed, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 31423 | 31423 | 15 CYPRESS ST | ward-6 | Parking - Broken Meter | 51031 | inactive | 2025-12-18 16:00 | 2025-12-22 | 42.328656 | -71.194991 |
| 31245 | 31245 | 107 CENTRE STREET | ward-1 | Parking - Broken Meter | 51031 | inactive | 2025-12-15 16:30 | 2025-12-16 | 42.355573 | -71.186841 |
| 30826 | 30826 | 2014 WASHINGTON ST | ward-5 | Parking - Broken Meter | 51031 | inactive | 2025-12-05 14:15 | 2025-12-09 | 42.331437 | -71.24684 |
| 28455 | 28455 | 887 WASHINGTON ST | ward-2 | Parking - Broken Meter | 51031 | inactive | 2025-10-20 10:15 | 2025-10-21 | 42.351426 | -71.209346 |
| 26939 | 26939 | 50 UNION ST | ward-6 | Parking - Broken Meter | 51031 | inactive | 2025-09-18 15:15 | 2025-09-18 | 42.329718 | -71.192048 |
| 26388 | 26388 | 103 MADISON AVE | ward-2 | Parking - Broken Meter | 51031 | inactive | 2025-09-09 12:15 | 2025-09-09 | 42.350085 | -71.206277 |
| 26206 | 26206 | 42 LANGLEY RD | ward-6 | Parking - Broken Meter | 51031 | inactive | 2025-09-05 10:30 | 2025-09-09 | 42.330735 | -71.192651 |
| 25755 | 25755 | 91 GREENLAWN AVENUE | ward-6 | Parking - Broken Meter | 51031 | inactive | 2025-08-26 19:15 | 2025-08-27 | 42.334068 | -71.204023 |
| 25343 | 25343 | 799 WASHINGTON ST | ward-2 | Parking - Broken Meter | 51031 | inactive | 2025-08-18 10:45 | 2025-08-19 | 42.352002 | -71.206169 |
| 23838 | 23838 | 10 LANGLEY RD | ward-6 | Parking - Broken Meter | 51031 | inactive | 2025-07-21 15:30 | 2025-07-22 | 42.331257 | -71.193978 |
| 22251 | 22251 | 437 CHERRY ST | ward-3 | Parking - Broken Meter | 51031 | inactive | 2025-06-27 10:45 | 2025-06-27 | 42.349536 | -71.228637 |
| 18606 | 18606 | 823 WASHINGTON STREET | ward-2 | Parking - Broken Meter | 51031 | inactive | 2025-04-30 16:30 | 2025-05-01 | 42.351727 | -71.206732 |
| 16716 | 16716 | 181 WELLS AVENUE | ward-8 | Parking - Broken Meter | 51031 | inactive | 2025-03-24 11:00 | 2025-03-24 | 42.295124 | -71.198278 |
| 14590 | 14590 | 796 BEACON ST | ward-6 | Parking - Broken Meter | 51031 | inactive | 2025-02-13 11:15 | 2025-02-13 | 42.330123 | -71.193497 |
| 14005 | 14005 | 21 HARTFORD ST | ward-6 | Parking - Broken Meter | 51031 | inactive | 2025-02-01 12:45 | 2025-02-05 | 42.321006 | -71.208176 |
| 13293 | 13293 | 102 ELM STREET | ward-3 | Parking - Broken Meter | 51031 | inactive | 2025-01-17 11:30 | 2025-01-19 | 42.349296 | -71.229023 |
| 12198 | 12198 | 429 CENTRE ST | ward-1 | Parking - Broken Meter | 51031 | inactive | 2024-12-24 10:15 | 2024-12-24 | 42.355517 | -71.186508 |
| 11056 | 11056 | 33 MAPLE AVE | ward-1 | Parking - Broken Meter | 51031 | inactive | 2024-12-04 17:00 | 2024-12-06 | 42.353439 | -71.188909 |
| 9998 | 9998 | 211 ADAMS STREET | ward-1 | Parking - Broken Meter | 51031 | inactive | 2024-11-09 15:45 | 2024-11-12 | 42.357888 | -71.199844 |
| 6614 | 6614 | 897 WASHINGTON ST | ward-2 | Parking - Broken Meter | 51031 | inactive | 2024-10-01 14:30 | 2024-10-04 | 42.351387 | -71.209651 |
| 5451 | 5451 | 411 LEXINGTON STREET | ward-4 | Parking - Broken Meter | 51031 | inactive | 2024-09-06 14:30 | 2024-09-25 | 42.347579 | -71.247157 |
| 3489 | 3489 | 911 WASHINGTON STREET | ward-2 | Parking - Broken Meter | 51031 | inactive | 2024-08-01 12:15 | 2024-10-04 | 42.351192 | -71.210074 |
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]);