_locations
41 rows where category_id = 53224
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 |
|---|---|---|---|---|---|---|---|---|---|
| 863 | 863 | 106 OLIVER RD | 42.320893 | -71.222692 | 53224 | 5 | 2024-08-13 | 0 | |
| 864 | 864 | 120 OTIS ST | 42.346919 | -71.212246 | 53224 | 2 | 2024-12-11 | 0 | |
| 865 | 865 | 15 LOCKWOOD RD | 42.344946 | -71.226027 | 53224 | 3 | 2024-08-13 | 0 | |
| 866 | 866 | 18 TEMPLE ST | 42.345312 | -71.226355 | 53224 | 3 | 2024-12-02 | 0 | |
| 867 | 867 | 180 HIGHLAND ST | 42.344198 | -71.223634 | 53224 | 3 | 2024-08-13 | 0 | |
| 868 | 868 | 2 CLAREMONT ST | 42.351136 | -71.190376 | 53224 | 1 | 2025-04-09 | 0 | |
| 869 | 869 | 212 CHESTNUT ST | 42.342387 | -71.223143 | 53224 | 3 | 2025-03-14 | 0 | |
| 870 | 870 | 240 VALENTINE ST | 42.338413 | -71.214008 | 53224 | 2 | 2024-12-11 | 0 | |
| 871 | 871 | 320 CHESTNUT ST | 42.338529 | -71.223101 | 53224 | 3 | 2024-12-11 | 0 | |
| 872 | 872 | 322 ADAMS ST | 42.355375 | -71.196026 | 53224 | 1 | 2025-02-07 | 0 | |
| 873 | 873 | 329 WATERTOWN ST | 42.361025 | -71.199932 | 53224 | 1 | 2024-12-09 | 0 | |
| 874 | 874 | 34 BONAD RD | 42.339451 | -71.220266 | 53224 | 3 | 2024-07-01 | 0 | |
| 875 | 875 | 340 CHESTNUT ST | 42.338021 | -71.223031 | 53224 | 3 | 2025-04-09 | 0 | |
| 876 | 876 | 550 BEACON ST | 42.331706 | -71.182383 | 53224 | 7 | 2024-07-01 | 0 | |
| 877 | 877 | 65 HILLSIDE AVE | 42.34702 | -71.2225 | 53224 | 2 | 2025-04-09 | 0 | |
| 878 | 878 | 790 WATERTOWN ST | 42.352545 | -71.217234 | 53224 | 3 | 2024-12-09 | 0 | |
| 879 | 879 | 819 WATERTOWN ST | 42.352498 | -71.218839 | 53224 | 3 | 2024-12-09 | 0 | |
| 880 | 880 | 82 BULLOUGH PARK | 42.339819 | -71.204869 | 53224 | 2 | 2024-12-09 | 0 | |
| 3574 | 3574 | 19 HIGH ST | 42.313575 | -71.222383 | 53224 | 5 | 2024-08-03 08:30 | 2024-08-08 | 0 |
| 3579 | 3579 | 81 TYLER TER | 42.332288 | -71.198586 | 53224 | 6 | 2024-08-03 08:45 | 2024-08-08 | 0 |
| 3993 | 3993 | 81 TYLER TER NEWTON CENTRE MA 2459 | 42.332288 | -71.198586 | 53224 | 6 | 2024-08-09 07:30 | 1 | |
| 4000 | 4000 | 19 HIGH ST NEWTON HIGHLANDS MA 2461 | 42.313575 | -71.222383 | 53224 | 5 | 2024-08-09 07:45 | 2024-12-09 | 0 |
| 6608 | 6608 | 244 DORSET ROAD | 42.33026 | -71.241914 | 53224 | 5 | 2024-10-01 11:30 | 2024-10-02 | 0 |
| 7570 | 7570 | 122 ROUNDWOOD RD | 42.316013 | -71.219261 | 53224 | 5 | 2024-10-18 13:00 | 2025-03-27 | 0 |
| 11498 | 11498 | 35 BEACONWOOD RD | 42.329975 | -71.210047 | 53224 | 6 | 2024-12-11 14:30 | 2025-02-07 | 0 |
| 11499 | 11499 | 525 WALNUT ST | 42.343277 | -71.206262 | 53224 | 2 | 2024-12-11 14:30 | 2025-02-07 | 0 |
| 11500 | 11500 | 72 CHARLESBANK RD | 42.3585 | -71.179392 | 53224 | 1 | 2024-12-11 14:30 | 2025-02-07 | 0 |
| 11501 | 11501 | 1007 WALNUT ST | 42.32697 | -71.206495 | 53224 | 6 | 2024-12-11 14:45 | 2025-04-09 | 0 |
| 11502 | 11502 | 15 BONAD RD | 42.338784 | -71.22021 | 53224 | 3 | 2024-12-11 14:45 | 2025-02-18 | 0 |
| 11503 | 11503 | 281 PRINCE ST | 42.337922 | -71.220766 | 53224 | 3 | 2024-12-11 14:45 | 2025-02-18 | 0 |
| 11504 | 11504 | 411 WATERTOWN ST | 42.359982 | -71.202638 | 53224 | 1 | 2024-12-11 14:45 | 2025-02-07 | 0 |
| 11505 | 11505 | 430 WATERTOWN ST | 42.35932 | -71.202965 | 53224 | 1 | 2024-12-11 14:45 | 2025-02-07 | 0 |
| 11506 | 11506 | 50 HIGHLAND AVE | 42.348988 | -71.209123 | 53224 | 2 | 2024-12-11 14:45 | 2025-02-07 | 0 |
| 11507 | 11507 | 996 WALNUT ST | 42.327103 | -71.205944 | 53224 | 6 | 2024-12-11 14:45 | 2025-04-09 | 0 |
| 13237 | 13237 | 26 GREYLOCK RD | 42.345689 | -71.214937 | 53224 | 2 | 2025-01-16 11:45 | 2025-08-18 | 0 |
| 16368 | 16368 | 51 WALDORF RD | 42.318909 | -71.219345 | 53224 | 5 | 2025-03-14 14:15 | 1 | |
| 20135 | 20135 | 34 BONAD RD | 42.339447 | -71.220267 | 53224 | 3 | 2025-05-28 11:30 | 2025-05-28 | 0 |
| 20191 | 20191 | 34 BONAD ROAD | 42.339299 | -71.220308 | 53224 | 3 | 2025-05-28 22:00 | 2025-08-16 | 0 |
| 22279 | 22279 | 28 ARDMORE RD | 42.344163 | -71.233403 | 53224 | 3 | 2025-06-27 17:15 | 1 | |
| 23828 | 23828 | 12 MECHANIC ST | 42.312384 | -71.217617 | 53224 | 5 | 2025-07-21 13:45 | 1 | |
| 26557 | 26557 | 95 LANGLEY RD | 42.329295 | -71.190396 | 53224 | 6 | 2025-09-11 15:45 | 2025-11-17 | 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 );