_locations
41 rows where category_id = 51137
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 |
|---|---|---|---|---|---|---|---|---|---|
| 3279 | 3279 | 26 WASHINGTON PARK | 42.349054 | -71.202379 | 51137 | 2 | 2024-07-29 10:30 | 2024-07-30 | 0 |
| 4577 | 4577 | 1479 WASHINGTON ST | 42.346753 | -71.232241 | 51137 | 3 | 2024-08-19 09:30 | 2024-08-19 | 0 |
| 8211 | 8211 | 934 WATERTOWN ST | 42.350302 | -71.223413 | 51137 | 3 | 2024-10-24 08:45 | 2024-10-24 | 0 |
| 8422 | 8422 | 26 ROWENA ROAD | 42.322967 | -71.197441 | 51137 | 6 | 2024-10-26 10:45 | 2024-10-29 | 0 |
| 9928 | 9928 | 963 WATERTOWN STREET | 42.350094 | -71.224725 | 51137 | 3 | 2024-11-08 07:15 | 2024-11-19 | 0 |
| 10078 | 10078 | 54 PARK ST | 42.355156 | -71.182035 | 51137 | 1 | 2024-11-13 07:30 | 2024-11-27 | 0 |
| 10513 | 10513 | 244 DORSET RD | 42.330392 | -71.241883 | 51137 | 5 | 2024-11-22 14:45 | 2024-11-25 | 0 |
| 11423 | 11423 | 12 CHANNING ST | 42.357839 | -71.187716 | 51137 | 1 | 2024-12-10 14:45 | 2025-02-14 | 0 |
| 11637 | 11637 | 228 HIGHLAND AVE | 42.347081 | -71.216616 | 51137 | 2 | 2024-12-13 11:45 | 1 | |
| 11729 | 11729 | 56 CHAPEL ST | 42.363382 | -71.20119 | 51137 | 1 | 2024-12-16 09:00 | 2025-06-30 | 0 |
| 11972 | 11972 | 108 JACKSON RD | 42.359271 | -71.194659 | 51137 | 1 | 2024-12-20 16:45 | 2024-12-27 | 0 |
| 12453 | 12453 | 239 RIVER ST | 42.355623 | -71.235713 | 51137 | 4 | 2024-12-31 12:00 | 2025-01-02 | 0 |
| 12515 | 12515 | 40 LYME RD | 42.358933 | -71.223254 | 51137 | 3 | 2025-01-02 11:15 | 2025-01-03 | 0 |
| 13052 | 13052 | 1820 WASHINGTON ST | 42.337111 | -71.240928 | 51137 | 4 | 2025-01-13 09:30 | 2025-01-13 | 0 |
| 15665 | 15665 | 265 CENTRE ST | 42.358453 | -71.185023 | 51137 | 1 | 2025-03-03 10:15 | 1 | |
| 15744 | 15744 | 18 AUSTIN ST | 42.350418 | -71.207573 | 51137 | 2 | 2025-03-04 16:30 | 2025-03-07 | 0 |
| 16090 | 16090 | 2084 WASHINGTON ST | 42.329709 | -71.248563 | 51137 | 5 | 2025-03-10 09:15 | 2025-03-27 | 0 |
| 16504 | 16504 | 230 GRANT AVENUE | 42.332088 | -71.188319 | 51137 | 7 | 2025-03-18 12:00 | 2025-11-06 | 0 |
| 18098 | 18098 | 221 OTIS ST | 42.346449 | -71.216934 | 51137 | 2 | 2025-04-22 09:15 | 2025-07-09 | 0 |
| 18360 | 18360 | 16 BROOKDALE RD | 42.361794 | -71.214575 | 51137 | 2 | 2025-04-25 15:45 | 2025-04-29 | 0 |
| 21758 | 21758 | 38 BALCARRES RD | 42.344325 | -71.218062 | 51137 | 2 | 2025-06-20 13:00 | 2025-06-25 | 0 |
| 24521 | 24521 | 32 HARVARD STREET | 42.351315 | -71.201582 | 51137 | 2 | 2025-08-01 15:00 | 2025-08-18 | 0 |
| 24946 | 24946 | 145 WARREN ST | 42.329691 | -71.188511 | 51137 | 6 | 2025-08-10 08:30 | 2025-08-13 | 0 |
| 26613 | 26613 | 12 KINGSBURY RD | 42.329907 | -71.168634 | 51137 | 7 | 2025-09-12 12:15 | 2025-09-23 | 0 |
| 26719 | 26719 | 20 SWALLOW DR | 42.328791 | -71.260146 | 51137 | 4 | 2025-09-15 11:30 | 2025-10-03 | 0 |
| 27018 | 27018 | 361 FANEUIL STREET | 42.35214 | -71.165619 | 51137 | 2025-09-21 20:15 | 2025-09-22 | 0 | |
| 27126 | 27126 | 20 AUSTIN ST | 42.350373 | -71.207604 | 51137 | 2 | 2025-09-23 09:30 | 1 | |
| 27445 | 27445 | 503 BOYLSTON ST | 42.319116 | -71.189825 | 51137 | 6 | 2025-09-29 10:45 | 2025-09-30 | 0 |
| 28269 | 28269 | 1 BACON ST | 42.358068 | -71.186643 | 51137 | 1 | 2025-10-15 14:45 | 1 | |
| 28481 | 28481 | 128 WESTLAND AVE | 42.354936 | -71.22906 | 51137 | 3 | 2025-10-20 13:45 | 1 | |
| 28588 | 28588 | 144 ELLIOT ST | 42.314283 | -71.215263 | 51137 | 5 | 2025-10-22 10:00 | 2025-10-27 | 0 |
| 29627 | 29627 | 54 JEROME AVE | 42.359715 | -71.22933 | 51137 | 3 | 2025-11-10 15:00 | 2025-12-18 | 0 |
| 30304 | 30304 | 28 SARGENT ST | 42.34662 | -71.182463 | 51137 | 7 | 2025-11-24 12:45 | 2025-12-10 | 0 |
| 30446 | 30446 | 39 BYFIELD RD | 42.332733 | -71.22303 | 51137 | 5 | 2025-11-26 12:00 | 1 | |
| 30455 | 30455 | 15 ELIZABETH CIR | 42.33771 | -71.22852 | 51137 | 3 | 2025-11-26 14:45 | 2025-12-18 | 0 |
| 30776 | 30776 | 60 WELLS AVE | 42.29451 | -71.200926 | 51137 | 8 | 2025-12-04 13:00 | 1 | |
| 30911 | 30911 | 153 HARVARD STREET | 42.347097 | -71.200853 | 51137 | 2 | 2025-12-09 07:30 | 1 | |
| 31079 | 31079 | 34 OTIS STREET | 42.347493 | -71.207998 | 51137 | 2 | 2025-12-11 17:15 | 2025-12-12 | 0 |
| 31097 | 31097 | 34 OTIS ST | 42.34761 | -71.208162 | 51137 | 2 | 2025-12-12 08:00 | 2025-12-18 | 0 |
| 31529 | 31529 | 18 WASHINGTON PARK | 42.349095 | -71.202024 | 51137 | 2 | 2025-12-19 13:45 | 1 | |
| 31618 | 31618 | 10 WASHINGTON PARK | 42.34914 | -71.201691 | 51137 | 2 | 2025-12-21 22:30 | 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 );