_locations

1 row where category_id = 51087

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: added (date)

Link rowid ▼ location latitude longitude category_id ward added removed active
6800 6800 215 AUBURNDALE AVE 42.35035 -71.240765 51087 4 2024-10-07 15:45   1

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
);