_locations
39 rows where category_id = 53467
This data as json, CSV (advanced)
Suggested facets: ward, removed, active, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 1151 | 1151 | 195 VARICK ROAD | 42.323774 | -71.245559 | 53467 | 5 | 2024-09-23 | 0 | |
| 1152 | 1152 | 34 BROOKSIDE AVE | 42.353033 | -71.213445 | 53467 | 2 | 2024-09-23 | 0 | |
| 1414 | 1414 | 99 SHADY HILL RD | 42.318408 | -71.204888 | 53467 | 5 | 2024-06-25 | 2024-09-23 | 0 |
| 1772 | 1772 | 29 WALTER ST | 42.321386 | -71.192879 | 53467 | 6 | 2024-07-01 10:00 | 2024-09-23 | 0 |
| 2419 | 2419 | 1000 COMMONWEALTH AVE | 42.337381 | -71.208615 | 53467 | 2 | 2024-07-11 14:30 | 2024-07-11 | 0 |
| 2578 | 2578 | 172 CABOT STREET | 42.347509 | -71.19669 | 53467 | 2 | 2024-07-15 16:45 | 2024-09-23 | 0 |
| 3287 | 3287 | 85 HYDE AVE | 42.347329 | -71.186363 | 53467 | 7 | 2024-07-29 11:45 | 2024-09-23 | 0 |
| 4384 | 4384 | 1215 COMMONWEALTH AVE | 42.337318 | -71.216558 | 53467 | 2 | 2024-08-14 20:00 | 2024-09-23 | 0 |
| 5641 | 5641 | 1334 WALNUT ST | 42.316936 | -71.20231 | 53467 | 5 | 2024-09-10 18:00 | 2024-09-23 | 0 |
| 5904 | 5904 | 61 LANGDON ST | 42.350237 | -71.193723 | 53467 | 1 | 2024-09-16 11:00 | 2024-09-23 | 0 |
| 6223 | 6223 | 24 SAGAMORE RD | 42.326222 | -71.216219 | 53467 | 5 | 2024-09-23 17:45 | 2024-09-26 | 0 |
| 6224 | 6224 | 77 DORCAR RD | 42.301212 | -71.175231 | 53467 | 8 | 2024-09-23 17:45 | 2024-09-26 | 0 |
| 6578 | 6578 | 10 LAUREL ST | 42.330242 | -71.20103 | 53467 | 6 | 2024-09-30 17:15 | 2024-10-22 | 0 |
| 6750 | 6750 | 64 LINCOLN RD | 42.355229 | -71.200304 | 53467 | 1 | 2024-10-04 15:30 | 2024-10-08 | 0 |
| 7213 | 7213 | 495 WATERTOWN ST | 42.358041 | -71.205489 | 53467 | 1 | 2024-10-16 12:45 | 2024-10-22 | 0 |
| 7963 | 7963 | 33 ELIOT MEMORIAL RD | 42.344866 | -71.179904 | 53467 | 7 | 2024-10-22 16:00 | 2024-10-22 | 0 |
| 10359 | 10359 | 30 NICKERSON RD | 42.306676 | -71.175369 | 53467 | 8 | 2024-11-20 09:30 | 2024-11-22 | 0 |
| 12230 | 12230 | 44 WOODBINE ST | 42.346286 | -71.252936 | 53467 | 4 | 2024-12-25 12:30 | 2025-01-30 | 0 |
| 13477 | 13477 | 15 CONCOLOR AVE | 42.348519 | -71.190747 | 53467 | 2 | 2025-01-22 08:30 | 2025-01-30 | 0 |
| 13846 | 13846 | 71 ANDREW ST | 42.312969 | -71.205305 | 53467 | 8 | 2025-01-28 16:45 | 2025-01-30 | 0 |
| 14525 | 14525 | 294 CABOT ST | 42.347907 | -71.202222 | 53467 | 2 | 2025-02-11 14:15 | 2025-02-13 | 0 |
| 15261 | 15261 | 39 BELLEVUE ST | 42.350679 | -71.188353 | 53467 | 1 | 2025-02-21 18:45 | 2025-02-27 | 0 |
| 15276 | 15276 | 87 LINCOLN ST | 42.321456 | -71.209683 | 53467 | 6 | 2025-02-23 10:30 | 2025-02-27 | 0 |
| 15482 | 15482 | 41 SOMERSET RD | 42.344442 | -71.217635 | 53467 | 2 | 2025-02-26 11:45 | 2025-02-27 | 0 |
| 16531 | 16531 | 71 ANDREW ST | 42.312969 | -71.205305 | 53467 | 8 | 2025-03-18 22:00 | 2025-03-24 | 0 |
| 17877 | 17877 | 49 GLENDALE RD | 42.339564 | -71.188785 | 53467 | 7 | 2025-04-15 19:30 | 1 | |
| 19512 | 19512 | 1385 WASHINGTON ST | 42.348681 | -71.229776 | 53467 | 3 | 2025-05-16 15:30 | 2025-05-19 | 0 |
| 20512 | 20512 | 51 WALDORF RD | 42.318909 | -71.219345 | 53467 | 5 | 2025-06-02 19:30 | 2025-06-03 | 0 |
| 20516 | 20516 | 19 OHIO AVE | 42.311691 | -71.221968 | 53467 | 5 | 2025-06-03 06:30 | 2025-06-03 | 0 |
| 20809 | 20809 | 29 PRAIRIE AVE | 42.349617 | -71.23964 | 53467 | 4 | 2025-06-06 07:00 | 2025-06-06 | 0 |
| 23230 | 23230 | 80 CROSS HILL RD | 42.305319 | -71.186904 | 53467 | 8 | 2025-07-14 14:30 | 2025-07-16 | 0 |
| 25312 | 25312 | 14 LESLIE RD | 42.339042 | -71.239428 | 53467 | 4 | 2025-08-16 10:00 | 2025-08-18 | 0 |
| 25514 | 25514 | 17 TUDOR TER | 42.349212 | -71.243042 | 53467 | 4 | 2025-08-21 06:45 | 2025-08-22 | 0 |
| 26252 | 26252 | 43 BLAKE ST | 42.346746 | -71.1986 | 53467 | 2 | 2025-09-05 18:45 | 2025-09-08 | 0 |
| 27142 | 27142 | 31 STUART RD | 42.340311 | -71.184326 | 53467 | 7 | 2025-09-23 11:15 | 2025-09-24 | 0 |
| 27480 | 27480 | 36 NARDELL RD | 42.309063 | -71.179641 | 53467 | 8 | 2025-09-29 16:15 | 2025-09-30 | 0 |
| 27626 | 27626 | 151 COUNTRY CLUB RD | 42.304878 | -71.189906 | 53467 | 8 | 2025-10-01 13:45 | 2025-11-03 | 0 |
| 30977 | 30977 | 19 BERNARD ST | 42.305562 | -71.211776 | 53467 | 8 | 2025-12-10 10:00 | 2025-12-10 | 0 |
| 31483 | 31483 | 24 CHAPIN RD | 42.333876 | -71.200472 | 53467 | 6 | 2025-12-19 12:15 | 2025-12-22 | 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 );