_locations

3 rows where category_id = 53468

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ location latitude longitude category_id ward added removed active
1141 1141 118 LOUISE ROAD 42.315137 -71.178566 53468 8   2024-07-01 0
1142 1142 40 HOMER STREET 42.334599 -71.19529 53468 6   2024-07-01 0
1443 1443 130 FESSENDEN STREET 42.363619 -71.212097 53468 2 2024-06-26 2024-07-01 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
);