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