_locations
11 rows where category_id = 53223
This data as json, CSV (advanced)
Suggested facets: ward, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 5997 | 5997 | 122–134 CHAPEL ST | 53223 | 2024-09-17 09:45 | 2024-09-17 | 0 | |||
| 10525 | 10525 | 21 WILLIAMS ST | 42.307499 | -71.219484 | 53223 | 5 | 2024-11-23 14:00 | 2024-11-26 | 0 |
| 12478 | 12478 | 933 CENTRE STREET | 42.340413 | -71.192862 | 53223 | 2 | 2025-01-02 08:15 | 2025-01-02 | 0 |
| 13731 | 13731 | 15 NORWOOD AVENUE | 42.328793 | -71.198106 | 53223 | 6 | 2025-01-27 13:15 | 2025-01-28 | 0 |
| 13849 | 13849 | 310 NEVADA STREET | 42.359117 | -71.205445 | 53223 | 1 | 2025-01-28 19:00 | 2025-01-29 | 0 |
| 15636 | 15636 | 5 MORSELAND AVE | 42.340194 | -71.197475 | 53223 | 2 | 2025-03-01 16:45 | 2025-03-03 | 0 |
| 15838 | 15838 | 811 WATERTOWN ST | 42.352578 | -71.218499 | 53223 | 3 | 2025-03-06 14:45 | 2025-03-13 | 0 |
| 16114 | 16114 | 180 BRANDEIS RD | 42.312618 | -71.185325 | 53223 | 8 | 2025-03-10 12:00 | 2025-03-10 | 0 |
| 21251 | 21251 | 244 LEXINGTON ST | 42.353523 | -71.244792 | 53223 | 4 | 2025-06-12 16:45 | 2025-06-13 | 0 |
| 30767 | 30767 | 60 WELLS AVE | 42.29451 | -71.200926 | 53223 | 8 | 2025-12-04 10:15 | 2025-12-04 | 0 |
| 31628 | 31628 | 8 HALLRON RD | 42.331824 | -71.257815 | 53223 | 4 | 2025-12-22 09:00 | 2025-12-23 | 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 );