_locations
577 rows where category_id = 51028
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 |
|---|---|---|---|---|---|---|---|---|---|
| 732 | 732 | 10 PILLION CT | 42.352141 | -71.197894 | 51028 | 2 | 2024-06-19 | 2024-06-20 | 0 |
| 1333 | 1333 | 423 ALBEMARLE RD | 42.353098 | -71.214654 | 51028 | 3 | 2024-06-24 | 2024-06-26 | 0 |
| 1489 | 1489 | 117 WARREN ST | 42.329467 | -71.187235 | 51028 | 6 | 2024-06-26 | 2024-06-26 | 0 |
| 1539 | 1539 | 8 OAKLAND AVE | 42.343732 | -71.259335 | 51028 | 4 | 2024-06-26 | 2024-06-26 | 0 |
| 1598 | 1598 | 64 OAKLAND AVENUE | 42.342053 | -71.260591 | 51028 | 4 | 2024-06-27 10:45 | 2024-06-27 | 0 |
| 1719 | 1719 | 145 NEVADA STREET | 42.362541 | -71.211818 | 51028 | 2 | 2024-06-29 07:45 | 2024-07-01 | 0 |
| 1741 | 1741 | 536 WALNUT STREET | 42.342846 | -71.20581 | 51028 | 2 | 2024-06-30 17:45 | 2024-07-01 | 0 |
| 1858 | 1858 | 56 CRESCENT AVE | 42.329643 | -71.197661 | 51028 | 6 | 2024-07-02 13:00 | 2024-07-02 | 0 |
| 1934 | 1934 | 15 JACKSON STREET | 42.319494 | -71.182922 | 51028 | 6 | 2024-07-03 09:45 | 2024-08-12 | 0 |
| 1972 | 1972 | 93 PARKER AVE | 42.317799 | -71.19912 | 51028 | 6 | 2024-07-03 21:00 | 2024-07-05 | 0 |
| 1976 | 1976 | 1272 BEACON STREET | 42.330788 | -71.215412 | 51028 | 6 | 2024-07-04 09:45 | 2024-07-05 | 0 |
| 2205 | 2205 | 25 PARKER STREET | 42.32635 | -71.193911 | 51028 | 6 | 2024-07-09 06:15 | 2024-08-28 | 0 |
| 2765 | 2765 | 199 CHURCH ST | 42.354575 | -71.187697 | 51028 | 1 | 2024-07-18 08:00 | 2024-07-18 | 0 |
| 3137 | 3137 | 10 MAYFLOWER TER | 42.32137 | -71.220726 | 51028 | 5 | 2024-07-25 13:15 | 2024-07-25 | 0 |
| 3460 | 3460 | 252 KENRICK STREET | 42.346557 | -71.173516 | 51028 | 7 | 2024-07-31 19:15 | 2024-08-01 | 0 |
| 3884 | 3884 | 71 PUTNAM ST | 42.345529 | -71.227543 | 51028 | 3 | 2024-08-08 10:00 | 2024-08-08 | 0 |
| 4121 | 4121 | 24 KODAYA RD | 42.321414 | -71.224891 | 51028 | 5 | 2024-08-10 17:45 | 2024-08-12 | 0 |
| 4154 | 4154 | 180 NEEDHAM ST | 42.311623 | -71.213079 | 51028 | 8 | 2024-08-12 08:45 | 2024-08-14 | 0 |
| 4311 | 4311 | 145 WARREN ST | 42.329604 | -71.188438 | 51028 | 6 | 2024-08-13 19:30 | 2024-08-14 | 0 |
| 4462 | 4462 | 58 GREEN ST | 42.35839 | -71.197778 | 51028 | 1 | 2024-08-15 22:15 | 2024-08-16 | 0 |
| 4540 | 4540 | 93 MADISON AVENUE | 42.350067 | -71.205747 | 51028 | 2 | 2024-08-16 21:45 | 2024-08-19 | 0 |
| 4561 | 4561 | 140 DEDHAM ST | 42.314761 | -71.202851 | 51028 | 5 | 2024-08-19 08:30 | 2024-08-20 | 0 |
| 4764 | 4764 | 137 ALLEN AVE | 42.325891 | -71.221269 | 51028 | 5 | 2024-08-22 08:30 | 2024-08-22 | 0 |
| 4795 | 4795 | 137 EAST QUINOBEQUIN ROAD | 42.324272 | -71.248167 | 51028 | 5 | 2024-08-22 13:45 | 2024-08-28 | 0 |
| 4799 | 4799 | 33 BOYLSTON ST | 42.322666 | -71.168694 | 51028 | 7 | 2024-08-22 14:45 | 2024-08-22 | 0 |
| 4920 | 4920 | 18 UPHAM ST | 42.354387 | -71.229691 | 51028 | 3 | 2024-08-26 13:30 | 2024-08-26 | 0 |
| 4945 | 4945 | 268 MELROSE ST | 42.347353 | -71.248644 | 51028 | 4 | 2024-08-26 17:00 | 2024-08-27 | 0 |
| 5208 | 5208 | 16 ALBA CIR | 42.348467 | -71.183782 | 51028 | 7 | 2024-09-02 19:45 | 2024-09-03 | 0 |
| 5532 | 5532 | 19 LAUREL AVE | 42.360941 | -71.235718 | 51028 | 3 | 2024-09-09 14:45 | 2024-09-09 | 0 |
| 5547 | 5547 | NEWTON FREE LIBRARY | 42.336042 | -71.207844 | 51028 | 2 | 2024-09-09 15:45 | 1 | |
| 5765 | 5765 | 25 OAK TERRACE | 42.321749 | -71.213513 | 51028 | 5 | 2024-09-13 07:15 | 2024-09-13 | 0 |
| 5825 | 5825 | 10 MURPHY CT | 42.357825 | -71.199898 | 51028 | 1 | 2024-09-13 21:15 | 2024-09-16 | 0 |
| 6057 | 6057 | 127 WITHINGTON RD | 42.345908 | -71.199204 | 51028 | 2 | 2024-09-23 17:45 | 2025-01-21 | 0 |
| 6058 | 6058 | 99 NEEDHAM STREET | 42.313986 | -71.213261 | 51028 | 5 | 2024-09-23 17:45 | 2024-10-03 | 0 |
| 6228 | 6228 | 112 LOUISE RD | 42.314896 | -71.178441 | 51028 | 8 | 2024-09-24 01:30 | 2024-09-24 | 0 |
| 6276 | 6276 | 1139 BEACON ST | 42.331202 | -71.209293 | 51028 | 6 | 2024-09-24 09:45 | 2024-12-16 | 0 |
| 6353 | 6353 | 265 WISWALL RD | 42.29135 | -71.192558 | 51028 | 8 | 2024-09-25 10:30 | 2024-10-08 | 0 |
| 6453 | 6453 | 16 BRAELAND AVE | 42.329407 | -71.191492 | 51028 | 6 | 2024-09-26 15:00 | 2024-10-09 | 0 |
| 6524 | 6524 | 111 HYDE ST | 42.32302 | -71.203894 | 51028 | 6 | 2024-09-28 20:00 | 2024-10-02 | 0 |
| 6660 | 6660 | 455 NAHANTON ST | 42.298349 | -71.208303 | 51028 | 8 | 2024-10-02 15:30 | 2024-10-02 | 0 |
| 6673 | 6673 | 100 DEVONSHIRE RD | 42.322033 | -71.230072 | 51028 | 5 | 2024-10-03 09:15 | 2024-10-03 | 0 |
| 6682 | 6682 | 2226 COMMONWEALTH AVE | 42.346928 | -71.253006 | 51028 | 4 | 2024-10-03 10:30 | 1 | |
| 6759 | 6759 | 479 NAHANTON STREET | 42.297336 | -71.207226 | 51028 | 8 | 2024-10-05 16:30 | 2024-10-07 | 0 |
| 6761 | 6761 | 330 HOMER STREET | 42.335732 | -71.208443 | 51028 | 2 | 2024-10-05 19:15 | 2024-10-07 | 0 |
| 7168 | 7168 | 6 LEONARD AVENUE | 42.34532 | -71.214886 | 51028 | 2 | 2024-10-15 16:30 | 2024-10-24 | 0 |
| 7273 | 7273 | 48 LITTLEFIELD RD | 42.309541 | -71.187617 | 51028 | 8 | 2024-10-17 12:00 | 1 | |
| 7521 | 7521 | 570 AUBURN ST | 42.344182 | -71.257176 | 51028 | 4 | 2024-10-18 11:15 | 1 | |
| 7522 | 7522 | 119 LANGDON ST | 42.348426 | -71.194749 | 51028 | 2 | 2024-10-18 11:15 | 2024-10-18 | 0 |
| 7562 | 7562 | 175 WAVERLEY AVE | 42.349831 | -71.180543 | 51028 | 7 | 2024-10-18 12:15 | 1 | |
| 8206 | 8206 | 178 BOYLSTON STREET | 42.320416 | -71.175747 | 51028 | 7 | 2024-10-24 08:00 | 2024-11-12 | 0 |
| 8376 | 8376 | 116 CHURCH ST | 42.353123 | -71.184532 | 51028 | 1 | 2024-10-25 11:15 | 1 | |
| 8571 | 8571 | 780 BEACON ST | 42.330192 | -71.192872 | 51028 | 6 | 2024-10-28 16:00 | 2024-11-01 | 0 |
| 8635 | 8635 | 243 ISLINGTON RD | 42.351596 | -71.256684 | 51028 | 4 | 2024-10-29 09:15 | 2025-02-14 | 0 |
| 8770 | 8770 | 42 WINDERMERE RD | 42.343047 | -71.23859 | 51028 | 4 | 2024-10-29 16:45 | 2024-10-30 | 0 |
| 8780 | 8780 | 2 DUNCKLEE STREET | 42.325201 | -71.20879 | 51028 | 6 | 2024-10-29 23:45 | 2024-10-30 | 0 |
| 9438 | 9438 | 15 ISLINGTON ROAD | 42.347477 | -71.252909 | 51028 | 4 | 2024-11-04 08:45 | 2024-11-04 | 0 |
| 9538 | 9538 | 125 WABAN ST | 42.358672 | -71.193785 | 51028 | 1 | 2024-11-05 07:45 | 2024-11-05 | 0 |
| 9681 | 9681 | 209 COUNTRY CLUB RD | 42.303246 | -71.189184 | 51028 | 8 | 2024-11-05 16:00 | 2024-11-05 | 0 |
| 9988 | 9988 | 111 COURT STREET | 42.353154 | -71.205745 | 51028 | 2 | 2024-11-09 10:00 | 2024-11-12 | 0 |
| 10069 | 10069 | 29 LINDEN STREET | 42.311761 | -71.219789 | 51028 | 5 | 2024-11-12 17:30 | 2024-12-17 | 0 |
| 10170 | 10170 | 31 BORDER STREET | 42.348833 | -71.230597 | 51028 | 3 | 2024-11-15 09:00 | 2024-11-22 | 0 |
| 10190 | 10190 | 72 HIGH STREET | 42.31478 | -71.223754 | 51028 | 5 | 2024-11-15 13:30 | 2024-11-15 | 0 |
| 10715 | 10715 | 9 LILL AVE | 42.355463 | -71.236665 | 51028 | 4 | 2024-11-26 13:45 | 2024-11-26 | 0 |
| 10787 | 10787 | 19 DALBY STREET | 42.364282 | -71.200678 | 51028 | 1 | 2024-11-29 10:45 | 2024-11-29 | 0 |
| 10807 | 10807 | 69 TYLER TERRACE | 42.333195 | -71.196658 | 51028 | 6 | 2024-11-30 11:15 | 2024-12-12 | 0 |
| 11175 | 11175 | 265 UPLAND AVE | 42.310156 | -71.206392 | 51028 | 8 | 2024-12-06 16:15 | 1 | |
| 11187 | 11187 | 47 NEWTONVILLE AVE | 42.35265 | -71.188001 | 51028 | 1 | 2024-12-07 16:45 | 2025-04-08 | 0 |
| 11340 | 11340 | 137 COMMONWEALTH AVE | 42.337937 | -71.172044 | 51028 | 7 | 2024-12-10 08:30 | 2024-12-10 | 0 |
| 11408 | 11408 | 66 ROOSEVELT RD | 42.313976 | -71.192553 | 51028 | 8 | 2024-12-10 14:30 | 2025-03-31 | 0 |
| 11575 | 11575 | 345 WALNUT PL | 42.349169 | -71.207161 | 51028 | 2 | 2024-12-12 10:45 | 2024-12-31 | 0 |
| 11602 | 11602 | 497 AUBURN STREET | 42.345119 | -71.253568 | 51028 | 4 | 2024-12-12 19:15 | 2024-12-19 | 0 |
| 11653 | 11653 | 54 CHARLESBANK RD | 42.35835 | -71.178619 | 51028 | 1 | 2024-12-13 14:45 | 2025-01-15 | 0 |
| 11672 | 11672 | 298 LEXINGTON ST | 42.351791 | -71.245758 | 51028 | 4 | 2024-12-14 16:45 | 1 | |
| 11673 | 11673 | 40 CHINIAN PATH | 42.292019 | -71.189915 | 51028 | 8 | 2024-12-14 20:30 | 2025-04-29 | 0 |
| 11683 | 11683 | 8 CHANDLER PL | 42.313614 | -71.214925 | 51028 | 5 | 2024-12-16 04:00 | 2024-12-27 | 0 |
| 11809 | 11809 | 1 COBB PL | 42.323246 | -71.245712 | 51028 | 5 | 2024-12-17 13:15 | 2024-12-27 | 0 |
| 11843 | 11843 | 30 NOD HILL RD | 42.30927 | -71.205194 | 51028 | 8 | 2024-12-18 09:30 | 2024-12-18 | 0 |
| 11990 | 11990 | 5 BROKEN TREE RD | 42.29722 | -71.182073 | 51028 | 8 | 2024-12-21 09:30 | 2025-01-16 | 0 |
| 12354 | 12354 | 26 ROCHESTER RD | 42.345446 | -71.195103 | 51028 | 2 | 2024-12-30 10:30 | 2024-12-30 | 0 |
| 12438 | 12438 | 67 PEARL STREET | 42.358332 | -71.188268 | 51028 | 1 | 2024-12-31 10:15 | 2024-12-31 | 0 |
| 12565 | 12565 | 1661 CENTRE ST | 42.320013 | -71.20613 | 51028 | 6 | 2025-01-02 20:45 | 2025-01-03 | 0 |
| 12958 | 12958 | 1338 COMMONWEALTH AVE | 42.336531 | -71.22135 | 51028 | 3 | 2025-01-09 20:15 | 2025-01-10 | 0 |
| 13132 | 13132 | 17 CALDON PATH | 42.292268 | -71.186661 | 51028 | 8 | 2025-01-14 13:30 | 2025-01-14 | 0 |
| 13231 | 13231 | 60 WOODBINE STREET | 42.346431 | -71.253939 | 51028 | 4 | 2025-01-16 10:45 | 2025-01-16 | 0 |
| 13340 | 13340 | 50 PINE ST | 42.354135 | -71.237034 | 51028 | 3 | 2025-01-20 08:00 | 2025-01-20 | 0 |
| 13341 | 13341 | 30 BEETHOVEN AVE | 42.329682 | -71.217707 | 51028 | 5 | 2025-01-20 08:30 | 2025-01-20 | 0 |
| 13470 | 13470 | 35 COLGATE RD | 42.328575 | -71.257491 | 51028 | 4 | 2025-01-22 07:45 | 2025-01-22 | 0 |
| 13635 | 13635 | 43 CARLETON ST | 42.359067 | -71.1873 | 51028 | 1 | 2025-01-24 09:00 | 2025-01-24 | 0 |
| 14257 | 14257 | 367 CALIFORNIA ST | 42.36534 | -71.203955 | 51028 | 1 | 2025-02-06 13:00 | 2025-02-06 | 0 |
| 14324 | 14324 | 19 KIRKSTALL RD | 42.343947 | -71.205017 | 51028 | 2 | 2025-02-08 11:30 | 2025-02-09 | 0 |
| 14379 | 14379 | 43 GRAYSON LN | 42.326838 | -71.263508 | 51028 | 4 | 2025-02-09 21:30 | 2025-02-10 | 0 |
| 14559 | 14559 | 61 BRUSH HILL RD | 42.310602 | -71.205872 | 51028 | 8 | 2025-02-12 11:45 | 2025-02-13 | 0 |
| 14626 | 14626 | 105 PEARL ST | 42.358599 | -71.19 | 51028 | 1 | 2025-02-13 21:15 | 2025-02-14 | 0 |
| 14760 | 14760 | 382 WOLCOTT ST | 42.34815 | -71.243244 | 51028 | 4 | 2025-02-16 21:30 | 2025-02-18 | 0 |
| 14962 | 14962 | 2077 WASHINGTON ST | 42.330321 | -71.248617 | 51028 | 4 | 2025-02-18 12:00 | 2025-02-20 | 0 |
| 15262 | 15262 | 18 BACON ST | 42.357726 | -71.186085 | 51028 | 1 | 2025-02-22 03:45 | 2025-02-24 | 0 |
| 15264 | 15264 | 340 WALNUT ST | 42.34941 | -71.206682 | 51028 | 2 | 2025-02-22 12:30 | 2025-02-24 | 0 |
| 15632 | 15632 | 89 REDWOOD RD | 42.301575 | -71.182728 | 51028 | 8 | 2025-03-01 12:15 | 2025-03-03 | 0 |
| 15666 | 15666 | 266 NEWTONVILLE AVE | 42.352362 | -71.197943 | 51028 | 2 | 2025-03-03 10:30 | 2025-03-04 | 0 |
| 15700 | 15700 | 137 FRANKLIN ST | 42.349149 | -71.177846 | 51028 | 7 | 2025-03-04 09:30 | 2025-03-15 | 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 );