_locations
42 rows where category_id = 50970
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 |
|---|---|---|---|---|---|---|---|---|---|
| 147 | 147 | 36 CRESTWOOD RD | 42.341805 | -71.215159 | 50970 | 2 | 2024-06-17 | 0 | |
| 1004 | 1004 | 540 PARKER STREET | 42.309182 | -71.197205 | 50970 | 8 | 2024-06-24 | 2024-06-25 | 0 |
| 1189 | 1189 | 15 WOODLAWN DR | 42.341002 | -71.17602 | 50970 | 7 | 2024-06-27 | 2024-07-19 | 0 |
| 1352 | 1352 | 17 GILBERT ST | 42.344409 | -71.236583 | 50970 | 4 | 2024-07-01 | 2024-07-03 | 0 |
| 2759 | 2759 | 184 UPLAND AVE | 42.312968 | -71.207588 | 50970 | 8 | 2024-08-06 | 2025-08-11 | 0 |
| 4248 | 4248 | 765 DEDHAM ST | 42.299231 | -71.187426 | 50970 | 8 | 2024-09-13 | 1 | |
| 4323 | 4323 | 10 CENTRAL CLOSE | 42.345483 | -71.247966 | 50970 | 4 | 2024-09-16 | 2024-10-09 | 0 |
| 5475 | 5475 | 520 COMMONWEALTH AVE | 42.336109 | -71.187598 | 50970 | 6 | 2024-10-18 | 1 | |
| 5496 | 5496 | 73 BALDPATE HILL RD | 42.306511 | -71.178633 | 50970 | 8 | 2024-10-18 | 1 | |
| 5694 | 5694 | 134 SOUTH AVE | 50970 | 2024-10-22 | 2024-10-23 | 0 | |||
| 5789 | 5789 | 8 BROADLAWN PARK | 42.304235 | -71.166066 | 50970 | 8 | 2024-10-24 | 1 | |
| 6734 | 6734 | 44 COLGATE RD | 42.327873 | -71.257392 | 50970 | 4 | 2024-11-07 | 1 | |
| 6743 | 6743 | 221 WALTHAM ST | 42.35952 | -71.222695 | 50970 | 3 | 2024-11-07 | 1 | |
| 6752 | 6752 | 131 MELROSE ST | 42.351983 | -71.249308 | 50970 | 4 | 2024-11-07 | 1 | |
| 6766 | 6766 | 522 COMMONWEALTH AVE | 42.336113 | -71.187672 | 50970 | 6 | 2024-11-07 | 1 | |
| 6774 | 6774 | 63 SOUTHGATE PARK | 42.355131 | -71.226581 | 50970 | 3 | 2024-11-07 | 1 | |
| 6893 | 6893 | 2133 COMMONWEALTH AVE | 42.348267 | -71.249137 | 50970 | 4 | 2024-11-13 | 2024-11-20 | 0 |
| 7573 | 7573 | 371 AUSTIN ST | 42.347765 | -71.22379 | 50970 | 2 | 2024-12-03 | 1 | |
| 7891 | 7891 | 701 BOYLSTON ST | 42.319378 | -71.199037 | 50970 | 6 | 2024-12-10 | 1 | |
| 9412 | 9412 | 46 TROY LN | 42.335307 | -71.219435 | 50970 | 5 | 2025-01-20 | 2025-01-23 | 0 |
| 9817 | 9817 | 63 TANGLEWOOD RD | 42.317271 | -71.181824 | 50970 | 8 | 2025-01-28 | 2025-01-31 | 0 |
| 10433 | 10433 | 63 PAGE RD | 42.354162 | -71.210763 | 50970 | 2 | 2025-02-13 | 1 | |
| 10611 | 10611 | 658 COMMONWEALTH AVE | 42.33555 | -71.194127 | 50970 | 6 | 2025-02-17 | 2025-02-24 | 0 |
| 11063 | 11063 | 176 DEDHAM ST | 42.313788 | -71.201642 | 50970 | 8 | 2025-02-24 | 2025-02-25 | 0 |
| 11804 | 11804 | 79 PEARL ST | 42.358545 | -71.188839 | 50970 | 1 | 2025-03-15 | 2025-03-17 | 0 |
| 13166 | 13166 | 44 ROLLING LN | 42.30747 | -71.172009 | 50970 | 8 | 2025-04-24 | 2025-04-28 | 0 |
| 13609 | 13609 | 44 ROLLING LN | 42.30747 | -71.172009 | 50970 | 8 | 2025-05-06 | 2025-05-13 | 0 |
| 14505 | 14505 | 22 ELMWOOD STREET | 42.355795 | -71.183118 | 50970 | 1 | 2025-05-27 | 2025-09-03 | 0 |
| 14619 | 14619 | 76 CLINTON PL | 42.339582 | -71.193834 | 50970 | 2 | 2025-05-28 | 2025-06-18 | 0 |
| 15401 | 15401 | 26 MERRILL RD | 42.337314 | -71.179191 | 50970 | 7 | 2025-06-11 | 2025-07-30 | 0 |
| 16360 | 16360 | 6 WHEELER RD | 42.312042 | -71.196237 | 50970 | 8 | 2025-06-30 | 1 | |
| 16366 | 16366 | 47 MONTCLAIR RD | 42.329898 | -71.228934 | 50970 | 5 | 2025-06-30 | 2025-07-01 | 0 |
| 16905 | 16905 | 999 WASHINGTON ST | 42.351066 | -71.213931 | 50970 | 2 | 2025-07-11 | 1 | |
| 17488 | 17488 | 1234 CHESTNUT ST | 42.309783 | -71.220132 | 50970 | 5 | 2025-07-21 | 2025-08-04 | 0 |
| 17989 | 17989 | 43 WINCHESTER RD | 42.349851 | -71.195909 | 50970 | 1 | 2025-08-02 | 2025-08-05 | 0 |
| 18906 | 18906 | 18 JOSEPH ROAD | 42.362589 | -71.215621 | 50970 | 3 | 2025-08-28 | 2025-09-09 | 0 |
| 19699 | 19699 | 38 FALMOUTH RD | 42.362406 | -71.2287 | 50970 | 3 | 2025-09-18 | 2025-10-07 | 0 |
| 21007 | 21007 | 232 BROOKLINE ST | 42.30261 | -71.176955 | 50970 | 8 | 2025-10-24 | 1 | |
| 22337 | 22337 | 89 PLEASANT ST | 42.331392 | -71.198406 | 50970 | 6 | 2025-11-26 | 1 | |
| 22738 | 22738 | 350 WOODWARD ST | 42.325389 | -71.225321 | 50970 | 5 | 2025-12-09 | 2025-12-11 | 0 |
| 23040 | 23040 | 436 WINCHESTER ST | 42.305643 | -71.205269 | 50970 | 8 | 2025-12-17 | 1 | |
| 23229 | 23229 | 499 CRAFTS ST | 42.360633 | -71.220371 | 50970 | 3 | 2025-12-21 | 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 );