home / n311

_locations

50 rows where category_id = 50955

✎ 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
1 1 140 BRANDEIS RD 42.313681 -71.18654 50955 8   2024-06-14 0
484 484 256 ALBEMARLE RD 42.357253 -71.216063 50955 3 2024-06-14 2024-06-26 0
507 507 11 FULLER AVE 42.36349 -71.222469 50955 3 2024-06-15   1
1242 1242 WARREN LINCOLN PLAYGROUND 42.3295 -71.229302 50955 5 2024-06-23 2024-07-15 0
1979 1979 130 WHEELER RD 42.31002 -71.191785 50955 8 2024-07-04 13:30 2024-07-08 0
1985 1985 COLD SPRING PARK 42.330992 -71.212896 50955 6 2024-07-04 22:00 2024-07-08 0
2633 2633 30 TIMSON PATH 42.291188 -71.189067 50955 8 2024-07-16 12:15   1
3331 3331 RICHARDSON PLAYGROUND 42.326992 -71.220318 50955 5 2024-07-30 06:45 2024-07-31 0
3598 3598 OAK HILL MIDDLE SCHOOLS PLAYFIELDS 42.31002 -71.191785 50955 8 2024-08-04 10:45 2024-08-19 0
4275 4275 360 LOWELL AVENUE 42.344922 -71.208902 50955 2 2024-08-13 11:15   1
5083 5083 1188 BEACON STREET 42.330214 -71.211743 50955 6 2024-08-28 17:15   1
5240 5240 125 MEADOWBROOK ROAD 42.310812 -71.190459 50955 8 2024-09-03 10:00 2024-09-10 0
5384 5384 32 MONTCLAIR ROAD 42.329047 -71.228791 50955 5 2024-09-05 11:30 2024-09-10 0
5559 5559 130 R WHEELER ROAD 42.313379 -71.189315 50955 8 2024-09-09 22:15 2024-09-11 0
6579 6579 306–368 ALBEMARLE RD 42.356435 -71.214362 50955 2 2024-09-30 18:30   1
6992 6992 11 HAWTHORN ST 42.358659 -71.203193 50955 1 2024-10-10 21:15   1
8287 8287 125 MEADOWBROOK ROAD 42.31151 -71.191295 50955 8 2024-10-24 14:00 2024-10-25 0
8544 8544 58 WHEELER ROAD 42.310578 -71.194178 50955 8 2024-10-28 15:15 2024-11-04 0
10771 10771 34 WINCHESTER ROAD 42.349475 -71.195317 50955 2 2024-11-27 16:15 2024-12-16 0
11666 11666 BURR PARK 42.351894 -71.18068 50955 1 2024-12-14 11:45 2025-01-03 0
11814 11814 32 MONTCLAIR ROAD 42.329047 -71.228791 50955 5 2024-12-17 14:00 2024-12-18 0
16095 16095 171 PINE ST 42.3522 -71.24202 50955 4 2025-03-10 09:45 2025-03-14 0
16116 16116 180 BRANDEIS RD 42.312618 -71.185325 50955 8 2025-03-10 12:00 2025-03-12 0
16473 16473 140 BRANDEIS RD 42.313681 -71.18654 50955 8 2025-03-17 17:00 2025-04-02 0
16576 16576 1697 BEACON ST 42.32646 -71.23271 50955 5 2025-03-20 10:00 2025-03-29 0
17223 17223 140 BRANDEIS ROAD 42.312245 -71.191175 50955 8 2025-04-02 16:15 2025-04-07 0
17249 17249 141 GROVE STREET 42.342457 -71.249811 50955 4 2025-04-03 13:15 2025-04-11 0
17660 17660 55 HUNTINGTON RD 42.347394 -71.175245 50955 7 2025-04-10 14:30 2025-04-11 0
17797 17797 1573 BEACON STREET 42.328856 -71.229134 50955 5 2025-04-14 18:30 2025-04-16 0
18038 18038 HENSHAW STREET 42.35409 -71.226935 50955 3 2025-04-19 08:45 2025-04-28 0
18039 18039 50 PRINCESS ROAD 42.354054 -71.226886 50955 3 2025-04-19 09:00 2025-05-05 0
18805 18805 250 BROOKLINE ST 42.301989 -71.177684 50955 8 2025-05-05 11:00 2025-05-15 0
20260 20260 2201 COMMONWEALTH AVE 42.347592 -71.25215 50955 4 2025-05-29 18:30 2025-08-08 0
20447 20447 101 EAST SIDE PKWY 42.350823 -71.196516 50955 2 2025-06-02 11:00 2025-07-24 0
20530 20530 2171 COMMONWEALTH AVE 42.348186 -71.251182 50955 4 2025-06-03 08:30 2025-06-11 0
20820 20820 457 WALNUT ST 42.345126 -71.207613 50955 2 2025-06-06 09:30 2025-06-11 0
21115 21115 2171 COMMONWEALTH AVE 42.348186 -71.251182 50955 4 2025-06-11 09:15 2025-07-30 0
21319 21319 125 DERBY ST 42.358311 -71.228547 50955 3 2025-06-14 06:45 2025-06-16 0
22177 22177 149 PLEASANT ST 42.332508 -71.199644 50955 6 2025-06-26 11:45 2025-06-26 0
24417 24417 46 HOMER STREET 42.334012 -71.196712 50955 6 2025-07-30 17:45 2025-08-18 0
25639 25639 130 WHEELER ROAD 42.311298 -71.191145 50955 8 2025-08-23 18:00 2025-08-27 0
26174 26174 229 CABOT ST 42.348825 -71.198771 50955 2 2025-09-04 16:45 2025-09-10 0
26535 26535 457 WALNUT STREET 42.344917 -71.20861 50955 2 2025-09-11 13:15 2025-09-15 0
26544 26544 235 CALIFORNIA ST 42.365016 -71.197866 50955 1 2025-09-11 14:00 2025-09-15 0
26547 26547 1188 BEACON ST 42.330852 -71.211506 50955 6 2025-09-11 14:15 2025-09-16 0
26623 26623 235 CALIFORNIA STREET 42.366473 -71.196003 50955 1 2025-09-12 13:00 2025-09-15 0
26654 26654 125 ALLEN AVENUE 42.326239 -71.220251 50955 5 2025-09-13 09:30 2025-09-16 0
26868 26868 235 CALIFORNIA ST 42.365016 -71.197866 50955 1 2025-09-17 10:45 2025-09-25 0
27399 27399 99 LITTLEFIELD RD 42.310683 -71.189591 50955 8 2025-09-27 16:15 2025-09-30 0
27782 27782 130 WHEELER ROAD 42.31098 -71.192164 50955 8 2025-10-05 11:15 2025-10-15 0

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