_locations
28 rows where category_id = 50990
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 |
|---|---|---|---|---|---|---|---|---|---|
| 398 | 398 | 65 WEBSTER PARK | 50990 | 1 | |||||
| 1308 | 1308 | 99 SARGENT STREET | 42.346201 | -71.184373 | 50990 | 7 | 2024-06-29 | 2024-07-03 | 0 |
| 1625 | 1625 | 2203 COMMONWEALTH AVE | 42.350556 | -71.252678 | 50990 | 4 | 2024-07-08 | 2024-07-10 | 0 |
| 1700 | 1700 | NEWTON CENTRE PLAYGROUND | 42.332573 | -71.195801 | 50990 | 6 | 2024-07-09 | 2024-07-10 | 0 |
| 3926 | 3926 | 90 A CHRISTINA STREET | 42.306243 | -71.213022 | 50990 | 8 | 2024-09-05 | 2024-09-09 | 0 |
| 4003 | 4003 | 31 HERRICK RD | 42.328962 | -71.193661 | 50990 | 6 | 2024-09-06 | 2024-09-10 | 0 |
| 4651 | 4651 | 10 HERRICK RD | 42.329783 | -71.193868 | 50990 | 6 | 2024-09-25 | 2024-09-25 | 0 |
| 4796 | 4796 | 409 WINCHESTER STREET | 42.30639 | -71.20581 | 50990 | 8 | 2024-09-30 | 2024-10-03 | 0 |
| 7110 | 7110 | 200–224 ALBEMARLE RD | 42.359618 | -71.216741 | 50990 | 2 | 2024-11-20 | 2024-11-22 | 0 |
| 8160 | 8160 | 02466 | 42.35359 | -71.252802 | 50990 | 4 | 2024-12-16 | 2024-12-16 | 0 |
| 8214 | 8214 | 293 ALBEMARLE RD | 42.356333 | -71.21567 | 50990 | 3 | 2024-12-17 | 2024-12-19 | 0 |
| 8292 | 8292 | 2–90 LAKE AVE | 42.329612 | -71.200319 | 50990 | 6 | 2024-12-20 | 2025-02-26 | 0 |
| 9894 | 9894 | 222 LOWELL AVENUE | 42.349856 | -71.210402 | 50990 | 2 | 2025-01-30 | 2025-02-01 | 0 |
| 10356 | 10356 | 288 WALNUT ST | 42.351012 | -71.206461 | 50990 | 2 | 2025-02-11 | 2025-02-12 | 0 |
| 10357 | 10357 | 442 WALNUT ST | 42.346143 | -71.205849 | 50990 | 2 | 2025-02-11 | 2025-02-12 | 0 |
| 10358 | 10358 | 472 WALNUT ST | 42.345117 | -71.205453 | 50990 | 2 | 2025-02-11 | 2025-02-12 | 0 |
| 10359 | 10359 | 508 WALNUT ST | 42.343965 | -71.205575 | 50990 | 2 | 2025-02-11 | 2025-02-12 | 0 |
| 13011 | 13011 | 77 LAKE AVE | 42.32981 | -71.200768 | 50990 | 6 | 2025-04-21 | 2025-04-29 | 0 |
| 13524 | 13524 | 1479 WASHINGTON STREET | 42.346908 | -71.231876 | 50990 | 3 | 2025-05-05 | 2025-05-05 | 0 |
| 14829 | 14829 | 1415 COMMONWEALTH AVE | 42.337566 | -71.224416 | 50990 | 3 | 2025-06-02 | 2025-06-02 | 0 |
| 14961 | 14961 | 96 DEXTER ROAD | 42.341911 | -71.205364 | 50990 | 2 | 2025-06-03 | 2025-06-05 | 0 |
| 15177 | 15177 | 1199 CENTRE ST | 42.331563 | -71.194797 | 50990 | 6 | 2025-06-06 | 2025-06-10 | 0 |
| 17682 | 17682 | 10 DOLPHIN RD | 42.340374 | -71.178593 | 50990 | 7 | 2025-07-25 | 2025-08-11 | 0 |
| 17885 | 17885 | 1050 CHESTNUT ST | 42.313329 | -71.224506 | 50990 | 5 | 2025-07-30 | 2025-08-11 | 0 |
| 19822 | 19822 | 1483 CENTRE ST | 42.324336 | -71.200431 | 50990 | 6 | 2025-09-23 | 2025-09-23 | 0 |
| 20377 | 20377 | 325 LOWELL AVE | 42.346098 | -71.211281 | 50990 | 2 | 2025-10-07 | 1 | |
| 21499 | 21499 | 29 THURSTON RD | 42.315885 | -71.217311 | 50990 | 5 | 2025-11-05 | 2025-11-05 | 0 |
| 22375 | 22375 | 289 PARK ST | 42.34725 | -71.183844 | 50990 | 7 | 2025-11-30 | 2025-12-01 | 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 );