home / n311

_locations

100 rows where category_id = 51041

✎ View and edit SQL

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
1109 1109 34 ELDREDGE STREET 42.354689 -71.183467 51041 1   2024-07-18 0
3285 3285 427 CENTRE ST 42.355522 -71.186506 51041 1 2024-07-29 11:30 2024-07-30 0
4299 4299 385 WARD ST 42.338713 -71.188696 51041 7 2024-08-13 15:00 2024-08-20 0
4469 4469 56 VALENTINE ST 42.342206 -71.220317 51041 3 2024-08-16 08:15 2024-08-21 0
4628 4628 130 RACHEL ROAD 42.306386 -71.205659 51041 8 2024-08-19 21:45 2024-08-21 0
4729 4729 2370 COMMONWEALTH AVE 42.344605 -71.258026 51041 4 2024-08-21 12:15 2024-09-24 0
5023 5023 370–390 CALIFORNIA ST 42.365122 -71.204364 51041 1 2024-08-27 19:30 2024-09-04 0
5276 5276 85 CHARLESBANK RD 42.358825 -71.179978 51041 1 2024-09-03 15:30 2024-09-04 0
5824 5824 430 CENTRE STREET 42.355818 -71.185747 51041 1 2024-09-13 18:45 2024-09-23 0
6004 6004 20 LESLIE RD 42.338919 -71.239151 51041 4 2024-09-17 10:45 2024-10-11 0
6184 6184 NEWTON HIGHLANDS PLAYGROUND 42.316342 -71.207266 51041 5 2024-09-23 17:45 2024-10-07 0
6866 6866 299 WATERTOWN ST 42.361179 -71.198638 51041 1 2024-10-08 17:00 2025-05-13 0
7050 7050 300 HAMMOND POND PARKWAY 42.326255 -71.177121 51041 7 2024-10-13 10:30 2024-10-16 0
7589 7589 14 MIDDLESEX RD 42.326282 -71.164929 51041 7 2024-10-18 14:00 2024-11-05 0
7705 7705 78 WINCHESTER STREET 42.317104 -71.207738 51041 5 2024-10-20 11:45 2025-09-22 0
9023 9023 70 CRESCENT ST 42.346683 -71.237767 51041 4 2024-10-30 21:15 2024-11-06 0
9432 9432 70 AUBURN ST 42.344629 -71.237608 51041 4 2024-11-03 21:00 2024-11-06 0
9691 9691 171 PINE ST 42.352196 -71.242018 51041 4 2024-11-05 16:15 2024-11-06 0
9989 9989 20 AUSTIN STREET 42.350403 -71.208199 51041 2 2024-11-09 12:30 2024-11-21 0
10150 10150 78 LAKEWOOD RD 42.326403 -71.206934 51041 6 2024-11-14 11:30   1
10202 10202 549 COMMONWEALTH AVE 42.336519 -71.18913 51041 7 2024-11-15 16:00 2025-08-10 0
10355 10355 28 AUSTIN STREET 42.350665 -71.208267 51041 2 2024-11-20 09:00 2024-11-21 0
10412 10412 557 SAW MILL BROOK PARKWAY 42.293566 -71.182335 51041 8 2024-11-21 08:30 2025-08-13 0
10413 10413 90 OAK HILL STREET 42.297867 -71.180093 51041 8 2024-11-21 08:30 2025-05-29 0
10899 10899 281 BEACON STREET 42.333227 -71.170319 51041 7 2024-12-02 12:30 2024-12-17 0
11052 11052 213 DERBY ST 42.359502 -71.232368 51041 3 2024-12-04 16:45 2024-12-06 0
11192 11192 211 DERBY ST 42.359438 -71.232395 51041 3 2024-12-08 14:30 2024-12-17 0
11354 11354 51 MIDDLESEX ROAD 42.326376 -71.162917 51041 7 2024-12-10 10:00 2025-05-15 0
11598 11598 54 ASH STREET 42.347097 -71.250849 51041 4 2024-12-12 15:15 2024-12-12 0
13205 13205 214 BEACON ST 42.333252 -71.167454 51041 7 2025-01-15 17:45 2025-01-23 0
14610 14610 23 NEWTONVILLE AVENUE 42.352198 -71.187187 51041 1 2025-02-13 15:15   1
15514 15514 1408 WALNUT ST 42.314455 -71.201841 51041 8 2025-02-26 16:30 2025-05-19 0
16232 16232 20 HARVARD ST 42.351885 -71.201691 51041 2 2025-03-11 16:45   1
16587 16587 20 HAWTHORN ST 42.358851 -71.202447 51041 1 2025-03-20 11:00 2025-03-26 0
17075 17075 381 DUDLEY RD 42.308631 -71.181774 51041 8 2025-03-30 20:15   1
17916 17916 60 MIDDLESEX RD 42.326757 -71.162681 51041 7 2025-04-16 12:15 2025-04-16 0
18179 18179 1269 CENTRE ST 42.330186 -71.195036 51041 6 2025-04-23 10:00 2025-04-23 0
18514 18514 291 WALNUT ST 42.350922 -71.20728 51041 2 2025-04-29 10:30 2025-09-04 0
18703 18703 342 BEACON ST 42.332589 -71.173238 51041 7 2025-05-02 11:15 2025-05-05 0
19133 19133 416 LANGLEY RD 42.319881 -71.183232 51041 6 2025-05-09 13:45 2025-05-12 0
19489 19489 91 OAK HILL ST 42.298146 -71.18024 51041 8 2025-05-16 11:30 2025-05-16 0
19710 19710 258 HAMMOND ST 42.332337 -71.171627 51041 7 2025-05-20 13:30 2025-05-20 0
19985 19985 1075 CENTRE STREET 42.335479 -71.193493 51041 6 2025-05-25 10:00 2025-07-16 0
20092 20092 173 JACKSON RD 42.357087 -71.195657 51041 1 2025-05-28 04:30 2025-05-28 0
20093 20093 893 WALNUT ST 42.330645 -71.207123 51041 6 2025-05-28 05:00 2025-05-28 0
20094 20094 94 WINCHESTER ST 42.316785 -71.208648 51041 5 2025-05-28 05:00 2025-05-28 0
20407 20407 970 BEACON ST 42.33042 -71.201511 51041 6 2025-06-02 04:45   1
20517 20517 232 BROOKLINE ST 42.30261 -71.176955 51041 8 2025-06-03 06:45   1
20521 20521 198 GREENWOOD ST 42.306561 -71.187944 51041 8 2025-06-03 07:15   1
20522 20522 53 VERNON ST 42.35445 -71.181734 51041 1 2025-06-03 07:15 2025-06-04 0
20610 20610 543 HAMMOND ST 42.32493 -71.165498 51041 7 2025-06-04 04:30   1
20865 20865 1766 WASHINGTON ST 42.338781 -71.239919 51041 4 2025-06-06 16:15   1
20866 20866 69 DAY ST 42.338223 -71.238141 51041 4 2025-06-06 16:15   1
20927 20927 41 ADAMS ST 42.362127 -71.205399 51041 1 2025-06-09 07:30   1
21022 21022 288 LEXINGTON ST 42.352119 -71.245557 51041 4 2025-06-10 05:30   1
21082 21082 1615 BEACON ST 42.327261 -71.230235 51041 5 2025-06-11 04:45   1
21083 21083 47 WOODWARD ST 42.320232 -71.213427 51041 6 2025-06-11 04:45   1
21084 21084 237 ADAMS ST 42.35724 -71.19891 51041 1 2025-06-11 05:00   1
21295 21295 287 CENTRE ST 42.35814 -71.185023 51041 1 2025-06-13 14:00   1
21297 21297 457 WALNUT ST 42.345126 -71.207613 51041 2 2025-06-13 14:15 2025-06-18 0
21377 21377 44 CAPITAL ST 42.360453 -71.195234 51041 1 2025-06-16 10:15   1
21557 21557 137 LAKE AVE 42.328278 -71.203167 51041 6 2025-06-18 06:00   1
21558 21558 3 MORELAND AVE 42.3288 -71.202722 51041 6 2025-06-18 06:00   1
21559 21559 50 LAKE AVE 42.329556 -71.199297 51041 6 2025-06-18 06:00   1
21560 21560 57 LAKE AVE 42.329916 -71.199855 51041 6 2025-06-18 06:00   1
21561 21561 90 LAKE AVE 42.329313 -71.201012 51041 6 2025-06-18 06:00   1
21568 21568 770 BEACON ST 42.330249 -71.19225 51041 6 2025-06-18 06:15   1
21674 21674 138 LAKE AVE 42.328152 -71.20251 51041 6 2025-06-19 16:15   1
21675 21675 255 WASHINGTON ST 42.357771 -71.183844 51041 1 2025-06-19 16:30   1
21875 21875 61 WASHBURN AVE 42.351498 -71.242781 51041 4 2025-06-23 07:15   1
21941 21941 191 MILL STREET 42.341704 -71.200907 51041 2 2025-06-23 16:15   1
21945 21945 431 WASHINGTON ST 42.356043 -71.190423 51041 1 2025-06-23 17:00 2025-07-01 0
22342 22342 761 WALNUT STREET 42.335328 -71.20905 51041 2 2025-06-30 10:30   1
22487 22487 119 ADAMS ST 42.360273 -71.202893 51041 1 2025-07-02 07:15   1
22805 22805 70 RIVER ST 42.352119 -71.229317 51041 3 2025-07-08 09:00   1
22831 22831 457 WALNUT ST 42.345126 -71.207613 51041 2 2025-07-08 12:00 2025-09-16 0
22881 22881 1085 CENTRE ST 42.335127 -71.193632 51041 6 2025-07-09 04:30   1
22882 22882 650 COMMONWEALTH AVE 42.335631 -71.193749 51041 6 2025-07-09 04:30   1
22989 22989 1243 WALNUT STREET 42.319512 -71.204436 51041 6 2025-07-09 16:00   1
23081 23081 233 COMMONWEALTH AVE 42.337539 -71.175704 51041 7 2025-07-11 08:45   1
23716 23716 233 JACKSON RD 42.35526 -71.195459 51041 1 2025-07-19 12:45   1
23780 23780 171 PEARL ST 42.359256 -71.193245 51041 1 2025-07-21 10:30   1
24032 24032 5 HAMMOND ST 42.337845 -71.178696 51041 7 2025-07-24 08:45   1
24157 24157 53 HOBART ROAD 42.332188 -71.181257 51041 7 2025-07-25 22:00   1
24988 24988 108 FULLER STREET 42.335475 -71.223737 51041 5 2025-08-11 13:45   1
25309 25309 887 CHESTNUT ST 42.318846 -71.226356 51041 5 2025-08-15 20:45   1
25427 25427 200 HAMMOND ST 42.333543 -71.173202 51041 7 2025-08-19 12:45   1
25428 25428 325 BEACON ST 42.333273 -71.171924 51041 7 2025-08-19 12:45   1
25868 25868 191 COLLEGE ROAD 42.337168 -71.172143 51041 7 2025-08-28 17:15   1
26050 26050 330 HOMER ST 42.336045 -71.207843 51041 2 2025-09-03 09:45   1
26051 26051 680 WALNUT ST 42.338106 -71.20661 51041 2 2025-09-03 09:45 2025-09-05 0
28705 28705 1299 CENTRE ST 42.329583 -71.19536 51041 6 2025-10-23 20:00   1
29100 29100 418 LANGLEY ROAD 42.319909 -71.182786 51041 6 2025-10-31 13:45   1
29360 29360 2 WELLS AVE 42.295185 -71.20184 51041 8 2025-11-05 10:15   1
29687 29687 566 GROVE ST 42.329655 -71.257959 51041 4 2025-11-12 08:30   1
29736 29736 1063 COMMONWEALTH AVE 42.338304 -71.21043 51041 2 2025-11-12 17:30   1
30168 30168 305 CENTRE ST 42.357888 -71.184929 51041 1 2025-11-20 16:15   1
30308 30308 154 WASHINGTON STREET 42.355993 -71.180307 51041 1 2025-11-24 13:45   1
31655 31655 28 DAY ST 42.339411 -71.237696 51041 4 2025-12-22 14:15 2025-12-22 0
31743 31743 76 CRESCENT ST 42.346431 -71.237709 51041 3 2025-12-23 17: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
);
Powered by Datasette · Queries took 702.413ms