_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 |
|---|---|---|---|---|---|---|---|---|---|
| 1238 | 1238 | 60 WOODBINE STREET | 42.346561 | -71.253645 | 51048 | 4 | 2024-06-23 | 1 | |
| 1937 | 1937 | 1299 BEACON STREET | 42.330548 | -71.216544 | 51048 | 6 | 2024-07-03 10:00 | 1 | |
| 1938 | 1938 | COLD SPRING PARK | 42.330992 | -71.212896 | 51048 | 6 | 2024-07-03 10:00 | 1 | |
| 3457 | 3457 | NEWTON CENTRE PLAYGROUND | 42.332573 | -71.195801 | 51048 | 6 | 2024-07-31 17:45 | 2024-08-01 | 0 |
| 4783 | 4783 | 14 DRIFTWOOD DR | 42.364337 | -71.223298 | 51048 | 3 | 2024-08-22 11:15 | 1 | |
| 19160 | 19160 | 173 WABAN HILL RD N | 42.339249 | -71.174966 | 51048 | 7 | 2025-05-10 17:00 | 2025-07-02 | 0 |
| 19657 | 19657 | 57 WOODBINE ST | 42.346665 | -71.253432 | 51048 | 4 | 2025-05-20 07:00 | 2025-07-02 | 0 |
| 19804 | 19804 | 241 NAHANTON ST | 42.299127 | -71.198384 | 51048 | 8 | 2025-05-21 15:45 | 2025-07-02 | 0 |
| 19984 | 19984 | 1148 CENTRE STREET | 42.333068 | -71.193686 | 51048 | 6 | 2025-05-24 19:30 | 2025-07-02 | 0 |
| 20381 | 20381 | 68 ALBERT RD | 42.355206 | -71.240418 | 51048 | 4 | 2025-05-31 21:45 | 2025-07-02 | 0 |
| 20915 | 20915 | 28 MANET RD | 42.33816 | -71.174808 | 51048 | 7 | 2025-06-08 17:30 | 2025-07-02 | 0 |
| 22506 | 22506 | 246 DUDLEY RD | 42.312636 | -71.179659 | 51048 | 8 | 2025-07-02 09:00 | 2025-07-02 | 0 |
| 22660 | 22660 | 71 WOODWARD ST | 42.320889 | -71.214242 | 51048 | 5 | 2025-07-04 19: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 );