_locations
65 rows where category_id = 50969
This data as json, CSV (advanced)
Suggested facets: ward, active, removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 146 | 146 | 193 OAK STREET | 42.307596 | -71.216689 | 50969 | 5 | 2024-08-16 | 0 | |
| 450 | 450 | 5 COCHITUATE ROAD | 42.323209 | -71.215015 | 50969 | 5 | 2024-06-14 | 1 | |
| 627 | 627 | 111 ATHELSTANE RD | 42.321615 | -71.199309 | 50969 | 6 | 2024-06-18 | 2024-06-20 | 0 |
| 985 | 985 | 25 KIMBALL TERRACE | 42.3467 | -71.20903 | 50969 | 2 | 2024-06-24 | 2024-07-23 | 0 |
| 1170 | 1170 | 117 WARREN ST | 42.329467 | -71.187235 | 50969 | 6 | 2024-06-27 | 2024-07-11 | 0 |
| 1564 | 1564 | 8 HARTFORD ST | 42.321449 | -71.207471 | 50969 | 6 | 2024-07-07 | 2024-07-08 | 0 |
| 1621 | 1621 | 2203 COMMONWEALTH AVE | 42.350556 | -71.252678 | 50969 | 4 | 2024-07-08 | 2024-07-08 | 0 |
| 2599 | 2599 | 99 ANDREW ST | 42.313225 | -71.203998 | 50969 | 8 | 2024-08-01 | 2024-08-07 | 0 |
| 2603 | 2603 | 36 TIRRELL CRES | 42.302148 | -71.173115 | 50969 | 8 | 2024-08-01 | 1 | |
| 2985 | 2985 | 256 ALBEMARLE ROAD | 42.357467 | -71.215745 | 50969 | 2 | 2024-08-09 | 2024-08-19 | 0 |
| 3379 | 3379 | 244 DORSET RD | 42.330392 | -71.241883 | 50969 | 5 | 2024-08-19 | 2024-08-22 | 0 |
| 3384 | 3384 | 49 JANET ROAD | 42.340194 | -71.195401 | 50969 | 2 | 2024-08-19 | 2024-08-20 | 0 |
| 3387 | 3387 | 30 MELVILLE AVE | 42.361797 | -71.206971 | 50969 | 1 | 2024-08-19 | 2024-08-27 | 0 |
| 3657 | 3657 | 14 BACON RD | 42.356172 | -71.210088 | 50969 | 2 | 2024-08-27 | 2024-09-10 | 0 |
| 3754 | 3754 | 110 ADELINE RD | 42.315198 | -71.190171 | 50969 | 8 | 2024-08-29 | 2024-09-05 | 0 |
| 4232 | 4232 | 12 CHANNING STREET | 42.357864 | -71.187871 | 50969 | 1 | 2024-09-12 | 2024-09-16 | 0 |
| 4475 | 4475 | 283 WOODLAND ROAD | 42.34034 | -71.241236 | 50969 | 4 | 2024-09-23 | 2024-09-25 | 0 |
| 5596 | 5596 | 297 DERBY ST | 42.360681 | -71.235853 | 50969 | 3 | 2024-10-22 | 2024-12-06 | 0 |
| 8651 | 8651 | 85 DUDLEY ROAD | 42.317116 | -71.186326 | 50969 | 8 | 2024-12-29 | 2025-01-14 | 0 |
| 8654 | 8654 | 9 CEDAR STREET | 42.340633 | -71.19875 | 50969 | 2 | 2024-12-29 | 2025-01-02 | 0 |
| 8669 | 8669 | 56 LINDBERGH AVE | 42.353477 | -71.226502 | 50969 | 3 | 2024-12-30 | 2025-03-26 | 0 |
| 8737 | 8737 | 224 ADAMS AVE | 42.357326 | -71.229723 | 50969 | 3 | 2024-12-31 | 2024-12-31 | 0 |
| 9712 | 9712 | 103 COLLINS RD | 42.323007 | -71.231247 | 50969 | 5 | 2025-01-26 | 2025-02-06 | 0 |
| 9822 | 9822 | 1000 COMMONWEALTH AVENUE | 42.337136 | -71.208234 | 50969 | 2 | 2025-01-29 | 2025-03-31 | 0 |
| 9831 | 9831 | 11 NONANTUM ST | 42.350499 | -71.175254 | 50969 | 1 | 2025-01-29 | 2025-01-29 | 0 |
| 10191 | 10191 | 54 PARK ST | 42.355014 | -71.182142 | 50969 | 1 | 2025-02-08 | 2025-02-11 | 0 |
| 10193 | 10193 | 24 RUANE ROAD | 42.340282 | -71.229759 | 50969 | 3 | 2025-02-08 | 2025-02-14 | 0 |
| 10194 | 10194 | 7 PLAYSTEAD ROAD | 42.352282 | -71.174514 | 50969 | 1 | 2025-02-08 | 2025-02-09 | 0 |
| 10198 | 10198 | 24 RUANE RD | 42.340175 | -71.229728 | 50969 | 3 | 2025-02-08 | 2025-02-09 | 0 |
| 10255 | 10255 | 38 BEECHER PL | 42.322536 | -71.183021 | 50969 | 6 | 2025-02-10 | 2025-02-11 | 0 |
| 10382 | 10382 | 82 WAYNE RD | 42.300711 | -71.173652 | 50969 | 8 | 2025-02-12 | 2025-09-04 | 0 |
| 10408 | 10408 | 8 CAVANAUGH PATH | 42.292917 | -71.182418 | 50969 | 8 | 2025-02-13 | 2025-03-03 | 0 |
| 10628 | 10628 | 51 LAKEWOOD RD | 42.326496 | -71.205638 | 50969 | 6 | 2025-02-18 | 2025-02-24 | 0 |
| 11259 | 11259 | 118 RIVER ST | 42.352605 | -71.231652 | 50969 | 3 | 2025-02-28 | 2025-03-03 | 0 |
| 11408 | 11408 | 749 CHESTNUT ST | 42.324201 | -71.226873 | 50969 | 5 | 2025-03-06 | 2025-03-14 | 0 |
| 11524 | 11524 | 8 BUNNY CIR | 42.350886 | -71.192538 | 50969 | 1 | 2025-03-08 | 2025-03-10 | 0 |
| 11803 | 11803 | 79 PEARL ST | 42.358545 | -71.188839 | 50969 | 1 | 2025-03-15 | 2025-03-17 | 0 |
| 11906 | 11906 | 8 HALE ST | 42.312753 | -71.223273 | 50969 | 5 | 2025-03-19 | 2025-03-20 | 0 |
| 12108 | 12108 | 100 BERKSHIRE RD | 42.340302 | -71.204301 | 50969 | 2 | 2025-03-26 | 2025-03-31 | 0 |
| 12194 | 12194 | 76 SHERIDAN ST | 42.356826 | -71.233839 | 50969 | 3 | 2025-03-27 | 2025-03-28 | 0 |
| 12255 | 12255 | 181 RIVER STREET | 42.354042 | -71.233554 | 50969 | 3 | 2025-03-28 | 2025-03-31 | 0 |
| 12280 | 12280 | 1 FOX PL | 42.307947 | -71.194176 | 50969 | 8 | 2025-03-28 | 1 | |
| 12765 | 12765 | 11 PARK LN | 42.333273 | -71.201975 | 50969 | 6 | 2025-04-13 | 2025-04-16 | 0 |
| 12897 | 12897 | 15 HOBART ROAD | 42.338559 | -71.181855 | 50969 | 7 | 2025-04-16 | 2025-04-16 | 0 |
| 12973 | 12973 | 55 HALE ST | 42.310954 | -71.223296 | 50969 | 5 | 2025-04-18 | 2025-05-27 | 0 |
| 13046 | 13046 | 11 HULL STREET | 42.34383 | -71.206196 | 50969 | 2 | 2025-04-22 | 2025-04-25 | 0 |
| 13162 | 13162 | 56 FISHER AVE | 42.326406 | -71.207235 | 50969 | 6 | 2025-04-24 | 2025-04-29 | 0 |
| 13416 | 13416 | 11 RUSTIC ST | 42.366537 | -71.19882 | 50969 | 1 | 2025-04-30 | 2025-05-06 | 0 |
| 13878 | 13878 | 1525 COMMONWEALTH AVE | 42.33951 | -71.228817 | 50969 | 3 | 2025-05-12 | 2025-05-15 | 0 |
| 15331 | 15331 | 8 PONTIAC RD | 42.323679 | -71.245296 | 50969 | 5 | 2025-06-10 | 2025-06-11 | 0 |
| 15529 | 15529 | 1645 BEACON ST | 42.326559 | -71.230986 | 50969 | 5 | 2025-06-15 | 2025-09-23 | 0 |
| 15915 | 15915 | 44 PAGE RD | 42.353631 | -71.210223 | 50969 | 2 | 2025-06-22 | 2025-07-15 | 0 |
| 16242 | 16242 | 1362 WASHINGTON ST | 42.34842 | -71.22852 | 50969 | 3 | 2025-06-26 | 1 | |
| 16243 | 16243 | 268 PARKER ST | 42.318153 | -71.194293 | 50969 | 8 | 2025-06-26 | 2025-07-03 | 0 |
| 16320 | 16320 | 761 WASHINGTON ST | 42.352335 | -71.204337 | 50969 | 2 | 2025-06-29 | 2025-07-01 | 0 |
| 16491 | 16491 | 11 ELIOT AVE | 42.352983 | -71.218049 | 50969 | 3 | 2025-07-02 | 2025-07-16 | 0 |
| 18104 | 18104 | 966 WATERTOWN ST | 42.349896 | -71.224745 | 50969 | 3 | 2025-08-05 | 2025-08-11 | 0 |
| 18415 | 18415 | 206 CABOT STREET | 42.348386 | -71.197935 | 50969 | 2 | 2025-08-13 | 2025-08-19 | 0 |
| 19002 | 19002 | 255 WASHINGTON ST | 42.357771 | -71.183844 | 50969 | 1 | 2025-09-02 | 1 | |
| 19050 | 19050 | 647 COMMONWEALTH AVE | 42.336495 | -71.193951 | 50969 | 2 | 2025-09-02 | 2025-09-03 | 0 |
| 19172 | 19172 | 101 VERNON ST | 42.355125 | -71.183705 | 50969 | 1 | 2025-09-05 | 1 | |
| 19173 | 19173 | 12 BALDWIN ST | 42.355602 | -71.183885 | 50969 | 1 | 2025-09-05 | 1 | |
| 22003 | 22003 | 295 AUBURN ST | 42.346728 | -71.247254 | 50969 | 4 | 2025-11-18 | 1 | |
| 22336 | 22336 | 101 NEVADA ST | 42.363054 | -71.213279 | 50969 | 2 | 2025-11-26 | 2025-12-17 | 0 |
| 23214 | 23214 | 10 WASHINGTON PARK | 42.34914 | -71.201691 | 50969 | 2 | 2025-12-20 | 2025-12-22 | 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 );