_locations
185 rows where category_id = 53460
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 |
|---|---|---|---|---|---|---|---|---|---|
| 420 | 420 | 11 MAPLE AVE | 42.354124 | -71.188672 | 53460 | 1 | 2024-06-18 | 0 | |
| 421 | 421 | 132 BELLEVUE ST | 42.351787 | -71.192116 | 53460 | 1 | 2024-06-18 | 0 | |
| 422 | 422 | 14 BACON ST | 42.357773 | -71.186182 | 53460 | 1 | 2024-06-18 | 0 | |
| 423 | 423 | 17 LEIGHTON ROAD | 42.34198 | -71.252931 | 53460 | 4 | 2024-06-18 | 0 | |
| 424 | 424 | 21 BACON PLACE | 42.31863 | -71.220419 | 53460 | 5 | 2024-06-18 | 0 | |
| 425 | 425 | 219 COMMONWEALTH AVE | 42.337794 | -71.174838 | 53460 | 7 | 2024-10-01 | 0 | |
| 426 | 426 | 230 UPLAND AVE | 42.31149 | -71.206664 | 53460 | 8 | 2024-06-18 | 0 | |
| 427 | 427 | 37 GAY ST | 42.346702 | -71.203136 | 53460 | 2 | 2024-06-18 | 0 | |
| 428 | 428 | 395 WINCHESTER ST | 42.306855 | -71.2062 | 53460 | 8 | 2024-06-18 | 0 | |
| 429 | 429 | 50 GRACE RD | 42.29804 | -71.176268 | 53460 | 8 | 2024-06-18 | 0 | |
| 430 | 430 | 92 MANET RD | 42.33605 | -71.175815 | 53460 | 7 | 2024-06-18 | 0 | |
| 782 | 782 | 15 OMAR TER | 42.353951 | -71.207276 | 53460 | 2 | 2024-06-20 | 2024-06-24 | 0 |
| 1321 | 1321 | 18 DUNSTAN ST | 42.350246 | -71.222113 | 53460 | 3 | 2024-06-24 | 2024-07-02 | 0 |
| 1478 | 1478 | 38 WHITE OAK RD | 42.327569 | -71.244278 | 53460 | 5 | 2024-06-26 | 2024-07-02 | 0 |
| 1571 | 1571 | 46 TAMWORTH RD | 42.320799 | -71.227276 | 53460 | 5 | 2024-06-27 | 2024-10-01 | 0 |
| 1654 | 1654 | 144 WALNUT STREET | 42.354851 | -71.208535 | 53460 | 2 | 2024-06-27 19:15 | 2024-09-23 | 0 |
| 1920 | 1920 | 149 WARREN ST | 42.329524 | -71.188808 | 53460 | 6 | 2024-07-03 08:30 | 2024-07-10 | 0 |
| 1968 | 1968 | 148 WARREN ST | 42.329439 | -71.18887 | 53460 | 6 | 2024-07-03 16:45 | 2024-09-23 | 0 |
| 1996 | 1996 | 53 ANDREW ST | 42.313575 | -71.205642 | 53460 | 8 | 2024-07-05 08:45 | 2024-07-17 | 0 |
| 2166 | 2166 | 157 HERRICK RD | 42.325583 | -71.191019 | 53460 | 6 | 2024-07-08 13:30 | 2024-07-24 | 0 |
| 2194 | 2194 | 119 CHARLESBANK RD | 42.359099 | -71.181491 | 53460 | 1 | 2024-07-08 16:00 | 2024-07-22 | 0 |
| 2830 | 2830 | 280 CENTRAL ST | 42.344077 | -71.252061 | 53460 | 4 | 2024-07-18 16:30 | 2024-09-16 | 0 |
| 2935 | 2935 | 131 DANE HILL RD | 42.310924 | -71.20491 | 53460 | 8 | 2024-07-22 10:15 | 2024-08-28 | 0 |
| 3041 | 3041 | 40 MOFFAT RD | 42.331963 | -71.226365 | 53460 | 5 | 2024-07-23 16:15 | 2024-09-16 | 0 |
| 3193 | 3193 | 20 BEAUMONT AVE | 42.343254 | -71.209686 | 53460 | 2 | 2024-07-26 15:15 | 2024-11-04 | 0 |
| 3211 | 3211 | 170 WINCHESTER ST | 42.314207 | -71.208819 | 53460 | 8 | 2024-07-27 17:15 | 2024-09-17 | 0 |
| 3426 | 3426 | 50 ALGONQUIN RD | 42.340839 | -71.170285 | 53460 | 7 | 2024-07-31 12:30 | 2024-09-17 | 0 |
| 3708 | 3708 | 109 VERNON ST | 42.355116 | -71.184487 | 53460 | 1 | 2024-08-06 07:45 | 2024-09-23 | 0 |
| 3709 | 3709 | 41 WOODLAND RD | 42.343893 | -71.251375 | 53460 | 4 | 2024-08-06 08:30 | 2024-09-17 | 0 |
| 4451 | 4451 | 18 DUNSTAN ST | 42.350246 | -71.222113 | 53460 | 3 | 2024-08-15 17:45 | 2024-08-21 | 0 |
| 4534 | 4534 | 1–99 HULL ST | 42.343847 | -71.207427 | 53460 | 2 | 2024-08-16 16:45 | 2024-08-21 | 0 |
| 4624 | 4624 | 39 SCOTNEY RD | 42.302503 | -71.175245 | 53460 | 8 | 2024-08-19 17:00 | 2024-09-13 | 0 |
| 5084 | 5084 | WINSTON RD | 42.309239 | -71.188628 | 53460 | 8 | 2024-08-28 17:15 | 2024-09-13 | 0 |
| 5100 | 5100 | 53 PAUL ST | 42.326744 | -71.196621 | 53460 | 6 | 2024-08-29 08:45 | 2024-09-13 | 0 |
| 6215 | 6215 | 10 CHAMPA ST | 42.313094 | -71.218208 | 53460 | 5 | 2024-09-23 17:45 | 2025-04-01 | 0 |
| 6216 | 6216 | 37 MORSE RD | 42.342634 | -71.199549 | 53460 | 2 | 2024-09-23 17:45 | 2024-09-25 | 0 |
| 6217 | 6217 | 56 WISWALL RD | 42.296343 | -71.185922 | 53460 | 8 | 2024-09-23 17:45 | 2024-10-22 | 0 |
| 6506 | 6506 | 1004 CENTRE ST | 42.337912 | -71.192733 | 53460 | 7 | 2024-09-27 16:00 | 2024-10-22 | 0 |
| 6778 | 6778 | 150 EASTBOURNE RD | 42.33703 | -71.186672 | 53460 | 7 | 2024-10-07 10:15 | 2024-10-15 | 0 |
| 7163 | 7163 | 133 EASTBOURNE RD | 42.337599 | -71.186904 | 53460 | 7 | 2024-10-15 15:00 | 2024-10-21 | 0 |
| 7232 | 7232 | 21 BACON PL | 42.318645 | -71.220575 | 53460 | 5 | 2024-10-16 16:15 | 2024-10-22 | 0 |
| 8501 | 8501 | 423–425 CRAFTS ST | 42.359771 | -71.216657 | 53460 | 2 | 2024-10-28 12:30 | 2024-11-04 | 0 |
| 9009 | 9009 | 299 MILL ST | 42.343139 | -71.205751 | 53460 | 2 | 2024-10-30 15:15 | 2024-11-05 | 0 |
| 9093 | 9093 | WINSTON RD | 42.309526 | -71.188355 | 53460 | 8 | 2024-10-31 19:00 | 2025-04-08 | 0 |
| 9458 | 9458 | 55 WETHERELL ST | 42.31161 | -71.217344 | 53460 | 5 | 2024-11-04 12:00 | 2025-04-08 | 0 |
| 9819 | 9819 | 31 HOMEWOOD RD | 42.32509 | -71.239863 | 53460 | 5 | 2024-11-07 11:15 | 2024-11-13 | 0 |
| 9945 | 9945 | 133 EASTBOURNE RD | 42.337599 | -71.186904 | 53460 | 7 | 2024-11-08 09:30 | 2025-04-08 | 0 |
| 9955 | 9955 | 11 CURVE ST | 42.346547 | -71.235433 | 53460 | 3 | 2024-11-08 10:15 | 2025-04-08 | 0 |
| 10102 | 10102 | 37 ALGONQUIN RD | 42.34049 | -71.169831 | 53460 | 7 | 2024-11-13 11:00 | 2025-04-08 | 0 |
| 10154 | 10154 | 35 EMERSON ST | 42.358491 | -71.188625 | 53460 | 1 | 2024-11-14 13:45 | 2025-02-25 | 0 |
| 10155 | 10155 | 56 BOYD ST | 42.359626 | -71.188051 | 53460 | 1 | 2024-11-14 13:45 | 2025-04-08 | 0 |
| 10196 | 10196 | 26 R COURT STREET | 42.353539 | -71.201827 | 53460 | 2 | 2024-11-15 14:15 | 2025-04-08 | 0 |
| 10350 | 10350 | 106–108 LAKE AVE | 42.329144 | -71.202054 | 53460 | 6 | 2024-11-20 08:30 | 2025-04-08 | 0 |
| 10394 | 10394 | 62 ALEXANDER RD | 42.315436 | -71.200442 | 53460 | 6 | 2024-11-20 15:30 | 2024-11-27 | 0 |
| 10793 | 10793 | 19 DALBY STREET | 42.364282 | -71.200678 | 53460 | 1 | 2024-11-29 13:00 | 2024-12-12 | 0 |
| 10892 | 10892 | 25 HILLTOP ST | 42.350477 | -71.194501 | 53460 | 1 | 2024-12-02 11:15 | 2024-12-17 | 0 |
| 11026 | 11026 | 9 MOSMAN STREET | 42.361204 | -71.217749 | 53460 | 3 | 2024-12-04 08:45 | 2024-12-05 | 0 |
| 11136 | 11136 | 89 REDWOOD RD | 42.301577 | -71.182729 | 53460 | 8 | 2024-12-06 12:00 | 2025-02-06 | 0 |
| 11266 | 11266 | 4 GEORGE ST | 42.347535 | -71.186285 | 53460 | 7 | 2024-12-09 08:45 | 2024-12-20 | 0 |
| 11301 | 11301 | 50 GRACE RD | 42.29804 | -71.176268 | 53460 | 8 | 2024-12-09 14:30 | 2024-12-17 | 0 |
| 11358 | 11358 | 118 MEADOWBROOK RD | 42.308517 | -71.191596 | 53460 | 8 | 2024-12-10 10:45 | 2025-04-08 | 0 |
| 11370 | 11370 | 26 SUMMIT ST | 42.353065 | -71.190983 | 53460 | 1 | 2024-12-10 12:00 | 2025-04-01 | 0 |
| 11596 | 11596 | 118 LANGDON ST | 42.348318 | -71.194319 | 53460 | 2 | 2024-12-12 14:30 | 2025-04-08 | 0 |
| 11599 | 11599 | 19 DALBY ST | 42.364212 | -71.200789 | 53460 | 1 | 2024-12-12 15:15 | 2025-04-08 | 0 |
| 11628 | 11628 | 175 MILL ST | 42.341709 | -71.200138 | 53460 | 2 | 2024-12-13 09:45 | 2024-12-20 | 0 |
| 11629 | 11629 | 205 MILL ST | 42.342045 | -71.201508 | 53460 | 2 | 2024-12-13 09:45 | 2024-12-20 | 0 |
| 12351 | 12351 | 11 CLIFF RD | 42.311856 | -71.22017 | 53460 | 5 | 2024-12-30 10:00 | 2025-04-01 | 0 |
| 12360 | 12360 | 6 ISLINGTON RD | 42.347494 | -71.25354 | 53460 | 4 | 2024-12-30 11:30 | 2025-04-08 | 0 |
| 12462 | 12462 | 175 MILL ST | 42.341709 | -71.200138 | 53460 | 2 | 2024-12-31 15:30 | 2025-04-08 | 0 |
| 12463 | 12463 | 219 MILL ST | 42.342194 | -71.202095 | 53460 | 2 | 2024-12-31 15:30 | 2025-04-08 | 0 |
| 12698 | 12698 | 14 CLOVERDALE RD | 42.320929 | -71.199621 | 53460 | 6 | 2025-01-06 14:45 | 2025-04-08 | 0 |
| 13000 | 13000 | 135 KIRKSTALL RD | 42.344878 | -71.199742 | 53460 | 2 | 2025-01-10 14:45 | 2025-04-08 | 0 |
| 13001 | 13001 | 195 MILL ST | 42.341928 | -71.201034 | 53460 | 2 | 2025-01-10 14:45 | 2025-04-08 | 0 |
| 13002 | 13002 | 251 MILL ST | 42.34259 | -71.203433 | 53460 | 2 | 2025-01-10 14:45 | 2025-04-08 | 0 |
| 14653 | 14653 | 51 GATE HOUSE RD | 42.332166 | -71.164445 | 53460 | 7 | 2025-02-14 10:30 | 2025-02-21 | 0 |
| 14665 | 14665 | 17 CHAPIN RD | 42.333498 | -71.200413 | 53460 | 6 | 2025-02-14 12:00 | 2025-04-01 | 0 |
| 14747 | 14747 | 96 MADISON AVE | 42.349949 | -71.205816 | 53460 | 2 | 2025-02-16 15:45 | 2025-02-28 | 0 |
| 15005 | 15005 | 532 PARKER ST | 42.309396 | -71.197263 | 53460 | 8 | 2025-02-18 14:45 | 2025-04-08 | 0 |
| 15013 | 15013 | 24 SCRIBNER PARK | 42.352731 | -71.24418 | 53460 | 4 | 2025-02-18 15:15 | 2025-04-08 | 0 |
| 15172 | 15172 | 99 GATE HOUSE RD | 42.330924 | -71.16579 | 53460 | 7 | 2025-02-20 12:45 | 2025-02-21 | 0 |
| 15300 | 15300 | 290 CYPRESS STREET | 42.32088 | -71.187667 | 53460 | 6 | 2025-02-24 09:00 | 2025-05-13 | 0 |
| 15403 | 15403 | 280 CYPRESS ST | 42.321276 | -71.187611 | 53460 | 6 | 2025-02-25 11:30 | 2025-05-13 | 0 |
| 15773 | 15773 | 342 QUINOBEQUIN RD | 42.321735 | -71.241777 | 53460 | 5 | 2025-03-05 12:30 | 2025-04-08 | 0 |
| 15822 | 15822 | 30 WESLEY STREET | 42.353111 | -71.187276 | 53460 | 1 | 2025-03-06 10:15 | 2025-06-02 | 0 |
| 15834 | 15834 | 179 KIRKSTALL RD | 42.3441 | -71.199356 | 53460 | 2 | 2025-03-06 12:15 | 2025-06-02 | 0 |
| 15851 | 15851 | 55 LOTHROP ST | 42.356565 | -71.203959 | 53460 | 1 | 2025-03-06 21:00 | 2025-03-12 | 0 |
| 15883 | 15883 | 191 KIRKSTALL RD | 42.343605 | -71.199576 | 53460 | 2 | 2025-03-07 10:15 | 2025-06-02 | 0 |
| 16194 | 16194 | 129 DORSET RD | 42.329799 | -71.237939 | 53460 | 5 | 2025-03-11 12:00 | 2025-06-02 | 0 |
| 16309 | 16309 | 20 MORSE RD | 42.343407 | -71.199743 | 53460 | 2 | 2025-03-13 10:00 | 2025-06-02 | 0 |
| 16310 | 16310 | 200 MILL ST | 42.341643 | -71.201372 | 53460 | 2 | 2025-03-13 10:00 | 2025-03-13 | 0 |
| 16432 | 16432 | 44 BUSWELL PARK | 42.350157 | -71.183777 | 53460 | 7 | 2025-03-17 09:45 | 2025-03-22 | 0 |
| 16441 | 16441 | 18 DUNSTAN ST | 42.350247 | -71.222112 | 53460 | 3 | 2025-03-17 11:45 | 2025-03-21 | 0 |
| 16445 | 16445 | 34 ADELLA AVE | 42.352326 | -71.22177 | 53460 | 3 | 2025-03-17 12:00 | 2025-03-22 | 0 |
| 16469 | 16469 | 45 FREDERICK ST | 42.346935 | -71.202681 | 53460 | 2 | 2025-03-17 16:15 | 2025-03-22 | 0 |
| 16470 | 16470 | 80 ATWOOD AVE | 42.34572 | -71.202429 | 53460 | 2 | 2025-03-17 16:15 | 2025-03-22 | 0 |
| 16505 | 16505 | 711 BEACON ST | 42.331068 | -71.189888 | 53460 | 6 | 2025-03-18 12:00 | 2025-03-22 | 0 |
| 16604 | 16604 | 64 KIRKSTALL RD | 42.344559 | -71.202866 | 53460 | 2 | 2025-03-20 14:30 | 2025-03-24 | 0 |
| 16701 | 16701 | 1 MALVERN TER | 42.351507 | -71.257523 | 53460 | 4 | 2025-03-24 08:45 | 2025-07-09 | 0 |
| 16739 | 16739 | 17 EDDY ST | 42.352011 | -71.217419 | 53460 | 3 | 2025-03-24 18:45 | 2025-07-09 | 0 |
| 17076 | 17076 | 54 DRUMLIN RD | 42.30603 | -71.180838 | 53460 | 8 | 2025-03-30 20:15 | 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 );