_locations
13 rows where category_id = 51048
This data as json, CSV (advanced)
Suggested facets: ward, added, removed, active, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 937 | 937 | 60 WOODBINE STREET | 42.346561 | -71.253645 | 51048 | 4 | 2024-06-23 | 1 | |
| 1454 | 1454 | 1299 BEACON STREET | 42.330548 | -71.216544 | 51048 | 6 | 2024-07-03 | 1 | |
| 1455 | 1455 | COLD SPRING PARK | 42.330992 | -71.212896 | 51048 | 6 | 2024-07-03 | 1 | |
| 2575 | 2575 | NEWTON CENTRE PLAYGROUND | 42.332573 | -71.195801 | 51048 | 6 | 2024-07-31 | 2024-08-01 | 0 |
| 3514 | 3514 | 14 DRIFTWOOD DR | 42.364337 | -71.223298 | 51048 | 3 | 2024-08-22 | 1 | |
| 13827 | 13827 | 173 WABAN HILL RD N | 42.339249 | -71.174966 | 51048 | 7 | 2025-05-10 | 2025-07-02 | 0 |
| 14210 | 14210 | 57 WOODBINE ST | 42.346665 | -71.253432 | 51048 | 4 | 2025-05-20 | 2025-07-02 | 0 |
| 14334 | 14334 | 241 NAHANTON ST | 42.299127 | -71.198384 | 51048 | 8 | 2025-05-21 | 2025-07-02 | 0 |
| 14481 | 14481 | 1148 CENTRE STREET | 42.333068 | -71.193686 | 51048 | 6 | 2025-05-24 | 2025-07-02 | 0 |
| 14793 | 14793 | 68 ALBERT RD | 42.355206 | -71.240418 | 51048 | 4 | 2025-06-01 | 2025-07-02 | 0 |
| 15212 | 15212 | 28 MANET RD | 42.33816 | -71.174808 | 51048 | 7 | 2025-06-08 | 2025-07-02 | 0 |
| 16496 | 16496 | 246 DUDLEY RD | 42.312636 | -71.179659 | 51048 | 8 | 2025-07-02 | 2025-07-02 | 0 |
| 16609 | 16609 | 71 WOODWARD ST | 42.320889 | -71.214242 | 51048 | 5 | 2025-07-04 | 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 );