home / n311

_locations

21 rows where category_id = 51032

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ location latitude longitude category_id ward added removed active
549 549 275 CENTRE ST 42.358545 -71.18527 51032 1 2024-06-17 2024-07-30 0
1644 1644 13 WILTSHIRE RD 42.356467 -71.196765 51032 1 2024-06-27 16:15 2024-07-30 0
2357 2357 11 WILTSHIRE RD 42.356281 -71.196756 51032 1 2024-07-10 16:30 2024-07-30 0
4489 4489 18 PHILIP BRAM WAY 42.350185 -71.207773 51032 2 2024-08-16 09:30 2024-09-25 0
7148 7148 32 LANGLEY ROAD 42.330807 -71.19315 51032 6 2024-10-15 11:00 2024-10-15 0
9994 9994 795 BEACON STREET 42.330744 -71.193686 51032 6 2024-11-09 14:00 2024-11-12 0
10646 10646 780 BEACON STREET 42.330316 -71.192742 51032 6 2024-11-25 14:45 2024-11-26 0
11122 11122 1234 CHESTNUT ST 42.309779 -71.220133 51032 5 2024-12-06 11:00 2024-12-06 0
11437 11437 80 HAMLET ST 42.323519 -71.182327 51032 6 2024-12-10 15:15 2025-07-03 0
11804 11804 22 LANGLEY RD 42.331004 -71.19345 51032 6 2024-12-17 12:00 2024-12-19 0
12876 12876 432 CHERRY STREET 42.349571 -71.228158 51032 3 2025-01-08 11:15 2025-01-08 0
18051 18051 20 WYOMING RD 42.362891 -71.210092 51032 1 2025-04-20 15:15 2025-04-22 0
18475 18475 1296-1298 CENTRE STREET 42.328698 -71.194373 51032 6 2025-04-28 17:00 2025-04-29 0
18497 18497 7 GOFF ST 42.332148 -71.259719 51032 4 2025-04-29 07:45 2025-04-29 0
22783 22783 264 R LOWELL AVENUE 42.348207 -71.210766 51032 2 2025-07-07 18:30 2025-07-08 0
22796 22796 311 WALNUT STREET 42.35011 -71.207505 51032 2 2025-07-08 08:15 2025-07-08 0
27550 27550 6 OLDHAM ROAD 42.340404 -71.236859 51032 3 2025-09-30 14:30 2025-09-30 0
27568 27568 1169 WASHINGTON STREET 42.349234 -71.221241 51032 3 2025-09-30 18:00 2025-10-01 0
27767 27767 47 ALGONQUIN RD 42.34086 -71.169966 51032 7 2025-10-04 11:15 2025-10-06 0
28214 28214 287 AUBURN ST 42.3468 -71.246799 51032 4 2025-10-14 17:00 2025-10-15 0
28883 28883 2115 COMMONWEALTH AVE 42.34833 -71.248248 51032 4 2025-10-28 11:15 2025-10-28 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 564.897ms