home / n311

_locations

35 rows where category_id = 51094

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ward, added (date), removed (date)

Link rowid ▼ location latitude longitude category_id ward added removed active
1113 1113 8 FREDANA ROAD 42.33141 -71.227267 51094 5   2024-06-26 0
1326 1326 540 CENTRE STREET 42.352552 -71.185961 51094 1 2024-06-24 2024-06-27 0
2287 2287 693 CENTRE STREET 42.34764 -71.188697 51094 2 2024-07-09 23:30 2024-07-10 0
2657 2657 13 WILTSHIRE RD 42.356328 -71.196664 51094 1 2024-07-16 15:30 2024-07-18 0
3215 3215 154 WOODCHESTER DR 42.341869 -71.174313 51094 7 2024-07-28 11:30 2024-07-30 0
4366 4366 10 DUNSTAN ST 42.350454 -71.222327 51094 3 2024-08-14 15:30 2024-08-14 0
5560 5560 251 MILL STREET 42.342295 -71.203437 51094 2 2024-09-10 05:30 2024-09-11 0
6765 6765 455 NAHANTON STREET 42.297693 -71.207505 51094 8 2024-10-06 11:45 2024-10-07 0
6893 6893 122 AUBURN ST 42.344528 -71.240223 51094 4 2024-10-09 07:15 2024-10-09 0
9965 9965 112 HYDE STREET 42.322971 -71.203793 51094 6 2024-11-08 14:15 2024-11-12 0
10259 10259 95 COLUMBIA AVE 42.313671 -71.209802 51094 8 2024-11-18 11:30 2024-11-20 0
10342 10342 143 ROWE STREET 42.347438 -71.243318 51094 4 2024-11-20 00:15 2024-11-26 0
10343 10343 231 JACKSON ROAD 42.355137 -71.195252 51094 1 2024-11-20 00:15 2024-12-02 0
11099 11099 22 HYDE ST 42.325596 -71.205527 51094 6 2024-12-06 08:45 2024-12-06 0
11816 11816 211 WEBSTER ST 42.348791 -71.23582 51094 3 2024-12-17 14:30 2024-12-18 0
13067 13067 140 VINE ST 42.302766 -71.169713 51094 8 2025-01-13 10:45 2025-01-14 0
16458 16458 132 WINDERMERE ROAD 42.34126 -71.240743 51094 4 2025-03-17 14:45 2025-03-17 0
16566 16566 15 SHORT ST 42.329124 -71.226648 51094 5 2025-03-20 00:30 2025-03-20 0
16669 16669 16 NOBLE STREET 42.361256 -71.232992 51094 3 2025-03-21 17:15 2025-03-24 0
16828 16828 51 GLEN AVE 42.329907 -71.186522 51094 6 2025-03-26 06:00 2025-04-25 0
18872 18872 825 CENTRE ST 42.343587 -71.191436 51094 2 2025-05-06 08:45 2025-05-13 0
22603 22603 130 RIVER ST 42.352902 -71.232224 51094 3 2025-07-03 09:15 2025-07-04 0
23805 23805 1274 WASHINGTON ST 42.349275 -71.225829 51094 3 2025-07-21 12:00 2025-07-21 0
24975 24975 159 WASHINGTON STREET 42.356101 -71.180398 51094 1 2025-08-11 10:30 2025-08-12 0
26871 26871 50 WOODLAND RD 42.34419 -71.250746 51094 4 2025-09-17 11:00 2025-09-22 0
26981 26981 1310 CENTRE ST 42.328935 -71.195229 51094 6 2025-09-19 13:15 2025-09-22 0
26982 26982 1371 CENTRE ST 42.327531 -71.197232 51094 6 2025-09-19 13:15 2025-09-22 0
27869 27869 428 WARD ST 42.338016 -71.190774 51094 7 2025-10-07 09:45 2025-10-08 0
27918 27918 228 BELLEVUE ST 42.352848 -71.195607 51094 1 2025-10-08 00:15 2025-10-09 0
28144 28144 814 WATERTOWN ST 42.352173 -71.218368 51094 3 2025-10-14 09:45 2025-10-14 0
28625 28625 247 WATERTOWN ST 42.361902 -71.196435 51094 1 2025-10-22 11:00 2025-10-22 0
28811 28811 1724 BEACON STREET 42.326382 -71.234327 51094 5 2025-10-27 11:00 2025-10-28 0
29217 29217 70 AUBURN ST 42.344523 -71.237534 51094 4 2025-11-03 10:30 2025-11-04 0
29461 29461 382 WATERTOWN ST 42.360363 -71.20157 51094 1 2025-11-06 13:15 2025-11-12 0
30609 30609 20 HARTFORD ST 42.320898 -71.207735 51094 6 2025-12-01 13:30 2025-12-02 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 345.863ms