home / n311

_locations

142 rows where category_id = 51148

✎ 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
1114 1114 1265 WALNUT STREET 42.319159 -71.204013 51148 5   2024-06-26 0
1115 1115 257 WALTHAM STREET 42.358213 -71.222884 51148 3   2024-07-01 0
1116 1116 372 WALTHAM STREET 42.354495 -71.223874 51148 3   2024-07-01 0
1117 1117 449 WALTHAM STREET 42.35224 -71.225514 51148 3   2024-07-01 0
1236 1236 215 WINCHESTER ST 42.31263 -71.209513 51148 8 2024-06-23 2024-06-25 0
1547 1547 1600 WASHINGTON ST 42.343213 -71.23556 51148 3 2024-06-26 2024-06-27 0
1749 1749 1412 WALNUT STREET 42.314197 -71.201808 51148 8 2024-07-01 00:45 2024-07-11 0
1750 1750 300 DEDHAM STREET 42.310008 -71.202773 51148 8 2024-07-01 00:45 2024-07-01 0
1807 1807 955 BOYLSTON STREET 42.319603 -71.210723 51148 6 2024-07-01 16:30 2024-07-09 0
1819 1819 109 WALNUT STREET 42.355929 -71.209082 51148 2 2024-07-02 02:15 2024-07-02 0
2080 2080 848 BEACON ST 42.329867 -71.195742 51148 6 2024-07-08 01:00 2024-07-08 0
2179 2179 5 BEMIS RD 42.363405 -71.208537 51148 1 2024-07-08 15:30 2024-07-09 0
2290 2290 323 WASHINGTON STREET 42.356964 -71.186798 51148 1 2024-07-10 02:45 2024-07-10 0
2438 2438 163 CYPRESS ST 42.324494 -71.191339 51148 6 2024-07-11 16:15 2024-07-19 0
2663 2663 13 WILTSHIRE RD 42.356328 -71.196664 51148 1 2024-07-16 15:45 2024-07-17 0
2903 2903 10 DARTMOUTH ST 42.339088 -71.225074 51148 3 2024-07-21 13:45 2024-07-22 0
3135 3135 32 HOLLY RD 42.329205 -71.240263 51148 5 2024-07-25 12:45 2024-08-06 0
3158 3158 111 GIBBS ST 42.333025 -71.188929 51148 6 2024-07-25 16:45 2024-08-06 0
3314 3314 195 MILL ST 42.341928 -71.201034 51148 2 2024-07-29 16:30 2024-07-30 0
3337 3337 611 CENTRE ST 42.350396 -71.186578 51148 1 2024-07-30 08:45 2024-08-13 0
3782 3782 LOWELL AVE 42.350616 -71.210838 51148 2 2024-08-07 09:15 2024-08-07 0
4194 4194 230 ADAMS ST 42.357764 -71.198779 51148 1 2024-08-12 12:00 2024-08-26 0
4259 4259 9 RUSSELL RD 42.359671 -71.181094 51148 1 2024-08-13 09:00 2024-08-13 0
4367 4367 910 WATERTOWN ST 42.350748 -71.222408 51148 3 2024-08-14 15:30 2024-08-14 0
4543 4543 1094 BEACON STREET 42.330657 -71.207199 51148 6 2024-08-17 09:15 2024-08-20 0
4742 4742 147 ARNOLD RD 42.305756 -71.192404 51148 8 2024-08-21 15:00 2024-08-21 0
5170 5170 3 WAUWINET RD 42.339907 -71.21774 51148 3 2024-08-30 14:00 2024-08-30 0
5184 5184 409 WINCHESTER ST 42.30653 -71.205974 51148 8 2024-08-31 13:15 2024-09-09 0
5490 5490 1670 CENTRE STREET 42.319504 -71.20644 51148 6 2024-09-08 23:15 2024-09-09 0
5511 5511 116 AUBURN ST 42.344329 -71.239869 51148 4 2024-09-09 09:15 2024-09-09 0
5719 5719 283 WOODLAND ROAD 42.340404 -71.240893 51148 4 2024-09-12 07:30 2024-09-12 0
6316 6316 3 CRAGMORE ROAD 42.317687 -71.222654 51148 5 2024-09-24 15:15 2024-09-25 0
6346 6346 108 ARNOLD RD 42.304474 -71.191408 51148 8 2024-09-25 09:30 2024-09-25 0
6376 6376 61-63 GARDNER STREET 42.359687 -71.191712 51148 1 2024-09-25 13:15 2024-09-25 0
6577 6577 131 BISHOPSGATE ROAD 42.332092 -71.18476 51148 7 2024-09-30 17:15 2024-10-01 0
6713 6713 40 WOODBINE TER 42.34544 -71.253446 51148 4 2024-10-04 08:30 2024-10-09 0
6838 6838 244 CALIFORNIA ST 42.364661 -71.198265 51148 1 2024-10-08 10:00 2024-10-09 0
6988 6988 2008 COMMONWEALTH AVENUE 42.347382 -71.243318 51148 4 2024-10-10 18:30 2024-10-11 0
6990 6990 1897-1899 COMMONWEALTH AVENUE 42.344845 -71.240614 51148 4 2024-10-10 18:45 2024-10-11 0
7839 7839 441 LOWELL AVE 42.342207 -71.211848 51148 2 2024-10-21 18:45 2024-10-30 0
7885 7885 1750 COMMONWEALTH AVE 42.340656 -71.23862 51148 4 2024-10-22 09:15 2024-10-23 0
8293 8293 294 GREENWOOD STREET 42.30435 -71.190972 51148 8 2024-10-24 15:30 2024-10-25 0
9715 9715 51 BOURNE ST 42.346223 -71.255223 51148 4 2024-11-05 18:15 2024-11-06 0
9927 9927 963 WATERTOWN STREET 42.350094 -71.224725 51148 3 2024-11-07 19:30 2024-11-08 0
9951 9951 963 WATERTOWN ST 42.350198 -71.224699 51148 3 2024-11-08 10:00 2024-11-12 0
9999 9999 79 FAXON ST 42.362266 -71.198868 51148 1 2024-11-09 15:45 2024-11-21 0
10300 10300 76 CHESTNUT ST 42.347472 -71.224541 51148 2 2024-11-19 08:30 2024-11-26 0
11681 11681 744 QUINOBEQUIN ROAD 42.317255 -71.226865 51148 5 2024-12-15 21:00 2024-12-16 0
12286 12286 30 CHASKE AVE 42.351005 -71.250393 51148 4 2024-12-26 20:45 2024-12-31 0
12474 12474 88 SAINT JAMES STREET 42.35872 -71.180211 51148 1 2025-01-01 16:00 2025-01-02 0
12618 12618 935 WASHINGTON ST 42.351251 -71.211056 51148 2 2025-01-04 11:30 2025-01-06 0
12640 12640 66 PARK STREET 42.354856 -71.182179 51148 1 2025-01-05 23:00 2025-01-08 0
13469 13469 52 BOURNE ST 42.346206 -71.254913 51148 4 2025-01-22 07:30 2025-01-23 0
15309 15309 251 WARD STREET 42.339682 -71.183 51148 7 2025-02-24 09:45 2025-02-24 0
15859 15859 28 JEFFERSON STREET 42.359228 -71.182764 51148 1 2025-03-07 01:30 2025-03-14 0
16375 16375 98 WINCHESTER ST 42.316677 -71.208513 51148 5 2025-03-14 15:15 2025-03-24 0
16524 16524 7 NORMAN RD 42.325686 -71.204445 51148 6 2025-03-18 16:15 2025-03-21 0
17160 17160 321 WALTHAM STREET 42.356215 -71.223598 51148 3 2025-04-01 14:45 2025-04-01 0
17274 17274 33 GODDARD ST 42.305949 -71.207154 51148 8 2025-04-03 21:30 2025-12-01 0
17407 17407 1412 WALNUT STREET 42.31426 -71.201582 51148 8 2025-04-07 15:30 2025-04-08 0
17601 17601 21 GARDNER ST 42.359283 -71.190068 51148 1 2025-04-09 16:45 2025-04-11 0
18227 18227 560 PARKER STREET 42.308468 -71.198106 51148 8 2025-04-24 00:30 2025-04-30 0
18716 18716 11 HULL STREET 42.343774 -71.206003 51148 2 2025-05-02 14:15 2025-05-27 0
18770 18770 2450 COMMONWEALTH AVENUE 42.344089 -71.260435 51148 4 2025-05-05 01:45 2025-05-05 0
18981 18981 140 BRANDEIS RD 42.31368 -71.18654 51148 8 2025-05-07 11:30 2025-05-07 0
19099 19099 1094 BEACON STREET 42.328983 -71.213513 51148 6 2025-05-09 00:30   1
19207 19207 339 RIVER ST 42.357933 -71.239253 51148 4 2025-05-12 10:45 2025-05-12 0
19208 19208 135 RIVER ST 42.353154 -71.232089 51148 3 2025-05-12 11:15 2025-05-12 0
19221 19221 9 HIGH STREET 42.313439 -71.209779 51148 8 2025-05-12 13:00 2025-06-10 0
19718 19718 712 WATERTOWN ST 42.35373 -71.214188 51148 3 2025-05-20 15:15 2025-05-23 0
19822 19822 712 WATERTOWN STREET 42.353848 -71.21399 51148 3 2025-05-21 23:00 2025-05-22 0
20178 20178 8 HEATHWOOD LANE 42.318021 -71.173795 51148 8 2025-05-28 17:30 2025-05-29 0
20761 20761 49 CROSS ST 42.350247 -71.218791 51148 3 2025-06-05 11:45 2025-06-13 0
21075 21075 143 STANTON AVE 42.334407 -71.241534 51148 4 2025-06-10 18:30 2025-06-13 0
21534 21534 5 FAIRFIELD ST 42.346026 -71.212406 51148 2 2025-06-17 17:45 2025-06-23 0
22347 22347 51 GLEN AVE 42.329907 -71.186522 51148 6 2025-06-30 11:15 2025-06-30 0
22417 22417 375 AUBURN STREET 42.346684 -71.249325 51148 4 2025-07-01 10:45 2025-07-02 0
22462 22462 69 BOWEN STREET 42.334186 -71.19536 51148 6 2025-07-01 21:45 2025-07-02 0
22840 22840 37-39 FORDHAM ROAD 42.361241 -71.22583 51148 3 2025-07-08 13:45 2025-07-14 0
23620 23620 592 AUBURN STREET 42.344131 -71.258059 51148 4 2025-07-17 16:45 2025-07-23 0
24043 24043 12 F COOK STREET 42.360611 -71.198656 51148 1 2025-07-24 10:30 2025-07-31 0
24794 24794 57 THEODORE RD 42.314238 -71.193645 51148 8 2025-08-06 14:15 2025-08-11 0
25214 25214 363 CRAFTS ST 42.359931 -71.214093 51148 2 2025-08-14 13:30 2025-08-18 0
25304 25304 68 MANET RD 42.336828 -71.175366 51148 7 2025-08-15 16:30 2025-08-18 0
25426 25426 395 WINCHESTER ST 42.306858 -71.2062 51148 8 2025-08-19 12:45 2025-08-21 0
25484 25484 1000 COMMONWEALTH AVE 42.337377 -71.208617 51148 2 2025-08-20 12:30 2025-08-20 0
25523 25523 100 NONANTUM ST 42.349797 -71.178998 51148 7 2025-08-21 10:00 2025-08-26 0
25526 25526 67 MARLBORO ST 42.350634 -71.177625 51148 1 2025-08-21 10:15 2025-08-26 0
25589 25589 5 SHIRLEY ST 42.352911 -71.238636 51148 3 2025-08-21 18:00 2025-08-26 0
25662 25662 16 ISLINGTON RD 42.34779 -71.253581 51148 4 2025-08-25 10:30 2025-08-25 0
25780 25780 712 WATERTOWN ST 42.35373 -71.214188 51148 3 2025-08-27 11:45 2025-09-08 0
25785 25785 727 CENTRE STREET 42.346811 -71.18948 51148 2 2025-08-27 12:45 2025-09-04 0
25985 25985 29 WILTSHIRE ROAD 42.356873 -71.196261 51148 1 2025-09-02 10:00 2025-09-03 0
26089 26089 41 CONVERSE AVENUE 42.348258 -71.190661 51148 2 2025-09-04 00:15 2025-09-09 0
26271 26271 57 THEODORE RD 42.314238 -71.193645 51148 8 2025-09-06 22:30 2025-09-09 0
26417 26417 2 ELLIS STREET 42.316735 -71.226924 51148 5 2025-09-09 17:45 2025-09-10 0
26418 26418 44 RESERVOIR AVENUE 42.316735 -71.226924 51148 5 2025-09-09 17:45 2025-09-10 0
26437 26437 729 DEDHAM ST 42.300351 -71.18852 51148 8 2025-09-10 09:15 2025-09-11 0
26813 26813 1 ELLIS STREET 42.316069 -71.226774 51148 5 2025-09-16 13:15 2025-09-17 0
26814 26814 2 ELLIS STREET 42.316767 -71.226903 51148 5 2025-09-16 13:15 2025-09-17 0

Next page

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 1062.841ms