_locations
52 rows where category_id = 53470
This data as json, CSV (advanced)
Suggested facets: ward, active, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 2518 | 2518 | 205 CYPRESS ST | 42.323396 | -71.190091 | 53470 | 6 | 2024-07-13 12:00 | 2024-07-23 | 0 |
| 2893 | 2893 | 12 ROTHERWOOD RD | 42.323488 | -71.199178 | 53470 | 6 | 2024-07-20 15:30 | 2024-07-23 | 0 |
| 3755 | 3755 | 5 ELLIOT STREET | 42.318604 | -71.212558 | 53470 | 5 | 2024-08-06 14:15 | 2024-08-12 | 0 |
| 4290 | 4290 | 15 ROBERTS AVE | 42.3524 | -71.211877 | 53470 | 2 | 2024-08-13 13:00 | 2024-08-13 | 0 |
| 4553 | 4553 | 15 DAVIS STREET | 42.348207 | -71.225529 | 53470 | 3 | 2024-08-18 12:30 | 2024-08-19 | 0 |
| 4700 | 4700 | 194 OAK STREET | 42.307581 | -71.216539 | 53470 | 5 | 2024-08-21 07:45 | 2024-11-01 | 0 |
| 7083 | 7083 | 15 EVERGREEN AVE | 42.344147 | -71.258416 | 53470 | 4 | 2024-10-14 13:15 | 2024-10-16 | 0 |
| 9449 | 9449 | 137 WITHINGTON ROAD | 42.345598 | -71.199104 | 53470 | 2 | 2024-11-04 11:00 | 2024-11-13 | 0 |
| 11721 | 11721 | 18 HAWTHORNE AVE | 42.341422 | -71.244965 | 53470 | 4 | 2024-12-16 08:15 | 2024-12-17 | 0 |
| 11857 | 11857 | 21-23 PEABODY STREET | 42.357372 | -71.187174 | 53470 | 1 | 2024-12-18 12:30 | 2024-12-19 | 0 |
| 12624 | 12624 | 15 WOODBINE TER | 42.346102 | -71.25421 | 53470 | 4 | 2025-01-05 11:00 | 2025-01-06 | 0 |
| 13195 | 13195 | 50 OAK AVENUE | 42.351107 | -71.231765 | 53470 | 3 | 2025-01-15 15:15 | 2025-01-15 | 0 |
| 15098 | 15098 | 350 QUINOBEQUIN RD | 42.321762 | -71.24153 | 53470 | 5 | 2025-02-19 13:00 | 2025-02-24 | 0 |
| 16683 | 16683 | 63 ROSALIE RD | 42.30414 | -71.189109 | 53470 | 8 | 2025-03-22 21:30 | 2025-03-26 | 0 |
| 17316 | 17316 | 58 MORTON STREET | 42.340261 | -71.200703 | 53470 | 2 | 2025-04-04 15:00 | 2025-04-18 | 0 |
| 19268 | 19268 | 295 CYPRESS ST | 42.320889 | -71.188457 | 53470 | 6 | 2025-05-13 08:15 | 2025-05-13 | 0 |
| 19356 | 19356 | 12 GLASTONBURY OVAL | 42.329745 | -71.220582 | 53470 | 5 | 2025-05-14 08:15 | 2025-05-20 | 0 |
| 20304 | 20304 | 50 KILBURN RD | 42.354081 | -71.227229 | 53470 | 3 | 2025-05-30 11:00 | 2025-07-01 | 0 |
| 20341 | 20341 | 60 PARKER TER | 42.312186 | -71.1936 | 53470 | 8 | 2025-05-30 15:30 | 2025-06-02 | 0 |
| 21267 | 21267 | 15 METACOMET ROAD | 42.329272 | -71.239135 | 53470 | 5 | 2025-06-13 07:45 | 2025-06-17 | 0 |
| 21520 | 21520 | 56 SOLON ST | 42.316389 | -71.201628 | 53470 | 5 | 2025-06-17 14:45 | 2025-06-23 | 0 |
| 21990 | 21990 | 23A CHARLESBANK ROAD | 42.358419 | -71.1774 | 53470 | 1 | 2025-06-24 08:15 | 2025-06-27 | 0 |
| 21999 | 21999 | 300 LAKE AVENUE | 42.323589 | -71.205016 | 53470 | 6 | 2025-06-24 09:45 | 2025-06-24 | 0 |
| 22227 | 22227 | 24 SHERIDAN ST | 42.358563 | -71.232804 | 53470 | 3 | 2025-06-26 22:15 | 2025-06-30 | 0 |
| 22335 | 22335 | 25 BALLARD ST | 42.339366 | -71.191539 | 53470 | 7 | 2025-06-30 09:45 | 2025-07-21 | 0 |
| 22622 | 22622 | 107 UPLAND AVE | 42.315399 | -71.20832 | 53470 | 8 | 2025-07-03 11:15 | 2025-07-07 | 0 |
| 22624 | 22624 | 71 HEATHERLAND RD | 42.313707 | -71.208437 | 53470 | 8 | 2025-07-03 11:30 | 2025-07-07 | 0 |
| 23312 | 23312 | 209 COMMONWEALTH AVE | 42.33771 | -71.174376 | 53470 | 7 | 2025-07-15 11:15 | 2025-07-16 | 0 |
| 23490 | 23490 | 102 BOYD ST | 42.360228 | -71.190077 | 53470 | 1 | 2025-07-16 10:45 | 2025-07-23 | 0 |
| 23540 | 23540 | 34 BEECHER TERRACE | 42.320956 | -71.181273 | 53470 | 6 | 2025-07-16 23:45 | 2025-07-23 | 0 |
| 23568 | 23568 | 404 LANGLEY RD | 42.320304 | -71.183093 | 53470 | 6 | 2025-07-17 10:15 | 2025-07-23 | 0 |
| 23713 | 23713 | 31 FAYETTE ST | 42.359796 | -71.192223 | 53470 | 1 | 2025-07-18 20:15 | 2025-07-23 | 0 |
| 24062 | 24062 | 47 PRESCOTT ST | 42.35526 | -71.206142 | 53470 | 2 | 2025-07-24 12:45 | 2025-07-26 | 0 |
| 24081 | 24081 | 205 CYPRESS ST | 42.3234 | -71.19009 | 53470 | 6 | 2025-07-24 16:15 | 2025-07-29 | 0 |
| 24090 | 24090 | 41 ALDERWOOD RD | 42.340203 | -71.190698 | 53470 | 7 | 2025-07-24 19:30 | 2025-08-05 | 0 |
| 24094 | 24094 | 46 ALDERWOOD RD | 42.340518 | -71.190518 | 53470 | 7 | 2025-07-25 07:15 | 2025-08-05 | 0 |
| 24554 | 24554 | 42 GREENOUGH ST | 42.343956 | -71.237934 | 53470 | 4 | 2025-08-03 13:45 | 2025-08-05 | 0 |
| 24847 | 24847 | 18 SKY VIEW CIR | 42.304653 | -71.186252 | 53470 | 8 | 2025-08-07 09:00 | 2025-08-25 | 0 |
| 25449 | 25449 | 36 SKY VIEW CIR | 42.304239 | -71.185545 | 53470 | 8 | 2025-08-20 03:30 | 2025-08-25 | 0 |
| 26251 | 26251 | 23 BLAKE ST | 42.347331 | -71.198802 | 53470 | 2 | 2025-09-05 18:45 | 2025-09-06 | 0 |
| 26737 | 26737 | 21 WHITTLESEY RD | 42.310503 | -71.196566 | 53470 | 8 | 2025-09-15 14:00 | 2025-09-16 | 0 |
| 28677 | 28677 | 19 PHILLIPS LN | 42.34716 | -71.204157 | 53470 | 2 | 2025-10-23 09:00 | 2025-10-25 | 0 |
| 29364 | 29364 | 21 COOLIDGE RD | 42.339339 | -71.187012 | 53470 | 7 | 2025-11-05 10:15 | 2025-11-05 | 0 |
| 30066 | 30066 | 75 BEECHER PL | 42.322509 | -71.181252 | 53470 | 6 | 2025-11-19 08:45 | 2025-11-19 | 0 |
| 30069 | 30069 | 368 LANGLEY RD | 42.321501 | -71.18375 | 53470 | 6 | 2025-11-19 09:00 | 2025-11-19 | 0 |
| 30073 | 30073 | 83 BEECHER PL | 42.322374 | -71.180928 | 53470 | 6 | 2025-11-19 09:15 | 2025-11-19 | 0 |
| 30091 | 30091 | 39 BEECHER PL | 42.321852 | -71.182539 | 53470 | 6 | 2025-11-19 12:45 | 2025-11-19 | 0 |
| 30374 | 30374 | 81 BEECHER PLACE | 42.322417 | -71.181002 | 53470 | 6 | 2025-11-25 09:15 | 2025-11-28 | 0 |
| 30380 | 30380 | 75 BEECHER PL | 42.322509 | -71.181252 | 53470 | 6 | 2025-11-25 09:45 | 2025-11-28 | 0 |
| 31264 | 31264 | 77 CLOVERDALE RD | 42.319665 | -71.20053 | 53470 | 6 | 2025-12-16 10:00 | 2025-12-17 | 0 |
| 31397 | 31397 | 11 WAYNE RD | 42.302673 | -71.171991 | 53470 | 8 | 2025-12-18 10:30 | 1 | |
| 31539 | 31539 | 154 ALLERTON RD | 42.323634 | -71.202168 | 53470 | 6 | 2025-12-19 14:00 | 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 );