requests
68 rows where category_id = 53231 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 6512 | 6512 | 16 BRAE BURN RD AUBURNDALE MA 2466 | ward-4 | Broken | 53231 | active | 2024-09-27 16:45 | 42.343631 | -71.239373 | |
| 6069 | 6069 | 45 CRESCENT AVE | ward-6 | Broken | 53231 | active | 2024-09-23 17:45 | 42.329743 | -71.198033 | |
| 6068 | 6068 | 10 OMAR TER | ward-2 | Broken | 53231 | inactive | 2024-09-23 17:45 | 2024-09-24 | 42.353712 | -71.206936 |
| 5940 | 5940 | 221 WALTHAM ST | ward-3 | Broken | 53231 | inactive | 2024-09-16 17:45 | 2024-09-24 | 42.359511 | -71.222694 |
| 5913 | 5913 | 31 GAY STREET | ward-2 | Broken | 53231 | inactive | 2024-09-16 13:15 | 2024-09-17 | 42.346811 | -71.202956 |
| 5846 | 5846 | WASHINGTON ST | ward-1 | Broken | 53231 | inactive | 2024-09-15 20:00 | 2024-09-24 | 42.354921 | -71.195187 |
| 5744 | 5744 | 33 OAK VALE | ward-5 | Broken | 53231 | inactive | 2024-09-12 14:15 | 2024-09-25 | 42.331602 | -71.225985 |
| 5720 | 5720 | 90 WELLS AVE | ward-8 | Broken | 53231 | active | 2024-09-12 08:45 | 42.292659 | -71.198445 | |
| 5620 | 5620 | 364 CALIFORNIA ST | ward-1 | Broken | 53231 | active | 2024-09-10 13:30 | 42.364967 | -71.203755 | |
| 5527 | 5527 | 59 DALBY ST | ward-1 | Broken | 53231 | active | 2024-09-09 13:15 | 42.363069 | -71.200158 | |
| 5521 | 5521 | 39 GROVE HILL PARK | ward-2 | Broken | 53231 | active | 2024-09-09 11:15 | 42.340037 | -71.209574 | |
| 5467 | 5467 | 55 CHARLESBANK RD | ward-1 | Broken | 53231 | inactive | 2024-09-07 07:00 | 2024-09-09 | 42.358661 | -71.17846 |
| 5415 | 5415 | 22 NARDELL RD | ward-8 | Broken | 53231 | inactive | 2024-09-05 22:00 | 2024-09-11 | 42.308722 | -71.180131 |
| 5273 | 5273 | 455 NAHANTON ST | ward-8 | Broken | 53231 | inactive | 2024-09-03 15:30 | 2024-09-04 | 42.298349 | -71.208303 |
| 5190 | 5190 | 225 BOYLSTON ST | ward-7 | Broken | 53231 | inactive | 2024-09-01 11:15 | 2024-09-03 | 42.321481 | -71.174864 |
| 5096 | 5096 | 23 REGINA RD | ward-4 | Broken | 53231 | active | 2024-08-29 08:30 | 42.348575 | -71.251115 | |
| 5071 | 5071 | 47 ASHMONT AVENUE | ward-1 | Broken | 53231 | inactive | 2024-08-28 15:15 | 2024-08-28 | 42.356384 | -71.202547 |
| 4824 | 4824 | 3 CHANDLER ST | ward-1 | Broken | 53231 | active | 2024-08-23 09:15 | 42.361605 | -71.202536 | |
| 4816 | 4816 | 11 KENWOOD AVE | ward-6 | Broken | 53231 | inactive | 2024-08-22 20:45 | 2024-08-26 | 42.337275 | -71.202251 |
| 4710 | 4710 | 15 SHELDON RD | ward-8 | Broken | 53231 | inactive | 2024-08-21 09:15 | 2024-08-21 | 42.318338 | -71.193042 |
| 4550 | 4550 | 24 SYLVESTER RD | ward-3 | Broken | 53231 | inactive | 2024-08-18 08:15 | 2024-08-21 | 42.361438 | -71.227919 |
| 4401 | 4401 | 116 NORTH ST | ward-3 | Broken | 53231 | active | 2024-08-15 10:30 | 42.362909 | -71.218679 | |
| 4263 | 4263 | AUBURNDALE PARK (THE COVE) | ward-4 | Broken | 53231 | inactive | 2024-08-13 09:30 | 2024-08-26 | 42.353584 | -71.251238 |
| 4247 | 4247 | 1550 CENTRE ST | ward-6 | Broken | 53231 | inactive | 2024-08-12 21:15 | 2024-08-13 | 42.322128 | -71.202255 |
| 4193 | 4193 | 110 NORTH ST | ward-3 | Broken | 53231 | inactive | 2024-08-12 12:00 | 2024-09-17 | 42.362829 | -71.218412 |
| 4139 | 4139 | 89–199 ADELINE RD | ward-8 | Broken | 53231 | inactive | 2024-08-11 17:45 | 2024-08-13 | 42.316239 | -71.190156 |
| 3835 | 3835 | 8 MEADOWBROOK RD | ward-8 | Broken | 53231 | inactive | 2024-08-07 17:15 | 2024-08-08 | 42.305562 | -71.194035 |
| 3808 | 3808 | 74 RACHEL RD | ward-8 | Broken | 53231 | inactive | 2024-08-07 12:15 | 2024-08-07 | 42.307285 | -71.203127 |
| 3775 | 3775 | 165 ALBEMARLE RD | ward-3 | Broken | 53231 | inactive | 2024-08-07 08:15 | 2024-08-21 | 42.36055 | -71.216928 |
| 3768 | 3768 | 427 CRAFTS ST | ward-3 | Broken | 53231 | inactive | 2024-08-06 19:45 | 2024-08-07 | 42.36 | -71.217156 |
| 3728 | 3728 | THE FESSENDEN SCHOOL | ward-3 | Broken | 53231 | inactive | 2024-08-06 11:00 | 2024-08-06 | 42.359844 | -71.217217 |
| 3271 | 3271 | 15 DWHINDA RD | ward-5 | Broken | 53231 | inactive | 2024-07-29 09:45 | 2024-07-31 | 42.323007 | -71.24673 |
| 3111 | 3111 | 104 OXFORD RD | ward-6 | Broken | 53231 | active | 2024-07-24 16:30 | 42.323653 | -71.194815 | |
| 2925 | 2925 | 716 COMMONWEALTH AVE | ward-6 | Broken | 53231 | inactive | 2024-07-22 10:00 | 2024-09-04 | 42.336515 | -71.196447 |
| 2818 | 2818 | 263 HAMMOND ST | ward-7 | Broken | 53231 | inactive | 2024-07-18 15:30 | 2024-07-30 | 42.331708 | -71.172036 |
| 2788 | 2788 | 215 SPIERS RD | ward-8 | Broken | 53231 | active | 2024-07-18 10:45 | 42.292315 | -71.181347 | |
| 2609 | 2609 | 19 SIMPSON ST | ward-1 | Broken | 53231 | inactive | 2024-07-16 09:00 | 2024-08-19 | 42.356328 | -71.173846 |
| 2489 | 2489 | 427 CRAFTS ST | ward-3 | Broken | 53231 | inactive | 2024-07-12 13:00 | 2024-07-18 | 42.359981 | -71.217108 |
| 1728 | 1728 | 5 EASTHAM RD | ward-8 | Broken | 53231 | inactive | 2024-06-30 03:45 | 2024-07-01 | 42.300956 | -71.174251 |
| 1699 | 1699 | 95 GLEN AVE | ward-6 | Broken | 53231 | inactive | 2024-06-28 14:30 | 2024-08-29 | 42.328581 | -71.187773 |
| 1686 | 1686 | 198 SUMNER ST | ward-6 | Broken | 53231 | inactive | 2024-06-28 12:15 | 2024-07-01 | 42.331357 | -71.191938 |
| 1611 | 1611 | 91 WEST ST | ward-1 | Broken | 53231 | active | 2024-06-27 11:45 | 42.358135 | -71.198458 | |
| 1457 | 1457 | 5 HELENE RD | ward-5 | Broken | 53231 | inactive | 2024-06-26 | 2024-06-26 | 42.333272 | -71.219458 |
| 1339 | 1339 | 308 WATERTOWN ST | ward-1 | Broken | 53231 | inactive | 2024-06-24 | 2024-08-08 | 42.360966 | -71.19901 |
| 1338 | 1338 | 1858 WASHINGTON ST | ward-4 | Broken | 53231 | inactive | 2024-06-24 | 2024-06-25 | 42.335923 | -71.241114 |
| 1336 | 1336 | 11 BRIDGE ST | ward-1 | Broken | 53231 | inactive | 2024-06-24 | 2024-06-25 | 42.364683 | -71.204418 |
| 1293 | 1293 | 35 CLOVERDALE RD | ward-6 | Broken | 53231 | active | 2024-06-24 | 42.32106 | -71.200398 | |
| 1264 | 1264 | 92 LANGDON ST | ward-2 | Broken | 53231 | active | 2024-06-24 | 42.34914 | -71.193867 | |
| 1240 | 1240 | 157 CHERRY ST | ward-3 | Broken | 53231 | active | 2024-06-23 | 42.35887 | -71.227283 | |
| 1203 | 1203 | 19 WESTCHESTER RD | ward-2 | Broken | 53231 | inactive | 2024-06-22 | 2024-07-17 | 42.347109 | -71.197777 |
| 979 | 979 | 9 MANHATTAN TER | ward-3 | Broken | 53231 | inactive | 2024-06-25 | 42.355559 | -71.229521 | |
| 978 | 978 | 89 BEMIS ST | ward-2 | Broken | 53231 | inactive | 2024-07-29 | 42.363322 | -71.211387 | |
| 977 | 977 | 83 GREENLAWN AVE | ward-6 | Broken | 53231 | active | 42.3339 | -71.20421 | ||
| 976 | 976 | 7 RESERVOIR AVE | ward-7 | Broken | 53231 | active | 42.33323 | -71.166034 | ||
| 975 | 975 | 55 JUNE LN | ward-8 | Broken | 53231 | active | 42.295616 | -71.181367 | ||
| 974 | 974 | 48 CHESLEY ROAD | ward-6 | Broken | 53231 | inactive | 2024-09-24 | 42.330946 | -71.190895 | |
| 973 | 973 | 46 WALKER STREET | ward-2 | Broken | 53231 | active | 42.353034 | -71.212377 | ||
| 972 | 972 | 452 DEDHAM ST | ward-8 | Broken | 53231 | inactive | 2024-06-26 | 42.30766 | -71.196414 | |
| 971 | 971 | 400 BEACON STREET | ward-7 | Broken | 53231 | active | 42.332312 | -71.176018 | ||
| 970 | 970 | 29 EXETER ST | ward-3 | Broken | 53231 | inactive | 2024-07-30 | 42.34022 | -71.227606 | |
| 969 | 969 | 2601-2609 BEACON STREET | Broken | 53231 | inactive | 2024-08-01 | 42.333457 | -71.167465 | ||
| 968 | 968 | 231 DORSET RD | ward-5 | Broken | 53231 | active | 42.330862 | -71.241885 | ||
| 967 | 967 | 150 HARTMAN RD | ward-8 | Broken | 53231 | active | 42.305805 | -71.185045 | ||
| 966 | 966 | 134 WENDELL RD | ward-8 | Broken | 53231 | inactive | 2024-07-15 | 42.309895 | -71.201421 | |
| 965 | 965 | 12 CHASKE AVE | ward-4 | Broken | 53231 | inactive | 2024-09-13 | 42.351023 | -71.249855 | |
| 964 | 964 | 111 PAULSON RD | ward-5 | Broken | 53231 | active | 42.332987 | -71.219657 | ||
| 963 | 963 | 1106 BEACON ST | ward-6 | Broken | 53231 | inactive | 2024-08-05 | 42.330718 | -71.207815 | |
| 962 | 962 | 11 HELENE RD | ward-5 | Broken | 53231 | active | 42.333697 | -71.219707 |
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]);