_locations
129 rows where category_id = 51173
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 |
|---|---|---|---|---|---|---|---|---|---|
| 740 | 740 | 1–31 HAMMOND ST | 42.336467 | -71.178578 | 51173 | 7 | 2024-06-20 | 2024-06-20 | 0 |
| 1613 | 1613 | 630 HAMMOND ST | 42.322727 | -71.163219 | 51173 | 2024-06-27 12:00 | 2024-06-27 | 0 | |
| 1631 | 1631 | 808 BEACON ST | 42.330033 | -71.193888 | 51173 | 6 | 2024-06-27 14:45 | 2024-06-28 | 0 |
| 1747 | 1747 | 86 DERBY STREET | 42.357467 | -71.22746 | 51173 | 3 | 2024-07-01 00:30 | 2024-07-03 | 0 |
| 1762 | 1762 | 9 WADE STREET | 42.31927 | -71.207279 | 51173 | 5 | 2024-07-01 08:45 | 2024-07-01 | 0 |
| 2114 | 2114 | 848 BEACON ST | 42.329867 | -71.195742 | 51173 | 6 | 2024-07-08 07:45 | 2024-07-08 | 0 |
| 2295 | 2295 | 1258–1268 WASHINGTON ST | 42.349347 | -71.225498 | 51173 | 3 | 2024-07-10 07:45 | 2024-07-11 | 0 |
| 2448 | 2448 | 1063 COMMONWEALTH AVENUE | 42.338247 | -71.210423 | 51173 | 2 | 2024-07-12 07:45 | 2024-07-12 | 0 |
| 3303 | 3303 | 196 CALIFORNIA ST | 42.364503 | -71.195996 | 51173 | 1 | 2024-07-29 13:45 | 2024-07-30 | 0 |
| 3771 | 3771 | 300 WASHINGTON ST | 42.356588 | -71.18595 | 51173 | 1 | 2024-08-07 07:00 | 2024-08-07 | 0 |
| 6535 | 6535 | 2088 COMMONWEALTH AVE | 42.347896 | -71.247144 | 51173 | 4 | 2024-09-29 16:15 | 2024-10-02 | 0 |
| 6568 | 6568 | BEACON ST | 42.332852 | -71.172771 | 51173 | 7 | 2024-09-30 13:45 | 2024-09-30 | 0 |
| 6736 | 6736 | 488 CENTRE ST | 42.353941 | -71.186164 | 51173 | 1 | 2024-10-04 12:15 | 2024-10-04 | 0 |
| 6883 | 6883 | 385 CALIFORNIA STREET | 42.364781 | -71.204731 | 51173 | 1 | 2024-10-09 06:15 | 2024-10-09 | 0 |
| 7529 | 7529 | 451 LEXINGTON ST | 42.34683 | -71.247184 | 51173 | 4 | 2024-10-18 11:15 | 2024-10-22 | 0 |
| 7985 | 7985 | 1750 COMMONWEALTH AVE | 42.340656 | -71.23862 | 51173 | 4 | 2024-10-23 07:15 | 2024-10-24 | 0 |
| 9036 | 9036 | 1887 COMMONWEALTH AVE | 42.34453 | -71.240686 | 51173 | 4 | 2024-10-31 09:00 | 2024-10-31 | 0 |
| 9418 | 9418 | 96 BEACON STREET | 42.333887 | -71.162338 | 51173 | 7 | 2024-11-02 08:45 | 2024-11-04 | 0 |
| 9757 | 9757 | 2094 COMMONWEALTH AVENUE | 42.347947 | -71.247174 | 51173 | 4 | 2024-11-06 19:15 | 2024-11-07 | 0 |
| 9853 | 9853 | 27 WINCHESTER STREET | 42.318885 | -71.207644 | 51173 | 5 | 2024-11-07 13:45 | 2024-11-08 | 0 |
| 10235 | 10235 | 2206 WASHINGTON STREET | 42.327312 | -71.253183 | 51173 | 4 | 2024-11-18 08:00 | 2024-11-18 | 0 |
| 10327 | 10327 | 159 WASHINGTON ST | 42.356296 | -71.180445 | 51173 | 1 | 2024-11-19 13:30 | 2024-11-20 | 0 |
| 10455 | 10455 | 1479 WASHINGTON STREET | 42.347128 | -71.231967 | 51173 | 3 | 2024-11-21 17:45 | 2024-11-22 | 0 |
| 10632 | 10632 | 1121 WASHINGTON ST | 42.349718 | -71.219353 | 51173 | 3 | 2024-11-25 11:45 | 2024-11-26 | 0 |
| 10960 | 10960 | 791 WALNUT STREET | 42.33425 | -71.209994 | 51173 | 2 | 2024-12-03 14:15 | 2024-12-03 | 0 |
| 11482 | 11482 | 486 WALNUT STREET | 42.344559 | -71.205659 | 51173 | 2 | 2024-12-11 07:00 | 2024-12-24 | 0 |
| 11744 | 11744 | 107 MOUNT VERNON STREET | 42.349746 | -71.214266 | 51173 | 2 | 2024-12-16 12:45 | 2024-12-17 | 0 |
| 12237 | 12237 | 529 CALIFORNIA STREET | 42.361519 | -71.209506 | 51173 | 1 | 2024-12-25 16:15 | 2024-12-27 | 0 |
| 12561 | 12561 | HAMMOND POND PKWY | 42.332094 | -71.181194 | 51173 | 7 | 2025-01-02 16:30 | 2025-01-03 | 0 |
| 12564 | 12564 | 2240 COMMONWEALTH AVE | 42.346891 | -71.253748 | 51173 | 4 | 2025-01-02 18:30 | 2025-01-16 | 0 |
| 12676 | 12676 | 935 WASHINGTON ST | 42.351251 | -71.211056 | 51173 | 2 | 2025-01-06 09:15 | 2025-01-13 | 0 |
| 13170 | 13170 | 107 CENTRE AVENUE | 42.355771 | -71.186787 | 51173 | 1 | 2025-01-15 09:15 | 2025-01-15 | 0 |
| 13473 | 13473 | 410 LEXINGTON STREET | 42.348234 | -71.247139 | 51173 | 4 | 2025-01-22 08:00 | 2025-01-22 | 0 |
| 13677 | 13677 | 470 COMMONWEALTH AVENUE | 42.336391 | -71.185575 | 51173 | 7 | 2025-01-24 22:15 | 2025-02-04 | 0 |
| 13692 | 13692 | 47 PARK ST | 42.35495 | -71.182149 | 51173 | 1 | 2025-01-26 12:00 | 2025-02-04 | 0 |
| 15573 | 15573 | 320 NEEDHAM ST | 42.307182 | -71.215956 | 51173 | 8 | 2025-02-27 17:00 | 2025-03-03 | 0 |
| 15913 | 15913 | 1269 CENTRE ST | 42.330186 | -71.195036 | 51173 | 6 | 2025-03-07 12:15 | 2025-03-12 | 0 |
| 15989 | 15989 | 470 COMMONWEALTH AVENUE | 42.336534 | -71.185446 | 51173 | 7 | 2025-03-08 08:00 | 2025-03-10 | 0 |
| 16012 | 16012 | 261 WALNUT STREET | 42.351759 | -71.207419 | 51173 | 2 | 2025-03-08 14:00 | 1 | |
| 16161 | 16161 | 283 BROOKLINE STREET | 42.301153 | -71.178505 | 51173 | 8 | 2025-03-10 20:15 | 2025-03-17 | 0 |
| 16206 | 16206 | 58 ASH ST | 42.347079 | -71.251241 | 51173 | 4 | 2025-03-11 13:30 | 2025-03-11 | 0 |
| 16372 | 16372 | 64 ASH ST | 42.347232 | -71.25138 | 51173 | 4 | 2025-03-14 15:00 | 2025-03-17 | 0 |
| 16541 | 16541 | 49 LANGLEY ROAD | 42.330423 | -71.192071 | 51173 | 6 | 2025-03-19 10:15 | 2025-03-26 | 0 |
| 16758 | 16758 | 359 LEXINGTON ST | 42.350058 | -71.247245 | 51173 | 4 | 2025-03-25 10:00 | 2025-03-26 | 0 |
| 16961 | 16961 | 160 WASHINGTON ST | 42.355917 | -71.180811 | 51173 | 1 | 2025-03-27 14:30 | 2025-03-27 | 0 |
| 16981 | 16981 | 688 CHESTNUT STREET | 42.326167 | -71.226227 | 51173 | 5 | 2025-03-27 19:00 | 2025-04-02 | 0 |
| 17083 | 17083 | 535 BEACON ST | 42.332265 | -71.18186 | 51173 | 7 | 2025-03-31 08:45 | 2025-04-01 | 0 |
| 17087 | 17087 | 10 WINCHESTER ST | 42.318873 | -71.207591 | 51173 | 5 | 2025-03-31 09:15 | 2025-04-01 | 0 |
| 17331 | 17331 | 867 BOYLSTON STREET | 42.319496 | -71.206732 | 51173 | 6 | 2025-04-04 18:30 | 2025-04-07 | 0 |
| 17572 | 17572 | 2122 COMMONWEALTH AVE | 42.34779 | -71.248545 | 51173 | 4 | 2025-04-09 09:00 | 2025-04-15 | 0 |
| 17740 | 17740 | 50 CHAPIN RD | 42.334353 | -71.19927 | 51173 | 6 | 2025-04-13 13:00 | 2025-04-23 | 0 |
| 18202 | 18202 | 1087 COMMONWEALTH AVE | 42.338457 | -71.211357 | 51173 | 2 | 2025-04-23 13:30 | 2025-04-24 | 0 |
| 18414 | 18414 | 924 WASHINGTON ST | 42.350877 | -71.211006 | 51173 | 2 | 2025-04-28 10:00 | 2025-04-29 | 0 |
| 18651 | 18651 | 427 CENTRE ST | 42.355521 | -71.186508 | 51173 | 1 | 2025-05-01 11:15 | 2025-07-15 | 0 |
| 18945 | 18945 | 924 WASHINGTON ST | 42.350877 | -71.211006 | 51173 | 2 | 2025-05-07 08:15 | 2025-05-12 | 0 |
| 19116 | 19116 | 1670 CENTRE ST | 42.319611 | -71.206137 | 51173 | 6 | 2025-05-09 10:30 | 2025-05-13 | 0 |
| 19322 | 19322 | 833 WASHINGTON STREET | 42.351791 | -71.207247 | 51173 | 2 | 2025-05-13 15:15 | 1 | |
| 19387 | 19387 | 91 ALLERTON RD | 42.324435 | -71.199657 | 51173 | 6 | 2025-05-14 13:15 | 1 | |
| 19937 | 19937 | 1670 CENTRE ST | 42.319611 | -71.206137 | 51173 | 6 | 2025-05-23 13:15 | 2025-07-22 | 0 |
| 19945 | 19945 | 554 WASHINGTON STREET | 42.354928 | -71.195556 | 51173 | 1 | 2025-05-23 14:00 | 1 | |
| 20719 | 20719 | 924 WASHINGTON ST | 42.350877 | -71.211006 | 51173 | 2 | 2025-06-04 20:45 | 2025-07-22 | 0 |
| 20744 | 20744 | 25 PARK STREET | 42.354939 | -71.182053 | 51173 | 1 | 2025-06-05 09:45 | 2025-07-30 | 0 |
| 21354 | 21354 | 475 WASHINGTON STREET | 42.355275 | -71.192766 | 51173 | 1 | 2025-06-16 07:15 | 1 | |
| 22219 | 22219 | 989 WATERTOWN ST | 42.34977 | -71.225739 | 51173 | 3 | 2025-06-26 16:00 | 2025-06-30 | 0 |
| 22867 | 22867 | 911 WASHINGTON ST | 42.351354 | -71.210196 | 51173 | 2 | 2025-07-08 16:00 | 2025-07-22 | 0 |
| 22913 | 22913 | 624 COMMONWEALTH AVE | 42.335991 | -71.192822 | 51173 | 6 | 2025-07-09 09:15 | 1 | |
| 23184 | 23184 | 833 WASHINGTON ST | 42.351795 | -71.207204 | 51173 | 2 | 2025-07-14 09:45 | 2025-07-22 | 0 |
| 23874 | 23874 | 535 BEACON ST | 42.332265 | -71.18186 | 51173 | 7 | 2025-07-22 10:00 | 2025-07-29 | 0 |
| 24353 | 24353 | 1667 CENTRE STREET | 42.319607 | -71.206507 | 51173 | 6 | 2025-07-30 09:00 | 1 | |
| 24354 | 24354 | 371 WASHINGTON ST | 42.356664 | -71.188551 | 51173 | 1 | 2025-07-30 09:15 | 2025-08-06 | 0 |
| 24430 | 24430 | 220 HOBART RD | 42.33276 | -71.181333 | 51173 | 7 | 2025-07-31 08:45 | 1 | |
| 24543 | 24543 | 345 NEWTONVILLE AVENUE | 42.351315 | -71.201411 | 51173 | 2 | 2025-08-02 13:30 | 2025-08-18 | 0 |
| 24627 | 24627 | 431 WASHINGTON ST | 42.356043 | -71.190423 | 51173 | 1 | 2025-08-04 16:15 | 1 | |
| 24753 | 24753 | 358 NEWTONVILLE AVENUE | 42.351125 | -71.201668 | 51173 | 2 | 2025-08-06 08:30 | 2025-08-15 | 0 |
| 24858 | 24858 | 245 WARD ST | 42.339753 | -71.182652 | 51173 | 7 | 2025-08-07 11:00 | 2025-08-15 | 0 |
| 24861 | 24861 | 308 HOMER ST | 42.335847 | -71.206758 | 51173 | 6 | 2025-08-07 11:15 | 2025-08-15 | 0 |
| 25499 | 25499 | 924 WASHINGTON ST | 42.350877 | -71.211006 | 51173 | 2 | 2025-08-20 15:15 | 2025-09-23 | 0 |
| 25510 | 25510 | 500 BEACON STREET | 42.331466 | -71.180693 | 51173 | 7 | 2025-08-20 21:00 | 1 | |
| 25531 | 25531 | 1640 CENTRE ST | 42.320286 | -71.205116 | 51173 | 6 | 2025-08-21 11:00 | 2025-08-21 | 0 |
| 25991 | 25991 | 732 WALNUT ST | 42.336423 | -71.20679 | 51173 | 2 | 2025-09-02 10:15 | 2025-09-02 | 0 |
| 25993 | 25993 | 426 HOMER ST | 42.337602 | -71.211681 | 51173 | 2 | 2025-09-02 10:30 | 2025-09-02 | 0 |
| 25994 | 25994 | 680 WALNUT ST | 42.338106 | -71.20661 | 51173 | 2 | 2025-09-02 10:30 | 2025-09-02 | 0 |
| 26159 | 26159 | 2 LOWELL AVE | 42.356493 | -71.206821 | 51173 | 2 | 2025-09-04 15:15 | 2025-09-29 | 0 |
| 26374 | 26374 | 244 NEEDHAM ST | 42.309468 | -71.214386 | 51173 | 8 | 2025-09-09 09:30 | 2025-09-12 | 0 |
| 26441 | 26441 | 389 WOODWARD STREET | 42.326252 | -71.226437 | 51173 | 5 | 2025-09-10 09:45 | 1 | |
| 26683 | 26683 | 696 CHESTNUT STREET | 42.32606 | -71.226414 | 51173 | 5 | 2025-09-15 05:15 | 1 | |
| 26777 | 26777 | 181 LEXINGTON ST | 42.355071 | -71.243204 | 51173 | 4 | 2025-09-16 08:00 | 2025-09-18 | 0 |
| 26923 | 26923 | 181 LEXINGTON ST | 42.355071 | -71.243204 | 51173 | 4 | 2025-09-18 10:45 | 1 | |
| 27378 | 27378 | 99 CRAFTS ST | 42.355917 | -71.202848 | 51173 | 1 | 2025-09-26 17:00 | 2025-09-29 | 0 |
| 27440 | 27440 | 14 NEEDHAM ST | 42.316101 | -71.209413 | 51173 | 8 | 2025-09-29 10:00 | 1 | |
| 27576 | 27576 | 54 HAMPSHIRE ST | 42.341004 | -71.223174 | 51173 | 3 | 2025-09-30 21:45 | 2025-10-02 | 0 |
| 27913 | 27913 | 144 ELLIOT STREET | 42.314578 | -71.215487 | 51173 | 5 | 2025-10-07 16:45 | 1 | |
| 28160 | 28160 | 88 WOODCLIFF ROAD | 42.319084 | -71.20199 | 51173 | 6 | 2025-10-14 10:45 | 2025-10-14 | 0 |
| 28311 | 28311 | 40 HARVARD ST | 42.351075 | -71.201408 | 51173 | 2 | 2025-10-16 09:45 | 1 | |
| 28351 | 28351 | 924 WASHINGTON ST | 42.350877 | -71.211006 | 51173 | 2 | 2025-10-16 13:15 | 2025-10-16 | 0 |
| 28498 | 28498 | 296 WASHINGTON ST | 42.35661 | -71.185851 | 51173 | 1 | 2025-10-20 15:45 | 2025-10-20 | 0 |
| 28524 | 28524 | 206 OAK ST | 42.307686 | -71.216429 | 51173 | 5 | 2025-10-21 09:30 | 1 | |
| 28572 | 28572 | 935 WASHINGTON ST | 42.351255 | -71.211033 | 51173 | 2 | 2025-10-22 01:45 | 1 | |
| 28666 | 28666 | 704 BEACON ST | 42.330681 | -71.189366 | 51173 | 6 | 2025-10-22 19:15 | 1 | |
| 28770 | 28770 | 12 DEDHAM STREET | 42.316418 | -71.208342 | 51173 | 8 | 2025-10-25 16:00 | 2025-11-14 | 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 );