_locations
32 rows where category_id = 53472
This data as json, CSV (advanced)
Suggested facets: location, latitude, longitude, ward, added, removed, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 822 | 822 | 112 WEST ST | 42.357802 | -71.197611 | 53472 | 1 | 2024-06-21 | 2024-06-21 | 0 |
| 1492 | 1492 | 11 BRIDGE ST | 42.364683 | -71.204418 | 53472 | 1 | 2024-07-04 | 2024-07-12 | 0 |
| 2032 | 2032 | 525 HAMMOND ST | 42.325686 | -71.165596 | 53472 | 7 | 2024-07-17 | 2024-07-23 | 0 |
| 6782 | 6782 | 30 JACONNET STREET | 42.311333 | -71.210155 | 53472 | 8 | 2024-11-08 | 2024-11-13 | 0 |
| 6809 | 6809 | 59–99 CLINTON PL | 42.339458 | -71.192994 | 53472 | 2 | 2024-11-08 | 2024-11-12 | 0 |
| 7127 | 7127 | 64 JACKSON STREET | 42.319386 | -71.185328 | 53472 | 6 | 2024-11-20 | 2024-11-22 | 0 |
| 7199 | 7199 | 64 JACKSON ST | 42.319278 | -71.185273 | 53472 | 6 | 2024-11-22 | 2024-11-22 | 0 |
| 7641 | 7641 | 333R OTIS STREET | 42.345289 | -71.221924 | 53472 | 3 | 2024-12-04 | 2025-06-09 | 0 |
| 7730 | 7730 | 61 WILLIAM STREET | 42.357943 | -71.235142 | 53472 | 4 | 2024-12-06 | 2024-12-09 | 0 |
| 8037 | 8037 | 390 DEDHAM ST | 42.308926 | -71.199002 | 53472 | 8 | 2024-12-12 | 2024-12-27 | 0 |
| 8222 | 8222 | 18 FESSENDEN ST | 42.360419 | -71.2148 | 53472 | 2 | 2024-12-18 | 2024-12-18 | 0 |
| 9549 | 9549 | 30 ASHEVILLE RD | 42.331887 | -71.25723 | 53472 | 4 | 2025-01-22 | 2025-01-24 | 0 |
| 10153 | 10153 | 15 DEXTER RD | 42.34329 | -71.207604 | 53472 | 2 | 2025-02-07 | 2025-02-07 | 0 |
| 10402 | 10402 | 525 HAMMOND ST | 42.325686 | -71.165597 | 53472 | 7 | 2025-02-13 | 2025-02-13 | 0 |
| 11432 | 11432 | 282 HOMER ST | 42.335577 | -71.205674 | 53472 | 6 | 2025-03-07 | 2025-03-07 | 0 |
| 12498 | 12498 | 1018 BOYLSTON ST | 42.318477 | -71.213423 | 53472 | 5 | 2025-04-06 | 2025-04-07 | 0 |
| 12670 | 12670 | 525 HAMMOND ST | 42.325686 | -71.165597 | 53472 | 7 | 2025-04-10 | 2025-04-14 | 0 |
| 13113 | 13113 | 59 KENSINGTON ST | 42.354198 | -71.21606 | 53472 | 3 | 2025-04-24 | 2025-04-24 | 0 |
| 13142 | 13142 | 525 HAMMOND ST | 42.325686 | -71.165597 | 53472 | 7 | 2025-04-24 | 2025-04-24 | 0 |
| 13284 | 13284 | 8 DAVID ROAD | 42.315593 | -71.194737 | 53472 | 8 | 2025-04-28 | 2025-04-30 | 0 |
| 13624 | 13624 | 49 WESTMINSTER ROAD | 42.326901 | -71.186331 | 53472 | 7 | 2025-05-06 | 2025-05-06 | 0 |
| 13999 | 13999 | 8 DAVID ROAD | 42.315593 | -71.194737 | 53472 | 8 | 2025-05-14 | 2025-07-14 | 0 |
| 16559 | 16559 | 33 JOHN ST | 42.320367 | -71.181482 | 53472 | 6 | 2025-07-02 | 2025-07-10 | 0 |
| 18057 | 18057 | 111 FLORENCE ST | 42.317586 | -71.177207 | 53472 | 8 | 2025-08-05 | 2025-08-05 | 0 |
| 18656 | 18656 | 181 WELLS AVE | 42.295014 | -71.197893 | 53472 | 8 | 2025-08-20 | 2025-08-20 | 0 |
| 19263 | 19263 | 43 BLAKE ST | 42.346746 | -71.1986 | 53472 | 2 | 2025-09-08 | 2025-09-08 | 0 |
| 20128 | 20128 | 11 MILDRED RD | 42.315255 | -71.196912 | 53472 | 8 | 2025-09-30 | 2025-10-11 | 0 |
| 20509 | 20509 | 256 NEWTONVILLE AVENUE | 42.352186 | -71.197109 | 53472 | 2 | 2025-10-10 | 2025-10-21 | 0 |
| 20521 | 20521 | 54 BRENTWOOD AVENUE | 42.332538 | -71.206797 | 53472 | 6 | 2025-10-12 | 2025-10-16 | 0 |
| 20903 | 20903 | 1064 CENTRE ST | 42.335901 | -71.193132 | 53472 | 6 | 2025-10-22 | 2025-10-23 | 0 |
| 21687 | 21687 | 54 ASHMONT AVE | 42.356079 | -71.202663 | 53472 | 1 | 2025-11-10 | 2025-11-10 | 0 |
| 22575 | 22575 | 162 CLARK ST | 42.31953 | -71.195783 | 53472 | 6 | 2025-12-04 | 2025-12-08 | 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 );