requests
24 rows where category_id = 53465 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: location, active, added, removed, latitude, longitude, added (date), removed (date)
| Link | rowid ▲ | location | ward | category | category_id | active | added | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 29336 | 29336 | 217 CRAFTS STREET | ward-1 | Noisy Manhole Cover | 53465 | active | 2025-11-04 17:30 | 42.357269 | -71.208224 | |
| 27275 | 27275 | 8 LOVETT RD | ward-8 | Noisy Manhole Cover | 53465 | active | 2025-09-25 11:00 | 42.300765 | -71.183808 | |
| 26724 | 26724 | 320 LOWELL AVE | ward-2 | Noisy Manhole Cover | 53465 | active | 2025-09-15 11:45 | 42.346314 | -71.210777 | |
| 24414 | 24414 | 217 CRAFTS ST | ward-1 | Noisy Manhole Cover | 53465 | active | 2025-07-30 16:15 | 42.357384 | -71.208036 | |
| 24165 | 24165 | 1000 COMMONWEALTH AVENUE | ward-2 | Noisy Manhole Cover | 53465 | active | 2025-07-26 16:15 | 42.336692 | -71.208835 | |
| 23621 | 23621 | 50 CHARLESBANK RD | ward-1 | Noisy Manhole Cover | 53465 | inactive | 2025-07-17 16:45 | 2025-10-30 | 42.358302 | -71.178444 |
| 23125 | 23125 | 51 OAK ST | ward-5 | Noisy Manhole Cover | 53465 | active | 2025-07-11 15:45 | 42.310899 | -71.221059 | |
| 21612 | 21612 | 11 WHEELER RD | ward-8 | Noisy Manhole Cover | 53465 | active | 2025-06-18 12:00 | 42.311592 | -71.196422 | |
| 20889 | 20889 | 50 CHARLESBANK ROAD | ward-1 | Noisy Manhole Cover | 53465 | inactive | 2025-06-07 11:15 | 2025-07-10 | 42.358383 | -71.178401 |
| 20687 | 20687 | 375 DUDLEY RD | ward-8 | Noisy Manhole Cover | 53465 | inactive | 2025-06-04 14:45 | 2025-07-14 | 42.308856 | -71.181869 |
| 19833 | 19833 | 231 MELROSE ST | ward-4 | Noisy Manhole Cover | 53465 | inactive | 2025-05-22 09:30 | 2025-05-23 | 42.348564 | -71.249153 |
| 19351 | 19351 | 143 FLORENCE ST | ward-8 | Noisy Manhole Cover | 53465 | active | 2025-05-14 08:00 | 42.317811 | -71.175951 | |
| 19350 | 19350 | 117 FLORENCE ST | ward-8 | Noisy Manhole Cover | 53465 | active | 2025-05-14 08:00 | 42.31791 | -71.177013 | |
| 18844 | 18844 | 236 TREMONT ST | ward-1 | Noisy Manhole Cover | 53465 | inactive | 2025-05-05 19:00 | 2025-05-06 | 42.353352 | -71.17799 |
| 16616 | 16616 | 55 CHARLESBANK ROAD | ward-1 | Noisy Manhole Cover | 53465 | inactive | 2025-03-20 17:00 | 2025-04-02 | 42.3584 | -71.178395 |
| 16615 | 16615 | 50 CHARLESBANK RD | ward-1 | Noisy Manhole Cover | 53465 | inactive | 2025-03-20 17:00 | 2025-04-02 | 42.358302 | -71.178444 |
| 13700 | 13700 | 32 WASHINGTON PARK | ward-2 | Noisy Manhole Cover | 53465 | inactive | 2025-01-26 19:00 | 2025-02-25 | 42.348928 | -71.202505 |
| 12775 | 12775 | 17 ELIOT AVE | ward-3 | Noisy Manhole Cover | 53465 | inactive | 2025-01-07 11:15 | 2025-01-07 | 42.353087 | -71.218176 |
| 10477 | 10477 | 15 CHAMPA ST | ward-5 | Noisy Manhole Cover | 53465 | inactive | 2024-11-22 10:00 | 2025-04-08 | 42.313381 | -71.218477 |
| 8630 | 8630 | 15 CHAMPA ST | ward-5 | Noisy Manhole Cover | 53465 | inactive | 2024-10-29 08:30 | 2024-10-29 | 42.313394 | -71.218434 |
| 6222 | 6222 | 375 DUDLEY RD | ward-8 | Noisy Manhole Cover | 53465 | inactive | 2024-09-23 17:45 | 2024-09-25 | 42.308856 | -71.181869 |
| 4255 | 4255 | 51 FLORENCE STREET | ward-8 | Noisy Manhole Cover | 53465 | inactive | 2024-08-13 08:00 | 2024-11-04 | 42.318306 | -71.180103 |
| 3806 | 3806 | 1025 WALNUT STREET | ward-6 | Noisy Manhole Cover | 53465 | inactive | 2024-08-07 12:00 | 2024-08-28 | 42.326453 | -71.206357 |
| 3165 | 3165 | 515 CENTRE STREET | ward-1 | Noisy Manhole Cover | 53465 | inactive | 2024-07-26 08:00 | 2024-09-17 | 42.353234 | -71.186466 |
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]);