_locations
168 rows where category_id = 51149
This data as json, CSV (advanced)
Suggested facets: ward, active, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 431 | 431 | 29 ARLINGTON ST | 42.351248 | -71.176621 | 51149 | 1 | 2024-06-17 | 0 | |
| 511 | 511 | 102 HERRICK RD | 42.327534 | -71.192165 | 51149 | 6 | 2024-06-15 | 2024-06-17 | 0 |
| 1247 | 1247 | 483 CENTRE STREET | 42.353874 | -71.186525 | 51149 | 1 | 2024-06-23 | 2024-06-25 | 0 |
| 1666 | 1666 | 63 COLUMBUS ST | 42.322057 | -71.208534 | 51149 | 6 | 2024-06-28 09:30 | 2024-07-01 | 0 |
| 1739 | 1739 | 580 WALNUT STREET | 42.34149 | -71.206518 | 51149 | 2 | 2024-06-30 17:00 | 2024-07-01 | 0 |
| 1740 | 1740 | 442 WALNUT STREET | 42.346145 | -71.20626 | 51149 | 2 | 2024-06-30 17:30 | 2024-07-01 | 0 |
| 1751 | 1751 | 729 DEDHAM STREET | 42.300327 | -71.188311 | 51149 | 8 | 2024-07-01 00:45 | 2024-07-01 | 0 |
| 2125 | 2125 | 25 LINCOLN RD | 42.356219 | -71.199133 | 51149 | 1 | 2024-07-08 09:00 | 2024-07-11 | 0 |
| 2551 | 2551 | 25 LINCOLN RD | 42.356219 | -71.199133 | 51149 | 1 | 2024-07-15 10:30 | 2024-07-16 | 0 |
| 2937 | 2937 | 676 GROVE ST | 42.326478 | -71.256901 | 51149 | 4 | 2024-07-22 10:30 | 2024-07-24 | 0 |
| 2948 | 2948 | 212 NEEDHAM STREET | 42.31074 | -71.214087 | 51149 | 5 | 2024-07-22 12:30 | 2024-07-22 | 0 |
| 3219 | 3219 | 887 MAIN STREET | 51149 | 2024-07-28 19:45 | 2024-07-31 | 0 | |||
| 3526 | 3526 | 661 WATERTOWN STREET | 42.35493 | -71.212054 | 51149 | 2 | 2024-08-02 09:00 | 2024-08-05 | 0 |
| 3753 | 3753 | 31 CRESCENT AVENUE | 42.330221 | -71.198278 | 51149 | 6 | 2024-08-06 14:00 | 2024-08-07 | 0 |
| 4119 | 4119 | 75 HIGHLAND ST | 42.346666 | -71.226477 | 51149 | 3 | 2024-08-10 16:15 | 2024-08-20 | 0 |
| 4431 | 4431 | 153 WESTCHESTER RD | 42.345137 | -71.194094 | 51149 | 2 | 2024-08-15 16:30 | 2024-08-20 | 0 |
| 4544 | 4544 | 27 NEEDHAM STREET | 42.316331 | -71.210031 | 51149 | 5 | 2024-08-17 09:15 | 2024-08-19 | 0 |
| 5160 | 5160 | 442 WALNUT ST | 42.346144 | -71.205847 | 51149 | 2 | 2024-08-30 11:30 | 2024-09-04 | 0 |
| 5189 | 5189 | 63 HARVARD STREET | 42.350294 | -71.201446 | 51149 | 2 | 2024-09-01 09:30 | 2024-09-03 | 0 |
| 5286 | 5286 | 423–433 WOLCOTT ST | 42.348947 | -71.245129 | 51149 | 4 | 2024-09-03 19:15 | 2024-09-24 | 0 |
| 5404 | 5404 | 544 WALNUT ST | 42.342118 | -71.206393 | 51149 | 2 | 2024-09-05 15:30 | 2024-09-09 | 0 |
| 5478 | 5478 | 291 LAKE AVENUE | 42.323861 | -71.204686 | 51149 | 6 | 2024-09-07 14:30 | 2024-09-11 | 0 |
| 5564 | 5564 | 97 CYPRESS STREET | 42.32654 | -71.193708 | 51149 | 6 | 2024-09-10 08:00 | 2024-09-11 | 0 |
| 5598 | 5598 | 443–473 HAMMOND ST | 42.328562 | -71.165742 | 51149 | 7 | 2024-09-10 10:45 | 2024-09-11 | 0 |
| 5608 | 5608 | 1545 BEACON STREET | 42.328924 | -71.227758 | 51149 | 5 | 2024-09-10 12:00 | 2024-09-11 | 0 |
| 5609 | 5609 | 7 BEETHOVEN AVENUE | 42.33051 | -71.218789 | 51149 | 5 | 2024-09-10 12:00 | 2024-09-11 | 0 |
| 5643 | 5643 | 360 HAMMOND ST | 42.330148 | -71.16776 | 51149 | 7 | 2024-09-10 18:45 | 2024-09-11 | 0 |
| 5665 | 5665 | 170 BOYLSTON STREET | 42.319909 | -71.174546 | 51149 | 7 | 2024-09-11 10:00 | 2024-09-11 | 0 |
| 5740 | 5740 | 221 WASHINGTON STREET | 42.356698 | -71.18359 | 51149 | 1 | 2024-09-12 12:45 | 2024-09-12 | 0 |
| 5840 | 5840 | 194 WINCHESTER STREET | 42.31355 | -71.209055 | 51149 | 8 | 2024-09-15 12:15 | 2024-09-16 | 0 |
| 5945 | 5945 | 6 HYDE AVE | 42.349728 | -71.186453 | 51149 | 7 | 2024-09-16 20:45 | 2024-10-01 | 0 |
| 6372 | 6372 | 11 HULL STREET | 42.34402 | -71.205981 | 51149 | 2 | 2024-09-25 12:45 | 2024-09-29 | 0 |
| 6708 | 6708 | 40 BEACONWOOD RD | 42.329654 | -71.209759 | 51149 | 6 | 2024-10-03 19:15 | 2024-10-08 | 0 |
| 6877 | 6877 | 122 AUBURN ST | 42.344528 | -71.240223 | 51149 | 4 | 2024-10-08 21:30 | 2024-10-09 | 0 |
| 8150 | 8150 | 188 EAST SIDE PKWY | 42.348037 | -71.197238 | 51149 | 2 | 2024-10-23 15:30 | 2024-10-28 | 0 |
| 9791 | 9791 | 249 HOMER ST | 42.335621 | -71.204088 | 51149 | 2 | 2024-11-07 10:15 | 1 | |
| 9799 | 9799 | 87 HOBART ROAD | 42.335979 | -71.18241 | 51149 | 7 | 2024-11-07 10:30 | 2024-11-21 | 0 |
| 9811 | 9811 | 27 WINCHESTER STREET | 42.318885 | -71.207644 | 51149 | 5 | 2024-11-07 11:00 | 2024-11-07 | 0 |
| 9860 | 9860 | 179 KIRKSTALL RD | 42.344097 | -71.199356 | 51149 | 2 | 2024-11-07 14:00 | 2024-11-08 | 0 |
| 9887 | 9887 | 171 PINE ST | 42.352196 | -71.242018 | 51149 | 4 | 2024-11-07 15:15 | 2024-11-08 | 0 |
| 10183 | 10183 | 3 EMERALD STREET | 42.356802 | -71.200638 | 51149 | 1 | 2024-11-15 10:30 | 2024-11-19 | 0 |
| 10284 | 10284 | 138 HANCOCK STREET | 42.341978 | -71.251246 | 51149 | 4 | 2024-11-18 15:00 | 2024-11-25 | 0 |
| 10286 | 10286 | 107 HANCOCK STREET | 42.342684 | -71.251107 | 51149 | 4 | 2024-11-18 15:15 | 2024-12-04 | 0 |
| 10289 | 10289 | 99 HANCOCK STREET | 42.3431 | -71.25078 | 51149 | 4 | 2024-11-18 15:45 | 2024-11-25 | 0 |
| 10405 | 10405 | 47 R SARGENT STREET | 42.347128 | -71.183472 | 51149 | 7 | 2024-11-20 18:15 | 2024-11-22 | 0 |
| 10474 | 10474 | 1479 WASHINGTON STREET | 42.347128 | -71.231967 | 51149 | 3 | 2024-11-22 10:00 | 2024-11-26 | 0 |
| 10517 | 10517 | 89 CHESTNUT ST | 42.347082 | -71.224676 | 51149 | 3 | 2024-11-22 15:15 | 2024-12-09 | 0 |
| 10643 | 10643 | 173 LANGLEY RD | 42.326991 | -71.188675 | 51149 | 6 | 2024-11-25 14:00 | 2024-12-04 | 0 |
| 10710 | 10710 | 283 BROOKLINE ST | 42.300942 | -71.178217 | 51149 | 8 | 2024-11-26 10:15 | 2024-11-26 | 0 |
| 10802 | 10802 | 254 CHURCH STREET | 42.354621 | -71.189598 | 51149 | 1 | 2024-11-30 01:15 | 2024-12-02 | 0 |
| 11309 | 11309 | 53–99 PRAIRIE AVE | 42.350515 | -71.239863 | 51149 | 4 | 2024-12-09 16:45 | 2024-12-10 | 0 |
| 11496 | 11496 | 525 HAMMOND STREET | 42.325969 | -71.165292 | 51149 | 7 | 2024-12-11 13:45 | 2024-12-11 | 0 |
| 11808 | 11808 | 394 DUDLEY ROAD | 42.30823 | -71.181026 | 51149 | 8 | 2024-12-17 12:45 | 2024-12-19 | 0 |
| 11956 | 11956 | 105 HANCOCK ST | 42.342944 | -71.251216 | 51149 | 4 | 2024-12-20 16:00 | 2024-12-23 | 0 |
| 12371 | 12371 | 9 CEDAR ST | 42.340614 | -71.199094 | 51149 | 2 | 2024-12-30 15:00 | 2025-01-02 | 0 |
| 12559 | 12559 | 550 BEACON ST | 42.33181 | -71.182238 | 51149 | 7 | 2025-01-02 16:15 | 2025-01-03 | 0 |
| 12949 | 12949 | 110 HULL ST | 42.343994 | -71.210998 | 51149 | 2 | 2025-01-09 15:30 | 2025-01-13 | 0 |
| 13272 | 13272 | 87 LINCOLN ST | 42.321444 | -71.209702 | 51149 | 6 | 2025-01-17 08:15 | 2025-01-21 | 0 |
| 13420 | 13420 | 131 BISHOPSGATE ROAD | 42.332029 | -71.184845 | 51149 | 7 | 2025-01-21 11:15 | 2025-01-21 | 0 |
| 13476 | 13476 | 99 WABAN STREET | 42.358229 | -71.193429 | 51149 | 1 | 2025-01-22 08:30 | 2025-01-31 | 0 |
| 13678 | 13678 | 6 MASSACHUSETTS 128 | 42.330649 | -71.254637 | 51149 | 4 | 2025-01-25 01:45 | 2025-01-27 | 0 |
| 13829 | 13829 | 8 SHORNECLIFFE RD | 42.350031 | -71.175699 | 51149 | 7 | 2025-01-28 15:15 | 2025-01-31 | 0 |
| 13964 | 13964 | 37 OAKWOOD RD | 42.343204 | -71.202744 | 51149 | 2 | 2025-01-31 09:30 | 2025-01-31 | 0 |
| 14208 | 14208 | 4 HUNNEWELL CIR | 42.355845 | -71.179232 | 51149 | 1 | 2025-02-05 11:15 | 2025-02-08 | 0 |
| 14310 | 14310 | 151 TREMONT ST | 42.352101 | -71.174525 | 51149 | 1 | 2025-02-07 15:30 | 2025-02-12 | 0 |
| 14374 | 14374 | 111 LINCOLN ST | 42.321258 | -71.210912 | 51149 | 6 | 2025-02-09 17:00 | 2025-02-12 | 0 |
| 14445 | 14445 | 59 WOODLAND RD | 42.343677 | -71.250557 | 51149 | 4 | 2025-02-10 15:30 | 2025-02-11 | 0 |
| 14492 | 14492 | 110 HULL ST | 42.343992 | -71.210997 | 51149 | 2 | 2025-02-11 09:45 | 2025-02-12 | 0 |
| 14691 | 14691 | 197 TREMONT ST | 42.352956 | -71.176302 | 51149 | 1 | 2025-02-14 15:15 | 2025-02-25 | 0 |
| 14887 | 14887 | 125 MCCARTHY RD | 42.296121 | -71.186391 | 51149 | 8 | 2025-02-18 09:15 | 2025-02-18 | 0 |
| 14952 | 14952 | 1005 CHESTNUT ST | 42.314715 | -71.225375 | 51149 | 5 | 2025-02-18 11:30 | 2025-02-20 | 0 |
| 15012 | 15012 | 823 WASHINGTON ST | 42.351876 | -71.206866 | 51149 | 2 | 2025-02-18 15:15 | 2025-02-19 | 0 |
| 15077 | 15077 | 12 FURBER LN | 42.335316 | -71.194032 | 51149 | 6 | 2025-02-19 10:30 | 2025-02-20 | 0 |
| 15304 | 15304 | 147 BROOKLINE ST | 42.305022 | -71.174907 | 51149 | 8 | 2025-02-24 09:15 | 2025-02-24 | 0 |
| 15553 | 15553 | 4 HUNNEWELL CIR | 42.355845 | -71.179232 | 51149 | 1 | 2025-02-27 11:45 | 2025-03-05 | 0 |
| 15601 | 15601 | 701 WASHINGTON ST | 42.352911 | -71.202434 | 51149 | 2 | 2025-02-28 11:45 | 2025-02-28 | 0 |
| 15688 | 15688 | 79 NEWELL RD | 42.351192 | -71.243793 | 51149 | 4 | 2025-03-03 15:00 | 2025-03-06 | 0 |
| 15864 | 15864 | 27 CHESTER STREET | 42.322921 | -71.20992 | 51149 | 6 | 2025-03-07 08:00 | 2025-03-10 | 0 |
| 15932 | 15932 | 77 FAIR OAKS AVE | 42.360444 | -71.212334 | 51149 | 2 | 2025-03-07 14:00 | 2025-03-19 | 0 |
| 15959 | 15959 | 153 WESTCHESTER RD | 42.345135 | -71.194095 | 51149 | 2 | 2025-03-07 16:30 | 2025-03-11 | 0 |
| 16076 | 16076 | 793 WASHINGTON ST | 42.352029 | -71.206083 | 51149 | 2 | 2025-03-10 08:45 | 2025-03-11 | 0 |
| 16084 | 16084 | 232 BROOKLINE ST | 42.30261 | -71.176955 | 51149 | 8 | 2025-03-10 09:00 | 2025-03-11 | 0 |
| 16178 | 16178 | 6 CAULFIELD CIRCLE | 42.288676 | -71.185669 | 51149 | 8 | 2025-03-11 09:15 | 2025-03-17 | 0 |
| 16227 | 16227 | 100 NEEDHAM ST | 42.313905 | -71.211213 | 51149 | 8 | 2025-03-11 16:15 | 2025-03-24 | 0 |
| 16285 | 16285 | 833 WASHINGTON ST | 42.351795 | -71.207204 | 51149 | 2 | 2025-03-12 16:45 | 2025-03-13 | 0 |
| 16312 | 16312 | 169 FLORENCE STREET | 42.317759 | -71.174932 | 51149 | 8 | 2025-03-13 10:45 | 2025-03-14 | 0 |
| 16339 | 16339 | 20 HOVEY STREET | 42.356585 | -71.190104 | 51149 | 1 | 2025-03-13 22:00 | 1 | |
| 16376 | 16376 | 94 WINCHESTER ST | 42.316785 | -71.208648 | 51149 | 5 | 2025-03-14 15:15 | 2025-03-24 | 0 |
| 16626 | 16626 | 33 ALDEN ST | 42.337242 | -71.193006 | 51149 | 7 | 2025-03-20 20:15 | 2025-03-21 | 0 |
| 16627 | 16627 | 962 CENTRE ST | 42.339321 | -71.192493 | 51149 | 7 | 2025-03-20 20:30 | 2025-03-21 | 0 |
| 16628 | 16628 | 32 WARE RD | 42.349266 | -71.25075 | 51149 | 4 | 2025-03-20 20:30 | 2025-03-21 | 0 |
| 16686 | 16686 | 160 VARICK ROAD | 42.324847 | -71.244889 | 51149 | 5 | 2025-03-23 13:30 | 2025-03-24 | 0 |
| 16688 | 16688 | 986 WALNUT ST | 42.327657 | -71.205944 | 51149 | 6 | 2025-03-23 14:15 | 2025-03-24 | 0 |
| 16719 | 16719 | 29 GREENWOOD ST | 42.310377 | -71.182724 | 51149 | 8 | 2025-03-24 12:30 | 2025-03-24 | 0 |
| 17307 | 17307 | 394 ELLIOT ST | 42.31215 | -71.226239 | 51149 | 5 | 2025-04-04 13:00 | 2025-04-07 | 0 |
| 18294 | 18294 | 126 GLEN AVENUE | 42.327714 | -71.188086 | 51149 | 7 | 2025-04-24 18:00 | 2025-04-25 | 0 |
| 18303 | 18303 | 10 NONANTUM ST | 42.350175 | -71.175164 | 51149 | 1 | 2025-04-25 06:45 | 2025-04-25 | 0 |
| 18443 | 18443 | 624 WASHINGTON ST | 42.353685 | -71.199158 | 51149 | 2 | 2025-04-28 13:00 | 2025-04-30 | 0 |
| 18574 | 18574 | 49 ASH ST | 42.347376 | -71.250836 | 51149 | 4 | 2025-04-30 09:00 | 1 | |
| 18731 | 18731 | 72 WESTMINSTER RD | 42.326325 | -71.185577 | 51149 | 7 | 2025-05-02 16:15 | 2025-05-05 | 0 |
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 );