_locations
23 rows where category_id = 50985
This data as json, CSV (advanced)
Suggested facets: ward, removed, removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 5843 | 5843 | 457 WALNUT ST | 42.345286 | -71.207683 | 50985 | 2 | 2024-09-15 17:00 | 2024-09-23 | 0 |
| 7996 | 7996 | 1408 CENTRE ST | 42.326094 | -71.197965 | 50985 | 6 | 2024-10-23 08:30 | 2024-11-05 | 0 |
| 8681 | 8681 | 12 WENHAM RD | 42.32782 | -71.208626 | 50985 | 6 | 2024-10-29 11:30 | 2024-10-30 | 0 |
| 10282 | 10282 | 140 LION DR | 42.311658 | -71.186863 | 50985 | 8 | 2024-11-18 14:30 | 2025-02-06 | 0 |
| 10621 | 10621 | 462 WALNUT STREET | 42.345479 | -71.205788 | 50985 | 2 | 2024-11-25 10:30 | 2024-11-27 | 0 |
| 11746 | 11746 | 290 ALBEMARLE ROAD | 42.355002 | -71.214049 | 50985 | 2 | 2024-12-16 13:45 | 2024-12-17 | 0 |
| 12243 | 12243 | 100 WALNUT STREET | 42.357071 | -71.209543 | 50985 | 2 | 2024-12-26 10:00 | 2025-01-02 | 0 |
| 12787 | 12787 | 611 CENTRE ST | 42.350076 | -71.18657 | 50985 | 1 | 2025-01-07 14:00 | 2025-02-19 | 0 |
| 13771 | 13771 | 19 OTIS PARK | 42.347263 | -71.206915 | 50985 | 2 | 2025-01-28 09:15 | 2025-04-21 | 0 |
| 16173 | 16173 | 687 WATERTOWN ST | 42.35463 | -71.21349 | 50985 | 2 | 2025-03-11 09:00 | 2025-03-12 | 0 |
| 16386 | 16386 | 110 TYLER TER | 42.331716 | -71.199068 | 50985 | 6 | 2025-03-15 14:15 | 2025-03-18 | 0 |
| 16675 | 16675 | 180 BRANDEIS RD | 42.312618 | -71.185325 | 50985 | 8 | 2025-03-22 15:45 | 2025-04-15 | 0 |
| 17496 | 17496 | 232 BROOKLINE ST | 42.30261 | -71.176955 | 50985 | 8 | 2025-04-08 12:15 | 2025-05-01 | 0 |
| 18036 | 18036 | 50 PRINCESS ROAD | 42.354257 | -71.226495 | 50985 | 3 | 2025-04-19 08:15 | 2025-04-29 | 0 |
| 18164 | 18164 | 57 LOUISE ROAD | 42.316279 | -71.176946 | 50985 | 8 | 2025-04-23 06:45 | 2025-05-08 | 0 |
| 22419 | 22419 | 94 WEBSTER ST | 42.349536 | -71.230676 | 50985 | 3 | 2025-07-01 11:15 | 2025-07-01 | 0 |
| 23861 | 23861 | 30 BEETHOVEN AVE | 42.329682 | -71.217707 | 50985 | 5 | 2025-07-22 08:00 | 2025-07-22 | 0 |
| 24662 | 24662 | 1200 BEACON ST | 42.330996 | -71.212896 | 50985 | 6 | 2025-08-05 08:45 | 2025-08-19 | 0 |
| 25648 | 25648 | 177 CHERRY ST | 42.358167 | -71.227485 | 50985 | 3 | 2025-08-24 20:45 | 2025-10-06 | 0 |
| 26531 | 26531 | 90 EAST SIDE PARKWAY | 42.351283 | -71.196561 | 50985 | 2 | 2025-09-11 12:45 | 2025-09-16 | 0 |
| 27011 | 27011 | 115 BEETHOVEN AVE | 42.326775 | -71.219439 | 50985 | 5 | 2025-09-20 17:45 | 2025-09-23 | 0 |
| 27717 | 27717 | 100 WALNUT ST | 42.357006 | -71.209409 | 50985 | 2 | 2025-10-03 09:30 | 2025-10-06 | 0 |
| 30483 | 30483 | 205 LEXINGTON ST | 42.354585 | -71.244036 | 50985 | 4 | 2025-11-29 11:45 | 2025-12-02 | 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 );