_locations

71 rows where category_id = 50968

✎ View and edit SQL

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
51 51 10 BOLTON RD 42.344958 -71.211422 50968 2     1
52 52 10 DOLPHIN RD 42.340373 -71.178593 50968 7     1
53 53 106 ESTY FARM RD 42.295735 -71.182377 50968 8     1
54 54 11 WAVERLEY AVE 42.354938 -71.178751 50968 1     1
55 55 121 WARD ST 42.338027 -71.1774 50968 7     1
56 56 15 WISWALL RD 42.297649 -71.185388 50968 8   2024-07-24 0
57 57 15-17 PROCTOR STREET 42.353503 -71.211796 50968 2     1
58 58 1548 COMMONWEALTH AVE 42.338781 -71.23012 50968 3     1
59 59 17 CHATHAM RD 42.325489 -71.217541 50968 5     1
60 60 18 WINONA ST 42.350204 -71.250948 50968 4     1
61 61 195 COUNTRY CLUB RD 42.303759 -71.189029 50968 8     1
62 62 20 MANDALAY RD 42.340959 -71.181909 50968 7     1
63 63 20 ROTHERWOOD RD 42.323299 -71.199262 50968 6     1
64 64 211 WEBSTER ST 42.348964 -71.236118 50968 3     1
65 65 2139 COMMONWEALTH AVE 42.348268 -71.249399 50968 4     1
66 66 23 ROTHERWOOD RD 42.323304 -71.19975 50968 6     1
67 67 246 TEMPLE ST 42.339755 -71.23315 50968 3     1
68 68 265 WISWALL RD 42.29135 -71.192558 50968 8     1
69 69 28 EMERSON ST 42.358776 -71.188165 50968 1     1
70 70 30 DRUMLIN RD 42.306523 -71.180453 50968 8     1
71 71 32 SHORNECLIFFE RD 42.349567 -71.176703 50968 7     1
72 72 32-70 85TH ST     50968     2024-06-25 0
73 73 35 WAYNE RD 42.302043 -71.172291 50968 8   2024-08-07 0
74 74 36 BRUCE LN 42.34269 -71.188329 50968 7     1
75 75 37 STRATFORD RD 42.351696 -71.237106 50968 3     1
76 76 423 ALBEMARLE RD 42.353098 -71.214654 50968 3     1
77 77 429 PARKER STREET 42.312669 -71.196234 50968 8     1
78 78 43 CRAFTS STREET 42.354822 -71.200749 50968 1   2024-07-30 0
79 79 450 DEDHAM STREET 42.307815 -71.196881 50968 8     1
80 80 5 COCHITUATE ROAD 42.323256 -71.215036 50968 5     1
81 81 638 BEACON STREET 42.331144 -71.186061 50968 6     1
82 82 70 BOWEN ST 42.334208 -71.195558 50968 6     1
83 83 74 HOMESTEAD ST 42.325296 -71.224442 50968 5   2024-07-18 0
84 84 76 BERKSHIRE RD 42.340564 -71.203177 50968 2     1
85 85 77 HAGEN RD 42.316791 -71.19188 50968 8   2024-07-23 0
86 86 79 KENWOOD AVENUE 42.335411 -71.20159 50968 6     1
87 87 81 LOVETT RD 42.303283 -71.183923 50968 8     1
88 88 84 FAIRMONT AVE 42.350039 -71.191302 50968 1     1
89 89 853 DEDHAM ST 42.297683 -71.184123 50968 8   2024-08-05 0
491 491 41 CAPITAL ST 42.3602 -71.195397 50968 1 2024-06-14 2024-06-25 0
621 621 31 MARY ELLEN RD 42.334526 -71.217577 50968 5 2024-06-17 2024-06-25 0
742 742 58 WACHUSETT STREET     50968   2024-06-20   1
833 833 33 RISLEY RD 42.338304 -71.21834 50968 3 2024-06-21 2024-06-25 0
953 953 18 NICKERSON RD 42.306388 -71.175095 50968 8 2024-06-24   1
975 975 155 TRUMAN RD 42.313469 -71.196991 50968 8 2024-06-24 2024-07-08 0
1105 1105 11 HALCYON RD 42.321975 -71.194799 50968 6 2024-06-26   1
1226 1226 22 CHAMBERLAIN RD 42.347809 -71.174826 50968 7 2024-06-27 2024-07-24 0
1339 1339 310 WOODWARD ST 42.324405 -71.224154 50968 5 2024-07-01   1
1619 1619 268 PRINCE ST 42.338635 -71.220938 50968 3 2024-07-08   1
1804 1804 15 NORWOOD AVE 42.328977 -71.198183 50968 6 2024-07-11 2024-07-24 0
1871 1871 125 ARNOLD RD 42.305242 -71.191608 50968 8 2024-07-12   1
2010 2010 153 OLIVER ROAD 42.320194 -71.224628 50968 5 2024-07-16   1
2043 2043 47 HARVARD ST 42.350648 -71.201703 50968 2 2024-07-17   1
2226 2226 27 CROSS HILL RD 42.304155 -71.187966 50968 8 2024-07-22   1
2230 2230 18 CYNTHIA RD 42.309316 -71.182871 50968 8 2024-07-22   1
2231 2231 8 CENTRAL AVENUE 42.356175 -71.205981 50968 2 2024-07-22 2024-07-25 0
2238 2238 624 SAW MILL BROOK PKWY 42.291703 -71.184057 50968 8 2024-07-22 2024-07-25 0
2239 2239 646 SAW MILL BROOK PKWY 42.291235 -71.184803 50968 8 2024-07-22 2024-07-29 0
2255 2255 73 ROUNDWOOD RD 42.316949 -71.217552 50968 5 2024-07-23   1
2324 2324 858 WALNUT ST 42.332025 -71.207007 50968 6 2024-07-24 2024-08-06 0
2337 2337 9 PROCTOR ST 42.353425 -71.211518 50968 2 2024-07-24   1
2375 2375 6 TROWBRIDGE STREET 42.328539 -71.197978 50968 6 2024-07-26 2024-07-31 0
2396 2396 62 MARSHALL ST 42.334082 -71.190833 50968 6 2024-07-27   1
2493 2493 1775 BEACON STREET 42.327159 -71.236709 50968 5 2024-07-30 2024-08-08 0
2507 2507 99 DEBORAH RD 42.306999 -71.183297 50968 8 2024-07-30   1
2612 2612 175 CHRISTINA ST 42.304641 -71.209619 50968 8 2024-08-01   1
2621 2621 396 DEDHAM ST 42.308755 -71.198683 50968 8 2024-08-01   1
2647 2647 41 OAKMONT RD 42.320282 -71.185927 50968 6 2024-08-02 2024-08-05 0
2780 2780 19 BROADLAWN PARK 42.303696 -71.16588 50968 8 2024-08-06   1
2820 2820 90 LAKE AVE 42.329316 -71.201011 50968 6 2024-08-07   1
2871 2871 72 FERNCROFT RD 42.332813 -71.220967 50968 5 2024-08-08   1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [_locations] (
   [location] TEXT,
   [latitude] FLOAT,
   [longitude] FLOAT,
   [category_id] TEXT REFERENCES [categories]([id]),
   [ward] INTEGER,
   [added] TEXT,
   [removed] TEXT,
   [active] INTEGER
);