_locations
65 rows where category_id = 50969
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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 626 | 626 | 111 ATHELSTANE RD | 42.321615 | -71.199309 | 50969 | 6 | 2024-06-17 | 2024-06-20 | 0 |
| 1310 | 1310 | 25 KIMBALL TERRACE | 42.3467 | -71.20903 | 50969 | 2 | 2024-06-24 | 2024-07-23 | 0 |
| 1559 | 1559 | 117 WARREN ST | 42.329467 | -71.187235 | 50969 | 6 | 2024-06-27 | 2024-07-11 | 0 |
| 2072 | 2072 | 8 HARTFORD ST | 42.321449 | -71.207471 | 50969 | 6 | 2024-07-07 11:30 | 2024-07-08 | 0 |
| 2144 | 2144 | 2203 COMMONWEALTH AVE | 42.350556 | -71.252678 | 50969 | 4 | 2024-07-08 11:00 | 2024-07-08 | 0 |
| 3484 | 3484 | 99 ANDREW ST | 42.313225 | -71.203998 | 50969 | 8 | 2024-08-01 11:15 | 2024-08-07 | 0 |
| 3487 | 3487 | 36 TIRRELL CRES | 42.302148 | -71.173115 | 50969 | 8 | 2024-08-01 11:30 | 1 | |
| 4062 | 4062 | 256 ALBEMARLE ROAD | 42.357467 | -71.215745 | 50969 | 2 | 2024-08-09 16:45 | 2024-08-19 | 0 |
| 4587 | 4587 | 244 DORSET RD | 42.330392 | -71.241883 | 50969 | 5 | 2024-08-19 11:00 | 2024-08-22 | 0 |
| 4597 | 4597 | 49 JANET ROAD | 42.340194 | -71.195401 | 50969 | 2 | 2024-08-19 12:15 | 2024-08-20 | 0 |
| 4602 | 4602 | 30 MELVILLE AVE | 42.361797 | -71.206971 | 50969 | 1 | 2024-08-19 12:45 | 2024-08-27 | 0 |
| 4967 | 4967 | 14 BACON RD | 42.356172 | -71.210088 | 50969 | 2 | 2024-08-27 09:00 | 2024-09-10 | 0 |
| 5120 | 5120 | 110 ADELINE RD | 42.315198 | -71.190171 | 50969 | 8 | 2024-08-29 13:30 | 2024-09-05 | 0 |
| 5759 | 5759 | 12 CHANNING STREET | 42.357864 | -71.187871 | 50969 | 1 | 2024-09-12 17:00 | 2024-09-16 | 0 |
| 6070 | 6070 | 283 WOODLAND ROAD | 42.34034 | -71.241236 | 50969 | 4 | 2024-09-23 17:45 | 2024-09-25 | 0 |
| 7842 | 7842 | 297 DERBY ST | 42.360681 | -71.235853 | 50969 | 3 | 2024-10-21 21:00 | 2024-12-06 | 0 |
| 12335 | 12335 | 85 DUDLEY ROAD | 42.317116 | -71.186326 | 50969 | 8 | 2024-12-28 19:45 | 2025-01-14 | 0 |
| 12338 | 12338 | 9 CEDAR STREET | 42.340633 | -71.19875 | 50969 | 2 | 2024-12-29 13:00 | 2025-01-02 | 0 |
| 12358 | 12358 | 56 LINDBERGH AVE | 42.353477 | -71.226502 | 50969 | 3 | 2024-12-30 11:15 | 2025-03-26 | 0 |
| 12452 | 12452 | 224 ADAMS AVE | 42.357326 | -71.229723 | 50969 | 3 | 2024-12-31 12:00 | 2024-12-31 | 0 |
| 13696 | 13696 | 103 COLLINS RD | 42.323007 | -71.231247 | 50969 | 5 | 2025-01-26 16:00 | 2025-02-06 | 0 |
| 13852 | 13852 | 1000 COMMONWEALTH AVENUE | 42.337136 | -71.208234 | 50969 | 2 | 2025-01-28 19:00 | 2025-03-31 | 0 |
| 13860 | 13860 | 11 NONANTUM ST | 42.350499 | -71.175254 | 50969 | 1 | 2025-01-29 07:30 | 2025-01-29 | 0 |
| 14322 | 14322 | 54 PARK ST | 42.355014 | -71.182142 | 50969 | 1 | 2025-02-08 07:45 | 2025-02-11 | 0 |
| 14325 | 14325 | 24 RUANE ROAD | 42.340282 | -71.229759 | 50969 | 3 | 2025-02-08 11:45 | 2025-02-14 | 0 |
| 14326 | 14326 | 7 PLAYSTEAD ROAD | 42.352282 | -71.174514 | 50969 | 1 | 2025-02-08 13:00 | 2025-02-09 | 0 |
| 14329 | 14329 | 24 RUANE RD | 42.340175 | -71.229728 | 50969 | 3 | 2025-02-08 15:00 | 2025-02-09 | 0 |
| 14401 | 14401 | 38 BEECHER PL | 42.322536 | -71.183021 | 50969 | 6 | 2025-02-10 10:00 | 2025-02-11 | 0 |
| 14547 | 14547 | 82 WAYNE RD | 42.300711 | -71.173652 | 50969 | 8 | 2025-02-12 04:00 | 2025-09-04 | 0 |
| 14582 | 14582 | 8 CAVANAUGH PATH | 42.292917 | -71.182418 | 50969 | 8 | 2025-02-13 09:45 | 2025-03-03 | 0 |
| 14833 | 14833 | 51 LAKEWOOD RD | 42.326496 | -71.205638 | 50969 | 6 | 2025-02-17 20:00 | 2025-02-24 | 0 |
| 15620 | 15620 | 118 RIVER ST | 42.352605 | -71.231652 | 50969 | 3 | 2025-02-28 17:00 | 2025-03-03 | 0 |
| 15846 | 15846 | 749 CHESTNUT ST | 42.324201 | -71.226873 | 50969 | 5 | 2025-03-06 17:15 | 2025-03-14 | 0 |
| 16001 | 16001 | 8 BUNNY CIR | 42.350886 | -71.192538 | 50969 | 1 | 2025-03-08 11:00 | 2025-03-10 | 0 |
| 16391 | 16391 | 79 PEARL ST | 42.358545 | -71.188839 | 50969 | 1 | 2025-03-15 17:45 | 2025-03-17 | 0 |
| 16545 | 16545 | 8 HALE ST | 42.312753 | -71.223273 | 50969 | 5 | 2025-03-19 11:15 | 2025-03-20 | 0 |
| 16829 | 16829 | 100 BERKSHIRE RD | 42.340302 | -71.204301 | 50969 | 2 | 2025-03-26 07:00 | 2025-03-29 | 0 |
| 16929 | 16929 | 76 SHERIDAN ST | 42.356826 | -71.233839 | 50969 | 3 | 2025-03-27 09:15 | 2025-03-28 | 0 |
| 17011 | 17011 | 181 RIVER STREET | 42.354042 | -71.233554 | 50969 | 3 | 2025-03-28 12:00 | 2025-03-31 | 0 |
| 17041 | 17041 | 1 FOX PL | 42.307947 | -71.194176 | 50969 | 8 | 2025-03-28 16:30 | 1 | |
| 17741 | 17741 | 11 PARK LN | 42.333273 | -71.201975 | 50969 | 6 | 2025-04-13 13:15 | 2025-04-16 | 0 |
| 17922 | 17922 | 15 HOBART ROAD | 42.338559 | -71.181855 | 50969 | 7 | 2025-04-16 12:45 | 2025-04-16 | 0 |
| 18026 | 18026 | 55 HALE ST | 42.310954 | -71.223296 | 50969 | 5 | 2025-04-18 15:15 | 2025-05-27 | 0 |
| 18136 | 18136 | 11 HULL STREET | 42.34383 | -71.206196 | 50969 | 2 | 2025-04-22 15:15 | 2025-04-25 | 0 |
| 18281 | 18281 | 56 FISHER AVE | 42.326406 | -71.207235 | 50969 | 6 | 2025-04-24 15:45 | 2025-04-29 | 0 |
| 18615 | 18615 | 11 RUSTIC ST | 42.366537 | -71.19882 | 50969 | 1 | 2025-04-30 19:30 | 2025-05-06 | 0 |
| 19227 | 19227 | 1525 COMMONWEALTH AVE | 42.33951 | -71.228817 | 50969 | 3 | 2025-05-12 13:30 | 2025-05-15 | 0 |
| 21071 | 21071 | 8 PONTIAC RD | 42.323679 | -71.245296 | 50969 | 5 | 2025-06-10 18:00 | 2025-06-11 | 0 |
| 21328 | 21328 | 1645 BEACON ST | 42.326559 | -71.230986 | 50969 | 5 | 2025-06-15 06:00 | 2025-09-23 | 0 |
| 21818 | 21818 | 44 PAGE RD | 42.353631 | -71.210223 | 50969 | 2 | 2025-06-22 15:30 | 2025-07-15 | 0 |
| 22194 | 22194 | 1362 WASHINGTON ST | 42.34842 | -71.22852 | 50969 | 3 | 2025-06-26 14:30 | 1 | |
| 22195 | 22195 | 268 PARKER ST | 42.318153 | -71.194293 | 50969 | 8 | 2025-06-26 14:30 | 2025-07-03 | 0 |
| 22291 | 22291 | 761 WASHINGTON ST | 42.352335 | -71.204337 | 50969 | 2 | 2025-06-29 10:45 | 2025-07-01 | 0 |
| 22499 | 22499 | 11 ELIOT AVE | 42.352983 | -71.218049 | 50969 | 3 | 2025-07-02 08:15 | 2025-07-16 | 0 |
| 24699 | 24699 | 966 WATERTOWN ST | 42.349896 | -71.224745 | 50969 | 3 | 2025-08-05 12:00 | 2025-08-11 | 0 |
| 25116 | 25116 | 206 CABOT STREET | 42.348386 | -71.197935 | 50969 | 2 | 2025-08-13 08:30 | 2025-08-19 | 0 |
| 25973 | 25973 | 255 WASHINGTON ST | 42.357771 | -71.183844 | 50969 | 1 | 2025-09-02 06:45 | 1 | |
| 26021 | 26021 | 647 COMMONWEALTH AVE | 42.336495 | -71.193951 | 50969 | 2 | 2025-09-02 15:15 | 2025-09-03 | 0 |
| 26192 | 26192 | 101 VERNON ST | 42.355125 | -71.183705 | 50969 | 1 | 2025-09-05 09:00 | 1 | |
| 26193 | 26193 | 12 BALDWIN ST | 42.355602 | -71.183885 | 50969 | 1 | 2025-09-05 09:00 | 1 | |
| 29994 | 29994 | 295 AUBURN ST | 42.346728 | -71.247254 | 50969 | 4 | 2025-11-18 09:45 | 1 | |
| 30432 | 30432 | 101 NEVADA ST | 42.363054 | -71.213279 | 50969 | 2 | 2025-11-26 09:45 | 2025-12-17 | 0 |
| 31589 | 31589 | 10 WASHINGTON PARK | 42.34914 | -71.201691 | 50969 | 2 | 2025-12-20 14:00 | 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 );