requests
100 rows where category_id = 51041 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 31743 | 31743 | 76 CRESCENT ST | ward-3 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-12-23 17:30 | 42.346431 | -71.237709 | |
| 31655 | 31655 | 28 DAY ST | ward-4 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-12-22 14:15 | 2025-12-22 | 42.339411 | -71.237696 |
| 30308 | 30308 | 154 WASHINGTON STREET | ward-1 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-11-24 13:45 | 42.355993 | -71.180307 | |
| 30168 | 30168 | 305 CENTRE ST | ward-1 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-11-20 16:15 | 42.357888 | -71.184929 | |
| 29736 | 29736 | 1063 COMMONWEALTH AVE | ward-2 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-11-12 17:30 | 42.338304 | -71.21043 | |
| 29687 | 29687 | 566 GROVE ST | ward-4 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-11-12 08:30 | 42.329655 | -71.257959 | |
| 29360 | 29360 | 2 WELLS AVE | ward-8 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-11-05 10:15 | 42.295185 | -71.20184 | |
| 29100 | 29100 | 418 LANGLEY ROAD | ward-6 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-10-31 13:45 | 42.319909 | -71.182786 | |
| 28705 | 28705 | 1299 CENTRE ST | ward-6 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-10-23 20:00 | 42.329583 | -71.19536 | |
| 26051 | 26051 | 680 WALNUT ST | ward-2 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-09-03 09:45 | 2025-09-05 | 42.338106 | -71.20661 |
| 26050 | 26050 | 330 HOMER ST | ward-2 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-09-03 09:45 | 42.336045 | -71.207843 | |
| 25868 | 25868 | 191 COLLEGE ROAD | ward-7 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-08-28 17:15 | 42.337168 | -71.172143 | |
| 25428 | 25428 | 325 BEACON ST | ward-7 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-08-19 12:45 | 42.333273 | -71.171924 | |
| 25427 | 25427 | 200 HAMMOND ST | ward-7 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-08-19 12:45 | 42.333543 | -71.173202 | |
| 25309 | 25309 | 887 CHESTNUT ST | ward-5 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-08-15 20:45 | 42.318846 | -71.226356 | |
| 24988 | 24988 | 108 FULLER STREET | ward-5 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-08-11 13:45 | 42.335475 | -71.223737 | |
| 24157 | 24157 | 53 HOBART ROAD | ward-7 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-07-25 22:00 | 42.332188 | -71.181257 | |
| 24032 | 24032 | 5 HAMMOND ST | ward-7 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-07-24 08:45 | 42.337845 | -71.178696 | |
| 23780 | 23780 | 171 PEARL ST | ward-1 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-07-21 10:30 | 42.359256 | -71.193245 | |
| 23716 | 23716 | 233 JACKSON RD | ward-1 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-07-19 12:45 | 42.35526 | -71.195459 | |
| 23081 | 23081 | 233 COMMONWEALTH AVE | ward-7 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-07-11 08:45 | 42.337539 | -71.175704 | |
| 22989 | 22989 | 1243 WALNUT STREET | ward-6 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-07-09 16:00 | 42.319512 | -71.204436 | |
| 22882 | 22882 | 650 COMMONWEALTH AVE | ward-6 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-07-09 04:30 | 42.335631 | -71.193749 | |
| 22881 | 22881 | 1085 CENTRE ST | ward-6 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-07-09 04:30 | 42.335127 | -71.193632 | |
| 22831 | 22831 | 457 WALNUT ST | ward-2 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-07-08 12:00 | 2025-09-16 | 42.345126 | -71.207613 |
| 22805 | 22805 | 70 RIVER ST | ward-3 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-07-08 09:00 | 42.352119 | -71.229317 | |
| 22487 | 22487 | 119 ADAMS ST | ward-1 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-07-02 07:15 | 42.360273 | -71.202893 | |
| 22342 | 22342 | 761 WALNUT STREET | ward-2 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-30 10:30 | 42.335328 | -71.20905 | |
| 21945 | 21945 | 431 WASHINGTON ST | ward-1 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-06-23 17:00 | 2025-07-01 | 42.356043 | -71.190423 |
| 21941 | 21941 | 191 MILL STREET | ward-2 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-23 16:15 | 42.341704 | -71.200907 | |
| 21875 | 21875 | 61 WASHBURN AVE | ward-4 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-23 07:15 | 42.351498 | -71.242781 | |
| 21675 | 21675 | 255 WASHINGTON ST | ward-1 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-19 16:30 | 42.357771 | -71.183844 | |
| 21674 | 21674 | 138 LAKE AVE | ward-6 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-19 16:15 | 42.328152 | -71.20251 | |
| 21568 | 21568 | 770 BEACON ST | ward-6 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-18 06:15 | 42.330249 | -71.19225 | |
| 21561 | 21561 | 90 LAKE AVE | ward-6 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-18 06:00 | 42.329313 | -71.201012 | |
| 21560 | 21560 | 57 LAKE AVE | ward-6 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-18 06:00 | 42.329916 | -71.199855 | |
| 21559 | 21559 | 50 LAKE AVE | ward-6 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-18 06:00 | 42.329556 | -71.199297 | |
| 21558 | 21558 | 3 MORELAND AVE | ward-6 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-18 06:00 | 42.3288 | -71.202722 | |
| 21557 | 21557 | 137 LAKE AVE | ward-6 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-18 06:00 | 42.328278 | -71.203167 | |
| 21377 | 21377 | 44 CAPITAL ST | ward-1 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-16 10:15 | 42.360453 | -71.195234 | |
| 21297 | 21297 | 457 WALNUT ST | ward-2 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-06-13 14:15 | 2025-06-18 | 42.345126 | -71.207613 |
| 21295 | 21295 | 287 CENTRE ST | ward-1 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-13 14:00 | 42.35814 | -71.185023 | |
| 21084 | 21084 | 237 ADAMS ST | ward-1 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-11 05:00 | 42.35724 | -71.19891 | |
| 21083 | 21083 | 47 WOODWARD ST | ward-6 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-11 04:45 | 42.320232 | -71.213427 | |
| 21082 | 21082 | 1615 BEACON ST | ward-5 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-11 04:45 | 42.327261 | -71.230235 | |
| 21022 | 21022 | 288 LEXINGTON ST | ward-4 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-10 05:30 | 42.352119 | -71.245557 | |
| 20927 | 20927 | 41 ADAMS ST | ward-1 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-09 07:30 | 42.362127 | -71.205399 | |
| 20866 | 20866 | 69 DAY ST | ward-4 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-06 16:15 | 42.338223 | -71.238141 | |
| 20865 | 20865 | 1766 WASHINGTON ST | ward-4 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-06 16:15 | 42.338781 | -71.239919 | |
| 20610 | 20610 | 543 HAMMOND ST | ward-7 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-04 04:30 | 42.32493 | -71.165498 | |
| 20522 | 20522 | 53 VERNON ST | ward-1 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-06-03 07:15 | 2025-06-04 | 42.35445 | -71.181734 |
| 20521 | 20521 | 198 GREENWOOD ST | ward-8 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-03 07:15 | 42.306561 | -71.187944 | |
| 20517 | 20517 | 232 BROOKLINE ST | ward-8 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-03 06:45 | 42.30261 | -71.176955 | |
| 20407 | 20407 | 970 BEACON ST | ward-6 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-06-02 04:45 | 42.33042 | -71.201511 | |
| 20094 | 20094 | 94 WINCHESTER ST | ward-5 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-05-28 05:00 | 2025-05-28 | 42.316785 | -71.208648 |
| 20093 | 20093 | 893 WALNUT ST | ward-6 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-05-28 05:00 | 2025-05-28 | 42.330645 | -71.207123 |
| 20092 | 20092 | 173 JACKSON RD | ward-1 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-05-28 04:30 | 2025-05-28 | 42.357087 | -71.195657 |
| 19985 | 19985 | 1075 CENTRE STREET | ward-6 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-05-25 10:00 | 2025-07-16 | 42.335479 | -71.193493 |
| 19710 | 19710 | 258 HAMMOND ST | ward-7 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-05-20 13:30 | 2025-05-20 | 42.332337 | -71.171627 |
| 19489 | 19489 | 91 OAK HILL ST | ward-8 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-05-16 11:30 | 2025-05-16 | 42.298146 | -71.18024 |
| 19133 | 19133 | 416 LANGLEY RD | ward-6 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-05-09 13:45 | 2025-05-12 | 42.319881 | -71.183232 |
| 18703 | 18703 | 342 BEACON ST | ward-7 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-05-02 11:15 | 2025-05-05 | 42.332589 | -71.173238 |
| 18514 | 18514 | 291 WALNUT ST | ward-2 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-04-29 10:30 | 2025-09-04 | 42.350922 | -71.20728 |
| 18179 | 18179 | 1269 CENTRE ST | ward-6 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-04-23 10:00 | 2025-04-23 | 42.330186 | -71.195036 |
| 17916 | 17916 | 60 MIDDLESEX RD | ward-7 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-04-16 12:15 | 2025-04-16 | 42.326757 | -71.162681 |
| 17075 | 17075 | 381 DUDLEY RD | ward-8 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-03-30 20:15 | 42.308631 | -71.181774 | |
| 16587 | 16587 | 20 HAWTHORN ST | ward-1 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-03-20 11:00 | 2025-03-26 | 42.358851 | -71.202447 |
| 16232 | 16232 | 20 HARVARD ST | ward-2 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-03-11 16:45 | 42.351885 | -71.201691 | |
| 15514 | 15514 | 1408 WALNUT ST | ward-8 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-02-26 16:30 | 2025-05-19 | 42.314455 | -71.201841 |
| 14610 | 14610 | 23 NEWTONVILLE AVENUE | ward-1 | Pavement Markings - Faded pavement markings | 51041 | active | 2025-02-13 15:15 | 42.352198 | -71.187187 | |
| 13205 | 13205 | 214 BEACON ST | ward-7 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2025-01-15 17:45 | 2025-01-23 | 42.333252 | -71.167454 |
| 11598 | 11598 | 54 ASH STREET | ward-4 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-12-12 15:15 | 2024-12-12 | 42.347097 | -71.250849 |
| 11354 | 11354 | 51 MIDDLESEX ROAD | ward-7 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-12-10 10:00 | 2025-05-15 | 42.326376 | -71.162917 |
| 11192 | 11192 | 211 DERBY ST | ward-3 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-12-08 14:30 | 2024-12-17 | 42.359438 | -71.232395 |
| 11052 | 11052 | 213 DERBY ST | ward-3 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-12-04 16:45 | 2024-12-06 | 42.359502 | -71.232368 |
| 10899 | 10899 | 281 BEACON STREET | ward-7 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-12-02 12:30 | 2024-12-17 | 42.333227 | -71.170319 |
| 10413 | 10413 | 90 OAK HILL STREET | ward-8 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-11-21 08:30 | 2025-05-29 | 42.297867 | -71.180093 |
| 10412 | 10412 | 557 SAW MILL BROOK PARKWAY | ward-8 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-11-21 08:30 | 2025-08-13 | 42.293566 | -71.182335 |
| 10355 | 10355 | 28 AUSTIN STREET | ward-2 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-11-20 09:00 | 2024-11-21 | 42.350665 | -71.208267 |
| 10202 | 10202 | 549 COMMONWEALTH AVE | ward-7 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-11-15 16:00 | 2025-08-10 | 42.336519 | -71.18913 |
| 10150 | 10150 | 78 LAKEWOOD RD | ward-6 | Pavement Markings - Faded pavement markings | 51041 | active | 2024-11-14 11:30 | 42.326403 | -71.206934 | |
| 9989 | 9989 | 20 AUSTIN STREET | ward-2 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-11-09 12:30 | 2024-11-21 | 42.350403 | -71.208199 |
| 9691 | 9691 | 171 PINE ST | ward-4 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-11-05 16:15 | 2024-11-06 | 42.352196 | -71.242018 |
| 9432 | 9432 | 70 AUBURN ST | ward-4 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-11-03 21:00 | 2024-11-06 | 42.344629 | -71.237608 |
| 9023 | 9023 | 70 CRESCENT ST | ward-4 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-10-30 21:15 | 2024-11-06 | 42.346683 | -71.237767 |
| 7705 | 7705 | 78 WINCHESTER STREET | ward-5 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-10-20 11:45 | 2025-09-22 | 42.317104 | -71.207738 |
| 7589 | 7589 | 14 MIDDLESEX RD | ward-7 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-10-18 14:00 | 2024-11-05 | 42.326282 | -71.164929 |
| 7050 | 7050 | 300 HAMMOND POND PARKWAY | ward-7 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-10-13 10:30 | 2024-10-16 | 42.326255 | -71.177121 |
| 6866 | 6866 | 299 WATERTOWN ST | ward-1 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-10-08 17:00 | 2025-05-13 | 42.361179 | -71.198638 |
| 6184 | 6184 | NEWTON HIGHLANDS PLAYGROUND | ward-5 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-09-23 17:45 | 2024-10-07 | 42.316342 | -71.207266 |
| 6004 | 6004 | 20 LESLIE RD | ward-4 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-09-17 10:45 | 2024-10-11 | 42.338919 | -71.239151 |
| 5824 | 5824 | 430 CENTRE STREET | ward-1 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-09-13 18:45 | 2024-09-23 | 42.355818 | -71.185747 |
| 5276 | 5276 | 85 CHARLESBANK RD | ward-1 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-09-03 15:30 | 2024-09-04 | 42.358825 | -71.179978 |
| 5023 | 5023 | 370–390 CALIFORNIA ST | ward-1 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-08-27 19:30 | 2024-09-04 | 42.365122 | -71.204364 |
| 4729 | 4729 | 2370 COMMONWEALTH AVE | ward-4 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-08-21 12:15 | 2024-09-24 | 42.344605 | -71.258026 |
| 4628 | 4628 | 130 RACHEL ROAD | ward-8 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-08-19 21:45 | 2024-08-21 | 42.306386 | -71.205659 |
| 4469 | 4469 | 56 VALENTINE ST | ward-3 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-08-16 08:15 | 2024-08-21 | 42.342206 | -71.220317 |
| 4299 | 4299 | 385 WARD ST | ward-7 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-08-13 15:00 | 2024-08-20 | 42.338713 | -71.188696 |
| 3285 | 3285 | 427 CENTRE ST | ward-1 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-07-29 11:30 | 2024-07-30 | 42.355522 | -71.186506 |
| 1109 | 1109 | 34 ELDREDGE STREET | ward-1 | Pavement Markings - Faded pavement markings | 51041 | inactive | 2024-07-18 | 42.354689 | -71.183467 |
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]);