_locations

71 rows where category_id = 50968

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ward, 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
490 490 41 CAPITAL ST 42.3602 -71.195397 50968 1 2024-06-14 2024-06-25 0
620 620 31 MARY ELLEN RD 42.334526 -71.217577 50968 5 2024-06-17 2024-06-25 0
741 741 58 WACHUSETT STREET     50968   2024-06-20   1
830 830 33 RISLEY RD 42.338304 -71.21834 50968 3 2024-06-21 2024-06-25 0
1265 1265 18 NICKERSON RD 42.306388 -71.175095 50968 8 2024-06-24   1
1295 1295 155 TRUMAN RD 42.313469 -71.196991 50968 8 2024-06-24 2024-07-08 0
1480 1480 11 HALCYON RD 42.321975 -71.194799 50968 6 2024-06-26   1
1625 1625 22 CHAMBERLAIN RD 42.347809 -71.174826 50968 7 2024-06-27 14:15 2024-07-24 0
1776 1776 310 WOODWARD ST 42.324405 -71.224154 50968 5 2024-07-01 11:00   1
2147 2147 268 PRINCE ST 42.338635 -71.220938 50968 3 2024-07-08 11:15   1
2408 2408 15 NORWOOD AVE 42.328977 -71.198183 50968 6 2024-07-11 13:45 2024-07-24 0
2493 2493 125 ARNOLD RD 42.305242 -71.191608 50968 8 2024-07-12 14:00   1
2675 2675 153 OLIVER ROAD 42.320194 -71.224628 50968 5 2024-07-16 18:00   1
2714 2714 47 HARVARD ST 42.350648 -71.201703 50968 2 2024-07-17 10:30   1
2964 2964 27 CROSS HILL RD 42.304155 -71.187966 50968 8 2024-07-22 15:15   1
2968 2968 8 CENTRAL AVENUE 42.356175 -71.205981 50968 2 2024-07-22 16:00 2024-07-25 0
2969 2969 18 CYNTHIA RD 42.309316 -71.182871 50968 8 2024-07-22 16:15   1
2977 2977 624 SAW MILL BROOK PKWY 42.291703 -71.184057 50968 8 2024-07-22 17:45 2024-07-25 0
2978 2978 646 SAW MILL BROOK PKWY 42.291235 -71.184803 50968 8 2024-07-22 17:45 2024-07-29 0
3002 3002 73 ROUNDWOOD RD 42.316949 -71.217552 50968 5 2024-07-23 09:15   1
3089 3089 858 WALNUT ST 42.332025 -71.207007 50968 6 2024-07-24 11:15 2024-08-06 0
3114 3114 9 PROCTOR ST 42.353425 -71.211518 50968 2 2024-07-24 19:15   1
3175 3175 6 TROWBRIDGE STREET 42.328539 -71.197978 50968 6 2024-07-26 10:45 2024-07-31 0
3205 3205 62 MARSHALL ST 42.334082 -71.190833 50968 6 2024-07-27 12:00   1
3332 3332 1775 BEACON STREET 42.327159 -71.236709 50968 5 2024-07-30 08:30 2024-08-08 0
3355 3355 99 DEBORAH RD 42.306999 -71.183297 50968 8 2024-07-30 10:30   1
3498 3498 175 CHRISTINA ST 42.304641 -71.209619 50968 8 2024-08-01 14:00   1
3510 3510 396 DEDHAM ST 42.308755 -71.198683 50968 8 2024-08-01 16:30   1
3551 3551 41 OAKMONT RD 42.320282 -71.185927 50968 6 2024-08-02 14:15 2024-08-05 0
3744 3744 19 BROADLAWN PARK 42.303696 -71.16588 50968 8 2024-08-06 12:45   1
3805 3805 90 LAKE AVE 42.329316 -71.201011 50968 6 2024-08-07 12:00   1
3866 3866 72 FERNCROFT RD 42.332813 -71.220967 50968 5 2024-08-08 09:30   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
);